Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Noun is::scimitar]]
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='scimitar') AND t1.p_id=2021224)
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
20
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='scimitar') AND t1.p_id=2021224)
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
20
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, p_id, o_hash, s_id_2 | p_id | 262 | const, const | 255 | Using index condition; 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 | Is incomplete |
---|---|---|---|
Weapon:Carved bamboo-hilted scimitar | Bamboo Hut (2) | ||
Weapon:Carved oak-hilted scimitar set with a blue topaz sphere | Elemental Emissary , Elemental Armaments | ||
Weapon:Carved oak-hilted scimitar set with a carved ruby flame | Elemental Emissary , Elemental Armaments | ||
Weapon:Carved oak-hilted scimitar set with a sapphire wave | Elemental Emissary , Elemental Armaments | ||
Weapon:Carved oak-hilted scimitar set with a white diamond lightning bolt | Elemental Emissary , Elemental Armaments | ||
Weapon:Carved oak-hilted scimitar set with a yellow diamond cut to resemble a boulder | Elemental Emissary , Elemental Armaments | ||
Weapon:Ceremonial scimitar with an ornate skull-shaped pommel | Forever Faithful (2), Forever Faithful (2) , Forever Faithful (1) | ||
Weapon:Cracked bone-hilted scimitar | Greater sluagh | true | |
Weapon:Crescent-bladed scimitar engraved with a flame pattern | Over The Edge, Over the Edge (1) | true | |
Weapon:Crescent-bladed scimitar engraved with a flame pattern (2) | Over the Edge (2) | true | |
Weapon:Curved damascened scimitar with a serpent-shaped topaz pommel | Cultured Attire (6) | ||
Weapon:Curved damascened scimitar with a yak-shaped topaz pommel | Cultured Attire (5) | ||
Weapon:Curved gilt-edged scimitar with a bone dog head pommel | This 'N' That (5) , ScallyWags | true | |
Weapon:Curved haledroth scimitar | Drathrok's Duskruin 422/Drathrok's Assemblage | ||
Weapon:Curved scimitar inlaid with a leaping sapphire dolphin | Visions of Holiness (2) , Visions of Holiness (1) | true | |
Weapon:Curved scimitar with a bare metal grip | Amylia's Attic (1) | true | |
Weapon:Curved scimitar with a golden leather-wrapped hilt | MegaSafari 413 game prizes , Basket of colored darts | ||
Weapon:Curved scimitar with a jade leather-wrapped hilt | Dragon's Horde | true | |
Weapon:Curved scimitar with an ice blue blade | Hero to Go (1) | ||
Weapon:Curved scimitar with an indigo leather-wrapped hilt | MegaSafari 413 game prizes , Basket of colored darts | ||
Weapon:Curved silvery scimitar with a nightsilk-wrapped hilt | Visions of Holiness (2) , Visions of Holiness (1) | ||
Weapon:Curved steel scimitar with a black leather-wrapped hilt | All Things Bardic, All Things Bardic (2) , All Things Bardic (1) | ||
Weapon:Curved steel scimitar with the mantra of the Warrior Mage guild etched into the silvered blade | War and Craft (1), War and Craft (2), War and Craft (2) , War and Craft (1) | true | |
Weapon:Curved-blade scimitar engraved with nightingales | Hollow Eve Festival 410/Raffles | true | |
Weapon:Curving golden scimitar with a silk-wrapped hilt | Bardic Barge (1), Bardic Barge (2), Bardic Barge (2) , Bardic Barge (1) | ||
Weapon:Curving scimitar with a scaled leather grip | Squat Bungalow (2) | ||
Weapon:Curving steel scimitar with a silvery horn hilt | Harbor Tower, First Floor, Harbor Tower | ||
Weapon:Damascened scimitar | Slay it with Music (1) | ||
Weapon:Dark steel scimitar with a polished e'erdream hilt | Dark Defenders (2) | ||
Weapon:Dark steel scimitar with a polished flamewood hilt | Dark Defenders (1) | ||
Weapon:Darkened scimitar with a simply embossed blade | King Fade's Back Alley Bazaar (1) | ||
Weapon:Deep ebony exoskeletal scimitar | Squat Bungalow | ||
Weapon:Dull grey scimitar with a rusted hilt | Second Round (2) , One Man's Trash (3) | true | |
Weapon:Dull iron scimitar with a bronze hilt wrapped tightly in viperskin | Festival Pavilion (2) , Festival Pavilion (1) | true | |
Weapon:Dull iron scimitar with an ebony hilt wrapped tightly in cobraskin | Festival Pavilion (2) , Festival Pavilion (1) | ||
Weapon:Ebony bladed scimitar with an intricately carved alabaster hilt | Curiosities In Coral | true | true |
Weapon:Elegantly curved scimitar inlaid with blood rubies | King Fade's Back Alley Bazaar (2) | true | |
Weapon:Elongated watersteel scimitar with a carnelian pommel | Cultured Attire (1), Cultured Attire (1) | true | |
Weapon:Elongated watersteel scimitar with a turquoise pommel | Cultured Attire (3) , Cultured Attire (2) | true | |
Weapon:Engraved scimitar | Kather watcher | ||
Weapon:Engraved scimitar hilted in flame-kissed gold | Outcast Military Surplus | ||
Weapon:Engraved scimitar with a blued steel blade | It's Elemental, It's Elemental | true | |
Weapon:Engraved scimitar with a cambrinth hilt | Curse of the Ghost Ship/End Loot | true | |
Weapon:Engraved scimitar with a leather-wrapped hilt | Curse of the Ghost Ship/Incidental Loot | ||
Weapon:Etched scimitar engraved with the centaurs of Trothfang | Taisidon Safari 417/Raffles | ||
Weapon:Etched steel scimitar affixed with a bronze-inlaid hilt | true | ||
Weapon:Etched steel scimitar affixed with a platinum-inlaid hilt | true | ||
Weapon:Etched steel scimitar affixed with a silver-inlaid hilt | true | ||
Weapon:Etched steel scimitar with a green silk-wrapped grip | Sutler's Wagon | ||
Weapon:Folded steel scimitar with a hilt shaped like flared-wings and capped by a claw clasping a spherical crystal | Curse of the Ghost Ship/End Loot | true |