SELECT count(1) FROM audit_qytb_i_project aqip INNER JOIN audit_project ap ON ap.FLOWSN =aqip.flowsn INNER JOIN audit_qytb_instance aqi ON aqip .qytbguid =aqi.RowGuid WHERE ap.STATUS >=26 AND aqi.qytbtype=0
SELECT count(1) FROM audit_qytb_i_project aqip INNER JOIN audit_project ap ON ap.FLOWSN =aqip.flowsn INNER JOIN audit_qytb_instance aqi ON aqip .qytbguid =aqi.RowGuid WHERE ap.STATUS >=26 AND aqi.qytbtype=1
SELECT count(1) FROM audit_qytb_i_project aqip INNER JOIN audit_project ap ON ap.FLOWSN =aqip.flowsn INNER JOIN audit_qytb_instance aqi ON aqip .qytbguid =aqi.RowGuid WHERE ap.STATUS >=26 AND aqi.qytbtype=2;
SELECT count(1) FROM audit_qytb_i_project aqip INNER JOIN audit_project ap ON ap.FLOWSN =aqip.flowsn INNER JOIN audit_qytb_instance aqi ON aqip .qytbguid =aqi.RowGuid WHERE ap.STATUS >=26 AND aqi.qytbtype=3