# [15-Feb-2023 12:18:49] /vipcat/root/ 167.99.142.201

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [15-Feb-2023 12:19:24] /vipcat/root/?customer=ZZ059&SID=347F8F2C5F7C42B39400884F5586EFFD527032&SPRN=32 167.99.142.201

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [15-Feb-2023 12:19:24] /vipcat/root/bg/ajax/users/session.html?_=1676456369500 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

DELETE FROM `token`

INSERT INTO `token` (`ID`, `Token`, `Expires`) VALUES (NULL, '-KuukFl98m5gBEVgjJ65gTzNv45uvDBfL-HgejySpHJ3GBRrD-jFmgUsxgaKAYL5kbiNNRG5GzSjxRAcy_nmtDUj7RsphDtt02lwVrzmF3o_q5Ub4n71n2cBvg1i2xQviIXaeVWjyOZCs0SDFVicJPHT7do7OFK_NrLi8BHx70-5-OswPlh55jdqpAl0gEVzUbhzFxrEmsEd3BMk_ASPnXZRcACe2H-4AVL6VvExRvamuxriVnmR_tfuNBWqv9DJFnzmTI_EvZTLMuuWdslPfU0c2yugHQIVcDat87t_iaX97xPfVaZpnzKYFCVq8b4jlQTGq6gzyhXlmOhXmQ_85zFEI0p4PNhiB5MXIA9CsJgCBv0J-eGBR8INY4W8_V4xZqnvB_iN8te0XaJbJpzbisCadqM8F62SAZCpedD4-eJ6MMJ9QtQbQo4LiViXCFJeCYmQA5hCrRJvnJMCqsw0rniySXQIZC1NwiwiKZhvmyfSp15BhV6LL5IubquodRrEhyNKvNKmFE-DZlSWywZJoA', '2023-03-01')

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:19:24] /vipcat/root/bg/ajax/prices.html?_=1676456370022 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 12:19:26] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 12:19:27] /vipcat/root/bg/ajax/users/session.html?_=1676456372263 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:19:27] /vipcat/root/bg/ajax/prices.html?_=1676456372530 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 12:46:32] /vipcat/root/ 167.99.142.201

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [15-Feb-2023 12:46:32] /vipcat/root/bg/ajax/users/session.html?_=1676457997635 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:46:32] /vipcat/root/bg/ajax/prices.html?_=1676457997938 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 12:46:36] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 12:46:36] /vipcat/root/bg/ajax/users/session.html?_=1676458001457 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:46:36] /vipcat/root/bg/ajax/prices.html?_=1676458001690 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 12:46:39] /vipcat/root/bg/ajax/basket/add.html?_=1676458004803 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6', NOW(), NOW(), '{"eyJpZCI6IjEifQ":1}', 1)
# [15-Feb-2023 12:46:42] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1
# [15-Feb-2023 12:46:42] /vipcat/root/bg/ajax/users/session.html?_=1676458007540 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:46:56] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:49:14] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:49:14] /vipcat/root/bg/ajax/users/session.html?_=1676458159392 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:49:57] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:49:57] /vipcat/root/bg/ajax/users/session.html?_=1676458203110 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:51:39] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:51:39] /vipcat/root/bg/ajax/users/session.html?_=1676458304927 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:52:02] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:52:02] /vipcat/root/bg/ajax/users/session.html?_=1676458327775 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:52:28] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:52:28] /vipcat/root/bg/ajax/users/session.html?_=1676458353957 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:53:24] /vipcat/root/ 167.99.142.201

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [15-Feb-2023 12:53:24] /vipcat/root/bg/ajax/users/session.html?_=1676458410035 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:53:25] /vipcat/root/bg/ajax/prices.html?_=1676458410290 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 12:53:27] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 12:53:27] /vipcat/root/bg/ajax/users/session.html?_=1676458413052 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:53:28] /vipcat/root/bg/ajax/prices.html?_=1676458413284 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 12:53:30] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 12:53:30] /vipcat/root/bg/ajax/users/session.html?_=1676458415844 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:53:30] /vipcat/root/bg/ajax/prices.html?_=1676458416086 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 12:53:35] /vipcat/root/bg/ajax/basket/add.html?_=1676458420631 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6', NOW(), NOW(), '{"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":1}', 1)
# [15-Feb-2023 12:53:42] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:53:43] /vipcat/root/bg/ajax/users/session.html?_=1676458428379 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:54:06] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:54:06] /vipcat/root/bg/ajax/users/session.html?_=1676458451711 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:54:11] /vipcat/root/bg/ajax/orders/submit.html?_=1676458456606 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT
                `orders`.`ID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2023-02-15 12:54:11', `Data` = 'VdllfW9yJ4FcHgVc_98znD1X14-P8qPpYrkcqMfBc5EinebStwyiHimw17ehtkCZqISG7GRT9IzyV2Jv97V4eVbTHlJPfiF33NgtNNm-eEVYCq8TystbfYgNEXNS_LSOQiPKe5JHdM8fCnEhQt8JIKN7Uoj4SGC-hjRcp2PlnJyWvdhDsootv30wQZ7m0Jib5w0tJ5YwIZw8DtF7_J95xuN3OZY3vaRmcRxom9c3H7IusE7Fzk4K__480haZsmoISpeJ9eErF1PKJR3yAZ0STTqRxmLkJldDGSMn60yaNjxpzB1vrcOgo7rzioVSAIZ5bnaxua3pNBT5drjXUD068iETkDjHTv1H6MMUbtVe3Aa4NAtML0nwvYxHPIVQQKyQMonQIEMFIkp4ZFdjVahlqmMpzMN2IZ4gcNdHNvzhf9-AiDq3fU515ULNnJOV2MKHEx1qopJdL0oIq-C3WPJZwP3Dk0MpVL2eJQBGJROEfBlkPTU2IoKefjAI8XlmPS2a_pZQdje21LIDsNiFjo-CmqTVo0p15ID61BKZGJb2BJzTj9ynkpOvTjCuXz72MDYUOP_zw26aRjRhcB9uQ4c6AiGgjwSfxCXOyc0nqhWw1wSXoU1n6Sm6sYg9LK7hc7XsnB2M9K7PbeJgBF_Ryf7sI1ZkZrRd3HdSxyATZMKl7ovTWD32N2fLImdJe388I30vk-CbxPQt0vK1TqvphmX4x35rwd7c5sVsG3XdTxcPgBriymfw0PYYloRdzi0UU2-pF1_xxh0L3vYw83-rk5FLBmMHSKu96EGiAB7AdWStq-39CyAfAXJrR1Xo4YreD_DmuhANJhw_gycv3tlCQD_gnFe5xLO7xDLc98qYHqzEv_MfhIEuRO8Yq-IRYq1vSZh3JUL7Ukilcy-zYI6gk2ziRbBXLke50A7R-x6ij5QDaXgHBcynwnL0iEiRSs1B6Z0BI5XI3HJwotd7TmH1KCIyizqVJJxy-qVh6z2Vu6TdsV4aTSDhpxgy3GtjcVyBr45zlNXa0RGA7g8pFUL9GkyGoL_Eu7q-LNdhLMzJTlfAOJiHpokbYGggZmz9j0PAwbxPrqkzc9ZRmuiEur-hff-vky36K2mxiNSWcZcOtcqwWziUm-4BzzMsExdxcy3QjI3gBdXleowYRm564YvDrEsbQkq0QheclGyJ83k8vJJVcdrRUVKCqJxfvQXwqjwX6jT_i9ZgE0JVagY9covOEEUfl6fs45805Vo4EGBx4VljypJn_pud_yUdlAx5IsyfsIOWlx3tcgY8BUB3XtfFdtK6pS0w-FCcAcCR0enXj8mECC9bJ2k5o1J7QZWZZXIjbjEaRfYu8YwVDA7zrzAl--fg_Cp_qyiul_WbW5AsXeOR6oiKTXsrRuecB3mEABzddp1fiuHiI_pYEfznc0BpxgQN5vhoK9oRhUtahE6V3oaYax-OCCcY0oCKvR-VKTEiWjoTOQLcBgKEU8tFjZC_3UptP-uN789DYvSIaq8Q6RvKH0k19YQnwcZhw9sDQk8zrjiyeqyoY9lz5LQ95tuM3TPgyqS4e5hByRBOD0GjlFXgafKz8gQPgv_Jt8YAp73J4UHQkewKqMR1LGJ1JF__qtlSRodaYKkt6AxYF15gusqJsM8rO6C2U92Y8jJU0Il7pctl4Q6cdq1yBQjBspxNfr_MTssBm9wSOzK5Sl5hpqEOTnQosvB5AcIrUqfYqFSXfGfzCpgWyqiWLPin5hRsKdif6g', `PostDate` = '2023-02-15 12:54:11', `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
# [15-Feb-2023 12:54:11] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:54:11] /vipcat/root/bg/ajax/users/session.html?_=1676458457068 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:54:28] /vipcat/root/bg/ajax/orders/send.html?_=1676458473297 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 2
                WHERE
                    `ID` = 7
                LIMIT 1

DELETE FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1
# [15-Feb-2023 12:54:32] /vipcat/root/bg/ajax/users/session.html?_=1676458477201 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:54:52] /vipcat/root/ 167.99.142.201

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [15-Feb-2023 12:54:52] /vipcat/root/bg/ajax/users/session.html?_=1676458497498 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:54:52] /vipcat/root/bg/ajax/prices.html?_=1676458497828 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 12:54:53] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 12:54:53] /vipcat/root/bg/ajax/users/session.html?_=1676458499037 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:54:54] /vipcat/root/bg/ajax/prices.html?_=1676458499311 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 12:54:55] /vipcat/root/bg/ajax/basket/add.html?_=1676458500956 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6', NOW(), NOW(), '{"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":1}', 1)
# [15-Feb-2023 12:54:57] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:54:57] /vipcat/root/bg/ajax/users/session.html?_=1676458502931 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:55:00] /vipcat/root/bg/ajax/orders/submit.html?_=1676458505167 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT
                `orders`.`ID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2023-02-15 12:55:00', `Data` = 'YiaivunxOgEJWRLLHGliaZx9DD-aLHc5BZ9rB1jBzURdE1j7td_fsLEonyk5Xwe9dwmj6TXC25Ou-0s4Hww8UiS2CtEN-L1-umyQ-Gi5vqGlcTbwjmEwp72rcr2Uo1qvPFMAfjDocvpQLtXVFN0FhY86tQz5knVJr_BksCxHdoUc_cmwQCDLxNoxmho2_KXL2Up1LfLEEVHBm0VQdr_IRy4aIKGcGYuLgYbiMyddIblPd-ro922Z2o3MYMAzWS73YRt_h-bXZql2FG8d9MjaADxmH3yv5UvfLKnLnvfMEW1jyLG1rujnMtNPtGcvFeOi4ecy6KqfpCvnajU5gyY0pWdPL2T-vr_lhfFPH_MCna6shjsIipvHbkVcfFxjF_wco_8TUigP9fq3GC8ZvbIcBCnRGPfti9knbOUEF7JJNfPR_7unIqX3D8lz2wBvVTbmWRhlFUo_ufSnwSye5ztdZUdPVlb6ZkxwLPyZ6UBFPhSGHc0bK2aab0KENttfCXAT_15iwLA_ZEqxmuJuk4g1kv6G3GcNa0_phpJBDXXAyjP7Z607UoqIvmgXhI94uftflDR0C2Fn2SQMkLbdPH3IrsvFzeVx5F1FszFbAHdCscJBjNcN8MSvAkEHMdN1toXoyUJWG75a0TrTA42x1WIt2M0Ly156G9iJCdJ_GhI3WdOSlk6I8nNP7BOgyPXB5CgMQGUGyopjk1n_k0cHC2OEbT-1hmEBwlApZ-PMSt7_sb5UnJOLz7Uh1WcKae4rK-eb7jWYL6-sWc7TM8h52FWWrIQnzpq8G28J-L9iHL3vuJ-_x2LQqjoQtLhxhYEDQ0OlS1EOspTHht9gyGZZ-3X2giWxk-d6Z7c4_V95C-dWh3hgfaE-ifCe4Bczxu1hZUaFBSGnlhjyG6Pq_ZqCUgPPWfo9k_ma7jtk1QDBm1IoMOQzMmd6ROvwa2Ep9BnPH4gemQSqaTPmh7deAF89Au99-cgiJW-XyOaK_JAWRBv3PEpGHveTwpskdr4jXkFqIS9dpU8kI-QaWWIpGjqLWy_UxHPPiisVCwECUUSTINQ_Yao7WMKBAo4mK2M5yT2Lkki2NWOZ6cehzwncQqdZuC379iFHSJ1tZEKdE0U7uchM7wm6t4dHJqfsf9M0WV5KxBNQwa8Xb-9OkzJazq-9y9_Fmj5UDGbW3AxvHS2FhcBwSQzfJ6noOz0HLolfvS9IdTt33yx5O7vldSHaDsCkqx4r7K3C-YZGappUDyoBhwVr7W25Kn8YF7Io4CHsV0hz2NYnzuMj2syVOgt5LYq0xTyhGIuXF3gIrX3QN2DILwau6J0oFKTZcB6tggQNggjqFnxqfv62GXbCzQZzculrXn04CylXA2tLAD2_bSr6QsE6F6dHxdduYTIyd0MJwDgaFCwQkqA9dexBOWXU_KnGhdnBCzjL3SGHSloRm2XPjGpnWvFdH2ekQFFjBSSnKqxLk86HpIPahthTY2OHa2Cu3kHNctYzw4KgBjfmd4p8BnOhGVogDV0wHzn9BjU0XPCgL1Hv7d1R09clzQg9n7CFtM8lOhNAUOevH8fB4dT31TEbsrW2L3uCPalK8jrOhoWIDpRAKCA-NiJg7AhKCgKIKbpVmPOaX7ydwVkSXuVtf0SXDh4xeRc8V1iwUlZ2mfTtLVXSvxMr8MtgVbXuf_qQUZih0PgzAoRzdT0uaxaYvRYATt8WQNdd5mFMU3zje5lpeIHk_fMQBLRBR5XzJGiMmZ95SA', `PostDate` = '2023-02-15 12:55:00', `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
# [15-Feb-2023 12:55:00] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:55:00] /vipcat/root/bg/ajax/users/session.html?_=1676458505606 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:58:46] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 12:58:46] /vipcat/root/bg/ajax/users/session.html?_=1676458731647 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:58:48] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 12:58:48] /vipcat/root/bg/ajax/users/session.html?_=1676458733797 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:58:49] /vipcat/root/bg/ajax/prices.html?_=1676458734173 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 12:58:54] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 12:58:54] /vipcat/root/bg/ajax/users/session.html?_=1676458739781 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 12:58:54] /vipcat/root/bg/ajax/prices.html?_=1676458740014 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 15:46:35] /vipcat/root/ 167.99.142.201

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [15-Feb-2023 15:46:41] /vipcat/root/ 167.99.142.201

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [15-Feb-2023 15:47:11] /vipcat/root/?customer=ZZ059&SID=347F8F2C5F7C42B39400884F5586EFFD527032&SPRN=32 167.99.142.201

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [15-Feb-2023 15:47:11] /vipcat/root/bg/ajax/users/session.html?_=1676468837016 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 15:47:11] /vipcat/root/bg/ajax/prices.html?_=1676468837305 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 15:47:14] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 15:47:14] /vipcat/root/bg/ajax/users/session.html?_=1676468839962 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 15:47:14] /vipcat/root/bg/ajax/prices.html?_=1676468840313 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 15:47:24] /vipcat/root/ 167.99.142.201

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [15-Feb-2023 15:47:24] /vipcat/root/bg/ajax/users/session.html?_=1676468850031 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 15:47:24] /vipcat/root/bg/ajax/prices.html?_=1676468850263 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 15:58:18] /vipcat/root/ 167.99.142.201

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [15-Feb-2023 15:58:18] /vipcat/root/bg/ajax/users/session.html?_=1676469504052 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 15:58:18] /vipcat/root/bg/ajax/prices.html?_=1676469504367 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 15:58:21] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 15:58:21] /vipcat/root/bg/ajax/users/session.html?_=1676469507292 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 15:58:22] /vipcat/root/bg/ajax/prices.html?_=1676469507531 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 15:58:28] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 15:58:28] /vipcat/root/bg/ajax/users/session.html?_=1676469514084 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 15:58:28] /vipcat/root/bg/ajax/prices.html?_=1676469514330 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 15:58:42] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 15:58:43] /vipcat/root/bg/ajax/users/session.html?_=1676469528517 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 15:58:43] /vipcat/root/bg/ajax/prices.html?_=1676469528759 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:01:28] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'накладки-дискови-lp565' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:01:28] /vipcat/root/bg/ajax/users/session.html?_=1676469693580 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:01:28] /vipcat/root/bg/ajax/prices.html?_=1676469693821 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:03:32] /vipcat/root/ 167.99.142.201

set names utf8

SELECT CONCAT_WS('/', `UploadID`, `Image`) AS `BackgroundURL`
            FROM
                `background`
            WHERE
                `Visible` = 1
            ORDER BY `LastUpdate` DESC
            LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [15-Feb-2023 16:03:32] /vipcat/root/bg/ajax/users/session.html?_=1676469817642 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:03:32] /vipcat/root/bg/ajax/prices.html?_=1676469817938 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp565' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:03:33] /vipcat/root/bg/products/облекло.html 167.99.142.201

set names utf8

SELECT
                    `GroupID`
                FROM
                    `group_texts`
                WHERE
                    `URLLabel` = 'облекло' AND
                    `Language` = 'bg'
                LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`ID`
            FROM
                `product_groups`
                INNER JOIN `product_params` ON `product_groups`.`ProductID` = `product_params`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 1
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('][', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (1,2,3) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Params`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('-', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (4,5) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Ranges`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC

SET SESSION group_concat_max_len = 10240

SELECT
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`ID`,
                `params`.`UploadID`,
                `params`.`FilterType`,
                `params`.`ImgValues`,
                `params`.`Prefix`,
                `params`.`Code`,
                GROUP_CONCAT(DISTINCT `PPV`.`ParamValue` SEPARATOR '][') AS `Values`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_params` AS `PPV` ON `products`.`ID` = `PPV`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `PPV`.`ParamID`
                INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC
# [15-Feb-2023 16:03:34] /vipcat/root/bg/ajax/users/session.html?_=1676469819570 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:03:34] /vipcat/root/bg/ajax/prices.html?_=1676469819833 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000067' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:03:38] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:03:38] /vipcat/root/bg/ajax/users/session.html?_=1676469823576 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:03:38] /vipcat/root/bg/ajax/prices.html?_=1676469823829 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:07:25] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:07:25] /vipcat/root/bg/ajax/users/session.html?_=1676470051322 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:07:26] /vipcat/root/bg/ajax/prices.html?_=1676470051575 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:08:38] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:08:38] /vipcat/root/bg/ajax/users/session.html?_=1676470123844 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:08:38] /vipcat/root/bg/ajax/prices.html?_=1676470124104 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:08:40] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:08:40] /vipcat/root/bg/ajax/users/session.html?_=1676470126183 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:08:40] /vipcat/root/bg/ajax/prices.html?_=1676470126407 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:09:02] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:09:02] /vipcat/root/bg/ajax/users/session.html?_=1676470148235 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:09:03] /vipcat/root/bg/ajax/prices.html?_=1676470148491 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:09:05] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:09:05] /vipcat/root/bg/ajax/users/session.html?_=1676470150930 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:09:05] /vipcat/root/bg/ajax/prices.html?_=1676470151164 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:09:26] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:09:26] /vipcat/root/bg/ajax/users/session.html?_=1676470171852 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:09:26] /vipcat/root/bg/ajax/prices.html?_=1676470172102 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:09:28] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:09:29] /vipcat/root/bg/ajax/users/session.html?_=1676470174720 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:09:29] /vipcat/root/bg/ajax/prices.html?_=1676470174963 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:10:08] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:10:08] /vipcat/root/bg/ajax/users/session.html?_=1676470213917 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:10:08] /vipcat/root/bg/ajax/prices.html?_=1676470214160 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:10:23] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:10:23] /vipcat/root/bg/ajax/users/session.html?_=1676470229034 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:10:23] /vipcat/root/bg/ajax/prices.html?_=1676470229281 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:10:33] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:10:33] /vipcat/root/bg/ajax/users/session.html?_=1676470238567 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:10:33] /vipcat/root/bg/ajax/prices.html?_=1676470238807 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:10:41] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:10:41] /vipcat/root/bg/ajax/users/session.html?_=1676470247165 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:10:41] /vipcat/root/bg/ajax/prices.html?_=1676470247406 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:18:03] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:18:04] /vipcat/root/bg/ajax/users/session.html?_=1676470689547 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:18:04] /vipcat/root/bg/ajax/prices.html?_=1676470689790 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:19:59] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:19:59] /vipcat/root/bg/ajax/users/session.html?_=1676470805064 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:19:59] /vipcat/root/bg/ajax/prices.html?_=1676470805312 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:23:41] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:23:41] /vipcat/root/bg/ajax/users/session.html?_=1676471026907 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:23:41] /vipcat/root/bg/ajax/prices.html?_=1676471027202 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:24:13] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:24:14] /vipcat/root/bg/ajax/users/session.html?_=1676471059695 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:24:14] /vipcat/root/bg/ajax/prices.html?_=1676471059958 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:24:41] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:24:41] /vipcat/root/bg/ajax/users/session.html?_=1676471087097 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:24:41] /vipcat/root/bg/ajax/prices.html?_=1676471087336 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:25:16] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:25:16] /vipcat/root/bg/ajax/users/session.html?_=1676471122362 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:25:17] /vipcat/root/bg/ajax/prices.html?_=1676471122593 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:28:34] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:28:35] /vipcat/root/bg/ajax/users/session.html?_=1676471320501 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:28:35] /vipcat/root/bg/ajax/prices.html?_=1676471320750 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:28:42] /vipcat/root/bg/ajax/basket/add.html?_=1676471328214 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":1,"eyJpZCI6IjQiLCJiYyI6IjAwMDMwMDAwMDAzNDEifQ":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                            LIMIT 1
# [15-Feb-2023 16:28:52] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 4 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 16:28:52] /vipcat/root/bg/ajax/users/session.html?_=1676471338234 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:31:26] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:31:26] /vipcat/root/bg/ajax/users/session.html?_=1676471491806 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:31:26] /vipcat/root/bg/ajax/prices.html?_=1676471492063 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:31:28] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:31:28] /vipcat/root/bg/ajax/users/session.html?_=1676471493800 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:31:28] /vipcat/root/bg/ajax/prices.html?_=1676471494039 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:32:43] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:32:43] /vipcat/root/bg/ajax/users/session.html?_=1676471569240 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:32:44] /vipcat/root/bg/ajax/prices.html?_=1676471569514 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:32:45] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 4 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 16:32:45] /vipcat/root/bg/ajax/users/session.html?_=1676471571095 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:32:48] /vipcat/root/bg/ajax/basket/remove.html?_=1676471573587 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":1}',
                                `Qty` = 1
                            WHERE
                                `ClientID`= '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                            LIMIT 1
# [15-Feb-2023 16:32:48] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 16:32:48] /vipcat/root/bg/ajax/users/session.html?_=1676471573888 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:32:49] /vipcat/root/bg/ajax/basket/remove.html?_=1676471574740 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

DELETE FROM `basket` WHERE `ClientID`= '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1
# [15-Feb-2023 16:32:49] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1
# [15-Feb-2023 16:32:49] /vipcat/root/bg/ajax/users/session.html?_=1676471574926 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:32:51] /vipcat/root/bg/products/2/летен-гащеризон.html 167.99.142.201

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'летен-гащеризон' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 4 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [15-Feb-2023 16:32:52] /vipcat/root/bg/ajax/users/session.html?_=1676471577570 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:32:52] /vipcat/root/bg/ajax/prices.html?_=1676471577863 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [15-Feb-2023 16:32:55] /vipcat/root/bg/ajax/basket/add.html?_=1676471580811 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6', NOW(), NOW(), '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1}', 1)
# [15-Feb-2023 16:32:57] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 4 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 16:32:57] /vipcat/root/bg/ajax/users/session.html?_=1676471582896 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
# [15-Feb-2023 16:34:26] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT `Data` FROM `basket` WHERE `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6' LIMIT 1

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `products`.`ID` = 4 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1
# [15-Feb-2023 16:34:26] /vipcat/root/bg/ajax/users/session.html?_=1676471672194 167.99.142.201

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '1d425a6bc033a13164439b3a460759afe9e358d19cf3578c76b756c5fc2476b6'
                 LIMIT 1
