# [23-Nov-2025 05:35:05] /elitcar/www/ 113.196.59.51

SELECT
                        [N_ContragentEShopSettings].[ID],
                        [N_ContragentEShopSettings].[UserName],
                        [N_ContragentEShopSettings].[Password],
                        [N_ContragentEShopSettings].[Name],
                        [N_ContragentEShopSettings].[OELogin],
                        [N_ContragentEShopSettings].[_User_Id],
                        [N_ContragentEShopSettings].[Contragent_Id],
                        [N_ContragentEShopSettings].[ServiceBG_Id],
                        [N_ContragentEShopSettings].[Blocked],
                        [N_ContragentEShopSettings].[BlockOrders],
                        [N_ContragentEShopSettings].[_Comp_type],
                        [N_Contragent].[Comp_Id],
                        [N_Contragent].[_Route],
                        [N_Contragent].[Name2] AS ContragentName,
                        [N_Contragent].[Address] AS ContragentAddress,
                        [N_Contragent].[BULSTAT] AS ContragentBulstat,
                        [N_Contragent].[VATRegistrationNo] AS ContragentVAT,
                        [N_Contragent].[Contact] AS ContragentContact,
                        [N_Businessgroup].[IpAddressBG],
                        [N_Contragent].[PricesIncludingVAT],
                        [N_Contragent].[VATBus_PostingGroup] AS VAT,
                        [N_Contragent].[Currency_Id]
                    FROM
                        [N_ContragentEShopSettings]
                        INNER JOIN [N_Contragent] ON [N_Contragent].[Id] = [N_ContragentEShopSettings].[Contragent_Id]
                        LEFT JOIN [N_Businessgroup] ON
                            [N_Businessgroup].[Id] = [N_ContragentEShopSettings].[ServiceBG_Id] AND
                            [N_Businessgroup].[Comp_Id] = [N_ContragentEShopSettings].[Comp_Id]
                    WHERE
                        [N_ContragentEShopSettings].[UserName] = 'web0rder' AND
                        [N_ContragentEShopSettings].[Password] = 'web0rder'

Successfully disconnected from the database!
