Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Item type is::Carving knife]]
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) ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=69028)
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
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) ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=69028)
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
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ALL | PRIMARY | 2 | Using temporary; Using filesort | ||||
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
Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item | Is incomplete |
---|---|---|---|
Weapon:Bone-hilted carving knife | Blood and Gourd (5) , Blood and Gourd (4), Blood and Gourd (3), Blood and Gourd (2), Blood and Gourd (1) | ||
Weapon:Bone-hilted carving knife with a tiny talisman-shaped cambrinth stone set into the pommel | War and Craft (2) , War and Craft (1) | ||
Weapon:Bronze carving knife acid-etched with coyotes | Cleric Shop (Muspar'i) | ||
Weapon:Brushed gold carving knife with a down-curved blade | Simply Essential (1) | ||
Weapon:Caracal fang carving knife | Trintah's Herbal Remedies, Trintah's Herbal Remedies | true | |
Weapon:Carving knife | Zerek's General Store , Wildland goblin, Wild Sea-worn Monk, Visfarej Cehs (obsolete), Visfarej Cehs, Tobb's Smithy (obsolete), Therenborough General Store, Somber Shaman, Item:Slim dark leather arm sheath with small gemstone fragments, Pale Black-Robed Theurgist, Old battle priest, Old Halfling cook, Lively crimson-robed priestess, Freckled Young Acolyte, Engineering Society (Riverhaven), Engineering Society (Ratha), Engineering Society (Muspar'i), Engineering Society (Hibarnhvidar), Engineering Society (Crossing), Enfermine's Dry Goods, Crazed madman | ||
Weapon:Carving knife (bone) | false | ||
Weapon:Carving knife (metal) | false | ||
Weapon:Carving knife (stone) | false | ||
Weapon:Carving knife encrusted with dried orange gunk | Blood and Gourd (5) , Blood and Gourd (4), Blood and Gourd (3), Blood and Gourd (2), Blood and Gourd (1) | ||
Weapon:Cedar-handled carving knife inset with a bronze turnip | Terrific Turnip (3) , Terrific Turnip (2), Terrific Turnip (1) | ||
Weapon:Celestial blue carving knife displaying the Moon Mage Guild crest | Slice and Dice (1) | ||
Weapon:Chipped steel carving knife | Ilerenz's Supplies | ||
Weapon:Coral-hilted carving knife set with a large freshwater pearl | Blood and Gourd (5) , Blood and Gourd (4), Blood and Gourd (3), Blood and Gourd (2), Blood and Gourd (1) | ||
Weapon:Darkened steel carving knife with a cambrinth-studded ironwood grip | War and Craft (2) , War and Craft (1) | ||
Weapon:Fang-pearl inlaid carving knife | Trintah's Herbal Remedies | true | |
Weapon:Flame-coral inlaid carving knife | Trintah's Herbal Remedies, Trintah's Herbal Remedies | true | |
Weapon:Flamewood-handled carving knife with a damascened steel blade | Simply Essential (2) | true | |
Weapon:Floral-patterned carving knife | Trintah's Herbal Remedies | true | |
Weapon:Frosty champagne carving knife displaying the Bards' Guild crest | Slice and Dice (1) | ||
Weapon:Gleaming silver carving knife | Kharsaan's Tent | ||
Weapon:Gold-handled carving knife set with a faceted ruby | Trader Guild , Ratha Shop | true | |
Weapon:Green carving knife engraved with the form of a dragon in flight | Fenwyrthie's Curio Shop , Estate Holder gifts | ||
Weapon:Grey-hilted carving knife | Game of Chicken | ||
Weapon:Hunter green carving knife displaying the Rangers' Guild crest | Slice and Dice (1) | ||
Weapon:Jeweled carving knife | Trintah's Herbal Remedies, Trintah's Herbal Remedies | true | |
Weapon:Liver-colored carving knife with a blackened blade | Slice and Dice (1) | ||
Weapon:Mahogany-handled carving knife with a curved golden blade | Simply Essential (2) | ||
Weapon:Narrow carving knife with a polished hilt | Breaking and Entering/Work Room loot | false | |
Weapon:Obsidian carving knife with an etched ironwood hilt | Cleric Shop (Riverhaven) | ||
Weapon:Orange carving knife | Boggle Blast (5) , Boggle Blast (4) | ||
Weapon:Ornate whalebone carving knife | Trintah's Herbal Remedies, Trintah's Herbal Remedies | true | |
Weapon:Oxblood red carving knife displaying the Empaths' Guild crest | Slice and Dice (1) | ||
Weapon:Polished brass carving knife with a twining vine etched along the blade | Simply Essential (1) | ||
Weapon:Polished carving knife capped with a soulstone pommel surrounded by amber chunks | Inner Illuminations (1) | ||
Weapon:Polished carving knife with a cambrinth-inset rosewood hilt | War and Craft (2) , War and Craft (1) | ||
Weapon:Pure white carving knife displaying the Paladins' Guild crest | Slice and Dice (1) | ||
Weapon:Razor-sharp silver carving knife | Trintah's Herbal Remedies, Trintah's Herbal Remedies | true | |
Weapon:Rich golden carving knife displaying the Traders' Guild crest | Slice and Dice (1) | ||
Weapon:Ritual carving knife with a polished ebony handle | Item:Nightsilk offering pouch clasped with a thirteen-point star , Item:Leather offering pouch dyed in mottled shades of brown, Item:Nightsilk offering pouch clasped with a thirteen-point star, Item:Crimson velvet offering pouch clasped with a gold phoenix, Item:Black samite offering pouch, Divinely Dressed, Item:Black samite offering pouch | true | |
Weapon:Ritual carving knife with a polished ivory handle | Item:White samite offering pouch , Item:White samite offering pouch, Item:Gauzy white spidersilk offering pouch trimmed with soft owl feathers, Item:Blue velvet offering pouch clasped with a thirteen-point star, Divinely Dressed, Item:Blue velvet offering pouch clasped with a thirteen-point star | true | |
Weapon:Ritual ebony carving knife | Warrior Mage Guild Shop, Griniel's Cottage | true | |
Weapon:Ritual jet-black carving knife | Griniel's Cottage | true | |
Weapon:Ritual silver carving knife with an ebony handle | Griniel's Cottage, Griniel's Cottage | true | |
Weapon:Ruby-hilted carving knife inlaid with jet | Dunshade: Echo of Tears/End loot | true | |
Weapon:Serrated carving knife with a molded brass hilt capped by a pair of cambrinth bats | War and Craft (2) , War and Craft (1) | ||
Weapon:Shadowy grey carving knife displaying the Thieves' Guild crest | Slice and Dice (1) | ||
Weapon:Shark-tooth carving knife with black coral hilt | Item:Otterskin diver's thigh sheath decorated with silver fittings , Jakuv's All-Trades Outlet (2), Jakuv's All-Trades Outlet (1), Item:Otterskin diver's thigh sheath decorated with silver fittings | ||
Weapon:Silver-bladed carving knife with a fine-grained walnut handle | Simply Essential (1) | ||
Weapon:Silver-edged carving knife with a pale lacewood hilt | Riverhaven Cleric Shop, Cleric Shop (Riverhaven) | true |