# [11-Jan-2024 11:15:13] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:15:14] /techco/www/bg/ajax/cookies.html?_=1704964514003 167.99.142.201

set names utf8

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'terms' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:16:16] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704964576824 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'xSQ5c4IZ7GxzhB9b6dZ5f3yIpbXGuG32RjY62UV03ofjjd9bfQ8JDv375TL304Tp'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [11-Jan-2024 11:16:17] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704964577819 167.99.142.201

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = 'xSQ5c4IZ7GxzhB9b6dZ5f3yIpbXGuG32RjY62UV03ofjjd9bfQ8JDv375TL304Tp'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [11-Jan-2024 11:16:17] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 11:16:20] /techco/www/tNw2sPa4q/bg/ajax/pages/form/1.html?_=1704964580015 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [11-Jan-2024 11:16:33] /techco/www/tNw2sPa4q/bg/ajax/pages/update/1.html?_=1704964592992 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

UPDATE `pages` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2023-11-01', `LastUpdate` = '2024-01-11 11:16:33', `UploadID` = '2127403418', `MetaTitle` = 'Тех-ко Авточасти', `MetaDescription` = 'Тех-ко е водещ доставчик на резервни части и смазочни материали в сектора за след продажбено обслужване на автомобили в България.', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Начало', `FooterLabel` = '', `URLLabel` = 'index', `Annotation` = '', `Content` = '', `AddContent` = 'slides,news,suppliers,catalogs,newsletter', `AddOn` = '', `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [11-Jan-2024 11:16:33] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 11:16:36] /techco/www/tNw2sPa4q/bg/ajax/pages/form/1.html?_=1704964596742 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [11-Jan-2024 11:16:46] /techco/www/tNw2sPa4q/bg/ajax/users/logout.html?_=1704964606366 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:16:46] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:16:49] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:19:06] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:19:07] /techco/www/bg/ajax/newsletter/form/home.html?_=1704964747380 167.99.142.201

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubscribe','LEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:20:34] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:20:35] /techco/www/bg/ajax/newsletter/form/home.html?_=1704964835120 167.99.142.201

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubscribe','LEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:21:01] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:22:59] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:22:59] /techco/www/bg/ajax/newsletter/form/home.html?_=1704964979757 167.99.142.201

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubscribe','LEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:23:06] /techco/www/bg/ajax/newsletter/form/subscribe.html?_=1704964986086 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LCompanyName','LSubscribe') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'terms'
             AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:23:40] /techco/www/bg/ajax/newsletter/form/subscribe.html?_=1704965020199 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LCompanyName','LSubscribe') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'terms'
             AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:23:42] /techco/www/bg/ajax/newsletter/form/subscribe.html?_=1704965022909 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LCompanyName','LSubscribe') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'terms'
             AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:24:41] /techco/www/bg/ajax/newsletter/form/subscribe.html?_=1704965081591 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LCompanyName','LSubscribe') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'terms'
             AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:30:55] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:30:56] /techco/www/bg/ajax/newsletter/form/home.html?_=1704965456310 167.99.142.201

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubscribe','LEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:31:06] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:31:06] /techco/www/bg/ajax/newsletter/form/home.html?_=1704965466509 167.99.142.201

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubscribe','LEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:31:13] /techco/www/bg/ajax/newsletter/form/subscribe.html?_=1704965473485 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LCompanyName','LSubscribe') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'terms'
             AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:31:58] /techco/www/bg/контакти.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'контакти' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHome') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT `MenuLabel`, `FooterLabel`, `URLLabel` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'contacts' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'contacts' AND
	    		`URLLabel` = 'контакти'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'контакти' AND
                P1.`Visible` = 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'контакти'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'контакти'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:31:59] /techco/www/bg/ajax/contacts/form.html?_=1704965519381 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorMessage','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'terms'
             AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:32:48] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:32:49] /techco/www/bg/ajax/newsletter/form/home.html?_=1704965569552 167.99.142.201

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubscribe','LEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:32:53] /techco/www/bg/ajax/newsletter/form/subscribe.html?_=1704965573316 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LCompanyName','LSubscribe') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'terms'
             AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:33:01] /techco/www/bg/ajax/newsletter/subscribe.html?_=1704965581045 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) FROM `newsletter_unsubscribed` WHERE `ID` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e' LIMIT 1

SELECT COUNT(*) FROM `newsletter_subscribers` WHERE `ID` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e' LIMIT 1

SELECT * FROM `newsletter_subscribers` LIMIT 1

SHOW COLUMNS FROM `newsletter_subscribers`

INSERT INTO `newsletter_subscribers` SET `ID` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e', `Language` = 'bg', `PostDate` = '2024-01-11', `LastUpdate` = '2024-01-11 11:33:01', `Data` = 'ubyTVPfpPNBpfpNWvGJ68kFFUGqyzo2X-ge_-yKn2dXBmYIb2uyKAt_N0BcHpefixMRLYg_dwCAjqbCL-bF82fzY8YkONn8iRS3eS3Gmaripdl3GYeOm5kUdwZTpBjJJLfJn0e62ygq3_0sIVXNOYoxjti7rRG9J6HC6haXSy1BCTtWdoByqJzM66t9BG-LcFwY5vphwzj84KRipbdu7ijrTMCeTw4RjfU6P7cSZIhE', `SearchKey` = 'aHJpc3RvZGF2YXJha2kbWF4Z3JhcGhpYwZW9vZAZGF2YXJza2kZ21haWwY29t'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNewsletter') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:33:02] /techco/www/bg/newsletter/success.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'newsletter' AND
	    		`URLLabel` = 'success'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'success' AND
                P1.`Visible` = 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'newsletter'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'newsletter'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:41:38] /techco/www/bg/newsletter/confirm/ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e.html 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'newsletter'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'newsletter'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:41:39] /techco/www/bg/ajax/cookies.html?_=1704966099083 167.99.142.201

set names utf8

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'terms' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:45:05] /techco/www/bg/newsletter/confirm/ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e.html 167.99.142.201

set names utf8

UPDATE `newsletter_subscribers` SET `Confirmed` = 1 WHERE `ID` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e' LIMIT 1;
# [11-Jan-2024 11:45:05] /techco/www/bg/newsletter/confirmed.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'newsletter' AND
	    		`URLLabel` = 'confirmed'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'confirmed' AND
                P1.`Visible` = 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'newsletter'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'newsletter'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:45:05] /techco/www/bg/ajax/cookies.html?_=1704966305788 167.99.142.201

set names utf8

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'terms' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 11:45:46] /techco/www/tNw2sPa4q/ 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:45:47] /techco/www/tNw2sPa4q/bg/ajax/users/form/login.html?_=1704966347168 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:45:51] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704966351251 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '6aN3h1WE1b56G1LyNTmt8ma0cp0EJ9652X25Q4cFWtOYjJbGv3q83X3RseUv0ALY'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [11-Jan-2024 11:45:52] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704966352225 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '6aN3h1WE1b56G1LyNTmt8ma0cp0EJ9652X25Q4cFWtOYjJbGv3q83X3RseUv0ALY'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [11-Jan-2024 11:45:52] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 11:47:37] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 11:47:40] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30
# [11-Jan-2024 11:47:43] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30
# [11-Jan-2024 11:49:05] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30
# [11-Jan-2024 11:49:14] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'newsletter'
	    	WHERE
                P1.`Language` = 'bg'
         LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'newsletter'
	    	WHERE
                P1.`Language` = 'en'
         LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 11:50:06] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:50:50] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:52:07] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:52:44] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:53:55] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:54:23] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:54:31] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:54:42] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:55:00] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:55:31] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:55:48] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:56:33] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 11:58:13] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_subscribers`.`Confirmed`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_subscribers`.`Confirmed`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC) AS CountTable
# [11-Jan-2024 11:58:16] /techco/www/tNw2sPa4q/bg/newsletter/unsubscribed.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate` AS `RegDate`,
                `newsletter_unsubscribed`.`PostDate` AS `UnsubDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_unsubscribed`.`Reason`
            FROM
                `newsletter_subscribers`
                INNER JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC LIMIT 0, 30
# [11-Jan-2024 12:01:56] /techco/www/tNw2sPa4q/bg/newsletter/unsubscribed.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate` AS `RegDate`,
                `newsletter_unsubscribed`.`PostDate` AS `UnsubDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_unsubscribed`.`Reason`
            FROM
                `newsletter_subscribers`
                INNER JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC LIMIT 0, 30
# [11-Jan-2024 12:01:59] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_subscribers`.`Confirmed`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_subscribers`.`Confirmed`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC) AS CountTable
# [11-Jan-2024 12:03:05] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_subscribers`.`Confirmed`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_subscribers`.`Confirmed`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC) AS CountTable
# [11-Jan-2024 12:03:11] /techco/www/tNw2sPa4q/bg/ajax/newsletter/unsubscribe/ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e.html?_=1704967391623 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `Data`
            FROM
                `newsletter_subscribers`
            WHERE
                `ID` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e' AND
                `Language` = 'bg'
            LIMIT 1

SELECT * FROM `newsletter_unsubscribed` LIMIT 1

SHOW COLUMNS FROM `newsletter_unsubscribed`

REPLACE INTO `newsletter_unsubscribed` SET `ID` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e', `PostDate` = '2024-01-11 12:03:11', `Reason` = 1
# [11-Jan-2024 12:03:11] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_subscribers`.`Confirmed`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC LIMIT 0, 30
# [11-Jan-2024 12:03:13] /techco/www/tNw2sPa4q/bg/newsletter/unsubscribed.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate` AS `RegDate`,
                `newsletter_unsubscribed`.`PostDate` AS `UnsubDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_unsubscribed`.`Reason`
            FROM
                `newsletter_subscribers`
                INNER JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate` AS `RegDate`,
                `newsletter_unsubscribed`.`PostDate` AS `UnsubDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_unsubscribed`.`Reason`
            FROM
                `newsletter_subscribers`
                INNER JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC) AS CountTable
# [11-Jan-2024 12:03:55] /techco/www/tNw2sPa4q/bg/ajax/newsletter/restore/ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e.html?_=1704967435557 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

DELETE FROM `newsletter_unsubscribed` WHERE `ID` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e'
# [11-Jan-2024 12:03:55] /techco/www/tNw2sPa4q/bg/newsletter/unsubscribed.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate` AS `RegDate`,
                `newsletter_unsubscribed`.`PostDate` AS `UnsubDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_unsubscribed`.`Reason`
            FROM
                `newsletter_subscribers`
                INNER JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC LIMIT 0, 30
# [11-Jan-2024 12:03:57] /techco/www/tNw2sPa4q/bg/newsletter/subscribers.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_subscribers`.`Confirmed`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `newsletter_subscribers`.`ID`,
                `newsletter_subscribers`.`Language`,
                `newsletter_subscribers`.`PostDate`,
                `newsletter_subscribers`.`Data`,
                `newsletter_subscribers`.`Confirmed`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg'
         ORDER BY `newsletter_subscribers`.`PostDate` DESC) AS CountTable
# [11-Jan-2024 12:04:00] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30
# [11-Jan-2024 12:04:02] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form.html?_=1704967442113 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 12:04:40] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form.html?_=1704967480376 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 12:04:46] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 12:04:47] /techco/www/tNw2sPa4q/bg/ajax/pages/form/1.html?_=1704967487242 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [11-Jan-2024 12:14:46] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 12:15:07] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 12:16:33] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 12:16:36] /techco/www/tNw2sPa4q/tNw2sPa4q/bg/groups/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'users'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'users'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 12:16:57] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 12:17:01] /techco/www/tNw2sPa4q/bg/groups/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 12:17:45] /techco/www/tNw2sPa4q/bg/groups/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            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
# [11-Jan-2024 12:19:08] /techco/www/tNw2sPa4q/bg/groups/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            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
# [11-Jan-2024 12:27:00] /techco/www/tNw2sPa4q/bg/groups/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 12:27:45] /techco/www/tNw2sPa4q/bg/groups/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            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
# [11-Jan-2024 12:27:50] /techco/www/tNw2sPa4q/bg/ajax/groups/form.html?_=1704968870102 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 12:27:57] /techco/www/tNw2sPa4q/bg/groups/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            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
# [11-Jan-2024 12:28:59] /techco/www/tNw2sPa4q/bg/groups/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            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
# [11-Jan-2024 12:29:03] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30
# [11-Jan-2024 12:30:04] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30
# [11-Jan-2024 12:30:07] /techco/www/tNw2sPa4q/bg/labels/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `LabelsBG`.`Label`,
                `LabelsBG`.`Value` AS `LabelsBGValue`,
                `LabelsEN`.`Value` AS `LabelsENValue`
            FROM
                `labels` AS `LabelsBG`
                LEFT JOIN `labels` AS `LabelsEN` ON `LabelsEN`.`Language` = 'en' AND `LabelsEN`.`Label` = `LabelsBG`.`Label`
            WHERE
                `LabelsBG`.`Language` = 'bg'
         ORDER BY `LabelsBG`.`Label` ASC
# [11-Jan-2024 12:30:39] /techco/www/tNw2sPa4q/bg/labels/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `LabelsBG`.`Label`,
                `LabelsBG`.`Value` AS `LabelsBGValue`,
                `LabelsEN`.`Value` AS `LabelsENValue`
            FROM
                `labels` AS `LabelsBG`
                LEFT JOIN `labels` AS `LabelsEN` ON `LabelsEN`.`Language` = 'en' AND `LabelsEN`.`Label` = `LabelsBG`.`Label`
            WHERE
                `LabelsBG`.`Language` = 'bg'
         ORDER BY `LabelsBG`.`Label` ASC
# [11-Jan-2024 12:31:15] /techco/www/tNw2sPa4q/bg/labels/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `LabelsBG`.`Label`,
                `LabelsBG`.`Value` AS `LabelsBGValue`,
                `LabelsEN`.`Value` AS `LabelsENValue`
            FROM
                `labels` AS `LabelsBG`
                LEFT JOIN `labels` AS `LabelsEN` ON `LabelsEN`.`Language` = 'en' AND `LabelsEN`.`Label` = `LabelsBG`.`Label`
            WHERE
                `LabelsBG`.`Language` = 'bg'
         ORDER BY `LabelsBG`.`Label` ASC
# [11-Jan-2024 12:31:31] /techco/www/tNw2sPa4q/bg/labels/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `LabelsBG`.`Label`,
                `LabelsBG`.`Value` AS `LabelsBGValue`,
                `LabelsEN`.`Value` AS `LabelsENValue`
            FROM
                `labels` AS `LabelsBG`
                LEFT JOIN `labels` AS `LabelsEN` ON `LabelsEN`.`Language` = 'en' AND `LabelsEN`.`Label` = `LabelsBG`.`Label`
            WHERE
                `LabelsBG`.`Language` = 'bg'
         ORDER BY `LabelsBG`.`Label` ASC
# [11-Jan-2024 12:35:06] /techco/www/tNw2sPa4q/bg/ajax/labels/form.html?label=Apr&_=1704969306390 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                LabelsBG.`Label`,
                LabelsBG.`Value` AS `ValueBG`,
                LabelsEN.`Value` AS `ValueEN`
            FROM
                `labels` AS LabelsBG
                LEFT JOIN `labels` AS LabelsEN ON LabelsEN.`Language` = 'en' AND LabelsEN.`Label` = LabelsBG.`Label`
            WHERE
                LabelsBG.`Language` = 'bg' AND
                LabelsBG.`Label` = 'Apr'
            LIMIT 1
# [11-Jan-2024 12:35:12] /techco/www/tNw2sPa4q/bg/ajax/labels/update.html?_=1704969312815 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT * FROM `labels` LIMIT 1

SHOW COLUMNS FROM `labels`

REPLACE INTO `labels` SET `Label` = 'Apr', `Language` = 'bg', `Value` = 'Апр'

SELECT * FROM `labels` LIMIT 1

SHOW COLUMNS FROM `labels`

REPLACE INTO `labels` SET `Label` = 'Apr', `Language` = 'en', `Value` = 'Apr'
# [11-Jan-2024 12:35:13] /techco/www/tNw2sPa4q/bg/labels/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `LabelsBG`.`Label`,
                `LabelsBG`.`Value` AS `LabelsBGValue`,
                `LabelsEN`.`Value` AS `LabelsENValue`
            FROM
                `labels` AS `LabelsBG`
                LEFT JOIN `labels` AS `LabelsEN` ON `LabelsEN`.`Language` = 'en' AND `LabelsEN`.`Label` = `LabelsBG`.`Label`
            WHERE
                `LabelsBG`.`Language` = 'bg'
         ORDER BY `LabelsBG`.`Label` ASC
# [11-Jan-2024 12:35:14] /techco/www/tNw2sPa4q/bg/ajax/labels/form.html?label=Apr&_=1704969314734 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                LabelsBG.`Label`,
                LabelsBG.`Value` AS `ValueBG`,
                LabelsEN.`Value` AS `ValueEN`
            FROM
                `labels` AS LabelsBG
                LEFT JOIN `labels` AS LabelsEN ON LabelsEN.`Language` = 'en' AND LabelsEN.`Label` = LabelsBG.`Label`
            WHERE
                LabelsBG.`Language` = 'bg' AND
                LabelsBG.`Label` = 'Apr'
            LIMIT 1
# [11-Jan-2024 12:35:17] /techco/www/tNw2sPa4q/bg/ajax/labels/update.html?_=1704969317559 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT * FROM `labels` LIMIT 1

SHOW COLUMNS FROM `labels`

REPLACE INTO `labels` SET `Label` = 'Apr', `Language` = 'bg', `Value` = 'Апр'

DELETE FROM `labels` WHERE `Label` = 'Apr' AND `Language` = 'en'
# [11-Jan-2024 12:35:17] /techco/www/tNw2sPa4q/bg/labels/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `LabelsBG`.`Label`,
                `LabelsBG`.`Value` AS `LabelsBGValue`,
                `LabelsEN`.`Value` AS `LabelsENValue`
            FROM
                `labels` AS `LabelsBG`
                LEFT JOIN `labels` AS `LabelsEN` ON `LabelsEN`.`Language` = 'en' AND `LabelsEN`.`Label` = `LabelsBG`.`Label`
            WHERE
                `LabelsBG`.`Language` = 'bg'
         ORDER BY `LabelsBG`.`Label` ASC
# [11-Jan-2024 14:16:51] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 14:16:52] /techco/www/bg/ajax/newsletter/form/home.html?_=1704975412211 167.99.142.201

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubscribe','LEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 14:16:53] /techco/www/tNw2sPa4q/ 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:16:54] /techco/www/tNw2sPa4q/bg/ajax/users/form/login.html?_=1704975413785 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:16:58] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704975418252 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'C9djjcb791rjjn0d37u6wezUha3FymZsKY4E4b2J5i8LNjOVFJnhI8sSk4DGwQU5'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [11-Jan-2024 14:16:59] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704975419331 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = 'C9djjcb791rjjn0d37u6wezUha3FymZsKY4E4b2J5i8LNjOVFJnhI8sSk4DGwQU5'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [11-Jan-2024 14:16:59] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 14:17:02] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30
# [11-Jan-2024 14:17:05] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form.html?_=1704975424519 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:17:12] /techco/www/tNw2sPa4q/bg/ajax/newsletter/upload/4975425074.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:17:16] /techco/www/tNw2sPa4q/bg/ajax/newsletter/urllabel.html?URLLabel=dGVzdA&_=1704975435722 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                        COUNT(*)
                    FROM
                        `newsletter`
                    WHERE
                        `URLLabel` = 'test'
# [11-Jan-2024 14:17:16] /techco/www/tNw2sPa4q/bg/ajax/newsletter/urllabel.html?URLLabel=dGVzdA&_=1704975436336 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                        COUNT(*)
                    FROM
                        `newsletter`
                    WHERE
                        `URLLabel` = 'test'
# [11-Jan-2024 14:17:31] /techco/www/tNw2sPa4q/bg/ajax/newsletter/upload/4975425074.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:17:51] /techco/www/tNw2sPa4q/bg/ajax/newsletter/insert.html?_=1704975470591 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT MAX(`ID`) + 1 FROM `newsletter`

SELECT * FROM `newsletter` LIMIT 1

SHOW COLUMNS FROM `newsletter`

INSERT INTO `newsletter` SET `ID` = 1, `Language` = 'bg', `PostDate` = '2024-01-11', `LastUpdate` = '2024-01-11 14:17:51', `UploadID` = '4975425074', `MetaTitle` = 'test', `MetaDescription` = 'test', `MetaImage` = 'teslax.jpg', `NoIndex` = 0, `Title` = 'test', `URLLabel` = 'test', `Content` = '<h1>test</h1><div>sdfasd fasd fasdfasdfasdf <a href="https://maxgraphic.bg">asdf</a></div><div><img src="/techco/www/uf/newsletter/4975425074/i_teslax1.jpg"></div>', `Visible` = 1
# [11-Jan-2024 14:17:51] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [11-Jan-2024 14:17:53] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:18:21] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:18:23] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:19:27] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:19:44] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:19:53] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:22:33] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:27:22] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:27:23] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:27:36] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [11-Jan-2024 14:27:37] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [11-Jan-2024 14:27:53] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:28:47] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:28:55] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:29:02] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 14:29:03] /techco/www/bg/ajax/newsletter/form/home.html?_=1704976142442 167.99.142.201

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubscribe','LEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 14:30:02] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:30:14] /techco/www/tNw2sPa4q/ 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:30:14] /techco/www/tNw2sPa4q/bg/ajax/users/form/login.html?_=1704976214065 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:30:18] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704976217975 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'fO1WWQVyT0L4oXVzE7NcQR53o8JTPqfwA7wqkQxAkq96k66bd3B75PERza3BQA2L'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [11-Jan-2024 14:30:19] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704976219031 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = 'fO1WWQVyT0L4oXVzE7NcQR53o8JTPqfwA7wqkQxAkq96k66bd3B75PERza3BQA2L'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [11-Jan-2024 14:30:19] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 14:30:26] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [11-Jan-2024 14:30:29] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:30:38] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [11-Jan-2024 14:32:59] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 14:33:13] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 14:33:26] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 14:33:28] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 14:33:38] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 14:49:51] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 14:54:30] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [11-Jan-2024 14:55:12] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 14:56:23] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 15:02:46] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 15:03:22] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 15:04:07] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 15:04:24] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 15:04:43] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1704978282812 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [11-Jan-2024 15:04:46] /techco/www/tNw2sPa4q/bg/ajax/newsletter/addsend/1.html?_=1704978285841 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT * FROM `newsletter_send` LIMIT 1

SHOW COLUMNS FROM `newsletter_send`

INSERT INTO `newsletter_send` SET `Language` = 'bg', `NewsletterID` = '1', `PostDate` = '2024-01-11 15:04:46', `Subject` = 'test', `Content` = '<h1>test</h1><div>sdfasd fasd fasdfasdfasdf <a href="https://maxgraphic.bg">asdf</a></div><div><img src="/techco/www/uf/newsletter/4975425074/i_teslax1.jpg"></div>'

SELECT
                `newsletter_subscribers`.`ID` AS `UserKey`,
                `newsletter_subscribers`.`Data`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1

SELECT * FROM `newsletter_users` LIMIT 1

SHOW COLUMNS FROM `newsletter_users`

REPLACE INTO `newsletter_users` SET `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e', `Data` = 'ubyTVPfpPNBpfpNWvGJ68kFFUGqyzo2X-ge_-yKn2dXBmYIb2uyKAt_N0BcHpefixMRLYg_dwCAjqbCL-bF82fzY8YkONn8iRS3eS3Gmaripdl3GYeOm5kUdwZTpBjJJLfJn0e62ygq3_0sIVXNOYoxjti7rRG9J6HC6haXSy1BCTtWdoByqJzM66t9BG-LcFwY5vphwzj84KRipbdu7ijrTMCeTw4RjfU6P7cSZIhE', `SendID` = 1, `SendKey` = 'a940c1fba237d1774c5fc78d8fac94f3'

SELECT COUNT(*) FROM `newsletter_users` WHERE `SendID` = 1

SELECT COUNT(*) FROM `newsletter_users` WHERE `SendID` = 1 AND `Sent` = 1
# [11-Jan-2024 15:04:46] /techco/www/tNw2sPa4q/bg/ajax/newsletter/send/a940c1fba237d1774c5fc78d8fac94f3/1.html?_=1704978285890 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_send`.`Subject`,
                `newsletter_send`.`Content`,
                `newsletter_users`.`UserKey`,
                `newsletter_users`.`Data`,
                `newsletter`.`URLLabel`
            FROM
                `newsletter_users`
                INNER JOIN `newsletter_send` ON `newsletter_send`.`ID` = `newsletter_users`.`SendID`
                INNER JOIN `newsletter` ON
                    `newsletter_send`.`NewsletterID` = `newsletter`.`ID` AND
                    `newsletter_send`.`Language` = `newsletter`.`Language`
            WHERE
                `newsletter_users`.`Sent` = 0 AND
                `newsletter_users`.`SendKey` = 'a940c1fba237d1774c5fc78d8fac94f3' AND
                `newsletter_send`.`ID` = 1 AND
                `newsletter_send`.`Language` = 'bg'
            LIMIT 1

UPDATE
                    `newsletter_users`
                SET
                    `SendKey` = ''
                WHERE
                    `SendID` = 1 AND
                    `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e'
                LIMIT 1

UPDATE
                `newsletter_users`
            SET
                `Sent` = 1
            WHERE
                `SendID` = 1 AND
                `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e'
            LIMIT 1
# [11-Jan-2024 15:05:15] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 15:05:18] /techco/www/tNw2sPa4q/bg/newsletter/log/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT `PostDate`, `Subject` FROM `newsletter_send` WHERE `ID` = 1 LIMIT 1

SELECT
                `Data`,
                `Sent`,
                `Opened`,
                `Links`,
                `SendKey`
            FROM
                `newsletter_users`
            WHERE
                `SendID` = 1
         LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `Data`,
                `Sent`,
                `Opened`,
                `Links`,
                `SendKey`
            FROM
                `newsletter_users`
            WHERE
                `SendID` = 1
        ) AS CountTable
# [11-Jan-2024 15:06:11] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 15:06:12] /techco/www/bg/ajax/newsletter/form/home.html?_=1704978371741 167.99.142.201

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubscribe','LEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 15:07:22] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 15:07:44] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 15:07:47] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 15:07:48] /techco/www/bg/ajax/newsletter/form/home.html?_=1704978467458 167.99.142.201

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubscribe','LEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 15:08:42] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1704978521472 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [11-Jan-2024 15:08:43] /techco/www/tNw2sPa4q/bg/ajax/newsletter/addsend/1.html?_=1704978523321 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT * FROM `newsletter_send` LIMIT 1

SHOW COLUMNS FROM `newsletter_send`

INSERT INTO `newsletter_send` SET `Language` = 'bg', `NewsletterID` = '1', `PostDate` = '2024-01-11 15:08:43', `Subject` = 'test', `Content` = '<h1>test</h1><div>sdfasd fasd fasdfasdfasdf <a href="https://maxgraphic.bg">asdf</a></div><div><img src="/techco/www/uf/newsletter/4975425074/i_teslax1.jpg"></div>'

SELECT
                `newsletter_subscribers`.`ID` AS `UserKey`,
                `newsletter_subscribers`.`Data`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1

SELECT * FROM `newsletter_users` LIMIT 1

SHOW COLUMNS FROM `newsletter_users`

REPLACE INTO `newsletter_users` SET `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e', `Data` = 'ubyTVPfpPNBpfpNWvGJ68kFFUGqyzo2X-ge_-yKn2dXBmYIb2uyKAt_N0BcHpefixMRLYg_dwCAjqbCL-bF82fzY8YkONn8iRS3eS3Gmaripdl3GYeOm5kUdwZTpBjJJLfJn0e62ygq3_0sIVXNOYoxjti7rRG9J6HC6haXSy1BCTtWdoByqJzM66t9BG-LcFwY5vphwzj84KRipbdu7ijrTMCeTw4RjfU6P7cSZIhE', `SendID` = 2, `SendKey` = '0f1df324c000d7df16865f719775b5ac'

SELECT COUNT(*) FROM `newsletter_users` WHERE `SendID` = 2

SELECT COUNT(*) FROM `newsletter_users` WHERE `SendID` = 2 AND `Sent` = 1
# [11-Jan-2024 15:08:43] /techco/www/tNw2sPa4q/bg/ajax/newsletter/send/0f1df324c000d7df16865f719775b5ac/2.html?_=1704978523384 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_send`.`Subject`,
                `newsletter_send`.`Content`,
                `newsletter_users`.`UserKey`,
                `newsletter_users`.`Data`,
                `newsletter`.`URLLabel`
            FROM
                `newsletter_users`
                INNER JOIN `newsletter_send` ON `newsletter_send`.`ID` = `newsletter_users`.`SendID`
                INNER JOIN `newsletter` ON
                    `newsletter_send`.`NewsletterID` = `newsletter`.`ID` AND
                    `newsletter_send`.`Language` = `newsletter`.`Language`
            WHERE
                `newsletter_users`.`Sent` = 0 AND
                `newsletter_users`.`SendKey` = '0f1df324c000d7df16865f719775b5ac' AND
                `newsletter_send`.`ID` = 2 AND
                `newsletter_send`.`Language` = 'bg'
            LIMIT 1

UPDATE
                    `newsletter_users`
                SET
                    `SendKey` = ''
                WHERE
                    `SendID` = 2 AND
                    `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e'
                LIMIT 1

UPDATE
                `newsletter_users`
            SET
                `Sent` = 1
            WHERE
                `SendID` = 2 AND
                `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e'
            LIMIT 1
# [11-Jan-2024 15:11:22] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 15:11:24] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1704978683498 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [11-Jan-2024 15:11:26] /techco/www/tNw2sPa4q/bg/ajax/newsletter/addsend/1.html?_=1704978685856 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT * FROM `newsletter_send` LIMIT 1

SHOW COLUMNS FROM `newsletter_send`

INSERT INTO `newsletter_send` SET `Language` = 'bg', `NewsletterID` = '1', `PostDate` = '2024-01-11 15:11:26', `Subject` = 'test', `Content` = '<h1>test</h1><div>sdfasd fasd fasdfasdfasdf <a href="https://maxgraphic.bg">asdf</a></div><div><img src="/techco/www/uf/newsletter/4975425074/i_teslax1.jpg"></div>'

SELECT
                `newsletter_subscribers`.`ID` AS `UserKey`,
                `newsletter_subscribers`.`Data`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1

SELECT * FROM `newsletter_users` LIMIT 1

SHOW COLUMNS FROM `newsletter_users`

REPLACE INTO `newsletter_users` SET `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e', `Data` = 'ubyTVPfpPNBpfpNWvGJ68kFFUGqyzo2X-ge_-yKn2dXBmYIb2uyKAt_N0BcHpefixMRLYg_dwCAjqbCL-bF82fzY8YkONn8iRS3eS3Gmaripdl3GYeOm5kUdwZTpBjJJLfJn0e62ygq3_0sIVXNOYoxjti7rRG9J6HC6haXSy1BCTtWdoByqJzM66t9BG-LcFwY5vphwzj84KRipbdu7ijrTMCeTw4RjfU6P7cSZIhE', `SendID` = 3, `SendKey` = '647366b7075a4e40d5259d605de073fa'

SELECT COUNT(*) FROM `newsletter_users` WHERE `SendID` = 3

SELECT COUNT(*) FROM `newsletter_users` WHERE `SendID` = 3 AND `Sent` = 1
# [11-Jan-2024 15:11:26] /techco/www/tNw2sPa4q/bg/ajax/newsletter/send/647366b7075a4e40d5259d605de073fa/3.html?_=1704978685905 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_send`.`Subject`,
                `newsletter_send`.`Content`,
                `newsletter_users`.`UserKey`,
                `newsletter_users`.`Data`,
                `newsletter`.`URLLabel`
            FROM
                `newsletter_users`
                INNER JOIN `newsletter_send` ON `newsletter_send`.`ID` = `newsletter_users`.`SendID`
                INNER JOIN `newsletter` ON
                    `newsletter_send`.`NewsletterID` = `newsletter`.`ID` AND
                    `newsletter_send`.`Language` = `newsletter`.`Language`
            WHERE
                `newsletter_users`.`Sent` = 0 AND
                `newsletter_users`.`SendKey` = '647366b7075a4e40d5259d605de073fa' AND
                `newsletter_send`.`ID` = 3 AND
                `newsletter_send`.`Language` = 'bg'
            LIMIT 1

UPDATE
                    `newsletter_users`
                SET
                    `SendKey` = ''
                WHERE
                    `SendID` = 3 AND
                    `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e'
                LIMIT 1

UPDATE
                `newsletter_users`
            SET
                `Sent` = 1
            WHERE
                `SendID` = 3 AND
                `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e'
            LIMIT 1
# [11-Jan-2024 15:11:27] /techco/www/tNw2sPa4q/bg/ajax/newsletter/send/647366b7075a4e40d5259d605de073fa/3.html?_=1704978687096 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_send`.`Subject`,
                `newsletter_send`.`Content`,
                `newsletter_users`.`UserKey`,
                `newsletter_users`.`Data`,
                `newsletter`.`URLLabel`
            FROM
                `newsletter_users`
                INNER JOIN `newsletter_send` ON `newsletter_send`.`ID` = `newsletter_users`.`SendID`
                INNER JOIN `newsletter` ON
                    `newsletter_send`.`NewsletterID` = `newsletter`.`ID` AND
                    `newsletter_send`.`Language` = `newsletter`.`Language`
            WHERE
                `newsletter_users`.`Sent` = 0 AND
                `newsletter_users`.`SendKey` = '647366b7075a4e40d5259d605de073fa' AND
                `newsletter_send`.`ID` = 3 AND
                `newsletter_send`.`Language` = 'bg'
            LIMIT 1
# [11-Jan-2024 15:14:29] /techco/www/tNw2sPa4q/bg/newsletter/log/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT `PostDate`, `Subject` FROM `newsletter_send` WHERE `ID` = 1 LIMIT 1

SELECT
                `Data`,
                `Sent`,
                `Opened`,
                `Links`,
                `SendKey`
            FROM
                `newsletter_users`
            WHERE
                `SendID` = 1
         LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `Data`,
                `Sent`,
                `Opened`,
                `Links`,
                `SendKey`
            FROM
                `newsletter_users`
            WHERE
                `SendID` = 1
        ) AS CountTable
# [11-Jan-2024 16:02:49] /techco/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNews') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAll') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [11-Jan-2024 16:02:50] /techco/www/bg/ajax/newsletter/form/home.html?_=1704981769827 167.99.142.201

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSubscribe','LEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2024 16:02:56] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704981775943 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '9y3dE3RzdKn79K7Qaa2Fr6X9I43WTw8b499Otvv1Z91s5S3Q4J39MWDu35888TN7'
            WHERE
                `UserKey` LIKE 'wrvCuMOmwqvCv8K4w6TCvMKtw5PDjsKzwq_Dl8KCw47DgcK0%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [11-Jan-2024 16:02:57] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704981776993 167.99.142.201

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '9y3dE3RzdKn79K7Qaa2Fr6X9I43WTw8b499Otvv1Z91s5S3Q4J39MWDu35888TN7'
            LIMIT 1
# [11-Jan-2024 16:03:00] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704981780053 167.99.142.201

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '9y3dE3RzdKn79K7Qaa2Fr6X9I43WTw8b499Otvv1Z91s5S3Q4J39MWDu35888TN7'
            LIMIT 1
# [11-Jan-2024 16:03:08] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704981787424 167.99.142.201

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '9y3dE3RzdKn79K7Qaa2Fr6X9I43WTw8b499Otvv1Z91s5S3Q4J39MWDu35888TN7'
            LIMIT 1
# [11-Jan-2024 16:03:16] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704981795526 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'tx6NwSgf9EbLNpF3U0XR2MSOz77klpN9lXpg42kdXA6x748yHjrpc6lQ7iD093Hz'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [11-Jan-2024 16:03:17] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1704981796409 167.99.142.201

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = 'tx6NwSgf9EbLNpF3U0XR2MSOz77klpN9lXpg42kdXA6x748yHjrpc6lQ7iD093Hz'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [11-Jan-2024 16:03:17] /techco/www/tNw2sPa4q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [11-Jan-2024 16:03:29] /techco/www/tNw2sPa4q/bg/newsletter/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [11-Jan-2024 16:03:30] /techco/www/tNw2sPa4q/bg/newsletter/1.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `newsletter_send`.`ID` AS `SendID`,
                `newsletter_send`.`NewsletterID`,
                `newsletter_send`.`PostDate`,
                `newsletter_send`.`Subject`,
                COUNT(`newsletter_users`.`UserKey`) AS `Subscribers`,
                COUNT(CASE WHEN `newsletter_users`.`SendKey` = '' THEN 1 END) AS `Progress`,
                SUM(`newsletter_users`.`Sent`) AS `Sent`,
                SUM(`newsletter_users`.`Opened`) AS `Opened`,
                SUM(`newsletter_users`.`Clicked`) AS `Clicked`
            FROM
                `newsletter`
                INNER JOIN `newsletter_send` ON
                    `newsletter`.`ID` = `newsletter_send`.`NewsletterID` AND
                    `newsletter`.`Language` = `newsletter_send`.`Language`
                LEFT JOIN `newsletter_users` ON `newsletter_users`.`SendID` = `newsletter_send`.`ID`
            WHERE
                `newsletter_send`.`NewsletterID` = 1 AND
                `newsletter`.`Language` = 'bg'
            GROUP BY
                `newsletter_send`.`ID`
            ORDER BY `PostDate` DESC
# [11-Jan-2024 16:10:02] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1704982199386 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [11-Jan-2024 16:10:10] /techco/www/tNw2sPa4q/bg/ajax/newsletter/addsend/1.html?_=1704982209724 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `URLLabel`,
                `Title`,
                `Content`
            FROM
                `newsletter`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT * FROM `newsletter_send` LIMIT 1

SHOW COLUMNS FROM `newsletter_send`

INSERT INTO `newsletter_send` SET `Language` = 'bg', `NewsletterID` = '1', `PostDate` = '2024-01-11 16:10:10', `Subject` = 'test 324', `Content` = '<h1>test</h1><div>sdfasd fasd fasdfasdfasdf <a href="https://maxgraphic.bg">asdf</a></div><div><img src="/techco/www/uf/newsletter/4975425074/i_teslax1.jpg"></div>'

SELECT
                `newsletter_subscribers`.`ID` AS `UserKey`,
                `newsletter_subscribers`.`Data`
            FROM
                `newsletter_subscribers`
                LEFT JOIN `newsletter_unsubscribed` ON `newsletter_subscribers`.`ID` = `newsletter_unsubscribed`.`ID`
            WHERE
                `newsletter_unsubscribed`.`ID` IS NULL AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1

SELECT * FROM `newsletter_users` LIMIT 1

SHOW COLUMNS FROM `newsletter_users`

REPLACE INTO `newsletter_users` SET `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e', `Data` = 'ubyTVPfpPNBpfpNWvGJ68kFFUGqyzo2X-ge_-yKn2dXBmYIb2uyKAt_N0BcHpefixMRLYg_dwCAjqbCL-bF82fzY8YkONn8iRS3eS3Gmaripdl3GYeOm5kUdwZTpBjJJLfJn0e62ygq3_0sIVXNOYoxjti7rRG9J6HC6haXSy1BCTtWdoByqJzM66t9BG-LcFwY5vphwzj84KRipbdu7ijrTMCeTw4RjfU6P7cSZIhE', `SendID` = 4, `SendKey` = 'e22992a6ebd7b604bd22705b364fecc5'

SELECT COUNT(*) FROM `newsletter_users` WHERE `SendID` = 4

SELECT COUNT(*) FROM `newsletter_users` WHERE `SendID` = 4 AND `Sent` = 1
# [11-Jan-2024 16:10:10] /techco/www/tNw2sPa4q/bg/ajax/newsletter/send/e22992a6ebd7b604bd22705b364fecc5/4.html?_=1704982209979 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_send`.`Subject`,
                `newsletter_send`.`Content`,
                `newsletter_users`.`UserKey`,
                `newsletter_users`.`Data`,
                `newsletter`.`URLLabel`
            FROM
                `newsletter_users`
                INNER JOIN `newsletter_send` ON `newsletter_send`.`ID` = `newsletter_users`.`SendID`
                INNER JOIN `newsletter` ON
                    `newsletter_send`.`NewsletterID` = `newsletter`.`ID` AND
                    `newsletter_send`.`Language` = `newsletter`.`Language`
            WHERE
                `newsletter_users`.`Sent` = 0 AND
                `newsletter_users`.`SendKey` = 'e22992a6ebd7b604bd22705b364fecc5' AND
                `newsletter_send`.`ID` = 4 AND
                `newsletter_send`.`Language` = 'bg'
            LIMIT 1

UPDATE
                    `newsletter_users`
                SET
                    `SendKey` = ''
                WHERE
                    `SendID` = 4 AND
                    `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e'
                LIMIT 1

UPDATE
                `newsletter_users`
            SET
                `Sent` = 1
            WHERE
                `SendID` = 4 AND
                `UserKey` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e'
            LIMIT 1
# [11-Jan-2024 16:10:13] /techco/www/tNw2sPa4q/bg/ajax/newsletter/send/e22992a6ebd7b604bd22705b364fecc5/4.html?_=1704982212791 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1935110548 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `newsletter_send`.`Subject`,
                `newsletter_send`.`Content`,
                `newsletter_users`.`UserKey`,
                `newsletter_users`.`Data`,
                `newsletter`.`URLLabel`
            FROM
                `newsletter_users`
                INNER JOIN `newsletter_send` ON `newsletter_send`.`ID` = `newsletter_users`.`SendID`
                INNER JOIN `newsletter` ON
                    `newsletter_send`.`NewsletterID` = `newsletter`.`ID` AND
                    `newsletter_send`.`Language` = `newsletter`.`Language`
            WHERE
                `newsletter_users`.`Sent` = 0 AND
                `newsletter_users`.`SendKey` = 'e22992a6ebd7b604bd22705b364fecc5' AND
                `newsletter_send`.`ID` = 4 AND
                `newsletter_send`.`Language` = 'bg'
            LIMIT 1
