select 
    ostatok_doc_remote.ostatok_doc_remote_id,
    goods_remote.goods_remote_id,
    goods_remote.skarb_id,
    goods_remote.goods_name,
    ostatok_items_remote.ostatok_items_remote_id,
    ostatok_items_remote.ostatok,
    producer_remote.producer_name,
    place_name_remote.base_id
from place_name_remote
   inner join ostatok_doc_remote on (place_name_remote.base_id = ostatok_doc_remote.base_id)
   inner join ostatok_items_remote on (ostatok_doc_remote.ostatok_doc_remote_id = ostatok_items_remote.ostatok_doc_remote_id)
   inner join goods_remote on (ostatok_items_remote.goods_id = goods_remote.skarb_id)
   inner join producer_remote on (goods_remote.producer_id = producer_remote.producer_remote_id)
where 
   (
      (ostatok_items_remote.goods_id = 3015)
   and 
      (ostatok_doc_remote.is_active = 1)
   )

 right outer join goods_remote on (ostatok_items_remote.goods_id = goods_remote.skarb_id)

select i.ostatok_items_remote_id,i.goods_id,d.added,p.place_name,g.goods_name,pr.producer_name,i.ostatok as ostatok,i.price_pro from goods_remote g
inner join ostatok_items_remote i on (g.skarb_id=i.goods_id)
inner join ostatok_doc_remote d on (i.ostatok_doc_remote_id=d.ostatok_doc_remote_id)
inner join producer_remote pr on (g.producer_id=pr.skarb_id)
inner join place_name_remote p on(g.base_id=p.base_id)
where upper(g.goods_name) like upper(:search_text) and d.is_active=1
order by 1