lljOflygcGPq5Lp95QFCgFL40DBoWw6WXQRJO9UjuPhOMYJGHmR4NQ0fRdvbYJpnc/hhRrA/Wvy84dK7E5Hxzcfnsqd/EmjppJKV64tcPcONtxRQbN62B/zbnHxo8aCNZTb7zdHv8ar+AERugUBy+VGpUGJpCG+bzoLYR1mW4bZO8K4P4qGJaZBF3Qy0dqkidNSTo2ueCXYq1/1OrLEKHz1xocCAhdvaLJY9Ju9pLJ/mDdMF6V/9NHpfzlBU7fPAsYMa9IswB4nsV2Y3noj5CtokMoGfTz1/m3061K3uL2GhMhg4EtY+UXy/64ZuFG0EFySKVsiOyZkLPdxIVT5LxPwGb9w5MCuqduVtCc5q8YQhk1jrmJ3H/9OO3Qq0biHlby8cIDRwmUH9cQcXbftlp/P/GJcXEofbMKCw4IdFeocTg1loHXIG8bCv1CFnhW2dJr3HMqRrpqveiEEI9aOF+6tfU+Ph+9hvqAMFCXvjH97wiC35u/9WBccCAUS5ylcqCj5dLC4wLA3h5nQaJpVKtuwJwI2yjmxxMHtmYLErql864cWP/2i9YtivbPscfH7oWrqnA5dFJkCwzuwYkHnCSmVRp/2Kd5T27TtfFmJrfJyVMP0KPajn3k/0uMfa0CxC4HXXpRsNVVJ80rK7zpMvReo0KC0bHRjWQiABMrngr/HFSvN9tSx5YDdHjCzDwQGckeppAafoYo93/Tr0SitaE1NAuTBSHp5c4jc+RmYufhhsKCRO7mxu0OAq+pwQ45He1Xd6uS7JGMefD26nOgRjjQADaFWaI4j9NMjRjF7dYfr1OaqHCeNza+bj4FvQzrXr+KtW+hg6wS+p2+v7BVL5Ua6VjbItCTiOQ53wIJpjGH/L9Dd0WWY8ClL+g06UK0ZgBYxHmATuu7R3NPikq+sspT0MaDcjerpYH1J+kEXTsmWROWKvRRQkrL0IuFGBh1PKlCrdzGBSJfX2snLHbbJveoamL4MqKswx/WoFeFLAh9lfNC6QnySXv5R9N02GiBlEOm8HdeXEyttJGmnEXzV3eFExdpwzKzGNcMyCYbT0s10IdiOYzzLKZKFF4rH4aMjQC2A/72z6uEjH8dimXMQadK6tMV7uIuuHCqtjG1zfJtGPdlMKBEK/Xaos8kmUCKG/a6mLpZzZhDZh+RxTz80DlkhmizjU8jkADsN49jMf11MW/mONMKmssLUgXfg2dohSo43IGwJ4Xb4sqm2wf+HiazKH+QcJD3cGGUsuUgfLAqzpZHqrs8TsMnvKQsTa6yB28BV1h/r3HAuQwAezko0ANswA29l4UKWrPImHKQHJZVVw6tj7NsnNgVsoXiWso3S0wUXkS8cCy9zZOPcf/MsE3HAy5lAm7f7rlXP19JE=
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