# [16-May-2024 15:49:23] /techco/www/ 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `UploadID`,
                `Image`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

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

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

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

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `UploadID`,
                `Image`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

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

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

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

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 15:49:23] /techco/www/bg/ajax/newsletter/form/home.html?_=1715863762889 108.61.209.243
# [16-May-2024 15:49:23] /techco/www/bg/ajax/cookies.html?_=1715863762889 108.61.209.243

set names utf8

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

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

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'terms' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [16-May-2024 15:49:25] /techco/www/bg/продукти.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'продукти' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
				`products`.`ID`
			FROM
				`products`
				INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
				INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
				INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
			WHERE
				(`PromoStart` IS NOT NULL OR `PromoEnd` IS NOT NULL) AND
				(`PromoStart` IS NULL OR `PromoStart` <= NOW()) AND
				(`PromoEnd` IS NULL OR `PromoEnd` >= NOW()) AND
				`product_texts`.`Language` = 'bg' AND
				`products`.`Visible` = 1 AND
				`groups`.`Visible` = 1
			LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'продукти'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'продукти'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 15:49:25] /techco/www/bg/ajax/cookies.html?_=1715863764970 108.61.209.243

set names utf8

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'terms' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [16-May-2024 15:52:18] /techco/www/bg/продукти.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'продукти' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
				`products`.`ID`
			FROM
				`products`
				INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
				INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
				INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
			WHERE
				(`PromoStart` IS NOT NULL OR `PromoEnd` IS NOT NULL) AND
				(`PromoStart` IS NULL OR `PromoStart` <= NOW()) AND
				(`PromoEnd` IS NULL OR `PromoEnd` >= NOW()) AND
				`product_texts`.`Language` = 'bg' AND
				`products`.`Visible` = 1 AND
				`groups`.`Visible` = 1
			LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'продукти'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'продукти'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 15:52:18] /techco/www/bg/ajax/cookies.html?_=1715863937944 108.61.209.243

set names utf8

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'terms' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [16-May-2024 15:52:29] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1715863948362 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'p1Da710moTbQyTR88eyP0AVZ9Kghn6f85P9HTQU6z9l21P9AwCNEcOfG5mlJ67vL'
            WHERE
                `UserKey` LIKE 'w4vDksOjw4LCpcODw5HDjcOBw6zCs8K-w43DlsObwp7CtsK9%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [16-May-2024 15:52:29] /techco/www/tNw2sPa4q/bg/ajax/users/login.html?_=1715863949112 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = 'p1Da710moTbQyTR88eyP0AVZ9Kghn6f85P9HTQU6z9l21P9AwCNEcOfG5mlJ67vL'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [16-May-2024 15:52:29] /techco/www/tNw2sPa4q/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                IF(`MenuLabel` <> '', `MenuLabel`, `FooterLabel`) AS `Label`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel` FROM `pages` WHERE `Language` = 'bg' AND
	`ParentID` = 1 AND
	`Module` = 'contacts' ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1
# [16-May-2024 15:52:35] /techco/www/tNw2sPa4q/bg/groups/list.html 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [16-May-2024 15:52:37] /techco/www/tNw2sPa4q/bg/ajax/groups/form.html?_=1715863956559 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC
# [16-May-2024 15:53:04] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LzQsNGB0LvQsC3QuC3Qs9GA0LXRgdC4&_=1715863983595 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 15:53:10] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LzQsNGB0LvQsC3QuC3Qs9GA0LXRgdC4&_=1715863990265 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 15:53:31] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LzQsNGB0LvQsC3QuC3Qs9GA0LXRgdC4&_=1715864010624 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 15:53:45] /techco/www/tNw2sPa4q/bg/ajax/groups/upload/5863957255.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:02:03] /techco/www/tNw2sPa4q/bg/ajax/groups/upload/5863957255.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:02:12] /techco/www/tNw2sPa4q/bg/ajax/groups/insert.html?_=1715864531935 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `groups`

SELECT * FROM `groups` LIMIT 1

SHOW COLUMNS FROM `groups`

REPLACE INTO `groups` SET `ID` = 1, `PostDate` = '2024-05-16', `LastUpdate` = '2024-05-16 16:02:12', `Code` = '111', `ParentID` = '0', `Color` = '', `UploadID` = '5863957255', `Image` = 'masla-i-gresi.png', `Visible` = 1

SELECT * FROM `group_texts` LIMIT 1

SHOW COLUMNS FROM `group_texts`

INSERT INTO `group_texts` SET `GroupID` = 1, `Language` = 'bg', `MenuLabel` = 'Масла и греси', `URLLabel` = 'масла-и-греси', `Title` = 'Масла и греси'
# [16-May-2024 16:02:12] /techco/www/tNw2sPa4q/bg/groups/list.html 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [16-May-2024 16:02:25] /techco/www/tNw2sPa4q/bg/ajax/groups/form/1.html?_=1715864544647 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `groups`.`ID` = 1 AND
                `group_texts`.`Language` = 'bg'
            LIMIT 1

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC
# [16-May-2024 16:02:29] /techco/www/tNw2sPa4q/bg/ajax/groups/form.html?_=1715864548657 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC
# [16-May-2024 16:03:17] /techco/www/tNw2sPa4q/bg/ajax/groups/upload/5864549357.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:03:45] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LTQvtCx0LDQstC60Lgt0LUt0LDQtdGA0L7Qt9C-0LvQuA&_=1715864625274 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:03:47] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LTQvtCx0LDQstC60Lgt0LUt0LDQtdGA0L7Qt9C-0LvQuA&_=1715864626865 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:03:47] /techco/www/tNw2sPa4q/bg/ajax/groups/insert.html?_=1715864626978 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `groups`

SELECT * FROM `groups` LIMIT 1

SHOW COLUMNS FROM `groups`

REPLACE INTO `groups` SET `ID` = '2', `PostDate` = '2024-05-16', `LastUpdate` = '2024-05-16 16:03:47', `Code` = '112', `ParentID` = '0', `Color` = '', `UploadID` = '5864549357', `Image` = 'aerosoli-i-dobavki.png', `Visible` = 1

SELECT * FROM `group_texts` LIMIT 1

SHOW COLUMNS FROM `group_texts`

INSERT INTO `group_texts` SET `GroupID` = '2', `Language` = 'bg', `MenuLabel` = 'Добавки е аерозоли', `URLLabel` = 'добавки-е-аерозоли', `Title` = 'Добавки е аерозоли'
# [16-May-2024 16:03:47] /techco/www/tNw2sPa4q/bg/groups/list.html 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [16-May-2024 16:03:50] /techco/www/tNw2sPa4q/bg/ajax/groups/form.html?_=1715864629993 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC
# [16-May-2024 16:04:09] /techco/www/tNw2sPa4q/bg/ajax/groups/upload/5864630696.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:04:16] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LDQutGD0LzRg9C70LDRgtC-0YDQuA&_=1715864656256 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:04:17] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LDQutGD0LzRg9C70LDRgtC-0YDQuA&_=1715864657002 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:04:17] /techco/www/tNw2sPa4q/bg/ajax/groups/insert.html?_=1715864657089 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `groups`

SELECT * FROM `groups` LIMIT 1

SHOW COLUMNS FROM `groups`

REPLACE INTO `groups` SET `ID` = '3', `PostDate` = '2024-05-16', `LastUpdate` = '2024-05-16 16:04:17', `Code` = '113', `ParentID` = '0', `Color` = '', `UploadID` = '5864630696', `Image` = 'akumulator.png', `Visible` = 1

SELECT * FROM `group_texts` LIMIT 1

SHOW COLUMNS FROM `group_texts`

INSERT INTO `group_texts` SET `GroupID` = '3', `Language` = 'bg', `MenuLabel` = 'Акумулатори', `URLLabel` = 'акумулатори', `Title` = 'Акумулатори'
# [16-May-2024 16:04:17] /techco/www/tNw2sPa4q/bg/groups/list.html 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [16-May-2024 16:06:06] /techco/www/tNw2sPa4q/bg/ajax/groups/form.html?_=1715864765265 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC
# [16-May-2024 16:06:12] /techco/www/tNw2sPa4q/bg/ajax/groups/upload/5864766115.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:06:19] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0YfQuNGB0YLQsNGH0LrQuA&_=1715864779110 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:06:20] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0YfQuNGB0YLQsNGH0LrQuA&_=1715864779679 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:06:20] /techco/www/tNw2sPa4q/bg/ajax/groups/insert.html?_=1715864779746 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `groups`

SELECT * FROM `groups` LIMIT 1

SHOW COLUMNS FROM `groups`

REPLACE INTO `groups` SET `ID` = '4', `PostDate` = '2024-05-16', `LastUpdate` = '2024-05-16 16:06:20', `Code` = '114', `ParentID` = '0', `Color` = '', `UploadID` = '5864766115', `Image` = 'chistachki.png', `Visible` = 1

SELECT * FROM `group_texts` LIMIT 1

SHOW COLUMNS FROM `group_texts`

INSERT INTO `group_texts` SET `GroupID` = '4', `Language` = 'bg', `MenuLabel` = 'Чистачки', `URLLabel` = 'чистачки', `Title` = 'Чистачки'
# [16-May-2024 16:06:20] /techco/www/tNw2sPa4q/bg/groups/list.html 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [16-May-2024 16:06:23] /techco/www/tNw2sPa4q/bg/ajax/groups/form.html?_=1715864782527 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC
# [16-May-2024 16:07:12] /techco/www/tNw2sPa4q/bg/ajax/groups/upload/5864783228.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:07:20] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0L7RgdCy0LXRgtC70LXQvdC40LU&_=1715864839563 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:07:20] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0L7RgdCy0LXRgtC70LXQvdC40LU&_=1715864840104 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:07:20] /techco/www/tNw2sPa4q/bg/ajax/groups/insert.html?_=1715864840185 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `groups`

SELECT * FROM `groups` LIMIT 1

SHOW COLUMNS FROM `groups`

REPLACE INTO `groups` SET `ID` = '5', `PostDate` = '2024-05-16', `LastUpdate` = '2024-05-16 16:07:20', `Code` = '115', `ParentID` = '0', `Color` = '', `UploadID` = '5864783228', `Image` = 'osvetlenie.png', `Visible` = 1

SELECT * FROM `group_texts` LIMIT 1

SHOW COLUMNS FROM `group_texts`

INSERT INTO `group_texts` SET `GroupID` = '5', `Language` = 'bg', `MenuLabel` = 'Осветление', `URLLabel` = 'осветление', `Title` = 'Осветление'
# [16-May-2024 16:07:21] /techco/www/tNw2sPa4q/bg/groups/list.html 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [16-May-2024 16:07:22] /techco/www/tNw2sPa4q/bg/ajax/groups/form.html?_=1715864841385 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC
# [16-May-2024 16:07:38] /techco/www/tNw2sPa4q/bg/ajax/groups/upload/5864842087.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:07:58] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LDQutGB0LXRgdC-0LDRgNC4&_=1715864878083 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:08:03] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LDQutGB0LXRgdC-0LDRgNC4&_=1715864883067 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:08:03] /techco/www/tNw2sPa4q/bg/ajax/groups/insert.html?_=1715864883144 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `groups`

SELECT * FROM `groups` LIMIT 1

SHOW COLUMNS FROM `groups`

REPLACE INTO `groups` SET `ID` = '6', `PostDate` = '2024-05-16', `LastUpdate` = '2024-05-16 16:08:03', `Code` = '116', `ParentID` = '0', `Color` = '', `UploadID` = '5864842087', `Image` = 'aksesoari.png', `Visible` = 1

SELECT * FROM `group_texts` LIMIT 1

SHOW COLUMNS FROM `group_texts`

INSERT INTO `group_texts` SET `GroupID` = '6', `Language` = 'bg', `MenuLabel` = 'Аксесоари', `URLLabel` = 'аксесоари', `Title` = 'Аксесоари'
# [16-May-2024 16:08:04] /techco/www/tNw2sPa4q/bg/groups/list.html 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [16-May-2024 16:08:05] /techco/www/tNw2sPa4q/bg/ajax/groups/form.html?_=1715864885263 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC
# [16-May-2024 16:08:18] /techco/www/tNw2sPa4q/bg/ajax/groups/upload/5864885963.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:08:32] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LjQvdGB0YLRgNGD0LzQtdC90YLQuA&_=1715864911666 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:08:32] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LjQvdGB0YLRgNGD0LzQtdC90YLQuA&_=1715864912210 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:08:32] /techco/www/tNw2sPa4q/bg/ajax/groups/insert.html?_=1715864912281 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `groups`

SELECT * FROM `groups` LIMIT 1

SHOW COLUMNS FROM `groups`

REPLACE INTO `groups` SET `ID` = '7', `PostDate` = '2024-05-16', `LastUpdate` = '2024-05-16 16:08:32', `Code` = '117', `ParentID` = '0', `Color` = '', `UploadID` = '5864885963', `Image` = 'instrumenti.png', `Visible` = 1

SELECT * FROM `group_texts` LIMIT 1

SHOW COLUMNS FROM `group_texts`

INSERT INTO `group_texts` SET `GroupID` = '7', `Language` = 'bg', `MenuLabel` = 'Инструменти', `URLLabel` = 'инструменти', `Title` = 'Инструменти'
# [16-May-2024 16:08:33] /techco/www/tNw2sPa4q/bg/groups/list.html 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [16-May-2024 16:08:34] /techco/www/tNw2sPa4q/bg/ajax/groups/form.html?_=1715864913671 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC
# [16-May-2024 16:09:00] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0YXQuNCz0LjQtdC90LAt0Lgt0L_RgNC10LTQv9Cw0LfQvdC4LdGB0YDQtdC00YHRgtCy0LA&_=1715864940096 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:09:02] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0YXQuNCz0LjQtdC90LAt0Lgt0L_RgNC10LTQv9Cw0LfQvdC4LdGB0YDQtdC00YHRgtCy0LA&_=1715864942251 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:09:14] /techco/www/tNw2sPa4q/bg/ajax/groups/upload/5864914376.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:09:16] /techco/www/tNw2sPa4q/bg/ajax/groups/insert.html?_=1715864955408 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `groups`

SELECT * FROM `groups` LIMIT 1

SHOW COLUMNS FROM `groups`

REPLACE INTO `groups` SET `ID` = '8', `PostDate` = '2024-05-16', `LastUpdate` = '2024-05-16 16:09:16', `Code` = '118', `ParentID` = '0', `Color` = '', `UploadID` = '5864914376', `Image` = 'higiena-i-predpazni-sredstva.png', `Visible` = 1

SELECT * FROM `group_texts` LIMIT 1

SHOW COLUMNS FROM `group_texts`

INSERT INTO `group_texts` SET `GroupID` = '8', `Language` = 'bg', `MenuLabel` = 'Хигиена и предпазни средства', `URLLabel` = 'хигиена-и-предпазни-средства', `Title` = 'Хигиена и предпазни средства'
# [16-May-2024 16:09:16] /techco/www/tNw2sPa4q/bg/groups/list.html 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [16-May-2024 16:09:44] /techco/www/tNw2sPa4q/bg/ajax/groups/form.html?_=1715864983512 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC
# [16-May-2024 16:09:51] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LrQvtC90YHRg9C80LDRgtC40LLQuC3Qt9CwLdCz0YPQvNC4&_=1715864991269 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:09:53] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LrQvtC90YHRg9C80LDRgtC40LLQuC3Qt9CwLdCz0YPQvNC4&_=1715864992648 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:09:56] /techco/www/tNw2sPa4q/bg/ajax/groups/upload/5864984214.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:09:58] /techco/www/tNw2sPa4q/bg/ajax/groups/insert.html?_=1715864997976 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `groups`

SELECT * FROM `groups` LIMIT 1

SHOW COLUMNS FROM `groups`

REPLACE INTO `groups` SET `ID` = '9', `PostDate` = '2024-05-16', `LastUpdate` = '2024-05-16 16:09:58', `Code` = '119', `ParentID` = '0', `Color` = '', `UploadID` = '5864984214', `Image` = 'konsumativi-za-gumi.png', `Visible` = 1

SELECT * FROM `group_texts` LIMIT 1

SHOW COLUMNS FROM `group_texts`

INSERT INTO `group_texts` SET `GroupID` = '9', `Language` = 'bg', `MenuLabel` = 'Консумативи за гуми', `URLLabel` = 'консумативи-за-гуми', `Title` = 'Консумативи за гуми'
# [16-May-2024 16:09:58] /techco/www/tNw2sPa4q/bg/groups/list.html 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [16-May-2024 16:10:32] /techco/www/tNw2sPa4q/bg/ajax/groups/form.html?_=1715865031367 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`ParentID`,
                `group_texts`.`Title`,
                `group_texts`.`MenuLabel`
            FROM
                `groups`
                INNER JOIN `group_texts` ON `groups`.`ID` = `group_texts`.`GroupID`
            WHERE
                `group_texts`.`Language` = 'bg'
            ORDER BY
                `groups`.`ParentID` ASC,
                `groups`.`PostDate` ASC
# [16-May-2024 16:10:37] /techco/www/tNw2sPa4q/bg/ajax/groups/urllabel.html?URLLabel=0LDQvdGC0LjRhNGA0LjQty3QuC3RgtC10YfQvdC-0YHRgi3Rh9C40YHRgtCw0YfQutC4&_=1715865036755 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:10:41] /techco/www/tNw2sPa4q/bg/ajax/groups/upload/5865032069.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [16-May-2024 16:10:44] /techco/www/tNw2sPa4q/bg/ajax/groups/insert.html?_=1715865043504 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `groups`

SELECT * FROM `groups` LIMIT 1

SHOW COLUMNS FROM `groups`

REPLACE INTO `groups` SET `ID` = '10', `PostDate` = '2024-05-16', `LastUpdate` = '2024-05-16 16:10:44', `Code` = '120', `ParentID` = '0', `Color` = '', `UploadID` = '5865032069', `Image` = 'antifreeze.png', `Visible` = 1

SELECT * FROM `group_texts` LIMIT 1

SHOW COLUMNS FROM `group_texts`

INSERT INTO `group_texts` SET `GroupID` = '10', `Language` = 'bg', `MenuLabel` = 'Антифриз и течност чистачки', `URLLabel` = 'антифриз-и-течност-чистачки', `Title` = 'Антифриз и течност чистачки'
# [16-May-2024 16:10:44] /techco/www/tNw2sPa4q/bg/groups/list.html 108.61.209.243

set names utf8

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

SELECT
                `groups`.`ID`,
                `groups`.`PostDate`,
                `groups`.`LastUpdate`,
                `groups`.`Code`,
                `PGT`.`Title` AS `Parent`,
                `GT`.`Title`,
                `GT`.`MenuLabel`,
                `groups`.`Visible`
            FROM
                `groups`
                INNER JOIN `group_texts` AS `GT` ON `groups`.`ID` = `GT`.`GroupID`
                LEFT JOIN `group_texts` AS `PGT` ON `groups`.`ParentID` = `PGT`.`GroupID` AND `PGT`.`Language` = 'bg'
            WHERE
                `GT`.`Language` = 'bg'
         ORDER BY `PGT`.`Title` ASC, `groups`.`LastUpdate` ASC
# [16-May-2024 16:55:53] /techco/www/ 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `UploadID`,
                `Image`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

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

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

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

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `UploadID`,
                `Image`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

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

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

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

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 16:55:53] /techco/www/bg/ajax/newsletter/form/home.html?_=1715867752773 108.61.209.243

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [16-May-2024 16:55:54] /techco/www/bg/продукти.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'продукти' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
				`products`.`ID`
			FROM
				`products`
				INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
				INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
				INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
			WHERE
				(`PromoStart` IS NOT NULL OR `PromoEnd` IS NOT NULL) AND
				(`PromoStart` IS NULL OR `PromoStart` <= NOW()) AND
				(`PromoEnd` IS NULL OR `PromoEnd` >= NOW()) AND
				`product_texts`.`Language` = 'bg' AND
				`products`.`Visible` = 1 AND
				`groups`.`Visible` = 1
			LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'продукти'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'продукти'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 16:55:59] /techco/www/bg/products/масла-и-греси.html 108.61.209.243

set names utf8

SELECT
                    `GroupID`
                FROM
                    `group_texts`
                WHERE
                    `URLLabel` = 'масла-и-греси' AND
                    `Language` = 'bg'
                LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 1
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

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

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`ID`
            FROM
                `product_groups`
                INNER JOIN `product_params` ON `product_groups`.`ProductID` = `product_params`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
            WHERE
                `product_groups`.`GroupID` = 1 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 1
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('][', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (1,2,3) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Params`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('-', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (4,5) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Ranges`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                
            WHERE
                `product_groups`.`GroupID` = 1 AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC

SET SESSION group_concat_max_len = 10240

SELECT
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`ID`,
                `params`.`UploadID`,
                `params`.`FilterType`,
                `params`.`ImgValues`,
                `params`.`Prefix`,
                `params`.`Code`,
                GROUP_CONCAT(DISTINCT `PPV`.`ParamValue` SEPARATOR '][') AS `Values`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_params` AS `PPV` ON `products`.`ID` = `PPV`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `PPV`.`ParamID`
                INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                
            WHERE
                `product_groups`.`GroupID` = 1 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'products'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'products'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 16:55:59] /techco/www/bg/ajax/prices.html?_=1715867759171 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [16-May-2024 16:56:03] /techco/www/bg/ajax/prices.html?_=1715867763028 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [16-May-2024 16:56:03] /techco/www/bg/ajax/prices.html?_=1715867763061 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()

DELETE FROM `token`

INSERT INTO `token` (`ID`, `Token`, `Expires`) VALUES (NULL, '_TQ5wCfHSGJFnEXL46xQ-El98mHCxsXPKyqPjAIJrx8qQnC3tfQ_lEuSxvaaIOf4XcWBpyJI0OiGlJvuLaxemoylNyQDjWHzFJ7B1OBbuyqkAZPHhz74nUxwTDohBM6Xo1MAFjQ3JMsd4KWJ4_leG7BLtpq-2Ua-PAyW1CGANHh-N9NDRtMKHFoCP68DkwYICZKNiE1kFf8ICe5fzsEpZTGulA9H2Zu7W3mKJMWUfFaUYRYxyIqF0SHuMvZaUnzaOTn55UaaAm-ri_b50ohxG6MVs-Tbw4mwVugPx7u7AQc5cjwuYkoMAvJoMca9WcRDtKpiTje7cfD9FxNQjB2TDxdKNCFmGE_DAgToYAKiYaxl7aR_Q41JmySn4HrtzE91Av3G7oJqNNMAFB37U4fCG0B2ltId2iGq3W91bk-OX9kCtpRPyfxVgH6b67uf-pQqeNr5ZblemQo5bOuL1NJXDm1c6-UahG-ip5VOwvwGn6D7PV0-yRSZ3_Cla_DCGe4xSuuJkOVMS0DlD8iO8bkgbA', '2024-05-30')
# [16-May-2024 16:56:04] /techco/www/bg/ajax/prices.html?_=1715867763845 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [16-May-2024 16:56:04] /techco/www/bg/ajax/prices.html?_=1715867763895 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [16-May-2024 16:56:14] /techco/www/bg/products/добавки-е-аерозоли.html 108.61.209.243

set names utf8

KILL 204 -> Query: 

KILL 205 -> Query: 

SELECT
                    `GroupID`
                FROM
                    `group_texts`
                WHERE
                    `URLLabel` = 'добавки-е-аерозоли' AND
                    `Language` = 'bg'
                LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

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

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`ID`
            FROM
                `product_groups`
                INNER JOIN `product_params` ON `product_groups`.`ProductID` = `product_params`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 1
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('][', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (1,2,3) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Params`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('-', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (4,5) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Ranges`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC

SET SESSION group_concat_max_len = 10240

SELECT
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`ID`,
                `params`.`UploadID`,
                `params`.`FilterType`,
                `params`.`ImgValues`,
                `params`.`Prefix`,
                `params`.`Code`,
                GROUP_CONCAT(DISTINCT `PPV`.`ParamValue` SEPARATOR '][') AS `Values`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_params` AS `PPV` ON `products`.`ID` = `PPV`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `PPV`.`ParamID`
                INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'products'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'products'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 16:56:15] /techco/www/bg/ajax/prices.html?_=1715867774396 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [16-May-2024 16:56:20] /techco/www/bg/ajax/prices.html?_=1715867779775 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [16-May-2024 16:56:20] /techco/www/bg/ajax/prices.html?_=1715867779992 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [16-May-2024 16:56:29] /techco/www/bg/ajax/prices.html?_=1715867788383 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [16-May-2024 16:56:31] /techco/www/bg/products/2/спрей-всмукателна-система-и-egr.html 108.61.209.243

set names utf8

SELECT
               `products`.*,
               `product_texts`.*
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
            WHERE
                `product_texts`.`URLLabel` = 'спрей-всмукателна-система-и-egr' AND
                `product_texts`.`Language` = 'bg' AND
                `product_groups`.`GroupID` = 2
            LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

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

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`Code`,
                `params`.`UploadID`,
                `params`.`ImgValues`,
                `product_params`.`ParamID`,
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`Prefix`,
                GROUP_CONCAT(`ParamValue` separator '<br />') AS `Values`
            FROM
                `product_params`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                INNER JOIN `param_texts` ON `product_params`.`ParamID` = `param_texts`.`ParamID`
            WHERE
                `product_params`.`ProductID` = 2591 AND
                `param_texts`.`Language` = 'bg'
            GROUP BY
                `product_params`.`ParamID`
            ORDER BY
                `params`.`PostDate` DESC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'products'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'products'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 16:56:32] /techco/www/bg/ajax/prices.html?_=1715867791407 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [16-May-2024 16:56:45] /techco/www/bg/products/добавки-е-аерозоли.html 108.61.209.243

set names utf8

SELECT
                    `GroupID`
                FROM
                    `group_texts`
                WHERE
                    `URLLabel` = 'добавки-е-аерозоли' AND
                    `Language` = 'bg'
                LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

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

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`ID`
            FROM
                `product_groups`
                INNER JOIN `product_params` ON `product_groups`.`ProductID` = `product_params`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 1
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('][', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (1,2,3) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Params`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('-', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (4,5) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Ranges`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC

SET SESSION group_concat_max_len = 10240

SELECT
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`ID`,
                `params`.`UploadID`,
                `params`.`FilterType`,
                `params`.`ImgValues`,
                `params`.`Prefix`,
                `params`.`Code`,
                GROUP_CONCAT(DISTINCT `PPV`.`ParamValue` SEPARATOR '][') AS `Values`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_params` AS `PPV` ON `products`.`ID` = `PPV`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `PPV`.`ParamID`
                INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'products'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'products'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 16:56:46] /techco/www/bg/ajax/prices.html?_=1715867805586 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
# [16-May-2024 16:56:47] /techco/www/ 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `URLLabel` FROM `pages` WHERE `Module` = 'news' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `UploadID`,
                `Image`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 5

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

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

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

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `PostDate`,
                `URLLabel`,
                `UploadID`,
                `Image`,
                `Title`,
                `Annotation`
            FROM
                `news`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC) AS CountTable

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

SELECT
                `UploadID`,
                `Title`,
                `Image`,
                `URL`
            FROM
                `suppliers`
            WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` DESC LIMIT 0, 30

SELECT `MenuLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'suppliers' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT `URLLabel`, `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'catalogs' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

SELECT
                `ID`,
                `UploadID`,
	        	`URLLabel`,
                `Annotation`,
                `Images`,
                `Visible`
	        FROM
	        	`catalogs`
	    	WHERE
                `FirstPage` = 1 AND
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` ASC,
                `LastUpdate` ASC
            LIMIT 3

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

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 16:56:48] /techco/www/bg/ajax/newsletter/form/home.html?_=1715867807631 108.61.209.243

set names utf8

SELECT `Annotation` FROM `pages` WHERE `ParentID` = 1 AND
	`Module` = 'newsletter' AND
	`Language` = 'bg' AND
	`Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` DESC LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [16-May-2024 16:56:49] /techco/www/bg/продукти.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'продукти' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
				`products`.`ID`
			FROM
				`products`
				INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
				INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
				INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
			WHERE
				(`PromoStart` IS NOT NULL OR `PromoEnd` IS NOT NULL) AND
				(`PromoStart` IS NULL OR `PromoStart` <= NOW()) AND
				(`PromoEnd` IS NULL OR `PromoEnd` >= NOW()) AND
				`product_texts`.`Language` = 'bg' AND
				`products`.`Visible` = 1 AND
				`groups`.`Visible` = 1
			LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'продукти'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'продукти'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 16:59:02] /techco/www/bg/продукти.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'продукти' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                `G1`.`ID`,
                `G1`.`UploadID`,
                `G1`.`Image`,
                `G1`.`ID`,
                `G1`.`ParentID`,
                `G1`.`Color`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `G2`.`ParentID` AS `ParentNodeID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`ParentID` = 0 AND
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'
            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`PostDate` ASC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'продукти'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'продукти'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 16:59:34] /techco/www/bg/products/добавки-е-аерозоли.html 108.61.209.243

set names utf8

SELECT
                    `GroupID`
                FROM
                    `group_texts`
                WHERE
                    `URLLabel` = 'добавки-е-аерозоли' AND
                    `Language` = 'bg'
                LIMIT 1

SELECT
                `G1`.`ID`,
                `GT1`.`MenuLabel`,
                `GT1`.`Title`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                `GT1`.`URLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `GT1`.`Language` = 'bg' AND
                `G1`.`ID` IN (
                    WITH RECURSIVE `cte` (`ParentID`) AS (
                        SELECT `ID` FROM `groups` WHERE `ID` = 2
                        UNION ALL
                        SELECT `groups`.`ParentID` FROM `groups` INNER JOIN `cte` ON `groups`.`ID` = `cte`.`ParentID`
                    )
                    SELECT `cte`.`ParentID` FROM `cte`
                )
            GROUP BY
                `G1`.`ID`

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

SELECT
                `G1`.`ID`,
                `G1`.`ParentID`,
                `GT1`.`MenuLabel`,
                `GT1`.`URLLabel`,
                `GT2`.`URLLabel` AS `ParentURLLabel`,
                (SELECT `ID` FROM `groups` WHERE `ParentID` = `G1`.`ID` LIMIT 1) AS `ChildID`
            FROM
                `groups` AS `G1`
                INNER JOIN `group_texts` AS `GT1` ON `G1`.`ID` = `GT1`.`GroupID`
                LEFT JOIN `group_texts` AS `GT2` ON `G1`.`ParentID` = `GT2`.`GroupID` AND `GT2`.`Language` = 'bg'
                LEFT JOIN `groups` AS `G2` ON `G1`.`ID` = `G2`.`ParentID`
            WHERE
                `G1`.`Visible` = 1 AND
                `GT1`.`Language` = 'bg'

            GROUP BY
                `G1`.`ID`
            ORDER BY
                `G1`.`ParentID` ASC,
                `G1`.`PostDate` ASC

SELECT
                `params`.`ID`
            FROM
                `product_groups`
                INNER JOIN `product_params` ON `product_groups`.`ProductID` = `product_params`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 1
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

SELECT
               `products`.`ID`,
               `products`.`UploadID`,
               `products`.`RefNumber`,
               `products`.`RefID`,
               `products`.`Brand`,
               `products`.`Gallery`,
               `product_texts`.`Title`,
               `product_texts`.`URLLabel`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('][', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (1,2,3) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Params`,
               (
                    SELECT
                        GROUP_CONCAT(DISTINCT CONCAT_WS('-', `product_params`.`ParamID`, `product_params`.`ParamValue`) SEPARATOR '|') AS `Params`
                    FROM
                        `product_params`
                        INNER JOIN `params` ON `params`.`ID` = `product_params`.`ParamID`
                    WHERE
                        `product_params`.`ProductID` = `products`.`ID` AND
                        `params`.`FilterType` IN (4,5) AND
                        `params`.`Code` != 'brand'
                    GROUP BY
                        `product_params`.`ProductID`
               ) AS `Ranges`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `groups` ON `product_groups`.`GroupID` = `groups`.`ID`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `product_texts`.`Language` = 'bg' AND
                `products`.`Visible` = 1 AND
                `groups`.`Visible` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `products`.`PostDate` ASC

SET SESSION group_concat_max_len = 10240

SELECT
                `param_texts`.`Title`,
                `param_texts`.`Metric`,
                `params`.`ID`,
                `params`.`UploadID`,
                `params`.`FilterType`,
                `params`.`ImgValues`,
                `params`.`Prefix`,
                `params`.`Code`,
                GROUP_CONCAT(DISTINCT `PPV`.`ParamValue` SEPARATOR '][') AS `Values`
            FROM
                `products`
                INNER JOIN `product_groups` ON `products`.`ID` = `product_groups`.`ProductID`
                INNER JOIN `product_params` AS `PPV` ON `products`.`ID` = `PPV`.`ProductID`
                INNER JOIN `params` ON `params`.`ID` = `PPV`.`ParamID`
                INNER JOIN `param_texts` ON `params`.`ID` = `param_texts`.`ParamID`
                
            WHERE
                `product_groups`.`GroupID` = 2 AND
                `params`.`FilterType` > 0 AND
                `params`.`Required` = 0
            GROUP BY
                `params`.`ID`
            ORDER BY
                `params`.`PostDate` ASC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'products'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'products'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` <= 1 AND
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [16-May-2024 16:59:35] /techco/www/bg/ajax/prices.html?_=1715867974677 108.61.209.243

set names utf8

SELECT `Token` FROM `token` WHERE `Expires` > CURDATE()
