Blue Gem
Name Gems ilvl DPS
Crafted Rigid Deepholm Iolite (0/0)
Jewelcrafting
85
50.0
Cataclysm 
Crafted Rigid River's Heart (0/0)
Jewelcrafting
90
50.0
Crafted Perfect Rigid Lapis Lazuli (0/0)
Jewelcrafting
88
50.0
Crafted Rigid Ocean Sapphire (0/0)
Jewelcrafting
85
40.0
Cataclysm 
Crafted Rigid Lapis Lazuli (0/0)
Jewelcrafting
87
40.0
Crafted Rigid Zephyrite (0/0)
Jewelcrafting
81
30.0
Cataclysm 
Red Gem
Name Gems ilvl DPS
Crafted Bold Queen's Garnet (0/0)
Jewelcrafting
85
40.7
Cataclysm 
Crafted Perfect Bold Pandarian Garnet (0/0)
Jewelcrafting
88
40.7
Crafted Bold Primordial Ruby (0/0)
Jewelcrafting
90
40.7
Crafted Precise Queen's Garnet (0/0)
Jewelcrafting
85
35.8
Cataclysm 
Crafted Perfect Precise Pandarian Garnet (0/0)
Jewelcrafting
88
35.8
Crafted Precise Primordial Ruby (0/0)
Jewelcrafting
90
35.8
Crafted Bold Inferno Ruby (0/0)
Jewelcrafting
85
32.6
Cataclysm 
Crafted Bold Pandarian Garnet (0/0)
Jewelcrafting
87
32.6
Crafted Precise Inferno Ruby (0/0)
Jewelcrafting
85
28.6
Cataclysm 
Crafted Precise Pandarian Garnet (0/0)
Jewelcrafting
87
28.6
Crafted Bold Carnelian (0/0)
Jewelcrafting
81
24.4
Cataclysm 
Crafted Precise Carnelian (0/0)
Jewelcrafting
81
21.5
Cataclysm 
Yellow Gem
Name Gems ilvl DPS
Crafted Smooth Lightstone (0/0)
Jewelcrafting
85
50.0
Cataclysm 
Crafted Perfect Smooth Sunstone (0/0)
Jewelcrafting
88
50.0
Crafted Perfect Fractured Sunstone (0/0)
Jewelcrafting
88
44.0
Crafted Fractured Sun's Radiance (0/0)
Jewelcrafting
90
44.0
Crafted Fractured Lightstone (0/0)
Jewelcrafting
85
44.0
Cataclysm 
Crafted Smooth Amberjewel (0/0)
Jewelcrafting
85
40.0
Cataclysm 
Crafted Smooth Sunstone (0/0)
Jewelcrafting
87
40.0
Crafted Perfect Quick Sunstone (0/0)
Jewelcrafting
88
35.8
Crafted Quick Sun's Radiance (0/0)
Jewelcrafting
90
35.8
Crafted Quick Lightstone (0/0)
Jewelcrafting
85
35.8
Cataclysm 
Crafted Fractured Sunstone (0/0)
Jewelcrafting
87
35.2
Crafted Fractured Amberjewel (0/0)
Jewelcrafting
85
35.2
Cataclysm 
Crafted Smooth Alicite (0/0)
Jewelcrafting
81
30.0
Cataclysm 
Crafted Quick Amberjewel (0/0)
Jewelcrafting
85
28.6
Cataclysm 
Crafted Quick Sunstone (0/0)
Jewelcrafting
87
28.6
Crafted Fractured Alicite (0/0)
Jewelcrafting
81
26.4
Cataclysm 
Crafted Quick Alicite (0/0)
Jewelcrafting
81
21.5
Cataclysm 
Orange Gem
Name Gems ilvl DPS
Crafted Inscribed Lava Coral (0/0)
Jewelcrafting
85
45.4
Cataclysm 
Crafted Perfect Inscribed Tiger Opal (0/0)
Jewelcrafting
88
45.4
Crafted Crafty Vermilion Onyx (0/0)
Jewelcrafting
90
42.9
Crafted Crafty Lava Coral (0/0)
Jewelcrafting
85
42.9
Cataclysm 
Crafted Skillful Lava Coral (0/0)
Jewelcrafting
85
42.4
Cataclysm 
Crafted Skillful Vermilion Onyx (0/0)
Jewelcrafting
90
42.4
Crafted Perfect Skillful Tiger Opal (0/0)
Jewelcrafting
88
42.4
Crafted Keen Vermilion Onyx (0/0)
Jewelcrafting
90
39.9
Crafted Perfect Keen Tiger Opal (0/0)
Jewelcrafting
88
39.9
Crafted Keen Lava Coral (0/0)
Jewelcrafting
85
39.9
Cataclysm 
Crafted Perfect Fierce Tiger Opal (0/0)
Jewelcrafting
88
38.3
Crafted Fierce Lava Coral (0/0)
Jewelcrafting
85
38.3
Cataclysm 
Crafted Fierce Vermilion Onyx (0/0)
Jewelcrafting
90
38.3
Crafted Inscribed Tiger Opal (0/0)
Jewelcrafting
87
36.3
Crafted Inscribed Ember Topaz (0/0)
Jewelcrafting
85
36.3
Cataclysm 
Crafted Wicked Vermilion Onyx (0/0)
Jewelcrafting
90
35.8
Crafted Perfect Wicked Tiger Opal (0/0)
Jewelcrafting
88
35.8
Crafted Crafty Tiger Opal (0/0)
Jewelcrafting
87
34.3
Crafted Skillful Ember Topaz (0/0)
Jewelcrafting
85
33.9
Cataclysm 
Crafted Skillful Tiger Opal (0/0)
Jewelcrafting
87
33.9
Crafted Keen Tiger Opal (0/0)
Jewelcrafting
87
31.9
Crafted Keen Ember Topaz (0/0)
Jewelcrafting
85
31.9
Cataclysm 
Crafted Fierce Ember Topaz (0/0)
Jewelcrafting
85
30.6
Cataclysm 
Crafted Fierce Tiger Opal (0/0)
Jewelcrafting
87
30.6
Crafted Wicked Tiger Opal (0/0)
Jewelcrafting
87
28.6
Crafted Inscribed Hessonite (0/0)
Jewelcrafting
81
27.2
Cataclysm 
Crafted Skillful Hessonite (0/0)
Jewelcrafting
81
25.4
Cataclysm 
Crafted Perfect Potent Tiger Opal (0/0)
Jewelcrafting
88
25.0
Crafted Deadly Vermilion Onyx (0/0)
Jewelcrafting
90
25.0
Crafted Deadly Lava Coral (0/0)
Jewelcrafting
85
25.0
Cataclysm 
Crafted Perfect Crafty Tiger Opal (0/0)
Jewelcrafting
88
25.0
Crafted Perfect Deadly Tiger Opal (0/0)
Jewelcrafting
88
25.0
Crafted Potent Vermilion Onyx (0/0)
Jewelcrafting
90
25.0
Crafted Keen Hessonite (0/0)
Jewelcrafting
81
23.9
Cataclysm 
Crafted Adept Lava Coral (0/0)
Jewelcrafting
85
22.0
Cataclysm 
Green Gem
Name Gems ilvl DPS
Crafted Piercing Elven Peridot (0/0)
Jewelcrafting
85
50.0
Cataclysm 
Crafted Perfect Piercing Alexandrite (0/0)
Jewelcrafting
88
50.0
Crafted Perfect Sensei's Alexandrite (0/0)
Jewelcrafting
88
47.0
Crafted Sensei's Wild Jade (0/0)
Jewelcrafting
90
47.0
Crafted Sensei's Elven Peridot (0/0)
Jewelcrafting
85
47.0
Cataclysm 
Crafted Perfect Lightning Alexandrite (0/0)
Jewelcrafting
88
42.9
Crafted Lightning Wild Jade (0/0)
Jewelcrafting
90
42.9
Crafted Lightning Elven Peridot (0/0)
Jewelcrafting
85
42.9
Cataclysm 
Crafted Piercing Alexandrite (0/0)
Jewelcrafting
87
40.0
Crafted Piercing Dream Emerald (0/0)
Jewelcrafting
85
40.0
Cataclysm 
Crafted Sensei's Alexandrite (0/0)
Jewelcrafting
87
37.6
Crafted Sensei's Dream Emerald (0/0)
Jewelcrafting
85
37.6
Cataclysm 
Crafted Lightning Dream Emerald (0/0)
Jewelcrafting
85
34.3
Cataclysm 
Crafted Lightning Alexandrite (0/0)
Jewelcrafting
87
34.3
Crafted Piercing Jasper (0/0)
Jewelcrafting
81
30.0
Cataclysm 
Crafted Sensei's Jasper (0/0)
Jewelcrafting
81
28.2
Cataclysm 
Crafted Lightning Jasper (0/0)
Jewelcrafting
81
25.7
Cataclysm 
Crafted Perfect Radiant Alexandrite (0/0)
Jewelcrafting
88
25.0
Crafted Perfect Nimble Alexandrite (0/0)
Jewelcrafting
88
25.0
Crafted Perfect Balanced Alexandrite (0/0)
Jewelcrafting
88
25.0
Crafted Radiant Wild Jade (0/0)
Jewelcrafting
90
25.0
Crafted Misty Wild Jade (0/0)
Jewelcrafting
90
25.0
Crafted Nimble Wild Jade (0/0)
Jewelcrafting
90
25.0
Crafted Perfect Jagged Alexandrite (0/0)
Jewelcrafting
88
25.0
Crafted Jagged Elven Peridot (0/0)
Jewelcrafting
85
25.0
Cataclysm 
Crafted Perfect Misty Alexandrite (0/0)
Jewelcrafting
88
25.0
Crafted Piercing Wild Jade (0/0)
Jewelcrafting
90
25.0
Crafted Balanced Elven Peridot (0/0)
Jewelcrafting
85
25.0
Cataclysm 
Crafted Nimble Elven Peridot (0/0)
Jewelcrafting
85
25.0
Cataclysm 
Crafted Balanced Wild Jade (0/0)
Jewelcrafting
90
25.0
Crafted Zen Wild Jade (0/0)
Jewelcrafting
90
22.0
Crafted Perfect Zen Alexandrite (0/0)
Jewelcrafting
88
22.0
Crafted Effulgent Wild Jade (0/0)
Jewelcrafting
90
22.0
Crafted Puissant Elven Peridot (0/0)
Jewelcrafting
85
22.0
Cataclysm 
Crafted Perfect Effulgent Alexandrite (0/0)
Jewelcrafting
88
22.0
Purple Gem
Name Gems ilvl DPS
Crafted Etched Shadow Spinel (0/0)
Jewelcrafting
85
45.4
Cataclysm 
Crafted Etched Imperial Amethyst (0/0)
Jewelcrafting
90
45.4
Crafted Perfect Etched Roguestone (0/0)
Jewelcrafting
88
45.4
Crafted Perfect Accurate Roguestone (0/0)
Jewelcrafting
88
42.9
Crafted Accurate Shadow Spinel (0/0)
Jewelcrafting
85
42.9
Cataclysm 
Crafted Accurate Imperial Amethyst (0/0)
Jewelcrafting
90
42.9
Crafted Etched Demonseye (0/0)
Jewelcrafting
85
36.3
Cataclysm 
Crafted Etched Roguestone (0/0)
Jewelcrafting
87
36.3
Crafted Accurate Demonseye (0/0)
Jewelcrafting
85
34.3
Cataclysm 
Crafted Accurate Roguestone (0/0)
Jewelcrafting
87
34.3
Crafted Etched Nightstone (0/0)
Jewelcrafting
81
27.2
Cataclysm 
Crafted Accurate Nightstone (0/0)
Jewelcrafting
81
25.7
Cataclysm 
Crafted Perfect Retaliating Roguestone (0/0)
Jewelcrafting
88
25.0
Crafted Retaliating Shadow Spinel (0/0)
Jewelcrafting
85
25.0
Cataclysm 
Crafted Perfect Glinting Roguestone (0/0)
Jewelcrafting
88
25.0
Crafted Veiled Imperial Amethyst (0/0)
Jewelcrafting
90
25.0
Crafted Glinting Shadow Spinel (0/0)
Jewelcrafting
85
25.0
Cataclysm 
Crafted Retaliating Imperial Amethyst (0/0)
Jewelcrafting
90
25.0
Crafted Glinting Imperial Amethyst (0/0)
Jewelcrafting
90
25.0
Crafted Perfect Veiled Roguestone (0/0)
Jewelcrafting
88
25.0
Crafted Perfect Tense Roguestone (0/0)
Jewelcrafting
88
20.4
Crafted Sovereign Imperial Amethyst (0/0)
Jewelcrafting
90
20.4
Crafted Tense Imperial Amethyst (0/0)
Jewelcrafting
90
20.4
Crafted Perfect Sovereign Roguestone (0/0)
Jewelcrafting
88
20.4
Crafted Sovereign Shadow Spinel (0/0)
Jewelcrafting
85
20.4
Cataclysm 
Crafted Veiled Roguestone (0/0)
Jewelcrafting
87
20.0
Crafted Retaliating Roguestone (0/0)
Jewelcrafting
87
20.0
Crafted Glinting Roguestone (0/0)
Jewelcrafting
87
20.0
Crafted Glinting Demonseye (0/0)
Jewelcrafting
85
20.0
Cataclysm 
Crafted Retaliating Demonseye (0/0)
Jewelcrafting
85
20.0
Cataclysm 
Crafted Guardian's Shadow Spinel (0/0)
Jewelcrafting
85
17.9
Cataclysm 
Crafted Perfect Guardian's Roguestone (0/0)
Jewelcrafting
88
17.9
Crafted Guardian's Imperial Amethyst (0/0)
Jewelcrafting
90
17.9
Crafted Sovereign Roguestone (0/0)
Jewelcrafting
87
16.3
Crafted Sovereign Demonseye (0/0)
Jewelcrafting
85
16.3
Cataclysm 
Meta Gem
Name Gems ilvl DPS
Crafted Enigmatic Primal Diamond (0/0)
Jewelcrafting
90
67.5
Crafted Impassive Primal Diamond (0/0)
Jewelcrafting
90
67.5
Crafted Destructive Primal Diamond (0/0)
Jewelcrafting
90
67.5
Crafted Fleet Primal Diamond (0/0)
Jewelcrafting
90
59.4
Crafted Reverberating Primal Diamond (0/0)
Jewelcrafting
90
57.0
Crafted Destructive Shadowspirit Diamond (0/0)
Jewelcrafting
85
55.0
Cataclysm 
Crafted Chaotic Shadowspirit Diamond (0/0)
Jewelcrafting
85
55.0
Cataclysm 
Crafted Impassive Shadowspirit Diamond (0/0)
Jewelcrafting
85
55.0
Cataclysm 
Crafted Enigmatic Shadowspirit Diamond (0/0)
Jewelcrafting
85
55.0
Cataclysm 
Crafted Fleet Shadowspirit Diamond (0/0)
Jewelcrafting
85
48.4
Cataclysm 
Crafted Reverberating Shadowspirit Diamond (0/0)
Jewelcrafting
85
44.8
Cataclysm 
Cogwheel Gem
Name Gems ilvl DPS
Crafted Smooth Tinker's Gear (0/0)
Engineering - Only
90
139.8
Crafted Rigid Tinker's Gear (0/0)
Engineering - Only
90
139.8
Crafted Fractured Tinker's Gear (0/0)
Engineering - Only
90
128.4
Crafted Rigid Cogwheel (0/0)
Engineering - Only
359
115.7
Cataclysm 
Crafted Precise Tinker's Gear (0/0)
Engineering - Only
90
112.8
Crafted Quick Tinker's Gear (0/0)
Engineering - Only
90
112.8
Crafted Smooth Cogwheel (0/0)
Engineering - Only
359
112.2
Cataclysm 
Crafted Fractured Cogwheel (0/0)
Engineering - Only
359
97.4
Cataclysm 
Crafted Precise Cogwheel (0/0)
Engineering - Only
359
85.9
Cataclysm 
Crafted Quick Cogwheel (0/0)
Engineering - Only
359
82.3
Cataclysm 
Sha-Touched
Name Gems ilvl DPS
Quest Reward Crystallized Terror (0/0)
513
136.2
SELECT * FROM items, itemsForClasses WHERE (slotID = '29' OR slotID = '30' OR slotID = '31' OR slotID = '32' OR slotID = '33' OR slotID = '34' OR slotID = '35' OR slotID = '44' OR slotID = '46') 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