MySQL database error: No data supplied for parameters in prepared statement for query
SELECT vacancy.id as vid,`title`, `v_alias`, `v_summary`, `v_profileId`, `sp_name`, `sp_latitude`, `sp_longitude`, `sp_logo`,
COALESCE(area, 'aOther') AS areaSort
FROM vacancy LEFT OUTER JOIN school_profile ON sp_id = v_profileId
LEFT OUTER JOIN vacanciesinareas ON vacancy.id = vacanciesinareas.vacancyid
LEFT OUTER JOIN area ON vacanciesinareas.areaId = area.id
LEFT OUTER JOIN vacanciesinsubjects on vacancy.id = vacanciesinsubjects.vacancyid
LEFT OUTER JOIN subject on vacanciesinsubjects.subjectid = subject.id
,vacanciesincategories,category WHERE vacancy.id = vacanciesincategories.vacancyid AND category.id = vacanciesincategories.categoryid
AND publish <= NOW() AND expire > NOW() AND `status` = 'publish'
AND subject.id = ?
AND categoryid = ?
ORDER BY title, vacancy.id
in D:\www\Greensheets2\www\classes\pageControls.php on line 1249