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 Bulgaria Croatia Estonia Finland Greece Guadeloupe Iceland Jamaica Latvia Lithuania Macedonia Malta Montenegro Morocco Netherlands Peru Poland Romania Serbia Slovakia St. Martin Turkey Ukraine United Arab Emirates 
