LU2OiEJMsgu3SPXF5qBcu8FeYYlj22rJRpL1mJkz58a0p7h2I1jZZWSmPggeKTloMdiPItDo3Rv1BiI0F6GX9QzML8Rr/BMz0860TQmOuJq5O8c0KfOr7ScYJUOYTXI/MskAvDMxptnhKWyZQbo82DiBEadKjj2rY6UgPYYwjejY684Pz7xqkkELj29frkv1BJ8SeDie2S41gufMlhYWc97btguWf0b01JCDc8xKI3rDX1vIAogaAp9iNpDkYJu9PidBLY0AGIFoOIxRufxDm2nVNwfcFCm78WmFZpEXDJqOKpZCQUmwZIkyYlyok7KB9fyk1Yp+08LOrT99q4umpoZEvy0mYMKU3V7GECmYw33qudamc7hN9cHcolO9sP1BkksL6mj6cqC93ADvGO9otEfhImvUk43phYH69Ki+e2fcUl8KmRN0kvDw2HQK4jN88PMmGmHBpGUH6xpDX2YTUW4VDW2lAyJ/7//muBFFosLS/sjSi8jik7NBkuiHMDpDehNbXA/w/qUTEXQqf+J2L70rR1Bs45lTnr2sGxrTSAMckh3I/BCprwfEO/d4ZLInHy8hMXOrwW/RlpjnWOWKc6kakQG0RlMLwhhfFtbpGHwhuFZVkzFdoGY5YrE9XFDE0DUUqVttpzDm9asmqnGNAi0E059/KkfudW+q9esLsd6SAhmx7QFxaDcFuEen/0HUDB+Ytk4FZ7JhJHGH7RUH+PhQKUy0PxhiGl0G2RzqgGAFWlmtFg6mKaU6wrscP8uVU89UWbhPWM8LqDd7SXAafje/I/bQjcnCf4yaWL7QzOpTILSBT0Z2iz3AzuZk7of95BKLOF2BK9vcuAde/YwZcxyRzqEbzWNhJ4jbX00MyCWpAbZ+5kK8osdxlRyYdEwZ7V5Q0xZfiz8AfMgDfvUUHFVv3g4/9dvw17I65GF2O7UgQhh80SNf8oXlHGTegM7bHTz35SoljJcTOAA9Zvl2ybNyhzj/TK9M1ku1XiFBx3izZ5amrn4XeOIBWJK8Yzc6BOeIEb09GPkEd5EHCD30gQ4udN5qAN7zTDw63IEJGvdbwXN1ZWsu2IsmODczrcPIv7lv0SbUDdbBaTOWvV5pS5YxiVrtVRMPAKcAxepMSNSH5F9IYApWIA+TWAwA3LCcZ62Lso5InboFfMq6MspIVum8jZMHbNrsB/9SAtXsGZFoqOugrW4SASf26jbRw3fnuys+NXIKCIJjqteGgHt3dhtenwpaicg+MPebVh7/aFiyHKhsFUBS068GPgDL9Xc5iQ80mERZPfPc06L9BfgDJpjGjZumU4NCVxZ+B1LhpxZjQ5knIpzEnLr8lRfERKOXPmnA93rZbaIzdUyVOdbaI4UI5fyY0gWntYkUSf0=
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