[QUERY FAIL] SELECT SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 101 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_101, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 210 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_210, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 739 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_739, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 740 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_740, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 741 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_741, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 742 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_742, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 743 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_743, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 744 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_744, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 745 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_745, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 746 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_746, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 747 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_747, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 748 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_748, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 789 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_789, SUM(CASE WHEN ( published = 1 AND (is_status = 5 OR is_forever = 1) and category_id = 812 AND ( degree_id = 5 ) AND ( salaries = 33 OR salaries = 4 ) AND (category_id_wrapper LIKE '%,101,%' AND (category_id = 47) OR category_id_wrapper LIKE '%,209,%' AND (category_id = 741 OR category_id = 210 OR category_id = 101 OR category_id = 739 OR category_id = 745) OR category_id_wrapper LIKE '%,366,%' ) ) THEN 1 ELSE 0 END) AS count_812 FROM fs_products WHERE fs_products
-
Software Engineering ( 0 )
-
Software Testing ( 0 )
-
Artificial Intelligence (AI) ( 0 )
-
Data Science ( 0 )
-
IT Infrastructure and Operations ( 0 )
-
Information Security ( 0 )
-
IoT/Embedded Engineer ( 0 )
-
IT Management/Specialist ( 0 )
-
Software Design ( 0 )
-
Product Management ( 0 )
-
Sales IT Phần mềm ( 0 )
-
Công nghệ thông tin khác ( 0 )
-
IT Project Management ( 0 )
-
Game Development ( 0 )