SELECT SUM(CASE WHEN (category_id_wrapper LIKE '%,190,%') THEN 1 ELSE 0 END) AS count_190, SUM(CASE WHEN (category_id_wrapper LIKE '%,193,%') THEN 1 ELSE 0 END) AS count_193, SUM(CASE WHEN (category_id_wrapper LIKE '%,208,%') THEN 1 ELSE 0 END) AS count_208, SUM(CASE WHEN (category_id_wrapper LIKE '%,209,%') THEN 1 ELSE 0 END) AS count_209, SUM(CASE WHEN (category_id_wrapper LIKE '%,211,%') THEN 1 ELSE 0 END) AS count_211, SUM(CASE WHEN (category_id_wrapper LIKE '%,212,%') THEN 1 ELSE 0 END) AS count_212, SUM(CASE WHEN (category_id_wrapper LIKE '%,215,%') THEN 1 ELSE 0 END) AS count_215, SUM(CASE WHEN (category_id_wrapper LIKE '%,219,%') THEN 1 ELSE 0 END) AS count_219, SUM(CASE WHEN (category_id_wrapper LIKE '%,226,%') THEN 1 ELSE 0 END) AS count_226, SUM(CASE WHEN (category_id_wrapper LIKE '%,234,%') THEN 1 ELSE 0 END) AS count_234, SUM(CASE WHEN (category_id_wrapper LIKE '%,240,%') THEN 1 ELSE 0 END) AS count_240, SUM(CASE WHEN (category_id_wrapper LIKE '%,250,%') THEN 1 ELSE 0 END) AS count_250, SUM(CASE WHEN (category_id_wrapper LIKE '%,257,%') THEN 1 ELSE 0 END) AS count_257, SUM(CASE WHEN (category_id_wrapper LIKE '%,266,%') THEN 1 ELSE 0 END) AS count_266, SUM(CASE WHEN (category_id_wrapper LIKE '%,272,%') THEN 1 ELSE 0 END) AS count_272, SUM(CASE WHEN (category_id_wrapper LIKE '%,279,%') THEN 1 ELSE 0 END) AS count_279, SUM(CASE WHEN (category_id_wrapper LIKE '%,293,%') THEN 1 ELSE 0 END) AS count_293, SUM(CASE WHEN (category_id_wrapper LIKE '%,299,%') THEN 1 ELSE 0 END) AS count_299, SUM(CASE WHEN (category_id_wrapper LIKE '%,304,%') THEN 1 ELSE 0 END) AS count_304, SUM(CASE WHEN (category_id_wrapper LIKE '%,312,%') THEN 1 ELSE 0 END) AS count_312, SUM(CASE WHEN (category_id_wrapper LIKE '%,317,%') THEN 1 ELSE 0 END) AS count_317, SUM(CASE WHEN (category_id_wrapper LIKE '%,325,%') THEN 1 ELSE 0 END) AS count_325, SUM(CASE WHEN (category_id_wrapper LIKE '%,328,%') THEN 1 ELSE 0 END) AS count_328, SUM(CASE WHEN (category_id_wrapper LIKE '%,329,%') THEN 1 ELSE 0 END) AS count_329, SUM(CASE WHEN (category_id_wrapper LIKE '%,330,%') THEN 1 ELSE 0 END) AS count_330, SUM(CASE WHEN (category_id_wrapper LIKE '%,364,%') THEN 1 ELSE 0 END) AS count_364, SUM(CASE WHEN (category_id_wrapper LIKE '%,365,%') THEN 1 ELSE 0 END) AS count_365, SUM(CASE WHEN (category_id_wrapper LIKE '%,366,%') THEN 1 ELSE 0 END) AS count_366, SUM(CASE WHEN (category_id_wrapper LIKE '%,493,%') THEN 1 ELSE 0 END) AS count_493, SUM(CASE WHEN (category_id_wrapper LIKE '%,1262,%') THEN 1 ELSE 0 END) AS count_1262, SUM(CASE WHEN (category_id_wrapper LIKE '%,1323,%') THEN 1 ELSE 0 END) AS count_1323, SUM(CASE WHEN (category_id_wrapper LIKE '%,1324,%') THEN 1 ELSE 0 END) AS count_1324 FROM fs_products WHERE published = 1 AND (is_status = 5 OR is_status = 4 OR is_forever = 1) AND created_time >= DATE_SUB("2025-07-19 15:37:24", INTERVAL 1 DAY) AND created_time <= "2025-07-19 15:37:24" AND ( degree_id = 5 ) AND ( salaries = 33 ) AND ( category_id_wrapper LIKE "%,47,%" OR category_id_wrapper LIKE "%,,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,330,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,299,%" )
Query Error SELECT *
FROM fs_job_categories
WHERE id =Array
(
[0] => 42000
[1] => 1064
[2] => 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 '' at line 3
)