RUr6lOVq8pfinwdG9c+RygRI7XQGDjCASd9DqaoYWgx1D214KKL6HZsVcvMye3n+gPYvFZlfMQtBQAGuW5dphbxZaxtNhVZieObZm/TAUtXd0hnsa9Mx+xhige4Yrm97B9Ta8z2zWqX8gH7JoQ0l/scCy6n91XobmInAQ03ayRx/pPiX4HyISg5Pcqb18rUch3aIHFel2jhPs02MI4XKc1JESsYrok3ZKW7oofY/OOloLsJ6msoOGgg4vhsq3YZYBgW8Rj4T72nEX24spwtzZT82z5li6z1Az2CNRt//IOpQoGMn6bUolu+oqPctsuVdcC5toRpmX68VqNujeiIZVjhgvhvNxWQ7cIqmrN/NSo0LxbixU18lKKErQQILpGaB01ruvDABKyHggOBiKV84PpVlCBFlEI/qu0E2Zlh/F+548kWxTP085kt0oWNHaXUFAvaaBtxyxqtNkOsOJJNU1cYMDHY/IvP429mDoQS/5GVFFPfp7LM6ZigHtU77K76C8astby6EQkXf+1y/+zHiaG5wG6thEUqQMeT5dCSAblPzppVfTBp9nvRFUgsyThWTQhCTjXFi9Z9ty83fj0RljmyNflgVtjGGJoF2pbZrP6tofrc9JGydNZBJDTVq2Bmy7jBj0Hp7U7WPYt/HpE7KQfpDIMWVPuICbkGjc5Pj3XySiGvoW8l2Kw5mcAu0a4b418vaxY8iioVdfFRUqOfArfhS7HWEEmfZ6n9QVHCqQiqvrHhP+sawkXAUAAj5IxzkgapT7BVYc3jX774FPMUKHyc8pIQM3vhCTPcPQanJYSx1MAtyF/DghY8cOLplSYw+E+FJyOWt4BnpGK6BCK39JfVEXEWVecq3/WeKiAd/EIGB5OuKZBeVNyXWcWUkzSrvue4ffP7MovGHaCHKyVVoQFFmgBelDda7cyPdSbjcDfs24q5TOQhcUiJArT5JWsyGFNSbo6klF8QImdhpIihilu39qBKCQ1cU23BIpt2/zV4fFj7zdHXk498v8b21cdP7kX4aHzp5QgQA1YzmiWDj7SYUO50+8zwwt4JPGlnMMxLLdd7iPVeZ1nbwEBrc1d8APiHB0X9K/1DXwNrWv8ho3vlgfgGiAMXTc4u5uZYXAM5xJRMeJ6Yo9eqa7XXCL0hgBzxvMu+nstsDrtyV2yJeaFiQuChas2ov2tFFuWIpRDNdkynAEuuMYJ787sW6jyTftVEPRlWi2IL8Ym5Bdm5D1RHV9QfzzyP+C0pGHK0gYLCCLyP+GPg9pBBtDft0+3gul11SoJ7BqrC9AahebCsJ07pa5BV3JS+4gEg443tFPddcIkL8X4ULy1E7e6CrxreA1oNaH33yAF0frsVX6aBVDnKq7e/kQ2Y9Nf11Hpg=
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