# [05-May-2023 11:50:41] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1683276752557 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '6OtEpE3gkeSN0uTulzEq2n4Y15sVSKtvzbRuzXaps2Exmbu6Z1YW2iX19MlZSwwr'
            WHERE
                `UserKey` LIKE 'w5DCucOmw53Cv8Kaw6XDo8OHw4fDosKaw5LDjMOSw6fCvcOKwr_CmcODw5c%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [05-May-2023 11:50:56] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1683276767228 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` = '6OtEpE3gkeSN0uTulzEq2n4Y15sVSKtvzbRuzXaps2Exmbu6Z1YW2iX19MlZSwwr'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 3
            LIMIT 1
# [05-May-2023 11:50:56] /maxxium/www/mxD7ap2Va/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 3 AND
                                CRC32(`UserKey`) = 3843054952 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
# [05-May-2023 11:51:12] /maxxium/www/mxD7ap2Va/bg/brands.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 3 AND
                                CRC32(`UserKey`) = 3843054952 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
# [05-May-2023 11:51:41] /maxxium/www/mxD7ap2Va/bg/recipes.html 167.99.142.201

set names utf8

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

SELECT
                DISTINCT `brands`.`Category`
            FROM
                `brands`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`BrandID` = `brands`.`ID`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` ASC

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

SELECT
	        	`recipes`.*,
                GROUP_CONCAT(CRC32(`brands`.`Category`) SEPARATOR ',') AS `Types`
	        FROM
	        	`recipes`
                LEFT JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
                LEFT JOIN `brands` ON `recipe_brands`.`BrandID` = `brands`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg'
         GROUP BY `recipes`.`ID` ORDER BY `recipes`.`PostDate` ASC

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` ASC
# [05-May-2023 11:52:17] /maxxium/www/bg/ajax/recipes/video/36.html?_=1683276848658 167.99.142.201

set names utf8

SELECT
                `VideoURL`
	        FROM
	        	`recipes`
            WHERE
                `ID` = 36 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1
