error: 1139: Invalid result set returned, Regex error 'unmatched closing parenthesis at offset 5'
SELECT id AS `vacancy-id`, `subject` AS `vacancy-title`, (SELECT `name` FROM county WHERE id = location) AS `vacancy-location`, small_description AS `vacancy-summary`, salary_min AS `vacancy-min-sal`, salary_max AS `vacancy-max-sal` FROM vacancies WHERE keywords REGEXP (SELECT REPLACE(keywords, ',', '|') FROM vacancies WHERE id = '35949') AND `subject` REGEXP (SELECT REPLACE(SUBJECT, ' ', '|') FROM vacancies WHERE id = '35949') AND active = 'Y' AND expiry_date > NOW()ORDER BY RAND() LIMIT 6


Function: debugInfo (File: /var/www/vhosts/simplyeducation.co.uk/httpdocs/website-includes/cls/database.class.php line:152);
Function: queryReturnResultSet (File: /var/www/vhosts/simplyeducation.co.uk/httpdocs/website-includes/cls/database.class.php line:128);
Function: query (File: /var/www/vhosts/simplyeducation.co.uk/httpdocs/website-includes/cls/database.class.php line:103);
Function: data_table (File: /var/www/vhosts/simplyeducation.co.uk/httpdocs/website/cls/jobs.class.php line:94);
Function: getRelatedJobs (File: /var/www/vhosts/simplyeducation.co.uk/httpdocs/website/content/banners/featured-jobs.mod.php line:10);
Function: include (File: /var/www/vhosts/simplyeducation.co.uk/httpdocs/website/cls/contents.class.php line:111);
Function: pageBanners (File: /var/www/vhosts/simplyeducation.co.uk/httpdocs/website/cls/render.class.php line:196);
Function: show (File: /var/www/vhosts/simplyeducation.co.uk/httpdocs/website/startup.inc.php line:52);
Function: include_once (File: /var/www/vhosts/simplyeducation.co.uk/httpdocs/site-index.php line:45);
Function: include_once (File: /var/www/vhosts/simplyeducation.co.uk/httpdocs/index.php line:23);
Did 7 queries.
SELECT id, refno, description, job_date, `subject` AS `title`, vacancy_type, contract_hours, town, (SELECT `name` FROM county WHERE id = location) AS `county`, postcode, salary_type, salary_min, salary_max, expiry_date, active, get_consultant_name(consultantid) as consultant FROM vacancies WHERE id = '35949' 0.000706
SELECT id AS `vacancy-id`, job_date AS `vacancy-date`, `subject` AS `vacancy-title`, (SELECT NAME FROM county WHERE id = location) AS `vacancy-location`, vacancy_type AS `vacancy-type`, small_description AS `vacancy-summary`, salary_min AS `vacancy-sal-min`, salary_max AS `vacancy-sal-max` FROM vacancies WHERE active = 'Y' AND expiry_date >= CURDATE() ORDER BY job_date DESC LIMIT 5 0.028182
SELECT subject as title, small_description, (SELECT `name` FROM county WHERE id = location) AS `county`, refno FROM vacancies WHERE id = '35949' 0.002216
SELECT subject FROM vacancies WHERE id = '35949' 0.000299
SELECT subject FROM vacancies WHERE id = '35949' 0.000309
SELECT consultantid as cid FROM vacancies WHERE id = 35949 0.000494
SELECT id, refno, description, job_date, `subject` AS `title`, vacancy_type, contract_hours, town, (SELECT `name` FROM county WHERE id = location) AS `county`, postcode, salary_type, salary_min, salary_max, expiry_date, active, get_consultant_name(consultantid) as consultant FROM vacancies WHERE id = '35949' 0.000602