# [31-May-2023 09:09:03] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 09:09:07] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 09:09:21] /maxxium/www/bg/brands/императорская-коллекция.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'императорская-коллекция'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 103
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 103
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 103
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 09:09:30] /maxxium/www/bg/brands/императорская-коллекция-lilac-metalized.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'императорская-коллекция-lilac-metalized'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 168
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 103
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    (`ParentID` = 103 OR `ID` = 103) AND
                    `ID` != 168
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 11:26:16] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 11:26:52] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 11:36:27] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 11:37:18] /maxxium/www/bg/brands/dalmore-12-yo.html 167.99.142.201

set names utf8
# [31-May-2023 11:37:18] /maxxium/www/bg/brands/dalmore-12-yo.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'dalmore-12-yo'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'dalmore-12-yo'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 61
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 61
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 61
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 61
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 61
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 61
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 11:37:56] /maxxium/www/bg/brands/jura-journey.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'jura-journey'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 63
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 63
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 63
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 11:39:08] /maxxium/www/mxD7ap2Va/ 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
# [31-May-2023 11:39:21] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1685522482717 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserPass') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [31-May-2023 11:39:31] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 11:39:39] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1685522500551 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserPass') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [31-May-2023 13:46:19] /maxxium/www/bg/recipes.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'recipes' AND
	    		`URLLabel` = 'recipes'
         AND `Visible` = 1 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'
         AND `recipes`.`Visible` = 1 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'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 13:46:20] /maxxium/www/bg/ajax/cookies.html?_=1685530102013 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
# [31-May-2023 13:49:19] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 13:50:40] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 13:51:32] /maxxium/www/bg/brands/haku-vodka.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'haku-vodka'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 146
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 146
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 146
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 13:52:00] /maxxium/www/bg/recipes.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'recipes' AND
	    		`URLLabel` = 'recipes'
         AND `Visible` = 1 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'
         AND `recipes`.`Visible` = 1 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'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 14:32:56] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 14:37:10] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1685533029679 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'H66gUygZ9hsMtS6LbhIXLu73DsbzYPJSpN86g9W9TB52667Idk9Mtoq36SDd477k'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [31-May-2023 14:37:16] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1685533035248 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` = 'H66gUygZ9hsMtS6LbhIXLu73DsbzYPJSpN86g9W9TB52667Idk9Mtoq36SDd477k'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserPass') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [31-May-2023 14:42:02] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1685533321401 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '437GoHsk312Qg9R890TB492BH1n8ItB8M5yI3BFIKlcLOP2FuW76aZD329JxNY3u'
            WHERE
                `UserKey` LIKE 'w5DCucOmw53Cv8Kaw6XDo8OHw4fDosKaw5LDjMOSw6fCvcOKwr_CmcODw5c%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [31-May-2023 14:42:20] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1685533339134 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` = '437GoHsk312Qg9R890TB492BH1n8ItB8M5yI3BFIKlcLOP2FuW76aZD329JxNY3u'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserPass') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [31-May-2023 14:44:31] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1685533470594 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'WgdvXYbmqDkOI9mSJRvJ0epU3QJGbII8s7ro6MzeTDeH25M4aE9q6DfriHkuL29M'
            WHERE
                `UserKey` LIKE 'w5DCucOmw53Cv8Kaw6XDo8OHw4fDosKaw5LDjMOSw6fCvcOKwr_CmcODw5c%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [31-May-2023 14:44:43] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1685533482343 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` = 'WgdvXYbmqDkOI9mSJRvJ0epU3QJGbII8s7ro6MzeTDeH25M4aE9q6DfriHkuL29M'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 3
            LIMIT 1
# [31-May-2023 14:44:43] /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
# [31-May-2023 14:44:52] /maxxium/www/mxD7ap2Va/bg/brands/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [31-May-2023 14:44:53] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/2.html?_=1685533492593 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
                `brands`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1

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

SELECT DISTINCT TRIM(`Category`) AS `Category` FROM `brands`
# [31-May-2023 14:55:17] /maxxium/www/mxD7ap2Va/bg/brands/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [31-May-2023 14:55:23] /maxxium/www/mxD7ap2Va/bg/recipes/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
                `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
# [31-May-2023 14:55:25] /maxxium/www/mxD7ap2Va/bg/ajax/recipes/form/23.html?_=1685534124665 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
                *,
                GROUP_CONCAT(`BrandID` SEPARATOR ',') AS `Brands`
            FROM
                `recipes`
                LEFT JOIN `recipe_brands` ON `recipes`.`ID` = `recipe_brands`.`RecipeID`
            WHERE
                `ID` = 23 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `Title`
            FROM
                `brands`
            WHERE
                `ID` != 0 AND
                `ParentID` = 0
        
                ORDER BY
                    `PostDate`
# [31-May-2023 14:55:43] /maxxium/www/mxD7ap2Va/bg/ajax/recipes/form/23.html?_=1685534142680 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
                *,
                GROUP_CONCAT(`BrandID` SEPARATOR ',') AS `Brands`
            FROM
                `recipes`
                LEFT JOIN `recipe_brands` ON `recipes`.`ID` = `recipe_brands`.`RecipeID`
            WHERE
                `ID` = 23 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `Title`
            FROM
                `brands`
            WHERE
                `ID` != 0 AND
                `ParentID` = 0
        
                ORDER BY
                    `PostDate`
# [31-May-2023 15:04:31] /maxxium/www/mxD7ap2Va/bg/recipes/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
                `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
# [31-May-2023 15:04:34] /maxxium/www/mxD7ap2Va/bg/ajax/recipes/form/23.html?_=1685534673280 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
                *,
                GROUP_CONCAT(`BrandID` SEPARATOR ',') AS `Brands`
            FROM
                `recipes`
                LEFT JOIN `recipe_brands` ON `recipes`.`ID` = `recipe_brands`.`RecipeID`
            WHERE
                `ID` = 23 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `Title`
            FROM
                `brands`
            WHERE
                `ID` != 0 AND
                `ParentID` = 0
        
                ORDER BY
                    `PostDate`
# [31-May-2023 15:04:52] /maxxium/www/mxD7ap2Va/bg/ajax/recipes/update/23.html?_=1685534691262 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 `recipes` LIMIT 1

SHOW COLUMNS FROM `recipes`

UPDATE `recipes` SET `ID` = '23', `Language` = 'bg', `PostDate` = '2023-01-25 15:04:52', `LastUpdate` = '2023-05-31 15:04:52', `UploadID` = '4654359969', `VideoURL` = 'https://www.youtube.com/watch?v=j4YoYX7VSD4', `Image` = 'aperol.jpg', `Title` = 'Cinzano Pro-Spritz', `Ingredients` = '90 ml Cinzano Pro-Spritz
60 ml Aperol
30 ml Сода
', `Instructions` = 'Ако нямате Aperol Spritz чаша, вземете чаша за бяло вино, напълнете я с лед, налейте първо пенливото вино, после добавете Aperol и накрая - содата. Разбъркайте съвсем леко и гарнирайте с резен портокал.', `Glass` = '2', `Visible` = 1 WHERE `ID` = '23' AND `Language` = 'bg'

DELETE FROM `recipe_brands` WHERE `RecipeID` = '23'

INSERT INTO `recipe_brands` (`RecipeID`, `BrandID`) VALUES 
	('23', '12'),
	('23', '9'),
	('23', '3'),
	('23', '22');
# [31-May-2023 15:04:52] /maxxium/www/mxD7ap2Va/bg/recipes/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
                `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
# [31-May-2023 15:04:55] /maxxium/www/mxD7ap2Va/bg/ajax/recipes/form/23.html?_=1685534694152 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
                *,
                GROUP_CONCAT(`BrandID` SEPARATOR ',') AS `Brands`
            FROM
                `recipes`
                LEFT JOIN `recipe_brands` ON `recipes`.`ID` = `recipe_brands`.`RecipeID`
            WHERE
                `ID` = 23 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `Title`
            FROM
                `brands`
            WHERE
                `ID` != 0 AND
                `ParentID` = 0
        
                ORDER BY
                    `PostDate`
# [31-May-2023 15:04:59] /maxxium/www/mxD7ap2Va/bg/ajax/recipes/update/23.html?_=1685534698425 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 `recipes` LIMIT 1

SHOW COLUMNS FROM `recipes`

UPDATE `recipes` SET `ID` = '23', `Language` = 'bg', `PostDate` = '2023-01-25 15:04:59', `LastUpdate` = '2023-05-31 15:04:59', `UploadID` = '4654359969', `VideoURL` = 'https://www.youtube.com/watch?v=j4YoYX7VSD4', `Image` = 'aperol.jpg', `Title` = 'Cinzano Pro-Spritz', `Ingredients` = '90 ml Cinzano Pro-Spritz
60 ml Aperol
30 ml Сода
', `Instructions` = 'Ако нямате Aperol Spritz чаша, вземете чаша за бяло вино, напълнете я с лед, налейте първо пенливото вино, после добавете Aperol и накрая - содата. Разбъркайте съвсем леко и гарнирайте с резен портокал.', `Glass` = '2', `Visible` = 1 WHERE `ID` = '23' AND `Language` = 'bg'

DELETE FROM `recipe_brands` WHERE `RecipeID` = '23'

INSERT INTO `recipe_brands` (`RecipeID`, `BrandID`) VALUES 
	('23', '12'),
	('23', '9');
# [31-May-2023 15:04:59] /maxxium/www/mxD7ap2Va/bg/recipes/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
                `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
# [31-May-2023 16:08:31] /maxxium/www/bg/recipes.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'recipes' AND
	    		`URLLabel` = 'recipes'
         AND `Visible` = 1 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'
         AND `recipes`.`Visible` = 1 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'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 16:08:32] /maxxium/www/bg/ajax/cookies.html?_=1685538633826 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
# [31-May-2023 16:11:18] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 16:13:18] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 16:14:04] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 16:14:09] /maxxium/www/bg/brands/aperol.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'aperol'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 12
         AND `recipes`.`Visible` = 1 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
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 12
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 12
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 16:15:45] /maxxium/www/bg/contact-us.html 167.99.142.201

set names utf8

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 16:16:30] /maxxium/www/bg/recipes.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'recipes' AND
	    		`URLLabel` = 'recipes'
         AND `Visible` = 1 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'
         AND `recipes`.`Visible` = 1 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'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 16:18:10] /maxxium/www/bg/events/събития.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`URLLabel` = 'събития'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 16:19:01] /maxxium/www/bg/events/ритейл.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`URLLabel` = 'ритейл'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 16:19:16] /maxxium/www/bg/ajax/events/3.html?i=g-ng-2022-11-14-12-41.jpg&_=1685539277966 167.99.142.201

set names utf8

SELECT
                `UploadID`,
                `Gallery`
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 3
         AND `Visible` = 1 LIMIT 1
# [31-May-2023 16:19:27] /maxxium/www/bg/ajax/events/3.html?i=g-ng-2022-11-14-12-411.jpg&_=1685539288967 167.99.142.201

set names utf8

SELECT
                `UploadID`,
                `Gallery`
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 3
         AND `Visible` = 1 LIMIT 1
# [31-May-2023 16:22:56] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 16:23:16] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 16:23:33] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 17:05:43] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1685542064201 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'yznjW5N2tT8GYF2oh1Zwdw8EfcKIJq10yNI2EMNLm22RliT261EmFj4cuoMAGKJU'
            WHERE
                `UserKey` LIKE 'w5DCucOmw53Cv8Kaw6XDo8OHw4fDosKaw5LDjMOSw6fCvcOKwr_CmcODw5c%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [31-May-2023 17:06:00] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1685542081194 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` = 'yznjW5N2tT8GYF2oh1Zwdw8EfcKIJq10yNI2EMNLm22RliT261EmFj4cuoMAGKJU'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 3
            LIMIT 1
# [31-May-2023 17:06:00] /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
# [31-May-2023 17:07:30] /maxxium/www/mxD7ap2Va/bg/ajax/pages/form/2.html?_=1685542171341 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
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [31-May-2023 17:07:47] /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
# [31-May-2023 17:08:05] /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
# [31-May-2023 17:08:14] /maxxium/www/mxD7ap2Va/bg/ajax/pages/form/2.html?_=1685542215600 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
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [31-May-2023 17:14:26] /maxxium/www/mxD7ap2Va/bg/brands/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [31-May-2023 17:14:47] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/101.html?_=1685542608602 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
                `brands`
            WHERE
                `ID` = 101 AND
                `Language` = 'bg'
            LIMIT 1

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

SELECT DISTINCT TRIM(`Category`) AS `Category` FROM `brands`
# [31-May-2023 17:18:35] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 17:19:07] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/101.html?_=1685542867948 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 `brands` LIMIT 1

SHOW COLUMNS FROM `brands`

UPDATE `brands` SET `ID` = '101', `Language` = 'bg', `PostDate` = '2023-05-18', `LastUpdate` = '2023-05-31 17:19:07', `ParentID` = '58', `UploadID` = '4415710596', `MetaTitle` = 'Maxxium Bulgaria', `MetaDescription` = 'Maxxium Bulgaria is a leading marketing and distribution company for premium spirits & wines with more than 21 years of experience on the Bulgarian domestic market.', `MetaImage` = 'header-merken-1692x515px.jpg', `NoIndex` = 0, `HeaderImages` = '["header-merken-1692x515px1.jpg"]', `Images` = '["aftershock-blue-thumb1.png","aftershock-blue-big.png"]', `Title` = 'After Shock Blue', `URLLabel` = 'after-shock-blue', `BuyURL` = '', `Content` = '<div><p><span class="markedContent" id="page7018R_mcid3400"><span style="left: calc(var(--scale-factor)*51.54px); top: calc(var(--scale-factor)*51.23px); font-size: calc(var(--scale-factor)*9.00px); font-family: sans-serif; transform: scaleX(0.981113);" role="presentation" dir="ltr">AFTER SHOCK (Афтър Шок) е хит сред младото поколение и е най-бързо развиващият се бранд</span></span><span class="markedContent" id="page7018R_mcid3401"> <span style="left: calc(var(--scale-factor)*51.54px); top: calc(var(--scale-factor)*62.03px); font-size: calc(var(--scale-factor)*9.00px); font-family: sans-serif; transform: scaleX(1.00842);" role="presentation" dir="ltr">в категорията на шотовете. Напитка с интензивни и провокативни вкусови предложения за</span></span><span class="markedContent" id="page7018R_mcid3402"> <span style="left: calc(var(--scale-factor)*51.54px); top: calc(var(--scale-factor)*72.83px); font-size: calc(var(--scale-factor)*9.00px); font-family: sans-serif; transform: scaleX(0.99564);" role="presentation" dir="ltr">хора, търсещи емоцията. Изключително разпознаваем с ярките си цветове и атрактивните</span></span><span class="markedContent" id="page7018R_mcid3403"> <span style="left: calc(var(--scale-factor)*51.54px); top: calc(var(--scale-factor)*83.63px); font-size: calc(var(--scale-factor)*9.00px); font-family: sans-serif; transform: scaleX(1.00021);" role="presentation" dir="ltr">ритуали на консумация в нощните заведения. After Shock, във всичките си версии, сам по себе</span></span><span class="markedContent" id="page7018R_mcid3404"> <span style="left: calc(var(--scale-factor)*51.54px); top: calc(var(--scale-factor)*94.43px); font-size: calc(var(--scale-factor)*9.00px); font-family: sans-serif; transform: scaleX(0.996969);" role="presentation" dir="ltr">си е категория, която е задължителна за всеки бар.</span></span></p><p><span class="markedContent" id="page7018R_mcid3404"><span style="left: calc(var(--scale-factor)*51.54px); top: calc(var(--scale-factor)*94.43px); font-size: calc(var(--scale-factor)*9.00px); font-family: sans-serif; transform: scaleX(0.996969);" role="presentation" dir="ltr"></span></span></p><p><span class="markedContent" id="page7018R_mcid3393"><span style="left: calc(var(--scale-factor)*62.36px); top: calc(var(--scale-factor)*537.81px); font-size: calc(var(--scale-factor)*10.00px); font-family: sans-serif; transform: scaleX(0.972102);" role="presentation" dir="ltr">С вкус на цитруси</span></span></p></div>', `BrandName` = 'AFTER SHOCK BLUE', `Category` = 'Ликьор', `Origin` = '', `Alcohol` = 30, `Served` = '', `Package` = '', `WebSite` = 'www.beamsuntory.com', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '101' AND `Language` = 'bg'
# [31-May-2023 17:19:07] /maxxium/www/mxD7ap2Va/bg/brands/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [31-May-2023 17:19:50] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/24.html?_=1685542911434 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
                `brands`
            WHERE
                `ID` = 24 AND
                `Language` = 'bg'
            LIMIT 1

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

SELECT DISTINCT TRIM(`Category`) AS `Category` FROM `brands`
# [31-May-2023 17:20:12] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/24.html?_=1685542933786 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 `brands` LIMIT 1

SHOW COLUMNS FROM `brands`

UPDATE `brands` SET `ID` = '24', `Language` = 'bg', `PostDate` = '2023-02-09', `LastUpdate` = '2023-05-31 17:20:12', `ParentID` = 0, `UploadID` = '5949166512', `MetaTitle` = 'Maxxium - Bulgaria', `MetaDescription` = 'Maxxium - Bulgaria', `MetaImage` = 'header-merken-1692x515px1.jpg', `NoIndex` = 0, `HeaderImages` = '["header-merken-1692x515px.jpg"]', `Images` = '["hibiki-thumb1.png","hibiki-big.png"]', `Title` = 'Hibiki ', `URLLabel` = 'hibiki-japanese-harmony', `BuyURL` = '', `Content` = '<p></p><p style="margin-top:4.5pt;margin-right:0cm;margin-bottom:4.5pt;margin-left:
0cm;line-height:18.0pt"><span style="font-size:13.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;
color:black">Hibiki Japanese Harmony е <span style="color:var(--gray)">японско
смесено (blended) уиски, </span><span style="color:var(--gray)">произведено
в най-старата </span><span style="color:var(--gray)">дестилерия в Япония –
Yamazaki </span><span style="color:var(--gray)">(осн. 1923 г.). В бленда
участват </span></span><span style="color: black; font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt;">повече от 10 малцови и зърнени </span><span style="font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt; color: var(--gray);">уискита,
които създават комплекс </span><span style="font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt; color: var(--gray);">от вкусове
и аромати. Отлежава </span><span style="font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt; color: var(--gray);">в 5 различни
вида бъчви от </span><span style="font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt; color: var(--gray);">дестилериите
Yamazaki, Hakushu </span><span style="font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt; color: var(--gray);">и Chita.
Резултатът е деликатен </span><span style="font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt; color: var(--gray);">хармоничен
вкус, който е </span><span style="font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt; color: var(--gray);">едновременно фин и
комплексен. </span><span style="font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt; color: var(--gray);">Бутилката е
изключително </span><span style="font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt; color: var(--gray);">красива – гарафа с 24
фасети, </span><span style="color: black; font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt;">които изобразяват 24-те месеца в </span><span style="font-family: Arial, &quot;sans-serif&quot;; font-size: 13.5pt; color: var(--gray);">японския
календар.</span></p><br><p></p>', `BrandName` = 'Hibiki Japanese Harmony', `Category` = 'Уиски', `Origin` = 'Япония', `Alcohol` = 43, `Served` = '', `Package` = '', `WebSite` = '', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '24' AND `Language` = 'bg'
# [31-May-2023 17:20:12] /maxxium/www/mxD7ap2Va/bg/brands/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [31-May-2023 17:20:17] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 17:20:22] /maxxium/www/bg/brands/hibiki-japanese-harmony.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'hibiki-japanese-harmony'
         AND `Visible` = 1 LIMIT 1
# [31-May-2023 17:20:22] /maxxium/www/bg/brands/hibiki-japanese-harmony.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'hibiki-japanese-harmony'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 24
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 24
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 24
         AND `Visible` = 1 LIMIT 1

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 24
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 24
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 24
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 17:20:47] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 17:21:00] /maxxium/www/bg/brands/tamnavulin.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'tamnavulin'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 1
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 1
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 17:21:07] /maxxium/www/bg/brands/tamnavulin-pinot-noir.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'tamnavulin-pinot-noir'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 88
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 1
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    (`ParentID` = 1 OR `ID` = 1) AND
                    `ID` != 88
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 17:21:32] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/10.html?_=1685543012938 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
                `brands`
            WHERE
                `ID` = 10 AND
                `Language` = 'bg'
            LIMIT 1

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

SELECT DISTINCT TRIM(`Category`) AS `Category` FROM `brands`
# [31-May-2023 17:21:39] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 17:22:05] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/10.html?_=1685543046309 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 `brands` LIMIT 1

SHOW COLUMNS FROM `brands`

UPDATE `brands` SET `ID` = '10', `Language` = 'bg', `PostDate` = '2023-02-08', `LastUpdate` = '2023-05-31 17:22:05', `ParentID` = 0, `UploadID` = '5860998199', `MetaTitle` = 'Freixenet Cordon Negro Brut', `MetaDescription` = 'Freixenet Cordon Negro Brut', `MetaImage` = 'freixenet-black-big.png', `NoIndex` = 0, `HeaderImages` = '["header-merken-1692x515px.jpg"]', `Images` = '["freixenet-black-thumb.png","freixenet-black-big1.png"]', `Title` = 'Freixenet', `URLLabel` = 'freixenet-cordon-negro-brut', `BuyURL` = '', `Content` = '<div><p>Испанско пенливо вино кава. Бледожълт цвят и плодови аромати. Изкусен придружител на всяко ястие. Купаж е между сортовете макабеу, ксарело и пареяда.  Отлежава между 12-18 месеца.</p></div>', `BrandName` = 'Freixenet Cordon Negro Brut', `Category` = 'Пенливо вино', `Origin` = 'Испания', `Alcohol` = 11.5, `Served` = '', `Package` = '0,75L', `WebSite` = 'https://www.freixenet.com/', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 1 WHERE `ID` = '10' AND `Language` = 'bg'
# [31-May-2023 17:22:05] /maxxium/www/mxD7ap2Va/bg/brands/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [31-May-2023 17:22:10] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 17:22:39] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/2.html?_=1685543080229 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
                `brands`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1

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

SELECT DISTINCT TRIM(`Category`) AS `Category` FROM `brands`
# [31-May-2023 17:23:03] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/2.html?_=1685543103901 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 `brands` LIMIT 1

SHOW COLUMNS FROM `brands`

UPDATE `brands` SET `ID` = '2', `Language` = 'bg', `PostDate` = '2023-01-06', `LastUpdate` = '2023-05-31 17:23:03', `ParentID` = 0, `UploadID` = '3015214420', `MetaTitle` = 'Maxxium - Bulgaria', `MetaDescription` = 'Мета описание', `MetaImage` = 'jimbeam-front2.png', `NoIndex` = 0, `HeaderImages` = '["header-merken-1692x515px.jpg"]', `Images` = '["jimbeam-front3.png","jimbeam-1l.jpg"]', `Title` = 'Jim Beam White Bourbon', `URLLabel` = 'jim-beam-white-bourbon', `BuyURL` = 'https://maxgraphic.bg', `Content` = '<p>Създаден за споделяне от 1795 г.</p><p>Kentucky Straight бърбън уиски. Създадено</p><p>през 1795 г. Най-продаваният бърбън в света.</p><p>Отлежава 4 години, или 2 пъти повече, отколкото</p><p>законът изисква. Притежава богат вкус с нотки</p><p>на карамел и аромат на ванилия и мед.</p>', `BrandName` = 'Jim Beam White Bourbon', `Category` = 'Уиски', `Origin` = 'САЩ', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = 'https://www.jimbeam.com', `Social` = 'https://facebook.com
https://youtube.com', `Documents` = '["25117-2022-12-20-contract.pdf"]', `ProductLink` = 'https://www.jimbeam.com', `Visible` = 1, `FirstPage` = 1 WHERE `ID` = '2' AND `Language` = 'bg'
# [31-May-2023 17:23:03] /maxxium/www/mxD7ap2Va/bg/brands/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [31-May-2023 17:23:28] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/34.html?_=1685543129084 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
                `brands`
            WHERE
                `ID` = 34 AND
                `Language` = 'bg'
            LIMIT 1

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

SELECT DISTINCT TRIM(`Category`) AS `Category` FROM `brands`
# [31-May-2023 17:23:42] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/34.html?_=1685543142891 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 `brands` LIMIT 1

SHOW COLUMNS FROM `brands`

UPDATE `brands` SET `ID` = '34', `Language` = 'bg', `PostDate` = '2023-02-10', `LastUpdate` = '2023-05-31 17:23:42', `ParentID` = 0, `UploadID` = '6026832529', `MetaTitle` = 'Maxxium - Bulgaria', `MetaDescription` = '', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["header-merken-1692x515px.jpg"]', `Images` = '["auchentoshan-thumb.png","auchentoshan-big.png"]', `Title` = 'Auchentoshan', `URLLabel` = 'auchentoshan-american-oak', `BuyURL` = '', `Content` = '<p>AUCHENTOSHAN (О-хин-тошън) е тройно <span style="color: var(--gray);">дестилирано шотландско едномалцово (single </span><span style="color: var(--gray);">malt) уиски. В света има само две дестилерии, </span><span style="color: var(--gray);">които използват метода на тройната дестилация при </span><span style="color: var(--gray);">производството на шотландско уиски, и едната от тях е </span><span style="color: var(--gray);">именно Auchentoshan. Тройната дестилация придава на</span></p><p>Auchentoshan много мек и деликатен вкус със сладки <span style="color: var(--gray);">и плодови нотки.</span></p><p>Тройно дестилирано едномалцово (single malt) уиски от региона Лоулендс (Lowlands),  отлежало единствено в ексбърбън бъчви. Резултатът е фина и богата вкусова палитра със сладки аромати на ванилия и кокос<br></p>', `BrandName` = 'Auchentoshan American Oak Single Malt Scotch Whisky', `Category` = 'Сингъл малц', `Origin` = 'Шотландия', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = '', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 1 WHERE `ID` = '34' AND `Language` = 'bg'
# [31-May-2023 17:23:42] /maxxium/www/mxD7ap2Va/bg/brands/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
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [31-May-2023 17:23:52] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 17:23:56] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 21:52:28] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 21:52:30] /maxxium/www/bg/recipes.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'recipes' AND
	    		`URLLabel` = 'recipes'
         AND `Visible` = 1 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'
         AND `recipes`.`Visible` = 1 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'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 21:52:34] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 21:52:36] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 21:52:38] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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
# [31-May-2023 21:52:54] /maxxium/www/bg/brands/courvoisier-vsop.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'courvoisier-vsop'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 131
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 131
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 131
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 21:53:04] /maxxium/www/bg/brands/fettercairn-12yo.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'fettercairn-12yo'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 65
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 65
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 65
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 21:53:11] /maxxium/www/bg/brands/dalmore-12-yo.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'dalmore-12-yo'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 61
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 61
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 61
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 21:53:38] /maxxium/www/bg/brands/the-dalmore-30yo.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'the-dalmore-30yo'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	`recipes`.*
	        FROM
	        	`recipes`
                INNER JOIN `recipe_brands` ON `recipe_brands`.`RecipeID` = `recipes`.`ID`
	    	WHERE
                `recipes`.`Language` = 'bg' AND
                `recipe_brands`.`BrandID` = 114
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

SELECT
                `Title`
            FROM
                `brands`
            WHERE
                `Language` = 'bg' AND
                `ID` = 114
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 114
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 21:53:44] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewBrands') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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
# [31-May-2023 21:54:00] /maxxium/www/bg/events/събития.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`URLLabel` = 'събития'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 21:54:05] /maxxium/www/bg/events/трейд.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`URLLabel` = 'трейд'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [31-May-2023 21:54:09] /maxxium/www/bg/events/ритейл.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`URLLabel` = 'ритейл'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
