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
110
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
110
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:Large flamewood harp depicting a flock of birds | Bardic Journey (3) , Bardic Journey (2) | |
Item:Large gleaming icon of polished steel shaped to resemble a thirteen-pointed star | Dunshade: Echo of Tears/End loot | |
Item:Leather bank book embossed with a flying bird | Book Nook | |
Item:Leather thigh bag heavily-beaded in cambrinth with the image of a nightingale in flight | Forever Faithful(2), Forever Faithful (2) , Forever Faithful (1) | |
Item:Leather vault book embossed with a flying bird | Book Nook | |
Item:Midnight black star-studded tabard emblazoned with Phelim's nightingale | Tending the Fold (2) , Tending the Fold (1) | |
Item:Midnight blue brocade corset accented with silver embroidery | Perfect Rose, Perfect Rose (2) | |
Item:Midnight blue gown streaked with silvery gossamer threads | Get The Look! , Black Orchid | |
Item:Midnight-blue silk robe embroidered with a nightingale singing against a background of glittering crystal stars | Trevellyn's of Leth Deri'el | |
Item:Midnight-blue suede carving case with a moonstone nightingale clasp | Altared Visions | |
Item:Miniature doll dressed in robes | 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:Mosaic cambrinth medallion depicting the image of Phelim's nightingale | Forever Faithful(2), Forever Faithful (2) , Forever Faithful (1) | |
Item:Multilayered dress robes tailored from Xibar-blue moonspun silk | Mercurial Mage | |
Item:Night black tabard sewn with a singing nightingale surrounded by silver stars | Festival Pavilion (2) , Festival Pavilion (1) | |
Item:Nightingale windchime | Su Helmas: Seeds of Entropy/Incidental loot , Su Helmas: Revealed!/Incidental loot, Su Helmas 444: Make Haste!/Incidental loot, Su Helmas 440: Entrapped/Incidental loot, Su Helmas 438: The Forbidden Temple/Incidental loot, Su Helmas 434: The Forbidden Temple/Incidental loot | true |
Item:Nightingale-shaped amulet | Gnarled Dwarf Peddler (1), Gnarled Dwarf peddler (1) | |
Item:Nightingales (1) | Heavenly Entrances (1) | |
Item:Pair of straight-legged pants with a column of embroidered birds up each side | Birds of a Feather (5) , Birds of a Feather (4), Birds of a Feather (3), Birds of a Feather (2), Birds of a Feather (1) | |
Item:Pilgrim's badge sculpted with the emblem of an Immortal | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Item:Polished silver collection plate engraved with a panther on the outside | Highway Robbery Redux | true |
Item:Porcelain plate painted with the figure of Damaris | Scholar's Museum , Gift Shop | false |
Item:Porcelain toy clothed in vestments | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Item:Pumpkin-colored knapsack with amethyst straps | Tastelessly Tacky (9) , Tastelessly Tacky (7), Tastelessly Tacky (5), Tastelessly Tacky (4), Tastelessly Tacky (3), Tastelessly Tacky (12), Tastelessly Tacky (11), Tastelessly Tacky (10) | |
Item:Roseate crystal amulet suspended from a narrow silver cord | Gadelica's Riches for the Reverent (1) | |
Item:Samite cloak silkscreened with a repeating pattern of flying nightingales | Turialo's Haven (8) | |
Item:Shesegri-chased silk enchanting pouch clasped with a twilight sapphire | Hollow Eve Festival 421/Raffles | |
Item:Sigilbook embossed with the constellation of the Nightingale on the cover | Web of Fate, Web of Fate (3) , Web of Fate (2), Web of Fate (1) | |
Item:Silver anklet inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | |
Item:Silver armband inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | |
Item:Silver bracelet inlaid with a cambrinth avatar | Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1) | |
Item:Silver cowbell with an e'erdream nightingale handle | Joys of Noise (6) | |
Item:Silvery lockpick with a singing nightingale's image etched along the side | Packrat's Paradise (6) , Packrat's Paradise (1), Behyra's | |
Item:Simple nightsilk cloak clasped with a shadow emerald | treasure map | true |
Item:Singing nightingale pinata | In The Hollow (2) | |
Item:Sleek writing quill tipped with a long nightingale feather | Sketchy By Design (9) | |
Weapon:Slender golden misericorde with a smoke ruby nightingale hilt | Sputkin's Splendors (4), Sputkin's Splendors (5) , Sputkin's Splendors (4) | |
Weapon:Slender silver misericorde with a midnight-blue crystal nightingale hilt | Sputkin's Wagon | |
Item:Smooth worry stone engraved with the symbol of an Immortal | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes | true |
Item:Songsilk nightingale with cosmic zircon eyes | Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot | |
Item:Splotched sketchbook depicting a starry night sky | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Aesthene's Close 449/End Loot | true |
Item:Stained glass Damaris window (1) | Wicked Windows (4) | |
Armor:Suit of azure full plate with gilded nightingales enameled upon its pauldrons | Visions of Holiness (3) | |
Item:Sweeping black silk cloak embroidered with a silver nightingale perched atop an olive branch | Sputkin's Wagon , Sputkin's Splendors (5), Sputkin's Splendors (4) | |
Item:Thigh pouch secured with a glass charm | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 436/Game prizes | |
Item:Tiny candy | 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:Tiny icon of metal | 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:Tiny nightingale charm | Pyff's Perch (2) , Pyff's Perch (1) | |
Item:Tiny taupe nightingale charm | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Sleeping Dragon Corn Maze 439/End loot, Sleeping Dragon Corn Maze 436/End loot, Sleeping Dragon Corn Maze 432/End loot, Sleeping Dragon Corn Maze 428/End loot, Sleeping Dragon Corn Maze 425/End loot | true |
Item:Toy bobblehead | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Shield:Triangular black tursa sipar inlaid with the emblem of Saint Detlef | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Sleeping Dragon Corn Maze 439/End loot, Sleeping Dragon Corn Maze 436/End loot, Sleeping Dragon Corn Maze 432/End loot, Sleeping Dragon Corn Maze 428/End loot | true |