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 i_status IN (2, 1) AND i_rating > 0 AND i_ratingcnt >= 17 ORDER BY i_rating ' at line 1 Failed query: SELECT SQL_CALC_FOUND_ROWS m_user , i_rating, i_ratingcnt , o_id , i_id, i_user, i_name, i_location, i_status , DATE_FORMAT(FROM_UNIXTIME(i_time), '%d-%M-%Y') AS reg_date FROM rate_members LEFT JOIN rate_members_online ON o_id=m_id LEFT JOIN rate_pictures ON i_user=m_id WHERE i_type = AND i_status IN (2, 1) AND i_rating > 0 AND i_ratingcnt >= 17 ORDER BY i_rating DESC LIMIT 0, 50