SjxZgRnbRRxeoLmlEBQhlQxbWoxfwV4IJ46DCleoaUH12GUAt8F5SVENZ3GFAU1BUFPZ4w078fE4Hne9N77Sk1Psplr87kZ7dg8CjWsARWlbddtFua0MmsjgICgpyDLZbkOC6yLT9Bc9u7BHWqROMHGQx5hbEtI5RQxGLm5jK2C7Z6LWE813lBe3ac0gJb4ROyYRITlq9bmTlBU7fbONWV+2XlVJ3Ylw/OaNWurqbd+uqT2VnF37YRkPFXGRf+MoPtyPBn7Z3lGb6MGOh025NXTjwY+cV5ajMHp2OctqwemUlfjL9XwwGZ0Nqj+7ZFslayk85t26uD+U6bpc3+9xs+/N1AVwSz9qHPdCDOCpuQ4fcKkdibI7YwOao2K99fwx4OPAlmbAkEDT13USp4GKVv0W5dXArC/4Cyk/QYRR6N1Yu4ExHCFkgzswdQKZ9Y7bQke7xdYULoiQKsO/5eCANnc7U7zNNax4/OapErdRWUWbFPW5uPsLGLJI1lt9B9vOWSfvpcz6MVjcE+xmbxtuK0YK6DZ+lrzB2mD/tOyOSUCG6c5Jz82hKBDO0sChizMaakdjapDr3H0tuAanlWIXqbh91RRmknXPID+Y06l9xU6inAl+4tMcawr2W0CFNUZ0WBdksj+adqwCH9Av3VBPEotJuEiVRDioUpx292yOSXEaTB59vYS2XcsAIbVnbDqh1RCvl8n7y3zQl4XxvS+ASu+Uc9FZXHqJcuWQ/2vvT/PCPHXQhQiFi1Olyp+qM6Kw0w41drzvinRW+FnxPl1XoTsXLiT7bu5J2Cto2LKKi++EjwTONROfuSTo6piGyIH7f92giMz8ko/wHKHBh0TXuUrC3RzZuN9EHt6dUlFDQnaE5cmdN8AEO/M9RAcvE68dke7SJyrIudPsINPPaL6C58yTCdET/UtSyl5Ligi9hssZA8AidGmK5Zo4mkqzrz3ENLBimHkvS8cy+K3T6XQ7bfV9TTFK3lQFlbXvesvoWr84fxkvi9QOqi2iYDz8ufLlTXfLoFuxk5FlylnUVYgIEjRPVgwM6mObO1XJxEFDKG/KuiNa8ytbTAKOSDlffVh4bZmTSPRwvRFkbf5sEdbciBFw83zQPxm1HwkKMztm11l5V8Ui/jr90ap4yYlJn7tDZMmWE6jF9mACUgb7lvs7F7p3e0rxzBKV2bU4oAa72+WZNr3yqYL5y3Uf63PqV/MyU8Efy50VEmrp5h7E/dAwhxXGkvpzCzzPJjJ4X+4jH4BGT2eLiUHuKIcAqYy0LLYBUNp8mIwJnjHjJEMfQo/USm2QAiItw9mQHJdmjTeWZZgws/vP/BJwJApVXt6eL4Dq+tmae1vPyAthxBawexR3Kr45JaUFf9Vi+5kJeg0=
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