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';