Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Cambric]]OR[[Uses material::Cambric]]
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 | 58 | 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='Cambric')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=120281 - 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 |
---|---|---|
Crimson cambric cloth edged with gold stitching | Fit to be Tied (2) | festival |
Delicate pale pink cambric mantle with a cloud-shaped silver clasp | Shimmers of Silver (2) | festival |
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 |
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 |
Fluttery skirt with a glittery gauze overlay | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Folding chair with a cushioned seat | Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Graceful fan painted with swirling 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 | |
HE2020Fabrics | ||
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 | ||
Hood (3) | Peddler's Wagon (obsolete) | |
Intricately ruched garter | 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:Bag | ||
Item:Bundle | ||
Item:Cloak (1) | ||
Item:Cream-colored cambric handkerchief | ||
Item:Hood | ||
Item:Knapsack | ||
Item:Pouch | ||
Item:Robes | ||
Item:Trousers | ||
Item:Tunic | ||
Jade green dergatine cassock lined with pure white cambric | Emperor's New Robes (2) , Emperor's New Robes (1) | festival |
Jet-black cambric cloth | Rite of Cravat (2) | festival |
Knapsack | Zerek's General Store , Peddler's Wagon (obsolete), Net and Bait, Marachek's General Store, Dokker's Workshop, Bayanzi Gherkrish and Sons | |
Length of fabric (2) | 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 |
Loose golden cambric kamis decorated with black silk embroidery | Farhana's Island Exquisites (2) , Farhana's Island Exquisites (1) | festival |
Multicolored flowered chintz corset lined with pale pink cambric | Tighten Up (2) , Tighten Up (1) | festival |
Pale cream cashmere robe lined with black cambric | Emperor's New Robes (2) , Emperor's New Robes (1) | festival |
Pearl white cambric cloth | Rite of Cravat (2) , Rite of Cravat (1) | |
Plain white cambric shirt with gathered sleeves | Knotty Pirate | festival |
Plain white cambric shirt with long sleeves | Haute Dogs and Fat Cats | |
Plump pillow embroidered with posies | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
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 | festival |
Pouch | Peddler's Wagon (obsolete) , Brigetta's Tanned Goods (obsolete), Bayanzi Gherkrish and Sons | |
Puffy haversack in the shape of a large starfish | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Sheaf of unfinished song scrolls tied with a faded blue cambric ribbon | Quelling the Riot/Incidental loot | |
Small gem pouch with scalloped edges | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | |
Smooth cambric shirt with short sleeves | Amylia's Attic (3) | festival |
Snow-white cambric handkerchief embroidered with a pair of interlocking hearts | Never Too Late Once More | festival |
Soft white cambric shirt with an upright collar | Kilt From Scratch | festival |
Supple rope of plaited fabric | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Thigh pouch secured with a glass charm | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 436/Game prizes | |
Thin jade green cotton robe with wide sleeves | Emperor's New Robes (2) , Emperor's New Robes (1) | festival |
Threadbare white cambric handkerchief | Second Round (2) | festival |
Tunic (3) | Peddler's Wagon (obsolete) |