select dj.id, dj.OpDate,dj.idPhysicalPerson, dr.idGoods,g.Name,dr.Amount from DocJournal as dj join drSales as dr on dr.idDoc = dj.id join refPhysicalPersons as pp on pp.id = dj.idPhysicalPerson join refGoods as g on g.id = dr.idGoods where dj.idPhysicalPerson in (123124,123125,123126) and dj.deleted= 0
