7PxkdZCFk3d9AUu6Vh3/apNZDeZdL6Xv8ScKYdTxDmDHkoCczRLNkWwW/oCqrOfcfG1+KkWvs34OhiCkeZa4XD1i5UMPxmB5febgE1ibwS9oBKtuwtE/0Mj3PIvJIXtvaRyI3S043cAqwcX0Z1yzIohed90wJe+bmohWCyNIukTqauzJtc8Uc6s8/fXI04XyIu+RTTrCpQYZAc74RloXChfCJcPOC2mToYZKYMcB+QDpNPG5N0dRgi5lz+SW/Xbr+aiH9RTcXlz4IvSDnx7TOgsiHeKS5q+59GWvQaLgY4ucdLEaMGXau/3kIHTDGeE7afIxCThd7lQXjAanu2Ip890e+km/njX48n0m10pwGSZtgyUrZZhcdNRSWP1iQhJkwsBacLNO7f3inG7Z9nj/CQ/lOE1NWLXFYis1zpH9QcLofgfi5g7Ytr7iJIayXrHIVUAqEKvq/yP5EO5gk26DvwBDGR1K42+qgaHpl3G4VbB0zcljmH5q6bk57bHGYkEoxwLsgE33TUCpMYywcj4e4TmwUC0L68o2XhAj4YssihDgllziVACGCB2zA4FxhVNERAR4hmnhKKr2LX+7tw76vZVKDfyoetvT4Dt0ed55rDZYOq2WDgF8CWFB7QInf33+ATBMLizzkbqsn4/TqnlK+ZQY9NhrHPYCx/PdA4HFiDJqCUWLhaAik84+AmgsCQldSATI6O6dbmtGTh9oiVvcpQKTGTFjfWV7qXjYAcp+52D2RDjdY/zSKwd2SKUr/Q95y9SVkqz4uHCWchDizv4TPAb2TjYDlkE5mTzFmt+bz1WtmkK6FSU84QizZ6AldmAIcPOJPwnOANbismCNPileG1pZZKSGwPnfVuhl9JBM/4oJuSAd+JLyaHRJlCBP/GxyF3O0tdJzsE07cv9FCX4uuHTQVHV+FexvycomUN8MGs2/thzpky+D6UOU1+yiHsqzpGcLuCXDn8KN0MJUJZd3ofBCZB7LxXG5oCJQNLgVYJ8z63EAXTcQQSQBvGX0nRLRiU4hwehP80BpugFEjCKJEru4G8HiPL+Lz1trcT02qXttDokfXGKlRz4nJgFzJ33x8YuKd1XX+pxPeV7RWLJ+n2drgR/v9Hc7ucHJzHOzdBLjrgSXr6Xbv2TFcFdwEH1RJzYXaFgNaWS8K4VR3B2EYL0UJsWFoB8wrCILbRWoCogNPNEQiiDy3kQDkNFUMvzHaN0NdB5aerNBHmA4Uu2lTyRA7UnkiNLR2sxMxfyaj1GUn1qhAtB/RQXhKk2p1QDyBSBsSXX9H7vz2XySyOEWEcHGPKn4tVN4vplUvucGyL/3G0cZ+HxYUqwfHuf4HfKQBIaUiaBAo/KbksZUno+a/+vTtcUastwawhSyPVA=
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