Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Item:+]] [[Has item property::gaethzen]]
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_object_ids` AS t2
INNER JOIN
`smw_di_blob` AS t3 ON t2.smw_id=t3.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=118
AND (
(t3.o_hash='gaethzen') AND t3.p_id=2021204)
)
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
15
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_object_ids` AS t2
INNER JOIN
`smw_di_blob` AS t3 ON t2.smw_id=t3.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=118
AND (
(t3.o_hash='gaethzen') AND t3.p_id=2021204)
)
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
15
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | ref | s_id, p_id, o_hash, s_id_2 | p_id | 262 | const, const | 74 | Using index condition; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t3.s_id | 1 | Using where | |
1 | SIMPLE | t2 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | drwiki.t3.s_id | 1 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneSource | |
---|---|
Gaethzen sphere | Treasure Creature , Tent of Avnel the Glassblower (4), Tent of Avnel the Glassblower (3), Tent of Avnel the Glassblower (2), Tent of Avnel the Glassblower (1) |
Gaethzen star | |
Gaethzen statuette of a figure | Breaking and Entering/Sanctum loot |
Gaethzen sunburst | |
Gaethzen wyvern encircled in flames | Sleeping Dragon Corn Maze 425/End loot |
Garland of gaethzen orbs | Estate Holder gifts |
Glittering gaethzen sunburst | Kalazashi's House of Majik |
Glittering gaethzen sunburst caught upon a dawnfire steel chain | Hollow Eve Festival 436/Auction |
Heavy gaethzen statue carved into the shape of a scarab | Su Helmas 444: Make Haste!/Incidental loot , Su Helmas 440: Entrapped/Incidental loot, Su Helmas 438: The Forbidden Temple/Incidental loot |
Large gaethzen coconut with a barkcloth husk | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade, Taisidon Mystery 435/A'baya Esplanade |
Large gaethzen rainbow streaked with glitter | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade, Taisidon Mystery 435/A'baya Esplanade |
Large gaethzen sphere suspended from a thick platinum chain | Beyond the Barrier: The Devastation of Lyras/End loot |
Luminous black gold crown enveloped in gaethzen flames | Premium token raffles |
Majestic gaethzen firebird | Fenwyrthie's Curio Shop |
Playful gaethzen shadowling | Konezu's Lenses |
Polished gaethzen crow | Beyond the Barrier: The Devastation of Lyras/Incidental Loot |
Polished gaethzen globe | Kalazashi's House of Majik |
Polished gaethzen lens | Konezu's Lenses |
Polished gaethzen moon | Kalazashi's House of Majik |
Polished gaethzen panther | Beyond the Barrier: The Devastation of Lyras/Incidental Loot |
Portable gaethzen lamp with steelsilk straps | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade, Taisidon Mystery 435/A'baya Esplanade |
Ruby-eyed gaethzen phoenix | Kalazashi's House of Majik |
Shielded gaethzen lantern secured to a braided leather strap | House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse |
Shimmering gaethzen coconut | MegaSafari 413 game prizes , Basket of colored darts |
Shimmering gaethzen dragon | MegaSafari 413 game prizes , Basket of colored darts |
Shimmering gaethzen fist | Drathrok's Duskruin 419/Incidental loot |
Shimmering gaethzen gnome | Konezu's Lenses |
Shimmering gaethzen lantern | Konezu's Lenses |
Shimmering gaethzen mermaid | MegaSafari 413 game prizes , Basket of colored darts |
Shimmering gaethzen orchid | Fenwyrthie's Curio Shop |
Shimmering gaethzen pirate | MegaSafari 413 game prizes , Basket of colored darts |
Shimmering gaethzen reading lamp with a triangular base | Breaking and Entering/Sanctum loot |
Shimmering gaethzen rose | Fenwyrthie's Curio Shop |
Shimmering gaethzen ship | MegaSafari 413 game prizes , Basket of colored darts |
Shimmering gaethzen turnip | Drathrok's Duskruin 421/Incidental loot |
Skittish gaethzen shadowling | Konezu's Lenses |
Small gaethzen sphere clasped within a severed hand | Curse of the Ghost Ship/Incidental Loot |
Small gaethzen sphere mounted on a tower-shaped base | Akigwe's Legacy: Secrets of the Tower/Incidental loot |
Spiteful gaethzen shadowling | Konezu's Lenses |
Tiny gaethzen firefly | Tent of Avnel the Glassblower (4) , Tent of Avnel the Glassblower (3), Tent of Avnel the Glassblower (2), Tent of Avnel the Glassblower (1), Kalazashi's House of Majik |
Triangular gaethzen sandwich with ruffled jade lettuce and striated sard ham | Hollow Eve Festival 417/Raffles |