PAx+YjKnxIxY8OFhTvJrPuDLgMU5xe9oNJU4qWFlSH1HApEXqq4O+yaWWT6PX19XHmKL/isH3vWvG19fgBGR/UcuzRRlqiWmlerTYL92lyrkxVganDvWFHicd4RbVgr7GLNDHsjLDwLYY/g+E47fN9fN2UeJO5Q9SlStX05VTbsj+SPFaYWJ4ZN1BqNWV9kro9eb+Lbzv/AogKZDxdF/GoMBz0I/ItBxUE8wJqTnnQl/Ns+QJhFYaAMPbsQ4MWsIMYimMYGxLpHd0feXOFEr/iGBqe+Ip83MmsbNVnOiEbdT3gYd5wkF8Q10GuLJ0dvDAce8jHMW1mbjESfb0fcinJmyxpboHmhhqt8DWx9rSAXTKP9MbycHzXgIqFNjHCyy8/rsPJ/8eIUutdqE+U8oF9C6CZ6gYSv1HJUwKKxU3/Jb2CSsEmcEs6CRYktXxfXm2qx44ZDXS+RlW7rvyWhx9KNsP9/80AqNHb9g+ElZPH9PsnGg4cPC5hLhr9dVMcdItAqscuHwiYDwk9ob72Ny8b4nGyYP3NGeZPpz5o5xBNSUNtdF1e/b5XDOkMelfHbXJRt2qK09wyKmXvd0sAPA2Ge8hCgo/8BNFoAhrDKbCl1E9qEQsn1ydFWx6BfWxaj8iVDErMtMA/HIOk/Q/ls1VqdQy5NS+RIk77W/pHNfQfrxo5SwQl0vR3BgdcsMcYBQJOmWd06XTwYgHLRXcS6sYCsA7CuZ8FXJwK5LrJZeSNclx5Zj3sN4z49EU9dOPm8OI+8dm8XWV+aLi1eNF2OMnOQK5Z5Z0gCZoJ4KRYBxrxVLjuNgxJj1v7D7KZP8lbFmE4rqZG0Y/18qtz/kx2qLpUizrtvVzzZ/CFE/wJPXv6tpxvmwzLbr3tWPzp7snTL0Y4qet7CgSMNDbWf9eFhu8zDPhG/H8qSTBOTvYQdGo1BMvZhiTPvRzTQcv/AxIdiUj6Cq6bRokJTRy+C/p5WDSZ4LwtUHxyDAJg85YZAyl/F5zwqinLpsxaRA7MkU02GOE2G6rDVNI7JiPgI8bv8uwa6Wv912eB/1x8t/Cpw2TUS4frrJq/C0qpwoXtWI9TG2opzDMHkT+LdLrm+I0k9X5E/WO0SFAwrUdZYn6owss8Vcjv8C23HzwhLUiFRz8QxCmayVLUHMJGDSa+gBybSh9h5Y2suwYdmYVQVztr7nmM7Flxck19EJkyPVVUzE60+14GyLEqdgV56TJ6GLqQuiCU0KZEbT9NyKc3Jn7qCoYa9VW35xPHLYuCf+pfU1IeJ+yYKsNToP6qqKtWKhnAu6YZdiy1zQcI4K4tHRGuSW11/O6QZyby2dkaCBJHwklESYRfHQ8RNJCQh0l+wnMjLuYkslIpNlGbEw3FrKYQ4=
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