MySQL server has gone away<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 '%Technicien%' THEN 4 ELSE 0 END ) as nbr_title_0,(CASE WHEN description like '%Technicien%' THEN 2 ELSE 0 END ) as nbr_keyword_0,(CASE WHEN title like '%Technicien%' OR description like '%Technicien%' OR requirement like '%Technicien%' THEN 1 ELSE 0 END ) as nbr_key_0,(CASE WHEN title like '%technicienne%' THEN 2 ELSE 0 END ) as nbr_title_1,(CASE WHEN description like '%technicienne%' THEN 1 ELSE 0 END ) as nbr_keyword_1,(CASE WHEN title like '%technicienne%' OR description like '%technicienne%' OR requirement like '%technicienne%' THEN 1 ELSE 0 END ) as nbr_key_1,(CASE WHEN title like '%instrumentation%' THEN 2 ELSE 0 END ) as nbr_title_3,(CASE WHEN description like '%instrumentation%' THEN 1 ELSE 0 END ) as nbr_keyword_3,(CASE WHEN title like '%instrumentation%' OR description like '%instrumentation%' OR requirement like '%instrumentation%' THEN 1 ELSE 0 END ) as nbr_key_3,(CASE WHEN title like '%electricite%' THEN 2 ELSE 0 END ) as nbr_title_6,(CASE WHEN description like '%electricite%' THEN 1 ELSE 0 END ) as nbr_keyword_6,(CASE WHEN title like '%electricite%' OR description like '%electricite%' OR requirement like '%electricite%' THEN 1 ELSE 0 END ) as nbr_key_6,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 city like '%centre-du-quebec%'  AND company like '%Placement personnel 1996 inc.%'  AND MATCH(title,company,description,tags) AGAINST ('Technicien technicienne en instrumentation et en electricite')  ORDER BY nbr_active DESC,nbr_title_0 +nbr_title_1 +nbr_title_3 +nbr_title_6  DESC,date_posted DESC,nbr_key_0 +nbr_key_1 +nbr_key_3 +nbr_key_6  DESC,nbr_keyword_0 +nbr_keyword_1 +nbr_keyword_3 +nbr_keyword_6  DESC,description ASC,id DESC  LIMIT 0 , 100