08CMS Info: MySQL Query Error
Time: 2024-8-20 07:40
SQL: SELECT COUNT(*) FROM #__archives16 a INNER JOIN #__archives_3 c ON c.aid = a.aid WHERE chu = '3' AND zxcd = '2' AND fwjg = '3' AND (CONCAT(',', fwpt, ',') LIKE '%,7,%' OR CONCAT(',', fwpt, ',') LIKE '%,24,%' OR CONCAT(',', fwpt, ',') LIKE '%,25,%' OR CONCAT(',', fwpt, ',') LIKE '%,23,%' OR CONCAT(',', fwpt, ',') LIKE '%,22,%' OR CONCAT(',', fwpt, ',') LIKE '%,620,%' OR CONCAT(',', fwpt, ',') LIKE '%,621,%' OR CONCAT(',', fwpt, ',') LIKE '%,622,%') AND a.mchid = '1' createdate >= 1724024448 AND a.chid = '3' AND a.ccid43 = '3006' AND a.ccid1 = '212' AND ( (c.fl < 2005)) AND ( (a.mj >= '150' and a.mj <= '200')) AND a.checked = 1 AND (a.enddate = 0 OR a.enddate > '1724110848')
File: Create() called at [/index.php : 63]
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 'createdate >= 1724024448 AND a.chid = '3' AND a.ccid43 = '3006' AND a.ccid1 = '2' at line 1
Errno.: 1064