np0HyMKqw8bq7D4ZOxLh65cP+9/MgnuwA3ybC5UiKn6owc1TmKRwX8HBeYQ7Cr9avjwyNhBEaAZVu/YaOgRQ1grybGsvVIskOBg0AKhiiVd7v7H2t8GAiCLR7xSnamEKjRYsXd06l6cHH2gKBSUr5Heb2tsA/5Ql8OruHS0zY1KErw10nz436zCJc7fxN6TJombKg0O53sdlx+c1xNVlZ0H/AgVp6QVPSpYCj2YyC7RD9sPUYM2tlmm46mEcLRAdDHDquANuUB7Qiuw30knJ+znUalLLfr7kUTmXFpe2bOuSiUe3fZdxRTDllWxMf0fjrpS8US+d8CgxxbF8pVrvGT18/mB4y1XXowvofRQpRUMxlWuyXIVkMxcGsew5TF5+ZCMTfkT8r3jhSWxHLV10AXW6gdHmtVkncG2M+p2Hi4n3eLqP4O3IjoHNcYglhCxs3/YGYv/CEmX5CyNDtcDrw58ZBPE/P3n8CJLVAS3FP2VpFWNXqO1nE4NMP6ecRVg1505bh+57zmGqJ3m7Rcjrqoe1z15+ludERDa7boZ8Lr/sIk6A2M280N+ht8XRe9nDsJy5Y7J3Aan/AnI8t0cEOK7jm1ZI4cRZ/inr+FesWeNmy4SJtQHdDEK4jRz0d9XYqLaadZ0b0t9WSLlIOa5cJ1aVYudVnOuilrq5xcJIxTZoQYMFQd62krw4LVErW3JW+3q4pviKRlNL8mX3kFV+/qxFJF26wvaHbkxd7pNNA100qAfjfleupguAV6fgzHgJuRy1dql/f8ye0LRb2b21omBzPllGi4/cvl4rZHp6VN2pFZjdDuBUmwqNFcN5Ihjk6p5NPJES5PMrRXVUxZNP7CN7k6pWkJZYxbqkt7QJhTIQHgHPBhAcBEe7qf0GAkBFRfZa3YM0krh4wPZ5J57VPMuEtsi1A88ksYV/u423csaHrm8/Kb3JBi494e92x5lv8//VQkUwQUqwFoMQCqCShxFpmcKWLeImZdlsdw3Etl/DsMKJStCQ4Bg9wrWtn6SnCTR2+rUv7kE6SuwXu9DxfFijRMYaeHyZVErtHl+rorhT57eZswn5xSrGtcX+5024S1vFkE28zG5AG8lkyb2qdxELb3kMyD2ZuZ3zi54nV+izW1i2VtiWzgjyqPzljjO3kUmKEnFnJUmCgUu1uAFUfOoVJFalZNrwlk0M7z7KrctUgdVFfKmxIRroV3Sv/HOeumZHM6nZyvfm8/Gy4tpB41++iYluvjafqb0T5cRcCylDEeq9Q85pQdyovOaxG/v01RCLvO4myFP8pdPPFEBqrWUMPwNGpAZE9eVQNCJgWWP5iylgnRsUgJQ2rTMMkqvqTGkbYgZmYsfE6ojO6b3bNyMLmUIRR15gi81nm2Y=
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