Battle Elixir
Name Gems ilvl DPS
Crafted Elixir of the Cobra (0/0)
Alchemy
85
222.5
Cataclysm 
Crafted Mad Hozen Elixir (0/0)
Alchemy
90
212.5
Crafted Elixir of the Master (0/0)
Alchemy
85
205.8
Cataclysm 
Crafted Monk's Elixir (0/0)
Alchemy
90
187.0
Crafted Elixir of Mighty Speed (0/0)
Alchemy
85
169.3
Cataclysm 
Crafted Elixir of the Rapids (0/0)
Alchemy
90
152.2
Flask
Name Gems ilvl DPS
Crafted Flask of Titanic Strength (0/0)
Alchemy
85
484.3
Cataclysm 
Crafted Flask of Winter's Bite (0/0)
Alchemy
90
464.0
Food
Name Gems ilvl DPS
Crafted Beer-Basted Crocolisk (0/0)
Cooking
85
146.5
Cataclysm 
Crafted Hearty Seafood Soup (0/0)
Cooking
81
97.7
Cataclysm 
Crafted Baked Rockfish (0/0)
Cooking
85
90.0
Cataclysm 
Crafted Lavascale Minestrone (0/0)
Cooking
85
79.2
Cataclysm 
Crafted Basilisk Liverdog (0/0)
Cooking
85
64.4
Cataclysm 
Crafted Lightly Fried Lurker (0/0)
Cooking
81
60.0
Cataclysm 
Crafted Green Curry Fish (0/0)
Cooking
90
57.5
Crafted Salted Eye (0/0)
Cooking
81
52.8
Cataclysm 
Crafted Pearl Milk Tea (0/0)
Cooking
90
50.6
Crafted Broiled Mountain Trout (0/0)
Cooking
81
43.0
Cataclysm 
Crafted Tangy Yogurt (0/0)
Cooking
90
41.2
Crafted Toasted Fish Jerky (0/0)
Cooking
86
27.5
Crafted Roasted Barley Tea (0/0)
Cooking
86
24.2
Crafted Yak Cheese Curds (0/0)
Cooking
86
19.7
SELECT * FROM items, itemsForClasses WHERE (slotID = '27' OR slotID = '36' OR slotID = '37' OR slotID = '38') AND (items.id = itemsForClasses.itemID AND (itemsForClasses.classID = '1' )) AND (zoneID = '648' OR zoneID = '662' OR zoneID = '668' OR zoneID = '675' OR zoneID = '681' OR zoneID = '687' OR zoneID = '693' OR zoneID = '698' OR zoneID = '710' OR zoneID = '649' OR zoneID = '663' OR zoneID = '669' OR zoneID = '676' OR zoneID = '682' OR zoneID = '688' OR zoneID = '694' OR zoneID = '699' OR zoneID = '711' OR zoneID = '732' OR zoneID = '733' OR zoneID = '735' OR zoneID = '734' OR zoneID = '746' OR zoneID = '747' OR zoneID = '748' OR zoneID = '329' OR zoneID = '355' OR zoneID = '372' OR zoneID = '361' OR zoneID = '372' OR zoneID = '367' OR zoneID = '378' OR zoneID = '387' OR zoneID = '330' OR zoneID = '356' OR zoneID = '362' OR zoneID = '373' OR zoneID = '368' OR zoneID = '379' OR zoneID = '388' OR zoneID = '393' OR zoneID = '394' OR zoneID = '423' OR zoneID = '424' OR zoneID = '425' OR zoneID = '455' OR zoneID = '456' OR zoneID = '457' OR zoneID = '336' OR zoneID = '337' OR zoneID = '338' OR zoneID = '339' OR zoneID = '340' OR zoneID = '341' OR zoneID = '441' OR zoneID = '442' OR zoneID = '470' OR zoneID = '471' OR zoneID = '473' OR zoneID = '487' OR zoneID = '488' OR zoneID = '489' OR zoneID = '490' OR zoneID = '491' OR zoneID = '493' OR zoneID = '494' OR zoneID = '648' OR zoneID = '486' OR zoneID = '492' OR zoneID = '495' OR zoneID = '496' OR zoneID = '497' OR zoneID = '498' OR zoneID = '499' OR zoneID = '500' OR zoneID = '501' OR zoneID = '542' OR zoneID = '543' OR zoneID = '544' OR zoneID = '545' OR zoneID = '546' OR zoneID = '547' OR zoneID = '548' OR zoneID = '549' OR zoneID = '550' OR zoneID = '551' OR zoneID = '552' OR zoneID = '553' OR zoneID = '554' OR zoneID = '555' OR zoneID = '556' OR zoneID = '591' OR zoneID = '589' OR zoneID = '590' OR zoneID = '627' OR zoneID = '628' OR zoneID = '629' OR zoneID = '630' OR zoneID = '10' OR zoneID = '17' OR zoneID = '39' OR zoneID = '16' OR zoneID = '49' OR zoneID = '70' OR zoneID = '228' OR zoneID = '252' OR zoneID = '322' OR zoneID = '18' OR zoneID = '71' OR zoneID = '72' OR zoneID = '73' OR zoneID = '74' OR zoneID = '186' OR zoneID = '188' OR zoneID = '208' OR zoneID = '45' OR zoneID = '8' OR zoneID = '10' OR zoneID = '580' OR zoneID = '617' OR zoneID = '623' OR zoneID = '647' OR zoneID = '744' OR zoneID = '667' OR zoneID = '717' OR zoneID = '718' OR zoneID = '0' OR zoneID = '0' OR zoneID = '0' OR zoneID = '0' OR typeID = '14') AND (faction = '0' OR faction = '1' OR faction = '2') AND reqlevel <= 100 AND (expansion = 5 or expansion = 4 OR expansion = 3) ORDER BY slotID