# [16-Feb-2023 11:51:50] /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
# [16-Feb-2023 11:51:54] /vipcat/root/?customer=ZZ059&SID=347F8F2C5F7C42B39400884F5586EFFD527032&SPRN=32 167.99.142.201

set names utf8

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

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

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

set names utf8

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

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

set names utf8

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

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

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

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

set names utf8

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

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

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

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

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

set names utf8

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

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

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 11:57:47] /vipcat/root/ 167.99.142.201

set names utf8

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

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

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

set names utf8

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

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

set names utf8

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

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

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 11:58:04] /vipcat/root/?customer=ZZ059&SID=47BB2C81410A41E0AF96C765F29C9F54527032&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
# [16-Feb-2023 11:58:04] /vipcat/root/bg/ajax/users/session.html?_=1676541491206 167.99.142.201

set names utf8

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

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

set names utf8

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

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

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

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

set names utf8

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

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

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

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

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

set names utf8

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

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

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 11:58:20] /vipcat/root/?customer=ZZ059&SID=47BB2C81410A41E0AF96C765F29C9F54527032&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
# [16-Feb-2023 11:58:20] /vipcat/root/bg/ajax/users/session.html?_=1676541507295 167.99.142.201

set names utf8

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

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

set names utf8

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

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

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 11:58:30] /vipcat/root/?customer=ZZ059&SID=47BB2C81410A41E0AF96C765F29C9F54527032&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
# [16-Feb-2023 11:58:31] /vipcat/root/bg/ajax/users/session.html?_=1676541517814 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 11:58:31] /vipcat/root/bg/ajax/prices.html?_=1676541518202 167.99.142.201

set names utf8

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

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

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 11:58:34] /vipcat/root/?customer=ZZ059&SID=47BB2C81410A41E0AF96C765F29C9F54527032&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
# [16-Feb-2023 11:58:35] /vipcat/root/bg/ajax/users/session.html?_=1676541521931 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 11:58:35] /vipcat/root/bg/ajax/prices.html?_=1676541522198 167.99.142.201

set names utf8

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

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

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 11:58:55] /vipcat/root/?customer=ZZ059&SID=47BB2C81410A41E0AF96C765F29C9F54527032&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
# [16-Feb-2023 11:58:55] /vipcat/root/bg/ajax/users/session.html?_=1676541542220 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 11:58:55] /vipcat/root/bg/ajax/prices.html?_=1676541542545 167.99.142.201

set names utf8

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

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

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 12:00:35] /vipcat/root/?customer=ZZ059&SID=47BB2C81410A41E0AF96C765F29C9F54527032&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
# [16-Feb-2023 12:00:35] /vipcat/root/bg/ajax/users/session.html?_=1676541642401 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 12:00:35] /vipcat/root/bg/ajax/prices.html?_=1676541642719 167.99.142.201

set names utf8

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

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

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

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

set names utf8

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

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

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

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

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

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 12:00:48] /vipcat/root/bg/ajax/prices.html?_=1676541655638 167.99.142.201

set names utf8

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

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

set names utf8

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

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

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

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

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

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 12:01:39] /vipcat/root/bg/ajax/prices.html?_=1676541706033 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 12:01:42] /vipcat/root/bg/ajax/basket/add.html?_=1676541709485 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(), '{"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ":1}', 1)
# [16-Feb-2023 12:01:44] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 12:02:01] /vipcat/root/bg/products/1/накладки-дискови-lp702.html 167.99.142.201

set names utf8

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

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

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

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

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

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 12:02:02] /vipcat/root/bg/ajax/prices.html?_=1676541729064 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp702' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 12:02:04] /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
# [16-Feb-2023 12:02:04] /vipcat/root/bg/ajax/users/session.html?_=1676541730989 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 12:02:04] /vipcat/root/bg/ajax/prices.html?_=1676541731286 167.99.142.201

set names utf8

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

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

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 12:02:05] /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
# [16-Feb-2023 12:02:05] /vipcat/root/bg/ajax/users/session.html?_=1676541732218 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 12:02:05] /vipcat/root/bg/ajax/prices.html?_=1676541732481 167.99.142.201

set names utf8

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

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

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

set names utf8

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

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

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

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

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

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 12:02:07] /vipcat/root/bg/ajax/prices.html?_=1676541734277 167.99.142.201

set names utf8

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

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

set names utf8

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

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

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 12:02:11] /vipcat/root/bg/ajax/users/session.html?_=1676541738763 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 12:05:09] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 12:05:09] /vipcat/root/bg/ajax/users/session.html?_=1676541916373 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 15:53: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
# [16-Feb-2023 15:54:27] /vipcat/root/?customer=ZZ059&SID=3F0A4439142D48989432359340D188F3527032&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
# [16-Feb-2023 15:54:27] /vipcat/root/bg/ajax/users/session.html?_=1676555674829 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 15:54:27] /vipcat/root/bg/ajax/prices.html?_=1676555675099 167.99.142.201

set names utf8

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

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

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

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

set names utf8

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

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

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

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

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

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:02:32] /vipcat/root/bg/ajax/prices.html?_=1676556160117 167.99.142.201

set names utf8

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

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

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:02:36] /vipcat/root/bg/ajax/users/session.html?_=1676556163293 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:03:09] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:03:09] /vipcat/root/bg/ajax/users/session.html?_=1676556196611 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:03:41] /vipcat/root/bg/ajax/orders/submit.html?_=1676556228152 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`ID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2023-02-16 16:03:41', `Data` = '{"Products":[{"ID":"2","PostDate":"2022-12-28","LastUpdate":"2022-12-28 07:42:59","UploadID":"2022\\/12\\/28\\/2205203980","RefNumber":"LP702","RefID":"lp702","ArtNumber":"LP702","Brand":"DELPHI","Gallery":"[\\"lp702jpg.jpg\\"]","Selected":"1","Visible":"1","ProductID":"2","Language":"bg","Title":"Накладки дискови LP702","URLLabel":"накладки-дискови-lp702","Content":"знак за преглед: E1 90R-01881\\/450, <br>WVA-номер: 20547, <br>спирачна система: ATE, <br>с ламарина против скърцане, <br>без принадлежности, <br>не е за подготвен за предупредителен датчик за износване, <br>ширина 1: 140 мм, <br>ширина 2: 141 мм, <br>височина 1: 58 мм, <br>височина 2: 48 мм, <br>дебелина 1: 16 мм, <br>дебелина 2: 16 мм <br>","BasketID":"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ","Price":40,"Alt":"Накладки дискови LP702","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2022\\/12\\/28\\/2205203980\\/l_lp702jpg.jpg","Barcode":"5012759305188","Qty":1,"Total":40},{"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":"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9","Price":48,"Alt":"ЛЕТЕН ГАЩЕРИЗОН","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2023\\/02\\/14\\/6374059726\\/l_2.jpg","Barcode":"0004000000341","Size":"L","Qty":1,"Total":48}]}', `PostDate` = '2023-02-16 16:03:41', `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
# [16-Feb-2023 16:03:41] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:03:41] /vipcat/root/bg/ajax/users/session.html?_=1676556228801 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:05:09] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:05:09] /vipcat/root/bg/ajax/users/session.html?_=1676556316720 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:05:12] /vipcat/root/bg/ajax/basket/update.html?_=1676556319669 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ":2,"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1}',
                                `Qty` = 3
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [16-Feb-2023 16:05:12] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:05:12] /vipcat/root/bg/ajax/users/session.html?_=1676556320057 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:05:15] /vipcat/root/bg/ajax/basket/update.html?_=1676556322590 167.99.142.201

set names utf8

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

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

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:05:15] /vipcat/root/bg/ajax/users/session.html?_=1676556323002 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:05:19] /vipcat/root/bg/ajax/orders/submit.html?_=1676556326224 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`ID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2023-02-16 16:05:19', `Data` = '{"Products":[{"ID":"2","PostDate":"2022-12-28","LastUpdate":"2022-12-28 07:42:59","UploadID":"2022\\/12\\/28\\/2205203980","RefNumber":"LP702","RefID":"lp702","ArtNumber":"LP702","Brand":"DELPHI","Gallery":"[\\"lp702jpg.jpg\\"]","Selected":"1","Visible":"1","ProductID":"2","Language":"bg","Title":"Накладки дискови LP702","URLLabel":"накладки-дискови-lp702","Content":"знак за преглед: E1 90R-01881\\/450, <br>WVA-номер: 20547, <br>спирачна система: ATE, <br>с ламарина против скърцане, <br>без принадлежности, <br>не е за подготвен за предупредителен датчик за износване, <br>ширина 1: 140 мм, <br>ширина 2: 141 мм, <br>височина 1: 58 мм, <br>височина 2: 48 мм, <br>дебелина 1: 16 мм, <br>дебелина 2: 16 мм <br>","BasketID":"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ","Price":40,"Alt":"Накладки дискови LP702","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2022\\/12\\/28\\/2205203980\\/l_lp702jpg.jpg","Barcode":"5012759305188","Qty":1,"Total":40},{"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":"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9","Price":48,"Alt":"ЛЕТЕН ГАЩЕРИЗОН","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2023\\/02\\/14\\/6374059726\\/l_2.jpg","Barcode":"0004000000341","Size":"L","Qty":1,"Total":48}]}' WHERE `ID` = '9'
# [16-Feb-2023 16:05:19] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:05:19] /vipcat/root/bg/ajax/users/session.html?_=1676556326898 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:06:09] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:06:09] /vipcat/root/bg/ajax/users/session.html?_=1676556376987 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:06:49] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:06:50] /vipcat/root/bg/ajax/users/session.html?_=1676556417170 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:07:32] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:07:33] /vipcat/root/bg/ajax/users/session.html?_=1676556460476 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:08:55] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:08:55] /vipcat/root/bg/ajax/users/session.html?_=1676556542821 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:09:27] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:09:27] /vipcat/root/bg/ajax/users/session.html?_=1676556574655 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:09:52] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:09:52] /vipcat/root/bg/ajax/users/session.html?_=1676556599934 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:13:24] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:13:24] /vipcat/root/bg/ajax/users/session.html?_=1676556811780 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:13:30] /vipcat/root/bg/ajax/orders/submit.html?_=1676556817553 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`ID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2023-02-16 16:13:30', `Data` = '{"Products":[{"ID":"2","PostDate":"2022-12-28","LastUpdate":"2022-12-28 07:42:59","UploadID":"2022\\/12\\/28\\/2205203980","RefNumber":"LP702","RefID":"lp702","ArtNumber":"LP702","Brand":"DELPHI","Gallery":"[\\"lp702jpg.jpg\\"]","Selected":"1","Visible":"1","ProductID":"2","Language":"bg","Title":"Накладки дискови LP702","URLLabel":"накладки-дискови-lp702","Content":"знак за преглед: E1 90R-01881\\/450, <br>WVA-номер: 20547, <br>спирачна система: ATE, <br>с ламарина против скърцане, <br>без принадлежности, <br>не е за подготвен за предупредителен датчик за износване, <br>ширина 1: 140 мм, <br>ширина 2: 141 мм, <br>височина 1: 58 мм, <br>височина 2: 48 мм, <br>дебелина 1: 16 мм, <br>дебелина 2: 16 мм <br>","BasketID":"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ","Price":40,"Alt":"Накладки дискови LP702","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2022\\/12\\/28\\/2205203980\\/l_lp702jpg.jpg","Barcode":"5012759305188","Qty":1,"Total":40},{"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":"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9","Price":48,"Alt":"ЛЕТЕН ГАЩЕРИЗОН","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2023\\/02\\/14\\/6374059726\\/l_2.jpg","Barcode":"0004000000341","Size":"L","Qty":1,"Total":48}],"Comment":"sdfg sdfgsdfg sdfgsdfg sdfgsdfg"}', `PostDate` = '2023-02-16 16:13:30', `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
# [16-Feb-2023 16:13:30] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:13:31] /vipcat/root/bg/ajax/users/session.html?_=1676556818288 167.99.142.201

set names utf8

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

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

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:15:50] /vipcat/root/bg/ajax/users/session.html?_=1676556957163 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:15:56] /vipcat/root/bg/ajax/orders/submit.html?_=1676556963174 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`ID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2023-02-16 16:15:56', `Data` = '{"Products":[{"ID":"2","PostDate":"2022-12-28","LastUpdate":"2022-12-28 07:42:59","UploadID":"2022\\/12\\/28\\/2205203980","RefNumber":"LP702","RefID":"lp702","ArtNumber":"LP702","Brand":"DELPHI","Gallery":"[\\"lp702jpg.jpg\\"]","Selected":"1","Visible":"1","ProductID":"2","Language":"bg","Title":"Накладки дискови LP702","URLLabel":"накладки-дискови-lp702","Content":"знак за преглед: E1 90R-01881\\/450, <br>WVA-номер: 20547, <br>спирачна система: ATE, <br>с ламарина против скърцане, <br>без принадлежности, <br>не е за подготвен за предупредителен датчик за износване, <br>ширина 1: 140 мм, <br>ширина 2: 141 мм, <br>височина 1: 58 мм, <br>височина 2: 48 мм, <br>дебелина 1: 16 мм, <br>дебелина 2: 16 мм <br>","BasketID":"eyJpZCI6IjIiLCJiYyI6IjUwMTI3NTkzMDUxODgifQ","Price":40,"Alt":"Накладки дискови LP702","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2022\\/12\\/28\\/2205203980\\/l_lp702jpg.jpg","Barcode":"5012759305188","Qty":1,"Total":40},{"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":"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9","Price":48,"Alt":"ЛЕТЕН ГАЩЕРИЗОН","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2023\\/02\\/14\\/6374059726\\/l_2.jpg","Barcode":"0004000000341","Size":"L","Qty":1,"Total":48}]}', `Comment` = 'sdf sdfgsdfg sdfg' WHERE `ID` = '10'
# [16-Feb-2023 16:15:56] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 16:15:56] /vipcat/root/bg/ajax/users/session.html?_=1676556963870 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:22:27] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`ID`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 16:22:28] /vipcat/root/bg/ajax/users/session.html?_=1676557355263 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:29:12] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 16:29:13] /vipcat/root/bg/ajax/users/session.html?_=1676557760618 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:29:34] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 16:29:35] /vipcat/root/bg/ajax/users/session.html?_=1676557782284 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:30:01] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 16:30:02] /vipcat/root/bg/ajax/users/session.html?_=1676557809498 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:30:12] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 16:30:12] /vipcat/root/bg/ajax/users/session.html?_=1676557819738 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 16:31:17] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 16:31:18] /vipcat/root/bg/ajax/users/session.html?_=1676557885324 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:01:32] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
# [16-Feb-2023 17:01:33] /vipcat/root/bg/ajax/users/session.html?_=1676559700646 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:03:30] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:03:30] /vipcat/root/bg/ajax/users/session.html?_=1676559817698 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:03:35] /vipcat/root/bg/ajax/orders/send.html?_=1676559822747 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:10:21] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:10:21] /vipcat/root/bg/ajax/users/session.html?_=1676560229014 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:10:23] /vipcat/root/bg/ajax/orders/send.html?_=1676560230525 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:11:01] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:11:02] /vipcat/root/bg/ajax/users/session.html?_=1676560269428 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:11:03] /vipcat/root/bg/ajax/orders/send.html?_=1676560270597 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:11:32] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:11:33] /vipcat/root/bg/ajax/users/session.html?_=1676560300466 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:11:34] /vipcat/root/bg/ajax/orders/send.html?_=1676560301804 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:12:09] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:12:09] /vipcat/root/bg/ajax/users/session.html?_=1676560337148 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:12:11] /vipcat/root/bg/ajax/orders/send.html?_=1676560339076 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:12:35] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:12:35] /vipcat/root/bg/ajax/users/session.html?_=1676560362920 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:12:37] /vipcat/root/bg/ajax/orders/send.html?_=1676560364627 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:12:52] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:12:52] /vipcat/root/bg/ajax/users/session.html?_=1676560379985 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:12:54] /vipcat/root/bg/ajax/orders/send.html?_=1676560381611 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:15:16] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:15:17] /vipcat/root/bg/ajax/users/session.html?_=1676560524307 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:15:18] /vipcat/root/bg/ajax/orders/send.html?_=1676560525250 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:16:25] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:16:25] /vipcat/root/bg/ajax/users/session.html?_=1676560592781 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:16:27] /vipcat/root/bg/ajax/orders/send.html?_=1676560594240 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:24:17] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:24:18] /vipcat/root/bg/ajax/users/session.html?_=1676561065329 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:25:32] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:25:33] /vipcat/root/bg/ajax/users/session.html?_=1676561140484 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:25:36] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT
               `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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:25:37] /vipcat/root/bg/ajax/users/session.html?_=1676561144231 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:25:41] /vipcat/root/bg/ajax/basket/remove.html?_=1676561148920 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjQiLCJiYyI6IjAwMDQwMDAwMDAzNDEiLCJzIjoiTCJ9":1}',
                                `Qty` = 1
                            WHERE
                                `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                            LIMIT 1
# [16-Feb-2023 17:25:41] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:25:42] /vipcat/root/bg/ajax/users/session.html?_=1676561149209 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:25:43] /vipcat/root/bg/ajax/basket/remove.html?_=1676561150952 167.99.142.201

set names utf8

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

DELETE FROM `basket` WHERE `ClientID`= '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1
# [16-Feb-2023 17:25:43] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' LIMIT 1
# [16-Feb-2023 17:25:43] /vipcat/root/bg/ajax/users/session.html?_=1676561151143 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:25:52] /vipcat/root/ 167.99.142.201

set names utf8

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

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

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

set names utf8

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

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

set names utf8

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

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

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'lp885' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 17:25:55] /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
# [16-Feb-2023 17:25:55] /vipcat/root/bg/ajax/users/session.html?_=1676561162974 167.99.142.201

set names utf8

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

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

set names utf8

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

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000067' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 17:25:58] /vipcat/root/bg/products/2/лятна-шапка-с-козирка.html 167.99.142.201

set names utf8

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

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

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

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

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

set names utf8

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

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

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0000000067' AND `Visible` = 1 LIMIT 1
# [16-Feb-2023 17:26:00] /vipcat/root/bg/ajax/basket/add.html?_=1676561167704 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)
# [16-Feb-2023 17:26:01] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:26:02] /vipcat/root/bg/ajax/users/session.html?_=1676561169401 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:26:14] /vipcat/root/bg/ajax/orders/submit.html?_=1676561181553 167.99.142.201

set names utf8

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

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
                `orders`.`ID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2023-02-16 17:26:14', `Data` = '{"Products":[{"ID":"5","PostDate":"2023-02-15","LastUpdate":"2023-02-15 15:35:28","UploadID":"2023\\/02\\/15\\/6467789545","RefNumber":"0000000067","RefID":"0000000067","ArtNumber":"0000000067","Brand":"REPSOL","Gallery":"[\\"1.jpg\\"]","Selected":"0","Visible":"1","ProductID":"5","Language":"bg","Title":"ЛЯТНА ШАПКА С КОЗИРКА","URLLabel":"лятна-шапка-с-козирка","Content":"БЯЛА ШАПКА","BasketID":"eyJpZCI6IjUiLCJiYyI6IjAwMDIwMDAwMDAwNjcifQ","Price":12,"Alt":"ЛЯТНА ШАПКА С КОЗИРКА","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2023\\/02\\/15\\/6467789545\\/l_1.jpg","Barcode":"0002000000067","Qty":1,"Total":12}]}', `Comment` = 'sdf sdfgsdfg sdfg' WHERE `ID` = '10'
# [16-Feb-2023 17:26:14] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:26:14] /vipcat/root/bg/ajax/users/session.html?_=1676561182025 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:26:17] /vipcat/root/bg/ajax/orders/send.html?_=1676561184609 167.99.142.201

set names utf8

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

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:26:48] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:26:48] /vipcat/root/bg/ajax/users/session.html?_=1676561215844 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:26:50] /vipcat/root/bg/ajax/orders/send.html?_=1676561218089 167.99.142.201

set names utf8

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

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:27:13] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:27:13] /vipcat/root/bg/ajax/users/session.html?_=1676561240560 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:27:15] /vipcat/root/bg/ajax/orders/send.html?_=1676561242319 167.99.142.201

set names utf8

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

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:27:57] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:27:58] /vipcat/root/bg/ajax/users/session.html?_=1676561285456 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:27:59] /vipcat/root/bg/ajax/orders/send.html?_=1676561287047 167.99.142.201

set names utf8

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

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:29:12] /vipcat/root/bg/orders.html 167.99.142.201

set names utf8

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:29:12] /vipcat/root/bg/ajax/users/session.html?_=1676561359814 167.99.142.201

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8'
                 LIMIT 1
# [16-Feb-2023 17:29:14] /vipcat/root/bg/ajax/orders/send.html?_=1676561361551 167.99.142.201

set names utf8

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

SELECT
                `orders`.`ID`,
                `orders`.`Data`,
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:31:28] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '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
                `orders`.`Comment`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`ClientID` = `basket`.`ClientID`
            WHERE
                `basket`.`ClientID` = '7d022843457460126d57d01efb9a33de3a738b25607c8d7b67c035c02d006bf8' AND
                `orders`.`Status` = 0
            LIMIT 1
# [16-Feb-2023 17:31:29] /vipcat/root/bg/ajax/users/session.html?_=1676561496465 167.99.142.201

set names utf8

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

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