1zOYHUjMtZwwO7zFpnUaF7SSbZCvbNPqb6BT4vz1TLtECqtQySjSdKHMdvzbI4lq/3elj0guU4yeW4YhpIs7A3/l03A2HQBmQsSrYzWJwbH5L8SwNneC7LCtkcAkl7hdEE8YUmXC61FUYhdze7ewvnvAIhd3qJcMEygQLncJaFSZ2Ud7CbYrKR7AKtmz08/2KiUlMF2LLSJ09Gqpmub0tEOv9CNUVqT+eoSJaVowacFNAXctjPWKARw1LZGfGPapq0GjT8YImMR3DE9ht0roAYNAa5UDDRvrI/bEuDh1GfoqM2l7OPoJzzvKRpXCumJgq0RmVeEWmcoVojgbNwZF7ptXV6wNcMWwjchYLXT9QUIIH4VdQV4sL8WcmzuCckeR16k7z01AWxV7hDGuM0+46yX4x6e/tHbah5Zqb6+5ILaB7B2MGTeSDkrtJWUhd8Lms7rYlXxFeSbvGucN7xc2DV3gaLy/dgns5rpINq470BzqFUdYiZrRTrtZcjWH/hZiTQPVIP+RGsfcs0C+JngzLXMUB1EvdiTkfU6fli/fwRzbZCFSsIMkauU9nJhC5I2jx89Gr+Ll20y9UV+V+aIg4gh28HkvgTxe+0avpTztl5QTOpOf7vEP89EWNgpd0zYZ6/0GPzbqReIBtM72X0+f+2ujVT/7MmnJtP8rBKStSwsyex8u1nZk5miZHhWvww5Vzcq1m9rDE/dW9mA0f7XFaipdkdLeyg0aigG9so+vdctgpMo39Zx419SFPyx0M2b5JE0lHdhy4QM+4Xx5IHp2S8jNzdqGvY9ZVfT0dqzzPWgL3mGeg7p3zLzH+E7u56rxlHdJc1JNvEdAZwj9u2YEIVBDoFQveB/esysOE34k5+CaL1LTAwhbwNO7V9ci7Su1lzt3NxrgZVUJIP5SnZSv8xubwNe3W9k4ODXUIut4acjjhvu2ZdGnuCE8vVPXCp0BlyHqFObgn5tFtwQZvN5NG9EZrw7uViaVqqDdtmd9bxQDGFyjeabS6mFXIJ8/0aEU9V4ihkBmixV1pUicql9SQLHDRo06RfLkMNbA+/KzvehWs8UrIozizI1CNXojZafu/Ou9uZzyAxvrzb7YknBOogtrDshZ6iMELnG7+3qJkZ+JmU7uzRmLvrlyi8EeOSQ5wGzP0duKoogeW3ZOfueopzjrhw9XenBXJd0cBz/Gg3lcLlAfjiGSsyoVtrLhhBxsQVMtcWDU945bt6Sny93u5YoUU9lY32QnZi89JIQrrrM/fQ/aabfdDuJEzeoUZWffSQvo8kyratHKHoLQUOWLTkR0WoQxo0xLWxZK6b/ZLkApaOEN8zYEks+COX1Oub2Qy8tIoBHitsrGDGtAvZF2tLfK3JOOzpTM4o+8Usk=
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