OQUFEXFW/jvSLXR0fvZ19JR5pbKel7C71BRDit6LbUCvR0XU8M+Gq8Ax5JdiFytUxouOyrtK++8/7kcTJ5fYZNEQPKf5ix2n7F/L9iUpcHqDKlwu1sxeZNW1W69/UPS6wBJu7e9CWKoW/YZtIT9nEElZkT+FHa1uJAoSf2kY6Sz0vc5l3y1md48if4ltqQLslwkjKEhcF8f9urivWJQGQ4aNbasRsxxV5xlSSbD90FK6p9hQJqlpPpqJ+Nptg5RhAIsSGDgcBToAzfDhpIaDZzVtBhNj3Svm7m+P/WEh23Lt3omlp5p92s6wRiLZenovxI59XPgcThnZ609wUEWAFtWqSw6iYskbSzRipcybLvDYFAmrACamgdkBtr1iSUJ+eF5zhhuDWl43/9lW9brK4IwcbyG4oZ5RSCX4IrjiR2oRwau7aDx4f3FmZuL+Cz16mZAyAyhr4EiMcjB81M5SWJYvr+5DSyMWgMC/EJ7lGznNNphNztworoRmEywI59Eas6/K32dXKGdTAxSD57MnsxhkROCgdePvcrVbu+OUbq51rZcNbIqCfxSWdCHOMLVdxJ2kM7KrV4g/Qrnh+r3rBBU04jT9a5CvGnpJAYD+5qB+cgU8rEmbJ//uTRhc0mTE/NBdVv58LokxaKymY3Xigb9Uht8Qnqrjem4hg7uR3Lg5obvlrlfOfudIU/yt4OjtfRgOniE6sPXpYiEL4+g0+BQMJRbsDgqRFARYoin97haTpVysLZoFjYI/l8qGclcrWY5JFadWssIt5TWTNR7xDCH3FL0k3Fpbkwtrprh7bhkceY7jRkwFqqrDszqRaeKgy1a7Nc7hTal44CDIrB4DMiNTAqvUXQzpjnZElk4UtLi6Cek5KNxWmzrDSB5uTx5z3qRjVeGWMkU7qw/FYdgk9s+t+bS1HYxgvGtPbhm/gj0/qQcg6OTbyr2hkX/MjNYQ7xNhH0zMGMO1aQm3WTnSP6U4JuHnRkpq+TyDeEzSIojbe4dKt/6q3+DOk93qoKLlkiAusAQkyfz4Vsreax+ZbPWZVDtQImdHSt7bZaPXM8rrigXx7L/i6dnzvUjxwf63VK7NWraMqRhR8laZimgX0kwl58fcNojw+UkFOO8w+uYjZEzt8hI0z8tJqQMgJD8PAkRYjLmVcaCQOrDoY7AiuVrPNDdVz1jb02Lc5a35Q4BZH2bp36JZRhp26S21xd+GTjTVuGrzIEdvnPFLh2R/SnGya8C9qLuQgbsLI5oJJIF4MKpLO9E5p2gTeUnb4uqnGOfxeo7EsBIxneSXu/mfZeOnvI8cQ1WBrG5QfwGTCiMA3EJ68is8Rb7oTzdoTwo+R3UcfXNzYHhAnf3E+N6MYi1OulyO4B3ocGKm2Lk=
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