jhwg2Pv5KIL8OLaxkL6wVBrrV5FAMAF6QT4OhsvbBAj/pcPL/RCUfNyxPUhBkFJu0Z6s6DriJ5de4Qu2ucfM1Kg9rgHwk7ARwno7q5qRyWZwZVpFiBhV7kp0//p79UgDwMhea4Lxnp6YVAS0SiIMVpMi8OM6YW6tpvgrDXYVg5mIlxvppakbH5V8E8OrsDS7BlYqo7XywHsPq2BxCn6RCoIfjpkL67r/KiTIqlG4l4svG4HFArO2VFxqP2ndGQloMc4DdOyR9IwUMVxVDVAK3YJKtABwL/GgJcz2UDcWXe2rghclYDkNrl7LgXbAgoINDphO9kpEQVY+FqUiVIafR5zOmmUdvXcHE2sxc6oNJMRSiAJzQY+2dT0wxb+sIwiKjZLncwZOQjKYa+Wc4pTeR23I/bNg6MRQXJeeaE/I3gIE2f+5jxapn7D/bQ9fyDSNAAIgHDj40XnnWOInsqjcRlaTPLzWzMynxuD+OWTIzHW2G7X+aW7KJjglIOvHk7AhpK/g0RQJXGSC11OdHQydJ8CgDfL7teGYF6k17rH/0VsNsMTfTLo6kaFzzscX+rY5ddJI3lgWoVEhveecpbXfW0TiLvkoXU7MnaCQVL4PoRalPy0c8AoLPgAvTjy+lSbo3f3VSmTNWpJzEVwBSlctqvqiH7zpMSfLhn4NkxKzG/blaFB6bzTJi0+tkveBlmEhW11p30y0lWniOxhpUqlmvoBsucnUcuhMLhi9apb1rY1oyP1G8VWANsXVgkxIC3btjAnDUvtpDBsmmaEhvV+qvjqROQhylX4dgNx3dQaQMLUs6Ptsmx8tDOy3W7DnQsFr3j/sW3YM/B2PpmQGjVai9G1/eOMoJrwkCGXSvcOpdnmUcp9oX8qrVfYYdLhFDJabdLGkN5xp9Yo7C7sqZoVzMSgMb2vqtekQgslzkBSerdXVcQ6zIpnNWG8HuDuCMPYCgVdFOnWYE11pquk2uCZqGw+vtI+fHfkxoAgY6dSxo3kPD213d5CU1xXMO4H7TTYHMuyzkRvOPr6IznPxQgB65QZ8cN2RmSBItX/a734TmdEazbrxI1DDscrIna5HWP7PHBL/L8TNfASly3Msoyc5HvqsW8aRqRYywHMNjalP+/hSfKEiPdR/QTpWZoiKfN9FJg0/DyYquyAbEfbqCgZV0OBHfYWQpQged5k9WvaSdPY6luqmBN93OKKt9kiJ8A4YMt/GDggAA32l8poAE+93V2M36HMFv6zeTrxM9dRAymUHv+V9ICAE5VqTZ7FX0COf+9ieojYhBLX1pfaPGbA3oplNXhfqGgeldj3+DI06E9xWm6zcAA7OQJqxx0mENdeYKvckqLzdAJ0ImYDfik+Ubyfu0j0SENeTTpTy6VI=
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