WoWq9xHkvNGBQBhZMOEpx0XgT+w4Hdf++BlSm5kq+ItqLmDYkjiOboWrn6EsbzBCCv1zrxGAFV+jIbkxFAvfNL9GoNiXm6u1oTTZ8TvNmnlJJs3sDhL1ubP2YZVML7HHAzT9JLA75LI1cfvjqGqx7yxrs0j+94+x4GCUhm0YI5ju1u7tBTqW/lS/afwCfW7BrHh6bp+dNlIQnspXLwm+kviclzhc7L3UY5J+7EXQcNh1jnUA5GIQ/z3a/xkyOofHeev47dIZ1vZjBCxLpY7IA4qVbPM+kk+2S/ooOdswjJrLohIEGVLXemanjGxuoIRZhIcU3ZJKhWNfd9j2z8Egd3zC3m0fArdiEs1ksZTWjdHVm6xvNlJNfV/eLhXUqIJWbKf2gHc5ca/qgZcJZGby2akvhkYvzxdjjhpBiGP9GTl1efQRUTp3XSRjPccvL0ahRDUhgiQWntvOI8MQVSAujKZs8b3DE65NF+Kz3YIyuB5VOPLas78ekp5D/QAovd9rKsPTWJH8pz1GAmrDud/gQKhA8cB2N1dvf0S9sbdXI+WIvTqEFtS+YlKuCh8bBa531Ut/zI/a14gMm+3N/3wRv9KOVJQXcUREXNSi7Or0BDqsP4v1o/PXKil9G0igr5g3ctN01zQiA0Ycnx5XHet60IrM0fA0Cj3/7qcCZALy1sp8thnHQs9bbr4mqfxSYSNF0VlZEiCFWg2iCWFDcdqAuqjID355KIsfGTTlmMTPruQvRMaubUgjyfwyArjNSClxV5Xrn8WbA+/SLsTWlu4KGN4Yv8BjagU6ZzqoLVOvSgpmroGAdRx3iqm1TjID6QcAQGsZV5tuTZpyWL7SYHdZtJD2wUSyISSvUc5m/ZfG6xgeQ4/QzOYu43Kh55WNxU6nr2AI+80UmaX5aqjVdWnL6wRC5CoRU5HAbzAteSFHm0x6F3ExRu2TO42yKxxpbBlBJfiYfo/cNdfvCZiZTK06wUq+rD8Nld5NT1iZDpQcmECKT64c2M/LGdl57jsgD/ssTiI+JwXXfxScUi2Ql3Um9C4wthOYIx6z6lBtwN84U8Bn5QC/DoKNuN+NapcTVxsz0/4Ps12ShA1PgJkcqOt4gSSy/QBMXn5LgIUXb+ZuoH4B+OISxEubHcGv3sXgDaFbdQ4yNwNg6eboAxieAk5eV/RGjxg3zgkU7AgXhvBO81ydWoQ/yxxhPHkkcXquah7472zq6mdVISoY4cBO6egL9lmkS/qKtHy8L3+jV68coSS7AOtvA7iNtkxv4HR7xWxr08eOy99zd9sMVQcs7bH2YFta7vTEtbJPI1EA3xMtzYr7uXKXr/RSeQtmxyFaD+qomC8S9HyIgfqjt0mtcqmDpe2pWvdRqPN1sW0cWfM=
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