# [17-Jan-2024 08:22: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
# [17-Jan-2024 08:22:03] /techco/www/bg/ajax/newsletter/form/home.html?_=1705472524583 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
# [17-Jan-2024 08:22:03] /techco/www/bg/ajax/cookies.html?_=1705472524584 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
# [17-Jan-2024 08:22:11] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705472533036 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'ZyNaaYjm7O8ZrVx9253GJsi3hlUv0nAOfO6B9vq3nsxbUVPksAds7Ak3ukf11Ry9'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [17-Jan-2024 08:22:12] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705472533773 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` = 'ZyNaaYjm7O8ZrVx9253GJsi3hlUv0nAOfO6B9vq3nsxbUVPksAds7Ak3ukf11Ry9'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [17-Jan-2024 08:22:12] /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
# [17-Jan-2024 08:22:15] /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
# [17-Jan-2024 08:22:19] /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
# [17-Jan-2024 08:22:21] /techco/www/tNw2sPa4q/bg/import/newsletter.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
# [17-Jan-2024 08:22:29] /techco/www/tNw2sPa4q/bg/ajax/import/upload.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
# [17-Jan-2024 08:22:29] /techco/www/tNw2sPa4q/bg/ajax/import/table.html?_=1705472551173 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
# [17-Jan-2024 13:28:21] /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
# [17-Jan-2024 13:28:22] /techco/www/bg/ajax/newsletter/form/home.html?_=1705490902327 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
# [17-Jan-2024 13:28:22] /techco/www/bg/ajax/cookies.html?_=1705490902330 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
# [17-Jan-2024 13:28:33] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705490913482 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'zk1d2BnFpliRNZSA4K5NNgxDjtubjZjBWYWiy57sJmeH33w401Jq7YjgHYMA9R9B'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [17-Jan-2024 13:28:34] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705490914287 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` = 'zk1d2BnFpliRNZSA4K5NNgxDjtubjZjBWYWiy57sJmeH33w401Jq7YjgHYMA9R9B'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [17-Jan-2024 13:28:34] /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
# [17-Jan-2024 13:29: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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [17-Jan-2024 13:29: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
# [17-Jan-2024 13:29:07] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/user/ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e.html?_=1705490947209 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
# [17-Jan-2024 13:40:08] /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
# [17-Jan-2024 13:40:10] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/user/ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e.html?_=1705491610767 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
# [17-Jan-2024 13:41:37] /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
# [17-Jan-2024 13:41:39] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/user/ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e.html?_=1705491699525 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
# [17-Jan-2024 13:41:58] /techco/www/tNw2sPa4q/bg/ajax/newsletter/update/ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e.html?_=1705491718182 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 `newsletter_subscribers` LIMIT 1

SHOW COLUMNS FROM `newsletter_subscribers`

UPDATE `newsletter_subscribers` SET `ID` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e', `Language` = 'bg', `LastUpdate` = '2024-01-17 13:41:58', `Data` = 'BLLAkQt78t3kz42XdBdDyqZx8IEVvtLTnmMAaKJxLQpqMQWkXcZ0cKPCmzkKV5j6DdsWwcCxmSXMn_2LPY5KivbTUxgHqJVkZH0RlwrPPQN7IAXZcdljFp0DENrTTcFYIXkNgVCWZm1feROOge2OvLBULvei_ke1hedF-eUl8Bd-GzFqkAp8YDUfYYy0-HVtDg9BHFCY4jt_Qf6pqPv6Mw', `SearchKey` = 'aHJpc3RvZGF2YXJha2kbWF4Z3JhcGhpYwZW9vZAZGF2YXJza2kZ21haWwY29t' WHERE `ID` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e' AND `Language` = 'bg'
# [17-Jan-2024 13:41:58] /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
# [17-Jan-2024 13:42:00] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/user/ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e.html?_=1705491720506 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
# [17-Jan-2024 13:44:28] /techco/www/tNw2sPa4q/bg/ajax/newsletter/update/ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e.html?_=1705491868091 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 `newsletter_subscribers` LIMIT 1

SHOW COLUMNS FROM `newsletter_subscribers`

UPDATE `newsletter_subscribers` SET `ID` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e', `Language` = 'bg', `LastUpdate` = '2024-01-17 13:44:28', `Data` = 'NhiJJIxEJTHw38UJZZ1pj4odBy2sD9NEr6fEXSEW03FZMgcp3d60HYgTesOJmcWu9JPbXVp89R4DU--dIH_IMa31fTAZ7cI_KGmv2mOxCZUcxrSHMTaEhlHfkDNx21YzuNsx9u2cbgnUeXLOTH5_KIlet5P1_CbS5aNCHh58LMFORNiEDY5YGsM5dswNKPlpufFuIgLNYActpeGv3RP6iDI5yg_fxb3bh027sFumzgjHSInVAjKP2PzIAQJFXu4HCTNzNHWipdzZv0aSvy9vnWqAdxhL_Lfi4ytVO4m3SMPqcsYlPX6exqMUKaLH2GyO', `SearchKey` = 'aHJpc3RvZGF2YXJha2kbWF4Z3JhcGhpYwZW9vZAZGF2YXJza2kZ21haWwY29t', `ClientNumber` = 'сдфгсдф', `ClientGroup` = 'Автосервиз' WHERE `ID` = 'ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e' AND `Language` = 'bg'
# [17-Jan-2024 13:44:28] /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
# [17-Jan-2024 13:44:30] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/user/ed42d2ccaddf7a75d421eadcfca83f05d0dcea1cdfb549bdf05a7d9ed0a79e4e.html?_=1705491870080 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
# [17-Jan-2024 13:46: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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `newsletter`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [17-Jan-2024 13:46:42] /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
# [17-Jan-2024 13:46:45] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705492005785 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
# [17-Jan-2024 13:47:31] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705492051125 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
# [17-Jan-2024 13:57: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
# [17-Jan-2024 13:57:28] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705492648646 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
# [17-Jan-2024 13:58:04] /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
# [17-Jan-2024 13:58:05] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705492685773 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
# [17-Jan-2024 14:05: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

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
# [17-Jan-2024 14:05:49] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705493149058 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
# [17-Jan-2024 14:06:06] /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
# [17-Jan-2024 14:06:07] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705493167430 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 DISTINCT `ClientGroup` FROM `newsletter_subscribers` ORDER BY `ClientGroup` ASC
# [17-Jan-2024 14:06: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

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
# [17-Jan-2024 14:06:48] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705493208737 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 DISTINCT `ClientGroup` FROM `newsletter_subscribers` ORDER BY `ClientGroup` ASC
# [17-Jan-2024 14:08:10] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705493290720 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 DISTINCT `ClientGroup` FROM `newsletter_subscribers` ORDER BY `ClientGroup` ASC
# [17-Jan-2024 14:19:39] /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
# [17-Jan-2024 14:19:46] /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
# [17-Jan-2024 14:19: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

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
# [17-Jan-2024 14:19:57] /techco/www/tNw2sPa4q/bg/ajax/users/logout.html?_=1705493997145 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
# [17-Jan-2024 14:19:57] /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
# [17-Jan-2024 14:19:57] /techco/www/bg/ajax/newsletter/form/home.html?_=1705493997886 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
# [17-Jan-2024 14:19:57] /techco/www/bg/ajax/cookies.html?_=1705493997890 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
# [17-Jan-2024 14:20:10] /techco/www/bg/ajax/newsletter/form/subscribe.html?_=1705494010023 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
# [17-Jan-2024 14:20:16] /techco/www/bg/ajax/newsletter/subscribe.html?_=1705494016265 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` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67' LIMIT 1

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

SELECT * FROM `newsletter_subscribers` LIMIT 1

SHOW COLUMNS FROM `newsletter_subscribers`

INSERT INTO `newsletter_subscribers` SET `ID` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67', `Language` = 'bg', `PostDate` = '2024-01-17', `LastUpdate` = '2024-01-17 14:20:16', `Data` = '64HkqwuXcWsJZXEOOJ_VDRjt0ra6lOvLL_WbAXdV3iqFnMoGMVz0fwLagEE_r1P_goVNSgbtlrsqMbwEQtklSnBS8XpyDF_HlDVZlFIdj-6ZJ8cMYb6e96ITIoICYYzb2Gm8oW1GC67zKJ5nIPLvlICBMFLsE8mqczp5ViravM5gKXiEm1iUQ-t8v2nIlYoi', `SearchKey` = 'aHJpc3RvbWF4Z3JhcGhpYw'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNewsletter') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [17-Jan-2024 14:20:17] /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
# [17-Jan-2024 14:20:50] /techco/www/bg/newsletter/confirm/53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67.html 167.99.142.201

set names utf8

UPDATE `newsletter_subscribers` SET `Confirmed` = 1 WHERE `ID` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67' LIMIT 1;
# [17-Jan-2024 14:20:50] /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
# [17-Jan-2024 14:20:55] /techco/www/bg/ajax/cookies.html?_=1705494054812 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
# [17-Jan-2024 14:21:08] /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
# [17-Jan-2024 14:21:08] /techco/www/tNw2sPa4q/bg/ajax/users/form/login.html?_=1705494068343 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
# [17-Jan-2024 14:21:13] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705494073533 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` = 'eEPI9n3XkB87HG2NIHt16eora3JSxCqg0Q7c55h4F6OYMha07GurJOWLz659pSMJ'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [17-Jan-2024 14:21:14] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705494074611 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` = 'eEPI9n3XkB87HG2NIHt16eora3JSxCqg0Q7c55h4F6OYMha07GurJOWLz659pSMJ'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [17-Jan-2024 14:21:14] /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
# [17-Jan-2024 14:21:17] /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
# [17-Jan-2024 14:21:19] /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
# [17-Jan-2024 14:21:21] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/user/53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67.html?_=1705494081936 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` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67' AND
                `Language` = 'bg'
            LIMIT 1
# [17-Jan-2024 14:21:35] /techco/www/tNw2sPa4q/bg/ajax/newsletter/update/53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67.html?_=1705494095772 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 `newsletter_subscribers` LIMIT 1

SHOW COLUMNS FROM `newsletter_subscribers`

UPDATE `newsletter_subscribers` SET `ID` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67', `Language` = 'bg', `LastUpdate` = '2024-01-17 14:21:35', `Data` = 'T59p8DjRMu_Dk-NHqrLsqllJe1bMm7dAP7NuV97FXjd7y5YYZWisYON85FBb2n2fj7QfEO-zlbO9jlMn6uRMODecTAM57qqcus3bfnlKu94EDkv7GPKnD141qLQDgKFGStA00JL9jx1YvUT_4nEff_3ekGXODIshTS3y_aQT1Ce2ONuTHfx6G5LCK8LDpOwLBPULJloZtX8IFw0MuWyg6uVmuYLDU9XmdEwpYinH7ZhlJKuBsyn92yy0DejNMCWT', `SearchKey` = 'aHJpc3RvbWF4Z3JhcGhpYw', `ClientNumber` = '', `ClientGroup` = 'Тежкотоварни' WHERE `ID` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67' AND `Language` = 'bg'
# [17-Jan-2024 14:21:35] /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
# [17-Jan-2024 14:21:38] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/user/53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67.html?_=1705494098073 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` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67' AND
                `Language` = 'bg'
            LIMIT 1
# [17-Jan-2024 14:21:58] /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
# [17-Jan-2024 14:22:01] /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
# [17-Jan-2024 14:22:03] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705494123761 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 DISTINCT `ClientGroup` FROM `newsletter_subscribers` ORDER BY `ClientGroup` ASC
# [17-Jan-2024 14:22:45] /techco/www/tNw2sPa4q/bg/ajax/newsletter/addsend/1.html?_=1705494165962 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
# [17-Jan-2024 14:23: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
# [17-Jan-2024 14:23:17] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705494197031 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 DISTINCT `ClientGroup` FROM `newsletter_subscribers` ORDER BY `ClientGroup` ASC
# [17-Jan-2024 14:23:19] /techco/www/tNw2sPa4q/bg/ajax/newsletter/addsend/1.html?_=1705494199179 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-17 14:23:19', `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`.`ClientGroup` = '' AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1

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`.`ClientGroup` = '' AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1

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

SELECT COUNT(*) FROM `newsletter_users` WHERE `SendID` = 5 AND `Sent` = 1
# [17-Jan-2024 14:23:39] /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
# [17-Jan-2024 14:23:45] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705494225770 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 DISTINCT `ClientGroup` FROM `newsletter_subscribers` ORDER BY `ClientGroup` ASC
# [17-Jan-2024 14:23:49] /techco/www/tNw2sPa4q/bg/ajax/newsletter/addsend/1.html?_=1705494228994 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-17 14:23:49', `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`.`ClientGroup` = '' AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1

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`.`ClientGroup` = '' AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1

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

SELECT COUNT(*) FROM `newsletter_users` WHERE `SendID` = 6 AND `Sent` = 1
# [17-Jan-2024 14:25: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
# [17-Jan-2024 14:25:52] /techco/www/bg/ajax/newsletter/form/home.html?_=1705494352178 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
# [17-Jan-2024 14:25:56] /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
# [17-Jan-2024 14:25:56] /techco/www/tNw2sPa4q/bg/ajax/users/form/login.html?_=1705494356658 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
# [17-Jan-2024 14:26:02] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705494362445 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` = 'L0BTrK62fPX6vne829xtqVWygJl94z7TiRzg8zSOpwtof1EdHoNndp3x6Oyh8yOV'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [17-Jan-2024 14:26:03] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705494363426 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` = 'L0BTrK62fPX6vne829xtqVWygJl94z7TiRzg8zSOpwtof1EdHoNndp3x6Oyh8yOV'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [17-Jan-2024 14:26:03] /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
# [17-Jan-2024 14:26:08] /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
# [17-Jan-2024 14:26:11] /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
# [17-Jan-2024 14:26:13] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705494373951 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 DISTINCT `ClientGroup` FROM `newsletter_subscribers` ORDER BY `ClientGroup` ASC
# [17-Jan-2024 14:26:17] /techco/www/tNw2sPa4q/bg/ajax/newsletter/addsend/1.html?_=1705494376995 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-17 14:26:17', `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`.`ClientGroup` = '' AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1

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`.`ClientGroup` = '' AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1
# [17-Jan-2024 14:26:28] /techco/www/tNw2sPa4q/bg/ajax/newsletter/addsend/1.html?_=1705494388074 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-17 14:26:28', `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`.`ClientGroup` = '' AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1

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`.`ClientGroup` = '' AND
                `newsletter_subscribers`.`Language` = 'bg' AND
                `newsletter_subscribers`.`Confirmed` = 1
# [17-Jan-2024 14:27:45] /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
# [17-Jan-2024 14:27:48] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/send/1.html?_=1705494468051 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 DISTINCT `ClientGroup` FROM `newsletter_subscribers` ORDER BY `ClientGroup` ASC
# [17-Jan-2024 14:28:24] /techco/www/tNw2sPa4q/bg/ajax/newsletter/addsend/1.html?_=1705494504542 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-17 14:28:24', `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`.`ClientGroup` = 'Автосервиз' 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` = 'NhiJJIxEJTHw38UJZZ1pj4odBy2sD9NEr6fEXSEW03FZMgcp3d60HYgTesOJmcWu9JPbXVp89R4DU--dIH_IMa31fTAZ7cI_KGmv2mOxCZUcxrSHMTaEhlHfkDNx21YzuNsx9u2cbgnUeXLOTH5_KIlet5P1_CbS5aNCHh58LMFORNiEDY5YGsM5dswNKPlpufFuIgLNYActpeGv3RP6iDI5yg_fxb3bh027sFumzgjHSInVAjKP2PzIAQJFXu4HCTNzNHWipdzZv0aSvy9vnWqAdxhL_Lfi4ytVO4m3SMPqcsYlPX6exqMUKaLH2GyO', `SendID` = 9, `SendKey` = '5b8132b7717b90fba63962caf81e5f7e'

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`.`ClientGroup` = 'Тежкотоварни' 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` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67', `Data` = 'T59p8DjRMu_Dk-NHqrLsqllJe1bMm7dAP7NuV97FXjd7y5YYZWisYON85FBb2n2fj7QfEO-zlbO9jlMn6uRMODecTAM57qqcus3bfnlKu94EDkv7GPKnD141qLQDgKFGStA00JL9jx1YvUT_4nEff_3ekGXODIshTS3y_aQT1Ce2ONuTHfx6G5LCK8LDpOwLBPULJloZtX8IFw0MuWyg6uVmuYLDU9XmdEwpYinH7ZhlJKuBsyn92yy0DejNMCWT', `SendID` = 9, `SendKey` = '5b8132b7717b90fba63962caf81e5f7e'
# [17-Jan-2024 14:58: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

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
# [17-Jan-2024 15:00:37] /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
# [17-Jan-2024 15:01:05] /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
# [17-Jan-2024 17:08:22] /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
# [17-Jan-2024 17:08:25] /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
# [17-Jan-2024 17:08:27] /techco/www/tNw2sPa4q/bg/import/newsletter.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
# [17-Jan-2024 17:09:36] /techco/www/tNw2sPa4q/bg/import/newsletter.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
# [17-Jan-2024 17:09:39] /techco/www/tNw2sPa4q/bg/import/newsletter.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
# [17-Jan-2024 17:22:43] /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
# [17-Jan-2024 17:22:44] /techco/www/bg/ajax/newsletter/form/home.html?_=1705504965167 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
# [17-Jan-2024 17:22:52] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705504972407 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'S7eTYXn05Y2TytMlHvC3587r19cYPuOM0LqdjzSSkAzy4QuW3L8PMfDk6XPhwgOU'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [17-Jan-2024 17:22:52] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705504973176 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` = 'S7eTYXn05Y2TytMlHvC3587r19cYPuOM0LqdjzSSkAzy4QuW3L8PMfDk6XPhwgOU'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [17-Jan-2024 17:22: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
# [17-Jan-2024 17:22:55] /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
# [17-Jan-2024 17:22: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
# [17-Jan-2024 17:23:00] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/user/53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67.html?_=1705504980345 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` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67' AND
                `Language` = 'bg'
            LIMIT 1
# [17-Jan-2024 17:23:37] /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
# [17-Jan-2024 17:23:39] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/user/53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67.html?_=1705505019443 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` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67' AND
                `Language` = 'bg'
            LIMIT 1
# [17-Jan-2024 17:24:17] /techco/www/tNw2sPa4q/bg/ajax/newsletter/update/53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67.html?_=1705505057635 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 `newsletter_subscribers` LIMIT 1

SHOW COLUMNS FROM `newsletter_subscribers`

UPDATE `newsletter_subscribers` SET `ID` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67', `Language` = 'bg', `LastUpdate` = '2024-01-17 17:24:17', `Data` = 'pl06kbdT7Wle4_sabNx66RVSmJZ9-fsw0t4nYhLO1D6Weu4hq5ZGhT1oEfu9m4wx-buDm_DYEpS4IzwQSJlwX_HsobiyLL-Kqp7jgteu652ViIbPTlVrDPNrOLYwMxrWF7eZjtCPbEZuUUnM6Y0jAiSZhLxgLDHk-IJhEx6lAkqONKIagVkT58rSaTA9Ohs67YHCxgh9QKCvZwbk4G5B1AmBRDEBQrwk-HZUi5tfx1v6Q6U9mK8H7KxceEf2bCZ33POJS-pZtVzH5c1ou7jcpK3Z6GhNf0RtUH7ojW2SxyTnnSs4dTt30QSK2DszXYsrTbrzRmOhZRaFmQRwqbIVqrgqzfKJeRG6HXKENdbRlps', `SearchKey` = 'aHJpc3RvZGF2YXJza2k0LzQsNC60YE0LPRgNCw0YTQuNC60LXQvtC-0LQaHJpc3RvbWF4Z3JhcGhpYw', `ClientObject` = '00', `ClientNumber` = 'ZZZZ0', `ClientGroup` = 'Тежкотоварни' WHERE `ID` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67' AND `Language` = 'bg'
# [17-Jan-2024 17:24:17] /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
# [17-Jan-2024 17:24:20] /techco/www/tNw2sPa4q/bg/ajax/newsletter/form/user/53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67.html?_=1705505060869 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` = '53a7c0e5c48bc7fa6824548c1ddaf4f33d4c046d6aa89b45add085813b886a67' AND
                `Language` = 'bg'
            LIMIT 1
# [17-Jan-2024 17:24: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
# [17-Jan-2024 17:24: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

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
# [17-Jan-2024 17:24: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

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
# [17-Jan-2024 17:24:34] /techco/www/tNw2sPa4q/bg/import/newsletter.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
# [17-Jan-2024 17:24:38] /techco/www/tNw2sPa4q/bg/ajax/import/upload.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
# [17-Jan-2024 17:24:38] /techco/www/tNw2sPa4q/bg/ajax/import/table.html?_=1705505079108 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
# [17-Jan-2024 18:02:48] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705507368479 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '1nquSl8cao5mU5KaIekA75o8F89X9Yjyge9MQkwsyLp2Gt88LP419Ig9uy1KC75E'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [17-Jan-2024 18:02:48] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1705507369177 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` = '1nquSl8cao5mU5KaIekA75o8F89X9Yjyge9MQkwsyLp2Gt88LP419Ig9uy1KC75E'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [17-Jan-2024 18:02:48] /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
# [17-Jan-2024 18:02: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
# [17-Jan-2024 18:02:53] /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
# [17-Jan-2024 18:03:04] /techco/www/bg/newsletter/subscribers/page_2.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
