b9g3ealXzt0OOOH8FzY9bhLnM6xMe/Rwcp0LjT7jgV0fUE/Gt7xkVqim7l6xa6EjNwv4mB/iYqO9SEcGZuLZhtZClL8F+UcdgJilONWDFHnXWRs5g7mBorzcK56PALWW8LsZIImd3S34sY7S9p/Ct/vlsfiwC0yW5cQzdTugwQsXi1mpn1dlCqYq6HMCpF+e7u/wMrqFJqXBQMIdS7oD4CI/dH3HRkAoRLJ1NKbegphPfrMRXJVgWECLphIYTvtw/vyfvbPjNk4tWp04WnHsCchRzSjnGK9bEgdofiWD4jquiMturfX5Ck38LXZeqJcTuqIhgsOrsexDrv9i9Q8qThcgbQosx851SasonqN/XbwNBCWA4bXXO6Ppa/dds3v9SieHvRUCjXCaN5W6g4lUXPMRtwJ2tIeqcAubwR1DMZl2xjdd7iNGKIO6tjhd+MHGHwSt3gQBrTx3TvhD9xCFAOajer/8aA/ugcxrWkDAxLKLjcfZ/ZsU4pdxdXytF8EoL6SU3msH0UXj6FhXARQqui+/zUIpS9B1oC+mWjBeo+Xa1HpNIo6P3bTQVbs6P6iHCn93B3PWm+h1Bgz2UBCq0vYnr+CeDXhRwzaAhi1Lvm9+m5ncm8Q69IyJXd96BOsOsqAt4XEcG6YJJqfMSqRXP3sNSQ0aD4CrkUDL0nnw+s5wncsItycIKZWX8dX8BASzEFpzaxOYm8DU2KLxzN4WefnrwHrB4Xd55kVXo4dcl9RpOH7wtEzfFQqUiBAp6kWkgeV1W1QO0R3h8GQB0sMlxJJYZNDVxPCMNCSmZ0u5p18IeSBEOgIqcvQ3fIudG1QEVJsx2mp1WpW41D+jKfa6ERMEq6/96QSN86MEQpmR1fwozz4/F44Wm8u/k9UGaJNYXhNpblA2GY1n3D46foEykM+3oLuTYWsz9sdYcUMZuHtYoctccfOfbFxEyoJ3b/Axknmq/E9nWUuMPAqcafIVZswS1sTqRDMPZIE9Y1igYnqcTRSbeu6+OjGUpjh8a9k1tQZUELQE5ewXZK5/RG0M00HRORlqREGopTlAwvnIkWoTypQ027Yd+c1o0GXr1Sg+oAgT3RJkpt2E4ueXFZO5hunNv2EU9b1x25B0JvBZvfJ1G5XDyaNUWArKwSwwQMJxck8q+6oFboF352s0mak5MnZzPKnv7ZaTNvxjD13EPrE2sfHoD8pqVzGfVIpFCxdlZSFa+3cVPP2IO/kWEAiKqln1KQWe+w1QVW9jlkhLCulb79+v5xQSFIV9fu+KITq0sP7zJBCpRwuQGJ5xn2wtqZoqGijs+QSEn7pMJ8Nh75JDl9zaQ6gVCSaAJqrmPwd7C5upAO/v3M7NbKlNvIqFoOwK5uy4mXqnfxcHTWY=
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