RfiDrac0j0OgRjNmmsOpOI23BAdHkbJ01LsR53s/oELmxgqpclhrsoi3kYqgE+ynB7/9RMkGpL3D8fcIE39tOvOuxay3zAwC4zhZPgVY0PILXoVBAsjgQIm1Q3n6uYIlkw1J4NIHv1CMBd9UVwmJuBW03UHLqKxEKvO0qIkAyr/xzf91Bj0GubAWUnZ/4CWLDYgg9RqhVQXeq0CAwXbmfjet70D9dntDMNZzL4B4jo5btmwwQIrc0IhWeEh6FFu8JPWgQ2NGUvgr1/d1aM5K6E3elfhf/FVw5JuNs4Yh3Vz/3pdGS42L1lI6PX/AY1UWU+gCfg2cLnNNlKyq662o4wMQ1sBxDtRzu4HYZrl/ANeSEiPxKAwL5gW848sqWmxIA6nESST0LSYN/mbztKJzmh0pQhC7dco+WQjRnSmB76M01H029XOJFQ17PpTGhfvf+lfWBtWSpNwqvq/c40nfLiGRe8sdct/sGfzvmZpbc9aWitkTPJ0mjlFrJKXtvuNNQ+y/A9ETLrWvBt7U9zLLmSd+HR1wRhIB6Fp66wfRSXEyrpc895BBcDqd+q8utbX/HmvfnTEfJcBwgc4HS2JtagDsiwBBiYhpX4rlylijcrrE0K25TnTkJMDwKxQtKQ69bHNELqg22jS1hfW26edY79p7WgjcMFczI6eQMFz56F2HvAB1flcUvdRLoDTnEzQ07XOlvB9NejNkZUHyHr6/JfyUXwDAWNwctKit9ChQUdSDMSI5Ie3mLby9DpdTJEfx2iRWhVoKA/lbekiydRWOJPFTFmOBs5FmCTQ8Mi2FCSLi4x9y85JW8FnNwBglJTUBNyGXi/XHr1Fk/3IrtIJWas+L4hVi+enF6dHqj8ot8qIMzTJtzCZSRliI8Bwi3nWy/CkxePqP6xH+D7CXLOgrHzbU9ua+8+g9DpnmwqdgtOJwVoZ4tmlzg1kLZrjsy+d2d5dPe/kLOQ2DXeDqadeaD/YvS8yqZicDaS4JEqxTYQCFHRRru/XZbMQ0gm+s5+a346s3NPOHaSYnZBmZ/7Sau1kZTu8W80VG5tv1j5TsWXclH9XYlm4U7Qo1c8iGKZJ/asbgBAiYZIDkvV0DjVA2rQXke8G0otnKJZp2OhWsP90SfaS35MIJFaHiI+54k8j2YWAZDhyr76UgiJ7pej0qF/vG/V3asScmOrSKhJKdQxOlVd0Th4s9Asg2/6OuTK8Hu7zR2FWHXluaRTmAZaZ17ALwsOp9VUFEjvF0WptL5b6kdA+V8naezW+H6Tn78RVv1QanASD0yHzTZDjLtVmCFWqtlIJgsyi0PWB5ng6EiX28nQ8n1DzRkH16bRPMrXP+hz7bLYoaog9wjqBL7IEyTfGcKs/oENKI9BynhKo=
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