Preferred Currency

Hot Properties in Italy

AN ERROR OCCURRED:

SQL Failure in function RunQuery() from class Database

MYSQL QUERY:
SELECT * FROM properties INNER JOIN regions ON properties.region_id=regions.region_id INNER JOIN countries ON regions.country_id=countries.country_id WHERE properties.property_featured=1 AND countries.country_id= order by rand() LIMIT 0,4;

MYSQL ERROR:
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 'order by rand() LIMIT 0,4' at line 1