-- sql/plus_country.sql
-- GENERATED - DO NOT MODIFY. See README.lit
SELECT
    id as gid,
    name,
    placetype,
    lon,
    lat,
    country
FROM data
WHERE
    substring(lower($1), 1, 3) = prefix
AND
    name ILIKE concat($1, '%')
AND
    country = $2
AND
    placetype IN ['locality', 'county']
ORDER BY pop_mag DESC, placetype ASC;