mk/SBwWj0Vfa5ZQmB3m2+NIws3gZtCS+gkWolClzPgZ57+M3FRCbKlD02CNSrjgqRb7NwZJjC0WXxa/b5qHuRaicQg9TIzM5DfGiQnmq5R1NF0L2+kA7su8WYArmUyY7C8b/mRpG01/EEXol7/2EokoqTJvif20T6iLvjQIKtfCRH1LaMxuRrsK0JdnQSq3taIVLKAfWGnnftuUHoQa1C3xy5mL2n42OYL4WB6c08jvBbzv4dtEzrmb8YnHcZVayWbqX5xkrdNTjW9lXUu6IUz0XipZNjF3e9zHLssK/iieB8AI0tB6X5mftlb19rV7QXiUg1jc69gWYuiqYdEC1rg4VADHVw+dJGeNFZlVgZN8NI/v+dVE7ag+/csnJMu9kVJg31irjyhRkP6UOfdHsjhywoPSHavNFDCY26orzFM0Nr+L5x2mB1z66d+/OUsvVPAGTVS5WHGVQ5NFYnHRFlMs1sFRgVop4PEPhV517a7auKx0tA2VuuDFsnUn02ALUxllaA0RlzBP9PcwSvLlKJQx26wBFIkLtwOag08bJXv77GVj/0WCUqG9WdeV18r3WyjD+B3xuK+duLihlOGqWwZlI3VIsRpAKSQE+XX+bPzPmwkBojnS+KbMVjOVqM1Mq/fpyWWhOX0aUHbHQw23/jn7l/Dh+h4tjyCW9U9xmhK7m6WSsqML2NZZn9Q8odS7uEPB2WxfIuNqP28suShK8GI+C5HcQ9z7XpB+zkdoOKmM8r5cyJ1rx86msmfyleiBRziEtntyOkx1Y9eDcylVp/tIDM5wZpuwp8OAqov4CRG3EuarIT8aIhWZMC/wEUS7OD3htAesL3gIEdKo7Y2B54OPQvrto7DsTTwZ3bMIk/TYhNT3thry+hDbKxtmetUtKY3DcjOzxAVaTurLCwj6rAY7paeTAqlZRGSll2gyepQLOErLLVvyHc6xXP2URJYpr06Z48aIPI6zfyrwcImPo26lcYMzjyt8yWNmbzXl8pVj7BnR093Gkkt2FhfiVr42L3ajMZao7WkIrzPpnPCOFY/ikmLlkOI2lBlMA0YbrG5Dv+PCWuc+TxPWjzDPLIA79xy7RhAb6PEII6VZhqH4DgOg6nXAYn/oQN4Tths34G19anY5IZ2JsFtR7zrvB/+8U8EvyLgXW0IfUCa6VdZq0VThxlTBAMGFXmCVNB75Xb134OUxo3YPzVMi5wM7qsvf+zKj+luB7GdGMNmMfclXf7EBn5/6chMiRzOhb/MPCduRb+TkUqwKh+k0FtknQCBv6+T9KHONcn0yXkqgSDzZ7I80KSOwpnU5oa+/ofV5EDIyQ0AHn74LvvLdbSVX0QtUah2VogC5h73ZV5VFJy1Kq01DX4JyXx5US9Ap7pRI=
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