也许这个？：
SELECt COUNT(t.longname) as cnt, l.location FROM locations l LEFT JOIN topics t ON t.longname = l.longname AND t.tag = 'atag' WHERe l.location IN ('Japan', 'France', 'Italy') GROUP BY l.location ORDER BY FIELD(l.location, 'Japan', 'France', 'Italy')
