OMFG
SELECT [a].[Id] ,
[a].[Comment] ,
[a].[CorrReceiveType_Id] ,
[a].[Email] ,
[a].[FullName] ,
[a].[Inn] ,
[a].[ItemType_Id] ,
[a].[LastAnketeDate] ,
[a].[PartnerCode] ,
[a].[PersonNameEng] ,
[a].[ShortName] ,
[a].[TaxCategory_Id] ,
[a].[Telephone] ,
[a].[OldId] ,
[a].[Version] ,
[a].[Revision] ,
[a].[AuthorizedCapital] ,
[a].[Currency_Id] ,
[a].[HasForeignPartners] ,
[a].[Kio] ,
[a].[Kpp] ,
[a].[Okpo] ,
[a].[OrganisationForm_Id] ,
[a].[RegisterSertificateDate] ,
[a].[RegisterOgrnDate] ,
[a].[RegistrateSertificateNumber] ,
[a].[RegistrateOgrnNumber] ,
[a].[RegistrationCity_Id] ,
[a].[RegistrationOgrnCity_Id] ,
[a].[Registrator] ,
[a].[RegistratorOgrn] ,
[a].[AllOkved] ,
[a].[#a.Name] ,
[a].[#b.Name] ,
[a].[#c.Name] ,
[a].[#d.Name] ,
[a].[#e.Name] ,
[a].[#f.Name] ,
[a].[#g.Name]
FROM ( SELECT TOP 42
[b].[Id] ,
[b].[TypeId] ,
[b].[Comment] ,
[b].[CorrReceiveType_Id] ,
[b].[Email] ,
[b].[FullName] ,
[b].[Inn] ,
[b].[ItemType_Id] ,
[b].[LastAnketeDate] ,
[b].[PartnerCode] ,
[b].[PersonNameEng] ,
[b].[ShortName] ,
[b].[TaxCategory_Id] ,
[b].[Telephone] ,
[b].[OldId] ,
[b].[Version] ,
[b].[Revision] ,
[c].[AuthorizedCapital] ,
[c].[Currency_Id] ,
[c].[HasForeignPartners] ,
[c].[Kio] ,
[c].[Kpp] ,
[c].[Okpo] ,
[c].[OrganisationForm_Id] ,
[c].[RegisterSertificateDate] ,
[c].[RegisterOgrnDate] ,
[c].[RegistrateSertificateNumber] ,
[c].[RegistrateOgrnNumber] ,
[c].[RegistrationCity_Id] ,
[c].[RegistrationOgrnCity_Id] ,
[c].[Registrator] ,
[c].[RegistratorOgrn] ,
[c].[AllOkved] ,
[d].[#a.Id] ,
[d].[#a.TypeId] ,
[d].[#a.CurCode] ,
[d].[#a.Name] ,
[d].[#a.NameInDocs] ,
[d].[#a.Sign] ,
[d].[#a.OldId] ,
[d].[#a.Version] ,
[d].[#a.Revision] ,
[e].[#b.Id] ,
[e].[#b.TypeId] ,
[e].[#b.CityCode] ,
[e].[#b.Country_Id] ,
[e].[#b.Name] ,
[e].[#b.NameEng] ,
[e].[#b.PhoneCode] ,
[e].[#b.ZipCode] ,
[e].[#b.OldId] ,
[e].[#b.Version] ,
[e].[#b.Revision] ,
[f].[#c.Id] ,
[f].[#c.TypeId] ,
[f].[#c.CityCode] ,
[f].[#c.Country_Id] ,
[f].[#c.Name] ,
[f].[#c.NameEng] ,
[f].[#c.PhoneCode] ,
[f].[#c.ZipCode] ,
[f].[#c.OldId] ,
[f].[#c.Version] ,
[f].[#c.Revision] ,
[g].[#d.Id] ,
[g].[#d.TypeId] ,
[g].[#d.OldId] ,
[g].[#d.Name] ,
[g].[#d.Description] ,
[g].[#d.Version] ,
[g].[#d.Revision] ,
[h].[#e.Id] ,
[h].[#e.TypeId] ,
[h].[#e.OldId] ,
[h].[#e.Name] ,
[h].[#e.Description] ,
[h].[#e.Version] ,
[h].[#e.Revision] ,
[i].[#f.Id] ,
[i].[#f.TypeId] ,
[i].[#f.OldId] ,
[i].[#f.Name] ,
[i].[#f.Description] ,
[i].[#f.Version] ,
[i].[#f.Revision] ,
[j].[#g.Id] ,
[j].[#g.TypeId] ,
[j].[#g.Comment] ,
[j].[#g.Description] ,
[j].[#g.EntityType_Id] ,
[j].[#g.InheritanceSchema_Id] ,
[j].[#g.IsInternal] ,
[j].[#g.IsAbstract] ,
[j].[#g.Layer_Id] ,
[j].[#g.LinkedEntity_Id] ,
[j].[#g.Name] ,
[j].[#g.OwnerEntity_Id] ,
[j].[#g.Revision] ,
[j].[#g.SysName] ,
[j].[#g.Hierarchy_Left] ,
[j].[#g.Hierarchy_Right] ,
[j].[#g.Hierarchy_Level] ,
[j].[#g.Parent_Id] ,
[j].[#g.Status_Id] ,
[j].[#g.Creator_Id] ,
ROW_NUMBER() OVER ( ORDER BY [b].[FullName] ASC ) AS [RowNumber0]
FROM ( SELECT [k].[Id] ,
[k].[TypeId] ,
[k].[AuthorizedCapital] ,
[k].[Currency_Id] ,
[k].[HasForeignPartners] ,
[k].[Kio] ,
[k].[Kpp] ,
[k].[Okpo] ,
[k].[OrganisationForm_Id] ,
[k].[RegisterSertificateDate] ,
[k].[RegisterOgrnDate] ,
[k].[RegistrateSertificateNumber] ,
[k].[RegistrateOgrnNumber] ,
[k].[RegistrationCity_Id] ,
[k].[RegistrationOgrnCity_Id] ,
[k].[Registrator] ,
[k].[RegistratorOgrn] ,
[k].[AllOkved]
FROM [dbo].[JuridicalPerson] [k]
) [c]
INNER JOIN ( SELECT [l].[Id] ,
[l].[TypeId] ,
[l].[Comment] ,
[l].[CorrReceiveType_Id] ,
[l].[Email] ,
[l].[FullName] ,
[l].[Inn] ,
[l].[ItemType_Id] ,
[l].[LastAnketeDate] ,
[l].[PartnerCode] ,
[l].[PersonNameEng] ,
[l].[ShortName] ,
[l].[TaxCategory_Id] ,
[l].[Telephone] ,
[l].[OldId] ,
[l].[Version] ,
[l].[Revision]
FROM [dbo].[Person] [l]
) [b] ON ( [b].[Id] = [c].[Id] )
LEFT OUTER JOIN ( SELECT [m].[Id] AS [#a.Id] ,
123 AS [#a.TypeId] ,
[m].[CurCode] AS [#a.CurCode] ,
[m].[Name] AS [#a.Name] ,
[m].[NameInDocs] AS [#a.NameInDocs] ,
[m].[Sign] AS [#a.Sign] ,
[m].[OldId] AS [#a.OldId] ,
[m].[Version] AS [#a.Version] ,
[m].[Revision] AS [#a.Revision]
FROM [dbo].[Currency] [m]
) [d] ON ( [c].[Currency_Id] = [d].[#a.Id] )
LEFT OUTER JOIN ( SELECT [n].[Id] AS [#b.Id] ,
115 AS [#b.TypeId] ,
[n].[CityCode] AS [#b.CityCode] ,
[n].[Country_Id] AS [#b.Country_Id] ,
[n].[Name] AS [#b.Name] ,
[n].[NameEng] AS [#b.NameEng] ,
[n].[PhoneCode] AS [#b.PhoneCode] ,
[n].[ZipCode] AS [#b.ZipCode] ,
[n].[OldId] AS [#b.OldId] ,
[n].[Version] AS [#b.Version] ,
[n].[Revision] AS [#b.Revision]
FROM [dbo].[City] [n]
) [e] ON ( [c].[RegistrationCity_Id] = [e].[#b.Id] )
LEFT OUTER JOIN ( SELECT [o].[Id] AS [#c.Id] ,
115 AS [#c.TypeId] ,
[o].[CityCode] AS [#c.CityCode] ,
[o].[Country_Id] AS [#c.Country_Id] ,
[o].[Name] AS [#c.Name] ,
[o].[NameEng] AS [#c.NameEng] ,
[o].[PhoneCode] AS [#c.PhoneCode] ,
[o].[ZipCode] AS [#c.ZipCode] ,
[o].[OldId] AS [#c.OldId] ,
[o].[Version] AS [#c.Version] ,
[o].[Revision] AS [#c.Revision]
FROM [dbo].[City] [o]
) [f] ON ( [c].[RegistrationOgrnCity_Id] = [f].[#c.Id] )
LEFT OUTER JOIN ( SELECT [p].[Id] AS [#d.Id] ,
276 AS [#d.TypeId] ,
[p].[OldId] AS [#d.OldId] ,
[p].[Name] AS [#d.Name] ,
[p].[Description] AS [#d.Description] ,
[p].[Version] AS [#d.Version] ,
[p].[Revision] AS [#d.Revision]
FROM [dbo].[TaxCategory] [p]
) [g] ON ( [b].[TaxCategory_Id] = [g].[#d.Id] )
LEFT OUTER JOIN ( SELECT [q].[Id] AS [#e.Id] ,
225 AS [#e.TypeId] ,
[q].[OldId] AS [#e.OldId] ,
[q].[Name] AS [#e.Name] ,
[q].[Description] AS [#e.Description] ,
[q].[Version] AS [#e.Version] ,
[q].[Revision] AS [#e.Revision]
FROM [dbo].[OrganisationForm] [q]
) [h] ON ( [c].[OrganisationForm_Id] = [h].[#e.Id] )
LEFT OUTER JOIN ( SELECT [r].[Id] AS [#f.Id] ,
124 AS [#f.TypeId] ,
[r].[OldId] AS [#f.OldId] ,
[r].[Name] AS [#f.Name] ,
[r].[Description] AS [#f.Description] ,
[r].[Version] AS [#f.Version] ,
[r].[Revision] AS [#f.Revision]
FROM [dbo].[DeliveryCorrespondenceType] [r]
) [i] ON ( [b].[CorrReceiveType_Id] = [i].[#f.Id] )
INNER JOIN ( SELECT [s].[Id] AS [#g.Id] ,
145 AS [#g.TypeId] ,
[s].[Comment] AS [#g.Comment] ,
[s].[Description] AS [#g.Description] ,
[s].[EntityType_Id] AS [#g.EntityType_Id] ,
[s].[InheritanceSchema_Id] AS [#g.InheritanceSchema_Id] ,
[s].[IsInternal] AS [#g.IsInternal] ,
[s].[IsAbstract] AS [#g.IsAbstract] ,
[s].[Layer_Id] AS [#g.Layer_Id] ,
[s].[LinkedEntity_Id] AS [#g.LinkedEntity_Id] ,
[s].[Name] AS [#g.Name] ,
[s].[OwnerEntity_Id] AS [#g.OwnerEntity_Id] ,
[s].[Revision] AS [#g.Revision] ,
[s].[SysName] AS [#g.SysName] ,
[s].[Hierarchy_Left] AS [#g.Hierarchy_Left] ,
[s].[Hierarchy_Right] AS [#g.Hierarchy_Right] ,
[s].[Hierarchy_Level] AS [#g.Hierarchy_Level] ,
[s].[Parent_Id] AS [#g.Parent_Id] ,
[s].[Status_Id] AS [#g.Status_Id] ,
[s].[Creator_Id] AS [#g.Creator_Id]
FROM [dbo].[DocEntity] [s]
) [j] ON ( [b].[ItemType_Id] = [j].[#g.Id] )
WHERE ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( [b].[Email] IS NOT NULL )
AND ( [b].[Email] LIKE '%123%' )
)
OR ( ( [b].[OldId] IS NOT NULL )
AND ( [b].[OldId] LIKE '%123%' )
)
)
OR ( ( [c].[AllOkved] IS NOT NULL )
AND ( [c].[AllOkved] LIKE '%123%' )
)
)
OR ( ( [b].[Inn] IS NOT NULL )
AND ( [b].[Inn] LIKE '%123%' )
)
)
OR ( ( [c].[Kio] IS NOT NULL )
AND ( [c].[Kio] LIKE '%123%' )
)
)
OR ( ( [b].[Comment] IS NOT NULL )
AND ( [b].[Comment] LIKE '%123%' )
)
)
OR ( ( [c].[Kpp] IS NOT NULL )
AND ( [c].[Kpp] LIKE '%123%' )
)
)
OR ( ( [b].[PersonNameEng] IS NOT NULL )
AND ( [b].[PersonNameEng] LIKE '%123%' )
)
)
OR ( ( [b].[Telephone] IS NOT NULL )
AND ( [b].[Telephone] LIKE '%123%' )
)
)
OR ( ( [c].[RegistrateOgrnNumber] IS NOT NULL )
AND ( [c].[RegistrateOgrnNumber] LIKE '%123%' )
)
)
OR ( ( [c].[Okpo] IS NOT NULL )
AND ( [c].[Okpo] LIKE '%123%' )
)
)
OR ( ( [c].[Registrator] IS NOT NULL )
AND ( [c].[Registrator] LIKE '%123%' )
)
)
OR ( ( [c].[RegistratorOgrn] IS NOT NULL )
AND ( [c].[RegistratorOgrn] LIKE '%123%' )
)
)
OR ( ( [b].[FullName] IS NOT NULL )
AND ( [b].[FullName] LIKE '%123%' )
)
)
OR ( ( [c].[RegistrateSertificateNumber] IS NOT NULL )
AND ( [c].[RegistrateSertificateNumber] LIKE '%123%' )
)
)
OR ( ( [b].[ShortName] IS NOT NULL )
AND ( [b].[ShortName] LIKE '%123%' )
)
)
OR ( ( [b].[PartnerCode] IS NOT NULL )
AND ( [b].[PartnerCode] LIKE '%123%' )
)
)
OR ( ( ( [c].[Currency_Id] IS NOT NULL )
AND ( [d].[#a.Name] IS NOT NULL )
)
AND ( [d].[#a.Name] LIKE '%123%' )
)
)
OR ( ( ( [c].[RegistrationCity_Id] IS NOT NULL )
AND ( [e].[#b.Name] IS NOT NULL )
)
AND ( [e].[#b.Name] LIKE '%123%' )
)
)
OR ( ( ( [c].[RegistrationOgrnCity_Id] IS NOT NULL )
AND ( [f].[#c.Name] IS NOT NULL )
)
AND ( [f].[#c.Name] LIKE '%123%' )
)
)
OR ( ( ( [b].[TaxCategory_Id] IS NOT NULL )
AND ( [g].[#d.Name] IS NOT NULL )
)
AND ( [g].[#d.Name] LIKE '%123%' )
)
)
OR ( ( ( [c].[OrganisationForm_Id] IS NOT NULL )
AND ( [h].[#e.Name] IS NOT NULL )
)
AND ( [h].[#e.Name] LIKE '%123%' )
)
)
OR ( ( ( [b].[CorrReceiveType_Id] IS NOT NULL )
AND ( [i].[#f.Name] IS NOT NULL )
)
AND ( [i].[#f.Name] LIKE '%123%' )
)
)
OR ( ( ( [b].[ItemType_Id] IS NOT NULL )
AND ( [j].[#g.Name] IS NOT NULL )
)
AND ( [j].[#g.Name] LIKE '%123%' )
)
)
ORDER BY [b].[FullName] ASC
) [a]
WHERE ( [a].[RowNumber0] > 0 )
ORDER BY [a].[FullName] ASC ;
