kLW7G2xqJBkORmpThnEoYHixK4oKafOCbHGO4gMeJ4q2q0cwjTJRFwP+zGgD7rlTmP3bzOjU/GD0fYPL9R6NoTL2OEK0b/N2u52pTvj3jHkq48Seb/s07fsjW5QyhCJzkx1U1XsLS1DNWqWHGNhk5OkbBqCEUSEDvQNpwHwmCVYRAtwNUIFaZWt5pNskZsLoBS+AASQE9Zd6siG7VEVYLWgLbyNvfICjT5DIrX4Xeardwc1L9NRtprq4b/BPttfrmihFDEEZtHWPxKT1h9NsNOGOZIFXpE3AiaSHnx2NncW8vTnutgENW0qhtS3evhcV0WKelvWSXmrmoYd52df4cHD+FhZ49SWmT5U/wNujuqFwzfENrkwgf9O8RdCkLbGFqSAcr+vXPGEMI8/ia+h26Z4bgmGM36kO1+2rR/Va9m5NBaQ1s5lLZoJHaIc6Kv+O+b6/miHCOdBtzEzSAbj7d9SibI4nD5BK/R8G7VkJGMkKJhRc+22IwgGe2ADOmFJNnoC17/6Km26QIIuxMx/2OUlobw6vWxZYJ7B5tCFrxSuW/Xp3wzgBOBJRfdlWWu23hzRqdekdEhxbW0bhJGMu9fK7I+q/Z/+uqBJUiOZJj5y8FqaL7LHM/gbRFHP4sibqhHKF9dikVqKnLuHyCISLDSmW/MLIrDLZGai67bZSNqMWn1JhtPx2qox9vFn28iHnSz713iEZDn/o1UnZCasUt1dgJSGLu3yTll4JUZyMjG/6BS1sg2Ft4kFa2UT+Qwo8fvJ5c3Q1mZZjzlYU7l0tAU+WIgzybZJUIz8xdDPy2oPJ1FmTp9V2cSMLDElefHVXfAt+1DuRpJKROcqB869CC9nmxartfCgjZsXAsC3wR49M1VIYijz++PdmbDAm7RZt8P5MTHoArO2X96O79a1vOR0Si//GqbcVHwT1EW90MwWSO02ZvpNGpGUd5rLRKfNBxgSp7k604TE7FmCqEdWYFVv5WFYgCOhk9UCyMcZLIjEPQy8Rx+IvdXKI1geMZX8T4/3h1EilSt4LkzPI/xrn210qhzegrGcZTk7Xh6Y9ycK4Ygv+YvvCBtlqpb2Eyjjun/uUr1+ucgZT1WnYd0o/4Hox88d974iM+wr2MZLb7d/jMXBbubSsj432VbG/mloNTF7NM6oosGBFuxHBfwt3EtNnlFqNPJN3+6+ZA8ZiYGwntpQgReb8ddRMUsNdpOdHSy7nBm6349zVoOipxbRMjrvI5m19dkJIY6PgmClUhrGzMIeNSR9To4sxlh5qQt7/9A2l5H9bjr9aiwqJ3wz9uylDcoaXkzK8PlgDsXXYXIQV7KinKfG+qxeZJP2N318awhmLpQGctKCGNZp4hbHH28NmWw7VvKVwL1MRV68=
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