pEtNFsnJ6G+6c1dh4tZCW5o+Qyg5pmxrBwizi8nbZ1smK7PIoEPbCxJN0JWjL+8GvrvNRTZablYWTvlr8aWzyNy2CYZI4vXCUzwzK+D2m1SWR8Pq/K32Y1w9Z+wPEzGqy1guNDHvfxyXoXDhQQ/UHzuRP4ptbT696jUL7wRJGNDlfb5g7+R73OwFM/ieu33VLHM7TUfkuY0TfXbzzZIvDiQiq31ERDPcOX+yCCsunj5b7TvGr4w5cCGlCs2J7ouso+G3CHIeZr9Z2bi+mDkPNmDfLsTYjFKPYQC3JV7zy38YMFALx6wqSosC4d+Kob1TUSYhi5C+HqAd/ST59t1KXu7dVBF4AxHX15howpBDu/JmDqO9T1vqtZi97vDQZEWUrJpX/XtJaYRRdr6LW5Pqq2b6DoDuW/8yH/drdoLPCPvnS3c5t/ODG69E8dfGVNC4kjVgqg5jfThJPgZjK9rk9ZrrWQcluWJ/4r3U2ugRqy5iSWNvMxDEOunenadOUutxhnmMy8jjI5O1CAf4+NZBgiaBa8XDWTc2CEeFzqpW+UOY1URwbNJe70JjmI0rB+rC/9XpODEAr71ozhuZcvChxMRTQ0apLNkL7WTkeecn3ab97TyZi0OljfTEXVqSjZjAjC5U7vQENJi2Bp4uqQmjjlMDWLTZDbH331UpdeI8t/q7L9mdTlacwhjchF2ukWdyVMpt6rkpZllu7dTtMKQPMWSPoW7sgWAuNptQaNg+cWA2pTXZYZFGCfy9a83GPP+UyiX41CL6wxVEuMiDgK0WBuphOg01+4efis9Ic1ps/uAG5KWJlWLXa2rICA3Kr/Rd/L8fpixPHEj0ogfpketQ1Xm3SX4/HkHXy7cIqwlxz9U5tBoDihG9Gy/gUnr619qHyVRawLzCIbdPhJozRMbxGOm+jwchvqaMan6VbRizOuyRjsMeRDMCJ/DBtPaA+MhsL7AS18JHYqy1VEDOfdy6v15kSyJh+Ce9DVlvsE+EhCImhzWgPCqmmlAhYxCM98qZHmrHHDSbRHs9nSJPIZKum8jxImIy+4n9pUZqViFg7Qlt8XBJ02a2UKDwoStYw3Z2j4g6HCJT3fzx5uudHsnS1Mm1E611+wpbPFWdwXe7mMkGaHBgafv92ssqXxSxApmhWoWTye9rJ9WOYpNgLZXcpSSvjla03LNGq+a6SrXbTphB96B6vBKnVE1e6zW/zkdMoqIYNI6XYj7D2bjW3sql5GGtnHyHyeRBmcnFqz/BF9yqZznigJS06CDlHRy28D9A/sbS9jVZt7yUzlUEvwn2Ewm0AMMZGVrvUGd2Qi5P1iPAGWS/UqbPPBxQZ9jGneUbAkn5Yo80XR+lUUSLYBxbXuJgrFVXHDcoaAD5YNw=
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