kslq2I2/c7tkwU1JzPHIS5zWeIFFGwa3tl1YHca9QNHWjnLNQuKxG+Y9XkvpHVOmrbyu3U87gb3sX9UX1ouclsyenNCcFAVWYmHep1P7lGkbBzNiZoM3WTKQ4ajxwv1AV4fs82AYVrf0FYQ2K+6MH0JL08CEQV4ZE7QxaCq/kdPJYcei2UKonfp8jgFz2d1mmGw1kDnic0LtcSnmtSRcwZPZFjTUOIxPZtlc+vKgGX0NeqqYNPrVa/84LeBeJ/h+ENkQ+b8YQohCld3FuT1Dd0nHH8+p/thAOYi/fIHlAhs88OzJu25JHK8fXSVURR/WOxkuBEwmZqjGZfCgeLb0cnXWw4YK4QjxG9D/w9aqBh68BbQM/r20ooIBKnVPuFFKp7GIZKSDb5GdKSqnZhTIxcE85WwXZbKOSv4L1YaUuW+zKPj4XQFzBx4wF5+IPrBFEbMTRS24ASUG9orUpzeh3Aw5P3bkz79cTQwvN9MupM13BVQ/Pou5xb0rI6zo1znHDDn1zd4FoRlScBEyrhgiwv6Vz+PvMo1wQRYslLgF9O9GfC7kzgsRPuxKm7xQF7Eoz/DfhvfazAMCa5Z0uxcCahkBo+4Le3IeK02z1KyESDgdisRe1Ze8YSQC5a0UT5OCgMDpStZNjVuu317CcAoRNf2ONxVDqGYG6sqqhu48N9WL8BONQtPEIP2+/z9hYzDxUSazCJqN+DGxGcYl/GBnD0g3wdbDgwTdlpFCcRKnyGlneZRnzIrZn79JNUhdOKSDOPzKVL5V8b7RfQkZvydGn546IbUyBDVmqnqaHOV0y3Lb1IrTOuZGhI5tGFI022voeHHAVF26UVGx6HwvYHddZ85+5jMAacmG3xONyDxxFeSsfp8ZQByHC+RH/p2ZIE00JrVmbxdAwXSIfWnKg+sY20faozcnRyMQo6I6ljpXvtqqk/QiTx0HeZr1C3uDSWcU2kX9bokaO4m5DDZw3sZ4nzH8Lo1FYuUxfCrgBlyeXDR5MzKVvix6hl30i9t99XkrHrTRMp1a036L2qnBrVuuvfiv3SZgi7KV2tEg7J+j5gPA5ikJQ8yrQ41gF1e4l5k6uGdpp1QRV9x5JaZ1M9xg0UJsdOt7qlUmDyYfRbQ5gd/vihx0n/OzkI9KbrXPwOOkS8itYQKAMjLtjzOb3OcKpO37OzWdWXc24kGpssbWvl9gLx4QtK355rYI+83ck7gHPF80VQZ8tegcQ7QLRNqbJHhpgnaY1sSyTRWIEraAqpNYzysqBz9SMrSL/2czWpcEbFfXdlVE4vCcX5cSpVi+qGqVuAxi5HGscTGcGlrM+vK9JafwfrhXhkZUZvHdkPQADmpoMPfT4mpXakSEzvyZa/+JcGEOt2xevj4847c=
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