SET NOCOUNT ON;

select   nn_rozn_price, nn.nn_kod, nn.nn_art, nn.nn_name,  nn_man.nn_man_name, man.mfa_brand, dbo.Storage_present(nn.nn_kod,@storage_kod) st_ost, dbo.Storage_present(nn.nn_kod,0) st_other,  dbo.Storage_busy(nn.nn_kod,@storage_kod) st_busy, dbo.NN_await(nn.nn_kod) nn_await
   from nomenclature nn
   inner join nomenclature_manufacturers nn_man on (nn_man.nn_man_kod=nn.nn_man_kod)
   left join Manufacturers man on (man.mfa_kod=nn.mfa_kod)
    where nn_kod=@nn_kod

union

select   nn_rozn_price, nn.nn_kod, nn.nn_art, nn.nn_name,  nn_man.nn_man_name, man.mfa_brand, dbo.Storage_present(nn.nn_kod,@storage_kod) st_ost, dbo.Storage_present(nn.nn_kod,0) st_other, dbo.Storage_busy(nn.nn_kod,@storage_kod) st_busy, dbo.NN_await(nn.nn_kod) nn_await
   from analogs a
   inner join nomenclature nn on (nn.nn_kod=a.nn_kod)
   inner join nomenclature_manufacturers nn_man on (nn_man.nn_man_kod=nn.nn_man_kod)
   left join Manufacturers man on (man.mfa_kod=nn.mfa_kod)
   where  analog_group in (
   select analog_group
   from analogs
   where nn_kod=@nn_kod)
   
   order by nn_man_name, nn_art