rMk81vv96/5tVGp9Wpsg8BbK22p5TYG6gRWQnYOGuF9c8FyYJYi8SGxCkO3MJbf9MGHWpK91BdRZnRi88HHcC0Qzd6FWGhvJlW4Q1Yfs7R/7JgASRyu8VYmQs4D2zGrBe3SIuFpDdznE+TdTk/fbJoYUHfCLS7bxk4RV6MztBuwbz8L4D0+/GBPMYkv/J9SEvMVficHq3amv69t8vSm46mY98ceGdMureCI1Z0nCLLwcplhhWgm/k5kZXe9S5mxVrx5Y3bgk0G1iBAHl/pMpY0j3SMURDjAiv/W3GEzTre9teUiFFZ0KlRK8KtAqygGdt2F0mKedWrfRFmcrCkzszUE3kTsjhKn8VagG7oYnK7cST7dU69/lAsdhtb4a3AvCvq+LZKqiv2E/LotcP+xuRyeJQbkpKObL0O9GZb1XsPr4WO67NXy7bUyys3Qe/dP9VdiJ/fJtRspCVHDo5wU1yWOHuLfbL36DCAsfrWR1ViPstRNdb9yrt3pmyO4Hi8CGqBvR/DAA1/A6GB93ZKlaQCtKExVlAQIcgUDIL0ir3rirMrdYnnuh06oICY5gky3vplhh/L3cAXVfr8Qni396iG6VkBtPHzi/xiHYgfJhZ47a9gZeUSUtUttGW2uzlyEEY/g/Z5FuBShFot9qeTF9JPjNw+YzANMA4DbGldBEbaXEhkqeqQrKKAOos3rIdWuIRWGGhoWdVogm9xV/16D+Fh5kxOixMhEp8NYhzyEUk+VnEdP4E5XNySRwPalu18huaHUTJfUQn+S6C2aQjioFVHuXL05Z9pQscgwgS3oAJ+Q2nGLr6Qdwk72vK1DX/7gzFm2XzhCxWKrXNiwmVriKb4YYGQ7tL260AfM81ksA9wQwAzXbkN+F/otR2U4A9b9dhdyBnzowqOJkN+MCFt3maGdMeCX5ehCXHfSWPBKTe3EGVIGKJevHH4U3uDWB1jQjieRktPkNVSleTlsXJ/lFSxJ8L8sYlVdl6wLXGDAI00gRFXPPmlJteC2mx/FWKHV+ZSKz2NgI7XqjqtMofYmMRJIOyywmZLh3QLtS+1KZBk/Xa7mPouuTOoTxSH+H1x+2qMBtyJirf4pvdm4GdIYWLEP9vkk83LjBmz61RLtfRND0l0BBAtJB/UObZHExnEAJBQmd1qrPrAd5h4sGIlJ0bKgiiuPWU/BpiL5CEso6AI/+S2xm9VwpYLQAENZvkdBzVsiRSt/mhBIBx7dWrucNAbUTjKuZjK/O8H9/WXNWBixKZg3Bd+pkRdMxQqZ/IE/5LNkvL4Hzh/W3cVcx2pJxXTsBL8oiRq7HtxUo/aA0Nbb/FactsBZdMxeDRR7e+TayJ0JUxxkjy9tPAYMtfEXwkpGBUz/OZQqcT0zsVZA=
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