Advertisement
Rochet2

get loots

Aug 29th, 2014
351
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.18 KB | None | 0 0
  1. SELECT `item` FROM `creature_loot_template` WHERE item IN (49285,49286,35226,33224,38576,35225,49282,49284,49283) UNION
  2. SELECT `item` FROM `disenchant_loot_template` WHERE item IN (49285,49286,35226,33224,38576,35225,49282,49284,49283) UNION
  3. SELECT `item` FROM `fishing_loot_template` WHERE item IN (49285,49286,35226,33224,38576,35225,49282,49284,49283) UNION
  4. SELECT `item` FROM `gameobject_loot_template` WHERE item IN (49285,49286,35226,33224,38576,35225,49282,49284,49283) UNION
  5. SELECT `item` FROM `item_loot_template` WHERE item IN (49285,49286,35226,33224,38576,35225,49282,49284,49283) UNION
  6. SELECT `item` FROM `milling_loot_template` WHERE item IN (49285,49286,35226,33224,38576,35225,49282,49284,49283) UNION
  7. SELECT `item` FROM `pickpocketing_loot_template` WHERE item IN (49285,49286,35226,33224,38576,35225,49282,49284,49283) UNION
  8. SELECT `item` FROM `prospecting_loot_template` WHERE item IN (49285,49286,35226,33224,38576,35225,49282,49284,49283) UNION
  9. SELECT `item` FROM `skinning_loot_template` WHERE item IN (49285,49286,35226,33224,38576,35225,49282,49284,49283) UNION
  10. SELECT `item` FROM `spell_loot_template` WHERE item IN (49285,49286,35226,33224,38576,35225,49282,49284,49283);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement