https://bugzilla.wikimedia.org/show_bug.cgi?id=24830

--- Comment #4 from Arthur Richards <aricha...@wikimedia.org> 2010-08-27 
19:36:20 UTC ---
47 Countries are affected:

mysql> select s.country_id, c.name from civicrm_state_province s,
civicrm_country c where c.id = s.country_id and s.abbreviation rlike '[0-9]'
group by s.country_id;
+------------+--------------------------------------+
| country_id | name                                 |
+------------+--------------------------------------+
|       1003 | Algeria                              | 
|       1014 | Austria                              | 
|       1016 | Bahrain                              | 
|       1017 | Bangladesh                           | 
|       1024 | Bhutan                               | 
|       1033 | Bulgaria                             | 
|       1035 | Myanmar                              | 
|       1037 | Cambodia                             | 
|       1045 | China                                | 
|       1051 | Congo                                | 
|       1054 | C�te d'Ivoire                        | 
|       1055 | Croatia                              | 
|       1056 | Cuba                                 | 
|       1057 | Cyprus                               | 
|       1059 | Denmark                              | 
|       1062 | Dominican Republic                   | 
|       1069 | Estonia                              | 
|       1076 | France                               | 
|       1085 | Greece                               | 
|       1100 | Iceland                              | 
|       1103 | Iran, Islamic Republic of            | 
|       1109 | Japan                                | 
|       1112 | Kenya                                | 
|       1115 | Korea, Republic of                   | 
|       1131 | Malaysia                             | 
|       1132 | Maldives                             | 
|       1133 | Mali                                 | 
|       1137 | Mauritania                           | 
|       1144 | Mongolia                             | 
|       1156 | Niger                                | 
|       1161 | Norway                               | 
|       1166 | Panama                               | 
|       1168 | Paraguay                             | 
|       1173 | Portugal                             | 
|       1187 | Saudi Arabia                         | 
|       1193 | Slovenia                             | 
|       1199 | Sri Lanka                            | 
|       1200 | Sudan                                | 
|       1210 | Tanzania, United Republic of         | 
|       1211 | Thailand                             | 
|       1218 | Tunisia                              | 
|       1219 | Turkey                               | 
|       1223 | Uganda                               | 
|       1224 | Ukraine                              | 
|       1227 | United States Minor Outlying Islands | 
|       1233 | Viet Nam                             | 
|       1239 | Zambia                               | 
+------------+--------------------------------------+
47 rows in set (0.01 sec)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to