学会公众号
  • 专科分会组织建设
  • 专科分会组织建设
  • 数据语句 select * from ( select a.*,ifnull(b.c,0) as filec from ( select a.*,ifnull(b.c,0) as newsc from ( select * from t_web_zkfh where isdel=0 ) a left join ( select count(1) as c,zkfh_id from t_web_content where checked=1 and zkfh_id>0 group by zkfh_id ) b on a.id=b.zkfh_id ) a left join ( select count(1) as c,zkfh_id from t_web_zkfh_files group by zkfh_id ) b on a.id=b.zkfh_id ) t order by convert( name using gbk ), dateandtime desc limit 0 , 15 执行错误,请联系管理员。
    分会名称 详细