# [22-Feb-2023 13:40:03] /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
# [22-Feb-2023 13:40:03] /vipcat/root/bg/ajax/prices.html?_=1677066003446 167.99.142.201

set names utf8

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

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [22-Feb-2023 13:40:10] /vipcat/root/?customer=ZZ059&SID=350D848E1CD34938A27DB6703E81EE24527032&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
# [22-Feb-2023 13:40:10] /vipcat/root/bg/ajax/users/session.html?_=1677066010719 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()
# [22-Feb-2023 13:40:11] /vipcat/root/bg/ajax/prices.html?_=1677066010720 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()
# [22-Feb-2023 13:40:11] /vipcat/root/bg/ajax/prices.html?_=1677066011018 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()
# [22-Feb-2023 13:40:16] /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
# [22-Feb-2023 13:40:16] /vipcat/root/bg/ajax/users/session.html?_=1677066016081 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()
# [22-Feb-2023 13:40:16] /vipcat/root/bg/ajax/prices.html?_=1677066016082 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()
# [22-Feb-2023 13:40:16] /vipcat/root/bg/ajax/prices.html?_=1677066016339 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()
# [22-Feb-2023 13:40:18] /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
# [22-Feb-2023 13:40:18] /vipcat/root/bg/ajax/users/session.html?_=1677066018029 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()
# [22-Feb-2023 13:40:18] /vipcat/root/bg/ajax/prices.html?_=1677066018031 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()
# [22-Feb-2023 13:40:18] /vipcat/root/bg/ajax/prices.html?_=1677066018309 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()
# [22-Feb-2023 13:40:20] /vipcat/root/bg/ajax/basket/add.html?_=1677066020182 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":6,"eyJpZCI6IjQiLCJiYyI6IjAwMDMwMDAwMDAzNDEiLCJzIjoiTSJ9":1}',
                                `Qty` = 7
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 13:40:20] /vipcat/root/bg/ajax/basket/popup.html?_=1677066020228 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` = 5 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` = 4 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

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

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":6,"eyJpZCI6IjQiLCJiYyI6IjAwMDMwMDAwMDAzNDEiLCJzIjoiTSJ9":2}',
                                `Qty` = 8
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 13:50:01] /vipcat/root/bg/ajax/basket/popup.html?_=1677066601336 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` = 5 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` = 4 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [22-Feb-2023 13:50:02] /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` = 5 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` = 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
# [22-Feb-2023 13:50:03] /vipcat/root/bg/ajax/users/session.html?_=1677066603358 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()
# [22-Feb-2023 13:50:07] /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
# [22-Feb-2023 13:50:07] /vipcat/root/bg/ajax/users/session.html?_=1677066607169 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()
# [22-Feb-2023 13:50:07] /vipcat/root/bg/ajax/prices.html?_=1677066607169 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()
# [22-Feb-2023 13:50:08] /vipcat/root/bg/ajax/prices.html?_=1677066607442 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()
# [22-Feb-2023 13:50:08] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [22-Feb-2023 13:50:09] /vipcat/root/bg/ajax/prices.html?_=1677066608894 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()
# [22-Feb-2023 13:50:09] /vipcat/root/bg/ajax/users/session.html?_=1677066608893 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()
# [22-Feb-2023 13:50:09] /vipcat/root/bg/ajax/prices.html?_=1677066609341 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()
# [22-Feb-2023 13:50:10] /vipcat/root/bg/ajax/basket/add.html?_=1677066610707 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":6,"eyJpZCI6IjQiLCJiYyI6IjAwMDMwMDAwMDAzNDEiLCJzIjoiTSJ9":2,"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":1}',
                                `Qty` = 9
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 13:50:10] /vipcat/root/bg/ajax/basket/popup.html?_=1677066610743 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` = 5 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` = 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` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [22-Feb-2023 13:52:55] /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` = 5 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` = 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` = 1 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
# [22-Feb-2023 13:52:56] /vipcat/root/bg/ajax/users/session.html?_=1677066776352 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()
# [22-Feb-2023 13:52:58] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [22-Feb-2023 13:52:58] /vipcat/root/bg/ajax/users/session.html?_=1677066778598 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()
# [22-Feb-2023 13:52:59] /vipcat/root/bg/ajax/prices.html?_=1677066778598 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()
# [22-Feb-2023 13:52:59] /vipcat/root/bg/ajax/prices.html?_=1677066778885 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()
# [22-Feb-2023 13:53:00] /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` = 5 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` = 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` = 1 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
# [22-Feb-2023 13:53:00] /vipcat/root/bg/ajax/users/session.html?_=1677066780706 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()
# [22-Feb-2023 13:53:02] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [22-Feb-2023 13:53:02] /vipcat/root/bg/ajax/users/session.html?_=1677066782062 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()
# [22-Feb-2023 13:53:02] /vipcat/root/bg/ajax/prices.html?_=1677066782062 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()
# [22-Feb-2023 13:53:02] /vipcat/root/bg/ajax/prices.html?_=1677066782329 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()
# [22-Feb-2023 13:53:03] /vipcat/root/bg/ajax/basket/add.html?_=1677066783392 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":6,"eyJpZCI6IjQiLCJiYyI6IjAwMDMwMDAwMDAzNDEiLCJzIjoiTSJ9":2,"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":2}',
                                `Qty` = 10
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 13:53:03] /vipcat/root/bg/ajax/basket/popup.html?_=1677066783426 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` = 5 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` = 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` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [22-Feb-2023 15:50:49] /vipcat/root/?customer=ZZ059&SID=313E20611FA84470AD4B5C0302D4CBB1527032&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
# [22-Feb-2023 15:50:50] /vipcat/root/bg/ajax/users/session.html?_=1677073850229 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()
# [22-Feb-2023 15:50:50] /vipcat/root/bg/ajax/prices.html?_=1677073850229 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()
# [22-Feb-2023 15:50:51] /vipcat/root/bg/ajax/prices.html?_=1677073850667 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()
# [22-Feb-2023 15:50:53] /vipcat/root/bg/orders/list.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `orders`.`Customer` = 'ZZ059'
            ORDER BY
                `orders`.`PostDate` DESC
         LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                *
            FROM
                `orders`
            WHERE
                `orders`.`Customer` = 'ZZ059'
            ORDER BY
                `orders`.`PostDate` DESC
        ) AS CountTable
# [22-Feb-2023 15:50:53] /vipcat/root/bg/ajax/users/session.html?_=1677073853765 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()
# [22-Feb-2023 15:50:56] /vipcat/root/bg/ajax/orders/1.html?_=1677073856054 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [22-Feb-2023 15:51:05] /vipcat/root/bg/ajax/orders/1.html?_=1677073865758 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [22-Feb-2023 15:51:11] /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
# [22-Feb-2023 15:51:11] /vipcat/root/bg/ajax/users/session.html?_=1677073871124 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()
# [22-Feb-2023 15:51:11] /vipcat/root/bg/ajax/prices.html?_=1677073871124 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()
# [22-Feb-2023 15:51:12] /vipcat/root/bg/ajax/prices.html?_=1677073871546 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()
# [22-Feb-2023 15:55:08] /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
# [22-Feb-2023 15:55:08] /vipcat/root/bg/ajax/users/session.html?_=1677074108535 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()
# [22-Feb-2023 15:55:08] /vipcat/root/bg/ajax/prices.html?_=1677074108536 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()
# [22-Feb-2023 15:55:09] /vipcat/root/bg/ajax/prices.html?_=1677074108914 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()
# [22-Feb-2023 15:55:18] /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` = 5 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` = 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` = 1 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
# [22-Feb-2023 15:55:19] /vipcat/root/bg/ajax/users/session.html?_=1677074119126 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()
# [22-Feb-2023 15:55: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` = 5 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` = 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` = 1 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
# [22-Feb-2023 15:55:29] /vipcat/root/bg/ajax/users/session.html?_=1677074128970 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()
# [22-Feb-2023 15:57:07] /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` = 5 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` = 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` = 1 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
# [22-Feb-2023 15:57:08] /vipcat/root/bg/ajax/users/session.html?_=1677074228640 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()
# [22-Feb-2023 15:57:11] /vipcat/root/bg/ajax/orders/submit.html?_=1677074231666 167.99.142.201
# [22-Feb-2023 15:57:11] /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` = 5 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` = 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` = 1 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
# [22-Feb-2023 15:57:13] /vipcat/root/bg/ajax/users/session.html?_=1677074233058 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()
# [22-Feb-2023 15:59: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` = 5 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` = 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` = 1 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
# [22-Feb-2023 15:59:16] /vipcat/root/bg/ajax/users/session.html?_=1677074356176 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()
# [22-Feb-2023 15:59: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` = 5 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` = 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` = 1 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
# [22-Feb-2023 15:59:58] /vipcat/root/bg/ajax/users/session.html?_=1677074398431 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()
# [22-Feb-2023 16:00:03] /vipcat/root/bg/ajax/orders/send.html?_=1677074403863 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` = 5 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` = 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` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `PostDate` = '2023-02-22 16:00:07', `LastUpdate` = '2023-02-22 16:00:07', `Customer` = 'ZZ059', `OrderNumber` = 'VIP000000002', `Products` = '[{"ID":"5","PostDate":"2023-02-15","LastUpdate":"2023-02-15 15:35:28","UploadID":"2023\\/02\\/15\\/6467789545","RefNumber":"0000000067","RefID":"0000000067","ArtNumber":"0000000067","Brand":"REPSOL","Gallery":"[\\"1.jpg\\"]","Selected":"0","Visible":"1","ProductID":"5","Language":"bg","Title":"ЛЯТНА ШАПКА С КОЗИРКА","URLLabel":"лятна-шапка-с-козирка","Content":"БЯЛА ШАПКА","BasketID":"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ","Price":12,"Alt":"ЛЯТНА ШАПКА С КОЗИРКА","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2023\\/02\\/15\\/6467789545\\/l_1.jpg","Barcode":"0002000000067","Avl":7,"Qty":6,"Total":72},{"ID":"4","PostDate":"2023-02-14","LastUpdate":"2023-02-15 15:37:15","UploadID":"2023\\/02\\/14\\/6374059726","RefNumber":"0000000341","RefID":"0000000341","ArtNumber":"0000000341","Brand":"REPSOL","Gallery":"[\\"2.jpg\\"]","Selected":"0","Visible":"1","ProductID":"4","Language":"bg","Title":"ЛЕТЕН ГАЩЕРИЗОН","URLLabel":"летен-гащеризон","Content":"","BasketID":"eyJpZCI6IjQiLCJiYyI6IjAwMDMwMDAwMDAzNDEiLCJzIjoiTSJ9","Price":48,"Alt":"ЛЕТЕН ГАЩЕРИЗОН","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2023\\/02\\/14\\/6374059726\\/l_2.jpg","Barcode":"0003000000341","Size":"M","Avl":2,"Qty":2,"Total":96},{"ID":"1","PostDate":"2022-12-28","LastUpdate":"2023-02-15 15:33:00","UploadID":"2022\\/12\\/28\\/2204793235","RefNumber":"LP565","RefID":"lp565","ArtNumber":"LP565","Brand":"DELPHI","Gallery":"[\\"lp565jpg.jpg\\"]","Selected":"1","Visible":"1","ProductID":"1","Language":"bg","Title":"Накладки дискови LP565","URLLabel":"накладки-дискови-lp565","Content":"знак за преглед: E1 90R-01878\\/507, <br>WVA-номер: 20961, <br>спирачна система: TRW, <br>без противоскърцаща планка, <br>с принадлежности, <br>не е за подготвен за предупредителен датчик за износване, <br>ширина 1: 87 мм, <br>ширина 2: 87 мм, <br>височина 1: 53 мм, <br>височина 2: 53 мм, <br>дебелина 1: 17 мм, <br>дебелина 2: 17 мм<br>Актуален номер: 20960, <br>D1017-7920, <br>D1112-8216, <br>D340-7335, <br>D894-7773<br><br>","BasketID":"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ","Price":42,"Alt":"Накладки дискови LP565","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2022\\/12\\/28\\/2204793235\\/l_lp565jpg.jpg","Barcode":"5012759303801","Avl":15,"Qty":2,"Total":84}]', `Comment` = '', `Total` = 252

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

DELETE FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1
# [22-Feb-2023 16:00:11] /vipcat/root/bg/ajax/users/session.html?_=1677074411183 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()
# [22-Feb-2023 16:00:16] /vipcat/root/bg/ajax/users/session.html?_=1677074416245 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()
# [22-Feb-2023 16:00:18] /vipcat/root/bg/orders/list.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `orders`.`Customer` = 'ZZ059'
            ORDER BY
                `orders`.`PostDate` DESC
         LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                *
            FROM
                `orders`
            WHERE
                `orders`.`Customer` = 'ZZ059'
            ORDER BY
                `orders`.`PostDate` DESC
        ) AS CountTable
# [22-Feb-2023 16:00:18] /vipcat/root/bg/ajax/users/session.html?_=1677074418118 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()
# [22-Feb-2023 16:00:21] /vipcat/root/bg/ajax/orders/1.html?_=1677074421557 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [22-Feb-2023 16:00:26] /vipcat/root/bg/ajax/orders/2.html?_=1677074426316 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 2
            LIMIT 1
# [22-Feb-2023 16:00:39] /vipcat/root/bg/ajax/orders/2.html?_=1677074439075 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 2
            LIMIT 1
# [22-Feb-2023 16:00:43] /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
# [22-Feb-2023 16:00:43] /vipcat/root/bg/ajax/prices.html?_=1677074443756 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()
# [22-Feb-2023 16:00:44] /vipcat/root/bg/ajax/users/session.html?_=1677074443755 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()
# [22-Feb-2023 16:00:44] /vipcat/root/bg/ajax/prices.html?_=1677074444858 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()
# [22-Feb-2023 16:00:46] /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
# [22-Feb-2023 16:00:46] /vipcat/root/bg/ajax/users/session.html?_=1677074446244 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()
# [22-Feb-2023 16:00:46] /vipcat/root/bg/ajax/prices.html?_=1677074446244 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()
# [22-Feb-2023 16:00:47] /vipcat/root/bg/ajax/prices.html?_=1677074446643 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()
# [22-Feb-2023 16:00:48] /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
# [22-Feb-2023 16:00:48] /vipcat/root/bg/ajax/users/session.html?_=1677074448577 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()
# [22-Feb-2023 16:00:48] /vipcat/root/bg/ajax/prices.html?_=1677074448578 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()
# [22-Feb-2023 16:00:49] /vipcat/root/bg/ajax/prices.html?_=1677074448995 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()
# [22-Feb-2023 16:00:53] /vipcat/root/bg/ajax/basket/add.html?_=1677074453179 167.99.142.201

set names utf8

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

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8', NOW(), NOW(), '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1}', 1)
# [22-Feb-2023 16:00:53] /vipcat/root/bg/ajax/basket/popup.html?_=1677074453229 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()
# [22-Feb-2023 16:02:02] /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
# [22-Feb-2023 16:02:03] /vipcat/root/bg/ajax/users/session.html?_=1677074523292 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()
# [22-Feb-2023 16:02:47] /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
# [22-Feb-2023 16:02:47] /vipcat/root/bg/ajax/users/session.html?_=1677074567718 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()
# [22-Feb-2023 16:02:48] /vipcat/root/bg/ajax/prices.html?_=1677074567718 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()
# [22-Feb-2023 16:02:48] /vipcat/root/bg/ajax/prices.html?_=1677074568084 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()
# [22-Feb-2023 16:02:49] /vipcat/root/bg/products/1/накладки-дискови-lp885.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` = 'накладки-дискови-lp885' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

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

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

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

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjMiLCJiYyI6IjUwMTI3NTk5MTMzNTIifQ":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:02:51] /vipcat/root/bg/ajax/basket/popup.html?_=1677074571526 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` = 3 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [22-Feb-2023 16:02:55] /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` = 3 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
# [22-Feb-2023 16:02:56] /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` = 3 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
# [22-Feb-2023 16:02:57] /vipcat/root/bg/ajax/users/session.html?_=1677074577606 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()
# [22-Feb-2023 16:04:19] /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
# [22-Feb-2023 16:04:19] /vipcat/root/bg/ajax/prices.html?_=1677074659709 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()
# [22-Feb-2023 16:04:20] /vipcat/root/bg/ajax/users/session.html?_=1677074659708 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()
# [22-Feb-2023 16:04:20] /vipcat/root/bg/ajax/prices.html?_=1677074660963 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()
# [22-Feb-2023 16:04:21] /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
# [22-Feb-2023 16:04:22] /vipcat/root/bg/ajax/users/session.html?_=1677074662069 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()
# [22-Feb-2023 16:04:22] /vipcat/root/bg/ajax/prices.html?_=1677074662070 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()
# [22-Feb-2023 16:04:22] /vipcat/root/bg/ajax/prices.html?_=1677074662396 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()
# [22-Feb-2023 16:04: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
# [22-Feb-2023 16:04:25] /vipcat/root/bg/ajax/users/session.html?_=1677074665411 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()
# [22-Feb-2023 16:04:25] /vipcat/root/bg/ajax/prices.html?_=1677074665412 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()
# [22-Feb-2023 16:04:26] /vipcat/root/bg/ajax/prices.html?_=1677074665848 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()
# [22-Feb-2023 16:04:27] /vipcat/root/bg/ajax/basket/add.html?_=1677074667167 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjMiLCJiYyI6IjUwMTI3NTk5MTMzNTIifQ":1,"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":1}',
                                `Qty` = 3
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:04:27] /vipcat/root/bg/ajax/basket/popup.html?_=1677074667217 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` = 3 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()
# [22-Feb-2023 16:06:05] /vipcat/root/bg/products/2/лятна-шапка-с-козирка.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 5 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [22-Feb-2023 16:06:05] /vipcat/root/bg/ajax/users/session.html?_=1677074765300 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()
# [22-Feb-2023 16:06:05] /vipcat/root/bg/ajax/prices.html?_=1677074765301 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()
# [22-Feb-2023 16:06:05] /vipcat/root/bg/ajax/prices.html?_=1677074765653 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()
# [22-Feb-2023 16:06:07] /vipcat/root/bg/ajax/basket/add.html?_=1677074767029 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjMiLCJiYyI6IjUwMTI3NTk5MTMzNTIifQ":1,"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":2}',
                                `Qty` = 4
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:06:07] /vipcat/root/bg/ajax/basket/popup.html?_=1677074767085 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` = 3 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()
# [22-Feb-2023 16:06:11] /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` = 3 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
# [22-Feb-2023 16:06:12] /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
# [22-Feb-2023 16:06:13] /vipcat/root/bg/ajax/users/session.html?_=1677074773004 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()
# [22-Feb-2023 16:06:13] /vipcat/root/bg/ajax/prices.html?_=1677074773005 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()
# [22-Feb-2023 16:06:13] /vipcat/root/bg/ajax/prices.html?_=1677074773450 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()
# [22-Feb-2023 16:06:16] /vipcat/root/bg/ajax/basket/add.html?_=1677074776245 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjMiLCJiYyI6IjUwMTI3NTk5MTMzNTIifQ":1,"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":3}',
                                `Qty` = 5
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:06:16] /vipcat/root/bg/ajax/basket/popup.html?_=1677074776301 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` = 3 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()
# [22-Feb-2023 16:08:52] /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
# [22-Feb-2023 16:08:53] /vipcat/root/bg/ajax/users/session.html?_=1677074933044 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()
# [22-Feb-2023 16:08:53] /vipcat/root/bg/ajax/prices.html?_=1677074933044 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()
# [22-Feb-2023 16:08:53] /vipcat/root/bg/ajax/prices.html?_=1677074933535 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()
# [22-Feb-2023 16:08:55] /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` = 3 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
# [22-Feb-2023 16:08:56] /vipcat/root/bg/ajax/users/session.html?_=1677074936764 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()
# [22-Feb-2023 16:09:03] /vipcat/root/bg/ajax/basket/remove.html?_=1677074943186 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjMiLCJiYyI6IjUwMTI3NTk5MTMzNTIifQ":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:09:03] /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` = 3 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
# [22-Feb-2023 16:09:04] /vipcat/root/bg/ajax/users/session.html?_=1677074944360 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()
# [22-Feb-2023 16:09:07] /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` = 3 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
# [22-Feb-2023 16:09:08] /vipcat/root/bg/ajax/users/session.html?_=1677074948675 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()
# [22-Feb-2023 16:16:01] /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
# [22-Feb-2023 16:16:01] /vipcat/root/bg/ajax/users/session.html?_=1677075361706 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()
# [22-Feb-2023 16:16:02] /vipcat/root/bg/ajax/prices.html?_=1677075361706 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()
# [22-Feb-2023 16:16:03] /vipcat/root/bg/ajax/prices.html?_=1677075362168 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()
# [22-Feb-2023 16:16:03] /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
# [22-Feb-2023 16:16:04] /vipcat/root/bg/ajax/users/session.html?_=1677075364442 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()
# [22-Feb-2023 16:16:04] /vipcat/root/bg/ajax/prices.html?_=1677075364443 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()
# [22-Feb-2023 16:16:05] /vipcat/root/bg/ajax/prices.html?_=1677075364805 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()
# [22-Feb-2023 16:16:07] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [22-Feb-2023 16:16:07] /vipcat/root/bg/ajax/prices.html?_=1677075367191 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()
# [22-Feb-2023 16:16:07] /vipcat/root/bg/ajax/users/session.html?_=1677075367191 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()
# [22-Feb-2023 16:16:08] /vipcat/root/bg/ajax/prices.html?_=1677075368018 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()
# [22-Feb-2023 16:16:09] /vipcat/root/bg/ajax/basket/add.html?_=1677075369217 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjMiLCJiYyI6IjUwMTI3NTk5MTMzNTIifQ":1,"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":1}',
                                `Qty` = 3
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:16:09] /vipcat/root/bg/ajax/basket/popup.html?_=1677075369303 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` = 3 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` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [22-Feb-2023 16:16:17] /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` = 3 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` = 1 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
# [22-Feb-2023 16:16:19] /vipcat/root/bg/ajax/users/session.html?_=1677075379026 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()
# [22-Feb-2023 16:16:41] /vipcat/root/ 167.99.142.201

set names utf8

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

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

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [22-Feb-2023 16:16:42] /vipcat/root/bg/ajax/prices.html?_=1677075402134 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()
# [22-Feb-2023 16:16:42] /vipcat/root/bg/ajax/users/session.html?_=1677075402133 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()
# [22-Feb-2023 16:16:43] /vipcat/root/bg/ajax/prices.html?_=1677075403090 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()
# [22-Feb-2023 16:16:43] /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
# [22-Feb-2023 16:16:44] /vipcat/root/bg/ajax/users/session.html?_=1677075404550 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()
# [22-Feb-2023 16:16:45] /vipcat/root/bg/ajax/prices.html?_=1677075404551 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()
# [22-Feb-2023 16:16:45] /vipcat/root/bg/ajax/prices.html?_=1677075405176 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()
# [22-Feb-2023 16:16:46] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 1 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [22-Feb-2023 16:16:46] /vipcat/root/bg/ajax/prices.html?_=1677075406931 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()
# [22-Feb-2023 16:16:47] /vipcat/root/bg/ajax/users/session.html?_=1677075406930 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()
# [22-Feb-2023 16:16:47] /vipcat/root/bg/ajax/prices.html?_=1677075407720 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()
# [22-Feb-2023 16:16:48] /vipcat/root/bg/ajax/basket/add.html?_=1677075408968 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjMiLCJiYyI6IjUwMTI3NTk5MTMzNTIifQ":1,"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":2}',
                                `Qty` = 4
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:16:49] /vipcat/root/bg/ajax/basket/popup.html?_=1677075409019 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` = 3 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` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [22-Feb-2023 16:16:57] /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` = 3 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` = 1 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
# [22-Feb-2023 16:16:58] /vipcat/root/bg/ajax/users/session.html?_=1677075418668 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()
# [22-Feb-2023 16:22:57] /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
# [22-Feb-2023 16:22:58] /vipcat/root/bg/ajax/users/session.html?_=1677075777986 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()
# [22-Feb-2023 16:22:58] /vipcat/root/bg/ajax/prices.html?_=1677075777987 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()
# [22-Feb-2023 16:22:59] /vipcat/root/bg/ajax/prices.html?_=1677075778408 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()
# [22-Feb-2023 16:22:59] /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
# [22-Feb-2023 16:23:00] /vipcat/root/bg/ajax/users/session.html?_=1677075780583 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()
# [22-Feb-2023 16:23:00] /vipcat/root/bg/ajax/prices.html?_=1677075780583 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()
# [22-Feb-2023 16:23:01] /vipcat/root/bg/ajax/prices.html?_=1677075781046 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()
# [22-Feb-2023 16:23:07] /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` = 3 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` = 1 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
# [22-Feb-2023 16:23:09] /vipcat/root/bg/ajax/users/session.html?_=1677075789342 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()
# [22-Feb-2023 16:23:15] /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
# [22-Feb-2023 16:23:15] /vipcat/root/bg/ajax/users/session.html?_=1677075795164 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()
# [22-Feb-2023 16:23:15] /vipcat/root/bg/ajax/prices.html?_=1677075795164 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()
# [22-Feb-2023 16:23:16] /vipcat/root/bg/ajax/prices.html?_=1677075795559 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()
# [22-Feb-2023 16:24:06] /vipcat/root/bg/products/1/накладки-дискови-lp702.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` = 'накладки-дискови-lp702' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

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

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

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

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjMiLCJiYyI6IjUwMTI3NTk5MTMzNTIifQ":1,"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":2,"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ":1}',
                                `Qty` = 5
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:24:08] /vipcat/root/bg/ajax/basket/popup.html?_=1677075848834 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` = 3 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` = 1 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` = 2 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [22-Feb-2023 16:25:29] /vipcat/root/bg/products/1/накладки-дискови-lp702.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` = 'накладки-дискови-lp702' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 1
            LIMIT 1

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

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

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

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjMiLCJiYyI6IjUwMTI3NTk5MTMzNTIifQ":1,"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":2,"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ":2}',
                                `Qty` = 6
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:25:33] /vipcat/root/bg/ajax/basket/popup.html?_=1677075933307 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` = 3 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` = 1 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` = 2 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [22-Feb-2023 16:26:16] /vipcat/root/bg/ajax/basket/remove.html?_=1677075976282 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":2,"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ":2}',
                                `Qty` = 5
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:26:19] /vipcat/root/bg/ajax/basket/remove.html?_=1677075979930 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1,"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ":2}',
                                `Qty` = 3
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:27:07] /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` = 2 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
# [22-Feb-2023 16:27:09] /vipcat/root/bg/ajax/users/session.html?_=1677076029208 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()
# [22-Feb-2023 16:29:02] /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` = 2 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
# [22-Feb-2023 16:29:03] /vipcat/root/bg/ajax/users/session.html?_=1677076143612 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()
# [22-Feb-2023 16:29:05] /vipcat/root/bg/ajax/basket/remove.html?_=1677076145202 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ":2}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:29: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` = 2 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
# [22-Feb-2023 16:29:05] /vipcat/root/bg/ajax/users/session.html?_=1677076145793 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()
# [22-Feb-2023 16:29:10] /vipcat/root/bg/ajax/basket/update.html?_=1677076150059 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ":1}',
                                `Qty` = 1
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:29:10] /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` = 2 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
# [22-Feb-2023 16:29:10] /vipcat/root/bg/ajax/users/session.html?_=1677076150954 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()
# [22-Feb-2023 16:29:15] /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
# [22-Feb-2023 16:29:16] /vipcat/root/bg/ajax/users/session.html?_=1677076155970 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()
# [22-Feb-2023 16:29:16] /vipcat/root/bg/ajax/prices.html?_=1677076155970 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()
# [22-Feb-2023 16:29:17] /vipcat/root/bg/ajax/prices.html?_=1677076156430 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()
# [22-Feb-2023 16:29:18] /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
# [22-Feb-2023 16:29:18] /vipcat/root/bg/ajax/users/session.html?_=1677076158162 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()
# [22-Feb-2023 16:29:18] /vipcat/root/bg/ajax/prices.html?_=1677076158162 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()
# [22-Feb-2023 16:29:19] /vipcat/root/bg/ajax/prices.html?_=1677076158592 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()
# [22-Feb-2023 16:29: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
# [22-Feb-2023 16:29:20] /vipcat/root/bg/ajax/users/session.html?_=1677076160576 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()
# [22-Feb-2023 16:29:20] /vipcat/root/bg/ajax/prices.html?_=1677076160577 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()
# [22-Feb-2023 16:29:21] /vipcat/root/bg/ajax/prices.html?_=1677076160904 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()
# [22-Feb-2023 16:29:22] /vipcat/root/bg/ajax/basket/add.html?_=1677076162833 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ":1,"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:29:22] /vipcat/root/bg/ajax/basket/popup.html?_=1677076162886 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` = 2 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` = 4 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [22-Feb-2023 16:34:44] /vipcat/root/bg/ajax/basket/remove.html?_=1677076483901 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1}',
                                `Qty` = 1
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:44: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
# [22-Feb-2023 16:44:07] /vipcat/root/bg/ajax/users/session.html?_=1677077047699 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()
# [22-Feb-2023 16:44:07] /vipcat/root/bg/ajax/prices.html?_=1677077047699 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()
# [22-Feb-2023 16:44:08] /vipcat/root/bg/ajax/prices.html?_=1677077047945 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()
# [22-Feb-2023 16:44:10] /vipcat/root/bg/ajax/basket/add.html?_=1677077050241 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":2}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:44:10] /vipcat/root/bg/ajax/basket/popup.html?_=1677077050282 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()
# [22-Feb-2023 16:45: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
# [22-Feb-2023 16:45:07] /vipcat/root/bg/ajax/users/session.html?_=1677077107967 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()
# [22-Feb-2023 16:45:08] /vipcat/root/bg/ajax/prices.html?_=1677077107967 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()
# [22-Feb-2023 16:45:08] /vipcat/root/bg/ajax/prices.html?_=1677077108350 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()
# [22-Feb-2023 16:45:12] /vipcat/root/bg/ajax/basket/add.html?_=1677077112128 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
# [22-Feb-2023 16:45:12] /vipcat/root/bg/ajax/basket/popup.html?_=1677077112162 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()
# [22-Feb-2023 16:45: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
# [22-Feb-2023 16:45:34] /vipcat/root/bg/ajax/users/session.html?_=1677077134234 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()
# [22-Feb-2023 16:45:34] /vipcat/root/bg/ajax/prices.html?_=1677077134235 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()
# [22-Feb-2023 16:45:34] /vipcat/root/bg/ajax/prices.html?_=1677077134518 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()
# [22-Feb-2023 16:45:37] /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
# [22-Feb-2023 16:45:37] /vipcat/root/bg/ajax/users/session.html?_=1677077137698 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()
# [22-Feb-2023 16:45:38] /vipcat/root/bg/ajax/prices.html?_=1677077137699 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()
# [22-Feb-2023 16:45:38] /vipcat/root/bg/ajax/prices.html?_=1677077138069 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()
# [22-Feb-2023 16:45:44] /vipcat/root/bg/ajax/basket/add.html?_=1677077144960 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
# [22-Feb-2023 16:45:44] /vipcat/root/bg/ajax/basket/popup.html?_=1677077145001 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()
# [22-Feb-2023 16:46:52] /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
# [22-Feb-2023 16:46:53] /vipcat/root/bg/ajax/users/session.html?_=1677077213450 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()
# [22-Feb-2023 16:46:53] /vipcat/root/bg/ajax/prices.html?_=1677077213451 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()
# [22-Feb-2023 16:46:54] /vipcat/root/bg/ajax/prices.html?_=1677077213806 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()
# [22-Feb-2023 16:46:56] /vipcat/root/bg/ajax/basket/add.html?_=1677077216150 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
# [22-Feb-2023 16:46:56] /vipcat/root/bg/ajax/basket/popup.html?_=1677077216242 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()
# [22-Feb-2023 16:47:03] /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
# [22-Feb-2023 16:47:04] /vipcat/root/bg/ajax/users/session.html?_=1677077224328 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()
# [22-Feb-2023 16:47:06] /vipcat/root/bg/ajax/basket/update.html?_=1677077226583 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
# [22-Feb-2023 16:47:06] /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
# [22-Feb-2023 16:47:07] /vipcat/root/bg/ajax/users/session.html?_=1677077227157 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()
# [22-Feb-2023 16:47:07] /vipcat/root/bg/ajax/basket/update.html?_=1677077227934 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
# [22-Feb-2023 16:47:07] /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
# [22-Feb-2023 16:47:08] /vipcat/root/bg/ajax/users/session.html?_=1677077228604 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()
# [22-Feb-2023 16:47:09] /vipcat/root/bg/ajax/basket/update.html?_=1677077229463 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":3}',
                                `Qty` = 3
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [22-Feb-2023 16:47:09] /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
# [22-Feb-2023 16:47:10] /vipcat/root/bg/ajax/users/session.html?_=1677077230257 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()
# [22-Feb-2023 16:50:54] /vipcat/root/bg/orders/list.html 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `orders`.`Customer` = 'ZZ059'
            ORDER BY
                `orders`.`PostDate` DESC
         LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                *
            FROM
                `orders`
            WHERE
                `orders`.`Customer` = 'ZZ059'
            ORDER BY
                `orders`.`PostDate` DESC
        ) AS CountTable
# [22-Feb-2023 16:50:54] /vipcat/root/bg/ajax/users/session.html?_=1677077454205 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()
# [22-Feb-2023 16:50:56] /vipcat/root/bg/ajax/orders/2.html?_=1677077456323 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 2
            LIMIT 1
# [22-Feb-2023 16:50:59] /vipcat/root/bg/ajax/orders/1.html?_=1677077459850 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [22-Feb-2023 16:51:02] /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
# [22-Feb-2023 16:51:03] /vipcat/root/bg/ajax/users/session.html?_=1677077463055 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()
# [22-Feb-2023 16:51:03] /vipcat/root/bg/ajax/prices.html?_=1677077463055 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()
# [22-Feb-2023 16:51:04] /vipcat/root/bg/ajax/prices.html?_=1677077463490 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()
# [22-Feb-2023 16:51:10] /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
# [22-Feb-2023 16:51:11] /vipcat/root/bg/ajax/users/session.html?_=1677077471127 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()
# [22-Feb-2023 16:51:11] /vipcat/root/bg/ajax/prices.html?_=1677077471128 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()
# [22-Feb-2023 16:51:11] /vipcat/root/bg/ajax/prices.html?_=1677077471500 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()
# [22-Feb-2023 16:51: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
# [22-Feb-2023 16:51:13] /vipcat/root/bg/ajax/users/session.html?_=1677077473462 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()
# [22-Feb-2023 16:51:13] /vipcat/root/bg/ajax/prices.html?_=1677077473463 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()
# [22-Feb-2023 16:51:13] /vipcat/root/bg/ajax/prices.html?_=1677077473736 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()
