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.city_id = 33 AND a.positions = 72 AND DATEDIFF(NOW(), a.created_time) <= (1 * 7) AND (
(a.name LIKE '%%')
OR (b.company_name LIKE '%%')
OR (a.alias LIKE '%%')
)
ORDER BY
a.is_hot DESC,
a.is_new_post DESC,
a.is_best DESC,
a.id DESC
Query ErrorSELECT a.id
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.city_id = 33 AND a.positions = 72 AND DATEDIFF(NOW(), a.created_time) <= (1 * 7) AND (
(a.name LIKE '%%')
OR (b.company_name LIKE '%%')
OR (a.alias LIKE '%%')
)
order by id DESC
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'a.positions' in 'where clause'
)