Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::Camlet]]OR[[Uses material::Camlet]]
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
0
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 84 | 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='Camlet')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=479452 - 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 |
---|---|---|
Artfully curved bubble umbrella covered in claret camlet | Tildi's Blooms (4) , Tildi's Blooms (3) | |
Blackened eyepatch of reinforced camlet sporting a Drogor's Wrath sapphire emblem | Natural Beauty (2) | |
Bright canary-yellow camlet umbrella with a carved zingana handle | Taisidon Safari 420 Game Prizes , Deluxe Safari 417 Game Prizes | |
Bright pink camlet frock coat with wide green silk lapels | Pink Pirate's Plunder and Pillage Palace | |
Brilliant blue camlet crafting satchel clasped by crossed knitting needles | Which Craft (1) | |
Brilliant red camlet parasol with a carved smokewood handle | Taisidon Safari 420 Game Prizes , Deluxe Safari 417 Game Prizes | |
Brilliant vermillion camlet frock coat with tomiek buttons | Salvage Finds of the Reshal Sea | |
Brilliant yellow camlet balandrana with copper brooches | Knight at the Club (1) | |
Brilliantly hued skirt of alternating camlet and watersilk panels | Natural Beauty (3) , Natural Beauty (2) | |
Butterscotch-hued camlet casaque with silver brooches | Knight at the Club (2) | festival |
Camlet and spun glitter hand-puppet resembling a jellyfish | Cleric wrapped tightly in dark robes | |
Camlet breeches with damite buckles at the knees | Sleeping Dragon Corn Maze 447/Incidental loot , Sleeping Dragon Corn Maze 443/Incidental loot, Sleeping Dragon Corn Maze 439/Incidental loot, Sleeping Dragon Corn Maze 436/Incidental loot, Sleeping Dragon Corn Maze 432/Incidental loot, Sleeping Dragon Corn Maze 428/Incidental loot, Item:Sailcloth backpack with leather straps | end loot |
Camlet cloak lined in grey satin | House of the Revenant Fang 429/Incidental loot | |
Camlet cloak trimmed with squirrel fur | House of the Revenant Fang 429/Incidental loot | |
Camlet inventor's backpack | Thryntyrlz BagMaker's Yurt (5) | |
Camlet rantija with a prominent hood | Comfortable Rakash (3) , Comfortable Rakash (2), Comfortable Rakash (1) | |
Camlet tricorn hat with a knot of white ribbons | Salvage Finds of the Reshal Sea | |
Camlet umbrella sporting a fringe of coral seahorses | treasure map | treasure map |
Crimson camlet tshoga with a flying golden dragon embroidered on the back | Farhana's Island Exquisites (2) | festival |
Dainty pale blue umbrella with camlet ruffles and swaying silver bells | Weather Beaters (3) | |
Deep blue camlet fedora with a pale blue watersilk hatband | All the King's Men (3) , All the King's Men (2) | festival |
Deeply hooded sky blue camlet rantija with a windstorm gossamer overlay | Comfortable Rakash (3) , Comfortable Rakash (2), Comfortable Rakash (1) | |
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 |
Explorer's camlet toolbag clasped by a dwalgim-headed mikkhalbamar pickaxe | Limited Treasures (5) | |
Fantastical miniature keep hued a soft rose | Limited Treasures (1) | |
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 | |
Forest green camlet fan embroidered with the words "NOT TODAY" in golden thread | Smaller Side of Life (3) | |
Forest-green camlet quiver with dangling winter emerald charms | Su Helmas 444: Make Haste!/Incidental loot , Su Helmas 440: Entrapped/Incidental loot, Su Helmas 438: The Forbidden Temple/Incidental loot | incidental |
Formal camlet trousers tinted the deep hue of night-tinged clouds | Natural Beauty (2) | |
Glacial teal camlet kimono sashed with absinthe emerald-strewn velvet | Hollow Eve Festival 421/Raffles | |
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 |
Heavy camlet arm pouch with a trio of arrowheads affixed | Aesthene's Close 449/End Loot | end loot |
Hollow Eve Festival 436/Game prizes | ||
Hollow Eve Festival 436/Game prizes/Material options | ||
Intense persimmon camlet umbrella with a carved dragonwood handle | Taisidon Safari 420 Game Prizes , Deluxe Safari 417 Game Prizes | |
Intricate josta of myriad silks fettered by an orichalcum disc | Comfortable Rakash (3) , Comfortable Rakash (2), Comfortable Rakash (1) | |
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 | |
Jade green camlet mra'sin fastened with a braided russet leather belt | Rizadi's Outfitters (4) , Rizadi's Outfitters (3) | |
Jade green camlet robe trimmed with miniver | Emperor's New Robes (2) | festival |
Knee-length pleated sepia camlet skirt with topstitching along the hem | ||
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 |
Martial-styled overcoat of atrous camlet lined in wool | Male Persuasion (3) | |
Off-the-shoulder teal camlet gown with a full skirt | Damsel In This Dress (3) | |
Ornate camlet gown with a pooling train | Damsel In This Dress (3) | |
Ornate rose-colored camlet gown with a pooling train | ||
Oversized minstrel's satchel crafted from treasureweave | Limited Treasures (4) |