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
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_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
0
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:Ash-rubbed scimitar with a silver hilt | Ristmuir's Armory | ||
Weapon:Bamboo-hilted scimitar with an etched blade | Bamboo Hut (3) | ||
Weapon:Barnacle encrusted scimitar | Skeletal sailor | ||
Weapon:Bent bone-hilted scimitar | Greater sluagh | true | |
Weapon:Black steel scimitar inset with a black diamond disc | Quest for Kanton's Dagger | ||
Weapon:Blackened scimitar set with a scratched silver charm in its hilt | Bacon Man's Birthday Bash 419/Pig Maze | ||
Weapon:Blackened steel scimitar dangling a braided lanyard from the hilt | Thorkim Family Farm 429/Pig Maze | ||
Weapon:Blackened steel scimitar etched with a silvery wolverine | Fiery Souls (2) , Fiery Souls (1) | true | |
Weapon:Blackened steel scimitar etched with silver stars | Starry Road (shop) | ||
Weapon:Blackened steel scimitar pierced with the silhouette of an undulate dragon | Mahchoe's Men's Shop (4) , Mahchoe's Men's Shop (3) | ||
Weapon:Blackened steel scimitar with a Musparan silk wrapped hilt | Premium raffles | true | |
Weapon:Blackened steel scimitar with an embossed leather hilt | Curse of the Ghost Ship/Incidental Loot | ||
Weapon:Blackened steel scimitar with an intricately carved alabaster hilt | High on the Frog | true | |
Weapon:Blue steel scimitar painted with frolicking puppies and kittens | Just a Slice (1) | ||
Weapon:Brass-edged scimitar with a hilt molded into the shape of dolphin | Morum Melgorehn/End loot | ||
Brass-etched scimitar engraved with the image of a ship | true | ||
Weapon:Brass-hilted scimitar etched with the image of a ship | Jourok | true | |
Weapon:Bright orange scimitar | Porly's Emporlyum (1) | true | |
Weapon:Bright red indurium scimitar dangling a trio of feathers from its hilt | Droughtman's Challenge 444/End loot , 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 | |
Weapon:Broken-tipped scimitar | Pirate buccaneer | true | |
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) |