yR7I+T01y0MAEh2PoTRNw+v+gDHcuOQXuVyZJiiIOgOlM4LoHj69AO+Zweyg8X25llvuR2KUwC/Hnv/++WBVm1zMfgES9/+EgELZLFS0vOIRooSQyVzJMNnLUEnavSSnXYp2u8R9rD+kS6vj1xwOZJ48FSz5fWVU/Pg+/EUMsSpbCiZJURyFCDciz4fvriLfW1xwR1odXPhyt8ZK7GTjQosFUl5oo2OnOsICsID6u2SSAaZf5gTZAqviHtvVMdxfZ9vHbW0IYOvidn04rdgbqW9ED6joA02W9hL8isIxnRHy+ntK57uYbw5X6/zSBPy82jZ5uhXxD3PXSu+GL+4/NNxCA5vR8PiwKcQZ4C3Z7d1JMZXtDHCQQUznUOreDns+MMBmS5ytbs66U4xA1vnuNgJqhm0OlGOxI0nUb1mJidh2O++cqRYsqVP59//PAUnVSgw+d+ZYmb0oFleqW7PKiKu983fPLDVV0tXw2A6g3Fv1YeqwiSCoC9iqDH7XpUH1ZVI1KPbzhWluIJgmZpoijkui5RdwK0iod0H6ydNTW7W/cvkxkNiz+qE9AvVu+NiJl+jgKJLmtAw6gN+zVl2SzkEY1NsymVvzQ4SGBs4Pmc6uaP8Wkh5Xf3clEhrEeYzf2MNMvO7v+T7BBUaQbbe8zh6jLW4EAMfXsrqH7Z1aC1skdDbUxRHaQutSsvRwm1DSnUY5dpyeGz1taeclHAT1Q9Kw1WZi2ZS/7wBEsW5GcC2g4fLjIfHxecbLnxL7YWko44dF4PDWpUGEOyaDOgr0iriSkoRJd8Mf23XKpJ0ik9qd/WLrDeu/FCshNRt9w5G+M/zK86cpj9VYG03Nm3gWRDWDHgDF/allb4RQKLruTH0SsQypRmRwtyDgg9m3e11tkkOKv2NyNpYvx6SH1/nREGG8trO0eFf9sxqEflNUGrLLqnxAPAvhuHAZXZHTWW6xYpauIpfllaAbnAnaHGFAq22N1rvH87EMzyhgC8GOJi+vzq9gr8tH7L4pIbdJVTJvDc/5F5R6wgDxDbyWkSzEaWB6140AK7xMq0XGBKsiU+HWCfong3ZUgKpA5+Cy6JG6u77i3iWeh1i5zSNtcvgumWpnKZdfF6lu2JBgD6OeyPKo38B9Ph0b4O6tIWRD1XFYZdx2Mm2Ez+GzSr57UKS0QMfpHUKFuMWtSlgrFlGLVhpTT+wwPGLnPgz3XSVHKyp3uJ/8hN1vkArbq7eBVTLvyuwKbv/Na2dekKHdLNpApB+3mJNHidsTxckfCo/bSK747vIemHU8Dwywa/8rK+NCjfKv0h6nj/tD2RrYImHg6EE8tkMPL+E44++kAReEl6igp1N34b6UqrcM8PxJcBR45k17fYR7vW6wnaPFUQc=
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