# [23-Feb-2023 10:05:18] /vipcat/root/bg/ajax/basket/add.html?_=1677139520029 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":4}',
                                `Qty` = 4
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:05:18] /vipcat/root/bg/ajax/basket/popup.html?_=1677139520105 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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
# [23-Feb-2023 10:34: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
# [23-Feb-2023 10:34:51] /vipcat/root/bg/ajax/prices.html?_=1677141292881 167.99.142.201

set names utf8

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000341' AND `Visible` = 1 LIMIT 1
# [23-Feb-2023 10:35:56] /vipcat/root/?customer=ZZ059&SID=10AF507B701D485D80A43744A675DFD1527032&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
# [23-Feb-2023 10:35:56] /vipcat/root/bg/ajax/users/session.html?_=1677141357682 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:35:56] /vipcat/root/bg/ajax/prices.html?_=1677141357682 167.99.142.201

set names utf8

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

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

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:35:57] /vipcat/root/bg/ajax/prices.html?_=1677141358143 167.99.142.201

set names utf8

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

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

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:35:59] /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
# [23-Feb-2023 10:35:59] /vipcat/root/bg/ajax/users/session.html?_=1677141360897 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:35:59] /vipcat/root/bg/ajax/prices.html?_=1677141360897 167.99.142.201

set names utf8

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:36:00] /vipcat/root/bg/ajax/prices.html?_=1677141361227 167.99.142.201

set names utf8

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:36:01] /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
# [23-Feb-2023 10:36:01] /vipcat/root/bg/ajax/users/session.html?_=1677141362660 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:36:01] /vipcat/root/bg/ajax/prices.html?_=1677141362660 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:36:01] /vipcat/root/bg/ajax/prices.html?_=1677141362981 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:36:05] /vipcat/root/bg/ajax/basket/add.html?_=1677141366609 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":5}',
                                `Qty` = 5
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:36:05] /vipcat/root/bg/ajax/basket/popup.html?_=1677141366682 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:40:49] /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
# [23-Feb-2023 10:40:49] /vipcat/root/bg/ajax/prices.html?_=1677141650947 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:40:49] /vipcat/root/bg/ajax/users/session.html?_=1677141650946 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:40:50] /vipcat/root/bg/ajax/prices.html?_=1677141651437 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:40:53] /vipcat/root/bg/ajax/basket/add.html?_=1677141655316 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":6}',
                                `Qty` = 6
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:40:53] /vipcat/root/bg/ajax/basket/popup.html?_=1677141655353 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:43: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
# [23-Feb-2023 10:43:42] /vipcat/root/bg/ajax/users/session.html?_=1677141823507 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:43:42] /vipcat/root/bg/ajax/prices.html?_=1677141823507 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:43:42] /vipcat/root/bg/ajax/prices.html?_=1677141823950 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:43:44] /vipcat/root/bg/ajax/basket/add.html?_=1677141825632 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":7}',
                                `Qty` = 7
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:43:44] /vipcat/root/bg/ajax/basket/popup.html?_=1677141825699 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:44: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
# [23-Feb-2023 10:44:09] /vipcat/root/bg/ajax/users/session.html?_=1677141850632 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:44:09] /vipcat/root/bg/ajax/prices.html?_=1677141850633 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:44:09] /vipcat/root/bg/ajax/prices.html?_=1677141850878 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:44:10] /vipcat/root/bg/ajax/basket/add.html?_=1677141852240 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":8}',
                                `Qty` = 8
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:44:10] /vipcat/root/bg/ajax/basket/popup.html?_=1677141852282 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:53:42] /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
# [23-Feb-2023 10:53:42] /vipcat/root/bg/ajax/users/session.html?_=1677142424332 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:53:43] /vipcat/root/bg/ajax/prices.html?_=1677142424332 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:53:43] /vipcat/root/bg/ajax/prices.html?_=1677142424728 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:53:45] /vipcat/root/bg/ajax/basket/add.html?_=1677142427013 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":9}',
                                `Qty` = 9
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:53:45] /vipcat/root/bg/ajax/basket/popup.html?_=1677142427067 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:53:56] /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
# [23-Feb-2023 10:53:57] /vipcat/root/bg/ajax/users/session.html?_=1677142438595 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:53:57] /vipcat/root/bg/ajax/prices.html?_=1677142438595 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:53:57] /vipcat/root/bg/ajax/prices.html?_=1677142438888 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:54: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
# [23-Feb-2023 10:54:04] /vipcat/root/bg/ajax/users/session.html?_=1677142445645 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:54:04] /vipcat/root/bg/ajax/prices.html?_=1677142445646 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:54:04] /vipcat/root/bg/ajax/prices.html?_=1677142445896 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:54:05] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 10:54:06] /vipcat/root/bg/ajax/users/session.html?_=1677142447830 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:54:07] /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
# [23-Feb-2023 10:54:08] /vipcat/root/bg/ajax/users/session.html?_=1677142449448 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:54:08] /vipcat/root/bg/ajax/prices.html?_=1677142449448 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:54:08] /vipcat/root/bg/ajax/prices.html?_=1677142449711 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:54:09] /vipcat/root/bg/ajax/basket/add.html?_=1677142451068 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":10}',
                                `Qty` = 10
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:54:09] /vipcat/root/bg/ajax/basket/popup.html?_=1677142451102 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:55:20] /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
# [23-Feb-2023 10:55:20] /vipcat/root/bg/ajax/users/session.html?_=1677142522117 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:55:20] /vipcat/root/bg/ajax/prices.html?_=1677142522117 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:55:21] /vipcat/root/bg/ajax/prices.html?_=1677142522429 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:55:22] /vipcat/root/bg/ajax/basket/add.html?_=1677142523891 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":11}',
                                `Qty` = 11
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:55:22] /vipcat/root/bg/ajax/basket/popup.html?_=1677142523948 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:57:29] /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
# [23-Feb-2023 10:57:29] /vipcat/root/bg/ajax/users/session.html?_=1677142651064 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:57:29] /vipcat/root/bg/ajax/prices.html?_=1677142651065 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:57:30] /vipcat/root/bg/ajax/prices.html?_=1677142651340 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:57:31] /vipcat/root/bg/ajax/basket/add.html?_=1677142653112 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":12}',
                                `Qty` = 12
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:57:31] /vipcat/root/bg/ajax/basket/popup.html?_=1677142653178 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:57: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
# [23-Feb-2023 10:57:34] /vipcat/root/bg/ajax/users/session.html?_=1677142655643 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:57:34] /vipcat/root/bg/ajax/prices.html?_=1677142655644 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:57:34] /vipcat/root/bg/ajax/prices.html?_=1677142655898 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:57:36] /vipcat/root/bg/ajax/basket/add.html?_=1677142657608 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":13}',
                                `Qty` = 13
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:57:36] /vipcat/root/bg/ajax/basket/popup.html?_=1677142657645 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:58:20] /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
# [23-Feb-2023 10:58:20] /vipcat/root/bg/ajax/users/session.html?_=1677142702127 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:58:21] /vipcat/root/bg/ajax/prices.html?_=1677142702128 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:58:21] /vipcat/root/bg/ajax/prices.html?_=1677142702528 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:58:24] /vipcat/root/bg/ajax/basket/add.html?_=1677142705720 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":14}',
                                `Qty` = 14
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:58:24] /vipcat/root/bg/ajax/basket/popup.html?_=1677142705755 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:58:54] /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
# [23-Feb-2023 10:58:54] /vipcat/root/bg/ajax/users/session.html?_=1677142736029 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:58:54] /vipcat/root/bg/ajax/prices.html?_=1677142736029 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:58:54] /vipcat/root/bg/ajax/prices.html?_=1677142736292 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 10:58:56] /vipcat/root/bg/ajax/basket/add.html?_=1677142737935 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":15}',
                                `Qty` = 15
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 10:58:56] /vipcat/root/bg/ajax/basket/popup.html?_=1677142737978 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:00:53] /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
# [23-Feb-2023 11:00:54] /vipcat/root/bg/ajax/users/session.html?_=1677142855741 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:00:54] /vipcat/root/bg/ajax/prices.html?_=1677142855742 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:00:54] /vipcat/root/bg/ajax/prices.html?_=1677142856192 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:00:56] /vipcat/root/bg/ajax/basket/add.html?_=1677142857844 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":16}',
                                `Qty` = 16
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 11:00:56] /vipcat/root/bg/ajax/basket/popup.html?_=1677142857922 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:00:58] /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
# [23-Feb-2023 11:00:59] /vipcat/root/bg/ajax/users/session.html?_=1677142860463 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:00:59] /vipcat/root/bg/ajax/prices.html?_=1677142860464 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:00:59] /vipcat/root/bg/ajax/prices.html?_=1677142860922 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:01: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
# [23-Feb-2023 11:01:14] /vipcat/root/bg/ajax/users/session.html?_=1677142875720 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:01:14] /vipcat/root/bg/ajax/prices.html?_=1677142875721 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:01:14] /vipcat/root/bg/ajax/prices.html?_=1677142876094 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:01:16] /vipcat/root/bg/ajax/basket/add.html?_=1677142877644 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":17}',
                                `Qty` = 17
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 11:01:16] /vipcat/root/bg/ajax/basket/popup.html?_=1677142877705 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:01:23] /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
# [23-Feb-2023 11:01:24] /vipcat/root/bg/ajax/prices.html?_=1677142885648 167.99.142.201

set names utf8

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:01:24] /vipcat/root/bg/ajax/users/session.html?_=1677142885647 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:01:25] /vipcat/root/bg/ajax/prices.html?_=1677142886652 167.99.142.201

set names utf8

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:01: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` = 5 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [23-Feb-2023 11:01:26] /vipcat/root/bg/ajax/prices.html?_=1677142887469 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:01:26] /vipcat/root/bg/ajax/users/session.html?_=1677142887469 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:01:26] /vipcat/root/bg/ajax/prices.html?_=1677142888352 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:01:27] /vipcat/root/bg/ajax/basket/add.html?_=1677142889188 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":17,"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":1}',
                                `Qty` = 18
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 11:01:27] /vipcat/root/bg/ajax/basket/popup.html?_=1677142889247 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:02:15] /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` = 5 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [23-Feb-2023 11:02:15] /vipcat/root/bg/ajax/prices.html?_=1677142937107 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:02:15] /vipcat/root/bg/ajax/users/session.html?_=1677142937106 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:02:16] /vipcat/root/bg/ajax/prices.html?_=1677142937890 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:02:17] /vipcat/root/bg/ajax/basket/add.html?_=1677142938523 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":17,"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":2}',
                                `Qty` = 19
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 11:02:17] /vipcat/root/bg/ajax/basket/popup.html?_=1677142938574 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:03:04] /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` = 5 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [23-Feb-2023 11:03:05] /vipcat/root/bg/ajax/users/session.html?_=1677142987017 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:03:06] /vipcat/root/bg/ajax/prices.html?_=1677142987017 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:03:06] /vipcat/root/bg/ajax/prices.html?_=1677142987567 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:03:07] /vipcat/root/bg/ajax/basket/add.html?_=1677142988730 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":17,"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":3}',
                                `Qty` = 20
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 11:03:07] /vipcat/root/bg/ajax/basket/popup.html?_=1677142988803 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:05: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` = 5 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [23-Feb-2023 11:05:51] /vipcat/root/bg/ajax/prices.html?_=1677143153310 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:05:52] /vipcat/root/bg/ajax/users/session.html?_=1677143153310 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:05:53] /vipcat/root/bg/ajax/prices.html?_=1677143154840 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:05:54] /vipcat/root/bg/ajax/basket/add.html?_=1677143155855 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":17,"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":4}',
                                `Qty` = 21
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 11:05:54] /vipcat/root/bg/ajax/basket/popup.html?_=1677143155911 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:06:15] /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` = 5 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [23-Feb-2023 11:06:15] /vipcat/root/bg/ajax/users/session.html?_=1677143177363 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:06:18] /vipcat/root/bg/ajax/prices.html?_=1677143177364 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:06:18] /vipcat/root/bg/ajax/prices.html?_=1677143179905 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:06:19] /vipcat/root/bg/ajax/basket/add.html?_=1677143180791 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":17,"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":5}',
                                `Qty` = 22
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 11:06:19] /vipcat/root/bg/ajax/basket/popup.html?_=1677143180829 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:06:36] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:06:37] /vipcat/root/bg/ajax/users/session.html?_=1677143198945 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:07:27] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:07:29] /vipcat/root/bg/ajax/users/session.html?_=1677143250966 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:07:43] /vipcat/root/bg/ajax/basket/update.html?_=1677143264637 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":5}',
                                `Qty` = 6
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 11:07:43] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:07:44] /vipcat/root/bg/ajax/users/session.html?_=1677143265613 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:07:45] /vipcat/root/bg/ajax/basket/update.html?_=1677143267454 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 11:07:46] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:07:47] /vipcat/root/bg/ajax/users/session.html?_=1677143268700 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:10:08] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:10:09] /vipcat/root/bg/ajax/users/session.html?_=1677143410881 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:11:33] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:11:35] /vipcat/root/bg/ajax/users/session.html?_=1677143497206 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:12:31] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:12:32] /vipcat/root/bg/ajax/users/session.html?_=1677143554176 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:12:59] /vipcat/root/bg/ajax/orders/submit.html?_=1677143580937 167.99.142.201

set names utf8

UPDATE
                    `basket`
                SET
                    `LastUpdate` = NOW(),
                    `Comment` = 'test'
                WHERE
                    `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                LIMIT 1
# [23-Feb-2023 11:12:59] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:13:03] /vipcat/root/bg/ajax/users/session.html?_=1677143584741 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:13:57] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:13:58] /vipcat/root/bg/ajax/users/session.html?_=1677143640338 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:14:14] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:14:16] /vipcat/root/bg/ajax/users/session.html?_=1677143657839 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:15:25] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:15:26] /vipcat/root/bg/ajax/users/session.html?_=1677143727691 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16:05] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:16:09] /vipcat/root/bg/ajax/users/session.html?_=1677143771147 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16:16] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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

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

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [23-Feb-2023 11:16:18] /vipcat/root/bg/ajax/users/session.html?_=1677143779529 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16:23] /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
# [23-Feb-2023 11:16:24] /vipcat/root/bg/ajax/users/session.html?_=1677143785524 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16:24] /vipcat/root/bg/ajax/prices.html?_=1677143785524 167.99.142.201

set names utf8

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

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

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16:25] /vipcat/root/bg/ajax/prices.html?_=1677143786018 167.99.142.201

set names utf8

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

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

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16:25] /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
# [23-Feb-2023 11:16:26] /vipcat/root/bg/ajax/users/session.html?_=1677143787560 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16:26] /vipcat/root/bg/ajax/prices.html?_=1677143787561 167.99.142.201

set names utf8

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16:26] /vipcat/root/bg/ajax/prices.html?_=1677143788027 167.99.142.201

set names utf8

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16: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` = 5 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [23-Feb-2023 11:16:28] /vipcat/root/bg/ajax/users/session.html?_=1677143789863 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `orders`
            WHERE
                `Customer` = 'ZZ059'

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16:28] /vipcat/root/bg/ajax/prices.html?_=1677143789864 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16:29] /vipcat/root/bg/ajax/prices.html?_=1677143790208 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [23-Feb-2023 11:16:30] /vipcat/root/bg/ajax/basket/add.html?_=1677143792443 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":2}',
                                `Qty` = 3
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [23-Feb-2023 11:16:31] /vipcat/root/bg/ajax/basket/popup.html?_=1677143792528 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' 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

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

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

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