iqWiftrYQZZENKQpNM17ewELxfo9guPi9QmieyCae10n+WejmQW8aiqor968CgDWPcB1VBNS4GYHGZVQk6F7VFKHuroZawv7uhChH3Oqyul7mBzQOEMRf14GSbSWWr0qKgqr5RYS82eVyuF780lbu7ERzpKp+1GdzRHKcsk664At415yHlNb8orP8dCu6lC7P4nmH8CLDg8k9jWGRXi/5Tl9kr1HwUFqYPXJpkFgBWPJhkLswxFGGTixRN5FO6qgC6vk9/6j4Xl7RYsLdRcYo5DbDJBCFaXOZ37BZM2sAWKy34KmuwknImOAtmUbBsfMICCxi27stm6Oa71XGpOq+ycZLaXyj+w833Co3/TLhW7yHfQwSvLkHBsJlVYUXnHMz7pdY1Fr6aBbcZYe+21OzHaRvgUCe4Qosm/9PcI5Fv/3LYs3mPrbyIU7NDUHzm7octNvb8WBswBsDqpT9Xow2oF/NmpZgI717TY5kG0bvr5/+++cC3tBUl+7grBqHBG2spI6XrcvzwLxweVWo8pxlAm19GYaks6qWaQdTBD2vebJiSugrxgnxSj06WE38c2Nmm2/ZTpTBaHdNv1tMC4w+UOw5g3jPixJWCNjkjVtOczCsVIKTLFLvpP2lg3Q6DVNUx82Ej9RFFxT3CUKlSHbPDP7MhYR/Zfb1CpQMyJ00w84kf6oYLJ0+p79DRtJQc25KsxnGpddfXK4aiFZxncWBTvaUQ/JbNC10eD38Q5jEXZbiW6IBHsIdM89Xypn2x3kak5CbvhigTOgc2iR6s9Y4bQfhVN8Ndd5mDMq62hI3kYppeLZbuqZibWzVFXpIEJCzpxxGWXPdFlcLDaCeMSvJ7UuDxADOg884ct5U0ssNi7dbBoOvE8bKdWI3JUIFZIoAGSHDp6u8mWwB9c0jO9VDHKezMvyhshPHcjSFVXgR/PhL4B+XvxSHZgDUv4sjrm/nbnRpvtDAglnRuqts2+O61Ko4RMrkYK4KyecsGSTTwxJI7y2cgyQLjaZFrNbiwvZGdwgYUy6M0cyuUaTVtTGkwitaJnG2kqrNtS1mWC5fZy5yhzBbxUj/YBhIKW1hTo4UdSHq2nlZdcJawMDv85WIKppcAE99glM8vpd2inC/VM3NrqYX7TGnsrrHFWz201ol+M+YDzzc44no25aJxa+BafT1JQVN+V+/wL2GJ/ESy7acT5OK40FtbiXVFw5OTVcbrmZE6Y7E3LCkTfQAEH8OqqthO5M8/+qHPP/qHIUkzRF1YnqX2f57WQKvfkFf+RVWZ7BD+7WrSDPOZYz3N2ZmVcZFJbENkVVIgMfE8M4v6OOUx+t4Twu4hPAODlZffrbs8x8XIFTUsKSqVS5lclljnuLdtVZdESO/pVa3MA=
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