k96PiBwZzjn5KAedW2Qjc5pGYwjv0wXYqDg3B3zuofP/xi/S1NcZ8PARvdAMpCPThphtvm99UoSbB2USXuZLy8WvJcnutDEuRJOwORwsA6P2MmR0qKwqBA2JuqmBsWQbz0I30pt0PrE5YwQzNDYbwr7Em1FsM8otidPVpdNuuSw6k4HM0pLgsh9kTEtbhB1zSLNk1SH2Hjn5ogyhGWsILxuEGxc8gwju1iqxnRaNEum8tIsnS+1huxUe+2zOwIsDtrBwanQaH40K2CpLkz5G+85Wb5pXVN7bTOxd58LgXHIxdOveJ7kS35OXg3l5uOUcigxR1cFN5aq5Pm7e0FUgkiq/U+L/zUpSI79oCpMxxKsojBCYXBIdbkfq+bJpxrC+6KZsZkW20Kzq5j6/tcogCSyLkO9HmoJhCh7Sj57QXbtSPk3PYCj2SgrtIGA9FRXe+PyKD5f5oIvU1pEwrExdlIV2/FdwcsOs/strpUufPraiS5P73xiN2/3Rz9OBlE7dS575L2li8hdIefhdiICVQnQtjDXQLrI3A09HdLPhCThjBQDIFKg10ZDSpwwB5N0AMdClMxzIDLH1UsZE0WPF7c87RdJQWYG6EYMx/Gvpg4+cuMK4PdnY5o+8yhZsKUNvKN93TXq0kxzsbxBcuX6ESOKTm6aCOePuzQsuNE9j+AzH1he6yHoaW9nJsIkRMtEdAJB4u4prSZrbK2+K9SzeGz5+8dTmEa8RfHtAyZ1GC9ea4PELK5olQ2zfORacEMH8pexagsvsUhwuoKtyu0QoGXeaeQJPq+1xnyk981SLBy7LDQU+fVHjjTTL6RhVP330hWmjqZOMi2bFhdbYhmRCivclAmtJzj928RLmRk6yfeeojeU0mvWjk4ePGbbhjqVUfAdJilWVXSX19P/vRBFfnnj2Jvab4wF4NQP0ZtPrHWlXRSgnxYF/x92iiuUKaUnenazKgVcTpxy8UzMdzT/dKZwIl1UZDuir11djKQgibXRHnGtyVDv2NRx6PmQKfObaawmkZw8ZrcdP88zpN7/as9Cp7A8aZNqnOcQb0y79/o+1zmSOaduhJsi27ujsbzQQn/kqehAUqREa5Ue7FeYiHnFbVGsz5siSnQzUWtrdO0aegx4MM8CJV+cM7iOB4bqk5x7Cu7Q3DfT0qgg6adl/Sq7rvqcJzRpFXC/SKZbgLiB126KUfbfDi7znKtE//qbByHAtC9Jjt9qfAxFeWCKhplGOwGcMToGOWkuCQn46Oxn7BODKg9istd3WAiHmxO1kmZ+yEBGebMldbygreKgfraTvRVAAtDdHLlSPf5DuO//d0/9SSHjd2rI5cBbHPWMEeRmwdY7/AnFONHZl/nYmiC7bvbQ6iDnQCXKmbQo=
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