# [04-May-2023 13:00:12] /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
# [04-May-2023 13:00:13] /maxxium/www/bg/ajax/cookies.html?_=1683194412361 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [04-May-2023 13:00: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 `Category` FROM `brands` WHERE `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

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

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

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'dalmore'
         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
# [04-May-2023 13:01:31] /maxxium/www/bg/brands/tyrconnell.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [04-May-2023 13:01:38] /maxxium/www/bg/brands/царская.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'царская'
         AND `Visible` = 1 LIMIT 1

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

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [04-May-2023 13:01:44] /maxxium/www/bg/brands/passoa.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [04-May-2023 13:01:48] /maxxium/www/bg/brands/jim-beam.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`brands`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'jim-beam'
         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` = 2
         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` = 2
         AND `Visible` = 1 LIMIT 1

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

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

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [04-May-2023 13:06:54] /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
# [04-May-2023 14:50:24] /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
# [04-May-2023 14:50:42] /maxxium/www/bg/brands/freixenet.html 167.99.142.201

set names utf8

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

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

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

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

set names utf8

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

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [04-May-2023 14:50:52] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [04-May-2023 14:51:24] /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
# [04-May-2023 14:51:48] /maxxium/www/bg/events/събития.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [04-May-2023 14:51:50] /maxxium/www/bg/ajax/events/1.html?i=dkm35485.jpg&_=1683201114153 167.99.142.201

set names utf8

SELECT
                `UploadID`,
                `Gallery`
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 1
         AND `Visible` = 1 LIMIT 1
# [04-May-2023 14:52:02] /maxxium/www/bg/ajax/events/1.html?i=aperol-atojazz-2.jpg&_=1683201125975 167.99.142.201

set names utf8

SELECT
                `UploadID`,
                `Gallery`
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 1
         AND `Visible` = 1 LIMIT 1
