# [10-Dec-2022 07:27:03] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                    `pages`.`Module`,
                    `pages`.`URLLabel`,
                    `pages`.`LastUpdate`,
                        `en`.`URLLabel` AS `enURLLabel`
                     FROM `pages` 
                    LEFT JOIN `pages` AS `en` ON
                        `pages`.`ID` = `en`.`ID` AND
                        `en`.`NoIndex` = 0 AND
                        (`en`.`ExternalURL` = '' OR `en`.`ExternalURL` IS NULL) AND
                        `en`.`Language` = 'en' AND
                        `en`.`Visible` = 1
                    WHERE
                    `pages`.`NoIndex` = 0 AND
                    (`pages`.`ExternalURL` = '' OR `pages`.`ExternalURL` IS NULL) AND
                    `pages`.`Language` = 'bg' AND
                    `pages`.`Visible` = 1
                ORDER BY
                    `pages`.`PostDate` ASC

SELECT
                    CONCAT_WS('/', `pages`.`URLLabel`, `product_texts`.`URLLabel`) AS `URLLabel`,
                    `products`.`LastUpdate`,
                        IF(`enProductText`.`URLLabel` IS NULL, '', CONCAT_WS('/', `enPage`.`URLLabel`, `enProductText`.`URLLabel`)) AS `enURLLabel`
                    
                FROM
                    `products`
                    INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                    INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Module` = 'products' AND `pages`.`Language` = 'bg'
            
                        LEFT JOIN `product_texts` AS `enProductText` ON
                            `product_texts`.`ProductID` = `enProductText`.`ProductID` AND
                            `enProductText`.`Language` = 'en'
                        LEFT JOIN `pages` AS `enPage` ON
                            `products`.`ParentID` = `enPage`.`ID` AND
                            `enPage`.`Module` = 'products' AND
                            `enPage`.`Language` = 'en' AND
                            `enPage`.`Visible` = 1
                    
                WHERE
                    `product_texts`.`Language` = 'bg' AND
                    `products`.`Visible` = 1
# [10-Dec-2022 07:28:04] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                    `pages`.`Module`,
                    `pages`.`URLLabel`,
                    `pages`.`LastUpdate`,
                        `en`.`URLLabel` AS `enURLLabel`
                     FROM `pages` 
                    LEFT JOIN `pages` AS `en` ON
                        `pages`.`ID` = `en`.`ID` AND
                        `en`.`NoIndex` = 0 AND
                        (`en`.`ExternalURL` = '' OR `en`.`ExternalURL` IS NULL) AND
                        `en`.`Language` = 'en' AND
                        `en`.`Visible` = 1
                    WHERE
                    `pages`.`NoIndex` = 0 AND
                    (`pages`.`ExternalURL` = '' OR `pages`.`ExternalURL` IS NULL) AND
                    `pages`.`Language` = 'bg' AND
                    `pages`.`Visible` = 1
                ORDER BY
                    `pages`.`PostDate` ASC

SELECT
                    CONCAT_WS('/', `pages`.`URLLabel`, `product_texts`.`URLLabel`) AS `URLLabel`,
                    `products`.`LastUpdate`,
                        IF(`enProductText`.`URLLabel` IS NULL, '', CONCAT_WS('/', `enPage`.`URLLabel`, `enProductText`.`URLLabel`)) AS `enURLLabel`
                    
                FROM
                    `products`
                    INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                    INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Module` = 'products' AND `pages`.`Language` = 'bg'
            
                        LEFT JOIN `product_texts` AS `enProductText` ON
                            `product_texts`.`ProductID` = `enProductText`.`ProductID` AND
                            `enProductText`.`Language` = 'en'
                        LEFT JOIN `pages` AS `enPage` ON
                            `products`.`ParentID` = `enPage`.`ID` AND
                            `enPage`.`Module` = 'products' AND
                            `enPage`.`Language` = 'en' AND
                            `enPage`.`Visible` = 1
                    
                WHERE
                    `product_texts`.`Language` = 'bg' AND
                    `products`.`Visible` = 1
# [10-Dec-2022 07:29:50] /www/root/en/sзаглавиеdfgsd-fgsdf.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'sзаглавиеdfgsd-fgsdf' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:29:57] /www/root/en/sзаглавиеdfgsd-fgsdf.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'sзаглавиеdfgsd-fgsdf' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:29:57] /www/root/en/ajax/users/bar.html?_=1670650198556 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [10-Dec-2022 07:31:57] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                    `pages`.`Module`,
                    `pages`.`URLLabel`,
                    `pages`.`LastUpdate`,
                        `en`.`URLLabel` AS `enURLLabel`
                     FROM `pages` 
                    LEFT JOIN `pages` AS `en` ON
                        `pages`.`ID` = `en`.`ID` AND
                        `en`.`NoIndex` = 0 AND
                        (`en`.`ExternalURL` = '' OR `en`.`ExternalURL` IS NULL) AND
                        `en`.`Language` = 'en' AND
                        `en`.`Visible` = 1
                    WHERE
                    `pages`.`NoIndex` = 0 AND
                    (`pages`.`ExternalURL` = '' OR `pages`.`ExternalURL` IS NULL) AND
                    `pages`.`Language` = 'bg' AND
                    `pages`.`Visible` = 1
                ORDER BY
                    `pages`.`PostDate` ASC

SELECT
                    CONCAT_WS('/', `pages`.`URLLabel`, `product_texts`.`URLLabel`) AS `URLLabel`,
                    `products`.`LastUpdate`,
                        IF(`enProductText`.`URLLabel` IS NULL OR `enPage`.`URLLabel` IS NULL, '', CONCAT_WS('/', `enPage`.`URLLabel`, `enProductText`.`URLLabel`)) AS `enURLLabel`
                    
                FROM
                    `products`
                    INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                    INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Module` = 'products' AND `pages`.`Language` = 'bg'
            
                        LEFT JOIN `product_texts` AS `enProductText` ON
                            `product_texts`.`ProductID` = `enProductText`.`ProductID` AND
                            `enProductText`.`Language` = 'en'
                        LEFT JOIN `pages` AS `enPage` ON
                            `products`.`ParentID` = `enPage`.`ID` AND
                            `enPage`.`Module` = 'products' AND
                            `enPage`.`Language` = 'en' AND
                            `enPage`.`Visible` = 1
                    
                WHERE
                    `product_texts`.`Language` = 'bg' AND
                    `products`.`Visible` = 1
# [10-Dec-2022 07:32:30] /www/root/en/index.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:32:31] /www/root/en/ajax/users/bar.html?_=1670650352174 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [10-Dec-2022 07:32:35] /www/root/en/events.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'events' AND
	    		`URLLabel` = 'events' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'events' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'en' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:32:35] /www/root/en/ajax/users/bar.html?_=1670650356717 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [10-Dec-2022 07:32:36] /www/root/en/reviews.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'reviews' AND
	    		`URLLabel` = 'reviews' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'reviews' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

SELECT
	        	*
	        FROM
	        	`reviews`
	    	WHERE
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:32:36] /www/root/en/ajax/users/bar.html?_=1670650357784 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [10-Dec-2022 07:32:38] /www/root/en/contacts.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'contacts' AND
	    		`URLLabel` = 'contacts' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:32:38] /www/root/en/ajax/users/bar.html?_=1670650360026 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [10-Dec-2022 07:32:38] /www/root/en/ajax/contacts/form.html?_=1670650360023 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LSend') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorMessage','ErrorIAgree') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'terms' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1
# [10-Dec-2022 07:32:40] /www/root/en/careers.html 167.99.142.201

set names utf8

SELECT
	        	*
	        FROM
	        	`careers`
	    	WHERE
                `Language` = 'en' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'careers' AND `Action` = 'empty' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'careers' AND
	    		`URLLabel` = 'no-positions' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:32:40] /www/root/en/ajax/users/bar.html?_=1670650361682 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [10-Dec-2022 07:32:42] /www/root/en/brands.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'brands' AND
	    		`URLLabel` = 'brands' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT * FROM `brands` WHERE `Language` = 'en' AND `Visible` = 1 ORDER BY `PostDate` DESC

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:32:43] /www/root/en/ajax/users/bar.html?_=1670650364280 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [10-Dec-2022 07:32:48] /www/root/en/user/register.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'user' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `Action`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `URLLabel` = 'register' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'users' AND
	    		`URLLabel` = 'register' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:32:48] /www/root/en/ajax/users/form/register.html?_=1670650369646 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSignupEMail','LSignup') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:32:48] /www/root/en/ajax/users/bar.html?_=1670650369647 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'terms' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1
# [10-Dec-2022 07:32:50] /www/root/en/user/login.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'user' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `Action`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `URLLabel` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'users' AND
	    		`URLLabel` = 'login' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:32:51] /www/root/en/ajax/users/bar.html?_=1670650372262 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'login' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [10-Dec-2022 07:32:51] /www/root/en/ajax/users/form/login.html?_=1670650372261 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLoginEMail','LLogin') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'forgot' AND `Visible` = 1 LIMIT 1

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNewAccount','LCreateAccount') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:35:59] /www/root/en/ajax/users/login.html?_=1670650560902 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '6KJKfCCzsZkx2638M1Znc4GN618nnPJ0Ns3gzkQ802iLBlTgHB5NRZMc6YMfx0b2'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPassword','LRememberMe') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPassword') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:36:04] /www/root/en/ajax/users/login.html?_=1670650565169 167.99.142.201

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` = '6KJKfCCzsZkx2638M1Znc4GN618nnPJ0Ns3gzkQ802iLBlTgHB5NRZMc6YMfx0b2'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [10-Dec-2022 07:36:04] /www/root/mgR8sVa0D/en/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'en'
                
            ORDER BY  `ID` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1
# [10-Dec-2022 07:36:10] /www/root/mgR8sVa0D/en/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'en'
                
            ORDER BY  `ID` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1
# [10-Dec-2022 07:36:39] /www/root/mgR8sVa0D/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1
# [10-Dec-2022 07:36:41] /www/root/mgR8sVa0D/bg/ajax/pages/form/10.html?_=1670650602557 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 07:36:49] /www/root/mgR8sVa0D/en/ajax/pages/form/10.html?_=1670650610952 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10
            LIMIT 1
# [10-Dec-2022 07:37:40] /www/root/mgR8sVa0D/en/ajax/pages/insert/10.html?_=1670650661655 167.99.142.201

set names utf8

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

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

INSERT INTO `pages` SET `ID` = '10', `Language` = 'en', `PostDate` = '2022-09-05', `LastUpdate` = '2022-12-10 07:37:40', `UploadID` = '10', `MetaTitle` = 'Products Мета title', `MetaDescription` = 'Products Мета description', `MetaImage` = '', `NoIndex` = 0, `ExternalURL` = '', `MenuLabel` = 'Products', `FooterLabel` = 'Products', `URLLabel` = 'products', `Images` = '', `Title` = 'Products', `Annotation` = 'Products annotation', `Content` = 'Products content<br>', `AddContent` = 'faq', `AddOn` = '', `Visible` = 1, `ParentID` = 1, `Module` = 'pages'
# [10-Dec-2022 07:37:40] /www/root/mgR8sVa0D/en/products.html 167.99.142.201

set names utf8

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'products' AND `Language` = 'en' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:37:40] /www/root/en/ajax/users/bar.html?_=1670650662094 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:40:55] /www/root/mgR8sVa0D/en/products.html 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [10-Dec-2022 07:41:26] /www/root/mgR8sVa0D/en/products.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'products' AND
	    		`URLLabel` = 'products' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'products' AND `Language` = 'en' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:41:27] /www/root/en/ajax/users/bar.html?_=1670650888244 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:41:30] /www/root/en/products.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'products' AND
	    		`URLLabel` = 'products' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'products' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:41:31] /www/root/en/ajax/users/bar.html?_=1670650892360 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:43:09] /www/root/en/index.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:43:10] /www/root/en/ajax/users/bar.html?_=1670650991477 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:43:11] /www/root/en/ajax/users/bar.html?_=1670650993042 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:43:12] /www/root/en/products.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'products' AND
	    		`URLLabel` = 'products' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'products' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:43:12] /www/root/en/ajax/users/bar.html?_=1670650993782 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:43:45] /www/root/en/products.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'products' AND
	    		`URLLabel` = 'products' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'products' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:43:45] /www/root/en/ajax/users/bar.html?_=1670651026697 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:45:54] /www/root/en/products.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'products' AND
	    		`URLLabel` = 'products' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT * FROM `faq` WHERE `PageID` = 10 AND `Language` = 'en' AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'products' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

SELECT
	        	*
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
                `Language` = 'en' AND
                `Gallery` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:45:54] /www/root/en/ajax/users/bar.html?_=1670651155538 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:45:55] /www/root/en/ajax/products/prices.html?_=1670651156265 167.99.142.201

set names utf8

SELECT
                `ID` AS `ProductID`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `products` WHERE `ID` IN ('1245623')
# [10-Dec-2022 07:46:15] /www/root/en/products.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'products' AND
	    		`URLLabel` = 'products' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT * FROM `faq` WHERE `PageID` = 10 AND `Language` = 'en' AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'products' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

SELECT
	        	*
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
                `Language` = 'en' AND
                `Gallery` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:46:15] /www/root/en/ajax/users/bar.html?_=1670651177034 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:46:15] /www/root/en/ajax/products/prices.html?_=1670651177035 167.99.142.201

set names utf8

SELECT
                `ID` AS `ProductID`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `products` WHERE `ID` IN ('1245623')
# [10-Dec-2022 07:46:28] /www/root/mgR8sVa0D 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `SubTitle`,
                `URL`,
                `ButtonLabel`
            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

UPDATE `slides` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('2','1') AND `Language` = 'bg'

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'index' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

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

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != ''
         AND `FirstPage` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'events'
         LIMIT 1

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

SELECT
	        	*
	        FROM
	        	`reviews`
	    	WHERE
                `Language` = 'bg'
         AND `FirstPage` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 2

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'reviews'
         LIMIT 1

SELECT COUNT(`ID`) FROM `reviews` WHERE `Language` = 'bg'

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'contacts'
         LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 07:46:29] /www/root/bg/ajax/users/bar.html?_=1670651190597 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:46:29] /www/root/bg/ajax/contacts/form.html?_=1670651190596 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LSubject','LMessage','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorMessage','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 07:46:29] /www/root/bg/ajax/basket/qty.html?_=1670651190597 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = '0ca66bcca4b1a07b7112836b9bb0674ca3578b0fd0503c9a8dfc0580bdce4333'
                 LIMIT 1
# [10-Dec-2022 07:46:32] /www/root/mgR8sVa0D/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1
# [10-Dec-2022 07:46:36] /www/root/mgR8sVa0D/bg/ajax/pages/form/10.html?_=1670651197573 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 07:46:42] /www/root/mgR8sVa0D/en/ajax/pages/form/10.html?_=1670651203841 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1
# [10-Dec-2022 07:46:44] /www/root/mgR8sVa0D/bg/ajax/pages/form/10.html?_=1670651206007 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 07:46:46] /www/root/mgR8sVa0D/en/ajax/pages/form/10.html?_=1670651207671 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1
# [10-Dec-2022 07:46:52] /www/root/mgR8sVa0D/bg/ajax/pages/form/10.html?_=1670651213815 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 07:46:54] /www/root/mgR8sVa0D/en/ajax/pages/form/10.html?_=1670651215382 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1
# [10-Dec-2022 07:47:01] /www/root/mgR8sVa0D/bg/ajax/pages/form/10.html?_=1670651222263 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 07:47:02] /www/root/mgR8sVa0D/en/ajax/pages/form/10.html?_=1670651223607 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1
# [10-Dec-2022 07:47:42] /www/root/mgR8sVa0D/bg/ajax/pages/form/10.html?_=1670651264035 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 07:48:17] /www/root/mgR8sVa0D/bg/products/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `LastUpdate` DESC

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

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

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

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'products' AND `Language` = 'bg' LIMIT 1
# [10-Dec-2022 07:48:19] /www/root/mgR8sVa0D/bg/ajax/products/form/1245623.html?_=1670651300916 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` = 1245623 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `Title`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                ((`ParentID` = 1 AND `Module` = 'products') OR `AddContent` LIKE '%products%')
# [10-Dec-2022 07:48:27] /www/root/mgR8sVa0D/en/ajax/products/form/1245623.html?_=1670651308320 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` = 1245623 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `Title`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                ((`ParentID` = 1 AND `Module` = 'products') OR `AddContent` LIKE '%products%')
# [10-Dec-2022 07:48:31] /www/root/mgR8sVa0D/bg/ajax/products/form/2657856655.html?_=1670651312163 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` = 2657856655 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `Title`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                ((`ParentID` = 1 AND `Module` = 'products') OR `AddContent` LIKE '%products%')
# [10-Dec-2022 07:48:33] /www/root/mgR8sVa0D/en/ajax/products/form/2657856655.html?_=1670651314814 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` = 2657856655 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` = 2657856655
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `Title`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                ((`ParentID` = 1 AND `Module` = 'products') OR `AddContent` LIKE '%products%')
# [10-Dec-2022 07:48:58] /www/root/mgR8sVa0D/en/ajax/products/insert/2657856655.html?_=1670651339511 167.99.142.201

set names utf8

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

SELECT
                `ID`
            FROM
                `products`
            WHERE
                `RefID` = 'ias21345123'
         AND `ID` != 2657856655 LIMIT 1

SELECT * FROM `products` LIMIT 1

SHOW COLUMNS FROM `products`

INSERT INTO `products` SET `ID` = '2657856655', `PostDate` = '2022-09-26', `LastUpdate` = '2022-12-10 07:48:58', `UploadID` = '4162877042', `ParentID` = '10', `RefNumber` = 'IAS21345123', `RefID` = 'ias21345123', `MetaImage` = '992ee2k318-430_10.jpg', `NoIndex` = 0, `Price` = 12, `PromoPrice` = 11, `SensorPrice` = 3, `StartFrom` = '2022-09-02', `EndTo` = '2023-01-28', `Weight` = 0.5, `Sizes` = 'XS,S,M,L,XL', `Gallery` = '["winterhome.png"]', `Pairs` = '', `Selected` = 0, `InStock` = 1, `Visible` = 1

SELECT * FROM `product_texts` LIMIT 1

SHOW COLUMNS FROM `product_texts`

INSERT INTO `product_texts` SET `ProductID` = '2657856655', `Language` = 'en', `MetaTitle` = 'Jersey v-neck t-shirt  EN', `MetaDescription` = 'Jersey v-neck t-shirt   EN', `Title` = 'Jersey v-neck t-shirt   EN', `URLLabel` = 'jersey-v-neck-t-shirt', `Content` = 'This v-neck t-shirt is bound to impress with its fashionable slim fit.  EN<br><br>    Jersey fabric composed of sustainable cotton<br>    V-neckline<br>    Slim fit<br><br>'
# [10-Dec-2022 07:50:23] /www/root/mgR8sVa0D/bg/products/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `LastUpdate` DESC

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

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

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

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'products' AND `Language` = 'bg' LIMIT 1
# [10-Dec-2022 07:50:26] /www/root/mgR8sVa0D/bg/ajax/products/form/2657856655.html?_=1670651427196 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` = 2657856655 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `Title`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                ((`ParentID` = 1 AND `Module` = 'products') OR `AddContent` LIKE '%products%')
# [10-Dec-2022 07:50:29] /www/root/mgR8sVa0D/en/ajax/products/form/2657856655.html?_=1670651430646 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` = 2657856655 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `Title`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                ((`ParentID` = 1 AND `Module` = 'products') OR `AddContent` LIKE '%products%')
# [10-Dec-2022 07:50:51] /www/root/mgR8sVa0D/bg/ajax/products/form/2657856658.html?_=1670651452299 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` = 2657856658 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `Title`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                ((`ParentID` = 1 AND `Module` = 'products') OR `AddContent` LIKE '%products%')

SELECT
                `ID`,
                `Title`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` IN ('2657856655','2657856656','2657856657') AND
                `Language` = 'bg'
# [10-Dec-2022 07:50:54] /www/root/mgR8sVa0D/en/ajax/products/form/2657856658.html?_=1670651455625 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` = 2657856658 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` = 2657856658
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `Title`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                ((`ParentID` = 1 AND `Module` = 'products') OR `AddContent` LIKE '%products%')

SELECT
                `ID`,
                `Title`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `ID` IN ('2657856655','2657856656','2657856657') AND
                `Language` = 'en'
# [10-Dec-2022 07:52:56] /www/root/mgR8sVa0D/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1
# [10-Dec-2022 07:53:08] /www/root/mgR8sVa0D/bg/ajax/pages/form.html?_=1670651589483 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [10-Dec-2022 07:53:27] /www/root/mgR8sVa0D/bg/ajax/pages/insert.html?_=1670651608118 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [10-Dec-2022 08:03:24] /www/root/mgR8sVa0D/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `ID` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'contacts' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'careers' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1
# [10-Dec-2022 08:03:28] /www/root/mgR8sVa0D/bg/ajax/pages/form.html?_=1670652209115 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [10-Dec-2022 08:03:42] /www/root/mgR8sVa0D/bg/ajax/pages/insert.html?_=1670652223413 167.99.142.201

set names utf8

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

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

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

INSERT INTO `pages` SET `ID` = '77', `Language` = 'bg', `PostDate` = '2022-12-10', `LastUpdate` = '2022-12-10 08:03:42', `UploadID` = '652208015', `MetaTitle` = 'test', `MetaDescription` = 'test', `MetaImage` = '', `NoIndex` = 0, `ExternalURL` = '', `MenuLabel` = 'test', `FooterLabel` = '', `URLLabel` = 'testtest', `Images` = '', `Title` = 'test', `Annotation` = 'test', `Content` = 'test', `AddContent` = '', `AddOn` = '', `Visible` = 1, `ParentID` = 1, `Module` = 'pages'
# [10-Dec-2022 08:03:42] /www/root/mgR8sVa0D/bg/testtest.html 167.99.142.201

set names utf8

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

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'testtest' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'testtest' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 08:03:42] /www/root/bg/ajax/users/bar.html?_=1670652224049 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 08:03:42] /www/root/bg/ajax/basket/qty.html?_=1670652224050 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = '0ca66bcca4b1a07b7112836b9bb0674ca3578b0fd0503c9a8dfc0580bdce4333'
                 LIMIT 1
# [10-Dec-2022 08:03:45] /www/root/mgR8sVa0D/bg/ajax/pages/form/77.html?_=1670652226634 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 77 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 08:04:18] /www/root/mgR8sVa0D/bg/ajax/pages/form/77.html?_=1670652259938 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 77 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 08:04:21] /www/root/mgR8sVa0D/en/ajax/pages/form/77.html?_=1670652263061 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 77 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 77
            LIMIT 1
# [10-Dec-2022 08:04:28] /www/root/mgR8sVa0D/bg/ajax/pages/form/77.html?_=1670652269242 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 77 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 08:04:36] /www/root/mgR8sVa0D/bg/ajax/pages/update/77.html?_=1670652277371 167.99.142.201

set names utf8

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

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

UPDATE `pages` SET `ID` = '77', `Language` = 'bg', `PostDate` = '2022-12-10', `LastUpdate` = '2022-12-10 08:04:36', `UploadID` = '652208015', `MetaTitle` = 'test BG', `MetaDescription` = 'test', `MetaImage` = '', `NoIndex` = 0, `ExternalURL` = '', `MenuLabel` = 'test', `FooterLabel` = '', `URLLabel` = 'testtest', `Images` = '', `Title` = 'test BG', `Annotation` = 'test', `Content` = 'test', `AddContent` = '', `AddOn` = '', `Visible` = 1 WHERE `ID` = '77' AND `Language` = 'bg'
# [10-Dec-2022 08:04:36] /www/root/mgR8sVa0D/bg/testtest.html 167.99.142.201

set names utf8

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

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'testtest' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'testtest' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 08:04:36] /www/root/bg/ajax/users/bar.html?_=1670652277988 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 08:04:36] /www/root/bg/ajax/basket/qty.html?_=1670652277988 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = '0ca66bcca4b1a07b7112836b9bb0674ca3578b0fd0503c9a8dfc0580bdce4333'
                 LIMIT 1
# [10-Dec-2022 08:04:38] /www/root/mgR8sVa0D/bg/ajax/pages/form/77.html?_=1670652279610 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 77 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 08:04:40] /www/root/mgR8sVa0D/en/ajax/pages/form/77.html?_=1670652281822 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 77 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 77
            LIMIT 1
# [10-Dec-2022 08:04:50] /www/root/mgR8sVa0D/en/ajax/pages/insert/77.html?_=1670652291765 167.99.142.201

set names utf8

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

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

INSERT INTO `pages` SET `ID` = '77', `Language` = 'en', `PostDate` = '2022-12-10', `LastUpdate` = '2022-12-10 08:04:50', `UploadID` = '652208015', `MetaTitle` = 'test EN', `MetaDescription` = 'test', `MetaImage` = '', `NoIndex` = 0, `ExternalURL` = '', `MenuLabel` = 'test', `FooterLabel` = '', `URLLabel` = 'testtest', `Images` = '', `Title` = 'test EN', `Annotation` = 'test', `Content` = 'test', `AddContent` = '', `AddOn` = '', `Visible` = 1, `ParentID` = 1, `Module` = 'pages'
# [10-Dec-2022 08:04:50] /www/root/mgR8sVa0D/en/testtest.html 167.99.142.201

set names utf8

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

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'testtest' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'testtest' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 08:04:51] /www/root/en/ajax/users/bar.html?_=1670652292295 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 08:04:53] /www/root/mgR8sVa0D/en/ajax/pages/form/77.html?_=1670652294794 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 77 AND
                `Language` = 'en'
            LIMIT 1
# [10-Dec-2022 08:04:55] /www/root/mgR8sVa0D/bg/ajax/pages/form/77.html?_=1670652296894 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 77 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 08:04:57] /www/root/mgR8sVa0D/en/ajax/pages/form/77.html?_=1670652298486 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 77 AND
                `Language` = 'en'
            LIMIT 1
# [10-Dec-2022 08:05:09] /www/root/mgR8sVa0D/en/products.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'products' AND
	    		`URLLabel` = 'products' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

SELECT * FROM `faq` WHERE `PageID` = 10 AND `Language` = 'en' ORDER BY `PostDate` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'products' AND `Language` = 'en' LIMIT 1

SELECT
	        	*
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
                `Language` = 'en' AND
                `Gallery` != ''
         ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [10-Dec-2022 08:05:09] /www/root/en/ajax/users/bar.html?_=1670652310677 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [10-Dec-2022 08:05:09] /www/root/en/ajax/products/prices.html?_=1670652310678 167.99.142.201

set names utf8

SELECT
                `ID` AS `ProductID`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `products` WHERE `ID` IN ('1245623','2657856655')
# [10-Dec-2022 08:05:12] /www/root/mgR8sVa0D/en/ajax/pages/form/10.html?_=1670652313955 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1
# [10-Dec-2022 08:05:16] /www/root/mgR8sVa0D/bg/ajax/pages/form/10.html?_=1670652317830 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Dec-2022 08:05:19] /www/root/mgR8sVa0D/en/ajax/pages/form/10.html?_=1670652320238 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 10 AND
                `Language` = 'en'
            LIMIT 1
