# [21-Feb-2023 12:08:40] /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
# [21-Feb-2023 12:08:40] /vipcat/root/bg/ajax/users/session.html?_=1676974123681 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [21-Feb-2023 12:08:40] /vipcat/root/bg/ajax/prices.html?_=1676974123725 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
# [21-Feb-2023 14:02:49] /vipcat/root/ 167.99.142.201

set names utf8

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

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

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

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [21-Feb-2023 14:02:49] /vipcat/root/bg/ajax/prices.html?_=1676980972814 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
# [21-Feb-2023 14:02:58] /vipcat/root/?customer=ZZ059&SID=9C273964DDA54CECB85C3345D5188A92527032&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
# [21-Feb-2023 14:02:58] /vipcat/root/bg/ajax/users/session.html?_=1676980981742 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:02:59] /vipcat/root/bg/ajax/prices.html?_=1676980982057 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()
# [21-Feb-2023 14:03:01] /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
# [21-Feb-2023 14:03:01] /vipcat/root/bg/ajax/users/session.html?_=1676980984670 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:03:05] /vipcat/root/?customer=ZZ059&SID=9C273964DDA54CECB85C3345D5188A92527032&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
# [21-Feb-2023 14:03:05] /vipcat/root/bg/ajax/users/session.html?_=1676980989015 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:03:06] /vipcat/root/bg/ajax/prices.html?_=1676980989281 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()
# [21-Feb-2023 14:03:07] /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
# [21-Feb-2023 14:03:08] /vipcat/root/bg/ajax/users/session.html?_=1676980991079 167.99.142.201

set names utf8

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

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

set names utf8

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

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

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:03:16] /vipcat/root/bg/ajax/prices.html?_=1676980999636 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()
# [21-Feb-2023 14:03: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
# [21-Feb-2023 14:03:20] /vipcat/root/bg/ajax/prices.html?_=1676981003561 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()
# [21-Feb-2023 14:03:20] /vipcat/root/bg/ajax/users/session.html?_=1676981003560 167.99.142.201

set names utf8

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

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

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDMwMDAwMDAzNDEiLCJzIjoiTSJ9":1,"eyJpZCI6IjQiLCJiYyI6IjAwMDIwMDAwMDAzNDEiLCJzIjoiUyJ9":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [21-Feb-2023 14:03:26] /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` = 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
# [21-Feb-2023 14:03:26] /vipcat/root/bg/ajax/users/session.html?_=1676981009931 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:03:30] /vipcat/root/bg/ajax/basket/remove.html?_=1676981013370 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDIwMDAwMDAzNDEiLCJzIjoiUyJ9":1}',
                                `Qty` = 1
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [21-Feb-2023 14:03:30] /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
# [21-Feb-2023 14:03:30] /vipcat/root/bg/ajax/users/session.html?_=1676981013920 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:03:34] /vipcat/root/bg/ajax/orders/submit.html?_=1676981017847 167.99.142.201

set names utf8

UPDATE
                    `basket`
                SET
                    `LastUpdate` = NOW(),
                    `Comment` = 'WERTWERT SDFG '
                WHERE
                    `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                LIMIT 1
# [21-Feb-2023 14:03:34] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

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

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

set names utf8

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

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

set names utf8

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

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

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

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

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

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:04:47] /vipcat/root/bg/ajax/orders/send.html?_=1676981090442 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
                    `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-21 14:04:48', `LastUpdate` = '2023-02-21 14:04:48', `Customer` = 'ZZ059', `OrderNumber` = 'VIP000000010', `Products` = '[{"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":"eyJpZCI6IjQiLCJiYyI6IjAwMDIwMDAwMDAzNDEiLCJzIjoiUyJ9","Price":48,"Alt":"ЛЕТЕН ГАЩЕРИЗОН","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2023\\/02\\/14\\/6374059726\\/l_2.jpg","Barcode":"0002000000341","Size":"S","Avl":22,"Qty":1,"Total":48}]', `Comment` = 'WERTWERT SDFG ', `Total` = 48

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

DELETE FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1
# [21-Feb-2023 14:04:52] /vipcat/root/bg/ajax/users/session.html?_=1676981095462 167.99.142.201

set names utf8

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

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:19:28] /vipcat/root/vCte4S0z/bg/ajax/users/form/login.html?_=1676981971064 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'error' AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [21-Feb-2023 14:19:31] /vipcat/root/vCte4S0z/bg/ajax/users/login.html?_=1676981974319 167.99.142.201

set names utf8

SELECT `ID`, `UserKey` FROM `users` WHERE `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' LIMIT 1
# [21-Feb-2023 14:19:31] /vipcat/root/vCte4S0z/ 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC) AS CountTable
# [21-Feb-2023 14:21:56] /vipcat/root/vCte4S0z 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC) AS CountTable
# [21-Feb-2023 14:21:59] /vipcat/root/vCte4S0z/bg/ajax/users/logout.html?_=1676982122148 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [21-Feb-2023 14:21: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
# [21-Feb-2023 14:21:59] /vipcat/root/bg/ajax/users/session.html?_=1676982122361 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:21:59] /vipcat/root/bg/ajax/prices.html?_=1676982122363 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()
# [21-Feb-2023 14:22:00] /vipcat/root/vCte4S0z/bg/ajax/users/form/login.html?_=1676982123856 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'error' AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [21-Feb-2023 14:22:01] /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
# [21-Feb-2023 14:22:01] /vipcat/root/bg/ajax/users/session.html?_=1676982124729 167.99.142.201

set names utf8

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

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:23:57] /vipcat/root/bg/ajax/orders/1.html?_=1676982240067 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `orders`.`ID` = :nID
            LIMIT 1
# [21-Feb-2023 14:24:42] /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
# [21-Feb-2023 14:24:42] /vipcat/root/bg/ajax/users/session.html?_=1676982285721 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:24:44] /vipcat/root/bg/ajax/orders/1.html?_=1676982287082 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = :nID
            LIMIT 1
# [21-Feb-2023 14:25:42] /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
# [21-Feb-2023 14:25:42] /vipcat/root/bg/ajax/users/session.html?_=1676982345611 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:25:44] /vipcat/root/bg/ajax/orders/1.html?_=1676982347425 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = :nID
            LIMIT 1
# [21-Feb-2023 14:27:55] /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
# [21-Feb-2023 14:27:55] /vipcat/root/bg/ajax/users/session.html?_=1676982478740 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:27:56] /vipcat/root/bg/ajax/orders/1.html?_=1676982479672 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:28:16] /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
# [21-Feb-2023 14:28:16] /vipcat/root/bg/ajax/users/session.html?_=1676982499373 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:28:18] /vipcat/root/bg/ajax/orders/1.html?_=1676982501264 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:29:06] /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
# [21-Feb-2023 14:29:06] /vipcat/root/bg/ajax/users/session.html?_=1676982549312 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:29:07] /vipcat/root/bg/ajax/orders/1.html?_=1676982550699 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:35:36] /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
# [21-Feb-2023 14:35:37] /vipcat/root/bg/ajax/users/session.html?_=1676982940062 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:35:38] /vipcat/root/bg/ajax/orders/1.html?_=1676982941362 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:37:16] /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
# [21-Feb-2023 14:37:17] /vipcat/root/bg/ajax/users/session.html?_=1676983040088 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:37:17] /vipcat/root/bg/ajax/orders/1.html?_=1676983041049 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:37:32] /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
# [21-Feb-2023 14:37:32] /vipcat/root/bg/ajax/users/session.html?_=1676983055370 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:37:33] /vipcat/root/bg/ajax/orders/1.html?_=1676983056481 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:37:55] /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
# [21-Feb-2023 14:37:55] /vipcat/root/bg/ajax/users/session.html?_=1676983078738 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:37:56] /vipcat/root/bg/ajax/orders/1.html?_=1676983079840 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:38:43] /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
# [21-Feb-2023 14:38:43] /vipcat/root/bg/ajax/users/session.html?_=1676983126155 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:38:44] /vipcat/root/bg/ajax/orders/1.html?_=1676983127138 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:39:00] /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
# [21-Feb-2023 14:39:00] /vipcat/root/bg/ajax/users/session.html?_=1676983143998 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:39:01] /vipcat/root/bg/ajax/orders/1.html?_=1676983144953 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:39:14] /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
# [21-Feb-2023 14:39:14] /vipcat/root/bg/ajax/users/session.html?_=1676983157900 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:39:15] /vipcat/root/bg/ajax/orders/1.html?_=1676983158945 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:39:29] /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
# [21-Feb-2023 14:39:29] /vipcat/root/bg/ajax/users/session.html?_=1676983172444 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:39:30] /vipcat/root/bg/ajax/orders/1.html?_=1676983173457 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:41:01] /vipcat/root/bg/ajax/orders/1.html?_=1676983264438 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:41:23] /vipcat/root/bg/ajax/orders/1.html?_=1676983286622 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:41:39] /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
# [21-Feb-2023 14:41:39] /vipcat/root/bg/ajax/users/session.html?_=1676983302724 167.99.142.201

set names utf8

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

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

set names utf8

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

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

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:43:59] /vipcat/root/bg/ajax/orders/1.html?_=1676983442902 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:47:19] /vipcat/root/bg/ajax/orders/1.html?_=1676983642065 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Feb-2023 14:51:22] /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
# [21-Feb-2023 14:51:22] /vipcat/root/bg/ajax/users/session.html?_=1676983885445 167.99.142.201

set names utf8

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

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:52:35] /vipcat/root/ 167.99.142.201

set names utf8

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

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

SELECT
               *
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `product_texts`.`Language` = 'bg' AND
                `products`.`selected` = 1
            GROUP BY `products`.`ID`
            ORDER BY `products`.`PostDate` DESC
# [21-Feb-2023 14:52:35] /vipcat/root/bg/ajax/prices.html?_=1676983958998 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()
# [21-Feb-2023 14:52:36] /vipcat/root/bg/ajax/users/session.html?_=1676983958998 167.99.142.201

set names utf8

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

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

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:54:15] /vipcat/root/bg/ajax/prices.html?_=1676984057991 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()
# [21-Feb-2023 14:57: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
# [21-Feb-2023 14:57:02] /vipcat/root/bg/ajax/users/session.html?_=1676984225426 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 14:57:02] /vipcat/root/bg/ajax/prices.html?_=1676984225426 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()
# [21-Feb-2023 14:57:04] /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
# [21-Feb-2023 14:57:04] /vipcat/root/bg/ajax/users/session.html?_=1676984227972 167.99.142.201

set names utf8

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

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [21-Feb-2023 15:03:39] /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
# [21-Feb-2023 15:03:39] /vipcat/root/bg/ajax/users/session.html?_=1676984623059 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()
# [21-Feb-2023 15:04:15] /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
# [21-Feb-2023 15:04:15] /vipcat/root/bg/ajax/users/session.html?_=1676984658298 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()
# [21-Feb-2023 15:06:23] /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
# [21-Feb-2023 15:06:23] /vipcat/root/bg/ajax/users/session.html?_=1676984786876 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()
# [21-Feb-2023 15:06:25] /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
# [21-Feb-2023 15:06:25] /vipcat/root/bg/ajax/users/session.html?_=1676984788999 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()
# [21-Feb-2023 15:06:41] /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
# [21-Feb-2023 15:06:41] /vipcat/root/bg/ajax/users/session.html?_=1676984804443 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()
# [21-Feb-2023 15:06:45] /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
# [21-Feb-2023 15:06:45] /vipcat/root/bg/ajax/users/session.html?_=1676984808504 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()
# [21-Feb-2023 15:07:14] /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
# [21-Feb-2023 15:07:14] /vipcat/root/bg/ajax/users/session.html?_=1676984837648 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()
# [21-Feb-2023 15:07:38] /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
# [21-Feb-2023 15:07:38] /vipcat/root/bg/ajax/users/session.html?_=1676984861892 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()
# [21-Feb-2023 15:07:40] /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
# [21-Feb-2023 15:07:41] /vipcat/root/bg/ajax/users/session.html?_=1676984864441 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()
# [21-Feb-2023 15:07:52] /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
# [21-Feb-2023 15:07:53] /vipcat/root/bg/ajax/users/session.html?_=1676984876129 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()
# [21-Feb-2023 15:08:13] /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
# [21-Feb-2023 15:08:13] /vipcat/root/bg/ajax/users/session.html?_=1676984896563 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()
# [21-Feb-2023 15:08:17] /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
# [21-Feb-2023 15:08:18] /vipcat/root/bg/ajax/users/session.html?_=1676984901279 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()
# [21-Feb-2023 15:08:52] /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
# [21-Feb-2023 15:08:53] /vipcat/root/bg/ajax/users/session.html?_=1676984936103 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()
# [21-Feb-2023 15:08:58] /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
# [21-Feb-2023 15:08:58] /vipcat/root/bg/ajax/users/session.html?_=1676984941874 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()
# [21-Feb-2023 15:08:59] /vipcat/root/bg/ajax/prices.html?_=1676984941875 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()
# [21-Feb-2023 15:09:00] /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
# [21-Feb-2023 15:09:00] /vipcat/root/bg/ajax/users/session.html?_=1676984943834 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()
# [21-Feb-2023 15:09:01] /vipcat/root/bg/ajax/prices.html?_=1676984943834 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()
# [21-Feb-2023 15:09:01] /vipcat/root/bg/products/2/лятна-шапка-с-козирка.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 5 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [21-Feb-2023 15:09:02] /vipcat/root/bg/ajax/users/session.html?_=1676984945220 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()
# [21-Feb-2023 15:09:02] /vipcat/root/bg/ajax/prices.html?_=1676984945221 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()
# [21-Feb-2023 15:09:03] /vipcat/root/bg/ajax/basket/add.html?_=1676984946545 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(), '{"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":1}', 1)
# [21-Feb-2023 15:09:47] /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
# [21-Feb-2023 15:09:48] /vipcat/root/bg/ajax/users/session.html?_=1676984991218 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()
# [21-Feb-2023 15:09:48] /vipcat/root/bg/ajax/prices.html?_=1676984991219 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()
# [21-Feb-2023 15:09:48] /vipcat/root/bg/ajax/prices.html?_=1676984991469 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()
# [21-Feb-2023 15:09:50] /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
# [21-Feb-2023 15:09:51] /vipcat/root/bg/ajax/users/session.html?_=1676984994198 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()
# [21-Feb-2023 15:09:51] /vipcat/root/bg/ajax/prices.html?_=1676984994199 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()
# [21-Feb-2023 15:09:51] /vipcat/root/bg/ajax/prices.html?_=1676984994435 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()
# [21-Feb-2023 15:09:54] /vipcat/root/bg/ajax/basket/add.html?_=1676984997768 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":2}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [21-Feb-2023 15:31:55] /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
# [21-Feb-2023 15:31:55] /vipcat/root/bg/ajax/users/session.html?_=1676986318334 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()
# [21-Feb-2023 15:31:55] /vipcat/root/bg/ajax/prices.html?_=1676986318334 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()
# [21-Feb-2023 15:31:55] /vipcat/root/bg/ajax/prices.html?_=1676986318689 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()
# [21-Feb-2023 15:31:57] /vipcat/root/bg/ajax/basket/add.html?_=1676986320259 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":3}',
                                `Qty` = 3
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [21-Feb-2023 15:32: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
# [21-Feb-2023 15:32:05] /vipcat/root/bg/ajax/users/session.html?_=1676986328632 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()
# [21-Feb-2023 15:32:05] /vipcat/root/bg/ajax/prices.html?_=1676986328633 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()
# [21-Feb-2023 15:32:05] /vipcat/root/bg/ajax/prices.html?_=1676986328913 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()
# [21-Feb-2023 15:32:08] /vipcat/root/bg/ajax/basket/add.html?_=1676986331980 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":4}',
                                `Qty` = 4
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [21-Feb-2023 15:32:08] /vipcat/root/bg/ajax/basket/popup.html?_=1676986332013 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()
# [21-Feb-2023 15:37:29] /vipcat/root/bg/products/2/лятна-шапка-с-козирка.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 5 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC
# [21-Feb-2023 15:37:29] /vipcat/root/bg/ajax/users/session.html?_=1676986652640 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()
# [21-Feb-2023 15:37:29] /vipcat/root/bg/ajax/prices.html?_=1676986652641 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()
# [21-Feb-2023 15:37:29] /vipcat/root/bg/ajax/prices.html?_=1676986652945 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()
# [21-Feb-2023 15:37:32] /vipcat/root/bg/ajax/basket/add.html?_=1676986655479 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":5}',
                                `Qty` = 5
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [21-Feb-2023 15:37:32] /vipcat/root/bg/ajax/basket/popup.html?_=1676986655515 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()
# [21-Feb-2023 15:39:19] /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
# [21-Feb-2023 15:39:19] /vipcat/root/bg/ajax/users/session.html?_=1676986762556 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()
# [21-Feb-2023 15:39:19] /vipcat/root/bg/ajax/prices.html?_=1676986762556 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()
# [21-Feb-2023 15:39:19] /vipcat/root/bg/ajax/prices.html?_=1676986762814 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()
# [21-Feb-2023 15:39:20] /vipcat/root/bg/ajax/basket/add.html?_=1676986764006 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ":6}',
                                `Qty` = 6
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [21-Feb-2023 15:39:20] /vipcat/root/bg/ajax/basket/popup.html?_=1676986764048 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()
# [21-Feb-2023 15:40:23] /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 `Token` FROM `token` WHERE `Expires` > CURDATE()

SELECT
                    `Comment`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [21-Feb-2023 15:40:23] /vipcat/root/bg/ajax/users/session.html?_=1676986826951 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()
