IconToAllianceID Mappings/SQL
From EVEDev
The following is a script to add the icon filename suffixes to the alliance table based on the table in IconToAllianceID Mappings.
Usable with CPP Database Dump:
- Tyrannis 1.0.1 build 33641
Usable with Database Engine:
- MySQL 5.0
Please note that the name of the allianceTable was not known to the script creator, you can improve the quality of this article by subtituting it in and removing this note.
ALTER TABLE `allianceTable` ADD COLUMN `icon` varchar(100) CHARACTER SET utf8_general_ci NULL DEFAULT -- update 354 alliances UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='01_02' WHERE `t1`.`AllianceID` = '1974662341' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='01_04' WHERE `t1`.`AllianceID` = '1967302747' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='02_02' WHERE `t1`.`AllianceID` = '1965875958' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='02_03' WHERE `t1`.`AllianceID` = '1962981871' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='02_04' WHERE `t1`.`AllianceID` = '1962870426' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='03_03' WHERE `t1`.`AllianceID` = '1988009450' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='03_02' WHERE `t1`.`AllianceID` = '1962835064' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='03_04' WHERE `t1`.`AllianceID` = '1988009449' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='04_01' WHERE `t1`.`AllianceID` = '1966049571' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='04_02' WHERE `t1`.`AllianceID` = '1963166628' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='04_03' WHERE `t1`.`AllianceID` = '2031941852' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='04_04' WHERE `t1`.`AllianceID` = '1988009451' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='05_01' WHERE `t1`.`AllianceID` = '1962872433' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='05_02' WHERE `t1`.`AllianceID` = '937038506' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='05_03' WHERE `t1`.`AllianceID` = '1439416485' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='05_04' WHERE `t1`.`AllianceID` = '1374837394' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='06_02' WHERE `t1`.`AllianceID` = '1099063355' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='06_03' WHERE `t1`.`AllianceID` = '1041482450' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_01' WHERE `t1`.`AllianceID` = '342755901' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_02' WHERE `t1`.`AllianceID` = '1026886508' UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_03' WHERE `t1`.`AllianceID` = '1220922756'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_04' WHERE `t1`.`AllianceID` = '1259365112'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_01' WHERE `t1`.`AllianceID` = '537119222'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_02' WHERE `t1`.`AllianceID` = '995013977'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_03' WHERE `t1`.`AllianceID` = '239739827'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_04' WHERE `t1`.`AllianceID` = '414616857'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='09_02' WHERE `t1`.`AllianceID` = '173739862'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='09_03' WHERE `t1`.`AllianceID` = '1441788490'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_01' WHERE `t1`.`AllianceID` = '978733650'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_02' WHERE `t1`.`AllianceID` = '264952485'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_03' WHERE `t1`.`AllianceID` = '373024435'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_04' WHERE `t1`.`AllianceID` = '521381722'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_01' WHERE `t1`.`AllianceID` = '157368852'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_02' WHERE `t1`.`AllianceID` = '628083666'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_03' WHERE `t1`.`AllianceID` = '881159574'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_04' WHERE `t1`.`AllianceID` = '937904219'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_01' WHERE `t1`.`AllianceID` = '755412150'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_02' WHERE `t1`.`AllianceID` = '898521033'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_03' WHERE `t1`.`AllianceID` = '894206965'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_04' WHERE `t1`.`AllianceID` = '893275782'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_01' WHERE `t1`.`AllianceID` = '741557221'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_02' WHERE `t1`.`AllianceID` = '327815755'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_03' WHERE `t1`.`AllianceID` = '295773986'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_01' WHERE `t1`.`AllianceID` = '937099054'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_02' WHERE `t1`.`AllianceID` = '618162213'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_03' WHERE `t1`.`AllianceID` = '613888047'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_04' WHERE `t1`.`AllianceID` = '632866070'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_01' WHERE `t1`.`AllianceID` = '790581431'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_02' WHERE `t1`.`AllianceID` = '701459600'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_03' WHERE `t1`.`AllianceID` = '900209169'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_04' WHERE `t1`.`AllianceID` = '898789246'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_01' WHERE `t1`.`AllianceID` = '759477551'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_02' WHERE `t1`.`AllianceID` = '1327233264'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_03' WHERE `t1`.`AllianceID` = '794831862'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_04' WHERE `t1`.`AllianceID` = '735932392'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_01' WHERE `t1`.`AllianceID` = '830660878'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_02' WHERE `t1`.`AllianceID` = '922541302'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_03' WHERE `t1`.`AllianceID` = '845358580'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_04' WHERE `t1`.`AllianceID` = '830476259'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_01' WHERE `t1`.`AllianceID` = '294099361'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_02' WHERE `t1`.`AllianceID` = '225947254'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_03' WHERE `t1`.`AllianceID` = '873672554'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_04' WHERE `t1`.`AllianceID` = '820673945'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_01' WHERE `t1`.`AllianceID` = '780843225'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_02' WHERE `t1`.`AllianceID` = '693547580'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_03' WHERE `t1`.`AllianceID` = '521550159'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_04' WHERE `t1`.`AllianceID` = '980676917'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_01' WHERE `t1`.`AllianceID` = '819637246'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_02' WHERE `t1`.`AllianceID` = '851986092'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_03' WHERE `t1`.`AllianceID` = '68685221'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_04' WHERE `t1`.`AllianceID` = '657191413'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_01' WHERE `t1`.`AllianceID` = '628991027'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_02' WHERE `t1`.`AllianceID` = '916366622'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_03' WHERE `t1`.`AllianceID` = '709354881'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_04' WHERE `t1`.`AllianceID` = '902819350'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_01' WHERE `t1`.`AllianceID` = '680656525'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_02' WHERE `t1`.`AllianceID` = '280458946'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_03' WHERE `t1`.`AllianceID` = '651394709'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_04' WHERE `t1`.`AllianceID` = '228932850'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_01' WHERE `t1`.`AllianceID` = '166439722'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_02' WHERE `t1`.`AllianceID` = '824518128'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_03' WHERE `t1`.`AllianceID` = '939383666'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_04' WHERE `t1`.`AllianceID` = '764328405'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_02' WHERE `t1`.`AllianceID` = '853118644'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_03' WHERE `t1`.`AllianceID` = '133380850'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_04' WHERE `t1`.`AllianceID` = '970258311'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_01' WHERE `t1`.`AllianceID` = '719152641'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_02' WHERE `t1`.`AllianceID` = '630715029'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_03' WHERE `t1`.`AllianceID` = '101400224'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_04' WHERE `t1`.`AllianceID` = '227106310'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_01' WHERE `t1`.`AllianceID` = '734409701'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_02' WHERE `t1`.`AllianceID` = '162958353'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_03' WHERE `t1`.`AllianceID` = '230415007'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_04' WHERE `t1`.`AllianceID` = '861668420'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_01' WHERE `t1`.`AllianceID` = '134442284'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_02' WHERE `t1`.`AllianceID` = '185649283'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_03' WHERE `t1`.`AllianceID` = '348908787'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_04' WHERE `t1`.`AllianceID` = '210997485'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_02' WHERE `t1`.`AllianceID` = '409364568'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_03' WHERE `t1`.`AllianceID` = '670047585'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_04' WHERE `t1`.`AllianceID` = '113001540'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_01' WHERE `t1`.`AllianceID` = '952720760'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_02' WHERE `t1`.`AllianceID` = '846017099'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_03' WHERE `t1`.`AllianceID` = '650545116'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_04' WHERE `t1`.`AllianceID` = '567099488'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_01' WHERE `t1`.`AllianceID` = '614102619'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_02' WHERE `t1`.`AllianceID` = '211088879'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_03' WHERE `t1`.`AllianceID` = '240835459'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_04' WHERE `t1`.`AllianceID` = '347057845'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_01' WHERE `t1`.`AllianceID` = '118499027'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_02' WHERE `t1`.`AllianceID` = '443039986'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_03' WHERE `t1`.`AllianceID` = '243562438'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_04' WHERE `t1`.`AllianceID` = '488282414'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_01' WHERE `t1`.`AllianceID` = '119175035'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_02' WHERE `t1`.`AllianceID` = '935962111'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_03' WHERE `t1`.`AllianceID` = '1081180970'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_04' WHERE `t1`.`AllianceID` = '647194493'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_01' WHERE `t1`.`AllianceID` = '309570220'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_02' WHERE `t1`.`AllianceID` = '829299188'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_03' WHERE `t1`.`AllianceID` = '826025559'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_04' WHERE `t1`.`AllianceID` = '213401527'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_01' WHERE `t1`.`AllianceID` = '838011673'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_02' WHERE `t1`.`AllianceID` = '937872513'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_03' WHERE `t1`.`AllianceID` = '389924442'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_04' WHERE `t1`.`AllianceID` = '927767240'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_01' WHERE `t1`.`AllianceID` = '581956272'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_02' WHERE `t1`.`AllianceID` = '716050598'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_03' WHERE `t1`.`AllianceID` = '102441019'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_04' WHERE `t1`.`AllianceID` = '487868936'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_01' WHERE `t1`.`AllianceID` = '891616204'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_02' WHERE `t1`.`AllianceID` = '822746991'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_03' WHERE `t1`.`AllianceID` = '217728874'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_04' WHERE `t1`.`AllianceID` = '204298938'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_01' WHERE `t1`.`AllianceID` = '1178366869'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_02' WHERE `t1`.`AllianceID` = '1281684917'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_03' WHERE `t1`.`AllianceID` = '283331937'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_04' WHERE `t1`.`AllianceID` = '107660664'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_01' WHERE `t1`.`AllianceID` = '202628879'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_02' WHERE `t1`.`AllianceID` = '689376961'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_03' WHERE `t1`.`AllianceID` = '129639137'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_04' WHERE `t1`.`AllianceID` = '662918705'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_01' WHERE `t1`.`AllianceID` = '927094775'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_02' WHERE `t1`.`AllianceID` = '902819350'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_03' WHERE `t1`.`AllianceID` = '159826257'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_04' WHERE `t1`.`AllianceID` = '348978562'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_01' WHERE `t1`.`AllianceID` = '1657456469'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_02' WHERE `t1`.`AllianceID` = '1617353742'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_03' WHERE `t1`.`AllianceID` = '1474035720'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_04' WHERE `t1`.`AllianceID` = '1171357902'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_01' WHERE `t1`.`AllianceID` = '419865710'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_02' WHERE `t1`.`AllianceID` = '979280912'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_03' WHERE `t1`.`AllianceID` = '424172891'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_04' WHERE `t1`.`AllianceID` = '670303846'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_01' WHERE `t1`.`AllianceID` = '973532707'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_02' WHERE `t1`.`AllianceID` = '386292982'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_03' WHERE `t1`.`AllianceID` = '427019530'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_04' WHERE `t1`.`AllianceID` = '942594614'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_01' WHERE `t1`.`AllianceID` = '1439278447'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_02' WHERE `t1`.`AllianceID` = '305786028'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_03' WHERE `t1`.`AllianceID` = '361595181'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_04' WHERE `t1`.`AllianceID` = '655846070'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_01' WHERE `t1`.`AllianceID` = '1731851374'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_02' WHERE `t1`.`AllianceID` = '364303645'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_03' WHERE `t1`.`AllianceID` = '897877797'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_04' WHERE `t1`.`AllianceID` = '444203333'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_01' WHERE `t1`.`AllianceID` = '1733643802'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_02' WHERE `t1`.`AllianceID` = '287387070'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_03' WHERE `t1`.`AllianceID` = '1538108032'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_04' WHERE `t1`.`AllianceID` = '1334228324'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_01' WHERE `t1`.`AllianceID` = '562804261'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_02' WHERE `t1`.`AllianceID` = '136013311'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_03' WHERE `t1`.`AllianceID` = '1305592065'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_04' WHERE `t1`.`AllianceID` = '1778250850'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_01' WHERE `t1`.`AllianceID` = '1326438017'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_02' WHERE `t1`.`AllianceID` = '500912361'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_03' WHERE `t1`.`AllianceID` = '344549974'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_04' WHERE `t1`.`AllianceID` = '1633825631'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_01' WHERE `t1`.`AllianceID` = '693829445'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_02' WHERE `t1`.`AllianceID` = '1617262222'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_03' WHERE `t1`.`AllianceID` = '273254349'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_04' WHERE `t1`.`AllianceID` = '268264129'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_01' WHERE `t1`.`AllianceID` = '812396591'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_02' WHERE `t1`.`AllianceID` = '1399057309'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_03' WHERE `t1`.`AllianceID` = '1510350889'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_04' WHERE `t1`.`AllianceID` = '176358229'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_01' WHERE `t1`.`AllianceID` = '1259761645'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_02' WHERE `t1`.`AllianceID` = '915114162'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_03' WHERE `t1`.`AllianceID` = '714390465'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_04' WHERE `t1`.`AllianceID` = '664511700'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_01' WHERE `t1`.`AllianceID` = '933731581'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_02' WHERE `t1`.`AllianceID` = '1218667238'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_03' WHERE `t1`.`AllianceID` = '1333213624'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_04' WHERE `t1`.`AllianceID` = '585089448'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_01' WHERE `t1`.`AllianceID` = '985451579'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_02' WHERE `t1`.`AllianceID` = '982284363'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_03' WHERE `t1`.`AllianceID` = '485127066'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_04' WHERE `t1`.`AllianceID` = '702036928'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_01' WHERE `t1`.`AllianceID` = '1231017993'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_02' WHERE `t1`.`AllianceID` = '494403294'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_03' WHERE `t1`.`AllianceID` = '227446060'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_04' WHERE `t1`.`AllianceID` = '581933217'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_01' WHERE `t1`.`AllianceID` = '1492453355'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_03' WHERE `t1`.`AllianceID` = '588312332'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_04' WHERE `t1`.`AllianceID` = '145834652'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_01' WHERE `t1`.`AllianceID` = '748398192'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_02' WHERE `t1`.`AllianceID` = '605296635'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_03' WHERE `t1`.`AllianceID` = '923562637'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_04' WHERE `t1`.`AllianceID` = '1436568627'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_01' WHERE `t1`.`AllianceID` = '709173242'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_02' WHERE `t1`.`AllianceID` = '921274069'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_03' WHERE `t1`.`AllianceID` = '161789084'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_04' WHERE `t1`.`AllianceID` = '248309546'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_01' WHERE `t1`.`AllianceID` = '288377808'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_02' WHERE `t1`.`AllianceID` = '1358408357'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_03' WHERE `t1`.`AllianceID` = '154532576'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_04' WHERE `t1`.`AllianceID` = '872127712'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_01' WHERE `t1`.`AllianceID` = '306798858'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_02' WHERE `t1`.`AllianceID` = '729078756'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_03' WHERE `t1`.`AllianceID` = '223369706'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_04' WHERE `t1`.`AllianceID` = '1083654693'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_01' WHERE `t1`.`AllianceID` = '275725590'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_02' WHERE `t1`.`AllianceID` = '831252438'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_03' WHERE `t1`.`AllianceID` = '284278305'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_04' WHERE `t1`.`AllianceID` = '917526329'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_01' WHERE `t1`.`AllianceID` = '1471767458'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_02' WHERE `t1`.`AllianceID` = '1236486154'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_03' WHERE `t1`.`AllianceID` = '1470696988'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_04' WHERE `t1`.`AllianceID` = '628280874'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_01' WHERE `t1`.`AllianceID` = '1695410410'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_02' WHERE `t1`.`AllianceID` = '961848448'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_03' WHERE `t1`.`AllianceID` = '1003067784'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_04' WHERE `t1`.`AllianceID` = '682915307'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_01' WHERE `t1`.`AllianceID` = '630969519'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_02' WHERE `t1`.`AllianceID` = '330639100'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_03' WHERE `t1`.`AllianceID` = '156756939'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_04' WHERE `t1`.`AllianceID` = '843638752'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_01' WHERE `t1`.`AllianceID` = '1015092638'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_02' WHERE `t1`.`AllianceID` = '1114190180'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_03' WHERE `t1`.`AllianceID` = '1040376220'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_04' WHERE `t1`.`AllianceID` = '496431473'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_01' WHERE `t1`.`AllianceID` = '1206229240'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_02' WHERE `t1`.`AllianceID` = '959524143'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_03' WHERE `t1`.`AllianceID` = '596408142'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_04' WHERE `t1`.`AllianceID` = '607835872'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_01' WHERE `t1`.`AllianceID` = '1325294000'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_02' WHERE `t1`.`AllianceID` = '1438160193'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_04' WHERE `t1`.`AllianceID` = '1598600949'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_01' WHERE `t1`.`AllianceID` = '384524280'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_02' WHERE `t1`.`AllianceID` = '979339647'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_03' WHERE `t1`.`AllianceID` = '1793821574'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_04' WHERE `t1`.`AllianceID` = '1184264779'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_01' WHERE `t1`.`AllianceID` = '320774832'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_02' WHERE `t1`.`AllianceID` = '1324392282'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_03' WHERE `t1`.`AllianceID` = '878866718'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_04' WHERE `t1`.`AllianceID` = '1813726532'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_01' WHERE `t1`.`AllianceID` = '845224486'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_02' WHERE `t1`.`AllianceID` = '655616830'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_03' WHERE `t1`.`AllianceID` = '704856874'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_04' WHERE `t1`.`AllianceID` = '613493214'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_01' WHERE `t1`.`AllianceID` = '817618922'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_02' WHERE `t1`.`AllianceID` = '969494429'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_03' WHERE `t1`.`AllianceID` = '313987070'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_04' WHERE `t1`.`AllianceID` = '166924340'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_01' WHERE `t1`.`AllianceID` = '151380924'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_02' WHERE `t1`.`AllianceID` = '1353656102'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_03' WHERE `t1`.`AllianceID` = '1206021109'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_04' WHERE `t1`.`AllianceID` = '1653863703'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_01' WHERE `t1`.`AllianceID` = '1302181348'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_02' WHERE `t1`.`AllianceID` = '1173986008'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_03' WHERE `t1`.`AllianceID` = '905407070'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_04' WHERE `t1`.`AllianceID` = '715032274'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_01' WHERE `t1`.`AllianceID` = '614765194'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_02' WHERE `t1`.`AllianceID` = '586234421'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_03' WHERE `t1`.`AllianceID` = '455411710'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_04' WHERE `t1`.`AllianceID` = '1254379905'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_01' WHERE `t1`.`AllianceID` = '1309030271'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_02' WHERE `t1`.`AllianceID` = '306798858'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_03' WHERE `t1`.`AllianceID` = '1402003305'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_04' WHERE `t1`.`AllianceID` = '1097355312'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_01' WHERE `t1`.`AllianceID` = '1433868460'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_02' WHERE `t1`.`AllianceID` = '1104449696'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_03' WHERE `t1`.`AllianceID` = '448511760'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_04' WHERE `t1`.`AllianceID` = '1260627398'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_01' WHERE `t1`.`AllianceID` = '999297753'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_02' WHERE `t1`.`AllianceID` = '1161017884'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_03' WHERE `t1`.`AllianceID` = '1583356798'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_04' WHERE `t1`.`AllianceID` = '294930214'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_01' WHERE `t1`.`AllianceID` = '580611538'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_02' WHERE `t1`.`AllianceID` = '673817002'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_03' WHERE `t1`.`AllianceID` = '1136157539'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_04' WHERE `t1`.`AllianceID` = '1490024253'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_01' WHERE `t1`.`AllianceID` = '1453523683'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_02' WHERE `t1`.`AllianceID` = '659333041'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_03' WHERE `t1`.`AllianceID` = '686603391'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_04' WHERE `t1`.`AllianceID` = '911652170'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_01' WHERE `t1`.`AllianceID` = '532949740'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_02' WHERE `t1`.`AllianceID` = '1499311634'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_03' WHERE `t1`.`AllianceID` = '1480700727'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_04' WHERE `t1`.`AllianceID` = '166924340'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_02' WHERE `t1`.`AllianceID` = '896695182'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_03' WHERE `t1`.`AllianceID` = '833571739'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_04' WHERE `t1`.`AllianceID` = '437579728'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_01' WHERE `t1`.`AllianceID` = '1087160562'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_02' WHERE `t1`.`AllianceID` = '1538382401'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_03' WHERE `t1`.`AllianceID` = '1685237465'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_04' WHERE `t1`.`AllianceID` = '861898608'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_01' WHERE `t1`.`AllianceID` = '264679431'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_03' WHERE `t1`.`AllianceID` = '1007323374'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_04' WHERE `t1`.`AllianceID` = '849565342'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_01' WHERE `t1`.`AllianceID` = '1294094452'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_02' WHERE `t1`.`AllianceID` = '608839271'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_03' WHERE `t1`.`AllianceID` = '1550724751'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_04' WHERE `t1`.`AllianceID` = '1987964414'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_01' WHERE `t1`.`AllianceID` = '855555544'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_02' WHERE `t1`.`AllianceID` = '1610350138'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_04' WHERE `t1`.`AllianceID` = '1798720604'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='84_04' WHERE `t1`.`AllianceID` = '703129312'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_01' WHERE `t1`.`AllianceID` = '505495351'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_03' WHERE `t1`.`AllianceID` = '1045152576'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_04' WHERE `t1`.`AllianceID` = '1658767552'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_01' WHERE `t1`.`AllianceID` = '215451578'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_02' WHERE `t1`.`AllianceID` = '1323245561'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_03' WHERE `t1`.`AllianceID` = '1393073050'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_01' WHERE `t1`.`AllianceID` = '1854757882'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_02' WHERE `t1`.`AllianceID` = '1960982151'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_03' WHERE `t1`.`AllianceID` = '1315108737'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_04' WHERE `t1`.`AllianceID` = '1012079455'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_01' WHERE `t1`.`AllianceID` = '1411711376'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_02' WHERE `t1`.`AllianceID` = '675031356'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_03' WHERE `t1`.`AllianceID` = '1489655626'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_04' WHERE `t1`.`AllianceID` = '349521578'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_01' WHERE `t1`.`AllianceID` = '1609780791'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_02' WHERE `t1`.`AllianceID` = '418808473'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_03' WHERE `t1`.`AllianceID` = '1913014423'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_04' WHERE `t1`.`AllianceID` = '1671078301'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_01' WHERE `t1`.`AllianceID` = '1980649055'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_02' WHERE `t1`.`AllianceID` = '1096087041'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_03' WHERE `t1`.`AllianceID` = '1482692012'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_04' WHERE `t1`.`AllianceID` = '1179747074'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_01' WHERE `t1`.`AllianceID` = '1397356346'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_02' WHERE `t1`.`AllianceID` = '1210620300'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_03' WHERE `t1`.`AllianceID` = '1620533655'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_04' WHERE `t1`.`AllianceID` = '581235492'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_01' WHERE `t1`.`AllianceID` = '1568020072'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_02' WHERE `t1`.`AllianceID` = '828884805'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_03' WHERE `t1`.`AllianceID` = '1875292563'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_04' WHERE `t1`.`AllianceID` = '1212162615'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_01' WHERE `t1`.`AllianceID` = '1494254776'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_02' WHERE `t1`.`AllianceID` = '723015129'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_03' WHERE `t1`.`AllianceID` = '204800686'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_04' WHERE `t1`.`AllianceID` = '1854195496'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_01' WHERE `t1`.`AllianceID` = '892861216'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_02' WHERE `t1`.`AllianceID` = '1484395853'; UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_03' WHERE `t1`.`AllianceID` = '2068015105';
