SELECT town0_.id AS id1_7_0_, town0_.bank AS bank2_7_0_, town0_.color AS color3_7_0_, town0_.description AS descript4_7_0_, town0_.freelyJoinable AS freelyJo5_7_0_, town0_.leader_id AS leader_13_7_0_, town0_.maxSize AS maxSize6_7_0_, town0_.motd AS motd7_7_0_, town0_.name AS name8_7_0_, town0_.nation_id AS nation_14_7_0_, town0_.pvpEnabled AS pvpEnabl9_7_0_, town0_.spawn AS spawn10_7_0_, town0_.version AS version11_7_0_, town0_.world AS world12_7_0_, resident1_.id AS id1_5_1_, resident1_.lastLogin AS lastLogi2_5_1_, resident1_.name AS name3_5_1_, resident1_.registeredOn AS register4_5_1_, resident1_.town_id AS town_id6_5_1_, resident1_.version AS version5_5_1_, friends2_.resident_id AS resident1_6_2_, resident3_.id AS friend_i2_6_2_, resident3_.id AS id1_5_3_, resident3_.lastLogin AS lastLogi2_5_3_, resident3_.name AS name3_5_3_, resident3_.registeredOn AS register4_5_3_, resident3_.town_id AS town_id6_5_3_, resident3_.version AS version5_5_3_, town4_.id AS id1_7_4_, town4_.bank AS bank2_7_4_, town4_.color AS color3_7_4_, town4_.description AS descript4_7_4_, town4_.freelyJoinable AS freelyJo5_7_4_, town4_.leader_id AS leader_13_7_4_, town4_.maxSize AS maxSize6_7_4_, town4_.motd AS motd7_7_4_, town4_.name AS name8_7_4_, town4_.nation_id AS nation_14_7_4_, town4_.pvpEnabled AS pvpEnabl9_7_4_, town4_.spawn AS spawn10_7_4_, town4_.version AS version11_7_4_, town4_.world AS world12_7_4_, nation5_.id AS id1_0_5_, nation5_.bank AS bank2_0_5_, nation5_.capital_id AS capital_8_0_5_, nation5_.description AS descript3_0_5_, nation5_.freelyJoinable AS freelyJo4_0_5_, nation5_.leader_id AS leader_i9_0_5_, nation5_.name AS name5_0_5_, nation5_.tax AS tax6_0_5_, nation5_.version AS version7_0_5_, allies6_.nation_id AS nation_i1_1_6_, nation7_.id AS ally_nat2_1_6_, nation7_.id AS id1_0_7_, nation7_.bank AS bank2_0_7_, nation7_.capital_id AS capital_8_0_7_, nation7_.description AS descript3_0_7_, nation7_.freelyJoinable AS freelyJo4_0_7_, nation7_.leader_id AS leader_i9_0_7_, nation7_.name AS name5_0_7_, nation7_.tax AS tax6_0_7_, nation7_.version AS version7_0_7_, town8_.id AS id1_7_8_, town8_.bank AS bank2_7_8_, town8_.color AS color3_7_8_, town8_.description AS descript4_7_8_, town8_.freelyJoinable AS freelyJo5_7_8_, town8_.leader_id AS leader_13_7_8_, town8_.maxSize AS maxSize6_7_8_, town8_.motd AS motd7_7_8_, town8_.name AS name8_7_8_, town8_.nation_id AS nation_14_7_8_, town8_.pvpEnabled AS pvpEnabl9_7_8_, town8_.spawn AS spawn10_7_8_, town8_.version AS version11_7_8_, town8_.world AS world12_7_8_, enemies9_.nation_id AS nation_i1_2_9_, nation10_.id AS enemy_na2_2_9_, nation10_.id AS id1_0_10_, nation10_.bank AS bank2_0_10_, nation10_.capital_id AS capital_8_0_10_, nation10_.description AS descript3_0_10_, nation10_.freelyJoinable AS freelyJo4_0_10_, nation10_.leader_id AS leader_i9_0_10_, nation10_.name AS name5_0_10_, nation10_.tax AS tax6_0_10_, nation10_.version AS version7_0_10_, resident11_.id AS id1_5_11_, resident11_.lastLogin AS lastLogi2_5_11_, resident11_.name AS name3_5_11_, resident11_.registeredOn AS register4_5_11_, resident11_.town_id AS town_id6_5_11_, resident11_.version AS version5_5_11_ FROM atherys.Town town0_ left outer join atherys.Resident resident1_ ON town0_.leader_id=resident1_.id left outer join atherys.resident_friends friends2_ ON resident1_.id=friends2_.resident_id left outer join atherys.Resident resident3_ ON friends2_.friend_id=resident3_.id left outer join atherys.Town town4_ ON resident3_.town_id=town4_.id left outer join atherys.Nation nation5_ ON town4_.nation_id=nation5_.id left outer join atherys.nation_allies allies6_ ON nation5_.id=allies6_.nation_id left outer join atherys.Nation nation7_ ON allies6_.ally_nation_id=nation7_.id left outer join atherys.Town town8_ ON nation7_.capital_id=town8_.id left outer join atherys.nation_enemies enemies9_ ON nation7_.id=enemies9_.nation_id left outer join atherys.Nation nation10_ ON enemies9_.enemy_nation_id=nation10_.id left outer join atherys.Resident resident11_ ON nation10_.leader_id=resident11_.id WHERE town0_.id=?