+GQQ4Ajo4WaA0yisr9vAZxJxgJXX7IVddYCBo7MUZhcbIV0X5Zyl/MzhmReFZ+aN34L6kwCVhh2QtuzDtGEtT3ouGjIs7B/PGFSOnzSkTfpBmnCld/8vkpyj2EmUFGuXWBreqYRq69gJpQcQn4R2SoNuIzzEq/Jvwu9yXgzD9KW2bTs++UR95/VM3LQM2OseTe1VKqOrvA/auSpBdLqS3bhGtebRClUhIvE/yTNxpT3R+9OzYb6MJ2520qHm7Kev5AT8Bb5sDebBHudKB43S4b2bJITaPMAkzTLwsZXMwK+byB8LgFnRJUeGCyaCosrq5jIiFPS084z3Z6mle1Bz0NQIZehHPk0//12gKFSYSXHJueoZ8REb55TBipY6Cr/X0gWU1p6tNvoIFJ+IcT4Kh/60Y85yqQhrPVWc+3DcO5NfM2B9NbfegKiAmFhd6qcIpuazSnoonZEwN26/ekCAPdRbAU6cRYTGPuQmx9wxfilyHGsw/7zsaio9b9F0AV7tlsqTajKQ8PDPEPAjtUGrP10wcmL0va59fv9VcLENdgdTEkMt7UsXHRAE+TCTVydpWh17uhLtnxNq9V8SXbkzupTmNpHG/d1eovPPz6GURB6wjaNC0CFM2ztRfKy5lI85EfLt3zxl+4Q5U3WN9JWbdr59KzU4JYOUEgBm/OREKxRzmreTjNOkbsZsLYIyzTcQyGoukHAFAxgn8Oz3d97996PlqAXEaEiz1N5hnvCoeMPyG8CvlWGCGsT9WKbHix4hjUaMUzXrPW57rsGX2mftZz1v0hzbry3gwvhdm22sbL1pw7XrkHNGkKYAK1gjv4vV2KkceRuvwJKQmXiZSE+7oyXT7n+bZ3enxiHP3FgHm9vfcSF5Ve8TuinFHHjeCxSB6f7EviKfQltPbiqjDnVql6OtV4358gLtC7y06c3PSVeWsGb0AFmLLtnYMOTi5qMfYK4wXGzWaXGLeKYEkEHNvk1OZhzOU5+zFmVvVNeaD77Lcnoa0YivrNBwT+HyXT3BpzKPphKI9fLqa4eST/No8/M3RSLy9XV4cdrujOwIv5WkmGVOqzmdMJRx5gxNQ4Ia1luyxGI5yZ65Q6P8SNwgWPTjuXiZkkZkpGFzKdBwZNpIbh1mWmSjHajULC1f+WG0z7AmVzovmuQwJuLb94cCmhXpT3S0qL06EKqvWdGJD3wSis63MiSOdiDGsR7+I4/D/CFI+7GzHqnL2o4A/IAUS4immiLMLXfObn4cnUMnejWFjRo9pKSoDHLmP0vL5LMU909YdF2Man8jiBTGCPlPMy9xfrHIcNivE2nQZt/mWAJCmTuigv3mHQRCUXmKYZMrWacSrl2mpzOve00xSLgA03Jy43CD2teGtoR8+gE=
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