iNsjGOm4/KryKbLUaBvH5XUPkviMc9bcDFigltPtQNEUtYRL3Km2VXbbaopFiJDmYQ67DySnJvVyu29VQCEmjuEiXxd6CohTEQQBDYpq1CCu+jkwXPQTQkNGnjvF+uZ7NzM/5mAtRnk6e0GxLbjOhTgEKgqwURE46WkOhKdvYC1ZXyRcoBuEjSzUPORcMKMkX9kb2E2Hp/GGi5SEVb2yOls1Vw8R7FrDuylDeiimUy09e3kPIXHAu9AxVCHgQ4iV/VMImbpBu9ojAcbqioPKaGKKcpknnUW/+sGzzVlTlhdnUuuxtfPpU3kTz3HCqNWjS/sywIs9HTPZWkjdZjPRn9kMMbcWsgkeonK9dMhN2pZNv6k9JKIGjobzkY4FP6xRXlh7F4L0wh+dIgipQEYsQ58Tne9hpnSTth8NALL/knANmqd7dPfI1CnZhF018QBhzTlVyiu51vXnjtRZ18ewiT2/+ifDcX4eBv/1PU0IvZjoRGEvXipO1G4pNq3YtHeOMlnIFz6yVq2KPzCNECYf5Mt0iMhmISqcnS2P2wxRKMQDNM0VULkK0PDg0It35hrDjuUNcbXpjnjST4FjCWG0TO1r5S4Ww6ktpg81uGEXYV3Ry+9bz04wuvjgpQIQjd+QBqn85SLuJpgsZQTIvFa9G5qNtb4PWapJBcNp7meSFiV3hGEbOAODwxQSBodWwj1DHe4pkqm9K8uYuY2IGDLoI70GrqvKCE/0IcZgxHYQPiWlPccJvqN+dh8g1bZtzMbI+H2P+cS4XiZ2MrnTCP0wrD9rbZqRnjdrFqWsQexeBz8Az862WTlVqHG07VD88+9+HfiqYzVGOptErro5ODa/0jPF9XaCl3mCgxVeoMHJarD5W9kJKygGYZxJ2EeMlYYuII8RYb0vx7q/OYa7fLEeAuE14z6SDPICyGDO43tNSjo7/eL/KV/qUWXzDHMh0opScIhqT2/QsgSW6/7jb2m59eii0j/bU6FPzzopA6zKlKor3M3KXdEwOBZ5FSRzhudBpvOos0dCG6YL9SZOwymjH3LLk+FM3jlr8HGZhOe3xDC8VIuoSFvhYLr/LRqEAtmL4z/WvSKAmUfNzHgEWO8BLpP7OSFxqfdCIkxZJ099ioajdGBcPv39oLPQm10iJ4Cdva7emL0mHQQEEJ+Sjqe/72AyXwJaTFpw8LN/ATxXpN64zkZf/MGQigrbcFaVuLljz5po+R1GpKaPo0S/70mpU7PhrsQ6Si5+gonyCwvJn7QLxpdvjDFZ2O+2W2SA+CLal+vvN+xfQ7HHLBUVjj41avSEZ2h196WnJSjXWV4ovzGl7S3OLg1DGHt4XouS8svtFOaqJcOsjgL3GJsSo85TfKOPvXUOoiyJikZAGW4=
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