Longest full-army battles

Army battles that took the most combat rounds.

Custom SQL query returning 20 rows (hide) 

SELECT seed, rounds, left_army, right_army FROM battles_army ORDER BY rounds DESC LIMIT 20

Edit SQL

This data as json, CSV

seedroundsleft_armyright_army
1 17 [{"name": "Troglodyte", "count": 42, "survivors": 0}, {"name": "Harpy", "count": 24, "survivors": 0}, {"name": "Beholder", "count": 21, "survivors": 9}, {"name": "Medusa", "count": 12, "survivors": 0}, {"name": "Minotaur", "count": 9, "survivors": 0}, {"name": "Manticore", "count": 6, "survivors": 0}, {"name": "Red Dragon", "count": 3, "survivors": 0}] [{"name": "Gnoll", "count": 36, "survivors": 0}, {"name": "Lizardman", "count": 27, "survivors": 0}, {"name": "Serpent Fly", "count": 24, "survivors": 0}, {"name": "Basilisk", "count": 12, "survivors": 0}, {"name": "Gorgon", "count": 9, "survivors": 0}, {"name": "Wyvern", "count": 6, "survivors": 0}, {"name": "Hydra", "count": 3, "survivors": 0}]
1 15 [{"name": "Centaur", "count": 42, "survivors": 0}, {"name": "Dwarf", "count": 24, "survivors": 0}, {"name": "Wood Elf", "count": 21, "survivors": 0}, {"name": "Pegasus", "count": 15, "survivors": 0}, {"name": "Dendroid Guard", "count": 9, "survivors": 0}, {"name": "Unicorn", "count": 6, "survivors": 0}, {"name": "Green Dragon", "count": 3, "survivors": 0}] [{"name": "Gremlin", "count": 48, "survivors": 0}, {"name": "Stone Gargoyle", "count": 27, "survivors": 0}, {"name": "Stone Golem", "count": 18, "survivors": 0}, {"name": "Mage", "count": 12, "survivors": 0}, {"name": "Genie", "count": 9, "survivors": 0}, {"name": "Naga", "count": 6, "survivors": 1}, {"name": "Giant", "count": 3, "survivors": 0}]
1 14 [{"name": "Infernal Troglodyte", "count": 42, "survivors": 0}, {"name": "Harpy Hag", "count": 24, "survivors": 0}, {"name": "Evil Eye", "count": 21, "survivors": 0}, {"name": "Medusa Queen", "count": 12, "survivors": 0}, {"name": "Minotaur King", "count": 9, "survivors": 0}, {"name": "Scorpicore", "count": 6, "survivors": 0}, {"name": "Black Dragon", "count": 3, "survivors": 0}] [{"name": "Master Gremlin", "count": 48, "survivors": 0}, {"name": "Obsidian Gargoyle", "count": 27, "survivors": 0}, {"name": "Iron Golem", "count": 18, "survivors": 0}, {"name": "Arch Mage", "count": 12, "survivors": 0}, {"name": "Master Genie", "count": 9, "survivors": 0}, {"name": "Naga Queen", "count": 6, "survivors": 0}, {"name": "Titan", "count": 3, "survivors": 2}]
1 14 [{"name": "Hobgoblin", "count": 45, "survivors": 0}, {"name": "Wolf Raider", "count": 27, "survivors": 0}, {"name": "Orc Chieftain", "count": 21, "survivors": 0}, {"name": "Ogre Mage", "count": 12, "survivors": 0}, {"name": "Thunderbird", "count": 9, "survivors": 0}, {"name": "Cyclops King", "count": 6, "survivors": 0}, {"name": "Ancient Behemoth", "count": 3, "survivors": 0}] [{"name": "Master Gremlin", "count": 48, "survivors": 0}, {"name": "Obsidian Gargoyle", "count": 27, "survivors": 0}, {"name": "Iron Golem", "count": 18, "survivors": 0}, {"name": "Arch Mage", "count": 12, "survivors": 0}, {"name": "Master Genie", "count": 9, "survivors": 0}, {"name": "Naga Queen", "count": 6, "survivors": 0}, {"name": "Titan", "count": 3, "survivors": 3}]
1 13 [{"name": "Gnoll Marauder", "count": 36, "survivors": 0}, {"name": "Lizard Warrior", "count": 27, "survivors": 0}, {"name": "Dragon Fly", "count": 24, "survivors": 0}, {"name": "Greater Basilisk", "count": 12, "survivors": 0}, {"name": "Mighty Gorgon", "count": 9, "survivors": 0}, {"name": "Wyvern Monarch", "count": 6, "survivors": 0}, {"name": "Chaos Hydra", "count": 3, "survivors": 0}] [{"name": "Skeleton Warrior", "count": 36, "survivors": 0}, {"name": "Zombie", "count": 24, "survivors": 0}, {"name": "Wraith", "count": 21, "survivors": 0}, {"name": "Vampire Lord", "count": 12, "survivors": 11}, {"name": "Power Lich", "count": 9, "survivors": 0}, {"name": "Dread Knight", "count": 6, "survivors": 0}, {"name": "Ghost Dragon", "count": 3, "survivors": 0}]
1 12 [{"name": "Halberdier", "count": 42, "survivors": 0}, {"name": "Marksman", "count": 27, "survivors": 0}, {"name": "Royal Griffin", "count": 21, "survivors": 0}, {"name": "Crusader", "count": 12, "survivors": 0}, {"name": "Zealot", "count": 9, "survivors": 0}, {"name": "Champion", "count": 6, "survivors": 0}, {"name": "Archangel", "count": 3, "survivors": 0}] [{"name": "Gnoll Marauder", "count": 36, "survivors": 0}, {"name": "Lizard Warrior", "count": 27, "survivors": 0}, {"name": "Dragon Fly", "count": 24, "survivors": 0}, {"name": "Greater Basilisk", "count": 12, "survivors": 0}, {"name": "Mighty Gorgon", "count": 9, "survivors": 0}, {"name": "Wyvern Monarch", "count": 6, "survivors": 0}, {"name": "Chaos Hydra", "count": 3, "survivors": 1}]
1 12 [{"name": "Gnoll Marauder", "count": 36, "survivors": 0}, {"name": "Lizard Warrior", "count": 27, "survivors": 0}, {"name": "Dragon Fly", "count": 24, "survivors": 0}, {"name": "Greater Basilisk", "count": 12, "survivors": 0}, {"name": "Mighty Gorgon", "count": 9, "survivors": 0}, {"name": "Wyvern Monarch", "count": 6, "survivors": 0}, {"name": "Chaos Hydra", "count": 3, "survivors": 2}] [{"name": "Familiar", "count": 45, "survivors": 0}, {"name": "Magog", "count": 24, "survivors": 0}, {"name": "Cerberus", "count": 15, "survivors": 0}, {"name": "Horned Demon", "count": 12, "survivors": 0}, {"name": "Pit Lord", "count": 9, "survivors": 0}, {"name": "Efreet Sultan", "count": 6, "survivors": 0}, {"name": "Arch Devil", "count": 3, "survivors": 0}]
1 12 [{"name": "Skeleton Warrior", "count": 36, "survivors": 0}, {"name": "Zombie", "count": 24, "survivors": 0}, {"name": "Wraith", "count": 21, "survivors": 0}, {"name": "Vampire Lord", "count": 12, "survivors": 0}, {"name": "Power Lich", "count": 9, "survivors": 0}, {"name": "Dread Knight", "count": 6, "survivors": 0}, {"name": "Ghost Dragon", "count": 3, "survivors": 0}] [{"name": "Hobgoblin", "count": 45, "survivors": 0}, {"name": "Wolf Raider", "count": 27, "survivors": 0}, {"name": "Orc Chieftain", "count": 21, "survivors": 0}, {"name": "Ogre Mage", "count": 12, "survivors": 0}, {"name": "Thunderbird", "count": 9, "survivors": 0}, {"name": "Cyclops King", "count": 6, "survivors": 0}, {"name": "Ancient Behemoth", "count": 3, "survivors": 1}]
1 11 [{"name": "Infernal Troglodyte", "count": 42, "survivors": 0}, {"name": "Harpy Hag", "count": 24, "survivors": 0}, {"name": "Evil Eye", "count": 21, "survivors": 0}, {"name": "Medusa Queen", "count": 12, "survivors": 0}, {"name": "Minotaur King", "count": 9, "survivors": 0}, {"name": "Scorpicore", "count": 6, "survivors": 0}, {"name": "Black Dragon", "count": 3, "survivors": 1}] [{"name": "Hobgoblin", "count": 45, "survivors": 0}, {"name": "Wolf Raider", "count": 27, "survivors": 0}, {"name": "Orc Chieftain", "count": 21, "survivors": 0}, {"name": "Ogre Mage", "count": 12, "survivors": 0}, {"name": "Thunderbird", "count": 9, "survivors": 0}, {"name": "Cyclops King", "count": 6, "survivors": 0}, {"name": "Ancient Behemoth", "count": 3, "survivors": 0}]
1 10 [{"name": "Pikeman", "count": 42, "survivors": 0}, {"name": "Archer", "count": 27, "survivors": 0}, {"name": "Griffin", "count": 21, "survivors": 0}, {"name": "Swordsman", "count": 12, "survivors": 0}, {"name": "Monk", "count": 9, "survivors": 0}, {"name": "Cavalier", "count": 6, "survivors": 0}, {"name": "Angel", "count": 3, "survivors": 0}] [{"name": "Centaur", "count": 42, "survivors": 0}, {"name": "Dwarf", "count": 24, "survivors": 24}, {"name": "Wood Elf", "count": 21, "survivors": 0}, {"name": "Pegasus", "count": 15, "survivors": 0}, {"name": "Dendroid Guard", "count": 9, "survivors": 2}, {"name": "Unicorn", "count": 6, "survivors": 0}, {"name": "Green Dragon", "count": 3, "survivors": 0}]
1 10 [{"name": "Gnoll", "count": 36, "survivors": 0}, {"name": "Lizardman", "count": 27, "survivors": 0}, {"name": "Serpent Fly", "count": 24, "survivors": 0}, {"name": "Basilisk", "count": 12, "survivors": 0}, {"name": "Gorgon", "count": 9, "survivors": 0}, {"name": "Wyvern", "count": 6, "survivors": 0}, {"name": "Hydra", "count": 3, "survivors": 0}] [{"name": "Gremlin", "count": 48, "survivors": 0}, {"name": "Stone Gargoyle", "count": 27, "survivors": 0}, {"name": "Stone Golem", "count": 18, "survivors": 8}, {"name": "Mage", "count": 12, "survivors": 0}, {"name": "Genie", "count": 9, "survivors": 0}, {"name": "Naga", "count": 6, "survivors": 2}, {"name": "Giant", "count": 3, "survivors": 0}]
1 10 [{"name": "Gnoll Marauder", "count": 36, "survivors": 0}, {"name": "Lizard Warrior", "count": 27, "survivors": 0}, {"name": "Dragon Fly", "count": 24, "survivors": 0}, {"name": "Greater Basilisk", "count": 12, "survivors": 0}, {"name": "Mighty Gorgon", "count": 9, "survivors": 0}, {"name": "Wyvern Monarch", "count": 6, "survivors": 0}, {"name": "Chaos Hydra", "count": 3, "survivors": 0}] [{"name": "Centaur Captain", "count": 42, "survivors": 0}, {"name": "Battle Dwarf", "count": 24, "survivors": 5}, {"name": "Grand Elf", "count": 21, "survivors": 0}, {"name": "Silver Pegasus", "count": 15, "survivors": 0}, {"name": "Dendroid Soldier", "count": 9, "survivors": 4}, {"name": "War Unicorn", "count": 6, "survivors": 0}, {"name": "Gold Dragon", "count": 3, "survivors": 0}]
1 10 [{"name": "Gnoll Marauder", "count": 36, "survivors": 0}, {"name": "Lizard Warrior", "count": 27, "survivors": 0}, {"name": "Dragon Fly", "count": 24, "survivors": 0}, {"name": "Greater Basilisk", "count": 12, "survivors": 0}, {"name": "Mighty Gorgon", "count": 9, "survivors": 0}, {"name": "Wyvern Monarch", "count": 6, "survivors": 0}, {"name": "Chaos Hydra", "count": 3, "survivors": 0}] [{"name": "Hobgoblin", "count": 45, "survivors": 0}, {"name": "Wolf Raider", "count": 27, "survivors": 0}, {"name": "Orc Chieftain", "count": 21, "survivors": 0}, {"name": "Ogre Mage", "count": 12, "survivors": 0}, {"name": "Thunderbird", "count": 9, "survivors": 0}, {"name": "Cyclops King", "count": 6, "survivors": 0}, {"name": "Ancient Behemoth", "count": 3, "survivors": 1}]
1 10 [{"name": "Gnoll Marauder", "count": 36, "survivors": 0}, {"name": "Lizard Warrior", "count": 27, "survivors": 0}, {"name": "Dragon Fly", "count": 24, "survivors": 0}, {"name": "Greater Basilisk", "count": 12, "survivors": 0}, {"name": "Mighty Gorgon", "count": 9, "survivors": 0}, {"name": "Wyvern Monarch", "count": 6, "survivors": 0}, {"name": "Chaos Hydra", "count": 3, "survivors": 0}] [{"name": "Master Gremlin", "count": 48, "survivors": 0}, {"name": "Obsidian Gargoyle", "count": 27, "survivors": 0}, {"name": "Iron Golem", "count": 18, "survivors": 0}, {"name": "Arch Mage", "count": 12, "survivors": 9}, {"name": "Master Genie", "count": 9, "survivors": 0}, {"name": "Naga Queen", "count": 6, "survivors": 0}, {"name": "Titan", "count": 3, "survivors": 3}]
1 9 [{"name": "Pikeman", "count": 42, "survivors": 0}, {"name": "Archer", "count": 27, "survivors": 0}, {"name": "Griffin", "count": 21, "survivors": 0}, {"name": "Swordsman", "count": 12, "survivors": 0}, {"name": "Monk", "count": 9, "survivors": 0}, {"name": "Cavalier", "count": 6, "survivors": 0}, {"name": "Angel", "count": 3, "survivors": 0}] [{"name": "Troglodyte", "count": 42, "survivors": 0}, {"name": "Harpy", "count": 24, "survivors": 2}, {"name": "Beholder", "count": 21, "survivors": 3}, {"name": "Medusa", "count": 12, "survivors": 0}, {"name": "Minotaur", "count": 9, "survivors": 0}, {"name": "Manticore", "count": 6, "survivors": 0}, {"name": "Red Dragon", "count": 3, "survivors": 1}]
1 9 [{"name": "Troglodyte", "count": 42, "survivors": 0}, {"name": "Harpy", "count": 24, "survivors": 0}, {"name": "Beholder", "count": 21, "survivors": 21}, {"name": "Medusa", "count": 12, "survivors": 6}, {"name": "Minotaur", "count": 9, "survivors": 0}, {"name": "Manticore", "count": 6, "survivors": 0}, {"name": "Red Dragon", "count": 3, "survivors": 0}] [{"name": "Centaur", "count": 42, "survivors": 0}, {"name": "Dwarf", "count": 24, "survivors": 0}, {"name": "Wood Elf", "count": 21, "survivors": 0}, {"name": "Pegasus", "count": 15, "survivors": 0}, {"name": "Dendroid Guard", "count": 9, "survivors": 0}, {"name": "Unicorn", "count": 6, "survivors": 0}, {"name": "Green Dragon", "count": 3, "survivors": 0}]
1 9 [{"name": "Gnoll", "count": 36, "survivors": 0}, {"name": "Lizardman", "count": 27, "survivors": 0}, {"name": "Serpent Fly", "count": 24, "survivors": 0}, {"name": "Basilisk", "count": 12, "survivors": 0}, {"name": "Gorgon", "count": 9, "survivors": 0}, {"name": "Wyvern", "count": 6, "survivors": 0}, {"name": "Hydra", "count": 3, "survivors": 0}] [{"name": "Imp", "count": 45, "survivors": 0}, {"name": "Gog", "count": 24, "survivors": 21}, {"name": "Hell Hound", "count": 15, "survivors": 0}, {"name": "Demon", "count": 12, "survivors": 0}, {"name": "Pit Fiend", "count": 9, "survivors": 0}, {"name": "Efreeti", "count": 6, "survivors": 0}, {"name": "Devil", "count": 3, "survivors": 2}]
1 9 [{"name": "Imp", "count": 45, "survivors": 0}, {"name": "Gog", "count": 24, "survivors": 7}, {"name": "Hell Hound", "count": 15, "survivors": 0}, {"name": "Demon", "count": 12, "survivors": 0}, {"name": "Pit Fiend", "count": 9, "survivors": 0}, {"name": "Efreeti", "count": 6, "survivors": 0}, {"name": "Devil", "count": 3, "survivors": 3}] [{"name": "Gremlin", "count": 48, "survivors": 0}, {"name": "Stone Gargoyle", "count": 27, "survivors": 0}, {"name": "Stone Golem", "count": 18, "survivors": 0}, {"name": "Mage", "count": 12, "survivors": 0}, {"name": "Genie", "count": 9, "survivors": 0}, {"name": "Naga", "count": 6, "survivors": 0}, {"name": "Giant", "count": 3, "survivors": 0}]
1 9 [{"name": "Skeleton", "count": 36, "survivors": 0}, {"name": "Walking Dead", "count": 24, "survivors": 11}, {"name": "Wight", "count": 21, "survivors": 0}, {"name": "Vampire", "count": 12, "survivors": 0}, {"name": "Lich", "count": 9, "survivors": 9}, {"name": "Black Knight", "count": 6, "survivors": 2}, {"name": "Bone Dragon", "count": 3, "survivors": 0}] [{"name": "Goblin", "count": 45, "survivors": 0}, {"name": "Wolf Rider", "count": 27, "survivors": 0}, {"name": "Orc", "count": 21, "survivors": 0}, {"name": "Ogre", "count": 12, "survivors": 0}, {"name": "Roc", "count": 9, "survivors": 0}, {"name": "Cyclops", "count": 6, "survivors": 0}, {"name": "Behemoth", "count": 3, "survivors": 0}]
1 9 [{"name": "Skeleton", "count": 36, "survivors": 0}, {"name": "Walking Dead", "count": 24, "survivors": 0}, {"name": "Wight", "count": 21, "survivors": 0}, {"name": "Vampire", "count": 12, "survivors": 0}, {"name": "Lich", "count": 9, "survivors": 0}, {"name": "Black Knight", "count": 6, "survivors": 0}, {"name": "Bone Dragon", "count": 3, "survivors": 0}] [{"name": "Gremlin", "count": 48, "survivors": 0}, {"name": "Stone Gargoyle", "count": 27, "survivors": 0}, {"name": "Stone Golem", "count": 18, "survivors": 4}, {"name": "Mage", "count": 12, "survivors": 0}, {"name": "Genie", "count": 9, "survivors": 0}, {"name": "Naga", "count": 6, "survivors": 3}, {"name": "Giant", "count": 3, "survivors": 0}]