Server shutdown in progress
SELECT COUNT(*) as total FROM jobs WHERE status = 1 AND (state = 'quebec' OR state = 'qc') AND date_posted <= '2024-04-29' AND company like '%Centre d\'emploi agricole de lanaudière (voir nom de l\'employeur dans titre du poste)%' AND salary_offered REGEXP '^17[^0-9]' AND MATCH(title,company,description,tags) AGAINST ('Adjoint e aide technicien ne')