Đã tìm thấy 0 công việc trong mục này
Bộ lọc
Địa điểm
-
Query ErrorSELECT COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 1 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_1, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 10 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_10, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 11 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_11, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 12 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_12, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 13 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_13, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 14 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_14, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 15 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_15, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 16 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_16, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 17 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_17, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 18 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_18, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 19 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_19, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 2 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_2, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 20 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_20, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 21 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_21, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 22 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_22, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 23 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_23, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 24 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_24, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 25 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_25, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 26 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_26, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 27 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_27, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 28 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_28, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 29 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_29, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 3 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_3, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 30 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_30, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 31 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_31, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 32 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_32, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 33 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_33, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 34 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_34, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 4 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_4, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 5 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_5, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 6 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_6, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 7 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_7, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 8 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_8, COUNT(CASE WHEN published = 1 AND (is_status = 5 OR is_forever = 1) AND created_time >= DATE_SUB("2025-08-12 18:24:05", INTERVAL 1 WEEK) AND created_time <= "2025-08-12 18:24:05" and city_id = 9 AND ( degree_id = 5 ) AND ( salaries = 4 ) 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 "%,366,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,364,%" OR category_id_wrapper LIKE "%,366,%" OR category_id_wrapper LIKE "%,366,%" ) AND ( wards_id=3248 ) THEN 1 END) AS count_city_9 FROM fs_products
Array ( [0] => HY000 [1] => 2006 [2] => MySQL server has gone away )