Server shutdown in progress<br>SELECT id,title,requirement,company,experience,city,site,source_url,category,description,employment_conditions,salary_offered,(CASE 
                    WHEN date_posted = date_start and date_start >='2024-08-25' THEN 1
                    WHEN date_start >= '2024-09-24' THEN 1 
                    ELSE 0 END ) as nbr_active,(CASE 
                    WHEN premium =1 THEN 0
                    ELSE 0 END ) as premium,(CASE WHEN title like '%Apparitrice%' THEN 4 ELSE 0 END ) as nbr_title_0,(CASE WHEN description like '%Apparitrice%' THEN 2 ELSE 0 END ) as nbr_keyword_0,(CASE WHEN title like '%Apparitrice%' OR description like '%Apparitrice%' OR requirement like '%Apparitrice%' THEN 1 ELSE 0 END ) as nbr_key_0,(CASE WHEN title like '%appariteur%' THEN 2 ELSE 0 END ) as nbr_title_2,(CASE WHEN description like '%appariteur%' THEN 1 ELSE 0 END ) as nbr_keyword_2,(CASE WHEN title like '%appariteur%' OR description like '%appariteur%' OR requirement like '%appariteur%' THEN 1 ELSE 0 END ) as nbr_key_2,(CASE WHEN title like '%centre%' THEN 2 ELSE 0 END ) as nbr_title_3,(CASE WHEN description like '%centre%' THEN 1 ELSE 0 END ) as nbr_keyword_3,(CASE WHEN title like '%centre%' OR description like '%centre%' OR requirement like '%centre%' THEN 1 ELSE 0 END ) as nbr_key_3,(CASE WHEN title like '%formation%' THEN 2 ELSE 0 END ) as nbr_title_5,(CASE WHEN description like '%formation%' THEN 1 ELSE 0 END ) as nbr_keyword_5,(CASE WHEN title like '%formation%' OR description like '%formation%' OR requirement like '%formation%' THEN 1 ELSE 0 END ) as nbr_key_5,(CASE WHEN title like '%professionnelle%' THEN 2 ELSE 0 END ) as nbr_title_6,(CASE WHEN description like '%professionnelle%' THEN 1 ELSE 0 END ) as nbr_keyword_6,(CASE WHEN title like '%professionnelle%' OR description like '%professionnelle%' OR requirement like '%professionnelle%' THEN 1 ELSE 0 END ) as nbr_key_6,(CASE WHEN title like '%pointe%' THEN 2 ELSE 0 END ) as nbr_title_9,(CASE WHEN description like '%pointe%' THEN 1 ELSE 0 END ) as nbr_keyword_9,(CASE WHEN title like '%pointe%' OR description like '%pointe%' OR requirement like '%pointe%' THEN 1 ELSE 0 END ) as nbr_key_9,(CASE WHEN title like '%lac%' THEN 2 ELSE 0 END ) as nbr_title_11,(CASE WHEN description like '%lac%' THEN 1 ELSE 0 END ) as nbr_keyword_11,(CASE WHEN title like '%lac%' OR description like '%lac%' OR requirement like '%lac%' THEN 1 ELSE 0 END ) as nbr_key_11,(CASE WHEN title like '%secteur%' THEN 2 ELSE 0 END ) as nbr_title_12,(CASE WHEN description like '%secteur%' THEN 1 ELSE 0 END ) as nbr_keyword_12,(CASE WHEN title like '%secteur%' OR description like '%secteur%' OR requirement like '%secteur%' THEN 1 ELSE 0 END ) as nbr_key_12,(CASE WHEN title like '%sant%' THEN 2 ELSE 0 END ) as nbr_title_13,(CASE WHEN description like '%sant%' THEN 1 ELSE 0 END ) as nbr_keyword_13,(CASE WHEN title like '%sant%' OR description like '%sant%' OR requirement like '%sant%' THEN 1 ELSE 0 END ) as nbr_key_13,date_insertion,date_start,(CASE WHEN date_posted >= '2024-09-17' THEN 1 ELSE 0 END ) as nbr_week,(CASE WHEN date_posted >= '2024-08-25' THEN 1 ELSE 0 END ) as nbr_month FROM jobs WHERE  status = 1  AND (state = 'quebec' OR state = 'qc')  AND date_posted <= '2024-09-24'  AND city like '%Salaberry-de-Valleyfield%'  AND salary_offered REGEXP '^27[^0-9]' AND MATCH(title,company,description,tags) AGAINST ('Apparitrice ou appariteur centre de formation professionnelle de la pointe du lac secteur sant')  ORDER BY nbr_active DESC,nbr_title_0 +nbr_title_2 +nbr_title_3 +nbr_title_5 +nbr_title_6 +nbr_title_9 +nbr_title_11 +nbr_title_12 +nbr_title_13  DESC,date_posted DESC,nbr_key_0 +nbr_key_2 +nbr_key_3 +nbr_key_5 +nbr_key_6 +nbr_key_9 +nbr_key_11 +nbr_key_12 +nbr_key_13  DESC,nbr_keyword_0 +nbr_keyword_2 +nbr_keyword_3 +nbr_keyword_5 +nbr_keyword_6 +nbr_keyword_9 +nbr_keyword_11 +nbr_keyword_12 +nbr_keyword_13  DESC,description ASC,id DESC  LIMIT 0 , 100