# [09-Aug-2023 13:04:49] /maxxium/www/ 167.99.142.201

set names utf8

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

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

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

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

set names utf8

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

set names utf8

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

set names utf8

SELECT
                *
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [09-Aug-2023 13:04:58] /maxxium/www/mxD7ap2Va/bg/brands/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `brands`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [09-Aug-2023 13:05:22] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form.html?_=1691575678853 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`

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [09-Aug-2023 13:05:29] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select.html?keyword=Cenote&_=1691575685030 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
# [09-Aug-2023 13:05:30] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select.html?keyword=Cenote Re&_=1691575686694 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
# [09-Aug-2023 13:05:32] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select.html?keyword=Cenote Reposado&_=1691575688175 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
# [09-Aug-2023 13:15:57] /maxxium/www/mxD7ap2Va/bg/ajax/brands/upload/1575522837.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
# [09-Aug-2023 13:16:16] /maxxium/www/mxD7ap2Va/bg/ajax/brands/urllabel.html?URLLabel=Y2Vub3RlLXJlcG9zYWRvLXRlcXVpbGE&_=1691576332499 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` = 'cenote-reposado-tequila'
# [09-Aug-2023 13:18:47] /maxxium/www/mxD7ap2Va/bg/ajax/brands/insert.html?_=1691576483300 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` = '175', `Language` = 'bg', `PostDate` = '2023-08-09', `LastUpdate` = '2023-08-09 13:18:47', `ParentID` = '', `UploadID` = '1575522837', `MetaTitle` = 'Cenote Reposado Tequila', `MetaDescription` = '', `MetaImage` = 'cenote-pack-shot-reposado-700ml_20212.jpg', `NoIndex` = 0, `HeaderImages` = '', `Images` = '', `Title` = 'Cenote Reposado Tequila', `URLLabel` = 'cenote-reposado-tequila', `BuyURL` = '', `Content` = '<p class="MsoNormal"><span lang="RU" style="mso-ansi-language:RU">Ние вярваме, че
процесът на стареене трябва да подобри, а не да доминира естествените вкусове
на агавето, затова нарочно овъгляваме по-слабо бъчвите, което прави цвета
по-светъл. Cenote™ Reposado отлежава 3 месеца в екс-бърбън бъчви от американски
дъб</span><span lang="EN-US">.</span><span lang="RU" style="mso-ansi-language:RU">
Резултатът е перфектен баланс от изискани вкусове на ванилия, дърво и
подправки, с прясно сготвено агаве и зелени растителни нотки.</span><span lang="EN-US"><o:p></o:p></span></p><p class="MsoNormal"><span lang="RU" style="mso-ansi-language:RU"><p class="MsoNormal"><b><span lang="RU" style="mso-ansi-language:RU">Нос:</span></b><span lang="RU" style="mso-ansi-language:RU"> Свеж, ярък цитрус и пипер</span><span lang="EN-US"><o:p></o:p></span></p>

<p class="MsoNormal"><b><span lang="RU" style="mso-ansi-language:RU">Вкус</span></b><span lang="RU" style="mso-ansi-language:RU">: Богат, сготвено агаве, подправки, фино
дърво, свежи зелени зеленчуци, ананас и манго с мента</span><span lang="EN-US"><o:p></o:p></span></p>

<p class="MsoNormal"><b><span lang="RU" style="mso-ansi-language:RU">Финал</span></b><span lang="RU" style="mso-ansi-language:RU">: Освежаващ и чист</span><span lang="EN-US"><o:p></o:p></span></p><br></span></p>', `BrandName` = 'Cenote Reposado Tequila', `Category` = 'Tequila & Mezcal', `SubCategory` = '', `Origin` = 'Мексико', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = '', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0
# [09-Aug-2023 13:19:03] /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
# [09-Aug-2023 13:19: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
# [09-Aug-2023 13:19: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
# [09-Aug-2023 13:19: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
# [09-Aug-2023 13:19:05] /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
# [09-Aug-2023 13:19:28] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=cen 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 '%cen%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'cen%' THEN 0
                        WHEN `Title` LIKE '% cen%' THEN 1
                        ELSE 2
                    END
# [09-Aug-2023 13:19:34] /maxxium/www/mxD7ap2Va/bg/ajax/brands/form.html?_=1691576530613 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`

SELECT DISTINCT TRIM(`SubCategory`) AS `SubCategory` FROM `brands`
# [09-Aug-2023 13:20:15] /maxxium/www/mxD7ap2Va/bg/ajax/brands/urllabel.html?URLLabel=Y2Vub3RlLXJlcG9zYWRvLXRlcXVpbGE&_=1691576571723 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` = 'cenote-reposado-tequila'
# [09-Aug-2023 13:20:24] /maxxium/www/mxD7ap2Va/bg/ajax/brands/upload/1576374627.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
# [09-Aug-2023 13:20:34] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select.html?keyword=Ceno&_=1691576590951 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
# [09-Aug-2023 13:20:39] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select.html?keyword=Cenote&_=1691576595141 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
# [09-Aug-2023 13:20:42] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select.html?keyword=Cenote Re&_=1691576598454 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
# [09-Aug-2023 13:20:45] /maxxium/www/mxD7ap2Va/bg/ajax/brands/select.html?keyword=Cenote Reposado Tequila&_=1691576601518 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
# [09-Aug-2023 13:21:48] /maxxium/www/mxD7ap2Va/bg/ajax/brands/insert.html?_=1691576664079 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` = '175', `Language` = 'bg', `PostDate` = '2023-08-09', `LastUpdate` = '2023-08-09 13:21:48', `ParentID` = '', `UploadID` = '1576374627', `MetaTitle` = 'Cenote Reposado Tequila', `MetaDescription` = 'Cenote premium tequila', `MetaImage` = '', `NoIndex` = 0, `HeaderImages` = '', `Images` = '["cenote-pack-shot-reposado-700ml_20212.jpg"]', `Title` = 'Cenote Reposado Tequila', `URLLabel` = 'cenote-reposado-tequila', `BuyURL` = '', `Content` = '<p class="MsoNormal"><span lang="RU" style="mso-ansi-language:RU">Ние вярваме, че
процесът на стареене трябва да подобри, а не да доминира естествените вкусове
на агавето, затова нарочно овъгляваме по-слабо бъчвите, което прави цвета
по-светъл. Cenote™ Reposado отлежава 3 месеца в екс-бърбън бъчви от американски
дъб</span><span lang="EN-US">.</span><span lang="RU" style="mso-ansi-language:RU">
Резултатът е перфектен баланс от изискани вкусове на ванилия, дърво и
подправки, с прясно сготвено агаве и зелени растителни нотки.</span><span lang="EN-US"><o:p></o:p></span></p><p class="MsoNormal"><span lang="RU" style="mso-ansi-language:RU"><p class="MsoNormal"><b><span lang="RU" style="mso-ansi-language:RU">Нос:</span></b><span lang="RU" style="mso-ansi-language:RU"> Свеж, ярък цитрус и пипер</span><span lang="EN-US"><o:p></o:p></span></p>

<p class="MsoNormal"><b><span lang="RU" style="mso-ansi-language:RU">Вкус</span></b><span lang="RU" style="mso-ansi-language:RU">: Богат, сготвено агаве, подправки, фино
дърво, свежи зелени зеленчуци, ананас и манго с мента</span><span lang="EN-US"><o:p></o:p></span></p>

<p class="MsoNormal"><b><span lang="RU" style="mso-ansi-language:RU">Финал</span></b><span lang="RU" style="mso-ansi-language:RU">: Освежаващ и чист</span><span lang="EN-US"><o:p></o:p></span></p><br></span></p>', `BrandName` = 'Cenote Reposado Tequila', `Category` = 'Tequila & Mezcal', `SubCategory` = '', `Origin` = 'Мексико', `Alcohol` = 40, `Served` = '', `Package` = '', `WebSite` = '', `Social` = '', `Documents` = '', `ProductLink` = '', `Visible` = 1, `FirstPage` = 0
# [09-Aug-2023 13:30:53] /maxxium/www/mxD7ap2Va/bg/brands/list.html?keyword=cen 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 '%cen%'
            ORDER BY 
                    CASE
                        WHEN `Title` LIKE 'cen%' THEN 0
                        WHEN `Title` LIKE '% cen%' THEN 1
                        ELSE 2
                    END
