# [22-May-2023 15:31:21] /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
				`products`.`ID`
			FROM
				`products`
				INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
				INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
				INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
			WHERE
				(`PromoStart` IS NOT NULL OR `PromoEnd` IS NOT NULL) AND
				(`PromoStart` IS NULL OR `PromoStart` <= NOW()) AND
				(`PromoEnd` IS NULL OR `PromoEnd` >= NOW()) AND
				`product_texts`.`Language` = 'bg' AND
				`products`.`Visible` = 1 AND
				`groups`.`Visible` = 1
			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
# [22-May-2023 15:31:21] /unicat/root/bg/ajax/prices.html?_=1684758684644 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

SELECT `RefNumber` FROM `products` WHERE `RefID` = 'power-brake-cleaner-500-ml' AND `Visible` = 1 LIMIT 1
# [22-May-2023 15:31:40] /unicat/root/nRqioDzp/bg/ajax/users/form/login.html?_=1684758703218 167.99.142.201

set names utf8

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

set names utf8

SELECT `ID`, `UserKey` FROM `users` WHERE `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' LIMIT 1
# [22-May-2023 15:31: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
# [22-May-2023 15:31:47] /unicat/root/nRqioDzp/bg/groups/list.html 167.99.142.201

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [22-May-2023 15:31:49] /unicat/root/nRqioDzp/bg/ajax/groups/form/2.html?_=1684758712833 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `groups`.`ID` = 2 AND
                `group_texts`.`Language` = 'bg'
            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
# [22-May-2023 15:34:16] /unicat/root/nRqioDzp/bg/groups/list.html 167.99.142.201

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [22-May-2023 15:53:10] /unicat/root/nRqioDzp/bg/groups/list.html?sort=01 167.99.142.201

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `groups`.`PostDate` DESC
# [22-May-2023 15:53:11] /unicat/root/nRqioDzp/bg/groups/list.html?sort=00 167.99.142.201

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `groups`.`PostDate` ASC
# [22-May-2023 15:53:13] /unicat/root/nRqioDzp/bg/groups/list.html?sort=01 167.99.142.201

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `groups`.`PostDate` DESC
