# [29-Aug-2023 10:30:26] /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
# [29-Aug-2023 10:30:26] /maxxium/www/mxD7ap2Va/bg/ajax/users/form/login.html?_=1693294405764 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
# [29-Aug-2023 10:30:30] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1693294409609 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

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'aMdng43M6222b4BE7XYdT4ujUZMwX2bljnhynKwQJc243n0xjv8P07EKrA5SkqyY'
            WHERE
                `UserKey` LIKE 'w5DCucOmw53Cv8Kaw6XDo8OHw4fDosKaw5LDjMOSw6fCvcOKwr_CmcODw5c%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [29-Aug-2023 10:30:38] /maxxium/www/mxD7ap2Va/bg/ajax/users/login.html?_=1693294417606 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`,
                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` = 'aMdng43M6222b4BE7XYdT4ujUZMwX2bljnhynKwQJc243n0xjv8P07EKrA5SkqyY'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 3
            LIMIT 1
# [29-Aug-2023 10:30:38] /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
# [29-Aug-2023 10:30:49] /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
# [29-Aug-2023 10:30:50] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 10:30:50] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 10:30:50] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 10:31:02] /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 `TOP`.`Category`,
                GROUP_CONCAT(DISTINCT `SUB`.`SubCategory` SEPARATOR '|') AS `SubCategories`
            FROM
                `brands` AS `TOP`
                LEFT JOIN `brands` AS `SUB` ON `TOP`.`Category` = `SUB`.`Category`
            WHERE
                `TOP`.`Language` = 'bg'
         AND `TOP`.`Visible` = 1
            GROUP BY
                `TOP`.`ID`
            ORDER BY
                `TOP`.`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
# [29-Aug-2023 10:31:42] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 10:31:42] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 10:31:42] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:36:01] /maxxium/www/bg/brands/aftershock-red.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'aftershock-red'
         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` = 58
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:36:01] /maxxium/www/uf/events/751416607/ 167.99.142.201
# [29-Aug-2023 12:36:01] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:36:01] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:37:16] /maxxium/www/bg/brands/after-shock-blue.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'after-shock-blue'
         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` = 101
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:37:16] /maxxium/www/uf/events/751416607/ 167.99.142.201
# [29-Aug-2023 12:37:16] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [29-Aug-2023 12:37:16] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

set names utf8

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

set names utf8

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
# [29-Aug-2023 12:38:56] /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
# [29-Aug-2023 12:38:58] /maxxium/www/uf/events/751416607/ 167.99.142.201
# [29-Aug-2023 12:38:58] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 12:38:58] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

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

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:44:43] /maxxium/www/bg/brands/appleton-estate.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'appleton-estate'
         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` = 5
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:44:43] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:44:43] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 12:44:43] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:46:10] /maxxium/www/bg/brands/appleton-reserve.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'appleton-reserve'
         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` = 52
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:46:10] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [29-Aug-2023 12:46:10] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8
# [29-Aug-2023 12:46:10] /maxxium/www/uf/events/1114268192/ 167.99.142.201

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

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:47:57] /maxxium/www/bg/brands/appleton-signature.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'appleton-signature'
         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` = 53
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:47:57] /maxxium/www/uf/events/751416607/ 167.99.142.201
# [29-Aug-2023 12:47:57] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 12:47:57] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

set names utf8

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

set names utf8

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
# [29-Aug-2023 12:48:34] /maxxium/www/bg/brands/auchentoshan-american-oak.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'auchentoshan-american-oak'
         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` = 34
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:48:34] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:48:34] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 12:48:34] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:49:37] /maxxium/www/bg/brands/auchentoshan-12y.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'auchentoshan-12y'
         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` = 57
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:49:38] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:49:38] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [29-Aug-2023 12:49:38] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:55:41] /maxxium/www/bg/brands/bakers.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'bakers'
         AND `Visible` = 1 LIMIT 1
# [29-Aug-2023 12:55:41] /maxxium/www/bg/brands/bakers.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'bakers'
         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` = 36
         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` = 36
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:55:41] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:55:41] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 12:55:41] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

set names utf8

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
# [29-Aug-2023 12:55:47] /maxxium/www/bg/brands/bols-yoghurt-liqueur.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'bols-yoghurt-liqueur'
         AND `Visible` = 1 LIMIT 1
# [29-Aug-2023 12:55:47] /maxxium/www/bg/brands/bols-yoghurt-liqueur.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'bols-yoghurt-liqueur'
         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` = 30
         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` = 30
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

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

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 30
             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
# [29-Aug-2023 12:55:48] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 12:55:48] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [29-Aug-2023 12:55:48] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:01:00] /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
# [29-Aug-2023 13:01:07] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=bols 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'
                 AND `Title` LIKE '%bols%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'bols%' THEN 0
                        WHEN `Title` LIKE '% bols%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:08:56] /maxxium/www/bg/brands/bowmore.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'bowmore'
         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` = 60
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:08:56] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 13:08:56] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:08:56] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:10:00] /maxxium/www/bg/brands/campari.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'campari'
         AND `Visible` = 1 LIMIT 1
# [29-Aug-2023 13:10:00] /maxxium/www/bg/brands/campari.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'campari'
         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` = 11
         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` = 11
         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
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 11
             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` = 11
         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` = 11
         AND `Visible` = 1 LIMIT 1

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:10:03] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [29-Aug-2023 13:10:03] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 13:10:03] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

set names utf8

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:11:34] /maxxium/www/bg/brands/cinzano-to-spritz.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'cinzano-to-spritz'
         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` = 9
         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` = 9
         AND `Visible` = 1 LIMIT 1

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:11:38] /maxxium/www/bg/brands/cenote-anejo-tequila.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'cenote-anejo-tequila'
         AND `Visible` = 1 LIMIT 1
# [29-Aug-2023 13:11:38] /maxxium/www/bg/brands/cenote-anejo-tequila.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'cenote-anejo-tequila'
         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` = 176
         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` = 176
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:11:39] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:11:39] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 13:11:39] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:15:10] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=chita 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'
                 AND `Title` LIKE '%chita%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'chita%' THEN 0
                        WHEN `Title` LIKE '% chita%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:15:14] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/23.html?_=1693304292896 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` = 23 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [29-Aug-2023 13:19:26] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/23.html?keyword=The Chita&_=1693304544997 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' AND
	    		`URLLabel` = 'select'
         LIMIT 1
# [29-Aug-2023 13:19:42] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/23.html?_=1693304561052 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` = '23', `Language` = 'bg', `PostDate` = '2023-02-09', `LastUpdate` = '2023-08-29 13:19:42', `ParentID` = 0, `UploadID` = '5949116382', `MetaTitle` = 'The Chita', `MetaDescription` = 'The Chita', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["header-1692-x-515-chita.jpg"]', `Images` = '["chita-147x450px.png","chita-big.png"]', `Title` = 'The Chita', `URLLabel` = 'chita', `BuyURL` = '', `Content` = '<p>През 1972 г. Кейдзо Саджи, вторият Мастър блендер на Suntory, прави важна стъпка в усъвършенстването на японските зърнени уискита, благословени от богатствата на японската природа и майсторство. На мъгливите и спокойни брегове на полуостров Чита, Кейдзо построява дестилерия за създаването на висококачествено японско зърнено уиски. За да се придаде по-голяма комплексност и дълбочина на вкуса, уискито Chita отлежава в испански винени бъчви и в американски бъчви от бял дъб.<br></p><p>Резултатът е по-леко и нежно зърнено уиски с неповторима изисканост и чист финал. Шинджи Фукуйо описва CHITA като „спокойствието на японското уиски”. Подобно на спокойните морски води на полуостров Чита в ден на хармонична тишина, това ефирно уиски излъчва безпогрешно спокоен дух.<br></p>', `BrandName` = 'The Chita Single Grain Japanese Whisky', `Category` = 'Whisky', `SubCategory` = 'Japanese Malt Whisky', `Origin` = 'Япония', `Alcohol` = 43, `Served` = '', `Package` = '', `WebSite` = 'www.suntory.com/brands/chitawhisky', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '23' AND `Language` = 'bg'
# [29-Aug-2023 13:19:42] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=chita 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'
                 AND `Title` LIKE '%chita%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'chita%' THEN 0
                        WHEN `Title` LIKE '% chita%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:19: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 `TOP`.`Category`,
                GROUP_CONCAT(DISTINCT `SUB`.`SubCategory` SEPARATOR '|') AS `SubCategories`
            FROM
                `brands` AS `TOP`
                LEFT JOIN `brands` AS `SUB` ON `TOP`.`Category` = `SUB`.`Category`
            WHERE
                `TOP`.`Language` = 'bg'
         AND `TOP`.`Visible` = 1
            GROUP BY
                `TOP`.`ID`
            ORDER BY
                `TOP`.`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
# [29-Aug-2023 13:19:58] /maxxium/www/bg/brands/cinzano-to-spritz.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'cinzano-to-spritz'
         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` = 9
         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` = 9
         AND `Visible` = 1 LIMIT 1

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:20:02] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [29-Aug-2023 13:20:02] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 13:20:02] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

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

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:24:51] /maxxium/www/bg/brands/cinzano-to-spritz.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'cinzano-to-spritz'
         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` = 9
         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` = 9
         AND `Visible` = 1 LIMIT 1

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:24:53] /maxxium/www/uf/events/751416607/ 167.99.142.201
# [29-Aug-2023 13:24:53] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:24:53] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:24:55] /maxxium/www/bg/brands/cinzano-rose.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'cinzano-rose'
         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` = 49
         AND `recipes`.`Visible` = 1 ORDER BY `recipes`.`PostDate` ASC

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:24:56] /maxxium/www/uf/events/751416607/ 167.99.142.201
# [29-Aug-2023 13:24:56] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 13:24:56] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:26:42] /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
# [29-Aug-2023 13:26:42] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [29-Aug-2023 13:26:42] /maxxium/www/uf/events/751416607/ 167.99.142.201
# [29-Aug-2023 13:26:42] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:28:14] /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
# [29-Aug-2023 13:28:14] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:28:14] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 13:28:14] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:28:38] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=dalmore 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'
                 AND `Title` LIKE '%dalmore%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'dalmore%' THEN 0
                        WHEN `Title` LIKE '% dalmore%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:28:43] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/61.html?_=1693305101707 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` = 61 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [29-Aug-2023 13:29:10] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/61.html?_=1693305128768 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` = '61', `Language` = 'bg', `PostDate` = '2023-04-07', `LastUpdate` = '2023-08-29 13:29:10', `ParentID` = 0, `UploadID` = '848756568', `MetaTitle` = 'The Dalmore', `MetaDescription` = 'The Dalmore', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["header-1692-x-515-dalmore1.jpg"]', `Images` = '["dalmore12-thumb1.png","dalmore12-big.png"]', `Title` = 'The Dalmore ', `URLLabel` = 'dalmore-12-yo', `BuyURL` = '', `Content` = '<p>THE DALMORE е легендарно шотландско едномалцово (single malt) уиски от регион Хайлендс (Highlands). <span style="color: var(--gray);">Дестилерията е основана през 1839 г. близо до езерото Лох Мори и до 1945 г. се управлява от семейство </span><span style="color: var(--gray);">Маккензи. Dalmore винаги е била една от най-популярните и луксозни марки едномалцов скоч.</span></p><p>Достигнала съвършенство през последния век и половинa, технологията на създаването му се крепи <span style="color: var(--gray);">на четири фундамента. Това са уникалният процес на дестилация, съзряването в най-добрите бъчви, </span><span style="color: var(--gray);">смесването на партидите от ексцентричния, но и сърцат перфекционист Ричард Патерсън и не на</span></p><p>последно място – финалното отлежаване в специални, ръчно подбрани бъчви, в които са се съхранявали <span style="color: var(--gray);">едни от най-скъпите напитки в света.</span></p><p>The Dalmore 12 YO o<span style="color: var(--gray);">тлежава минимум 12 години. </span><span style="color: var(--gray);">Първите 9 години – в бъчви от </span><span style="color: var(--gray);">американски бял дъб, съхранявал </span><span style="color: var(--gray);">преди това бърбън. След това течността </span><span style="color: var(--gray);">се разделя на две. Едната част остава </span><span style="color: var(--gray);">за следващите 3 години в ексбърбън </span><span style="color: var(--gray);">бъчви, а другата половина се прехвърля </span><span style="color: var(--gray);">в бъчви, съхранявали шери Matusalem </span><span style="color: var(--gray);">Оloroso в продължение на минимум 30 </span><span style="color: var(--gray);">години.</span></p><p><span style="color: var(--gray);"><br></span></p>', `BrandName` = 'The Dalmore 12 YO Single Malt Scotch Whisky', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = 'www.thedalmore.com', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 1 WHERE `ID` = '61' AND `Language` = 'bg'
# [29-Aug-2023 13:29:10] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=dalmore 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'
                 AND `Title` LIKE '%dalmore%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'dalmore%' THEN 0
                        WHEN `Title` LIKE '% dalmore%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:29:17] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/80.html?_=1693305135927 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` = 80 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [29-Aug-2023 13:29:43] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/80.html?_=1693305162114 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` = '80', `Language` = 'bg', `PostDate` = '2023-04-07', `LastUpdate` = '2023-08-29 13:29:43', `ParentID` = '61', `UploadID` = '854121684', `MetaTitle` = 'Maxxium - Bulgaria', `MetaDescription` = 'Maxxium - Bulgaria', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["header-1692-x-515-dalmore.jpg"]', `Images` = '["dalmore15-thumb1.png","dalmore15-big.png"]', `Title` = 'The Dalmore 15YO Single Malt Scotch Whisky', `URLLabel` = 'dalmore-15yo', `BuyURL` = '', `Content` = '<p>Отлежава минимум 15 години <span style="color: var(--gray);">в ексбърбън бъчви и 3 вида </span><span style="color: var(--gray);">бъчви от шери – Matusalem </span><span style="color: var(--gray);">Oloroso, Apostoles и Amoroso</span></p>', `BrandName` = 'Dalmore 15YO Single Malt Scotch Whisky', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = 'www.thedalmore.com', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '80' AND `Language` = 'bg'
# [29-Aug-2023 13:29:43] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=dalmore 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'
                 AND `Title` LIKE '%dalmore%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'dalmore%' THEN 0
                        WHEN `Title` LIKE '% dalmore%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:29:50] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/80.html?_=1693305168986 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` = 80 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [29-Aug-2023 13:30:13] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/80.html?_=1693305192378 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` = '80', `Language` = 'bg', `PostDate` = '2023-04-07', `LastUpdate` = '2023-08-29 13:30:13', `ParentID` = '61', `UploadID` = '854121684', `MetaTitle` = 'The Dalmore', `MetaDescription` = 'The Dalmore', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["header-1692-x-515-dalmore.jpg"]', `Images` = '["dalmore15-thumb1.png","dalmore15-big.png"]', `Title` = 'The Dalmore 15YO Single Malt Scotch Whisky', `URLLabel` = 'dalmore-15yo', `BuyURL` = '', `Content` = '<p>Отлежава минимум 15 години <span style="color: var(--gray);">в ексбърбън бъчви и 3 вида </span><span style="color: var(--gray);">бъчви от шери – Matusalem </span><span style="color: var(--gray);">Oloroso, Apostoles и Amoroso</span></p>', `BrandName` = 'The Dalmore 15YO Single Malt Scotch Whisky', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = 'www.thedalmore.com', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '80' AND `Language` = 'bg'
# [29-Aug-2023 13:30:13] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=dalmore 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'
                 AND `Title` LIKE '%dalmore%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'dalmore%' THEN 0
                        WHEN `Title` LIKE '% dalmore%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:30: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 `TOP`.`Category`,
                GROUP_CONCAT(DISTINCT `SUB`.`SubCategory` SEPARATOR '|') AS `SubCategories`
            FROM
                `brands` AS `TOP`
                LEFT JOIN `brands` AS `SUB` ON `TOP`.`Category` = `SUB`.`Category`
            WHERE
                `TOP`.`Language` = 'bg'
         AND `TOP`.`Visible` = 1
            GROUP BY
                `TOP`.`ID`
            ORDER BY
                `TOP`.`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
# [29-Aug-2023 13:30:26] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 13:30:26] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [29-Aug-2023 13:30:26] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:30:39] /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
# [29-Aug-2023 13:30:40] /maxxium/www/uf/events/751416607/ 167.99.142.201
# [29-Aug-2023 13:30:40] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:30:40] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

set names utf8

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
# [29-Aug-2023 13:32:03] /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
# [29-Aug-2023 13:32:03] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:32:03] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [29-Aug-2023 13:32:03] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:32:08] /maxxium/www/bg/brands/dalmore-15yo.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'dalmore-15yo'
         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` = 80
         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 OR `ID` = 61) AND
                    `ID` != 80
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:32:08] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 13:32:08] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:32:08] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:32:14] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/61.html?_=1693305313478 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` = 61 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [29-Aug-2023 13:32:26] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/61.html?_=1693305325358 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` = '61', `Language` = 'bg', `PostDate` = '2023-04-07', `LastUpdate` = '2023-08-29 13:32:26', `ParentID` = 0, `UploadID` = '848756568', `MetaTitle` = 'The Dalmore', `MetaDescription` = 'The Dalmore', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["header-1692-x-515-dalmore1.jpg"]', `Images` = '["dalmore12-thumb1.png","dalmore12-big.png"]', `Title` = 'The Dalmore ', `URLLabel` = 'dalmore-12-yo', `BuyURL` = '', `Content` = '<p>THE DALMORE е легендарно шотландско едномалцово (single malt) уиски от регион Хайлендс (Highlands). <span style="color: var(--gray);">Дестилерията е основана през 1839 г. близо до езерото Лох Мори и до 1945 г. се управлява от семейство </span><span style="color: var(--gray);">Маккензи. Dalmore винаги е била една от най-популярните и луксозни марки едномалцов скоч.</span></p><p>Достигнала съвършенство през последния век и половинa, технологията на създаването му се крепи <span style="color: var(--gray);">на четири фундамента. Това са уникалният процес на дестилация, съзряването в най-добрите бъчви, </span><span style="color: var(--gray);">смесването на партидите от ексцентричния, но и сърцат перфекционист Ричард Патерсън и не на</span></p><p>последно място – финалното отлежаване в специални, ръчно подбрани бъчви, в които са се съхранявали <span style="color: var(--gray);">едни от най-скъпите напитки в света.</span></p><p>The Dalmore 12 YO o<span style="color: var(--gray);">тлежава минимум 12 години. </span><span style="color: var(--gray);">Първите 9 години – в бъчви от </span><span style="color: var(--gray);">американски бял дъб, съхранявал </span><span style="color: var(--gray);">преди това бърбън. След това течността </span><span style="color: var(--gray);">се разделя на две. Едната част остава </span><span style="color: var(--gray);">за следващите 3 години в ексбърбън </span><span style="color: var(--gray);">бъчви, а другата половина се прехвърля </span><span style="color: var(--gray);">в бъчви, съхранявали шери Matusalem </span><span style="color: var(--gray);">Оloroso в продължение на минимум 30 </span><span style="color: var(--gray);">години.</span></p><p><span style="color: var(--gray);"><br></span></p>', `BrandName` = 'The Dalmore 12 YO Single Malt Scotch Whisky', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = 'www.thedalmore.com', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 1 WHERE `ID` = '61' AND `Language` = 'bg'
# [29-Aug-2023 13:32:26] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=dalmore 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'
                 AND `Title` LIKE '%dalmore%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'dalmore%' THEN 0
                        WHEN `Title` LIKE '% dalmore%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:32:38] /maxxium/www/bg/brands/dalmore-cigar-malt.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'dalmore-cigar-malt'
         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` = 82
         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 OR `ID` = 61) AND
                    `ID` != 82
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:32:38] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:32:38] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:32:38] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:32:44] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/61.html?_=1693305342673 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` = 61 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [29-Aug-2023 13:33:06] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/61.html?keyword=The Dalmore&_=1693305365048 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' AND
	    		`URLLabel` = 'select'
         LIMIT 1
# [29-Aug-2023 13:33:25] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/61.html?_=1693305384325 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` = '61', `Language` = 'bg', `PostDate` = '2023-04-07', `LastUpdate` = '2023-08-29 13:33:25', `ParentID` = 0, `UploadID` = '848756568', `MetaTitle` = 'The Dalmore', `MetaDescription` = 'The Dalmore', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["header-1692-x-515-dalmore1.jpg"]', `Images` = '["dalmore12-thumb1.png","dalmore12-big.png"]', `Title` = 'The Dalmore Cigar Malt', `URLLabel` = 'dalmore-12-yo', `BuyURL` = '', `Content` = '<p>THE DALMORE е легендарно шотландско едномалцово (single malt) уиски от регион Хайлендс (Highlands). <span style="color: var(--gray);">Дестилерията е основана през 1839 г. близо до езерото Лох Мори и до 1945 г. се управлява от семейство </span><span style="color: var(--gray);">Маккензи. Dalmore винаги е била една от най-популярните и луксозни марки едномалцов скоч.</span></p><p>Достигнала съвършенство през последния век и половинa, технологията на създаването му се крепи <span style="color: var(--gray);">на четири фундамента. Това са уникалният процес на дестилация, съзряването в най-добрите бъчви, </span><span style="color: var(--gray);">смесването на партидите от ексцентричния, но и сърцат перфекционист Ричард Патерсън и не на</span></p><p>последно място – финалното отлежаване в специални, ръчно подбрани бъчви, в които са се съхранявали <span style="color: var(--gray);">едни от най-скъпите напитки в света.</span></p><p>The Dalmore 12 YO o<span style="color: var(--gray);">тлежава минимум 12 години. </span><span style="color: var(--gray);">Първите 9 години – в бъчви от </span><span style="color: var(--gray);">американски бял дъб, съхранявал </span><span style="color: var(--gray);">преди това бърбън. След това течността </span><span style="color: var(--gray);">се разделя на две. Едната част остава </span><span style="color: var(--gray);">за следващите 3 години в ексбърбън </span><span style="color: var(--gray);">бъчви, а другата половина се прехвърля </span><span style="color: var(--gray);">в бъчви, съхранявали шери Matusalem </span><span style="color: var(--gray);">Оloroso в продължение на минимум 30 </span><span style="color: var(--gray);">години.</span></p><p><span style="color: var(--gray);"><br></span></p>', `BrandName` = 'The Dalmore 12 YO Single Malt Scotch Whisky', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = 'www.thedalmore.com', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 1 WHERE `ID` = '61' AND `Language` = 'bg'
# [29-Aug-2023 13:33:25] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=dalmore 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'
                 AND `Title` LIKE '%dalmore%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'dalmore%' THEN 0
                        WHEN `Title` LIKE '% dalmore%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:33:31] /maxxium/www/bg/brands/dalmore-cigar-malt.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'dalmore-cigar-malt'
         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` = 82
         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 OR `ID` = 61) AND
                    `ID` != 82
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:33:31] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:33:31] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:33:31] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:33:37] /maxxium/www/bg/brands/dalmore-cigar-malt.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'dalmore-cigar-malt'
         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` = 82
         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 OR `ID` = 61) AND
                    `ID` != 82
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:33:38] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:33:38] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 13:33:38] /maxxium/www/uf/events/1114311358/ 167.99.142.201

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:33:44] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/82.html?_=1693305402871 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` = 82 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [29-Aug-2023 13:33:53] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/82.html?keyword=The Dalmore&_=1693305411754 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' AND
	    		`URLLabel` = 'select'
         LIMIT 1
# [29-Aug-2023 13:34:47] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/82.html?_=1693305466458 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` = '82', `Language` = 'bg', `PostDate` = '2023-04-07', `LastUpdate` = '2023-08-29 13:34:47', `ParentID` = '61', `UploadID` = '854332541', `MetaTitle` = 'The Dalmore ', `MetaDescription` = 'The Dalmore ', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["header-1692-x-515-dalmore.jpg"]', `Images` = '["dalmore-cigar-thumb1.png","dalmore-cigar-big.png"]', `Title` = 'The Dalmore Cigar Malt', `URLLabel` = 'dalmore-cigar-malt', `BuyURL` = 'https://drinks-shop.bg/product/dalmore-cigar-malt', `Content` = '<p>The Dalmore Cigar Malt Reserve е уиски, <span style="color: var(--gray);">създадено от легендарния Ричард Патерсън </span><span style="color: var(--gray);">като перфектната комбинация с пура. </span><span style="color: var(--gray);">Отлежава в бъчви от Matusalem Oloroso,</span><span style="color: var(--gray);">Марсала, Мадейра, Каберне Совиньон и </span><span style="color: var(--gray);">американски бърбън</span></p>', `BrandName` = 'The Dalmore Cigar Malt Scotch Whisky ', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 44, `Served` = '', `Package` = '', `WebSite` = '', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '82' AND `Language` = 'bg'
# [29-Aug-2023 13:34:47] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=dalmore 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'
                 AND `Title` LIKE '%dalmore%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'dalmore%' THEN 0
                        WHEN `Title` LIKE '% dalmore%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:34:52] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/78.html?_=1693305470669 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` = 78 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [29-Aug-2023 13:35:00] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/78.html?keyword=The Dalmore Cigar Malt&_=1693305478855 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' AND
	    		`URLLabel` = 'select'
         LIMIT 1
# [29-Aug-2023 13:35:03] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/78.html?keyword=The Dalmore&_=1693305481550 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' AND
	    		`URLLabel` = 'select'
         LIMIT 1
# [29-Aug-2023 13:35:03] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/78.html?_=1693305481702 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` = '78', `Language` = 'bg', `PostDate` = '2023-04-06', `LastUpdate` = '2023-08-29 13:35:03', `ParentID` = '61', `UploadID` = '853822015', `MetaTitle` = 'Maxxium - Bulgaria', `MetaDescription` = 'Maxxium - Bulgaria', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["header-1692-x-515-dalmore.jpg"]', `Images` = '["dalmore-12yo-front2.png","dalmore-12yo-big.png"]', `Title` = 'The Dalmore 12YO Sherry Single Malt Scotch Whisky', `URLLabel` = 'dalmore-sherry-12y', `BuyURL` = '', `Content` = '<p>Отлежава минимум 12 години. Първите 9 години – <span style="color: var(--gray);">в бъчви от американски бял дъб, съхранявал преди </span><span style="color: var(--gray);">това бърбън. След това течността се разделя на </span><span style="color: var(--gray);">три. Едната част остава за следващите 3 години </span><span style="color: var(--gray);">в ексбърбън бъчви, а другите две се прехвърлят </span><span style="color: var(--gray);">в бъчви, съхранявали Matusalem Оloroso и Pedro </span><span style="color: var(--gray);">Jimenez шери. Ароматът е на карамелизиран </span><span style="color: var(--gray);">портокал, джинджифил, стафиди и мед. Има изявен </span><span style="color: var(--gray);">вкус на тъмен шоколад и смлени бадеми с канела, а </span><span style="color: var(--gray);">послевкусът е на сладко манго, панакота и лимонов </span><span style="color: var(--gray);">пай.</span></p>', `BrandName` = 'The Dalmore 12YO Sherry Single Malt Scotch Whisky', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 43, `Served` = '', `Package` = '', `WebSite` = 'www.thedalmore.com', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '78' AND `Language` = 'bg'
# [29-Aug-2023 13:35:03] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=dalmore 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'
                 AND `Title` LIKE '%dalmore%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'dalmore%' THEN 0
                        WHEN `Title` LIKE '% dalmore%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:35:10] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/78.html?_=1693305489397 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` = 78 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [29-Aug-2023 13:35:16] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/78.html?keyword=The Dalmore&_=1693305494878 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' AND
	    		`URLLabel` = 'select'
         LIMIT 1
# [29-Aug-2023 13:35:52] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/78.html?_=1693305530705 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` = '78', `Language` = 'bg', `PostDate` = '2023-04-06', `LastUpdate` = '2023-08-29 13:35:52', `ParentID` = '61', `UploadID` = '853822015', `MetaTitle` = 'The Dalmore', `MetaDescription` = 'The Dalmore', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["header-1692-x-515-dalmore.jpg"]', `Images` = '["dalmore-12yo-front2.png","dalmore-12yo-big.png"]', `Title` = 'The Dalmore 12YO Sherry Single Malt Scotch Whisky', `URLLabel` = 'dalmore-sherry-12y', `BuyURL` = '', `Content` = '<p>Отлежава минимум 12 години. Първите 9 години – <span style="color: var(--gray);">в бъчви от американски бял дъб, съхранявал преди </span><span style="color: var(--gray);">това бърбън. След това течността се разделя на </span><span style="color: var(--gray);">три. Едната част остава за следващите 3 години </span><span style="color: var(--gray);">в ексбърбън бъчви, а другите две се прехвърлят </span><span style="color: var(--gray);">в бъчви, съхранявали Matusalem Оloroso и Pedro </span><span style="color: var(--gray);">Jimenez шери. Ароматът е на карамелизиран </span><span style="color: var(--gray);">портокал, джинджифил, стафиди и мед. Има изявен </span><span style="color: var(--gray);">вкус на тъмен шоколад и смлени бадеми с канела, а </span><span style="color: var(--gray);">послевкусът е на сладко манго, панакота и лимонов </span><span style="color: var(--gray);">пай.</span></p>', `BrandName` = 'The Dalmore 12YO Sherry Single Malt Scotch Whisky', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 43, `Served` = '', `Package` = '', `WebSite` = 'www.thedalmore.com', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '78' AND `Language` = 'bg'
# [29-Aug-2023 13:35:52] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=dalmore 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'
                 AND `Title` LIKE '%dalmore%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'dalmore%' THEN 0
                        WHEN `Title` LIKE '% dalmore%' THEN 1
                        ELSE 2
                    END
# [29-Aug-2023 13:36:53] /maxxium/www/bg/brands/dalmore-15yo.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'dalmore-15yo'
         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` = 80
         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 OR `ID` = 61) AND
                    `ID` != 80
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:36:53] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [29-Aug-2023 13:36:53] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [29-Aug-2023 13:36:53] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:36:55] /maxxium/www/bg/brands/dalmore-sherry-12y.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'dalmore-sherry-12y'
         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` = 78
         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 OR `ID` = 61) AND
                    `ID` != 78
             AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` DESC

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:36:55] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [29-Aug-2023 13:36:55] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [29-Aug-2023 13:36:55] /maxxium/www/uf/events/1114268192/ 167.99.142.201

set names utf8

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

set names utf8

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