# [20-Sep-2023 11:24:52] /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
# [20-Sep-2023 11:24:52] /unicat/root/bg/ajax/prices.html?_=1695198292750 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
# [20-Sep-2023 11:25:02] /unicat/root/nRqioDzp/bg/ajax/users/form/login.html?_=1695198301991 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'error' AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [20-Sep-2023 11:25:06] /unicat/root/nRqioDzp/bg/ajax/users/login.html?_=1695198306104 167.99.142.201

set names utf8

SELECT `ID`, `UserKey` FROM `users` WHERE `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' LIMIT 1
# [20-Sep-2023 11:25:06] /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
# [20-Sep-2023 11:25:10] /unicat/root/nRqioDzp/bg/banners/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `banners`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:27:57] /unicat/root/nRqioDzp/bg/ajax/banners/form/1.html?_=1695198477189 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `banners`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:28:01] /unicat/root/nRqioDzp/bg/ajax/banners/upload/4671377751.html 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [20-Sep-2023 11:28:04] /unicat/root/nRqioDzp/bg/ajax/banners/upload/4671377751.html 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [20-Sep-2023 11:28:06] /unicat/root/nRqioDzp/bg/ajax/banners/upload/4671377751.html 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [20-Sep-2023 11:28:14] /unicat/root/nRqioDzp/bg/ajax/banners/update/1.html?_=1695198494150 167.99.142.201

set names utf8

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

SELECT * FROM `banners` LIMIT 1

SHOW COLUMNS FROM `banners`

UPDATE `banners` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2023-09-14', `LastUpdate` = '2023-09-20 11:28:14', `UploadID` = '4671377751', `StartFrom` = '2023-09-05', `EndTo` = '2023-09-28', `DatesAlignment` = '0', `ColorScheme` = '0', `Images` = '["banner_1180.jpg","banner_580.jpg","banner_380.jpg"]', `Title` = 'Списание 8 НА ЖИВО', `URL` = 'https://vimeo.com/820078631', `RefNumber` = '34563456', `Row` = '12', `PriceAlignment` = '0', `Visible` = 1, `Public` = 0 WHERE `ID` = '1' AND `Language` = 'bg'
# [20-Sep-2023 11:28:14] /unicat/root/nRqioDzp/bg/banners/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `banners`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:28:16] /unicat/root/nRqioDzp/bg/ajax/banners/form/1.html?_=1695198496046 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `banners`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:28:35] /unicat/root/nRqioDzp/bg/ajax/banners/form/1.html?_=1695198515452 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `banners`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:28:38] /unicat/root/nRqioDzp/bg/ajax/banners/update/1.html?_=1695198518464 167.99.142.201

set names utf8

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

SELECT * FROM `banners` LIMIT 1

SHOW COLUMNS FROM `banners`

UPDATE `banners` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2023-09-14', `LastUpdate` = '2023-09-20 11:28:38', `UploadID` = '4671377751', `StartFrom` = '2023-09-05', `EndTo` = '2023-09-28', `DatesAlignment` = '0', `ColorScheme` = '0', `Images` = '["banner_1180.jpg","banner_580.jpg","banner_380.jpg"]', `Title` = 'Списание 8 НА ЖИВО', `URL` = 'https://vimeo.com/820078631', `RefNumber` = '34563456', `Row` = '1', `PriceAlignment` = '0', `Visible` = 1, `Public` = 0 WHERE `ID` = '1' AND `Language` = 'bg'
# [20-Sep-2023 11:28:38] /unicat/root/nRqioDzp/bg/banners/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `banners`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:28:39] /unicat/root/nRqioDzp/bg/ajax/banners/form/2.html?_=1695198519567 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `banners`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:28:45] /unicat/root/nRqioDzp/bg/events/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:28:47] /unicat/root/nRqioDzp/bg/ajax/events/form/1.html?_=1695198527646 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:28:58] /unicat/root/nRqioDzp/bg/ajax/events/upload/4673790478.html 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [20-Sep-2023 11:29:09] /unicat/root/nRqioDzp/bg/ajax/events/update/1.html?_=1695198549438 167.99.142.201

set names utf8

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

SELECT * FROM `events` LIMIT 1

SHOW COLUMNS FROM `events`

UPDATE `events` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2023-09-14', `StartFrom` = '2023-09-01', `EndTo` = '2023-09-30', `LastUpdate` = '2023-09-20 11:29:09', `UploadID` = '4673790478', `MetaTitle` = 'ЗА НАС', `MetaDescription` = 'Мета описание', `MetaImage` = 'banner_1180.jpg', `NoIndex` = 0, `Title` = 'сфгхдфгхдфг', `URLLabel` = 'списание-8-на-живо', `Image` = 'untitled.png', `Content` = '<div>Z\\ASDFAS DFASF ASD<br><img src="/unicat/root/uf/events/4673790478/i_untitled1.png"></div>', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '1' AND `Language` IS NULL
# [20-Sep-2023 11:29:48] /unicat/root/nRqioDzp/bg/events/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:29:49] /unicat/root/nRqioDzp/bg/ajax/events/form/1.html?_=1695198589662 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:29:55] /unicat/root/nRqioDzp/bg/ajax/events/upload/4673790478.html 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [20-Sep-2023 11:29:57] /unicat/root/nRqioDzp/bg/ajax/events/update/1.html?_=1695198597774 167.99.142.201

set names utf8

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

SELECT * FROM `events` LIMIT 1

SHOW COLUMNS FROM `events`

UPDATE `events` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2023-09-14', `StartFrom` = '2023-09-01', `EndTo` = '2023-09-30', `LastUpdate` = '2023-09-20 11:29:57', `UploadID` = '4673790478', `MetaTitle` = 'ЗА НАС', `MetaDescription` = 'Мета описание', `MetaImage` = 'banner_11801.jpg', `NoIndex` = 0, `Title` = 'Списание 8 НА ЖИВО', `URLLabel` = 'списание-8-на-живо', `Image` = 'untitled.png', `Content` = '<div>Z\\ASDFAS DFASF ASD<br><img src="/unicat/root/uf/events/4673790478/i_untitled1.png"></div>', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [20-Sep-2023 11:29:57] /unicat/root/nRqioDzp/bg/events/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:29:59] /unicat/root/nRqioDzp/bg/ajax/events/form/1.html?_=1695198599734 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:30:03] /unicat/root/nRqioDzp/bg/ajax/events/visible/1.html?_=1695198603460 167.99.142.201

set names utf8

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

UPDATE
                    `events`
                SET
                    `Visible` = IF(`Visible` = 1, 0, 1)
                WHERE
                    `ID` = '1'
                LIMIT 1

SELECT
                    `Visible`
                FROM
                    `events`
                WHERE
                    `ID` = '1'
                LIMIT 1
# [20-Sep-2023 11:30:04] /unicat/root/nRqioDzp/bg/ajax/events/visible/1.html?_=1695198604924 167.99.142.201

set names utf8

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

UPDATE
                    `events`
                SET
                    `Visible` = IF(`Visible` = 1, 0, 1)
                WHERE
                    `ID` = '1'
                LIMIT 1

SELECT
                    `Visible`
                FROM
                    `events`
                WHERE
                    `ID` = '1'
                LIMIT 1
# [20-Sep-2023 11:30:07] /unicat/root/nRqioDzp/bg/ajax/events/form/1.html?_=1695198607596 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:31:13] /unicat/root/nRqioDzp/bg/events/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:31:19] /unicat/root/nRqioDzp/bg/ajax/events/visible/1.html?_=1695198679957 167.99.142.201

set names utf8

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

UPDATE
                    `events`
                SET
                    `Visible` = IF(`Visible` = 1, 0, 1)
                WHERE
                    `ID` = '1'
                LIMIT 1

SELECT
                    `Visible`
                FROM
                    `events`
                WHERE
                    `ID` = '1'
                LIMIT 1
# [20-Sep-2023 11:31:23] /unicat/root/nRqioDzp/bg/ajax/events/visible/1.html?_=1695198683484 167.99.142.201

set names utf8

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

UPDATE
                    `events`
                SET
                    `Visible` = IF(`Visible` = 1, 0, 1)
                WHERE
                    `ID` = '1'
                LIMIT 1

SELECT
                    `Visible`
                FROM
                    `events`
                WHERE
                    `ID` = '1'
                LIMIT 1
# [20-Sep-2023 11:35:57] /unicat/root/nRqioDzp/bg/events/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`,
                `StartFrom` > CURDATE() AS `Upcomming`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:35:59] /unicat/root/nRqioDzp/bg/ajax/events/form/1.html?_=1695198959973 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:36:06] /unicat/root/nRqioDzp/bg/ajax/events/update/1.html?_=1695198966174 167.99.142.201

set names utf8

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

SELECT * FROM `events` LIMIT 1

SHOW COLUMNS FROM `events`

UPDATE `events` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2023-09-14', `StartFrom` = '2023-09-28', `EndTo` = '2023-09-30', `LastUpdate` = '2023-09-20 11:36:06', `UploadID` = '4673790478', `MetaTitle` = 'ЗА НАС', `MetaDescription` = 'Мета описание', `MetaImage` = 'banner_11801.jpg', `NoIndex` = 0, `Title` = 'Списание 8 НА ЖИВО', `URLLabel` = 'списание-8-на-живо', `Image` = 'untitled.png', `Content` = '<div>Z\\ASDFAS DFASF ASD<br><img src="/unicat/root/uf/events/4673790478/i_untitled1.png"></div>', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [20-Sep-2023 11:36:06] /unicat/root/nRqioDzp/bg/events/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`,
                `StartFrom` > CURDATE() AS `Upcomming`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:36:21] /unicat/root/nRqioDzp/bg/ajax/events/form/1.html?_=1695198981176 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:36:31] /unicat/root/nRqioDzp/bg/ajax/events/update/1.html?_=1695198991757 167.99.142.201

set names utf8

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

SELECT * FROM `events` LIMIT 1

SHOW COLUMNS FROM `events`

UPDATE `events` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2023-09-14', `StartFrom` = '2023-09-01', `EndTo` = '2023-09-30', `LastUpdate` = '2023-09-20 11:36:31', `UploadID` = '4673790478', `MetaTitle` = 'ЗА НАС', `MetaDescription` = 'Мета описание', `MetaImage` = 'banner_11801.jpg', `NoIndex` = 0, `Title` = 'Списание 8 НА ЖИВО', `URLLabel` = 'списание-8-на-живо', `Image` = 'untitled.png', `Content` = '<div>Z\\ASDFAS DFASF ASD<br><img src="/unicat/root/uf/events/4673790478/i_untitled1.png"></div>', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [20-Sep-2023 11:36:31] /unicat/root/nRqioDzp/bg/events/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`,
                `StartFrom` > CURDATE() AS `Upcomming`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:38:11] /unicat/root/nRqioDzp/bg/ajax/events/form/1.html?_=1695199091694 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:38:19] /unicat/root/nRqioDzp/bg/ajax/events/update/1.html?_=1695199099573 167.99.142.201

set names utf8

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

SELECT * FROM `events` LIMIT 1

SHOW COLUMNS FROM `events`

UPDATE `events` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2023-09-14', `StartFrom` = '2023-09-01', `EndTo` = '2023-09-08', `LastUpdate` = '2023-09-20 11:38:19', `UploadID` = '4673790478', `MetaTitle` = 'ЗА НАС', `MetaDescription` = 'Мета описание', `MetaImage` = 'banner_11801.jpg', `NoIndex` = 0, `Title` = 'Списание 8 НА ЖИВО', `URLLabel` = 'списание-8-на-живо', `Image` = 'untitled.png', `Content` = '<div>Z\\ASDFAS DFASF ASD<br><img src="/unicat/root/uf/events/4673790478/i_untitled1.png"></div>', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [20-Sep-2023 11:38:19] /unicat/root/nRqioDzp/bg/events/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`,
                `StartFrom` > CURDATE() AS `Upcomming`,
                `EndTo` < CURDATE() AS `Expired`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:39:34] /unicat/root/nRqioDzp/bg/banners/list.html 167.99.142.201

set names utf8

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

SELECT
                *,
                `StartFrom` > CURDATE() AS `Upcomming`,
                `EndTo` < CURDATE() AS `Expired`
            FROM
                `banners`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:39:36] /unicat/root/nRqioDzp/bg/ajax/banners/form/2.html?_=1695199176108 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `banners`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:39:41] /unicat/root/nRqioDzp/bg/ajax/banners/update/2.html?_=1695199181005 167.99.142.201

set names utf8

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

SELECT * FROM `banners` LIMIT 1

SHOW COLUMNS FROM `banners`

UPDATE `banners` SET `ID` = '2', `Language` = 'bg', `PostDate` = '2023-09-15', `LastUpdate` = '2023-09-20 11:39:41', `UploadID` = '4768212838', `StartFrom` = '2023-09-06', `EndTo` = '2023-09-14', `DatesAlignment` = '1', `ColorScheme` = '1', `Images` = '["banner_11803.jpg","banner_5803.jpg","banner_3803.jpg"]', `Title` = 'Подаръци', `URL` = '', `RefNumber` = '34563456', `Row` = '1', `PriceAlignment` = '1', `Visible` = 1, `Public` = 1 WHERE `ID` = '2' AND `Language` = 'bg'
# [20-Sep-2023 11:39:41] /unicat/root/nRqioDzp/bg/banners/list.html 167.99.142.201

set names utf8

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

SELECT
                *,
                `StartFrom` > CURDATE() AS `Upcomming`,
                `EndTo` < CURDATE() AS `Expired`
            FROM
                `banners`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:39:44] /unicat/root/nRqioDzp/bg/ajax/banners/form/2.html?_=1695199184007 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `banners`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [20-Sep-2023 11:39:50] /unicat/root/nRqioDzp/bg/ajax/banners/update/2.html?_=1695199190774 167.99.142.201

set names utf8

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

SELECT * FROM `banners` LIMIT 1

SHOW COLUMNS FROM `banners`

UPDATE `banners` SET `ID` = '2', `Language` = 'bg', `PostDate` = '2023-09-15', `LastUpdate` = '2023-09-20 11:39:50', `UploadID` = '4768212838', `StartFrom` = '2023-09-06', `EndTo` = '2023-09-14', `DatesAlignment` = '1', `ColorScheme` = '1', `Images` = '["banner_11803.jpg","banner_5803.jpg","banner_3803.jpg"]', `Title` = 'Подаръци', `URL` = '', `RefNumber` = '34563456', `Row` = '1', `PriceAlignment` = '1', `Visible` = 1, `Public` = 1 WHERE `ID` = '2' AND `Language` = 'bg'
# [20-Sep-2023 11:39:50] /unicat/root/nRqioDzp/bg/banners/list.html 167.99.142.201

set names utf8

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

SELECT
                *,
                `StartFrom` > CURDATE() AS `Upcomming`,
                `EndTo` < CURDATE() AS `Expired`
            FROM
                `banners`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:40:08] /unicat/root/nRqioDzp/bg/banners/list.html 167.99.142.201

set names utf8

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

SELECT
                *,
                `StartFrom` > CURDATE() AS `Upcomming`,
                `EndTo` < CURDATE() AS `Expired`
            FROM
                `banners`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [20-Sep-2023 11:48:39] /unicat/root/ 167.99.142.201

set names utf8

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

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

SELECT
				`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
# [20-Sep-2023 11:48:39] /unicat/root/bg/ajax/users/session.html?_=1695199719813 167.99.142.201

set names utf8

SELECT
                            `UserKey`
                        FROM
                            `users`
                        WHERE
                            `ID` = 1462881436 AND
                            RIGHT(`UserKey`, 1) = 1
                        LIMIT 1
# [20-Sep-2023 11:48:39] /unicat/root/bg/ajax/prices.html?_=1695199719932 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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