VGLcksI35G8+mEUcGJG+DaXsZM/1fWr2epm3EjUw6LzTjOl5V/6tYQtuUq1AIT6bZfyMK15V7nvM9uX+S3wVfVUICfmXpgt68yp7AyOmaRghb3EbqH48mONxOLKMHJmGW3CKsHSgi0YwiaFKDx3aGY08KIab/VbA+Ws7hBK5B5/uwAVqetmTN3nTgxPPYTuIYWUn5zosHO58NneRg8yibo09jiQAGVH9WvoTkPLwdRnNv2DNcEPp2KVvBI3SRhTa+rN5Y2cfGEPYF1Ut+5sObKw1TF4PLzqSSCemrsy5z9iHYyWypG6tY04aHuLxUOA4JElyXkuueoHPYDQTH7BrpVasTAJaUF9wh+JmavHJBi80/E3JSarOVPNltktP9sfS/Mt6Bv91Dp55de4IFL+GS4ynX8N/oUQ5+7WO3tVy1zS/6CROvDSjGIV6Dj+onhurJo307HYWg8PrS43roF9qQJjDXWlabAe8W0cI0TCnqqF3RKBV9y4MzdPld1bNsrsc5TIJjcYZP3G3C6u6vSLsGAIQxaEhTo6Qy1C1iMp+codExs1hweZYXCSJCUGP5mho2fB5ZwTjtrrOBz5411ww6fi3JLsfSlqpLjkHIcBu/VlCsQUt3tOXgTC+Vs2A0NO2YTa8SLcNb1CsAuIVUKZBIpnz9LeOaVHl/0u7VTavvUIyFP2/xLFtgtQa/epWMFhoGUM9Ct4wdfuyvhYwAhTteSLzLRVtUYprXlpq1OsXHhVFxdXjLuR7E54A3kii/PIw7v8JWKtBIfJKoz0l/8d6YrNL6o/xk+IGnB9jIv+NPFYlb5J+BesdxA2V8PRK6QWZKbvdoAxbJurFmqzr7g6Jj/khKtH4V20LQwUEPv1+zSEtqFAV7NK9omwbrJqKHp2sbhaAM8Cm7pekuHrKSvImUw3Fv51ktNDJqFoRqzvWxS5p77nlJvArIxqrWV6AwegKMu28u1Wx5dVN6aDEn6ckeqNerVKa2ETOX3d3o2hlrnAXlbu0zvZT2Ss+FCjyLtYNeauAzBUuD1FQj//567x1LymrP0SohDN6pUaaQS6kJcmHsbQp5sfFHrzNOo20cI+3BgVdb9jFqO0LtiI7nAZxjK85+JS8YBj+rINp1g4YRCz1wct1vEpGoVeXhKZd4lwJOcUvMjFffKmcvnydCgEnHXhMmSrD3hrUoILMcHh99m/DxQKCjKljWJmNHBgDJxTu0oKumqpa5f5lP13Sl1uqFCwwJp94QwD64xBzm+evuq6Y4/pIKvxxaJDI32hnHmbzKJ6t6Qq6bdxFhAN8MWOuf6ebvFHXKG+iVySyG4MDtwB5NCZtZQPUIWeqAAOjxjqKJAihtC5KSJriRAujRtzIk+fUnc5Rrku2mElDw8U=
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