# [13-Dec-2022 15:37:07] /unicat/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
# [13-Dec-2022 15:37:07] /unicat/root/bg/ajax/prices.html?_=1670938630590 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0990822-serwo' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = '54267-jbm' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'super-conc-screen-wash-21-1l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'rowe-antifreeze-g12-15l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0970816-serwo-gmbh' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'emergency-car-kit' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'os-h7-12v-55w-nb-x2' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = '036164' AND `Visible` = 1 LIMIT 1
# [13-Dec-2022 15:37:20] /unicat/root/nRqioDzp/bg/ajax/users/form/login.html?_=1670938644035 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'error' AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Dec-2022 15:37:24] /unicat/root/nRqioDzp/bg/ajax/users/login.html?_=1670938647508 167.99.142.201

set names utf8

SELECT `ID`, `UserKey` FROM `users` WHERE `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQ%' LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'error' AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Dec-2022 15:37:26] /unicat/root/nRqioDzp/bg/ajax/users/form/login.html?_=1670938649937 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'error' AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Dec-2022 15:37:30] /unicat/root/nRqioDzp/bg/ajax/users/login.html?_=1670938653110 167.99.142.201

set names utf8

SELECT `ID`, `UserKey` FROM `users` WHERE `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' LIMIT 1
# [13-Dec-2022 15:37:30] /unicat/root/nRqioDzp/ 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC) AS CountTable
# [13-Dec-2022 15:37:32] /unicat/root/nRqioDzp/?sort=40 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` ASC) AS CountTable
# [13-Dec-2022 15:37:33] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:37:35] /unicat/root/nRqioDzp/bg/ajax/products/form/18.html?_=1670938658586 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 18 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 18

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 676
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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` = 18 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:37:56] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:37:57] /unicat/root/nRqioDzp/bg/ajax/products/form/18.html?_=1670938680425 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 18 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 18

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 676
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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` = 18 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:37:59] /unicat/root/nRqioDzp/bg/ajax/products/update/18.html?_=1670938682641 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30851-20ax5maxi'
         AND `ID` != 18 LIMIT 1
# [13-Dec-2022 15:41:26] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:41:27] /unicat/root/nRqioDzp/bg/ajax/products/form/18.html?_=1670938890334 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 18 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 18

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 676
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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` = 18 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:41:30] /unicat/root/nRqioDzp/bg/ajax/products/update/18.html?_=1670938893589 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30851-20ax5maxi'
         AND `ID` != 18 LIMIT 1
# [13-Dec-2022 15:41:38] /unicat/root/nRqioDzp/bg/ajax/products/form/18.html?_=1670938901764 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 18 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 18

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 676
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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` = 18 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:41:44] /unicat/root/nRqioDzp/bg/ajax/products/update/18.html?_=1670938908037 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30851-20ax5maxi'
         AND `ID` != 18 LIMIT 1
# [13-Dec-2022 15:41:55] /unicat/root/nRqioDzp/bg/ajax/products/form/18.html?_=1670938918219 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 18 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 18

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 676
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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` = 18 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:42:01] /unicat/root/nRqioDzp/bg/ajax/products/update/18.html?_=1670938924733 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30851-20ax5maxi'
         AND `ID` != 18 LIMIT 1
# [13-Dec-2022 15:42:07] /unicat/root/nRqioDzp/bg/ajax/products/form/6.html?_=1670938930643 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 6 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 6

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 674
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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` = 6 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:42:44] /unicat/root/nRqioDzp/bg/ajax/products/form/6.html?_=1670938967706 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 6 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 6

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 674
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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` = 6 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:42:50] /unicat/root/nRqioDzp/bg/ajax/products/update/6.html?_=1670938973925 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30601-20ax50box'
         AND `ID` != 6 LIMIT 1
# [13-Dec-2022 15:43:14] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:43:16] /unicat/root/nRqioDzp/bg/ajax/products/form/6.html?_=1670939000018 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 6 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 6

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 674
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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` = 6 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:43:23] /unicat/root/nRqioDzp/bg/ajax/products/update/6.html?_=1670939006364 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30601-20ax50box'
         AND `ID` != 6 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '6', `PostDate` = '2025-01-01', `LastUpdate` = '2022-12-13 15:43:23', `UploadID` = '2022/03/07/6658899517', `PromoStart` = '2022-12-01 00:00:00', `PromoEnd` = '2022-12-17 00:23:59', `Timer` = 1, `RefNumber` = 'TPS 30601 20Ax50BOX', `RefID` = 'tps-30601-20ax50box', `ArtNumber` = '30601', `Brand` = 'TECNOPART', `Gallery` = '["tps-30601-20ax50box_001.jpg","tps-30601-20ax50box_002.jpg"]', `Selected` = 0, `Visible` = 1 WHERE `ID` = '6'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

UPDATE `product_texts` SET `ProductID` = '6', `Language` = 'bg', `Title` = 'БУШОНИ 20 А, КУТИЯ 50 БРОЯ', `URLLabel` = '30601tps', `Content` = 'БУШОНИ 20 А, КУТИЯ 50 БРОЯ' WHERE `ProductID` = '6' AND `Language` = 'bg'

DELETE FROM `product_groups` WHERE `ProductID` = '6'

INSERT INTO `product_groups` (`ProductID`, `GroupID`) VALUES 
	('6', '674');

DELETE FROM `product_params` WHERE `ProductID` = '6'
# [13-Dec-2022 15:43:29] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:43:36] /unicat/root/nRqioDzp/bg/ajax/products/form/18.html?_=1670939019530 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 18 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 18

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 676
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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` = 18 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:43:39] /unicat/root/nRqioDzp/bg/ajax/products/update/18.html?_=1670939022612 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30851-20ax5maxi'
         AND `ID` != 18 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '18', `PostDate` = '2037-01-01', `LastUpdate` = '2022-12-13 15:43:39', `UploadID` = '2022/03/07/6658904385', `PromoStart` = NULL, `PromoEnd` = NULL, `Timer` = 0, `RefNumber` = 'TPS 30851 20Ax5maxi', `RefID` = 'tps-30851-20ax5maxi', `ArtNumber` = '30851', `Brand` = 'TECNOPART', `Gallery` = '["tps-30851-20ax5maxi_001.jpg","tps-30851-20ax5maxi_002.jpg"]', `Selected` = 0, `Visible` = 1 WHERE `ID` = '18'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

UPDATE `product_texts` SET `ProductID` = '18', `Language` = 'bg', `Title` = 'БУШОНИ МАКСИ 20 А, К-Т 5 БРОЯ', `URLLabel` = '30851tps', `Content` = 'БУШОНИ МАКСИ 20 А, К-Т 5 БРОЯ' WHERE `ProductID` = '18' AND `Language` = 'bg'

DELETE FROM `product_groups` WHERE `ProductID` = '18'

INSERT INTO `product_groups` (`ProductID`, `GroupID`) VALUES 
	('18', '676');

DELETE FROM `product_params` WHERE `ProductID` = '18'
# [13-Dec-2022 15:43:42] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:43:44] /unicat/root/nRqioDzp/bg/ajax/products/form/6.html?_=1670939028003 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 6 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 6

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 674
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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` = 6 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:44:22] /unicat/root/nRqioDzp/bg/ajax/products/update/6.html?_=1670939065588 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30601-20ax50box'
         AND `ID` != 6 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '6', `PostDate` = '2025-01-01', `LastUpdate` = '2022-12-13 15:44:22', `UploadID` = '2022/03/07/6658899517', `PromoStart` = NULL, `PromoEnd` = NULL, `Timer` = 1, `RefNumber` = 'TPS 30601 20Ax50BOX', `RefID` = 'tps-30601-20ax50box', `ArtNumber` = '30601', `Brand` = 'TECNOPART', `Gallery` = '["tps-30601-20ax50box_001.jpg","tps-30601-20ax50box_002.jpg"]', `Selected` = 0, `Visible` = 1 WHERE `ID` = '6'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

UPDATE `product_texts` SET `ProductID` = '6', `Language` = 'bg', `Title` = 'БУШОНИ 20 А, КУТИЯ 50 БРОЯ', `URLLabel` = '30601tps', `Content` = 'БУШОНИ 20 А, КУТИЯ 50 БРОЯ' WHERE `ProductID` = '6' AND `Language` = 'bg'

DELETE FROM `product_groups` WHERE `ProductID` = '6'

INSERT INTO `product_groups` (`ProductID`, `GroupID`) VALUES 
	('6', '674');

DELETE FROM `product_params` WHERE `ProductID` = '6'
# [13-Dec-2022 15:44:24] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:44:26] /unicat/root/nRqioDzp/bg/ajax/products/form/5.html?_=1670939069442 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 5 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 5

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 674
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:44:34] /unicat/root/nRqioDzp/bg/ajax/products/update/5.html?_=1670939078052 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30581-15ax50box'
         AND `ID` != 5 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '5', `PostDate` = '2024-01-01', `LastUpdate` = '2022-12-13 15:44:34', `UploadID` = '2022/03/07/6658899291', `PromoStart` = NULL, `PromoEnd` = NULL, `Timer` = 1, `RefNumber` = 'TPS 30581 15Ax50BOX', `RefID` = 'tps-30581-15ax50box', `ArtNumber` = '30581', `Brand` = 'TECNOPART', `Gallery` = '["tps-30581-15ax50box_001.jpg","tps-30581-15ax50box_002.jpg"]', `Selected` = 0, `Visible` = 1 WHERE `ID` = '5'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

UPDATE `product_texts` SET `ProductID` = '5', `Language` = 'bg', `Title` = 'БУШОНИ 15 А, КУТИЯ 50 БРОЯ', `URLLabel` = '30581tps', `Content` = 'БУШОНИ 15 А, КУТИЯ 50 БРОЯ' WHERE `ProductID` = '5' AND `Language` = 'bg'

DELETE FROM `product_groups` WHERE `ProductID` = '5'

INSERT INTO `product_groups` (`ProductID`, `GroupID`) VALUES 
	('5', '674');

DELETE FROM `product_params` WHERE `ProductID` = '5'
# [13-Dec-2022 15:44:40] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:44:42] /unicat/root/nRqioDzp/bg/ajax/products/form/4.html?_=1670939085290 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 4 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 4

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 674
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:44:46] /unicat/root/nRqioDzp/bg/ajax/products/update/4.html?_=1670939089427 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30561-10ax50box'
         AND `ID` != 4 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '4', `PostDate` = '2023-01-01', `LastUpdate` = '2022-12-13 15:44:46', `UploadID` = '2022/03/07/6658899052', `PromoStart` = NULL, `PromoEnd` = NULL, `Timer` = 1, `RefNumber` = 'TPS 30561 10Ax50BOX', `RefID` = 'tps-30561-10ax50box', `ArtNumber` = '30561', `Brand` = 'TECNOPART', `Gallery` = '["tps-30561-10ax50box_001.jpg","tps-30561-10ax50box_002.jpg"]', `Selected` = 0, `Visible` = 1 WHERE `ID` = '4'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

UPDATE `product_texts` SET `ProductID` = '4', `Language` = 'bg', `Title` = 'БУШОНИ 10 А, КУТИЯ 50 БРОЯ', `URLLabel` = '30561tps', `Content` = 'БУШОНИ 10 А, КУТИЯ 50 БРОЯ' WHERE `ProductID` = '4' AND `Language` = 'bg'

DELETE FROM `product_groups` WHERE `ProductID` = '4'

INSERT INTO `product_groups` (`ProductID`, `GroupID`) VALUES 
	('4', '674');

DELETE FROM `product_params` WHERE `ProductID` = '4'
# [13-Dec-2022 15:44:48] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:44:50] /unicat/root/nRqioDzp/bg/ajax/products/form/1.html?_=1670939093203 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 1

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 273
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:44:56] /unicat/root/nRqioDzp/bg/ajax/products/update/1.html?_=1670939099643 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30501-3ax50box'
         AND `ID` != 1 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '1', `PostDate` = '2020-01-01', `LastUpdate` = '2022-12-13 15:44:56', `UploadID` = '2022/03/07/6658898283', `PromoStart` = '2022-12-12 00:00:00', `PromoEnd` = '2022-12-17 00:23:59', `Timer` = 0, `RefNumber` = 'TPS 30501 3Ax50BOX', `RefID` = 'tps-30501-3ax50box', `ArtNumber` = '30501', `Brand` = 'TECNOPART', `Gallery` = '["tps-30501-3ax50box_001.jpg","tps-30501-3ax50box_002.jpg"]', `Selected` = 0, `Visible` = 1 WHERE `ID` = '1'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

UPDATE `product_texts` SET `ProductID` = '1', `Language` = 'bg', `Title` = 'БУШОНИ 3 А, КУТИЯ 50 БРОЯ', `URLLabel` = 'tps-30501', `Content` = 'БУШОНИ 3 А, КУТИЯ 50 БРОЯ' WHERE `ProductID` = '1' AND `Language` = 'bg'

DELETE FROM `product_groups` WHERE `ProductID` = '1'

INSERT INTO `product_groups` (`ProductID`, `GroupID`) VALUES 
	('1', '273');

DELETE FROM `product_params` WHERE `ProductID` = '1'
# [13-Dec-2022 15:44:57] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:45:01] /unicat/root/nRqioDzp/bg/ajax/products/form/1.html?_=1670939104483 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 1

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 273
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:45:05] /unicat/root/nRqioDzp/bg/ajax/products/update/1.html?_=1670939108715 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30501-3ax50box'
         AND `ID` != 1 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '1', `PostDate` = '2020-01-01', `LastUpdate` = '2022-12-13 15:45:05', `UploadID` = '2022/03/07/6658898283', `PromoStart` = '2022-12-12 12:30:00', `PromoEnd` = '2022-12-17 00:23:00', `Timer` = 0, `RefNumber` = 'TPS 30501 3Ax50BOX', `RefID` = 'tps-30501-3ax50box', `ArtNumber` = '30501', `Brand` = 'TECNOPART', `Gallery` = '["tps-30501-3ax50box_001.jpg","tps-30501-3ax50box_002.jpg"]', `Selected` = 0, `Visible` = 1 WHERE `ID` = '1'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

UPDATE `product_texts` SET `ProductID` = '1', `Language` = 'bg', `Title` = 'БУШОНИ 3 А, КУТИЯ 50 БРОЯ', `URLLabel` = 'tps-30501', `Content` = 'БУШОНИ 3 А, КУТИЯ 50 БРОЯ' WHERE `ProductID` = '1' AND `Language` = 'bg'

DELETE FROM `product_groups` WHERE `ProductID` = '1'

INSERT INTO `product_groups` (`ProductID`, `GroupID`) VALUES 
	('1', '273');

DELETE FROM `product_params` WHERE `ProductID` = '1'
# [13-Dec-2022 15:45:08] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:45:34] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:45:35] /unicat/root/nRqioDzp/bg/ajax/products/form/1.html?_=1670939138706 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 1

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 273
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:45:41] /unicat/root/nRqioDzp/bg/ajax/products/update/1.html?_=1670939145010 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30501-3ax50box'
         AND `ID` != 1 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '1', `PostDate` = '2020-01-01', `LastUpdate` = '2022-12-13 15:45:41', `UploadID` = '2022/03/07/6658898283', `PromoStart` = '2022-12-12 12:30:00', `PromoEnd` = '2022-12-17 23:59:00', `Timer` = 0, `RefNumber` = 'TPS 30501 3Ax50BOX', `RefID` = 'tps-30501-3ax50box', `ArtNumber` = '30501', `Brand` = 'TECNOPART', `Gallery` = '["tps-30501-3ax50box_001.jpg","tps-30501-3ax50box_002.jpg"]', `Selected` = 0, `Visible` = 1 WHERE `ID` = '1'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

UPDATE `product_texts` SET `ProductID` = '1', `Language` = 'bg', `Title` = 'БУШОНИ 3 А, КУТИЯ 50 БРОЯ', `URLLabel` = 'tps-30501', `Content` = 'БУШОНИ 3 А, КУТИЯ 50 БРОЯ' WHERE `ProductID` = '1' AND `Language` = 'bg'

DELETE FROM `product_groups` WHERE `ProductID` = '1'

INSERT INTO `product_groups` (`ProductID`, `GroupID`) VALUES 
	('1', '273');

DELETE FROM `product_params` WHERE `ProductID` = '1'
# [13-Dec-2022 15:45:45] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:48:51] /unicat/root/nRqioDzp/bg/ajax/users/logout.html?_=1670939334605 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [13-Dec-2022 15:48:51] /unicat/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
# [13-Dec-2022 15:48:51] /unicat/root/bg/ajax/prices.html?_=1670939334916 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0990822-serwo' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = '54267-jbm' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'super-conc-screen-wash-21-1l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'rowe-antifreeze-g12-15l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0970816-serwo-gmbh' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'emergency-car-kit' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'os-h7-12v-55w-nb-x2' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = '036164' AND `Visible` = 1 LIMIT 1
# [13-Dec-2022 15:48:54] /unicat/root/bg/promo.html 167.99.142.201

set names utf8

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `products`.`PromoEnd`,
               `products`.`Timer`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               `product_groups`.`GroupID`
            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
                (`PromoStart` IS NOT NULL OR `PromoEnd` IS NOT NULL) AND
                (`PromoStart` IS NULL OR `PromoStart` <= NOW()) AND
                (`PromoEnd` IS NULL OR `PromoEnd` >= NOW()) AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC
# [13-Dec-2022 15:48:55] /unicat/root/bg/promo.html 167.99.142.201

set names utf8

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `products`.`PromoEnd`,
               `products`.`Timer`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               `product_groups`.`GroupID`
            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
                (`PromoStart` IS NOT NULL OR `PromoEnd` IS NOT NULL) AND
                (`PromoStart` IS NULL OR `PromoStart` <= NOW()) AND
                (`PromoEnd` IS NULL OR `PromoEnd` >= NOW()) AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC
# [13-Dec-2022 15:49:02] /unicat/root/nRqioDzp/bg/ajax/users/form/login.html?_=1670939345928 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'error' AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Dec-2022 15:49:07] /unicat/root/nRqioDzp/bg/ajax/users/login.html?_=1670939350084 167.99.142.201

set names utf8

SELECT `ID`, `UserKey` FROM `users` WHERE `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' LIMIT 1
# [13-Dec-2022 15:49:07] /unicat/root/nRqioDzp/ 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`LastUpdate` ASC) AS CountTable
# [13-Dec-2022 15:49:09] /unicat/root/nRqioDzp/?sort=40 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` ASC) AS CountTable
# [13-Dec-2022 15:49:10] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:49:11] /unicat/root/nRqioDzp/bg/ajax/products/form/1.html?_=1670939354990 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 1

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 273
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:49:16] /unicat/root/nRqioDzp/bg/ajax/products/update/1.html?_=1670939359615 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'tps-30501-3ax50box'
         AND `ID` != 1 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '1', `PostDate` = '2020-01-01', `LastUpdate` = '2022-12-13 15:49:16', `UploadID` = '2022/03/07/6658898283', `PromoStart` = '2022-12-12 12:30:00', `PromoEnd` = '2022-12-17 23:59:00', `Timer` = 1, `RefNumber` = 'TPS 30501 3Ax50BOX', `RefID` = 'tps-30501-3ax50box', `ArtNumber` = '30501', `Brand` = 'TECNOPART', `Gallery` = '["tps-30501-3ax50box_001.jpg","tps-30501-3ax50box_002.jpg"]', `Selected` = 0, `Visible` = 1 WHERE `ID` = '1'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

UPDATE `product_texts` SET `ProductID` = '1', `Language` = 'bg', `Title` = 'БУШОНИ 3 А, КУТИЯ 50 БРОЯ', `URLLabel` = 'tps-30501', `Content` = 'БУШОНИ 3 А, КУТИЯ 50 БРОЯ' WHERE `ProductID` = '1' AND `Language` = 'bg'

DELETE FROM `product_groups` WHERE `ProductID` = '1'

INSERT INTO `product_groups` (`ProductID`, `GroupID`) VALUES 
	('1', '273');

DELETE FROM `product_params` WHERE `ProductID` = '1'
# [13-Dec-2022 15:49:16] /unicat/root/nRqioDzp/?sort=41 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
               *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
         ORDER BY `products`.`PromoEnd` DESC) AS CountTable
# [13-Dec-2022 15:49:18] /unicat/root/nRqioDzp/bg/ajax/products/form/1.html?_=1670939361254 167.99.142.201

set names utf8

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

SELECT
                `products`.*,
                `product_texts`.*,
                GROUP_CONCAT(`GroupID` SEPARATOR ',') AS `Groups`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                LEFT JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `products`.`ID` = 1 AND
                `product_texts`.`Language` = 'bg'
            LIMIT 1

SELECT `ImgValues` FROM `params` WHERE `Code` = 'brand' LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC

SELECT
                    `GroupID`
                FROM
                    `product_groups`
                WHERE
                    `ProductID` = 1

SELECT
                `MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg' AND
                `groups`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 273
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`
                FROM
                    `params`
                    INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                WHERE
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `param_texts`.`Title` ASC

SELECT
                    `param_texts`.`ParamID`,
                    IF(
                        `param_texts`.`Metric` = '',
                        `param_texts`.`Title`,
                        CONCAT_WS(' ', `param_texts`.`Title`, CONCAT('[', `param_texts`.`Metric`, ']'))
                    ) AS `Param`,
                    `ParamValue`
                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'
                ORDER BY
                    `params`.`PostDate` DESC
# [13-Dec-2022 15:49:26] /unicat/root/ 167.99.142.201

set names utf8

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

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
# [13-Dec-2022 15:49:26] /unicat/root/bg/ajax/users/session.html?_=1670939369604 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [13-Dec-2022 15:49:26] /unicat/root/bg/ajax/prices.html?_=1670939369645 167.99.142.201

set names utf8

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

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0990822-serwo' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = '54267-jbm' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'super-conc-screen-wash-21-1l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'rowe-antifreeze-g12-15l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = '0970816-serwo-gmbh' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'emergency-car-kit' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'os-h7-12v-55w-nb-x2' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = '036164' AND `Visible` = 1 LIMIT 1
# [13-Dec-2022 15:49:29] /unicat/root/bg/promo.html 167.99.142.201

set names utf8

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

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `products`.`PromoEnd`,
               `products`.`Timer`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               `product_groups`.`GroupID`
            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
                (`PromoStart` IS NOT NULL OR `PromoEnd` IS NOT NULL) AND
                (`PromoStart` IS NULL OR `PromoStart` <= NOW()) AND
                (`PromoEnd` IS NULL OR `PromoEnd` >= NOW()) AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC
# [13-Dec-2022 15:49:29] /unicat/root/bg/ajax/users/session.html?_=1670939373055 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [13-Dec-2022 15:49:32] /unicat/root/bg/products/273/tps-30501.html 167.99.142.201

set names utf8

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

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` = 'tps-30501' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 273
            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` = 273
                        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
# [13-Dec-2022 15:49:32] /unicat/root/bg/ajax/users/session.html?_=1670939375334 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [13-Dec-2022 15:49:32] /unicat/root/bg/ajax/prices.html?_=1670939375368 167.99.142.201

set names utf8

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

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30501-3ax50box' AND `Visible` = 1 LIMIT 1
# [13-Dec-2022 15:49:33] /unicat/root/bg/promo.html 167.99.142.201

set names utf8

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

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `products`.`PromoEnd`,
               `products`.`Timer`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               `product_groups`.`GroupID`
            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
                (`PromoStart` IS NOT NULL OR `PromoEnd` IS NOT NULL) AND
                (`PromoStart` IS NULL OR `PromoStart` <= NOW()) AND
                (`PromoEnd` IS NULL OR `PromoEnd` >= NOW()) AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC
# [13-Dec-2022 15:49:33] /unicat/root/bg/ajax/users/session.html?_=1670939377118 167.99.142.201

set names utf8

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