# [10-Jan-2023 06:48:47] /goodgo/www/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

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

SELECT
	        	*
	        FROM
	        	`reviews`
	    	WHERE
                `Language` = 'bg'
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 2

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'reviews'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `reviews` WHERE `Language` = 'bg' AND `Visible` = 1

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Jan-2023 06:48:47] /goodgo/www/bg/ajax/cookies.html?_=1673326131445 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Jan-2023 06:48:59] /goodgo/www/gJ3dnAld/bg/ajax/users/form/login.html?_=1673326143144 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLoginEMail','EMailError','LSubmit') 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
# [10-Jan-2023 06:49:04] /goodgo/www/gJ3dnAld/bg/ajax/users/login.html?_=1673326147919 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '2343c9U9bFg6BkGSMcK9mYJJvxw8xOd7EIt1yI7R52FTDP4qgbA4iJ6uQ7S8ySS1'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Jan-2023 06:49:05] /goodgo/www/gJ3dnAld/bg/ajax/users/login.html?_=1673326149130 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` = '2343c9U9bFg6BkGSMcK9mYJJvxw8xOd7EIt1yI7R52FTDP4qgbA4iJ6uQ7S8ySS1'
            LIMIT 1
# [10-Jan-2023 06:49:05] /goodgo/www/gJ3dnAldbg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1
# [10-Jan-2023 06:49:09] /goodgo/www/gJ3dnAld/bg/labels/list.html 167.99.142.201

set names utf8

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

SELECT
                `LabelsBG`.`Label`,
                `LabelsBG`.`Value` AS `LabelsBGValue`
            FROM
                `labels` AS `LabelsBG`
            WHERE
                `LabelsBG`.`Language` = 'bg'
         ORDER BY `LabelsBG`.`Label` ASC
# [10-Jan-2023 06:49:12] /goodgo/www/gJ3dnAld/bg/ajax/labels/form.html?label=Apr&_=1673326156376 167.99.142.201

set names utf8

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

SELECT
                LabelsBG.`Label`,
                LabelsBG.`Value` AS `ValueBG`
            FROM
                `labels` AS LabelsBG
            WHERE
                LabelsBG.`Language` = 'bg' AND
                LabelsBG.`Label` = 'Apr'
            LIMIT 1
# [10-Jan-2023 06:49:25] /goodgo/www/gJ3dnAld/bg/ajax/labels/form.html?label=ErrorEMail&_=1673326169589 167.99.142.201

set names utf8

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

SELECT
                LabelsBG.`Label`,
                LabelsBG.`Value` AS `ValueBG`
            FROM
                `labels` AS LabelsBG
            WHERE
                LabelsBG.`Language` = 'bg' AND
                LabelsBG.`Label` = 'ErrorEMail'
            LIMIT 1
# [10-Jan-2023 06:53:49] /goodgo/www/gJ3dnAld/bg/ajax/labels/form.html?label=ErrorMessage&_=1673326433126 167.99.142.201

set names utf8

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

SELECT
                LabelsBG.`Label`,
                LabelsBG.`Value` AS `ValueBG`
            FROM
                `labels` AS LabelsBG
            WHERE
                LabelsBG.`Language` = 'bg' AND
                LabelsBG.`Label` = 'ErrorMessage'
            LIMIT 1
# [10-Jan-2023 06:54:11] /goodgo/www/gJ3dnAld/bg/ajax/labels/form.html?label=Aug&_=1673326455141 167.99.142.201

set names utf8

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

SELECT
                LabelsBG.`Label`,
                LabelsBG.`Value` AS `ValueBG`
            FROM
                `labels` AS LabelsBG
            WHERE
                LabelsBG.`Language` = 'bg' AND
                LabelsBG.`Label` = 'Aug'
            LIMIT 1
