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 | Rare item |
---|---|---|
Item:Crimson cambric cloth edged with gold stitching | Fit to be Tied (2) | true |
Item:Delicate pale pink cambric mantle with a cloud-shaped silver clasp | Shimmers of Silver (2) | true |
Item:Dramatic cloak fastened with a clasp | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Item:Flowing robes flecked with tiny droplets | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | true |
Item: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 | |
Item:Folding chair with a cushioned seat | Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item: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 | |
Template:HE2020Fabrics | ||
Item: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 | true |
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 | ||
Item:Hood (3) | Peddler's Wagon (obsolete) | |
Item: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 | ||
Item:Jade green dergatine cassock lined with pure white cambric | Emperor's New Robes (2) , Emperor's New Robes (1) | true |
Item:Jet-black cambric cloth | Rite of Cravat (2) | true |
Item:Knapsack | Zerek's General Store , Peddler's Wagon (obsolete), Net and Bait, Marachek's General Store, Dokker's Workshop, Bayanzi Gherkrish and Sons | |
Item: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 | true |
Item:Loose golden cambric kamis decorated with black silk embroidery | Farhana's Island Exquisites (2) , Farhana's Island Exquisites (1) | true |
Item:Multicolored flowered chintz corset lined with pale pink cambric | Tighten Up (2) , Tighten Up (1) | true |
Item:Pale cream cashmere robe lined with black cambric | Emperor's New Robes (2) , Emperor's New Robes (1) | true |
Item:Pearl white cambric cloth | Rite of Cravat (2) , Rite of Cravat (1) | |
Item:Plain white cambric shirt with gathered sleeves | Knotty Pirate | true |
Item:Plain white cambric shirt with long sleeves | Haute Dogs and Fat Cats | |
Item: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 | |
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:Pouch | Peddler's Wagon (obsolete) , Brigetta's Tanned Goods (obsolete), Bayanzi Gherkrish and Sons | |
Item: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 | |
Item:Sheaf of unfinished song scrolls tied with a faded blue cambric ribbon | Quelling the Riot/Incidental loot | |
Item:Small gem pouch with scalloped edges | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | |
Item:Smooth cambric shirt with short sleeves | Amylia's Attic (3) | true |
Item:Snow-white cambric handkerchief embroidered with a pair of interlocking hearts | Never Too Late Once More | true |
Item:Soft white cambric shirt with an upright collar | Kilt From Scratch | true |
Item: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 | |
Item:Thigh pouch secured with a glass charm | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 436/Game prizes | |
Item:Thin jade green cotton robe with wide sleeves | Emperor's New Robes (2) , Emperor's New Robes (1) | true |
Item:Threadbare white cambric handkerchief | Second Round (2) | true |
Item:Tunic (3) | Peddler's Wagon (obsolete) |