# [02-Sep-2023 08:35:16] /maxxium/www/ 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [02-Sep-2023 08:35:17] /maxxium/www/bg/ajax/cookies.html?_=1693632917689 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
# [02-Sep-2023 08:35:48] /maxxium/www/uf/events/751416607/ 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [02-Sep-2023 08:35:49] /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
# [02-Sep-2023 08:36:17] /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
# [02-Sep-2023 08:36:26] /maxxium/www/bg/contact-us.html 167.99.142.201

set names utf8

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

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

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

set names utf8

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

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [02-Sep-2023 08:44: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
# [02-Sep-2023 08:44:48] /maxxium/www/bg/brands/aftershock-red.html 167.99.142.201

set names utf8

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

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

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [02-Sep-2023 08:44:57] /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
# [02-Sep-2023 08:44: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
# [02-Sep-2023 08:44: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
