g47/b4T1H8sA3wQvPMU/akoW4Liz1VRlhaFnuxe/fDBjm7joP6AbHWiBpzRlpk9sWwb19iJXdxI0shcjFU+DSOIHsjilQRRnWUGXCi2IPzAKQbaqrnKvjqj1tE2LWai01OAQjHoT9061/cOtBX/qRHRlWZwCvQWzpfZC/Wej2+Lrk4xCYVrt8XVjdtQa4uBh3IskX5YvFj4GCjHwYEExjkogL541plQhhBoSI8LQujtK0WHSnQby5ovABf9Ch/LT5cI5ax+GYqj5ERC3BGzS6GgzzsYJ4l+H9Z3Z2vFN0mKngz6Rsa0Whf5lgnSpJ8oNeZ7dXPq9BLDE/gfnZAkkRRFN5k2lIEMbECtLQNtIXmDMlNNppt6Dk5B2ZLTHdVq29f22N5WJk8YnmX0h2xfIUvMEe1djT/7LyX4qY2RhhEKdrzqpvKE72RcRNgQeMOS2sp7y2c1mot9MsxZiaTQ/ilAVzQ24ixEb+p84uR8e+6wPPmcwhjt7iuM8ap4s+VWsK2qDSoTar3R2QYvHs/LNlSX8S2mK/Ph10vWSTDBMjgAiixYXg3FTBrtSD27wOdBaetIC2JGT60QOxHRen0b2bkj3j6y+0cn8BZfqpwIqVlLQx24Klvg8cjQwa63xXVEpUeqD8y+apmBekXctM47I5GnZ+MdFl/IxRFhA/PFlpEH5Ot2TQs8j06P/uuk55fXznDuqcaHul9vJ4eYAO/hyv0i36Lqz/Z3Yghpq17TOjCGmSEG4FXxbSfqxbSfsunsK/SJp1J9qoOxju04kO1bc1FQrakOwCKL4CbZXNxDej5dCjwEkl4Wpi2tIlhsKEuy8K3Jtwg90yatHvIh3Sx5DenCn20yRJkADyPUf7h25wWollYWE7J/K+9uU40QKwsQ9cHJ4QibIVwrBo1W0UQewR/q5qG/b76zWcsMFJcE0SiDTCOUrWjNpbqIqTRhgNd9YhasZE2iHIiiuXK4BB4ke4qjun8BuNVRVhxNAUWKVjr5Gf5r3x1Nkilxrj6YW5P+g7uWvW9iGep0qH58b4Fq/5OilHnmt+HPkMoD5TjLI0bXjONzhvBMeI6X2X9ovxetjqCVYsFD9BRR4TnK2bPSAsbkYaf8gNjKQqbvcMYrGKtIBkO4uKfX8f2lwp7XLi++C1DzAKqbD1mfmvDSw3+BkE0HAyvKYWcrGSBmSQ+5VAypqMCshpjj8pk7vu3PpOpuUDYrgLfsSnBSJFs82lrvvJX1VVm6f4VG/46rHS25bANbeQ9A3+eXRHU8mB5p7y5eNFhe6a7HRvCPtn76xBzRpLLaskfMoRreXTnRaiuY8ozlc5HiF8wsfQGyysRA7sZKBtjXIIY7OPld3Td8zxgtLG9F3gd3fEs5V7Jb5BS8=
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