h84KAEj6OUKFkUmkwLXJ9CRwHJb9xFddMfY3jm0ifRGIgmLvk3j3Vrg+RwJW3eeU0KaBpoyyfg54g76lkPZztyh/e0LSAna/ZOl08vYeP/dQzm2Q1MqmtGVxbxr7XDa/TLU01OO+TGcPSq0/4TXxniFvD1pryA5SB5GoWo6jwSgo8Uj+2LLAyDI5b7hdP0Chzp+Q1kPv2UTMIKcKPMyIB8UtxRR2t+pwytj/khOZAr6FPtPJcxqK/Ua8vLLp1L6Fht1bI4i2qbgwQmp0Y/EhAIIqRqJVhOTF+gs1lksnxcDtbihIPR5efXYd8nZbUodP5FgRCDBZqVZo+iYL+OA71xuebutFLdFpW0EtY9fP0LQ+p1uZh92I676L+mWtFjwTZv/uu5i4SG2xMjcv7RZeA7/Gr4DbX+rbj5S2+38nIHR5jAtLYbdijJvZr0n4uh2HuHbnUwVeYcHBLdoFfqnFqDfyvyyDOMfFKjIKh99c8L3J1Q0XoaEAO76maXwHKZTt2iA5m8uudU8DbseGwymDMEEWUARygaw/M41XK8A4cPZfprpMKucL8Eafzo1HzmGXH72BWWPmNAMehZySysv9KpUVKubDlR+X2/ofQpde9gmCulX2G5ZLFxYD7wS5NuPX4aJBg9Uc5AFtjO4EWb6W5BugH/gN/YTkWTzN0Je28Q8t3zK7X+UVIKC/T7qwPxh7iWorvTSbvmlJ+3JB3NkCRifNWnDZkY5ToVYRoSGuPgpb7rEeVGBu4KLuti+lxCT1AsJtXpcESY/eRLwd8sKvDBsWYkyCsmNtQhOXMr7WBeWlXESMHRBr+fOkkvh66qO+C/3DCgvAdCopJWNiHxRwg+VNr2glHhTI0YzrxtlPaAyYi1AlzXxGz4bRZbXj9ohs2rN5erMDzpLus1mnBlhkZXk0SPrBowUehfbdms3m0nlf1nAEKOwFqVuVUqCth1tMu1aSBWXEvnBk+6HmiwArCmxan+C8DQImX+S5PyMxjosFY9pqKcQt9lwO3QwxiPimbA0yzVGAs3LekecqWklelWl4ARws9jHvWY3x3jGAFNWjP5nNg4RWlHl/eIUi5583zDzSNhnrhsWHhvYuL3r3tzWjXHxUJZnI/OK/jzHMhit+c4VsQ+2oWYcsJJbpTU895+XUnQwSOg9iLCwVk728bPdG/iaHQZqm4jpyL8T3EVuywuohYAb2xazjsXHcw1Rtaz5QK5SMHOwsU60tDgphMYcTKCpRXsEiGZ/vqRmPRXx3/tx265zOPaJDJ84WpTZCk0WTzGw6ETejPDyYHQVLfPFYAyUIGwFUPShPPUXMD6tQPq6ZcbCdOch/nl3zIpK64/o6MeUHzaZOIG8Rqj61s8rvrTwh2UJAWoZtlPY=
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