PfehVJcexYvB4MEgszihsK69bzx8wRlMwZ4Oiy75PIKu0d9Vjlg3as5qWp01pu4K3fYxn/fAiXuUsDPAbLbPy9lglwxuc5PF+VqjIsPuo6MXN1GfrX6muDM3ooqqShr6KTwRjk89aqPSI4PMkqceQMB5LVgZ/4EcKzJ00HmIb7pKef3DE1r1pQ+b3vrUD2IPddhB5dfp02tK9Gt3MJAKLh+U9efTWOwXH8zVvdBoh5/vUVPSB1/JgRjG1bsw1Sbt4b4ENNPnih7THVtm9M3rp9S8CNMdW4eh3p1+JFZMm/R2AXHMJtdviL1Ni3SFaQIJkgbA0uS/gcW1RK+N7HNjVybEsyfKvrsQJtDb3uggpX702HwfSkGzFdqXRtbG4MR1NPCFQuJmnIgcir6yY/RJXNdadWzyZAl5DmoJcqgsWG4TyXube1QJZZWfvS1iWGekwxQsi07vrewSK65dgH7NmZRKu5DEIKw5B8fasw6nCjmbuTj+K7MLloI0gg81aT9XoOfpaSF55Bn/NNFCIgYnSnbiqCVqMh+7yAOtqvPDKaribbi6iev7W8lnTZkbxqbn3uCz9OldBJ66GXLhL8PQsn6zvPovLJGSoiT6LNUMCvYAfkN2Hk4p0KJcKd/84/F+IgLCrQMSjvRPyy2YHRCWatyF+pLnu3tlHqLq2OtuV8I83/YLWk/sYkWbS4eCrYzjz4mGdeLx1UzTSc1VLzHkYk9GPebQugjgRvrL5STupCdwitLvBmXZjANHhatWkHwgi+XpuIBF6qTEpUx+R6w5OwMGondF8AktJM/Pmj6iSRr8LusSDIE8oe34T7SrGD4M7A0BnIwzxVHpZ3BVRgdGln9wSIjL4qB0mNt7ViudnBWLD34EnteGOLvoUzO7BWuKEwXghmBqM2A1l/ULOepXlHOeiuDIfqUyEQN7wiSYVrvk5cXR9bS5aEnN4TijJRfH3+MvrZipVOu2nsyRSVvmtWJvkMY4h779NwRt5AAsg+e1JS3WKRhKu4YGGbaA/6+NcvV6JeO5KGRGQpwbIwWP+pAdiU0MLxPmizL/CAfSvJsXEYsgwxZY0BSrBjP2BsG4W1fpkXiCByP4wxyeFFLg2sABzHM9bG2mAuj4zWDU1UI/fCUKFuEc/FGCBh28TGTB4KWxLNibw1Nc0DMWvS7uXLyhbjPJSto9vNMDuIXwBNlmQEetOSY+5b/2rjgXOnH0FDxZinY4XVe+C07Y5/UuDw2FHgm4FVYFMR5GKf+ZsTo4PxSObQiqQdW4avNnBLJWmROqMyNKV3C0UfRPz7AJrHcsVRgY39lvyaXWgDkRL/1Ra3mvMUK+t7++z2b27aCl2Z3d9zCmalS7Xi/ZKJ7uwTI/nOB1Ym9K8vmUGos=
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