Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Phelim||nightingale]]OR[[Uses material::Phelim||Nightingale]]
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 | 165 | 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='Phelim') OR (t2.o_hash='nightingale'))
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 (9632)
INSERT IGNORE INTO `t6` (id) VALUES (28149)
Query Metrics
Query-Size:6Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Item:Bronze armband inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | true |
Item:Brooch depicting a nightingale with crystal tipped wings | Women at Arms (4) , Women at Arms (3), Women at Arms (2), Women at Arms (1) | |
Item:Brushed silver flute etched with a band of golden nightingales | Nytingale's Instruments (9) | |
Item:Cambrinth ankle cuff inlaid with bloodstone nightingales to spell PHELIM | Forever Faithful (2) , Forever Faithful (1) | |
Item:Carmine madun pouch clasped with a purple gold nightingale | Sketchy By Design (7) | |
Item:Cerulean wool cloak embroidered with ivory nightingales and lined in silk | Ezlani's Collections (2) , Ezlani's Collections (1) | |
Item:Cherrywood ocarina charm adorned with a golden nightingale | Marelien's Memories (2) | |
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:Copper ritual drum | Gadelica's Riches for the Reverent (4) , Gadelica's Riches for the Reverent (3), Gadelica's Riches for the Reverent (2), Gadelica's Riches for the Reverent (1) | |
Item:Crystal bell with an onyx panther handle | Exaltation Tintinnabulum (1) | |
Item:Crystal-dusted cambrinth orb etched with the image of a nightingale fluttering over a sleeping dragon | Bunglefoot's Tent (2) , Bunglefoot's Tent (1) | true |
Weapon:Curved silvery scimitar with a nightsilk-wrapped hilt | Visions of Holiness (2) , Visions of Holiness (1) | |
Weapon:Curved-blade scimitar engraved with nightingales | Hollow Eve Festival 410/Raffles | |
Item:Dangly candy necklace with a tiny spun sugar | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes | true |
Item:Dark blue nightingale feather | Rusty Barnacle , River Dreamer, Night Sky's Hair, Marsh Skipper, Demosel's Lair (2) | |
Item:Dark blue robe streaked with grey wings and clasped with a silver nightingale | Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2) | |
Item:Dark piece of polished flint sculpted into the likeness of an Immortal | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | |
Item:Dark silken lockpick pouch clasped by a midnight blue crystal nightingale | Hollow Eve Festival 414/Raffles | |
Item:Dark silken lockpick satchel clasped by a midnight-blue crystal nightingale | Auction Tent - Ice Festival | true |
Item:Delicate silver nightingale amulet suspended from a heavy chain | Amulets by Liathe (3) , Amulets by Liathe (1) | |
Item:Dreamstone nightingale icon set within an alcove of starstone | Su Helmas: Seeds of Entropy/End loot , Su Helmas 438: The Forbidden Temple/End loot, Su Helmas 434: The Forbidden Temple/End loot | |
Weapon:Dusk-hued light crossbow with its limbs tipped by tiny animite nightingales | Visions of Holiness (3) | |
Item:Dusky blue nightweaver-silk handfasting cord studded with carved crystalline stars | Sputkin's Wagon , Sputkin's Splendors (5), Sputkin's Splendors (4), Sputkin's (3), Sputkin's (2) | |
Item:Dusky blue prayer tapestry appliqued with a silver silk nightingale | Sputkin's Splendors (5) , Sputkin's Splendors (4), Sputkin's (3) | |
Item:Dusky blue prayer tapestry appliqued with a silver silk nightingale (1) | Sputkin's Wagon | |
Item:Dusky nightsilk songbook satchel clasped with a platinum nightingale | Bardic Barge (2) , Bardic Barge (1) | |
Item:Dusky nightsilk songbook scattered with bright diamond stars | Bardic Barge (2) , Bardic Barge (1) | |
Item:Ebony violin bow (1) | Nytingale's Instruments (8) , Nytingale's Instruments (6), Nytingale's Instruments (5), Nytingale's Instruments (2) | |
Item:Elegantly carved necklace formed from interlocking crystal cubes | Magma Falls Mini-Festival Auction | true |
Item:Enormous lollipop covered in iridescent sugar crystals | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes | true |
Item:Enveloping nightsilk astrologer's greatcloak picked with silveress constellations | ||
Item:Ethereal sparkling white starlight velvet slippers embellished with alavern beads | Nigeyi's (4) , Nigeyi's (3), Nigeyi's (2) | |
Item:Exquisitely carved nightfire opal nightingale | Hollow Eve Festival 428/Raffles | |
Item:Fibrous icon of strands | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Fiddle bow | Drones and Drums | |
Item:Folded icon of leather | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Gauzy white cotton shirt intricately stitched with nutmeg-brown nightingales | Item:Sooty black cotton shirt adorned with shrike-carved buttons , Seiryn's Transformations (4), Seiryn's Transformations (3), Seiryn's Transformations (2), Seiryn's Transformations (1), Item:Sooty black cotton shirt adorned with shrike-carved buttons | |
Item:Ghostly blue moonstone nightingales | Mystical Machinations (2) , Mystical Machinations (1) | |
Weapon:Glaes throwing nightingale | Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot, Droughtman's Challenge 437/Incidental loot, Droughtman's Challenge 433/Incidental loot, Droughtman's Challenge 430/Incidental loot | true |
Item:Gold earcuff with looped chains dangling nightingales | Item:Mother-of-pearl egg covered with a fine silver filigree , Item:Mother-of-pearl egg covered with a fine silver filigree | |
Item:Gold medallion symbolizing dedication to Damaris | Tending the Fold (2) , Tending the Fold (1), Festival Pavilion (2), Festival Pavilion (1) | |
Item:Gold-banded boxwood recorder | Nytingale's Instruments (8) , Nytingale's Instruments (6), Nytingale's Instruments (5), Nytingale's Instruments (2) | |
Item:Golden choker hung with a silk webbed ring surrounded by nightingale feathers | Festival Pavilion (2) , Festival Pavilion (1) | |
Item:Golden nightingale fetish | Path of the Panther | |
Item:Graceful burlwood violin with elongated flame-shaped soundholes | Nytingale's Instruments (8) , Nytingale's Instruments (5) | |
Item:Graceful nightingale amulet on a rope of sandalwood worry beads | Amulets by Liathe (5) | |
Template:HE2020Gods | ||
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 |
Talk:Hollow Eve Festival 436/Game prizes | ||
Hollow Eve Festival 436/Game prizes/Material options |