Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::be'ort||coyote]]OR[[Uses material::Be'ort||Coyote]]
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 | 158 | 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='be\'ort') OR (t2.o_hash='coyote'))
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 INNER JOIN `t6` AS t6 ON t4.o_id=t6.id WHERE t4.p_id=2021246 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1 - Temporary table t6
INSERT IGNORE INTO `t6` (id) VALUES (9655)
INSERT IGNORE INTO `t6` (id) VALUES (92610)
Query Metrics
Query-Size:6Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
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 |
Weapon:Bronze carving knife acid-etched with coyotes | Cleric Shop (Muspar'i) | |
Item:Bronze coyote's head clasp with a broken hinge | Cardamom Knickerknee's Fine Used Goods (3) , Cardamom Knickerknee's Fine Used Goods (2), Cardamom Knickerknee's Fine Used Goods (1) | |
Item:Brushed silver torque inlaid with an onyx coyote silhouetted against a cambrinth moon | ||
Weapon:Brushed-steel ceremonial dagger (1) | ||
Weapon:Brushed-steel ceremonial dagger (2) | Dark Defenders (2) | |
Item:Cambrinth ankle cuff inlaid with tourmaline coyotes to spell BE'ORT | Forever Faithful (2) , Forever Faithful (1) | |
Item:Cambrinth coyote statue with diamond-dust fur | Cleric Shop (Muspar'i) | |
Item:Clerical skullcap appliqued with mad fae faces | Huldah Shrine prizes 410 , Huldah Shrine prizes 406 | |
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:Coal Be'ort tear rose | Hunka's Burning Love (3) | |
Item:Coyote (1) | Heavenly Entrances (1) | |
Item:Coyote stamp | Stamped! | |
Item:Coyote token | Relief in the Dark (3) , Relief in the Dark (2), Relief in the Dark (1) | |
Item:Coyote-shaped berry tart with caramel drizzle | Be'ort shrine | |
Item:Crystal Be'ort scission blade | Shard Acolyte , Musty Tent, Muspar'i Acolyte, Inside a Sagging Tent, Acolyte | |
Item:Dark floor-length robe embroidered with the symbols of the dark aspects | Hide and Seek | |
Item:Dark grey robe embroidered with a pair of coyotes howling against a pattern of silvery raindrops | Trevellyn's of Leth Deri'el | |
Item:Deep red silk prayer rug exquisitely embroidered with a howling coyote | Blood and Gourd (5) , Blood and Gourd (4), Blood and Gourd (3) | |
Weapon:Double coyote-headed maul with a solid chain shaft (1) | ||
Weapon:Double coyote-headed maul with a solid chain shaft (2) | Dark Defenders (2) | |
Item:Drum pouch embellished with a cambrinth medallion | Dark Symphony (2) | |
Item:Elegantly carved necklace formed from interlocking crystal cubes | Magma Falls Mini-Festival Auction | true |
Item:Etched iron medallion | ||
Weapon:Flame maple latchbow with a coyote-shaped stock | ||
Item:Fur-lined knee boots clasped with ivory hooks | Cultured Attire (5) | |
Weapon:Gleaming short sword engraved with a howling coyote (1) | Item:White lacquered sheath with elegant silken ties , Peaceful Intentions (1), Item:White lacquered sheath with elegant silken ties | |
Weapon:Gleaming short sword engraved with a howling coyote (2) | Item:White lacquered sheath with elegant silken ties , Peaceful Intentions (2), Item:White lacquered sheath with elegant silken ties | |
Item:Gleaming silver cloak clasp molded into a howling coyote | Be'ort shrine | |
Item:Glossy black prayer parchment | Scriptorium | |
Item:Gold medallion symbolizing dedication to Glythtide | Tending the Fold (2) , Tending the Fold (1), Festival Pavilion (2), Festival Pavilion (1) | |
Item:Grizzled grey coyote charm with its head thrown back in a howl | Origami Envelope | true |
Weapon:Heavy iron mace with a polished yew handle | Visions of Holiness (2) , Visions of Holiness (1) | |
Item:Heavy kertig and cambrinth armband in the shape of a coyote skull | Limited Treasures (1) , Item:Indigo dragonar thigh bag with a kertig clasp carved into a snarling coyote | |
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:Homemade shrine crowded with tiny religious figurines | Eclectic Eccentric (3) , Eclectic Eccentric (2) | |
Item:Howling coyote pinata | In The Hollow (2) | |
Item:Indigo dragonar thigh bag with a kertig clasp carved into a snarling coyote | Limited Treasures (1) | |
Item:Intricately embroidered robe of flowing nightsilk | Divinely Dressed | |
Item:Aged cherrywood humidor trimmed with a thin golden band | ||
Item:Animal skeleton | ||
Item:Anloral coyote pin | ||
Item:Be'ort effigy | ||
Item:Be'ort heart-blackener coffee | ||
Item:Beige scroll | ||
Item:Black latten teaspoon with an engraved stem | ||
Item:Black silk cloth embroidered with a battle scene | ||
Item:Brass-studded hickory carving case with a topaz coyote clasp | ||
Item:Bronze armband inlaid with a cambrinth avatar |