bKQPSAPlX8SQj7NaLRosa3UvMl/TMf8wZdMAwpx0Hq05rAbUR88qWuUnl9d7jBYPnCSYnmWeAhpS3Qc518TbhAmdKGtDHoO0bJ5oTOsvLgatgogAInQUy6ppjDRSGM58/cNYbQ4uUIBa6uEDLLMRJeK0VCJnGUrZ4t28eHorIrq1xKcqOSEKfeOq3N0vLp4YD+l8QKTY727d+x4w/yQCljHIp33qQxOhsFXB92ZKqCFpETgdyMw3z9ImlGA6qZM66mb91+r8h9dRkUFoy6HTw+YtlgNRmMvrHlLKoURTSxyHYUMLP1AZDB8i32HsyBD1UteHx8thvGabRzWxxSqi4pBBVE3Px+XpqPff58+grp84vqFBr5zvAPmdcp8i0ueX/pXBZDiMw4fQkVL6RLrKvmPbnTRwPcYiik9/B8Yp4fHKo9xd4j3pf02lZQ30H2/Xyb0lL3rGWX2E9rtq4qMeSeWpAPSEqb+lMS15oUkhniFAlRvfaMo5T1r1vj/mYOSPOCCwOjENHljn3j4Y0nccs5aHGrBMclR3JFfLIM5zSIYyGbXpqVJtca08tfuS8GE6PyDcLtAd/k8112Zx1HHUFgl33IJdRRwu2qKPF9bA8dvQ5KWyQdsB8Fr07pO8TrsLBFmfecJRWxMwNfaFT1CHzIKZjJj1l7/i4RC5Y18/uglfjmXuQYC2oQrBtnkkCJALfFybglB8X8fE3ugOXciQ8/jYt5XbUpIy+MmIf6v1oSHRqnRx1T3GCNo2Cc5cGqin+g+hg16UikwvVQdKTA3s/Y3hWl0V6nebEjc+x3HhrBHkRxfbfXmC4fBUzVKgag1VJYfIfJ2PPoI2/1+gkzfvbzYgBG/h3VVvg1uN+WLrj0fi7DQks47zENhPEGFZcnd/KmUN+dzgWd/dMzrNKq+xYswPpqAF6oCUNT+zIO68xDkjXjY14c+63TOB3JvijvNcAkCc7h1D1lLz5Uim7Uu3/riORzrZIW806IAo/+rR6Afvt7GknKKzBBgNbQzJ0fSiJS9L3+2K0B66wMZqU9cAs0B9NnSAZTWEd3o8MBhPL13mexzsJvDdxyR383BeuCNoxLXZlt/GR5OO39wyoe7mVASMlkNSfLwgnt9xDHl7+ZP2f1gGOnIgoltM45Oage863xpWlbwCaAVXgjC4gkAxrjrAXnsZ+54yHJAFz9eglnHQtcdplQPbXqlI2M+9DffCIWFBlo71E3nKIjDwZpUhVLyDUQ9WTitIOongc37cw4rh8eK7vuVVp8Bf8cR5+rBn56P1QTlFa81CDvb+Ikbn7xw7w6sOZHy+AFa8+8S+TR1aATw4ljnaYppYNPgQuM5lKW6vbwgQMcIILB/NPPKaDNgZtbP9IS2t4o6JwFM=
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