超复杂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(+)