70ZHBX36Wa/Tj0t41eYWJM28922GJ4ftub+ZYTzaKZ4dSGzQTUXGuV3QQh7WgNZtw7aWoR7h4jvcP69xdR9XOUj1OtGE00I+CPKmrxbOcmFM1Ic3ARny3ZZ8CHcYf/zgHiyOkKizzSiruy21PiCLIBG+FtXj2qab+g0Zqk5dX+vzHberIhK7ladZFR5hiX5nUgHIWhlnBWNek8Aj/22/THPbA+vqMT7Ibkt8QlFi+opiD6b1NN3IMTZ38rVQCAkNpr+g/ReqF23ojz0ELZ/RxKPGb82IqT60Ve6RtgiuXpi7+IrmamOUVjXsghFOHTEO+syBiT0qvE29rcTxs4xv4zJnD2JHoBKNLMNtCU1pI6Lk1LJ4SD7gpgCIBDQAW0buLRAh7mjYQdSCakWwiIWZN87m7Oqs5IVCKiOVgC+NXKHMShh2/SUARfPGk19Z4ZW3IEgXmGcE48ygwAZc1BSFGhJLUubvzwSrbn4fhlvijKNWvHqxNsaz+vtJMP1E4Yk5T5NJDn5GwsDmlXTA48Lk1m4U1uv0UlOr7CFHS2sdTp01LwSGGvp6YoXpb8WBvQXGbV3oitR7DgJ7fXX/UNu0dw6QjJ5gNu1IYAI+IPvAx31NHT0DqJQYycnPpBgTVdT2s+QXAqt5kZgZwkhx7THi2xLCgm2IhBcPzxHFBW+vdSarY2e6ONRORxL/y5m1W3rk9oejHhtOMosBp+66McbVrN7sDGDrCIwB1xXzBghDm0oyeQxNxcKcA/XDXzNjJ8BrZVd3bnLuflyzzZs2T4OchCm7JLybsh01nNQRmnBdR8EcR3QTyA+MmwYk/A2w6NbWgQNOzB+h1x2P0PwahxxKIOfQ42No1q68CA2Y5m+y+99qsEAr/zUdXGZf9Er1EE5QfPniSLEKsqYRgWz4E5lMG+tfSOTnp3maT0EtDa4SgLxQArW0H3l7Lc6dfwkeBmen253aCj0N+StJN9lqHl2OYBK/UsK8aaVfJiupaEguFsWpZQZ+IQpcrq+wOma52WC9e+10Uv+rY08zoe0aX6WAkVan9TSC2xP7Z64/+ztGRdl7/YeZBmEMHofC1WMhI/o5iGcY0LX4QqDE0oxbqhQAPcl+4zts4+idwQQm86pufUNOD+EMY7AJN9vbaZuRb71PD+uFLLEK4vNhpq18vVV8DF+B1+R+hTOdLBqNwt+80qhEjSuuXIAYNVBq6Ah4WL2Uykl4LwpOiAGSy5veHLOlsSJaioCr7hi1J8/ZNy9jXf9oTbKRTnmROedCkzQI1MjMFsqcnKTlOpiFXkjD3ZGURJeYew046t7PvMKAWxtp9gOGq6TtQFDKXn49zgfcRA7yMSH72pjGNz4Bb+qShTGHOjKQ/ov9wxcBpds5TbM=
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