Heroes with starting spells

Heroes that start with a spell in their spell book.

Custom SQL query returning 116 rows (hide)

SELECT icon, name, class, town, specialty, spell FROM heroes WHERE spell != '' ORDER BY town, name

Edit SQL

This data as json, CSV

name	class	town	specialty	spell
Akka	Elder	Bulwark	Bloodlust	Bloodlust
Allora	Elder	Bulwark	Sorcery	Haste
Biarma	Elder	Bulwark	First Aid	Dispel
Dalton	Elder	Bulwark	Shield	Shield
Glacius	Elder	Bulwark	Frost Ring	Frost Ring
Haugir	Elder	Bulwark	Navigation	Dispel
Kriv	Elder	Bulwark	Shamans	View Air
Sial	Elder	Bulwark	Ice Bolt	Ice Bolt
Vehr	Elder	Bulwark	Gold	View Earth
Adela	Cleric	Castle	Bless	Bless
Adelaide	Cleric	Castle	Frost Ring	Frost Ring
Caitlin	Cleric	Castle	Gold	Cure
Cuthbert	Cleric	Castle	Weakness	Weakness
Ingham	Cleric	Castle	Monks	Curse
Loynis	Cleric	Castle	Prayer	Prayer
Rion	Cleric	Castle	First Aid	Stone Skin
Sanya	Cleric	Castle	Eagle Eye	Dispel
Aenain	Elementalist	Conflux	Disrupting Ray	Disrupting Ray
Brissa	Elementalist	Conflux	Haste	Haste
Ciele	Elementalist	Conflux	Magic Arrow	Magic Arrow
Gelare	Elementalist	Conflux	Gold	Dispel
Grindan	Elementalist	Conflux	Gold	Slow
Inteus	Elementalist	Conflux	Bloodlust	Bloodlust
Labetha	Elementalist	Conflux	Stone Skin	Stone Skin
Luna	Elementalist	Conflux	Fire Wall	Fire Wall
Andal	Navigator	Cove	Crystal	Slow
Astra	Navigator	Cove	Cure	Cure
Casmetra	Navigator	Cove	Sea Witches	Dispel
Dargem	Navigator	Cove	Air Shield	Air Shield
Eovacius	Navigator	Cove	Clone	Clone
Manfred	Navigator	Cove	Fireball	Fireball
Spint	Navigator	Cove	Sorcery	Bless
Zilare	Navigator	Cove	Forgetfulness	Forgetfulness
Alamar	Warlock	Dungeon	Resurrection	Resurrection
Darkstorn	Warlock	Dungeon	Stone Skin	Stone Skin
Deemer	Warlock	Dungeon	Meteor Shower	Meteor Shower
Geon	Warlock	Dungeon	Eagle Eye	Slow
Jaegar	Warlock	Dungeon	Mysticism	Shield
Jeddite	Warlock	Dungeon	Resurrection	Resurrection
Malekith	Warlock	Dungeon	Sorcery	Bloodlust
Sephinroth	Warlock	Dungeon	Crystal	Protection from Air
Agar	Artificer	Factory	Sandworms	View Earth
Bertram	Artificer	Factory	Gold	Magic Arrow
Celestine	Artificer	Factory	Armadillos	Haste
Eanswythe	Artificer	Factory	Weakness	Weakness
Todd	Artificer	Factory	Automatons	Shield
Victoria	Artificer	Factory	Land Mine	Land Mine
Wrathmont	Artificer	Factory	Frenzy	Frenzy
Ziph	Artificer	Factory	Lightning Bolt	Lightning Bolt
Andra	Witch	Fortress	Intelligence	Dispel
Kinkeria	Witch	Fortress	Learning	Slow
Merist	Witch	Fortress	Stone Skin	Stone Skin
Mirlanda	Witch	Fortress	Weakness	Weakness
Rosic	Witch	Fortress	Mysticism	Magic Arrow
Styg	Witch	Fortress	Sorcery	Shield
Tiva	Witch	Fortress	Eagle Eye	Stone Skin
Verdish	Witch	Fortress	First Aid	Protection from Fire
Voy	Witch	Fortress	Navigation	Slow
Ash	Heretic	Inferno	Bloodlust	Bloodlust
Axsis	Heretic	Inferno	Mysticism	Protection from Air
Ayden	Heretic	Inferno	Intelligence	View Earth
Calid	Heretic	Inferno	Sulfur	Haste
Olema	Heretic	Inferno	Weakness	Weakness
Xarfax	Heretic	Inferno	Fireball	Fireball
Xyron	Heretic	Inferno	Inferno (spell)	Inferno
Zydar	Heretic	Inferno	Sorcery	Stone Skin
Aislinn	Necromancer	Necropolis	Meteor Shower	Meteor Shower
Charna	Death Knight	Necropolis	Wights	Magic Arrow
Clavius	Death Knight	Necropolis	Gold	Magic Arrow
Galthran	Death Knight	Necropolis	Skeletons	Shield
Haart LichLord Haart	Death Knight	Necropolis	Black Knights	Slow
Isra	Death Knight	Necropolis	Necromancy	Magic Arrow
Moandor	Death Knight	Necropolis	Liches	Slow
Nagash	Necromancer	Necropolis	Gold	Protection from Air
Nimbus	Necromancer	Necropolis	Eagle Eye	Shield
Ranloo	Death Knight	Necropolis	Ballista	Haste
Sandro	Necromancer	Necropolis	Sorcery	Slow
Septienna	Necromancer	Necropolis	Death Ripple	Death Ripple
Straker	Death Knight	Necropolis	Walking Dead	Haste
Tamika	Death Knight	Necropolis	Black Knights	Magic Arrow
Thant	Necromancer	Necropolis	Animate Dead	Animate Dead
Vidomina	Necromancer	Necropolis	Necromancy	Curse
Vokial	Death Knight	Necropolis	Vampires	Stone Skin
Xsi	Necromancer	Necropolis	Stone Skin	Stone Skin
Aeris	Druid	Rampart	Pegasi	Protection from Air
Alagar	Druid	Rampart	Ice Bolt	Ice Bolt
Coronius	Druid	Rampart	Slayer	Slayer
Elleshar	Druid	Rampart	Intelligence	Curse
Gem	Druid	Rampart	First Aid	Summon Boat / Bless
Malcom	Druid	Rampart	Eagle Eye	Magic Arrow
Melodia	Druid	Rampart	Fortune	Fortune
Uland	Druid	Rampart	Cure	Cure
Dessa	Battle Mage	Stronghold	Logistics	Stone Skin
Gird	Battle Mage	Stronghold	Sorcery	Bloodlust
Gundula	Battle Mage	Stronghold	Offense	Slow
Oris	Battle Mage	Stronghold	Eagle Eye	Protection from Air
Saurug	Battle Mage	Stronghold	Gems	Bloodlust
Terek	Battle Mage	Stronghold	Haste	Haste
Vey	Battle Mage	Stronghold	Ogres	Magic Arrow
Zubin	Battle Mage	Stronghold	Precision	Precision
Aine	Wizard	Tower	Gold	Curse
Astral	Wizard	Tower	Hypnotize	Hypnotize
Cyra	Wizard	Tower	Haste	Haste
Daremyth	Wizard	Tower	Fortune	Fortune
Fafner	Alchemist	Tower	Nagas	Haste
Halon	Wizard	Tower	Mysticism	Stone Skin
Iona	Alchemist	Tower	Genies	Magic Arrow
Josephine	Alchemist	Tower	Golems	Haste
Neela	Alchemist	Tower	Armorer	Shield
Piquedram	Alchemist	Tower	Gargoyles	Shield
Rissa	Alchemist	Tower	Mercury	Magic Arrow
Serena	Wizard	Tower	Eagle Eye	Dispel
Solmyr	Wizard	Tower	Chain Lightning	Chain Lightning
Thane	Alchemist	Tower	Genies	Magic Arrow
Theodorus	Wizard	Tower	Magi	Shield
Torosar	Alchemist	Tower	Ballista	Magic Arrow