SELECT
                                    _User_Id,
                                    _ChangeBlockedCntr
                                FROM
                                    N_ContragentEShopSettings
                                    INNER JOIN N_Users ON N_Users.Id = N_ContragentEShopSettings._User_Id
                                WHERE
                                    N_ContragentEShopSettings._User_Id = :sUser_Id /*това ти е променливата, която прочиташ при логване*/
                                    AND  N_Users.Is_Active = 1
Array
(
    [:sUser_Id] => 
)


SELECT * FROM fn_GetNextRouteForClient('001', '548B32E74F7445DBAF5ABC08C7CD53D3', '00', 0)

exec usp_CheckContragentDue_ElitCar_web '548B32E74F7445DBAF5ABC08C7CD53D3', '001',0, '2025-04-14', '00'

SELECT * FROM `elitcar_store`.`history_autos` WHERE `MonetaUser` = 'innovasys' AND `Language` = 'bg' ORDER BY PostDate DESC LIMIT 30

SELECT * FROM `elitcar_store`.`history_vin` WHERE `MonetaUser` = 'innovasys' ORDER BY PostDate DESC LIMIT 30

Successfully disconnected from the database!
# [14-Apr-2025 15:46:32] /elitcar/www/bg/ajax/moneta/sort.html?sn=553190&_=1744634793983 108.61.209.243
# [14-Apr-2025 15:46:32] /elitcar/www/bg/ajax/history/parts.html?_=1744634793986 108.61.209.243
# [14-Apr-2025 15:46:32] /elitcar/www/bg/ajax/users/bar.html?_=1744634794048 108.61.209.243

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_DeliveryAddress].[Route_Id] AS _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].[VATBus_PostingGroup] AS VAT,
                                [N_Contragent].[Currency_Id],
                                [N_Contragent].CreditLimit_LCY AS Creditlimit,
                                [N_Contragent].PaymentTermsCode  AS PaymentTerms,
                                [N_Contragent].PaymentMethodCode  AS PaymentMethodCode,
                                COALESCE([N_DeliveryAddress]._TransportType, [N_Contragent].TransportType) AS TransportType,
                                -- [N_DeliveryAddress].Route_Id AS TransportType,
                                COALESCE([N_DeliveryAddress]._SubDocument_Code, [N_Contragent]._SaleDocSubType_EK) AS SaleDocSubType,
                                COALESCE([N_DeliveryAddress]._DefaultPrintForm, [N_Contragent]._DefaultPrintForm) AS DefaultPrintForm
                            FROM
                                [N_ContragentEShopSettings] WITH(NOLOCK)
                            INNER JOIN [N_Contragent] WITH(NOLOCK) ON
                                [N_Contragent].[Id] = [N_ContragentEShopSettings].[Contragent_Id]
                            LEFT JOIN [N_DeliveryAddress] WITH(NOLOCK) ON
                                [N_Contragent].[Comp_Id] = [N_DeliveryAddress].[Comp_Id] AND
                                [N_Contragent].[Id] = [N_DeliveryAddress].[Contragent_Id] AND
                                [N_ContragentEShopSettings].[ServiceBG_Id] = [N_DeliveryAddress].[ServiceBG_Id]
                            LEFT JOIN [N_Businessgroup] WITH(NOLOCK) ON
                                [N_Businessgroup].[Id] = [N_ContragentEShopSettings].[ServiceBG_Id] AND
                                [N_Businessgroup].[Comp_Id] = [N_ContragentEShopSettings].[Comp_Id]
                            WHERE
                                [N_ContragentEShopSettings].[ID] = '8DAD158C30E643FEBFC767D77EBC2F9C'

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_DeliveryAddress].[Route_Id] AS _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].[VATBus_PostingGroup] AS VAT,
                                [N_Contragent].[Currency_Id],
                                [N_Contragent].CreditLimit_LCY AS Creditlimit,
                                [N_Contragent].PaymentTermsCode  AS PaymentTerms,
                                [N_Contragent].PaymentMethodCode  AS PaymentMethodCode,
                                COALESCE([N_DeliveryAddress]._TransportType, [N_Contragent].TransportType) AS TransportType,
                                -- [N_DeliveryAddress].Route_Id AS TransportType,
                                COALESCE([N_DeliveryAddress]._SubDocument_Code, [N_Contragent]._SaleDocSubType_EK) AS SaleDocSubType,
                                COALESCE([N_DeliveryAddress]._DefaultPrintForm, [N_Contragent]._DefaultPrintForm) AS DefaultPrintForm
                            FROM
                                [N_ContragentEShopSettings] WITH(NOLOCK)
                            INNER JOIN [N_Contragent] WITH(NOLOCK) ON
                                [N_Contragent].[Id] = [N_ContragentEShopSettings].[Contragent_Id]
                            LEFT JOIN [N_DeliveryAddress] WITH(NOLOCK) ON
                                [N_Contragent].[Comp_Id] = [N_DeliveryAddress].[Comp_Id] AND
                                [N_Contragent].[Id] = [N_DeliveryAddress].[Contragent_Id] AND
                                [N_ContragentEShopSettings].[ServiceBG_Id] = [N_DeliveryAddress].[ServiceBG_Id]
                            LEFT JOIN [N_Businessgroup] WITH(NOLOCK) ON
                                [N_Businessgroup].[Id] = [N_ContragentEShopSettings].[ServiceBG_Id] AND
                                [N_Businessgroup].[Comp_Id] = [N_ContragentEShopSettings].[Comp_Id]
                            WHERE
                                [N_ContragentEShopSettings].[ID] = '8DAD158C30E643FEBFC767D77EBC2F9C'

SELECT
                                    _User_Id,
                                    _ChangeBlockedCntr
                                FROM
                                    N_ContragentEShopSettings
                                    INNER JOIN N_Users ON N_Users.Id = N_ContragentEShopSettings._User_Id
                                WHERE
                                    N_ContragentEShopSettings._User_Id = :sUser_Id /*това ти е променливата, която прочиташ при логване*/
                                    AND  N_Users.Is_Active = 1
Array
(
    [:sUser_Id] => 
)


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_DeliveryAddress].[Route_Id] AS _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].[VATBus_PostingGroup] AS VAT,
                                [N_Contragent].[Currency_Id],
                                [N_Contragent].CreditLimit_LCY AS Creditlimit,
                                [N_Contragent].PaymentTermsCode  AS PaymentTerms,
                                [N_Contragent].PaymentMethodCode  AS PaymentMethodCode,
                                COALESCE([N_DeliveryAddress]._TransportType, [N_Contragent].TransportType) AS TransportType,
                                -- [N_DeliveryAddress].Route_Id AS TransportType,
                                COALESCE([N_DeliveryAddress]._SubDocument_Code, [N_Contragent]._SaleDocSubType_EK) AS SaleDocSubType,
                                COALESCE([N_DeliveryAddress]._DefaultPrintForm, [N_Contragent]._DefaultPrintForm) AS DefaultPrintForm
                            FROM
                                [N_ContragentEShopSettings] WITH(NOLOCK)
                            INNER JOIN [N_Contragent] WITH(NOLOCK) ON
                                [N_Contragent].[Id] = [N_ContragentEShopSettings].[Contragent_Id]
                            LEFT JOIN [N_DeliveryAddress] WITH(NOLOCK) ON
                                [N_Contragent].[Comp_Id] = [N_DeliveryAddress].[Comp_Id] AND
                                [N_Contragent].[Id] = [N_DeliveryAddress].[Contragent_Id] AND
                                [N_ContragentEShopSettings].[ServiceBG_Id] = [N_DeliveryAddress].[ServiceBG_Id]
                            LEFT JOIN [N_Businessgroup] WITH(NOLOCK) ON
                                [N_Businessgroup].[Id] = [N_ContragentEShopSettings].[ServiceBG_Id] AND
                                [N_Businessgroup].[Comp_Id] = [N_ContragentEShopSettings].[Comp_Id]
                            WHERE
                                [N_ContragentEShopSettings].[ID] = '8DAD158C30E643FEBFC767D77EBC2F9C'

SELECT
                                    _User_Id,
                                    _ChangeBlockedCntr
                                FROM
                                    N_ContragentEShopSettings
                                    INNER JOIN N_Users ON N_Users.Id = N_ContragentEShopSettings._User_Id
                                WHERE
                                    N_ContragentEShopSettings._User_Id = :sUser_Id /*това ти е променливата, която прочиташ при логване*/
                                    AND  N_Users.Is_Active = 1
Array
(
    [:sUser_Id] => 
)


SELECT * FROM fn_GetNextRouteForClient('001', '548B32E74F7445DBAF5ABC08C7CD53D3', '00', 0)

SELECT
                                    _User_Id,
                                    _ChangeBlockedCntr
                                FROM
                                    N_ContragentEShopSettings
                                    INNER JOIN N_Users ON N_Users.Id = N_ContragentEShopSettings._User_Id
                                WHERE
                                    N_ContragentEShopSettings._User_Id = :sUser_Id /*това ти е променливата, която прочиташ при логване*/
                                    AND  N_Users.Is_Active = 1
Array
(
    [:sUser_Id] => 
)


exec usp_CheckContragentDue_ElitCar_web '548B32E74F7445DBAF5ABC08C7CD53D3', '001',0, '2025-04-14', '00'

SELECT * FROM fn_GetNextRouteForClient('001', '548B32E74F7445DBAF5ABC08C7CD53D3', '00', 0)
# [14-Apr-2025 15:46:33] /elitcar/www/bg/ajax/moneta/sort.html?sn=553190&_=1744634793983 108.61.209.243

set names utf8

SELECT
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`Sales`,
                `elitcar_store`.`moneta`.`Qty`,
                `elitcar_store`.`moneta`.`QtyAll`,
                `elitcar_store`.`moneta`.`FullSearchTecDocId`
            FROM
                `elitcar_store`.`moneta`
                LEFT JOIN `elitcar_store`.`availabilities` ON `elitcar_store`.`moneta`.`MonetaId` = `elitcar_store`.`availabilities`.`MonetaId` AND `elitcar_store`.`availabilities`.`BusinessGroupID` = '00'
            WHERE
                `elitcar_store`.`moneta`.`MonetaId` IN('AJUSA 12027300','AJUSA 12000700','AJUSA 12032600','AJUSA 57005000','BILSTEIN 24-021289','CORTECO 12014584','CORTECO 49472013','DT 11.10570','ELRING 553.190','FEBI 03345','KYB 553190','MONROE D8466S','MONROE D8467S','PAYEN HR569','PAYEN HR805','SACHS 290 619','SWAG 30 34 0001','TOKICO 2859','TOKICO E2785','TRUCKTEC 07.12.117','TRW BK1856','REINZ 70-25837-00','RANCHO RS5144','MONROE D8467','DPH 1272960','DPH 45720','ELRING 294.250','PEUGEOT 1607427280','REINZ 12-25837-01','REINZ 70-22737-00','STARLINE GA 6506')
            ORDER BY
                `elitcar_store`.`availabilities`.`Qty` DESC,
                `elitcar_store`.`moneta`.`Qty` DESC,
                `elitcar_store`.`moneta`.`QtyAll` DESC,
                `elitcar_store`.`moneta`.`Sales` DESC

Successfully disconnected from the database!

SELECT * FROM fn_GetNextRouteForClient('001', '548B32E74F7445DBAF5ABC08C7CD53D3', '00', 0)

exec usp_CheckContragentDue_ElitCar_web '548B32E74F7445DBAF5ABC08C7CD53D3', '001',0, '2025-04-14', '00'

exec usp_CheckContragentDue_ElitCar_web '548B32E74F7445DBAF5ABC08C7CD53D3', '001',0, '2025-04-14', '00'
# [14-Apr-2025 15:46:33] /elitcar/www/bg/ajax/history/parts.html?_=1744634793986 108.61.209.243

set names utf8

SELECT * FROM `elitcar_store`.`history_parts` WHERE `MonetaUser` = 'innovasys' AND `Language` = 'bg' ORDER BY PostDate DESC LIMIT 30

Successfully disconnected from the database!
# [14-Apr-2025 15:46:33] /elitcar/www/bg/ajax/users/bar.html?_=1744634794048 108.61.209.243

set names utf8

SELECT `TotalQty` FROM `elitcar_store`.`basket` WHERE `UserName` = 'innovasys' AND `ContragentID` = '548B32E74F7445DBAF5ABC08C7CD53D3' LIMIT 1

SELECT COUNT(*) FROM `elitcar_store`.`offers` WHERE `UserID` = '8DAD158C30E643FEBFC767D77EBC2F9C' AND `Status` = 0

Successfully disconnected from the database!
# [14-Apr-2025 15:46:33] /elitcar/www/bg/ajax/prices/W00gUEVVR0VPVCAxNjA3NDI3MjgwXQ.html?_=1744634792139 108.61.209.243
# [14-Apr-2025 15:46:33] /elitcar/www/bg/ajax/prices/W00gRUxSSU5HIDI5NC4yNTBd.html?_=1744634792140 108.61.209.243
# [14-Apr-2025 15:46:33] /elitcar/www/bg/ajax/prices/W00gU1RBUkxJTkUgR0EgNjUxMV0.html?_=1744634792141 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('ELRING 294.250', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('PEUGEOT 1607427280', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('STARLINE GA 6511', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('PEUGEOT 1607427280', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('ELRING 294.250', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('STARLINE GA 6511', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'PEUGEOT 1607427280'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'ELRING 294.250'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:46:34] /elitcar/www/bg/ajax/prices/W00gRUxSSU5HIDI5NC4yNTBd.html?_=1744634792140 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:46:34] /elitcar/www/bg/ajax/prices/W00gUEVVR0VPVCAxNjA3NDI3MjgwXQ.html?_=1744634792139 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'STARLINE GA 6511'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:46:34] /elitcar/www/bg/ajax/prices/W00gU1RBUkxJTkUgR0EgNjUxMV0.html?_=1744634792141 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:46:34] /elitcar/www/bg/ajax/prices/W00gR09FVFpFIDUwLTMwNjY3MC01MF0.html?_=1744634792760 108.61.209.243
# [14-Apr-2025 15:46:34] /elitcar/www/bg/ajax/prices/W00gQUpVU0EgMTIwMDA3MDBd.html?_=1744634792760 108.61.209.243
# [14-Apr-2025 15:46:34] /elitcar/www/bg/ajax/prices/W00gUEFZRU4gSFI2MTVd.html?_=1744634792762 108.61.209.243
# [14-Apr-2025 15:46:34] /elitcar/www/bg/ajax/prices/W00gUEFZRU4gSFI1Njld.html?_=1744634792761 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('AJUSA 12000700', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('GOETZE 50-306670-50', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('PAYEN HR615', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('PAYEN HR569', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('GOETZE 50-306670-50', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('AJUSA 12000700', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('PAYEN HR615', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('PAYEN HR569', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'GOETZE 50-306670-50'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'PAYEN HR615'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'AJUSA 12000700'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:46:34] /elitcar/www/bg/ajax/prices/W00gR09FVFpFIDUwLTMwNjY3MC01MF0.html?_=1744634792760 108.61.209.243
# [14-Apr-2025 15:46:34] /elitcar/www/bg/ajax/prices/W00gUEFZRU4gSFI2MTVd.html?_=1744634792762 108.61.209.243

set names utf8

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!

Successfully disconnected from the database!
# [14-Apr-2025 15:46:34] /elitcar/www/bg/ajax/prices/W00gQUpVU0EgMTIwMDA3MDBd.html?_=1744634792760 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'PAYEN HR569'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:46:34] /elitcar/www/bg/ajax/prices/W00gUEFZRU4gSFI1Njld.html?_=1744634792761 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:46:40] /elitcar/www/bg/ajax/prices/W00gUEFZRU4gSFI4MDVd.html?_=1744634798907 108.61.209.243
# [14-Apr-2025 15:46:40] /elitcar/www/bg/ajax/prices/W00gRFQgMTEuMTA1NzBd.html?_=1744634798908 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('DT 11.10570', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('PAYEN HR805', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('DT 11.10570', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('PAYEN HR805', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'DT 11.10570'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'PAYEN HR805'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:46:40] /elitcar/www/bg/ajax/prices/W00gRFQgMTEuMTA1NzBd.html?_=1744634798908 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:46:40] /elitcar/www/bg/ajax/prices/W00gUEFZRU4gSFI4MDVd.html?_=1744634798907 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:46:41] /elitcar/www/bg/ajax/prices/W00gQ09SVEVDTyAxMjAxNjg1MF0.html?_=1744634799870 108.61.209.243
# [14-Apr-2025 15:46:41] /elitcar/www/bg/ajax/prices/W00gQUpVU0EgNTcwMDUwMDBd.html?_=1744634799870 108.61.209.243
# [14-Apr-2025 15:46:41] /elitcar/www/bg/ajax/prices/W00gQUpVU0EgMTIwMzI2MDBd.html?_=1744634799871 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('AJUSA 57005000', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('CORTECO 12016850', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('AJUSA 12032600', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('AJUSA 57005000', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('CORTECO 12016850', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('AJUSA 12032600', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'AJUSA 57005000'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'CORTECO 12016850'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'AJUSA 12032600'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:46:41] /elitcar/www/bg/ajax/prices/W00gQUpVU0EgNTcwMDUwMDBd.html?_=1744634799870 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:46:41] /elitcar/www/bg/ajax/prices/W00gQ09SVEVDTyAxMjAxNjg1MF0.html?_=1744634799870 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:46:41] /elitcar/www/bg/ajax/prices/W00gQUpVU0EgMTIwMzI2MDBd.html?_=1744634799871 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:46:49] /elitcar/www/bg/ajax/prices/W00gQUpVU0EgMTIwMjczMDBd.html?_=1744634807891 108.61.209.243
# [14-Apr-2025 15:46:49] /elitcar/www/bg/ajax/prices/W00gQUpVU0EgMTIwMDQ1MDBd.html?_=1744634807892 108.61.209.243
# [14-Apr-2025 15:46:49] /elitcar/www/bg/ajax/prices/W00gU1dBRyAzMCAzNCAwMDAxXQ.html?_=1744634807893 108.61.209.243
# [14-Apr-2025 15:46:49] /elitcar/www/bg/ajax/prices/W00gVFJVQ0tURUMgMDcuMTIuMTE3XQ.html?_=1744634807894 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('AJUSA 12027300', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('AJUSA 12004500', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('SWAG 30 34 0001', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('TRUCKTEC 07.12.117', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('AJUSA 12027300', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('AJUSA 12004500', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('TRUCKTEC 07.12.117', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('SWAG 30 34 0001', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'AJUSA 12027300'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'AJUSA 12004500'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'TRUCKTEC 07.12.117'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'SWAG 30 34 0001'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:46:49] /elitcar/www/bg/ajax/prices/W00gQUpVU0EgMTIwMjczMDBd.html?_=1744634807891 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:46:49] /elitcar/www/bg/ajax/prices/W00gQUpVU0EgMTIwMDQ1MDBd.html?_=1744634807892 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:46:49] /elitcar/www/bg/ajax/prices/W00gVFJVQ0tURUMgMDcuMTIuMTE3XQ.html?_=1744634807894 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:46:49] /elitcar/www/bg/ajax/prices/W00gU1dBRyAzMCAzNCAwMDAxXQ.html?_=1744634807893 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:47:57] /elitcar/www/bg/ajax/banners/pos_0.html?_=1744634875887 108.61.209.243
# [14-Apr-2025 15:47:57] /elitcar/www/bg/ajax/banners/pos_2.html?_=1744634875888 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Image`,
                `Title`,
                `Target`,
                `Position`
            FROM
                `elitcar_store`.`banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Image` != '' AND
                `Position` = 0 AND
                `Visible` = 1 AND
                `Domain` & 1
        ORDER BY `PostDate` DESC

UPDATE `elitcar_store`.`banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN (217,198)
# [14-Apr-2025 15:47:57] /elitcar/www/bg/ajax/banners/pos_1.html?_=1744634875887 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Image`,
                `Title`,
                `Target`,
                `Position`
            FROM
                `elitcar_store`.`banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Image` != '' AND
                `Position` = 2 AND
                `Visible` = 1 AND
                `Domain` & 1
        ORDER BY RAND() LIMIT 3

set names utf8

SELECT
                `ID`,
                `Image`,
                `Title`,
                `Target`,
                `Position`
            FROM
                `elitcar_store`.`banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Image` != '' AND
                `Position` = 1 AND
                `Visible` = 1 AND
                `Domain` & 1
        ORDER BY RAND() LIMIT 1
# [14-Apr-2025 15:47:57] /elitcar/www/bg/ajax/promo.html?_=1744634875888 108.61.209.243
# [14-Apr-2025 15:47:57] /elitcar/www/bg/ajax/promo.html?_=1744634875888 108.61.209.243

SELECT TOP 5
                Item_Id
            FROM
                N_SalesPrice
            WHERE
                Comp_id = '001' AND
                _promotype = 1 AND
                (StartingDate <= GETDATE() OR StartingDate IS NULL) AND
                (EndingDate >= GETDATE() OR EndingDate IS NULL)
            ORDER BY NEWID()

set names utf8

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BOSCH S P00 000 003'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 9212190
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `ProductId` = 9212190
            LIMIT 1

SELECT
                `FolderName`,
                `Name`,
                `Suffix`
            FROM
                `autokelly`.`productfile`
                INNER JOIN `autokelly`.`file` ON `autokelly`.`file`.`Id` = `autokelly`.`productfile`.`FileId`
            WHERE
                `autokelly`.`productfile`.`ProductId` = 9212190 AND
                `autokelly`.`file`.`Image` = 1 AND
                 `autokelly`.`file`.`Suffix` = 'JPG'
            ORDER BY
                `autokelly`.`productfile`.`Order`
            LIMIT 1

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BOSCH S P00 000 162'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BOSCH S P00 000 162'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BOSCH S P00 000 162'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'ECS 14716-7.4'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'ECS 14716-7.4'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'ECS 14716-7.4'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BOSCH S P00 000 172'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BOSCH S P00 000 172'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BOSCH S P00 000 172'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BOSCH S P00 000 160'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BOSCH S P00 000 160'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BOSCH S P00 000 160'
            ORDER BY N_Item.Id

SELECT TOP 5
                Item_Id
            FROM
                N_SalesPrice
            WHERE
                Comp_id = '001' AND
                _promotype = 2 AND
                (StartingDate <= GETDATE() OR StartingDate IS NULL) AND
                (EndingDate >= GETDATE() OR EndingDate IS NULL)
            ORDER BY NEWID()

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BGS 7310'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BGS 7310'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BGS 7310'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BGS 4114'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BGS 4114'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BGS 4114'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'ECS OP101'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'ECS OP101'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'ECS OP101'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BGS 7890'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BGS 7890'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BGS 7890'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BGS 6055'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BGS 6055'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BGS 6055'
            ORDER BY N_Item.Id

SELECT TOP 5
                Item_Id
            FROM
                N_SalesPrice
            WHERE
                Comp_id = '001' AND
                _promotype = 3 AND
                (StartingDate <= GETDATE() OR StartingDate IS NULL) AND
                (EndingDate >= GETDATE() OR EndingDate IS NULL)
            ORDER BY NEWID()
# [14-Apr-2025 15:48:00] /elitcar/www/bg/groups/39849642.html 108.61.209.243

set names utf8

SELECT
                `autokelly`.`catalog`.`Id`,
                `autokelly`.`catalog`.`Type`,
                `autokelly`.`catalog`.`TecDocId`,
                `autokelly`.`structure`.`ParentId`,
                `autokelly`.`catalogname`.`CatalogNameConversionId`,
                `autokelly`.`catalogname`.`BG` AS `NodeName`,
                `autokelly`.`catalogimages`.*,
                IF(`autokelly`.`catalogvisible`.`Unvisible` IS NULL, 1, 0) AS `Visible`,
                IF(`S`.`ParentId` IS NULL, 0, 1) AS `ChildNodes`
            FROM
                `autokelly`.`structure`
                INNER JOIN `autokelly`.`catalognameconversion` ON `autokelly`.`catalognameconversion`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                INNER JOIN `autokelly`.`catalogname` ON `autokelly`.`catalogname`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id`
                INNER JOIN `autokelly`.`catalog` ON `autokelly`.`catalog`.`Id` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogimages` ON `autokelly`.`catalogimages`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogvisible` ON
                    `autokelly`.`catalogvisible`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id` AND
                    `autokelly`.`catalogvisible`.`ParentId` = `autokelly`.`structure`.`ParentId`
                LEFT JOIN `autokelly`.`structure` AS `S` ON `S`.`ParentId` = `autokelly`.`catalog`.`Id`
            WHERE
                `autokelly`.`structure`.`ParentId` = 39849642
        
            GROUP BY
                `autokelly`.`catalog`.`Id`
            ORDER BY
                `autokelly`.`catalogimages`.`FileName` DESC,
                `autokelly`.`structure`.`Order`,
                `autokelly`.`catalogname`.`BG`

SELECT
                `autokelly`.`catalog`.`Id`,
                `autokelly`.`catalog`.`Type`,
                `autokelly`.`catalog`.`TecDocId`,
                `autokelly`.`structure`.`ParentId`,
                `autokelly`.`catalogname`.`CatalogNameConversionId`,
                `autokelly`.`catalogname`.`BG` AS `NodeName`,
                `autokelly`.`catalogimages`.*,
                IF(`autokelly`.`catalogvisible`.`Unvisible` IS NULL, 1, 0) AS `Visible`,
                IF(`S`.`ParentId` IS NULL, 0, 1) AS `ChildNodes`
            FROM
                `autokelly`.`structure`
                INNER JOIN `autokelly`.`catalognameconversion` ON `autokelly`.`catalognameconversion`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                INNER JOIN `autokelly`.`catalogname` ON `autokelly`.`catalogname`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id`
                INNER JOIN `autokelly`.`catalog` ON `autokelly`.`catalog`.`Id` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogimages` ON `autokelly`.`catalogimages`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogvisible` ON
                    `autokelly`.`catalogvisible`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id` AND
                    `autokelly`.`catalogvisible`.`ParentId` = `autokelly`.`structure`.`ParentId`
                LEFT JOIN `autokelly`.`structure` AS `S` ON `S`.`ParentId` = `autokelly`.`catalog`.`Id`
            WHERE
                `autokelly`.`structure`.`ParentId` = 51224611
        
            GROUP BY
                `autokelly`.`catalog`.`Id`
            ORDER BY
                `autokelly`.`catalogimages`.`FileName` DESC,
                `autokelly`.`structure`.`Order`,
                `autokelly`.`catalogname`.`BG`

SELECT
                `autokelly`.`catalog`.`Id`,
                `autokelly`.`catalog`.`Type`,
                `autokelly`.`catalog`.`TecDocId`,
                `autokelly`.`structure`.`ParentId`,
                `autokelly`.`catalogname`.`CatalogNameConversionId`,
                `autokelly`.`catalogname`.`BG` AS `NodeName`,
                `autokelly`.`catalogimages`.*,
                IF(`autokelly`.`catalogvisible`.`Unvisible` IS NULL, 1, 0) AS `Visible`,
                IF(`S`.`ParentId` IS NULL, 0, 1) AS `ChildNodes`
            FROM
                `autokelly`.`structure`
                INNER JOIN `autokelly`.`catalognameconversion` ON `autokelly`.`catalognameconversion`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                INNER JOIN `autokelly`.`catalogname` ON `autokelly`.`catalogname`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id`
                INNER JOIN `autokelly`.`catalog` ON `autokelly`.`catalog`.`Id` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogimages` ON `autokelly`.`catalogimages`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogvisible` ON
                    `autokelly`.`catalogvisible`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id` AND
                    `autokelly`.`catalogvisible`.`ParentId` = `autokelly`.`structure`.`ParentId`
                LEFT JOIN `autokelly`.`structure` AS `S` ON `S`.`ParentId` = `autokelly`.`catalog`.`Id`
            WHERE
                `autokelly`.`structure`.`ParentId` = 38979037
        
            GROUP BY
                `autokelly`.`catalog`.`Id`
            ORDER BY
                `autokelly`.`catalogimages`.`FileName` DESC,
                `autokelly`.`structure`.`Order`,
                `autokelly`.`catalogname`.`BG`

SELECT
                `autokelly`.`catalog`.`Id`,
                `autokelly`.`catalog`.`Type`,
                `autokelly`.`catalog`.`TecDocId`,
                `autokelly`.`structure`.`ParentId`,
                `autokelly`.`catalogname`.`CatalogNameConversionId`,
                `autokelly`.`catalogname`.`BG` AS `NodeName`,
                `autokelly`.`catalogimages`.*,
                IF(`autokelly`.`catalogvisible`.`Unvisible` IS NULL, 1, 0) AS `Visible`,
                IF(`S`.`ParentId` IS NULL, 0, 1) AS `ChildNodes`
            FROM
                `autokelly`.`structure`
                INNER JOIN `autokelly`.`catalognameconversion` ON `autokelly`.`catalognameconversion`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                INNER JOIN `autokelly`.`catalogname` ON `autokelly`.`catalogname`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id`
                INNER JOIN `autokelly`.`catalog` ON `autokelly`.`catalog`.`Id` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogimages` ON `autokelly`.`catalogimages`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogvisible` ON
                    `autokelly`.`catalogvisible`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id` AND
                    `autokelly`.`catalogvisible`.`ParentId` = `autokelly`.`structure`.`ParentId`
                LEFT JOIN `autokelly`.`structure` AS `S` ON `S`.`ParentId` = `autokelly`.`catalog`.`Id`
            WHERE
                `autokelly`.`structure`.`ParentId` = 38979167
        
            GROUP BY
                `autokelly`.`catalog`.`Id`
            ORDER BY
                `autokelly`.`catalogimages`.`FileName` DESC,
                `autokelly`.`structure`.`Order`,
                `autokelly`.`catalogname`.`BG`

SELECT
                `autokelly`.`catalog`.`Id`,
                `autokelly`.`catalog`.`Type`,
                `autokelly`.`catalog`.`TecDocId`,
                `autokelly`.`structure`.`ParentId`,
                `autokelly`.`catalogname`.`CatalogNameConversionId`,
                `autokelly`.`catalogname`.`BG` AS `NodeName`,
                `autokelly`.`catalogimages`.*,
                IF(`autokelly`.`catalogvisible`.`Unvisible` IS NULL, 1, 0) AS `Visible`,
                IF(`S`.`ParentId` IS NULL, 0, 1) AS `ChildNodes`
            FROM
                `autokelly`.`structure`
                INNER JOIN `autokelly`.`catalognameconversion` ON `autokelly`.`catalognameconversion`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                INNER JOIN `autokelly`.`catalogname` ON `autokelly`.`catalogname`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id`
                INNER JOIN `autokelly`.`catalog` ON `autokelly`.`catalog`.`Id` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogimages` ON `autokelly`.`catalogimages`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogvisible` ON
                    `autokelly`.`catalogvisible`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id` AND
                    `autokelly`.`catalogvisible`.`ParentId` = `autokelly`.`structure`.`ParentId`
                LEFT JOIN `autokelly`.`structure` AS `S` ON `S`.`ParentId` = `autokelly`.`catalog`.`Id`
            WHERE
                `autokelly`.`structure`.`ParentId` = 38957081
        
            GROUP BY
                `autokelly`.`catalog`.`Id`
            ORDER BY
                `autokelly`.`catalogimages`.`FileName` DESC,
                `autokelly`.`structure`.`Order`,
                `autokelly`.`catalogname`.`BG`

SELECT
                `autokelly`.`catalog`.`Id`,
                `autokelly`.`catalog`.`Type`,
                `autokelly`.`catalog`.`TecDocId`,
                `autokelly`.`structure`.`ParentId`,
                `autokelly`.`catalogname`.`CatalogNameConversionId`,
                `autokelly`.`catalogname`.`BG` AS `NodeName`,
                `autokelly`.`catalogimages`.*,
                IF(`autokelly`.`catalogvisible`.`Unvisible` IS NULL, 1, 0) AS `Visible`,
                IF(`S`.`ParentId` IS NULL, 0, 1) AS `ChildNodes`
            FROM
                `autokelly`.`structure`
                INNER JOIN `autokelly`.`catalognameconversion` ON `autokelly`.`catalognameconversion`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                INNER JOIN `autokelly`.`catalogname` ON `autokelly`.`catalogname`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id`
                INNER JOIN `autokelly`.`catalog` ON `autokelly`.`catalog`.`Id` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogimages` ON `autokelly`.`catalogimages`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogvisible` ON
                    `autokelly`.`catalogvisible`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id` AND
                    `autokelly`.`catalogvisible`.`ParentId` = `autokelly`.`structure`.`ParentId`
                LEFT JOIN `autokelly`.`structure` AS `S` ON `S`.`ParentId` = `autokelly`.`catalog`.`Id`
            WHERE
                `autokelly`.`structure`.`ParentId` = 38957087
        
            GROUP BY
                `autokelly`.`catalog`.`Id`
            ORDER BY
                `autokelly`.`catalogimages`.`FileName` DESC,
                `autokelly`.`structure`.`Order`,
                `autokelly`.`catalogname`.`BG`

SELECT
                `autokelly`.`catalog`.`Id`,
                `autokelly`.`catalog`.`Type`,
                `autokelly`.`catalog`.`TecDocId`,
                `autokelly`.`structure`.`ParentId`,
                `autokelly`.`catalogname`.`CatalogNameConversionId`,
                `autokelly`.`catalogname`.`BG` AS `NodeName`,
                `autokelly`.`catalogimages`.*,
                IF(`autokelly`.`catalogvisible`.`Unvisible` IS NULL, 1, 0) AS `Visible`,
                IF(`S`.`ParentId` IS NULL, 0, 1) AS `ChildNodes`
            FROM
                `autokelly`.`structure`
                INNER JOIN `autokelly`.`catalognameconversion` ON `autokelly`.`catalognameconversion`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                INNER JOIN `autokelly`.`catalogname` ON `autokelly`.`catalogname`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id`
                INNER JOIN `autokelly`.`catalog` ON `autokelly`.`catalog`.`Id` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogimages` ON `autokelly`.`catalogimages`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogvisible` ON
                    `autokelly`.`catalogvisible`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id` AND
                    `autokelly`.`catalogvisible`.`ParentId` = `autokelly`.`structure`.`ParentId`
                LEFT JOIN `autokelly`.`structure` AS `S` ON `S`.`ParentId` = `autokelly`.`catalog`.`Id`
            WHERE
                `autokelly`.`structure`.`ParentId` = 40064029
        
            GROUP BY
                `autokelly`.`catalog`.`Id`
            ORDER BY
                `autokelly`.`catalogimages`.`FileName` DESC,
                `autokelly`.`structure`.`Order`,
                `autokelly`.`catalogname`.`BG`

SELECT
                `autokelly`.`catalog`.`Id`,
                `autokelly`.`catalog`.`Type`,
                `autokelly`.`catalog`.`TecDocId`,
                `autokelly`.`structure`.`ParentId`,
                `autokelly`.`catalogname`.`CatalogNameConversionId`,
                `autokelly`.`catalogname`.`BG` AS `NodeName`,
                `autokelly`.`catalogimages`.*,
                IF(`autokelly`.`catalogvisible`.`Unvisible` IS NULL, 1, 0) AS `Visible`,
                IF(`S`.`ParentId` IS NULL, 0, 1) AS `ChildNodes`
            FROM
                `autokelly`.`structure`
                INNER JOIN `autokelly`.`catalognameconversion` ON `autokelly`.`catalognameconversion`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                INNER JOIN `autokelly`.`catalogname` ON `autokelly`.`catalogname`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id`
                INNER JOIN `autokelly`.`catalog` ON `autokelly`.`catalog`.`Id` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogimages` ON `autokelly`.`catalogimages`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogvisible` ON
                    `autokelly`.`catalogvisible`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id` AND
                    `autokelly`.`catalogvisible`.`ParentId` = `autokelly`.`structure`.`ParentId`
                LEFT JOIN `autokelly`.`structure` AS `S` ON `S`.`ParentId` = `autokelly`.`catalog`.`Id`
            WHERE
                `autokelly`.`structure`.`ParentId` = 38957089
        
            GROUP BY
                `autokelly`.`catalog`.`Id`
            ORDER BY
                `autokelly`.`catalogimages`.`FileName` DESC,
                `autokelly`.`structure`.`Order`,
                `autokelly`.`catalogname`.`BG`

SELECT
                `autokelly`.`catalog`.`Id`,
                `autokelly`.`catalog`.`Type`,
                `autokelly`.`catalog`.`TecDocId`,
                `autokelly`.`structure`.`ParentId`,
                `autokelly`.`catalogname`.`CatalogNameConversionId`,
                `autokelly`.`catalogname`.`BG` AS `NodeName`,
                `autokelly`.`catalogimages`.*,
                IF(`autokelly`.`catalogvisible`.`Unvisible` IS NULL, 1, 0) AS `Visible`,
                IF(`S`.`ParentId` IS NULL, 0, 1) AS `ChildNodes`
            FROM
                `autokelly`.`structure`
                INNER JOIN `autokelly`.`catalognameconversion` ON `autokelly`.`catalognameconversion`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                INNER JOIN `autokelly`.`catalogname` ON `autokelly`.`catalogname`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id`
                INNER JOIN `autokelly`.`catalog` ON `autokelly`.`catalog`.`Id` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogimages` ON `autokelly`.`catalogimages`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogvisible` ON
                    `autokelly`.`catalogvisible`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id` AND
                    `autokelly`.`catalogvisible`.`ParentId` = `autokelly`.`structure`.`ParentId`
                LEFT JOIN `autokelly`.`structure` AS `S` ON `S`.`ParentId` = `autokelly`.`catalog`.`Id`
            WHERE
                `autokelly`.`structure`.`ParentId` = 38908614
        
            GROUP BY
                `autokelly`.`catalog`.`Id`
            ORDER BY
                `autokelly`.`catalogimages`.`FileName` DESC,
                `autokelly`.`structure`.`Order`,
                `autokelly`.`catalogname`.`BG`

SELECT
                `autokelly`.`catalog`.`Id`,
                `autokelly`.`catalog`.`Type`,
                `autokelly`.`catalog`.`TecDocId`,
                `autokelly`.`structure`.`ParentId`,
                `autokelly`.`catalogname`.`CatalogNameConversionId`,
                `autokelly`.`catalogname`.`BG` AS `NodeName`,
                `autokelly`.`catalogimages`.*,
                IF(`autokelly`.`catalogvisible`.`Unvisible` IS NULL, 1, 0) AS `Visible`,
                IF(`S`.`ParentId` IS NULL, 0, 1) AS `ChildNodes`
            FROM
                `autokelly`.`structure`
                INNER JOIN `autokelly`.`catalognameconversion` ON `autokelly`.`catalognameconversion`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                INNER JOIN `autokelly`.`catalogname` ON `autokelly`.`catalogname`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id`
                INNER JOIN `autokelly`.`catalog` ON `autokelly`.`catalog`.`Id` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogimages` ON `autokelly`.`catalogimages`.`CatalogId` = `autokelly`.`structure`.`CatalogId`
                LEFT JOIN `autokelly`.`catalogvisible` ON
                    `autokelly`.`catalogvisible`.`CatalogNameConversionId` = `autokelly`.`catalognameconversion`.`Id` AND
                    `autokelly`.`catalogvisible`.`ParentId` = `autokelly`.`structure`.`ParentId`
                LEFT JOIN `autokelly`.`structure` AS `S` ON `S`.`ParentId` = `autokelly`.`catalog`.`Id`
            WHERE
                `autokelly`.`structure`.`ParentId` = 40064028
        
            GROUP BY
                `autokelly`.`catalog`.`Id`
            ORDER BY
                `autokelly`.`catalogimages`.`FileName` DESC,
                `autokelly`.`structure`.`Order`,
                `autokelly`.`catalogname`.`BG`

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BGS 7073'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BGS 7073'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BGS 7073'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BGS 2243'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BGS 2243'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BGS 2243'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BGS 810'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BGS 810'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BGS 810'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'ECS VT01374'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'ECS VT01374'
            LIMIT 1

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BGS 1110'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BGS 1110'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BGS 1110'
            ORDER BY N_Item.Id

SELECT TOP 5
                Item_Id
            FROM
                N_SalesPrice
            WHERE
                Comp_id = '001' AND
                _promotype = 4 AND
                (StartingDate <= GETDATE() OR StartingDate IS NULL) AND
                (EndingDate >= GETDATE() OR EndingDate IS NULL)
            ORDER BY NEWID()

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'GOLD EAGLE 21304'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'GOLD EAGLE 21304'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'GOLD EAGLE 21304'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BOSCH F 026 C00 466'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BOSCH F 026 C00 466'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BOSCH F 026 C00 466'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BOSCH F 026 C00 468'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BOSCH F 026 C00 468'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BOSCH F 026 C00 468'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BOSCH F 026 C00 469'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BOSCH F 026 C00 469'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BOSCH F 026 C00 469'
            ORDER BY N_Item.Id

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'BOSCH 0 684 400 253'

SELECT
                `autokelly`.`product`.`Id` AS `ProductId`,
                `autokelly`.`codeprimary`.`CodeValue`,
                `autokelly`.`brand`.`Name` AS `BrandName`,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`,
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`ProducerId`,
                `elitcar_store`.`moneta`.`ProducerCode`
            FROM
                `autokelly`.`product`
                INNER JOIN `autokelly`.`brand` ON `autokelly`.`brand`.`Id` =  `autokelly`.`product`.`BrandId`
                INNER JOIN `autokelly`.`codeprimary` ON `autokelly`.`codeprimary`.`ProductId` =  `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`product`.`Id`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
                LEFT JOIN `elitcar_store`.`moneta` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`product`.`Id`
            WHERE
                `autokelly`.`product`.`Id` = 0
            LIMIT 1

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BOSCH 0 684 400 253'
            LIMIT 1

SELECT
                N_Item.Id,
                N_Item.No2,
                N_Item.FullSearch_Id,
                N_Item.FullSearchTecDoc_Id,
                N_Producer.SUP_ID,
                N_Producer.SUP_BRAND,
                N_Producer.BRA_ID,
                N_Producer.BRA_BRAND,
                N_Item.Description,
                N_Item.C_Datetime,
                N_Item.VendorNo,
                N_Item.VendorItemNo,
                N_Item.Blocked,
                N_Item._TecDocNo,
                N_Item.ReusableGroup_Id,
                N_Producer.Name,
                N_Producer._Name2,
                N_Producer.WithoutQty
            FROM
                N_Item WITH(NOLOCK)
                INNER JOIN N_Producer WITH(NOLOCK) ON (N_Producer.Id = N_Item.Producer_code)
            WHERE
                N_Item.Comp_Id = '001' AND
                N_Item.Id = 'BOSCH 0 684 400 253'
            ORDER BY N_Item.Id

Successfully disconnected from the database!
# [14-Apr-2025 15:48:03] /elitcar/www/bg/ajax/prices/promo/W00gQk9TQ0ggUyBQMDAgMDAwIDAwM10.html?_=1744634882193 108.61.209.243
# [14-Apr-2025 15:48:03] /elitcar/www/bg/ajax/prices/promo/W00gQk9TQ0ggUyBQMDAgMDAwIDE2Ml0.html?_=1744634882193 108.61.209.243
# [14-Apr-2025 15:48:03] /elitcar/www/bg/ajax/prices/promo/W00gRUNTIDE0NzE2LTcuNF0.html?_=1744634882194 108.61.209.243
# [14-Apr-2025 15:48:03] /elitcar/www/bg/ajax/prices/promo/W00gQk9TQ0ggUyBQMDAgMDAwIDE3Ml0.html?_=1744634882194 108.61.209.243
# [14-Apr-2025 15:48:03] /elitcar/www/bg/ajax/prices/promo/W00gQk9TQ0ggUyBQMDAgMDAwIDE2MF0.html?_=1744634882195 108.61.209.243
# [14-Apr-2025 15:48:03] /elitcar/www/bg/ajax/prices/promo/W00gQkdTIDczMTBd.html?_=1744634882195 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('BOSCH S P00 000 162', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('ECS 14716-7.4', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('BOSCH S P00 000 160', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('BOSCH S P00 000 172', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('BGS 7310', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('BOSCH S P00 000 003', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BOSCH S P00 000 162', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BOSCH S P00 000 172', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BGS 7310', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('ECS 14716-7.4', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BOSCH S P00 000 160', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BOSCH S P00 000 003', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BOSCH S P00 000 162'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BOSCH S P00 000 172'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BGS 7310'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'ECS 14716-7.4'
            GROUP BY fComp_Id,fItem_Id

Successfully disconnected from the database!

Successfully disconnected from the database!

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BOSCH S P00 000 160'
            GROUP BY fComp_Id,fItem_Id

Successfully disconnected from the database!

Successfully disconnected from the database!

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BOSCH S P00 000 003'
            GROUP BY fComp_Id,fItem_Id

Successfully disconnected from the database!
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gQkdTIDQxMTRd.html?_=1744634882195 108.61.209.243
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gRUNTIE9QMTAxXQ.html?_=1744634882196 108.61.209.243
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gQkdTIDc4OTBd.html?_=1744634882196 108.61.209.243

Successfully disconnected from the database!
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gQkdTIDYwNTVd.html?_=1744634882196 108.61.209.243
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gQkdTIDcwNzNd.html?_=1744634882197 108.61.209.243
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gQkdTIDIyNDNd.html?_=1744634882197 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('ECS OP101', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('BGS 7890', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('BGS 4114', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('BGS 6055', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('BGS 7073', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('ECS OP101', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BGS 7890', '', '')

SELECT * FROM  fn_EShopItemInfo_New('BGS 2243', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BGS 4114', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BGS 6055', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BGS 7073', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'ECS OP101'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BGS 7890'
            GROUP BY fComp_Id,fItem_Id

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BGS 2243', '', '')

Successfully disconnected from the database!

Successfully disconnected from the database!

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BGS 6055'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gQkdTIDgxMF0.html?_=1744634882197 108.61.209.243
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gRUNTIFZUMDEzNzRd.html?_=1744634882198 108.61.209.243

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BGS 4114'
            GROUP BY fComp_Id,fItem_Id

Successfully disconnected from the database!

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BGS 7073'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BGS 2243'
            GROUP BY fComp_Id,fItem_Id

Successfully disconnected from the database!
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gQkdTIDExMTBd.html?_=1744634882198 108.61.209.243

Successfully disconnected from the database!

Successfully disconnected from the database!
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gR09MRCBFQUdMRSAyMTMwNF0.html?_=1744634882199 108.61.209.243
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gQk9TQ0ggRiAwMjYgQzAwIDQ2Nl0.html?_=1744634882199 108.61.209.243
# [14-Apr-2025 15:48:04] /elitcar/www/bg/ajax/prices/promo/W00gQk9TQ0ggRiAwMjYgQzAwIDQ2OF0.html?_=1744634882199 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('BGS 810', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('ECS VT01374', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BGS 810', '', '')

SELECT * FROM  fn_EShopItemInfo_New('BGS 1110', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('ECS VT01374', '', '')

SELECT * FROM  fn_EShopItemInfo_New('GOLD EAGLE 21304', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('BOSCH F 026 C00 468', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('BOSCH F 026 C00 466', '', '', '');

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BGS 810'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'ECS VT01374'
            GROUP BY fComp_Id,fItem_Id

Successfully disconnected from the database!

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BGS 1110', '', '')

Successfully disconnected from the database!

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BOSCH F 026 C00 468', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('GOLD EAGLE 21304', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BOSCH F 026 C00 466', '', '')
# [14-Apr-2025 15:48:05] /elitcar/www/bg/ajax/prices/promo/W00gQk9TQ0ggRiAwMjYgQzAwIDQ2OV0.html?_=1744634882200 108.61.209.243
# [14-Apr-2025 15:48:05] /elitcar/www/bg/ajax/prices/promo/W00gQk9TQ0ggMCA2ODQgNDAwIDI1M10.html?_=1744634882200 108.61.209.243

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BOSCH F 026 C00 468'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BGS 1110'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BOSCH F 026 C00 466'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'GOLD EAGLE 21304'
            GROUP BY fComp_Id,fItem_Id

Successfully disconnected from the database!

Successfully disconnected from the database!

Successfully disconnected from the database!

Successfully disconnected from the database!

SELECT * FROM  fn_EShopItemInfo_New('BOSCH F 026 C00 469', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('BOSCH 0 684 400 253', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BOSCH F 026 C00 469', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BOSCH 0 684 400 253', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BOSCH F 026 C00 469'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BOSCH 0 684 400 253'
            GROUP BY fComp_Id,fItem_Id

Successfully disconnected from the database!

Successfully disconnected from the database!
# [14-Apr-2025 15:48:09] /elitcar/www/bg/manufacturers.html 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LSearchNumber','LSearchPart','ErrorValidNumber','LSearchCar','LManufacturer','LYear','LModel','LType') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LShowAll') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LModelSearchPlaceholder') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC
# [14-Apr-2025 15:49:02] /elitcar/www/bg/models/16.html 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LModelSeries','LYear') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LShowAll') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LAll') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC
# [14-Apr-2025 15:49:05] /elitcar/www/bg/types/16-39565.html 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LModel','LYear','LType','LFuel','LEngine') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LAll','LShowAll') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC
# [14-Apr-2025 15:49:07] /elitcar/www/bg/ajax/types/choice/142450.html?_=1744634946085 108.61.209.243

set names utf8

SELECT
                `autokelly`.`catalog`.`Id`
            FROM
                `autokelly`.`catalog`
                INNER JOIN `autokelly`.`structure` ON `autokelly`.`catalog`.`Id` = `autokelly`.`structure`.`ParentId`
                INNER JOIN `autokelly`.`catalog` AS `C2` ON `C2`.`Id` = `autokelly`.`structure`.`CatalogId` AND `C2`.`TecDocId` IS NULL
            WHERE
                `autokelly`.`catalog`.`Type` = 101 AND
                `autokelly`.`catalog`.`TecDocId` = 142450
            GROUP BY
                `autokelly`.`catalog`.`Id`
            LIMIT 1
# [14-Apr-2025 15:49:08] /elitcar/www/bg/tree/16-39565-142450.html 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LSearchTree','LSearchWord','LTreeSearchPlaceholder') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC
# [14-Apr-2025 15:49:15] /elitcar/www/bg/tecdoc/16-39565-142450/tn_100259.html 108.61.209.243
# [14-Apr-2025 15:49:15] /elitcar/www/bg/tecdoc/16-39565-142450/tn_100259.html 108.61.209.243

set names utf8

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'e50406' AND `ProducerId` = 4814

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'azmt410401342' AND `ProducerId` = 5275

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '1510252' AND `ProducerId` = 317

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'md3021' AND `ProducerId` = 180

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'fof10062' AND `ProducerId` = 146

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'anf0450' AND `ProducerId` = 7678

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'la120k' AND `ProducerId` = 4280

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'adbp210008' AND `ProducerId` = 350

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BLUE PRINT ADBP210008'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'b8113141' AND `ProducerId` = 5349

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'b10437' AND `ProducerId` = 4815

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'f026407277' AND `ProducerId` = 30

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'BOSCH F 026 407 277'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'cof100698e' AND `ProducerId` = 43

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'CHAMPION COF100698E'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'eof336' AND `ProducerId` = 421

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'fa6816eco' AND `ProducerId` = 437

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'v109' AND `ProducerId` = 7368

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'a211053' AND `ProducerId` = 186

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'dl1336' AND `ProducerId` = 4396

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'dp1110110340' AND `ProducerId` = 4948

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '1682954980' AND `ProducerId` = 4391

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '170546' AND `ProducerId` = 101

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'FEBI 170546'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'oe6729' AND `ProducerId` = 256

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'FILTRON OE 672/9'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'ch12454eco' AND `ProducerId` = 59

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'e951hd497' AND `ProducerId` = 81

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'so7297' AND `ProducerId` = 6309

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '14456' AND `ProducerId` = 341

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'f122101' AND `ProducerId` = 185

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'fof10062' AND `ProducerId` = 201

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'ox1238d' AND `ProducerId` = 34

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'KNECHT OX 1238D'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'lfoe347' AND `ProducerId` = 4501

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'lfoe347' AND `ProducerId` = 4973

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'lo1016' AND `ProducerId` = 4600

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '153071762491' AND `ProducerId` = 95

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MAGNETI MARELLI 153071762491'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'ox1238d' AND `ProducerId` = 287

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'hu6012zkit' AND `ProducerId` = 4

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MANN HU 6012 Z KIT'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '6012zofspcsms' AND `ProducerId` = 358

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '262090' AND `ProducerId` = 403

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '14456' AND `ProducerId` = 244

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'elh4516' AND `ProducerId` = 218

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'l210' AND `ProducerId` = 4470

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'lvfl858' AND `ProducerId` = 4564

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'fop406' AND `ProducerId` = 490

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'eof425610' AND `ProducerId` = 378

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'opfof40231' AND `ProducerId` = 129

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'pta4210033' AND `ProducerId` = 6457

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'pta4210034' AND `ProducerId` = 6457

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '1f0164' AND `ProducerId` = 6983

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'l1133' AND `ProducerId` = 38

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'purpo3043' AND `ProducerId` = 6891

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'qfl0376' AND `ProducerId` = 57

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '7o0266p' AND `ProducerId` = 6358

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 's5211pe' AND `ProducerId` = 142

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '2050802sx' AND `ProducerId` = 4595

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'op1066' AND `ProducerId` = 91

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '2521100' AND `ProducerId` = 137

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'UFI 25.211.00'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '586669' AND `ProducerId` = 21

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'VALEO 586669'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'v20600106' AND `ProducerId` = 183

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'VEMO V20-60-0106'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'v206001061' AND `ProducerId` = 183

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'v20600110' AND `ProducerId` = 183

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'VEMO V20-60-0110'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '19992601' AND `ProducerId` = 4346

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'vol807071' AND `ProducerId` = 7745

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg1989902' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2217429' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2228743' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2260331' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2326161' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2360900' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2414432' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wl7556' AND `ProducerId` = 324

Successfully disconnected from the database!
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/moneta/sort.html?_=1744634956791 108.61.209.243

set names utf8

SELECT
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`Sales`,
                `elitcar_store`.`moneta`.`Qty`,
                `elitcar_store`.`moneta`.`QtyAll`,
                `elitcar_store`.`moneta`.`FullSearchTecDocId`
            FROM
                `elitcar_store`.`moneta`
                LEFT JOIN `elitcar_store`.`availabilities` ON `elitcar_store`.`moneta`.`MonetaId` = `elitcar_store`.`availabilities`.`MonetaId` AND `elitcar_store`.`availabilities`.`BusinessGroupID` = ''
            WHERE
                `elitcar_store`.`moneta`.`MonetaId` IN('BLUE PRINT ADBP210008','BOSCH F 026 407 277','CHAMPION COF100698E','FEBI 170546','FILTRON OE 672/9','KNECHT OX 1238D','MAGNETI MARELLI 153071762491','MANN HU 6012 Z KIT','UFI 25.211.00','VALEO 586669','VEMO V20-60-0106','VEMO V20-60-0110')
            ORDER BY
                `elitcar_store`.`availabilities`.`Qty` DESC,
                `elitcar_store`.`moneta`.`Qty` DESC,
                `elitcar_store`.`moneta`.`QtyAll` DESC,
                `elitcar_store`.`moneta`.`Sales` DESC
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gQk9TQ0ggRiAwMjYgNDA3IDI3N10.html?_=1744634956878 108.61.209.243
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gS05FQ0hUIE9YIDEyMzhEXQ.html?_=1744634956879 108.61.209.243
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gRklMVFJPTiBPRSA2NzIvOV0.html?_=1744634956879 108.61.209.243
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gTUFOTiBIVSA2MDEyIFogS0lUXQ.html?_=1744634956879 108.61.209.243
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gVkVNTyBWMjAtNjAtMDEwNl0.html?_=1744634956880 108.61.209.243
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gVkVNTyBWMjAtNjAtMDExMF0.html?_=1744634956881 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('BOSCH F 026 407 277', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('FILTRON OE 672/9', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('KNECHT OX 1238D', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('VEMO V20-60-0106', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('MANN HU 6012 Z KIT', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('VEMO V20-60-0110', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BOSCH F 026 407 277', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('FILTRON OE 672/9', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('VEMO V20-60-0106', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MANN HU 6012 Z KIT', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('VEMO V20-60-0110', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('KNECHT OX 1238D', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BOSCH F 026 407 277'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'FILTRON OE 672/9'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'VEMO V20-60-0106'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'VEMO V20-60-0110'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MANN HU 6012 Z KIT'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gQk9TQ0ggRiAwMjYgNDA3IDI3N10.html?_=1744634956878 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'KNECHT OX 1238D'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gRklMVFJPTiBPRSA2NzIvOV0.html?_=1744634956879 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gVkVNTyBWMjAtNjAtMDEwNl0.html?_=1744634956880 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gVkVNTyBWMjAtNjAtMDExMF0.html?_=1744634956881 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gTUFOTiBIVSA2MDEyIFogS0lUXQ.html?_=1744634956879 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gQkxVRSBQUklOVCBBREJQMjEwMDA4XQ.html?_=1744634956881 108.61.209.243
# [14-Apr-2025 15:49:18] /elitcar/www/bg/ajax/prices/W00gS05FQ0hUIE9YIDEyMzhEXQ.html?_=1744634956879 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!

SELECT * FROM  fn_EShopItemInfo_New('BLUE PRINT ADBP210008', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('BLUE PRINT ADBP210008', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'BLUE PRINT ADBP210008'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:49:19] /elitcar/www/bg/ajax/prices/W00gQkxVRSBQUklOVCBBREJQMjEwMDA4XQ.html?_=1744634956881 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:20] /elitcar/www/bg/ajax/prices/W00gRkVCSSAxNzA1NDZd.html?_=1744634958538 108.61.209.243
# [14-Apr-2025 15:49:20] /elitcar/www/bg/ajax/prices/W00gQ0hBTVBJT04gQ09GMTAwNjk4RV0.html?_=1744634958539 108.61.209.243
# [14-Apr-2025 15:49:20] /elitcar/www/bg/ajax/prices/W00gTUFHTkVUSSBNQVJFTExJIDE1MzA3MTc2MjQ5MV0.html?_=1744634958540 108.61.209.243
# [14-Apr-2025 15:49:20] /elitcar/www/bg/ajax/prices/W00gVUZJIDI1LjIxMS4wMF0.html?_=1744634958542 108.61.209.243
# [14-Apr-2025 15:49:20] /elitcar/www/bg/ajax/prices/W00gVkFMRU8gNTg2NjY5XQ.html?_=1744634958543 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('FEBI 170546', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('MAGNETI MARELLI 153071762491', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('CHAMPION COF100698E', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('UFI 25.211.00', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('VALEO 586669', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('FEBI 170546', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MAGNETI MARELLI 153071762491', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('CHAMPION COF100698E', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('UFI 25.211.00', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('VALEO 586669', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'FEBI 170546'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MAGNETI MARELLI 153071762491'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'CHAMPION COF100698E'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'UFI 25.211.00'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'VALEO 586669'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:49:20] /elitcar/www/bg/ajax/prices/W00gRkVCSSAxNzA1NDZd.html?_=1744634958538 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:20] /elitcar/www/bg/ajax/prices/W00gTUFHTkVUSSBNQVJFTExJIDE1MzA3MTc2MjQ5MV0.html?_=1744634958540 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:20] /elitcar/www/bg/ajax/prices/W00gQ0hBTVBJT04gQ09GMTAwNjk4RV0.html?_=1744634958539 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:20] /elitcar/www/bg/ajax/prices/W00gVUZJIDI1LjIxMS4wMF0.html?_=1744634958542 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:20] /elitcar/www/bg/ajax/prices/W00gVkFMRU8gNTg2NjY5XQ.html?_=1744634958543 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:32] /elitcar/www/bg/tecdoc/16-39565-142450/tn_104377.html 108.61.209.243
# [14-Apr-2025 15:49:33] /elitcar/www/bg/tecdoc/16-39565-142450/tn_104377.html 108.61.209.243

set names utf8

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'b10371' AND `ProducerId` = 4815

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'pm011200' AND `ProducerId` = 4514

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'ET ENGINETEAM PM011200'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'pr260000' AND `ProducerId` = 267

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'fr10079500' AND `ProducerId` = 235

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'FRECCIA FR10-079500'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '0845340000' AND `ProducerId` = 385

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '42101600' AND `ProducerId` = 432

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'KS 42 101 600'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '800121410000' AND `ProducerId` = 432

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'KS 80 01214 1 0 000'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '800125310000' AND `ProducerId` = 432

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'KS 80 01253 1 0 000'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '081pi00124000' AND `ProducerId` = 287

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MAHLE 081 PI 00124 000'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '081pi00125000' AND `ProducerId` = 287

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MAHLE 081 PI 00125 000'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '081pi00130000' AND `ProducerId` = 287

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MAHLE 081 PI 00130 000'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '081pi00130002' AND `ProducerId` = 287

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MAHLE 081 PI 00130 002'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '081rs001070n0' AND `ProducerId` = 287

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MAHLE 081 RS 00107 0N0'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '081rs001250n0' AND `ProducerId` = 287

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MAHLE 081 RS 00125 0N0'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '081rs001290n0' AND `ProducerId` = 287

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MAHLE 081 RS 00129 0N0'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'mv3130162000' AND `ProducerId` = 5645

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '120007006300' AND `ProducerId` = 4717

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '8745340000' AND `ProducerId` = 216

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'NURAL 87-453400-00'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg1889359' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg1967155' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2170522' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2178568' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2179683' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2198352' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2264125' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2264127' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2294865' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2295479' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2331600' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2338983' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2377815' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2470609' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '3130047000' AND `ProducerId` = 4402

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '3130162000' AND `ProducerId` = 4402

Successfully disconnected from the database!
# [14-Apr-2025 15:49:35] /elitcar/www/bg/ajax/moneta/sort.html?_=1744634974390 108.61.209.243

set names utf8

SELECT
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`Sales`,
                `elitcar_store`.`moneta`.`Qty`,
                `elitcar_store`.`moneta`.`QtyAll`,
                `elitcar_store`.`moneta`.`FullSearchTecDocId`
            FROM
                `elitcar_store`.`moneta`
                LEFT JOIN `elitcar_store`.`availabilities` ON `elitcar_store`.`moneta`.`MonetaId` = `elitcar_store`.`availabilities`.`MonetaId` AND `elitcar_store`.`availabilities`.`BusinessGroupID` = ''
            WHERE
                `elitcar_store`.`moneta`.`MonetaId` IN('ET ENGINETEAM PM011200','FRECCIA FR10-079500','KS 42 101 600','KS 80 01214 1 0 000','KS 80 01253 1 0 000','MAHLE 081 PI 00124 000','MAHLE 081 PI 00125 000','MAHLE 081 PI 00130 000','MAHLE 081 PI 00130 002','MAHLE 081 RS 00107 0N0','MAHLE 081 RS 00125 0N0','MAHLE 081 RS 00129 0N0','NURAL 87-453400-00')
            ORDER BY
                `elitcar_store`.`availabilities`.`Qty` DESC,
                `elitcar_store`.`moneta`.`Qty` DESC,
                `elitcar_store`.`moneta`.`QtyAll` DESC,
                `elitcar_store`.`moneta`.`Sales` DESC
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gTlVSQUwgODctNDUzNDAwLTAwXQ.html?_=1744634974485 108.61.209.243
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gRVQgRU5HSU5FVEVBTSBQTTAxMTIwMF0.html?_=1744634974485 108.61.209.243
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gRlJFQ0NJQSBGUjEwLTA3OTUwMF0.html?_=1744634974485 108.61.209.243
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gS1MgNDIgMTAxIDYwMF0.html?_=1744634974486 108.61.209.243
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gS1MgODAgMDEyMTQgMSAwIDAwMF0.html?_=1744634974487 108.61.209.243
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gS1MgODAgMDEyNTMgMSAwIDAwMF0.html?_=1744634974489 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('FRECCIA FR10-079500', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('NURAL 87-453400-00', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('KS 80 01253 1 0 000', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('KS 42 101 600', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('ET ENGINETEAM PM011200', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('KS 80 01214 1 0 000', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('KS 80 01253 1 0 000', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('NURAL 87-453400-00', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('FRECCIA FR10-079500', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('KS 42 101 600', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('ET ENGINETEAM PM011200', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('KS 80 01214 1 0 000', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'KS 80 01253 1 0 000'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'NURAL 87-453400-00'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'FRECCIA FR10-079500'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'KS 42 101 600'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'KS 80 01214 1 0 000'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'ET ENGINETEAM PM011200'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gS1MgODAgMDEyNTMgMSAwIDAwMF0.html?_=1744634974489 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gTlVSQUwgODctNDUzNDAwLTAwXQ.html?_=1744634974485 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gRlJFQ0NJQSBGUjEwLTA3OTUwMF0.html?_=1744634974485 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gS1MgNDIgMTAxIDYwMF0.html?_=1744634974486 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gS1MgODAgMDEyMTQgMSAwIDAwMF0.html?_=1744634974487 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gRVQgRU5HSU5FVEVBTSBQTTAxMTIwMF0.html?_=1744634974485 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTI0IDAwMF0.html?_=1744634974489 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('MAHLE 081 PI 00124 000', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MAHLE 081 PI 00124 000', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MAHLE 081 PI 00124 000'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:49:36] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTI0IDAwMF0.html?_=1744634974489 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:37] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTMwIDAwMF0.html?_=1744634975941 108.61.209.243
# [14-Apr-2025 15:49:37] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTI1IDAwMF0.html?_=1744634975940 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('MAHLE 081 PI 00130 000', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('MAHLE 081 PI 00125 000', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MAHLE 081 PI 00130 000', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MAHLE 081 PI 00125 000', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MAHLE 081 PI 00130 000'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MAHLE 081 PI 00125 000'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:49:37] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTMwIDAwMF0.html?_=1744634975941 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:37] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTI1IDAwMF0.html?_=1744634975940 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:38] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTMwIDAwMl0.html?_=1744634976790 108.61.209.243
# [14-Apr-2025 15:49:38] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFJTIDAwMTA3IDBOMF0.html?_=1744634976791 108.61.209.243
# [14-Apr-2025 15:49:38] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFJTIDAwMTI1IDBOMF0.html?_=1744634976792 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('MAHLE 081 RS 00125 0N0', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('MAHLE 081 PI 00130 002', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('MAHLE 081 RS 00107 0N0', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MAHLE 081 PI 00130 002', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MAHLE 081 RS 00125 0N0', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MAHLE 081 RS 00107 0N0', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MAHLE 081 PI 00130 002'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MAHLE 081 RS 00125 0N0'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MAHLE 081 RS 00107 0N0'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:49:38] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTMwIDAwMl0.html?_=1744634976790 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:38] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFJTIDAwMTI1IDBOMF0.html?_=1744634976792 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:38] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFJTIDAwMTA3IDBOMF0.html?_=1744634976791 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:38] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFJTIDAwMTI5IDBOMF0.html?_=1744634977365 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('MAHLE 081 RS 00129 0N0', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MAHLE 081 RS 00129 0N0', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MAHLE 081 RS 00129 0N0'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:49:39] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFJTIDAwMTI5IDBOMF0.html?_=1744634977365 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:49:53] /elitcar/www/bg/ajax/substitutes/WzQzMl1bNDIxMDE2MDBd.html?_=1744634991213 108.61.209.243

set names utf8

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '081pi00125000' AND `ProducerId` = 287

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MAHLE 081 PI 00125 000'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2179683' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2377815' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '3130162000' AND `ProducerId` = 4402

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '42101600' AND `ProducerId` = 432

SELECT `ProductId` FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'KS 42 101 600' LIMIT 1

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'KS 42 101 600' LIMIT 1
# [14-Apr-2025 15:49:53] /elitcar/www/bg/ajax/moneta/sort.html?_=1744634991559 108.61.209.243

set names utf8

SELECT
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`Sales`,
                `elitcar_store`.`moneta`.`Qty`,
                `elitcar_store`.`moneta`.`QtyAll`,
                `elitcar_store`.`moneta`.`FullSearchTecDocId`
            FROM
                `elitcar_store`.`moneta`
                LEFT JOIN `elitcar_store`.`availabilities` ON `elitcar_store`.`moneta`.`MonetaId` = `elitcar_store`.`availabilities`.`MonetaId` AND `elitcar_store`.`availabilities`.`BusinessGroupID` = ''
            WHERE
                `elitcar_store`.`moneta`.`MonetaId` IN('MAHLE 081 PI 00125 000')
            ORDER BY
                `elitcar_store`.`availabilities`.`Qty` DESC,
                `elitcar_store`.`moneta`.`Qty` DESC,
                `elitcar_store`.`moneta`.`QtyAll` DESC,
                `elitcar_store`.`moneta`.`Sales` DESC
# [14-Apr-2025 15:49:53] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTI1IDAwMF0.html?_=1744634991613 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('MAHLE 081 PI 00125 000', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MAHLE 081 PI 00125 000', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MAHLE 081 PI 00125 000'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:49:53] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTI1IDAwMF0.html?_=1744634991613 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:50:03] /elitcar/www/bg/tecdoc/287/WzI4N11bMDgxIFBJIDAwMTI1IDAwMF1bTSBNQUhMRSAwODEgUEkgMDAxMjUgMDAwXQ.html?sn=081 PI 00125 000 108.61.209.243

set names utf8

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MAHLE 081 PI 00125 000'
            LIMIT 1

SELECT
                `elitcar_store`.`moneta`.`ProductId`
            FROM
                `elitcar_store`.`moneta`
                INNER JOIN `autokelly`.`recommended` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`recommended`.`ProductId`
            WHERE
                `elitcar_store`.`moneta`.`MonetaId` = 'MAHLE 081 PI 00125 000'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'pm011200' AND `ProducerId` = 4514

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'ET ENGINETEAM PM011200'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '42101600' AND `ProducerId` = 432

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'KS 42 101 600'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '081pi00125000' AND `ProducerId` = 287

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'mv3130162000' AND `ProducerId` = 5645

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2179683' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2377815' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '3130162000' AND `ProducerId` = 4402

SELECT `ProductId` FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'MAHLE 081 PI 00125 000' LIMIT 1

SELECT `ReusableGroupId` FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'MAHLE 081 PI 00125 000' LIMIT 1

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'MAHLE 081 PI 00125 000' LIMIT 1
# [14-Apr-2025 15:50:05] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTI1IDAwMF0.html?_=1744635003713 108.61.209.243
# [14-Apr-2025 15:50:05] /elitcar/www/bg/ajax/moneta/sort.html?_=1744635003714 108.61.209.243

set names utf8

SELECT
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`Sales`,
                `elitcar_store`.`moneta`.`Qty`,
                `elitcar_store`.`moneta`.`QtyAll`,
                `elitcar_store`.`moneta`.`FullSearchTecDocId`
            FROM
                `elitcar_store`.`moneta`
                LEFT JOIN `elitcar_store`.`availabilities` ON `elitcar_store`.`moneta`.`MonetaId` = `elitcar_store`.`availabilities`.`MonetaId` AND `elitcar_store`.`availabilities`.`BusinessGroupID` = ''
            WHERE
                `elitcar_store`.`moneta`.`MonetaId` IN('ET ENGINETEAM PM011200','KS 42 101 600')
            ORDER BY
                `elitcar_store`.`availabilities`.`Qty` DESC,
                `elitcar_store`.`moneta`.`Qty` DESC,
                `elitcar_store`.`moneta`.`QtyAll` DESC,
                `elitcar_store`.`moneta`.`Sales` DESC
# [14-Apr-2025 15:50:05] /elitcar/www/bg/ajax/prices/W00gRVQgRU5HSU5FVEVBTSBQTTAxMTIwMF0.html?_=1744635003797 108.61.209.243
# [14-Apr-2025 15:50:05] /elitcar/www/bg/ajax/prices/W00gS1MgNDIgMTAxIDYwMF0.html?_=1744635003797 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('MAHLE 081 PI 00125 000', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MAHLE 081 PI 00125 000', '', '')

SELECT * FROM  fn_EShopItemInfo_New('KS 42 101 600', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('ET ENGINETEAM PM011200', '', '', '');

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MAHLE 081 PI 00125 000'
            GROUP BY fComp_Id,fItem_Id

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('KS 42 101 600', '', '')

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('ET ENGINETEAM PM011200', '', '')
# [14-Apr-2025 15:50:05] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTI1IDAwMF0.html?_=1744635003713 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'KS 42 101 600'
            GROUP BY fComp_Id,fItem_Id

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'ET ENGINETEAM PM011200'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:50:05] /elitcar/www/bg/ajax/prices/W00gS1MgNDIgMTAxIDYwMF0.html?_=1744635003797 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:50:05] /elitcar/www/bg/ajax/prices/W00gRVQgRU5HSU5FVEVBTSBQTTAxMTIwMF0.html?_=1744635003797 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:50:15] /elitcar/www/bg/ajax/substitutes/WzQ1MTRdW1BNMDExMjAwXQ.html?_=1744635014068 108.61.209.243

set names utf8

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'pm011200' AND `ProducerId` = 4514

SELECT `ProductId` FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'ET ENGINETEAM PM011200' LIMIT 1

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'ET ENGINETEAM PM011200' LIMIT 1
# [14-Apr-2025 15:50:21] /elitcar/www/bg/tecdoc/287/WzI4N11bMDgxIFBJIDAwMTI1IDAwMF1bTSBNQUhMRSAwODEgUEkgMDAxMjUgMDAwXQ.html?sn=081 PI 00125 000 108.61.209.243

set names utf8

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'MAHLE 081 PI 00125 000'
            LIMIT 1

SELECT
                `elitcar_store`.`moneta`.`ProductId`
            FROM
                `elitcar_store`.`moneta`
                INNER JOIN `autokelly`.`recommended` ON `elitcar_store`.`moneta`.`ProductId` = `autokelly`.`recommended`.`ProductId`
            WHERE
                `elitcar_store`.`moneta`.`MonetaId` = 'MAHLE 081 PI 00125 000'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'pm011200' AND `ProducerId` = 4514

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'ET ENGINETEAM PM011200'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '42101600' AND `ProducerId` = 432

SELECT
                `BrandID`,
                `Gallery`,
                `Title`,
                `Content`
            FROM
                `elitcar_store`.`products`
            WHERE
                `MonetaID` = 'KS 42 101 600'
            LIMIT 1

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '081pi00125000' AND `ProducerId` = 287

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'mv3130162000' AND `ProducerId` = 5645

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2179683' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = 'wg2377815' AND `ProducerId` = 4832

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '3130162000' AND `ProducerId` = 4402

SELECT `ProductId` FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'MAHLE 081 PI 00125 000' LIMIT 1

SELECT `ReusableGroupId` FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'MAHLE 081 PI 00125 000' LIMIT 1

SELECT * FROM `elitcar_store`.`moneta` WHERE `MonetaId` = 'MAHLE 081 PI 00125 000' LIMIT 1
# [14-Apr-2025 15:50:22] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTI1IDAwMF0.html?_=1744635021036 108.61.209.243
# [14-Apr-2025 15:50:22] /elitcar/www/bg/ajax/moneta/sort.html?_=1744635021037 108.61.209.243

set names utf8

SELECT
                `elitcar_store`.`moneta`.`MonetaId`,
                `elitcar_store`.`moneta`.`Sales`,
                `elitcar_store`.`moneta`.`Qty`,
                `elitcar_store`.`moneta`.`QtyAll`,
                `elitcar_store`.`moneta`.`FullSearchTecDocId`
            FROM
                `elitcar_store`.`moneta`
                LEFT JOIN `elitcar_store`.`availabilities` ON `elitcar_store`.`moneta`.`MonetaId` = `elitcar_store`.`availabilities`.`MonetaId` AND `elitcar_store`.`availabilities`.`BusinessGroupID` = ''
            WHERE
                `elitcar_store`.`moneta`.`MonetaId` IN('ET ENGINETEAM PM011200','KS 42 101 600')
            ORDER BY
                `elitcar_store`.`availabilities`.`Qty` DESC,
                `elitcar_store`.`moneta`.`Qty` DESC,
                `elitcar_store`.`moneta`.`QtyAll` DESC,
                `elitcar_store`.`moneta`.`Sales` DESC
# [14-Apr-2025 15:50:22] /elitcar/www/bg/ajax/prices/W00gRVQgRU5HSU5FVEVBTSBQTTAxMTIwMF0.html?_=1744635021107 108.61.209.243
# [14-Apr-2025 15:50:22] /elitcar/www/bg/ajax/prices/W00gS1MgNDIgMTAxIDYwMF0.html?_=1744635021108 108.61.209.243

SELECT * FROM  fn_EShopItemInfo_New('MAHLE 081 PI 00125 000', '', '', '');

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('MAHLE 081 PI 00125 000', '', '')

SELECT * FROM  fn_EShopItemInfo_New('ET ENGINETEAM PM011200', '', '', '');

SELECT * FROM  fn_EShopItemInfo_New('KS 42 101 600', '', '', '');

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'MAHLE 081 PI 00125 000'
            GROUP BY fComp_Id,fItem_Id

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('ET ENGINETEAM PM011200', '', '')
# [14-Apr-2025 15:50:22] /elitcar/www/bg/ajax/prices/W00gTUFITEUgMDgxIFBJIDAwMTI1IDAwMF0.html?_=1744635021036 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!

SELECT AuctionDescription FROM fn_EShopItemInfoGiftsAuctionDesc_ElitCar('KS 42 101 600', '', '')

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'ET ENGINETEAM PM011200'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:50:23] /elitcar/www/bg/ajax/prices/W00gRVQgRU5HSU5FVEVBTSBQTTAxMTIwMF0.html?_=1744635021107 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!

SELECT
                SUM(sQuantity) AS sQuantity
            FROM
                G_LItemEntry_0 E WITH(NOLOCK)
                INNER JOIN N_Businessgroup B WITH(NOLOCK) ON (B.Id=E.fBusinessGroup_Id) AND (B.Comp_Id=E.fComp_Id)
            WHERE
                E.SLevel=3 AND
                E.fComp_Id = '001' AND
                B.IsOuterBG = 1 AND
                E.fBusinessGroup_Id > 74 AND
                e.fItem_Id = 'KS 42 101 600'
            GROUP BY fComp_Id,fItem_Id
# [14-Apr-2025 15:50:23] /elitcar/www/bg/ajax/prices/W00gS1MgNDIgMTAxIDYwMF0.html?_=1744635021108 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LPriceForYou','InfoDeposit','LDeposit','InfoDeliveryTaxes','LSevenDays','LAction','LAdd','LReplace','LDeliveryNoReturn','LOutOfStock') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

Successfully disconnected from the database!
# [14-Apr-2025 15:50:31] /elitcar/www/bg/ajax/search/select.html?keyword=081 PI 00125 000&_=1744635029916 108.61.209.243

set names utf8

SELECT `MonetaId` FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` = '081pi00125000' AND `ProducerId` = 287

SELECT
                `autokelly`.`codeoem`.*,
                `autokelly`.`producttextname`.`BG` AS `ProductTitle`
            FROM
                `autokelly`.`codeoem`
                INNER JOIN `autokelly`.`producttextnameconversion` ON `autokelly`.`producttextnameconversion`.`ProductId` = `autokelly`.`codeoem`.`ProductId`
                INNER JOIN `autokelly`.`producttextname` ON `autokelly`.`producttextname`.`ProductTextNameConversionId` = `autokelly`.`producttextnameconversion`.`Id`
            WHERE
                MATCH(`CodeValue`) AGAINST ('081pi00125000')
            HAVING
                `CodeValue` LIKE ('081pi00125000%')
            LIMIT 9

SELECT * FROM `elitcar_store`.`moneta` WHERE `FullSearchTecDocId` LIKE '081pi00125000%' LIMIT 9
# [14-Apr-2025 15:51:37] /elitcar/www/bg/manufacturers.html 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LSearchNumber','LSearchPart','ErrorValidNumber','LSearchCar','LManufacturer','LYear','LModel','LType') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LShowAll') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LModelSearchPlaceholder') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC
# [14-Apr-2025 15:51:40] /elitcar/www/bg/models/36.html 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LModelSeries','LYear') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LShowAll') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LAll') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC
# [14-Apr-2025 15:51:50] /elitcar/www/bg/models/36.html 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LModelSeries','LYear') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LShowAll') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `elitcar_store`.`labels`
            WHERE
                `Label` IN ('LAll') AND
                `Language` = 'bg'
             ORDER BY
                `elitcar_store`.`labels`.`Label` ASC
