- Dank erhalten: 0
Fehler bei der Komponenten-Installation.
-
Autor
- Neues Mitglied
-
Weniger
Mehr
11 Jahre 10 Monate her - 11 Jahre 10 Monate her #6727
von
Fehler bei der Komponenten-Installation. wurde erstellt von
Hallo, ich wollte gerade mal kurz vor Saisonstart die Komponente aktualieseren und plötzlich kommt die Fehlermeldung.
==> "Fehler bei der Komponenten-Installation"
Vor diesem Update hatte ich die JoomLeague v2.0.54.-diddipoeler.
Im zweiten Schritt habe ich alles was mit Joomleague unter Joomla war deinstalliert und dann das Komplettpaket von github.com/diddipoeler/joomleague-2-komplettpaket versucht zu installieren und dann diese Fehlermeldung siehe im Spoiler.
Hier die Fehlermeldung in Org.
==> "Fehler bei der Komponenten-Installation"
Vor diesem Update hatte ich die JoomLeague v2.0.54.-diddipoeler.
Im zweiten Schritt habe ich alles was mit Joomleague unter Joomla war deinstalliert und dann das Komplettpaket von github.com/diddipoeler/joomleague-2-komplettpaket versucht zu installieren und dann diese Fehlermeldung siehe im Spoiler.
Hier die Fehlermeldung in Org.
Warnung: Spoiler!
JInstaller: :Install: SQL-Fehler DB-Funktion mit Fehlercode 1062 fehlgeschlagen!
Duplicate entry 'AFGHANISTAN__ISLAMIC_REPUBLIC-AFG' for key 'name' SQL=-- -- Daten für Tabelle `XYZ1_joomleague_countries` -- INSERT INTO `XYZ1_joomleague_countries` (`id`, `name`, `alpha2`, `alpha3`, `ordering`, `checked_out`, `checked_out_time`, `itu`, `fips`, `ioc`, `picture`, `fifa`, `ds`, `wmo`) VALUES (NULL, 'AFGHANISTAN__ISLAMIC_REPUBLIC', 'AF', 'AFG', 0, 0, '0000-00-00 00:00:00', 'AFG', 'AF', 'AFG', 'images/com_joomleague/database/flags/af.png', 'AFG', 'AFG', 'AF'), (NULL, 'ALAND_ISLANDS', 'AX', 'ALA', 0, 0, '0000-00-00 00:00:00', '', '', '', 'images/com_joomleague/database/flags/ax.png', 'ALD', 'FIN', ''), (NULL, 'ALBANIA__REPUBLIC_OF', 'AL', 'ALB', 0, 0, '0000-00-00 00:00:00', 'ALB', 'AL', 'ALB', 'images/com_joomleague/database/flags/al.png', 'ALB', 'AL', 'AB'), (NULL, 'ALGERIA__PEOPLE_S_DEMOCRATIC_REPUBLIC', 'DZ', 'DZA', 0, 0, '0000-00-00 00:00:00', 'ALG', 'AG', 'ALG', 'images/com_joomleague/database/flags/dz.png', 'ALG', 'DZ', 'AL'), (NULL, 'AMERICAN_SAMOA', 'AS', 'ASM', 0, 0, '0000-00-00 00:00:00', 'SMA', 'AQ', 'ASA', 'images/com_joomleague/database/flags/as.png', 'ASA', 'USA', ''), (NULL, 'ANDORRA__PRINCIPALITY_OF', 'AD', 'AND', 0, 0, '0000-00-00 00:00:00', 'AND', 'AN', 'AND', 'images/com_joomleague/database/flags/ad.png', 'AND', 'AND', ''), (NULL, 'ANGOLA__REPUBLIC_OF', 'AO', 'AGO', 0, 0, '0000-00-00 00:00:00', 'AGL', 'AO', 'ANG', 'images/com_joomleague/database/flags/ao.png', 'ANG', '', 'AN'), (NULL, 'ANGUILLA', 'AI', 'AIA', 0, 0, '0000-00-00 00:00:00', 'AIA', 'AV', 'AIA', 'images/com_joomleague/database/flags/ai.png', 'AIA', '', ''), (NULL, 'ANTARCTICA__THE TERRITORY SOUT', 'AQ', 'ATA', 0, 0, '0000-00-00 00:00:00', '', 'AY', '', 'images/com_joomleague/database/flags/aq.png', 'ROS', '', 'AA'), (NULL, 'ANTIGUA_AND_BARBUDA', 'AG', 'ATG', 0, 0, '0000-00-00 00:00:00', 'ATG', 'AC', 'ANT', 'images/com_joomleague/database/flags/ag.png', 'ATG', '', 'AT'), (NULL, 'ARGENTINA__ARGENTINE_REPUBLIC', 'AR', 'ARG', 0, 0, '0000-00-00 00:00:00', 'ARG', 'AR', 'ARG', 'images/com_joomleague/database/flags/ar.png', 'ARG', 'RA', 'AG'), (NULL, 'ARMENIA__REPUBLIC_OF', 'AM', 'ARM', 0, 0, '0000-00-00 00:00:00', 'ARM', 'AM', 'ARM', 'images/com_joomleague/database/flags/am.png', 'ARM', 'AM', 'AY'), (NULL, 'ARUBA', 'AW', 'ABW', 0, 0, '0000-00-00 00:00:00', 'ABW', 'AA', 'ARU', 'images/com_joomleague/database/flags/aw.png', 'ARU', '', 'NU'), (NULL, 'AUSTRALIA__COMMONWEALTH_OF', 'AU', 'AUS', 0, 0, '0000-00-00 00:00:00', 'AUS', 'AS', 'AUS', 'images/com_joomleague/database/flags/au.png', 'AUS', 'AUS', 'AU'), (NULL, 'AUSTRIA__REPUBLIC_OF', 'AT', 'AUT', 0, 0, '0000-00-00 00:00:00', 'AUT', 'AU', 'AUT', 'images/com_joomleague/database/flags/at.png', 'AUT', 'A', 'OS'), (NULL, 'AZERBAIJAN__REPUBLIC_OF', 'AZ', 'AZE', 0, 0, '0000-00-00 00:00:00', 'AZE', 'AJ', 'AZE', 'images/com_joomleague/database/flags/az.png', 'AZE', 'AZ', 'AJ'), (NULL, 'BAHAMAS__COMMONWEALTH_OF_THE', 'BS', 'BHS', 0, 0, '0000-00-00 00:00:00', 'BAH', 'BF', 'BAH', 'images/com_joomleague/database/flags/bs.png', 'BAH', 'BS', 'BA'), (NULL, 'BAHRAIN__KINGDOM_OF', 'BH', 'BHR', 0, 0, '0000-00-00 00:00:00', 'BHR', 'BA', 'BRN', 'images/com_joomleague/database/flags/bh.png', 'BHR', 'BRN', 'BN'), (NULL, 'BANGLADESH__PEOPLE_S_REPUBLIC', 'BD', 'BGD', 0, 0, '0000-00-00 00:00:00', 'BGD', 'BG', 'BAN', 'images/com_joomleague/database/flags/bd.png', 'BAN', 'BD', 'BW'), (NULL, 'BARBADOS', 'BB', 'BRB', 0, 0, '0000-00-00 00:00:00', 'BRB', 'BB', 'BAR', 'images/com_joomleague/database/flags/bb.png', 'BRB', 'BDS', 'BR'), (NULL, 'BELARUS__REPUBLIC_OF', 'BY', 'BLR', 0, 0, '0000-00-00 00:00:00', 'BLR', 'BO', 'BLR', 'images/com_joomleague/database/flags/by.png', 'BLR', 'BY', 'BY'), (NULL, 'BELGIUM__KINGDOM_OF', 'BE', 'BEL', 0, 0, '0000-00-00 00:00:00', 'BEL', 'BE', 'BEL', 'images/com_joomleague/database/flags/be.png', 'BEL', 'B', 'BX'), (NULL, 'BELIZE', 'BZ', 'BLZ', 0, 0, '0000-00-00 00:00:00', 'BLZ', 'BH', 'BIZ', 'images/com_joomleague/database/flags/bz.png', 'BLZ', 'BZ', 'BH'), (NULL, 'BENIN_REPUBLIC_OF', 'BJ', 'BEN', 0, 0, '0000-00-00 00:00:00', 'BEN', 'BN', 'BEN', 'images/com_joomleague/database/flags/bj.png', 'BEN', 'DY', 'BJ'), (NULL, 'BERMUDA', 'BM', 'BMU', 0, 0, '0000-00-00 00:00:00', 'BER', 'BD', 'BER', 'images/com_joomleague/database/flags/bm.png', 'BER', '', 'BE'), (NULL, 'BHUTAN_KINGDOM_OF', 'BT', 'BTN', 0, 0, '0000-00-00 00:00:00', 'BTN', 'BT', 'BHU', 'images/com_joomleague/database/flags/bt.png', 'BHU', '', ''), (NULL, 'BOLIVIA__REPUBLIC_OF', 'BO', 'BOL', 0, 0, '0000-00-00 00:00:00', 'BOL', 'BL', 'BOL', 'images/com_joomleague/database/flags/bo.png', 'BOL', 'BOL', 'BO'), (NULL, 'BONAIRE__SINT_EUSTATIUS_AND_SABA', 'BQ', 'BES', 0, 0, '0000-00-00 00:00:00', 'ATN', 'NL', 'AHO', 'images/com_joomleague/database/flags/bq.png', 'ANT', 'NA', 'NU'), (NULL, 'BOSNIA_AND_HERZEGOVINA', 'BA', 'BIH', 0, 0, '0000-00-00 00:00:00', 'BIH', 'BK', 'BIH', 'images/com_joomleague/database/flags/ba.png', 'BIH', 'BIH', 'BG'), (NULL, 'BOTSWANA__REPUBLIC_OF', 'BW', 'BWA', 0, 0, '0000-00-00 00:00:00', 'BOT', 'BC', 'BOT', 'images/com_joomleague/database/flags/bw.png', 'BOT', 'BW', 'BC'), (NULL, 'BOUVET_ISLAND__BOUVETOYA_', 'BV', 'BVT', 0, 0, '0000-00-00 00:00:00', '', 'BV', '', 'images/com_joomleague/database/flags/bv.png', '', '', 'BV'), (NULL, 'BRAZIL__FEDERATIVE_REPUBLIC_OF', 'BR', 'BRA', 0, 0, '0000-00-00 00:00:00', 'B', 'BR', 'BRA', 'images/com_joomleague/database/flags/br.png', 'BRA', 'BR', 'BZ'), (NULL, 'BRITISH_INDIAN_OCEAN_TERRITORY', 'IO', 'IOT', 0, 0, '0000-00-00 00:00:00', 'BIO', 'IO', '', 'images/com_joomleague/database/flags/io.png', '', '', ''), (NULL, 'BRUNEI_DARUSSALAM', 'BN', 'BRN', 0, 0, '0000-00-00 00:00:00', 'BRU', 'BX', 'BRU', 'images/com_joomleague/database/flags/bn.png', 'BRU', 'BRU', 'BD'), (NULL, 'BULGARIA__REPUBLIC_OF', 'BG', 'BGR', 0, 0, '0000-00-00 00:00:00', 'BUL', 'BU', 'BUL', 'images/com_joomleague/database/flags/bg.png', 'BUL', 'BG', 'BU'), (NULL, 'BURKINA_FASO', 'BF', 'BFA', 0, 0, '0000-00-00 00:00:00', 'BFA', 'UV', 'BUR', 'images/com_joomleague/database/flags/bf.png', 'BFA', 'BF', 'HV'), (NULL, 'BURUNDI__REPUBLIC_OF', 'BI', 'BDI', 0, 0, '0000-00-00 00:00:00', 'BDI', 'BY', 'BDI', 'images/com_joomleague/database/flags/bi.png', 'BDI', 'RU', 'BI'), (NULL, 'CAMBODIA__KINGDOM_OF', 'KH', 'KHM', 0, 0, '0000-00-00 00:00:00', 'CBG', 'CB', 'CAM', 'images/com_joomleague/database/flags/kh.png', 'CAM', 'K', 'KP'), (NULL, 'CAMEROON__REPUBLIC_OF', 'CM', 'CMR', 0, 0, '0000-00-00 00:00:00', 'CME', 'CM', 'CMR', 'images/com_joomleague/database/flags/cm.png', 'CMR', 'CAM', 'CM'), (NULL, 'CANADA', 'CA', 'CAN', 0, 0, '0000-00-00 00:00:00', 'CAN', 'CA', 'CAN', 'images/com_joomleague/database/flags/ca.png', 'CAN', 'CDN', 'CN'), (NULL, 'CAPE_VERDE__REPUBLIC_OF', 'CV', 'CPV', 0, 0, '0000-00-00 00:00:00', 'CPV', 'CV', 'CPV', 'images/com_joomleague/database/flags/cv.png', 'CPV', '', 'CV'), (NULL, 'CAYMAN_ISLANDS', 'KY', 'CYM', 0, 0, '0000-00-00 00:00:00', 'CYM', 'CJ', 'CAY', 'images/com_joomleague/database/flags/ky.png', 'CAY', '', 'GC'), (NULL, 'CENTRAL_AFRICAN_REPUBLIC', 'CF', 'CAF', 0, 0, '0000-00-00 00:00:00', 'CAF', 'CT', 'CAF', 'images/com_joomleague/database/flags/cf.png', 'CTA', 'RCA', 'CE'), (NULL, 'CHAD__REPUBLIC_OF', 'TD', 'TCD', 0, 0, '0000-00-00 00:00:00', 'TCD', 'CD', 'CHA', 'images/com_joomleague/database/flags/td.png', 'CHA', 'TCH', 'CD'), (NULL, 'CHILE__REPUBLIC_OF', 'CL', 'CHL', 0, 0, '0000-00-00 00:00:00', 'CHL', 'CI', 'CHI', 'images/com_joomleague/database/flags/cl.png', 'CHI', 'RCH', 'CH'), (NULL, 'CHINA__PEOPLE_S_REPUBLIC_OF', 'CN', 'CHN', 0, 0, '0000-00-00 00:00:00', 'CHN', 'CH', 'CHN', 'images/com_joomleague/database/flags/cn.png', 'CHN', '', 'CI'), (NULL, 'CHRISTMAS_ISLAND', 'CX', 'CXR', 0, 0, '0000-00-00 00:00:00', 'CHR', 'KT', '', 'images/com_joomleague/database/flags/cx.png', 'CXR', 'AUS', 'KI'), (NULL, 'COCOS__KEELING__ISLANDS', 'CC', 'CCK', 0, 0, '0000-00-00 00:00:00', 'ICO', 'CK', '', 'images/com_joomleague/database/flags/cc.png', 'CCK', 'AUS', 'KK'), (NULL, 'COLOMBIA__REPUBLIC_OF', 'CO', 'COL', 0, 0, '0000-00-00 00:00:00', 'CLM', 'CO', 'COL', 'images/com_joomleague/database/flags/co.png', 'COL', 'CO', 'CO'), (NULL, 'COMOROS__UNION_OF_THE', 'KM', 'COM', 0, 0, '0000-00-00 00:00:00', 'COM', 'CN', 'COM', 'images/com_joomleague/database/flags/km.png', 'COM', '', 'IC'), (NULL, 'CONGO__REPUBLIC_OF_THE', 'CG', 'COG', 0, 0, '0000-00-00 00:00:00', 'COG', 'CF', 'CGO', 'images/com_joomleague/database/flags/cg.png', 'CGO', 'RCB', 'CG'), (NULL, 'CONGO__DEMOCRATIC_REPUBLIC_OF', 'CD', 'COD', 0, 0, '0000-00-00 00:00:00', 'COD', 'CG', 'COD', 'images/com_joomleague/database/flags/cd.png', 'COD', 'ZRE', 'ZR'), (NULL, 'COOK_ISLANDS', 'CK', 'COK', 0, 0, '0000-00-00 00:00:00', 'CKH', 'CW', 'COK', 'images/com_joomleague/database/flags/ck.png', 'COK', 'NZ', 'KU'), (NULL, 'COSTA_RICA__REPUBLIC_OF', 'CR', 'CRI', 0, 0, '0000-00-00 00:00:00', 'CTR', 'CS', 'CRC', 'images/com_joomleague/database/flags/cr.png', 'CRC', 'CR', 'CS'), (NULL, 'COTE_D_IVOIRE__REPUBLIC_OF', 'CI', 'CIV', 0, 0, '0000-00-00 00:00:00', 'CTI', 'IV', 'CIV', 'images/com_joomleague/database/flags/ci.png', 'CIV', 'CI', 'IV'), (NULL, 'CROATIA__REPUBLIC_OF', 'HR', 'HRV', 0, 0, '0000-00-00 00:00:00', 'HRV', 'HR', 'CRO', 'images/com_joomleague/database/flags/hr.png', 'CRO', 'HR', 'RH'), (NULL, 'CUBA__REPUBLIC_OF', 'CU', 'CUB', 0, 0, '0000-00-00 00:00:00', 'CUB', 'CU', 'CUB', 'images/com_joomleague/database/flags/cu.png', 'CUB', 'C', 'CU'), (NULL, 'CURACAO', 'CW', 'CUW', 0, 0, '0000-00-00 00:00:00', '', 'UC', '', 'images/com_joomleague/database/flags/cw.png', '', '', ''), (NULL, 'CYPRUS__REPUBLIC_OF', 'CY', 'CYP', 0, 0, '0000-00-00 00:00:00', 'CYP', 'CY', 'CYP', 'images/com_joomleague/database/flags/cy.png', 'CYP', 'CY', 'CY'), (NULL, 'CZECH_REPUBLIC', 'CZ', 'CZE', 0, 0, '0000-00-00 00:00:00', 'CZE', 'EZ', 'CZE', 'images/com_joomleague/database/flags/cz.png', 'CZE', 'CZ', 'CZ'), (NULL, 'DENMARK__KINGDOM_OF', 'DK', 'DNK', 0, 0, '0000-00-00 00:00:00', 'DNK', 'DA', 'DEN', 'images/com_joomleague/database/flags/dk.png', 'DEN', 'DK', 'DN'), (NULL, 'DJIBOUTI__REPUBLIC_OF', 'DJ', 'DJI', 0, 0, '0000-00-00 00:00:00', 'DJI', 'DJ', 'DJI', 'images/com_joomleague/database/flags/dj.png', 'DJI', '', 'DJ'), (NULL, 'DOMINICA__COMMONWEALTH_OF', 'DM', 'DMA', 0, 0, '0000-00-00 00:00:00', 'DMA', 'DO', 'DMA', 'images/com_joomleague/database/flags/dm.png', 'DMA', 'WD', 'DO'), (NULL, 'DOMINICAN_REPUBLIC', 'DO', 'DOM', 0, 0, '0000-00-00 00:00:00', 'DOM', 'DR', 'DOM', 'images/com_joomleague/database/flags/do.png', 'DOM', 'DOM', 'DR'), (NULL, 'ECUADOR__REPUBLIC_OF', 'EC', 'ECU', 0, 0, '0000-00-00 00:00:00', 'EQA', 'EC', 'ECU', 'images/com_joomleague/database/flags/ec.png', 'ECU', 'EC', 'EQ'), (NULL, 'EGYPT__ARAB_REPUBLIC_OF', 'EG', 'EGY', 0, 0, '0000-00-00 00:00:00', 'EGY', 'EG', 'EGY', 'images/com_joomleague/database/flags/eg.png', 'EGY', 'ET', 'EG'), (NULL, 'EL_SALVADOR__REPUBLIC_OF', 'SV', 'SLV', 0, 0, '0000-00-00 00:00:00', 'SLV', 'ES', 'ESA', 'images/com_joomleague/database/flags/sv.png', 'SLV', 'ES', 'ES'), (NULL, 'EQUATORIAL_GUINEA__REPUBLIC_OF', 'GQ', 'GNQ', 0, 0, '0000-00-00 00:00:00', 'GNE', 'EK', 'GEQ', 'images/com_joomleague/database/flags/gq.png', 'EQG', '', 'GQ'), (NULL, 'ERITREA__STATE_OF', 'ER', 'ERI', 0, 0, '0000-00-00 00:00:00', 'ERI', 'ER', 'ERI', 'images/com_joomleague/database/flags/er.png', 'ERI', '', ''), (NULL, 'ESTONIA__REPUBLIC_OF', 'EE', 'EST', 0, 0, '0000-00-00 00:00:00', 'EST', 'EN', 'EST', 'images/com_joomleague/database/flags/ee.png', 'EST', 'EST', 'EO'), (NULL, 'ETHIOPIA__FEDERAL_DEMOCRATIC_R', 'ET', 'ETH', 0, 0, '0000-00-00 00:00:00', 'ETH', 'ET', 'ETH', 'images/com_joomleague/database/flags/et.png', 'ETH', 'ETH', 'ET'), (NULL, 'FALKLAND_ISLANDS__MALVINAS_', 'FK', 'FLK', 0, 0, '0000-00-00 00:00:00', 'FLK', 'FK', 'FLK', 'images/com_joomleague/database/flags/fk.png', 'FLK', '', 'FK'), (NULL, 'FAROE_ISLANDS', 'FO', 'FRO', 0, 0, '0000-00-00 00:00:00', 'FRO', 'FO', 'FAR', 'images/com_joomleague/database/flags/fo.png', 'FRO', 'FO', 'FA'), (NULL, 'FIJI__REPUBLIC_OF_THE_FIJI_ISL', 'FJ', 'FJI', 0, 0, '0000-00-00 00:00:00', 'FJI', 'FJ', 'FIJ', 'images/com_joomleague/database/flags/fj.png', 'FIJ', 'FJI', 'FJ'), (NULL, 'FINLAND__REPUBLIC_OF', 'FI', 'FIN', 0, 0, '0000-00-00 00:00:00', 'FIN', 'FI', 'FIN', 'images/com_joomleague/database/flags/fi.png', 'FIN', 'FIN', 'FI'), (NULL, 'FRANCE__FRENCH_REPUBLIC', 'FR', 'FRA', 0, 0, '0000-00-00 00:00:00', 'F', 'FR', 'FRA', 'images/com_joomleague/database/flags/fr.png', 'FRA', 'F', 'FR'), (NULL, 'FRENCH_GUIANA', 'GF', 'GUF', 0, 0, '0000-00-00 00:00:00', 'GUF', 'FG', 'FGU', 'images/com_joomleague/database/flags/gf.png', 'GUF', 'F', 'FG'), (NULL, 'FRENCH_POLYNESIA', 'PF', 'PYF', 0, 0, '0000-00-00 00:00:00', 'OCE', 'FP', 'FPO', 'images/com_joomleague/database/flags/pf.png', 'TAH', 'F', 'PF'), (NULL, 'FRENCH_SOUTHERN_TERRITORIES', 'TF', 'ATF', 0, 0, '0000-00-00 00:00:00', '', 'FS', '', 'images/com_joomleague/database/flags/tf.png', '', 'F', ''), (NULL, 'GABON__GABONESE_REPUBLIC', 'GA', 'GAB', 0, 0, '0000-00-00 00:00:00', 'GAB', 'GB', 'GAB', 'images/com_joomleague/database/flags/ga.png', 'GAB', 'G', 'GO'), (NULL, 'GAMBIA__REPUBLIC_OF_THE', 'GM', 'GMB', 0, 0, '0000-00-00 00:00:00', 'GMB', 'GA', 'GAM', 'images/com_joomleague/database/flags/gm.png', 'GAM', 'WAG', 'GB'), (NULL, 'GEORGIA', 'GE', 'GEO', 0, 0, '0000-00-00 00:00:00', 'GEO', 'GG', 'GEO', 'images/com_joomleague/database/flags/ge.png', 'GEO', 'GE', 'GG'), (NULL, 'GERMANY__FEDERAL_REPUBLIC_OF', 'DE', 'DEU', 0, 0, '0000-00-00 00:00:00', 'D', 'GM', 'GER', 'images/com_joomleague/database/flags/de.png', 'GER', 'D', 'DL'), (NULL, 'GHANA__REPUBLIC_OF', 'GH', 'GHA', 0, 0, '0000-00-00 00:00:00', 'GHA', 'GH', 'GHA', 'images/com_joomleague/database/flags/gh.png', 'GHA', 'GH', 'GH'), (NULL, 'GIBRALTAR', 'GI', 'GIB', 0, 0, '0000-00-00 00:00:00', 'GIB', 'GI', 'GIB', 'images/com_joomleague/database/flags/gi.png', 'GBZ', 'GBZ', 'GI'), (NULL, 'GREECE__HELLENIC_REPUBLIC', 'GR', 'GRC', 0, 0, '0000-00-00 00:00:00', 'GRC', 'GR', 'GRE', 'images/com_joomleague/database/flags/gr.png', 'GRE', 'GR', 'GR'), (NULL, 'GREENLAND', 'GL', 'GRL', 0, 0, '0000-00-00 00:00:00', 'GRL', 'GL', 'GRL', 'images/com_joomleague/database/flags/gl.png', 'GRL', 'DK', 'GL'), (NULL, 'GRENADA', 'GD', 'GRD', 0, 0, '0000-00-00 00:00:00', 'GRD', 'GJ', 'GRN', 'images/com_joomleague/database/flags/gd.png', 'GRN', 'WG', 'GD'), (NULL, 'GUADELOUPE', 'GP', 'GLP', 0, 0, '0000-00-00 00:00:00', 'GDL', 'GP', 'GUD', 'images/com_joomleague/database/flags/gp.png', 'GLP', 'F', 'MF'), (NULL, 'GUAM', 'GU', 'GUM', 0, 0, '0000-00-00 00:00:00', 'GUM', 'GQ', 'GUM', 'images/com_joomleague/database/flags/gu.png', 'GUM', 'USA', 'GM'), (NULL, 'GUATEMALA__REPUBLIC_OF', 'GT', 'GTM', 0, 0, '0000-00-00 00:00:00', 'GTM', 'GT', 'GUA', 'images/com_joomleague/database/flags/gt.png', 'GUA', 'GCA', 'GU'), (NULL, 'GUERNSEY__BAILIWICK_OF', 'GG', 'GGY', 0, 0, '0000-00-00 00:00:00', '', 'GK', '', 'images/com_joomleague/database/flags/gg.png', 'GBG', 'GBG', ''), (NULL, 'GUINEA__REPUBLIC_OF', 'GN', 'GIN', 0, 0, '0000-00-00 00:00:00', 'GUI', 'GV', 'GUI', 'images/com_joomleague/database/flags/gn.png', 'GUI', 'RG', 'GN'), (NULL, 'GUINEA-BISSAU__REPUBLIC_OF', 'GW', 'GNB', 0, 0, '0000-00-00 00:00:00', 'GNB', 'PU', 'GBS', 'images/com_joomleague/database/flags/gw.png', 'GNB', '', 'GW'), (NULL, 'GUYANA__CO-OPERATIVE_REPUBLIC', 'GY', 'GUY', 0, 0, '0000-00-00 00:00:00', 'GUY', 'GY', 'GUY', 'images/com_joomleague/database/flags/gy.png', 'GUY', 'GUY', 'GY'), (NULL, 'HAITI__REPUBLIC_OF', 'HT', 'HTI', 0, 0, '0000-00-00 00:00:00', 'HTI', 'HA', 'HAI', 'images/com_joomleague/database/flags/ht.png', 'HAI', 'RH', 'HA'), (NULL, 'HEARD_ISLAND_AND_MCDONALD_ISLA', 'HM', 'HMD', 0, 0, '0000-00-00 00:00:00', '', 'HM', '', 'images/com_joomleague/database/flags/hm.png', '', 'AUS', ''), (NULL, 'HONDURAS__REPUBLIC_OF', 'HN', 'HND', 0, 0, '0000-00-00 00:00:00', 'HND', 'HO', 'HON', 'images/com_joomleague/database/flags/hn.png', 'HON', '', 'HO'), (NULL, 'HONG KONG__SPECIAL_ADMINISTRAT', 'HK', 'HKG', 0, 0, '0000-00-00 00:00:00', 'HKG', 'HK', 'HKG', 'images/com_joomleague/database/flags/hk.png', 'HKG', 'HK', 'HK'), (NULL, 'HUNGARY__REPUBLIC_OF', 'HU', 'HUN', 0, 0, '0000-00-00 00:00:00', 'HNG', 'HU', 'HUN', 'images/com_joomleague/database/flags/hu.png', 'HUN', 'H', 'HU'), (NULL, 'ICELAND__REPUBLIC_OF', 'IS', 'ISL', 0, 0, '0000-00-00 00:00:00', 'ISL', 'IC', 'ISL', 'images/com_joomleague/database/flags/is.png', 'ISL', 'IS', 'IL'), (NULL, 'INDIA__REPUBLIC_OF', 'IN', 'IND', 0, 0, '0000-00-00 00:00:00', 'IND', 'IN', 'IND', 'images/com_joomleague/database/flags/in.png', 'IND', 'IND', 'IN'), (NULL, 'INDONESIA__REPUBLIC_OF', 'ID', 'IDN', 0, 0, '0000-00-00 00:00:00', 'INS', 'ID', 'INA', 'images/com_joomleague/database/flags/id.png', 'IDN', 'RI', 'ID'), (NULL, 'IRAN__ISLAMIC_REPUBLIC_OF', 'IR', 'IRN', 0, 0, '0000-00-00 00:00:00', 'IRN', 'IR', 'IRI', 'images/com_joomleague/database/flags/ir.png', 'IRN', 'IR', 'IR'), (NULL, 'IRAQ__REPUBLIC_OF', 'IQ', 'IRQ', 0, 0, '0000-00-00 00:00:00', 'IRQ', 'IZ', 'IRQ', 'images/com_joomleague/database/flags/iq.png', 'IRQ', 'IRQ', 'IQ'), (NULL, 'IRELAND', 'IE', 'IRL', 0, 0, '0000-00-00 00:00:00', 'IRL', 'EI', 'IRL', 'images/com_joomleague/database/flags/ie.png', 'IRL', 'IRL', 'IE'), (NULL, 'ISLE_OF_MAN', 'IM', 'IMN', 0, 0, '0000-00-00 00:00:00', '', 'IM', '', 'images/com_joomleague/database/flags/im.png', 'GBM', 'GBM', ''), (NULL, 'ISRAEL__STATE_OF', 'IL', 'ISR', 0, 0, '0000-00-00 00:00:00', 'ISR', 'IS', 'ISR', 'images/com_joomleague/database/flags/il.png', 'ISR', 'IL', 'IS'), (NULL, 'ITALY__ITALIAN_REPUBLIC', 'IT', 'ITA', 0, 0, '0000-00-00 00:00:00', 'I', 'IT', 'ITA', 'images/com_joomleague/database/flags/it.png', 'ITA', 'I', 'IY'), (NULL, 'JAMAICA', 'JM', 'JAM', 0, 0, '0000-00-00 00:00:00', 'JMC', 'JM', 'JAM', 'images/com_joomleague/database/flags/jm.png', 'JAM', 'JA', 'JM'), (NULL, 'JAPAN', 'JP', 'JPN', 0, 0, '0000-00-00 00:00:00', 'J', 'JA', 'JPN', 'images/com_joomleague/database/flags/jp.png', 'JPN', 'J', 'JP'), (NULL, 'JERSEY__BAILIWICK_OF', 'JE', 'JEY', 0, 0, '0000-00-00 00:00:00', '', 'JE', '', 'images/com_joomleague/database/flags/je.png', 'GBJ', 'GBJ', ''), (NULL, 'JORDAN__HASHEMITE_KINGDOM_OF', 'JO', 'JOR', 0, 0, '0000-00-00 00:00:00', 'JOR', 'JO', 'JOR', 'images/com_joomleague/database/flags/jo.png', 'JOR', 'HKJ', 'JD'), (NULL, 'KAZAKHSTAN__REPUBLIC_OF', 'KZ', 'KAZ', 0, 0, '0000-00-00 00:00:00', 'KAZ', 'KZ', 'KAZ', 'images/com_joomleague/database/flags/kz.png', 'KAZ', 'KZ', 'KZ'), (NULL, 'KENYA__REPUBLIC_OF', 'KE', 'KEN', 0, 0, '0000-00-00 00:00:00', 'KEN', 'KE', 'KEN', 'images/com_joomleague/database/flags/ke.png', 'KEN', 'EAK', 'KN'), (NULL, 'KIRIBATI__REPUBLIC_OF', 'KI', 'KIR', 0, 0, '0000-00-00 00:00:00', 'KIR', 'KR', 'KIR', 'images/com_joomleague/database/flags/ki.png', 'KIR', '', 'KB'), (NULL, 'KOREA__DEMOCRATIC_PEOPLE_S_REP', 'KP', 'PRK', 0, 0, '0000-00-00 00:00:00', 'KRE', 'KN', 'PRK', 'images/com_joomleague/database/flags/kp.png', 'PRK', '', 'KR'), (NULL, 'KOREA__REPUBLIC_OF', 'KR', 'KOR', 0, 0, '0000-00-00 00:00:00', 'KOR', 'KS', 'KOR', 'images/com_joomleague/database/flags/kr.png', 'KOR', 'ROK', 'KO'), (NULL, 'KUWAIT__STATE_OF', 'KW', 'KWT', 0, 0, '0000-00-00 00:00:00', 'KWT', 'KU', 'KUW', 'images/com_joomleague/database/flags/kw.png', 'KUW', 'KWT', 'KW'), (NULL, 'KYRGYZ_REPUBLIC', 'KG', 'KGZ', 0, 0, '0000-00-00 00:00:00', 'KGZ', 'KG', 'KGZ', 'images/com_joomleague/database/flags/kg.png', 'KGZ', 'KS', 'KG'), (NULL, 'LAO_PEOPLE_S_DEMOCRATIC_REPUBL', 'LA', 'LAO', 0, 0, '0000-00-00 00:00:00', 'LAO', 'LA', 'LAO', 'images/com_joomleague/database/flags/la.png', 'LAO', 'LAO', 'LA'), (NULL, 'LATVIA__REPUBLIC_OF', 'LV', 'LVA', 0, 0, '0000-00-00 00:00:00', 'LVA', 'LG', 'LAT', 'images/com_joomleague/database/flags/lv.png', 'LVA', 'LV', 'LV'), (NULL, 'LEBANON__LEBANESE_REPUBLIC', 'LB', 'LBN', 0, 0, '0000-00-00 00:00:00', 'LBN', 'LE', 'LIB', 'images/com_joomleague/database/flags/lb.png', 'LIB', 'RL', 'LB'), (NULL, 'LESOTHO__KINGDOM_OF', 'LS', 'LSO', 0, 0, '0000-00-00 00:00:00', 'LSO', 'LT', 'LES', 'images/com_joomleague/database/flags/ls.png', 'LES', 'LS', 'LS'), (NULL, 'LIBERIA__REPUBLIC_OF', 'LR', 'LBR', 0, 0, '0000-00-00 00:00:00', 'LBR', 'LI', 'LBR', 'images/com_joomleague/database/flags/lr.png', 'LBR', 'LB', 'LI'), (NULL, 'LIBYAN_ARAB_JAMAHIRIYA', 'LY', 'LBY', 0, 0, '0000-00-00 00:00:00', 'LBY', 'LY', 'LBA', 'images/com_joomleague/database/flags/ly.png', 'LBY', 'LAR', 'LY'), (NULL, 'LIECHTENSTEIN__PRINCIPALITY_OF', 'LI', 'LIE', 0, 0, '0000-00-00 00:00:00', 'LIE', 'LS', 'LIE', 'images/com_joomleague/database/flags/li.png', 'LIE', 'FL', ''), (NULL, 'LITHUANIA__REPUBLIC_OF', 'LT', 'LTU', 0, 0, '0000-00-00 00:00:00', 'LTU', 'LH', 'LTU', 'images/com_joomleague/database/flags/lt.png', 'LTU', 'LT', 'LT'), (NULL, 'LUXEMBOURG__GRAND_DUCHY_OF', 'LU', 'LUX', 0, 0, '0000-00-00 00:00:00', 'LUX', 'LU', 'LUX', 'images/com_joomleague/database/flags/lu.png', 'LUX', 'L', 'BX'), (NULL, 'MACAO__SPECIAL_ADMINISTRATIVE', 'MO', 'MAC', 0, 0, '0000-00-00 00:00:00', 'MAC', 'MC', 'MAC', 'images/com_joomleague/database/flags/mo.png', 'MAC', '', 'MU'), (NULL, 'MACEDONIA__THE_FORMER_YUGOSLAV', 'MK', 'MKD', 0, 0, '0000-00-00 00:00:00', 'MKD', 'MK', 'MKD', 'images/com_joomleague/database/flags/mk.png', 'MKD', 'MK', 'MJ'), (NULL, 'MADAGASCAR__REPUBLIC_OF', 'MG', 'MDG', 0, 0, '0000-00-00 00:00:00', 'MDG', 'MA', 'MAD', 'images/com_joomleague/database/flags/mg.png', 'MAD', 'RM', 'MG'), (NULL, 'MALAWI__REPUBLIC_OF', 'MW', 'MWI', 0, 0, '0000-00-00 00:00:00', 'MWI', 'MI', 'MAW', 'images/com_joomleague/database/flags/mw.png', 'MWI', 'MW', 'MW'), (NULL, 'MALAYSIA', 'MY', 'MYS', 0, 0, '0000-00-00 00:00:00', 'MLA', 'MY', 'MAS', 'images/com_joomleague/database/flags/my.png', 'MAS', 'MAL', 'MS'), (NULL, 'MALDIVES__REPUBLIC_OF', 'MV', 'MDV', 0, 0, '0000-00-00 00:00:00', 'MLD', 'MV', 'MDV', 'images/com_joomleague/database/flags/mv.png', 'MDV', '', 'MV'), (NULL, 'MALI__REPUBLIC_OF', 'ML', 'MLI', 0, 0, '0000-00-00 00:00:00', 'MLI', 'ML', 'MLI', 'images/com_joomleague/database/flags/ml.png', 'MLI', 'RMM', 'MI'), (NULL, 'MALTA__REPUBLIC_OF', 'MT', 'MLT', 0, 0, '0000-00-00 00:00:00', 'MLT', 'MT', 'MLT', 'images/com_joomleague/database/flags/mt.png', 'MLT', 'M', 'ML'), (NULL, 'MARSHALL_ISLANDS__REPUBLIC_OF', 'MH', 'MHL', 0, 0, '0000-00-00 00:00:00', 'MHL', 'RM', 'MSH', 'images/com_joomleague/database/flags/mh.png', 'MHL', '', 'MH'), (NULL, 'MARTINIQUE', 'MQ', 'MTQ', 0, 0, '0000-00-00 00:00:00', 'MRT', 'MB', 'MRT', 'images/com_joomleague/database/flags/mq.png', 'MTQ', 'F', 'MR'), (NULL, 'MAURITANIA__ISLAMIC_REPUBLIC_O', 'MR', 'MRT', 0, 0, '0000-00-00 00:00:00', 'MTN', 'MR', 'MTN', 'images/com_joomleague/database/flags/mr.png', 'MTN', 'RIM', 'MT'), (NULL, 'MAURITIUS__REPUBLIC_OF', 'MU', 'MUS', 0, 0, '0000-00-00 00:00:00', 'MAU', 'MP', 'MRI', 'images/com_joomleague/database/flags/mu.png', 'MRI', 'MS', 'MA'), (NULL, 'MAYOTTE', 'YT', 'MYT', 0, 0, '0000-00-00 00:00:00', 'MYT', 'MF', 'MAY', 'images/com_joomleague/database/flags/yt.png', 'MYT', '', ''), (NULL, 'MEXICO__UNITED_MEXICAN_STATES', 'MX', 'MEX', 0, 0, '0000-00-00 00:00:00', 'MEX', 'MX', 'MEX', 'images/com_joomleague/database/flags/mx.png', 'MEX', 'MEX', 'MX'), (NULL, 'MICRONESIA__FEDERATED_STATES_O', 'FM', 'FSM', 0, 0, '0000-00-00 00:00:00', 'FSM', 'FM', 'FSM', 'images/com_joomleague/database/flags/fm.png', 'FSM', '', ''), (NULL, 'MOLDOVA__REPUBLIC_OF', 'MD', 'MDA', 0, 0, '0000-00-00 00:00:00', 'MDA', 'MD', 'MDA', 'images/com_joomleague/database/flags/md.png', 'MDA', 'MD', 'RM'), (NULL, 'MONACO__PRINCIPALITY_OF', 'MC', 'MCO', 0, 0, '0000-00-00 00:00:00', 'MCO', 'MN', 'MON', 'images/com_joomleague/database/flags/mc.png', 'MON', 'MC', ''), (NULL, 'MONGOLIA', 'MN', 'MNG', 0, 0, '0000-00-00 00:00:00', 'MNG', 'MG', 'MGL', 'images/com_joomleague/database/flags/mn.png', 'MNG', 'MGL', 'MO'), (NULL, 'MONTENEGRO__REPUBLIC_OF', 'ME', 'MNE', 0, 0, '0000-00-00 00:00:00', 'MNE', 'MJ', 'MGO', 'images/com_joomleague/database/flags/me.png', 'MNE', '(NULLSe', ''), (NULL, 'MONTSERRAT', 'MS', 'MSR', 0, 0, '0000-00-00 00:00:00', 'MSR', 'MH', 'MNT', 'images/com_joomleague/database/flags/ms.png', 'MSR', '', ''), (NULL, 'MOROCCO__KINGDOM_OF', 'MA', 'MAR', 0, 0, '0000-00-00 00:00:00', 'MRC', 'MO', 'MAR', 'images/com_joomleague/database/flags/ma.png', 'MAR', 'MA', 'MC'), (NULL, 'MOZAMBIQUE__REPUBLIC_OF', 'MZ', 'MOZ', 0, 0, '0000-00-00 00:00:00', 'MOZ', 'MZ', 'MOZ', 'images/com_joomleague/database/flags/mz.png', 'MOZ', 'MOC', 'MZ'), (NULL, 'MYANMAR__UNION_OF', 'MM', 'MMR', 0, 0, '0000-00-00 00:00:00', 'MYA', 'BM', 'MYA', 'images/com_joomleague/database/flags/mm.png', 'MYA', 'BUR', 'BM'), (NULL, 'NAMIBIA__REPUBLIC_OF', 'NA', 'NAM', 0, 0, '0000-00-00 00:00:00', 'NMB', 'WA', 'NAM', 'images/com_joomleague/database/flags/na.png', 'NAM', 'NAM', 'NM'), (NULL, 'NAURU__REPUBLIC_OF', 'NR', 'NRU', 0, 0, '0000-00-00 00:00:00', 'NRU', 'NR', 'NRU', 'images/com_joomleague/database/flags/nr.png', 'NRU', 'NAU', 'NW'), (NULL, 'NEPAL__STATE_OF', 'NP', 'NPL', 0, 0, '0000-00-00 00:00:00', 'NPL', 'NP', 'NEP', 'images/com_joomleague/database/flags/np.png', 'NEP', 'NEP', 'NP'), (NULL, 'NETHERLANDS__THE', 'NL', 'NLD', 0, 0, '0000-00-00 00:00:00', 'HOL', 'NL', 'NED', 'images/com_joomleague/database/flags/nl.png', 'NED', 'NL', 'NL'), (NULL, 'NEW_CALEDONIA', 'NC', 'NCL', 0, 0, '0000-00-00 00:00:00', 'NCL', 'NC', 'NCD', 'images/com_joomleague/database/flags/nc.png', 'NCL', 'F', 'NC'), (NULL, 'NEW_ZEALAND', 'NZ', 'NZL', 0, 0, '0000-00-00 00:00:00', 'NZL', 'NZ', 'NZL', 'images/com_joomleague/database/flags/nz.png', 'NZL', 'NZ', 'NZ'), (NULL, 'NICARAGUA__REPUBLIC_OF', 'NI', 'NIC', 0, 0, '0000-00-00 00:00:00', 'NCG', 'NU', 'NCA', 'images/com_joomleague/database/flags/ni.png', 'NCA', 'NIC', 'NK'), (NULL, 'NIGER__REPUBLIC_OF', 'NE', 'NER', 0, 0, '0000-00-00 00:00:00', 'NGR', 'NG', 'NIG', 'images/com_joomleague/database/flags/ne.png', 'NIG', 'RN', 'NR'), (NULL, 'NIGERIA__FEDERAL_REPUBLIC_OF', 'NG', 'NGA', 0, 0, '0000-00-00 00:00:00', 'NIG', 'NI', 'NGR', 'images/com_joomleague/database/flags/ng.png', 'NGA', 'NGR', 'NI'), (NULL, 'NIUE', 'NU', 'NIU', 0, 0, '0000-00-00 00:00:00', 'NIU', 'NE', 'NIU', 'images/com_joomleague/database/flags/nu.png', 'NIU', 'NZ', ''), (NULL, 'NORFOLK_ISLAND', 'NF', 'NFK', 0, 0, '0000-00-00 00:00:00', 'NFK', 'NF', 'NFI', 'images/com_joomleague/database/flags/nf.png', 'NFK', 'AUS', 'NF'), (NULL, 'NORTHERN_MARIANA_ISLANDS__COMM', 'MP', 'MNP', 0, 0, '0000-00-00 00:00:00', 'MRA', 'CQ', 'NMA', 'images/com_joomleague/database/flags/mp.png', 'NMI', 'USA', 'MY'), (NULL, 'NORWAY__KINGDOM_OF', 'NO', 'NOR', 0, 0, '0000-00-00 00:00:00', 'NOR', 'NO', 'NOR', 'images/com_joomleague/database/flags/no.png', 'NOR', 'N', 'NO'), (NULL, 'OMAN__SULTANATE_OF', 'OM', 'OMN', 0, 0, '0000-00-00 00:00:00', 'OMA', 'MU', 'OMA', 'images/com_joomleague/database/flags/om.png', 'OMA', '', 'OM'), (NULL, 'PAKISTAN__ISLAMIC_REPUBLIC_OF', 'PK', 'PAK', 0, 0, '0000-00-00 00:00:00', 'PAK', 'PK', 'PAK', 'images/com_joomleague/database/flags/pk.png', 'PAK', 'PK', 'PK'), (NULL, 'PALAU__REPUBLIC_OF', 'PW', 'PLW', 0, 0, '0000-00-00 00:00:00', 'PLW', 'PS', 'PLW', 'images/com_joomleague/database/flags/pw.png', 'PLW', '', ''), (NULL, 'PALESTINIAN_TERRITORY__OCCUPIE', 'PS', 'PSE', 0, 0, '0000-00-00 00:00:00', '', 'GZ', 'PLE', 'images/com_joomleague/database/flags/ps.png', 'PLE', '', ''), (NULL, 'PANAMA__REPUBLIC_OF', 'PA', 'PAN', 0, 0, '0000-00-00 00:00:00', 'PNR', 'PM', 'PAN', 'images/com_joomleague/database/flags/pa.png', 'PAN', 'PA', 'PM'), (NULL, 'PAPUA_NEW_GUINEA__INDEPENDENT', 'PG', 'PNG', 0, 0, '0000-00-00 00:00:00', 'PNG', 'PP', 'PNG', 'images/com_joomleague/database/flags/pg.png', 'PNG', 'PNG', 'NG'), (NULL, 'PARAGUAY__REPUBLIC_OF', 'PY', 'PRY', 0, 0, '0000-00-00 00:00:00', 'PRG', 'PA', 'PAR', 'images/com_joomleague/database/flags/py.png', 'PAR', 'PY', 'PY'), (NULL, 'PERU__REPUBLIC_OF', 'PE', 'PER', 0, 0, '0000-00-00 00:00:00', 'PRU', 'PE', 'PER', 'images/com_joomleague/database/flags/pe.png', 'PER', 'PE', 'PR'), (NULL, 'PHILIPPINES__REPUBLIC_OF_THE', 'PH', 'PHL', 0, 0, '0000-00-00 00:00:00', 'PHL', 'RP', 'PHI', 'images/com_joomleague/database/flags/ph.png', 'PHI', 'RP', 'PH'), (NULL, 'PITCAIRN_ISLANDS', 'PN', 'PCN', 0, 0, '0000-00-00 00:00:00', 'PTC', 'PC', '', 'images/com_joomleague/database/flags/pn.png', 'PCN', '', 'PT'), (NULL, 'POLAND__REPUBLIC_OF', 'PL', 'POL', 0, 0, '0000-00-00 00:00:00', 'POL', 'PL', 'POL', 'images/com_joomleague/database/flags/pl.png', 'POL', 'PL', 'PL'), (NULL, 'PORTUGAL__PORTUGUESE_REPUBLIC', 'PT', 'PRT', 0, 0, '0000-00-00 00:00:00', 'POR', 'PO', 'POR', 'images/com_joomleague/database/flags/pt.png', 'POR', 'P', 'PO'), (NULL, 'PUERTO_RICO__COMMONWEALTH_OF', 'PR', 'PRI', 0, 0, '0000-00-00 00:00:00', 'PTR', 'RQ', 'PUR', 'images/com_joomleague/database/flags/pr.png', 'PUR', 'USA', 'PU'), (NULL, 'QATAR__STATE_OF', 'QA', 'QAT', 0, 0, '0000-00-00 00:00:00', 'QAT', 'QA', 'QAT', 'images/com_joomleague/database/flags/qa.png', 'QAT', 'Q', 'QT'), (NULL, 'REUNION', 'RE', 'REU', 0, 0, '0000-00-00 00:00:00', 'REU', 'RE', 'REU', 'images/com_joomleague/database/flags/re.png', 'REU', 'F', 'RE'), (NULL, 'ROMANIA', 'RO', 'ROU', 0, 0, '0000-00-00 00:00:00', 'ROU', 'RO', 'ROU', 'images/com_joomleague/database/flags/ro.png', 'ROU', 'RO', 'RO'), (NULL, 'RUSSIAN_FEDERATION', 'RU', 'RUS', 0, 0, '0000-00-00 00:00:00', 'RUS', 'RS', 'RUS', 'images/com_joomleague/database/flags/ru.png', 'RUS', 'RUS', 'RS'), (NULL, 'RWANDA__REPUBLIC_OF', 'RW', 'RWA', 0, 0, '0000-00-00 00:00:00', 'RRW', 'RW', 'RWA', 'images/com_joomleague/database/flags/rw.png', 'RWA', 'RWA', 'RW'), (NULL, 'SAINT_BARTHELEMY', 'BL', 'BLM', 0, 0, '0000-00-00 00:00:00', '', 'TB', '', 'images/com_joomleague/database/flags/bl.png', '', '', ''), (NULL, 'SAINT_HELENA', 'SH', 'SHN', 0, 0, '0000-00-00 00:00:00', 'SHN', 'SH', 'HEL', 'images/com_joomleague/database/flags/sh.png', 'SHN', '', 'HE'), (NULL, 'SAINT_KITTS_AND_NEVIS__FEDERAT', 'KN', 'KNA', 0, 0, '0000-00-00 00:00:00', 'KNA', 'SC', 'SKN', 'images/com_joomleague/database/flags/kn.png', 'SKN', '', 'AT'), (NULL, 'SAINT_LUCIA', 'LC', 'LCA', 0, 0, '0000-00-00 00:00:00', 'LCA', 'ST', 'LCA', 'images/com_joomleague/database/flags/lc.png', 'LCA', 'WL', 'LC'), (NULL, 'SAINT_MARTIN', 'MF', 'MAF', 0, 0, '0000-00-00 00:00:00', '', 'RN', '', 'images/com_joomleague/database/flags/mf.png', '', '', ''), (NULL, 'SAINT_PIERRE_AND_MIQUELON', 'PM', 'SPM', 0, 0, '0000-00-00 00:00:00', 'SPM', 'SB', 'SPM', 'images/com_joomleague/database/flags/pm.png', 'SPM', 'F', 'FP'), (NULL, 'SAINT_VINCENT_AND_THE_GRENADIN', 'VC', 'VCT', 0, 0, '0000-00-00 00:00:00', 'VCT', 'VC', 'VIN', 'images/com_joomleague/database/flags/vc.png', 'VIN', 'WV', 'VG'), (NULL, 'SAMOA__INDEPENDENT_STATE_OF', 'WS', 'WSM', 0, 0, '0000-00-00 00:00:00', 'SMO', 'WS', 'SAM', 'images/com_joomleague/database/flags/ws.png', 'SAM', 'WS', 'ZM'), (NULL, 'SAN_MARINO__REPUBLIC_OF', 'SM', 'SMR', 0, 0, '0000-00-00 00:00:00', 'SMR', 'SM', 'SMR', 'images/com_joomleague/database/flags/sm.png', 'SMR', 'RSM', ''), (NULL, 'SAO_TOME_AND_PRINCIPE__DEMOCRA', 'ST', 'STP', 0, 0, '0000-00-00 00:00:00', 'STP', 'TP', 'STP', 'images/com_joomleague/database/flags/st.png', 'STP', '', 'TP'), (NULL, 'SAUDI_ARABIA__KINGDOM_OF', 'SA', 'SAU', 0, 0, '0000-00-00 00:00:00', 'ARS', 'SA', 'KSA', 'images/com_joomleague/database/flags/sa.png', 'KSA', 'SA', 'SD'), (NULL, 'SENEGAL__REPUBLIC_OF', 'SN', 'SEN', 0, 0, '0000-00-00 00:00:00', 'SEN', 'SG', 'SEN', 'images/com_joomleague/database/flags/sn.png', 'SEN', 'SN', 'SG'), (NULL, 'SERBIA__REPUBLIC_OF', 'RS', 'SRB', 0, 0, '0000-00-00 00:00:00', 'SRB', 'RI', 'SRB', 'images/com_joomleague/database/flags/rs.png', 'SRB', 'SCG', 'YG'), (NULL, 'SEYCHELLES__REPUBLIC_OF', 'SC', 'SYC', 0, 0, '0000-00-00 00:00:00', 'SEY', 'SE', 'SEY', 'images/com_joomleague/database/flags/sc.png', 'SEY', 'SY', 'SC'), (NULL, 'SIERRA_LEONE__REPUBLIC_OF', 'SL', 'SLE', 0, 0, '0000-00-00 00:00:00', 'SRL', 'SL', 'SLE', 'images/com_joomleague/database/flags/sl.png', 'SLE', 'WAL', 'SL'), (NULL, 'SINGAPORE__REPUBLIC_OF', 'SG', 'SGP', 0, 0, '0000-00-00 00:00:00', 'SNG', 'SN', 'SIN', 'images/com_joomleague/database/flags/sg.png', 'SIN', 'SGP', 'SR'), (NULL, 'SINT__MAARTEN', 'SX', 'SXM', 0, 0, '0000-00-00 00:00:00', '', 'NN', '', 'images/com_joomleague/database/flags/sx.png', '', '', ''), (NULL, 'SLOVAKIA__SLOVAK REPUBLIC_', 'SK', 'SVK', 0, 0, '0000-00-00 00:00:00', 'SVK', 'LO', 'SVK', 'images/com_joomleague/database/flags/sk.png', 'SVK', 'SK', 'SQ'), (NULL, 'SLOVENIA__REPUBLIC_OF', 'SI', 'SVN', 0, 0, '0000-00-00 00:00:00', 'SVN', 'SI', 'SLO', 'images/com_joomleague/database/flags/si.png', 'SVN', 'SLO', 'LJ'), (NULL, 'SOLOMON_ISLANDS', 'SB', 'SLB', 0, 0, '0000-00-00 00:00:00', 'SLM', 'BP', 'SOL', 'images/com_joomleague/database/flags/sb.png', 'SOL', '', 'SO'), (NULL, 'SOMALIA__SOMALI_REPUBLIC', 'SO', 'SOM', 0, 0, '0000-00-00 00:00:00', 'SOM', 'SO', 'SOM', 'images/com_joomleague/database/flags/so.png', 'SOM', 'SO', 'SI'), (NULL, 'SOUTH_AFRICA__REPUBLIC_OF', 'ZA', 'ZAF', 0, 0, '0000-00-00 00:00:00', 'AFS', 'SF', 'RSA', 'images/com_joomleague/database/flags/za.png', 'RSA', 'ZA', 'ZA'), (NULL, 'SOUTH_GEORGIA_AND_THE_SOUTH_SA', 'GS', 'SGS', 0, 0, '0000-00-00 00:00:00', '', 'SX', '', 'images/com_joomleague/database/flags/gs.png', '', '', ''), (NULL, 'SOUTH__SUDAN', 'SS', 'SSD', 0, 0, '0000-00-00 00:00:00', 'SSD', 'OD', '', 'images/com_joomleague/database/flags/ss.png', '', '', ''), (NULL, 'SPAIN__KINGDOM_OF', 'ES', 'ESP', 0, 0, '0000-00-00 00:00:00', 'E', 'SP', 'ESP', 'images/com_joomleague/database/flags/es.png', 'ESP', 'E', 'SP'), (NULL, 'SRI_LANKA__DEMOCRATIC_SOCIALIS', 'LK', 'LKA', 0, 0, '0000-00-00 00:00:00', 'CLN', 'CE', 'SRI', 'images/com_joomleague/database/flags/lk.png', 'SRI', 'CL', 'SB'), (NULL, 'SUDAN__REPUBLIC_OF', 'SD', 'SDN', 0, 0, '0000-00-00 00:00:00', 'SDN', 'SU', 'SUD', 'images/com_joomleague/database/flags/sd.png', 'SUD', 'SUD', 'SU'), (NULL, 'SURINAME__REPUBLIC_OF', 'SR', 'SUR', 0, 0, '0000-00-00 00:00:00', 'SUR', 'NS', 'SUR', 'images/com_joomleague/database/flags/sr.png', 'SUR', 'SME', 'SM'), (NULL, 'SVALBARD___JAN_MAYEN_ISLANDS', 'SJ', 'SJM', 0, 0, '0000-00-00 00:00:00', 'NOR', 'SV', '', 'images/com_joomleague/database/flags/sj.png', '', '', 'SZ'), (NULL, 'SWAZILAND__KINGDOM_OF', 'SZ', 'SWZ', 0, 0, '0000-00-00 00:00:00', 'SWZ', 'WZ', 'SWZ', 'images/com_joomleague/database/flags/sz.png', 'SWZ', 'SD', 'SV'), (NULL, 'SWEDEN__KINGDOM_OF', 'SE', 'SWE', 0, 0, '0000-00-00 00:00:00', 'S', 'SW', 'SWE', 'images/com_joomleague/database/flags/se.png', 'SWE', 'S', 'SN'), (NULL, 'SWITZERLAND__SWISS_CONFEDERATI', 'CH', 'CHE', 0, 0, '0000-00-00 00:00:00', 'SUI', 'SZ', 'SUI', 'images/com_joomleague/database/flags/ch.png', 'SUI', 'CH', 'SW'), (NULL, 'SYRIAN_ARAB_REPUBLIC', 'SY', 'SYR', 0, 0, '0000-00-00 00:00:00', 'SYR', 'SY', 'SYR', 'images/com_joomleague/database/flags/sy.png', 'SYR', 'SYR', 'SY'), (NULL, 'TAIWAN', 'TW', 'TWN', 0, 0, '0000-00-00 00:00:00', '', 'TW', 'TPE', 'images/com_joomleague/database/flags/tw.png', 'TPE', 'RC', ''), (NULL, 'TAJIKISTAN__REPUBLIC_OF', 'TJ', 'TJK', 0, 0, '0000-00-00 00:00:00', 'TJK', 'TI', 'TJK', 'images/com_joomleague/database/flags/tj.png', 'TJK', 'TJ', 'TA'), (NULL, 'TANZANIA__UNITED_REPUBLIC_OF', 'TZ', 'TZA', 0, 0, '0000-00-00 00:00:00', 'TZA', 'TZ', 'TAN', 'images/com_joomleague/database/flags/tz.png', 'TAN', 'EAT', 'TN'), (NULL, 'THAILAND__KINGDOM_OF', 'TH', 'THA', 0, 0, '0000-00-00 00:00:00', 'THA', 'TH', 'THA', 'images/com_joomleague/database/flags/th.png', 'THA', 'T', 'TH'), (NULL, 'TIMOR-LESTE_DEMOCRATIC_REPUBL', 'TL', 'TLS', 0, 0, '0000-00-00 00:00:00', 'TLS', 'TT', 'TLS', 'images/com_joomleague/database/flags/tl.png', 'TLS', '', 'TM'), (NULL, 'TOGO__TOGOLESE_REPUBLIC', 'TG', 'TGO', 0, 0, '0000-00-00 00:00:00', 'TGO', 'TO', 'TOG', 'images/com_joomleague/database/flags/tg.png', 'TOG', 'TG', 'TG'), (NULL, 'TOKELAU', 'TK', 'TKL', 0, 0, '0000-00-00 00:00:00', 'TKL', 'TL', '', 'images/com_joomleague/database/flags/tk.png', 'TKL', 'NZ', 'TK'), (NULL, 'TONGA__KINGDOM_OF', 'TO', 'TON', 0, 0, '0000-00-00 00:00:00', 'TON', 'TN', 'TGA', 'images/com_joomleague/database/flags/to.png', 'TGA', '', 'TO'), (NULL, 'TRINIDAD_AND_TOBAGO__REPUBLIC', 'TT', 'TTO', 0, 0, '0000-00-00 00:00:00', 'TRD', 'TD', 'TRI', 'images/com_joomleague/database/flags/tt.png', 'TRI', 'TT', 'TD'), (NULL, 'TUNISIA__TUNISIAN_REPUBLIC', 'TN', 'TUN', 0, 0, '0000-00-00 00:00:00', 'TUN', 'TS', 'TUN', 'images/com_joomleague/database/flags/tn.png', 'TUN', 'TN', 'TS'), (NULL, 'TURKEY__REPUBLIC_OF', 'TR', 'TUR', 0, 0, '0000-00-00 00:00:00', 'TUR', 'TU', 'TUR', 'images/com_joomleague/database/flags/tr.png', 'TUR', 'TR', 'TU'), (NULL, 'TURKMENISTAN', 'TM', 'TKM', 0, 0, '0000-00-00 00:00:00', 'TKM', 'TX', 'TKM', 'images/com_joomleague/database/flags/tm.png', 'TKM', 'TM', 'TR'), (NULL, 'TURKS_AND_CAICOS_ISLANDS', 'TC', 'TCA', 0, 0, '0000-00-00 00:00:00', 'TCA', 'TK', 'TKS', 'images/com_joomleague/database/flags/tc.png', 'TCA', '', 'TI'), (NULL, 'TUVALU', 'TV', 'TUV', 0, 0, '0000-00-00 00:00:00', 'TUV', 'TV', 'TUV', 'images/com_joomleague/database/flags/tv.png', 'TUV', '', 'TV'), (NULL, 'UGANDA__REPUBLIC_OF', 'UG', 'UGA', 0, 0, '0000-00-00 00:00:00', 'UGA', 'UG', 'UGA', 'images/com_joomleague/database/flags/ug.png', 'UGA', 'EAU', 'UG'), (NULL, 'UKRAINE', 'UA', 'UKR', 0, 0, '0000-00-00 00:00:00', 'UKR', 'UP', 'UKR', 'images/com_joomleague/database/flags/ua.png', 'UKR', 'UA', 'UR'), (NULL, 'UNITED_ARAB_EMIRATES', 'AE', 'ARE', 0, 0, '0000-00-00 00:00:00', 'UAE', 'AE', 'UAE', 'images/com_joomleague/database/flags/ae.png', 'UAE', '', 'ER'), (NULL, 'UNITED_KINGDOM_OF_GREAT_BRITAIN', 'GB', 'GBR', 0, 0, '0000-00-00 00:00:00', 'G', 'UK', 'GBR', 'images/com_joomleague/database/flags/gb.png', '', 'GB', 'UK'), (NULL, 'UNITED_STATES_MINOR_OUTLYING_I', 'UM', 'UMI', 0, 0, '0000-00-00 00:00:00', '', 'a', '', 'images/com_joomleague/database/flags/um.png', '', 'USA', ''), (NULL, 'UNITED_STATES_OF_AMERICA', 'US', 'USA', 0, 0, '0000-00-00 00:00:00', 'USA', 'US', 'USA', 'images/com_joomleague/database/flags/us.png', 'USA', 'USA', 'US'), (NULL, 'URUGUAY__EASTERN_REPUBLIC_OF', 'UY', 'URY', 0, 0, '0000-00-00 00:00:00', 'URG', 'UY', 'URU', 'images/com_joomleague/database/flags/uy.png', 'URU', 'ROU', 'UY'), (NULL, 'UZBEKISTAN__REPUBLIC_OF', 'UZ', 'UZB', 0, 0, '0000-00-00 00:00:00', 'UZB', 'UZ', 'UZB', 'images/com_joomleague/database/flags/uz.png', 'UZB', 'UZ', 'UZ'), (NULL, 'VANUATU__REPUBLIC_OF', 'VU', 'VUT', 0, 0, '0000-00-00 00:00:00', 'VUT', 'NH', 'VAN', 'images/com_joomleague/database/flags/vu.png', 'VAN', '', 'NV'), (NULL, 'HOLY_SEE__VATICAN_CITY_STATE_', 'VA', 'VAT', 0, 0, '0000-00-00 00:00:00', 'CVA', 'VT', '', 'images/com_joomleague/database/flags/va.png', 'VAT', 'V', ''), (NULL, 'VENEZUELA__BOLIVARIAN_REPUBLIC', 'VE', 'VEN', 0, 0, '0000-00-00 00:00:00', 'VEN', 'VE', 'VEN', 'images/com_joomleague/database/flags/ve.png', 'VEN', 'YV', 'VN'), (NULL, 'VIETNAM__SOCIALIST_REPUBLIC_OF', 'VN', 'VNM', 0, 0, '0000-00-00 00:00:00', 'VTN', 'VM', 'VIE', 'images/com_joomleague/database/flags/vn.png', 'VIE', 'VN', 'VS'), (NULL, 'BRITISH_VIRGIN_ISLANDS', 'VG', 'VGB', 0, 0, '0000-00-00 00:00:00', 'VRG', 'VI', 'IVB', 'images/com_joomleague/database/flags/vg.png', 'VGB', 'BVI', 'VI'), (NULL, 'UNITED_STATES_VIRGIN_ISLANDS', 'VI', 'VIR', 0, 0, '0000-00-00 00:00:00', 'VIR', 'VQ', 'ISV', 'images/com_joomleague/database/flags/vi.png', 'VIR', 'USA', 'VI'), (NULL, 'WALLIS_AND_FUTUNA', 'WF', 'WLF', 0, 0, '0000-00-00 00:00:00', 'WAL', 'WF', 'WAF', 'images/com_joomleague/database/flags/wf.png', 'WLF', 'F', 'FW'), (NULL, 'WESTERN_SAHARA', 'EH', 'ESH', 0, 0, '0000-00-00 00:00:00', 'AOE', 'WI', '', 'images/com_joomleague/database/flags/eh.png', 'SAH', '', ''), (NULL, 'YEMEN', 'YE', 'YEM', 0, 0, '0000-00-00 00:00:00', 'YEM', 'YM', 'YEM', 'images/com_joomleague/database/flags/ye.png', 'YEM', 'YAR', 'YE'), (NULL, 'ZAMBIA__REPUBLIC_OF', 'ZM', 'ZMB', 0, 0, '0000-00-00 00:00:00', 'ZMB', 'ZA', 'ZAM', 'images/com_joomleague/database/flags/zm.png', 'ZAM', 'Z', 'ZB'), (NULL, 'ZIMBABWE__REPUBLIC_OF', 'ZW', 'ZWE', 0, 0, '0000-00-00 00:00:00', 'ZWE', 'ZI', 'ZIM', 'images/com_joomleague/database/flags/zw.png', 'ZIM', 'ZW', 'ZW'), (NULL, 'WALES', '', 'WAL', 0, 0, '2013-02-18 14:19:03', '', '', '', 'images/com_joomleague/database/flags/22px-flag_of_wales_2_svg_1361191015.png', 'WAL', '', ''), (NULL, 'SCOTLAND', 'KS', 'SCO', 0, 0, '2013-02-18 14:18:51', '', '', '', 'images/com_joomleague/database/flags/22px-flag_of_scotland_svg_1361191116.png', 'SCO', '', ''), (NULL, 'EAST__GERMANY', '', 'DDR', 0, 0, '2013-02-18 14:18:40', '', '', 'GDR', 'images/com_joomleague/database/flags/22px-flag_of_east_germany_svg_1361191203.png', 'GDR', '', ''), (NULL, 'CZECHOSLOVAKIA', '', 'CSK', 0, 0, '2013-02-18 14:18:27', '', '', 'TCH', 'images/com_joomleague/database/flags/22px-flag_of_czechoslovakia_svg_1361191420.png', 'TCH', '', ''), (NULL, 'SOVIET__UNION', '', 'SUN', 0, 0, '2013-02-18 14:18:08', '', '', 'URS', 'images/com_joomleague/database/flags/22px-flag_of_the_soviet_union_svg_1361191541.png', 'URS', '', ''), (NULL, 'ZAIRE', '', 'ZAR', 0, 0, '2013-02-18 14:17:53', '', '', 'ZAI', 'images/com_joomleague/database/flags/22px-flag_of_zaire_svg_1361191599.png', 'ZAI', '', ''), (NULL, 'SOUTH__YEMEN', '', 'YMD', 0, 0, '2013-02-18 14:17:38', '', '', 'YMD', 'images/com_joomleague/database/flags/22px-flag_of_south_yemen_svg_1361191769.png', 'SYE', '', ''), (NULL, 'DAHOMEY', '', 'DHY', 0, 0, '2013-02-18 14:17:11', '', '', 'DAH', 'images/com_joomleague/database/flags/22px-flag_of_benin_svg_1361196684.png', 'DAH', '', ''), (NULL, 'RHODESIA', '', 'RHO', 0, 0, '2013-02-18 14:15:57', '', '', 'RHO', 'images/com_joomleague/database/flags/22px-flag_of_rhodesia_svg_1361196944.png', 'RHO', '', '');
SQL =
--
-- Daten für Tabelle `#__joomleague_countries`
--
INSERT INTO `#__joomleague_countries` (`id`, `name`, `alpha2`, `alpha3`, `ordering`, `checked_out`, `checked_out_time`, `itu`, `fips`, `ioc`, `picture`, `fifa`, `ds`, `wmo`) VALUES
(NULL, 'AFGHANISTAN__ISLAMIC_REPUBLIC', 'AF', 'AFG', 0, 0, '0000-00-00 00:00:00', 'AFG', 'AF', 'AFG', 'images/com_joomleague/database/flags/af.png', 'AFG', 'AFG', 'AF'),
(NULL, 'ALAND_ISLANDS', 'AX', 'ALA', 0, 0, '0000-00-00 00:00:00', '', '', '', 'images/com_joomleague/database/flags/ax.png', 'ALD', 'FIN', ''),
(NULL, 'ALBANIA__REPUBLIC_OF', 'AL', 'ALB', 0, 0, '0000-00-00 00:00:00', 'ALB', 'AL', 'ALB', 'images/com_joomleague/database/flags/al.png', 'ALB', 'AL', 'AB'),
(NULL, 'ALGERIA__PEOPLE_S_DEMOCRATIC_REPUBLIC', 'DZ', 'DZA', 0, 0, '0000-00-00 00:00:00', 'ALG', 'AG', 'ALG', 'images/com_joomleague/database/flags/dz.png', 'ALG', 'DZ', 'AL'),
(NULL, 'AMERICAN_SAMOA', 'AS', 'ASM', 0, 0, '0000-00-00 00:00:00', 'SMA', 'AQ', 'ASA', 'images/com_joomleague/database/flags/as.png', 'ASA', 'USA', ''),
(NULL, 'ANDORRA__PRINCIPALITY_OF', 'AD', 'AND', 0, 0, '0000-00-00 00:00:00', 'AND', 'AN', 'AND', 'images/com_joomleague/database/flags/ad.png', 'AND', 'AND', ''),
(NULL, 'ANGOLA__REPUBLIC_OF', 'AO', 'AGO', 0, 0, '0000-00-00 00:00:00', 'AGL', 'AO', 'ANG', 'images/com_joomleague/database/flags/ao.png', 'ANG', '', 'AN'),
(NULL, 'ANGUILLA', 'AI', 'AIA', 0, 0, '0000-00-00 00:00:00', 'AIA', 'AV', 'AIA', 'images/com_joomleague/database/flags/ai.png', 'AIA', '', ''),
(NULL, 'ANTARCTICA__THE TERRITORY SOUT', 'AQ', 'ATA', 0, 0, '0000-00-00 00:00:00', '', 'AY', '', 'images/com_joomleague/database/flags/aq.png', 'ROS', '', 'AA'),
(NULL, 'ANTIGUA_AND_BARBUDA', 'AG', 'ATG', 0, 0, '0000-00-00 00:00:00', 'ATG', 'AC', 'ANT', 'images/com_joomleague/database/flags/ag.png', 'ATG', '', 'AT'),
(NULL, 'ARGENTINA__ARGENTINE_REPUBLIC', 'AR', 'ARG', 0, 0, '0000-00-00 00:00:00', 'ARG', 'AR', 'ARG', 'images/com_joomleague/database/flags/ar.png', 'ARG', 'RA', 'AG'),
(NULL, 'ARMENIA__REPUBLIC_OF', 'AM', 'ARM', 0, 0, '0000-00-00 00:00:00', 'ARM', 'AM', 'ARM', 'images/com_joomleague/database/flags/am.png', 'ARM', 'AM', 'AY'),
(NULL, 'ARUBA', 'AW', 'ABW', 0, 0, '0000-00-00 00:00:00', 'ABW', 'AA', 'ARU', 'images/com_joomleague/database/flags/aw.png', 'ARU', '', 'NU'),
(NULL, 'AUSTRALIA__COMMONWEALTH_OF', 'AU', 'AUS', 0, 0, '0000-00-00 00:00:00', 'AUS', 'AS', 'AUS', 'images/com_joomleague/database/flags/au.png', 'AUS', 'AUS', 'AU'),
(NULL, 'AUSTRIA__REPUBLIC_OF', 'AT', 'AUT', 0, 0, '0000-00-00 00:00:00', 'AUT', 'AU', 'AUT', 'images/com_joomleague/database/flags/at.png', 'AUT', 'A', 'OS'),
(NULL, 'AZERBAIJAN__REPUBLIC_OF', 'AZ', 'AZE', 0, 0, '0000-00-00 00:00:00', 'AZE', 'AJ', 'AZE', 'images/com_joomleague/database/flags/az.png', 'AZE', 'AZ', 'AJ'),
(NULL, 'BAHAMAS__COMMONWEALTH_OF_THE', 'BS', 'BHS', 0, 0, '0000-00-00 00:00:00', 'BAH', 'BF', 'BAH', 'images/com_joomleague/database/flags/bs.png', 'BAH', 'BS', 'BA'),
(NULL, 'BAHRAIN__KINGDOM_OF', 'BH', 'BHR', 0, 0, '0000-00-00 00:00:00', 'BHR', 'BA', 'BRN', 'images/com_joomleague/database/flags/bh.png', 'BHR', 'BRN', 'BN'),
(NULL, 'BANGLADESH__PEOPLE_S_REPUBLIC', 'BD', 'BGD', 0, 0, '0000-00-00 00:00:00', 'BGD', 'BG', 'BAN', 'images/com_joomleague/database/flags/bd.png', 'BAN', 'BD', 'BW'),
(NULL, 'BARBADOS', 'BB', 'BRB', 0, 0, '0000-00-00 00:00:00', 'BRB', 'BB', 'BAR', 'images/com_joomleague/database/flags/bb.png', 'BRB', 'BDS', 'BR'),
(NULL, 'BELARUS__REPUBLIC_OF', 'BY', 'BLR', 0, 0, '0000-00-00 00:00:00', 'BLR', 'BO', 'BLR', 'images/com_joomleague/database/flags/by.png', 'BLR', 'BY', 'BY'),
(NULL, 'BELGIUM__KINGDOM_OF', 'BE', 'BEL', 0, 0, '0000-00-00 00:00:00', 'BEL', 'BE', 'BEL', 'images/com_joomleague/database/flags/be.png', 'BEL', 'B', 'BX'),
(NULL, 'BELIZE', 'BZ', 'BLZ', 0, 0, '0000-00-00 00:00:00', 'BLZ', 'BH', 'BIZ', 'images/com_joomleague/database/flags/bz.png', 'BLZ', 'BZ', 'BH'),
(NULL, 'BENIN_REPUBLIC_OF', 'BJ', 'BEN', 0, 0, '0000-00-00 00:00:00', 'BEN', 'BN', 'BEN', 'images/com_joomleague/database/flags/bj.png', 'BEN', 'DY', 'BJ'),
(NULL, 'BERMUDA', 'BM', 'BMU', 0, 0, '0000-00-00 00:00:00', 'BER', 'BD', 'BER', 'images/com_joomleague/database/flags/bm.png', 'BER', '', 'BE'),
(NULL, 'BHUTAN_KINGDOM_OF', 'BT', 'BTN', 0, 0, '0000-00-00 00:00:00', 'BTN', 'BT', 'BHU', 'images/com_joomleague/database/flags/bt.png', 'BHU', '', ''),
(NULL, 'BOLIVIA__REPUBLIC_OF', 'BO', 'BOL', 0, 0, '0000-00-00 00:00:00', 'BOL', 'BL', 'BOL', 'images/com_joomleague/database/flags/bo.png', 'BOL', 'BOL', 'BO'),
(NULL, 'BONAIRE__SINT_EUSTATIUS_AND_SABA', 'BQ', 'BES', 0, 0, '0000-00-00 00:00:00', 'ATN', 'NL', 'AHO', 'images/com_joomleague/database/flags/bq.png', 'ANT', 'NA', 'NU'),
(NULL, 'BOSNIA_AND_HERZEGOVINA', 'BA', 'BIH', 0, 0, '0000-00-00 00:00:00', 'BIH', 'BK', 'BIH', 'images/com_joomleague/database/flags/ba.png', 'BIH', 'BIH', 'BG'),
(NULL, 'BOTSWANA__REPUBLIC_OF', 'BW', 'BWA', 0, 0, '0000-00-00 00:00:00', 'BOT', 'BC', 'BOT', 'images/com_joomleague/database/flags/bw.png', 'BOT', 'BW', 'BC'),
(NULL, 'BOUVET_ISLAND__BOUVETOYA_', 'BV', 'BVT', 0, 0, '0000-00-00 00:00:00', '', 'BV', '', 'images/com_joomleague/database/flags/bv.png', '', '', 'BV'),
(NULL, 'BRAZIL__FEDERATIVE_REPUBLIC_OF', 'BR', 'BRA', 0, 0, '0000-00-00 00:00:00', 'B', 'BR', 'BRA', 'images/com_joomleague/database/flags/br.png', 'BRA', 'BR', 'BZ'),
(NULL, 'BRITISH_INDIAN_OCEAN_TERRITORY', 'IO', 'IOT', 0, 0, '0000-00-00 00:00:00', 'BIO', 'IO', '', 'images/com_joomleague/database/flags/io.png', '', '', ''),
(NULL, 'BRUNEI_DARUSSALAM', 'BN', 'BRN', 0, 0, '0000-00-00 00:00:00', 'BRU', 'BX', 'BRU', 'images/com_joomleague/database/flags/bn.png', 'BRU', 'BRU', 'BD'),
(NULL, 'BULGARIA__REPUBLIC_OF', 'BG', 'BGR', 0, 0, '0000-00-00 00:00:00', 'BUL', 'BU', 'BUL', 'images/com_joomleague/database/flags/bg.png', 'BUL', 'BG', 'BU'),
(NULL, 'BURKINA_FASO', 'BF', 'BFA', 0, 0, '0000-00-00 00:00:00', 'BFA', 'UV', 'BUR', 'images/com_joomleague/database/flags/bf.png', 'BFA', 'BF', 'HV'),
(NULL, 'BURUNDI__REPUBLIC_OF', 'BI', 'BDI', 0, 0, '0000-00-00 00:00:00', 'BDI', 'BY', 'BDI', 'images/com_joomleague/database/flags/bi.png', 'BDI', 'RU', 'BI'),
(NULL, 'CAMBODIA__KINGDOM_OF', 'KH', 'KHM', 0, 0, '0000-00-00 00:00:00', 'CBG', 'CB', 'CAM', 'images/com_joomleague/database/flags/kh.png', 'CAM', 'K', 'KP'),
(NULL, 'CAMEROON__REPUBLIC_OF', 'CM', 'CMR', 0, 0, '0000-00-00 00:00:00', 'CME', 'CM', 'CMR', 'images/com_joomleague/database/flags/cm.png', 'CMR', 'CAM', 'CM'),
(NULL, 'CANADA', 'CA', 'CAN', 0, 0, '0000-00-00 00:00:00', 'CAN', 'CA', 'CAN', 'images/com_joomleague/database/flags/ca.png', 'CAN', 'CDN', 'CN'),
(NULL, 'CAPE_VERDE__REPUBLIC_OF', 'CV', 'CPV', 0, 0, '0000-00-00 00:00:00', 'CPV', 'CV', 'CPV', 'images/com_joomleague/database/flags/cv.png', 'CPV', '', 'CV'),
(NULL, 'CAYMAN_ISLANDS', 'KY', 'CYM', 0, 0, '0000-00-00 00:00:00', 'CYM', 'CJ', 'CAY', 'images/com_joomleague/database/flags/ky.png', 'CAY', '', 'GC'),
(NULL, 'CENTRAL_AFRICAN_REPUBLIC', 'CF', 'CAF', 0, 0, '0000-00-00 00:00:00', 'CAF', 'CT', 'CAF', 'images/com_joomleague/database/flags/cf.png', 'CTA', 'RCA', 'CE'),
(NULL, 'CHAD__REPUBLIC_OF', 'TD', 'TCD', 0, 0, '0000-00-00 00:00:00', 'TCD', 'CD', 'CHA', 'images/com_joomleague/database/flags/td.png', 'CHA', 'TCH', 'CD'),
(NULL, 'CHILE__REPUBLIC_OF', 'CL', 'CHL', 0, 0, '0000-00-00 00:00:00', 'CHL', 'CI', 'CHI', 'images/com_joomleague/database/flags/cl.png', 'CHI', 'RCH', 'CH'),
(NULL, 'CHINA__PEOPLE_S_REPUBLIC_OF', 'CN', 'CHN', 0, 0, '0000-00-00 00:00:00', 'CHN', 'CH', 'CHN', 'images/com_joomleague/database/flags/cn.png', 'CHN', '', 'CI'),
(NULL, 'CHRISTMAS_ISLAND', 'CX', 'CXR', 0, 0, '0000-00-00 00:00:00', 'CHR', 'KT', '', 'images/com_joomleague/database/flags/cx.png', 'CXR', 'AUS', 'KI'),
(NULL, 'COCOS__KEELING__ISLANDS', 'CC', 'CCK', 0, 0, '0000-00-00 00:00:00', 'ICO', 'CK', '', 'images/com_joomleague/database/flags/cc.png', 'CCK', 'AUS', 'KK'),
(NULL, 'COLOMBIA__REPUBLIC_OF', 'CO', 'COL', 0, 0, '0000-00-00 00:00:00', 'CLM', 'CO', 'COL', 'images/com_joomleague/database/flags/co.png', 'COL', 'CO', 'CO'),
(NULL, 'COMOROS__UNION_OF_THE', 'KM', 'COM', 0, 0, '0000-00-00 00:00:00', 'COM', 'CN', 'COM', 'images/com_joomleague/database/flags/km.png', 'COM', '', 'IC'),
(NULL, 'CONGO__REPUBLIC_OF_THE', 'CG', 'COG', 0, 0, '0000-00-00 00:00:00', 'COG', 'CF', 'CGO', 'images/com_joomleague/database/flags/cg.png', 'CGO', 'RCB', 'CG'),
(NULL, 'CONGO__DEMOCRATIC_REPUBLIC_OF', 'CD', 'COD', 0, 0, '0000-00-00 00:00:00', 'COD', 'CG', 'COD', 'images/com_joomleague/database/flags/cd.png', 'COD', 'ZRE', 'ZR'),
(NULL, 'COOK_ISLANDS', 'CK', 'COK', 0, 0, '0000-00-00 00:00:00', 'CKH', 'CW', 'COK', 'images/com_joomleague/database/flags/ck.png', 'COK', 'NZ', 'KU'),
(NULL, 'COSTA_RICA__REPUBLIC_OF', 'CR', 'CRI', 0, 0, '0000-00-00 00:00:00', 'CTR', 'CS', 'CRC', 'images/com_joomleague/database/flags/cr.png', 'CRC', 'CR', 'CS'),
(NULL, 'COTE_D_IVOIRE__REPUBLIC_OF', 'CI', 'CIV', 0, 0, '0000-00-00 00:00:00', 'CTI', 'IV', 'CIV', 'images/com_joomleague/database/flags/ci.png', 'CIV', 'CI', 'IV'),
(NULL, 'CROATIA__REPUBLIC_OF', 'HR', 'HRV', 0, 0, '0000-00-00 00:00:00', 'HRV', 'HR', 'CRO', 'images/com_joomleague/database/flags/hr.png', 'CRO', 'HR', 'RH'),
(NULL, 'CUBA__REPUBLIC_OF', 'CU', 'CUB', 0, 0, '0000-00-00 00:00:00', 'CUB', 'CU', 'CUB', 'images/com_joomleague/database/flags/cu.png', 'CUB', 'C', 'CU'),
(NULL, 'CURACAO', 'CW', 'CUW', 0, 0, '0000-00-00 00:00:00', '', 'UC', '', 'images/com_joomleague/database/flags/cw.png', '', '', ''),
(NULL, 'CYPRUS__REPUBLIC_OF', 'CY', 'CYP', 0, 0, '0000-00-00 00:00:00', 'CYP', 'CY', 'CYP', 'images/com_joomleague/database/flags/cy.png', 'CYP', 'CY', 'CY'),
(NULL, 'CZECH_REPUBLIC', 'CZ', 'CZE', 0, 0, '0000-00-00 00:00:00', 'CZE', 'EZ', 'CZE', 'images/com_joomleague/database/flags/cz.png', 'CZE', 'CZ', 'CZ'),
(NULL, 'DENMARK__KINGDOM_OF', 'DK', 'DNK', 0, 0, '0000-00-00 00:00:00', 'DNK', 'DA', 'DEN', 'images/com_joomleague/database/flags/dk.png', 'DEN', 'DK', 'DN'),
(NULL, 'DJIBOUTI__REPUBLIC_OF', 'DJ', 'DJI', 0, 0, '0000-00-00 00:00:00', 'DJI', 'DJ', 'DJI', 'images/com_joomleague/database/flags/dj.png', 'DJI', '', 'DJ'),
(NULL, 'DOMINICA__COMMONWEALTH_OF', 'DM', 'DMA', 0, 0, '0000-00-00 00:00:00', 'DMA', 'DO', 'DMA', 'images/com_joomleague/database/flags/dm.png', 'DMA', 'WD', 'DO'),
(NULL, 'DOMINICAN_REPUBLIC', 'DO', 'DOM', 0, 0, '0000-00-00 00:00:00', 'DOM', 'DR', 'DOM', 'images/com_joomleague/database/flags/do.png', 'DOM', 'DOM', 'DR'),
(NULL, 'ECUADOR__REPUBLIC_OF', 'EC', 'ECU', 0, 0, '0000-00-00 00:00:00', 'EQA', 'EC', 'ECU', 'images/com_joomleague/database/flags/ec.png', 'ECU', 'EC', 'EQ'),
(NULL, 'EGYPT__ARAB_REPUBLIC_OF', 'EG', 'EGY', 0, 0, '0000-00-00 00:00:00', 'EGY', 'EG', 'EGY', 'images/com_joomleague/database/flags/eg.png', 'EGY', 'ET', 'EG'),
(NULL, 'EL_SALVADOR__REPUBLIC_OF', 'SV', 'SLV', 0, 0, '0000-00-00 00:00:00', 'SLV', 'ES', 'ESA', 'images/com_joomleague/database/flags/sv.png', 'SLV', 'ES', 'ES'),
(NULL, 'EQUATORIAL_GUINEA__REPUBLIC_OF', 'GQ', 'GNQ', 0, 0, '0000-00-00 00:00:00', 'GNE', 'EK', 'GEQ', 'images/com_joomleague/database/flags/gq.png', 'EQG', '', 'GQ'),
(NULL, 'ERITREA__STATE_OF', 'ER', 'ERI', 0, 0, '0000-00-00 00:00:00', 'ERI', 'ER', 'ERI', 'images/com_joomleague/database/flags/er.png', 'ERI', '', ''),
(NULL, 'ESTONIA__REPUBLIC_OF', 'EE', 'EST', 0, 0, '0000-00-00 00:00:00', 'EST', 'EN', 'EST', 'images/com_joomleague/database/flags/ee.png', 'EST', 'EST', 'EO'),
(NULL, 'ETHIOPIA__FEDERAL_DEMOCRATIC_R', 'ET', 'ETH', 0, 0, '0000-00-00 00:00:00', 'ETH', 'ET', 'ETH', 'images/com_joomleague/database/flags/et.png', 'ETH', 'ETH', 'ET'),
(NULL, 'FALKLAND_ISLANDS__MALVINAS_', 'FK', 'FLK', 0, 0, '0000-00-00 00:00:00', 'FLK', 'FK', 'FLK', 'images/com_joomleague/database/flags/fk.png', 'FLK', '', 'FK'),
(NULL, 'FAROE_ISLANDS', 'FO', 'FRO', 0, 0, '0000-00-00 00:00:00', 'FRO', 'FO', 'FAR', 'images/com_joomleague/database/flags/fo.png', 'FRO', 'FO', 'FA'),
(NULL, 'FIJI__REPUBLIC_OF_THE_FIJI_ISL', 'FJ', 'FJI', 0, 0, '0000-00-00 00:00:00', 'FJI', 'FJ', 'FIJ', 'images/com_joomleague/database/flags/fj.png', 'FIJ', 'FJI', 'FJ'),
(NULL, 'FINLAND__REPUBLIC_OF', 'FI', 'FIN', 0, 0, '0000-00-00 00:00:00', 'FIN', 'FI', 'FIN', 'images/com_joomleague/database/flags/fi.png', 'FIN', 'FIN', 'FI'),
(NULL, 'FRANCE__FRENCH_REPUBLIC', 'FR', 'FRA', 0, 0, '0000-00-00 00:00:00', 'F', 'FR', 'FRA', 'images/com_joomleague/database/flags/fr.png', 'FRA', 'F', 'FR'),
(NULL, 'FRENCH_GUIANA', 'GF', 'GUF', 0, 0, '0000-00-00 00:00:00', 'GUF', 'FG', 'FGU', 'images/com_joomleague/database/flags/gf.png', 'GUF', 'F', 'FG'),
(NULL, 'FRENCH_POLYNESIA', 'PF', 'PYF', 0, 0, '0000-00-00 00:00:00', 'OCE', 'FP', 'FPO', 'images/com_joomleague/database/flags/pf.png', 'TAH', 'F', 'PF'),
(NULL, 'FRENCH_SOUTHERN_TERRITORIES', 'TF', 'ATF', 0, 0, '0000-00-00 00:00:00', '', 'FS', '', 'images/com_joomleague/database/flags/tf.png', '', 'F', ''),
(NULL, 'GABON__GABONESE_REPUBLIC', 'GA', 'GAB', 0, 0, '0000-00-00 00:00:00', 'GAB', 'GB', 'GAB', 'images/com_joomleague/database/flags/ga.png', 'GAB', 'G', 'GO'),
(NULL, 'GAMBIA__REPUBLIC_OF_THE', 'GM', 'GMB', 0, 0, '0000-00-00 00:00:00', 'GMB', 'GA', 'GAM', 'images/com_joomleague/database/flags/gm.png', 'GAM', 'WAG', 'GB'),
(NULL, 'GEORGIA', 'GE', 'GEO', 0, 0, '0000-00-00 00:00:00', 'GEO', 'GG', 'GEO', 'images/com_joomleague/database/flags/ge.png', 'GEO', 'GE', 'GG'),
(NULL, 'GERMANY__FEDERAL_REPUBLIC_OF', 'DE', 'DEU', 0, 0, '0000-00-00 00:00:00', 'D', 'GM', 'GER', 'images/com_joomleague/database/flags/de.png', 'GER', 'D', 'DL'),
(NULL, 'GHANA__REPUBLIC_OF', 'GH', 'GHA', 0, 0, '0000-00-00 00:00:00', 'GHA', 'GH', 'GHA', 'images/com_joomleague/database/flags/gh.png', 'GHA', 'GH', 'GH'),
(NULL, 'GIBRALTAR', 'GI', 'GIB', 0, 0, '0000-00-00 00:00:00', 'GIB', 'GI', 'GIB', 'images/com_joomleague/database/flags/gi.png', 'GBZ', 'GBZ', 'GI'),
(NULL, 'GREECE__HELLENIC_REPUBLIC', 'GR', 'GRC', 0, 0, '0000-00-00 00:00:00', 'GRC', 'GR', 'GRE', 'images/com_joomleague/database/flags/gr.png', 'GRE', 'GR', 'GR'),
(NULL, 'GREENLAND', 'GL', 'GRL', 0, 0, '0000-00-00 00:00:00', 'GRL', 'GL', 'GRL', 'images/com_joomleague/database/flags/gl.png', 'GRL', 'DK', 'GL'),
(NULL, 'GRENADA', 'GD', 'GRD', 0, 0, '0000-00-00 00:00:00', 'GRD', 'GJ', 'GRN', 'images/com_joomleague/database/flags/gd.png', 'GRN', 'WG', 'GD'),
(NULL, 'GUADELOUPE', 'GP', 'GLP', 0, 0, '0000-00-00 00:00:00', 'GDL', 'GP', 'GUD', 'images/com_joomleague/database/flags/gp.png', 'GLP', 'F', 'MF'),
(NULL, 'GUAM', 'GU', 'GUM', 0, 0, '0000-00-00 00:00:00', 'GUM', 'GQ', 'GUM', 'images/com_joomleague/database/flags/gu.png', 'GUM', 'USA', 'GM'),
(NULL, 'GUATEMALA__REPUBLIC_OF', 'GT', 'GTM', 0, 0, '0000-00-00 00:00:00', 'GTM', 'GT', 'GUA', 'images/com_joomleague/database/flags/gt.png', 'GUA', 'GCA', 'GU'),
(NULL, 'GUERNSEY__BAILIWICK_OF', 'GG', 'GGY', 0, 0, '0000-00-00 00:00:00', '', 'GK', '', 'images/com_joomleague/database/flags/gg.png', 'GBG', 'GBG', ''),
(NULL, 'GUINEA__REPUBLIC_OF', 'GN', 'GIN', 0, 0, '0000-00-00 00:00:00', 'GUI', 'GV', 'GUI', 'images/com_joomleague/database/flags/gn.png', 'GUI', 'RG', 'GN'),
(NULL, 'GUINEA-BISSAU__REPUBLIC_OF', 'GW', 'GNB', 0, 0, '0000-00-00 00:00:00', 'GNB', 'PU', 'GBS', 'images/com_joomleague/database/flags/gw.png', 'GNB', '', 'GW'),
(NULL, 'GUYANA__CO-OPERATIVE_REPUBLIC', 'GY', 'GUY', 0, 0, '0000-00-00 00:00:00', 'GUY', 'GY', 'GUY', 'images/com_joomleague/database/flags/gy.png', 'GUY', 'GUY', 'GY'),
(NULL, 'HAITI__REPUBLIC_OF', 'HT', 'HTI', 0, 0, '0000-00-00 00:00:00', 'HTI', 'HA', 'HAI', 'images/com_joomleague/database/flags/ht.png', 'HAI', 'RH', 'HA'),
(NULL, 'HEARD_ISLAND_AND_MCDONALD_ISLA', 'HM', 'HMD', 0, 0, '0000-00-00 00:00:00', '', 'HM', '', 'images/com_joomleague/database/flags/hm.png', '', 'AUS', ''),
(NULL, 'HONDURAS__REPUBLIC_OF', 'HN', 'HND', 0, 0, '0000-00-00 00:00:00', 'HND', 'HO', 'HON', 'images/com_joomleague/database/flags/hn.png', 'HON', '', 'HO'),
(NULL, 'HONG KONG__SPECIAL_ADMINISTRAT', 'HK', 'HKG', 0, 0, '0000-00-00 00:00:00', 'HKG', 'HK', 'HKG', 'images/com_joomleague/database/flags/hk.png', 'HKG', 'HK', 'HK'),
(NULL, 'HUNGARY__REPUBLIC_OF', 'HU', 'HUN', 0, 0, '0000-00-00 00:00:00', 'HNG', 'HU', 'HUN', 'images/com_joomleague/database/flags/hu.png', 'HUN', 'H', 'HU'),
(NULL, 'ICELAND__REPUBLIC_OF', 'IS', 'ISL', 0, 0, '0000-00-00 00:00:00', 'ISL', 'IC', 'ISL', 'images/com_joomleague/database/flags/is.png', 'ISL', 'IS', 'IL'),
(NULL, 'INDIA__REPUBLIC_OF', 'IN', 'IND', 0, 0, '0000-00-00 00:00:00', 'IND', 'IN', 'IND', 'images/com_joomleague/database/flags/in.png', 'IND', 'IND', 'IN'),
(NULL, 'INDONESIA__REPUBLIC_OF', 'ID', 'IDN', 0, 0, '0000-00-00 00:00:00', 'INS', 'ID', 'INA', 'images/com_joomleague/database/flags/id.png', 'IDN', 'RI', 'ID'),
(NULL, 'IRAN__ISLAMIC_REPUBLIC_OF', 'IR', 'IRN', 0, 0, '0000-00-00 00:00:00', 'IRN', 'IR', 'IRI', 'images/com_joomleague/database/flags/ir.png', 'IRN', 'IR', 'IR'),
(NULL, 'IRAQ__REPUBLIC_OF', 'IQ', 'IRQ', 0, 0, '0000-00-00 00:00:00', 'IRQ', 'IZ', 'IRQ', 'images/com_joomleague/database/flags/iq.png', 'IRQ', 'IRQ', 'IQ'),
(NULL, 'IRELAND', 'IE', 'IRL', 0, 0, '0000-00-00 00:00:00', 'IRL', 'EI', 'IRL', 'images/com_joomleague/database/flags/ie.png', 'IRL', 'IRL', 'IE'),
(NULL, 'ISLE_OF_MAN', 'IM', 'IMN', 0, 0, '0000-00-00 00:00:00', '', 'IM', '', 'images/com_joomleague/database/flags/im.png', 'GBM', 'GBM', ''),
(NULL, 'ISRAEL__STATE_OF', 'IL', 'ISR', 0, 0, '0000-00-00 00:00:00', 'ISR', 'IS', 'ISR', 'images/com_joomleague/database/flags/il.png', 'ISR', 'IL', 'IS'),
(NULL, 'ITALY__ITALIAN_REPUBLIC', 'IT', 'ITA', 0, 0, '0000-00-00 00:00:00', 'I', 'IT', 'ITA', 'images/com_joomleague/database/flags/it.png', 'ITA', 'I', 'IY'),
(NULL, 'JAMAICA', 'JM', 'JAM', 0, 0, '0000-00-00 00:00:00', 'JMC', 'JM', 'JAM', 'images/com_joomleague/database/flags/jm.png', 'JAM', 'JA', 'JM'),
(NULL, 'JAPAN', 'JP', 'JPN', 0, 0, '0000-00-00 00:00:00', 'J', 'JA', 'JPN', 'images/com_joomleague/database/flags/jp.png', 'JPN', 'J', 'JP'),
(NULL, 'JERSEY__BAILIWICK_OF', 'JE', 'JEY', 0, 0, '0000-00-00 00:00:00', '', 'JE', '', 'images/com_joomleague/database/flags/je.png', 'GBJ', 'GBJ', ''),
(NULL, 'JORDAN__HASHEMITE_KINGDOM_OF', 'JO', 'JOR', 0, 0, '0000-00-00 00:00:00', 'JOR', 'JO', 'JOR', 'images/com_joomleague/database/flags/jo.png', 'JOR', 'HKJ', 'JD'),
(NULL, 'KAZAKHSTAN__REPUBLIC_OF', 'KZ', 'KAZ', 0, 0, '0000-00-00 00:00:00', 'KAZ', 'KZ', 'KAZ', 'images/com_joomleague/database/flags/kz.png', 'KAZ', 'KZ', 'KZ'),
(NULL, 'KENYA__REPUBLIC_OF', 'KE', 'KEN', 0, 0, '0000-00-00 00:00:00', 'KEN', 'KE', 'KEN', 'images/com_joomleague/database/flags/ke.png', 'KEN', 'EAK', 'KN'),
(NULL, 'KIRIBATI__REPUBLIC_OF', 'KI', 'KIR', 0, 0, '0000-00-00 00:00:00', 'KIR', 'KR', 'KIR', 'images/com_joomleague/database/flags/ki.png', 'KIR', '', 'KB'),
(NULL, 'KOREA__DEMOCRATIC_PEOPLE_S_REP', 'KP', 'PRK', 0, 0, '0000-00-00 00:00:00', 'KRE', 'KN', 'PRK', 'images/com_joomleague/database/flags/kp.png', 'PRK', '', 'KR'),
(NULL, 'KOREA__REPUBLIC_OF', 'KR', 'KOR', 0, 0, '0000-00-00 00:00:00', 'KOR', 'KS', 'KOR', 'images/com_joomleague/database/flags/kr.png', 'KOR', 'ROK', 'KO'),
(NULL, 'KUWAIT__STATE_OF', 'KW', 'KWT', 0, 0, '0000-00-00 00:00:00', 'KWT', 'KU', 'KUW', 'images/com_joomleague/database/flags/kw.png', 'KUW', 'KWT', 'KW'),
(NULL, 'KYRGYZ_REPUBLIC', 'KG', 'KGZ', 0, 0, '0000-00-00 00:00:00', 'KGZ', 'KG', 'KGZ', 'images/com_joomleague/database/flags/kg.png', 'KGZ', 'KS', 'KG'),
(NULL, 'LAO_PEOPLE_S_DEMOCRATIC_REPUBL', 'LA', 'LAO', 0, 0, '0000-00-00 00:00:00', 'LAO', 'LA', 'LAO', 'images/com_joomleague/database/flags/la.png', 'LAO', 'LAO', 'LA'),
(NULL, 'LATVIA__REPUBLIC_OF', 'LV', 'LVA', 0, 0, '0000-00-00 00:00:00', 'LVA', 'LG', 'LAT', 'images/com_joomleague/database/flags/lv.png', 'LVA', 'LV', 'LV'),
(NULL, 'LEBANON__LEBANESE_REPUBLIC', 'LB', 'LBN', 0, 0, '0000-00-00 00:00:00', 'LBN', 'LE', 'LIB', 'images/com_joomleague/database/flags/lb.png', 'LIB', 'RL', 'LB'),
(NULL, 'LESOTHO__KINGDOM_OF', 'LS', 'LSO', 0, 0, '0000-00-00 00:00:00', 'LSO', 'LT', 'LES', 'images/com_joomleague/database/flags/ls.png', 'LES', 'LS', 'LS'),
(NULL, 'LIBERIA__REPUBLIC_OF', 'LR', 'LBR', 0, 0, '0000-00-00 00:00:00', 'LBR', 'LI', 'LBR', 'images/com_joomleague/database/flags/lr.png', 'LBR', 'LB', 'LI'),
(NULL, 'LIBYAN_ARAB_JAMAHIRIYA', 'LY', 'LBY', 0, 0, '0000-00-00 00:00:00', 'LBY', 'LY', 'LBA', 'images/com_joomleague/database/flags/ly.png', 'LBY', 'LAR', 'LY'),
(NULL, 'LIECHTENSTEIN__PRINCIPALITY_OF', 'LI', 'LIE', 0, 0, '0000-00-00 00:00:00', 'LIE', 'LS', 'LIE', 'images/com_joomleague/database/flags/li.png', 'LIE', 'FL', ''),
(NULL, 'LITHUANIA__REPUBLIC_OF', 'LT', 'LTU', 0, 0, '0000-00-00 00:00:00', 'LTU', 'LH', 'LTU', 'images/com_joomleague/database/flags/lt.png', 'LTU', 'LT', 'LT'),
(NULL, 'LUXEMBOURG__GRAND_DUCHY_OF', 'LU', 'LUX', 0, 0, '0000-00-00 00:00:00', 'LUX', 'LU', 'LUX', 'images/com_joomleague/database/flags/lu.png', 'LUX', 'L', 'BX'),
(NULL, 'MACAO__SPECIAL_ADMINISTRATIVE', 'MO', 'MAC', 0, 0, '0000-00-00 00:00:00', 'MAC', 'MC', 'MAC', 'images/com_joomleague/database/flags/mo.png', 'MAC', '', 'MU'),
(NULL, 'MACEDONIA__THE_FORMER_YUGOSLAV', 'MK', 'MKD', 0, 0, '0000-00-00 00:00:00', 'MKD', 'MK', 'MKD', 'images/com_joomleague/database/flags/mk.png', 'MKD', 'MK', 'MJ'),
(NULL, 'MADAGASCAR__REPUBLIC_OF', 'MG', 'MDG', 0, 0, '0000-00-00 00:00:00', 'MDG', 'MA', 'MAD', 'images/com_joomleague/database/flags/mg.png', 'MAD', 'RM', 'MG'),
(NULL, 'MALAWI__REPUBLIC_OF', 'MW', 'MWI', 0, 0, '0000-00-00 00:00:00', 'MWI', 'MI', 'MAW', 'images/com_joomleague/database/flags/mw.png', 'MWI', 'MW', 'MW'),
(NULL, 'MALAYSIA', 'MY', 'MYS', 0, 0, '0000-00-00 00:00:00', 'MLA', 'MY', 'MAS', 'images/com_joomleague/database/flags/my.png', 'MAS', 'MAL', 'MS'),
(NULL, 'MALDIVES__REPUBLIC_OF', 'MV', 'MDV', 0, 0, '0000-00-00 00:00:00', 'MLD', 'MV', 'MDV', 'images/com_joomleague/database/flags/mv.png', 'MDV', '', 'MV'),
(NULL, 'MALI__REPUBLIC_OF', 'ML', 'MLI', 0, 0, '0000-00-00 00:00:00', 'MLI', 'ML', 'MLI', 'images/com_joomleague/database/flags/ml.png', 'MLI', 'RMM', 'MI'),
(NULL, 'MALTA__REPUBLIC_OF', 'MT', 'MLT', 0, 0, '0000-00-00 00:00:00', 'MLT', 'MT', 'MLT', 'images/com_joomleague/database/flags/mt.png', 'MLT', 'M', 'ML'),
(NULL, 'MARSHALL_ISLANDS__REPUBLIC_OF', 'MH', 'MHL', 0, 0, '0000-00-[/spoiler
Duplicate entry 'AFGHANISTAN__ISLAMIC_REPUBLIC-AFG' for key 'name' SQL=-- -- Daten für Tabelle `XYZ1_joomleague_countries` -- INSERT INTO `XYZ1_joomleague_countries` (`id`, `name`, `alpha2`, `alpha3`, `ordering`, `checked_out`, `checked_out_time`, `itu`, `fips`, `ioc`, `picture`, `fifa`, `ds`, `wmo`) VALUES (NULL, 'AFGHANISTAN__ISLAMIC_REPUBLIC', 'AF', 'AFG', 0, 0, '0000-00-00 00:00:00', 'AFG', 'AF', 'AFG', 'images/com_joomleague/database/flags/af.png', 'AFG', 'AFG', 'AF'), (NULL, 'ALAND_ISLANDS', 'AX', 'ALA', 0, 0, '0000-00-00 00:00:00', '', '', '', 'images/com_joomleague/database/flags/ax.png', 'ALD', 'FIN', ''), (NULL, 'ALBANIA__REPUBLIC_OF', 'AL', 'ALB', 0, 0, '0000-00-00 00:00:00', 'ALB', 'AL', 'ALB', 'images/com_joomleague/database/flags/al.png', 'ALB', 'AL', 'AB'), (NULL, 'ALGERIA__PEOPLE_S_DEMOCRATIC_REPUBLIC', 'DZ', 'DZA', 0, 0, '0000-00-00 00:00:00', 'ALG', 'AG', 'ALG', 'images/com_joomleague/database/flags/dz.png', 'ALG', 'DZ', 'AL'), (NULL, 'AMERICAN_SAMOA', 'AS', 'ASM', 0, 0, '0000-00-00 00:00:00', 'SMA', 'AQ', 'ASA', 'images/com_joomleague/database/flags/as.png', 'ASA', 'USA', ''), (NULL, 'ANDORRA__PRINCIPALITY_OF', 'AD', 'AND', 0, 0, '0000-00-00 00:00:00', 'AND', 'AN', 'AND', 'images/com_joomleague/database/flags/ad.png', 'AND', 'AND', ''), (NULL, 'ANGOLA__REPUBLIC_OF', 'AO', 'AGO', 0, 0, '0000-00-00 00:00:00', 'AGL', 'AO', 'ANG', 'images/com_joomleague/database/flags/ao.png', 'ANG', '', 'AN'), (NULL, 'ANGUILLA', 'AI', 'AIA', 0, 0, '0000-00-00 00:00:00', 'AIA', 'AV', 'AIA', 'images/com_joomleague/database/flags/ai.png', 'AIA', '', ''), (NULL, 'ANTARCTICA__THE TERRITORY SOUT', 'AQ', 'ATA', 0, 0, '0000-00-00 00:00:00', '', 'AY', '', 'images/com_joomleague/database/flags/aq.png', 'ROS', '', 'AA'), (NULL, 'ANTIGUA_AND_BARBUDA', 'AG', 'ATG', 0, 0, '0000-00-00 00:00:00', 'ATG', 'AC', 'ANT', 'images/com_joomleague/database/flags/ag.png', 'ATG', '', 'AT'), (NULL, 'ARGENTINA__ARGENTINE_REPUBLIC', 'AR', 'ARG', 0, 0, '0000-00-00 00:00:00', 'ARG', 'AR', 'ARG', 'images/com_joomleague/database/flags/ar.png', 'ARG', 'RA', 'AG'), (NULL, 'ARMENIA__REPUBLIC_OF', 'AM', 'ARM', 0, 0, '0000-00-00 00:00:00', 'ARM', 'AM', 'ARM', 'images/com_joomleague/database/flags/am.png', 'ARM', 'AM', 'AY'), (NULL, 'ARUBA', 'AW', 'ABW', 0, 0, '0000-00-00 00:00:00', 'ABW', 'AA', 'ARU', 'images/com_joomleague/database/flags/aw.png', 'ARU', '', 'NU'), (NULL, 'AUSTRALIA__COMMONWEALTH_OF', 'AU', 'AUS', 0, 0, '0000-00-00 00:00:00', 'AUS', 'AS', 'AUS', 'images/com_joomleague/database/flags/au.png', 'AUS', 'AUS', 'AU'), (NULL, 'AUSTRIA__REPUBLIC_OF', 'AT', 'AUT', 0, 0, '0000-00-00 00:00:00', 'AUT', 'AU', 'AUT', 'images/com_joomleague/database/flags/at.png', 'AUT', 'A', 'OS'), (NULL, 'AZERBAIJAN__REPUBLIC_OF', 'AZ', 'AZE', 0, 0, '0000-00-00 00:00:00', 'AZE', 'AJ', 'AZE', 'images/com_joomleague/database/flags/az.png', 'AZE', 'AZ', 'AJ'), (NULL, 'BAHAMAS__COMMONWEALTH_OF_THE', 'BS', 'BHS', 0, 0, '0000-00-00 00:00:00', 'BAH', 'BF', 'BAH', 'images/com_joomleague/database/flags/bs.png', 'BAH', 'BS', 'BA'), (NULL, 'BAHRAIN__KINGDOM_OF', 'BH', 'BHR', 0, 0, '0000-00-00 00:00:00', 'BHR', 'BA', 'BRN', 'images/com_joomleague/database/flags/bh.png', 'BHR', 'BRN', 'BN'), (NULL, 'BANGLADESH__PEOPLE_S_REPUBLIC', 'BD', 'BGD', 0, 0, '0000-00-00 00:00:00', 'BGD', 'BG', 'BAN', 'images/com_joomleague/database/flags/bd.png', 'BAN', 'BD', 'BW'), (NULL, 'BARBADOS', 'BB', 'BRB', 0, 0, '0000-00-00 00:00:00', 'BRB', 'BB', 'BAR', 'images/com_joomleague/database/flags/bb.png', 'BRB', 'BDS', 'BR'), (NULL, 'BELARUS__REPUBLIC_OF', 'BY', 'BLR', 0, 0, '0000-00-00 00:00:00', 'BLR', 'BO', 'BLR', 'images/com_joomleague/database/flags/by.png', 'BLR', 'BY', 'BY'), (NULL, 'BELGIUM__KINGDOM_OF', 'BE', 'BEL', 0, 0, '0000-00-00 00:00:00', 'BEL', 'BE', 'BEL', 'images/com_joomleague/database/flags/be.png', 'BEL', 'B', 'BX'), (NULL, 'BELIZE', 'BZ', 'BLZ', 0, 0, '0000-00-00 00:00:00', 'BLZ', 'BH', 'BIZ', 'images/com_joomleague/database/flags/bz.png', 'BLZ', 'BZ', 'BH'), (NULL, 'BENIN_REPUBLIC_OF', 'BJ', 'BEN', 0, 0, '0000-00-00 00:00:00', 'BEN', 'BN', 'BEN', 'images/com_joomleague/database/flags/bj.png', 'BEN', 'DY', 'BJ'), (NULL, 'BERMUDA', 'BM', 'BMU', 0, 0, '0000-00-00 00:00:00', 'BER', 'BD', 'BER', 'images/com_joomleague/database/flags/bm.png', 'BER', '', 'BE'), (NULL, 'BHUTAN_KINGDOM_OF', 'BT', 'BTN', 0, 0, '0000-00-00 00:00:00', 'BTN', 'BT', 'BHU', 'images/com_joomleague/database/flags/bt.png', 'BHU', '', ''), (NULL, 'BOLIVIA__REPUBLIC_OF', 'BO', 'BOL', 0, 0, '0000-00-00 00:00:00', 'BOL', 'BL', 'BOL', 'images/com_joomleague/database/flags/bo.png', 'BOL', 'BOL', 'BO'), (NULL, 'BONAIRE__SINT_EUSTATIUS_AND_SABA', 'BQ', 'BES', 0, 0, '0000-00-00 00:00:00', 'ATN', 'NL', 'AHO', 'images/com_joomleague/database/flags/bq.png', 'ANT', 'NA', 'NU'), (NULL, 'BOSNIA_AND_HERZEGOVINA', 'BA', 'BIH', 0, 0, '0000-00-00 00:00:00', 'BIH', 'BK', 'BIH', 'images/com_joomleague/database/flags/ba.png', 'BIH', 'BIH', 'BG'), (NULL, 'BOTSWANA__REPUBLIC_OF', 'BW', 'BWA', 0, 0, '0000-00-00 00:00:00', 'BOT', 'BC', 'BOT', 'images/com_joomleague/database/flags/bw.png', 'BOT', 'BW', 'BC'), (NULL, 'BOUVET_ISLAND__BOUVETOYA_', 'BV', 'BVT', 0, 0, '0000-00-00 00:00:00', '', 'BV', '', 'images/com_joomleague/database/flags/bv.png', '', '', 'BV'), (NULL, 'BRAZIL__FEDERATIVE_REPUBLIC_OF', 'BR', 'BRA', 0, 0, '0000-00-00 00:00:00', 'B', 'BR', 'BRA', 'images/com_joomleague/database/flags/br.png', 'BRA', 'BR', 'BZ'), (NULL, 'BRITISH_INDIAN_OCEAN_TERRITORY', 'IO', 'IOT', 0, 0, '0000-00-00 00:00:00', 'BIO', 'IO', '', 'images/com_joomleague/database/flags/io.png', '', '', ''), (NULL, 'BRUNEI_DARUSSALAM', 'BN', 'BRN', 0, 0, '0000-00-00 00:00:00', 'BRU', 'BX', 'BRU', 'images/com_joomleague/database/flags/bn.png', 'BRU', 'BRU', 'BD'), (NULL, 'BULGARIA__REPUBLIC_OF', 'BG', 'BGR', 0, 0, '0000-00-00 00:00:00', 'BUL', 'BU', 'BUL', 'images/com_joomleague/database/flags/bg.png', 'BUL', 'BG', 'BU'), (NULL, 'BURKINA_FASO', 'BF', 'BFA', 0, 0, '0000-00-00 00:00:00', 'BFA', 'UV', 'BUR', 'images/com_joomleague/database/flags/bf.png', 'BFA', 'BF', 'HV'), (NULL, 'BURUNDI__REPUBLIC_OF', 'BI', 'BDI', 0, 0, '0000-00-00 00:00:00', 'BDI', 'BY', 'BDI', 'images/com_joomleague/database/flags/bi.png', 'BDI', 'RU', 'BI'), (NULL, 'CAMBODIA__KINGDOM_OF', 'KH', 'KHM', 0, 0, '0000-00-00 00:00:00', 'CBG', 'CB', 'CAM', 'images/com_joomleague/database/flags/kh.png', 'CAM', 'K', 'KP'), (NULL, 'CAMEROON__REPUBLIC_OF', 'CM', 'CMR', 0, 0, '0000-00-00 00:00:00', 'CME', 'CM', 'CMR', 'images/com_joomleague/database/flags/cm.png', 'CMR', 'CAM', 'CM'), (NULL, 'CANADA', 'CA', 'CAN', 0, 0, '0000-00-00 00:00:00', 'CAN', 'CA', 'CAN', 'images/com_joomleague/database/flags/ca.png', 'CAN', 'CDN', 'CN'), (NULL, 'CAPE_VERDE__REPUBLIC_OF', 'CV', 'CPV', 0, 0, '0000-00-00 00:00:00', 'CPV', 'CV', 'CPV', 'images/com_joomleague/database/flags/cv.png', 'CPV', '', 'CV'), (NULL, 'CAYMAN_ISLANDS', 'KY', 'CYM', 0, 0, '0000-00-00 00:00:00', 'CYM', 'CJ', 'CAY', 'images/com_joomleague/database/flags/ky.png', 'CAY', '', 'GC'), (NULL, 'CENTRAL_AFRICAN_REPUBLIC', 'CF', 'CAF', 0, 0, '0000-00-00 00:00:00', 'CAF', 'CT', 'CAF', 'images/com_joomleague/database/flags/cf.png', 'CTA', 'RCA', 'CE'), (NULL, 'CHAD__REPUBLIC_OF', 'TD', 'TCD', 0, 0, '0000-00-00 00:00:00', 'TCD', 'CD', 'CHA', 'images/com_joomleague/database/flags/td.png', 'CHA', 'TCH', 'CD'), (NULL, 'CHILE__REPUBLIC_OF', 'CL', 'CHL', 0, 0, '0000-00-00 00:00:00', 'CHL', 'CI', 'CHI', 'images/com_joomleague/database/flags/cl.png', 'CHI', 'RCH', 'CH'), (NULL, 'CHINA__PEOPLE_S_REPUBLIC_OF', 'CN', 'CHN', 0, 0, '0000-00-00 00:00:00', 'CHN', 'CH', 'CHN', 'images/com_joomleague/database/flags/cn.png', 'CHN', '', 'CI'), (NULL, 'CHRISTMAS_ISLAND', 'CX', 'CXR', 0, 0, '0000-00-00 00:00:00', 'CHR', 'KT', '', 'images/com_joomleague/database/flags/cx.png', 'CXR', 'AUS', 'KI'), (NULL, 'COCOS__KEELING__ISLANDS', 'CC', 'CCK', 0, 0, '0000-00-00 00:00:00', 'ICO', 'CK', '', 'images/com_joomleague/database/flags/cc.png', 'CCK', 'AUS', 'KK'), (NULL, 'COLOMBIA__REPUBLIC_OF', 'CO', 'COL', 0, 0, '0000-00-00 00:00:00', 'CLM', 'CO', 'COL', 'images/com_joomleague/database/flags/co.png', 'COL', 'CO', 'CO'), (NULL, 'COMOROS__UNION_OF_THE', 'KM', 'COM', 0, 0, '0000-00-00 00:00:00', 'COM', 'CN', 'COM', 'images/com_joomleague/database/flags/km.png', 'COM', '', 'IC'), (NULL, 'CONGO__REPUBLIC_OF_THE', 'CG', 'COG', 0, 0, '0000-00-00 00:00:00', 'COG', 'CF', 'CGO', 'images/com_joomleague/database/flags/cg.png', 'CGO', 'RCB', 'CG'), (NULL, 'CONGO__DEMOCRATIC_REPUBLIC_OF', 'CD', 'COD', 0, 0, '0000-00-00 00:00:00', 'COD', 'CG', 'COD', 'images/com_joomleague/database/flags/cd.png', 'COD', 'ZRE', 'ZR'), (NULL, 'COOK_ISLANDS', 'CK', 'COK', 0, 0, '0000-00-00 00:00:00', 'CKH', 'CW', 'COK', 'images/com_joomleague/database/flags/ck.png', 'COK', 'NZ', 'KU'), (NULL, 'COSTA_RICA__REPUBLIC_OF', 'CR', 'CRI', 0, 0, '0000-00-00 00:00:00', 'CTR', 'CS', 'CRC', 'images/com_joomleague/database/flags/cr.png', 'CRC', 'CR', 'CS'), (NULL, 'COTE_D_IVOIRE__REPUBLIC_OF', 'CI', 'CIV', 0, 0, '0000-00-00 00:00:00', 'CTI', 'IV', 'CIV', 'images/com_joomleague/database/flags/ci.png', 'CIV', 'CI', 'IV'), (NULL, 'CROATIA__REPUBLIC_OF', 'HR', 'HRV', 0, 0, '0000-00-00 00:00:00', 'HRV', 'HR', 'CRO', 'images/com_joomleague/database/flags/hr.png', 'CRO', 'HR', 'RH'), (NULL, 'CUBA__REPUBLIC_OF', 'CU', 'CUB', 0, 0, '0000-00-00 00:00:00', 'CUB', 'CU', 'CUB', 'images/com_joomleague/database/flags/cu.png', 'CUB', 'C', 'CU'), (NULL, 'CURACAO', 'CW', 'CUW', 0, 0, '0000-00-00 00:00:00', '', 'UC', '', 'images/com_joomleague/database/flags/cw.png', '', '', ''), (NULL, 'CYPRUS__REPUBLIC_OF', 'CY', 'CYP', 0, 0, '0000-00-00 00:00:00', 'CYP', 'CY', 'CYP', 'images/com_joomleague/database/flags/cy.png', 'CYP', 'CY', 'CY'), (NULL, 'CZECH_REPUBLIC', 'CZ', 'CZE', 0, 0, '0000-00-00 00:00:00', 'CZE', 'EZ', 'CZE', 'images/com_joomleague/database/flags/cz.png', 'CZE', 'CZ', 'CZ'), (NULL, 'DENMARK__KINGDOM_OF', 'DK', 'DNK', 0, 0, '0000-00-00 00:00:00', 'DNK', 'DA', 'DEN', 'images/com_joomleague/database/flags/dk.png', 'DEN', 'DK', 'DN'), (NULL, 'DJIBOUTI__REPUBLIC_OF', 'DJ', 'DJI', 0, 0, '0000-00-00 00:00:00', 'DJI', 'DJ', 'DJI', 'images/com_joomleague/database/flags/dj.png', 'DJI', '', 'DJ'), (NULL, 'DOMINICA__COMMONWEALTH_OF', 'DM', 'DMA', 0, 0, '0000-00-00 00:00:00', 'DMA', 'DO', 'DMA', 'images/com_joomleague/database/flags/dm.png', 'DMA', 'WD', 'DO'), (NULL, 'DOMINICAN_REPUBLIC', 'DO', 'DOM', 0, 0, '0000-00-00 00:00:00', 'DOM', 'DR', 'DOM', 'images/com_joomleague/database/flags/do.png', 'DOM', 'DOM', 'DR'), (NULL, 'ECUADOR__REPUBLIC_OF', 'EC', 'ECU', 0, 0, '0000-00-00 00:00:00', 'EQA', 'EC', 'ECU', 'images/com_joomleague/database/flags/ec.png', 'ECU', 'EC', 'EQ'), (NULL, 'EGYPT__ARAB_REPUBLIC_OF', 'EG', 'EGY', 0, 0, '0000-00-00 00:00:00', 'EGY', 'EG', 'EGY', 'images/com_joomleague/database/flags/eg.png', 'EGY', 'ET', 'EG'), (NULL, 'EL_SALVADOR__REPUBLIC_OF', 'SV', 'SLV', 0, 0, '0000-00-00 00:00:00', 'SLV', 'ES', 'ESA', 'images/com_joomleague/database/flags/sv.png', 'SLV', 'ES', 'ES'), (NULL, 'EQUATORIAL_GUINEA__REPUBLIC_OF', 'GQ', 'GNQ', 0, 0, '0000-00-00 00:00:00', 'GNE', 'EK', 'GEQ', 'images/com_joomleague/database/flags/gq.png', 'EQG', '', 'GQ'), (NULL, 'ERITREA__STATE_OF', 'ER', 'ERI', 0, 0, '0000-00-00 00:00:00', 'ERI', 'ER', 'ERI', 'images/com_joomleague/database/flags/er.png', 'ERI', '', ''), (NULL, 'ESTONIA__REPUBLIC_OF', 'EE', 'EST', 0, 0, '0000-00-00 00:00:00', 'EST', 'EN', 'EST', 'images/com_joomleague/database/flags/ee.png', 'EST', 'EST', 'EO'), (NULL, 'ETHIOPIA__FEDERAL_DEMOCRATIC_R', 'ET', 'ETH', 0, 0, '0000-00-00 00:00:00', 'ETH', 'ET', 'ETH', 'images/com_joomleague/database/flags/et.png', 'ETH', 'ETH', 'ET'), (NULL, 'FALKLAND_ISLANDS__MALVINAS_', 'FK', 'FLK', 0, 0, '0000-00-00 00:00:00', 'FLK', 'FK', 'FLK', 'images/com_joomleague/database/flags/fk.png', 'FLK', '', 'FK'), (NULL, 'FAROE_ISLANDS', 'FO', 'FRO', 0, 0, '0000-00-00 00:00:00', 'FRO', 'FO', 'FAR', 'images/com_joomleague/database/flags/fo.png', 'FRO', 'FO', 'FA'), (NULL, 'FIJI__REPUBLIC_OF_THE_FIJI_ISL', 'FJ', 'FJI', 0, 0, '0000-00-00 00:00:00', 'FJI', 'FJ', 'FIJ', 'images/com_joomleague/database/flags/fj.png', 'FIJ', 'FJI', 'FJ'), (NULL, 'FINLAND__REPUBLIC_OF', 'FI', 'FIN', 0, 0, '0000-00-00 00:00:00', 'FIN', 'FI', 'FIN', 'images/com_joomleague/database/flags/fi.png', 'FIN', 'FIN', 'FI'), (NULL, 'FRANCE__FRENCH_REPUBLIC', 'FR', 'FRA', 0, 0, '0000-00-00 00:00:00', 'F', 'FR', 'FRA', 'images/com_joomleague/database/flags/fr.png', 'FRA', 'F', 'FR'), (NULL, 'FRENCH_GUIANA', 'GF', 'GUF', 0, 0, '0000-00-00 00:00:00', 'GUF', 'FG', 'FGU', 'images/com_joomleague/database/flags/gf.png', 'GUF', 'F', 'FG'), (NULL, 'FRENCH_POLYNESIA', 'PF', 'PYF', 0, 0, '0000-00-00 00:00:00', 'OCE', 'FP', 'FPO', 'images/com_joomleague/database/flags/pf.png', 'TAH', 'F', 'PF'), (NULL, 'FRENCH_SOUTHERN_TERRITORIES', 'TF', 'ATF', 0, 0, '0000-00-00 00:00:00', '', 'FS', '', 'images/com_joomleague/database/flags/tf.png', '', 'F', ''), (NULL, 'GABON__GABONESE_REPUBLIC', 'GA', 'GAB', 0, 0, '0000-00-00 00:00:00', 'GAB', 'GB', 'GAB', 'images/com_joomleague/database/flags/ga.png', 'GAB', 'G', 'GO'), (NULL, 'GAMBIA__REPUBLIC_OF_THE', 'GM', 'GMB', 0, 0, '0000-00-00 00:00:00', 'GMB', 'GA', 'GAM', 'images/com_joomleague/database/flags/gm.png', 'GAM', 'WAG', 'GB'), (NULL, 'GEORGIA', 'GE', 'GEO', 0, 0, '0000-00-00 00:00:00', 'GEO', 'GG', 'GEO', 'images/com_joomleague/database/flags/ge.png', 'GEO', 'GE', 'GG'), (NULL, 'GERMANY__FEDERAL_REPUBLIC_OF', 'DE', 'DEU', 0, 0, '0000-00-00 00:00:00', 'D', 'GM', 'GER', 'images/com_joomleague/database/flags/de.png', 'GER', 'D', 'DL'), (NULL, 'GHANA__REPUBLIC_OF', 'GH', 'GHA', 0, 0, '0000-00-00 00:00:00', 'GHA', 'GH', 'GHA', 'images/com_joomleague/database/flags/gh.png', 'GHA', 'GH', 'GH'), (NULL, 'GIBRALTAR', 'GI', 'GIB', 0, 0, '0000-00-00 00:00:00', 'GIB', 'GI', 'GIB', 'images/com_joomleague/database/flags/gi.png', 'GBZ', 'GBZ', 'GI'), (NULL, 'GREECE__HELLENIC_REPUBLIC', 'GR', 'GRC', 0, 0, '0000-00-00 00:00:00', 'GRC', 'GR', 'GRE', 'images/com_joomleague/database/flags/gr.png', 'GRE', 'GR', 'GR'), (NULL, 'GREENLAND', 'GL', 'GRL', 0, 0, '0000-00-00 00:00:00', 'GRL', 'GL', 'GRL', 'images/com_joomleague/database/flags/gl.png', 'GRL', 'DK', 'GL'), (NULL, 'GRENADA', 'GD', 'GRD', 0, 0, '0000-00-00 00:00:00', 'GRD', 'GJ', 'GRN', 'images/com_joomleague/database/flags/gd.png', 'GRN', 'WG', 'GD'), (NULL, 'GUADELOUPE', 'GP', 'GLP', 0, 0, '0000-00-00 00:00:00', 'GDL', 'GP', 'GUD', 'images/com_joomleague/database/flags/gp.png', 'GLP', 'F', 'MF'), (NULL, 'GUAM', 'GU', 'GUM', 0, 0, '0000-00-00 00:00:00', 'GUM', 'GQ', 'GUM', 'images/com_joomleague/database/flags/gu.png', 'GUM', 'USA', 'GM'), (NULL, 'GUATEMALA__REPUBLIC_OF', 'GT', 'GTM', 0, 0, '0000-00-00 00:00:00', 'GTM', 'GT', 'GUA', 'images/com_joomleague/database/flags/gt.png', 'GUA', 'GCA', 'GU'), (NULL, 'GUERNSEY__BAILIWICK_OF', 'GG', 'GGY', 0, 0, '0000-00-00 00:00:00', '', 'GK', '', 'images/com_joomleague/database/flags/gg.png', 'GBG', 'GBG', ''), (NULL, 'GUINEA__REPUBLIC_OF', 'GN', 'GIN', 0, 0, '0000-00-00 00:00:00', 'GUI', 'GV', 'GUI', 'images/com_joomleague/database/flags/gn.png', 'GUI', 'RG', 'GN'), (NULL, 'GUINEA-BISSAU__REPUBLIC_OF', 'GW', 'GNB', 0, 0, '0000-00-00 00:00:00', 'GNB', 'PU', 'GBS', 'images/com_joomleague/database/flags/gw.png', 'GNB', '', 'GW'), (NULL, 'GUYANA__CO-OPERATIVE_REPUBLIC', 'GY', 'GUY', 0, 0, '0000-00-00 00:00:00', 'GUY', 'GY', 'GUY', 'images/com_joomleague/database/flags/gy.png', 'GUY', 'GUY', 'GY'), (NULL, 'HAITI__REPUBLIC_OF', 'HT', 'HTI', 0, 0, '0000-00-00 00:00:00', 'HTI', 'HA', 'HAI', 'images/com_joomleague/database/flags/ht.png', 'HAI', 'RH', 'HA'), (NULL, 'HEARD_ISLAND_AND_MCDONALD_ISLA', 'HM', 'HMD', 0, 0, '0000-00-00 00:00:00', '', 'HM', '', 'images/com_joomleague/database/flags/hm.png', '', 'AUS', ''), (NULL, 'HONDURAS__REPUBLIC_OF', 'HN', 'HND', 0, 0, '0000-00-00 00:00:00', 'HND', 'HO', 'HON', 'images/com_joomleague/database/flags/hn.png', 'HON', '', 'HO'), (NULL, 'HONG KONG__SPECIAL_ADMINISTRAT', 'HK', 'HKG', 0, 0, '0000-00-00 00:00:00', 'HKG', 'HK', 'HKG', 'images/com_joomleague/database/flags/hk.png', 'HKG', 'HK', 'HK'), (NULL, 'HUNGARY__REPUBLIC_OF', 'HU', 'HUN', 0, 0, '0000-00-00 00:00:00', 'HNG', 'HU', 'HUN', 'images/com_joomleague/database/flags/hu.png', 'HUN', 'H', 'HU'), (NULL, 'ICELAND__REPUBLIC_OF', 'IS', 'ISL', 0, 0, '0000-00-00 00:00:00', 'ISL', 'IC', 'ISL', 'images/com_joomleague/database/flags/is.png', 'ISL', 'IS', 'IL'), (NULL, 'INDIA__REPUBLIC_OF', 'IN', 'IND', 0, 0, '0000-00-00 00:00:00', 'IND', 'IN', 'IND', 'images/com_joomleague/database/flags/in.png', 'IND', 'IND', 'IN'), (NULL, 'INDONESIA__REPUBLIC_OF', 'ID', 'IDN', 0, 0, '0000-00-00 00:00:00', 'INS', 'ID', 'INA', 'images/com_joomleague/database/flags/id.png', 'IDN', 'RI', 'ID'), (NULL, 'IRAN__ISLAMIC_REPUBLIC_OF', 'IR', 'IRN', 0, 0, '0000-00-00 00:00:00', 'IRN', 'IR', 'IRI', 'images/com_joomleague/database/flags/ir.png', 'IRN', 'IR', 'IR'), (NULL, 'IRAQ__REPUBLIC_OF', 'IQ', 'IRQ', 0, 0, '0000-00-00 00:00:00', 'IRQ', 'IZ', 'IRQ', 'images/com_joomleague/database/flags/iq.png', 'IRQ', 'IRQ', 'IQ'), (NULL, 'IRELAND', 'IE', 'IRL', 0, 0, '0000-00-00 00:00:00', 'IRL', 'EI', 'IRL', 'images/com_joomleague/database/flags/ie.png', 'IRL', 'IRL', 'IE'), (NULL, 'ISLE_OF_MAN', 'IM', 'IMN', 0, 0, '0000-00-00 00:00:00', '', 'IM', '', 'images/com_joomleague/database/flags/im.png', 'GBM', 'GBM', ''), (NULL, 'ISRAEL__STATE_OF', 'IL', 'ISR', 0, 0, '0000-00-00 00:00:00', 'ISR', 'IS', 'ISR', 'images/com_joomleague/database/flags/il.png', 'ISR', 'IL', 'IS'), (NULL, 'ITALY__ITALIAN_REPUBLIC', 'IT', 'ITA', 0, 0, '0000-00-00 00:00:00', 'I', 'IT', 'ITA', 'images/com_joomleague/database/flags/it.png', 'ITA', 'I', 'IY'), (NULL, 'JAMAICA', 'JM', 'JAM', 0, 0, '0000-00-00 00:00:00', 'JMC', 'JM', 'JAM', 'images/com_joomleague/database/flags/jm.png', 'JAM', 'JA', 'JM'), (NULL, 'JAPAN', 'JP', 'JPN', 0, 0, '0000-00-00 00:00:00', 'J', 'JA', 'JPN', 'images/com_joomleague/database/flags/jp.png', 'JPN', 'J', 'JP'), (NULL, 'JERSEY__BAILIWICK_OF', 'JE', 'JEY', 0, 0, '0000-00-00 00:00:00', '', 'JE', '', 'images/com_joomleague/database/flags/je.png', 'GBJ', 'GBJ', ''), (NULL, 'JORDAN__HASHEMITE_KINGDOM_OF', 'JO', 'JOR', 0, 0, '0000-00-00 00:00:00', 'JOR', 'JO', 'JOR', 'images/com_joomleague/database/flags/jo.png', 'JOR', 'HKJ', 'JD'), (NULL, 'KAZAKHSTAN__REPUBLIC_OF', 'KZ', 'KAZ', 0, 0, '0000-00-00 00:00:00', 'KAZ', 'KZ', 'KAZ', 'images/com_joomleague/database/flags/kz.png', 'KAZ', 'KZ', 'KZ'), (NULL, 'KENYA__REPUBLIC_OF', 'KE', 'KEN', 0, 0, '0000-00-00 00:00:00', 'KEN', 'KE', 'KEN', 'images/com_joomleague/database/flags/ke.png', 'KEN', 'EAK', 'KN'), (NULL, 'KIRIBATI__REPUBLIC_OF', 'KI', 'KIR', 0, 0, '0000-00-00 00:00:00', 'KIR', 'KR', 'KIR', 'images/com_joomleague/database/flags/ki.png', 'KIR', '', 'KB'), (NULL, 'KOREA__DEMOCRATIC_PEOPLE_S_REP', 'KP', 'PRK', 0, 0, '0000-00-00 00:00:00', 'KRE', 'KN', 'PRK', 'images/com_joomleague/database/flags/kp.png', 'PRK', '', 'KR'), (NULL, 'KOREA__REPUBLIC_OF', 'KR', 'KOR', 0, 0, '0000-00-00 00:00:00', 'KOR', 'KS', 'KOR', 'images/com_joomleague/database/flags/kr.png', 'KOR', 'ROK', 'KO'), (NULL, 'KUWAIT__STATE_OF', 'KW', 'KWT', 0, 0, '0000-00-00 00:00:00', 'KWT', 'KU', 'KUW', 'images/com_joomleague/database/flags/kw.png', 'KUW', 'KWT', 'KW'), (NULL, 'KYRGYZ_REPUBLIC', 'KG', 'KGZ', 0, 0, '0000-00-00 00:00:00', 'KGZ', 'KG', 'KGZ', 'images/com_joomleague/database/flags/kg.png', 'KGZ', 'KS', 'KG'), (NULL, 'LAO_PEOPLE_S_DEMOCRATIC_REPUBL', 'LA', 'LAO', 0, 0, '0000-00-00 00:00:00', 'LAO', 'LA', 'LAO', 'images/com_joomleague/database/flags/la.png', 'LAO', 'LAO', 'LA'), (NULL, 'LATVIA__REPUBLIC_OF', 'LV', 'LVA', 0, 0, '0000-00-00 00:00:00', 'LVA', 'LG', 'LAT', 'images/com_joomleague/database/flags/lv.png', 'LVA', 'LV', 'LV'), (NULL, 'LEBANON__LEBANESE_REPUBLIC', 'LB', 'LBN', 0, 0, '0000-00-00 00:00:00', 'LBN', 'LE', 'LIB', 'images/com_joomleague/database/flags/lb.png', 'LIB', 'RL', 'LB'), (NULL, 'LESOTHO__KINGDOM_OF', 'LS', 'LSO', 0, 0, '0000-00-00 00:00:00', 'LSO', 'LT', 'LES', 'images/com_joomleague/database/flags/ls.png', 'LES', 'LS', 'LS'), (NULL, 'LIBERIA__REPUBLIC_OF', 'LR', 'LBR', 0, 0, '0000-00-00 00:00:00', 'LBR', 'LI', 'LBR', 'images/com_joomleague/database/flags/lr.png', 'LBR', 'LB', 'LI'), (NULL, 'LIBYAN_ARAB_JAMAHIRIYA', 'LY', 'LBY', 0, 0, '0000-00-00 00:00:00', 'LBY', 'LY', 'LBA', 'images/com_joomleague/database/flags/ly.png', 'LBY', 'LAR', 'LY'), (NULL, 'LIECHTENSTEIN__PRINCIPALITY_OF', 'LI', 'LIE', 0, 0, '0000-00-00 00:00:00', 'LIE', 'LS', 'LIE', 'images/com_joomleague/database/flags/li.png', 'LIE', 'FL', ''), (NULL, 'LITHUANIA__REPUBLIC_OF', 'LT', 'LTU', 0, 0, '0000-00-00 00:00:00', 'LTU', 'LH', 'LTU', 'images/com_joomleague/database/flags/lt.png', 'LTU', 'LT', 'LT'), (NULL, 'LUXEMBOURG__GRAND_DUCHY_OF', 'LU', 'LUX', 0, 0, '0000-00-00 00:00:00', 'LUX', 'LU', 'LUX', 'images/com_joomleague/database/flags/lu.png', 'LUX', 'L', 'BX'), (NULL, 'MACAO__SPECIAL_ADMINISTRATIVE', 'MO', 'MAC', 0, 0, '0000-00-00 00:00:00', 'MAC', 'MC', 'MAC', 'images/com_joomleague/database/flags/mo.png', 'MAC', '', 'MU'), (NULL, 'MACEDONIA__THE_FORMER_YUGOSLAV', 'MK', 'MKD', 0, 0, '0000-00-00 00:00:00', 'MKD', 'MK', 'MKD', 'images/com_joomleague/database/flags/mk.png', 'MKD', 'MK', 'MJ'), (NULL, 'MADAGASCAR__REPUBLIC_OF', 'MG', 'MDG', 0, 0, '0000-00-00 00:00:00', 'MDG', 'MA', 'MAD', 'images/com_joomleague/database/flags/mg.png', 'MAD', 'RM', 'MG'), (NULL, 'MALAWI__REPUBLIC_OF', 'MW', 'MWI', 0, 0, '0000-00-00 00:00:00', 'MWI', 'MI', 'MAW', 'images/com_joomleague/database/flags/mw.png', 'MWI', 'MW', 'MW'), (NULL, 'MALAYSIA', 'MY', 'MYS', 0, 0, '0000-00-00 00:00:00', 'MLA', 'MY', 'MAS', 'images/com_joomleague/database/flags/my.png', 'MAS', 'MAL', 'MS'), (NULL, 'MALDIVES__REPUBLIC_OF', 'MV', 'MDV', 0, 0, '0000-00-00 00:00:00', 'MLD', 'MV', 'MDV', 'images/com_joomleague/database/flags/mv.png', 'MDV', '', 'MV'), (NULL, 'MALI__REPUBLIC_OF', 'ML', 'MLI', 0, 0, '0000-00-00 00:00:00', 'MLI', 'ML', 'MLI', 'images/com_joomleague/database/flags/ml.png', 'MLI', 'RMM', 'MI'), (NULL, 'MALTA__REPUBLIC_OF', 'MT', 'MLT', 0, 0, '0000-00-00 00:00:00', 'MLT', 'MT', 'MLT', 'images/com_joomleague/database/flags/mt.png', 'MLT', 'M', 'ML'), (NULL, 'MARSHALL_ISLANDS__REPUBLIC_OF', 'MH', 'MHL', 0, 0, '0000-00-00 00:00:00', 'MHL', 'RM', 'MSH', 'images/com_joomleague/database/flags/mh.png', 'MHL', '', 'MH'), (NULL, 'MARTINIQUE', 'MQ', 'MTQ', 0, 0, '0000-00-00 00:00:00', 'MRT', 'MB', 'MRT', 'images/com_joomleague/database/flags/mq.png', 'MTQ', 'F', 'MR'), (NULL, 'MAURITANIA__ISLAMIC_REPUBLIC_O', 'MR', 'MRT', 0, 0, '0000-00-00 00:00:00', 'MTN', 'MR', 'MTN', 'images/com_joomleague/database/flags/mr.png', 'MTN', 'RIM', 'MT'), (NULL, 'MAURITIUS__REPUBLIC_OF', 'MU', 'MUS', 0, 0, '0000-00-00 00:00:00', 'MAU', 'MP', 'MRI', 'images/com_joomleague/database/flags/mu.png', 'MRI', 'MS', 'MA'), (NULL, 'MAYOTTE', 'YT', 'MYT', 0, 0, '0000-00-00 00:00:00', 'MYT', 'MF', 'MAY', 'images/com_joomleague/database/flags/yt.png', 'MYT', '', ''), (NULL, 'MEXICO__UNITED_MEXICAN_STATES', 'MX', 'MEX', 0, 0, '0000-00-00 00:00:00', 'MEX', 'MX', 'MEX', 'images/com_joomleague/database/flags/mx.png', 'MEX', 'MEX', 'MX'), (NULL, 'MICRONESIA__FEDERATED_STATES_O', 'FM', 'FSM', 0, 0, '0000-00-00 00:00:00', 'FSM', 'FM', 'FSM', 'images/com_joomleague/database/flags/fm.png', 'FSM', '', ''), (NULL, 'MOLDOVA__REPUBLIC_OF', 'MD', 'MDA', 0, 0, '0000-00-00 00:00:00', 'MDA', 'MD', 'MDA', 'images/com_joomleague/database/flags/md.png', 'MDA', 'MD', 'RM'), (NULL, 'MONACO__PRINCIPALITY_OF', 'MC', 'MCO', 0, 0, '0000-00-00 00:00:00', 'MCO', 'MN', 'MON', 'images/com_joomleague/database/flags/mc.png', 'MON', 'MC', ''), (NULL, 'MONGOLIA', 'MN', 'MNG', 0, 0, '0000-00-00 00:00:00', 'MNG', 'MG', 'MGL', 'images/com_joomleague/database/flags/mn.png', 'MNG', 'MGL', 'MO'), (NULL, 'MONTENEGRO__REPUBLIC_OF', 'ME', 'MNE', 0, 0, '0000-00-00 00:00:00', 'MNE', 'MJ', 'MGO', 'images/com_joomleague/database/flags/me.png', 'MNE', '(NULLSe', ''), (NULL, 'MONTSERRAT', 'MS', 'MSR', 0, 0, '0000-00-00 00:00:00', 'MSR', 'MH', 'MNT', 'images/com_joomleague/database/flags/ms.png', 'MSR', '', ''), (NULL, 'MOROCCO__KINGDOM_OF', 'MA', 'MAR', 0, 0, '0000-00-00 00:00:00', 'MRC', 'MO', 'MAR', 'images/com_joomleague/database/flags/ma.png', 'MAR', 'MA', 'MC'), (NULL, 'MOZAMBIQUE__REPUBLIC_OF', 'MZ', 'MOZ', 0, 0, '0000-00-00 00:00:00', 'MOZ', 'MZ', 'MOZ', 'images/com_joomleague/database/flags/mz.png', 'MOZ', 'MOC', 'MZ'), (NULL, 'MYANMAR__UNION_OF', 'MM', 'MMR', 0, 0, '0000-00-00 00:00:00', 'MYA', 'BM', 'MYA', 'images/com_joomleague/database/flags/mm.png', 'MYA', 'BUR', 'BM'), (NULL, 'NAMIBIA__REPUBLIC_OF', 'NA', 'NAM', 0, 0, '0000-00-00 00:00:00', 'NMB', 'WA', 'NAM', 'images/com_joomleague/database/flags/na.png', 'NAM', 'NAM', 'NM'), (NULL, 'NAURU__REPUBLIC_OF', 'NR', 'NRU', 0, 0, '0000-00-00 00:00:00', 'NRU', 'NR', 'NRU', 'images/com_joomleague/database/flags/nr.png', 'NRU', 'NAU', 'NW'), (NULL, 'NEPAL__STATE_OF', 'NP', 'NPL', 0, 0, '0000-00-00 00:00:00', 'NPL', 'NP', 'NEP', 'images/com_joomleague/database/flags/np.png', 'NEP', 'NEP', 'NP'), (NULL, 'NETHERLANDS__THE', 'NL', 'NLD', 0, 0, '0000-00-00 00:00:00', 'HOL', 'NL', 'NED', 'images/com_joomleague/database/flags/nl.png', 'NED', 'NL', 'NL'), (NULL, 'NEW_CALEDONIA', 'NC', 'NCL', 0, 0, '0000-00-00 00:00:00', 'NCL', 'NC', 'NCD', 'images/com_joomleague/database/flags/nc.png', 'NCL', 'F', 'NC'), (NULL, 'NEW_ZEALAND', 'NZ', 'NZL', 0, 0, '0000-00-00 00:00:00', 'NZL', 'NZ', 'NZL', 'images/com_joomleague/database/flags/nz.png', 'NZL', 'NZ', 'NZ'), (NULL, 'NICARAGUA__REPUBLIC_OF', 'NI', 'NIC', 0, 0, '0000-00-00 00:00:00', 'NCG', 'NU', 'NCA', 'images/com_joomleague/database/flags/ni.png', 'NCA', 'NIC', 'NK'), (NULL, 'NIGER__REPUBLIC_OF', 'NE', 'NER', 0, 0, '0000-00-00 00:00:00', 'NGR', 'NG', 'NIG', 'images/com_joomleague/database/flags/ne.png', 'NIG', 'RN', 'NR'), (NULL, 'NIGERIA__FEDERAL_REPUBLIC_OF', 'NG', 'NGA', 0, 0, '0000-00-00 00:00:00', 'NIG', 'NI', 'NGR', 'images/com_joomleague/database/flags/ng.png', 'NGA', 'NGR', 'NI'), (NULL, 'NIUE', 'NU', 'NIU', 0, 0, '0000-00-00 00:00:00', 'NIU', 'NE', 'NIU', 'images/com_joomleague/database/flags/nu.png', 'NIU', 'NZ', ''), (NULL, 'NORFOLK_ISLAND', 'NF', 'NFK', 0, 0, '0000-00-00 00:00:00', 'NFK', 'NF', 'NFI', 'images/com_joomleague/database/flags/nf.png', 'NFK', 'AUS', 'NF'), (NULL, 'NORTHERN_MARIANA_ISLANDS__COMM', 'MP', 'MNP', 0, 0, '0000-00-00 00:00:00', 'MRA', 'CQ', 'NMA', 'images/com_joomleague/database/flags/mp.png', 'NMI', 'USA', 'MY'), (NULL, 'NORWAY__KINGDOM_OF', 'NO', 'NOR', 0, 0, '0000-00-00 00:00:00', 'NOR', 'NO', 'NOR', 'images/com_joomleague/database/flags/no.png', 'NOR', 'N', 'NO'), (NULL, 'OMAN__SULTANATE_OF', 'OM', 'OMN', 0, 0, '0000-00-00 00:00:00', 'OMA', 'MU', 'OMA', 'images/com_joomleague/database/flags/om.png', 'OMA', '', 'OM'), (NULL, 'PAKISTAN__ISLAMIC_REPUBLIC_OF', 'PK', 'PAK', 0, 0, '0000-00-00 00:00:00', 'PAK', 'PK', 'PAK', 'images/com_joomleague/database/flags/pk.png', 'PAK', 'PK', 'PK'), (NULL, 'PALAU__REPUBLIC_OF', 'PW', 'PLW', 0, 0, '0000-00-00 00:00:00', 'PLW', 'PS', 'PLW', 'images/com_joomleague/database/flags/pw.png', 'PLW', '', ''), (NULL, 'PALESTINIAN_TERRITORY__OCCUPIE', 'PS', 'PSE', 0, 0, '0000-00-00 00:00:00', '', 'GZ', 'PLE', 'images/com_joomleague/database/flags/ps.png', 'PLE', '', ''), (NULL, 'PANAMA__REPUBLIC_OF', 'PA', 'PAN', 0, 0, '0000-00-00 00:00:00', 'PNR', 'PM', 'PAN', 'images/com_joomleague/database/flags/pa.png', 'PAN', 'PA', 'PM'), (NULL, 'PAPUA_NEW_GUINEA__INDEPENDENT', 'PG', 'PNG', 0, 0, '0000-00-00 00:00:00', 'PNG', 'PP', 'PNG', 'images/com_joomleague/database/flags/pg.png', 'PNG', 'PNG', 'NG'), (NULL, 'PARAGUAY__REPUBLIC_OF', 'PY', 'PRY', 0, 0, '0000-00-00 00:00:00', 'PRG', 'PA', 'PAR', 'images/com_joomleague/database/flags/py.png', 'PAR', 'PY', 'PY'), (NULL, 'PERU__REPUBLIC_OF', 'PE', 'PER', 0, 0, '0000-00-00 00:00:00', 'PRU', 'PE', 'PER', 'images/com_joomleague/database/flags/pe.png', 'PER', 'PE', 'PR'), (NULL, 'PHILIPPINES__REPUBLIC_OF_THE', 'PH', 'PHL', 0, 0, '0000-00-00 00:00:00', 'PHL', 'RP', 'PHI', 'images/com_joomleague/database/flags/ph.png', 'PHI', 'RP', 'PH'), (NULL, 'PITCAIRN_ISLANDS', 'PN', 'PCN', 0, 0, '0000-00-00 00:00:00', 'PTC', 'PC', '', 'images/com_joomleague/database/flags/pn.png', 'PCN', '', 'PT'), (NULL, 'POLAND__REPUBLIC_OF', 'PL', 'POL', 0, 0, '0000-00-00 00:00:00', 'POL', 'PL', 'POL', 'images/com_joomleague/database/flags/pl.png', 'POL', 'PL', 'PL'), (NULL, 'PORTUGAL__PORTUGUESE_REPUBLIC', 'PT', 'PRT', 0, 0, '0000-00-00 00:00:00', 'POR', 'PO', 'POR', 'images/com_joomleague/database/flags/pt.png', 'POR', 'P', 'PO'), (NULL, 'PUERTO_RICO__COMMONWEALTH_OF', 'PR', 'PRI', 0, 0, '0000-00-00 00:00:00', 'PTR', 'RQ', 'PUR', 'images/com_joomleague/database/flags/pr.png', 'PUR', 'USA', 'PU'), (NULL, 'QATAR__STATE_OF', 'QA', 'QAT', 0, 0, '0000-00-00 00:00:00', 'QAT', 'QA', 'QAT', 'images/com_joomleague/database/flags/qa.png', 'QAT', 'Q', 'QT'), (NULL, 'REUNION', 'RE', 'REU', 0, 0, '0000-00-00 00:00:00', 'REU', 'RE', 'REU', 'images/com_joomleague/database/flags/re.png', 'REU', 'F', 'RE'), (NULL, 'ROMANIA', 'RO', 'ROU', 0, 0, '0000-00-00 00:00:00', 'ROU', 'RO', 'ROU', 'images/com_joomleague/database/flags/ro.png', 'ROU', 'RO', 'RO'), (NULL, 'RUSSIAN_FEDERATION', 'RU', 'RUS', 0, 0, '0000-00-00 00:00:00', 'RUS', 'RS', 'RUS', 'images/com_joomleague/database/flags/ru.png', 'RUS', 'RUS', 'RS'), (NULL, 'RWANDA__REPUBLIC_OF', 'RW', 'RWA', 0, 0, '0000-00-00 00:00:00', 'RRW', 'RW', 'RWA', 'images/com_joomleague/database/flags/rw.png', 'RWA', 'RWA', 'RW'), (NULL, 'SAINT_BARTHELEMY', 'BL', 'BLM', 0, 0, '0000-00-00 00:00:00', '', 'TB', '', 'images/com_joomleague/database/flags/bl.png', '', '', ''), (NULL, 'SAINT_HELENA', 'SH', 'SHN', 0, 0, '0000-00-00 00:00:00', 'SHN', 'SH', 'HEL', 'images/com_joomleague/database/flags/sh.png', 'SHN', '', 'HE'), (NULL, 'SAINT_KITTS_AND_NEVIS__FEDERAT', 'KN', 'KNA', 0, 0, '0000-00-00 00:00:00', 'KNA', 'SC', 'SKN', 'images/com_joomleague/database/flags/kn.png', 'SKN', '', 'AT'), (NULL, 'SAINT_LUCIA', 'LC', 'LCA', 0, 0, '0000-00-00 00:00:00', 'LCA', 'ST', 'LCA', 'images/com_joomleague/database/flags/lc.png', 'LCA', 'WL', 'LC'), (NULL, 'SAINT_MARTIN', 'MF', 'MAF', 0, 0, '0000-00-00 00:00:00', '', 'RN', '', 'images/com_joomleague/database/flags/mf.png', '', '', ''), (NULL, 'SAINT_PIERRE_AND_MIQUELON', 'PM', 'SPM', 0, 0, '0000-00-00 00:00:00', 'SPM', 'SB', 'SPM', 'images/com_joomleague/database/flags/pm.png', 'SPM', 'F', 'FP'), (NULL, 'SAINT_VINCENT_AND_THE_GRENADIN', 'VC', 'VCT', 0, 0, '0000-00-00 00:00:00', 'VCT', 'VC', 'VIN', 'images/com_joomleague/database/flags/vc.png', 'VIN', 'WV', 'VG'), (NULL, 'SAMOA__INDEPENDENT_STATE_OF', 'WS', 'WSM', 0, 0, '0000-00-00 00:00:00', 'SMO', 'WS', 'SAM', 'images/com_joomleague/database/flags/ws.png', 'SAM', 'WS', 'ZM'), (NULL, 'SAN_MARINO__REPUBLIC_OF', 'SM', 'SMR', 0, 0, '0000-00-00 00:00:00', 'SMR', 'SM', 'SMR', 'images/com_joomleague/database/flags/sm.png', 'SMR', 'RSM', ''), (NULL, 'SAO_TOME_AND_PRINCIPE__DEMOCRA', 'ST', 'STP', 0, 0, '0000-00-00 00:00:00', 'STP', 'TP', 'STP', 'images/com_joomleague/database/flags/st.png', 'STP', '', 'TP'), (NULL, 'SAUDI_ARABIA__KINGDOM_OF', 'SA', 'SAU', 0, 0, '0000-00-00 00:00:00', 'ARS', 'SA', 'KSA', 'images/com_joomleague/database/flags/sa.png', 'KSA', 'SA', 'SD'), (NULL, 'SENEGAL__REPUBLIC_OF', 'SN', 'SEN', 0, 0, '0000-00-00 00:00:00', 'SEN', 'SG', 'SEN', 'images/com_joomleague/database/flags/sn.png', 'SEN', 'SN', 'SG'), (NULL, 'SERBIA__REPUBLIC_OF', 'RS', 'SRB', 0, 0, '0000-00-00 00:00:00', 'SRB', 'RI', 'SRB', 'images/com_joomleague/database/flags/rs.png', 'SRB', 'SCG', 'YG'), (NULL, 'SEYCHELLES__REPUBLIC_OF', 'SC', 'SYC', 0, 0, '0000-00-00 00:00:00', 'SEY', 'SE', 'SEY', 'images/com_joomleague/database/flags/sc.png', 'SEY', 'SY', 'SC'), (NULL, 'SIERRA_LEONE__REPUBLIC_OF', 'SL', 'SLE', 0, 0, '0000-00-00 00:00:00', 'SRL', 'SL', 'SLE', 'images/com_joomleague/database/flags/sl.png', 'SLE', 'WAL', 'SL'), (NULL, 'SINGAPORE__REPUBLIC_OF', 'SG', 'SGP', 0, 0, '0000-00-00 00:00:00', 'SNG', 'SN', 'SIN', 'images/com_joomleague/database/flags/sg.png', 'SIN', 'SGP', 'SR'), (NULL, 'SINT__MAARTEN', 'SX', 'SXM', 0, 0, '0000-00-00 00:00:00', '', 'NN', '', 'images/com_joomleague/database/flags/sx.png', '', '', ''), (NULL, 'SLOVAKIA__SLOVAK REPUBLIC_', 'SK', 'SVK', 0, 0, '0000-00-00 00:00:00', 'SVK', 'LO', 'SVK', 'images/com_joomleague/database/flags/sk.png', 'SVK', 'SK', 'SQ'), (NULL, 'SLOVENIA__REPUBLIC_OF', 'SI', 'SVN', 0, 0, '0000-00-00 00:00:00', 'SVN', 'SI', 'SLO', 'images/com_joomleague/database/flags/si.png', 'SVN', 'SLO', 'LJ'), (NULL, 'SOLOMON_ISLANDS', 'SB', 'SLB', 0, 0, '0000-00-00 00:00:00', 'SLM', 'BP', 'SOL', 'images/com_joomleague/database/flags/sb.png', 'SOL', '', 'SO'), (NULL, 'SOMALIA__SOMALI_REPUBLIC', 'SO', 'SOM', 0, 0, '0000-00-00 00:00:00', 'SOM', 'SO', 'SOM', 'images/com_joomleague/database/flags/so.png', 'SOM', 'SO', 'SI'), (NULL, 'SOUTH_AFRICA__REPUBLIC_OF', 'ZA', 'ZAF', 0, 0, '0000-00-00 00:00:00', 'AFS', 'SF', 'RSA', 'images/com_joomleague/database/flags/za.png', 'RSA', 'ZA', 'ZA'), (NULL, 'SOUTH_GEORGIA_AND_THE_SOUTH_SA', 'GS', 'SGS', 0, 0, '0000-00-00 00:00:00', '', 'SX', '', 'images/com_joomleague/database/flags/gs.png', '', '', ''), (NULL, 'SOUTH__SUDAN', 'SS', 'SSD', 0, 0, '0000-00-00 00:00:00', 'SSD', 'OD', '', 'images/com_joomleague/database/flags/ss.png', '', '', ''), (NULL, 'SPAIN__KINGDOM_OF', 'ES', 'ESP', 0, 0, '0000-00-00 00:00:00', 'E', 'SP', 'ESP', 'images/com_joomleague/database/flags/es.png', 'ESP', 'E', 'SP'), (NULL, 'SRI_LANKA__DEMOCRATIC_SOCIALIS', 'LK', 'LKA', 0, 0, '0000-00-00 00:00:00', 'CLN', 'CE', 'SRI', 'images/com_joomleague/database/flags/lk.png', 'SRI', 'CL', 'SB'), (NULL, 'SUDAN__REPUBLIC_OF', 'SD', 'SDN', 0, 0, '0000-00-00 00:00:00', 'SDN', 'SU', 'SUD', 'images/com_joomleague/database/flags/sd.png', 'SUD', 'SUD', 'SU'), (NULL, 'SURINAME__REPUBLIC_OF', 'SR', 'SUR', 0, 0, '0000-00-00 00:00:00', 'SUR', 'NS', 'SUR', 'images/com_joomleague/database/flags/sr.png', 'SUR', 'SME', 'SM'), (NULL, 'SVALBARD___JAN_MAYEN_ISLANDS', 'SJ', 'SJM', 0, 0, '0000-00-00 00:00:00', 'NOR', 'SV', '', 'images/com_joomleague/database/flags/sj.png', '', '', 'SZ'), (NULL, 'SWAZILAND__KINGDOM_OF', 'SZ', 'SWZ', 0, 0, '0000-00-00 00:00:00', 'SWZ', 'WZ', 'SWZ', 'images/com_joomleague/database/flags/sz.png', 'SWZ', 'SD', 'SV'), (NULL, 'SWEDEN__KINGDOM_OF', 'SE', 'SWE', 0, 0, '0000-00-00 00:00:00', 'S', 'SW', 'SWE', 'images/com_joomleague/database/flags/se.png', 'SWE', 'S', 'SN'), (NULL, 'SWITZERLAND__SWISS_CONFEDERATI', 'CH', 'CHE', 0, 0, '0000-00-00 00:00:00', 'SUI', 'SZ', 'SUI', 'images/com_joomleague/database/flags/ch.png', 'SUI', 'CH', 'SW'), (NULL, 'SYRIAN_ARAB_REPUBLIC', 'SY', 'SYR', 0, 0, '0000-00-00 00:00:00', 'SYR', 'SY', 'SYR', 'images/com_joomleague/database/flags/sy.png', 'SYR', 'SYR', 'SY'), (NULL, 'TAIWAN', 'TW', 'TWN', 0, 0, '0000-00-00 00:00:00', '', 'TW', 'TPE', 'images/com_joomleague/database/flags/tw.png', 'TPE', 'RC', ''), (NULL, 'TAJIKISTAN__REPUBLIC_OF', 'TJ', 'TJK', 0, 0, '0000-00-00 00:00:00', 'TJK', 'TI', 'TJK', 'images/com_joomleague/database/flags/tj.png', 'TJK', 'TJ', 'TA'), (NULL, 'TANZANIA__UNITED_REPUBLIC_OF', 'TZ', 'TZA', 0, 0, '0000-00-00 00:00:00', 'TZA', 'TZ', 'TAN', 'images/com_joomleague/database/flags/tz.png', 'TAN', 'EAT', 'TN'), (NULL, 'THAILAND__KINGDOM_OF', 'TH', 'THA', 0, 0, '0000-00-00 00:00:00', 'THA', 'TH', 'THA', 'images/com_joomleague/database/flags/th.png', 'THA', 'T', 'TH'), (NULL, 'TIMOR-LESTE_DEMOCRATIC_REPUBL', 'TL', 'TLS', 0, 0, '0000-00-00 00:00:00', 'TLS', 'TT', 'TLS', 'images/com_joomleague/database/flags/tl.png', 'TLS', '', 'TM'), (NULL, 'TOGO__TOGOLESE_REPUBLIC', 'TG', 'TGO', 0, 0, '0000-00-00 00:00:00', 'TGO', 'TO', 'TOG', 'images/com_joomleague/database/flags/tg.png', 'TOG', 'TG', 'TG'), (NULL, 'TOKELAU', 'TK', 'TKL', 0, 0, '0000-00-00 00:00:00', 'TKL', 'TL', '', 'images/com_joomleague/database/flags/tk.png', 'TKL', 'NZ', 'TK'), (NULL, 'TONGA__KINGDOM_OF', 'TO', 'TON', 0, 0, '0000-00-00 00:00:00', 'TON', 'TN', 'TGA', 'images/com_joomleague/database/flags/to.png', 'TGA', '', 'TO'), (NULL, 'TRINIDAD_AND_TOBAGO__REPUBLIC', 'TT', 'TTO', 0, 0, '0000-00-00 00:00:00', 'TRD', 'TD', 'TRI', 'images/com_joomleague/database/flags/tt.png', 'TRI', 'TT', 'TD'), (NULL, 'TUNISIA__TUNISIAN_REPUBLIC', 'TN', 'TUN', 0, 0, '0000-00-00 00:00:00', 'TUN', 'TS', 'TUN', 'images/com_joomleague/database/flags/tn.png', 'TUN', 'TN', 'TS'), (NULL, 'TURKEY__REPUBLIC_OF', 'TR', 'TUR', 0, 0, '0000-00-00 00:00:00', 'TUR', 'TU', 'TUR', 'images/com_joomleague/database/flags/tr.png', 'TUR', 'TR', 'TU'), (NULL, 'TURKMENISTAN', 'TM', 'TKM', 0, 0, '0000-00-00 00:00:00', 'TKM', 'TX', 'TKM', 'images/com_joomleague/database/flags/tm.png', 'TKM', 'TM', 'TR'), (NULL, 'TURKS_AND_CAICOS_ISLANDS', 'TC', 'TCA', 0, 0, '0000-00-00 00:00:00', 'TCA', 'TK', 'TKS', 'images/com_joomleague/database/flags/tc.png', 'TCA', '', 'TI'), (NULL, 'TUVALU', 'TV', 'TUV', 0, 0, '0000-00-00 00:00:00', 'TUV', 'TV', 'TUV', 'images/com_joomleague/database/flags/tv.png', 'TUV', '', 'TV'), (NULL, 'UGANDA__REPUBLIC_OF', 'UG', 'UGA', 0, 0, '0000-00-00 00:00:00', 'UGA', 'UG', 'UGA', 'images/com_joomleague/database/flags/ug.png', 'UGA', 'EAU', 'UG'), (NULL, 'UKRAINE', 'UA', 'UKR', 0, 0, '0000-00-00 00:00:00', 'UKR', 'UP', 'UKR', 'images/com_joomleague/database/flags/ua.png', 'UKR', 'UA', 'UR'), (NULL, 'UNITED_ARAB_EMIRATES', 'AE', 'ARE', 0, 0, '0000-00-00 00:00:00', 'UAE', 'AE', 'UAE', 'images/com_joomleague/database/flags/ae.png', 'UAE', '', 'ER'), (NULL, 'UNITED_KINGDOM_OF_GREAT_BRITAIN', 'GB', 'GBR', 0, 0, '0000-00-00 00:00:00', 'G', 'UK', 'GBR', 'images/com_joomleague/database/flags/gb.png', '', 'GB', 'UK'), (NULL, 'UNITED_STATES_MINOR_OUTLYING_I', 'UM', 'UMI', 0, 0, '0000-00-00 00:00:00', '', 'a', '', 'images/com_joomleague/database/flags/um.png', '', 'USA', ''), (NULL, 'UNITED_STATES_OF_AMERICA', 'US', 'USA', 0, 0, '0000-00-00 00:00:00', 'USA', 'US', 'USA', 'images/com_joomleague/database/flags/us.png', 'USA', 'USA', 'US'), (NULL, 'URUGUAY__EASTERN_REPUBLIC_OF', 'UY', 'URY', 0, 0, '0000-00-00 00:00:00', 'URG', 'UY', 'URU', 'images/com_joomleague/database/flags/uy.png', 'URU', 'ROU', 'UY'), (NULL, 'UZBEKISTAN__REPUBLIC_OF', 'UZ', 'UZB', 0, 0, '0000-00-00 00:00:00', 'UZB', 'UZ', 'UZB', 'images/com_joomleague/database/flags/uz.png', 'UZB', 'UZ', 'UZ'), (NULL, 'VANUATU__REPUBLIC_OF', 'VU', 'VUT', 0, 0, '0000-00-00 00:00:00', 'VUT', 'NH', 'VAN', 'images/com_joomleague/database/flags/vu.png', 'VAN', '', 'NV'), (NULL, 'HOLY_SEE__VATICAN_CITY_STATE_', 'VA', 'VAT', 0, 0, '0000-00-00 00:00:00', 'CVA', 'VT', '', 'images/com_joomleague/database/flags/va.png', 'VAT', 'V', ''), (NULL, 'VENEZUELA__BOLIVARIAN_REPUBLIC', 'VE', 'VEN', 0, 0, '0000-00-00 00:00:00', 'VEN', 'VE', 'VEN', 'images/com_joomleague/database/flags/ve.png', 'VEN', 'YV', 'VN'), (NULL, 'VIETNAM__SOCIALIST_REPUBLIC_OF', 'VN', 'VNM', 0, 0, '0000-00-00 00:00:00', 'VTN', 'VM', 'VIE', 'images/com_joomleague/database/flags/vn.png', 'VIE', 'VN', 'VS'), (NULL, 'BRITISH_VIRGIN_ISLANDS', 'VG', 'VGB', 0, 0, '0000-00-00 00:00:00', 'VRG', 'VI', 'IVB', 'images/com_joomleague/database/flags/vg.png', 'VGB', 'BVI', 'VI'), (NULL, 'UNITED_STATES_VIRGIN_ISLANDS', 'VI', 'VIR', 0, 0, '0000-00-00 00:00:00', 'VIR', 'VQ', 'ISV', 'images/com_joomleague/database/flags/vi.png', 'VIR', 'USA', 'VI'), (NULL, 'WALLIS_AND_FUTUNA', 'WF', 'WLF', 0, 0, '0000-00-00 00:00:00', 'WAL', 'WF', 'WAF', 'images/com_joomleague/database/flags/wf.png', 'WLF', 'F', 'FW'), (NULL, 'WESTERN_SAHARA', 'EH', 'ESH', 0, 0, '0000-00-00 00:00:00', 'AOE', 'WI', '', 'images/com_joomleague/database/flags/eh.png', 'SAH', '', ''), (NULL, 'YEMEN', 'YE', 'YEM', 0, 0, '0000-00-00 00:00:00', 'YEM', 'YM', 'YEM', 'images/com_joomleague/database/flags/ye.png', 'YEM', 'YAR', 'YE'), (NULL, 'ZAMBIA__REPUBLIC_OF', 'ZM', 'ZMB', 0, 0, '0000-00-00 00:00:00', 'ZMB', 'ZA', 'ZAM', 'images/com_joomleague/database/flags/zm.png', 'ZAM', 'Z', 'ZB'), (NULL, 'ZIMBABWE__REPUBLIC_OF', 'ZW', 'ZWE', 0, 0, '0000-00-00 00:00:00', 'ZWE', 'ZI', 'ZIM', 'images/com_joomleague/database/flags/zw.png', 'ZIM', 'ZW', 'ZW'), (NULL, 'WALES', '', 'WAL', 0, 0, '2013-02-18 14:19:03', '', '', '', 'images/com_joomleague/database/flags/22px-flag_of_wales_2_svg_1361191015.png', 'WAL', '', ''), (NULL, 'SCOTLAND', 'KS', 'SCO', 0, 0, '2013-02-18 14:18:51', '', '', '', 'images/com_joomleague/database/flags/22px-flag_of_scotland_svg_1361191116.png', 'SCO', '', ''), (NULL, 'EAST__GERMANY', '', 'DDR', 0, 0, '2013-02-18 14:18:40', '', '', 'GDR', 'images/com_joomleague/database/flags/22px-flag_of_east_germany_svg_1361191203.png', 'GDR', '', ''), (NULL, 'CZECHOSLOVAKIA', '', 'CSK', 0, 0, '2013-02-18 14:18:27', '', '', 'TCH', 'images/com_joomleague/database/flags/22px-flag_of_czechoslovakia_svg_1361191420.png', 'TCH', '', ''), (NULL, 'SOVIET__UNION', '', 'SUN', 0, 0, '2013-02-18 14:18:08', '', '', 'URS', 'images/com_joomleague/database/flags/22px-flag_of_the_soviet_union_svg_1361191541.png', 'URS', '', ''), (NULL, 'ZAIRE', '', 'ZAR', 0, 0, '2013-02-18 14:17:53', '', '', 'ZAI', 'images/com_joomleague/database/flags/22px-flag_of_zaire_svg_1361191599.png', 'ZAI', '', ''), (NULL, 'SOUTH__YEMEN', '', 'YMD', 0, 0, '2013-02-18 14:17:38', '', '', 'YMD', 'images/com_joomleague/database/flags/22px-flag_of_south_yemen_svg_1361191769.png', 'SYE', '', ''), (NULL, 'DAHOMEY', '', 'DHY', 0, 0, '2013-02-18 14:17:11', '', '', 'DAH', 'images/com_joomleague/database/flags/22px-flag_of_benin_svg_1361196684.png', 'DAH', '', ''), (NULL, 'RHODESIA', '', 'RHO', 0, 0, '2013-02-18 14:15:57', '', '', 'RHO', 'images/com_joomleague/database/flags/22px-flag_of_rhodesia_svg_1361196944.png', 'RHO', '', '');
SQL =
--
-- Daten für Tabelle `#__joomleague_countries`
--
INSERT INTO `#__joomleague_countries` (`id`, `name`, `alpha2`, `alpha3`, `ordering`, `checked_out`, `checked_out_time`, `itu`, `fips`, `ioc`, `picture`, `fifa`, `ds`, `wmo`) VALUES
(NULL, 'AFGHANISTAN__ISLAMIC_REPUBLIC', 'AF', 'AFG', 0, 0, '0000-00-00 00:00:00', 'AFG', 'AF', 'AFG', 'images/com_joomleague/database/flags/af.png', 'AFG', 'AFG', 'AF'),
(NULL, 'ALAND_ISLANDS', 'AX', 'ALA', 0, 0, '0000-00-00 00:00:00', '', '', '', 'images/com_joomleague/database/flags/ax.png', 'ALD', 'FIN', ''),
(NULL, 'ALBANIA__REPUBLIC_OF', 'AL', 'ALB', 0, 0, '0000-00-00 00:00:00', 'ALB', 'AL', 'ALB', 'images/com_joomleague/database/flags/al.png', 'ALB', 'AL', 'AB'),
(NULL, 'ALGERIA__PEOPLE_S_DEMOCRATIC_REPUBLIC', 'DZ', 'DZA', 0, 0, '0000-00-00 00:00:00', 'ALG', 'AG', 'ALG', 'images/com_joomleague/database/flags/dz.png', 'ALG', 'DZ', 'AL'),
(NULL, 'AMERICAN_SAMOA', 'AS', 'ASM', 0, 0, '0000-00-00 00:00:00', 'SMA', 'AQ', 'ASA', 'images/com_joomleague/database/flags/as.png', 'ASA', 'USA', ''),
(NULL, 'ANDORRA__PRINCIPALITY_OF', 'AD', 'AND', 0, 0, '0000-00-00 00:00:00', 'AND', 'AN', 'AND', 'images/com_joomleague/database/flags/ad.png', 'AND', 'AND', ''),
(NULL, 'ANGOLA__REPUBLIC_OF', 'AO', 'AGO', 0, 0, '0000-00-00 00:00:00', 'AGL', 'AO', 'ANG', 'images/com_joomleague/database/flags/ao.png', 'ANG', '', 'AN'),
(NULL, 'ANGUILLA', 'AI', 'AIA', 0, 0, '0000-00-00 00:00:00', 'AIA', 'AV', 'AIA', 'images/com_joomleague/database/flags/ai.png', 'AIA', '', ''),
(NULL, 'ANTARCTICA__THE TERRITORY SOUT', 'AQ', 'ATA', 0, 0, '0000-00-00 00:00:00', '', 'AY', '', 'images/com_joomleague/database/flags/aq.png', 'ROS', '', 'AA'),
(NULL, 'ANTIGUA_AND_BARBUDA', 'AG', 'ATG', 0, 0, '0000-00-00 00:00:00', 'ATG', 'AC', 'ANT', 'images/com_joomleague/database/flags/ag.png', 'ATG', '', 'AT'),
(NULL, 'ARGENTINA__ARGENTINE_REPUBLIC', 'AR', 'ARG', 0, 0, '0000-00-00 00:00:00', 'ARG', 'AR', 'ARG', 'images/com_joomleague/database/flags/ar.png', 'ARG', 'RA', 'AG'),
(NULL, 'ARMENIA__REPUBLIC_OF', 'AM', 'ARM', 0, 0, '0000-00-00 00:00:00', 'ARM', 'AM', 'ARM', 'images/com_joomleague/database/flags/am.png', 'ARM', 'AM', 'AY'),
(NULL, 'ARUBA', 'AW', 'ABW', 0, 0, '0000-00-00 00:00:00', 'ABW', 'AA', 'ARU', 'images/com_joomleague/database/flags/aw.png', 'ARU', '', 'NU'),
(NULL, 'AUSTRALIA__COMMONWEALTH_OF', 'AU', 'AUS', 0, 0, '0000-00-00 00:00:00', 'AUS', 'AS', 'AUS', 'images/com_joomleague/database/flags/au.png', 'AUS', 'AUS', 'AU'),
(NULL, 'AUSTRIA__REPUBLIC_OF', 'AT', 'AUT', 0, 0, '0000-00-00 00:00:00', 'AUT', 'AU', 'AUT', 'images/com_joomleague/database/flags/at.png', 'AUT', 'A', 'OS'),
(NULL, 'AZERBAIJAN__REPUBLIC_OF', 'AZ', 'AZE', 0, 0, '0000-00-00 00:00:00', 'AZE', 'AJ', 'AZE', 'images/com_joomleague/database/flags/az.png', 'AZE', 'AZ', 'AJ'),
(NULL, 'BAHAMAS__COMMONWEALTH_OF_THE', 'BS', 'BHS', 0, 0, '0000-00-00 00:00:00', 'BAH', 'BF', 'BAH', 'images/com_joomleague/database/flags/bs.png', 'BAH', 'BS', 'BA'),
(NULL, 'BAHRAIN__KINGDOM_OF', 'BH', 'BHR', 0, 0, '0000-00-00 00:00:00', 'BHR', 'BA', 'BRN', 'images/com_joomleague/database/flags/bh.png', 'BHR', 'BRN', 'BN'),
(NULL, 'BANGLADESH__PEOPLE_S_REPUBLIC', 'BD', 'BGD', 0, 0, '0000-00-00 00:00:00', 'BGD', 'BG', 'BAN', 'images/com_joomleague/database/flags/bd.png', 'BAN', 'BD', 'BW'),
(NULL, 'BARBADOS', 'BB', 'BRB', 0, 0, '0000-00-00 00:00:00', 'BRB', 'BB', 'BAR', 'images/com_joomleague/database/flags/bb.png', 'BRB', 'BDS', 'BR'),
(NULL, 'BELARUS__REPUBLIC_OF', 'BY', 'BLR', 0, 0, '0000-00-00 00:00:00', 'BLR', 'BO', 'BLR', 'images/com_joomleague/database/flags/by.png', 'BLR', 'BY', 'BY'),
(NULL, 'BELGIUM__KINGDOM_OF', 'BE', 'BEL', 0, 0, '0000-00-00 00:00:00', 'BEL', 'BE', 'BEL', 'images/com_joomleague/database/flags/be.png', 'BEL', 'B', 'BX'),
(NULL, 'BELIZE', 'BZ', 'BLZ', 0, 0, '0000-00-00 00:00:00', 'BLZ', 'BH', 'BIZ', 'images/com_joomleague/database/flags/bz.png', 'BLZ', 'BZ', 'BH'),
(NULL, 'BENIN_REPUBLIC_OF', 'BJ', 'BEN', 0, 0, '0000-00-00 00:00:00', 'BEN', 'BN', 'BEN', 'images/com_joomleague/database/flags/bj.png', 'BEN', 'DY', 'BJ'),
(NULL, 'BERMUDA', 'BM', 'BMU', 0, 0, '0000-00-00 00:00:00', 'BER', 'BD', 'BER', 'images/com_joomleague/database/flags/bm.png', 'BER', '', 'BE'),
(NULL, 'BHUTAN_KINGDOM_OF', 'BT', 'BTN', 0, 0, '0000-00-00 00:00:00', 'BTN', 'BT', 'BHU', 'images/com_joomleague/database/flags/bt.png', 'BHU', '', ''),
(NULL, 'BOLIVIA__REPUBLIC_OF', 'BO', 'BOL', 0, 0, '0000-00-00 00:00:00', 'BOL', 'BL', 'BOL', 'images/com_joomleague/database/flags/bo.png', 'BOL', 'BOL', 'BO'),
(NULL, 'BONAIRE__SINT_EUSTATIUS_AND_SABA', 'BQ', 'BES', 0, 0, '0000-00-00 00:00:00', 'ATN', 'NL', 'AHO', 'images/com_joomleague/database/flags/bq.png', 'ANT', 'NA', 'NU'),
(NULL, 'BOSNIA_AND_HERZEGOVINA', 'BA', 'BIH', 0, 0, '0000-00-00 00:00:00', 'BIH', 'BK', 'BIH', 'images/com_joomleague/database/flags/ba.png', 'BIH', 'BIH', 'BG'),
(NULL, 'BOTSWANA__REPUBLIC_OF', 'BW', 'BWA', 0, 0, '0000-00-00 00:00:00', 'BOT', 'BC', 'BOT', 'images/com_joomleague/database/flags/bw.png', 'BOT', 'BW', 'BC'),
(NULL, 'BOUVET_ISLAND__BOUVETOYA_', 'BV', 'BVT', 0, 0, '0000-00-00 00:00:00', '', 'BV', '', 'images/com_joomleague/database/flags/bv.png', '', '', 'BV'),
(NULL, 'BRAZIL__FEDERATIVE_REPUBLIC_OF', 'BR', 'BRA', 0, 0, '0000-00-00 00:00:00', 'B', 'BR', 'BRA', 'images/com_joomleague/database/flags/br.png', 'BRA', 'BR', 'BZ'),
(NULL, 'BRITISH_INDIAN_OCEAN_TERRITORY', 'IO', 'IOT', 0, 0, '0000-00-00 00:00:00', 'BIO', 'IO', '', 'images/com_joomleague/database/flags/io.png', '', '', ''),
(NULL, 'BRUNEI_DARUSSALAM', 'BN', 'BRN', 0, 0, '0000-00-00 00:00:00', 'BRU', 'BX', 'BRU', 'images/com_joomleague/database/flags/bn.png', 'BRU', 'BRU', 'BD'),
(NULL, 'BULGARIA__REPUBLIC_OF', 'BG', 'BGR', 0, 0, '0000-00-00 00:00:00', 'BUL', 'BU', 'BUL', 'images/com_joomleague/database/flags/bg.png', 'BUL', 'BG', 'BU'),
(NULL, 'BURKINA_FASO', 'BF', 'BFA', 0, 0, '0000-00-00 00:00:00', 'BFA', 'UV', 'BUR', 'images/com_joomleague/database/flags/bf.png', 'BFA', 'BF', 'HV'),
(NULL, 'BURUNDI__REPUBLIC_OF', 'BI', 'BDI', 0, 0, '0000-00-00 00:00:00', 'BDI', 'BY', 'BDI', 'images/com_joomleague/database/flags/bi.png', 'BDI', 'RU', 'BI'),
(NULL, 'CAMBODIA__KINGDOM_OF', 'KH', 'KHM', 0, 0, '0000-00-00 00:00:00', 'CBG', 'CB', 'CAM', 'images/com_joomleague/database/flags/kh.png', 'CAM', 'K', 'KP'),
(NULL, 'CAMEROON__REPUBLIC_OF', 'CM', 'CMR', 0, 0, '0000-00-00 00:00:00', 'CME', 'CM', 'CMR', 'images/com_joomleague/database/flags/cm.png', 'CMR', 'CAM', 'CM'),
(NULL, 'CANADA', 'CA', 'CAN', 0, 0, '0000-00-00 00:00:00', 'CAN', 'CA', 'CAN', 'images/com_joomleague/database/flags/ca.png', 'CAN', 'CDN', 'CN'),
(NULL, 'CAPE_VERDE__REPUBLIC_OF', 'CV', 'CPV', 0, 0, '0000-00-00 00:00:00', 'CPV', 'CV', 'CPV', 'images/com_joomleague/database/flags/cv.png', 'CPV', '', 'CV'),
(NULL, 'CAYMAN_ISLANDS', 'KY', 'CYM', 0, 0, '0000-00-00 00:00:00', 'CYM', 'CJ', 'CAY', 'images/com_joomleague/database/flags/ky.png', 'CAY', '', 'GC'),
(NULL, 'CENTRAL_AFRICAN_REPUBLIC', 'CF', 'CAF', 0, 0, '0000-00-00 00:00:00', 'CAF', 'CT', 'CAF', 'images/com_joomleague/database/flags/cf.png', 'CTA', 'RCA', 'CE'),
(NULL, 'CHAD__REPUBLIC_OF', 'TD', 'TCD', 0, 0, '0000-00-00 00:00:00', 'TCD', 'CD', 'CHA', 'images/com_joomleague/database/flags/td.png', 'CHA', 'TCH', 'CD'),
(NULL, 'CHILE__REPUBLIC_OF', 'CL', 'CHL', 0, 0, '0000-00-00 00:00:00', 'CHL', 'CI', 'CHI', 'images/com_joomleague/database/flags/cl.png', 'CHI', 'RCH', 'CH'),
(NULL, 'CHINA__PEOPLE_S_REPUBLIC_OF', 'CN', 'CHN', 0, 0, '0000-00-00 00:00:00', 'CHN', 'CH', 'CHN', 'images/com_joomleague/database/flags/cn.png', 'CHN', '', 'CI'),
(NULL, 'CHRISTMAS_ISLAND', 'CX', 'CXR', 0, 0, '0000-00-00 00:00:00', 'CHR', 'KT', '', 'images/com_joomleague/database/flags/cx.png', 'CXR', 'AUS', 'KI'),
(NULL, 'COCOS__KEELING__ISLANDS', 'CC', 'CCK', 0, 0, '0000-00-00 00:00:00', 'ICO', 'CK', '', 'images/com_joomleague/database/flags/cc.png', 'CCK', 'AUS', 'KK'),
(NULL, 'COLOMBIA__REPUBLIC_OF', 'CO', 'COL', 0, 0, '0000-00-00 00:00:00', 'CLM', 'CO', 'COL', 'images/com_joomleague/database/flags/co.png', 'COL', 'CO', 'CO'),
(NULL, 'COMOROS__UNION_OF_THE', 'KM', 'COM', 0, 0, '0000-00-00 00:00:00', 'COM', 'CN', 'COM', 'images/com_joomleague/database/flags/km.png', 'COM', '', 'IC'),
(NULL, 'CONGO__REPUBLIC_OF_THE', 'CG', 'COG', 0, 0, '0000-00-00 00:00:00', 'COG', 'CF', 'CGO', 'images/com_joomleague/database/flags/cg.png', 'CGO', 'RCB', 'CG'),
(NULL, 'CONGO__DEMOCRATIC_REPUBLIC_OF', 'CD', 'COD', 0, 0, '0000-00-00 00:00:00', 'COD', 'CG', 'COD', 'images/com_joomleague/database/flags/cd.png', 'COD', 'ZRE', 'ZR'),
(NULL, 'COOK_ISLANDS', 'CK', 'COK', 0, 0, '0000-00-00 00:00:00', 'CKH', 'CW', 'COK', 'images/com_joomleague/database/flags/ck.png', 'COK', 'NZ', 'KU'),
(NULL, 'COSTA_RICA__REPUBLIC_OF', 'CR', 'CRI', 0, 0, '0000-00-00 00:00:00', 'CTR', 'CS', 'CRC', 'images/com_joomleague/database/flags/cr.png', 'CRC', 'CR', 'CS'),
(NULL, 'COTE_D_IVOIRE__REPUBLIC_OF', 'CI', 'CIV', 0, 0, '0000-00-00 00:00:00', 'CTI', 'IV', 'CIV', 'images/com_joomleague/database/flags/ci.png', 'CIV', 'CI', 'IV'),
(NULL, 'CROATIA__REPUBLIC_OF', 'HR', 'HRV', 0, 0, '0000-00-00 00:00:00', 'HRV', 'HR', 'CRO', 'images/com_joomleague/database/flags/hr.png', 'CRO', 'HR', 'RH'),
(NULL, 'CUBA__REPUBLIC_OF', 'CU', 'CUB', 0, 0, '0000-00-00 00:00:00', 'CUB', 'CU', 'CUB', 'images/com_joomleague/database/flags/cu.png', 'CUB', 'C', 'CU'),
(NULL, 'CURACAO', 'CW', 'CUW', 0, 0, '0000-00-00 00:00:00', '', 'UC', '', 'images/com_joomleague/database/flags/cw.png', '', '', ''),
(NULL, 'CYPRUS__REPUBLIC_OF', 'CY', 'CYP', 0, 0, '0000-00-00 00:00:00', 'CYP', 'CY', 'CYP', 'images/com_joomleague/database/flags/cy.png', 'CYP', 'CY', 'CY'),
(NULL, 'CZECH_REPUBLIC', 'CZ', 'CZE', 0, 0, '0000-00-00 00:00:00', 'CZE', 'EZ', 'CZE', 'images/com_joomleague/database/flags/cz.png', 'CZE', 'CZ', 'CZ'),
(NULL, 'DENMARK__KINGDOM_OF', 'DK', 'DNK', 0, 0, '0000-00-00 00:00:00', 'DNK', 'DA', 'DEN', 'images/com_joomleague/database/flags/dk.png', 'DEN', 'DK', 'DN'),
(NULL, 'DJIBOUTI__REPUBLIC_OF', 'DJ', 'DJI', 0, 0, '0000-00-00 00:00:00', 'DJI', 'DJ', 'DJI', 'images/com_joomleague/database/flags/dj.png', 'DJI', '', 'DJ'),
(NULL, 'DOMINICA__COMMONWEALTH_OF', 'DM', 'DMA', 0, 0, '0000-00-00 00:00:00', 'DMA', 'DO', 'DMA', 'images/com_joomleague/database/flags/dm.png', 'DMA', 'WD', 'DO'),
(NULL, 'DOMINICAN_REPUBLIC', 'DO', 'DOM', 0, 0, '0000-00-00 00:00:00', 'DOM', 'DR', 'DOM', 'images/com_joomleague/database/flags/do.png', 'DOM', 'DOM', 'DR'),
(NULL, 'ECUADOR__REPUBLIC_OF', 'EC', 'ECU', 0, 0, '0000-00-00 00:00:00', 'EQA', 'EC', 'ECU', 'images/com_joomleague/database/flags/ec.png', 'ECU', 'EC', 'EQ'),
(NULL, 'EGYPT__ARAB_REPUBLIC_OF', 'EG', 'EGY', 0, 0, '0000-00-00 00:00:00', 'EGY', 'EG', 'EGY', 'images/com_joomleague/database/flags/eg.png', 'EGY', 'ET', 'EG'),
(NULL, 'EL_SALVADOR__REPUBLIC_OF', 'SV', 'SLV', 0, 0, '0000-00-00 00:00:00', 'SLV', 'ES', 'ESA', 'images/com_joomleague/database/flags/sv.png', 'SLV', 'ES', 'ES'),
(NULL, 'EQUATORIAL_GUINEA__REPUBLIC_OF', 'GQ', 'GNQ', 0, 0, '0000-00-00 00:00:00', 'GNE', 'EK', 'GEQ', 'images/com_joomleague/database/flags/gq.png', 'EQG', '', 'GQ'),
(NULL, 'ERITREA__STATE_OF', 'ER', 'ERI', 0, 0, '0000-00-00 00:00:00', 'ERI', 'ER', 'ERI', 'images/com_joomleague/database/flags/er.png', 'ERI', '', ''),
(NULL, 'ESTONIA__REPUBLIC_OF', 'EE', 'EST', 0, 0, '0000-00-00 00:00:00', 'EST', 'EN', 'EST', 'images/com_joomleague/database/flags/ee.png', 'EST', 'EST', 'EO'),
(NULL, 'ETHIOPIA__FEDERAL_DEMOCRATIC_R', 'ET', 'ETH', 0, 0, '0000-00-00 00:00:00', 'ETH', 'ET', 'ETH', 'images/com_joomleague/database/flags/et.png', 'ETH', 'ETH', 'ET'),
(NULL, 'FALKLAND_ISLANDS__MALVINAS_', 'FK', 'FLK', 0, 0, '0000-00-00 00:00:00', 'FLK', 'FK', 'FLK', 'images/com_joomleague/database/flags/fk.png', 'FLK', '', 'FK'),
(NULL, 'FAROE_ISLANDS', 'FO', 'FRO', 0, 0, '0000-00-00 00:00:00', 'FRO', 'FO', 'FAR', 'images/com_joomleague/database/flags/fo.png', 'FRO', 'FO', 'FA'),
(NULL, 'FIJI__REPUBLIC_OF_THE_FIJI_ISL', 'FJ', 'FJI', 0, 0, '0000-00-00 00:00:00', 'FJI', 'FJ', 'FIJ', 'images/com_joomleague/database/flags/fj.png', 'FIJ', 'FJI', 'FJ'),
(NULL, 'FINLAND__REPUBLIC_OF', 'FI', 'FIN', 0, 0, '0000-00-00 00:00:00', 'FIN', 'FI', 'FIN', 'images/com_joomleague/database/flags/fi.png', 'FIN', 'FIN', 'FI'),
(NULL, 'FRANCE__FRENCH_REPUBLIC', 'FR', 'FRA', 0, 0, '0000-00-00 00:00:00', 'F', 'FR', 'FRA', 'images/com_joomleague/database/flags/fr.png', 'FRA', 'F', 'FR'),
(NULL, 'FRENCH_GUIANA', 'GF', 'GUF', 0, 0, '0000-00-00 00:00:00', 'GUF', 'FG', 'FGU', 'images/com_joomleague/database/flags/gf.png', 'GUF', 'F', 'FG'),
(NULL, 'FRENCH_POLYNESIA', 'PF', 'PYF', 0, 0, '0000-00-00 00:00:00', 'OCE', 'FP', 'FPO', 'images/com_joomleague/database/flags/pf.png', 'TAH', 'F', 'PF'),
(NULL, 'FRENCH_SOUTHERN_TERRITORIES', 'TF', 'ATF', 0, 0, '0000-00-00 00:00:00', '', 'FS', '', 'images/com_joomleague/database/flags/tf.png', '', 'F', ''),
(NULL, 'GABON__GABONESE_REPUBLIC', 'GA', 'GAB', 0, 0, '0000-00-00 00:00:00', 'GAB', 'GB', 'GAB', 'images/com_joomleague/database/flags/ga.png', 'GAB', 'G', 'GO'),
(NULL, 'GAMBIA__REPUBLIC_OF_THE', 'GM', 'GMB', 0, 0, '0000-00-00 00:00:00', 'GMB', 'GA', 'GAM', 'images/com_joomleague/database/flags/gm.png', 'GAM', 'WAG', 'GB'),
(NULL, 'GEORGIA', 'GE', 'GEO', 0, 0, '0000-00-00 00:00:00', 'GEO', 'GG', 'GEO', 'images/com_joomleague/database/flags/ge.png', 'GEO', 'GE', 'GG'),
(NULL, 'GERMANY__FEDERAL_REPUBLIC_OF', 'DE', 'DEU', 0, 0, '0000-00-00 00:00:00', 'D', 'GM', 'GER', 'images/com_joomleague/database/flags/de.png', 'GER', 'D', 'DL'),
(NULL, 'GHANA__REPUBLIC_OF', 'GH', 'GHA', 0, 0, '0000-00-00 00:00:00', 'GHA', 'GH', 'GHA', 'images/com_joomleague/database/flags/gh.png', 'GHA', 'GH', 'GH'),
(NULL, 'GIBRALTAR', 'GI', 'GIB', 0, 0, '0000-00-00 00:00:00', 'GIB', 'GI', 'GIB', 'images/com_joomleague/database/flags/gi.png', 'GBZ', 'GBZ', 'GI'),
(NULL, 'GREECE__HELLENIC_REPUBLIC', 'GR', 'GRC', 0, 0, '0000-00-00 00:00:00', 'GRC', 'GR', 'GRE', 'images/com_joomleague/database/flags/gr.png', 'GRE', 'GR', 'GR'),
(NULL, 'GREENLAND', 'GL', 'GRL', 0, 0, '0000-00-00 00:00:00', 'GRL', 'GL', 'GRL', 'images/com_joomleague/database/flags/gl.png', 'GRL', 'DK', 'GL'),
(NULL, 'GRENADA', 'GD', 'GRD', 0, 0, '0000-00-00 00:00:00', 'GRD', 'GJ', 'GRN', 'images/com_joomleague/database/flags/gd.png', 'GRN', 'WG', 'GD'),
(NULL, 'GUADELOUPE', 'GP', 'GLP', 0, 0, '0000-00-00 00:00:00', 'GDL', 'GP', 'GUD', 'images/com_joomleague/database/flags/gp.png', 'GLP', 'F', 'MF'),
(NULL, 'GUAM', 'GU', 'GUM', 0, 0, '0000-00-00 00:00:00', 'GUM', 'GQ', 'GUM', 'images/com_joomleague/database/flags/gu.png', 'GUM', 'USA', 'GM'),
(NULL, 'GUATEMALA__REPUBLIC_OF', 'GT', 'GTM', 0, 0, '0000-00-00 00:00:00', 'GTM', 'GT', 'GUA', 'images/com_joomleague/database/flags/gt.png', 'GUA', 'GCA', 'GU'),
(NULL, 'GUERNSEY__BAILIWICK_OF', 'GG', 'GGY', 0, 0, '0000-00-00 00:00:00', '', 'GK', '', 'images/com_joomleague/database/flags/gg.png', 'GBG', 'GBG', ''),
(NULL, 'GUINEA__REPUBLIC_OF', 'GN', 'GIN', 0, 0, '0000-00-00 00:00:00', 'GUI', 'GV', 'GUI', 'images/com_joomleague/database/flags/gn.png', 'GUI', 'RG', 'GN'),
(NULL, 'GUINEA-BISSAU__REPUBLIC_OF', 'GW', 'GNB', 0, 0, '0000-00-00 00:00:00', 'GNB', 'PU', 'GBS', 'images/com_joomleague/database/flags/gw.png', 'GNB', '', 'GW'),
(NULL, 'GUYANA__CO-OPERATIVE_REPUBLIC', 'GY', 'GUY', 0, 0, '0000-00-00 00:00:00', 'GUY', 'GY', 'GUY', 'images/com_joomleague/database/flags/gy.png', 'GUY', 'GUY', 'GY'),
(NULL, 'HAITI__REPUBLIC_OF', 'HT', 'HTI', 0, 0, '0000-00-00 00:00:00', 'HTI', 'HA', 'HAI', 'images/com_joomleague/database/flags/ht.png', 'HAI', 'RH', 'HA'),
(NULL, 'HEARD_ISLAND_AND_MCDONALD_ISLA', 'HM', 'HMD', 0, 0, '0000-00-00 00:00:00', '', 'HM', '', 'images/com_joomleague/database/flags/hm.png', '', 'AUS', ''),
(NULL, 'HONDURAS__REPUBLIC_OF', 'HN', 'HND', 0, 0, '0000-00-00 00:00:00', 'HND', 'HO', 'HON', 'images/com_joomleague/database/flags/hn.png', 'HON', '', 'HO'),
(NULL, 'HONG KONG__SPECIAL_ADMINISTRAT', 'HK', 'HKG', 0, 0, '0000-00-00 00:00:00', 'HKG', 'HK', 'HKG', 'images/com_joomleague/database/flags/hk.png', 'HKG', 'HK', 'HK'),
(NULL, 'HUNGARY__REPUBLIC_OF', 'HU', 'HUN', 0, 0, '0000-00-00 00:00:00', 'HNG', 'HU', 'HUN', 'images/com_joomleague/database/flags/hu.png', 'HUN', 'H', 'HU'),
(NULL, 'ICELAND__REPUBLIC_OF', 'IS', 'ISL', 0, 0, '0000-00-00 00:00:00', 'ISL', 'IC', 'ISL', 'images/com_joomleague/database/flags/is.png', 'ISL', 'IS', 'IL'),
(NULL, 'INDIA__REPUBLIC_OF', 'IN', 'IND', 0, 0, '0000-00-00 00:00:00', 'IND', 'IN', 'IND', 'images/com_joomleague/database/flags/in.png', 'IND', 'IND', 'IN'),
(NULL, 'INDONESIA__REPUBLIC_OF', 'ID', 'IDN', 0, 0, '0000-00-00 00:00:00', 'INS', 'ID', 'INA', 'images/com_joomleague/database/flags/id.png', 'IDN', 'RI', 'ID'),
(NULL, 'IRAN__ISLAMIC_REPUBLIC_OF', 'IR', 'IRN', 0, 0, '0000-00-00 00:00:00', 'IRN', 'IR', 'IRI', 'images/com_joomleague/database/flags/ir.png', 'IRN', 'IR', 'IR'),
(NULL, 'IRAQ__REPUBLIC_OF', 'IQ', 'IRQ', 0, 0, '0000-00-00 00:00:00', 'IRQ', 'IZ', 'IRQ', 'images/com_joomleague/database/flags/iq.png', 'IRQ', 'IRQ', 'IQ'),
(NULL, 'IRELAND', 'IE', 'IRL', 0, 0, '0000-00-00 00:00:00', 'IRL', 'EI', 'IRL', 'images/com_joomleague/database/flags/ie.png', 'IRL', 'IRL', 'IE'),
(NULL, 'ISLE_OF_MAN', 'IM', 'IMN', 0, 0, '0000-00-00 00:00:00', '', 'IM', '', 'images/com_joomleague/database/flags/im.png', 'GBM', 'GBM', ''),
(NULL, 'ISRAEL__STATE_OF', 'IL', 'ISR', 0, 0, '0000-00-00 00:00:00', 'ISR', 'IS', 'ISR', 'images/com_joomleague/database/flags/il.png', 'ISR', 'IL', 'IS'),
(NULL, 'ITALY__ITALIAN_REPUBLIC', 'IT', 'ITA', 0, 0, '0000-00-00 00:00:00', 'I', 'IT', 'ITA', 'images/com_joomleague/database/flags/it.png', 'ITA', 'I', 'IY'),
(NULL, 'JAMAICA', 'JM', 'JAM', 0, 0, '0000-00-00 00:00:00', 'JMC', 'JM', 'JAM', 'images/com_joomleague/database/flags/jm.png', 'JAM', 'JA', 'JM'),
(NULL, 'JAPAN', 'JP', 'JPN', 0, 0, '0000-00-00 00:00:00', 'J', 'JA', 'JPN', 'images/com_joomleague/database/flags/jp.png', 'JPN', 'J', 'JP'),
(NULL, 'JERSEY__BAILIWICK_OF', 'JE', 'JEY', 0, 0, '0000-00-00 00:00:00', '', 'JE', '', 'images/com_joomleague/database/flags/je.png', 'GBJ', 'GBJ', ''),
(NULL, 'JORDAN__HASHEMITE_KINGDOM_OF', 'JO', 'JOR', 0, 0, '0000-00-00 00:00:00', 'JOR', 'JO', 'JOR', 'images/com_joomleague/database/flags/jo.png', 'JOR', 'HKJ', 'JD'),
(NULL, 'KAZAKHSTAN__REPUBLIC_OF', 'KZ', 'KAZ', 0, 0, '0000-00-00 00:00:00', 'KAZ', 'KZ', 'KAZ', 'images/com_joomleague/database/flags/kz.png', 'KAZ', 'KZ', 'KZ'),
(NULL, 'KENYA__REPUBLIC_OF', 'KE', 'KEN', 0, 0, '0000-00-00 00:00:00', 'KEN', 'KE', 'KEN', 'images/com_joomleague/database/flags/ke.png', 'KEN', 'EAK', 'KN'),
(NULL, 'KIRIBATI__REPUBLIC_OF', 'KI', 'KIR', 0, 0, '0000-00-00 00:00:00', 'KIR', 'KR', 'KIR', 'images/com_joomleague/database/flags/ki.png', 'KIR', '', 'KB'),
(NULL, 'KOREA__DEMOCRATIC_PEOPLE_S_REP', 'KP', 'PRK', 0, 0, '0000-00-00 00:00:00', 'KRE', 'KN', 'PRK', 'images/com_joomleague/database/flags/kp.png', 'PRK', '', 'KR'),
(NULL, 'KOREA__REPUBLIC_OF', 'KR', 'KOR', 0, 0, '0000-00-00 00:00:00', 'KOR', 'KS', 'KOR', 'images/com_joomleague/database/flags/kr.png', 'KOR', 'ROK', 'KO'),
(NULL, 'KUWAIT__STATE_OF', 'KW', 'KWT', 0, 0, '0000-00-00 00:00:00', 'KWT', 'KU', 'KUW', 'images/com_joomleague/database/flags/kw.png', 'KUW', 'KWT', 'KW'),
(NULL, 'KYRGYZ_REPUBLIC', 'KG', 'KGZ', 0, 0, '0000-00-00 00:00:00', 'KGZ', 'KG', 'KGZ', 'images/com_joomleague/database/flags/kg.png', 'KGZ', 'KS', 'KG'),
(NULL, 'LAO_PEOPLE_S_DEMOCRATIC_REPUBL', 'LA', 'LAO', 0, 0, '0000-00-00 00:00:00', 'LAO', 'LA', 'LAO', 'images/com_joomleague/database/flags/la.png', 'LAO', 'LAO', 'LA'),
(NULL, 'LATVIA__REPUBLIC_OF', 'LV', 'LVA', 0, 0, '0000-00-00 00:00:00', 'LVA', 'LG', 'LAT', 'images/com_joomleague/database/flags/lv.png', 'LVA', 'LV', 'LV'),
(NULL, 'LEBANON__LEBANESE_REPUBLIC', 'LB', 'LBN', 0, 0, '0000-00-00 00:00:00', 'LBN', 'LE', 'LIB', 'images/com_joomleague/database/flags/lb.png', 'LIB', 'RL', 'LB'),
(NULL, 'LESOTHO__KINGDOM_OF', 'LS', 'LSO', 0, 0, '0000-00-00 00:00:00', 'LSO', 'LT', 'LES', 'images/com_joomleague/database/flags/ls.png', 'LES', 'LS', 'LS'),
(NULL, 'LIBERIA__REPUBLIC_OF', 'LR', 'LBR', 0, 0, '0000-00-00 00:00:00', 'LBR', 'LI', 'LBR', 'images/com_joomleague/database/flags/lr.png', 'LBR', 'LB', 'LI'),
(NULL, 'LIBYAN_ARAB_JAMAHIRIYA', 'LY', 'LBY', 0, 0, '0000-00-00 00:00:00', 'LBY', 'LY', 'LBA', 'images/com_joomleague/database/flags/ly.png', 'LBY', 'LAR', 'LY'),
(NULL, 'LIECHTENSTEIN__PRINCIPALITY_OF', 'LI', 'LIE', 0, 0, '0000-00-00 00:00:00', 'LIE', 'LS', 'LIE', 'images/com_joomleague/database/flags/li.png', 'LIE', 'FL', ''),
(NULL, 'LITHUANIA__REPUBLIC_OF', 'LT', 'LTU', 0, 0, '0000-00-00 00:00:00', 'LTU', 'LH', 'LTU', 'images/com_joomleague/database/flags/lt.png', 'LTU', 'LT', 'LT'),
(NULL, 'LUXEMBOURG__GRAND_DUCHY_OF', 'LU', 'LUX', 0, 0, '0000-00-00 00:00:00', 'LUX', 'LU', 'LUX', 'images/com_joomleague/database/flags/lu.png', 'LUX', 'L', 'BX'),
(NULL, 'MACAO__SPECIAL_ADMINISTRATIVE', 'MO', 'MAC', 0, 0, '0000-00-00 00:00:00', 'MAC', 'MC', 'MAC', 'images/com_joomleague/database/flags/mo.png', 'MAC', '', 'MU'),
(NULL, 'MACEDONIA__THE_FORMER_YUGOSLAV', 'MK', 'MKD', 0, 0, '0000-00-00 00:00:00', 'MKD', 'MK', 'MKD', 'images/com_joomleague/database/flags/mk.png', 'MKD', 'MK', 'MJ'),
(NULL, 'MADAGASCAR__REPUBLIC_OF', 'MG', 'MDG', 0, 0, '0000-00-00 00:00:00', 'MDG', 'MA', 'MAD', 'images/com_joomleague/database/flags/mg.png', 'MAD', 'RM', 'MG'),
(NULL, 'MALAWI__REPUBLIC_OF', 'MW', 'MWI', 0, 0, '0000-00-00 00:00:00', 'MWI', 'MI', 'MAW', 'images/com_joomleague/database/flags/mw.png', 'MWI', 'MW', 'MW'),
(NULL, 'MALAYSIA', 'MY', 'MYS', 0, 0, '0000-00-00 00:00:00', 'MLA', 'MY', 'MAS', 'images/com_joomleague/database/flags/my.png', 'MAS', 'MAL', 'MS'),
(NULL, 'MALDIVES__REPUBLIC_OF', 'MV', 'MDV', 0, 0, '0000-00-00 00:00:00', 'MLD', 'MV', 'MDV', 'images/com_joomleague/database/flags/mv.png', 'MDV', '', 'MV'),
(NULL, 'MALI__REPUBLIC_OF', 'ML', 'MLI', 0, 0, '0000-00-00 00:00:00', 'MLI', 'ML', 'MLI', 'images/com_joomleague/database/flags/ml.png', 'MLI', 'RMM', 'MI'),
(NULL, 'MALTA__REPUBLIC_OF', 'MT', 'MLT', 0, 0, '0000-00-00 00:00:00', 'MLT', 'MT', 'MLT', 'images/com_joomleague/database/flags/mt.png', 'MLT', 'M', 'ML'),
(NULL, 'MARSHALL_ISLANDS__REPUBLIC_OF', 'MH', 'MHL', 0, 0, '0000-00-[/spoiler
Letzte Änderung: 11 Jahre 10 Monate her von . Begründung: Spoiler n.i,o
Bitte Anmelden um der Konversation beizutreten.
- svdoldie@gmx.de
-
- Offline
- Moderator
-
Weniger
Mehr
- Beiträge: 1601
- Dank erhalten: 169
11 Jahre 10 Monate her - 11 Jahre 10 Monate her #6728
von svdoldie@gmx.de
svdoldie@gmx.de antwortete auf Fehler bei der Komponenten-Installation.
lösch mal bitte mit phpmyadmin den db-eintrag _joomlegue_countries
und danach nochmal installieren
und danach nochmal installieren
Letzte Änderung: 11 Jahre 10 Monate her von svdoldie@gmx.de.
Bitte Anmelden um der Konversation beizutreten.
- diddipoeler@der-ball-ist-rund.net
-
- Offline
- Administrator
-
Weniger
Mehr
- Beiträge: 5114
- Dank erhalten: 599
11 Jahre 10 Monate her #6729
von diddipoeler@der-ball-ist-rund.net
fehler bereinigt. neue version im github.
Folgende Benutzer bedankten sich: svdoldie@gmx.de
Bitte Anmelden um der Konversation beizutreten.
-
Autor
- Neues Mitglied
-
Weniger
Mehr
- Dank erhalten: 0
11 Jahre 10 Monate her #6730
von
antwortete auf Fehler bei der Komponenten-Installation.
Bevor der Countrie-Fehler war. Hatte ich diesen
JInstaller: :Install: SQL-Fehler DB-Funktion mit Fehlercode 1064 fehlgeschlagen!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `1234_joomleague_version_history` ( `id` int(11) NO' at line 7 SQL=-- -- Tabellenstruktur f�r Tabelle `1234_joomleague_version_history` -- ALTER TABLE `1234_joomleague_project_team` ADD `penalty_points` INT( 11 ) NOT NULL DEFAULT '0' CREATE TABLE IF NOT EXISTS `1234_joomleague_version_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` date NOT NULL DEFAULT '0000-00-00', `text` text, `version` VARCHAR(255) NOT NULL DEFAULT '' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
--
-- Tabellenstruktur f�r Tabelle `#__joomleague_version_history`
--
ALTER TABLE `#__joomleague_project_team` ADD `penalty_points` INT( 11 ) NOT NULL DEFAULT '0'
CREATE TABLE IF NOT EXISTS `#__joomleague_version_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL DEFAULT '0000-00-00',
`text` text,
`version` VARCHAR(255) NOT NULL DEFAULT '' ,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Komponentenaktualisierung: SQL-Fehlerdatei DB-Funktion mit Fehlercode 1064 fehlgeschlagen!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `1234_joomleague_version_history` ( `id` int(11) NO' at line 7 SQL=-- -- Tabellenstruktur f�r Tabelle `1234_joomleague_version_history` -- ALTER TABLE `1234_joomleague_project_team` ADD `penalty_points` INT( 11 ) NOT NULL DEFAULT '0' CREATE TABLE IF NOT EXISTS `1234_joomleague_version_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` date NOT NULL DEFAULT '0000-00-00', `text` text, `version` VARCHAR(255) NOT NULL DEFAULT '' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
--
-- Tabellenstruktur f�r Tabelle `#__joomleague_version_history`
--
ALTER TABLE `#__joomleague_project_team` ADD `penalty_points` INT( 11 ) NOT NULL DEFAULT '0'
CREATE TABLE IF NOT EXISTS `#__joomleague_version_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL DEFAULT '0000-00-00',
`text` text,
`version` VARCHAR(255) NOT NULL DEFAULT '' ,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Warnung: Spoiler!
JInstaller: :Install: SQL-Fehler DB-Funktion mit Fehlercode 1064 fehlgeschlagen!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `1234_joomleague_version_history` ( `id` int(11) NO' at line 7 SQL=-- -- Tabellenstruktur f�r Tabelle `1234_joomleague_version_history` -- ALTER TABLE `1234_joomleague_project_team` ADD `penalty_points` INT( 11 ) NOT NULL DEFAULT '0' CREATE TABLE IF NOT EXISTS `1234_joomleague_version_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` date NOT NULL DEFAULT '0000-00-00', `text` text, `version` VARCHAR(255) NOT NULL DEFAULT '' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
--
-- Tabellenstruktur f�r Tabelle `#__joomleague_version_history`
--
ALTER TABLE `#__joomleague_project_team` ADD `penalty_points` INT( 11 ) NOT NULL DEFAULT '0'
CREATE TABLE IF NOT EXISTS `#__joomleague_version_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL DEFAULT '0000-00-00',
`text` text,
`version` VARCHAR(255) NOT NULL DEFAULT '' ,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Komponentenaktualisierung: SQL-Fehlerdatei DB-Funktion mit Fehlercode 1064 fehlgeschlagen!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `1234_joomleague_version_history` ( `id` int(11) NO' at line 7 SQL=-- -- Tabellenstruktur f�r Tabelle `1234_joomleague_version_history` -- ALTER TABLE `1234_joomleague_project_team` ADD `penalty_points` INT( 11 ) NOT NULL DEFAULT '0' CREATE TABLE IF NOT EXISTS `1234_joomleague_version_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` date NOT NULL DEFAULT '0000-00-00', `text` text, `version` VARCHAR(255) NOT NULL DEFAULT '' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
--
-- Tabellenstruktur f�r Tabelle `#__joomleague_version_history`
--
ALTER TABLE `#__joomleague_project_team` ADD `penalty_points` INT( 11 ) NOT NULL DEFAULT '0'
CREATE TABLE IF NOT EXISTS `#__joomleague_version_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL DEFAULT '0000-00-00',
`text` text,
`version` VARCHAR(255) NOT NULL DEFAULT '' ,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Bitte Anmelden um der Konversation beizutreten.
- diddipoeler@der-ball-ist-rund.net
-
- Offline
- Administrator
-
Weniger
Mehr
- Beiträge: 5114
- Dank erhalten: 599
11 Jahre 10 Monate her #6731
von diddipoeler@der-ball-ist-rund.net
bitte vorher die alte version von joomleague löschen und dann die neue installieren.
Bitte Anmelden um der Konversation beizutreten.
-
Autor
- Neues Mitglied
-
Weniger
Mehr
- Dank erhalten: 0
11 Jahre 10 Monate her #6733
von
antwortete auf Fehler bei der Komponenten-Installation.
Was ist gemeint mit alter Version löschen?
Nur unter Joomla 2.5.11 -> Erweiterungen -> Verwalten => alles was Joomleague heißt deinstallieren oder auch die DB-Einträge Joomleague löschen?
Nur unter Joomla 2.5.11 -> Erweiterungen -> Verwalten => alles was Joomleague heißt deinstallieren oder auch die DB-Einträge Joomleague löschen?
Bitte Anmelden um der Konversation beizutreten.
Moderatoren: diddipoeler@der-ball-ist-rund.net
Ladezeit der Seite: 0.260 Sekunden