C4qd+rHQ60aKMO3aDxjI0PZ5TC06JCD6FBD+R+tfaJ4knso5pCzLXYPGYJsA+K30/yq7nAHUmQCZBRFT5cwYQho5hDQkzMr/RvaF5Ur0j1HYE4g3IX1uJYYCABVvpisF1o0Hn+PcySia3bfuFK3Hgv/nGvw69zrmU3q/e9OknEXlzfOUfva9lw1WuO2eqZU5RBv+1BrUItQNLeb6+VDbBC+BfNnKs+OecbUiPuCifziPK0kMD3CapWzniHKDmwb3ZrnmTfQxdETZDPLx6kA5rqBV++uWCBD53sKZbBmB/ObdPfXDjuWqoKOWkCN6gQ7R08PU48Nn7o8ddAbESU2J9LYnMMiJ4xfv93knURZiKR4DjwNxVL4UIF+OqV68fQcPy5Sgo43+yCSjMACmUvjdqHG+6X6rKcTO2xg4HsRG7w/8jPPFHQMZ9L7pSe965wU4ycmLE6XMtQN1vXf5NUcmP7x6Yj5fxMWz0QW79fDcLTLNG6kq0qKONuFm7n62ZWCf1h9dism+iB4Kjw+Y5+pHuL6JTK9hg7VWeTKSQUM6Vz3+4VrUgx9lM3MPbzPnt4ivH6ZIkZXLHYOBlA0Z8HjxEjaXxrrw5cfJJO36w0gEC7D/AJLQ5Cx75CxKM1y3E0MDRdsBd7Fb95V3HP2s9qB3q2UXvcX0bvYVmCmuii93LXyAUb5yTtxlK+6UWpFU/sVBOyiX/xL0TezjMWClHqZ2AWvrE9/+OQC3/tkqjD1DdrCBmx0XsRvOy7MGLUxeH/B4+vOR36V+8JxP3zwGHMVaThwsC4tzakljKCfqkJhPB/WgOPE/OZ3pSSsGNgMdF+B3PnPtg/UaBfl83e/GwouCNS/IQY1tfZtLvQsMoBUUD9KdoTqQbYC1cMMFN1MgM12HPHMIdVVi0CMAqbSLAFg5OSeeCgE3plTCnhZqrFdH0GWrRCP4/LfaPUoJZ809yhoEeKXv0j5kbMg5frztZVa/Zx7Xo6xM04pHtOoFItpDaHQ1+PVjtunPOlnuR/9/3jvYvN9OgOozTCT2IK32mDoH/j06omM8hZcOtMEGTesunL9gq195ZpfkLpIisN6HQCo67xbIQxA14NVW5dbxArDhHddSD1jXdZFWZhV8Zb1ZrA8NqdqSCX6TN1TlPa9HfW1S+i8vKjQsOcIalD+8ole5q+7Yz7j1jwNd0z3JQiDGu/7f1XHe78qvDcI992eIdEXhiP/dBCJbG9V2Jlsi+ud0SWCi301QQ8dn8LBELuoRRABNsztJGSZCXmC6Oy9vvDOpUZKj8xoHpdNWndJNlBdI8OTYHUCTuXbSOn/hvpsyWfIQspwjxJ+tgrupGaDcyvuuRf8ziiGoKSSIP5vr4pWfihRi1T25RHMMAjNNWhA=
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