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_wrapper LIKE '%,756,%' OR a.category_id_wrapper LIKE '%,1309,%' OR a.category_id_wrapper LIKE '%,290,%' OR a.category_id_wrapper LIKE '%,1311,%' OR a.category_id_wrapper LIKE '%,1314,%' OR a.category_id_wrapper LIKE '%,1316,%' OR a.category_id_wrapper LIKE '%,101,%' OR a.category_id_wrapper LIKE '%,47,%' OR a.category_id_wrapper LIKE '%,753,%' OR a.category_id_wrapper LIKE '%,754,%' OR a.category_id_wrapper LIKE '%,755,%' OR a.category_id_wrapper LIKE '%,756,%' OR a.category_id_wrapper LIKE '%,757,%' OR a.category_id_wrapper LIKE '%,743,%' OR a.category_id_wrapper LIKE '%,787,%' OR a.category_id_wrapper LIKE '%,788,%' OR a.category_id_wrapper LIKE '%,812,%' OR a.category_id_wrapper LIKE '%,813,%' OR a.category_id_wrapper LIKE '%,814,%' OR a.category_id_wrapper LIKE '%,815,%' OR a.category_id_wrapper LIKE '%,816,%' OR a.category_id_wrapper LIKE '%,210,%' OR a.category_id_wrapper LIKE '%,759,%' OR a.category_id_wrapper LIKE '%,758,%' OR a.category_id_wrapper LIKE '%,760,%' OR a.category_id_wrapper LIKE '%,761,%' OR a.category_id_wrapper LIKE '%,762,%' OR a.category_id_wrapper LIKE '%,763,%' OR a.category_id_wrapper LIKE '%,209,%' OR a.category_id_wrapper LIKE '%,101,%' OR a.category_id_wrapper LIKE '%,210,%' OR a.category_id_wrapper LIKE '%,739,%' OR a.category_id_wrapper LIKE '%,740,%' OR a.category_id_wrapper LIKE '%,741,%' OR a.category_id_wrapper LIKE '%,742,%' OR a.category_id_wrapper LIKE '%,743,%' OR a.category_id_wrapper LIKE '%,744,%' OR a.category_id_wrapper LIKE '%,745,%' OR a.category_id_wrapper LIKE '%,746,%' OR a.category_id_wrapper LIKE '%,748,%' OR a.category_id_wrapper LIKE '%,789,%' OR a.category_id_wrapper LIKE '%,812,%' OR a.category_id_wrapper LIKE '%,745,%' OR a.category_id_wrapper LIKE '%,803,%' OR a.category_id_wrapper LIKE '%,807,%' OR a.category_id_wrapper LIKE '%,740,%' OR a.category_id_wrapper LIKE '%,768,%' OR a.category_id_wrapper LIKE '%,769,%')
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_wrapper IS NOT NULL
AND a.category_id_wrapper != ''
Query ErrorSELECT id,name,alias FROM fs_cities WHERE published = 1 ORDER BY ordering ASCArray
(
[0] => HY000
[1] => 2006
[2] => MySQL server has gone away
)