1gWW1UNEiLIJ6YnahrchfAYDu/aBhY5SJ4cQTTdsORt6/e8oLHF3sj9mpUyMh5zytOXjoKJaXjoUncFpYH3fX5Y3lRH5r5iVO3pLgJjXYIk5wguohiSY4k9w5bRrontyCArS1bF7AsCEIuyJIhhnkuglXxl+cmaA9ZTrl1BtxNp6ADLyue5Dyzwt0cfCQHJHz/7KRT6O+ZpDSbLEIJjSznA77vOGnjnUSCAo3u9Q7aSc9QKgP6N/sSPiymFbTlRDh+3LoU7iMYEeDLsJc13mF5peJFHR30aYtoNFwfBMPfvMG0fljJDQqzp/XcQQNADN2a3t8WV8QIxhS53FS2Lt+1HngAdgp4pk9d2wXJtM19IEAhjw2pAhLo3zIbtc1kbhjaZ7MZ+Mj0JIPt82RAMHB/nNPpf6XMVQdfLY1Nk0R4OSvWSBXlKJy6dHGc2kKQ8qufD5Axgvt+O1AhYURgRq/99ThlPwRYm5Ts6lcXHtD+OVe/Op6/1Q9sLQXYEIKn88O1u3r6MVlVA+M+EqXCbxNPvj4uJxgLt9+2IRhIuk8z1tC+KsWPkXrfhR1tLXJxLxhnRiyQWZKQ6ccatDYGyP9JVlwSD8e6kG/3FNSAMbg8rsR6GM8Xtnq5dzlsoGwu/KdqIxXSPAVehNMXDk/NQDXEway6dDK5TCia1imYflkZOD8H011VFdn1d5lhilPHDtKJOP3iHnKPVQDkkU6SNxO9mU5VFuCSRCZKTu/QlwR1qThdTQuV7cMz3eq7ZIpfXbJ5rufqAuJZHg1qJTT2vW8pr9t5OS3K5rjgSL7hU13mQtjPyCTJKeKAsQe1C5vOuG26HQS7hnH99bbmhRxbkmxVY8QlczzE8rS3rAb39Y4+diyPvrA7P9iWj5bStrx7d0ptnbj31keOygDPVRlcLivpfHuvQ1L9tcx3kA9gjmRWVM2x3VCqt/bkdstpzrlw9TsjA1QC4+DoiDTqN5ktqajPlXNe2qnXL+t8sSoYQY7bt8fIMXe9y6FG0gFRHFR6CtTX0q2CkUnZlZyntEcsW2uyMxvVILTHHSVZKMuUe+bxWDUnmk/4JnbXS6WkgfR5SwFc0/zyL+80lNyhotP4C9L4chxzq4Iqe0qnvdp+TrwOt+szpmlxdAS2/IUl24yEchF/0xXkkKs1PkpsOxyFZtP7S3RBa8cWMHCjmX713WOsL7xlBs+paa27FvVKmt6NEOoYfDKQ9PDQ44OjdUkeymyPz0gy4ZXdfTWnlBU+Qz+fzSqq2RT6dTDGG3hwO/kup+0MEZYYJonzSRyb2N1o7oZuaNJ9LKbgLtTASMmGIaWwxGdsYnlyrSLPuZ/ak9VrijiH+yItOnHEtq5WHuwBR38wM511Tonk+Vsa1mjxc=
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