Database Error : 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 (state='Confirmed' OR (state='unConfirmed' AND CONCAT(SUBSTR(insertTime...' at line 1

Error Number : 1064

query : 'SELECT COUNT(*) AS number FROM dct_visits WHERE doctor_id=2 AND visitDate='1404-04-07' AND type IN () AND (state='Confirmed' OR (state='unConfirmed' AND CONCAT(SUBSTR(insertTime FROM 1 FOR 11),ADDTIME(SUBSTR(insertTime FROM 12 FOR 8),'00:10:00'))>'1404-04-04 06:17:14')) AND (site_id=3 OR parent_site_id=3) AND `delete`='No''