Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Alabaster]]OR[[Uses material::Alabaster]]
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
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
`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
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 106 | 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='Alabaster')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=79474 - 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 | Rarity is |
---|---|---|
Item:Alabaster mask with a serene visage | Split Personalities (3) , Split Personalities (1), Item:Sand-scarred wooden bolt box | |
Item:Alabaster mixing stick carved in relief with ivy | Which Craft (1) | festival |
Item:Alabaster mortar engraved with ivy around the outside | Which Craft (1) | festival |
Item:Alabaster pestle carved in relief with ivy | Which Craft (1) | festival |
Item:Alabaster ring inset with the vulture of Aldauth | Misenseor Goods (6) , Misenseor Goods (5), Misenseor Goods (4), Misenseor Goods (3), Misenseor Goods (2), Misenseor Goods (1) | |
Item:Alabaster scorpion pin | Grave earth pile 432 prizes , Grave earth pile 428 prizes, Grave earth pile 425 prizes, Grave earth pile 421 prizes, Grave earth pile | |
Item:Alabaster sheep | Drathrok's Duskruin 442/Incidental loot , Drathrok's Duskruin 438/Incidental loot, Drathrok's Duskruin 435/Incidental loot, Drathrok's Duskruin 430/Incidental loot, Drathrok's Duskruin 426/Incidental loot | |
Item:Alabaster tile mosaic | Museum of Imperial History | common |
Item:Alabaster-trimmed Wayerd pyramid carved in relief with ivy | Which Craft (1) | festival |
Template:BEStones | ||
Item:Blue gold diary locket set with an ebony star sapphire | By the Book | |
Shield:Blue tower shield emblazoned with a snow-capped mountain | Acaph's Acquisitions | |
Breaking and Entering/Rooms and Loot/Material options | ||
Item:Brushed steel armband | Wyvern Trials gifts and prizes | |
Item:Brushed steel book locket embossed with crossed swords | By the Book | |
Item:Burnished gold clippers inset with slivers of alabaster | Estate Holder gifts | |
Item:Carved alabaster statuette resembling a rampaging snowbeast | Bacon Man's Birthday Bash 419/Pig Maze | |
Item:Cone shell choker adorned with shiny alabaster feathers | Drogor Shrine | festival |
Item:Delicate gold haircomb bearing a bouquet of alabaster pear blossoms | Estate Holder gifts | |
Weapon:Ebony bladed scimitar with an intricately carved alabaster hilt | Curiosities In Coral | auction |
Item:Elaborately braided ceremonial spidersilk sheath | Rusty Barnacle , River Dreamer, North Wind's Skimmer, Demosel's Lair (2), Demosel's Lair (1) | |
Item:Elegant alabaster fireplace with matching urns | Home for the Fireplace | |
Item:Fine mistsilk sack dotted with a multitude of stone beads | Hollow Eve Festival 414/Auction | |
Item:Gloomwood tome locket carved with a crude skull | By the Book | |
Item:Golden silk handfasting cord swathed in sheer black lace | Sputkin's Wagon , Sputkin's Splendors (5), Sputkin's Splendors (4), Sputkin's (3), Sputkin's (2) | |
Item:Grooved alabaster warhorn adorned with pewter clasps | Sound the Hunt (3) | |
Item:Hemispherical jeolzindu charm formed from tiny white alabaster cubes | Corik's Secret: Treasures of the Tomb/Incidental loot | |
Item:Huge alabaster egg | Sandbox , Item:Lump of dried earth, Harawep Shrine 421 | festival |
Item:Icesteel spellbook locket set with a cabochon fire agate | By the Book | |
Item:Immaculate cameo trailed by alabaster faces increasingly desiccated by khor'vela | Split Personalities (3) , Item:Red gold music box with its gilding flaking to reveal wood corrupted by bone bits | |
Item:Alabaster boulder | ||
Item:Alabaster divination bones | ||
Item:Alabaster flask | ||
Item:Alabaster lockpick ring | ||
Item:Alabaster ring inset with the vulture of Aldauth | ||
Item:Alabaster scorpion pin | ||
Item:Elaborately braided ceremonial spidersilk sheath | ||
Item:Golden silk handfasting cord swathed in sheer black lace | ||
Item:Grooved alabaster warhorn adorned with pewter clasps | ||
Item:Hemispherical jeolzindu charm formed from tiny white alabaster cubes | ||
Item:Jade hairsticks inlaid with twining alabaster ivy | ||
Item:Lithe alabaster Elf statue | ||
Item:Modest white prayer cloth with pale alabaster beads sewn along the edges | ||
Item:Pale alabaster parchment case dusted with sparkling gold flakes | ||
Item:Polished alabaster stone shaped like twin crossed bones | ||
Item:Sea-blue tinted crystal globe with brickwell tower inside | ||
Item:Set of pink alabaster limbs | ||
Item:Smoky soulstone encased in etched alabaster | ||
Item:Thick crimson moonsilver diadem centered with a winter opal | ||
Item:Thick crimson moonsilver hip-chain clasped with a winter opal |