+8q6JkQa/hnr+lOBvKNLRJded06RLPyRvRCZf4qywNfgbueNKpUeNhlu9flpPZgTJQowrt+b9l7gpKOY6N7uo5Upu7/VAvYEd5DUL07dBWRbX0q7MKHCr8/2GhpfpDCwKh35CJ7JlkA+vy2X0D5d0/JmUC98/cI2GwAZrr57JDBMoAQ9luzR/muLTcPbbGwJRjR5efi0vMv6aaTYDf8ZTb68wv4/6mroyvZs3/VgUyrj3w6EcTQ+J1p5K1Zj0cvX5S33JH7fX7EZtCb4bx0ALf5EyuYIEZvbaHrcR8tu8vIFJ1oiHf49HPhTSPNGn/w3N7/1CSSUk1z4QVQkW5EGmkIZSGGp219bi3DrOL2RLiEatGB9pwimfthuO65Qa8sOaZFzxpArdxQHWPC/8Dbs9KxdIdb14yLjLACdsbv0+iDemcnrjXtlC6uuHcqMQAr5K/VNt52XhfG1WeGtd9iMnWpJFoSUMCOuDCc2OriQx2r3jwYAxHthRrDYibFZsUoUK9bw2oZLMCb454Rm/EKtK0ZU+La5RKKi42CIJU8iJ3yGXF8+x2GlsU1lD3vRfyetFmnG47ZhvnRYX8Ral+5Ccxszz+QuVip50jGd557wBaENFU5rA5M/PHQoHFWKG/IJL7pblvpihSWex0lbe3Hlm4Q/ejaerSbGo5bcEP0SMf5lsxkpPj/N7JabSm7AmK7CEu2ChtlC/SyajnCE6Y4W5YiFGRbcG7J87v06m7pCKruOAoqsrnkIb8C1WQFy2aZUjnCsMb2QKStGjfMKYo9QXrs9LLOVwj6rJtQfLZRt38czM9vmMNJ3uoRKxcn6u7vhD3+4nP9B0DK4SttOs0J9wzkxfbisaG4ROiZTJW2Jh3AQlM00CjeJrdRjAifUhIEQQ0eJny2TLO+Gz/uHt0jKbECJmmXVXLMkLajNCfc67dBd7KsHL0Il0lj8SeFRFhlBmdZV+VgJ2SIlAKnoLe5T7vrG5PrCzAgIxGzENC8lLK7bANmaHZHYP53BGsBOj1Mz3f++oIfDWIsZV82VrCrjUQOjY4wtQBUq/V32+hRX4B+rIYTltsnowQWNed+KI++IwdfYdTTXzcIvaMex9cTVq44UZjBHbjNEGYetdmGjrnyS3RGIY0SZKadE1OhrwOgfmv1qAwRRODQ4yJN77VN1Mr84YNE80F8eoc/aVuQjiwDU1JErp3JSBh7hCqqbyGhKgJPs6fT8ME8Yx/bcm5IL+hX+fQgxrGK3zMiiOfkzK6RP/HoShBuxiv1tpd/Zlc3U35fzXzUvNxgmxJ5oybsGcfKDS2ieVatzQF9SlwO05HUHq2lz476UPbx/0yoHoUZX/ZJooxfWw0J6Ut1O2B4C2bJC/oJ3b2t5eJVKj1c=
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