# [28-Mar-2024 15:37:19] /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`,
                `UploadID`,
                `Image`,
                `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`,
                `UploadID`,
                `Image`,
                `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`,
                `URLLabel`,
                `URL`,
                `Content` <> '' AS `bContent`
            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
# [28-Mar-2024 15:37:28] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1711633048066 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '3qL13s2wYKpNXkHxR8lY37B6fQUECLTuH2138w8oQ7r6p4o14O60B2JKl2A3N3ld'
            WHERE
                `UserKey` LIKE 'w4vCvMOjwr7CjcKyw5rDi8OUw57DgsOCwq7DlMK3wpnCtMKu%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [28-Mar-2024 15:37:28] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1711633048838 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` = '3qL13s2wYKpNXkHxR8lY37B6fQUECLTuH2138w8oQ7r6p4o14O60B2JKl2A3N3ld'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [28-Mar-2024 15:37:28] /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
# [28-Mar-2024 15:37:33] /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
# [28-Mar-2024 15:37: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`.`ClientObject`,
                `newsletter_subscribers`.`ClientNumber`,
                `newsletter_subscribers`.`ClientGroup`,
                `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
# [28-Mar-2024 15:37:37] /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
# [28-Mar-2024 15:37:49] /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
# [28-Mar-2024 15:37:49] /techco/www/tNw2sPa4q/bg/ajax/import/table.html?_=1711633069096 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
# [28-Mar-2024 15:38:14] /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
# [28-Mar-2024 15:38:14] /techco/www/tNw2sPa4q/bg/ajax/import/table.html?_=1711633094328 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
# [28-Mar-2024 15:39:12] /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
# [28-Mar-2024 15:39:17] /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
# [28-Mar-2024 15:39:17] /techco/www/tNw2sPa4q/bg/ajax/import/table.html?_=1711633157535 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
