Error: 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 'Worker)) AND jobDisplayFrom<='2017-12-11' AND jobDisplayTo>='2017-12-11' GROUP ' at line 1
Query: SELECT COUNT(*) AS rowCount FROM (SELECT recruitmentJobs.jobID FROM recruitmentJobs LEFT JOIN recruitmentJobsType ON recruitmentJobsType.jobID=recruitmentJobs.jobID JOIN recruitmentTypes ON tID=rtypeid LEFT JOIN recruitmentRegionConnect ON recruitmentRegionConnect.jobID=recruitmentJobs.jobID JOIN recruitmentRegions ON recruitmentRegions.rID=recruitmentRegionConnect.rID WHERE (jobExternal+jobExternalApproved=0 OR jobExternal+jobExternalApproved=2) AND jobActive=1 AND jobDisplayTo>='17-12-11' AND recruitmentJobs.jobID IN (SELECT rsl_job_id FROM recruitment_sector_links WHERE rsl_sector_id IN (Social Worker)) AND jobDisplayFrom<='2017-12-11' AND jobDisplayTo>='2017-12-11' GROUP BY recruitmentJobs.jobID ORDER BY jobAdded DESC ) sub;
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 'Worker)) AND jobDisplayFrom<='2017-12-11' AND jobDisplayTo>='2017-12-11' GROUP ' at line 1  
   -> /home/swiis/public_html/includes/modules/jobsearchModule.php Line 205
   -> /home/swiis/public_html/page.php Line 586
Error: 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 'Worker)) AND jobDisplayFrom<='2017-12-11' AND jobDisplayTo>='2017-12-11' GROUP ' at line 1
Query: SELECT *,GROUP_CONCAT(tTitle SEPARATOR ', ') AS types FROM recruitmentJobs LEFT JOIN recruitmentJobsType ON recruitmentJobsType.jobID=recruitmentJobs.jobID JOIN recruitmentTypes ON tID=rtypeid LEFT JOIN recruitmentRegionConnect ON recruitmentRegionConnect.jobID=recruitmentJobs.jobID JOIN recruitmentRegions ON recruitmentRegions.rID=recruitmentRegionConnect.rID WHERE (jobExternal+jobExternalApproved=0 OR jobExternal+jobExternalApproved=2) AND jobActive=1 AND jobDisplayTo>='17-12-11' AND recruitmentJobs.jobID IN (SELECT rsl_job_id FROM recruitment_sector_links WHERE rsl_sector_id IN (Social Worker)) AND jobDisplayFrom<='2017-12-11' AND jobDisplayTo>='2017-12-11' GROUP BY recruitmentJobs.jobID ORDER BY jobAdded 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 'Worker)) AND jobDisplayFrom<='2017-12-11' AND jobDisplayTo>='2017-12-11' GROUP ' at line 1  
   -> /home/swiis/public_html/includes/modules/jobsearchModule.php Line 205
   -> /home/swiis/public_html/page.php Line 586
Cannot modify header information - headers already sent by (output started at /home/swiis/public_html/includes/common/sql.php:145)/home/swiis/public_html/includes/modules/loginModule.phpLine 240
   -> /home/swiis/public_html/includes/modules/loginModule.php Line 240
   -> /home/swiis/public_html/includes/modules/loginModule.php Line 201
   -> /home/swiis/public_html/page.php Line 586
Search results | Swiis Health & Social Care

forgot password

Your search results

Invalid argument supplied for foreach()/home/swiis/public_html/style/templates/jobsearchResults.tplLine 7
   -> /home/swiis/public_html/includes/common/class.templates.php Line 38
   -> /home/swiis/public_html/includes/modules/jobsearchModule.php Line 785
   -> /home/swiis/public_html/includes/modules/jobsearchModule.php Line 205
   -> /home/swiis/public_html/page.php Line 586
Join in
Google+