FDytsb3U5jnnC8JrVTZ7QS7onlOo5lGbTt66C3EQnELMFPxCvrv1egNnziS10tiMAPZ2TJVQIi9DDZ0TPXqAn8cwgQuOD2xdqxasgAqIisFYvsXev4FYAdnDqvFxQiZDljLUL4Kcx0QM+UmioL8jau1rpeNRcN88MRIYo7xpSHd8U2WHs5YTASvh8oyQyCBUDhBQ0Do57Ap3IUvDVJuGTZVILG4dU3CpMrpjBQJS5udJxn7Dv6VHhO2yO4MKBeZttQA57Qm2yLsO5MOnGFF+TgDzCI7rFmCI7FW5dDwm7Hikr3qc/453XBxQyg8KzmnOdwLPz2ll59ZTEcN398eUn/3VSXcUQkxykk/MXRNI4lA2i1mNd3y+Cb51S5NzJYEjq6DZfllzv4m7ilyF3UWj5tCrOlaD8/PFpxiiIHM5gDbOWhzVJd/R6epF1xLJL4nuD5TLSLPHzk4wBkP+WCKXZf1aC6K3sFDbfNqn0cUoKQ24/k2mBjl1VGWuuLZuLV90i97ZktFCj6572RoOlFDVCH9TJM4xPYDrobw6yO6T+OtJDiJ+5MQsrVMQJWq7d6jWBDqyAqmT7BBuHOUWxIn7haI+gXHEpnUxLWut5VF5sTRdqjvL0Dmi2dgJrNSz/Gr2+Fxxg/aGAnc+krFGQybcSy/gZ2gRfT42PE898rrhkLVU/Aw7mYoCzxrT0Dt0rWKOtlKm7pSU55pKw+L38CeuX4IEhPPzEC9ypu/MnoQ9V5EtAVkxl5KX3wdSR4Ghq2MxNEgQpQJyllYRZeoVuZfPIDYZ7blQEbGon2OgkL9WsnDZTun6X3Xh5ktD7Pf3l3d7sIcE3K61vuFb8r/gZwTdlnHJyeDyK4aSjwbE44CK2npETNjopbPFUh+rwT+ryF0uQg4fkPoP5aSPXiJDe8IWtOXt4AQjhbFmN+kUHX0NFGW5R9VdJr3Nh4k1HbCMksl8f7QPkXjRddU+RaRCxDSLSvIpl6IuP3NkQ6FWzLL+tpIWoTvM995V6LX4tSbCVclX56IqCw+B3qis3G5gJjGqEIu6HMY73vLS8pJEYMF+MMlZBccwtEv99j7rEt+AlvRCHY3omnWfEbYyRHsb9gc5UqQp9VgW9uaXvJOMYv3tU2HA26dnn7FrPyvtTBoRn3PqPZRG7SU8elaOgBlbNTRfmeqbifOUXWLqjUf5EhCICWHUdrJsbWDz4Z95cbLwji4lcXgfS8eMnEMXY/Ov2rrUPDjxucVFyp8wFfn0LbcQQMwlk1XnGrkPYMQeWHxhuY2VTJR+5/XwKJs8/qZQeho5hOi0TF5jx0Ca2ZTvsW8QxG/5dtWLiYfkyJpNJj8qrG8q+xC+euE2nqHqyvIH50SyMCXkzJp6pd62BLt48vE=
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