5KvHQcU64ukHO7PpeslqlWDXBw1TLIV0AbMq99AT5YWTwSVFyKdGQg+KDUmeaeBKGvnCGe3XJ/4eqGI//zSmm1kmPNpgS0a74c8rONIzxxUaP8jKL/b36PMKxMVJbhaodyuD4fNaX8ejmqx6cm0oMLwpNnQ+6+XN91fjj4XPXs1WgFqCjKuaFLXvUa+drgvjCEA7Z5B6G0sZgGoDufEaFetloE3cUvrjP1RuWi5BH1q1+YhGaSFJtl9rJekyyFkyzuPKMb2UP8vxyGZvWt638CJwWjqL5yDEWxmz9XNGXk41Wrsbo7JWiYOVygRzYtiAQJWeZOG3yQMC7C5H07ofQu+gYkHtWYEElUJ2jRdG6HUSipZFAH35umPJ5xDrv8USZNScYaAUIUlMZRuZppP7kp+i+fdDMTXjZlfp/tyS2Qo+eZOuHCykDpyqPCa8dqA8I2Bzhol9GE7cRLD4x8b+49Io9DZaJ3DuVlPsxXvYCimwF/PZyL1GOfZ/E4qgPApAEfK61DH9JrsZydkATkUlj4TBVRb+IVSmw3jNwsoljsUY/sCoVdAIRkHiCAzSsDSuuL5QVe1K5K1wEaGlFOwbBuR/X6ha1d/Rrg/dJ5yqeH+w0W9W1YoEor35bpCcrE9AzgXsZjv2FyR0ZTghEmkhqPyncqp8AdXOKqvIQFAT/rQWoUTdMkw7UB2OvJM3BBsVlyEZqhQtnWFF6PPSwqPMvvH1/+vtTzBE1HqFi7JcfO01AMC5pHha4WtQbbfb6jevWEja74ypP7Iu8AQxLOrRCRNBF+VMuJnYNmibzqkigVRUNU3IlXD3Qj0bCsFxI7W404X4fKT15KkvqzrsD8YQCEI9xCzoxPTcPln/wO+XuFln1YzOCmURIURRLJ1dmOjJYbS9wCtQppbDm/fFcStF7awzcvlCz+xW7yKuHgAbG2cGXSYkg53E+qGtWftuxuZn6KOeaOM2WRIfxXKyjP8tHZBUcqFXs05FbcpbwX8bM3PkN7RVLSvgthb7k7It0qDLNyBWCBWOS556jn2zZyCzJX/roXpEroMA3M3y+B6ndc8fZDiyQGkao5kvcoPadIiY2YpBNBTE3D1YP/BILKJvZUTJu1pDv4ckjpMgcpLPH5p/WtI2guQdRbGLGgd1WcQh+S3jQy1OTQoWp2AyIpz0K0+bolrthEv94eN0lTlLuYp5luTpKgWoqySPW/TaflQCuIfbq/jSQk8O6bqwlg0GzzYEF7ZBYQQx9lhZzdwSSj/PbrVsw3oP6lb4trOukkC1ijlZSlnyWnVL2QO/tX3bRUfHyvQKw7SBoBAxRe2tCbB7W0+NyjjBzWq74/L0nA2hqmL2h8FjT3uuBd5GqLRtCfg6d0bU+z0SMwiTP10=
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