select StoreCards.Name, cast(documents.OrdNumber as integer),
documents.DocDate$Date,
l2.QUnit, l2.ID, storeBatches.Name, StoreCards.EAN,
LogStorePositions.BarCode, StoreCards.id StoreCardId, StoreCards.Code KodSklKarty, l1.storeposition_id PoziceOdkud, l2.storeposition_id PoziceKam, p1.name, p2.name
from LogStoreDocuments documents
left join logstoredocuments2 l1 on l1.parent_id=documents.id and documents.documenttype='33'
left join logstoredocuments2 l2 on l2.id=l1.masterrow_id
left join storecards on storecards.id=l1.storecard_id
LEFT JOIN storeBatches on l1.StoreBatch_ID = storeBatches.ID
LEFT JOIN LogStorePositions p1 ON p1.ID = l1.StorePosition_ID
LEFT JOIN LogStorePositions p2 ON p2.ID = l2.StorePosition_ID
where Executed = 'N' and DocumentType = '33' and
documents.OrdNumber = 2198 and PositionType = '0' and l2.storeposition_id is not null
order by LogStorePositions.BarCode