SQL:
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 '%,,%' AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
ORDER BY
a.is_hot DESC,
a.is_new_post DESC,
a.is_best DESC,
a.id DESC
build_where_full: AND (a.category_id IN (756,1309,210,743,101,740,742,812)) AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
build_where_full: AND (a.category_id IN (756,1309,210,743,101,740,742,812)) AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
build_where_full: AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
build_where_full: AND (a.category_id IN (756,1309,210,743,101,740,742,812)) AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
build_where_full: AND (a.category_id IN (756,1309,210,743,101,740,742,812)) AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
build_where_full: AND (a.category_id IN (756,1309,210,743,101,740,742,812)) AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
build_where_full: AND (a.category_id IN (756,1309,210,743,101,740,742,812)) AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
build_where_full: AND (a.category_id IN (756,1309,210,743,101,740,742,812)) AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
build_where_full: AND (a.category_id IN (756,1309,210,743,101,740,742,812)) AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
build_where_full: AND (a.category_id IN (756,1309,210,743,101,740,742,812)) AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
build_where_full: AND (a.category_id IN (756,1309,210,743,101,740,742,812)) AND DATEDIFF(NOW(), a.created_time) <= (1 * 30)
Query Error SELECT name
FROM fs_cities
WHERE alias = 'fullstack-developer,van-tai-1,software-testing,iotembedded-engineer,software-engineering,data-science,information-security,game-development'
Array
(
[0] => HY000
[1] => 2006
[2] => MySQL server has gone away
)