# [11-Jan-2025 07:52:21] /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
# [11-Jan-2025 07:52:21] /mygregor/www/bg 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' 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` = 'bg' 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` = 'bg' 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` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' 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` = 'bg' 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` = 'bg'
         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` = 'bg'
         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` = 'bg'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'bg' 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` = 'bg'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'bg' 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` = 'bg'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2025 07:52:21] /mygregor/www/bg/ajax/basket/qty.html?_=1736574741563 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007'
                 LIMIT 1
# [11-Jan-2025 07:52:21] /mygregor/www/bg/ajax/users/bar.html?_=1736574741562 167.99.142.201
# [11-Jan-2025 07:52:21] /mygregor/www/bg/ajax/products/prices.html?_=1736574741564 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` = 'bg'

set names utf8

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

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

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

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

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

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [11-Jan-2025 07:52:25] /mygregor/www/en/ 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
# [11-Jan-2025 07:52:25] /mygregor/www/en/ajax/users/bar.html?_=1736574745166 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
# [11-Jan-2025 07:52:25] /mygregor/www/en/ajax/basket/qty.html?_=1736574745167 167.99.142.201

set names utf8
# [11-Jan-2025 07:52:25] /mygregor/www/en/ajax/products/prices.html?_=1736574745167 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'

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007'
                 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
# [11-Jan-2025 07:52:26] /mygregor/www/en/accessories.html 167.99.142.201

set names utf8

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

SELECT
                `products`.`ID`,
                `products`.`RefID`,
                `products`.`UploadID`,
                `products`.`Gallery`,
                `products`.`Visible`,
                `product_texts`.`Language`,
                `product_texts`.`Title`,
                `product_texts`.`URLLabel`,
                `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` = 'accessories' AND
                `products`.`Gallery` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

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

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

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

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

SELECT
                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` = 'accessories' 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
# [11-Jan-2025 07:52:26] /mygregor/www/en/ajax/basket/qty.html?_=1736574746248 167.99.142.201
# [11-Jan-2025 07:52:26] /mygregor/www/en/ajax/users/bar.html?_=1736574746248 167.99.142.201
# [11-Jan-2025 07:52:26] /mygregor/www/en/ajax/products/prices.html?_=1736574746249 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

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007'
                 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 ('8','9') AND
                `Language` = 'en'

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
# [11-Jan-2025 07:52:27] /mygregor/www/en/accessories/cables-white.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
	    		`URLLabel` = 'cables-white' 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` = 'cables-white'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReadMore') 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` = 'mygregor-cables' 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
# [11-Jan-2025 07:52:27] /mygregor/www/en/ajax/basket/qty.html?_=1736574747214 167.99.142.201
# [11-Jan-2025 07:52:27] /mygregor/www/en/ajax/users/bar.html?_=1736574747213 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
# [11-Jan-2025 07:52:27] /mygregor/www/en/ajax/products/prices.html?_=1736574747215 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 ('9') AND
                `Language` = 'en'

set names utf8

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

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007'
                 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
# [11-Jan-2025 07:52:29] /mygregor/www/en/ajax/basket/add.html?_=1736574749087 167.99.142.201

set names utf8

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

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007', NOW(), NOW(), '{"eyJpZCI6IjkifQ":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` = 9 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` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007'
                 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 '%"9"%' AND
                `InStock` = 1 AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' 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
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [11-Jan-2025 07:52:29] /mygregor/www/en/ajax/basket/qty.html?_=1736574749155 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007'
                 LIMIT 1
# [11-Jan-2025 07:52:30] /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` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' 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 ('9') 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` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' 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
# [11-Jan-2025 07:52:30] /mygregor/www/en/ajax/users/bar.html?_=1736574750566 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
# [11-Jan-2025 07:53:09] /mygregor/www/en/ajax/orders/submit.html?_=1736574788762 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` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' AND
                `orders`.`Status` <= 1
            LIMIT 1

SELECT `ID` FROM `basket` WHERE `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' 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` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' 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 ('9') AND
                `InStock` = 1 AND
                `Visible` = 1

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `Language` = 'en', `LastUpdate` = '2025-01-11 07:53:09', `BasketID` = '319', `UserID` = 0, `Data` = 'dBIg4dbMTVatif84wM0ctQ7PfEhfsvhHp1E-nm_1gSTrqzbIr0vImVENrqJuWFcA6mb5O4LRW2-rpGQjwOXjZNodatDaflPDee4pgz0a695I-7op5PGvMbU9FL5P6x47B2qkWdTMu6agrYqBWjeJ78EgF8dhbBwFMC9A0IUvnOjZpIgr8QaKSb-MC6xSudOhRAksPj_lHeJ6R_vZfqV2bZAQzAUm1BqLalEpvoCmjTjF-2OZq8YUQ3GwGdA11VSJ32Z3vS0LTHgXHWzr7PQVU9fUv-UKviPTs9SalAMbe-bHQVyHSo-wtHC0ldiBYQTfoFySI6gaqQhDpzJ_9qtZgoLNDIgOtqTDVWo3qEJBx8tml2pmoHLS_RLp11myzSCZU4RSr6vFa-PxIzYLYgSmhhK9QQeT3fCYyeBJ_sdoDLWAut2meK_KUM526jpaGkHtd2_C5V_lfoeH20fCHl8HQuYj_Cajd6HwowgYNOltQWpcxM4RxqAfRsMk5CHeYOpdDmOAZBlTO1ljPQYnmV3dK3-jJg6GiYWg8f-QXxRRqmav-OI8izE7ex5BtiTcvg7i_1Y94gNe_L4LyauidXd2iSQdtr9e4zG96TEorBLKelpZXrliFw1yn0tl6TQD8bOMlBZoDqEwh84qiPron7bBIyunIOVQL8qLMG3FqmPe5kTGq3QboUj9ZYx2aZWpaedZSnCWAwg7EroHpi7RP6X70d1Zc3tS6tdik51fK_mDjRRqO3CQj-hQlFT45hdX85bQwtspPSdes5TkPwvTiqd5BIl6dUBPb5KKUvXDlTZ3tbQVlMFChckdjEDh3cYuT2Nryn7Jg2CfVV54NhqJOTaWathQ4J8qwbdnOPI2toQPEiHJN8JZ2Yq4-TKFwDHPrMYpKz0jtkif_O20vyGwlZuzq1So24A3UwAOlDK4jVfJpddGKg1EM2gXQrLpJX4nQAmSRGP9l13VoWgB0piYbNoKNxMk0xOXD_AyM_27ZmgWzqNuggbyjNTRpj6UFM-qCXcK0pXw-ob2YuyOFW2kNhb5-x5ZI5itzRCXXALYVwiM0ukwt_0puz3upsJmabh-wje3RApfStfVT14Fxk6_c6TjnoZOnM7zKXvXGB6u_rL5mBN4s8YLaFa8_1BeS_WwHzTa75ovHbKZBAXKn6bqZEqU1kNiFr3V22YNxQVLJ643EjFfr8OAQhSkDGUvBHwdaJtu3TQo9uH-yCvMGATJ4ojnab4vEg0_PmCJIsCgTQTOyjpe454b686mE51mPvYNSZwbn3e7M1gZZpPU2Qwjc8Nt3sKzKFdE25BS7MO6_276mSdn7azDQ_jVPeYg84fL5GEwHcU8nk7gvYXqe3ARkcwH4jmqAP72nw6Ciy-g-2J5_mTtusXlIhQiyy_ZbR-8KBuaxXVYe6xgpTSJz9FBTGL2z0DQj7o-hpqDciUMiP_UE2abijmEVTFFRumOZdPOZeFKHfaAoe5oZE7dyI_X2qBjEYkdK4vYOh0AfP0XlICI_ZC9i6oqzcLIqRW6eY0_6P7Q', `SearchKey` = 'wrvCn8OGw6jCscwrvCn8OGw6jCscwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwrHCn8OYwwrDCsMOGw6jCscK0wrbDpMKsw', `PostDate` = '2025-01-11 07:53:09'

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
# [11-Jan-2025 07:53:09] /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` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' AND
                    `orders`.`Status` < 2
                LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' 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 ('9') 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` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' 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
# [11-Jan-2025 07:53:09] /mygregor/www/en/ajax/users/bar.html?_=1736574789002 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
# [11-Jan-2025 07:53:09] /mygregor/www/en/ajax/delivery/price.html?_=1736574789006 167.99.142.201

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

set names utf8

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-01-11 07:53:10', `Data` = '53p8wwQUpy7fhP81U1hNL9IPTQ-XGNelw0Of9ux7B46eOJ6g-q8f7howDdZJiwpdu35wAjO4f6ADMYm9a05k49jOCio2CiV8a8G7cUvF7xykIGZQrT6s761L_YpdMkktKWEFRIZtCuzIi0WfIj0WjOP4o7tVMns7QpQXY1Ohga11Ur8njB34oafLWLdf-lR9oysRFatvKJXS9037ND5OwRCt4HexYDez02bs1ds8ihnPQBtjvDc64prCMAsXMOU64fqyKEmAANsVUVeu_kRFOceshzenEV4njyeIVcffxvxO1Iu0OGyzzUKCv54g1J21DK67w3URoZhTsg3rJHh-hdTyvzVmtChx2snC9sJ2JudZjcfpToiE2xMBecMLF9sD95n-nIMtKuQg1D5erE_7MYFhCfDFRzfFXTBZzc0qwBWScuTsU2wZYdERSv7GtgAdda3mmjPVcYlJ8n8dInd3Kv3OSQsPrY3P66pofCWVX3qg6v-N_ptVHs-2JgwfBwvkX6oj1Foo07i8MqWTOeddXUleJw3y-1oOZtwokTA9A2ORgDUg4qNt-fYBGlSXEycdX3FxZigApiqnOaZnSSo49vMConYmMV9N4_LwbXfhclrod5eX1Sjch39WsROMZaSJZw5X9QQeRtVN-pdocgc4JFTVynsALeQMBWFN6oAOaLcSERAdhWMc4QnIF0e61l4byGgSYkIO2-xMeIF22D4lXFuL4qZSusN5LOhgiNioGIubgLvgAXVPvdlaYifVOK7rEVOB79BHrI2xt6W2rGElYsmJ7yXuFV8WyxcSpvGIrePSJ8u-K0Pww8BeH4M4RYSTFEpV3yFsfFLRQHYTmuJS7Erwd1mqheHgzXbS8UM28UBiOnBygWE-DA_tz_grjsX-IW6pz_Kp88Rc-ZM4iO1Q6dmOeVekjaCatW_-TblcYyDzh7nxK02p6ocnhmsZvrDKWDouEqfnpAZab4j-3eWJQzV5loORZ-51yhJADoF7rj4qjFk35n_1X1DY3_lv5ZEJiAfJSWT-0HqokYyr7fqB111tkWd_Mt8n3JDazAdEEkKQwfhNhLuHgFCwtDweIqNmcChUsnINd0WIvXyvwBfdHBozjci3mFrkMU5IdEbJsqaXj0UZ_SJpVWHqJyoHcGfLh3eAiNVdCAI1kEyu7uRHYgnGFxz0e4tbZdShhXRAqd99rAYLZzS_dcbRfpXOOWwkUkmjKD63vEG0h0Wh73G-JMt9vNKlMpDwpPEi18OnGraMmNbNN6BLZV8FLIc2Ue_sPdqSz3VnLO8to9TlnzoldjngOW6Jyp_H0Vq8m8l3Js4q8wnFvI_p_QQGj_YP6XCShQI_GicGQWwiaxtBM6TE3fGpiwH0t2UV9vMTsTnooeecpPG8-2zCCx80ZezM15scd_bJg5dXBxHSLc317bLChRDi9FKn8jsZN9FHq1_rIK_2DblsL50ADTLyxQ018XUWuabsPJHGdqQhLizaRtIJCk3FrmFF-SzhzodfOS7MHEizZZhCvQ50-gPTWvPPNSRxA5QQawNQ0gK_jOx-JF5RBKQXWGvdjAaZu97tAes9TOLL94Q921d6bzLWTHFp1L_6' WHERE `ID` = '255'

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
# [11-Jan-2025 07:53:12] /mygregor/www/en/ajax/orders/confirm.html?_=1736574792041 167.99.142.201

set names utf8

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-01-11 07:53:12', `Data` = 'pikV52PCWuDRXuy871fwap695dmUSy9WcvsmQ_CRwzJZ_KDzhWruIBKnnCJkMN5-e7sKMG8Mi5l0eQ4XnBO1_67_1fpFxFo4lbqt67egl8bufDA24r5ZVTOUYvb4BVokHd9n7jQfWmWnhJA9SnUPUwTH26ZXNjI1eQjTNbLfVvYFi3524HNnfTOzPo0ZvLNdI2nPB7-IE1Gk7aiYyDFSaoQU_1UmOgIrCWJPx29YGXbTtTzBIpuuACUr3iO5N967e1veSGJ9TPZ7LUNrhQo7Uqq_rV_gD8cNKrfJ9YhJdIovVjcd-Lx_00kYJxHUtjAD-rawSGIF5vy4MS-4Kj0uC2jFHobJW0zDne3Uq8iK1fjLyGnGqjV71kJegNxCseUoRmyMvRGdJVpKEAjJx5p2ssSn62JlIbGlpsgSroivAJfpCKITELbUquPlV6OSl4shUixNEsMv-fN4PFqH_WNNEbzSQWm1sRvCgVvq6p38-Pak4hj5li1yPpI6qfPy0pJ8v8wfzE1tMdhCooDKrN_yLjazSLj20L0DrsnAMlExrrm6EgzTF0XQhLwefn3o0j7mJZc0gchZRDwrdKB0K3yS2unIqvsI3PS6P2FYEZJ7xVAMV3k7zIcrYZSAvbTlRgDPpTPDv5XjFAuBlz4CmTi8nQjsOc_J8wiPzbtcKQe9h2QDSO6pv2-OnhsKh-P12y4bZH8ZXTMmO9Rx5GWULt-c5C6NLWbGTeko2SVScabeo_kLWlpNshxKziVTvB0XWIJTgH1eTKgTaxVu1_YpEg_A2YXDwVrQZvLQ-P1ev3etkwgHtkaEEpfzjsrnYeW8Vr8tHOFLRsUJ5178oEveMPhAxczmIgnyIZxLe5L07IKOilpUV_tkdglCZkf6dNo6d7MRlZXPNvGnOZB201PE0IHBDhCCtGkedRSVoH1qbT_ix66I6NTJGgihwcAnIPw0ocfCxcNvYfVxWwQwXVTHIXw722qiT-njqxTM6yJJFGAZySdJtKtL7ZHCFrTF_lIq2dlXySJr1YXngBQ0QyNzQUapAC2rskVrIfQ8ZXh8Ky6YXJ_TpuWOAjEKr2g8RmkGiJpixtLASOymht4YrwO3l5qt0ZZtaQG3NWm7N6CnuLHgzp0KLebAkKvSEfYR90DZ51255mG24cM9cAr9YnAv4-552m1XIvtA_b7_QLhEWHw2PNBFy13oyd-nltNxkfqBXYBQrJcZVElLT5NDMGBOrxKLTnz0fywEgUXXxFqNQHdQZI4cyMqVq8oQ52jrrDc-tKMK7tKULey8wWUqz41ahzN2E2fAdxWVrnUXvWZ2YLdgXta8rbVrplt8do8MT4Wez00o0S30P9j3tLTkMoQjRb9Gq9ph69ZAdQqj_eAgmd5EO_kJiubY04EM4jgpGsVIGQ54db4lZ5dta_zB4kn1krhs8oLINs9afclV6TBGLuj8Hz6BWlyx8oUwes0H7wWdTeWSTo_zUeMl5UKaTikPk7V_80CB6qCJA7sF42LhqyEuoaxJ5bi42RPcDaZsHeQ32h4ZZ5MNGGBtmQwP5mQdsZdsIYGXNwF6eth5SA6nDWfwBAGBosO6wzLY_JJdH6A6HVmGe0lLulM8XOfMLzyXXoIjtvaY4xj3oEHl1xn_Mx_xN2j4zRZiByLF4JQua7tXIuTpo990Bf5uDuOyoMV9xHbzcP24rD7wcR0tzh9pmsk_5Xq51dLfaNXSQNFyuDzunK9iVw5jr5_eBfw4ATJjkQ4dj5XjyMZ4X2m8rbWX8Ggw6vVg7dYqM51OnO1D_emBbcsCYMx6HNjLHdpFjhidOstEBgLpA2CLEgEq42HTW94YtDDRgeGgbiPVfVIRrYbm5i6uhf-_2OUKAAOadRRBUfRiDCHZPNeTOTiLBDeOV10ijmo', `UserID` = 0, `TotalPrice` = 39.82, `Status` = 1 WHERE `ID` = '255'

SELECT * FROM `receipts` LIMIT 1

SHOW COLUMNS FROM `receipts`

INSERT INTO `receipts` SET `Language` = 'en', `PostDate` = '2025-01-11 07:53:12', `LastUpdate` = '2025-01-11 07:53:12', `OrderID` = '255', `PaymentData` = 'fKiaSpAVVF0piqtBp5e12atXj4SPVmyQ3zCpi6TDxGVjbV3bsxw89V__BfvU1X2_vzqczTGHmTgZXO5STPMO5uX1BvDKVFDUax4IW9VBJZEFogY3QZNIuGLPct0J0p2o6G_oGPAJVdY4XPiD_5xxP-uMDnd5ragnw9LbJbrI3Wd3UyuA6tA42dbouakoI1vChUnEj77mA3Z6ApxUGEPOmAN5oJ0pXqOMEyRRJOMD9RzLrNv59u2Pt_NyS6DpmuMy1mbH88wT0dTwlEpFLMveI6Y_D82s0Xz_IsvzRTHOUKD5QYNH6mxk3CVXMXwchkiql1NBfCccEuE_tfaYU8V5_yl-IaA_aedx94RKmhDvC_RD3FfcxPG7VH2IyIq5YtE-PGLoFjIxIiLOp8kykdND6Xe1uNPiqqGd003AIHyaOJ4pG1aVnqtmoBIyprQyYowMaH0GKqnTxcgPjQX7kffhD2pqJSJp9mz7IWQOHTEMSTXbyqiGMVjf0ChdFvrPVBTh1GculcxzfvpzslFM6oJpcDmvtW4NXtRIXwB7Ns3yYRrGQV-53IIpta_I8TZ6MsVOqFaeEUWnK3zfsxS1w9BjiNt60X_OHjFrHFj3lCCJQrA68C26OwIh3LdLbciHzp41-QOn73RbiZZJGudROMZs8ML4fhngMENTZqu9sPN5uDAJ7buWQXqkjCmlFavjc6WgsttlyuFb6PoRDrpbbZFlS3PzISrG2r-zujgQfK_8QtU', `Amount` = 39.82, `Currency` = 'EUR'

SELECT
                `orders`.`ID`,
                `basket`.`ClientID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `orders`.`ID` = 255 AND
                `Status` & 1 AND
                `Status` & 4 = 0
            LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' 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 ('9') 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 ('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') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' 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 ('LOrderSubject','LSupportText1','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPostDate','ErrorLanguage','ErrorOrgPerson','ErrorVAT','ErrorOrgName','ErrorAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `Language` = 'en', `OrderID` = '255', `PostDate` = '2025-01-11 07:53:12', `LastUpdate` = '2025-01-11 07:53:12', `Data` = 'tymShQSIX97lpF1JwppDlHF5US5Amcoqwt4LEULqnA4RrkjsnfiUeT1kaTft15ZTwoAPl6muIDdFp9yzc8oyQ4qLaCwziSFWn2NKOVRy0Mvp9A3gryDzY6QTBftB8hcEEJsgLRd8QTN5oW1ftLf1Bd0hJ7K3VmhUulGh2cUAFlXFZg_R3c46on84PjIoPn7H-X4l2qNBkfv8IPO0DatkiKx1CQhSBO54UeU6tgTGaYBmoFdXegD1SNd-lHHYfvhMryXpgcq0gbxNCHVH_HrBrRWLJGIZBPM1Kisj1edp6JzZDTNmIasmmiQ27o-ThyIfJtTNkgoZOylEh26LPhEr-odBccZAK4m0z9NevArejiOhF5Ul9sdpNe_tsDL3NKL31PKno-NNgK6DRwhDYjjYro2BkoCM-vdrpmtb3mcTNdRzSsomF5wMNzrhCzVTXvMAp0jc68-LTiLoB5HvFlBIyUtOlrBNDlY8-xTIvFqSaws9ov6NiOY76--U-IiXh9Zcl2vqdgleahBDIKVMASMb6DC4-iCbbX8XWBXLgPFuuCLGfa3pHavTDkknmJ4s4bk5CnBFXMsCQLspGZbYvHRpK87MRwjkvGuOY0hCzH1x4ltbeuBCd85Jln0Bm2aaqNEaMyreAVQdlwKzHdIMJYWU3VDi0pCQnAvsgxzj2g9uEiVA208Y6Yp8bBKR58Lwt6nv-XbzDGZAhnfY52pTdgD10cfP1ROfqWisQVC1vfCK_zFi_vd8dAAgN3QuGSP3fTQWCB1vhoTqAepucZeO-atlE77CzLWPVqsmT2ulvdCqBmk', `SearchKey` = 'wrvCn8OGw6jCscwrvCn8OGw6jCscwrDCisK2w5fCr8Kzw4LDwrHCn8OGw6HCrsOEw4bDoMK2w4bDwrHCn8OYw'

SELECT
                *
            FROM
                `invoices`
            WHERE
                `ID` = 1000000167
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LOriginal','LInvoicePerson','LInvoiceCompanyNumber','LInvoiceVATNumber','LInvDescription','LInvQuantity','LInvPrice','LInvSum','LInvSubTotal','LInvVAT','LInvSlovom','LInvTotal','LInvPaymentMethod','LCard','LPaymentOnDelivery','LInvReceived','LInvComposed','LInvNoVATInfoEU','LInvNoVATInfo') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `receipts`.`ID`,
                `receipts`.`Language`,
                `receipts`.`PostDate`,
                `receipts`.`PaymentData`,
                `invoices`.`Data` AS `InvoiceData`
            FROM
                `receipts`
                INNER JOIN `invoices` ON
                    `receipts`.`OrderID` = `invoices`.`OrderID`
            WHERE
                `receipts`.`OrderID` = 255
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReceipt','LOrgNumber','LOrgVAT','LNumber','LOrder','LPOS','LTransaction','LDate','LOperator','LKol','LPaidByCard','LItem','LItems') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 2
                WHERE
                    `ID` = 255
                LIMIT 1

DELETE FROM `basket` WHERE `ClientID`= 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007' LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 4
                WHERE
                    `ID` = 255
                LIMIT 1

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'orders' AND `Action` = 'success' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1
# [11-Jan-2025 07:53:16] /mygregor/www/en/orders/success/255.html 167.99.142.201

set names utf8

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

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'orders' AND
	    		`URLLabel` = 'success' 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` = 'success' AND
                P1.`Visible` = 1

SELECT
                `Data`
            FROM
                `orders`
            WHERE
                `ID` = 255
            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
# [11-Jan-2025 07:53:17] /mygregor/www/en/ajax/users/bar.html?_=1736574796753 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
# [11-Jan-2025 07:53:40] /mygregor/www/en/user/login.html 167.99.142.201

set names utf8

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

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

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

SELECT
                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` = 'login' AND
                P1.`Visible` = 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
# [11-Jan-2025 07:53:40] /mygregor/www/en/ajax/users/form/login.html?_=1736574819921 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLoginEMail','LEnterEMail','LPassword','LLogin') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2025 07:53:40] /mygregor/www/en/ajax/users/bar.html?_=1736574819922 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNewAccount','LCreateAccount') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [11-Jan-2025 07:53:40] /mygregor/www/en/ajax/basket/qty.html?_=1736574819922 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'b25a0f53484eb8a87dbae4557e4c40e1792157c8a5469d2e62bdfe258d06d007'
                 LIMIT 1
# [11-Jan-2025 07:54:01] /mygregor/www/en/ajax/users/login.html?_=1736574840831 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS Access
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8e17f241486172e9982926a73624b58ee%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [11-Jan-2025 07:54:01] /mygregor/www/mgVh5s90Z/en/pages/list.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1
# [11-Jan-2025 07:54:04] /mygregor/www/mgVh5s90Z/en/receipts/list.html 167.99.142.201

set names utf8

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

SELECT * FROM `receipts` WHERE 1 ORDER BY `ID` ASC
# [11-Jan-2025 07:54:07] /mygregor/www/mgVh5s90Z/en/receipts/23.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `receipts`
            WHERE
                `ID` = 23
            LIMIT 1
