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