EH0RNLX5R24y4aAqZMwokDlm9aYKRJp7dO16fb9HfIg6lw15aEKGD62b28igmB52P5hgDW9yAlcXZXM+t2ixGRePDxFlr8jgI6lRRcEgXzaSxY0nkAj6UkgrwTm2MOnjl9KZHSklRAwQpF30NH3gv8yBR5cDtX9sJvI0n+yR+emYI11hLax1/Yi1iM4Emu6UyXvNV6TKpjOxKO/6Wvo5uFxeH8KlUywJ4BhS9VgIeAoDd19rBtLSLyWx9oNDt6YMHVq7gCXRcFZb4mKm7j70+aZFbBUJ0cnSK93feX2c5Z3sFCYYZYJRtH0EIRnlWWEeMDX2y6mtwyHjiX9BVkvX8cFIpb3rZET2oYGmFrXUE3me4kYx2UTjxME7Tk0+CpIS9yV5dRkdvcLwUBcAsErrGYdxIsaVb9Xb8m1eZ3ISgn9Pe/B469fbiYm+z6QP5Pm8h05+0inEgb4x9t7JHVMlreYroSzSp8E5GS8Rf5/TyGv2l91+nE188bFmdy/LK48TlKJKkasHWdYHsrKG0lecEnXltLImSZV9njrDV2WJl2lOSlU4EX9Se2Nev05ZgXdRQo1CvCcQMc4ANy5YH7FsJ9sTdVtkPBs0UPvFzCHCOUWzREaMCyzf27MfC9mjADaxKHDC23PEnqR6r7NCEFnqTTwxT+k7Sc1xJuqCxTmUtwfn10GX07rfLw4Oce60FvDN18IdAPUMc2+Pr3wdKIumYf6wAy++unVAYIVovTfoRLh3GtHe7nALjS9753ti6cU0R5Pytr7uXpLr6FmMLuFYz1Y5ZxYfsv8qKsFbud5W+kMAXNhcSOcFSz4V22sernmZ1c4vJu8lHa2r89VVM6rsD8hfU1o95Tio6AXVR9mLR7jrQelpARBxF19var/KedRzyawbLSw8DtV91rNelHJbKYfbql8I+cy4DJJ80Dn6b7yxLxzo6kJR+wzsIZ3toIw6Wgf3BkvbOm+DbfoXrGHDqPDDK3Ozn6/bQKHrYdqDKDi4AX4L1/LvSWBiB3E3VqhQKp+oBe84nOelqvXQeVIfZeH2LfzG8K9eTvU5I73zu00JBGrDLmggUs9yzlRAOuNpUqyEM3ahRqJr6iXM8uaZdGs2hoF8CP0AGgO2vJOSYwsCqjt/5b8TJvzw15UxeFTXD5i6yBpUAWuuMWqe8yk4noPe5COX4awVlaeHGxpQYP4WKTFR1XXgAI7Suw0dGc3FDN64VMbq/+qfRv4g0ZZsE/JFPRBjBtuDhB6F5XU9iea59woy3I8J9qvNFpgcwEc0jW5eNaubQBjijE/NDvTuf7hmJmquJYuVDZ0oTh6N5exSpAWrVnZPuI6A3FaW4f0MbGIC3Pcdl35cRoI4i0gRgeN8tWg9GBnIsN2eWD8=
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