Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Item type is::Short bow||Shortbow]]
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
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id
INNER JOIN
`t3` AS t3 ON t1.o_id=t3.id) ON t0.smw_id=t1.s_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
505
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
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id
INNER JOIN
`t3` AS t3 ON t1.o_id=t3.id) ON t0.smw_id=t1.s_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
505
OFFSET
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | system | PRIMARY | 1 | Using temporary; Using filesort | ||||
1 | SIMPLE | t2 | ALL | PRIMARY | 2 | |||||
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, drwiki.t2.id | 1 | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) (2021226).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021226 LIMIT 1 - Temporary table t3
INSERT IGNORE INTO `t3` (id) VALUES (82095)
INSERT IGNORE INTO `t3` (id) VALUES (82095)
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item | Is incomplete |
---|---|---|---|
Weapon:Bone-tipped yew short bow | Sutler's Wagon | ||
Weapon:Copper-banded maple short bow with a braided spidersilk bowstring | Turquoise Tent, Turquoise Tent | ||
Weapon:Copperwood short bow inlaid with malachite oak leaves | Curse of the Ghost Ship/Incidental Loot | ||
Weapon:Cypress shortbow with silver filigreed limbs | treasure map | true | true |
Weapon:Damaris shortbow | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Sleeping Dragon Corn Maze 439/End loot | true | |
Weapon:Ebonwood shortbow with an ornately carved grip | Hollow Eve Festival 406/Raffles | true | |
Weapon:Ebony competition shortbow with animite inlay | Droughtman's Challenge 426/Incidental loot | ||
Weapon:Ebony sniper's shortbow engraved with Dergati's all-seeing eye | true | ||
Weapon:Ebony sniper's shortbow tipped with perfect nightfire opals | true | ||
Weapon:Elaborate animite-tipped short bow carved from desert palms | Outcast Military Surplus, Outcast Military Surplus | true | |
Weapon:Exquisite cloudbark alpine shortbow wrapped in smokewhorl | Estate Holder Mini-Fest 442/Auction | true | true |
Weapon:Flamethorn shortbow intricately engraved with a pattern of coiled dragons | Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot | true | |
Weapon:Flawless diamondwood shortbow graced with a trio of Huntress diamonds | Droughtman's Challenge 441/End loot , Droughtman's Challenge 437/End loot, Droughtman's Challenge 433/End loot | true | |
Weapon:Glazed mahogany shortbow | true | ||
Weapon:Leather and horn-backed shortbow | Slings and Arrows of Outrageous Fortune | ||
Weapon:Leather-gripped yew shortbow | Milgrym's Weapons | ||
Weapon:Leather-wrapped shortbow tied with a dangling bundle of bones | Hero to Go (1) | ||
Weapon:Matte black Nisha shortbow carved with cinnibar-rubbed spirals | Hollow Eve Festival 410/Raffles | true | |
Weapon:Notched teak shortbow | Wise Weapons (2) , Wise Weapons (1) | true | |
Weapon:Ornately carved goldwood Nisha shortbow | Mentor gifts and prizes | true | |
Weapon:Recurved haon short bow with a polished coral handle | Armaments by Sqinth (2) | ||
Weapon:Rowan short bow engraved with images of various woodland animals | Armaments by Sqinth (2) | ||
Weapon:Shortbow (crafted) | false | ||
Weapon:Silverwillow shortbow with a lotusweave-wrapped grip | Open Lotus Designs (1) | ||
Weapon:Silvery grey-black alerce shortbow tinged with reddish highlights | Hollow Eve Festival 414/Auction | true | true |
Weapon:Sniper's short bow dyed a deep forest green | Survivalist Supplies | ||
Weapon:Steel short bow | Avlea's Bows, Avlea's Bows | true | |
Weapon:Steel-wrapped ironwood short bow with a braided spidersilk bowstring | true | ||
Weapon:Striped shortbow painted to resemble a raccoon tail | This 'N' That (3), This 'N' That (3) | true | |
Weapon:Thin steel-gripped shortbow | true | ||
Weapon:Alder gut-stringed shortbow with a cracked leather grip | true | ||
Weapon:Ash short bow | true | ||
Weapon:Beechwood short bow | true | ||
Weapon:Black short bow carved into the shape of a stylized dolphin | |||
Weapon:Bone-tipped yew short bow | |||
Weapon:Copperwood short bow inlaid with malachite oak leaves | |||
Weapon:Ebony sniper's shortbow engraved with Dergati's all-seeing eye | true | ||
Weapon:Elaborate animite-tipped short bow carved from desert palms | true | ||
Weapon:Leather and horn-backed shortbow | |||
Weapon:Leather-wrapped shortbow tied with a dangling bundle of bones | |||
Weapon:Matte black Nisha shortbow carved with cinnibar-rubbed spirals | true | ||
Weapon:Polished mistwood short bow strung with twisted sinew | |||
Weapon:Recurved haon short bow with a polished coral handle | |||
Weapon:Rowan short bow engraved with images of various woodland animals | |||
Weapon:S'lai short bow | |||
Weapon:Sniper's short bow dyed a deep forest green | |||
Weapon:Sniper's short bow veined with matte silver | |||
Weapon:Steel short bow | true | ||
Weapon:Steel-wrapped ironwood short bow with a braided spidersilk bowstring | true | ||
Weapon:Striped shortbow painted to resemble a raccoon tail | true | ||
Weapon:Wickedly curved stormtouched lirisan shortbow with Huntress diamond inlay | Drathrok's Duskruin 438/Raffle | true | |
Weapon:Wide-bellied battle shortbow with a black leather grip | |||
Weapon:Yew shortbow with a horn riser | true | ||
Weapon:Yew shortbow with a leather handgrip | Wise Weapons (2) | true | |
Weapon:Yew shortbow with a rawhide grip | Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 438/Incidental loot, Drathrok's Duskruin 435/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot | true |