Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::shrew]]OR[[Uses material::Shrew]]
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 | 124 | 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='shrew')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=71065 - 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:Bright silk devotional pouch embroidered with a wild-eyed shrew | Visions of Holiness (2) , Visions of Holiness (1) | |
Item:Brilliant multicolored parchment satchel embroidered with a coy shrew | Scriptorium | |
Item:Bronze anklet inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | |
Item:Bronze armband inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | true |
Item:Brushed gold shrew amulet suspended from a heavy chain | Amulets by Liathe (3) , Amulets by Liathe (1) | |
Item:Burnished gold ring set with a large cambrinth shrew | Forever Faithful (2) , Forever Faithful (1) | |
Item:Cambrinth ankle cuff inlaid with fire opal shrews to spell KERENHAPPUCH | Forever Faithful (2) , Forever Faithful (1) | |
Item:Cinnabar ring inset with the shrew of Kerenhappuch | Misenseor Goods (6) , Misenseor Goods (5), Misenseor Goods (4), Misenseor Goods (3), Misenseor Goods (2), Misenseor Goods (1) | |
Item:Clouded glass armband strung with a constellation of tiny stars | Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot | |
Item:Colorful silken prayer shawl with a beaded fringe | Divinely Dressed | |
Item:Copper cowbell with a sardonyx owl handle | Joys of Noise (6) | |
Item:Crafty shrew | Heavenly Entrances (1) | |
Item:Dark crystal jar beaded with tiny diamond shrews | Visions of Holiness (2) | |
Item:Dark floor-length robe embroidered with the symbols of the dark aspects | Hide and Seek | |
Item:Dark parchment illustrated with spectral shrews | Taisidon Mystery 446/A'baya Esplanade | true |
Armor:Darkly tinted augmented hauberk with an emblazoned disk adorning the chest | Griniel's Cottage, Griniel's Cottage | |
Item:Decrepit shrew amulet threaded on a cord of twisted sinew | Amulets by Liathe (6) , Amulets by Liathe (5) | |
Item:Elegant midnight black Elothean silk robe cinched with a triple-wrapped sash | Silk Lotus (2) , Silk Lotus (1) | |
Item:Elegantly carved necklace formed from interlocking crystal cubes | Magma Falls Mini-Festival Auction | true |
Item:Engraved silver censer suspended from a sturdy chain (1) | Brother Durantine's Shop | |
Item:Eye-searing bright green tabard emblazoned with the shrew of the mad goddess Kerenhappuch | Tending the Fold (2) , Tending the Fold (1), Hollow Eve Festival 406/Raffles, Hollow Eve Festival 392/Raffles | |
Item:Flamboyant firesilk mage's robes clasped with a lava sphalerite | treasure map | true |
Item:Fuzzy brown shrews with long leather tails | Twilight Treasures | |
Weapon:Gargantuan Kerenhappuch war icon set atop a chiseled haft of cocobolo | Misenseor Goods (5) , Misenseor Goods (3) | |
Item:Gaudy rainbow silk spellbook case clasped with a carved mahogany shrew | Mystical Machinations (2) , Mystical Machinations (1) | |
Weapon:Gleaming claymore with jewel-encrusted quillions (2) | ||
Weapon:Gleaming claymore with jewel-encrusted quillions (3) | Dark Defenders (2) | |
Weapon:Gleaming steel briquet with a golden braided lanyard (1) | ||
Weapon:Gleaming steel briquet with a golden braided lanyard (2) | Dark Defenders (2) | |
Item:Gleaming uthamar tin topped by temptress beryl stones | Su Helmas 444: Make Haste!/End loot | true |
Item:Gold medallion symbolizing dedication to Meraud | Tending the Fold (2) , Tending the Fold (1), Festival Pavilion (2), Festival Pavilion (1) | |
Item:Grey silk surcoat embroidered with a clambering brown shrew | Seiryn's Transformations (4) , Seiryn's Transformations (3), Seiryn's Transformations (2), Seiryn's Transformations (1), Item:Cerise silk surcoat embroidered with a grey horned owl, Item:Cerise silk surcoat embroidered with a grey horned owl | |
Item:Hollow Eve 439 gift | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Ichea, Hollow Eve Festival 439 | true |
Item:Indurium lockpick tailband etched with a shrew | Droughtman's Challenge 444/Incidental loot | true |
Weapon:Intricately carved javelin displaying a brilliant forest's heart garnet | Dark Defenders (2) | |
Item:Intricately embroidered robe of flowing nightsilk | Divinely Dressed | |
Weapon:Ironwood-hafted mace carved with shrews | Griniel's Cottage | |
Item:Aged cherrywood humidor trimmed with a thin golden band | ||
Item:Animal skeleton | ||
Item:Anloral shrew pin | ||
Item:Black leather boots studded with silver shrews | ||
Item:Blood-red handfasting cord fastened with two glassy black obsidian tokens | ||
Item:Bright silk devotional pouch embroidered with a wild-eyed shrew | ||
Item:Brilliant multicolored parchment satchel embroidered with a coy shrew | ||
Item:Bronze armband inlaid with a cambrinth avatar | ||
Item:Brushed gold shrew amulet suspended from a heavy chain | ||
Item:Burnished gold ring set with a large cambrinth shrew | ||
Item:Cambrinth ankle cuff inlaid with fire opal shrews to spell KERENHAPPUCH | ||
Item:Cinnabar ring inset with the shrew of Kerenhappuch | ||
Item:Dark crystal jar beaded with tiny diamond shrews |