ewe6u+Krv1WrxhulhwrR+R5eLBXuHmniMO3RxMQO3BTZlBe3n84plRm/5Ccw1asDKtNITnk2dtilhNUVyMNHCugVXx2m2ont1Xm0VUcPkFRzPIH5H9FwvLHixZBoME2saWN7cmfLaxvSeSVwaPA+96kZnRmYLUSNQL3eMofZgK4eAc9lWXSRMLiCSJ3/WcnDw168kenyRk4Ty4qpEPB6FfyNluTOmYHEYHcflh72zJt3wOLaDo/Mk5l5PnTzBQreHoKI5+P3XS91/C7KO6xwKshfKSOj4mzhgxqqSkSi80F8xRaZdZZsjyhSX6qfjz8TpL+xonajeCUTL1tpdQ2zBeRAZzEVLutUZURYDPf2lzkL+9fRFx+Gyk8TiotvDgcr8Orf0RU8khJFu8Z3sggQ3tQ65xD8ETuQvxpuchpbQ9c+3v0yxdarezz+BPNBKdWqG1Eq+VlMCL3vVYF6He1k00+oCHj9m0Bq98NEn2hnnBUwiEK5t8D7/hMGSBwhGyaQKAd0lkvPdPxn0YxSeXTZNoUH3PrhGfyJJ5xyaGfJze0OGOuek+vvLztkrmnsHdllHTwDJJzL3gVmBjRIzQ24moGWfGqDX6BOMXAb/5DLKF1XbpbMFM7YP5m5CFmex7gUIDsxCBrv22Ri3+hI3Tlier2tVchu8l6UVDhPRFOfK3+Ij9zIw6tWg0yQakYArZpjS2aZlKr+cBbR/wxBdtVoTToGyNrIKUEJ0IJP3pKsgRfoK6j+H2OOyhexAl7xR4QHACXJvV60FASZMcb9UyXo/1VXhWbkR1Nor3RehzdN1K4a/M4OJ4ArihglQTOTfplyVSMASVNQup+pKsN0cNYWA9elS+OaIXxhqvvrkQtSjVi1dUVnoOsfGNPb7NyD/kcc9FaDxviFFn0CTsaLTLvnqHFF0EzDVQoqyFBcw7IhSj0n4aCEzCfutkcDPgPSCgm/7Efa7A1F/0oDGHR+FMLCVeE63SL/vRhhI/WZCawFvrl+LEHza1fNW2jD4GTcxAADsVXcT+EimFzGVU6CQ57zsl/wTliWgs4JKB4ZNMsIkUL/zyyKcD4Jrollq9smPR4to6f2ld6tIjF6fr4slGYji6PIPYlKWt5l+qfrsOOFpnzyEuv9Uo8jcIw8l8YyEVuEwfEjxyu8+mOtqOBKujePZ5G8ARnq7rc+G2uRdxZxm+Dr3lWGFcg+GNuY1ZwB3Ujuk/WD+pOxBEQO0atlMtpIgSpjIhrqEBP0g9g2LjHk6f37h9UBFlDXp1jYq05iE8KPSbtlT5RAlScJI//IQVJL+VMjIS8UovpGf4tJeHPwxugNIt7fJ/TEtuufjINDlKrGvHJvA8Ko+GiBWQOCpC6Jkd62tlb4QSbDW/J3cA0=
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