# [03-Jan-2025 07:02:55] /mygregor/www/ 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

SELECT `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` ASC

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2025 07:02:55] /mygregor/www/en/ajax/users/bar.html?_=1735880575815 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
# [03-Jan-2025 07:02:55] /mygregor/www/en/ajax/products/prices.html?_=1735880575816 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'
# [03-Jan-2025 07:02:55] /mygregor/www/en/ajax/basket/qty.html?_=1735880575815 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'
                 LIMIT 1
# [03-Jan-2025 07:02:55] /mygregor/www/en/ajax/geolocation/lng_en.html?_=1735880575815 167.99.142.201

set names utf8

SELECT `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` ASC
# [03-Jan-2025 07:02:58] /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
# [03-Jan-2025 07:02:58] /mygregor/www/bg/ajax/users/bar.html?_=1735880578146 167.99.142.201
# [03-Jan-2025 07:02:58] /mygregor/www/bg/ajax/basket/qty.html?_=1735880578146 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'
                 LIMIT 1

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
# [03-Jan-2025 07:02:58] /mygregor/www/bg/ajax/products/prices.html?_=1735880578147 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'
# [03-Jan-2025 07:03:10] /mygregor/www/mgVh5s90Z 167.99.142.201

set names utf8

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
# [03-Jan-2025 07:03:10] /mygregor/www/en/ajax/users/bar.html?_=1735880590277 167.99.142.201
# [03-Jan-2025 07:03:10] /mygregor/www/en/ajax/basket/qty.html?_=1735880590277 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'
                 LIMIT 1

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
# [03-Jan-2025 07:03:12] /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
# [03-Jan-2025 07:03:13] /mygregor/www/en/ajax/users/form/login.html?_=1735880593075 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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail','ErrorPassword') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2025 07:03:13] /mygregor/www/en/ajax/users/bar.html?_=1735880593076 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
# [03-Jan-2025 07:03:13] /mygregor/www/en/ajax/basket/qty.html?_=1735880593076 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'
                 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
                        `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
# [03-Jan-2025 07:03:17] /mygregor/www/en/user/register.html 167.99.142.201

set names utf8

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

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

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

SELECT
                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` = 'register' 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
# [03-Jan-2025 07:03:17] /mygregor/www/en/ajax/users/form/register.html?_=1735880597152 167.99.142.201
# [03-Jan-2025 07:03:17] /mygregor/www/en/ajax/users/bar.html?_=1735880597153 167.99.142.201
# [03-Jan-2025 07:03:17] /mygregor/www/en/ajax/basket/qty.html?_=1735880597153 167.99.142.201

set names utf8

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'
                 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` = '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

set names utf8

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 ('LSignupEMail','LSignup','LPassword','LVerifyPassword','LFullName','LPhone') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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','ErrorPasswords','ErrorIAgree') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

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

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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHaveAccount') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2025 07:03:20] /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
# [03-Jan-2025 07:03:20] /mygregor/www/en/ajax/users/form/login.html?_=1735880600667 167.99.142.201

set names utf8
# [03-Jan-2025 07:03:20] /mygregor/www/en/ajax/users/bar.html?_=1735880600668 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLoginEMail','LEnterEMail','LPassword','LLogin') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail','ErrorPassword') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2025 07:03:20] /mygregor/www/en/ajax/basket/qty.html?_=1735880600668 167.99.142.201

set names utf8

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

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNewAccount','LCreateAccount') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2025 07:05:21] /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
# [03-Jan-2025 07:05:28] /mygregor/www/en/ajax/users/login.html?_=1735880728580 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
# [03-Jan-2025 07:05:50] /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
# [03-Jan-2025 07:05:50] /mygregor/www/en/ajax/users/form/login.html?_=1735880750194 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

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
# [03-Jan-2025 07:05:50] /mygregor/www/en/ajax/basket/qty.html?_=1735880750195 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'
                 LIMIT 1
# [03-Jan-2025 07:05:50] /mygregor/www/en/ajax/users/bar.html?_=1735880750194 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
# [03-Jan-2025 07:05:58] /mygregor/www/en/ajax/users/login.html?_=1735880758852 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
# [03-Jan-2025 07:05:59] /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
# [03-Jan-2025 07:06:08] /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
# [03-Jan-2025 07:06:13] /mygregor/www/mgVh5s90Z/en/receipts/2.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` = 2
            LIMIT 1
# [03-Jan-2025 07:07:23] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form/2.html?_=1735880842987 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` = 2
            LIMIT 1
# [03-Jan-2025 07:07:53] /mygregor/www/mgVh5s90Z/en/receipts/2.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` = 2
            LIMIT 1
# [03-Jan-2025 07:08:44] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form/2.html?_=1735880924264 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` = 2
            LIMIT 1
# [03-Jan-2025 07:09:41] /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
# [03-Jan-2025 07:09:42] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form/2.html?_=1735880982265 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` = 2
            LIMIT 1
# [03-Jan-2025 07:10:47] /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
# [03-Jan-2025 07:10:50] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form/2.html?_=1735881050033 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` = 2
            LIMIT 1
# [03-Jan-2025 07:15:51] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form/2.html?_=1735881351079 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` = 2
            LIMIT 1
# [03-Jan-2025 07:16:36] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form/2.html?_=1735881396141 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` = 2
            LIMIT 1
# [03-Jan-2025 07:19:34] /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
# [03-Jan-2025 07:19:35] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form/2.html?_=1735881575136 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` = 2
            LIMIT 1
# [03-Jan-2025 07:22:43] /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
# [03-Jan-2025 07:23:36] /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
# [03-Jan-2025 07:25:02] /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
# [03-Jan-2025 07:25:06] /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
# [03-Jan-2025 07:25:28] /mygregor/www/mgVh5s90Z/en/receipts/list.html?from=01.01.2025&to=31.01.2025&keyword= 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:26:06] /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
# [03-Jan-2025 07:26:09] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form.html?_=1735881969831 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
# [03-Jan-2025 07:26:32] /mygregor/www/mgVh5s90Z/en/ajax/receipts/insert.html?_=1735881992012 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
                `Data`
            FROM
                `orders`
            WHERE
                `orders`.`ID` = 23452345 AND
                `Status` & 1 AND
                `Status` & 4
            LIMIT 1

SELECT MAX(`ID`) + 1 FROM `receipts`
# [03-Jan-2025 07:27:05] /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
# [03-Jan-2025 07:27:06] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form.html?_=1735882026869 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
# [03-Jan-2025 07:28:54] /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
# [03-Jan-2025 07:28:56] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form.html?_=1735882135949 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
# [03-Jan-2025 07:29:42] /mygregor/www/mgVh5s90Z/en/orders/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
                `orders`.*,
                 `order_status`.`DeliveryCode`
            FROM
                `orders`
                LEFT JOIN `order_status` ON `orders`.`ID` = `order_status`.`OrderID` AND `order_status`.`DeliveryCode` != ''
             WHERE `orders`.`Status` >= 4
            
            ORDER BY  `LastUpdate` DESC
         LIMIT 0, 100

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('StatusSentToUser','StatusPaid','StatusApproved','StatusPrepared','StatusShipped','StatusDelivered','StatusRefused') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (SELECT
                `orders`.*,
                 `order_status`.`DeliveryCode`
            FROM
                `orders`
                LEFT JOIN `order_status` ON `orders`.`ID` = `order_status`.`OrderID` AND `order_status`.`DeliveryCode` != ''
             WHERE `orders`.`Status` >= 4
            
            ORDER BY  `LastUpdate` DESC
        ) AS CountTable
# [03-Jan-2025 07:29:55] /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
# [03-Jan-2025 07:29:57] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form.html?_=1735882197652 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
# [03-Jan-2025 07:30:06] /mygregor/www/mgVh5s90Z/en/ajax/receipts/insert.html?_=1735882206079 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
                `Data`
            FROM
                `orders`
            WHERE
                `orders`.`ID` = 235 AND
                `Status` & 1 AND
                `Status` & 4
            LIMIT 1

SELECT MAX(`ID`) + 1 FROM `receipts`
# [03-Jan-2025 07:31:19] /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
# [03-Jan-2025 07:31:20] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form.html?_=1735882280132 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
# [03-Jan-2025 07:31:28] /mygregor/www/mgVh5s90Z/en/ajax/receipts/insert.html?_=1735882288523 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
                `Data`
            FROM
                `orders`
            WHERE
                `orders`.`ID` = 235 AND
                `Status` & 1 AND
                `Status` & 4
            LIMIT 1

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

SELECT * FROM `receipts` LIMIT 1

SHOW COLUMNS FROM `receipts`

INSERT INTO `receipts` SET `ID` = '3', `PostDate` = '2025-01-03 07:31:28', `LastUpdate` = '2025-01-03 07:31:28', `Terminal` = '40086901382', `TransactionID` = '34564567', `OrderID` = '235', `Data` = '3D3Y8wmsCjK0bm-O-8mZRFCRLituXEbjM8t0Sxovlz4BGce1v6RNkwCwdqt1kSsBXo6c5yZBgn1UEsiemYEmEJhrXKOSL7OSr01nuxdQgUqQKUxjmzE7j7LfLFH8a4EIZkNY5jI6YSZCHOk1SkyquFYzS_cmU15vC20zy1GA-Pt1-PO-o_vb3_i6G-HgVb8K5PHkO3udb2r6hIAPVfnFiwHAq7Qu74F6VSYmo0SaeF0HaEXbimendTcM_dZsH9lrGp0NIcBCgsIpszye8fdpf8fxgvxxAVt2vanwNIAMDLoxqkTtlghnb1Zdh_8NZdyQrmoXyALXb4oyLpm8Q1Uo1zgGubZolgSwgdZT21yWG76pkBkWxecxe6qXvG2m2wo9Kct65bxqNTgoqk3Dt9CT5xl6MgvxAK3O2hVPADSwNeAFqv3ZOZimpLVuoPHd4TkSHG6e0nKIcBoslhyo8Iyc9vuXv_ND9zbHQrkU2mZemdo1noj1Zq-K6ETP9Xu6q0Jc368ZfNMM2RXJnJ1ajYI2XMtYApcE1gODf0dNmuobIuhiw92BEAvWUzKPwBTwZFRX-GNP3CEi9rQ9lgZBI2NZBlajlsfpzmCXITY9A24V-9xs3psnRAeT-q9pidzWmWlm'
# [03-Jan-2025 07:31:31] /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
# [03-Jan-2025 07:31:39] /mygregor/www/mgVh5s90Z/en/receipts/3.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` = 3
            LIMIT 1
# [03-Jan-2025 07:33:25] /mygregor/www/mgVh5s90Z/en/receipts/list.html?from=01.01.2025&to=31.01.2025&keyword= 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:37:09] /mygregor/www/mgVh5s90Z/en/receipts/list.html?from=01.01.2025&to=31.01.2025&keyword= 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:37:12] /mygregor/www/mgVh5s90Z/en/receipts/list.html?from=01.01.2025&to=31.01.2025&keyword= 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:41:05] /mygregor/www/mgVh5s90Z/en/receipts/list.html?from=01.01.2025&to=31.01.2025&keyword= 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:41:15] /mygregor/www/mgVh5s90Z/en/receipts/list.html?from=01.01.2025&to=31.01.2025&keyword= 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:41:45] /mygregor/www/mgVh5s90Z/mgVh5s90Z/en/receipts/xml.html?from=01.01.2025&to=31.01.2025 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 `Language`, `Label` FROM `languages` ORDER BY `ID` ASC

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

SELECT
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`,
                `NoIndex`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         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'
         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` != ''
         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` != ''
         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'
         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
# [03-Jan-2025 07:41:45] /mygregor/www/en/ajax/users/bar.html?_=1735882905639 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2025 07:41:45] /mygregor/www/en/ajax/basket/qty.html?_=1735882905639 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'
                 LIMIT 1
# [03-Jan-2025 07:41:58] /mygregor/www/mgVh5s90Z/en/receipts/list.html?from=01.01.2025&to=31.01.2025&keyword= 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:42:08] /mygregor/www/mgVh5s90Z/en/receipts/xml.html?from=01.01.2025&to=31.01.2025 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC

SELECT `Language`, `Label` FROM `languages` ORDER BY `ID` ASC

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

SELECT
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`,
                `NoIndex`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         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'
         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` != ''
         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` != ''
         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'
         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
# [03-Jan-2025 07:42:08] /mygregor/www/en/ajax/users/bar.html?_=1735882928643 167.99.142.201
# [03-Jan-2025 07:42:08] /mygregor/www/en/ajax/basket/qty.html?_=1735882928643 167.99.142.201

set names utf8

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'
                 LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2025 07:42:44] /mygregor/www/mgVh5s90Z/en/receipts/xml.html?from=01.01.2025&to=31.01.2025 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC

SELECT `Language`, `Label` FROM `languages` ORDER BY `ID` ASC

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

SELECT
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`,
                `NoIndex`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         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'
         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` != ''
         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` != ''
         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'
         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
# [03-Jan-2025 07:42:45] /mygregor/www/en/ajax/users/bar.html?_=1735882965142 167.99.142.201
# [03-Jan-2025 07:42:45] /mygregor/www/en/ajax/basket/qty.html?_=1735882965142 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'
                 LIMIT 1

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2025 07:43:20] /mygregor/www/mgVh5s90Z/en/receipts/xml.html?from=01.01.2025&to=31.01.2025 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC

SELECT `Language`, `Label` FROM `languages` ORDER BY `ID` ASC

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

SELECT
                `ID`,
                `ParentID`,
                `MenuLabel`,
                `URLLabel`,
                `ExternalURL`,
                `NoIndex`
            FROM
                `pages`
            WHERE
                `Module` IN ('pages', 'products', 'faq', 'contacts') AND
                `MenuLabel` <> '' AND
                `Language` = 'en'
         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'
         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` != ''
         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` != ''
         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'
         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
# [03-Jan-2025 07:43:20] /mygregor/www/en/ajax/users/bar.html?_=1735883000806 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLogout') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [03-Jan-2025 07:43:20] /mygregor/www/en/ajax/basket/qty.html?_=1735883000806 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'
                 LIMIT 1
# [03-Jan-2025 07:44:08] /mygregor/www/mgVh5s90Z/en/receipts/xml.html?from=01.01.2025&to=31.01.2025 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:44:45] /mygregor/www/mgVh5s90Z/en/receipts/xml.html?from=01.01.2025&to=31.01.2025 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:44:47] /mygregor/www/mgVh5s90Z/en/receipts/xml.html?from=01.01.2025&to=31.01.2025 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:45:57] /mygregor/www/mgVh5s90Z/en/receipts/xml.html?from=01.01.2025&to=31.01.2025 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:49:26] /mygregor/www/mgVh5s90Z/en/receipts/xml.html?from=01.01.2025&to=31.01.2025 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:54:10] /mygregor/www/mgVh5s90Z/en/receipts/list.html?from=01.01.2025&to=31.01.2025&keyword= 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 07:54:12] /mygregor/www/mgVh5s90Z/en/receipts/xml.html?from=01.01.2025&to=31.01.2025 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 08:05:47] /mygregor/www/mgVh5s90Z/en/receipts/list.html?from=01.01.2025&to=31.01.2025&keyword= 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 08:05:48] /mygregor/www/mgVh5s90Z/en/receipts/xml.html?from=01.01.2025&to=31.01.2025 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 AND `PostDate` BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59'  ORDER BY `ID` ASC
# [03-Jan-2025 08:30:39] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form.html?_=1735885839777 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
# [03-Jan-2025 08:30:57] /mygregor/www/mgVh5s90Z/en/ajax/receipts/form.html?_=1735885857152 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
# [03-Jan-2025 08:31:45] /mygregor/www/mgVh5s90Z/en/orders/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
                `orders`.*,
                 `order_status`.`DeliveryCode`
            FROM
                `orders`
                LEFT JOIN `order_status` ON `orders`.`ID` = `order_status`.`OrderID` AND `order_status`.`DeliveryCode` != ''
             WHERE `orders`.`Status` >= 4
            
            ORDER BY  `LastUpdate` DESC
         LIMIT 0, 100

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('StatusSentToUser','StatusPaid','StatusApproved','StatusPrepared','StatusShipped','StatusDelivered','StatusRefused') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(*) AS NumRows FROM (SELECT
                `orders`.*,
                 `order_status`.`DeliveryCode`
            FROM
                `orders`
                LEFT JOIN `order_status` ON `orders`.`ID` = `order_status`.`OrderID` AND `order_status`.`DeliveryCode` != ''
             WHERE `orders`.`Status` >= 4
            
            ORDER BY  `LastUpdate` DESC
        ) AS CountTable
# [03-Jan-2025 08:31:47] /mygregor/www/mgVh5s90Z/en/orders/235.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
                `orders`
            WHERE
                `ID` = 235
            LIMIT 1

SELECT
                *
            FROM
                `order_status`
            WHERE
                `OrderID` = 235
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOrder','LInfo','LProducts','LPrice','LQty','LTotal','LSubTotal','LPromoCode','LDiscount','LClient','LReceiver','LDelivery','LPayment','LPayWithCard','LPayOnDelivery') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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