uMe5giKvv68iCd4rtocg8KAqDXj3FuuZsIjbaLZeT9648t6HQLxcJnkr6eUjk0+sDASGb2JfRZ9kfwXhH/0SJoFUIai8b7mYsMn4Ep8DgkJenGhjrv6+tHaBZkr8yHsVy9Lvj3z00zBumHLHMjq1aSyDY27B/HppPataGEc4FzySmrBs3NIQ8GPLjvifIaLubkJalS1/0RHyQF0dX6uMRXhnZXwmXWeib2Fqdmny3mUYTS6afqe4ZhgFMRAAHbhJtrDtZwLCT0JChIr8toEOyZL2Cnvp005CvolEAtfveAWza/dcShmlKQaqyJZYNe4EG9+57gxkhxgTlVyDS0Wz4TwmkowEpwCMMRci7fB2ULX/ulOWDdH1zsyun4XkvqP5Cv4Yjh86Aw5Qv9NXMjj4D0NWNbsMIVOn9QtzV27wK/Ort2M2/zOKMwIGFHnoaWHlPqEDPi1kj25i2ZRu09Us2qTvc1GHvjgsn/9pxuA5Q68qJ4Bb2YO6CYcORCwKNgPL1boA/EEUxEse4XYpKOcQsnJjvk6keWeafj8EsSr/bXi0vcSeP6nx19RpII8aZu8S1jvlEELVmRaG8pGBE92Ehy0u1/VscEnUXYZ4OIfHICsseqrF1lUv/dVkvoSlwI0xjAq8Up5cvVR9QOdn/b0v7hIIqWFYr2vQC7m2zKV1eUpAEhjSv/raeRBA3Lrqa2SoKYNoQLIjWzaW1EM4D1QXa3gp9GCmdSw/pl7ap8boZslWi/KqMepuWaW32pWgQwe43HD+iSNH/KVyZ4nWBPC/EzlJtpZmuJayubA6la4dH/YIveU5QKjsfiZfcDoyMq8O352u8yFnsKOQF7pA/VPaFQdzGHibRPxzPmdE/RyfPYfCJNKQQXViC6yOw0MTMVtBuzu0yzWluy2KUVEmxrduTyZ3EKCVjcG7a+IpRvb1O2jeDrUYMqexOvj1uSszu2sCjaWVw7ZoFHQ8GkHqGOa8A5bY4CoIkfzCck2VC27oEvKFy/RdXn4dmhmKTuiNALOzxaKPFtggA63ZCFhnYfsJY5HY2TAby5IiqVeB8d4M3SwQXKujmu87E0CwVsWyAcuggukLQJdCemNwugQlArgB+T/FAan6lxrPDXKAEbTkDADAf2sY/o1SbRdxyO0WScMHGXOZEntMMR72m9L6oS5+FZ8G6dIfM4F4IQigfb0D4fWivru5cdKxcJXinEh2amcsJi8WJqC7Km1BhLqQthU+5K372ug99JRi6Je7+7RdkQV7UBTDlLdApfMRq+pf5ttRCGyhTFLbIiFwV9FFdGWQhdQSHt6BRTSg0OIbHz5QQg61fSOaXTTgz7aYaML/0FDuR95NHHzM9VlZtcF8S6EQyTX+8YXrdVyW6NSuLEM=
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