Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::zachriedek||gremlin]]
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_blob` AS t1
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
(
((t1.o_hash='zachriedek') OR (t1.o_hash='gremlin')
))
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_blob` AS t1
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
(
((t1.o_hash='zachriedek') OR (t1.o_hash='gremlin')
))
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 | t1 | range | s_id, p_id, o_hash, s_id_2 | o_hash | 258 | 69 | Using index condition; Using temporary; Using filesort | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where | |
1 | SIMPLE | t2 | eq_ref | PRIMARY | PRIMARY | 4 | drwiki.t1.p_id | 1 | Distinct |
Auxilliary Tables
- Temporary table t2
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Item:Devious chakrel gremlin amulet hung from a slender steel cord | Sound the Hunt (2) | |
Item:Faded canvas pack with a circular cambrinth emblem | Quest for Kanton's Dagger | |
Item:Ghoulish gremlin doll with eyes of cool blue sapphire | Dunshade: Echo of Tears/End loot | |
Item:Gloriously polished jade ring inlaid with bronze gremlins | Trader Shop (Crossing) | |
Item:Gold medallion symbolizing dedication to Kertigen | Tending the Fold (2) , Tending the Fold (1), Festival Pavilion (2), Festival Pavilion (1) | |
Item:Gremlin anatomy chart | Gersvinda's Natural Studies (5) , Gersvinda's Natural Studies (2) | |
Item:Hematite ring inset with the raccoon of Zachriedek | Misenseor Goods (6) , Misenseor Goods (5), Misenseor Goods (4), Misenseor Goods (3), Misenseor Goods (2), Misenseor Goods (1) | |
Item:Homemade shrine crowded with tiny religious figurines | Eclectic Eccentric (3) , Eclectic Eccentric (2) | |
Item:Intricately embroidered robe of flowing nightsilk | Divinely Dressed | |
Item:Anloral raccoon pin | ||
Item:Cambrinth ankle cuff inlaid with black onyx raccoons to spell ZACHRIEDEK | ||
Item:Dark floor-length robe embroidered with the symbols of the dark aspects | ||
Item:Devious chakrel gremlin amulet hung from a slender steel cord | ||
Item:Faded canvas pack with a circular cambrinth emblem | ||
Item:Ghoulish gremlin doll with eyes of cool blue sapphire | ||
Item:Gloriously polished jade ring inlaid with bronze gremlins | ||
Item:Gremlin anatomy chart | ||
Item:Heavy cloak of beige wool | ||
Item:Hematite ring inset with the raccoon of Zachriedek | ||
Item:Homemade shrine crowded with tiny religious figurines | ||
Item:Intricately embroidered robe of flowing nightsilk | ||
Item:Leather thigh bag heavily beaded in cambrinth with the image of a chubby raccoon | ||
Item:Mosaic cambrinth medallion depicting the image of Zachriedek's raccoon | ||
Item:Oaken icon of the god Zachriedek | ||
Item:Pair of gremlin slippers | ||
Item:Polished white gold ring set with a large amethyst | ||
Item:Rust-colored jute prayer rug with a crudely painted snarling raccoon | ||
Item:Sturdy platinum-spool parchment | ||
Item:Supple leather pouch beaded in cambrinth to spell ZACHRIEDEK | ||
Item:Triple-stranded gold hip chain dangling with tiny cambrinth raccoons | ||
Item:Wide gold ring set with a large cambrinth raccoon | ||
Item:Zachriedek box | ||
Item:Zachriedek effigy | ||
Armor:Lamellar hauberk crafted of enamelled bronze | Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot | |
Item:Leather thigh bag heavily beaded in cambrinth with the image of a chubby raccoon | Forever Faithful(2), Forever Faithful (2) , Forever Faithful (1) | |
Weapon:Mammoth Zachriedek war icon set atop a haft of sickly aspen | Misenseor Goods (4), Misenseor Goods (5) , Misenseor Goods (4) | |
Item:Miniature Zachriedek figurine dressed in midnight black robes | Beyond the Barrier: The Devastation of Lyras/End loot | |
Item:Mosaic cambrinth medallion depicting the image of Zachriedek's raccoon | Forever Faithful(2), Forever Faithful (2) | |
Item:Oaken icon of the god Zachriedek | Sputkin's Splendors (5) , Sputkin's Splendors (4), Sputkin's (3), Sputkin's (2), Sputkin's (1), Iormethani's Godly Objects (2), Iormethani's Godly Objects (1) | |
Item:Painted wooden medallion | ||
Item:Pair of gremlin slippers | Item:Zachriedek box , Masquer Aid (1), Item:Zachriedek box | |
Item:Pale golden moneybelt subtly embroidered with silver thread | Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot | |
Item:Polished white gold ring set with a large amethyst | Trader Shop (Crossing) | |
Item:Pyrite Zachriedek carving | Glassus' Shop | |
Item:Rust-colored jute prayer rug with a crudely painted snarling raccoon | Sputkin's Splendors (5) , Sputkin's Splendors (4), Sputkin's (3) | |
Item:Rust-colored prayer rug with a crudely painted snarling raccoon (1) | Sputkin's Wagon | |
Armor:Snarled golden gremlin mask | Trader Guild, Crossing Shop, Trader Shop (Crossing) | |
Item:Stained glass Zachriedek window | Wicked Windows (4) , Wicked Windows (3), Wicked Windows (2), Wicked Windows (1) | |
Item:Sturdy platinum-spool parchment | Scriptorium | |
Item:Supple leather pouch beaded in cambrinth to spell ZACHRIEDEK | Forever Faithful (2) , Forever Faithful (1) |