|
  |
| Centre for Asia Pacific Aviation - News & Analysis from ATM Monthly |
select a.hq_country,b.carrier_name,c.name,c.id as id, d.name as region from mos_whos_who as a
INNER JOIN mos_whoswho_airline_sites AS ws ON ws.whoshwo_id = a.id INNER JOIN mos_airline_code as b ON a.carrier = b.id INNER JOIN mos_airline_country as c ON a.hq_country = c.id INNER JOIN mos_airline_region as d ON a.region_id = d.id WHERE 1=1 AND ws.type = '1' AND ws.website_id = '3' group by c.name order by c.name ASC
