hF90WZ8YqZGqCxmefjMfRB+bimzSIqe6lz1CeJhuvQyaou+EOrPiSs5mRw4u0uhCCEHNDH2PCWYd84J/+JVH+EU6LxI81bYivsCgAtx3+eNXZzfV2CAqOlaMa1E+7ARTV11Hr5D+D4m4Xsu1QgzjlS8wCIlc15vB0zoFEQzKHV40GAhmY/8Rx+n2AaV17f8cDcytG6BAcjd+J7m/ocua3Onl7AmKK/P4YyIASPDr2BYcxPLYfkxGGfGhqq/ShQdvLnsNrhrC7qVyQRcC5BiolCLko1dBkuGoqZCErkkEF4z07/59JHhqlfialwXeoQyAUKeOig+UWXyxTNM02Mm+HzMyWum13Jzgr3oGRwCJxyc7YPLcWVvV3Ds8lcODraN0N1wRTaCRTdL/atLJ5yUyzst2aEM1rYD+lrYCvql4gEvvZ0XiuIs42/n4gg2kHtlxvJTQD9OrS7xJ9KZXnyzpPcfXLvKAcSW3vw6wL8YfMafV/DwugHNHjhHkjFOv71+TEVlkXn+qpXNrD15nHDSPFFfYsASOKEJz5m+GJPTBB6B5NCjKWLUn1ONYO19XvXx4v66vIbqTIqVN33pyLAdUWRBqg7IItmTpXv20yB3Q4qVWTH2MgMbN/JYZrRkWEH7aw12fNauqgFGSunEmWCwqV/wyINPfNXtsJvgxIc7qLGNWsYeGVlR7C6jJwH03x6XKE1FV/sZE9C7mKIyupEaCZ4YzytjDRqZv4RaDa0l9QsTElXievZDbQw6dyysx7t3flldhMITKooIZL/iUHapn7B2GyMB+uUG6NMXweoInX6g8oeG5xz0zFAIYR50/K3klPQDHWgc9B18Gey5kpEN/s9gEcSNvhNJxQd6XXeol4KAym1F2El/MeumCjDb4x4NKIs79IB0xpOkP2wqjtbvdJXVPWWn7DXsmcoEmO/sZGJKtSOirdrqHcgyiaWmocIUMkoOob421F6F8+y5Gzyhl3XrCrHs+lE5rRvLNLyM9RdI/0M7I+xuupJwUdsGQaR7rVhGPtR1ZblFJnxEe5rdqW5xfkAeIgNDVbw6NVN9BTHJsjRE5ZGvYuTcs6rv01PTzaI0UbsOiAxz5zblXEiwi4lizEPXdPru42+TS/u2l70nejTAoLgfVBS3T4SzI6aXBq/EsCrqDAOIVzI9Nldt9InL2hzGwD8W0dzjI5xpKtF17gvsrmkJulEfIww71kTgZGRqn/edVp8IOmTyzv9oEyvV6zbY8SpkPaLTqd6gtnf/pxlhPGgREoa9J5V+DOE5o2yF4ax9B0m04mohRKLZIGEvE8W3ERwoOPAiRVTqfuJLlBP7sTuELAbTVEs5yym+Lqlchh+2P3aPWsArrYSgoZcOc7To/QZfu1K1+4Aw=
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