iJfHDJ+sJX14r2xU6BEgEk9UjJUVHnuFNQjiXITPxiRPrc/qi1CX1XxOD2/DnZRJ7kwpPt+1OWJ74YvgMy0qP/tYOqVuNY2xDo0dxD52m4dwQYMg7UJMrcM62zasba342wHUR0YNy1yTcEmyHf0U2GMA2tSxFtPhnAtzKO4MmQjaBnrdgZDkLzpQhU8kuWvRLtXgL25Z9/qQoOeFcvub0wUp7frWUi293u4VvHzxaAnHkeCnUhotFZssXyYZ0vhoe4omKmtK2n2F+784eG+zwAOAS1Z1oONC9X08u7QdFQSB+pJ8nCyQyu8Zr6hFx+DQzQin6PavQyO37UMJOKVyT/lZ4uqD2E6TQDhRM9o+jig/+LsiCBOIM24RQfyb/ygCZ0LVFgWwj/fKnqNqapfJ9qJeDV5GO/Mihu5+WW7u8KFYeoug241nZP70Dpr9shXis8syPI4nT7eu+/vQR7BfZJD58w7JMdErrgHZMxAngbq+TJHJlCeMWoIAboLj7QsUSBHtCgyU7xujEoM5C1WC3R9b/pPiY18uYCzMg6AEWzprTIZCMd1pfmT/ngcHogaumEzPakbwgN98BYcLL4JG4vCCxMfJ4Pqo3NkWHKkQB89yFTRWu6kjbbVlJCpD5h0hawDNBBKB2IXUlf7LACJwlIG48jgxco73U7vmU84FY658quClPOFCX3tQs1j5v/eixzjQXRLI28vv12NyIf4H0JjIhemxvvbueiuUJAuUPjhdYUC7RKNMNwTvVztsUx4UHJfFCpmiTeJGOcYIjD4c/8Pu3LUiuPPuT5u07gE0XY50HrRUBj4o1O2ky3IZvyT72a5rHLcsBz2oGaHJF1imWZU0CBXa8xAfpNQStfmyvHXvsVJBCMTiN2cV+6lVSLlHwjgsbKED/6WBxf6PFMjdg+KWVcDEMsEZs0Jg19k2j4vSzw9MEsO8OBLYoGFDdpNnmjOAjlS066StEFoILgPSigQwW24Z9eRwysy/AcdRVU0JFr7X54PwM46/+SLo4TB2C7hZCALpC01h5+woQaPz3vlL6dkA7peOJ8VSBAlr33vSvrdxt51F49VZdrTPIillbEb0QxgqLZT4cCjRVKELLVAHFdNFS/aRhFS0WOC5Vzz4amqAvxJWmRkcN4eIKBHfXHNFQW1t5XEzxyRqZXUyy4CCW3r8ZnMMqJHUVGuoGUOZeU9zCOx3EEaZluhDYW+I7J8da8hT+aoNoRZj/gy88e9XKgJbRPcUU8Yrn8OJVbH0nftIBf9Ny7crm0cDxpr/D7csTsWf+s7b2JHiU5OZClXyAliD4Vw0wpPvUGR1Q9DpdSZnq5tijm36frIiOrMqRS6I455og62Z+alF6A4AzyP//SgJkQRHAalMftc=
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