Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::swan]]OR[[Uses material::Swan]]
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
20
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
20
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 66 | 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='swan')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=17357 - 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 |
---|---|---|
Item:Brocade thigh bag dyed in variegated purples and blues | ||
Item:Carved rosewood hair brush inlaid with mother-of-pearl | ||
Item:Golden wedding torque with carved ivory swans holding a baroque pearl pendant | ||
Item:Gown crafted of pure white swan feathers smoothed in a sleek design | ||
Item:Graceful chakrel swan amulet hung from a braided red gold chain | ||
Item:Midnight blue nightsilk cloak stitched with pure white swans | ||
Item:Polished silver amulet engraved with two swans floating on a lake | ||
Item:Pure white flat-bottomed gourd embellished at the rim with wispy swan feathers | ||
Item:Sculpted swan of snowy white jade | ||
Item:Silver and glass swan feather quill | ||
Item:Silvery spidersilk satchel accented by some pure white swan feathers | ||
Item:Small leather wrist sheath embossed with a crow and swan | ||
Item:White suede pouch laced with a swan feather-tipped silk drawstring | ||
Item:White swan's feather beaded with alternating iridescent clear and blue crystals | ||
Item:Ivory footbrush with a bas-relief swan carved on the back | treasure map, Thorkim Family Farm 429/Pig Maze , Bacon Man's Birthday Bash 419/Pig Maze | true |
Item:Kiln-dried clay swan | Taisidon Safari 417/Raffles | |
Item:Midnight blue nightsilk cloak stitched with pure white swans | Fire and Ice, Fire and Ice (2) , Fire and Ice (1) | |
Item:Midnight blue silk tie hand painted with a white swan on a still pool | Head to Toe | true |
Armor:Opulent white mask topped with a crowning crest of swan feathers | Tavern Troupe Performing Order/Gifts and prizes | |
Armor:Pair of silver gauntlets with pure white swan feathers dangling from the cuffs | Fit for a Baron, Fit for a Baron | |
Weapon:Polished copper iltesh with a large hexa-hued gloomglass set into a haon pommel | Cultured Attire (6) | |
Item:Polished silver amulet engraved with two swans floating on a lake | Obscured Visions, Obscured Visions | |
Item:Pure white flat-bottomed gourd embellished at the rim with wispy swan feathers | Natural Magic, Natural Magic (2) , Natural Magic (1) | true |
Item:Sculpted swan of snowy white jade | Ahreusse's Atelier (1) | |
Shield:Dark ironwood buckler painted with a graceful white swan | ||
Item:Silver and glass swan feather quill | Cacophony of Silver and Glass (2), Cacophony of Silver and Glass (3) , Cacophony of Silver and Glass (2) | |
Item:Silver hairbrush with a preening swan etched on the back | Bacon Man's Birthday Bash 419/Pig Maze | |
Item:Silverwood swan | Whittler Roakin | |
Item:Silvery spidersilk satchel accented by some pure white swan feathers | Droughtman's Maze , Demosel's Lair (2), Demosel's Lair (1) | |
Item:Simple tool bag of soft dark leather | Large bin of miniature figurines | |
Item:Sky-blue spidersilk scarf intricately embroidered with flocks of birds | Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2) | |
Item:Sleek writing quill tipped with a long nightingale feather | Sketchy By Design (9) | |
Item:Small leather wrist sheath embossed with a crow and swan | Just Desserts (1), Just Desserts (1) | |
Item:Spacious black walnut picnic basket painted with a pair of dancing swans | Tavern Troupe Performing Order/Gifts and prizes | |
Item:Stately ring carved from bronze | Tavern Troupe Performing Order/Gifts and prizes | |
Item:Supple kidskin hip pouch with a pewter clasp | 6th-Year Estate Holder Token Auction | true |
Item:Swan feather quill | Rundmolen Post Office (Fang Cove) | false |
Item:Swan-feather quill with a delicate platinum tip | Bacon Man's Birthday Bash 419/Pig Maze | |
Item:Thick white bath towel decorated with an embroidered swan | treasure map, Bacon Man's Birthday Bash 419/Pig Maze | true |
Weapon:Tyrium bastard sword with a glaes pommel | treasure map, Item:Worn and tattered map | true |
Weapon:Umbral glaes mace with a shadowbark haft | Drathrok's Duskruin 435/Auction | |
Item:White plush swan with black beady eyes | That's a Wrap | true |
Item:White suede pouch laced with a swan feather-tipped silk drawstring | River Dreamer, Rusty Barnacle, Marsh Skipper, North Wind's Skimmer, Rusty Barnacle , River Dreamer, North Wind's Skimmer, Night Sky's Hair, Marsh Skipper, Demosel's Lair (2) | false |
Item:White swan's feather beaded with alternating iridescent clear and blue crystals | Rusty Barnacle, Marsh Skipper, North Wind's Skimmer, Rusty Barnacle , North Wind's Skimmer, Marsh Skipper, Demosel's Lair (2) | |
Item:Wide chocolate-brown leather belt with a topaz-bordered silver buckle | Cultured Attire (6) | |
Item:Woven willow tea basket trailing spring-hued ribbons | Tavern Troupe Performing Order/Gifts and prizes |