Sz4fDj0MW5LZCAmBqEHykfcCYJz/tqMFWWxTMJFDop4D3KOLa15V/tJSe/hj0uVPACM/no+uZLd0YeAsgpbGbdBTXwSb1c5E3k3zvTq/AJKlbdPPAeJAg//sKMQJTxE8cHADlCeS1gvwfJkxPCjOKKbhQjVeukJp0BUT8yozXbva6yoUM59uW2041gVyUlSEkp4dT3g35iou/b7YzoIKRNPzso846jrwpTcQhCZvm9Pl15rO3/Q2+2tFTi7Xc0UQwsEQP/haUoTFL5NNYOfSE1X3ErvDr+cQ742MCzNjh18akurueh8XOgo+TKlOaV01w5mrKVVjv1oDhtfRXCqf9d1+41n3kGtCNa76UBZs4Zey1BbMVKl1Z4ZP1ehcCXHjHLYR0Sj0xidZikWiGMQYvnDYmyydDTinVOTaJPzA/8LkBbHYfes54f0mcB4jZVcMmdQg+Nho4IlGG5yFlk0MHOeXVWsFbXiCjV1iJ7iQOJ70ML9CnKwkiIyEXu9LQGLdwbX24pAkdsNVjPYd2miZEuRKLVPG3kpLDUnyBUkOHH72DUx95DkQYW1za6VpBuJY/AF447DoaI3NHmefzTv0eC984RhTWZ95IyMfy+qFePuZXcJwaHXX/UIDiXhYzVMl/7ya2oBXHNEOdZuunVV/38bYp2WvKygval20AuPCW7bggk0UEIo+Ni1YgRt7qFU94KHxMf560H+dK0f0lG2quC67XqnH89n2ERZFmaE+jT/z17H2G40eCH+5sohrG2Xei2Iqy1wyIJFJgpWksPSJkLcx36KIy3RxsIGKP9a/6uYmtwQNVmk/uqHMUQnslxfDbGZ1qQFvpmIZt4CGffm8pMEL/azjGjIAF/hSz3uQoRm3X55Fw9KVpK3Kpr9N9imi3APcs+4J1QI1b1qjkJ3ElrspZCIKOs263cXYgxOHDfrIWtAXNkxeS1FjurqXaDNBIkFmNNeOcLh6z9pxFoVvQGai+LgheGtVBQZI/6Dzew8uqZExSkd9ya/cOxm1NeLvE79ICePLnQIqPq7OMFbL1rMaJJxn4FO0snnk8ZXLNUKWPmRMHC4DTPe97MQVon67Nu7ky5wvr4ajL3N0V/DOwpHwqj2EE1S9zbFrXRSJLfk4+2jVSltrqvmJunR6HWrYtpgOSV4/XqF7dnEE293BN9V8mtbFpaty/cE9l71wLZKZ5MDjfEWQChFCRu/fs4t4WQynmxp3dy0cZINO3XhGDZ8IyCHVUcBOLN0Eprh+t9cKcuJ6c2rstQPYT+FG4FaATDCLO3DOKuNKaDMAl5mGluy55m6dasr6VGb6eEBTPGZl/zO1eCi73Gu7DkL2z98L2kxWG3swi7/RVM9k60MV8RO1hLsSL2e01MHZjMM=
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