SELECT COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 1 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_1, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 10 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_10, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 11 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_11, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 12 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_12, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 13 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_13, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 14 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_14, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 15 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_15, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 16 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_16, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 17 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_17, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 18 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_18, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 19 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_19, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 2 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_2, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 20 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_20, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 21 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_21, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 22 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_22, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 23 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_23, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 24 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_24, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 25 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_25, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 26 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_26, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 27 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_27, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 28 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_28, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 29 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_29, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 3 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_3, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 30 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_30, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 31 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_31, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 32 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_32, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 33 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_33, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 34 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_34, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 4 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_4, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 5 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_5, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 6 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_6, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 7 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_7, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 8 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_8, COUNT(CASE WHEN published = 1 AND is_status = 5 and city_id = 9 AND ( degree_id = 5 ) AND ( salaries = 31 OR salaries = 29 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 210 OR category_id = 741 OR category_id = 743 OR category_id = 739 OR category_id = 101 OR category_id = 740) OR category_id_wrapper LIKE '%,366,%' ) AND ( user_id = 145351 ) THEN 1 END) AS count_city_9 FROM fs_products
