# [24-Apr-2023 13:45:40] /maxxium/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ParentID` = 0
         AND `Visible` = 1 ORDER BY `brands`.`Title` ASC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [24-Apr-2023 13:45:41] /maxxium/www/bg/ajax/cookies.html?_=1682333140944 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
# [24-Apr-2023 13:45:47] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1682333147176 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'FT5xhZuAtEQscsmlSERTUQnR5opJbp4U7aB8S0qdygrU367kEB329mnh8zmEIUFg'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [24-Apr-2023 13:45:48] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1682333148234 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` = 'FT5xhZuAtEQscsmlSERTUQnR5opJbp4U7aB8S0qdygrU367kEB329mnh8zmEIUFg'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [24-Apr-2023 13:45:48] /maxxium/www/mxD7ap2Va/bg/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`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC
# [24-Apr-2023 13:45:50] /maxxium/www/mxD7ap2Va/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
# [24-Apr-2023 13:45:51] /maxxium/www/mxD7ap2Va/bg/recipes/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
                `recipes`.`ID`,
                `recipes`.`Language`,
                `recipes`.`PostDate`,
                `recipes`.`LastUpdate`,
                `recipes`.`Title`,
                `recipes`.`Visible`,
                GROUP_CONCAT(`brands`.`Title` SEPARATOR ',') AS `Brands`
            FROM
                `recipes`
                LEFT JOIN `recipe_brands` ON `recipes`.`ID` = `recipe_brands`.`RecipeID`
                LEFT JOIN `brands` ON `recipe_brands`.`BrandID` = `brands`.`ID`
            WHERE
                `recipes`.`Language` = 'bg'
                
            GROUP BY `recipes`.`ID`
            ORDER BY  `PostDate` ASC
# [24-Apr-2023 13:45:53] /maxxium/www/mxD7ap2Va/bg/brands/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [24-Apr-2023 13:45:54] /maxxium/www/mxD7ap2Va/bg/events/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`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC
# [24-Apr-2023 16:14:11] /maxxium/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ParentID` = 0
         AND `Visible` = 1 ORDER BY `brands`.`Title` ASC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [24-Apr-2023 16:14:11] /maxxium/www/bg/ajax/cookies.html?_=1682342051127 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
# [24-Apr-2023 16:14:13] /maxxium/www/mxD7ap2Va 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
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index'
         LIMIT 1

SELECT
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ParentID` = 0
         ORDER BY `brands`.`Title` ASC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` ASC
# [24-Apr-2023 16:14:14] /maxxium/www/bg/ajax/cookies.html?_=1682342053975 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
# [24-Apr-2023 16:14:17] /maxxium/www/mxD7ap2Va/bg/brands.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
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'brands' AND
	    		`URLLabel` = 'brands'
         LIMIT 1

SELECT DISTINCT `Category` FROM `brands` WHERE `Language` = 'bg' ORDER BY `PostDate` ASC

SELECT
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ParentID` = 0
         ORDER BY `brands`.`Title` ASC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` ASC
# [24-Apr-2023 16:14:18] /maxxium/www/bg/ajax/cookies.html?_=1682342057871 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
# [24-Apr-2023 16:14:20] /maxxium/www/mxD7ap2Va/bg/about-us.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
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'about-us'
         LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'about-us'
         LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` ASC
# [24-Apr-2023 16:14:20] /maxxium/www/bg/ajax/cookies.html?_=1682342060323 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
# [24-Apr-2023 16:14:21] /maxxium/www/mxD7ap2Va/bg/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`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC
# [24-Apr-2023 16:14:24] /maxxium/www/mxD7ap2Va/bg/recipes/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
                `recipes`.`ID`,
                `recipes`.`Language`,
                `recipes`.`PostDate`,
                `recipes`.`LastUpdate`,
                `recipes`.`Title`,
                `recipes`.`Visible`,
                GROUP_CONCAT(`brands`.`Title` SEPARATOR ',') AS `Brands`
            FROM
                `recipes`
                LEFT JOIN `recipe_brands` ON `recipes`.`ID` = `recipe_brands`.`RecipeID`
                LEFT JOIN `brands` ON `recipe_brands`.`BrandID` = `brands`.`ID`
            WHERE
                `recipes`.`Language` = 'bg'
                
            GROUP BY `recipes`.`ID`
            ORDER BY  `PostDate` ASC
# [24-Apr-2023 16:14:26] /maxxium/www/mxD7ap2Va/bg/brands/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [24-Apr-2023 16:14:27] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/1.html?_=1682342067397 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
                *
            FROM
                `brands`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `Title`
            FROM
                `brands`
            WHERE
                `ID` != 1 AND
                `ParentID` = 0
        
                ORDER BY
                    `PostDate`

SELECT DISTINCT TRIM(`Category`) AS `Category` FROM `brands`
