Wad7P1+8RmCCdSZLl3oFGX8rFzRKrRG8S90q5nyQx53KkTgma0GnkOEWPS7W1exbZp6Iwbv6ecFxO3c00ttduG5TklhcL31C+67fePIiLD3B6WwUZBmtM2ORSbVal2y/qQsdm23jHx9OPO+8MfJfellkQElUQG8cMqy1g8knRWsCWXgVgxWgI6Hkx4bLiYGnRe2AlLmTQ4GW85piajHsUz4fHypngZDdNR+ZkWoldUxz6HPkbhka3aCwJodvvJKRmLJRjJKhPq4vzRoljrzlqiGdQjHgBnmMhJobd7lfYTFIiVENneanx19rqlXhCDHpl0RJjau2+Hxpq0xxN2c3E+6OP2ZaxwCIsDq9s4DKf0xAXUiEK/lo+hqBv9UEfcNX5wKs2urUI2UafEXquem/55chQFi+c/kG6qC8UXcxX68jOTGgRD4OOypQyEuRueNZ6WUrPRm9UGjISfiHURSUSKZbeUmhcSan/S/arGs4lFa7JphQPPwHXDUmZW8Grh5WNAQ7q2M0mRtFGPx/srSmxqKedCfg7c9pL/gRkCrZqENqLk8huvGPqrvCMQ60X99AtHqx+P72IReiv9MI81HdB7pU6o3iSRrU8jCEDaOhYZY9M/0lS3d9aWnUToji2SMVDAXlvSyTdy8tyUVW6kHLv+3TxDbG8vDZzRSu7TH6LCpGM5Jr2RRNwTe2SEyaQrpvxo2xVPNs/pgg7jGIkc7C9h1hKWe40GlXjFYLyrPOlk1kfbP3VVaxfYRVCQb/nkJGBqNL/k2kou9JfvH5QVGHtljAEi1M/qF5/i8B1NuQPKjOb2R5ihxcJT2TjfCKmn2svRmpgcH+VCADRAV7EIhF2KpwDXWPt4fyV9XTh5C11P5iOBRuXcQjC2V7yTuG5A5+PQudsT/B2KZwIanrJRSXPeNN9O14pUPLDyt7Qmfw0NUcSL8Vl/6cTjSsGz/x8rzPEynJ08DaXj9N3cuXrsSzsuCEEfKuSCObgQD6kZCGmE8J/LCYRpNRvOObfG/EEhTtIqeYDYEe4cDOOwfUelVOfNzqkJWPUuKTLuMPA+mah41HCVB53gs6k7HzegY80EfNV7zY+yA8HZXdyc/48ZA0A1x6UBxkYQLJgcT+n+bc91ALgRGu3zw6O+OPtMBgEYM3QYv3mEWwaUjT88GGtf1+mE752BoI9qvu5ef2i0iyA0vzi++Z2DPkod72vgMTZZtkhNiuXLXgOg3pssJDSS8Oq0shMDBEaYI6seAbWNQs42qhuOGvhwR4a7tLBi8xb+VcLSBtsdzADOdmgbkpbRqf1+Eutst0EtdtdUdCAZgzmKRtl+VXF/sY25E0fzJVQ+Hq6/rc29h81Iy9CrhXfVExjS1oVYzfz5hVpA5ORzw=
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