Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Pewter]]OR[[Uses material::Pewter]]
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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 | ALL | PRIMARY | 382 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id WHERE (t2.o_hash='Pewter')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=70114 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Item:Brown suede pants with dull pewter buttons | Bacon Man's Birthday Bash 419/Pig Maze | |
Item:Brushed suede pants lined with pewter rivets | Darkbox 428 prizes , Darkbox 414 prizes, Basket of colored darts | |
Item:Buff doeskin cloak with vines embroidered along the hem | Jhanine Dering Cloaks (4) , Jhanine Dering Cloaks (3) | |
Item:Burning topaz sun charm set upon a pewter backing | Drathrok's Duskruin 442/Incidental loot | true |
Item:Calloused pewter foot with long cambrinth toenails | War and Craft (2) , War and Craft (1) | |
Item:Cambrinth sphere resting in a pewter paw | Paladins' Guild , Emporium | |
Item:Carved cherrywood cane topped with a pewter ball | Walk This Way (1) , Courtly Styles (2) | |
Weapon:Carved oaken parry stick shaped like a scrawny rat | Drathrok's Duskruin 446/Incidental loot , Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 435/Incidental loot, Drathrok's Duskruin 430/Incidental loot, Drathrok's Duskruin 422/Incidental loot, Drathrok's Duskruin 421/Incidental loot | true |
Item:Charcoal linen shirt with ebony silk ties | Rizadi's Outfitters (2) , Rizadi's Outfitters (1) | |
Item:Chicken-shaped pewter cloak pin | Pi'rasha's Pins (3) | true |
Item:Chubby ceramic flagon with a simple pewter lid | Ode to Glythtide (1) | |
Item:Clear crystal globe set on a pewter base | Snow Good | |
Item:Cloak of mottled smoky grey and flat black silk fastened with a pewter clasp | Jhanine Dering Cloaks (3) , Jhanine Dering Cloaks (2), Jhanine Dering Cloaks (1) | |
Item:Commemorative coin with rippled edges | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Competition miniature Merelew soldier wielding a tiny trident | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | true |
Item:Cracked pewter badge painted with "I have a stick and you look like a pinata" | Beppo's (2) | true |
Item:Creamy brocade vest with ornate pewter buttons | Bacon Man's Birthday Bash 419/Pig Maze | |
Item:Crooked pewter hand with long cambrinth fingernails | War and Craft (2) , War and Craft (1) | |
Weapon:Curved kythe | Tobb's Smithy, Tobb's Smithy (obsolete) | |
Item:Curved wood shaper painted with chevrons | Breaking and Entering/Work Room loot | false |
Item:Dangling pewter skull earring set with red glass eyes | Prison Riot: The Aftermath/Incidental loot | |
Item:Dark grey tweed vest lined with pale peach damask | This Little Piggy (7) , This Little Piggy (5), This Little Piggy (3) | |
Item:Dark jade weapon harness adorned with a pewter dragon | Fenwyrthie's Curio Shop , Estate Holder gifts | |
Item:Dark leather kilt fastened with a tarnished pewter pin | Order of the Black Fox/Gifts and prizes | |
Item:Dark pewter amulet with a rubied Bardic Blood Knot | Curiosities In Coral | true |
Item:Dark pewter ring cast in the shape of a face with a fanged and scowling mouth | Bacon Man's Birthday Bash 419/Pig Maze | |
Item:Deep black zibeline cloak edged with white fox fur | In The Snow (3) | true |
Item:Delicate bracelet of interlocking striped seaperch | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Delicate egg-shaped pendant with a small jagged hole chipped into it | ||
Item:Delicately spiraling armband crafted from polished pewter | Obscured Visions | |
Item:Dented pewter gravedigger's flask | Jakuv's All-Trades Outlet (3) , Jakuv's All-Trades Outlet (2), Jakuv's All-Trades Outlet (1) | |
Item:Dented pewter tankard painted with a corn field | Thorkim Family Farm 429/Pig Maze , Sleeping Dragon Corn Maze 447/Incidental loot, Sleeping Dragon Corn Maze 443/Incidental loot, Sleeping Dragon Corn Maze 439/Incidental loot, Sleeping Dragon Corn Maze 436/Incidental loot, Sleeping Dragon Corn Maze 432/Incidental loot, Sleeping Dragon Corn Maze 428/Incidental loot | |
Item:Detailed pewter dove with its wings folded | If You Beard It | true |
Item:Disfigured pewter bowl | Highway Robbery Redux | true |
Item:Duffel with a pewter clasp | Dying to Shop (2) | true |
Item:Dull pewter box enameled with pink roses | Quick Bite (4) | |
Item:Duo of short butter knives with ornately wrought handles | Tildi's Blooms (4) , Tildi's Blooms (3) | |
Item:Ebony oxhide zoster with several polished pewter buckles | Urn Back Time (2) | true |
Item:Embossed leather belt with a large pewter buckle | MegaSafari 413 game prizes , Hollow Eve Festival 439/Darkbox, Darkbox 414 prizes, Basket of colored darts | |
Item:Engraved pewter bracer embedded with a soulstone | Inner Illuminations (1) | |
Item:Engraved pewter cigarillo case clasped by a citrine lion | Cloudwalker's Smoke Shop | |
Item:Engraved pewter goblet | Curse of the Ghost Ship/Incidental Loot | |
Item:Etched pewter phylactery set on a leather strap | Only The Holy (2) | true |
Item:Etched pewter tankard | ArtSea Gifts and Souvenirs | true |
Item:Etched pewter tankard (2) | Origami Envelope | true |
Item:Exquisite haircomb twined in blossoms | Breaking and Entering/Bedroom loot | |
Item:Faded black satchel fastened with a pewter hammer clasp | Paladins' Guild , Emporium | |
Item:Filigree earrings threaded with beads | Breaking and Entering/Bedroom loot | |
Item:Fine metal pins | Breaking and Entering/Work Room loot | false |
Item:Fine pewter earcuff shaped to resemble a skeletal beast (1) | Turialo's Haven (6) |