--Запрос 1
select top 1 A.AfsName, WS.orig_price, WS.self_price, Ws.quantity, WS.was_at
from single_ware_sells WS inner join afs A on Ws.object_id = A.AfsId
where WS.ware_code = 4556 (4555)
order by WS.was_at desc

--Запрос 2
select  WS.orig_price, WS.self_price, Ws.quantity, WS.was_at
from single_ware_sells WS 
where WS.ware_code = 4556 (4555)   --Возвращает 309 (45)  записей
 order by WS.was_at desc