oSIOcTnJOVXgsisHFJT097OW6msLvkRtQGNKiDgmAUXW+J6HqmJEq9y5dOdidPO70edF00BtOrCoFVTJkTq3T2MZ1F0Dw9YxEqBmKaHTvy7Vl0wYg/F8hlduZF0qNfQTcC23tt5anip9Y3QzSwmFw2BvPGuhQJ9bTYmzYhdOJl0hQKpb+9tIWBInh2fHppA0kZ3haywz0X8aHarjnzhQO5S6tw1gvzWt3Zt8dtcip9LLsui6cviirDIDl6Wv4Hf8L72qeG4ngUWZgu3Kd/IbfFfYerpDUnireYVYVRz9lm5NuQpyQfYze94Z63Ak3byJONF/RqEPuE2eJxCm5tVFlFWst7EhHCUF79wUDYYM3+fX/rrSuvIMwz00D9MbQ20imjMjo0BxY4BgFDxhQjUQzM1qgP8ULMxOL8oQwNogA+b3lFHUfV0LT+85AnsQTb69rHC+dYCeG4ue0oqgmVQgE5TItMzre5jMlfBKS5AO1RPPaApiswxtWHWpLRD6QM4ZCG6Sav/VVb4NoEZOfSOSo6rL1VmbXwdH/gW9W4tlwnNctyz1fD2Ax00Ne4ZHUNyf2Tzc23kHKiZ93GtHQqdnC/M42W/BIBy1Wtj47OeXOwAz2e2De7vRc35Ekfl+LTanyCwCRITx1ZudyZ+qIOG1QK4DgYZ/nABWezsQ6xqy/Q+QBKjVKMtsOWPsm4SrYPeWRKyGsUNzG1T5RCkkBhjirJV0IPsW6Wrn7bZdqYv49R7WHLed0gGrxzIeOlpcIUd+tp4XVAT37L1MXyPkFZHRpKbJVFXiM4U5HBmt2vf1dSc8wNOz8YFaDGVJqSHb4FcE9dtMLGjEPiFExfFaRMWAHeu3X9b9g5uH2ymWf5p+/N7L4+GKiU9UvG4Jk6Hbwsyq+icj6IaqP41rBeVbO44llOHxoN/jxH0Qa6e36cSsy31nCEtcTeiTlDf4FgkP+MaHOsznmGz50t9yLxRWhfshBLRRTizQfmD+8fmeR8Yw93IzV3QkxG73VRyBEdiygvoogHqb7FwDSKvRkSghvI7xcgKDfmPxIFG6lqsush+TANfAJxjR8Oxh43j1FYuC9g10F6aQ0UR6ojfcCIh/eONkjyjnv5PTdlGLI9QP4jExJNHYRVYCBA451viaE+/agdkDQffVoOK7bdl50QTIl/dJFdRYPEkS2sfqe37QpmB43BGc1d0U3D+1NzoVcJTJ0bgKm7kQk0EfT3oQL6ZWv1x12WHk/Y1mxdX8Q+bH2hNIuLEnurYuUTQBZyP1Or2KilMn8XqEtDijvD6MiC08PslEytBoo21JUIJ1uMT5WJumfkUriDzndZ61p+0W/nemMc89M3nYPg4uJegi+6GPSJ4ZL2Q1Y03IRDdALdkGmEI=
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