Fp67JYPP6Sug3jUsHkXK5EVcbSWCAa3etxsqkm/o3Ef+ZeT6BkKfvIwbyVn2/7ZoDq4vsH2k370K6CkfCUF2T0aNwdgxlNzEqvPmvA92xb9IQCzEhmsgpr98CgcLRV0uQbKS1jlr3J9GxZOb4X4tJjyRIjt1dIwpzCs4k31Edh0Teh5qSggDk3QcJzMILOiNBwDyXt/JzUnlWPF7Agnk2XcIC1gbMu2Yys5W2tFJuRzy+i/xt+MCEgS0VaDBd4dK7nRCiwWqKU9gTcIbWpIkaPcL7qZNi1MHBWFKiUGxE4vV4ArKpOy9gFdq5bsn9Tv14aXdXHhiNdvwwvHEKnTDjdmCGDn2zmV929Vw1tSoJjKBrXLM5O5oRAbxR/+ZdciEZ/OUWoNSv5vnpS3EqzbgebWUuvP/A1Fp9l1MwayM3g+jpoVqqo9XtYw2Xd5fRMp9jhXoFgBSnyD4JIWwIrbmIulq5+8j3wPd6ve7qwApJNItjoAEPp/lOVORsGmEuvN29ZN3ynfrxM6BctLvSRpkiD7XRnWS7Hw4HTCYX+eCx/BPRtkeAETrcBcdQiGOgCK41k2yH5oGBHn9JX5yN4v0e8jKRDT79VgImhz+UTVRIv+TXID56K7v74MrydqYymuEMVTXQiHCvGxJJjGf+owxBxR9xHHuRgITZ7WuFvdygV9mCLhbs6mQ6YAnT6+vAau7J4fOWD0PCGA3Is+WSRkfppdpBdmZr+chTng3O9ontB9LrcptwG9B7lk+rxIX8Ue/Rh2qZo2IytHop/idDcsmP0eLuSHAPgRnHZgBLSSX/AM3FAz4TpLbJVXbOn7e2is6dD5B5s+A7SFjlQVBUvvjP6XVX8s8ahw10NuOQw3E6h3GCDPwdvjtwcK1Ju9KrqMZj5qdGnYaT1kuZH+0uksA0RBER7fC9JVOzpCPVfJAvdAHPVqZFstJ9w8vMUHGYltCnzYrE6VmVMcSFkeB8TG/QVkWA/HROpHFPGcOf0vcOTnVGBEJpHdIp4yJL+EDjbLuEs5jT1uF0DF/xhRqq1VE+Z/0Z1Hg3X5AZV2YoS3HLbyHZuP/Z6THbxIXs2Ws+zR3Ong0zG5JW5w51qVgjoPqOBA462p8Wz1TBcFaLNAZHxemDroqKzzvrYnxOCMrxAtj+Zc59WMJMFqusWDc9OwIdoynnjZmemNOq/56sS2SudmU8v3/+0naj8kvcpCcSwOMzGN+XEsJ7OjyTP1AAISzxAoO5X3WkG2wZph00onnbahZkWWfek0fu5GOFeMC6ORvu8M4Z+RGWyFNNaZmDV3AXK/nLzbsmUKOVReYEZQnLpV8YVN2nth7HRoSxanUbutLqSi932qflvED9LVi+CM3GxOiety3AYEL5H2448g=
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