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 |
+-----------------------------+-------+
| Aeonus                      | 17881 |
| Aeonus                      | 20737 |
| Akkiris Lightning-Waker     | 21617 |
| Akkiris Lightning-Waker     | 20908 |
| Ambassador Hellmaw          | 18731 |
| Ambassador Hellmaw          | 20636 |
| Angered Skeleton            | 20298 |
| Angered Skeleton            | 18524 |
| 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               | 20377 |
| Barkeep Kelly               |  2366 |
| Blackfang Tarantula         | 18983 |
| Blackfang Tarantula         | 22162 |
| Blackheart the Inciter      | 20637 |
| Blackheart the Inciter      | 19300 |
| Blackheart the Inciter      | 19302 |
| Blackheart the Inciter      | 19303 |
| Blackheart the Inciter      | 19304 |
| Blackheart the Inciter      | 18667 |
| Blackheart the Inciter      | 19301 |
| Blackwing Drakonaar         | 20911 |
| Blackwing Drakonaar         | 21588 |
| Bleeding Hollow Archer      | 18048 |
| Bleeding Hollow Archer      | 17270 |
| Bleeding Hollow Darkcaster  | 17269 |
| Bleeding Hollow Darkcaster  | 18049 |
| Bleeding Hollow Scryer      | 18050 |
| Bleeding Hollow Scryer      | 17478 |
| Blood Guard Porung          | 20992 |
| Blood Guard Porung          | 20923 |
| 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                | 21694 |
| Bog Overlord                | 21914 |
| Bogstrok                    | 19884 |
| Bogstrok                    | 17816 |
| Bonechewer Beastmaster      | 17455 |
| Bonechewer Beastmaster      | 18051 |
| Bonechewer Destroyer        | 18052 |
| Bonechewer Destroyer        | 17271 |
| Bonechewer Hungerer         | 17259 |
| Bonechewer Hungerer         | 18053 |
| Bonechewer Ravener          | 18054 |
| Bonechewer Ravener          | 17264 |
| Bonechewer Ripper           | 17281 |
| Bonechewer Ripper           | 18055 |
| Broggok                     | 18601 |
| Broggok                     | 17380 |
| Cabal Acolyte               | 18633 |
| Cabal Acolyte               | 20638 |
| Cabal Assassin              | 20639 |
| Cabal Assassin              | 18636 |
| Cabal Cultist               | 18631 |
| Cabal Cultist               | 20640 |
| Cabal Deathsworn            | 20641 |
| Cabal Deathsworn            | 18635 |
| Cabal Executioner           | 18632 |
| Cabal Executioner           | 20642 |
| Cabal Familiar              | 20643 |
| Cabal Familiar              | 18641 |
| Cabal Fanatic               | 18830 |
| Cabal Fanatic               | 20644 |
| Cabal Ritualist             | 20645 |
| Cabal Ritualist             | 18794 |
| Cabal Shadow Priest         | 18637 |
| Cabal Shadow Priest         | 20646 |
| Cabal Spellbinder           | 20647 |
| Cabal Spellbinder           | 18639 |
| Cabal Summoner              | 18634 |
| Cabal Summoner              | 20648 |
| Cabal Warlock               | 20649 |
| Cabal Warlock               | 18640 |
| Cabal Zealot                | 18638 |
| Cabal Zealot                | 20650 |
| Captain Skarloc             | 20521 |
| Captain Skarloc             | 17862 |
| Caretaker Smithers          | 20363 |
| Caretaker Smithers          |  2379 |
| Chrono Lord Deja            | 17879 |
| Chrono Lord Deja            | 20738 |
| Coilfang Champion           | 19885 |
| Coilfang Champion           | 17957 |
| Coilfang Collaborator       | 17962 |
| Coilfang Collaborator       | 19903 |
| Coilfang Defender           | 19886 |
| Coilfang Defender           | 17958 |
| Coilfang Enchantress        | 17961 |
| Coilfang Enchantress        | 19887 |
| Coilfang Engineer           | 20620 |
| Coilfang Engineer           | 17721 |
| Coilfang Leper              | 21338 |
| Coilfang Leper              | 21915 |
| Coilfang Myrmidon           | 20621 |
| Coilfang Myrmidon           | 17800 |
| Coilfang Oracle             | 17803 |
| Coilfang Oracle             | 20622 |
| Coilfang Siren              | 20623 |
| Coilfang Siren              | 17801 |
| Coilfang Slavehandler       | 17959 |
| Coilfang Slavehandler       | 19889 |
| Coilfang Slavemaster        | 20624 |
| Coilfang Slavemaster        | 17805 |
| Coilfang Soothsayer         | 17960 |
| Coilfang Soothsayer         | 19890 |
| Coilfang Sorceress          | 20625 |
| Coilfang Sorceress          | 17722 |
| Coilfang Technician         | 17940 |
| Coilfang Technician         | 19891 |
| Coilfang Tempest            | 21843 |
| Coilfang Tempest            | 21127 |
| Coilfang Warrior            | 17802 |
| Coilfang Warrior            | 20626 |
| Coilfang Water Elemental    | 20627 |
| Coilfang Water Elemental    | 17917 |
| Commander Sarannis          | 17976 |
| Commander Sarannis          | 21551 |
| Dalliah the Doomsayer       | 21590 |
| Dalliah the Doomsayer       | 20885 |
| Darkwater Crocolisk         | 20075 |
| Darkwater Crocolisk         | 17952 |
| Darkwater Crocolisk         | 22163 |
| 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 |
| Ethereal Theurgist          | 20261 |
| Ethereal Theurgist          | 18315 |
| Ethereum Life-Binder        | 21702 |
| Ethereum Life-Binder        | 22346 |
| Ethereum Slayer             | 21596 |
| Ethereum Slayer             | 20896 |
| Ethereum Wave-Caster        | 20897 |
| Ethereum Wave-Caster        | 21597 |
| Exarch Maladaar             | 20306 |
| Exarch Maladaar             | 18373 |
| Fel Guardhound              | 18642 |
| Fel Guardhound              | 20651 |
| Fel Orc Convert             | 20567 |
| Fel Orc Convert             | 17083 |
| Fel Orc Neophyte            | 17429 |
| Fel Orc Neophyte            | 18603 |
| Fel Overseer                | 20652 |
| Fel Overseer                | 18796 |
| Felguard Brute              | 18894 |
| Felguard Brute              | 21645 |
| Fen Ray                     | 20173 |
| Fen Ray                     | 17731 |
| Frayer                      | 18587 |
| Frayer                      | 21552 |
| Frayer Wildling             | 21554 |
| Frayer Wildling             | 19608 |
| Gargantuan Abyssal          | 20898 |
| Gargantuan Abyssal          | 21598 |
| Gatewatcher Gyro-Kill       | 21525 |
| Gatewatcher Gyro-Kill       | 19218 |
| Gatewatcher Iron-Hand       | 19710 |
| Gatewatcher Iron-Hand       | 21526 |
| Ghaz'an                     | 20168 |
| Ghaz'an                     | 18105 |
| Grand Warlock Nethekurse    | 16807 |
| Grand Warlock Nethekurse    | 20568 |
| Grandmaster Vorpil          | 20653 |
| Grandmaster Vorpil          | 18732 |
| Greater Bogstrok            | 17817 |
| Greater Bogstrok            | 19892 |
| Greater Frayer              | 21555 |
| Greater Frayer              | 19557 |
| Hal McAllister              | 20342 |
| Hal McAllister              |  3540 |
| Harbinger Skyriss           | 20912 |
| Harbinger Skyriss           | 21466 |
| Harbinger Skyriss           | 21467 |
| 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            |  2266 |
| Hillsbrad Farmer            | 20433 |
| 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            | 21532 |
| Mechanar Wrecker            | 19713 |
| 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 Stalker               | 18314 |
| Nexus Stalker               | 20264 |
| Nexus Terror                | 20265 |
| Nexus Terror                | 19307 |
| Nexus-Prince Shaffar        | 18344 |
| Nexus-Prince Shaffar        | 20266 |
| Omor the Unscarred          | 18433 |
| Omor the Unscarred          | 17308 |
| Pandemonius                 | 18341 |
| Pandemonius                 | 20267 |
| Pathaleon the Calculator    | 21537 |
| Pathaleon the Calculator    | 19220 |
| Phase-Hunter                | 20906 |
| Phase-Hunter                | 21606 |
| Phasing Soldier             | 20311 |
| Phasing Soldier             | 18556 |
| Phasing Stalker             | 18559 |
| Phasing Stalker             | 20313 |
| Pit Spectator               | 20543 |
| Pit Spectator               | 17846 |
| Protean Horror              | 20865 |
| Protean Horror              | 21607 |
| Protean Nightmare           | 21608 |
| Protean Nightmare           | 20864 |
| Protean Spawn               | 21395 |
| Protean Spawn               | 21609 |
| Quagmirran                  | 19894 |
| Quagmirran                  | 17942 |
| Rabid Warhound              | 17669 |
| Rabid Warhound              | 20574 |
| Raging Skeleton             | 20315 |
| Raging Skeleton             | 18521 |
| Rift Keeper                 | 21148 |
| Rift Keeper                 | 21104 |
| Rift Keeper                 | 22170 |
| Rift Lord                   | 20744 |
| Rift Lord                   | 21140 |
| Rift Lord                   | 17839 |
| Rokmar the Crackler         | 17991 |
| Rokmar the Crackler         | 19895 |
| Sable Jaguar                | 22173 |
| Sable Jaguar                | 18982 |
| 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          |   315 |
| Stalvan Mistmantle          | 20355 |
| 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       | 20545 |
| Tarren Mill Guardsman       | 23175 |
| Tarren Mill Guardsman       | 23176 |
| Tarren Mill Lookout         | 20546 |
| Tarren Mill Lookout         | 23177 |
| Tarren Mill Lookout         | 23178 |
| Tarren Mill Lookout         | 18094 |
| 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 |
| Temporus                    | 20745 |
| Temporus                    | 17880 |
| The Black Stalker           | 17882 |
| The Black Stalker           | 20184 |
| The Maker                   | 18621 |
| The Maker                   | 17381 |
| Thorngrin the Tender        | 17978 |
| Thorngrin the Tender        | 21581 |
| Thrall                      | 20548 |
| Thrall                      |  4949 |
| Thrall                      | 17876 |
| Thrall                      | 17852 |
| Thrall                      | 19556 |
| Thrall                      | 19647 |
| Tidal Surger                | 21695 |
| Tidal Surger                | 21917 |
| Time-Lost Scryer            | 20697 |
| Time-Lost Scryer            | 18319 |
| Time-Lost Shadowmage        | 18320 |
| Time-Lost Shadowmage        | 20698 |
| Tortured Skeleton           | 20662 |
| Tortured Skeleton           | 18797 |
| Unbound Devastator          | 20881 |
| Unbound Devastator          | 21619 |
| Unchained Doombringer       | 21621 |
| Unchained Doombringer       | 20900 |
| Underbat                    | 17724 |
| Underbat                    | 20185 |
| Underbog Lord               | 20187 |
| Underbog Lord               | 17734 |
| Underbog Lurker             | 17725 |
| Underbog Lurker             | 20188 |
| Underbog Shambler           | 20190 |
| Underbog Shambler           | 17871 |
| Unliving Soldier            | 18498 |
| Unliving Soldier            | 20321 |
| Unliving Sorcerer           | 20322 |
| Unliving Sorcerer           | 18499 |
| Vazruden                    | 17537 |
| Vazruden                    | 18434 |
| Warbringer O'mrogg          | 20596 |
| Warbringer O'mrogg          | 16809 |
| Warchief Kargath Bladefist  | 16808 |
| Warchief Kargath Bladefist  | 20597 |
| Warlord Kalithresh          | 20633 |
| Warlord Kalithresh          | 17798 |
| Warp Splinter               | 17977 |
| Warp Splinter               | 21582 |
| Watchkeeper Gargolmar       | 18436 |
| Watchkeeper Gargolmar       | 17306 |
| Wrath-Scryer Soccothrates   | 20886 |
| Wrath-Scryer Soccothrates   | 21624 |
| Wrathfin Myrmidon           | 20191 |
| Wrathfin Myrmidon           | 17726 |
| Wrathfin Sentry             | 17727 |
| Wrathfin Sentry             | 20192 |
| Wrathfin Warrior            | 20193 |
| Wrathfin Warrior            | 17735 |
| Zereketh the Unbound        | 20870 |
| Zereketh the Unbound        | 21626 |
| Zixil                       | 20419 |
| Zixil                       |  3537 |
+-----------------------------+-------+
542 rows in set