Вся зарубежная недвижимость
на одном портале

Подписка на обновления

SELECT c.id, c.country_code, c.locative_name, c.geonameid, c.name, count(p.id) as propcount, c.latitude, c.longitude, u.url, p.type2 FROM (geo_city c JOIN pmr_properties p ON c.country_code=p.geo_country AND c.geonameid=p.geo_city_id) LEFT JOIN urls u ON u.country_code = c.country_code AND u.city_id = c.geonameid WHERE p.approved=1 AND c.country_code = "TR" GROUP BY c.id, p.type2 ORDER BY c.name