Uzupełnienie listy krajów - polecenie SQL

Przydatne skrypty, programy itp, do współpracy z programem KQS.store

Uzupełnienie listy krajów - polecenie SQL

przez sebp » 2017 lis 23, Cz 20:17

Dla zaoszczędzenia czasu w dodawaniu podsyłam listę krajów z pominięciem Polski. Polecenie SQL do zaaplikowania bezpośrednio w bazie.
Mam nadzieję, że się wam przyda.


Kod: Odnośnik widoczny tylko dla zalogowanych użytkowników - Zarejestruj się
INSERT INTO kqs_kraje (kraj, iso_alfa2, iso_alfa3, iso_num)
     VALUES
('Afganistan','AF','AFG',4),
('Albania','AL','ALB',8),
('Algieria','DZ','DZA',12),
('Andora','AD','AND',20),
('Angola','AO','AGO',24),
('Anguilla','AI','AIA',660),
('Antarktyka','AQ','ATA',10),
('Antigua i Barbuda','AG','ATG',28),
('Arabia Saudyjska','SA','SAU',682),
('Argentyna','AR','ARG',32),
('Armenia','AM','ARM',51),
('Aruba','AW','ABW',533),
('Australia','AU','AUS',36),
('Austria','AT','AUT',40),
('Azerbejdżan','AZ','AZE',31),
('Bahamy','BS','BHS',44),
('Bahrajn','BH','BHR',48),
('Bangladesz','BD','BGD',50),
('Barbados','BB','BRB',52),
('Belgia','BE','BEL',56),
('Belize','BZ','BLZ',84),
('Benin','BJ','BEN',204),
('Bermudy','BM','BMU',60),
('Bhutan','BT','BTN',64),
('Białoruś','BY','BLR',112),
('Boliwia','BO','BOL',68),
('Bonaire, Sint Eustatius i Saba','BQ','BES',535),
('Bośnia i Hercegowina','BA','BIH',70),
('Botswana','BW','BWA',72),
('Brazylia','BR','BRA',76),
('Brunei','BN','BRN',96),
('Brytyjskie Terytorium Oceanu Indyjskiego','IO','IOT',86),
('Brytyjskie Wyspy Dziewicze','VG','VGB',92),
('Bułgaria','BG','BGR',100),
('Burkina Faso','BF','BFA',854),
('Burundi','BI','BDI',108),
('Chile','CL','CHL',152),
('Chiny','CN','CHN',156),
('Chorwacja','HR','HRV',191),
('Curaçao','CW','CUW',531),
('Cypr','CY','CYP',196),
('Czad','TD','TCD',148),
('Czarnogóra','ME','MNE',499),
('Czechy','CZ','CZE',203),
('Dalekie Wyspy Mniejsze Stanów Zjednoczonych','UM','UMI',581),
('Dania','DK','DNK',208),
('Demokratyczna Republika Konga','CD','COD',180),
('Dominika','DM','DMA',212),
('Dominikana','DO','DOM',214),
('Dżibuti','DJ','DJI',262),
('Egipt','EG','EGY',818),
('Ekwador','EC','ECU',218),
('Erytrea','ER','ERI',232),
('Estonia','EE','EST',233),
('Etiopia','ET','ETH',231),
('Falklandy','FK','FLK',238),
('Fidżi','FJ','FJI',242),
('Filipiny','PH','PHL',608),
('Finlandia','FI','FIN',246),
('Francja','FR','FRA',250),
('Francuskie Terytoria Południowe i Antarktyczne','TF','ATF',260),
('Gabon','GA','GAB',266),
('Gambia','GM','GMB',270),
('Georgia Południowa i Sandwich Południowy','GS','SGS',239),
('Ghana','GH','GHA',288),
('Gibraltar','GI','GIB',292),
('Grecja','GR','GRC',300),
('Grenada','GD','GRD',308),
('Grenlandia','GL','GRL',304),
('Gruzja','GE','GEO',268),
('Guam','GU','GUM',316),
('Guernsey','GG','GGY',831),
('Gujana Francuska','GF','GUF',254),
('Gujana','GY','GUY',328),
('Gwadelupa','GP','GLP',312),
('Gwatemala','GT','GTM',320),
('Gwinea Bissau','GW','GNB',624),
('Gwinea Równikowa','GQ','GNQ',226),
('Gwinea','GN','GIN',324),
('Haiti','HT','HTI',332),
('Hiszpania','ES','ESP',724),
('Holandia','NL','NLD',528),
('Honduras','HN','HND',340),
('Hongkong','HK','HKG',344),
('Indie','IN','IND',356),
('Indonezja','ID','IDN',360),
('Irak','IQ','IRQ',368),
('Iran','IR','IRN',364),
('Irlandia','IE','IRL',372),
('Islandia','IS','ISL',352),
('Izrael','IL','ISR',376),
('Jamajka','JM','JAM',388),
('Japonia','JP','JPN',392),
('Jemen','YE','YEM',887),
('Jersey','JE','JEY',832),
('Jordania','JO','JOR',400),
('Kajmany','KY','CYM',136),
('Kambodża','KH','KHM',116),
('Kamerun','CM','CMR',120),
('Kanada','CA','CAN',124),
('Katar','QA','QAT',634),
('Kazachstan','KZ','KAZ',398),
('Kenia','KE','KEN',404),
('Kirgistan','KG','KGZ',417),
('Kiribati','KI','KIR',296),
('Kolumbia','CO','COL',170),
('Komory','KM','COM',174),
('Kongo','CG','COG',178),
('Korea Południowa','KR','KOR',410),
('Korea Północna','KP','PRK',408),
('Kostaryka','CR','CRI',188),
('Kuba','CU','CUB',192),
('Kuwejt','KW','KWT',414),
('Laos','LA','LAO',418),
('Lesotho','LS','LSO',426),
('Liban','LB','LBN',422),
('Liberia','LR','LBR',430),
('Libia','LY','LBY',434),
('Liechtenstein','LI','LIE',438),
('Litwa','LT','LTU',440),
('Luksemburg','LU','LUX',442),
('Łotwa','LV','LVA',428),
('Macedonia','MK','MKD',807),
('Madagaskar','MG','MDG',450),
('Majotta','YT','MYT',175),
('Makau','MO','MAC',446),
('Malawi','MW','MWI',454),
('Malediwy','MV','MDV',462),
('Malezja','MY','MYS',458),
('Mali','ML','MLI',466),
('Malta','MT','MLT',470),
('Mariany Północne','MP','MNP',580),
('Maroko','MA','MAR',504),
('Martynika','MQ','MTQ',474),
('Mauretania','MR','MRT',478),
('Mauritius','MU','MUS',480),
('Meksyk','MX','MEX',484),
('Mikronezja','FM','FSM',583),
('Mjanma','MM','MMR',104),
('Mołdawia','MD','MDA',498),
('Monako','MC','MCO',492),
('Mongolia','MN','MNG',496),
('Montserrat','MS','MSR',500),
('Mozambik','MZ','MOZ',508),
('Namibia','NA','NAM',516),
('Nauru','NR','NRU',520),
('Nepal','NP','NPL',524),
('Niemcy','DE','DEU',276),
('Niger','NE','NER',562),
('Nigeria','NG','NGA',566),
('Nikaragua','NI','NIC',558),
('Niue','NU','NIU',570),
('Norfolk','NF','NFK',574),
('Norwegia','NO','NOR',578),
('Nowa Kaledonia','NC','NCL',540),
('Nowa Zelandia','NZ','NZL',554),
('Oman','OM','OMN',512),
('Pakistan','PK','PAK',586),
('Palau','PW','PLW',585),
('Palestyna','PS','PSE',275),
('Panama','PA','PAN',591),
('Papua-Nowa Gwinea','PG','PNG',598),
('Paragwaj','PY','PRY',600),
('Peru','PE','PER',604),
('Pitcairn','PN','PCN',612),
('Polinezja Francuska','PF','PYF',258),
('Portoryko','PR','PRI',630),
('Portugalia','PT','PRT',620),
('Południowa Afryka','ZA','ZAF',710),
('Republika Środkowoafrykańska','CF','CAF',140),
('Republika Zielonego Przylądka','CV','CPV',132),
('Reunion','RE','REU',638),
('Rosja','RU','RUS',643),
('Rumunia','RO','ROU',642),
('Rwanda','RW','RWA',646),
('Sahara Zachodnia','EH','ESH',732),
('Saint Kitts i Nevis','KN','KNA',659),
('Saint Lucia','LC','LCA',662),
('Saint Vincent i Grenadyny','VC','VCT',670),
('Saint-Barthélemy','BL','BLM',652),
('Saint-Martin','MF','MAF',663),
('Saint-Pierre i Miquelon','PM','SPM',666),
('Salwador','SV','SLV',222),
('Samoa Amerykańskie','AS','ASM',16),
('Samoa','WS','WSM',882),
('San Marino','SM','SMR',674),
('Senegal','SN','SEN',686),
('Serbia','RS','SRB',688),
('Seszele','SC','SYC',690),
('Sierra Leone','SL','SLE',694),
('Singapur','SG','SGP',702),
('Sint Maarten','SX','SXM',534),
('Słowacja','SK','SVK',703),
('Słowenia','SI','SVN',705),
('Somalia','SO','SOM',706),
('Sri Lanka','LK','LKA',144),
('Stany Zjednoczone','US','USA',840),
('Suazi','SZ','SWZ',748),
('Sudan','SD','SDN',729),
('Sudan Południowy','SS','SSD',728),
('Surinam','SR','SUR',740),
('Svalbard i Jan Mayen','SJ','SJM',744),
('Syria','SY','SYR',760),
('Szwajcaria','CH','CHE',756),
('Szwecja','SE','SWE',752),
('Tadżykistan','TJ','TJK',762),
('Tajlandia','TH','THA',764),
('Tajwan','TW','TWN',158),
('Tanzania','TZ','TZA',834),
('Timor Wschodni','TL','TLS',626),
('Togo','TG','TGO',768),
('Tokelau','TK','TKL',772),
('Tonga','TO','TON',776),
('Trynidad i Tobago','TT','TTO',780),
('Tunezja','TN','TUN',788),
('Turcja','TR','TUR',792),
('Turkmenistan','TM','TKM',795),
('Turks i Caicos','TC','TCA',796),
('Tuvalu','TV','TUV',798),
('Uganda','UG','UGA',800),
('Ukraina','UA','UKR',804),
('Urugwaj','UY','URY',858),
('Uzbekistan','UZ','UZB',860),
('Vanuatu','VU','VUT',548),
('Wallis i Futuna','WF','WLF',876),
('Watykan','VA','VAT',336),
('Wenezuela','VE','VEN',862),
('Węgry','HU','HUN',348),
('Wielka Brytania','GB','GBR',826),
('Wietnam','VN','VNM',704),
('Włochy','IT','ITA',380),
('Wybrzeże Kości Słoniowej','CI','CIV',384),
('Wyspa Bouveta','BV','BVT',74),
('Wyspa Bożego Narodzenia','CX','CXR',162),
('Wyspa Man','IM','IMN',833),
('Wyspa Świętej Heleny','SH','SHN',654),
('Wyspy Alandzkie','AX','ALA',248),
('Wyspy Cooka','CK','COK',184),
('Wyspy Dziewicze Stanów Zjednoczonych','VI','VIR',850),
('Wyspy Heard i McDonalda','HM','HMD',334),
('Wyspy Kokosowe','CC','CCK',166),
('Wyspy Marshalla','MH','MHL',584),
('Wyspy Owcze','FO','FRO',234),
('Wyspy Salomona','SB','SLB',90),
('Wyspy Świętego Tomasza i Książęca','ST','STP',678),
('Zambia','ZM','ZMB',894),
('Zimbabwe','ZW','ZWE',716),
('Zjednoczone Emiraty Arabskie','AE','ARE',784)
Avatar użytkownika
 
Autor tematu
Posty: 141
Dołączył(a): 2012 wrz 19, Śr 21:49
Podziękował : 3 razy
Otrzymał podziękowań: 2 razy

Re: Uzupełnienie listy krajów - polecenie SQL

przez sucro » 2017 lis 23, Cz 20:25

Dobra robota
Avatar użytkownika
Admin Witryny
 
Posty: 242
Dołączył(a): 2008 kwi 08, Wt 13:44
Lokalizacja: MEGAMO
Podziękował : 12 razy
Otrzymał podziękowań: 19 razy

Re: Uzupełnienie listy krajów - polecenie SQL

przez sebp » 2017 lis 25, So 13:21

Jak by ktoś chciał jeszcze tłumaczenie na English, to poniżej takie mało zgrabne polecenie.

Kod: Odnośnik widoczny tylko dla zalogowanych użytkowników - Zarejestruj się
INSERT INTO kqs_elementy_jezykowe (element_rodzaj, element_id, jezyk, wartosc)
     VALUES
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AF"),"English","Afghanistan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AL"),"English","Albania"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="DZ"),"English","Algeria"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AD"),"English","Andorra"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AO"),"English","Angola"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AI"),"English","Anguilla"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AQ"),"English","Antarctica"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AG"),"English","Antigua and Barbuda"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SA"),"English","Saudi Arabia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AR"),"English","Argentina"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AM"),"English","Armenia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AW"),"English","Aruba"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AU"),"English","Australia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AT"),"English","Austria"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AZ"),"English","Azerbaijan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BS"),"English","Bahamas"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BH"),"English","Bahrain"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BD"),"English","Bangladesh"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BB"),"English","Barbados"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BE"),"English","Belgium"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BZ"),"English","Belize"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BJ"),"English","Benin"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BM"),"English","Bermuda"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BT"),"English","Bhutan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BY"),"English","Belarus"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BO"),"English","Bolivia, Plurinational State of"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BQ"),"English","Bonaire, Sint Eustatius and Saba"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BA"),"English","Bosnia and Herzegovina"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BW"),"English","Botswana"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BR"),"English","Brazil"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BN"),"English","Brunei Darussalam"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="IO"),"English","British Indian Ocean Territory"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="VG"),"English","Virgin Islands, British"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BG"),"English","Bulgaria"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BF"),"English","Burkina Faso"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BI"),"English","Burundi"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CL"),"English","Chile"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CN"),"English","China"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="HR"),"English","Croatia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CW"),"English","Curaçao"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CY"),"English","Cyprus"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TD"),"English","Chad"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="ME"),"English","Montenegro"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CZ"),"English","Czechia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="UM"),"English","United States Minor Outlying Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="DK"),"English","Denmark"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CD"),"English","Congo, the Democratic Republic of the"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="DM"),"English","Dominica"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="DO"),"English","Dominican Republic"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="DJ"),"English","Djibouti"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="EG"),"English","Egypt"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="EC"),"English","Ecuador"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="ER"),"English","Eritrea"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="EE"),"English","Estonia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="ET"),"English","Ethiopia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="FK"),"English","Falkland Islands (Malvinas)"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="FJ"),"English","Fiji"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PH"),"English","Philippines"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="FI"),"English","Finland"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="FR"),"English","France"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TF"),"English","French Southern Territories"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GA"),"English","Gabon"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GM"),"English","Gambia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GS"),"English","South Georgia and the South Sandwich Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GH"),"English","Ghana"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GI"),"English","Gibraltar"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GR"),"English","Greece"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GD"),"English","Grenada"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GL"),"English","Greenland"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GE"),"English","Georgia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GU"),"English","Guam"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GG"),"English","Guernsey"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GF"),"English","French Guiana"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GY"),"English","Guyana"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GP"),"English","Guadeloupe"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GT"),"English","Guatemala"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GW"),"English","Guinea-Bissau"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GQ"),"English","Equatorial Guinea"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GN"),"English","Guinea"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="HT"),"English","Haiti"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="ES"),"English","Spain"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NL"),"English","Netherlands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="HN"),"English","Honduras"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="HK"),"English","Hong Kong"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="IN"),"English","India"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="ID"),"English","Indonesia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="IQ"),"English","Iraq"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="IR"),"English","Iran, Islamic Republic of"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="IE"),"English","Ireland"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="IS"),"English","Iceland"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="IL"),"English","Israel"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="JM"),"English","Jamaica"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="JP"),"English","Japan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="YE"),"English","Yemen"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="JE"),"English","Jersey"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="JO"),"English","Jordan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="KY"),"English","Cayman Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="KH"),"English","Cambodia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CM"),"English","Cameroon"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CA"),"English","Canada"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="QA"),"English","Qatar"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="KZ"),"English","Kazakhstan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="KE"),"English","Kenya"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="KG"),"English","Kyrgyzstan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="KI"),"English","Kiribati"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CO"),"English","Colombia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="KM"),"English","Comoros"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CG"),"English","Congo"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="KR"),"English","Korea, Republic of"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="KP"),"English","Korea, Democratic People's Republic of"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CR"),"English","Costa Rica"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CU"),"English","Cuba"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="KW"),"English","Kuwait"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="LA"),"English","Lao People's Democratic Republic"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="LS"),"English","Lesotho"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="LB"),"English","Lebanon"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="LR"),"English","Liberia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="LY"),"English","Libyan Arab Jamahiriya"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="LI"),"English","Liechtenstein"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="LT"),"English","Lithuania"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="LU"),"English","Luxembourg"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="LV"),"English","Latvia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MK"),"English","Macedonia, the former Yugoslav Republic of"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MG"),"English","Madagascar"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="YT"),"English","Mayotte"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MO"),"English","Macao"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MW"),"English","Malawi"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MV"),"English","Maldives"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MY"),"English","Malaysia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="ML"),"English","Mali"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MT"),"English","Malta"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MP"),"English","Northern Mariana Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MA"),"English","Morocco"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MQ"),"English","Martinique"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MR"),"English","Mauritania"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MU"),"English","Mauritius"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MX"),"English","Mexico"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="FM"),"English","Micronesia, Federated States of"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MM"),"English","Myanmar"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MD"),"English","Moldova, Republic of"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MC"),"English","Monaco"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MN"),"English","Mongolia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MS"),"English","Montserrat"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MZ"),"English","Mozambique"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NA"),"English","Namibia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NR"),"English","Nauru"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NP"),"English","Nepal"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="DE"),"English","Germany"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NE"),"English","Niger"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NG"),"English","Nigeria"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NI"),"English","Nicaragua"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NU"),"English","Niue"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NF"),"English","Norfolk Island"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NO"),"English","Norway"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NC"),"English","New Caledonia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="NZ"),"English","New Zealand"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="OM"),"English","Oman"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PK"),"English","Pakistan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PW"),"English","Palau"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PS"),"English","Palestinian Territory, Occupied"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PA"),"English","Panama"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PG"),"English","Papua New Guinea"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PY"),"English","Paraguay"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PE"),"English","Peru"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PN"),"English","Pitcairn"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PF"),"English","French Polynesia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PR"),"English","Puerto Rico"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PT"),"English","Portugal"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="ZA"),"English","South Africa"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CF"),"English","Central African Republic"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CV"),"English","Cape Verde"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="RE"),"English","Réunion"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="RU"),"English","Russian Federation"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="RO"),"English","Romania"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="RW"),"English","Rwanda"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="EH"),"English","Western Sahara"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="KN"),"English","Saint Kitts and Nevis"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="LC"),"English","Saint Lucia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="VC"),"English","Saint Vincent and the Grenadines"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BL"),"English","Saint Barthélemy"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MF"),"English","Saint Martin (French part)"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="PM"),"English","Saint Pierre and Miquelon"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SV"),"English","El Salvador"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AS"),"English","American Samoa"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="WS"),"English","Samoa"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SM"),"English","San Marino"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SN"),"English","Senegal"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="RS"),"English","Serbia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SC"),"English","Seychelles"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SL"),"English","Sierra Leone"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SG"),"English","Singapore"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SX"),"English","Sint Maarten (Dutch part)"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SK"),"English","Slovakia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SI"),"English","Slovenia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SO"),"English","Somalia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="LK"),"English","Sri Lanka"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="US"),"English","United States"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SZ"),"English","Swaziland"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SD"),"English","Sudan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SS"),"English","South Sudan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SR"),"English","Suriname"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SJ"),"English","Svalbard and Jan Mayen"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SY"),"English","Syrian Arab Republic"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CH"),"English","Switzerland"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SE"),"English","Sweden"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TJ"),"English","Tajikistan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TH"),"English","Thailand"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TW"),"English","Taiwan, Province of China"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TZ"),"English","Tanzania, United Republic of"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TL"),"English","Timor-Leste"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TG"),"English","Togo"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TK"),"English","Tokelau"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TO"),"English","Tonga"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TT"),"English","Trinidad and Tobago"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TN"),"English","Tunisia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TR"),"English","Turkey"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TM"),"English","Turkmenistan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TC"),"English","Turks and Caicos Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="TV"),"English","Tuvalu"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="UG"),"English","Uganda"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="UA"),"English","Ukraine"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="UY"),"English","Uruguay"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="UZ"),"English","Uzbekistan"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="VU"),"English","Vanuatu"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="WF"),"English","Wallis and Futuna"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="VA"),"English","Holy See (Vatican City State)"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="VE"),"English","Venezuela, Bolivarian Republic of"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="HU"),"English","Hungary"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="GB"),"English","United Kingdom"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="VN"),"English","Viet Nam"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="IT"),"English","Italy"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CI"),"English","Côte d'Ivoire"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="BV"),"English","Bouvet Island"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CX"),"English","Christmas Island"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="IM"),"English","Isle of Man"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SH"),"English","Saint Helena, Ascension and Tristan da Cunha"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AX"),"English","Åland Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CK"),"English","Cook Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="VI"),"English","Virgin Islands, U.S."),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="HM"),"English","Heard Island and McDonald Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="CC"),"English","Cocos (Keeling) Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="MH"),"English","Marshall Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="FO"),"English","Faroe Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="SB"),"English","Solomon Islands"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="ST"),"English","Sao Tome and Principe"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="ZM"),"English","Zambia"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="ZW"),"English","Zimbabwe"),
(38,(SELECT numer FROM kqs_kraje WHERE iso_alfa2="AE"),"English","United Arab Emirates");

Niestety wersja 4.7 nie obsługuje sortowania w dodatkowych językach zatem przy tej ilości pozycji nie można mówić o użyteczności.
Avatar użytkownika
 
Autor tematu
Posty: 141
Dołączył(a): 2012 wrz 19, Śr 21:49
Podziękował : 3 razy
Otrzymał podziękowań: 2 razy


Użytkownicy przeglądający ten dział: Brak zidentyfikowanych użytkowników i 0 gości
cron