SQL Error encountered
SQL Query: SELECT job.jobID AS id, job.jobReference AS reference, job.jobTitle AS title, job.jobIndustryID AS industryID, job.areaofHRID AS areaofHRID, job.jobTypeID AS typeID, job.jobDescription AS description, job.jobSalaryFrom AS salaryFrom, job.jobSalaryTo AS salaryTo, job.jobRegionID AS regionID, job.jobPackage AS package, job.userID AS userID, job.jobStatus AS jobStatus, job.payType AS paytype, job.clientID AS clientID, jobType.jobType AS type, jobIndustry.jobIndustry AS industry, areaOfHR.areaOfHR AS areaOfHR, jobRegion.jobRegion AS region, featuredJobs.DisplayOrder AS featuredOrder, CASE WHEN typicalAssignments.jobID IS NULL THEN 0 ELSE 1 END AS typicalAss FROM job LEFT JOIN jobType ON jobType.jobTypeID=job.jobTypeID LEFT JOIN jobIndustry ON jobIndustry.jobIndustryID=job.jobIndustryID LEFT JOIN areaOfHR ON areaOfHR.areaOfHRID=job.areaOfHRID LEFT JOIN jobRegion ON jobRegion.jobRegionID=job.jobRegionID LEFT JOIN featuredJobs ON featuredJobs.jobID=job.jobID LEFT JOIN typicalAssignments ON typicalAssignments.jobID=job.jobID WHERE job.jobID = 2502/CIPD-qualified-Learning-and-Development-Advisor
Error returned: 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-Development-Advisor' at line 30