uzrp4tBrsULHG6v98ASm2OtGb2jZr47xotESMDmigj0MeND02/G4G9MZmfsGCtDlsq3b/cm86enPWaqfmlRFHTRFFZAoSqK8FZHWM8364mal4fCARx17fJjVDn4x/nRMdQcR510wXydFOFSxDL3nfL4vPwP4rTtfp+xApld0G1xp8WFq2r+Nt8gBA9OH3064zxR9/1Nf+e7pZagfn0HY5q55ei+lQ3m9lWRJAZZQbZXZF0eptF1cC7Xra3JIO73OtOOZTfhBysvv15XzK01MwicgZU8adPFNWdFBszODoHox5jSjat7ZVQiibV86iJmuglOEI6baYJZn8fwYcXuliBvt9TtK/DSw2QNmdqQvBWdWMAGUUWyw8Ar/WNzuNwIMMDK2ksAj8obOsB2hWxl0cHpXNuyZxLWd9qbujeTY66x2gxFzFuNfmkoxgpVS5slnpQaLJeVHxHGveH2gGe3xKWUKpJ+ezkxSaB6ml+WzPL8UZzndR9AgmuccofJUEl46pwBFAvIYsNQJTq83ivqScfkLvY1rabREgsVHlhqnJshPLIEGs/W8VSjblcP3Dz0h5NjGCuqu4xp+rr0KQ88deZFuaboFVE2io8/0HNQn6u67L6TGUuldoHDJgXUi6edi5IFz4RKKTqYjD0AVnl0KrGpFaTl00D1WZmDgFuRX+LxgxKoT+LJC62X4pKVeIgPERXlqXmKNR0cxFwnRVL7vj1Jp+QJB2k01Iu2xqcrYCr5DiJgikbPW3Vk8O5ctSdGLno4UOlf+tmpBdr7Mj1MBbbxKOO9cCgp8O/ygHELTAxRbAvX3/FPnM0/LMHC0i1VowqYt+2B1R/A/bFSZ7DFDh3Kxd8U4MJb8lqnTX1qMsmkAjJADZRuxZtmSYpdJFQJcsUVMUNPAqadZfHBKUlLlcVC/JgOc+S8u5vD5pbhsF1ZvhbVQe6gEZywx597ajeDSXfmnbN1oFRHma7+qjovRAR/ugcPi8TiWqSicsFSS3eUYNizr/RUDzS/EAj5COGzt+TIDog0jPuKwUzovvBB/0QLXTbpdv9IEkNtKyMw7Rqe7lQue9Pi4klDnNUkUsm17bepj9jt0CEfEh4tNcK9EaKqN3OIZACkQmYiYFQufh9aoLHn54qCXpwLQLM9XzVRDUKE8+MWImItkDzs7Cn6th6wBnoN3795Czif6lYIKPBj7fjltxAS7gefGh/OEglaCkAur5AXL/o2s369LEbcndGHSL5Z7dAH7iI2hJULTqUJzYYlSGrwKMreb+jDnqRADsl6JNPP42bDHPGgcAKyGncwBb+pGGmKSUUHVBiu8HpwjVzHiaxzZnrL6+r3plMKdmBalinOqkmlTulorv/+fSNLxOU9FLyFQ/230MZQ=
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