DNHfRexT9lTFRXDcKwZRCjK7sspXqCqHEPdglV0MJyZNRymnIuekxUu3umnihlh7KQSM/fvm8M5/+J2WQox4y7J63d6XRaqsix16BLi9n3F9BhZ3mJAYyizuRpdriAfztoz6aQe0ttFurVrav0z9SZgVLH96K0hCOaY6ky/hcb4jfTH/abW2QpuOts7gEMjSc1EJqfM7VPho+O/T16v8jMDJspPtV7dIOH3yrhRQCEJg/a+XdiK+GM0otVyQJCoWMyUQSUpEfyuxaeb1tsEESlOU0kpwrgWk8QGYtRebOmkdGCRLWBkn/9uI3OyeZnUFCcVyBs8Pc362g/RmapSN0hT3DgDJvHGozrZDcFDzeahu0YXwxHkaMaPA8UETnkPpR+gpyN3Z69ox7hfco7UKyRAL3Yeg4T11V8DluWmnIfj8IIaA1DxGtxesOd+PN72NZkMgYRYhE9IkfzjgQUSWMU7P75KxXxvDCfIQdplC9hrPAGKJHKkLpXRT540j7BHhYXwecsKvCpdCnsBiXL6M2LAY8dL+xcnK7NMJGsFM2Hz+UHfchkd+RXeOGS2My/o5EgcQ9yVhIYsCNFhZdrNe20otqMgft6XhQqJHBDz8anDKe0nb8B2r9vB7uBnHSYo81UhwNVIBJJlC3v4tv0roYSRgR/TFJqcAi1oT4EOO9VdhUIFrZGNtze2C4ifeA8BhNCu4nhlqeIg+ZwPh+NYx8gu2uvzKKZEUTnMPMw5zAI0jQxXDlUPzDxNwISnjNo0MOVR+cNR26m9YmssF6+/fM7mfyeXJZrAVWevpUuo8YBW2PQMFRXeynActA3lo0/N2GkGRpkBMq9D7omou8KpH3CBJSySy/LD3n+owwG/krNxRHZpz6oto2k7rQRk2hxNOsnG8E5olCyElv7ChssJOY8I5ZSq1V0gIz9il2C7wSaCtuwDlFiQCcma9Sr8FmSwIrtG9HJIdX+FEb09y+9gzYZtH8/qT1V/L/98+dmyArfNVhOUNCorbT8hcUAhJllWOJynyioJCFJjW6R9HvomkusA3vCFZixnKx6dvfE6JV8lvaDnaz+2M7WanXX1nb66ih1CfQC7IeDnTDR/Ypo6fMe73nuHD5pNl5LUcy6wgjbiRK4p2k3CZChZMd7Br42Oud0PYS/YvcS1lP/qzKseq+HrB0/nwNdfaaGR7ZLAI0RcR48oQnkAuNj4WTigzlYdQe0bCASKXs7B5qrJ5kIZ/KMaOyrAgZ0qqH4If64uFu0zniCaHCwGV3/QqaLhijBZXkR06OM3ifWS428i7MVivGPfmquXqWaynWdoKHv9pM3+8MS2j5H80eBAUcSsv5EcoaZ7zkMnnhP7/jxUmOHEvXKig126cr4edihQ8/T4=
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