Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Copperleaf]]
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=89165)
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=89165)
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 | 53 | 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: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:Faenellica | Teshi's Instruments | |
Item:Gemshorn | Teshi's Instruments | |
Item:Gold hoop earrings gilded with copperleaf | Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2) | |
Item:Graceful copperleaf faenellica inlaid with a swirling flight of silverwillow wrens | Nytingale's Instruments (7) , Nytingale's Instruments (4), Nytingale's Instruments (10) | |
Item:Hichiriki | Teshi's Instruments | |
Item:Inlaid silverwillow psaltery | Nytingale's Instruments (8) , Nytingale's Instruments (5) | |
Item:Bow | ||
Item:Carved copperleaf bed | ||
Item:Castanets | ||
Item:Cistre | ||
Item:Copperleaf drum stick | ||
Item:Copperleaf frost dulcimer | ||
Item:Copperleaf-inlaid teak sundial | ||
Item:Drum stick | ||
Item:Faenellica | ||
Item:Gemshorn | ||
Item:Gold hoop earrings gilded with copperleaf | ||
Item:Graceful copperleaf faenellica inlaid with a swirling flight of silverwillow wrens | ||
Item:Hichiriki | ||
Item:Inlaid silverwillow psaltery | ||
Item:Kithara | ||
Item:Medium case | ||
Item:Mirliton | ||
Item:Naqqara | ||
Item:Pick | ||
Item:Rebec | ||
Item:Slouched black leather boots with gold-inlaid copperleaf clasps | ||
Item:Small case | ||
Item:Syrinx | ||
Item:Tipper | ||
Item:Kithara | Teshi's Instruments | |
Item:Marqueterie copperleaf locket (1) | Semtrach's Art To Order (2) | |
Item:Medium case | True Bard D'Or , Teshi's Instruments, Malik the True Bard, Elepaio's Luthierre | |
Item:Mirliton | Teshi's Instruments , Sinjian's Bardic Requisites | |
Item:Naqqara | Teshi's Instruments | |
Item:Pick | True Bard D'Or , Teshi's Instruments, Malik the True Bard, House of Bardic Blues, Elepaio's Luthierre | |
Item:Rebec | Teshi's Instruments | |
Item:Slouched black leather boots with gold-inlaid copperleaf clasps | Curse of the Ghost Ship/Incidental Loot | |
Item:Small case | True Bard D'Or , Teshi's Instruments, Malik the True Bard, Elepaio's Luthierre | |
Item:Syrinx | Teshi's Instruments | |
Item:Tipper | True Bard D'Or , Teshi's Instruments, Malik the True Bard, House of Bardic Blues, Drones and Drums | |
Weapon:Copperleaf dako'gi crossbow set with a bone scrimshaw boltplate |