Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Item type is::Tower shield]]
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=53573)
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=53573)
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 |
---|---|---|---|
Shield:Blackened steel tower shield edged with rampant dragons that surround an ornately set Elamiri sapphire | Mahchoe's Men's Shop (4) , Mahchoe's Men's Shop (3) | true | |
Shield:Blackened tower shield emblazoned with a brightly polished lightning bolt (1) | Bardic Journey (3) , Bardic Journey (2), Bardic Journey (1) | true | |
Shield:Blackened tower shield emblazoned with a brightly polished phoenix rising from a pyre | Bardic Journey (3) , Bardic Journey (2), Bardic Journey (1) | true | |
Shield:Blackened tower shield with an empty setting surrounded by barbed spikes | treasure map | true | |
Shield:Blue tower shield painted with a wave pattern | Griniel's Cottage | true | |
Shield:Bone and ivory inlaid tower shield | Trader Shop (Muspar'i) | true | |
Shield:Bright red tower shield bearing a gold device | Quelling the Riot/End loot | true | |
Shield:Brilliant green tower shield adorned with a leaping inkhorne | Faithful Defender (2) , Faithful Defender (1) | true | |
Shield:Bronze tower shield emblazoned with an imposing stag | Acaph's Acquisitions | true | |
Shield:Brown tower shield painted with a grey tornado | Griniel's Cottage | true | |
Shield:Brush silver tower shield etched with the image of twin crossed battle axes | Akigwe's Legacy: Secrets of the Tower/Incidental loot | true | |
Shield:Brushed silver tower shield etched with the image of a towering keep | Akigwe's Legacy: Secrets of the Tower/Incidental loot | true | |
Shield:Cherrywood tower shield banded with oak | Uwresari's Exotic Blunders (1) | true | |
Shield:Crescent-shaped steel tower shield embossed with a horn-of-plenty and a cluster of ripe red grapes | Item:Crescent-shaped tower shield sack , Extreme Shop, Item:Crescent-shaped tower shield sack, Armaments by Sqinth (1) | ||
Shield:Curved tower shield painted with a rayed sun on a deep crimson background | Ruins of Ulf'Hara/Supply Wagon , Return to the Keep 423/Supply Wagon | true | |
Shield:Curved tower shield painted with the image of a slain Lun'Shele Trekhalo | Trintah's Herbal Remedies | true | |
Shield:Dadoed tower shield | Wise Weapons (2) , Wise Weapons (1) | true | |
Shield:Dark red tower shield emblazoned with a ring of golden thorns | Acaph's Acquisitions | true | |
Shield:Dark tower shield centered with a silversteel boss | Squat Bungalow (2) | ||
Shield:Discolored tower shield painted with a great turnip battle scene | Terrific Turnip (2), Terrific Turnip (3) , Terrific Turnip (2) | true | |
Shield:Ebony tower shield emblazoned with a platinum lightning bolt striking a stout oak tree | Acaph's Acquisitions, Acaph's Acquisitions | true | |
Shield:Emblazoned tower shield | Theren Keep Armory | true | |
Shield:Emblazoned tower shield adorned with the silhouette of a dragon | Festival Armory | true | |
Shield:Emblazoned tower shield adorned with the silhouette of a spider | Obscure Memories (6) , Obscure Memories (3), Obscure Memories (1) | true | |
Shield:Emblazoned tower shield etched with the image of a dark raven | Provincial Paradise | true | |
Shield:Embossed tower shield inlaid with a mischievous turnip | Terrific Turnip (2), Terrific Turnip (3) , Terrific Turnip (2) | true | |
Shield:Emerald green tower shield | Curse of the Ghost Ship/Incidental Loot | true | |
Shield:Enameled tower shield painted with the Therengian royal crest | Trader Shop (Crossing) | true | |
Shield:Engraved gold-burnished tower shield | Overstocked and Underpriced | true | |
Shield:Forged steel tower shield intricately etched with an image of the Rissan Paladin Guild | Trintah's Herbal Remedies, Trintah's Herbal Remedies | true | |
Shield:Gleaming silver tower shield embossed with a set of golden scales | Grey Raven Commissary | true | |
Shield:Gleaming silvery tower shield etched with gold | Iprilu's Emporium (obsolete) | true | |
Shield:Gold tower shield emblazoned with a rising sun | Acaph's Acquisitions, Acaph's Acquisitions | true | |
Shield:Golden tower shield engraved with the words, "Truth, Loyalty, Honor!" | Elvisian's Guild Emporium | true | |
Shield:Golden tower shield trimmed with glistening emeralds | Fate's Fortune's Games/Prizes | true | |
Shield:Green tower shield painted with a large brown mountain | Griniel's Cottage | true | |
Shield:Grey tower shield divided by a turquoise cross | Field of Shields | true | |
Shield:Hammered-gold tower shield acid-etched with a wolf's head | Faithful Defender, Faithful Defender (2) , Faithful Defender (1) | true | |
Shield:Heater shield (crafted) | false | ||
Shield:Hide-covered tower shield reinforced with wide strips of copper | Empath Emporium (4) , Empath Emporium (3), Empath Emporium (2), Empath Emporium (1) | true | |
Shield:Highly-polished tower shield | Faithful Defender, Faithful Defender (2) , Faithful Defender (1) | true | |
Shield:Large iron tower shield prominently displaying a silver crest | Abandoned Dragon (2) , Abandoned Dragon (1) | true | |
Shield:Matte black tower shield embellished with a huge bloodstone at its center | Squat Bungalow (1) | true | |
Shield:Matte black tower shield studded with silver crescents | Empath Emporium (3) , Empath Emporium (2), Empath Emporium (1) | true | |
Shield:Matte-black tower shield embellished with a huge bloodstone at its center | Corik's Secret: Treasures of the Tomb/Incidental loot | true | |
Shield:Metal tower shield | Tembeg's Armory | ||
Shield:Midnight blue tower shield | Curse of the Ghost Ship/Incidental Loot | true | |
Shield:Midnight blue tower shield embedded with nine golden stars | Field of Shields | true | |
Shield:Mirror-finished tower shield centered with a steel dome | Empath Emporium (4) , Empath Emporium (3), Empath Emporium (2), Empath Emporium (1) | true | |
Shield:Orange-striped tower shield with bold black lettering | Porly's Emporlyum (1) | true |