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
0
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
0
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:Animite swan medallion bearing the visage of Queen Morganae | Ilithian Heritage | |
Armor:Great helm topped with a silver crown and pure white swan feather plumes | ||
Armor:Pair of silver gauntlets with pure white swan feathers dangling from the cuffs | ||
Item:Black leather armband embroidered with a barely visible image | Pirate Hideaway (2) , Pirate Hideaway (1) | true |
Item:Black leather saddle with an ornate black swan cantle and horn | Cultured Attire (5) | |
Item:Black-on-lily tiered angular corset | ||
Item:Brocade thigh bag dyed in variegated purples and blues | Thighs Have It (3) , Thighs Have It (2) | |
Item:Carved rosewood hair brush inlaid with mother-of-pearl | Simply Essential (2) | |
Item:Chic white valise covered in brushed cashmere | Tavern Troupe Performing Order/Gifts and prizes | |
Item:Coral sculpture of a tranquil pool in a small glade of trees | Beachcomber Delights (2) , Beachcomber Delights (1) | |
Item:Dainty white wrist purse composed of kirmiko | Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot, Droughtman's Challenge 437/Incidental loot, Droughtman's Challenge 433/Incidental loot, Droughtman's Challenge 430/Incidental loot | |
Shield:Dark ironwood buckler painted with a graceful white swan | Vishlan's Wares (festival version 3), Vishlan's Wares (4) , Vishlan's Wares (1) | |
Item:Glossy chocolate-hued silk slippers stitched with delicate gold swans | Cultured Attire (6) | |
Item:Golden wedding torque with carved ivory swans holding a baroque pearl pendant | Pischic's Pearls | |
Item:Gown crafted of pure white swan feathers smoothed in a sleek design | Frilly Fashions | |
Item:Graceful cambrinth swan | Cambripalooza! | |
Item:Graceful chakrel swan amulet hung from a braided red gold chain | Vishlan's Wares (1) , Burning Embers (1) | |
Item:Gracefully curving dragonwood lyra viol with palladium tuning keys | Cultured Attire (3) | |
Armor:Great helm topped with a silver crown and pure white swan feather plumes | Fit for a Baron, Fit for a Baron | |
Item:Black leather armband embroidered with a barely visible image | ||
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 |