Query body:
FROM fs_products_statistic AS a
LEFT JOIN fs_members_employer AS b ON a.user_id = b.id
LEFT JOIN fs_job_experience AS job ON a.experience = job.id
LEFT JOIN fs_job_organize AS job_organize ON a.organize = job_organize.id
LEFT JOIN fs_job_degree AS deg ON a.degree_id = deg.id
WHERE a.published = 1 AND a.is_status = 5 AND a.category_id = 1309 AND a.category_id = 812 AND a.category_id = 210 AND a.category_id = 745 AND a.category_id = 328 AND a.category_id = 740 AND a.category_id = 101 AND a.category_id = 743 AND (a.category_id_wrapper LIKE '%,756,%')
ORDER BY
a.is_hot DESC,
a.is_new_post DESC,
a.is_best DESC,
a.id DESC
Count by field query:
SELECT a.category_id_wrapper
FROM fs_products_statistic AS a
WHERE a.published = 1
AND a.is_status = 5
AND a.category_id = 1309 AND a.category_id = 812 AND a.category_id = 210 AND a.category_id = 745 AND a.category_id = 328 AND a.category_id = 740 AND a.category_id = 101 AND a.category_id = 743 AND (a.category_id_wrapper LIKE '%,756,%')
AND a.category_id_wrapper IS NOT NULL
AND a.category_id_wrapper != ''
AND a.category_id != ''
AND a.category_id IS NOT NULL