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 '%,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 '%,743,%' OR a.category_id_wrapper LIKE '%,787,%' OR a.category_id_wrapper LIKE '%,788,%' 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 '%,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 '%,740,%' OR a.category_id_wrapper LIKE '%,768,%' OR a.category_id_wrapper LIKE '%,769,%' 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,%')
ORDER BY
a.is_hot DESC,
a.is_new_post DESC,
a.is_best DESC,
a.id DESC
Query Error
SELECT
a.id, a.posting_code, a.name, a.alias,
a.city_id, a.user_id, a.created_time,
a.latitude, a.longitude, a.address,
a.is_hot, a.is_new_post, a.is_best,
a.salaries, a.time_limited, a.hits,
a.link_map, a.wards_id, a.language, a.organize,
a.experience, a.degree_id, a.sex,
job.name AS name_job,
job_organize.name AS name_organize,
deg.name AS name_deg,
emp.company_name,
emp.avatar AS com_image,
sal.name AS salary_name,
city.name AS city_name,
wards.name AS wards_name
FROM fs_products_statistic AS a
INNER JOIN fs_members_employer AS emp ON a.user_id = emp.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
LEFT JOIN fs_job_salaries AS sal ON a.salaries = sal.id
LEFT JOIN fs_cities AS city ON a.city_id = city.id
LEFT JOIN fs_wards AS wards ON a.wards_id = wards.id
WHERE a.id IN (24003,23455,22866,21060,20349,19257,19100,19076,18548,18083,13632,10207,7112,6966,6964,5687,23994,23484,23395,23391)
ORDER BY FIELD(a.id, 24003,23455,22866,21060,20349,19257,19100,19076,18548,18083,13632,10207,7112,6966,6964,5687,23994,23484,23395,23391)
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'a.address' in 'field list'
)