超复杂oracle 语句

  select c2.id,c2.item_name|| '(' || nvl(m.nTitle,0) || ')',nvl(m.parent_no,53)
          from tb_item_config c2,
  (select b.id, b.parent_no, count(b.id) as nTitle
  from (select c.id, c.item_name, c.parent_no, s.web_user_id
          from tb_item_config c, tb_suit_who s
         where c.parent_no = 53
           and c.id = s.suit_who_id(+)) b,
       tb_favourablesale f
where b.web_user_id = f.user_id and f.type = 1 and etime>sysdate
  group by b.parent_no, b.id, b.item_name) m
 
  where c2.parent_no = 53
  and c2.id = m.id(+)