K4RrNBdCQhRavhKoT8r6Sew/nKJe3YbGiVOYfwGUe70+9cMQ5zC6D/CtXVMhElQ75LWvThO/7X9KXQpknjAYxZHuuQF12Nencw6jAQQyXwf+z5+kdD0mpsy4WvR7AvKygUWcpNyT1bNsDibzzAouptiWGn85kdPhk5bi3Ziwdikq40lEz3yqZlNO+VekuMEBnjx2QMjXv3KLsZ9mrZ3ya3FFqUKZ+Z2AuuE5XFISc/p1YOnVEZv8qVn0DwhqmIgTEMFehK2CtHLt5Y6zfFUS3ywh0tMDm7KuQV/+Gc0QYr/p4wBPI+H+N+RtVHmqmm+1O1tQZBO8bPt1SdWg899Swbo414KzprhDmqTjLhnM9wsFxdZBgEXIJw/BVwS4mIvlZbkiO54F0DdPs/fpR3jSUVrr40Y8e2hYqL0ckqoeVtztxAj6L6KUpWqp9HrniPrEFIs2uRsAGYtX9tgeUHQULc4sQ7ZlY0Qeui5vPQSHy4IMLNzmBcFIsYgjVe+pFQwn/4kuh3kdPMEK99lSjTuLuWDAu8I0YWVURgJG1l0n85zkvzEtepeaeolKeUFF7okuZybpvdpLhZAIBfhzIykOn4ujWHf2FkzLGl608YJyxQ3xjLT3hlZ73uYFSgzYt+3cdhH7BsyonakJjkiLGI2sC3L4mBP6ZFwzTRfmpToMWpPTEQXePwgT16vAR0CM3BPAr6KGUm7OPZa04gNg7CibQnWV/xCaXDGLCyRkWaeLTnBbHb5vWbSwiwbgzGJgzTWdyy0GHFz8CSu4rrcqRgAf7RuARQU6bQAc6Dhf5dr66fdX+yDyir4EQF3DBwqQAmF0Q3RYf0rD9pwhOQ+7GZfgDB7ouKBM55G6RaSuaqfmDJTLJ1ck6T0WnxUMbYiCGX0xZqCwmaqPD3pxzVlSWuw45yALYUEaNHD8fs8YKEtQNsQ3TQJjg76j77bI4zhPyeezSIcM3mBndAa7B/wpiVjh8+HawW6CEaEN5Bc85tSqtaK+KLWBpKEQunjcZ3UBhYpDh7BRdh5J3DCZlECGiITp/Oxxe9du4rbFH2CzAslFlzC5zbj/PzyOk7qlwDJ7GPb0+paa72JuMAQrUL5MZAl2RM08XuLX876n2kT5TJ3Qrem5smJD6ma9zpohBW8yg3ONfSp2sce5PO9I9hTWZFcefT967CBuBRe5IQ+yBmQEaiSR2cEC7l58drLIO5xbNht+R45dNDcD24g/K6EUFslD0DcE854hElFiaqQNr+KMQ7COSly9jeOEJasglK7pM4mCY6ZLBEvloMyahi7j4fAgIHIZUuEoWspiu16whZJrXx6Q88YhVlXQAazIMygQ1pGkQSCMt5FPuCPfZZTT+M/CxY0iYYiprzmAs/ytAxM=
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