Search the travel guide:

Resort

• Sa Coma and Cala Millor Travel Guide
• Travel Information
• Photos
• Hotels in Sa Coma and Cala Millor

Rants and Raves

• Write a Travel Review

Spain Map

• 

Directory

• Travel Insurance
• Hostels

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=