HH8mU+f055UVJ9QPMePOXBPcCmNcDjySBOxOMq9XQzH1YigCOSOBKAT2ZgTYWt32ILJ+ppJ0M7V3F+nQ9MMfn1cQ20VEWEfOoBkOsYpriFLBpsCcSsRcX9C4NGmA5DapjWrD54hMczWqSfhPtaANUgiGsbhEIy9NvADHaF6/JSPl4AlOscaJepu4buVTQXdYm0wMNEzm3rFaOtlIoKIohpFXjgMwnPTP20zoABFMr57fYUucfqEZqhMNWKpV8eLybxaRajiqsmLFKjezzPpbYE4hyria37l5DCd0c/vesMqv9NOLZMthzMeBIj/+m7c7c87bOpvcWlviBs50C5fTmuSUe2TzGcTW8AYFX/5HixX/3QhaDYjr3MWDqGoozBn2ALG8MjVYILLTat5ux9bUrcmJJW/s005ShIFRywzri4xvX0m0VzSW1wSGEPrOcMK/C9bU7eDyJwIa5mDBWV6k7GybSQTNioadQG8zyMEN7OofS7ukQqCSx0q6FX0f2wyYwjSEFX7oT90utY7z0kL8mZx16aLIhFNibL4fUOqNqfXi9ACguIHiTgQQFlmvhx9QhoGTvjRDE/gYl9Wzp/S8E+wN64tekI3Rkm2CjLTl+Dk+Z2sNyaOOcGR54o0O/zw/ocohAu6rGzLQc+/d2xP/QzfmnecJ9FlvbmbwjGYPSiTSG4TuZa47Ssm5cswRCfnc6UKmCyHKOoexPm98k03M2gkhrBwcpjazaMPTUjBpGSNhDGG9PqWNmTyiYCiunb4ha4+2Y3VOML67mFUT8LmlYl2sK2LxX30R46lghrzFs9xGJ2dweVX1OmkLzty+CERJPvJ+CXzKdFSWbd2rB8M/5jObyyX9BJVLI4TEUc2v8w2WWeprWqesJCrstvN4jQugzdtzOva7mMetyx8IkOsDKDTVJ8LmRwIMUFC73KGK1uxQSdmQGij7Znip2mPq7gw6xMK3TlOTOUkIVFOkWpKfWyTS0ZgGY4REvsgjIpnRahIvAj+GO+DDIqIsSSC4QGn7hRN5XTdfV1l9OuEVhVKZKIizl46saJcg0n7KC9SnBb8OB+Tm7gRikai07NP8flSxZHLB+V1EW5LZhi+40Gj3D427LdvI7SgkKv1mQpL/d2LgVCU2jzzry/e9TePsYg0gPr7t2W/Geby5fGxSU1p899nTxlaY7d1enMws8INEXeNjo6CiF3bCrqbih/xL4fa+BpqGFoRPrGx3f31C2aX/fmAQ7cCATs3EI5mKZi/cKlwuwC4KqHbImZpnZzd0aCkup5GuPFQOs7C94y3SLUGXDxRSN0mohKTkfbfzDeOnDa7uJUl48DQBjcE40t1TbqhnLSj0fitNChXIxZ9zIMzUWffxOhRkx0Ambdxfboo=
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