Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::unicorn]]OR[[Uses material::Unicorn]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
10
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 366 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id WHERE (t2.o_hash='unicorn')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=28078 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Armor:Silver chain helm adorned with a spiraling horn | ||
Armor:Unicorn-head great helm | ||
Weapon:Ash-hafted partisan etched with silvered unicorns | Edword's Accoutrements (4) , Edword's Accoutrements (2), Edword's Accoutrements (1) | |
Item:Asketine unicorn pin | Natural Magic (2) , Natural Magic (1), Champren's Empath Emporium | true |
Item:Azure surcoat emblazoned with a silver-horned golden unicorn | Edword's Accoutrements (4) , Edword's Accoutrements (2), Edword's Accoutrements (1) | |
Item:Black cambrinth unicorn | Idon Abide the Ten (2) | |
Item:Black linen robe adorned with the adder of Asketi | Hollow Eve Festival 417/Raffles | |
Shield:Black tower shield emblazoned with a wounded white unicorn rampant over an enormous red moon | Banabu Garam's Jeweled Exquise (1) | |
Item:Black unicorn truffle rolled in dark cocoa powder | ||
Item:Black unicorn with a red silk mane and tail | Pretty Pony (2) | |
Item:Black velvet clergy cape fully lined in satin with braided gold trim on the arm slits | Bunglefoot's Tent (2) , Bunglefoot's Tent (1) | true |
Item:Black velvet tabard with sparkling unicorns embroidered along the hem | Shawgril's Bolt Goods (2) , Shawgril's Bolt Goods (1) | |
Item:Black wool tunic with a black unicorn embroidered on the chest | Asketi's Stop (4) | |
Item:Blackened ironwood amulet carved in the shape of an adder | Gnarled Dwarf peddler (1) , Gnarled Dwarf Peddler (2) | |
Item:Blackened silver medallion inlaid with white jade | Hollow Eve Festival 406/Raffles , Hollow Eve Festival 392/Raffles | |
Item:Blackened unicorn-shaped brooch with sharpened silver teeth | Asketi's Stop (2) , Asketi's Stop (1) | |
Item:Blue silk scarf embroidered with a silver unicorn | Immania and Xaie's Emporium of Elegance (2) , Immania and Xaie's Emporium of Elegance (1) | |
Item:Bone spoon with a scrimshawed handle | Snookie's Divine Spoons (3) , Snookie's Divine Spoons (2), Snookie's Divine Spoons (1) | |
Item:Bouquet of Healing Heart orchids arranged in a ceramic unicorn vase | Perpetual Blossoms of Mer'Kresh (3) , Perpetual Blossoms of Mer'Kresh (2) | true |
Weapon:Brass parry stick spiraled like a unicorn horn | Emmiline's Cottage | |
Item:Bright gold bell with an intricate porcelain unicorn handle | Fragile Finds | |
Item:Brightly polished wand of pale sapphire carved into a tight spiral reminiscent of a unicorn's horn | Sho'hhs Migendaniis | |
Item:Bronze anklet inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | |
Item:Bronze armband inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | true |
Item:Bronze rowel spurs embellished with blackened unicorns | Riding The Range (2) | |
Item:Brown wool tunic with a black unicorn embroidered on the chest | Asketi's Stop (4) | |
Item:Cambrinth ankle cuff inlaid with diamond unicorns to spell HODIERNA | Forever Faithful (2) , Forever Faithful (1) | |
Item:Cambrinth anklet clasped with a rearing unicorn cut from a flawless diamond | Wavecrester , Tropic Night, Mermaid's Fall, Harper's Song, Cat's Ninth Life | |
Item:Carved blue agate unicorn cameo brooch framed in gold | Item:Silvery spidersilk satchel accented by some pure white swan feathers , Item:Silvery spidersilk satchel accented by some pure white swan feathers, Flower Gazebo (2), Flower Gazebo (1), Droughtman's Maze | |
Item:Carved brick hearth | Noble's Barn | |
Item:Carved ivory gemshorn | Drones and Drums | |
Weapon:Carved lunat staff topped with a silver unicorn | ||
Item:Carved wooden ring | Darthan's prize booth | |
Item:Cerulean thigh pouch embroidered with silvery thread | Breeze , The | |
Item:Cherry carving case with a delicate unicorn clasp of gleaming crystal | Altared Visions | |
Item:Cloak depicting a proud unicorn standing in a field of jadice flowers | Weather Beaters (2) , Weather Beaters (1) | |
Item:Clouded glass armband strung with a constellation of tiny stars | Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot | |
Item:Cluster of darkly glimmering midwinter's sickle set upon an icesteel hair-clasp | Fashionable Panda (2) | |
Item:Coiled metal serpent band devouring a blackened unicorn spinel | Hollow Eve Festival 436/Auction | true |
Item:Columned white-marble fireplace | Frother's Beasts | |
Item:Copper signet ring (8) | Rundmolen Post Office (Leth Deriel) | false |
Armor:Copper-worked plate brigandine engraved with a vivid image of a white unicorn | Iprilu's Emporium (obsolete) | |
Armor:Copper-worked plate greaves trimmed with silver | Iprilu's Emporium (obsolete) | |
Item:Copperwood pipe with an ivory bowl carved in the shape of a brig | Curse of the Ghost Ship/Incidental Loot | |
Item:Cracked mother-of-pearl icon | Museum of Imperial History | |
Item:Creamy hulnik linen hooded cloak trimmed with a border of richly embroidered purple silk and the image of a silvery unicorn prancing upon a field of clover | Shawgril's Bolt Goods (3) , Shawgril's Bolt Goods (2), Shawgril's Bolt Goods (1) | |
Item:Creamy white silk tunic edged with a border of embroidered golden unicorns along the hem and sleeves | Item:Silvery spidersilk satchel accented by some pure white swan feathers , Item:Silvery spidersilk satchel accented by some pure white swan feathers, Flower Gazebo (2), Flower Gazebo (1), Droughtman's Maze | |
Item:Crisp white foraging apron lined with satin and painted with a unicorn over the front pocket | Healer's Haven , Empath Emporium (4), Empath Emporium (3), Empath Emporium (2), Empath Emporium (1), Champren's Empath Emporium | true |
Item:Crystal bell with a silver unicorn handle | Exaltation Tintinnabulum (1) | |
Item:Crystal unicorn bracelet | Hollow Eve Festival 417/Raffles |