Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Night diamond]]OR[[Uses material::Night diamond]]
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 | 98 | 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='Night diamond')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=217746 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rarity is |
---|---|---|
Creamy jade rabbits with night diamond eyes | Hair Apparent (2) | |
Dark red bloodlace garter swagged in night diamonds | Galleria of Garters (2) | |
Deep ebon duchess satin wrap accented by a night diamond clasp | Silken Seams (2) | |
Diaphanous silk dance veil adorned with blossoms | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Dramatic cloak fastened with a clasp | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | incidental |
Draping leaf green rosecloth blouse with a drawstring neckline | Damsel In This Dress (5) , Damsel In This Dress (3) | |
Dusky purple paisley madun doublet threaded with night diamonds | Limited Treasures (1) | |
Elaborately dressed puppet with eyes | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Faceted merlot ruby perfume bottle fit with a night diamond stopper | Everlasting Beauty (3) | festival |
Faceted night diamond box adorned with a green flower-shaped label | Everlasting Beauty (2) | festival |
Feathery seaweed fronds dappled with swirls | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | |
Flowing robes flecked with tiny droplets | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | incidental |
Fuzzy dolphin slippers with large eyes | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Gleaming razor-sharp rapier with an intricately engraved hilt (2) | Dark Defenders (2) | |
Glittering night diamond snail housed in a spiraled silver-limned shell | Tildi's Blooms (4) , Tildi's Blooms (3) | |
Glittery parry stick with faceted ends | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Glitzy nielloed gold wristlet encrusted with night diamonds | Uwresari's Exotic Wonders (2) , Uwresari's Exotic Wonders (1), Hollow Eve Festival 406/Raffles | |
HE2020Gemstones | ||
Heavily embroidered sash with gemstone fractals | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | incidental |
Hollow Eve 439 gift | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Ichea, Hollow Eve Festival 439 | end loot |
Hollow Eve Festival 436/Game prizes | ||
Hollow Eve Festival 436/Game prizes/Material options | ||
Interlocking miniature tridents | Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Iridescent filaments strung with stars | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Azure crystal medallion embellished by night diamonds | ||
Item:Backless spun glitter dress dyed shimmering silver | ||
Item:Blonde oak bangles inlaid with night diamonds | ||
Item:Ceremonial prayer tome embedded with a trio of night diamonds | ||
Item:Deep ebon duchess satin wrap accented by a night diamond clasp | ||
Item:Glitzy nielloed gold wristlet encrusted with night diamonds | ||
Item:Lush viridian cravat pinned with a trilliant cut night diamond | ||
Item:Platinum necklace dangling three tiny rose-shaped night diamonds | ||
Item:Smooth tyrium engagement ring inlaid with a night diamond gear | ||
Item:Strapless gown of translucent Albarian lace over twilight thornweave | ||
Item:Violet-hued rosecloth gown with night diamonds accentuating a plunging neckline | ||
Jaunty fedora accented with a small shark | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Lacquered abacus strung with polished beads | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Lacquered band set with a tiny clownfish | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Latticed picnic basket tied with sea otters | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | incidental |
Lavish midnight black marquisette slippers tipped with night diamonds | Nigeyi's (4) , Nigeyi's (3), Nigeyi's (2) | |
Layered marblesilk skirt embellished with night diamonds | Natural Beauty (3) , Natural Beauty (2) | |
Loose blueberry-hued cire shirt trimmed in cream silk | Fashionable Panda (2) | |
Lush viridian cravat pinned with a trilliant cut night diamond | Knightly Attire (1) | |
Magnificent darkstone tiara arrayed with night diamond starbursts | Wedding Belles (2) , Wedding Belles (1) | |
Midnight black bloodlace carryall adorned with dangling night diamond toggles | Dark Dalliance (2) | festival |
Miniature fortune teller enveloped in layers of garishly bright treasureweave | Item:Spacious flat-top travel trunk plastered with numerous faded sideshow posters , Limited Treasures (1) | |
Miniature haralun Armorsmith Kauko figurine styled with outrageously blue hair | Siegery Shop (2) | |
Miniature polar bear with round eyes | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | |
Night diamond briolette pendant suspended from a delicate black gold chain | Hollow Eve Festival 414/Raffles | |
Night diamond halter-necked trouser dress of ebony and ivory spun glitter | Limited Treasures (1) |