pJvqxRh9Lyd92GEQThLIgUyVMo7PQJD5ZKAOsnGJ8mSQHxEyXaPvTfJcy6x8i9V84wLQPW5/kl7Yse+j2AKVSyeybO3TFLyCWn4B1a7nhkeoAe66fjs6De0zSbf7Bt2OFZ3QLl/39HN48T2w+LmJ4diuOfY6YCVqrh2IjqE53lK8qp8ZPlkAiVS2hWijuFtIMW8GzaQK6W+Hf3N9wdLbD4pi3C1ltR/DCkb/7u4HMwOAmhDps7AyKA1HlyfPo35KonSejDMd/Dv8F8lKvBcQ0akXR7PLdp2CmZqv2F16KxLg2tj7BI7FCZvJgBGTcLVgaS00+vN5ZorOdMKsMqXmMxS9CTOj17Jc8QsSqmCgDeA569etGcsOUkd8ae6jodtTHV7MNaE/UG3B0rBbqHgxxLs1yZgmNXg5F5q9uvCumr9zfq76KDaU6Vtdy3lxYzAOwabVvkcuFVheUewCO69vu8HWxvg1QUM9oHNgN/jVD4gE/3DNRMm4ofk7J/2YTrBWTxCs2ZdmEl3wWdQMRO3p0CyQ7Q6KX2ziAxQc8gpzTm100z47gWvfsGbo7/twaiLyFcT7svNXA3fnDx9bePnUauHsDxq4m5UOi0Hcpf3FIDNHlGx8eUWRxbncB+NJEam9TsvmlKDSpmVJVHp1wNU32Wew215EOFmOyqyALWOBB21hk/5C6mvMhVW2K7upS88hGO2YCQkeuDN5DL/1TQ67JW42mAkHsj2vQQeD7lj7M0BvvpWJWHOQK+psDgxUIGuYqHOmbsvuoI9NwnsGsPmetrslY8SbkVFgLK7L/LaidnY8Vt0iKgnOzwTzbhP58Y63OBRJikKY3nNlc7vXVm3dNB5MIhjEnjtH4B5UTgBY28sxTWeq/WEUoU1Je2rQ4Tg/jeSqfPaHmxYVGmQ1Ten6dd3J6wxXdyjjETjePYVRmInocEYoRbIHAZ0kXSPr7jpd0UWYDzQYlsFU2j9KUB2BjsKwB5nyabH1vn9mfeUzmi0lzR31oTnYI1F9HCXCrrRbtlRnt0RZSuzWi5efjtnS7gFwG//e5iop09xMxFB97omS/NpX39xapap56JfHNRyFGg9HedKJciDy5/OogL0UqOjH7NAzo6+ObBVva0ZHro8PFx21a6PQZucSWyC2S6gLgXnS8Uv4dcQZ25sRm+f2gZO3fPr9S5iVWQnqrILXJggCvphUfXrOpqb64vMEHT3UK31MB5F4tOwHL9ajvwhvcrWyr02bHk38ZaUDRrlYvgGf0znMnul7I9aJluD0+1BLvMTm/rCOUbrJkInxv5QYFsxvbO51wUfJXy95GDbLLGL/LHCNIyAohH7lWzQCx6kQfRsb5VcyI/lvITT+sX+pAOZHP8A/axFewRXf/8s=
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