I44pV8rzMVmRbxdRcg4B7Er3X9+JzjXnlvUP+DPMQsM59GKNpHc2IQnMP+Koop0nWRdqItFNChPsfRUwqdxXbmGiA6BTTX6vQkvIJcTcy/yzySsFqg8Ml/xVCyE6RP3fbkqmPLc3iIpdNfdDI27N5Q66h3KAqi29Rv0udiuC1dIJw4ydJlmhGAlPwoOG+jyu9HVwfR7IGm4YJER079EzCHF+pVvM8/qbXVxQBZ2AZDH0+GxKNQWbx+uyJWTOeQS6ozKreE3X1W8viF1FqfRpkeXEwIixOw/j0B6+y6nlE32c/jxdkUOLhfGA8uL+bsiEiuGDmOOQ2Rxm3KrM9WjX+njyZtDJ+arut18Y+EWbfZCQJAfs3ixQZ37YHvSOEHes7qhbziKmzC3HGV4zvMrxR1L8zc9GUFsYjpzp6zcHJPjF0PSn5hFyyhk9UmqD9qpl4Ra83AUxXk//fUpoOmgEnAjI9r15rA/1J+/vBG6rT4QEnST9Mq1o+O5TDKr7UwInlsF3lXJvq7Nqqp4z8fpO1CXFl1sZjb7ByzduzFDVKUShKQuOrwJNGYS6Xpv8lNYfjz3xpYR8Sia5c+AjHHCFU0OW0sk8Wl+SM2h6hqo6upiYd/gtCnW+33fEKF57vVtzTRXS0da/oHGd11J3jnTNsHCmg+6nVwdKzJfRQpx5WP6O8W+UooCMtW4hl8p1o6pvVjsKoGiWsw7SnvFdNFgHw/1Gbg2gOrWoYvabgrjJT/7cE0OvA0IZ3qZUzQ4kaRBQq2+d+OJB1rGtzuxs0/aJfuic0de7LL3S6sHV9nu0foNfmHGWNDoj4RJowYdMHBhpeuWuFsa+Us9hGmwm5UNkF/XC2cNflCtFh92cNYgsXovBbu8SD/etyCfeGi4i56hb2JsXiBH6pqiqI0I7MBuXHgJ8yk+bogLN6yu3nKtG78TrJ0yi8uMisX6gzznU+ePjm/3I54nmPA/qi/tnMveEs+Ty3UjvAdpQL65bf8+9mfGLwOh4Kv1V8If1a3Q18SwjtuKKrhTM0BS0hVJlpWp+z0MJNSPIW6AOeAp0+1H8HRblHUxVydgbRM3BM+UcrqgzWql0uf2Gx5dEDbL00vyX6P9iwZhgGeSVz2ak6Xi1Y+dwGzJmG/tWYYnGV8/+ed6koSzhbm78MScUcNiu+kSeG0us+HOByPeL/vkB6aL/WTbszDem/SiR/6r8jBM6qWouX6T4wjdKFpUl7OgoPnV3R81DFo+/F2vqVPUu92Q+QNxr/YYvbRSY8vYH3r5bEs1ecL9/90VrjURrRuNLucIRZ75fcvj+cw46uPfR2qXjRNwpWHmuDsvfN/787dcayQoAGRBp0qhEiW5ul26E0pZ4+0G6hU9xkyv917JSvM4=
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