1
Post a Job for FREE
Upload CV
Sign In
Sign In
Not registered?
Create Account
Email Address
*
Password
*
Sign In
Email Address
*
Password
*
Sign In
Email Address
*
Password
*
Retrieve Password
Email Address
*
Logout
Like our site?
Like our site? Please help us spread the word!
Recruitment Agents
Search by Sector
SELECT SQL_CALC_FOUND_ROWS D.*,(CASE WHEN total IS NOT NULL THEN total ELSE 0 END) as gtotal FROM (SELECT * FROM (SELECT A.id,A.seo_url,A.name,A.logo,A.li_image,A.description FROM `recruiters` A WHERE A.login_type = '0' AND A.name!='' AND A.logo!='' AND A.logo NOT LIKE 'http%' AND A.country IN() AND A.sector_id IN (SELECT id FROM category WHERE (cpath LIKE '%Accounting & Finance%' OR cname='Accounting & Finance'))) AS T LEFT JOIN (SELECT count(id) as total,recruiters_id FROM `vacancies` where date_expired>=NOW() OR date_expired='' OR date_expired='0000-00-00 00:00:00' group by recruiters_id) AS B ON T.id=B.recruiters_id) AS D order by D.total desc
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 ') AND A.sector_id IN (SELECT id FROM category WHERE (cpath LIKE '%Accounting & F' at line 1
