You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
AND O.deleted=0
AND O.date >="2025-02-10"
ORDER BY O.date
)' at line 10Array
(
[0] => Error Number: 1064
[1] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')
AND O.deleted=0
AND O.date >="2025-02-10"
ORDER BY O.date
)' at line 10
[2] =>
SELECT *
FROM (
SELECT P.id, O.mlsNum,
DATE_FORMAT(O.date,"%c/%e/%Y") AS date,
TIME_FORMAT(O.timeStart,"%l:%i%p") AS timeStart,
TIME_FORMAT(O.timeEnd,"%l:%i%p") AS timeEnd,
IF(O.listingAgent = "", P.agent, O.listingAgent) AS listingAgent, IF(O.listingOffice = "", P.listingOffice, O.listingOffice) AS listingOffice
FROM RETS_OpenHouses AS O
JOIN RETS_Property AS P ON (O.mlsNum=P.mlsNum AND O.feed=P.feed)
WHERE P.id IN()
AND O.deleted=0
AND O.date >="2025-02-10"
ORDER BY O.date
) AS T
GROUP BY T.id;
)