# [17-Aug-2023 10:22:08] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=chit 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 '%chit%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'chit%' THEN 0
                        WHEN `Title` LIKE '% chit%' THEN 1
                        ELSE 2
                    END
# [17-Aug-2023 10:22:10] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/23.html?_=1692257070884 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`
# [17-Aug-2023 10:22:31] /maxxium/www/bg/brands/chita.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:22: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
# [17-Aug-2023 10:22: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
# [17-Aug-2023 10:22: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
# [17-Aug-2023 10:23:14] /maxxium/www/mxD7ap2Va/bg/ajax/brands/upload/5949116382.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
# [17-Aug-2023 10:23:18] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/23.html?_=1692257139294 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-17 10:23:18', `ParentID` = 0, `UploadID` = '5949116382', `MetaTitle` = 'Maxxium - Bulgaria', `MetaDescription` = 'Maxxium - Bulgaria', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["header-1692-x-515-chita.jpg"]', `Images` = '["chita-147x450px.png","chita-big.png"]', `Title` = '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'
# [17-Aug-2023 10:23:18] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=chit 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 '%chit%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'chit%' THEN 0
                        WHEN `Title` LIKE '% chit%' THEN 1
                        ELSE 2
                    END
# [17-Aug-2023 10:23:24] /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
# [17-Aug-2023 10:23:30] /maxxium/www/bg/brands/chita.html 167.99.142.201

set names utf8

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

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

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

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

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
# [17-Aug-2023 10:24:21] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=glen gran 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 '%glen%gran%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'glen%gran%' THEN 0
                        WHEN `Title` LIKE '% glen%gran%' THEN 1
                        ELSE 2
                    END
# [17-Aug-2023 10:25:30] /maxxium/www/uf/events/751416607/ 167.99.142.201
# [17-Aug-2023 10:25:30] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [17-Aug-2023 10:25:30] /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
# [17-Aug-2023 10:25:38] /maxxium/www/bg/brands/glen-grant-10y.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'glen-grant-10y'
         AND `Visible` = 1 LIMIT 1
# [17-Aug-2023 10:25:38] /maxxium/www/bg/brands/glen-grant-10y.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:25:39] /maxxium/www/uf/events/751416607/ 167.99.142.201
# [17-Aug-2023 10:25:39] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [17-Aug-2023 10:25:39] /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
# [17-Aug-2023 10:25:44] /maxxium/www/bg/brands/glen-grant-tmr.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'glen-grant-tmr'
         AND `Visible` = 1 LIMIT 1
# [17-Aug-2023 10:25:44] /maxxium/www/bg/brands/glen-grant-tmr.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                    *
                FROM
                    `brands`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 62
             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
# [17-Aug-2023 10:25:44] /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
# [17-Aug-2023 10:25:44] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [17-Aug-2023 10:25:44] /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
# [17-Aug-2023 10:25:58] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/62.html?_=1692257299758 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` = 62 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [17-Aug-2023 10:26:20] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/62.html?_=1692257321073 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` = '62', `Language` = 'bg', `PostDate` = '2023-04-07', `LastUpdate` = '2023-08-17 10:26:20', `ParentID` = 0, `UploadID` = '849009554', `MetaTitle` = 'Glen Grant | Maxxium Bulgaria LTD', `MetaDescription` = 'Glen Grant | Maxxium Bulgaria LTD', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["heade1692-x-515-glen-grant.jpg"]', `Images` = '["glengrant-big1.png"]', `Title` = 'Glen Grant TMR', `URLLabel` = 'glen-grant-tmr', `BuyURL` = 'https://drinks-shop.bg/product/glen-grant-tmr-single-malt-whisky-07-l', `Content` = '<p>Шотландско едномалцово <span style="color: var(--gray);">(single malt) уиски със </span><span style="color: var(--gray);">светлозлатист цвят </span><span style="color: var(--gray);">и аромат на ябълки. </span><span style="color: var(--gray);">GLEN GRANT THE MAJOR’S </span><span style="color: var(--gray);">RESERVE предлага свеж </span><span style="color: var(--gray);">вкус на овощни плодове, </span><span style="color: var(--gray);">с лек и сух завършек.</span></p>', `BrandName` = 'Glen Grant TMR Single Malt Scotch Whisky', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 43, `Served` = '', `Package` = '', `WebSite` = 'https://www.glengrant.com/', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '62' AND `Language` = 'bg'
# [17-Aug-2023 10:26:20] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=glen gran 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 '%glen%gran%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'glen%gran%' THEN 0
                        WHEN `Title` LIKE '% glen%gran%' THEN 1
                        ELSE 2
                    END
# [17-Aug-2023 10:26:24] /maxxium/www/bg/brands/glen-grant-tmr.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:26:24] /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
# [17-Aug-2023 10:26:24] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [17-Aug-2023 10:26:24] /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
# [17-Aug-2023 10:26:36] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/83.html?_=1692257336860 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` = 83 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [17-Aug-2023 10:26:53] /maxxium/www/bg/brands/glen-grant-tmr.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:26:53] /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
# [17-Aug-2023 10:26: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
# [17-Aug-2023 10:26: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
# [17-Aug-2023 10:26:56] /maxxium/www/bg/brands/glen-grant-18y.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:26: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
# [17-Aug-2023 10:26:56] /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
# [17-Aug-2023 10:26: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
# [17-Aug-2023 10:27:08] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/62.html?_=1692257369435 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` = 62 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [17-Aug-2023 10:27:15] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/62.html?keyword=Glen&_=1692257376258 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
# [17-Aug-2023 10:27:17] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/62.html?keyword=Glen Grant&_=1692257378022 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
# [17-Aug-2023 10:27:18] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/62.html?keyword=Glen Grant&_=1692257379718 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
# [17-Aug-2023 10:27:19] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/62.html?keyword=Glen Grant 10&_=1692257380545 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
# [17-Aug-2023 10:27:20] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/62.html?keyword=Glen Grant 10YO&_=1692257381668 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
# [17-Aug-2023 10:28:35] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/62.html?_=1692257456509 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` = '62', `Language` = 'bg', `PostDate` = '2023-04-07', `LastUpdate` = '2023-08-17 10:28:35', `ParentID` = 0, `UploadID` = '849009554', `MetaTitle` = 'Glen Grant ', `MetaDescription` = 'Glen Grant ', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '["heade1692-x-515-glen-grant.jpg"]', `Images` = '["glengrant-big1.png"]', `Title` = 'Glen Grant TMR', `URLLabel` = 'glen-grant-tmr', `BuyURL` = 'https://drinks-shop.bg/product/glen-grant-tmr-single-malt-whisky-07-l', `Content` = '<p>Шотландско едномалцово <span style="color: var(--gray);">(single malt) уиски със </span><span style="color: var(--gray);">светлозлатист цвят </span><span style="color: var(--gray);">и аромат на ябълки. </span><span style="color: var(--gray);">GLEN GRANT THE MAJOR’S </span><span style="color: var(--gray);">RESERVE предлага свеж </span><span style="color: var(--gray);">вкус на овощни плодове, </span><span style="color: var(--gray);">с лек и сух завършек.</span></p>', `BrandName` = 'Glen Grant TMR ', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = 'https://www.glengrant.com/', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '62' AND `Language` = 'bg'
# [17-Aug-2023 10:28:35] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=glen gran 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 '%glen%gran%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'glen%gran%' THEN 0
                        WHEN `Title` LIKE '% glen%gran%' THEN 1
                        ELSE 2
                    END
# [17-Aug-2023 10:28:40] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

SELECT
                DISTINCT `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
# [17-Aug-2023 10:28:58] /maxxium/www/bg/brands/glen-grant-tmr.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:28:58] /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
# [17-Aug-2023 10:28:58] /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
# [17-Aug-2023 10:28: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
# [17-Aug-2023 10:29:12] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/83.html?_=1692257493584 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` = 83 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [17-Aug-2023 10:29:23] /maxxium/www/mxD7ap2Va/bg/ajax/brands/upload/854417252.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
# [17-Aug-2023 10:29:48] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/83.html?keyword=Glen Grant&_=1692257529586 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
# [17-Aug-2023 10:29:50] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/83.html?keyword=Glen Grant 1&_=1692257531551 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
# [17-Aug-2023 10:29:51] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/83.html?keyword=Glen Grant 18&_=1692257532218 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
# [17-Aug-2023 10:29:52] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/83.html?keyword=Glen Grant 18Y&_=1692257532980 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
# [17-Aug-2023 10:29:52] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/83.html?keyword=Glen Grant 18Y&_=1692257533754 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
# [17-Aug-2023 10:29:53] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/83.html?keyword=Glen Grant 1&_=1692257534632 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
# [17-Aug-2023 10:29:54] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/83.html?keyword=Glen Grant 10&_=1692257535747 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
# [17-Aug-2023 10:29:55] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/83.html?keyword=Glen Grant 10T&_=1692257536691 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
# [17-Aug-2023 10:29:57] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/83.html?keyword=Glen Grant 10YO&_=1692257538287 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
# [17-Aug-2023 10:30:50] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/83.html?_=1692257591221 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` = '83', `Language` = 'bg', `PostDate` = '2023-04-07', `LastUpdate` = '2023-08-17 10:30:50', `ParentID` = '62', `UploadID` = '854417252', `MetaTitle` = 'Glen Grant 18 YO ', `MetaDescription` = 'Glen Grant 18 YO ', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '', `Images` = '["gg18yo-147x450px.png","glen-grant-18yo-btl-and-box-recised.jpg"]', `Title` = 'Glen Grant 18YO Single Malt Scotch Whisky', `URLLabel` = 'glen-grant-18y', `BuyURL` = '', `Content` = '<p>Комплексен малц, който отлежава в първокласни, <span style="color: var(--gray);">ръчно подбрани ексбърбън бъчви. Ярък, златист </span><span style="color: var(--gray);">цвят c богати малцови аромати. Деликатни нежни </span><span style="color: var(--gray);">нотки на ванилия, карамел и стафиди. </span><span style="color: var(--gray);">Дълъг послевкус с пикантни аромати</span></p>', `BrandName` = 'Glen Grant 18YO Single Malt Scotch Whisky', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 43, `Served` = '', `Package` = '', `WebSite` = 'https://www.glengrant.com/', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '83' AND `Language` = 'bg'
# [17-Aug-2023 10:30:50] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=glen gran 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 '%glen%gran%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'glen%gran%' THEN 0
                        WHEN `Title` LIKE '% glen%gran%' THEN 1
                        ELSE 2
                    END
# [17-Aug-2023 10:30:55] /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
# [17-Aug-2023 10:30:58] /maxxium/www/bg/brands/glen-grant-10y.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:30:59] /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
# [17-Aug-2023 10:30:59] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [17-Aug-2023 10:30:59] /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
# [17-Aug-2023 10:31:03] /maxxium/www/bg/brands/glen-grant-tmr.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:31:04] /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
# [17-Aug-2023 10:31:04] /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
# [17-Aug-2023 10:31:04] /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
# [17-Aug-2023 10:31:07] /maxxium/www/bg/brands/glen-grant-18y.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:31:07] /maxxium/www/uf/events/1114268192/ 167.99.142.201
# [17-Aug-2023 10:31:07] /maxxium/www/uf/events/751416607/ 167.99.142.201
# [17-Aug-2023 10:31:07] /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
# [17-Aug-2023 10:31:24] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/90.html?_=1692257625349 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` = 90 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [17-Aug-2023 10:31:41] /maxxium/www/mxD7ap2Va/bg/ajax/brands/upload/855323100.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
# [17-Aug-2023 10:31:44] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/90.html?_=1692257645589 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` = '90', `Language` = 'bg', `PostDate` = '2023-04-07', `LastUpdate` = '2023-08-17 10:31:44', `ParentID` = '62', `UploadID` = '855323100', `MetaTitle` = 'Glen Grant | Maxxium Bulgaria LTD', `MetaDescription` = 'Glen Grant | Maxxium Bulgaria LTD', `MetaImage` = 'gledngrand-arboralis-big1.png', `NoIndex` = 0, `HeaderImages` = '["heade1692-x-515-glen-grant.jpg"]', `Images` = '["ggarb-147x450px.png","700ml-arboralis-frontboxed.jpg"]', `Title` = 'Glen Grant Arboralis Single Malt Scotch Whisky', `URLLabel` = 'glen-grant-arboralis', `BuyURL` = 'https://drinks-shop.bg/product/glen-grant-arboralis-07l-43-abv', `Content` = '<p>Това яркозлатно сингъл ма<span style="color: var(--gray);">лц уиски е отлежало </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><span style="color: var(--gray);">които се простират във </span><span style="color: var(--gray);">Викторианските Градини </span><span style="color: var(--gray);">на дестилерията Glen </span><span style="color: var(--gray);">Grant.</span></p>', `BrandName` = 'Glen Grant Arboralis Single Malt Scotch Whisky', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = 'https://www.glengrant.com/', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0 WHERE `ID` = '90' AND `Language` = 'bg'
# [17-Aug-2023 10:31:44] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=glen gran 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 '%glen%gran%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'glen%gran%' THEN 0
                        WHEN `Title` LIKE '% glen%gran%' THEN 1
                        ELSE 2
                    END
# [17-Aug-2023 10:31:51] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/90.html?_=1692257652416 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` = 90 AND
                `Language` = 'bg'
            LIMIT 1

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

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

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [17-Aug-2023 10:32:01] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/90.html?keyword=Glen&_=1692257662270 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
# [17-Aug-2023 10:32:03] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/90.html?keyword=Glen Grant&_=1692257664453 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
# [17-Aug-2023 10:32:07] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select/90.html?keyword=Glen Grant 10YO&_=1692257667820 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
# [17-Aug-2023 10:32:22] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/90.html?_=1692257683652 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` = '90', `Language` = 'bg', `PostDate` = '2023-04-07', `LastUpdate` = '2023-08-17 10:32:22', `ParentID` = '62', `UploadID` = '855323100', `MetaTitle` = 'Glen Grant | Maxxium Bulgaria LTD', `MetaDescription` = 'Glen Grant | Maxxium Bulgaria LTD', `MetaImage` = 'gledngrand-arboralis-big1.png', `NoIndex` = 0, `HeaderImages` = '["heade1692-x-515-glen-grant.jpg"]', `Images` = '["ggarb-147x450px.png","700ml-arboralis-frontboxed.jpg"]', `Title` = 'Glen Grant Arboralis Single Malt Scotch Whisky', `URLLabel` = 'glen-grant-arboralis', `BuyURL` = 'https://drinks-shop.bg/product/glen-grant-arboralis-07l-43-abv', `Content` = '<p>Това яркозлатно сингъл ма<span style="color: var(--gray);">лц уиски е отлежало </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><span style="color: var(--gray);">които се простират във </span><span style="color: var(--gray);">Викторианските Градини </span><span style="color: var(--gray);">на дестилерията Glen </span><span style="color: var(--gray);">Grant.</span></p>', `BrandName` = 'Glen Grant Arboralis Single Malt Scotch Whisky', `Category` = 'Whisky', `SubCategory` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = 'https://www.glengrant.com/', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 1 WHERE `ID` = '90' AND `Language` = 'bg'
# [17-Aug-2023 10:32:22] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=glen gran 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 '%glen%gran%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'glen%gran%' THEN 0
                        WHEN `Title` LIKE '% glen%gran%' THEN 1
                        ELSE 2
                    END
# [17-Aug-2023 10:32:26] /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
# [17-Aug-2023 10:32:32] /maxxium/www/bg/brands/glen-grant-10y.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:32:32] /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
# [17-Aug-2023 10:32:32] /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
# [17-Aug-2023 10:32:32] /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
# [17-Aug-2023 10:32:36] /maxxium/www/bg/brands/glen-grant-tmr.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:32:37] /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
# [17-Aug-2023 10:32:37] /maxxium/www/uf/events/1114311358/ 167.99.142.201
# [17-Aug-2023 10:32:37] /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
# [17-Aug-2023 10:32:39] /maxxium/www/bg/brands/glen-grant-arboralis.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Aug-2023 10:32: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
# [17-Aug-2023 10:32:39] /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
# [17-Aug-2023 10:32: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
