You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10
SELECT r.name, r.country_code, r.province_code, r.region_city_code, c.country_name, p.province_name, rc.region_name FROM resorts r LEFT OUTER JOIN countries c ON r.country_code=c.country_code LEFT OUTER JOIN provinces p ON r.province_code=p.province_code LEFT OUTER JOIN regions_cities rc ON r.region_city_code=rc.id WHERE r.id=