rendered paste bodymysql> INSERT IGNORE INTO `heroic_dump` (`nonheroic`) (SELECT `id` FROM `creature` WHERE `id` IN (SELECT `entry` FROM `creature_template` WHERE `name` IN (SELECT `name` FROM `creature_template` WHERE `entry` IN (SELECT `entry` FROM `creature_loot_template`))) AND `isHeroic` = '0' AND `map` IN (540,542,543,546,547,545,552,553,554,555,556,557,558,560,267));
Query OK, 265 rows affected
Records: 1530 Duplicates: 1265 Warnings: 0
mysql> INSERT IGNORE INTO `heroic_dump` (`heroic`) (SELECT `id` FROM `creature` WHERE `id` IN (SELECT `entry` from creature_template where name in (select name from creature_template where entry in (select nonheroic from heroic_dump))) AND `isHeroic` = '1');
Query OK, 249 rows affected
Records: 1482 Duplicates: 1233 Warnings: 0
mysql> select name,entry from creature_template where name in (select name from creature_template where entry in (select heroic from heroic_dump)) order by name;
+-----------------------------+-------+
| name | entry |
+-----------------------------+-------+
| Akkiris Lightning-Waker | 20908 |
| Akkiris Lightning-Waker | 21617 |
| Ambassador Hellmaw | 20636 |
| Ambassador Hellmaw | 18731 |
| Angered Skeleton | 18524 |
| Angered Skeleton | 20298 |
| Arcanist Doan | 20352 |
| Arcanist Doan | 6487 |
| Arcatraz Defender | 20857 |
| Arcatraz Defender | 21585 |
| Arcatraz Sentinel | 21586 |
| Arcatraz Sentinel | 20869 |
| Arcatraz Warder | 20859 |
| Arcatraz Warder | 21587 |
| Auchenai Monk | 20299 |
| Auchenai Monk | 18497 |
| Auchenai Necromancer | 18702 |
| Auchenai Necromancer | 20300 |
| Auchenai Soulpriest | 20301 |
| Auchenai Soulpriest | 18493 |
| Auchenai Vindicator | 18495 |
| Auchenai Vindicator | 20302 |
| Avatar of the Martyred | 20303 |
| Avatar of the Martyred | 18478 |
| Avian Warhawk | 21904 |
| Avian Warhawk | 21990 |
| Barkeep Kelly | 2366 |
| Barkeep Kelly | 20377 |
| Blackheart the Inciter | 18667 |
| Blackheart the Inciter | 19304 |
| Blackheart the Inciter | 19300 |
| Blackheart the Inciter | 19303 |
| Blackheart the Inciter | 19302 |
| Blackheart the Inciter | 19301 |
| Blackheart the Inciter | 20637 |
| Blackwing Drakonaar | 21588 |
| Blackwing Drakonaar | 20911 |
| Bleeding Hollow Archer | 17270 |
| Bleeding Hollow Archer | 18048 |
| Bleeding Hollow Darkcaster | 18049 |
| Bleeding Hollow Darkcaster | 17269 |
| Bleeding Hollow Scryer | 17478 |
| Bleeding Hollow Scryer | 18050 |
| Bloodfalcon | 21544 |
| Bloodfalcon | 18155 |
| Bloodwarder Centurion | 19510 |
| Bloodwarder Centurion | 21522 |
| Bloodwarder Falconer | 21545 |
| Bloodwarder Falconer | 17994 |
| Bloodwarder Greenkeeper | 18419 |
| Bloodwarder Greenkeeper | 21546 |
| Bloodwarder Mender | 21547 |
| Bloodwarder Mender | 19633 |
| Bloodwarder Physician | 20990 |
| Bloodwarder Physician | 21523 |
| Bloodwarder Protector | 21548 |
| Bloodwarder Protector | 17993 |
| Bloodwarder Slayer | 19167 |
| Bloodwarder Slayer | 21524 |
| Bloodwarder Steward | 21549 |
| Bloodwarder Steward | 18404 |
| Bog Giant | 17723 |
| Bog Giant | 20164 |
| Bog Overlord | 21914 |
| Bog Overlord | 21694 |
| Bogstrok | 17816 |
| Bogstrok | 19884 |
| Bonechewer Beastmaster | 18051 |
| Bonechewer Beastmaster | 17455 |
| Bonechewer Destroyer | 17271 |
| Bonechewer Destroyer | 18052 |
| Bonechewer Hungerer | 18053 |
| Bonechewer Hungerer | 17259 |
| Bonechewer Ravener | 17264 |
| Bonechewer Ravener | 18054 |
| Bonechewer Ripper | 18055 |
| Bonechewer Ripper | 17281 |
| Broggok | 17380 |
| Broggok | 18601 |
| Cabal Acolyte | 20638 |
| Cabal Acolyte | 18633 |
| Cabal Assassin | 18636 |
| Cabal Assassin | 20639 |
| Cabal Cultist | 20640 |
| Cabal Cultist | 18631 |
| Cabal Deathsworn | 18635 |
| Cabal Deathsworn | 20641 |
| Cabal Executioner | 20642 |
| Cabal Executioner | 18632 |
| Cabal Familiar | 18641 |
| Cabal Familiar | 20643 |
| Cabal Fanatic | 20644 |
| Cabal Fanatic | 18830 |
| Cabal Ritualist | 18794 |
| Cabal Ritualist | 20645 |
| Cabal Shadow Priest | 20646 |
| Cabal Shadow Priest | 18637 |
| Cabal Spellbinder | 18639 |
| Cabal Spellbinder | 20647 |
| Cabal Summoner | 20648 |
| Cabal Summoner | 18634 |
| Cabal Warlock | 18640 |
| Cabal Warlock | 20649 |
| Cabal Zealot | 20650 |
| Cabal Zealot | 18638 |
| Captain Skarloc | 17862 |
| Captain Skarloc | 20521 |
| Caretaker Smithers | 20363 |
| Caretaker Smithers | 2379 |
| Coilfang Champion | 17957 |
| Coilfang Champion | 19885 |
| Coilfang Collaborator | 19903 |
| Coilfang Collaborator | 17962 |
| Coilfang Defender | 17958 |
| Coilfang Defender | 19886 |
| Coilfang Enchantress | 19887 |
| Coilfang Enchantress | 17961 |
| Coilfang Engineer | 17721 |
| Coilfang Engineer | 20620 |
| Coilfang Leper | 21915 |
| Coilfang Leper | 21338 |
| Coilfang Myrmidon | 17800 |
| Coilfang Myrmidon | 20621 |
| Coilfang Oracle | 20622 |
| Coilfang Oracle | 17803 |
| Coilfang Siren | 17801 |
| Coilfang Siren | 20623 |
| Coilfang Slavehandler | 19889 |
| Coilfang Slavehandler | 17959 |
| Coilfang Slavemaster | 17805 |
| Coilfang Slavemaster | 20624 |
| Coilfang Soothsayer | 19890 |
| Coilfang Soothsayer | 17960 |
| Coilfang Sorceress | 17722 |
| Coilfang Sorceress | 20625 |
| Coilfang Technician | 19891 |
| Coilfang Technician | 17940 |
| Coilfang Tempest | 21127 |
| Coilfang Tempest | 21843 |
| Coilfang Warrior | 20626 |
| Coilfang Warrior | 17802 |
| Coilfang Water Elemental | 17917 |
| Coilfang Water Elemental | 20627 |
| Commander Sarannis | 21551 |
| Commander Sarannis | 17976 |
| Dalliah the Doomsayer | 20885 |
| Dalliah the Doomsayer | 21590 |
| Darkweaver Syth | 20690 |
| Darkweaver Syth | 18472 |
| Death Watcher | 20867 |
| Death Watcher | 21591 |
| Dreghood Slave | 20628 |
| Dreghood Slave | 17799 |
| Durnholde Rifleman | 17820 |
| Durnholde Rifleman | 20526 |
| Durnholde Sentry | 20527 |
| Durnholde Sentry | 17819 |
| Durnholde Tracking Hound | 17840 |
| Durnholde Tracking Hound | 20528 |
| Durnholde Veteran | 20529 |
| Durnholde Veteran | 17860 |
| Durnholde Warden | 17833 |
| Durnholde Warden | 20530 |
| Epoch Hunter | 20531 |
| Epoch Hunter | 18096 |
| Eredar Soul-Eater | 20879 |
| Eredar Soul-Eater | 21595 |
| Ethereal Crypt Raider | 20255 |
| Ethereal Crypt Raider | 18311 |
| Ethereal Darkcaster | 18331 |
| Ethereal Darkcaster | 20256 |
| Ethereal Priest | 20257 |
| Ethereal Priest | 18317 |
| Ethereal Scavenger | 18309 |
| Ethereal Scavenger | 20258 |
| Ethereal Sorcerer | 20259 |
| Ethereal Sorcerer | 18313 |
| Ethereal Spellbinder | 18312 |
| Ethereal Spellbinder | 20260 |
| Ethereum Life-Binder | 22346 |
| Ethereum Life-Binder | 21702 |
| Ethereum Slayer | 20896 |
| Ethereum Slayer | 21596 |
| Ethereum Wave-Caster | 21597 |
| Ethereum Wave-Caster | 20897 |
| Exarch Maladaar | 18373 |
| Exarch Maladaar | 20306 |
| Fel Guardhound | 20651 |
| Fel Guardhound | 18642 |
| Fel Orc Convert | 17083 |
| Fel Orc Convert | 20567 |
| Fel Orc Neophyte | 18603 |
| Fel Orc Neophyte | 17429 |
| Fel Overseer | 18796 |
| Fel Overseer | 20652 |
| Felguard Brute | 21645 |
| Felguard Brute | 18894 |
| Fen Ray | 17731 |
| Fen Ray | 20173 |
| Frayer | 21552 |
| Frayer | 18587 |
| Frayer Wildling | 19608 |
| Frayer Wildling | 21554 |
| Gargantuan Abyssal | 21598 |
| Gargantuan Abyssal | 20898 |
| Gatewatcher Gyro-Kill | 19218 |
| Gatewatcher Gyro-Kill | 21525 |
| Gatewatcher Iron-Hand | 21526 |
| Gatewatcher Iron-Hand | 19710 |
| Ghaz'an | 18105 |
| Ghaz'an | 20168 |
| Grand Warlock Nethekurse | 20568 |
| Grand Warlock Nethekurse | 16807 |
| Grandmaster Vorpil | 18732 |
| Grandmaster Vorpil | 20653 |
| Greater Bogstrok | 19892 |
| Greater Bogstrok | 17817 |
| Greater Frayer | 19557 |
| Greater Frayer | 21555 |
| Hal McAllister | 20342 |
| Hal McAllister | 3540 |
| Harbinger Skyriss | 21467 |
| Harbinger Skyriss | 20912 |
| Harbinger Skyriss | 21466 |
| Harbinger Skyriss | 21599 |
| Hellfire Sentry | 18057 |
| Hellfire Sentry | 17517 |
| Hellfire Watcher | 17309 |
| Hellfire Watcher | 18058 |
| High Botanist Freywinn | 21558 |
| High Botanist Freywinn | 17975 |
| Hillsbrad Farmer | 20433 |
| Hillsbrad Farmer | 2266 |
| Hungarfen | 17770 |
| Hungarfen | 20169 |
| Hydromancer Thespia | 20629 |
| Hydromancer Thespia | 17797 |
| Infinite Saboteur | 18172 |
| Infinite Saboteur | 20533 |
| Kel'Thuzad | 20423 |
| Kel'Thuzad | 20350 |
| Kel'Thuzad | 15990 |
| Keli'dan the Breaker | 17377 |
| Keli'dan the Breaker | 18607 |
| Laj | 21559 |
| Laj | 17980 |
| Laughing Skull Enforcer | 17370 |
| Laughing Skull Enforcer | 18608 |
| Laughing Skull Legionnaire | 18609 |
| Laughing Skull Legionnaire | 17626 |
| Laughing Skull Rogue | 17491 |
| Laughing Skull Rogue | 18610 |
| Laughing Skull Warden | 18611 |
| Laughing Skull Warden | 17624 |
| Lieutenant Drake | 17848 |
| Lieutenant Drake | 20535 |
| Magtheridon | 17257 |
| Magtheridon | 19703 |
| Magtheridon | 21174 |
| Malicious Instructor | 18848 |
| Malicious Instructor | 20656 |
| Mana Leech | 20263 |
| Mana Leech | 19306 |
| Mechanar Crusher | 19231 |
| Mechanar Crusher | 21527 |
| Mechanar Driller | 21528 |
| Mechanar Driller | 19712 |
| Mechanar Tinkerer | 19716 |
| Mechanar Tinkerer | 21531 |
| Mechanar Wrecker | 19713 |
| Mechanar Wrecker | 21532 |
| Mechano-Lord Capacitus | 19219 |
| Mechano-Lord Capacitus | 21533 |
| Mekgineer Steamrigger | 20630 |
| Mekgineer Steamrigger | 17796 |
| Mennu the Betrayer | 17941 |
| Mennu the Betrayer | 19893 |
| Murkblood Oracle | 20179 |
| Murkblood Oracle | 17771 |
| Murkblood Spearman | 17729 |
| Murkblood Spearman | 20180 |
| Murkblood Tribesman | 20181 |
| Murkblood Tribesman | 17728 |
| Murmur | 18708 |
| Murmur | 20657 |
| Mutate Fear-Shrieker | 21560 |
| Mutate Fear-Shrieker | 19513 |
| Mutate Fleshlasher | 19598 |
| Mutate Fleshlasher | 21561 |
| Mutate Horror | 21562 |
| Mutate Horror | 19865 |
| Nascent Fel Orc | 17398 |
| Nascent Fel Orc | 18612 |
| Nazan | 18432 |
| Nazan | 17536 |
| Negaton Screamer | 20875 |
| Negaton Screamer | 21604 |
| Negaton Warp-Master | 21605 |
| Negaton Warp-Master | 20873 |
| Nethermancer Sepethrea | 19221 |
| Nethermancer Sepethrea | 21536 |
| Nethervine Inciter | 21563 |
| Nethervine Inciter | 19511 |
| Nethervine Reaper | 19512 |
| Nethervine Reaper | 21564 |
| Nethervine Trickster | 21565 |
| Nethervine Trickster | 19843 |
| Nexus Terror | 19307 |
| Nexus Terror | 20265 |
| Nexus-Prince Shaffar | 20266 |
| Nexus-Prince Shaffar | 18344 |
| Omor the Unscarred | 17308 |
| Omor the Unscarred | 18433 |
| Pandemonius | 20267 |
| Pandemonius | 18341 |
| Pathaleon the Calculator | 19220 |
| Pathaleon the Calculator | 21537 |
| Phase-Hunter | 21606 |
| Phase-Hunter | 20906 |
| Phasing Soldier | 18556 |
| Phasing Soldier | 20311 |
| Phasing Stalker | 20313 |
| Phasing Stalker | 18559 |
| Pit Spectator | 17846 |
| Pit Spectator | 20543 |
| Protean Horror | 21607 |
| Protean Horror | 20865 |
| Protean Nightmare | 20864 |
| Protean Nightmare | 21608 |
| Protean Spawn | 21609 |
| Protean Spawn | 21395 |
| Quagmirran | 17942 |
| Quagmirran | 19894 |
| Rabid Warhound | 20574 |
| Rabid Warhound | 17669 |
| Raging Skeleton | 18521 |
| Raging Skeleton | 20315 |
| Rokmar the Crackler | 19895 |
| Rokmar the Crackler | 17991 |
| Sargeron Archer | 20901 |
| Sargeron Archer | 21610 |
| Sargeron Hellcaller | 21611 |
| Sargeron Hellcaller | 20902 |
| Sethekk Guard | 18323 |
| Sethekk Guard | 20692 |
| Sethekk Oracle | 20694 |
| Sethekk Oracle | 18328 |
| Sethekk Ravenguard | 18322 |
| Sethekk Ravenguard | 20696 |
| Sethekk Shaman | 20699 |
| Sethekk Shaman | 18326 |
| Sethekk Talon Lord | 18321 |
| Sethekk Talon Lord | 20701 |
| Shadowmoon Acolyte | 20576 |
| Shadowmoon Acolyte | 16594 |
| Shadowmoon Adept | 17397 |
| Shadowmoon Adept | 18615 |
| Shadowmoon Darkcaster | 20577 |
| Shadowmoon Darkcaster | 17694 |
| Shadowmoon Summoner | 17395 |
| Shadowmoon Summoner | 18617 |
| Shadowmoon Technician | 18618 |
| Shadowmoon Technician | 17414 |
| Shadowmoon Warlock | 17371 |
| Shadowmoon Warlock | 18619 |
| Shattered Hand Archer | 20579 |
| Shattered Hand Archer | 17427 |
| Shattered Hand Assassin | 17695 |
| Shattered Hand Assassin | 20580 |
| Shattered Hand Blood Guard | 20581 |
| Shattered Hand Blood Guard | 17461 |
| Shattered Hand Brawler | 16593 |
| Shattered Hand Brawler | 20582 |
| Shattered Hand Centurion | 20583 |
| Shattered Hand Centurion | 17465 |
| Shattered Hand Champion | 17671 |
| Shattered Hand Champion | 20584 |
| Shattered Hand Gladiator | 20586 |
| Shattered Hand Gladiator | 17464 |
| Shattered Hand Heathen | 17420 |
| Shattered Hand Heathen | 20587 |
| Shattered Hand Houndmaster | 20588 |
| Shattered Hand Houndmaster | 17670 |
| Shattered Hand Legionnaire | 16700 |
| Shattered Hand Legionnaire | 20589 |
| Shattered Hand Reaver | 20590 |
| Shattered Hand Reaver | 16699 |
| Shattered Hand Sentry | 16507 |
| Shattered Hand Sentry | 20593 |
| Shattered Hand Sharpshooter | 20594 |
| Shattered Hand Sharpshooter | 16704 |
| Shattered Hand Warhound | 17280 |
| Shattered Hand Warhound | 18059 |
| Shattered Hand Zealot | 20595 |
| Shattered Hand Zealot | 17462 |
| Shirrak the Dead Watcher | 18371 |
| Shirrak the Dead Watcher | 20318 |
| Skulking Witch | 21613 |
| Skulking Witch | 20882 |
| Soul Devourer | 20866 |
| Soul Devourer | 21614 |
| Spiteful Temptress | 21615 |
| Spiteful Temptress | 20883 |
| Stalvan Mistmantle | 20355 |
| Stalvan Mistmantle | 315 |
| Steam Surger | 21696 |
| Steam Surger | 21916 |
| Summoned Cabal Acolyte | 20660 |
| Summoned Cabal Acolyte | 19208 |
| Summoned Cabal Deathsworn | 19209 |
| Summoned Cabal Deathsworn | 20661 |
| Sunseeker Astromage | 21539 |
| Sunseeker Astromage | 19168 |
| Sunseeker Botanist | 18422 |
| Sunseeker Botanist | 21570 |
| Sunseeker Channeler | 21571 |
| Sunseeker Channeler | 19505 |
| Sunseeker Chemist | 19486 |
| Sunseeker Chemist | 21572 |
| Sunseeker Engineer | 21540 |
| Sunseeker Engineer | 20988 |
| Sunseeker Gene-Splicer | 19507 |
| Sunseeker Gene-Splicer | 21573 |
| Sunseeker Geomancer | 21574 |
| Sunseeker Geomancer | 18420 |
| Sunseeker Harvester | 19509 |
| Sunseeker Harvester | 21575 |
| Sunseeker Herbalist | 21576 |
| Sunseeker Herbalist | 19508 |
| Sunseeker Netherbinder | 20059 |
| Sunseeker Netherbinder | 21541 |
| Sunseeker Researcher | 21577 |
| Sunseeker Researcher | 18421 |
| Swamplord Musel'ek | 17826 |
| Swamplord Musel'ek | 20183 |
| Talon King Ikiss | 20706 |
| Talon King Ikiss | 18473 |
| Tarren Mill Guardsman | 18092 |
| Tarren Mill Guardsman | 23175 |
| Tarren Mill Guardsman | 23176 |
| Tarren Mill Guardsman | 20545 |
| Tarren Mill Lookout | 20546 |
| Tarren Mill Lookout | 18094 |
| Tarren Mill Lookout | 23177 |
| Tarren Mill Lookout | 23178 |
| Tarren Mill Protector | 18093 |
| Tarren Mill Protector | 23179 |
| Tarren Mill Protector | 23180 |
| Tarren Mill Protector | 20547 |
| Tavarok | 20268 |
| Tavarok | 18343 |
| Tempest-Forge Destroyer | 19735 |
| Tempest-Forge Destroyer | 21542 |
| Tempest-Forge Patroller | 21543 |
| Tempest-Forge Patroller | 19166 |
| Tempest-Forge Peacekeeper | 18405 |
| Tempest-Forge Peacekeeper | 21578 |
| The Black Stalker | 20184 |
| The Black Stalker | 17882 |
| The Maker | 17381 |
| The Maker | 18621 |
| Thorngrin the Tender | 21581 |
| Thorngrin the Tender | 17978 |
| Thrall | 19647 |
| Thrall | 19556 |
| Thrall | 17876 |
| Thrall | 4949 |
| Thrall | 17852 |
| Thrall | 20548 |
| Tidal Surger | 21917 |
| Tidal Surger | 21695 |
| Time-Lost Scryer | 18319 |
| Time-Lost Scryer | 20697 |
| Time-Lost Shadowmage | 20698 |
| Time-Lost Shadowmage | 18320 |
| Tortured Skeleton | 18797 |
| Tortured Skeleton | 20662 |
| Unbound Devastator | 21619 |
| Unbound Devastator | 20881 |
| Unchained Doombringer | 20900 |
| Unchained Doombringer | 21621 |
| Underbat | 20185 |
| Underbat | 17724 |
| Underbog Lord | 17734 |
| Underbog Lord | 20187 |
| Underbog Lurker | 20188 |
| Underbog Lurker | 17725 |
| Underbog Shambler | 17871 |
| Underbog Shambler | 20190 |
| Unliving Soldier | 20321 |
| Unliving Soldier | 18498 |
| Unliving Sorcerer | 18499 |
| Unliving Sorcerer | 20322 |
| Vazruden | 18434 |
| Vazruden | 17537 |
| Warbringer O'mrogg | 16809 |
| Warbringer O'mrogg | 20596 |
| Warchief Kargath Bladefist | 20597 |
| Warchief Kargath Bladefist | 16808 |
| Warlord Kalithresh | 17798 |
| Warlord Kalithresh | 20633 |
| Warp Splinter | 21582 |
| Warp Splinter | 17977 |
| Watchkeeper Gargolmar | 17306 |
| Watchkeeper Gargolmar | 18436 |
| Wrath-Scryer Soccothrates | 21624 |
| Wrath-Scryer Soccothrates | 20886 |
| Wrathfin Myrmidon | 17726 |
| Wrathfin Myrmidon | 20191 |
| Wrathfin Sentry | 20192 |
| Wrathfin Sentry | 17727 |
| Wrathfin Warrior | 17735 |
| Wrathfin Warrior | 20193 |
| Zereketh the Unbound | 21626 |
| Zereketh the Unbound | 20870 |
| Zixil | 20419 |
| Zixil | 3537 |
+-----------------------------+-------+
517 rows in set
mysql> select 517/2
-> ;
+----------+
| 517/2 |
+----------+
| 258.5000 |
+----------+
1 row in set