6C5n97oCCvXFdmzewcb0SzVWIHwlFRGKxYotjjrE/NR5SmBOY6kErholmK/PF6ChNrnDV/Ee8QcTgKUJQfOhPV4SWLtSm3uyKN7QxcVNGscSnwHhvElz7dNxeuhAKXEocNmUrS/TyfVLnFWM2XG81txok9tQ/Glea+jhPtswgxL+qPY4Z5P3MSxhsiS2ajzC1zW52ZAA8ncPBInm2oBRzzsyghaGe3cqkxwR35Ne1bpuWeLcsqRCN3049sbJERsYA6SIAMO44MfWDvnLgiT9uT5rUlaf5APN7jqGl8QzB5/4pJT5MD+CM5PuE0X/z3pG2EIFtJT/GbY24AQb3zGGGj+Fwf8v9V8PN0O9GREIW45bQwx4n876zX6mXhe0IdBVCTBillabfyRctmVqMcUlIPkzbthkpWyTNEZqayifIpn5ZavTE5eZDl1HFPE0A1c+J8QjwEAphuB/dHk7jc2M3CsLnYkk5my2vH2idWYaqrkah7C3bx2jP8uI5TK9eEtpFn4QZD7ehKfNqsIRAiJXscwbNwoRziz7HT7G2oSrylBh0akc/7QQzP2oXOlvWFg5hYHCHoLTXGcj/LGH9+mSVJyoHVBKFJOLiy9Wo3NOlqrFCs9FvPSBp3MBJPDPIBGeJrrUjl/eXTJFXMQG7PMzH9bWLucfXN5kQyQ4cZqfW8cgvB9EGVia1VQGQ3wvsnpOZNGmXzxWQtXhaKi4DmATwtg8vCNmcno1adqqAmzMNuKllmYgVW06ep48k/jDP+lGZLlWd2DQaf2owygRFpx07m1EVlkssVOWf5EyOSjbKQhaYEU6+Yxzad95rv/kky2ZwMKdhykEcaXUxenL+MSbU1FRJyBZceg0o8+lnNTSiW34PG7WOj33WkEHJj7xIlF0IEssX9EY/jpSwT2nK3Vg9GOOQhZERYBh3mr2XTJzu3wQh4yn9IBEmz8GGGwbCr+u6p8qB7q6Dl1/FG1DspEvnvvSFyznJHzp8KNuB2QkmUyKrq4/rFXEFURXbeQeOOCnTBxcW5fM1YIoBP0w8D60ZoncWUfBVmc9J8CuI96a1BskqgNo/kj1hrKJe1O+Xq26Mj/qK+Xc1+DM456dblUS0gmAc1e4DenycqMYTE/iuvPDPpaQ26ZPE1q/a5U7sR7b7Sz2CzFjNm7c2CsROX22TYBFLbxgHFP1YacNBAY2F+yTAHbNl+i0zyRALYBrSTSZA5Y9Ow7buT3q2g1LitVTgUfrT4megQKLaOeIWyMd31cyJpEkBYrXEVAXDGsfcvPhqgBmGHFEXe5MAXDu77qIufga3J55FK79020H9TYkcnzzVkQ0nwC9rvJlIJBBm947q38IOzpFy/5S+NkFUPnmQHG09m00fxu+uxA1UAc=
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