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