Error: Unknown column 'Healthcare' in 'where clause'
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 (Healthcare)) AND jobDisplayFrom<='2017-12-11' AND jobDisplayTo>='2017-12-11' GROUP BY recruitmentJobs.jobID ORDER BY jobAdded DESC ) sub;
Unknown column 'Healthcare' in 'where clause'  
   -> /home/swiis/public_html/includes/modules/jobsearchModule.php Line 205
   -> /home/swiis/public_html/page.php Line 586
Error: Unknown column 'Healthcare' in 'where clause'
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 (Healthcare)) AND jobDisplayFrom<='2017-12-11' AND jobDisplayTo>='2017-12-11' GROUP BY recruitmentJobs.jobID ORDER BY jobAdded DESC
Unknown column 'Healthcare' in 'where clause'  
   -> /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+