Query: Security purchase / sale check broker

Select distinct [DBList].[DBId], [DBList].[LogicalName] from

-- 1st Part ------------------------------------------------------------------------------------------------------------

(Select [StockTransfer].*
From ([StockTransfer] Inner Join [Article]
on ([StockTransfer].[ArticleId] = [Article].[Id] And [StockTransfer].[DBId] = [Article].[DBId]))
Where [Article].[Type] = 2
and [StockTransfer].[Type] in (1, 2)
and convert(varchar, [StockTransfer].[DBId]) + '-' + convert(varchar, [StockTransfer].[Id]) in
(
Select convert(varchar, [InvoicePayment].[DBId]) + '-' + convert(varchar, [InvoicePayment].[StockTransferId])
from (([InvoicePayment]
INNER JOIN [GLAccount] as [DGLAccount]
ON ([InvoicePayment].[DGLAccountId] = [DGLAccount].[Id] and [InvoicePayment].[DBId] = [DGLAccount].[DBId]))
INNER JOIN [GLAccount] as [CGLAccount]
ON ([InvoicePayment].[CGLAccountId] = [CGLAccount].[Id] and [InvoicePayment].[DBId] = [CGLAccount].[DBId]))
where ([DGLAccount].[Type] in (11, 12) or [CGLAccount].[Type] in (11, 12))
and Not [InvoicePayment].[StockTransferId] = 0
Union All
Select distinct convert(varchar, [GLMovement].[DBId]) + '-' + convert(varchar, [GLMovement].[StockTransferId]) from
([GLMovement] INNER JOIN [GLAccount]
ON ([GLMovement].[GLAccountId] = [GLAccount].[Id] and [GLMovement].[DBId] = [GLAccount].[DBId]))
where [GLAccount].[Type] in (11, 12)
and Not [GLMovement].[StockTransferId] = 0
)
and (([StockTransfer].[ClientId] = 0 and [StockTransfer].[Type] = 2) or ([StockTransfer].[SupplierId] = 0 and [StockTransfer].[Type] = 1))

-- 2nd Part ------------------------------------------------------------------------------------------------------------

Union All
Select [StockTransfer].*
From ([StockTransfer] Inner Join [Article]
on ([StockTransfer].[ArticleId] = [Article].[Id] And [StockTransfer].[DBId] = [Article].[DBId]))
Where [Article].[Type] = 2
and [StockTransfer].[Type] in (1, 2)
and Not convert(varchar, [StockTransfer].[DBId]) + '-' + convert(varchar, [StockTransfer].[Id]) in
(
Select convert(varchar, [InvoicePayment].[DBId]) + '-' + convert(varchar, [InvoicePayment].[StockTransferId])
from (([InvoicePayment]
INNER JOIN [GLAccount] as [DGLAccount]
ON ([InvoicePayment].[DGLAccountId] = [DGLAccount].[Id] and [InvoicePayment].[DBId] = [DGLAccount].[DBId]))
INNER JOIN [GLAccount] as [CGLAccount]
ON ([InvoicePayment].[CGLAccountId] = [CGLAccount].[Id] and [InvoicePayment].[DBId] = [CGLAccount].[DBId]))
where ([DGLAccount].[Type] in (11, 12) or [CGLAccount].[Type] in (11, 12))
and Not [InvoicePayment].[StockTransferId] = 0
Union All
Select distinct convert(varchar, [GLMovement].[DBId]) + '-' + convert(varchar, [GLMovement].[StockTransferId]) from
([GLMovement] INNER JOIN [GLAccount]
ON ([GLMovement].[GLAccountId] = [GLAccount].[Id] and [GLMovement].[DBId] = [GLAccount].[DBId]))
where [GLAccount].[Type] in (11, 12)
and Not [GLMovement].[StockTransferId] = 0
)
and (Not [StockTransfer].[ClientId] = 0 or Not [StockTransfer].[SupplierId] = 0)
and Not [StockTransfer].[GLPeriodId] = 0

-- 3rd Part ------------------------------------------------------------------------------------------------------------

Union All
Select [StockTransfer].*
From ([StockTransfer] Inner Join [Article]
on ([StockTransfer].[ArticleId] = [Article].[Id] And [StockTransfer].[DBId] = [Article].[DBId]))
Where [Article].[Type] = 2
and [StockTransfer].[Type] in (1, 2)
and Not [StockTransfer].[ClientId] = 0
and Not [StockTransfer].[SupplierId] = 0

-- 4th Part ------------------------------------------------------------------------------------------------------------

Union All
Select [StockTransfer].*
From (([StockTransfer] Inner Join [Article]
on ([StockTransfer].[ArticleId] = [Article].[Id] And [StockTransfer].[DBId] = [Article].[DBId]))
Left Join [Client]
on ([StockTransfer].[ClientId] = [Client].[Id] And [StockTransfer].[DBId] = [Client].[DBId]))
Where [Article].[Type] = 2
and [StockTransfer].[Type] in (1, 2)
and Not [StockTransfer].[ClientId] = 0 and [Client].[Id] Is Null

-- 5th Part ------------------------------------------------------------------------------------------------------------

Union All
Select [StockTransfer].*
From (([StockTransfer] Inner Join [Article]
on ([StockTransfer].[ArticleId] = [Article].[Id] And [StockTransfer].[DBId] = [Article].[DBId]))
Left Join [Supplier]
on ([StockTransfer].[SupplierId] = [Supplier].[Id] And [StockTransfer].[DBId] = [Supplier].[DBId]))
Where [Article].[Type] = 2
and [StockTransfer].[Type] in (1, 2)
and Not [StockTransfer].[SupplierId] = 0
and [Supplier].[Id] Is Null
) as [ResTable] INNER JOIN [Licence].[DeMaSy].[DBList]
ON [ResTable].[DBId] = [DBList].[DBId]
order by [DBList].[LogicalName]