Query: SELECT SQL_CALC_FOUND_ROWS DISTINCT i.*, p.is_paid, p.hot_swop, IF( IF(sold = 0 ,datediff('2024-11-21 20:14:58',DateTo) > 0 ,datediff('2024-11-21',sold_time) > 14),1,0) AS is_expired, (SELECT m.Name FROM items_model AS m WHERE i.ItemModel = m.ID ) AS ItemModel_Name, (SELECT t.Name FROM items_type AS t WHERE i.ItemType = t.ID ) AS ItemType_Name, (SELECT CONCAT(a.firstname,' ',a.lastname) FROM agent AS a WHERE a.agent_id = i.agent_id ) AS agent_name, (SELECT r.name FROM regions AS r WHERE r.region_id = i.City ) AS City_Name, (SELECT r.name FROM regions AS r WHERE r.region_id = i.Country ) AS Country_Name FROM items AS i LEFT JOIN items_payment AS p ON i.ID = p.swop_id AND p.date_from <= '2024-11-21 20:14:58' AND p.date_to >= '2024-11-21 20:14:58' WHERE 1 AND i.agent_id = AND Live = 1 AND pay_status = 1 AND IF(sold = 0 ,datediff('2024-11-21',DateTo) <= 14 ,datediff('2024-11-21',sold_time) <= 14) ORDER BY IF( IF(sold = 0 ,datediff('2024-11-21 20:14:58',DateTo) > 0 ,datediff('2024-11-21',sold_time) > 14),1,0) ASC, p.is_paid DESC, p.creation_date DESC, sold, LastUpdateTime DESC LIMIT 0,12 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 'AND Live = 1 AND pay_status = 1 AND IF(sold = 0 ' at line 39Query: SELECT * FROM agent WHERE 1 AND agent_id = LIMIT 1 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 'LIMIT 1' at line 3