Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Lacewood]]
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 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246 AND t1.o_id=79039)
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 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246 AND t1.o_id=79039)
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 | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id | 5 | const | 138 | Using where; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Item:Dainty cowbell fit with a polished handle | Breaking and Entering/Library loot | |
Item:Delicate triptych in a frame of blue-black-stained lacewood | Sleeping Dragon Corn Maze 447/Incidental loot , Sleeping Dragon Corn Maze 443/Incidental loot, Sleeping Dragon Corn Maze 439/Incidental loot, Sleeping Dragon Corn Maze 436/Incidental loot, Sleeping Dragon Corn Maze 432/Incidental loot | |
Item:Drum stick | Teshi's Instruments , Nytingale's Instruments (9), Nytingale's Instruments (8), Nytingale's Instruments (6), Nytingale's Instruments (5), Nytingale's Instruments (4), Nytingale's Instruments (2), Nytingale's Instruments (10), Masquer Aid (1), House of Bardic Blues, Hotagi'rath Theater (shop), Gadelica's Riches for the Reverent (4), Gadelica's Riches for the Reverent (3), Gadelica's Riches for the Reverent (2), Gadelica's Riches for the Reverent (1), Elepaio's Luthierre, Drones and Drums | |
Item:Elegant dolphin amulet dangling from a lacewood-beaded necklace | Amulets by Liathe (5) | |
Weapon:Etched briquet marked with a simple blossom | Breaking and Entering/Armory loot | |
Item:Faenellica | Teshi's Instruments | |
Item:Feathery seaweed fronds dappled with swirls | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | |
Item:Fierce scorpion amulet dangling from a lacewood-beaded necklace | Amulets by Liathe (5) | |
Item:Folding chair with a cushioned seat | Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Fragile cube | Breaking and Entering/Bedroom loot | |
Item:Fragile sea globe with a polished base | 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:Gemshorn | Teshi's Instruments | |
Weapon:Glaes jambiya with a carved lacewood hilt | treasure map, Item:Worn and tattered map | true |
Item:Graceful oval lacewood tea table | Weaving Minstrel , Spinning Jenny | |
Template:HE2020Woods | ||
Item:Heavy amulet formed like an ox dangling from a lacewood-beaded necklace | Amulets by Liathe (5) | |
Item:Hichiriki | Teshi's Instruments | |
Item:Hollow Eve 399 gift | ||
Talk:Hollow Eve Festival 436/Game prizes | ||
Hollow Eve Festival 436/Game prizes/Material options | ||
Item:Bow | ||
Item:Castanets | ||
Item:Cistre | ||
Item:Drum stick | ||
Item:Faenellica | ||
Item:Gemshorn | ||
Item:Graceful oval lacewood tea table | ||
Item:Hichiriki | ||
Item:Hollow Eve 399 gift | ||
Item:Kithara | ||
Item:Lacewood ocarina adorned with glittering sapphire and amethyst butterflies | ||
Item:Lacewood parchment case with an engraved gold clasp | ||
Item:Lacewood trinket case printed with a vibrant mermaid | ||
Item:Lacquered lacewood compendium | ||
Item:Medium case | ||
Item:Mirliton | ||
Item:Naqqara | ||
Item:Pick | ||
Item:Polished lacewood cistre with a fretwork soundhole | ||
Item:Rebec | ||
Item:Small case | ||
Item:Syrinx | ||
Item:Tipper | ||
Item:Kithara | Teshi's Instruments | |
Item:Knotted lacewood foraging basket | Weelegend's Wagon | |
Item:Lacewood cabinet | SimuCoins | |
Item:Lacewood guiro carved into the shape of a crouching frog | Bardic Journey (7) , Bardic Journey (6) | |
Item:Lacewood lap harp decorated with silver dancing pivuh | Hollow Eve Festival 417/Raffles | |
Item:Lacewood ocarina adorned with glittering sapphire and amethyst butterflies | Alimia's Ocarinas | |
Item:Lacewood parchment case with an engraved gold clasp | Crystal Pilgrim (3) , Crystal Pilgrim (2), Crystal Pilgrim (1) |