k2VHy+eCCyqaklW7NpFrmjVXrD79nC40fM9xyAfD8+VSGPVSK/nF/aXd5WlfMuRQv5k8kHE3dDLLz0ku7dpomD8NEukN2RZZBwZRotn6EmsLYi9TOXeozyqwgxBB+XGKdeZDh28deFevin4J1nwumDrzDmFGDp7tpfsnlzgGmTgblbHWKvIL9+lWk7+18N3PzYEuUR0PxPKNI6tGUjT5QnYCLT+E185bfxcU8Xc0rdTs/aZEQup5Neh49O+0YMuobOKsoU6tfqWoOLfUWQdJbw8BXflTZJTRv/kLiW4LZ8OYHU5L0giWkyik39FW974yyVoG07XB23CB/Sf6JA9OZi49P/8/3/CFgTkbQEPtq4BcZwUc+BnV6xnmD2EvEQg9pehx/+bQS0rjNKz0m7F7KE4+l4dHWOMrNsxGtvP0VmymHGNdxq8C8XLsrY4XVttZmuc9PYplPTBKcG8fSZ+zkfWj7TN2Z7QwQn+o6/xMrs8zZvq49nD1knAYfx7ziiFRUPUGb9fCOJy7/heWhL0HngG+mEdoxG0tyK3itPI2iEk6nfXjMvva8UhOuPyRxq4fNfZi1vwhSt+mAWqHjCNBEVMPsMKd0ofLsu+wJV1iwhheD+c5JlFRs/xu2otffpiHWX8hzHIl/CM6aUFbn2cA3iyglUrdgMErB//t7z1yK+Gl5LY6lzBL7q5x2OA28QWg4i8H5V2mDKB0r8ZPRp/qdO0S3jZ8pEPbwenu8ieZTsMZkTngFg1Ezmxc3KxJzBtqJDqzAxGJ4RUxh8jJaylNAMHjMu/mfPwvLlqrYIcP7vt+IO/aOmznpUZkyCQhsA2vabneaIB/P/CQQ/hGgnx0OL2JlWrWrvLj0BFAYYfdoEOZaGnpB4guZ32mPE/wTN7aSfIev9YzeU6uwKr4zNuElp0V6eLIAXlxR0TDviAs2iIAlYofWAtY03RafKxut0mnKM2Os883UmReP6wWhmN/WTpOqPyp4vhRhdBNO1Cx3Dm9jkPRmBtk+Lv24zmeLkySGHjHxg0fVLAr06Z3zdWnXAokozBm8hNB/k5a5sUk0fFQsBQlIm4HJ6ZVBXRMNFslTou6nr/vRv6yqpYv5VPK0bZiPfFFgcwU1zmoXGCiF36N5znSJ3UwZNykorZ8XKs71GKtuT/XOdCHzHtD5g02WSXKRtCIocZiFckzqZm91jojXh4DplWpID78osvj2XzzYQV8rIglv44TCAbmZ45z2cyHqzPOvAtydgXw2XRJ89YTQcnXDTCs401YcKXMFEdbYC4t+59G45B0e5AwoBIa/Jfl+aTJBHVw9F9cvjrZxILUFALXTSxc0F47QVHSKXWnBclgx45FhSXXC45TRo7mEg7DZRctT0d5pTdV8pU=
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