Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Item type is::Trader jewelry]]
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=497637)
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=497637)
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 |
---|---|---|---|
Item:Crystal bracelet inlaid with precious stones | Trader Shop (Crossing) | true | |
Weapon:Curved steel iltesh with a carved bone hilt | Trader Shop (Muspar'i), Trader Shop (Muspar'i) | ||
Item:Diamond-encrusted platinum lunchbox | Herb's Bakery | true | |
Item:Diamond-studded platinum ring bearing the crest of the Trader's Guild | Trader Guild , Ratha Shop | true | |
Armor:Dwarven mining helm (2) | Akigwe's Legacy: Secrets of the Tower/End loot | true | |
Item:Engraved ramshorn archer's ring | Acaph's Acquisitions | true | |
Item:Faceted blue topaz ring in an elaborate silver setting | Stone Soup | true | |
Item:Gem-encrusted golden goblet | Curse of the Ghost Ship/Incidental Loot , Akigwe's Legacy: Secrets of the Tower/Incidental loot | true | |
Item:Gloriously polished jade ring inlaid with bronze gremlins | Trader Shop (Crossing) | true | |
Item:Glossy jade thumb ring bearing a bronze crest | Breaking and Entering/Library loot | false | |
Item:Gold manacle with a broken chain | Quelling the Riot/End loot , Item:Black velvet jewelry box, Item:Black velvet jewelry box | true | |
Item:Gold-plated lunchbox | Herb's Bakery | true | |
Item:Golden sunburst pin | Stone Soup | true | |
Item:Hammered copper lunchbox | Herb's Bakery | true | |
Item:Hand-tooled contract case adorned with a diamond flower | Breaking and Entering/Library loot | true | |
Item:Heavy silver-inlaid bracelet | Item:Carved onyx box , Droughtman's Maze, Droughtman's Challenge 433/Incidental loot, Droughtman's Challenge 430/Incidental loot, Droughtman's Challenge 426/Incidental loot, Item:Carved onyx box | true | |
Item:Intricate sapphire Dragon Spine orchid pin with a fine platinum stem | All That Sparkles | true | |
Item:Animite badge engraved with an outstretched hand | true | ||
Item:Bronze-painted tin lunchbox surmounted by a toothy gear | true | ||
Item:Carved jade necklace with polished bronze clasps | true | ||
Item:Delicate platinum ring adorned with a diamond butterfly | true | ||
Item:Diamond-encrusted platinum lunchbox | true | ||
Item:Gem-encrusted golden goblet | true | ||
Item:Gold-plated lunchbox | true | ||
Item:Hammered copper lunchbox | true | ||
Item:Intricate sapphire Dragon Spine orchid pin with a fine platinum stem | true | ||
Item:Ornate golden platter | true | ||
Item:Platinum hairpin with diamond letters spiraling along the length (hodierna) | true | ||
Item:Platinum hairpin with diamond letters spiraling along the length (meraud) | true | ||
Item:White gold necklace displaying a large amethyst pendant | true | ||
Item:Large crystal skull | Corik's Secret: Treasures of the Tomb/End loot | true | |
Item:Ledger case of aromatic cedar and a brilliant green sapphire set on the front in a golden rosette | Sebastien's Fine Print (2) , Sebastien's Fine Print (1) | true | |
Item:Linked necklace of tiny gold manacles | Quelling the Riot/End loot , Item:Black velvet jewelry box, Item:Black velvet jewelry box | true | |
Item:Little cat carved of flawless onyx | Ahreusse's Atelier (1) | true | |
Item:Miniature apple tree | Trader Guild, Ratha Shop, Trader Guild , Ratha Shop | true | |
Item:Ornate golden platter | Curse of the Ghost Ship/Incidental Loot | true | |
Item:Pink lunchbox emblazoned with a frolicking kitten | Herb's Bakery | true | |
Item:Platinum badge engraved with an outstretched hand | Trader Guild , Ratha Shop | true | |
Item:Platinum brooch set with a large moonstone | Hollow Eve Festival 414/Raffles | true | |
Item:Platinum hairpin with diamond letters spiraling along the length (hodierna) | Item:Mother-of-pearl egg covered with a fine silver filigree , Item:Mother-of-pearl egg covered with a fine silver filigree | true | |
Item:Platinum hairpin with diamond letters spiraling along the length (meraud) | Item:Mother-of-pearl egg covered with a fine silver filigree , Item:Mother-of-pearl egg covered with a fine silver filigree | true | |
Weapon:Platinum-inlaid skinning knife set with a large diamond | Trader Guild , Ratha Shop | ||
Item:Polished Elven ivy anklet crafted from interlocking jade leaves | All That Sparkles | true | |
Item:Polished white gold earrings set with two tear-shaped amethysts | Trader Guild, Crossing Shop, Trader Shop (Crossing) | true | |
Item:Polished white gold ring set with a large amethyst | Trader Shop (Crossing) | true | |
Item:Rose quartz brooch set in filigreed silver | Trader Guild, Crossing Shop, Trader Shop (Crossing) | true | |
Item:Ruby-studded gold ring bearing the crest of the Trader's Guild | Trader Guild , Ratha Shop | true | |
Item:Shimmering moonstone fae slipper pin with a brushed silver stem | Droughtman's Maze , All That Sparkles | true | |
Item:Silver earring set with a small red garnet | Trader Shop (Crossing) | true | |
Item:Silver wire bracelet strung with multi-hued gemstone charms | All That Sparkles | true |