SwLPRsAKe3xRA9GY67T4WwChHw0P5dvjghCxkY6eBXP+QEbAKbUqhMIXWr7H7CVBgwJEZDiLwzERecTM2ITJ/gty0Xk3LyWoNCqUHW63J4Xn3Zj520TwRb/svb3JEt7g6KtBDlLbCUg9cMGMcWKzlX723sDjsYRKVlS4ZZaqhXnEh+ohKWYu6rS3OrKuK2pVy3EMLgIfJvRaIlB/f6f+wk1Wzhw7i1Da7t3u0Q4pseC2Dyb3Tv9mJf5mjFIZ0KksqIV51JT23QySCBwDckEzR2hquPdjIGm9zRzWqOiGPrLK8VnI5IxWfeEPzZ+PK0doRE7RT12VCuUUCAtxyqy6emoV6u2132Bmv6N99Uqp9riDkA3Hh6GnD02zvF20QOpiTxJGHwhDIrDE1MwCuB1Oyg1X4sZcFPD+BMryJtTkn2Vdf1QzxJKPRp4zKCbvrJNQuDcoFkG5zuva1p8s7/CW8G8xpit+Kder95H8ZMN1l1moT2N5LvoF84sa3ID6znGNImtKaA7ygk19AuMSeD1W0D6kXV7fYGuO57Ybde/B5tpamXNc91+9suW2AYrNKMdMMJ3ZsRQJXfIantdN0p95FNRssYUAX8wv49gf5XkXZ56yrWEPHlhnfUfmbrOFaGv89UYtYpvoX4lW4CBYfzH5oW7CAcJAtscaEJjb3GY0vfyDncoEeljuSIotMF/RS34wEkerbr+Di4a66SlTb0TxyuaoqY+hySLm21pa3jg7tHF33XghLHDLE53rAkqrRfvjXh6wIsPKtODXntwbUzKEV7CBAcJPXWgwPamXmxBbQLcwT9e1OuNGh1wzJAsTfS1nOKK+cCPrcVnHtkWHU2XjV0+cSaGHbLkRkwvgqyw3IWKr2uW0Om9e4hFfKXmQfT2Rx0HMSG7OTLh0+/7gZw6kltfOwvtu7Vrf1zm6Twqm6tN/FZzVqDDgyGNyKRYi//OyaIyccy/mf/RSjBdMjuiNb50mrrUcyhiwQSkL5rB8JXN1s5i61ckCIXwzyLNBJY6ERy+aEpnxKDVsGHD9Rup6SdgnhU4i3Z5UZebyjIYMKw8rbCKfa+3gF2F9CyqrL7b/4jRj3v526NLMhGRMt74KQUEE2sfdbbbrVBPvavSXyQMG85eMSP3pAkT463PiDoBqNriyEEgTgFvEc776a5cGJ/aaAyTqVgD7ysI4XB/Q40VbPUR4OX52TzpA9lCHCgPvZ3JQC72r+WmqY/jAUPZmm7NGrKeHrPM1O/INXNW1rv1lYJtglYxDetjM8no4kEr5UPA7v8XJGMJg8+ZeNBGQg43/nSxW6b78GTlMt9ykXLu9VYCfsBkaal3JMLVKlD1oQOpFgZbJYorYfWcwPvbsqb1vn6JAPw+mMggJVDo=
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