YwEYoF2bs6f5fk6keXGUBRhx0rlWa6RL5UPWv8bT3o+Z7F1rpz0xK0bIxw+Zj1nJjF6R469Zpsyr5relqLgBTPEsvCpvHTOmPsS8hhFiYt3LT7HWblPpHBUn6NB+M3P08sUK3m98AQaYrLK9QiBq8h27WJY3OcmH0qaZ3JpewTGhU9RbmzRhGA9+2RGS4Q9JVReigeR6h/s5MmsUZYm2SkvnC/Z0d/98iNA0mWQMxKbRdqmD7r/sYi0nEG3tQ2h3bALcy/Z4g1pxTfAv4BRN5CoJnrmeFNbz1QuBZTJcSz4j/7XlYA1ZacZrbeM+ZjRzer2Hpl20Y3i64wuAGmrpbMbj+v8J5wp6GHtsMF0c2ecQnpFzDLpbeWcek3Iv7zJRiRbTMT9u9wb/Y8rCt2YH6KrXPqMSRSM0mC5bXoNSCMn9aZ7olBvfxGffsBBIAtBiEFzGscEnH3H9sS7RKhed8Vl+skxKL6ZPIDfwybT9NtPylkRuM86URcOW/n4SsX3raiMnrZy2jeuxvDSpyMXYXdEr8ZoTBqqZT/c6wqNFECOP0iAEYCYvAtgezw8RfJENK08d4TWIfTlrMow23wvEqCCYBGQdAHh2niY46fh8ZuHJ1tIt5wXWtDo3uVJ5DWVHHY43ZYgHJKY2QdYgh5UDZEiPWpogCLLy4wRAcAqJHvP+lxm8T/eScyDGOsbf929c5UKuPtzq1x87LPmpxhfXYpRoM9jiTfcBfwwtwrmCFC+Yxk/vSiDoY/VUvy763hKSWCXdPKgkVJbK0mMIQuHqf4b2JhQXg117v0p/w8cw0kktAwLlHgEm/B4okdIi0fnOJlXJRmGnMp7xs6w/y12jyhHaJvdafyga+kJwojkapLWL+syml5zhulqKH0ThtEQ67UnEwC0uck9j4TeOj60L6sTVYCjFQSLVQRav0tW7WqPAFf53+qrIuPS3+0BsWdIF9pg6BgxG1nN+zwJR2VdFtY3YDvw/G6Aam4JgSAORaIc4QIkcPSyKtoTxzXAO08krvpyqmZuOWik1VNgjpIlE5ilPdCcS+oysV2Rx32hrClfNDfIOdJ9G8hc+o5E/9fepKyDP5BilAK/hheY+URrtOS+sQ9NOE1F4FqjI7t3Hf8S+/qjZmFds2iHAjYf4qRhlyNkGBWrrYhKkcOQt25mzesXvVTZ8jV0O8FAwQeO3nARbFNXT5BpqtjAzx16qq8afdQ6Tm948TvzIV9AG1ar5ajKmnYAJ4pYp8c2EC1tlvF2mOa3OPGrpplYLMyHzpY6F9r5HGA5iDYWQiZdK+EhIkOQ6sIk4OJMtRNPgT1+WyHl5xX8roeNwUuxyB3dxCqB0BsCany+/oIqvI0NCwmX9UqNdNg+CcHSeGmRzQ1I=
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