KSQYQJAe7jrEEyBPjCMghuNj6wZ+mkcXzMIr2/WfDC7l+Trx+1ogDc8aOcQ9Wn3CkMbzd4s2rqgulHnNx5MriM0d7j2xz8skHLnKkmkSXinRL2DGsR9HvUmCmyfpp5k2j0YaRT2D8TvBRvtgDLkJlIWBjLg8AYK/944j30YO4Vhi4cTSlZfc89Nmi8hqcV0vH8mf5V9wtQCHRLUuvXeXE+n49G9bqu+wdCuHuIATJagr9ZtEiBdVt8r1p+AmqX594PAW/7r9EidFNB7spipKpzRAdwLJ3o9WB6zpZBDuziWuM7nxnjCradbMtKHqultJZEGAXaWDFdhRKkX0u8uo1L1M42J6DBa65yS8RfpcAnRWLlzApHuPqwCnfcyh5TC7zGk4/5q+fCUZZHRi/t3QvFMFOFw2is5MZ5g2NkOmcgLYUTXXYlZBBu33YTbbHcNjH4RcFaPgLWgJEN9mgCW8IyoScv9XGB8t4IORnkMwz6S4Hv6alF1miNcbpgI2lPBdoCSfDdp18xCLaQVCF3k1AiWAqW6Fm/h0/BCK0U5hfoF4vykP3HW1KGQ+Yi1VmdMcQw1wL2YKzw6kAYWl11AdI5wuJ+uW3I6705IsvRerC00rt3nemcKqg+qKMu8usOVkhZ7PMgzAem8f+LAyib9JEHOXW+mEXIMDLbG3chudpiOiLcoT5jbzX+0lkgsIkYw4gnbKsr9UKI60IK159r5jnqBETFlXDFSV75fHnNgNhJp1zbI5MaUd+5Qus31T/HFELYUS4d3aONbQ1vi1762ZmpJlVr7RTN5w+K4SME7DGFqhBeK4i+aXJe8gy2E2GaiwkV/QrxYGjZQDBzFeezuzoXTilICGizMF84Ak0QO+M60ggy9W8Mlr/VTe0bXYMKg0LuyiChnCyMu1szea0CqB42qXI0LAuBvN9m2sLJMczU+So1RR2A0Ehi8UK9I/XT+geWcfwVDzFhUvJHPz6Cm3BPkMAUk7zdkPdlOEwyL2lsqiVHbfgI07Q6hizk6fytwavvP2aI1z+/TDNzAYQXolpiUyuub4NvvndUo88rCflf6zPGGeuwdev+ClAotmp2QQFJytlIoyMrO7fQiman6IABHuGE407c2tFsj4GDcSQHufICxFW4ZBVP/3zPWS0bZoXe14fCWoJ4OXJdX2hQZhe+03U1+D34T7jX4cKoSdnIy44etE7o7MJXtqsiGydS9XrV3DUxK3C2og7qh9dCtfRqCllgYd1d7QhearDKcgmBvwE9HbydfuNZj6aFemwoR0n/mZy0AOsOUro1clkTeCUhKUwqnOPUktz2zHWKR/iosyvPolmBHmGanBN9czCLld9uxdxxuDjNj95ybvxkrpgnShrb6KL+EFNDi/jpM=
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