xLXLeNJdP90URJrDGCrJX9RmoiHjXWOHIwRrgUsX0rpyea/E14jgId4vyjIyuxfkDl3pmmpoDMjlTeXTFeYmvdYA8aVHhH/SaNjYF2THO4vgiVlhrjid01DHCCCXNBKJT+1fVsfD442O9F/lmsm1jqUGGMhiGm73BoBpDa2iwou6FGMlAV4vm1dpGJL5XJrw9FkV8syuf8Fy4nPo6W2Cj+2orj84LyXVraEATNYpYuaTOs4fCC4XLMchTJJpHScpbc1Tb0eP5dcXBWD9YuiTZTblT5arZv6MGRf2V3nSRtfet1bxKUdEAS7QderaV7FEsacOiXJfQHvOyfRNTpq+aLpMBi98qDNIWdFsfh0UggXxZzY7KYB9sp5hRaH1RVBD5eJiSNU+pCq7DGCdouEV4LqwaXPsVn2f/sQui9SiEYXqbEpAk337xLaPJneLkb1UMjavk+CKjUqmHJln28JqBAnJgeWwDfvPz6CnMCHjqWC+8Q0V8OOEklD90EtrHlzx9MG+q6fh+Ny25zQk8RLhGPOAic3gtKpcT28RczC5LeASs5Z6dLOspSL972lkNpgx/qzZ7L3XjpdzNlGQk45cMIfyM+lz919rNGwy25criINYcybqE5OaVvHPMpVqKXk6//wp1yAx7oFh/PT/hngAtp4eRVXId4UG+gWa2jbKT8rdlxN3YpAl4qb/Rr32VkcgX79ouSrJ7mjfoEHKhgqSpz16diQx/nkPj5g0KsX1HpuZEstybHbkPQzcUmxfQ76uxpZCEPBv5JbNnWGwH4txClSToReENEgn/RZWAzPsCWcNwaXcxjXwb5ysYi3EzY4jlfjzBVJHHmX9pQ4dGDwlJOqWqWf6vRQxvTJ6dtdXvNa+t7L/aTM9ihJyeQ3BHvICaLxj0xz25gpLUG2kRJ48MpUuMRd4gcb8zRnXSN0wKnS3Q9IiZ6XrUwKKpZErqe6xzZdEkwQi10PllK7FxL4N2zjT+jNX/nuWhuMeTuyQrSXZgeDmHBt/mSXWoiT0DaRzMaEyF0gXpihZlPSPOOIgQ9yCzcqPD0XeszF7OL5CmVLULWQ4d1c797ZNEU2fxRnqbfXV/KEIZDSsQOIiYxRdAjfEngzhh7Ddcw8A+MmwRuPpKbDmEGAEv+gol0cgcerW6A7X+hPy2xGqMD9ZQd9H/gx3wrmpcgx2wDqXZV4/PPlqoKLvE8RYYaZnwiCiyxbmGJK1Rgq+gljGv7jSfN4tjeFq17mv+iFFd5UTkRPDl067Gz2pTT901xxPPYkNSZmfuoGHF1WwJTZazSCEsTh8PkAG0PelD4ECG1e0wB0Qj5qdfFDHG4CRTpZooAAxRuil9gyeAzd9qA9iNRLb2C0VWobqWPcyIMXBXLt7+PY=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100