Skip to content

Instantly share code, notes, and snippets.

@Retriman
Created June 6, 2015 05:47
Show Gist options
  • Save Retriman/d9afcb312b538f54dc05 to your computer and use it in GitHub Desktop.
Save Retriman/d9afcb312b538f54dc05 to your computer and use it in GitHub Desktop.
SELECT * FROM `creature` WHERE `id` IN (37221,37223);
SELECT * FROM `gameobject` WHERE `id` IN ( 201385, 201885, 202396, 500001, 201596, 201709, 500002, 202211, 500003, 202079, 202212, 201710, 202337, 202336 );
SELECT * FROM `gameobject` WHERE `id` IN (201709, 500002, 202211, 500003);
SELECT * FROM `gameobject_template` WHERE `entry` IN (201709, 500002, 202211, 500003);
SELECT * FROM `gameobject_template` WHERE `entry` IN (201385,201885,202396,500001,201596);
SELECT * FROM `creature_template` WHERE `entry` =36955; -- Lady Proudmoore part 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment