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
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
`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
0
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 |
---|---|---|
Template:BEWoods | ||
Item:Basswood display case with fae carved along the sides | Trader Guild , Ratha Shop/Archive | |
Weapon:Basswood half-handled riste flaunting prismatic blades of rencate | Risty Business | true |
Weapon:Basswood riste flaunting prismatic blades of rencate | Risty Business | true |
Item:Bow | True Bard D'Or , Teshi's Instruments, Malik the True Bard, Elepaio's Luthierre | |
Breaking and Entering/Rooms and Loot/Material options | ||
Item:Burnished wheel painted with colorful sea creatures | 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:Butcher's knife fit with a short hilt | Breaking and Entering/Kitchen loot | |
Item:Castanets | Teshi's Instruments | |
Item:Cistre | Teshi's Instruments | |
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 |