Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Punka||Punka leather]]
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
(`smw_di_wikipage` AS t1
INNER JOIN
`t3` AS t3 ON t1.o_id=t3.id) ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246)
AND 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
(`smw_di_wikipage` AS t1
INNER JOIN
`t3` AS t3 ON t1.o_id=t3.id) ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246)
AND 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 | t3 | system | PRIMARY | 1 | Using temporary; Using filesort | ||||
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 54 | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t3
INSERT IGNORE INTO `t3` (id) VALUES (1005452)
INSERT IGNORE INTO `t3` (id) VALUES (1005452)
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Weapon:Finivire steppe bow with lumium tips | Sleeping Dragon Corn Maze 428/End loot | |
Item:Folded icon of leather | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Green punka cloak with black braid trimming | In The Snow (2) , In The Snow (1) | |
Item:Grisly leather war belt dangling sightless shrunken heads with sewn shut mouths | Limited Treasures (6) | true |
Template:HE2020Leathers | ||
Talk:Hollow Eve Festival 436/Game prizes | ||
Hollow Eve Festival 436/Game prizes/Material options | ||
Item:Hooded punka cloak of vibrant pumpkin-hued leather | Hollow Eve Festival 443/Raffles | |
Item:Huntsman's greatcloak of night-black punka subtly patterned with shadowy leaves | Limited Treasures (4) | |
Item:Ice skates with watered steel blades | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Large tome patterned with stylized sigils | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Length of virid punka | Blood and Gourd (3) | |
Item:Loimic pickaxe with a textured punka-wrapped handle | Skyward Crafting (5) | true |
Item:Miniature Merelew woodsman figurine carrying an iroko walking staff | Siegery Shop (5) | |
Item:Miniature mechanical war mammoth carrying a bandolier of firework canisters | Siegery Shop (5) | |
Item:Miniature sleazy lout of haphazardly folded punka leather | House of the Revenant Fang 433/Incidental loot , House of the Revenant Fang 429/Incidental loot | |
Item:Mottled green weapon harness | Stabbaticals (1) | |
Item:Niniam-buckled adventurer's journal with a greenish punka cover | Item:Epistemic journal | |
Item:Pacificist's petite plush pasabas of padded patchwork punka and petalette | ||
Item:Pair of dirt-hued punka leather goggles shaped like potatoes | Eye Spy (3) | |
Item:Pair of forest-green punka leather leggings with a wide belt | Natural Beauty (4) | true |
Item:Pair of palladium triangular-heeled heliotrope punka boots wrapped with eye-searing lime green cire | Give 'Em the Boot (6) | |
Item:Pair of punka leather dress boots with square heels | Natural Beauty (4) | true |
Item:Pair of punka leather knee-high boots adorned with Imperial topaz buttons | Item:Brinewood basket adorned with an Imperial topaz clasp | true |
Item:Pair of shadowleaf leggings with a wide punka leather belt | Item:Brinewood basket adorned with an Imperial topaz clasp | true |
Item:Polished steel cheese knife with a whale-shaped handle | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | |
Item:Punka leather bodice adorned with spectrolite beads and silver threading | Natural Beauty (4) | true |
Item:Punka leather gem pouch clasped with a tiny sardonyx togball | Finest Box of Gems (2) | true |
Armor:Punka leggings embossed with brown recluses | Accents for the Arachnophile (5) , Accents for the Arachnophile (4) | |
Item:Punka weapon harness | ||
Item:Reddish-green weapon harness | Stabbaticals (2) | true |
Item:Register cover embossed with a crafting figure | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Rugged forest green punka jousting boots | Nigeyi's (4) , Nigeyi's (3), Nigeyi's (2) | |
Item:Sanguine-hued gutting knife with a punka-wrapped handle | Blood and Gourd (4) , Blood and Gourd (3) | |
Item:Sleek lootpouch fastened with a leviathan | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Slender steel skinning knife with a gemstone pommel | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Slim codex detailed with filigree | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Stiff punka scarecrow with a pebbled green tunic | Sleeping Dragon Corn Maze 432/Incidental loot | |
Item:Stormy grey slippers laced with windstorm gossamer ribbons | Wedding Belles (2) , Wedding Belles (1) | |
Item:Studded punka back harness | Stabbaticals (2) , Stabbaticals (1) | true |
Item:Sturdy engineer's toolbag composed of dark green punka | Which Craft (2) | |
Item:Toadlike punka waterskin boasting a squat bogbirch stopper | ||
Item:Velvet toy sword with a grip | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Item:Verdigris punka overcoat with wooden buttons | Row Row Row Your Coat | true |