rBFbysUY20n5acsf0eXmpICCxhQGMpvkRzfFctx62v+mqwZhuAFF5cebv7n5XkaoashZej9PagqtdIPzBEBaByJS5/8EIIfhYERImPFW98Vv4ilFx0wzn5/6D9BU9RbnRC9u8Lf1ajSMYL4SpVofSrIJEqj5xY4EZpDuLWvklrE08/els6D8usWKn6+0BM+CQgbzsnddrDqegZstfw81LLYJYYC7pIAkrpr/knTE7uEMdb1Io1ryjf8S3NJTaRNK2qorUtmNqVvN20XAW2fwXbQpfi7AVjKlCpA5aampy33Ka5vxFMhibrBHrJcUQG46I+GuXpceK6CkaOLkCh/0Ki5/IMwCOA+OUnxjtMBbzvz35t1lPfMVJGBfmCsLKTLrdrHOwN8zGnooBo3hBM44e/3qZagPMRBiCZqYDDEPzIvP9Sz4BuhdLBBGdmER4npvOevt8g00whY25BVioX4GbJCOLts7dr3ygw3OZcYx63d16BGsUF9+8iwVyViGZjeZnCJPamGM0wF4MwcV5V7O/+3af8nJVO38tD62tDt7mZyRjvq/nHDlvfAQw5CXYdzYStnojohtDmYIH8bYTPWANbtFnoDYFlnhM8mmWvPBTz5jDhBZzWIHXLzZoncu3cKl7bnw6v4QlJGjBJUti7Q6tz5fg7LHgZEZvAo8wpw7ZS+GzLhN6X2XHQh9bxbPBudAM5xug2SpyNMRMWYm26tj58GJweMOela96RDMNnx2obRT6tWwse3EIe9dkwnytoyX74vMXze/ueR1B8dikdjDAmhFyB2ndZno56GsCVdMOqCL+sLNoH7BrUpLwNQkJOhTgGbM67bAaIduAkWFsOenU2aES0lq2UW5cnb0hPkAt1/+vwkQcvLz+LhmzYgSffjb+hilBkCc3b9VKh2SOWabQNSAkGKpttsuaE7OH8rpRIVG8EnrGqi+G6eXFVAWZ2Z0MpdAODgQagVfZyk0ENJ3WYmGneKMSP+TQlzMyhZUJIYRPohwiZQfH4+s6eevYSExJArj0jy0NHXoItCM9rFp3+gL1SDxx99tzlQF5x8FQxgqM/EFIkxmm1Ry1BAAAK/n1rBblmKlE9Ud9I0E4a1D1g68xu79/gZr71DZBrGytZizf5rMDvD32K0VMKl/6zJlkIxXBdbDAQy70eGLpj6jGCM3FRgps/TCo91bZb3ApzI8aZHhrB8rmG2IwaKZ38U0OcHON1DNtsUkhjG4tRemJ8QCDLOJa9QK/Px5gQgNsrKwqN4qLWSXgzXTRMHhYveB8qyobz73B2rI+9cnztTjiiD+FhNtfE/xP7u9ChDxqkNshAa+sqhoGZMnFMdjqtoqrzyC1/tFBNVbGKUJytftWH4QZjShdX1N0lKR/2w=
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