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