Country:
---Select Country--- SELECT c.* FROM ac_locations AS l, country AS c WHERE l.country_id = c.id and country_id IN (' ','AD','AE','AG','AI','AL','AM','AN','AO','AR','AT','AU','AW','AX','AZ','BA','BB','BE','BG','BH','BL','BN','BO','BR','BS','BW','BY','BZ','CA','CD','CH','CI','CL','CM','CN','CO','CR','CS','CY','CZ','DE','DJ','DK','DO','EC','EE','EG','EN','ES','ET','EU','FI','FJ','FO','FR','GA','GB','GD','GE','GF','GI','GM','GN','GP','GR','GT','GU','HK','HN','HR','HU','ID','IE','IL','IN','IS','IT','JM','JO','JP','KE','KN','KO','KP','KR','KW','KY','LB','LC','LI','LK','LS','LT','LU','LV','LY','MA','MD','ME','MF','MG','MK','ML','MP','MQ','MT','MU','MW','MX','MY','MZ','NA','NC','NG','NI','NL','NO','NZ','OM','OR','PA','PE','PF','PG','PH','PK','PL','PR','PT','PY','QA','RE','RO','RU','S5','S6','SA','SC','SE','SG','SI','SK','SM','SN','SR','SS','SV','SY','SZ','TG','TH','TN','TR','TT','UA','UG','US','UY','VE','VI','VN','VU','WA','WS','YE','YT','ZA','ZM','ZW') GROUP BY l.country_id ORDER BY c.countryAlbania Argentina Austria Bulgaria Croatia Estonia Finland Greece Guadeloupe Iceland Jamaica Latvia Lithuania Macedonia Malta Martinique Montenegro Morocco Netherlands Peru Poland Romania Serbia Slovakia St. Martin Turkey Ukraine United Arab Emirates United States 
