7aD2vFcPZfz+ekwQXUSr5cCe5HRBtGVDNCmJwIoYoGrPesC+aQiMKkhjdbG5H6jn+V0HjvRCj8TO+l4mTRef0hQwEgb3LXWqu0t8JEJtS4H3qwDyCpxyuvoiK8ni9w7YQ9sdoxeYAqnIbHSggt6u+eqpAwnmmFZPCq5S+TIsaUtpNOzTCJ2xpX/ve90XmV1mCNzJOYtHmqsD1ntlFt/cy8jawv8e8EdGPKjm3bcmntNgLDT5NldDGBtXIhEEOIesvp8W7eLfRzPcPMG5fFSNavkMr+7eAHvPq+JcIe/9Q3ghRZM+bKILDW8mab1U6OQGvHJkbBbY7jJ+d9JDGf/6q698V/knofQOtOAy2qGWRbRh0ogtBXV2lWX7VnqDixDEkqCQ/xg19mwH15bf0dHTswMyyFJI6BmQmBPfSCsggKzRTgmN8H0+e3qcghIGSy4GbtcWgj9rv3fasX0AaNjqNKczdZvdeZNXU5tYH7koMNTw2oTZESfJmkTDzUMppC7PL1mE0ykdYfJ0Fb7A95hCZRLsFYbZTI7HAhA0hlnfFhUkLR4b3aJX7nZcQpEIRe0pnSQxSeoXc6qq0hubti7oEZrYwc2LcNd9qAiQfFtcXpoBO9uiXSQtWxHuGm/Fnqi9mtGZxDTgkKZzHX4GeDlr+nCqUWWg6rt1v8b1FmSXSssbIjSSBQWde4o147P1BdvH+q+lhQ/8h61hUEbPqCydbzt6/EhDym/RtfFpSHjc/LWQz0A6Knf+sTNlS0IdmiIYqKE6X/fQKbswMtx7wap2SrfW+9IFUF9mNopwg7aBVQvn/Jc4Ve3NtzBgZe3qC99BYvfbr3025DqPlPz5uEctdWl3u3K5yNALYLwz/eUdpV5JOzUDFfAUj8CV2exwWm3gzUsz6XUJtw+bwPcEqO/qBGITeAkBhtlvYO4c17xzHGuN3qqGTTYK/frDb4GubhU7pNCQgbzHeU4C7X5+EHCiNQdmrSTVw+kIspodRlJINCmrrpOgQowoRMgvMn6geBBH6zL3XrPrAW/2ESBxVyGFg21YKqdc1Hkdh9qntIxQ4OE5QitpL34N+KOqc1YD5kZBrJcW14IsuYrEWfMDgrjLuxknkglMxZpE/wz7XKbZ4Y193gbKzTch8uesiHDYdlvULL3qLxQDTujgwB0kyljhejnZz5i9Lbz7nrEcaf7hee1QMe0JOqgVUHAaZIkmpovRX+j0b3reqSvC5aIwsZwLnBqRs/mSeb6M0ZSIydejOvAZCfvMi2LDDwThWfCHXHnep9hFzY/ODZEAj52X1OMOqb76Px+nmIPwRsDN/9zFhdSvsMLcz97bUmmoFSI3itVT4oYgtrKfJfn07SpLVdq4SG0hkVd9JgHPi8Pmabg=
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