Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Shadowleaf]]OR[[Uses material::Shadowleaf]]
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 | 39 | 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='Shadowleaf')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=1005469 - 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:Large shadowleaf panther with glinting midnight diamond eyes | Estate Holder Charity Auction 434 | |
Item:Lavish stormsilk pouch with braided shadowleaf ties | Hollow Eve Festival 425/Auction | |
Item:Masterfully-tailored shadowleaf moneyvest | Drathrok's Duskruin 426/Auction | |
Item:Mottled shadowleaf sketchbook with a Velakan starsteel clasp | Guildfest 445/Auction | true |
Armor:Pair of darkly variegated shadowleaf pants | Item:Light armor pack dyed in shadowy hues , Hollow Eve Festival 425/Auction | |
Armor:Pair of shadowleaf assassin's greaves with gusseted seams | Droughtman's Challenge 437/End loot , Droughtman's Challenge 433/End loot, Droughtman's Challenge 430/End loot | |
Item:Pair of shadowleaf leggings with a wide punka leather belt | Item:Brinewood basket adorned with an Imperial topaz clasp | true |
Item:Polished gold moradu-bone harp case | Hollow Eve Festival 425/Auction | |
Armor:Ribbed moradu-bone hauberk reinforced with shadowleaf binding | Hollow Eve Festival 428/Auction | |
Armor:Salt-stained shadowleaf leathers set with dreadful kraken-beak epaulets | Item:Imperial weave carryall set with an etched flooded goldfyre medallion , Droughtman's Challenge 444/Raffle | true |
Armor:Shadowleaf assassin's coat tinged somber black | Droughtman's Challenge 437/End loot , Droughtman's Challenge 433/End loot, Droughtman's Challenge 430/End loot | |
Armor:Shadowleaf assassin's cowl shrouded in somber black faeweave | Droughtman's Challenge 437/End loot , Droughtman's Challenge 433/End loot, Droughtman's Challenge 430/End loot | |
Armor:Shadowleaf assassin's gauntlets with tapered cuffs | Droughtman's Challenge 437/End loot , Droughtman's Challenge 433/End loot, Droughtman's Challenge 430/End loot | |
Armor:Shadowleaf assassin's leathers tinged somber black | Droughtman's Challenge 437/End loot , Droughtman's Challenge 433/End loot, Droughtman's Challenge 430/End loot | |
Item:Shadowleaf bellows with matching shadowbark handles | Drathrok's Duskruin 435/Auction | true |
Item:Shadowleaf gem pouch | Finest Box of Gems (1) | |
Armor:Shadowleaf gloves stitched with deep red on the palms | Item:Light armor pack dyed in shadowy hues , Hollow Eve Festival 425/Auction | |
Armor:Shadowleaf headdress embellished with draconic umbral-bone plating | Item:Shadowy rucksack pinned with a midnight diamond wyvern , Drathrok's Duskruin 448/Raffle | true |
Item:Shadowleaf highwayman's satchel | Hollow Eve Festival 439/Auction | true |
Item:Shadowleaf quiver graced with a Huntress diamond spider | Item:Huge steelsilk wolf spider with two rows of Huntress diamond eyes | true |
Shield:Shadowleaf small shield painted with a darkly sanguine king protea | Item:Canvas bag pinned with a silversteel warrior | true |
Item:Shadowleaf-bound book of master crafting instructions | Hollow Eve Festival 447/Auction | true |
Item:Single faesoul blossom strung on a shadowleaf cord | Hollow Eve Festival 425/Auction | |
Item:Sleek shadowleaf recliner with tapered telothian legs | Estate Holder Charity Auction 434 | |
Armor:Sleeved shadowleaf gloves encircled with maelstones at the cuffs | Item:Shadowy rucksack pinned with a midnight diamond wyvern , Drathrok's Duskruin 448/Raffle | true |
Armor:Sleeveless shirt crafted from void-black shadowleaf | Item:Light armor pack dyed in shadowy hues , Hollow Eve Festival 425/Auction | |
Armor:Supple armwraps of interwoven shadowleaf strips | Item:Light armor pack dyed in shadowy hues , Hollow Eve Festival 425/Auction | |
Weapon:Taisidon wayfinder's wildland machete wrapped in woven barkcloth and shadowleaf | Taisidon Mystery 435/Raffle | true |
Weapon:Tenebrous black ka'hurst pasabas with a shadowleaf-wrapped hilt | 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 |