# [19-Feb-2025 15:01:04] /mygregor/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
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'en' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 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 `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` 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`,
                `NoIndex`
            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`,
                `NoIndex`
            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`,
                `NoIndex`
            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 ('LConflictResolution') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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 ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Feb-2025 15:01:04] /mygregor/www/en/ajax/basket/qty.html?_=1739970065066 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
                 LIMIT 1
# [19-Feb-2025 15:01:04] /mygregor/www/en/ajax/users/bar.html?_=1739970065066 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-Feb-2025 15:01:04] /mygregor/www/en/ajax/products/prices.html?_=1739970065068 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-Feb-2025 15:01:04] /mygregor/www/en/ajax/geolocation/lng_en.html?_=1739970065067 167.99.142.201

set names utf8

SELECT `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` ASC
# [19-Feb-2025 15:01:06] /mygregor/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
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'en' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 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 `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` 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`,
                `NoIndex`
            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`,
                `NoIndex`
            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`,
                `NoIndex`
            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 ('LConflictResolution') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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 ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Feb-2025 15:01:07] /mygregor/www/en/ajax/users/bar.html?_=1739970067452 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
# [19-Feb-2025 15:01:07] /mygregor/www/en/ajax/basket/qty.html?_=1739970067452 167.99.142.201
# [19-Feb-2025 15:01:07] /mygregor/www/en/ajax/products/prices.html?_=1739970067453 167.99.142.201

set names utf8

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
                 LIMIT 1

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'

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-Feb-2025 15:01:09] /mygregor/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`,
                `product_texts`.`Price`
	        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
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'en' AND
                P1.`URLLabel` = 'products' AND
                P1.`Visible` = 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 `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` 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`,
                `NoIndex`
            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`,
                `NoIndex`
            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`,
                `NoIndex`
            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 ('LConflictResolution') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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 ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Feb-2025 15:01:10] /mygregor/www/en/ajax/users/bar.html?_=1739970070501 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-Feb-2025 15:01:10] /mygregor/www/en/ajax/products/prices.html?_=1739970070502 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-Feb-2025 15:01:10] /mygregor/www/en/ajax/basket/qty.html?_=1739970070501 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
                 LIMIT 1
# [19-Feb-2025 15:01:11] /mygregor/www/en/products/mygregor-station-silver.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-silver' AND
                `Language` = 'en'
         AND `Visible` = 1 LIMIT 1

SELECT
                PT2.`Language`,
                CONCAT_WS('/', `pages`.`URLLabel`, PT2.`URLLabel`) AS `URLLabel`
            FROM
                `product_texts` AS PT1
                INNER JOIN `product_texts` AS PT2 ON PT1.`ProductID` = PT2.`ProductID`
                INNER JOIN `products` ON `products`.`ID` = PT2.`ProductID` AND `products`.`NoIndex` = 0 AND `products`.`Visible` = 1
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Module` = 'products' AND `pages`.`Language` = PT2.`Language`
            WHERE
                PT1.`Language` = 'en' AND
                PT1.`URLLabel` = 'mygregor-station-silver'

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 ('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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LQty','LAddToCart') 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 `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` 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`,
                `NoIndex`
            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`,
                `NoIndex`
            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`,
                `NoIndex`
            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 ('LConflictResolution') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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 ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Feb-2025 15:01:11] /mygregor/www/en/ajax/users/bar.html?_=1739970071799 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-Feb-2025 15:01:11] /mygregor/www/en/ajax/basket/qty.html?_=1739970071799 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
                 LIMIT 1
# [19-Feb-2025 15:01:11] /mygregor/www/en/ajax/products/prices.html?_=1739970071800 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-Feb-2025 15:01:12] /mygregor/www/en/ajax/basket/add.html?_=1739970072873 167.99.142.201

set names utf8

SELECT `Data` FROM `basket` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' LIMIT 1

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

SELECT
                `ID`,
                `UploadID`,
                `Title`,
                `Colour`,
                `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
                `InStock` = 1 AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                    `Data`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
                 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `Title`,
                `Colour`,
                `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
                `InStock` = 1 AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' 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`,
                `Colour`,
                `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
                `InStock` = 1 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-Feb-2025 15:01:12] /mygregor/www/en/ajax/basket/qty.html?_=1739970072962 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
                 LIMIT 1
# [19-Feb-2025 15:01:13] /mygregor/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
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'en' AND
                P1.`URLLabel` = 'order' AND
                P1.`Visible` = 1

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

SELECT `Data` FROM `basket` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' 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`.`Colour`, `product_sets`.`Colour`) AS `Colour`,
                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
                `InStock` = 1 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','LColor','LQty','LTotal') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

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

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 ('LInvoiceNeed','LInvoiceCompanyName','LInvoicePerson','LInvoiceCompanyNumber','LVATNumber','LVATRegistration','LInvoiceVATNumber','LInvoiceAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' 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 `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` 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`,
                `NoIndex`
            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`,
                `NoIndex`
            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`,
                `NoIndex`
            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 ('LConflictResolution') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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 ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Feb-2025 15:01:13] /mygregor/www/en/ajax/users/bar.html?_=1739970074217 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-Feb-2025 15:01:27] /mygregor/www/en/ajax/orders/submit.html?_=1739970087409 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` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND
                `orders`.`Status` <= 1
            LIMIT 1

SELECT `ID` FROM `basket` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' LIMIT 1

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

SELECT `ID` FROM `countries` WHERE `Code` = 'AT' AND `EU` = 1 LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' 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`.`Colour`, `product_sets`.`Colour`) AS `Colour`,
                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
                `InStock` = 1 AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `Language` = 'en', `LastUpdate` = '2025-02-19 15:01:27', `BasketID` = '320', `UserID` = 0, `Data` = 'Zq0_A9tPnCP8fTD2qxnd0IupSa1I3jD5G7kk62ZIZxbk530DIDtbApCPgQ-qUszV76UJcZHPORqLYdZrjJYuF-bIjf_EKwAp_nmeujRptX2asMcDLXG1IFiBcO7X59Csw4Y7IUyaPsJr5AYV0ZcDWHEXjOtL1JF9X-dfB0cwjzORBi-63szxQvpbWmczGqU89rcrFDP21ZU2Y0xHbSevd51xyzMxohUbZdTI6n-WXquUUoP1phBUXu_ubcc2xs5ysu9UMsVUV8rnCuuqhB65YcK3pf_B4yGuIERIUcwRSDnxYx9rYoahjt02RX42UyI2W7DOaBONrUIaFLQinu1HZp62jKrJPPi12jsjiZqTVB1i32UhjAq5A2ZqKKKmHIvO7EBLsiytm3avBr7bkNML7ljGkx8gREwVk3c4fOoQgdeWvHsKThAyizIU9_EkboWZ1TPKuR6Lo8vqEEhsbtuarJS2THmALd8qBlqUwZBMIDyN6OSlG_gY_ZiIYCSoEc3vxa_q5vgbYW0ZXarFEeDEmUt2-e7ruoT5aFwxRQbuydbbAdcw1lMZG_RIaHOR6nOuTMw5DOKmSE_gV-WOxhzjf-RorBdR5P1oqPBCfg43SXEgV98n2beBnvPSZNeaexTmAHKh_3Bkb79DPMNBBI-1gZbXguzMkxhTHBwPSPsoKAlQOrPqzcyS7wGdjcG1HJ4DLTesvWsYWqKIrISO5C8HRVpUV2g5cMCV9T7Uydndd2Ptu8Pc3xK70YCoz9fdMqWerFwjkz3QggIlmc3nzo4FLI1X6JLpZJupaHGYom_87Epo65KqVQGqphFNEA8P9vQNxBY_N6V8yVZgLlIQU4oyvlHhDYi5qAyRUoq0cQsbHPtg1EO9w_3cxFtO-p3TpGooAEqprUgHmz3lAelMGUKJ7erLE3E8I4Vye9Hr2pa5McUZHcZbboRK-6brYj0ktvmzj5swMn39fdrsMRfL-kGyl93oXbgMZptoreuWBAXv8RNgFFw2xWq7qDbWo-nmGn50jxoMPZVNKk5vt0rtTjJzDR9psAj3kZne7OMl8Uu7sLcapVl1LwFXuwjwgsuxPak_YN37ABcVqrsT7rfuTxFp4tMc68MMOYhM3vYGMHHrbHQ6N-9b3OFOn7OaeqXAvrm-zAeCkfvlGId3Uu9SdC5b134v-Rs1mgySN0YFU_Wb-u_f_msFUYKgZwv9nQAeIOnQJAhTErVBfI8vy833HNlt14KFaWQ2KqnwPNKtwJGTTcStawOSdCz0GzIRPMR0ufpot8YoCLTfHibkcrrUOx2T4OuqnueWn0d3dY9V0oDSU0xGVToRZrKK-OzQgd_D93NvFpTMCaaACcMQOCw5_pb90cYLun_JrL6tjtfBttebpwOKxhMXfTthH1JyAQfq0joKVt75XwUHgClx4CTD-yjM6sgWIIp5DPWMUBYvpgEQfnX9Gljk_Bsbu7_ixyybTvbEWzoUE4XmGcfx8m_AD2Khi_5ZAHVIJTc3-vqQuBom4y5eckYfA4D5oCFMz-_xtuUsJMazrxYFaTzs6GD-7wsdiaGQKOrH5DVtrEhvAKo6wTN8pZVrzpuIIC-jpYPYwnpayvN8MlhePMZ4T7fLKQ3a-TAvtt8ad_KlWK0UqJ-3r7Rw9hBrXHPgGmbA6Hgt690nMEfx3cdal5tMHEMrM2qa-Q', `SearchKey` = 'wrvCn8OGw6jCscwrvCn8OGw6jCscwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwrHCn8OYwwrDCsMOGw6jCscK0wrbDpMKsw', `PostDate` = '2025-02-19 15:01:27'

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-Feb-2025 15:01:27] /mygregor/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
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'en' AND
                P1.`URLLabel` = 'preview' AND
                P1.`Visible` = 1

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

SELECT `Data` FROM `basket` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' 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`.`Colour`, `product_sets`.`Colour`) AS `Colour`,
                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
                `InStock` = 1 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','LColor','LQty','LTotal') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LShoppingCart','LCheckoutDetails','LOrderComplete') 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 ('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 ('LPayment','LPayWithCard') 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` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOrderLoginInfo') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

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

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

SELECT `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` 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`,
                `NoIndex`
            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`,
                `NoIndex`
            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`,
                `NoIndex`
            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 ('LConflictResolution') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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 ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Feb-2025 15:01:27] /mygregor/www/en/ajax/users/bar.html?_=1739970087687 167.99.142.201
# [19-Feb-2025 15:01:27] /mygregor/www/en/ajax/delivery/price.html?_=1739970087688 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

set names utf8

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' 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

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

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

SELECT
                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` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-02-19 15:01:28', `Data` = 'X0erPbzHyM2Kfiv3hv2ZQYSRgBculI3gQJqHgB84k9SoPJkvD30PC_-xS69ftAd1VFd93DE1fgPOt_PQ0juiAMMW__drYQlnDa8mpni8RZQF2D5hQXOJE1_4kDI4yFXYum0f64UExJiiryLenTtyNSyPhwMDyP9hLFfyC9X60HJu7yD2OaW1RU92Oc8u5pXeLcLQOoCEqbMdsGzpu_TKpim3rNCBCM_pf6a-y3s4A-49KdaiVo0wv_KzUXpGrntR6wa3dbzM_0GjetYusjTmm_5kec8JUBhd0kwy8OQWK93i0w47JOAHkoH_27yc_Js1g4HZrCZ08abkh162JinW3kay11ZlroPJLbUuW1Tl6M-TFIClyT_OL9357GPVIvbSe8buZxbZoHBkK6EuO_yTZgOB1lzI7_-AajEVUyR5krYzMft59T_TNKz01DrdTS8hMdgpM_BuuQZPQ13q4fSDALTAiM1n6vVS4M5ROqviRx0AWbMBx9K-wn-6hxPs_fs2h9UgawfXYTorzj7WE36wvan731LYt8ocbt24Wuf4vvwF3PhnEZZnBpDFOc2YHYDeVigYd2Msoq2hHNQS81H2ycmnGD7RvUJq2rGdqb7V2eeLNGozmuzOePUjZgyn0oo9Px5EUlb7TDvqhlGR_cTJBDi4MsBDcABTu__UYG1K8fsGPUSorSv4Oc_BMqJtTRAwf_38d9CRzKtoBytI0jGmEiMRjf4U5N_O6FeeHDYGSyB9fdvBIJD-haa4KQr2UnIsVR1ijs82k3j5h--vHkJXKyO4AIY_QYkkNT2hzmGQkd5bgiF-w-lqFvvlzJt-UWzpWpGTMfWqHeZX5fGBOo7p6az2hwv9pf5tsrdD0tbFt8eh2B0a3fgPp2lW7FU0W_PITt5o3e4eElewsh-3U5zdG66Q3JWMpHtucKwn6DBkISDRGnehD1D_2hBzWmunv8xkMmCMKD8XOD3CUV813LI7Wu6pEBlaPd054vPjjTB5Le5xoriYRPFzDl4Gs2JgbA79EUMOjPJSPzsqLifPAui7xSdgX5xftkR9QqKTt2xMq78A7aiLqhc4xzaasdMlvGYdRs47CNixCcjnLqYvqSJQcQhgOrBv-3P-GJOZfuJyDt_vB4ey-0-5gs13fdgxgN551mg9KgQE0-WGYtwi8mLGoLjKh8_dZmcJAEiKs2jewUQYRwOo1JO6XDciyX4VKint3C4T8IKjj54PgqGH94ARtzwrSQTzp4yRFJVzNrn1X3oAPiXjvMZ-mdyAKeGZ37yPBZa6COtheQYKRWnFgV_Y1p_qDrXQAw8WwxQrQu2jCUqS63-v1NK4DTaLDEWF-21oVxfdHGPT94VE7GdYUqe3OmVV5VVnakVLufNLuUK6C-R_2fYOIZu95uZUYDxsxbcwg263F0-j0geDfFDIuTUPmfEfCSsWUkq4n1fQNs7psZXxaM5zRzK38gXknrYM5jnbUHPJ84uBpdmf9C35ipl-KFB0uKLVHVHMoNGYkTUrHcBHwlj6yBfo6iSQQpCaI2bRkyRmHMpOYn31bQqfz8CfmV_n3irUaw1rd6v0l0lKobWqNsSP8YvyyrAn4ZRrAiXpKqvopWXHgmbrKhUm5FTYGPGOjVYAA3Ulf6KiTk_QyUYcbdi1RVnaLugcsHTBwyyRsLiOA0snmucke8KIWDYlhnnU8p6uXVHMCt4qKGQrlNZ6tt63EluvGLGMBzpjklqNnqecUxXqqmwoYt4NrE35tw' WHERE `ID` = '256'

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-Feb-2025 15:02:03] /mygregor/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
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'en' AND
                P1.`URLLabel` = 'preview' AND
                P1.`Visible` = 1

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

SELECT `Data` FROM `basket` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' 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`.`Colour`, `product_sets`.`Colour`) AS `Colour`,
                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
                `InStock` = 1 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','LColor','LQty','LTotal') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LShoppingCart','LCheckoutDetails','LOrderComplete') 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 ('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 ('LPayment','LPayWithCard') 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` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-02-19 15:02:03', `Data` = 'kVlKImRNGaNn-SJZS7aJHAdXi1eMshEMULv3z8dHmNv_09Oxn-ecU7tH3tl7wzXoZfi-bd-dTj_COjsjxVpU3vca4Y0gXCNSc-gOgeQpj1wKFn3DVD73m0qgVYzhpFuZ18nc9WVkA3uXxzcdyg6f1wDMuL7qLThb07pBtJmNf7Cus5B4g1acrsUoIo0LlINS7_rZmf1O7k6TO-h__aUGHKYdDqfsxtW1Oh02p5OfX3FXVyKoof_oJsXeSPQtYP2x0IHB6oWBV1MAM-bkAaG5_J2kcPhLrf7fFcZyUHt_Ygscati07YsYd9We9j_jCdweDOtpuCWNBjORdvvu9DAYzYkQuJmetpqXRcyZD0X3TfVk9DXejqv-iZ_67uCuQ8scPMGJ7OC-BV1FJ1HP6ni0bYLL_taWnU0UbVzZlYY9dnjpQOAB8Ha7zC4jVTkDaNe0WerBL7g56sOaDst2TOnKLlazpjNJcwha4q_SnOvROeYYHV4sKJIFAB_odwGzn-amCM2KufJaH4a7lGlvFRNKtkiknqfqYdDNh68tN_1jbNAo5OX3QxEOE9J_3HP8j2MnCMuIn92LDDh5ginMa4J4UvU45cwhufIfpj4_0VzC3wezRUE_CeoEDTv9lenPHW6CQFbI5IZejeNpFSu2liBXaqnMyW5Skh8OX0BXqMybLwMncOzTPyiT_5lVcswfx9x1MhbVc3IS4osHUi194hJ4s3c1hb_I6O0zBQxGxoy4zE0ZWpTnvG9rWsmbVCISOPLExoT7051CK8CeOXlvEvd3YREx7tNT_On7jdqlbUoeApsvnqfJBBo3WG6yi4P9LvHA3YZ3PmSNWHAJLiAPJhjOT7ztqX0y4MpmBCWWP3WhDzZCR5FwNuBPiCuS1X_2IkLKqFaMjcx6PvZ60AET6bLFahujgQ3hJEER6X6VP5uShyX1yi5mgEDGsbPifl88jIUJYN3emKjYiRvhZng8fvdJmRLZ6VZnZdHO30OvgOADlprNO8_SHVsQgixAjKuQ3zscdIfzGb_2PXWzRP7qaCCs0echDdQrciHewfvYzRISbhGs557iioVb4hSwaAbUBK8grgcbtZNTJyfq6hzcd57jpwW6UlC7YSXHNkLt0Bil_9pZMW_Hg8Xa_EKhy_tIPzLePKd0ltqO-ySPW3Y_kdgcs4pogTrl0kuKSDpGqwj8SEOfQsM1d3VCb64J4pHE1nYIIotPzvzY4agHYYJdDg3W1hw97SJPgd2btfZ5F2Q0-bhyCAUfMlSIg6oJulWlsVLN_oVLFYMnWRg9KNkfZdGM3Kg5XtXmmNCtII6aybMPAC8d2o6If1Unx8h04eaulyYVwH9wd3HJo4OUZD7QTSv9ZzL5Yga9Z0SWlysAt1GIr9A2QAM3-C9kTX14EOLbCf7M29eO6fdbXoC5CAgzPtp4HqwS0hrrYadB75uKScUR-VbzEp1iTvCtbx-KOJub1iacx4rbEwC5QFnxHqT0tq86yeJj9aIbYWoHzh5BUVNt85G10xQpeUSBXGEJ8vnLWVNBYHa39wr-P2dT_noUYTM6XdEFW4NYu0nzPr_oefAKracLJ60YcYJ37y_HEqKAdsRCDWwmW-p8esS273mmRGPGPpFOBmwKqwYZ6ynqQ08PNI4Y5oX5flusj52tdTSBFYF_MM_7bjhciIJ4plU0ft0Tnadk2ejrY_KOAZeqzr7o4vR7xODp7w0dDjairzRd9UR4MDbonsZ-YprraePnZZ1bfw' WHERE `ID` = '256'

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

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

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

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

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

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

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

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

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

SELECT `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` 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`,
                `NoIndex`
            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`,
                `NoIndex`
            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`,
                `NoIndex`
            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 ('LConflictResolution') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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 ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [19-Feb-2025 15:02:03] /mygregor/www/en/ajax/users/bar.html?_=1739970123765 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
