Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Basswood]]
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=89163)
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=89163)
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 | 106 | 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:Compact writing slate with a border | Breaking and Entering/Library loot | false |
Item:Competition miniature flock of seagulls with beady yellow eyes | Hollow Eve Festival 447/Game prizes | true |
Item:Dainty comb carved with blossoms | Breaking and Entering/Bedroom loot | |
Item:Dainty cowbell fit with a polished handle | Breaking and Entering/Library 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 | |
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: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 | |
Item:Glaes awl with a gilded basswood handle | Skyward Crafting (4) | true |
Template:HE2020Woods | ||
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:Basswood display case with fae carved along the sides | ||
Item:Bow | ||
Item:Castanets | ||
Item:Cistre | ||
Item:Drum stick | ||
Item:Faenellica | ||
Item:Gemshorn | ||
Item:Hichiriki | ||
Item:Hollow Eve 399 gift | ||
Item:Kithara | ||
Item:Medium case | ||
Item:Mirliton | ||
Item:Naqqara | ||
Item:Pick | ||
Item:Rebec | ||
Item:Small case | ||
Item:Syrinx | ||
Item:Tipper | ||
Item:Kithara | Teshi's Instruments | |
Item:Lacquered abacus strung with polished beads | 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:Lacquered band set with a tiny clownfish | 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 portrait framed in wood | Breaking and Entering/Library loot | |
Item:Latticed picnic basket tied with sea otters | 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:Long mixing stick topped with a trio of blooms | Breaking and Entering/Kitchen loot | false |
Item:Loose-fitting pajama top with polished buttons | Breaking and Entering/Bedroom loot | |
Item:Medium case | True Bard D'Or , Teshi's Instruments, Malik the True Bard, Elepaio's Luthierre | |
Item:Mesh sieve with a polished handle | Breaking and Entering/Kitchen loot | false |
Item:Metal scissors with wood handles | Breaking and Entering/Work Room loot | false |
Weapon:Miniature toy crossbow composed of wood | Breaking and Entering/Armory loot | |
Item:Miniature turtles | 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:Mirliton | Teshi's Instruments , Sinjian's Bardic Requisites | |
Item:Naqqara | Teshi's Instruments |