ZO3LxPgoWvsMRHeagaM5DiTwDjCyNkfJ0BSz7j1HUMiNyZJB+cwNVwpm7V+gfFpFYgtBmcxvKwPAIQJNcBjG7XuLeOxPzqtXUufMtNBKq3p+53rJufBVXAV7M3mfMN3N1xgFZB4dlIzcF5PDBffeeHDwlbqhCIWEHt9Bqz5u5OJB+7yIaI1tRYkj9pxEH9iEuTLbfekM82SW+IGZ5fVwTwKjkrb3uYw55xCJGRakvbCIzsQPmAgv2s3sDW/cC+LefqaqLVKbgGj/HvpMA0r65AAk86T/Z+AGnXfwW+vZpSUgngCHMejF1eMtQLzWf/Mo/b8rK4i21ASUWh4p12/6xES6zEhEAqhfGaZC8jBzc31YWUBLV8P426dbHsY8hLxNHYS6xYevQ6SY94sdPImu8FoYWbqXkK4YSFHCZz2aJUKfDd4oxt1h26MubX8WNvr+MmanNAzOHR/8wQi0GuQ27iFI4J4HHRJtX6K/wrC9EBnuX0o57pbGBZNGoaQPSZZUre4WVz2SiYSAw2r1sEpqjxFweNV1nWtnyDGkudYA2TQ/zVDeb2JWLNCGrX6OOaC50yrcXyPohn5lAES8TQrLYMzIDf4BnQg1qgBdoIjSVA7qJB5gT1ax2+95q3PKRuaoZjDUler90R555kktbbVEZUrtrhVZW9o0NK3Z+NwFLLSF/9KoYILgqArM9wiFGIZfGnMrBSJ8Xs41X/pjf1XAxcxTYnNkQ6CZGhHr1hNlC5aEF6jR+al/lhIIb42eDgbRJX0SDjCIT5Kuov7dqvHiGxARVuUPizDl/u268uMZ3xjY41CV1FVrBY//W13sjLJngcERQQnHDhpkrzzr8+CtZ1mpjvvqHNGEoOwZTfS4qG8HNty0bvyn+xnjOUUkji/lOQC+jJPVGJmauRqp4Om94rE5S+DqBgg60qHs3n8fUA0g06EcisG+kFoKj02YXgwsl2cdItEYDBRBMtjXhX+D3JsDrCS//2uvHZpkjL759SOkcd2uFVfutGYLQFEbMB6IafL+XGTSBesfvuhhJwEkUApLBc167c9mSc6QE4hM6PFrjd8zyNqdHI/4XgSMcOQGpONTDHE8/hAd8VmCtQOjT/ggazpQkZ/weqSRqHFLgIE5oQP5RhGdKM9q6udix5Qp/KxEzFdRyDS0PSvIPkRDNcoUypLbY2t9fccqRYTiXM3F0R23FKOy5nfNXSITNYWdLAYhOp785yLrzO14S9r7ylprKw5hLvse//ofe9LiSq57+Bz8fBbTwWYnSXbuhcJDrJYvV2Yd6UJR4JVzduE7ADuqUnG5yf4kkhD7igEE6cRq5DnAj+sw444804WGRNk2ATkRDD9dae7zS6/3ynE6QESMgDjEuuasl2ZJrYE=
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