# [12-Jun-2023 12:05:44] /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
# [12-Jun-2023 12:05:55] /vipcat/root/?customer=ZZ059&SID=B625840869D24716A24E7073A40F6271527032&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
# [12-Jun-2023 12:05:55] /vipcat/root/bg/ajax/users/session.html?_=1686560755990 167.99.142.201

set names utf8

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

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

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

DELETE FROM `token`

INSERT INTO `token` (`ID`, `Token`, `Expires`) VALUES (NULL, 'hpdG_2jmv7EgQsnvLPogwiCW9T6cKOUFn4wieESaRfVv-kJYpMHygJxZaKYcaifdZfK7nRluaPGfAk1YBEiBkuOr82sIqZNc57LfebGL6zta32WTK6WYqhHJ8Dik4UvFnbYzS6QisfEfACXnE2E918_vNUixb4qmHU3d-CtQyoAjTjTCzmygd4VpAtm1o6X1NXysxHRx_3FujqYJysBiGnbwBFUb3bQ_P_67KR2wH11-0uzbAY-tJlkSCOGdF3lZiobdxoOX-GV_vBKNVD0lZ84uyNM7ldQwIRduHr486qln82CrwOmluVqqWfyU0Pe2IxLGfgKqQV3pjKDcbqSMp1jmX9Ks8t6m7z4EP0n98G3qh7yFX_qCocPk_U7D9ddRCMcGKf6yu9ZtGnxm1xpODH5WD8fVyuTTQJsZp7p5Rzv2cRdNmCh3Os8M9yNxAU9_HtHUx2NIIk-FKNgBZi_puVuWyzAxYTt5YpwQJaqFlBWb0t3PVj8YQ-VxuBpelysB2iEVDb4Dosh27ndYR1JnKQ', '2023-06-26')
# [12-Jun-2023 12:05:56] /vipcat/root/bg/ajax/prices.html?_=1686560756576 167.99.142.201

set names utf8

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

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

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:03] /vipcat/root/?customer=ZZ059&SID=B625840869D24716A24E7073A40F6271527032&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
# [12-Jun-2023 12:07:03] /vipcat/root/bg/ajax/users/session.html?_=1686560824168 167.99.142.201

set names utf8

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:06] /vipcat/root/?customer=ZZ059&SID=B625840869D24716A24E7073A40F6271527032&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
# [12-Jun-2023 12:07:06] /vipcat/root/bg/ajax/users/session.html?_=1686560827138 167.99.142.201

set names utf8

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:17] /vipcat/root/?customer=ZZ059&SID=B625840869D24716A24E7073A40F6271527032&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
# [12-Jun-2023 12:07:17] /vipcat/root/bg/ajax/users/session.html?_=1686560837877 167.99.142.201

set names utf8

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:17] /vipcat/root/bg/ajax/prices.html?_=1686560838198 167.99.142.201

set names utf8

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

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

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:18] /vipcat/root/?customer=ZZ059&SID=B625840869D24716A24E7073A40F6271527032&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
# [12-Jun-2023 12:07:18] /vipcat/root/bg/ajax/users/session.html?_=1686560839255 167.99.142.201

set names utf8

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:19] /vipcat/root/bg/ajax/prices.html?_=1686560839527 167.99.142.201

set names utf8

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

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

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:51] /vipcat/root/?customer=ZZ059&SID=B625840869D24716A24E7073A40F6271527032&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
# [12-Jun-2023 12:07:51] /vipcat/root/bg/ajax/users/session.html?_=1686560872271 167.99.142.201

set names utf8

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:52] /vipcat/root/bg/ajax/prices.html?_=1686560872539 167.99.142.201

set names utf8

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

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

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:52] /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` = 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`.`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` = 1 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` = 1 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` = 1 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC
# [12-Jun-2023 12:07:53] /vipcat/root/bg/ajax/users/session.html?_=1686560873642 167.99.142.201

set names utf8

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:53] /vipcat/root/bg/ajax/prices.html?_=1686560873896 167.99.142.201

set names utf8

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

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

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:54] /vipcat/root/bg/products/1/накладки-дискови-lp565.html 167.99.142.201

set names utf8

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

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

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

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

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

set names utf8

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:54] /vipcat/root/bg/ajax/prices.html?_=1686560875172 167.99.142.201

set names utf8

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:56] /vipcat/root/bg/ajax/basket/add.html?_=1686560876558 167.99.142.201

set names utf8

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

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('a6e3b00547eae6114615db721596cd3369f1b24e26a8cb4791e5debfbc1f5d70', NOW(), NOW(), '{"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ":1}', 1)
# [12-Jun-2023 12:07:56] /vipcat/root/bg/ajax/basket/popup.html?_=1686560876715 167.99.142.201

set names utf8

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:58] /vipcat/root/bg/basket.html 167.99.142.201

set names utf8

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

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:07:58] /vipcat/root/bg/ajax/users/session.html?_=1686560879040 167.99.142.201

set names utf8

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

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

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [12-Jun-2023 12:08:03] /vipcat/root/bg/ajax/orders/send.html?_=1686560883744 167.99.142.201

set names utf8

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

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `PostDate` = '2023-06-12 12:08:07', `LastUpdate` = '2023-06-12 12:08:07', `Customer` = 'ZZ059', `OrderNumber` = 'VIP000000008', `Products` = '[{"ID":"1","PostDate":"2022-12-28","LastUpdate":"2023-02-15 15:33:00","UploadID":"2022\\/12\\/28\\/2204793235","RefNumber":"LP565","RefID":"lp565","ArtNumber":"LP565","Brand":"DELPHI","Gallery":"[\\"lp565jpg.jpg\\"]","Selected":"1","Visible":"1","ProductID":"1","Language":"bg","Title":"Накладки дискови LP565","URLLabel":"накладки-дискови-lp565","Content":"знак за преглед: E1 90R-01878\\/507, <br>WVA-номер: 20961, <br>спирачна система: TRW, <br>без противоскърцаща планка, <br>с принадлежности, <br>не е за подготвен за предупредителен датчик за износване, <br>ширина 1: 87 мм, <br>ширина 2: 87 мм, <br>височина 1: 53 мм, <br>височина 2: 53 мм, <br>дебелина 1: 17 мм, <br>дебелина 2: 17 мм<br>Актуален номер: 20960, <br>D1017-7920, <br>D1112-8216, <br>D340-7335, <br>D894-7773<br><br>","BasketID":"eyJpZCI6IjEiLCJiYyI6IjUwMTI3NTkzMDM4MDEifQ","Price":42,"Alt":"Накладки дискови LP565","Image":"https:\\/\\/mgin.dev\\/vipcat\\/root\\/uf\\/products\\/2022\\/12\\/28\\/2204793235\\/l_lp565jpg.jpg","Barcode":"5012759303801","Avl":15,"Qty":1,"Total":42}]', `Comment` = 'test', `Total` = 42
