08CMS Info: MySQL Query Error
Time: 2024-8-17 20:10
SQL: SELECT COUNT(*) FROM #__archives16 a INNER JOIN #__archives_3 c ON c.aid = a.aid WHERE shi = '4' AND ting = '4' AND wei = '1' AND cx = '3' AND (CONCAT(',', fwpt, ',') LIKE '%,12,%' OR CONCAT(',', fwpt, ',') LIKE '%,26,%' OR CONCAT(',', fwpt, ',') LIKE '%,27,%' OR CONCAT(',', fwpt, ',') LIKE '%,28,%' OR CONCAT(',', fwpt, ',') LIKE '%,29,%' OR CONCAT(',', fwpt, ',') LIKE '%,596,%' OR CONCAT(',', fwpt, ',') LIKE '%,608,%' OR CONCAT(',', fwpt, ',') LIKE '%,609,%' OR CONCAT(',', fwpt, ',') LIKE '%,610,%') AND a.goodhouse = '1' createdate >= 1723637428 AND a.chid = '3' AND a.ccid1 = '214' AND ( (c.fl >= 2013)) AND ( (a.mj >= '300')) AND a.checked = 1 AND (a.enddate = 0 OR a.enddate > '1723896628')
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 >= 1723637428 AND a.chid = '3' AND a.ccid1 = '214' AND ( (c.fl >= 201' at line 1
Errno.: 1064