SELECT A.id, A.fname, A.sname, A.title, A.city, A.county, A.salary_type, A.seo_url, A.image, A.salary_from, A.salary_to, A.availability, A.anonymous, A.job_type, A.video_link, B.id as short_list_id, C.cname,(SELECT sum(total_like) FROM video_like D WHERE A.id=D.like_id) AS total_like FROM candidates A LEFT JOIN candidate_shortlist B ON A.id=B.candidate_id LEFT JOIN category C ON A.category_id=C.id WHERE A.status = 1 AND B.recruiter_id=
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1