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-03-29' THEN 1
                    WHEN date_start >= '2024-04-28' THEN 1 
                    ELSE 0 END ) as nbr_active,(CASE 
                    WHEN premium =1 THEN 0
                    ELSE 0 END ) as premium,(CASE WHEN title like '%411911%' THEN 4 ELSE 0 END ) as nbr_title_0,(CASE WHEN description like '%411911%' THEN 2 ELSE 0 END ) as nbr_keyword_0,(CASE WHEN title like '%411911%' OR description like '%411911%' OR requirement like '%411911%' THEN 1 ELSE 0 END ) as nbr_key_0,(CASE WHEN title like '%emploi%' THEN 2 ELSE 0 END ) as nbr_title_1,(CASE WHEN description like '%emploi%' THEN 1 ELSE 0 END ) as nbr_keyword_1,(CASE WHEN title like '%emploi%' OR description like '%emploi%' OR requirement like '%emploi%' THEN 1 ELSE 0 END ) as nbr_key_1,(CASE WHEN title like '%etudiant%' THEN 2 ELSE 0 END ) as nbr_title_2,(CASE WHEN description like '%etudiant%' THEN 1 ELSE 0 END ) as nbr_keyword_2,(CASE WHEN title like '%etudiant%' OR description like '%etudiant%' OR requirement like '%etudiant%' THEN 1 ELSE 0 END ) as nbr_key_2,(CASE WHEN title like '%soutien%' THEN 2 ELSE 0 END ) as nbr_title_4,(CASE WHEN description like '%soutien%' THEN 1 ELSE 0 END ) as nbr_keyword_4,(CASE WHEN title like '%soutien%' OR description like '%soutien%' OR requirement like '%soutien%' THEN 1 ELSE 0 END ) as nbr_key_4,(CASE WHEN title like '%aux%' THEN 2 ELSE 0 END ) as nbr_title_5,(CASE WHEN description like '%aux%' THEN 1 ELSE 0 END ) as nbr_keyword_5,(CASE WHEN title like '%aux%' OR description like '%aux%' OR requirement like '%aux%' THEN 1 ELSE 0 END ) as nbr_key_5,(CASE WHEN title like '%conseilleres%' THEN 2 ELSE 0 END ) as nbr_title_6,(CASE WHEN description like '%conseilleres%' THEN 1 ELSE 0 END ) as nbr_keyword_6,(CASE WHEN title like '%conseilleres%' OR description like '%conseilleres%' OR requirement like '%conseilleres%' THEN 1 ELSE 0 END ) as nbr_key_6,(CASE WHEN title like '%conseillers%' THEN 2 ELSE 0 END ) as nbr_title_8,(CASE WHEN description like '%conseillers%' THEN 1 ELSE 0 END ) as nbr_keyword_8,(CASE WHEN title like '%conseillers%' OR description like '%conseillers%' OR requirement like '%conseillers%' THEN 1 ELSE 0 END ) as nbr_key_8,(CASE WHEN title like '%production%' THEN 2 ELSE 0 END ) as nbr_title_10,(CASE WHEN description like '%production%' THEN 1 ELSE 0 END ) as nbr_keyword_10,(CASE WHEN title like '%production%' OR description like '%production%' OR requirement like '%production%' THEN 1 ELSE 0 END ) as nbr_key_10,(CASE WHEN title like '%graphique%' THEN 2 ELSE 0 END ) as nbr_title_11,(CASE WHEN description like '%graphique%' THEN 1 ELSE 0 END ) as nbr_keyword_11,(CASE WHEN title like '%graphique%' OR description like '%graphique%' OR requirement like '%graphique%' THEN 1 ELSE 0 END ) as nbr_key_11,date_insertion,date_start,(CASE WHEN date_posted >= '2024-04-21' THEN 1 ELSE 0 END ) as nbr_week,(CASE WHEN date_posted >= '2024-03-29' THEN 1 ELSE 0 END ) as nbr_month FROM jobs WHERE  status = 1  AND (state = 'quebec' OR state = 'qc')  AND date_posted <= '2024-04-28'  AND MATCH(title,company,description,tags) AGAINST ('411911 emploi etudiant en soutien aux conseilleres et conseillers en production graphique')  ORDER BY nbr_active DESC,nbr_title_0 +nbr_title_1 +nbr_title_2 +nbr_title_4 +nbr_title_5 +nbr_title_6 +nbr_title_8 +nbr_title_10 +nbr_title_11  DESC,date_posted DESC,nbr_key_0 +nbr_key_1 +nbr_key_2 +nbr_key_4 +nbr_key_5 +nbr_key_6 +nbr_key_8 +nbr_key_10 +nbr_key_11  DESC,nbr_keyword_0 +nbr_keyword_1 +nbr_keyword_2 +nbr_keyword_4 +nbr_keyword_5 +nbr_keyword_6 +nbr_keyword_8 +nbr_keyword_10 +nbr_keyword_11  DESC,description ASC,id DESC  LIMIT 0 , 100