select t0.BG_RESPONSIBLE, count(t0.BG_BUG_ID) ammount from
(select ap.ap_property_id, b.BG_BUG_ID, b.BG_RESPONSIBLE, b.BG_DETECTION_DATE from td.audit_properties ap
left join td.audit_log al on al.AU_ACTION_ID = ap.ap_action_id
left join td.bug b on b.BG_BUG_ID = al.au_entity_id
where b.BG_DETECTION_DATE between '2012-08-01' and '2012-08-31' and ap.ap_new_value = 'Reopen'
) t0
group by t0.BG_BUG_ID, t0.BG_RESPONSIBLE having count(t0.BG_BUG_ID) > 2
order by t0.BG_RESPONSIBLE
(select ap.ap_property_id, b.BG_BUG_ID, b.BG_RESPONSIBLE, b.BG_DETECTION_DATE from td.audit_properties ap
left join td.audit_log al on al.AU_ACTION_ID = ap.ap_action_id
left join td.bug b on b.BG_BUG_ID = al.au_entity_id
where b.BG_DETECTION_DATE between '2012-08-01' and '2012-08-31' and ap.ap_new_value = 'Reopen'
) t0
group by t0.BG_BUG_ID, t0.BG_RESPONSIBLE having count(t0.BG_BUG_ID) > 2
order by t0.BG_RESPONSIBLE
781
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
