# [19-Nov-2022 08:45:23] /mygr/www/ 167.99.142.201

set names utf8

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

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

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

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `ParentID` = 1 AND
	    		`Module` = 'products'
         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 `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT COUNT(`ID`) FROM `reviews` WHERE `Language` = 'en' AND `Visible` = 1

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `ParentID` = 1 AND
	    		`Module` = 'reviews'
         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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:45:23] /mygr/www/en/ajax/cookies.html?_=1668840323884 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:45:23] /mygr/www/en/ajax/users/bar.html?_=1668840323885 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
# [19-Nov-2022 08:45:23] /mygr/www/en/ajax/basket/qty.html?_=1668840323885 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:45:23] /mygr/www/en/ajax/products/prices.html?_=1668840323887 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('3','4','6') AND
                `Language` = 'en'
# [19-Nov-2022 08:54:40] /mygr/www/en/products.html 167.99.142.201

set names utf8

SELECT
                `products`.`ID`,
                `products`.`RefID`,
                `products`.`UploadID`,
                `products`.`Gallery`,
                `products`.`Visible`,
                `product_texts`.`Language`,
                `product_texts`.`Title`,
                `product_texts`.`URLLabel`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `product_texts`.`Language` = 'en' AND
                `pages`.`URLLabel` = 'products' AND
                `products`.`Gallery` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

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

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

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

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` = 'reviews' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

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

SELECT COUNT(`ID`) FROM `reviews` WHERE `Language` = 'en' AND `Visible` = 1

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `ParentID` = 1 AND
	    		`Module` = 'reviews'
         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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:54:40] /mygr/www/en/ajax/users/bar.html?_=1668840880862 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
# [19-Nov-2022 08:54:40] /mygr/www/en/ajax/products/prices.html?_=1668840880867 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('3','4','6') AND
                `Language` = 'en'
# [19-Nov-2022 08:54:40] /mygr/www/en/ajax/basket/qty.html?_=1668840880866 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:54:44] /mygr/www/en/accessories.html 167.99.142.201

set names utf8

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

SELECT
                `products`.`ID`,
                `products`.`RefID`,
                `products`.`UploadID`,
                `products`.`Gallery`,
                `products`.`Visible`,
                `product_texts`.`Language`,
                `product_texts`.`Title`,
                `product_texts`.`URLLabel`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `product_texts`.`Language` = 'en' AND
                `pages`.`URLLabel` = 'accessories' AND
                `products`.`Gallery` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

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

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

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'products' AND
	    		`URLLabel` = 'accessories' 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 `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT COUNT(`ID`) FROM `reviews` WHERE `Language` = 'en' AND `Visible` = 1

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `ParentID` = 1 AND
	    		`Module` = 'reviews'
         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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:54:44] /mygr/www/en/ajax/users/bar.html?_=1668840885142 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
# [19-Nov-2022 08:54:45] /mygr/www/en/ajax/products/prices.html?_=1668840885148 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('8','9') AND
                `Language` = 'en'
# [19-Nov-2022 08:54:45] /mygr/www/en/ajax/basket/qty.html?_=1668840885144 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:54:46] /mygr/www/en/products.html 167.99.142.201

set names utf8

SELECT
                `products`.`ID`,
                `products`.`RefID`,
                `products`.`UploadID`,
                `products`.`Gallery`,
                `products`.`Visible`,
                `product_texts`.`Language`,
                `product_texts`.`Title`,
                `product_texts`.`URLLabel`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `product_texts`.`Language` = 'en' AND
                `pages`.`URLLabel` = 'products' AND
                `products`.`Gallery` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

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

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

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

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` = 'reviews' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

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

SELECT COUNT(`ID`) FROM `reviews` WHERE `Language` = 'en' AND `Visible` = 1

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `ParentID` = 1 AND
	    		`Module` = 'reviews'
         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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:54:47] /mygr/www/en/ajax/users/bar.html?_=1668840887208 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
# [19-Nov-2022 08:54:47] /mygr/www/en/ajax/basket/qty.html?_=1668840887208 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:54:47] /mygr/www/en/ajax/products/prices.html?_=1668840887209 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('3','4','6') AND
                `Language` = 'en'
# [19-Nov-2022 08:54:48] /mygr/www/en/faq.html 167.99.142.201

set names utf8

SELECT
                        `ID`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'faq' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

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

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

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

SELECT
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:54:49] /mygr/www/en/ajax/users/bar.html?_=1668840889348 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
# [19-Nov-2022 08:54:49] /mygr/www/en/ajax/basket/qty.html?_=1668840889349 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:54:52] /mygr/www/en/installation-manual.html 167.99.142.201

set names utf8

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

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

SELECT
                `ID`,
                `ASideLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `ASideLabel` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

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

SELECT
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:54:52] /mygr/www/en/ajax/users/bar.html?_=1668840893108 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
# [19-Nov-2022 08:54:52] /mygr/www/en/ajax/basket/qty.html?_=1668840893108 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:54:59] /mygr/www/en/products.html 167.99.142.201

set names utf8

SELECT
                `products`.`ID`,
                `products`.`RefID`,
                `products`.`UploadID`,
                `products`.`Gallery`,
                `products`.`Visible`,
                `product_texts`.`Language`,
                `product_texts`.`Title`,
                `product_texts`.`URLLabel`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `product_texts`.`Language` = 'en' AND
                `pages`.`URLLabel` = 'products' AND
                `products`.`Gallery` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

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

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

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

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` = 'reviews' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

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

SELECT COUNT(`ID`) FROM `reviews` WHERE `Language` = 'en' AND `Visible` = 1

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `ParentID` = 1 AND
	    		`Module` = 'reviews'
         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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:55:00] /mygr/www/en/ajax/users/bar.html?_=1668840900225 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
# [19-Nov-2022 08:55:00] /mygr/www/en/ajax/basket/qty.html?_=1668840900226 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:55:00] /mygr/www/en/ajax/products/prices.html?_=1668840900234 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('3','4','6') AND
                `Language` = 'en'
# [19-Nov-2022 08:56:56] /mygr/www/en/products.html 167.99.142.201

set names utf8

SELECT
                `products`.`ID`,
                `products`.`RefID`,
                `products`.`UploadID`,
                `products`.`Gallery`,
                `products`.`Visible`,
                `product_texts`.`Language`,
                `product_texts`.`Title`,
                `product_texts`.`URLLabel`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `product_texts`.`Language` = 'en' AND
                `pages`.`URLLabel` = 'products' AND
                `products`.`Gallery` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

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

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

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

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` = 'reviews' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

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

SELECT COUNT(`ID`) FROM `reviews` WHERE `Language` = 'en' AND `Visible` = 1

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `ParentID` = 1 AND
	    		`Module` = 'reviews'
         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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:56:56] /mygr/www/en/ajax/users/bar.html?_=1668841016904 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
# [19-Nov-2022 08:56:56] /mygr/www/en/ajax/basket/qty.html?_=1668841016904 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:56:56] /mygr/www/en/ajax/products/prices.html?_=1668841016905 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('3','4','6') AND
                `Language` = 'en'
# [19-Nov-2022 08:57:06] /mygr/www/en/products.html 167.99.142.201

set names utf8

SELECT
                `products`.`ID`,
                `products`.`RefID`,
                `products`.`UploadID`,
                `products`.`Gallery`,
                `products`.`Visible`,
                `product_texts`.`Language`,
                `product_texts`.`Title`,
                `product_texts`.`URLLabel`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `product_texts`.`Language` = 'en' AND
                `pages`.`URLLabel` = 'products' AND
                `products`.`Gallery` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

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

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

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

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` = 'reviews' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

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

SELECT COUNT(`ID`) FROM `reviews` WHERE `Language` = 'en' AND `Visible` = 1

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `ParentID` = 1 AND
	    		`Module` = 'reviews'
         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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:57:07] /mygr/www/en/ajax/users/bar.html?_=1668841027587 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
# [19-Nov-2022 08:57:07] /mygr/www/en/ajax/basket/qty.html?_=1668841027588 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:57:07] /mygr/www/en/ajax/products/prices.html?_=1668841027591 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('3','4','6') AND
                `Language` = 'en'
# [19-Nov-2022 08:57:08] /mygr/www/en/products/mygregor-station-black.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
	    		`URLLabel` = 'mygregor-station-black' AND
                `Language` = 'en'
         AND `Visible` = 1 LIMIT 1

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LColor') 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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:57:08] /mygr/www/en/ajax/users/bar.html?_=1668841028733 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
# [19-Nov-2022 08:57:08] /mygr/www/en/ajax/basket/qty.html?_=1668841028734 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:57:08] /mygr/www/en/ajax/products/prices.html?_=1668841028735 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('3') AND
                `Language` = 'en'
# [19-Nov-2022 08:57:10] /mygr/www/en/ajax/basket/add.html?_=1668841030221 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb', NOW(), NOW(), '{"eyJpZCI6IjMifQ":1}', 1)

SELECT
                `ID`,
                `UploadID`,
                `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                `Price`,
                `PromoPrice`,
                `RadiationSensorPrice`,
                /* Promo */
                `StartFrom`,
                `EndTo`,
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `PromoPrice` > 0 AND
                `PromoPrice` < `Price` AS `Promo`,
                /* *** */
                `Pairs`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
	    	WHERE
	    		`ID` = 3 AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                    `Data`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                `Price`,
                `PromoPrice`,
                `RadiationSensorPrice`,
                `StartFrom`,
                `EndTo`,
                /* Promo */
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `PromoPrice` > 0 AND
                `PromoPrice` < `Price` AS `Promo`
            FROM
                `products`
                INNER JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `Products` LIKE '%"3"%' AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

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

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

SELECT
                `ID`,
                `UploadID`,
                `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                `Price`,
                `PromoPrice`,
                `RadiationSensorPrice`,
                `StartFrom`,
                `EndTo`,
                /* Promo */
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `PromoPrice` > 0 AND
                `PromoPrice` < `Price` AS `Promo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
            WHERE
                `ID` IN ('5','7') AND
                `Visible` = 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoesWith') 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
# [19-Nov-2022 08:57:10] /mygr/www/en/ajax/basket/qty.html?_=1668841030297 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:57:12] /mygr/www/en/ajax/basket/update.html?_=1668841033149 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjMifQ":1,"eyJpZCI6IjUifQ":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                            LIMIT 1
# [19-Nov-2022 08:57:13] /mygr/www/en/ajax/basket/remove.html?_=1668841033925 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjMifQ":1}',
                                `Qty` = 1
                            WHERE
                                `ClientID`= '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                            LIMIT 1
# [19-Nov-2022 08:57:32] /mygr/www/en/faq.html 167.99.142.201

set names utf8

SELECT
                        `ID`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'faq' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

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

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

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

SELECT
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:57:32] /mygr/www/en/ajax/users/bar.html?_=1668841052915 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
# [19-Nov-2022 08:57:32] /mygr/www/en/ajax/basket/qty.html?_=1668841052916 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [19-Nov-2022 08:57:37] /mygr/www/ 167.99.142.201

set names utf8

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

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

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

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `ParentID` = 1 AND
	    		`Module` = 'products'
         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 `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT COUNT(`ID`) FROM `reviews` WHERE `Language` = 'en' AND `Visible` = 1

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `ParentID` = 1 AND
	    		`Module` = 'reviews'
         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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:57:37] /mygr/www/en/ajax/users/bar.html?_=1668841057801 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
# [19-Nov-2022 08:57:37] /mygr/www/en/ajax/products/prices.html?_=1668841057804 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('3','4','6') AND
                `Language` = 'en'
# [19-Nov-2022 08:57:48] /mygr/www/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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:57:48] /mygr/www/en/ajax/users/form/register.html?_=1668841068810 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSignupEMail','LSignup','LPassword','LVerifyPassword','LFullName','LPhone') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail','ErrorPassword','ErrorPasswords','ErrorFullName','ErrorPhone','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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextIAgree') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:57:48] /mygr/www/en/ajax/users/bar.html?_=1668841068810 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
# [19-Nov-2022 08:57:58] /mygr/www/en/ajax/users/register.html?_=1668841078991 167.99.142.201

set names utf8

SELECT `ID` FROM `users` WHERE `UserKey` LIKE 'wr_DisOZw6HDgcObwqzDocK0w5DDk8OMw4bDm8OCw5jCt8KDwrTDkg%' LIMIT 1

INSERT INTO `users`(
                `PostDate`,
                `LastUpdate`,
                `UserKey`,
                `Data`,
                `SearchKey`,
                `SortName`,
                `SortEMail`)
            VALUES (
                NOW(),
                NOW(),
                'wr_DisOZw6HDgcObwqzDocK0w5DDk8OMw4bDm8OCw5jCt8KDwrTDkge222674ddb1a3b75fa1828d8db3343d81',
                'lsikZvSEMkc_wu7m5ZFtv9s1XRoUu-G0u9CTZxaxMrxUZOPIdrzDe7an9mDXpsngT1HN69upGtHlLTLkGi3TOd1KSyubHrWVUbrZHKei6xY4INSDDvuFzhx0RaQ8kpQyLPKVkfNyVEthiofKn3t03CuhvAP3gdC3KpfzqW7eP2DPt2dTykl3GwsCpdoC21Ku',
                'wrjCoMK6w57CsMKfwr7DwrHCn8K2wqDCpsOEwrbDrsK0worDwrjCoMK6w57CsMKfwr7DwrnCr8K2wqLCp8KfwrbDnMK2wpDlMOKwr7D',
                1040114,
                1040114
            );

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS Access,
                `ApiToken`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'wr_DisOZw6HDgcObwqzDocK0w5DDk8OMw4bDm8OCw5jCt8KDwrTDkge222674ddb1a3b75fa1828d8db3343d8%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1

SELECT
                `orders`.`ID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` < 2
            LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [19-Nov-2022 08:57:58] /mygr/www/en/user.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
                                `ID`,
                                `Data`,
                                `ApiToken`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `Data`
            FROM
                `users`
            WHERE
                `ID` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEMail','LName','LPhone','LPassword','LEdit','LResetPassword','LSaveChanges') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `ID`,
                `PostDate`,
                `TotalPrice`,
                `Status`
            FROM
                `orders`
            WHERE
                `UserID` = 1 AND
                `Status` > 2

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

SELECT
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:57:59] /mygr/www/en/ajax/users/bar.html?_=1668841079482 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') 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
# [19-Nov-2022 08:58:07] /mygr/www/en/order.html 167.99.142.201

set names utf8

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

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

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

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

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LDelivery','LDeliveryToAddress','LDeliveryToOffice','LCountry','ErrorCountry','LProvince','LTown','LPostalCode','LDeliveryAddressLabel','LDeliveryAddressDetails','LDeliveryOfficeAddress','LDeliveryComment') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT `Code`, `Name` FROM `countries` ORDER BY `Name` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceNeed','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceVATNumber','LVATRegistration','LInvoiceAddress','LInvoicePerson') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

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

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

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSend') 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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 08:58:08] /mygr/www/en/ajax/users/bar.html?_=1668841088605 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') 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
# [19-Nov-2022 08:58:48] /mygr/www/en/ajax/orders/submit.html?_=1668841128921 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`BasketID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` <= 1
            LIMIT 1

SELECT `ID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorCountry','ErrorProvince','ErrorTown','ErrorPostalCode','ErrorAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorInvoiceCompanyName','ErrorInvoiceNumber','ErrorInvoicePersonInCharge','ErrorInvoiceAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 09:01:18] /mygr/www/en/ajax/orders/submit.html?_=1668841278769 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`BasketID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` <= 1
            LIMIT 1

SELECT `ID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorCountry','ErrorProvince','ErrorTown','ErrorPostalCode','ErrorAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `Language` = 'en', `LastUpdate` = '2022-11-19 09:01:18', `BasketID` = '1', `UserID` = 1, `Data` = '1KvcsEwz2stSzJRgjcH3-02tYYGeaWc37GiHFWyHnLI7BuNCxFs6558fnsEq9XwmpKMo2eyEfXqtgHGzhorrQrc0CD1evO3uBZFziHQT-DJIBAxJ089as4fkB7KISEM1Fd5hxWsfrumhufQxc8UdrrfrtmCaNt974xNhm1qwmIHulz2OT83B2FXjn63MXHDwJxoQk4L6OUxKE5aeLsA3WLzdkJLJDqKWhL1hYmlJcLVM5PN1yGxrz61TURzWpcx--2O9uGOxkY1LCOp4PQN1V-l4E6mW2eJifMdWUx_ZerissrHjOw9T1bpwUXUDOYzipeGVeQ47UewtqHw_z4xTBOSeEdzvLYntrmPHFHz6uOzCmdIXAUHLxQFZsZNimFw2E1MJCFQXpP1JbAfsz_6xo9H4eWHiRTqMHtE3DiPDcJUhDmaVXfqtjTLSb8JRkDaoiJuCzSSvNfj-IGquPhzZWK3o5iIa43T_f4inJelivQK210Ln_X3WBDTX-Y32R0y3Ep5oi2Njzo1aihyQDDpyYlYVzEnb9iHkp7HKIXqy9fcdRfe8RoJYfh7IjdRPgQT5KzVIVNvvdMJWYaQl0E9GYQUcNxcl0PUps8vGzt0mJJQKzGe7OfsL4N9TKhUIX2ula5XD9Zt_uJV7r5_xlo3WVUqC5mzpY3VXwmscrfWgHXAZRv22QEjB58mvk41vHqCkEMuaiMNexHjPkJ68zwNociYAH-Oau49OYfka99vZK1bKa6yGNWQkyGPP4HHPj-fAF9OSwEkKlWrUMsrznBIF64Zcf7qGduFkcHd2Vf8J3iCl8BgZX4Z2ft3a5OdnTmW9FzxT9w8EVHDv66wUdVEnCk5xwlyHcdg3totBmpn4Sj56_LQkDrmauYOqgYVEkTntPvx63sBzsyu4vfdFIuIbxqaMItHA_nez0WM2jtgqg3RoXSNCC_luV-6sNUe5YNFaFDxkqjTU-ByjAmMcwh8Wh90Kf6cvz68whh0YU7h0_enRkk43_hj58wfamHNJK0minDvBrLeto8TYWp2qp75HJ_-yDWnGl4ZBJphC3codeMtfWk24qOhqvHD1aC2g8ZuY0Ti8wiQHkaxVvU54dneB40TIN4rMQ1fq1wqs1rcXE82jKBA-lxFzRO2CS3upl5L1erx9eSG5IicUaXWZ-ruhHzV5AZE76SjuOi3mTE6E454WkYgqFjPj4J8phWA5wyM7yah23NHOQchF0kcCsTMy6rHCV0q7UZv_wu0eZ92UjxrVJ6peurqGfra6MjMu6oC6Dz4P8lAK9-y71Nb_fhg4MEB7Fb-cg-iiZo2ON70uepKxNR4eRc2fUIIDz5Er1H6dQ04K7Qbm60y07hS87KwqzZDECLboNmwRaa1yBWA8zE0rEHFUVGGASWjhquY7GD7GWtjeodqxyEMhM1Iy327fDRt74OK9cDKM_84lThY2I1UTgMyVZktWEPUtXL6hldYaEvUEo_tWPOcRNKwKn3yvyw', `SearchKey` = 'wrjCoMK6w57CsMKfwr7DwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwrHCn8OYwwrnCr8K2wwrHCi8K6w5bCsMKzw5TDpMKswwrnCoMOCwwrDDhcOTw6bCm8Omw4HDrMKiwpzDl8KMwrPCv8', `PostDate` = '2022-11-19 09:01:18'

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'orders' AND `Action` = 'preview' AND `Visible` = 1 LIMIT 1
# [19-Nov-2022 09:01:18] /mygr/www/en/order/preview.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'order' 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 `Module` = 'orders' AND `URLLabel` = 'preview' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPrice','LQty','LTotal') 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
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEditOrder') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSend') 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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 09:01:19] /mygr/www/en/ajax/users/bar.html?_=1668841279597 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') 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
# [19-Nov-2022 09:01:19] /mygr/www/en/ajax/delivery/price.html?_=1668841279598 167.99.142.201

set names utf8

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT
                IF(`EU` = 1, 'false', 'true') AS `CustomsDeclarable`
            FROM
                `countries`
            WHERE
                `Code` = 'AT'
            LIMIT 1

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-19 09:01:20', `Data` = 'kuzgcafNabdv_6Ozk9yBtce0pGudfD7rKJj0tafVCt-xBw6BLZfVTzhPgYkZ5kuyE056SqgnGC5fccs2eUC0aaRPBg21R8lLivV0KOnxyoYzOeg-lwQtqQa8Ln-uVjrnRzgbywtG20MzWrx9XmYLtz2ec7_trrxfPnwciPBVgfuAxNkhprwL_GSOlHqwBf5CRNhoUpA3yoQXZ3-hDOpSbSzrXaV4ZkhRI7Wesi1oXeZpxc3qMtGGllnthxs3G7X6Lnqx3WhN-IHKPadKqGK4_rrf35iVbFLjBRAE4As5O_pZQco7pxuyFUMQ00ScSaB9QwoKZsiV-A8RP1KzS2AmFI5IT9x1zgqqBaCwQk3acINC5fnJo5KjylyLVYJ-iP8pKfGqJBHaHUGuNAYZKVqRX70J8Uj2ENzD2Gg3WumtbPuncab_OBd4WmIbeb5_lolJk-9GvNYq4ngEzJ4ONjUg-FPTmhviAzf8ieEBgAPm1EAWT14yW4tRRw6acY5V9RdtlltMf5vHeDvZ2PoP5BHk_cLnh-pfahTkn1kZzwdeTIsE9NSabgEjxqnJ2wB1Kw1AAmS1f6eLIYguld-jCsTx3PoLHLYPEOkJQLw2LuB4iPacXQTR1rx4csknfDlsxTx5rU0sw9thombBEvoxsnFTtEZzjhyBG1V-vmi0yUzjB3lYa3x0XkopTTxThwcO8HnN1mZVP_cz_UyytmJX-2JDQY0aZKmyq6XP4cVZ6q3FPiaKhyX_y6UcRBoYfoAe6R-LDz5iqGOIQ54uerLUbCd6y6boCTs9KypOa5Hyfz4wPvoG-9kXlbXevZJoleTSudBl7jbSaZLnDZ1t_xwrmytWZwjujuQTubbFxa-SrsltGq_-QiCxadr722UYSOYigR7TcL7n5ZlYYF8X8TYwp80HfP_lAWN6w7nT29X7R6it5XzN0lpvDdVpdF3zTfCTLaoA4Px-X9FWlXwy32IbRPMugj7V5FWJ21OGsOqk1dzZKnW70jKCLEA4llMpn1d7rX040lOjk6kiGqY7CglsQFe1Vxt-Evh57rVnyIRqPAkA3DSbYJZzp0eUCQqlXp27xoE_e017ELJIkt7n5eW3ZzTZLJ4eUoFpUMXWyGyJyaQbgpogWH3JXIAHg4eCMj6xebwKfca7WJm8CBE8s6zAAEzdbsM--Q8X98tlQ03h3NYNtHHQgs8Wf0cZxLmIyPaH4kPNDOEy91XbAV08XcoblOt2jR5dpi8ZydCeRZPd-06rB5AXgDouHh869fpcHj_NFjdEus3iNeXDwxThQHLH19ZUnkfOjc3eFcOXg8isZBf-unGCNUE3RSbcKDoHl13W3kz3BUz2Dxj0U7i-pZNFX1OKdMK9p9UMt1Q1XpynWrMf39NKVmvTGNyHKh6C5EtLqYhMrXYaV2b7TGYWuUs0OAFqgHKa9gD-N3WAJeUZT5nfnaUk6hcuZkg_W0Z2xg2DoRZ_XVgJ67JCj8lUWOR-1jPemzxwT2LKCWQV5eeTXpe4hhazFM_OuxCa6IyIMMkgAAWlgbHGr56y2lYC71d63bRxQw' WHERE `ID` = '1'

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LTotal') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 09:01:27] /mygr/www/en/order.html 167.99.142.201

set names utf8

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

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

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

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

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LDelivery','LDeliveryToAddress','LDeliveryToOffice','LCountry','ErrorCountry','LProvince','LTown','LPostalCode','LDeliveryAddressLabel','LDeliveryAddressDetails','LDeliveryOfficeAddress','LDeliveryComment') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT `Code`, `Name` FROM `countries` ORDER BY `Name` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceNeed','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceVATNumber','LVATRegistration','LInvoiceAddress','LInvoicePerson') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFreeDeliveryInfo') 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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSend') 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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 09:01:28] /mygr/www/en/ajax/users/bar.html?_=1668841288474 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') 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
# [19-Nov-2022 09:01:35] /mygr/www/en/ajax/promocodes.html?_=1668841295573 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Discount`,
                `DiscountType`
            FROM
                `promocodes`
            WHERE
                `PromoCode` = 'ICO10' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Visible` = 1
            LIMIT 1

UPDATE
                    `basket`
                SET
                    `LastUpdate` = NOW(),
                    `PromoCodeID` = 2
                WHERE
                    `ClientID`= '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                LIMIT 1
# [19-Nov-2022 09:01:35] /mygr/www/en/order.html 167.99.142.201

set names utf8

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

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

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

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

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LDelivery','LDeliveryToAddress','LDeliveryToOffice','LCountry','ErrorCountry','LProvince','LTown','LPostalCode','LDeliveryAddressLabel','LDeliveryAddressDetails','LDeliveryOfficeAddress','LDeliveryComment') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT `Code`, `Name` FROM `countries` ORDER BY `Name` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceNeed','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceVATNumber','LVATRegistration','LInvoiceAddress','LInvoicePerson') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `PromoCode`,
                `StartFrom`,
                `EndTo`,
                `Discount`,
                `DiscountType`
            FROM
                `promocodes`
            WHERE
                `ID` = 2 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFreeDeliveryInfo') 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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSend') 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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 09:01:36] /mygr/www/en/ajax/users/bar.html?_=1668841296201 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') 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
# [19-Nov-2022 09:01:43] /mygr/www/en/ajax/orders/submit.html?_=1668841303328 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`BasketID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` <= 1
            LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `PromoCode`,
                `StartFrom`,
                `EndTo`,
                `Discount`,
                `DiscountType`
            FROM
                `promocodes`
            WHERE
                `ID` = 2 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorCountry','ErrorProvince','ErrorTown','ErrorPostalCode','ErrorAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `Language` = 'en', `LastUpdate` = '2022-11-19 09:01:43', `BasketID` = '1', `UserID` = 1, `Data` = 'NusW_0N_jxRRmqYBKDOrJ63eGHbD5Bq-sb0t6UZSLXtzZznysX12LnEXq1QA2HR26hB04YG-oT8CLQtpAZ4Mdt_IuLLS7eiOejtRH2NFxfyUUfVF9yiB2pYhdGjQgYSor9DU5ViTUmAq2mTSRK1otTtgUeDGPwEqhjTwCHWQd-vYkijfZY5P3UuHwzq2Ps3H1p5ySCiiNc-XZBj4EqjjlDqpluqqQgI1hkv6FHM0PRTG9Bcw1y49ksUuwUuQiVkg-_0diMP7zRYMhUkN6h8mHEqETQagMXxftq0z3Wx46GCwy7b-rMSeC7kJF5I8hE8HTn2wRL9yVwi-fFi39Fq0ml3JTs6ww4tq15N5S4kUHPpFcwJwSXCw3624M2wczDfDC7jB_jTEXIHW-zpwYEEXkY4e718Ijnoepozm2G6D4dOqUQt6s6j-k2a3JzZNair1p6mhDJ2Jz7IThYbkv9KAq4g6FgYsEzBh3f8UBAQoLHv8MPP823brjHAwYUQ5NxsY8DDJrQLgJva9IPQ_K23FZ356F7eivOoCGRwn8UZ6k8TjYC_JGTOhwETJ_MyL1K-9tcjVA5uUYFHbLg4yI9Kz1onUKzUae9Tf-AzsklZTaSDoF3NFwBg4f0nOvmoU3u3Oltsu9d9Z1d9xCCW3OAwFUCc-NCz4SE3BR-rAlIpOAfFAolxouDznPTCinc7l6zif7vb6biqCFj13Boei_sq2N45ATmaqwgXyStWrX6gPL3f2Qw0VtMsDHHyX2DdXzVYTldr-mlyUdSCHWTNzHWIoS2NFJhQboY-aR9QIbGZz1RLF0iNWCKEzyazjU8_4un568I3hJc4W1bcQ2fIqQAvc9-USTJN1uQNgD-wz07yVr1q6zJ8M19Vdud2Glvk2gVp7dkzoHjHTDoVKVmswlzG1A6-kYspVG8amjDktNvGZcv9o7raTuBN5pSp_J-4oLV0xbkWK2gb0Qd9XwR__ObFQfLwegV7ujGTQSN1MJ4cbYkOVlXaJMWeXET0yVUU4AAdspgdcvRQsr2qkRxXXvXShyDojw4A-Uizx8GyiP6GB3zshyuCUSm5Pn5jT3NEUcwo31gZBCo1Sc5CqIFsTu97qIJUsuoqfIq7Syuu2sdHZBA1QAvTCTDM7fQ64TltEzmpjXBdjN7cgGq4KtdSYvsWYk5cK4g32LdCeczO8dUiGOhvVH02A9zlU9PRWuI-5S6n5uuPcYKNkViK-s4M1nWK8r_eOd9b-erJqpoXhjvVyFZNOA4bIa6V86L6LzkVrxAmv-e1tjVrEbdCzuAufu1cSBK6A3GdDjp4-MYtGRMKRqOZP5xL__k-sBaIcmI3cnUGAnwR94-b6KwDQ7_q4yMjK2zJoKoYRnsmyUTWJMaCGBHmnWj4Nt1CN_pWX3oNLzp4-qY87peDQDzAEOJaW86sWrMD-0PrsOwZbvSFxx487Q7V3bYMFnUXBseE6n2wmD2O_WRM0Mymwhc1jfWzONVL1DSyArFXv3xM3bk5JvOruHXFjWEGSRasTB0xZoRE-of9oRPlvqqUifOstzGHVaFjBxnA0k8lHXfFBjA0VoWtNxYqqhE1tkG8qR5m2jPngqo_pQDc1sNALzB02vxsHhsrjc_wB2eM-cTl4pK1py0LzPCLsfPixwhaSyUGB2jbryU-IvxRfK9-TBEiOMQbXuJXO5w', `SearchKey` = 'wrjCr8Kw6TCmsOAwwrjCoMK6w57CsMKfwr7DwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwrHCn8OYwwrnCr8K2wwrHCi8K6w5bCsMKzw5TDpMKswwrnCoMOCwwrDDhcOTw6bCm8Omw4HDrMKiwpzDl8KMwrPCv8' WHERE `ID` = '1'

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'orders' AND `Action` = 'preview' AND `Visible` = 1 LIMIT 1
# [19-Nov-2022 09:01:43] /mygr/www/en/order/preview.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'order' 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 `Module` = 'orders' AND `URLLabel` = 'preview' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPrice','LQty','LTotal') 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
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `PromoCode`,
                `StartFrom`,
                `EndTo`,
                `Discount`,
                `DiscountType`
            FROM
                `promocodes`
            WHERE
                `ID` = 2 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPromoCode','LDiscount') 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEditOrder') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSend') 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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 09:01:43] /mygr/www/en/ajax/delivery/price.html?_=1668841304025 167.99.142.201

set names utf8

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT
                IF(`EU` = 1, 'false', 'true') AS `CustomsDeclarable`
            FROM
                `countries`
            WHERE
                `Code` = 'AT'
            LIMIT 1
# [19-Nov-2022 09:01:43] /mygr/www/en/ajax/users/bar.html?_=1668841304022 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') 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
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-19 09:01:44', `Data` = 'pTkreEGUgwghSGHqEEgISMlgNx52lfUmWRNKxxZYBCfDWDr7ZkFSysy8CLdrAo5ZwBuB0IWIq-uIEsrxH2OjwV9b1XRP64ZiZZz4HXDWhVKsyNqGnVF57FG_63wr6yD5N48ZiE3paf8TUYUWn7jKXImt_B265EkLKni03dMKv1oe4f0X1eoCzZX-kL-ebuTsNxmn5XM9y9igJOhhkelytQaJq_TXy_0_6n2M15OI1gLNbefhM5i0EQXrqStwAT0cHubWQlfXqPeFHrqyj1WksX4jsdEjhjQfW_00WikhzGIyn6vOH_u4IwngjVMgTvBk7xFqJPXWEy9LokDVHpRN_E65zjPTHietGaG7to8Rly7R-5ex1msWMkCFjCRi18-QnPqLRO-UvAbWrPuq1efJmKK-ZIrjSIeEqoj9qcHAJWcSeW8TzVqViwSq2S7WjDZ2FF7lm1Q8swfGIwtd-3cG1WAg5QVrf7IfKEUjbwlA5mCt3OmwHDWCA8Hkn7FymtFXid4qC4tHKZAu0--J7IuNorD-phuRrSbNFMv7q7NB2lGR_-UARvK52_LwSqSzWasEMfR6RhKFPpGqwlJ9uHGG4QIRlCdvfYcWRXcmXe3QqZvIQlEy6tLJ8vM3Rjw0pquwYHZsSlotPQLXM9MHwe_T3Au_xOenNxcUs4n3da_HYnAhJY2HbOD6GZhT1UIwDwiKAN7lQBBstrYfUi_wZAknK98zij-xsE2g8sFxDlxfJPcPSdWMMgDJxyCfSOjqaTbMnkVc4Cw0SYraCfjlO39Er80dGvwKjLRSJ1xkfwc_qFeqWNzEk3JaikTw1Gs8XqrSYPInVOM7QI-XIHuOY2E_Bddpwj_vAmXx7n8dHuHTD3F0A_OuH5By401r4gT-WWEqR8zzTqbiWHqqsTA5llkGkuWENq9oI9XG0xcdvOYMYrH1W2biRakA7yoP2FeJ3FqHVTO3qogg5zL82totzeix5d5QqAxzErJ1Xa-VWiW5ixExeIJd6eCXv-r6k-PZXBfVqPwax0OD350IFYEuutaVRZm0q-f1K4vOha0bzvpZBTysmxjhwbmPGz0Jn6Dvi-kGe3TeKI_Nt6LyDPjl0OwIkJV7IPJjTp8qpJWg8bwer5EJXnd_wnj6VKoKY0HpvGzcZemlNbwMGAoo1zysAnwTnTtvyQiOrHM6-_qijztj_4gYZcrXRDJESrK1e6H45r83t8GGXmTN-PlS4zylIR3l-lHBezW1Wi2uoTFMODnJHx6p5xSIW9bk9EYa6LxdbFKHiOdtkkdUCYTOmYKjlMGYQwN_2TIYl00ieQOWTqwu3Gxv0JTrDPnTAfxUawOpK9zy5m84pOdZ3KaVm_YzX7Z30rLEtG38xA_ol5YlKyovux9DIikY-FJsR3p3BoFIc_lXoWAlthKkovtUipYRfLv1G1az7Tr0amUqmTJdHxIzx1Y8TMOPwwtBi78J6yeTLdpd5YJ1bxhZrPkwdYfjVRIi1U-0L71bEO0cMmydsHf_ManIQkblvLAS-udu81tsWgs2o9CeH8Dzz_5gCHMkdd6KdqsBKwXzrdMQDljD7WnoC03zCjktkg14dYpyzu41xCoXp7IhGtUWqO-StsdVJhzFZRkuQWsYXFPQcSjVgpwVms7-aIFKSWLvog9gN8ZUlfcsPeVP4biFluGRmF0E0wxGI1I6Rkdfv3MN4rR7KGGRX6N6FwbY_9KanQedxXguMF3c' WHERE `ID` = '1'

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LTotal') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 09:01:46] /mygr/www/en/order.html 167.99.142.201

set names utf8

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

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

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

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

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LDelivery','LDeliveryToAddress','LDeliveryToOffice','LCountry','ErrorCountry','LProvince','LTown','LPostalCode','LDeliveryAddressLabel','LDeliveryAddressDetails','LDeliveryOfficeAddress','LDeliveryComment') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT `Code`, `Name` FROM `countries` ORDER BY `Name` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceNeed','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceVATNumber','LVATRegistration','LInvoiceAddress','LInvoicePerson') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `PromoCode`,
                `StartFrom`,
                `EndTo`,
                `Discount`,
                `DiscountType`
            FROM
                `promocodes`
            WHERE
                `ID` = 2 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFreeDeliveryInfo') 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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSend') 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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 09:01:47] /mygr/www/en/ajax/users/bar.html?_=1668841307427 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') 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
# [19-Nov-2022 09:01:52] /mygr/www/en/ajax/orders/submit.html?_=1668841312760 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`BasketID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` <= 1
            LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `PromoCode`,
                `StartFrom`,
                `EndTo`,
                `Discount`,
                `DiscountType`
            FROM
                `promocodes`
            WHERE
                `ID` = 2 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorCountry','ErrorProvince','ErrorTown','ErrorPostalCode','ErrorAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `Language` = 'en', `LastUpdate` = '2022-11-19 09:01:52', `BasketID` = '1', `UserID` = 1, `Data` = 'bhorueNjx8FLPwQByf5XluYM6ymdnYMnsHdWO0h5xLflf1WqHolDSh9X9LLvclozE4u1wipK_QFBJGBfFGL9mzn-vklh21L34lmWICqKdy5jdwgWpaldrF_gAelB_stiUwsc-tOF4drKbQJHAe48h9t6QDJINw9XZKFaaKe8VWnLpqw6V8LRDaj9k12_m4-_Zq57yAnNYpR3eV4PlYg54i_xWcZ3sQzCXTEMIRr1PalinhWWVSwlg5JUfK2mmrIIXtuArLyZRWikhLeMtau-3xwYtyOchPKJWoPlgEinid5MjVqM7Mh_OYN2Ow8aw12TfSfNoSCKdlwVpi-GJzEs66iYL_9JMAgkFfgsSEC0907X49pN48GMxb2LFxaJw9zKc1DrwEF2akvIPNYCEumYNgJBXQFUnNPZ8isOt50Dtazba9Kqxhupwaaudd5StDT122KtgwwpgM_cxu5dgaWv4BP9hNTflTk-X2fwL0N5p7TE9m3wq6t-O2Q6qzO3NyDkWveykzflgtGL7-BTLnWfWMk8y4PQdnITs-jv2cKEifHdMeAzlgwUYoj_vehmvbE60UVajMjo6u91GhNfWh4oE-6fRIGt4hUrZ1GDFgdzxTbNMlDXSTFkEA7uLfsJJCNNO0jpO8drpm_L7Kdzs49ARRmKe0XptgxPRWIOebk5NaUWHZHSQw6aFsptG-RhbXvaIREXDJKZCzAQ0zK15xTaQ78htjxS6VZTqyY0o9gF-Ve_ViJJdTLVAxBgLXoXMlN8VnX9HOJBTiMkdjpTg3w7DuIKBy_DyQM1FnDATjNhY3ZNZELje64C3-1vc_WdjtKtmi9Pv1MEft5dS23dKlqdB8jFcjyPjvC9MGkkfv2X7jmeCR0Ln_E7gEtQC2rsfQD58gUvkw2rqiy_LE6JiM7rJVyJTt7vSUtTFgPZpz_A4caudQ_T-aOpxuBXM82TlVFWO26-DQbgmEYwbCHMHTq3X2VxbhEwGnH96mazLA3MFprQJG22u0u5o0lt1X8GVMIMb5DHVp7xe2aQhcfVhOAt_jcR0QxQHLjH8W2QMtoT8KcAZ0csKRg1guM18aON4DBXAN3xebYxzh2k3t_hHLsrODTtqnYlaZ79_G2Jx2fnBOb1VcWaYkJQbW6GjwZT7QCMYZE-n2DYRdha_EaoFxr0ksph9u9MztB5xIAtZ8ObfW0_azRO479Y0ZKOGlG9SmgXIjv8NiWHKZPkMpxIYJByHOfxQpU3QiaPFoBg1tmDpcRts3XU8iChE8zdKemqYD90RKO-gIE5MF2R6b24_OQ6QHcThkjztXrQVgleG6q7gghH67l4BcwiVwlQuUYmnxb8a96kFwN1Eemauzso9v-aseuDjlg3vuqTemW1ph7UddvpqTHzoChVXZ_CH5PMXlqqET_0yhxjh16vdmaaizEoGGGO4y6zez54kWkHE_AN0_H7spQzsKSTNvOEtJyo872YwUkqedJgHY0sFN7fRrmM6o3g45F3mZrHm8QE_LDdz9uPiB8Ce9jB546eqtsLmay2wBgGvQQu5UQ4Fq4yIKkXnfNHWGssPty2LBJqQXJ4rV-dcHD3f4r86NUcdnrr9LsZwT8A4dgniXw6_lTgrTdedvIW-G1He0jC1IZVGg7UWEHLo3wmr3e1udc7HMNsurYSv7GTJOPhfvbwOJPrc6tmpw', `SearchKey` = 'wrjCr8Kw6TCmsOAwwrjCoMK6w57CsMKfwr7DwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwrHCn8OYwwrnCr8K2wwrHCi8K6w5bCsMKzw5TDpMKswwrnCoMOCwwrDDhcOTw6bCm8Omw4HDrMKiwpzDl8KMwrPCv8' WHERE `ID` = '1'

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'orders' AND `Action` = 'preview' AND `Visible` = 1 LIMIT 1
# [19-Nov-2022 09:01:52] /mygr/www/en/order/preview.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'order' 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 `Module` = 'orders' AND `URLLabel` = 'preview' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPrice','LQty','LTotal') 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
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-19 09:01:52', `Data` = 'dt7lcNoCAPXL-g0VIf6t9rQls8MKPTr7NVYj8ffL4TMJ4wiYqIn-QydbDmOp8bq7GScGBDnlk2bO18Km5jXbPsx5fhFKQLZypAEu0RtjJso0cBlHEOIHi3Y6uWAj5S57Lb4GMbJ79VkCyfl5icvQ7mzLeu-VkANzhzRv3RqwGFdU62xyE6cwF5qg8Nr-ZmwyYr1v1bFS-kP68SWeuP9r_tBA7F59EVxDxpUHeDbiSwhjPhP7I-QL1DiCl5h2XE3kvZUQxYST2kicmMSXCg-XNzuyQF8a6r6of8fkD1gVaxx-QYcV8ZV1PeVgza9bF8SNnibkwa9e-5qbZLo--X_Hpmzt8PJxjoDvtbf6kocsEkknisxvL2Bhd-MeyoqyPqPjofq3IK5PqOdeLSqR7V3ExppZht4izq3hkIfRTWDY_ahQMxq_otdGMEAPUAjE08vmcRXFFWYGdVoUL0Na88LGOkHFiDwcl2hR7gkqpuM-k_DnT4yCeovjW6fI73BzCg7Pbbg0D-8lCifgamw0-q8ssYxuJ2wnP7WB-em0lDL9niWBw509lKDUAt4n46umlzKte_MOhsHspTUQZ7hhb3hj68DuqRXkXDKLv9ycWAP6xK96Du-ldWIebZiDIjersFTLje17Te2huQ4J7Ei7tkKBqQzO_littmlZ5SQho7yH1XCxltECr8h6cg9UllYlghnvE5eIuOz3mOXflE0ni9Tnkm-ymFYAN_9t_b63WCbIsjqtPRhjVjPj529lvi4Sw-P2OHPKGtp3Qeppfx-EULZur3rniX65ruL94sCZDHRr5NUklSg8oEgUYiq1uXkb-ZmLiZJ8b5ByjNM1BLAT662pDqW3vSz1Dg_hROaJ3besul860M9PKx97y7loTSPuBaSt87b5L1Ek6oubv9yKgkM2LnQ0qtLSEe4usHPf_Zw9HtEQm3KdEFX4oTtpr65-dCrK-tdHFyD7zFv7u-uS9rwEulS45lpfzqRDxhLX79AY6YYr_mzZ_ZaQULxKGUpA2aLa8dy4dgLQwOhD43UMFBnfM_k2NsuUIJy9oHRTeYEi51MpDN7604hTyQt__KwrXkRFZo9j4QAMsXOufKhKLOo6pr1p2SvWSwEETe9SJXprWBtjVDm8Qb7xto27H6VJH0Z6SCa8WEi8fmeYcALXe-M0qf49DDiABP7zYc653Ih3bxGocKAw9sqUTDkk12yLbtPFyD5adUdUAip-dz123jQmoAV_oYz8hVZfgyRh9m56QDspg6RILjdsyuU9cmyEBhxbGsRqm_mRdfsFOfTMBowdpfy45xxQ_9hEK0l8y896u8UR1VDvERIyAks_6AaDxutnefVZ5HvyzBQBV0jJMmpkXS9g-8_K4FLTLgI1A4Py6tpIQpwaecCUzFsgBLjJ5SeI-kVE-0bCrdE-3MpzApvAcY77d71mEoc5bhT0mUMcRNu69ybo46LH6oZaXotbI9P6d5TaflHuX2NkT4YPqMQwD_Ls3wdGNTOfpiO1_JsmCjgiAWCmZd7RjY2m57qQpwIaeUW3ve2QzJp9FuD8JUaVh-ibMXWnCEWbIapJTq1xFUTfWhQOE5pllDf9kYpQFPZIOUJqBY_3KjdGkCjM7tlIIVNDYnirJ2nDeNt3DCs-OIMw2GVyp1YLyFwGvjj8BUmXeIBS6Xb_hImL-iOXQI-XTsQ5jsxVTPTGbUCmwpQnP82hBi1fBU4VXHzaGCihuyFc' WHERE `ID` = '1'

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `PromoCode`,
                `StartFrom`,
                `EndTo`,
                `Discount`,
                `DiscountType`
            FROM
                `promocodes`
            WHERE
                `ID` = 2 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPromoCode','LDiscount') 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEditOrder') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSend') 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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 09:01:53] /mygr/www/en/ajax/users/bar.html?_=1668841313431 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') 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
# [19-Nov-2022 09:03:59] /mygr/www/en/ajax/orders/confirm.html?_=1668841440014 167.99.142.201

set names utf8

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-19 09:03:59', `Data` = 'Pa7KVlTuMMou_Rsn-kd6n89wx0ms0QgVGtkHCDW9AEihR-H0QukNoEV3D9tTknx7c5JH-uy2WH7niuREahJWNGicffCZOLk-Ch-FkArqJszTNedibWPDm3wfjJpdv2KbE8IqnjIqaQSCZe2jiZBBTz_g6ZVlhCxbsrVKKBrslAVX-7PQEbtHttJZuBiR9QVjZlck2gUw4mftJQi-tRZxoa7odpKVYcKgwlArV5Q4KxyzW-yny2fJAzcIvX-U0I0sVocqPPzxi0czfqtPoeYpUXmXeE7jdMBQ7b9RI-Of6z_P-2d6Cx7vh3_uIhPNDdW6RoTWj0PWFMpc3rjuF1LQ2DT8pyYSTEh3GXHpDacOK5CU-_supgpDUg4mU5jle5MTDw4LQL61PEni_BmV5FSB3QQsjOzMkx6EzV8EFXGyC755sIl5r5mg7EoLfghHaVsdziN9bOSOCxFL3JO95jixZ45FNGf4LKFUj9gdifUmyJO3dHFDPlDewyVQmSKJ1Gb0rnl8LmGw1Vf09paL1a-FyKHCel2fvgypn7NBRSc0NlrUI-NO4XRospWpKIWq85VzpZNEl9HTbcQV1DY2d1A4q2LGqp9R3jMizs1NIZKnI0kb4H48l-DfhJ9H4q391sa5jfozzKrX0N53cXZ0AaZOYvud-DMqqQ0naGagyYLbWtBW9EDoi_l-PcL4Um3XCQ3N2mhXpccfqRB8OYm9_P7EJcThaZv1LLJJUnQzIHjWjYCXVD6ugB0SYVks0_S0TwAv1inbJV-TGlqa-bA01sfUNQYXHr06Yb0vkGqhM7vIh6nv9wb8gth10yNU156aUVYSebXV6GuG3qUwBH-qnht0v1f-yQXeLNLamCmFFsvOD6jJfOvax5qn94FBfyyTM0nUS3bfASNx0eedLPCI2xfIvbzcTpPWGHOL7xcbMCexx4iypzlB_aWpYyoNPI_F396JYAA5sCpmyUXZbof1Yq2vZVh7Ox4fRuk8yH8wiMf3BMmVIYNqbnA0oDLJlX-pQ_autDzOyv7DCpr-oQhUzN-4yPeioQRoc-vMVDqcZYx0GN1XmaMzfh4qHcPcUVSGttHBbT34q_a7qBe4cU2r-lCWLlRTvN1kNlvOmXcG7pVfPB5eHihybptV4gdT4QxBWOgGw9AvugKpWpzQ0fkBbGnv7nsf7Kzgxe0FK9iJt5F0HdtdZfJEXRAfHUbZPx6Cfwl6dwIn4r1K1FFUhv384iXPE1pbNpbb17vCMOFyOsY37K3qk95kOCRZHLmPwaWfhtpo6ybO_auvWs7EOYOxhIt8_yilma4DqO4n9Fnm3lacmd1Bxz-BNSGKto02psaKJY7mAD29FXTg3Yh2egSnTgxaKw-5WLiCYzPAn8Nc3VPD4oddoKAozk2qzRRFbeDxgZAzjrGayVkEhtyLNulY6QJlrqt4Kgvh8IuNmT7R5R2fAzeANuklLpSWoI9KB7bfuUto47Dki2AKhs-lMBC6YREYWJXxGwcrQ15IAqIJukUbvInQ7CxBRNeQhLP3tjKsc-p1dJsnzeOQIPUVfuIKrWKE-7LJLiigIf4RaTOTOoSEwFMggW4kXgQa8X3PywbIthJoPw9umP6Scl_-FHHii9dmRgwZBoQE8UFZp0vnquFXMSMPMga8SqAQuwuWiSE-Mw7mYqYhgf8HU0qhLtMh27aK7KyrpceXxSadohoNPi236kCkA2JYdmxrF5WZcxNOUnb83F2S_NKTcnZp5s0jq67YOiRTRsXqiY9qRNX1IVW19WxkeXWsYk9GVIiSjRxZNzIhFJ4o6QrDE1H6cAI7tuspn_5ka3LpL8wIS3CnFJ-nxrHHPS7ZPdgTzJ_Jp4oOVui44rBd-ab5doJE5POkfc8TRQvlMkg0OC-h_UahvNgnMXpyMVjQSAWzbJDrpm1ZhK1PxCcQPZXCXxHV_5M6N-FGh00NWzXTujo1cXORsnrzVCDNz_wQ4xFSFL45OhlLd0Recq9taYlmX4h4W5okB62OCA', `UserID` = 1, `TotalPrice` = 116.1, `Status` = 1 WHERE `ID` = '1'
# [19-Nov-2022 09:04:00] /mygr/www/en/payments/failed/1.html 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFailedPayment') 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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 09:04:00] /mygr/www/en/ajax/users/bar.html?_=1668841440684 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') 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
# [19-Nov-2022 09:04:02] /mygr/www/en/ajax/users/bar.html?_=1668841442403 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') 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
# [19-Nov-2022 09:04:05] /mygr/www/en/ajax/orders/submit.html?_=1668841445559 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`BasketID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` <= 1
            LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `PromoCode`,
                `StartFrom`,
                `EndTo`,
                `Discount`,
                `DiscountType`
            FROM
                `promocodes`
            WHERE
                `ID` = 2 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorCountry','ErrorProvince','ErrorTown','ErrorPostalCode','ErrorAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `Language` = 'en', `LastUpdate` = '2022-11-19 09:04:05', `BasketID` = '1', `UserID` = 1, `Data` = 'ogZkUWC9HRmxDObyHfWBqznGkbhLZXUov-nl4hpY-N9JNPPXtdr5GaHPDxHVMCLL7DxZ-3HatiSLxreS0BSZZgdhtgZcSvlYh5naFEj4Ugvr4vber2Ud1gLO4cZnEgPpLfF-JYsStjUJ684JpE3UA1qCvDlcG2I6n5AqnDOnHQesI90pUsc_cTPAu-DdMaL9bcPNN_X0QpMG3tnJRI1f6a4apRrZ-xZCq-F71l9ZijfSf7uPwSf9YDKzx6kd993BzTVtdH1KRQQUnLVaEksE34Dgh7-idHqKqmN7tpQKQ0EwghoRH2IKdS7OOeUUrCR9tFgOFwVAIWrVO_oP2Cv2Cp2qHdzXL4vrKR9DeRoKRy1s0U_MU12NSGttvOWi-Ldx-fH4qHkak4tZuC4t4-kHiCiNUv_o2-fBUlf2UUS2izYKgZRxDoj4MYZBJqESZ6Xe1Ifsku4_P3kA1B_ltHeZ5-fQjXdB14OjcrkBp4-142QchGzcsw2sAhzNBVXCg08WW2IfvInU3JSXkc7DWXDNTyVTqU8QR1L4uT5imnCaV7SWUf9TPYsowAQ8XY2PVyCVGgTCDnt84Rv4hsejsDhxC1goAR3_xcngnJwlU-DdABzkwzUhQMt89DiMWyBIBNBRCtxgGKR3FeWUQ-7G3j8M5MdGzPhnmkMWqtUiKz4kTaVmJjkKTrXY6IHe8u3HELNU_tELnUUfG7k_-PZbYN6okujokWnQspFqw6qWE1S1AjiZDa9iy2bfWOH5q05poHjvaWLXX22wXLUlyK9lwNfc99Y5syyx4a8lCQfZgDRAbTVQZLYBPCftwIAIFjvkjR5RNMtqOCchVu_v7APj-_FmP0OztxvoJysyuKqS5l5sGnb368uDLWeAnYkCjdloYce-5-5VmTMdOnDC2movczPhAnOiKELU64mz7bxhPoulDkHeUjhEB7uoa44-KBksHwhD2TFU3P9elVg6TqvDkdqLpIFR04iyE8oRJ4oQbSe_3uo0Wz3L7Vfi--1klZBzRduVA-K4L3xC-Pzr-ag983CSlbajUacJg02x_53Rx9F9tpQvuoFW8GAvX0XKPGyznhSwgvujUiWvSrBJio8tFufeTL3zf5wiNPTGqGA0jdTVpKXG5bLiFxgyvjwiogLJajr33hfvm93jnPG4NDxYx9aL1WZ0cQJGrUQdVnsUsRUQxma9L3PZRe4BZNkOynnZBDcqR-z6EDlak5xrFXjtoGPpXvxTNkR3FtpJIA251BPl1FPswUehcOc6PjDnmxv0vP75W1Ks2cj2ODxYU84DI14zjUOyhysVm9QIvLPuLIto6jOb6-EszOJVhORzyzor9EzUY5G0UU2Ks566dusbAktE2nFC_fPe70MJXNVgCNyTzkA5keHgDk6-7T7dZIF14xBbroKOyQ-ouE_3Ua7Lg33VLBaOjIAVTPdBFvIMioVqDgbbRMCKe0AGrC9fgJQlfPZ5ANA0U_VktBonU83F8x4tVTpXEIqizpqyjzcMFusbrbArxK5p_cDKcv53xe97IlDxIgw2if51XFbeKc5pgb2bBpHkyCF9_NupUX01b-zfDaH0YbK35PP3JWsAmjWNZmexdVXZwc8GnXMuexe4ezbGq1srm5d48B6dt9ZWGegDYJ4wlZYsncf_jMMOqH2n4B06FXVQxG4zwaZbl-weM0qeUA', `SearchKey` = 'wrjCr8Kw6TCmsOAwwrjCoMK6w57CsMKfwr7DwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwrHCn8OYwwrnCr8K2wwrHCi8K6w5bCsMKzw5TDpMKswwrnCoMOCwwrDDhcOTw6bCm8Omw4HDrMKiwpzDl8KMwrPCv8' WHERE `ID` = '1'

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'orders' AND `Action` = 'preview' AND `Visible` = 1 LIMIT 1
# [19-Nov-2022 09:04:05] /mygr/www/en/order/preview.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'order' 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 `Module` = 'orders' AND `URLLabel` = 'preview' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPrice','LQty','LTotal') 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
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-19 09:04:05', `Data` = 'w9RlmwKLsdWNRO0yA7WIaaRUyeS30bVTLDhxnu4BTXTO6Dbe8fRrQC11WFP1N8NRZ94JjXh-OwYaNduyHamU2Ah7HjsaACc8bNrILIcy7xfTNCEj91poRSyB8tOqmQoQNRc9WUy6VQUwaP6uV9zuEDu2-xyyhZxfFAIPP52lQ6zZyYKBbGm06Evzz0Xnv8L2hXvCN2H_dEDNSJ21nELdqH_-B2W8TNxNh1AFNjprCLdaAaAihBkSgte37BW8oYsAkGNHoFxxEVJNFUcSYSjWmfJimorcOjW5-IM2wPSpaSuqPupKD8VT8ZNRtV_05Gk0NDksOV6m6ftRx881gFTsLKbIKWt9Gx4240Kh4ehpG3gGvn4CSQ8NSRnpAdQQh6NO3GSD_eLZoRU5TqLRXKroZY1kbbdaOtfgnZqT9P3PXCgzbewyZEpDGeWuiNcSOzbmhhVhbGoM3zw6AQs3AraQMADuqxv1TVCDfz7-9poo0tAdzHhnFlhDDZzFQToKDEod9brW4R-f5dLO5lvlczCoED7hw-wDB0wKdC45wXNaIXlZ79BhfrTQjhG0VMJdzji_J7889BP_EEGkETPtdr0tTZapSgAVM36iPEO_DfaeyMbpBuntOldGqZIweHa3b5gLUU0S0Wy1vwbs9NZ1VEqg2IYTa9Gh_Sh3byv1fp6qjUkRZtPP39QqI2px-3F6Y8df1au-haZY-2pSgeI10vu15Y5phmkHJQRCpmJLXJuh5PJgRTdsLcP3yt95kStfv3o2_AhNGPZ18fShHwja0DIHPJS99h3GRjwU-xXWb1f4D7YgUwYL_roxtYhnyMkYFtUyvO9kOXKd-5_xLqpX1xOriQ7PSxru185Su7PiAMUJkZxSxgzU-2usWUzjDIwlidczpVojrLXDiUtYNFszPlhN4m1J1aoqA0kYAzPMqYYHf65wTXmRzokiflZ8a1914tU1GbsTdM2kkFI3h1QX8Ob52Ndmh3Bh9SY8lclSnHoWODidVBT3p4vMZgEoR-at-h6DdX2Fv2ZPstfgKsQZ1sfAkDdk4H0BXdfqkNlqHoYhuDQVEVVjpQzas1Q0V1lx1PswmQRY4WLlcla698pb7BXhTmKq2SodPUg59SHrPHzUV-1DwKIiJ3swaU0BFFNPUqo2XbzlGIXtZ7CYlMu3CqmpXUfH3KnKHDApa3lkLW6FmIiqcDNHHS3FfZz6N0syTF8QXVOskCyAmrHq0r9udEil0DHE8fpI7VFYTY2Tbf4m32nvtm7EQaxMF8Pc1D46BNrHMUIqK9wsL-jQZ9s_l20r4j1SjHuTtiFg1Dz2Aayn-jk0YFjKsRo06HOBP-gRrJjy_-Dyqf2aoSXZwmsoBVLwe01jV7PR4TiXjlJlP-0YJhQOwH58MzA_5bX3N1cU4-8mSk3zyVLhZrwqbSR_y15XpGYJ7GKBStINkHDyNMuAwM5LtkD7Bj-JWuC9aR-hBWzzeizchD-_-UU3S3GO2m89gHhhl3V0MET0Y_ijSm35Pgf0PedXClzdo2JpqwDOxiiBkzHQZc-f7ncQm6WjEN57YmXzIUkOju8yc4hCWa8-Ra0qo4ewfcerJxEpzkhnjlx_iw9bTadmz1PCgZxZXFAjoSWXdBR10q8oArbEFqC1DdEO0BRsxSbKG6a3I9hUqniBcUpEbyBkM8E10z5QrxNLkb5NYUe6gpNcGsXyLsANJXFiwnX1xmW5fNWPvw-21ps5' WHERE `ID` = '1'

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `PromoCode`,
                `StartFrom`,
                `EndTo`,
                `Discount`,
                `DiscountType`
            FROM
                `promocodes`
            WHERE
                `ID` = 2 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPromoCode','LDiscount') 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEditOrder') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSend') 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
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 4

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'en'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'en' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'en'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Nov-2022 09:04:06] /mygr/www/en/ajax/users/bar.html?_=1668841446249 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') 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
# [19-Nov-2022 09:04:08] /mygr/www/en/ajax/orders/confirm.html?_=1668841448198 167.99.142.201

set names utf8

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-19 09:04:08', `Data` = 'JvRAJFtLiOz4efIjy0gGVbh732FV9H2PsqMM6XArsePeiUrQkXkRY42SOe0gh5nZDGeHVX8l2Mj9AChg83M0gnryCiJq3ddFWFqlbafm8t89hJrMoRVv2qMVZkVc7NeTQYKZyqGwpMCW4BWzgs64FSIisqs72Fh1KhuVNbCAQi_KGo29WYetZoZKujixnNw-FB-aOkvma2oww2YhHzIx2bPhCHfH5n8zj4gFbA2p5RP3tYSC6bUMne1tLg8HPhQ831CH3AEH4ouASWdNk6kcm0DPMoR57s5kPY4bL3KWbQsSqMOU4hjemzvZU0-gNMiEWZQj2Ly6pPtMtm-ybWJ6z5rqvf-4E96HENK-pmj3_-BXHgbRIGgYj0Q1wfwuTKw0mfif29wsMmaL0qiKvLevtAD9Z5PNwOfgI7yeXpp9cVI4wYuRWOlI731v6V5_ta5dLk6NIpNhMmdbY4tClFenTqWQ6lwFglVwiR2Yg7gcqqMMxX01K4F1o_JuY4zn0ZqI90qnmFrz6ISqi0jcdXR20Q-2zc1YVXFm6J3Ts-9OAWK6NB_R2E-4FOEy6m3Zm7gnSgsrqRux6lGlKynio-NsFEsiwP635iks7xzTSuKwixwmZFONqJG1mImhkp_qqDv0qhE4Vqy6iDurRqnbLWHhnS2jrEM7AFCAKmSGsTRYcZYg_P0f5zRrahKrTJkTVS_DLX_oLOFu90OnMBF7II93voWsuT4o53jm4u9Nmr5-pGka86iRDMylwF3vM38zpMawzGfCY5EjAByjzOMWZvpDqFur73FVB5gqlxUl1EptOL2lMOudaSlgcO2Zc1EYVWgeRY9prB2woU5NR8HJQuCnq7oVlwdRZZ86OCbiwydOirQ0jK5uyBBiDzCGwsJU5KKKwkfLmqUGDsXgXzGdcQOQfH0cTZ9Bf4ko3q3x3vhvwjXsf-7IIe1h7U-7yt9FfRk2BZ1MRxqr8LXFZyKZY93AWAHTYWH-v5WPK6UhTIKqmO-U4eiBLmIht9OWVAMulqS9NslETb3P3w_Qh9JCBgnz2-sXmkA7THO1vrIyO9uhqx2mDaR_re_XmO_GBGe8Bmno_fZHEc2cH1AJ_YH1jbbjpA4w13aDVWnfe9QbBv7mniSz60J16U0qzoYWCSTOPvBXktDPUhETmIbUDjVzP5R4Au68MDw-0OvZS59JFUpqJaWc90PkFm9-pp5t13xDi2I1KlnUvog_Bn6qpTgeLP-31d6O2kyObLcKLTd-9npbF0gCCLIxYBQAevxBHiXsYANkInRPz7HLaU93G-6qyNXvRA1jcRcid3s6r6KZhN4Fe9jSwBGuAs1bkB6OyyO63ozpRcs7KunMwZnGWepI5gagVmcSm32OEEZBkqOrsmy-ac3lxctjZzIoMI-cqoFlAk4fvIhhb29g_MF2mTR5chvhiJfk78GcVs5I7dQ6hJG3jYWfMtMWBwF2JDmphD8neOBOdpnOiGOpOCPkGKakse-v1fXJ-I8NgeuuAVNXApJVUb8l_cjSJVROUrjysexeR8bofq1DdUqQEMU0Z5n80-SZai5vHdTyeqG3AnOPz-AzJ6SPUhD8ptJkkc2l3BE8djxe6xEUWCClAuZrCldk2MODrYy96X-ESoJQRiNY7j-DBHK1l4i689pxfYU62_8IO1qKi2I4GaAXBYSfkqGjjFAykcjj0AasZOrm7etKqmmJOP_PK1t_IeJrDpyhZW4UWWPF8uetR8YOUfRIwbwSYd7GwdflL1Qd_5V2_1vPN9yeN8ilNE_UZpuH9pUdU5bi1LEuFnJpqwnJOoC7Yhcym0uUw0FnBG6-2raN-gRJyRWTGTZ32_UwVp65rs0bWGjoae4jVFc6JS1ZcYEFGjhp2APHAmWFUOVhaLMWb0bcVa24DUupogbFXKVsJDt8BO21z-3ZvUJ_ZKeZHYZC_rNECLsRn3j5aSpZxhiGw_bRZqBTgdTqjOyMyy5jgIi3z04fCUQaGPMoswH1qRI8cNJqAcrYkA', `UserID` = 1, `TotalPrice` = 116.1, `Status` = 1 WHERE `ID` = '1'
# [19-Nov-2022 09:04:08] /mygr/www/en/payments/success/1.html 167.99.142.201

set names utf8

SELECT
                `basket`.`ClientID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `orders`.`ID` = 1 AND
                `orders`.`Status` = 1
            LIMIT 1

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` = 1
                LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                COALESCE(`product_texts`.`ProductID`, `product_sets`.`ProductID`) AS `ID`, /* IFNO: to check is valid */
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Dimensions`,
                COALESCE(`product_texts`.`Price`, `product_sets`.`Price`) AS `Price`,
                COALESCE(`product_texts`.`PromoPrice`, `product_sets`.`PromoPrice`) AS `PromoPrice`,
                COALESCE(`product_texts`.`RadiationSensorPrice`, `product_sets`.`RadiationSensorPrice`) AS `RadiationSensorPrice`,
                COALESCE(`product_texts`.`StartFrom`, `product_sets`.`StartFrom`) AS `StartFrom`,
                COALESCE(`product_texts`.`EndTo`, `product_sets`.`EndTo`) AS `EndTo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'en'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'en'
            WHERE
                `ID` IN ('3') AND
                `Visible` = 1

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

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

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-19 09:04:08', `Data` = 'S9141XV-4yHgTdAHq1VrZPfowxgk9tU5ZYTPFuxugvoJS0mXqxCa0JhzmwGuKsJGEx813E1fTX9cHiNCVu0CaJJBJTbqn5hznHv655I04wrf7doae-tlELH0B8B_XgP1kOGAO3FT8CYqUUToCfMfckFwHgUrEfnKnB9hrkHgNN4Yqv0WuIaUASm14tGWPjWZqdpStZV4XRJjUGzOUEikyoCWOK3srt_MS1i9UO-SRufhSnak2zeUfbKLBGWVgKKAXySmIpZO62XoYim42XLSitLBxrjhgMC2WeLBfHKnbEYL5QMNTXrqGOEgJBtxnBPv2DOqZZdTuhbXJIIFrmPUPUZPJPaMqNu9z353zvIf5MiV8K-LM-5RdVwW5RGy6A27M0FMS4GqCI-jQhwI-By5imCvhZRtzy4QAPYEre27HDVdcYWVh82WxJYgCiz-Tz8LOnhFZciXgqHi2JuSwxRrh8drfCfdmQmdAUIMl9Vq6hsS9FXAPkTMbjEtU6MOu1lT3vDtNUakozonVcRQ0hgPGiUjEQc-8W8S1h7Epb-UUhA_k305MlkFeddpvsr5VHimQcJfjXWs6kGsz-IR5iNqnjHgDWv56DvRmKpgHiSwEzdCIDVfadIjHmHn13Zvlpr9yXRkFWV6TCpBLRPkwhnw7sCxI7oBUevC3ttBx4N5Wci9aGve3l7SC3SO-Xxfpq0eYpbcLAocZexzC5pSnrh8GgOgUemi8DHHgMGIxmXtuD9R-Uo4vYgKv32SDVNIYfS0XZttaWtQHxyXNGs_G33KpXRs5LZ_HrvK9bqKdfQSJMzr_xqEiGTfl1eLyLNZu9KFeIvjrsA6xvZFkRaw3-2K_MhAd0slrAy73pSaFbnZ1ynnWVqe-p5T4RHIeEYx4cDuiql3kvHcmrQawYsyqmL8fE2rBY7_7iXewpF8uEEqGHyqPZlKQoovRpa7S8d69IkyubVH5JShys0ISWUUvhUEP0UQHj3yLFhIvjrdr2kZBebTwyXM_xgM7Y1O_wYJk-1GJIib00HDVioRwDYsND1pbUpJNDSKbZBisbYjpcdZjhqyMjf7j9byqOVRii2F8YM9uKuKQmUz2lihBV_yEgaGkNnFWIXg306ZNslE8QRRRfkFoEdBrJqWifnc45hrSX-VSILWezilGwg3KZyCb7KQIVH7-2_q5l2w0JFgfUWK6e-P06Wki5aIo_YOX_44vaPznVkTRJ1RRl4ThOXWVUUdHljHRBflM4DwtnG26aT7Nf4AojDUcNV9KnVXHlc4ueyb-pccEmYh0XhYzoKKuxOdXkk7ksMm4lWnF8nmV5GsLHRsg3CUX5bz6fY5dk-511D8-87JAY3BHYG9Sae6pMB1WOdGZBzqLAR0X9HkYcBwP_knjM7ZZaFTKX1eHj1CuAWINiX2VKQ3elt7Yt5_k_Bq00e0vEfgTGAUslvQWH3cf7YhoHw2qyPSYhzADOraDKvVHKjSWaYRTH1dmZ789bTwJ6BUCXII9QU2_XS4qXs7J9FB2RrXGVT7V7Xz-3qKk10MyxK-mlgaKAz1Gbv2qB1-6kMA4A7KZlZ6QOV200MrBLV2KclDZH1ZrQasaAVv6WQcj0AEX5QCdUdV1wC2dzYbfVSUm7DpKdEQkBF0Ef4EJHyWAsUQShFOJXu9uv7mUExTcOStTvJDMGqVBTQrMG4r2ae6qx33OLY7h3U1zccQwB53T4WphPFx6Tg0IqPPbHUaKob6eTB6jranHpHGidSgkqAB-mUBXrkXtkwLmHmfC1d5YQwC0vsH95tiALjg3M-mWrmA4Ah-SM1cDZQCDIXd4ACBz_UNXPX_6DuA20REszSog53wsWdK4LQGCCy3lOXFihOXE4xpst0oX4yl7v-38XB2-cK1g4zT_Mg6Ue44b5Dd3kMw_J_SJ3ZlBB3MXFNspra8_j_sHoutjKJhdcm44U4AttVbyL5TGuC2LZWtcwSO9v7nyX2OjxvTVostS1EJAiuL30hkQJVAUXYiPcOY8g' WHERE `ID` = '1'

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `PromoCode`,
                `StartFrom`,
                `EndTo`,
                `Discount`,
                `DiscountType`
            FROM
                `promocodes`
            WHERE
                `ID` = 2 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPromoCode','LDiscount') 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEditOrder') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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