select a.OrdNumber, b.Code, c.Code, lsp.code
from MainInvProtocols a
join DocQueues b on a.DocQueue_ID=b.id
join Periods c on a.Period_ID=c.id
join MAININVPROTOCOLPOSITIONS p on p.PARENT_ID = a.ID
join LOGSTOREPOSITIONS lsp on lsp.id = p.STOREPOSITION_ID
where p.id=:OBJIDGenerated by ABRA Software a.s. 27.10.2021 16:34:10