# [05-Jun-2023 12:09:09] /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
# [05-Jun-2023 12:09:13] /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
# [05-Jun-2023 15:05:37] /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
# [05-Jun-2023 15:17:09] /maxxium/www/mxD7ap2Va/bg/brands/list.html?sort=40 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 3 AND
                                CRC32(`UserKey`) = 3843054952 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY `URL` ASC
# [05-Jun-2023 15:17:24] /maxxium/www/mxD7ap2Va/bg/brands/list.html?sort=50 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 3 AND
                                CRC32(`UserKey`) = 3843054952 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [05-Jun-2023 15:18:42] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form.html?_=1685967675043 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 3 AND
                                CRC32(`UserKey`) = 3843054952 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

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

SELECT DISTINCT TRIM(`Category`) AS `Category` FROM `brands`
# [05-Jun-2023 15:19:15] /maxxium/www/mxD7ap2Va/bg/ajax/brands/urllabel.html?URLLabel=bGFyaW9zLTEyLWdpbg&_=1685967707247 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
                        COUNT(*)
                    FROM
                        `brands`
                    WHERE
                        `URLLabel` = 'larios-12-gin'
# [05-Jun-2023 15:19:52] /maxxium/www/mxD7ap2Va/bg/ajax/brands/upload/5967522948.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
# [05-Jun-2023 15:22:12] /maxxium/www/mxD7ap2Va/bg/ajax/brands/insert.html?_=1685967884061 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 MAX(`ID`) + 1 FROM `brands`

SELECT * FROM `brands` LIMIT 1

SHOW COLUMNS FROM `brands`

INSERT INTO `brands` SET `ID` = '172', `Language` = 'bg', `PostDate` = '2023-06-05', `LastUpdate` = '2023-06-05 15:22:12', `ParentID` = 0, `UploadID` = '5967522948', `MetaTitle` = 'Larios', `MetaDescription` = '', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '', `Images` = '["larios-12-70cl-bottle-image-jpg.jpg"]', `Title` = 'Larios 12 Gin', `URLLabel` = 'larios-12-gin', `BuyURL` = '', `Content` = '<div>Джин Larios се прави от царевица и се дестилира 4 пъти за постигане на по-гладък вкусов профил. Характерен е с лек, цветисто-плодов</div><div>аромат и ефирни цитрусови нотки. В България се предлага в двете си най-популярни версии.</div><div><br></div><div><div>LARIOS 12 Създаден от 12 уникални растения и плодове, които допринасят за свежия вкус и деликатен бленд, с фин аромат на цитруси и хвойна.</div></div><div><br></div>', `BrandName` = 'Larios 12 Gin', `Category` = 'Джин', `Origin` = 'Испания', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = '', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0
# [05-Jun-2023 15:22:12] /maxxium/www/mxD7ap2Va/bg/brands/list.html?sort=50 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 3 AND
                                CRC32(`UserKey`) = 3843054952 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [05-Jun-2023 15:22:18] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [05-Jun-2023 15:22:37] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form.html?_=1685967909376 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 3 AND
                                CRC32(`UserKey`) = 3843054952 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

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

SELECT DISTINCT TRIM(`Category`) AS `Category` FROM `brands`
# [05-Jun-2023 15:23:01] /maxxium/www/mxD7ap2Va/bg/ajax/brands/urllabel.html?URLLabel=bGFyaW9zLXJvc2UtZ2lu&_=1685967933252 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
                        COUNT(*)
                    FROM
                        `brands`
                    WHERE
                        `URLLabel` = 'larios-rose-gin'
# [05-Jun-2023 15:23:08] /maxxium/www/mxD7ap2Va/bg/ajax/brands/upload/5967757239.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
# [05-Jun-2023 15:24:34] /maxxium/www/mxD7ap2Va/bg/ajax/brands/insert.html?_=1685968026287 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 MAX(`ID`) + 1 FROM `brands`

SELECT * FROM `brands` LIMIT 1

SHOW COLUMNS FROM `brands`

INSERT INTO `brands` SET `ID` = '173', `Language` = 'bg', `PostDate` = '2023-06-05', `LastUpdate` = '2023-06-05 15:24:34', `ParentID` = 0, `UploadID` = '5967757239', `MetaTitle` = 'Larios', `MetaDescription` = '', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '', `Images` = '["larios-rose-70cl-bottle-image-jpg.jpg"]', `Title` = 'Larios Rose Gin', `URLLabel` = 'larios-rose-gin', `BuyURL` = '', `Content` = '<div>Роден в Малага и вдъхновен от богата 150-годишна история, LARIOS е признат за „джина на Средиземноморието”. №1 в Испания и континентална Европа, той е и сред 10-те най-продавани марки джин в целия свят.</div><div><br></div><div><div>LARIOS ROSE Аромат на ягоди и цитруси, с преобладаващ вкус на ягоди. Копринен и нежен послевкус.</div></div>', `BrandName` = 'Larios Rose Gin', `Category` = 'Джин', `Origin` = 'Испания', `Alcohol` = 37.5, `Served` = '', `Package` = '', `WebSite` = '', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0
# [05-Jun-2023 15:24:34] /maxxium/www/mxD7ap2Va/bg/brands/list.html?sort=50 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 3 AND
                                CRC32(`UserKey`) = 3843054952 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [05-Jun-2023 15:24:40] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [05-Jun-2023 15:28:04] /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
# [05-Jun-2023 15:28:06] /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
# [05-Jun-2023 15:28:15] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form/1.html?_=1685968247918 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` = 1 AND
                `Language` = 'bg'
            LIMIT 1

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

SELECT DISTINCT TRIM(`Category`) AS `Category` FROM `brands`
# [05-Jun-2023 15:28:57] /maxxium/www/mxD7ap2Va/bg/ajax/brands/update/1.html?_=1685968289921 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` = '1', `Language` = 'bg', `PostDate` = '2022-12-16', `LastUpdate` = '2023-06-05 15:28:57', `ParentID` = 0, `UploadID` = '1203413403', `MetaTitle` = 'Maxxium - Bulgaria', `MetaDescription` = 'Maxxium Bulgaria is a leading marketing and distribution company for premium spirits & wines with more than 21 years of experience on the Bulgarian domestic market.', `MetaImage` = 'tamnavulin-double-big1.png', `NoIndex` = 0, `HeaderImages` = '["header-merken-1692x515px21.jpg"]', `Images` = '["tamnavulin-335x1024-1-147x450.png","tamnavulin-big.png"]', `Title` = 'Tamnavulin', `URLLabel` = 'tamnavulin', `BuyURL` = 'https://maxgraphic.bg', `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);">в бъчви от шери Amoroso Oloroso </span><span style="color: var(--gray);">и за достигане на богат, плътен, г</span><span style="color: var(--gray);">ладък и мек вкус. Неопушено. </span><span style="color: var(--gray);">No-Age Statement – без посочени </span><span style="color: var(--gray);">години на отлежаване.</span></p>', `BrandName` = 'Tamnavulin Single Malt Scotch Whisky', `Category` = 'Single Malt Scotch Whisky', `Origin` = 'Шотландия', `Alcohol` = 40, `Served` = 'Сервиран', `Package` = '0,7l', `WebSite` = 'https://www.tamnavulinwhisky.com/', `Social` = 'https://facebook.com
https://insragram.com
https://youtube.com', `Documents` = '["12772668171.pdf"]', `ProductLink` = 'https://maxgraphic.bg', `Visible` = 1, `FirstPage` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [05-Jun-2023 15:28:57] /maxxium/www/mxD7ap2Va/bg/brands/list.html?sort=50 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 3 AND
                                CRC32(`UserKey`) = 3843054952 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [05-Jun-2023 15:29:03] /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
# [05-Jun-2023 15:29:18] /maxxium/www/bg/brands.html 167.99.142.201

set names utf8

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

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

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

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [05-Jun-2023 15:29:21] /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
# [05-Jun-2023 15:30:03] /maxxium/www/bg/brands/aftershock-red.html 167.99.142.201
# [05-Jun-2023 15:30:03] /maxxium/www/bg/brands/aftershock-red.html 167.99.142.201

set names utf8

set names utf8

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

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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LCategory','LOrigin','LAlcohol','LServed','LPackage','LWebSite','LSocial','LBuy') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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