Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Kiralan]]OR[[Uses material::Kiralan]]
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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 | ALL | PRIMARY | 53 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id WHERE (t2.o_hash='Kiralan')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=1005466 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Item:Glossy kiralan calling card dispenser inset with a large royal Zoluren topaz | Hollow Eve Festival 428/Auction | |
Item:Heavy sanguinai seaman's boots with kiralan toecaps | Hollow Eve Festival 439/Auction | true |
Item:Kiralan and loimic trinket | Hollow Eve Festival 425/Auction | |
Armor:Kiralan bar-mail hauberk fitted with elaborate coral pauldrons | Hollow Eve Festival 436/Auction | true |
Armor:Kiralan chainmail helm crowned with a rendition of a shark's jawbone | Hollow Eve Festival 425/Auction , Item:Chain mesh armor pack with sharktooth-tipped ties | |
Armor:Kiralan chainmail vest bearing all of the hues of the ocean depths | Hollow Eve Festival 425/Auction , Item:Chain mesh armor pack with sharktooth-tipped ties | |
Item:Kiralan chanfron graced with a compass rose of wuthering goldfyre | Item:Seasilk saddlebag embroidered with a chariot drawn by sea-creatures | true |
Item:Kiralan crinnet with ridges of flooded goldfyre | Item:Seasilk saddlebag embroidered with a chariot drawn by sea-creatures | true |
Item:Kiralan crupper awash with luminescent starshine | Item:Seasilk saddlebag embroidered with a chariot drawn by sea-creatures | true |
Item:Kiralan flanchards inlaid with asarenjan | Item:Seasilk saddlebag embroidered with a chariot drawn by sea-creatures | true |
Armor:Kiralan mail gloves edged in shark's teeth | Hollow Eve Festival 425/Auction , Item:Chain mesh armor pack with sharktooth-tipped ties | |
Armor:Kiralan mail pants with spiked kneeguards | Hollow Eve Festival 425/Auction , Item:Chain mesh armor pack with sharktooth-tipped ties | |
Weapon:Kiralan naginata with a shadowbark shaft | Droughtman's Challenge 441/End loot , Droughtman's Challenge 437/End loot, Droughtman's Challenge 433/End loot, Droughtman's Challenge 430/End loot | true |
Item:Kiralan necklace with a massive Dalterein diamond held in a complex setting | Hollow Eve Festival 428/Auction | |
Item:Kiralan neithrel band interspersed with silver striated tablature turquoises | Guildfest 431/Auction , Item:Bardic blue Imperial weave sash pinned with a magnificent tablature turquoise | |
Item:Kiralan peytrel inlaid with an undersea cityscape | Item:Seasilk saddlebag embroidered with a chariot drawn by sea-creatures | true |
Weapon:Kiralan quarterstaff shaped like a giant electric eel | Droughtman's Challenge 426/End loot | |
Weapon:Kiralan scythe with an ebony handle | Guildfest 438/Auction | |
Weapon:Kiralan trident bound to a haft of ayabere | Hollow Eve Festival 439/Auction | true |
Shield:Kiralan war shield glimmering with motes of asarenjan | Hollow Eve Festival 436/Auction | true |
Item:Kiralan wedding band pierced with a jagged shard of black assassin's diamond | Item:Etched platinum ring box | |
Item:Kiralan wedding ring pierced with a jagged shard of black assassin's diamond | Item:Etched platinum ring box | |
Item:Korograth leather ship's kitten sack lined in generous layers of stormsilk | Hollow Eve Festival 439/Auction | true |
Armor:Majestic kiralan full plate with sweeping lightning amethyst inset pauldrons | Drathrok's Duskruin 430/Auction | |
Item:Miniature anvil crafted from pearlescent kiralan | Su Helmas: Seeds of Entropy/Incidental loot | |
Item:Miniature kiralan voidspawn with soulless eyes | Hollow Eve Festival 439/Auction | true |
Item:Oversized Tokka card with a dark blue kiralan foil backing | Guildfest 438/Auction | |
Weapon:Polished kiralan boarding axe with an ilomba handle | Droughtman's Challenge 441/End loot , Droughtman's Challenge 437/End loot, Droughtman's Challenge 433/End loot, Droughtman's Challenge 430/End loot | true |
Item:Polished kiralan teardrop | Hollow Eve Festival 428/Auction | |
Item:Polished palm-sized kiralan semiquaver note | Item:Polished haledroth lighter case inset with a large faceted moonspun ruby , Guildfest 438/Auction | |
Weapon:Razor-edged kiralan khopesh adorned with an ocean's deep emerald | Droughtman's Challenge 426/End loot | |
Item:Rectangular grey instrument case painted with a starry landscape | Guildfest 445/Auction | true |
Weapon:Sea-worn kiralan chain blade attached to a stormwood hilt | Hollow Eve Festival 439/Auction | true |
Item:Shallow kiralan box carved with tiny frolicking tone-on-tone shadowlings | Item:Jacinthe dragonfire brocade makeup reticule suspended on silversteel chains , Hollow Eve Festival 425/Auction | |
Item:Silverweave document satchel with polished kiralan buckles | Drathrok's Duskruin 430/Auction | |
Item:Slim almanac with a thin kiralan cover | Guildfest 431/Auction | |
Shield:Small kiralan shield inlaid in diacan with a deeplight fish | Hollow Eve Festival 436/Auction | true |
Shield:Stalwart kiralan deflector lined in stormsilk | Hollow Eve Festival 447/Auction | true |
Item:Stormsilk umbrella with kiralan ribs | Hollow Eve Festival 436/Auction | true |
Item:Stormtouched cloudbark kalimba with seven prismatic keys | Hollow Eve Festival 443/Auction | |
Item:Stormwood box raked in tiny claw marks | Item:Cloudbark toy chest etched with whimsical dragons | true |
Item:Sturdy war saddle clad in plates of kiralan | Item:Seasilk saddlebag embroidered with a chariot drawn by sea-creatures | true |
Item:Tiny icon of metal | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes |