StuRents

Database Error

The site has encountered a database error when trying to execute the following query:

SELECT h.*,l.name,p.photo_id AS pic,p.img,loc.title AS loc FROM house_profiles AS h INNER JOIN house_landlords AS l ON l.landlord_id=h.landlord_id INNER JOIN locations AS loc ON loc.loc_id=h.loc_id LEFT JOIN photos AS p ON p.type='house' and p.item_id=h.house_id and p.order=1 WHERE h.landlord_id= and h.status=1 ORDER BY RAND() LIMIT 2

The MYSQL error produced was:

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 'and h.status=1 ORDER BY RAND() LIMIT 2' at line 6