select 
      (SELECT c.place FROM libr_theme c WHERE c.id=theme AND c.del='N' AND ROWNUM= 1  ) place ,
      count(*)
from libr_invent a,libr_books  b 
group by place
having count(*)> 1 
order by place
where a.del='N' and b.del='N' and a.id=b.id(+)