g55AItGAS7w3CIyha7/Ckz2w69LJBYcPQuNYqwucm5/32V6sGZJq2G25oSN+ROqNcYp3Un/qa7zXZrVtG4rufMVfkb9o6eoy7C/4B7qgWfWsOgR/x2ZW0OxZYpAgZNJONqSI/ieCOZM39miMNSypR3UwLpTQq9grUOvcDS0eDGvTr2mAks0S52g9ppbvd3AmGfkOdoo9R1uzIi9gT2tBxscTVd/qvF1IOn5d02LWGFSFxYf7YFuuuOe8a5zPmwd+p06eZcE62tOhylylJgNYpamRpGD6BYdEsCEc1XWlguGW1EDHPiIu5r99Kw8+q3pDUgR2Oy0Rh23/d8JPJmCmGxJ6VtJHd3K8IRfOLX7WMX2rqCL/48nejkOcRRIhUV21USu1EBwxjuhE2lNfrggHKzj+SA0BDHaYsWNcAFJrzOUwIzEe2e+7b6iPeO2o3zz5k8TVW0Ja3qrUHlyzeARK1wATikluiUzQyXj4nb8TEYTbKuo8vhdwqEfAjBuzHT6k+fvV4TBdn8guO/Lffd2GqUozejDbXiGi7DB8h+w4YoXMtw4NS+3LUxh2vVG/9u46fgNS4OSq3z9SE/xmby9u8XQIxC62o4nFKqjhEcV+6zInPQzHHRf1DIA4P+xIPgmw8EfnPswVZDFvutWkpZeSlp3fuN3hO3cy8amAe1WtgX7vXFFWkDNt4H1MaPeaYtp1O2iPUH/hQeZwuJLQI4jkpI194M9WRVhtXsYjwQuCwod6/fjA8nvcUmv371yh6sKMTkfq2hLufo9sw7fvTIJZQIW2LrcU7OEdloTJycdz53QAEIHpbVgw4b60HRh49GrN+kbBj17XWY+DM5K0dVJLoFTD1Mlo22oJ+TznEEIA/fuNoBKnVK0gM2GPH7OqG0gDcUMEooDVVVJo+5ga2u4y0Bk1ZCFTx5PqGVjghRzX0UcluP1MYh2qvfZbGs2FR+tFUSdwjUEXD6MVNpXrqo5WEvc2uSxr3lyl8y46ijtJFdAN8yBxjzo0SI06J/YqFPKUDKku47cg3boGfNiB+t8cXOUeA7JnLUkRRgomQCdoQfGoP91ECmwNFOl+n/3qyJYslqDBCo+egBNuJuc8+CVPgUALkVtj+ZxeW5OTSQ1sb7ebaCIpnMVACwFn6zEjFoLrr58As9L4F0OG99uvsMUXQLSnETORchWbleLowK61nIkE5/W7BZSUZAxi3Sygq+YUjwvtOwc3J26VPj0T15lGuNPesaI3i7HAZzRKSxii2FaCPwJblRaJv2DEhv/46vN6xlXoWC81RTznEX3k8T837jJRYOMRlCZt27nl6j1KbFkyUsUt+a74MOBKoSWGSnj9Z2x3PLE2zbhA5vgrmpSqqY4ABnOaTsR01kwMR6I=
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