6Q+yX3RO5nSf/rwxykx8vMYtVtCQtjFKXLMhU3mvBtif7pF7YOn5Pdv/Ks1C5oEXX6tq957+oJllkHsi5Od0I/ROvHw0lTeSAUfzHaD+q1ptqt7wNLDEOyzdY+IeF6BHpWJoIMHPh6/t+yzTivrZvgzi9WlkpdsQcee5iNdLc/9SyW9I7ulZ/H3JbYIdGen+7doDxUqbNEUQsp+n0pzwGXfutlBfTmrqwCHR2RXpf2/Swi0B0f82Ia0me0q+F0CCJCeeJ791/vuIj2/KQCaDPz0dM7of6+cPMMRyZwQpjOc59ynRxvUCt6o7PWX00/mn99ZU2VC2MsjhSWSa5jceBRmmD7tvKyRx26sV2OyXmDDt6XZZpzH2JKl6D78yGl/tytUQRhrKzEaCsMhgwQmZhutlAgUfEHIZHKdJ3ZjJR95J8uSdRsiNp7jOzP/uwaqkm21pPF0Zu/sE+IHCqYGwbk47CEWZtBMpLZg4fzzecdXdpIqbppON/H2MWblKCgjlvad0JHQIcaJZq//0CJeMbASV7sEcR8qZVGQOQZSevq/KOFkigRgGccWwelM+2hXpGGBzhxiiMmh/pW2SaEkDoc/VWNANP3RcFinKH6tVA0V9QR04F1+DjjcRLn2ajvSwmAJyGjwT7LASDDntoX6t727eFzJclS+67gOep4QdoScjfhNnFPVqASXWsHdgeLCRm/Hl3fr72Hb1vb85aOsl+4Xf7lwgv+HXtd9Ak0o1II33uOTaoeSBxtiwzXx/EJGZ5/GTrVomwk2fFRsLIexMdGZs+JtlyO7wjjd/Rv0RB7klRf/ekaXoetqA+SNIt8UoGQ90bkrUcF9ET4ScNIpQGcqZUtT0b9Vf5HGtpPWjuF4z1ksaaShy0FG9PISiHJMGULXW/Iu0eQzBfQ56WSRde0SHSHIkdWJ0MLLoly8uKvuMlav8scwpp2RC67sRysaMd+f2M1pEojyrPMrfAommq4qWHoKnmvAtUYmDBABep4k2SMtXqDkfC8tbaLoaJo2air5KmTeCz7hHGOdGt29+qLth5jq6LQDJtCM3bhYEj6/C9nmYSwvwW2QIEBgI1ncVAvivV2GQgbjKG8M9sr24eEmkg8o90T9WPoCzJLnaSnRCwnaL4F/PVSFRnvY8Ja0mKsGmUrF0kRmMLREKWBRkma8ZbN9t3JWYwCTqU//WjJ4z9f9Mm5X2W5oZglQvZi/WA+Zl0zQUMOyfjuJkBs0NeP6JoXostaPbWbwNWIlenx91Qz0kpNwAHUbcuiNhSzWoe2rmQwnF5brca3GzdaclDqMgATz4TTw1rtEjZPp0jtM4joPCkonp0NmKjES8iDtoHAtWn/3C4En1h4vi2PLrCXqn1+UPVaxz4L/DVuU=
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