CREATE TABLE geoname.cities AS
 SELECT g.geonameid, g.name AS name, g.country, NULL AS isolanguage, 
         NULL AS ispreferredname
         FROM geoname.geonames AS g 
         WHERE g.fclass = 'P' OR
         g.fcode = 'PPL' OR
         g.fcode = 'PPLA'
 UNION
 SELECT g.geonameid, a.alternatename AS name, g.country, 
         a.isolanguage, a.ispreferredname
         FROM geoname.geonames AS g INNER JOIN geoname.alternatename AS a 
         ON g.geonameid = a.geonameid
         WHERE g.fclass = 'P' OR
         g.fcode = 'PPL' OR
         g.fcode = 'PPLA';