bT1Mma7yKGr1rtjmtrzHVC6LMfdsZJYIwH58TcS1a2cyDtXRst5GUmO57fqSyDbB9nk7zrpqauh3cznIoB0kDoo/pfcEVutWqZweI7/LE2o80IbJDwzln6eGdtATaFCB3leZ93q0prvjNwAJTtQ0Maef05bayt5nMcam3dJMD2ZlqjRcESDB7f7jJ4OPE+fCsQy0eDOuDKk2wKivpcRZglEE5Pj1Frs+3tLsudADvv+PLY1Xhd5pcXqN1b6UW6k9HDuSnHDD+qkimE0ImRCPaENSp9vJDbFgdaL2mdUVTVK1eMx0b4WL2bSsfWqt9bTemVTfsHq/VkqpMjHX+pFRSWF43LN9csp0B1wO/llsaaX/g3O1dKiLRwQk/4amXHRqfsQgKWIf44898ob7UqVUsCu7NWuO6iXj1qXbsio+Y9eOGGFsRAcsSDNjvaqDGYeE7e0ITogCZ9FvNrsosHPoGoKBWlRrJrYjlYp8JNdXd1N5guqDIPfwobEsKj+SvNsjOC+d+xtPne3IkSC5fAfuKnK5JraxQKOhddwHh5eEQ776wNH88B20MqX8FZCPvqTMjakq3XzPSZ/Zd9ySz+pXEWH3J2hvOewZPMNwTxuJPUZKdICopiJBQNMzfuI3laszHuILsaXSVhyQy94dUQAX0nUH2REdTeeoFJZik2xjcDOu0QXqxm51NwNFf2CB2H0uD6q8H6i3FIxMX0jpJRk8K382IQVKlZPdMyU7tZ4HT+k3kbr/dv1KUpDGRKdi2uyM9h7RK0Bmhrjd9FrohfBwjEOeB1l5MgEACcSQTkF7AL+4aS9le5wyAaXlCRkE2ZjXo7wqgS2GNCfD7kH9l1jYByGKJim+hudPZhunNpGvIXR4Crchlz+zn3P9YgHoAGbeWCv/uifhJgBR6mQBEe7LrNsOxPL1j7k5PN0VHvB+LL7qmqXB9kYO/GMern1ILH4tqQyaECcgK1QwCGJeh0mgIKisDKsy8FSUQGT9beUDbmvx1OoBQEL/enHfwrgHExjoy/MHuebJQQv5UeNc7Itjgp5Kd0bwj9qBa1QbgWYHsNXwRSlmFHm0aVapEojPjz9jfMYJqyDGQsQq8eh6fl6/T8jOR0b0zXqKSpt46NHjNsGlbZa3hGdFKL3iLPMsioXzDQetR5SSf3DOeIdiafH8e2Gjw8FktU/5qrw98NU9t04cQibWIUmd/JksTckrXQS56DR1g0TBxyxLzFxhXfly6e33i2nFhnmCkBNNT63sJo1jDdwnpSM1eDEssuEOJf5zS0oOSuvOTsppSmEgkA+OJ9IbdusZ+EqfT1zzjeoG5Ci34suqmInbPykpMnAk3dF52ashbdn4y9yLa4gcHa6rh261jMTn4mH7MGI/74c=
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