bK8n1ZhQyafJMnG2zlfW/hG6k6RbxJh1R5jPWKEjdkHbjl0aEBaJ9zI0wwvgV7NDDv778tP9KpV4384u6Ea2BWxrbmzOWi5Rp9VUM5Gr+bWK3CF85TtBBjgRtGiruVZvVhyyasdoY7tSELtDKu20af5RHAiNXbVf1/F38QSDnzf9rj1uwqrqZM5tSiKZunHPux6HtKzgtwPswCM+d+yCDcaEg2GcWh8oHZqg+EbR2SXv/JseF8fSz/5rnxwILWORVQkc1CB2WcmQiZn5BHB30BzSgcaS5Sseoz/KAPlRZlR6NaFh/sGyBoIDIBzDNAhMQBL1DZwI9gVjcIJlcTN8s0yMZZsru7jMIS7Qa0tUaxDIbMMXhFnbU99Fy/qajPxLjM4PckG3kzuKYgd3CVgEtWxfphQphcUFf/F1c6G2GACJCh/VkjGGYFOLYniqLolwcAdCLLXK6eFxaGnBopBxSrhVD8G2upXNMnxiopzv4jx5Drc70rmUKKiBwpqkqr669ojp3bz9qnnCSm3pBAErTeQ5QhMlLtlL0oM1hNF1IBYKZ1QwgBRLCjJ0sdiNmeLPHOy+ZgVX30NMti1ROt6tcCkkV66VDO5yWd5fEC+i38s3maSP/4ckuS9x+TMYFzlc6qaC5scExglTTt0BDR1VnnVF4QpN4mp845vdizq+zhm4Hj+h8uPYGhBht1qquRSNGteJckxP8s8MbJYguBlmPfN/30ikhBuPEazdVI3oqwOeu/13BzWH4nOUgna8fNO/ZUrjJZJJHvRM8YCzSkaSM4fNDhmYK+bDQWeK0edGR1R+kMiporplxoir5tCW8J5UgZc0q1S/YmqA/MqJd52YAqlTkBZ4WW7zlHZN36wXZDh4HKLRsVSti2aABRT/eSheOo5zx133MfD9zO5LBX5Vsck75xG0CH9P/rIHACVEKZ3FADHT3DL3823l67DIg6PhftUiex5ePGy0XaLiPUNmy71/E4NFHxSAC5zV01Smel32pI2EcWZnAuUUcHkBaNrHjrlidhkJs5ZX/W0IDcvd7OMWbjhtaMM7iuOOjTNeAl4f3fflqdEZaiFfYMZUD+YuQROnlUHqjFAQdSi8srFLRbEolYR2gCNbhy6+P4qLZDARGX1cY6G7UxIcnuQNZg2OAmQ1GqDLuKbfN/DM7Vavv4uf6o81e4WbL+1BBMnVJ4qnu2dHnBvZXV6RPaQa7EvmEwcyO4vxwwlB6YZROGJx77MbeDmxZRbOvZSXyeQ0CsGXo8ECOEsniuKGek2r8Bv0FSwQdK+oR9xPWUurnXhq5UA8FzICeFDg9/gSW4rO7a47fVjP1Pei983SxCyFog+LTfgY941b32W5WOQXcOU/lZB4yKRGtysQgukvOott0JU+gr70C1Ug1vpCLfEhtCUEvaF+lr6O3eiHouO4PTTeqR/9X4PUxsTAte1MqG+Rclj/nkjoTNEUK9gY2RYNhMpbKoI5ZyKdywud13EWMEBJYJHv8jKAYHmViKgX2JQkmC70aFFvdv4CTf5ddlYLLV7w+H2fAP8wq3ykKGRKfX8ckCZpwZmP0WtSwq9roKMIWlTgnW1T2JA2n6QEW5rezHWO8TBBWF4yPByvPbbLXBw+CBoH8XjBIZAerFOkcKZFcOPM+rH1gihtqxGH8E0ALAykrOQopSGROS+MXzioBGVZJQ2ZYUc6YcKgBn4mSa5RgKp4b85MEcO2A6XqyrM=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100