08CMS Info: MySQL Query Error
Time: 2024-8-17 19:09
SQL: SELECT COUNT(*) FROM #__archives16 a INNER JOIN #__archives_3 c ON c.aid = a.aid WHERE shi = '5' AND chu = '1' AND zxcd = '4' AND (CONCAT(',', fwpt, ',') LIKE '%,1,%' OR CONCAT(',', fwpt, ',') LIKE '%,502,%' OR CONCAT(',', fwpt, ',') LIKE '%,14,%' OR CONCAT(',', fwpt, ',') LIKE '%,15,%' OR CONCAT(',', fwpt, ',') LIKE '%,16,%' OR CONCAT(',', fwpt, ',') LIKE '%,17,%' OR CONCAT(',', fwpt, ',') LIKE '%,18,%' OR CONCAT(',', fwpt, ',') LIKE '%,514,%' OR CONCAT(',', fwpt, ',') LIKE '%,555,%' OR CONCAT(',', fwpt, ',') LIKE '%,556,%' OR CONCAT(',', fwpt, ',') LIKE '%,557,%' OR CONCAT(',', fwpt, ',') LIKE '%,503,%' OR CONCAT(',', fwpt, ',') LIKE '%,21,%' OR CONCAT(',', fwpt, ',') LIKE '%,20,%' OR CONCAT(',', fwpt, ',') LIKE '%,607,%' OR CONCAT(',', fwpt, ',') LIKE '%,801,%' OR CONCAT(',', fwpt, ',') LIKE '%,802,%' OR CONCAT(',', fwpt, ',') LIKE '%,803,%' OR CONCAT(',', fwpt, ',') LIKE '%,805,%' OR CONCAT(',', fwpt, ',') LIKE '%,806,%' OR CONCAT(',', fwpt, ',') LIKE '%,810,%' OR CONCAT(',', fwpt, ',') LIKE '%,811,%' OR CONCAT(',', fwpt, ',') LIKE '%,812,%' OR CONCAT(',', fwpt, ',') LIKE '%,814,%' OR CONCAT(',', fwpt, ',') LIKE '%,815,%' OR CONCAT(',', fwpt, ',') LIKE '%,807,%' OR CONCAT(',', fwpt, ',') LIKE '%,808,%' OR CONCAT(',', fwpt, ',') LIKE '%,809,%' OR CONCAT(',', fwpt, ',') LIKE '%,813,%') AND a.imgnum >= '1' createdate >= 1723633790 AND a.chid = '3' AND a.ccid1 = '217' AND ( (a.zj <= '20')) AND ( (a.mj >= '130' and a.mj <= '150')) AND a.checked = 1 AND (a.enddate = 0 OR a.enddate > '1723892990')
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 >= 1723633790 AND a.chid = '3' AND a.ccid1 = '217' AND ( (a.zj <= '20' at line 1
Errno.: 1064