# [08-Dec-2022 14:57:01] /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
# [08-Dec-2022 14:59:11] /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
# [08-Dec-2022 14:59:13] /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
# [08-Dec-2022 15:00:53] /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
# [08-Dec-2022 15:01:44] /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
# [08-Dec-2022 15:01:47] /unicat/root/bg/ajax/prices.html?_=1670504514249 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
# [08-Dec-2022 15:01:47] /unicat/root/bg/ajax/prices.html?_=1670504514432 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'power-brake-cleaner-500-ml' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:02:06] /unicat/root/bg/groups/масла-и-греси.html 167.99.142.201

set names utf8

SELECT
                    `GroupID`
                FROM
                    `group_texts`
                WHERE
                    `URLLabel` = 'масла-и-греси' AND
                    `Language` = 'bg'
                LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 41
                        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 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` = 41 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC
# [08-Dec-2022 15:02:08] /unicat/root/bg/products/масла-и-греси/тежкотоварни-двигателни-масла.html 167.99.142.201

set names utf8

SELECT
                    `GT1`.`GroupID`
                FROM
                    `group_texts` AS `GT1`
                    INNER JOIN `groups` ON `groups`.`ID` = `GT1`.`GroupID`
                    INNER JOIN `group_texts` AS `GT2` ON `groups`.`ParentID` = `GT2`.`GroupID`
                WHERE
                    `GT1`.`URLLabel` = 'тежкотоварни-двигателни-масла' AND
                    `GT2`.`URLLabel` = 'масла-и-греси' AND
                    `GT1`.`Language` = 'bg' AND
                    `GT2`.`Language` = 'bg'
                LIMIT 1

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

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

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

SELECT
                `params`.`ID`
            FROM
                `product_groups`
                INNER JOIN `product_params` ON `product_groups`.`ProductID` = `product_params`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
            WHERE
                `product_groups`.`GroupID` = 43 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 1
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('][', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (1,2,3) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Params`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('-', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (4,5) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Ranges`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                
            WHERE
                `product_groups`.`GroupID` = 43 AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC

SET SESSION group_concat_max_len = 10240

SELECT
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`ID`,
                `params`.`UploadID`,
                `params`.`FilterType`,
                `params`.`ImgValues`,
                `params`.`Prefix`,
                `params`.`Code`,
                GROUP_CONCAT(DISTINCT `PPV`.`ParamValue` SEPARATOR '][') AS `Values`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_params` AS `PPV` ON `products`.`ID` = `PPV`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `PPV`.`ParamID`
                INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                
            WHERE
                `product_groups`.`GroupID` = 43 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC
# [08-Dec-2022 15:02:08] /unicat/root/bg/ajax/prices.html?_=1670504535375 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-15w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7630-ls-15w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-10w40-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7630-ls-fe-10w30-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9630-ls-ll-10w40-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-3030-15w40-4l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-15w40-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9540-ll-10w40-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7410-15w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9630-ls-ll-10w40-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9630-ls-ll-10w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9540-ll-10w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-1020-sae-30-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9660-ls-fe-ll-5w30-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9550-fe-ll-5w30-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-3030-15w40-1l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-10w40-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-1020-sae-10w-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-1020-sae-30-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-5w30-e6e9-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e7-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e7-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e7-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e6e9-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e6e9-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e6e9-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w30-e6e9-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w30-e6e9-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'dt-thpd-10w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'mixfleet-15w40-4l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'dt-uhpd-10w40-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'dt-uhpd-ms-10w40-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'dt-vhpd-ms-5w30-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-10w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-15w40-5l' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:08:07] /unicat/root/nRqioDzp/bg/ajax/users/form/login.html?_=1670504894001 167.99.142.201

set names utf8

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

set names utf8

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

set names utf8

SELECT `ID`, `UserKey` FROM `users` WHERE `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' LIMIT 1
# [08-Dec-2022 15:11:44] /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
# [08-Dec-2022 15:12:02] /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
# [08-Dec-2022 15:13:45] /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
# [08-Dec-2022 15:14:44] /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
# [08-Dec-2022 15:14:47] /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
# [08-Dec-2022 15:15:03] /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
# [08-Dec-2022 15:15:08] /unicat/root/nRqioDzp/bg/ajax/products/form/55.html?_=1670505315159 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` = 55 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` = 55

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` = 656
                        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` = 55 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [08-Dec-2022 15:19:24] /unicat/root/nRqioDzp/bg/ajax/products/form/55.html?_=1670505571450 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` = 55 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` = 55

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` = 656
                        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` = 55 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [08-Dec-2022 15:19:36] /unicat/root/nRqioDzp/bg/ajax/products/update/55.html?_=1670505583500 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-81221-64-obi'
         AND `ID` != 55 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '55', `PostDate` = '2074-01-01', `LastUpdate` = '2022-12-08 15:19:36', `UploadID` = '2022/03/07/6658916139', `RefNumber` = 'TPS 81221 6.4 OBI', `RefID` = 'tps-81221-64-obi', `ArtNumber` = '81221', `Brand` = 'TECNOPART', `Gallery` = '', `Selected` = 0, `Visible` = 1 WHERE `ID` = '55'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

UPDATE `product_texts` SET `ProductID` = '55', `Language` = 'bg', `Title` = 'КАБЕЛНО УХО СИНЬО TPS 81221 6.4 OBI (100 БРОЯ)', `URLLabel` = '81221tps', `Content` = 'КАБЕЛНО УХО СИНЬО TPS 81221 6.4 OBI (100 БРОЯ)' WHERE `ProductID` = '55' AND `Language` = 'bg'

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

INSERT INTO `product_groups` (`ProductID`, `GroupID`) VALUES 
	('55', '656');

DELETE FROM `product_params` WHERE `ProductID` = '55'
# [08-Dec-2022 15:19:36] /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
# [08-Dec-2022 15:19:42] /unicat/root/nRqioDzp/bg/ajax/products/form/2.html?_=1670505589850 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` = 2 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` = 2

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` = 2 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [08-Dec-2022 15:19:49] /unicat/root/nRqioDzp/bg/ajax/products/update/2.html?_=1670505596099 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-30521-5ax50box'
         AND `ID` != 2 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '2', `PostDate` = '2021-01-01', `LastUpdate` = '2022-12-08 15:19:49', `UploadID` = '2022/03/07/6658898565', `RefNumber` = 'TPS 30521 5Ax50BOX', `RefID` = 'tps-30521-5ax50box', `ArtNumber` = '30521', `Brand` = 'TECNOPART', `Gallery` = '["tps-30521-5ax50box_001.jpg","tps-30521-5ax50box_002.jpg"]', `Selected` = 0, `Visible` = 1 WHERE `ID` = '2'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

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

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

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

DELETE FROM `product_params` WHERE `ProductID` = '2'
# [08-Dec-2022 15:19:49] /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
# [08-Dec-2022 15:19:52] /unicat/root/nRqioDzp/bg/ajax/products/form/3.html?_=1670505599059 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` = 3 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` = 3

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` = 3 AND
                    `param_texts`.`Language` = 'bg'
                ORDER BY
                    `params`.`PostDate` DESC
# [08-Dec-2022 15:19:58] /unicat/root/nRqioDzp/bg/ajax/products/update/3.html?_=1670505605235 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-30541-75ax50box'
         AND `ID` != 3 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

UPDATE `products` SET `ID` = '3', `PostDate` = '2022-01-01', `LastUpdate` = '2022-12-08 15:19:58', `UploadID` = '2022/03/07/6658898822', `RefNumber` = 'TPS 30541 7.5Ax50BOX', `RefID` = 'tps-30541-75ax50box', `ArtNumber` = '30541', `Brand` = 'TECNOPART', `Gallery` = '["tps-30541-75ax50box_001.jpg","tps-30541-75ax50box_002.jpg"]', `Selected` = 0, `Visible` = 1 WHERE `ID` = '3'

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

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

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

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

DELETE FROM `product_params` WHERE `ProductID` = '3'
# [08-Dec-2022 15:19:58] /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
# [08-Dec-2022 15:20:01] /unicat/root/nRqioDzp/bg/ajax/products/form/5.html?_=1670505608355 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
# [08-Dec-2022 15:20:15] /unicat/root/nRqioDzp/bg/ajax/products/update/5.html?_=1670505622372 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-08 15:20:15', `UploadID` = '2022/03/07/6658899291', `PromoStartFrom` = '2022-12-06', `PromoEndTo` = '2022-12-15', `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'
# [08-Dec-2022 15:20:15] /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
# [08-Dec-2022 15:20:17] /unicat/root/nRqioDzp/bg/ajax/products/form/4.html?_=1670505624578 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
# [08-Dec-2022 15:21:26] /unicat/root/nRqioDzp/bg/ajax/products/form/4.html?_=1670505693231 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
# [08-Dec-2022 15:21:32] /unicat/root/nRqioDzp/bg/ajax/products/update/4.html?_=1670505699698 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-08 15:21:32', `UploadID` = '2022/03/07/6658899052', `PromoStartFrom` = '2022-12-06', `PromoEndTo` = '2022-12-23', `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'
# [08-Dec-2022 15:21:32] /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
# [08-Dec-2022 15:21:37] /unicat/root/nRqioDzp?sort=20 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`.`ArtNumber` 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`.`ArtNumber` ASC) AS CountTable
# [08-Dec-2022 15:21:38] /unicat/root/nRqioDzp?sort=30 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 `product_texts`.`Title` 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 `product_texts`.`Title` ASC) AS CountTable
# [08-Dec-2022 15:23:29] /unicat/root/nRqioDzp?sort=30 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 `product_texts`.`Title` 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 `product_texts`.`Title` ASC) AS CountTable
# [08-Dec-2022 15:23:31] /unicat/root/nRqioDzp?sort=30 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 `product_texts`.`Title` 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 `product_texts`.`Title` ASC) AS CountTable
# [08-Dec-2022 15:23:33] /unicat/root/nRqioDzp?sort=30 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 `product_texts`.`Title` 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 `product_texts`.`Title` ASC) AS CountTable
# [08-Dec-2022 15:24:28] /unicat/root/nRqioDzp?sort=30 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [08-Dec-2022 15:24:39] /unicat/root/nRqioDzp?sort=30 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 `product_texts`.`Title` 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 `product_texts`.`Title` ASC) AS CountTable
# [08-Dec-2022 15:24:41] /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`.`PromoStartFrom` 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`.`PromoStartFrom` ASC) AS CountTable
# [08-Dec-2022 15:24: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`.`PromoStartFrom` 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`.`PromoStartFrom` DESC) AS CountTable
# [08-Dec-2022 15:25:00] /unicat/root/nRqioDzp/bg/ajax/products/form/1.html?_=1670505907773 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
                    `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
# [08-Dec-2022 15:25:17] /unicat/root/nRqioDzp/bg/ajax/products/update/1.html?_=1670505924958 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-08 15:25:17', `UploadID` = '2022/03/07/6658898283', `PromoStartFrom` = NULL, `PromoEndTo` = '2022-12-30', `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'

DELETE FROM `product_params` WHERE `ProductID` = '1'
# [08-Dec-2022 15:25:24] /unicat/root/nRqioDzp/bg/ajax/products/form/1.html?_=1670505931380 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
                    `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
# [08-Dec-2022 15:25:30] /unicat/root/nRqioDzp/bg/ajax/products/update/1.html?_=1670505937902 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-08 15:25:30', `UploadID` = '2022/03/07/6658898283', `PromoStartFrom` = NULL, `PromoEndTo` = '2022-12-30', `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'
# [08-Dec-2022 15:25:31] /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`.`PromoStartFrom` 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`.`PromoStartFrom` DESC) AS CountTable
# [08-Dec-2022 15:25:34] /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`.`PromoStartFrom` 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`.`PromoStartFrom` ASC) AS CountTable
# [08-Dec-2022 15:25:35] /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`.`PromoStartFrom` 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`.`PromoStartFrom` DESC) AS CountTable
# [08-Dec-2022 15:25:43] /unicat/root/nRqioDzp/bg/ajax/products/form/18.html?_=1670505950765 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
# [08-Dec-2022 15:25:49] /unicat/root/nRqioDzp/bg/ajax/products/update/18.html?_=1670505956766 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-08 15:25:49', `UploadID` = '2022/03/07/6658904385', `PromoStartFrom` = NULL, `PromoEndTo` = '2022-12-31', `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'
# [08-Dec-2022 15:25:49] /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`.`PromoStartFrom` 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`.`PromoStartFrom` DESC) AS CountTable
# [08-Dec-2022 15:25:52] /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`.`PromoStartFrom` 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`.`PromoStartFrom` ASC) AS CountTable
# [08-Dec-2022 15:25:53] /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`.`PromoStartFrom` 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`.`PromoStartFrom` DESC) AS CountTable
# [08-Dec-2022 15:26:36] /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`.`PromoEndTo` 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`.`PromoEndTo` DESC) AS CountTable
# [08-Dec-2022 15:26:41] /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`.`PromoEndTo` 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`.`PromoEndTo` ASC) AS CountTable
# [08-Dec-2022 15:26: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`.`PromoEndTo` 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`.`PromoEndTo` DESC) AS CountTable
# [08-Dec-2022 15:37:45] /unicat/root/nRqioDzp/bg/ajax/users/logout.html?_=1670506672712 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [08-Dec-2022 15:37:45] /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
# [08-Dec-2022 15:37:45] /unicat/root/bg/ajax/prices.html?_=1670506672977 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
# [08-Dec-2022 15:37:47] /unicat/root/bg/groups/масла-и-греси.html 167.99.142.201

set names utf8

SELECT
                    `GroupID`
                FROM
                    `group_texts`
                WHERE
                    `URLLabel` = 'масла-и-греси' AND
                    `Language` = 'bg'
                LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 41
                        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 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` = 41 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC
# [08-Dec-2022 15:37:48] /unicat/root/bg/products/масла-и-греси/тежкотоварни-двигателни-масла.html 167.99.142.201

set names utf8

SELECT
                    `GT1`.`GroupID`
                FROM
                    `group_texts` AS `GT1`
                    INNER JOIN `groups` ON `groups`.`ID` = `GT1`.`GroupID`
                    INNER JOIN `group_texts` AS `GT2` ON `groups`.`ParentID` = `GT2`.`GroupID`
                WHERE
                    `GT1`.`URLLabel` = 'тежкотоварни-двигателни-масла' AND
                    `GT2`.`URLLabel` = 'масла-и-греси' AND
                    `GT1`.`Language` = 'bg' AND
                    `GT2`.`Language` = 'bg'
                LIMIT 1

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

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

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

SELECT
                `params`.`ID`
            FROM
                `product_groups`
                INNER JOIN `product_params` ON `product_groups`.`ProductID` = `product_params`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
            WHERE
                `product_groups`.`GroupID` = 43 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 1
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('][', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (1,2,3) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Params`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('-', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (4,5) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Ranges`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                
            WHERE
                `product_groups`.`GroupID` = 43 AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC

SET SESSION group_concat_max_len = 10240

SELECT
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`ID`,
                `params`.`UploadID`,
                `params`.`FilterType`,
                `params`.`ImgValues`,
                `params`.`Prefix`,
                `params`.`Code`,
                GROUP_CONCAT(DISTINCT `PPV`.`ParamValue` SEPARATOR '][') AS `Values`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_params` AS `PPV` ON `products`.`ID` = `PPV`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `PPV`.`ParamID`
                INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                
            WHERE
                `product_groups`.`GroupID` = 43 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC
# [08-Dec-2022 15:37:48] /unicat/root/bg/ajax/prices.html?_=1670506675909 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-15w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7630-ls-15w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-10w40-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7630-ls-fe-10w30-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9630-ls-ll-10w40-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-3030-15w40-4l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-15w40-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9540-ll-10w40-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7410-15w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9630-ls-ll-10w40-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9630-ls-ll-10w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9540-ll-10w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-1020-sae-30-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9660-ls-fe-ll-5w30-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-9550-fe-ll-5w30-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-3030-15w40-1l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-10w40-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-1020-sae-10w-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-1020-sae-30-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-5w30-e6e9-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e7-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e7-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e7-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e6e9-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e6e9-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w40-e6e9-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w30-e6e9-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'vecton-ld-10w30-e6e9-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'dt-thpd-10w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'mixfleet-15w40-4l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'dt-uhpd-10w40-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'dt-uhpd-ms-10w40-5l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'dt-vhpd-ms-5w30-208l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-10w40-20l' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'giant-7530-15w40-5l' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:38:05] /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
# [08-Dec-2022 15:38:05] /unicat/root/bg/ajax/prices.html?_=1670506692704 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
# [08-Dec-2022 15:38:06] /unicat/root/bg/products/промо.html 167.99.142.201

set names utf8

SELECT
                    `GroupID`
                FROM
                    `group_texts`
                WHERE
                    `URLLabel` = 'промо' AND
                    `Language` = 'bg'
                LIMIT 1

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

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

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

SELECT
                `params`.`ID`
            FROM
                `product_groups`
                INNER JOIN `product_params` ON `product_groups`.`ProductID` = `product_params`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 1
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('][', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (1,2,3) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Params`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('-', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (4,5) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Ranges`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC

SET SESSION group_concat_max_len = 10240

SELECT
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`ID`,
                `params`.`UploadID`,
                `params`.`FilterType`,
                `params`.`ImgValues`,
                `params`.`Prefix`,
                `params`.`Code`,
                GROUP_CONCAT(DISTINCT `PPV`.`ParamValue` SEPARATOR '][') AS `Values`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_params` AS `PPV` ON `products`.`ID` = `PPV`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `PPV`.`ParamID`
                INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC
# [08-Dec-2022 15:38:06] /unicat/root/bg/ajax/prices.html?_=1670506693627 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'impregnating-spray-400ml' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'e-evolution-dx2-5w30-5l' AND `Visible` = 1 LIMIT 1

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'os-ledinspect-headtorch250' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'os-battery-starter-cable-700a' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:38:15] /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
# [08-Dec-2022 15:38:15] /unicat/root/bg/ajax/prices.html?_=1670506702491 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
# [08-Dec-2022 15:44:08] /unicat/root/bg/promo.html 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
# [08-Dec-2022 15:44:08] /unicat/root/bg/ajax/prices.html?_=1670507055688 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
# [08-Dec-2022 15:44:11] /unicat/root/bg/ajax/prices.html?_=1670507058683 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'power-brake-cleaner-500-ml' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:44:34] /unicat/root/bg/promo.html 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
# [08-Dec-2022 15:46:14] /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`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`
            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
                (`PromoStartFrom` IS NOT NULL OR `PromoEndTo` IS NOT NULL) AND
                (`PromoStartFrom` IS NULL OR `PromoStartFrom` <= CURDATE()) AND
                (`PromoEndTo` IS NULL OR `PromoEndTo` >= CURDATE())
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC
# [08-Dec-2022 15:46:29] /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`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`
            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
                (`PromoStartFrom` IS NOT NULL OR `PromoEndTo` IS NOT NULL) AND
                (`PromoStartFrom` IS NULL OR `PromoStartFrom` <= CURDATE()) AND
                (`PromoEndTo` IS NULL OR `PromoEndTo` >= CURDATE()) AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC
# [08-Dec-2022 15:46:29] /unicat/root/bg/ajax/prices.html?_=1670507196527 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30561-10ax50box' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30851-20ax5maxi' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:46:49] /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`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`
            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
                (`PromoStartFrom` IS NOT NULL OR `PromoEndTo` IS NOT NULL) AND
                (`PromoStartFrom` IS NULL OR `PromoStartFrom` <= CURDATE()) AND
                (`PromoEndTo` IS NULL OR `PromoEndTo` >= CURDATE()) AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC
# [08-Dec-2022 15:46:49] /unicat/root/bg/ajax/prices.html?_=1670507216199 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30561-10ax50box' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30851-20ax5maxi' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:46:53] /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
# [08-Dec-2022 15:46:53] /unicat/root/bg/ajax/prices.html?_=1670507220188 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
# [08-Dec-2022 15:47:02] /unicat/root/bg/products/промо.html 167.99.142.201

set names utf8

SELECT
                    `GroupID`
                FROM
                    `group_texts`
                WHERE
                    `URLLabel` = 'промо' AND
                    `Language` = 'bg'
                LIMIT 1

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

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

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

SELECT
                `params`.`ID`
            FROM
                `product_groups`
                INNER JOIN `product_params` ON `product_groups`.`ProductID` = `product_params`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 1
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('][', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (1,2,3) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Params`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('-', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (4,5) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Ranges`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC

SET SESSION group_concat_max_len = 10240

SELECT
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`ID`,
                `params`.`UploadID`,
                `params`.`FilterType`,
                `params`.`ImgValues`,
                `params`.`Prefix`,
                `params`.`Code`,
                GROUP_CONCAT(DISTINCT `PPV`.`ParamValue` SEPARATOR '][') AS `Values`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_params` AS `PPV` ON `products`.`ID` = `PPV`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `PPV`.`ParamID`
                INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC
# [08-Dec-2022 15:47:02] /unicat/root/bg/ajax/prices.html?_=1670507229365 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'impregnating-spray-400ml' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'e-evolution-dx2-5w30-5l' AND `Visible` = 1 LIMIT 1

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'os-ledinspect-headtorch250' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'os-battery-starter-cable-700a' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:47:05] /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
# [08-Dec-2022 15:47:05] /unicat/root/bg/ajax/prices.html?_=1670507232652 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
# [08-Dec-2022 15:47:08] /unicat/root/bg/products/промо.html 167.99.142.201

set names utf8

SELECT
                    `GroupID`
                FROM
                    `group_texts`
                WHERE
                    `URLLabel` = 'промо' AND
                    `Language` = 'bg'
                LIMIT 1

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

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

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

SELECT
                `params`.`ID`
            FROM
                `product_groups`
                INNER JOIN `product_params` ON `product_groups`.`ProductID` = `product_params`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 1
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('][', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (1,2,3) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Params`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('-', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (4,5) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Ranges`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC

SET SESSION group_concat_max_len = 10240

SELECT
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`ID`,
                `params`.`UploadID`,
                `params`.`FilterType`,
                `params`.`ImgValues`,
                `params`.`Prefix`,
                `params`.`Code`,
                GROUP_CONCAT(DISTINCT `PPV`.`ParamValue` SEPARATOR '][') AS `Values`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_params` AS `PPV` ON `products`.`ID` = `PPV`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `PPV`.`ParamID`
                INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC
# [08-Dec-2022 15:47:08] /unicat/root/bg/ajax/prices.html?_=1670507235459 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'impregnating-spray-400ml' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'e-evolution-dx2-5w30-5l' AND `Visible` = 1 LIMIT 1

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'os-ledinspect-headtorch250' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'os-battery-starter-cable-700a' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:47:49] /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
# [08-Dec-2022 15:47:50] /unicat/root/bg/ajax/prices.html?_=1670507277800 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
# [08-Dec-2022 15:47:52] /unicat/root/bg/products/промо.html 167.99.142.201

set names utf8

SELECT
                    `GroupID`
                FROM
                    `group_texts`
                WHERE
                    `URLLabel` = 'промо' AND
                    `Language` = 'bg'
                LIMIT 1

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

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

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

SELECT
                `params`.`ID`
            FROM
                `product_groups`
                INNER JOIN `product_params` ON `product_groups`.`ProductID` = `product_params`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 1
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('][', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (1,2,3) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Params`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('-', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (4,5) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Ranges`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC

SET SESSION group_concat_max_len = 10240

SELECT
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`ID`,
                `params`.`UploadID`,
                `params`.`FilterType`,
                `params`.`ImgValues`,
                `params`.`Prefix`,
                `params`.`Code`,
                GROUP_CONCAT(DISTINCT `PPV`.`ParamValue` SEPARATOR '][') AS `Values`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_params` AS `PPV` ON `products`.`ID` = `PPV`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `PPV`.`ParamID`
                INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                
            WHERE
                `product_groups`.`GroupID` = 826 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC
# [08-Dec-2022 15:47:52] /unicat/root/bg/ajax/prices.html?_=1670507279914 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'impregnating-spray-400ml' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'e-evolution-dx2-5w30-5l' AND `Visible` = 1 LIMIT 1

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'os-ledinspect-headtorch250' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'os-battery-starter-cable-700a' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:47:58] /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
# [08-Dec-2022 15:48:02] /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`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`
            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
                (`PromoStartFrom` IS NOT NULL OR `PromoEndTo` IS NOT NULL) AND
                (`PromoStartFrom` IS NULL OR `PromoStartFrom` <= CURDATE()) AND
                (`PromoEndTo` IS NULL OR `PromoEndTo` >= CURDATE()) AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC
# [08-Dec-2022 15:48:03] /unicat/root/bg/ajax/prices.html?_=1670507290169 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30561-10ax50box' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30851-20ax5maxi' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:48:08] /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`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`
            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
                (`PromoStartFrom` IS NOT NULL OR `PromoEndTo` IS NOT NULL) AND
                (`PromoStartFrom` IS NULL OR `PromoStartFrom` <= CURDATE()) AND
                (`PromoEndTo` IS NULL OR `PromoEndTo` >= CURDATE()) AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC
# [08-Dec-2022 15:48:08] /unicat/root/bg/ajax/prices.html?_=1670507295451 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30561-10ax50box' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30851-20ax5maxi' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:56:37] /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
# [08-Dec-2022 15:56:41] /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`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`
            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
                (`PromoStartFrom` IS NOT NULL OR `PromoEndTo` IS NOT NULL) AND
                (`PromoStartFrom` IS NULL OR `PromoStartFrom` <= CURDATE()) AND
                (`PromoEndTo` IS NULL OR `PromoEndTo` >= CURDATE()) AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC
# [08-Dec-2022 15:56:41] /unicat/root/bg/ajax/prices.html?_=1670507808395 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30561-10ax50box' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30851-20ax5maxi' AND `Visible` = 1 LIMIT 1
# [08-Dec-2022 15:56:42] /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
# [08-Dec-2022 15:56:55] /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
# [08-Dec-2022 15:56:56] /unicat/root/bg/ajax/prices.html?_=1670507823075 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
# [08-Dec-2022 15:57:01] /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`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`
            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
                (`PromoStartFrom` IS NOT NULL OR `PromoEndTo` IS NOT NULL) AND
                (`PromoStartFrom` IS NULL OR `PromoStartFrom` <= CURDATE()) AND
                (`PromoEndTo` IS NULL OR `PromoEndTo` >= CURDATE()) AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC
# [08-Dec-2022 15:57:01] /unicat/root/bg/ajax/prices.html?_=1670507828862 167.99.142.201

set names utf8

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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30561-10ax50box' AND `Visible` = 1 LIMIT 1

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'tps-30851-20ax5maxi' AND `Visible` = 1 LIMIT 1
