ntw9OUF8rR0XLLlRIcBU0z9x182QGIWnS7oByGS1PzNiFDplnjAxR4kcOJ/+0ts5gD/0jPifV7zQbamMcRV5QjLMTN2V+5HTjdaV5z0g7zIi9CvjyKnl9h8rP1sG7lDktUjVQRQnrRyvN7iyg+KD0kobUBHHlqiisLVwbXVIOzaI+tV3ri2FecrSYrHCq+tJnlFxJxmPAP+eFBp/D5qpBv+ak2Sm5sRkC/oolAgkkofw2+zJ7ph5UyTLphwPF0lzOzwDs9MnO3WTUNiUiZOrN9J3ykHyoPTKEXmS4fOqy9ubNQh+Xd6WO/6lvDqRAOjQr4cedFhFBNzTw1+OhZU4XpGpxMqLBLX5y3LMic+2EuJYWvcroPnqVHUQB29RwdsECEsGuSHR+P3TP3FgmmsGlDjgFBPmBKN+staYxSp3NgHqwKai4wAr6rj+GCmT1CuU+SeMlmXZ0hAo79THGPSo523Yf4xcWpplTlXmkBsrLpN1qcek6dDeqE8GR14KR0c+ZkQNGkjfe2tEbsApmmaV24KyIlv/VHxLbjiqt/FdKEtvImoPCknMeRQV09uvB5OJZOFoCeADiGSkkerdkhIVpdhI7kiy7Yx+X208rM1VnXSRaI013APUWDfJ6zoxQXCLOXIvuwL91wtrV/PnYH5ec/6ifleHM+/1OLp8xUQb9ib8N3smsAte0F+DRBlo/zA8F0Td2pCv36clGsFP10NAy7o1m5kGoCr1+CfBAHW4fxc9WPNxBFsMcPuYTCtVGKsT8+feSVy2s1tdVXXK0Yv2AJzYMw/zKVYm85PGURwlj0/kmBj0uE8zph7kqS6/AWbqOg39rFIwWfU/5J4OG3PELW4QHF2X1l3R4vvbEnr1zNqFHpKfqif89YWMnlclKvRNNZsuo9r+gA76CRzzxfhg9BELedWszNrD5PkTbdKQgqeta78PBj6ic6un/6FDz21apGFHX+6lgIovcMNsff4qyubuG4q/MISsmAEQb1sHBQiEsMkV4dGQYGTVOChVROG9I5X91HTjttlsKxnE8U/E89VoFvjB9uq6mBQE01pIzOePU5yNKBorVCNOAYvFPKd4QzsciaIKGDtIbSaWDhEW9aGfTrVSgExhMNSLBvM+oI/STPka7gG+e65uAGoq0KK8b2RiyNZw5DlWzUMei086HpzundUWUacS0ar7P6PLQL/edPHymEyWd18WNYwxSTwzyRQkQ4BvbTwlrARtjynSTmHATIB4yPfcNSi0t5SCWzMiOfWc6jpPKoysPCu4Eu/xfNmZxq5gBkAjg7pibY1tJqYQWHuNz4oowCbXxh5nD81rXgZgQ8j63jauN23OD76qyicMNO/x6c6luA8fd9umOI8IF06v2etXVCzAyr8=
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