# [24-Mar-2025 12:29:43] /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
# [24-Mar-2025 12:29:43] /mygregor/www/en/ajax/users/bar.html?_=1742812184633 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
# [24-Mar-2025 12:29:43] /mygregor/www/en/ajax/basket/qty.html?_=1742812184633 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                 LIMIT 1
# [24-Mar-2025 12:29:43] /mygregor/www/en/ajax/products/prices.html?_=1742812184634 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'
# [24-Mar-2025 12:29:43] /mygregor/www/en/ajax/geolocation/lng_en.html?_=1742812184634 167.99.142.201

set names utf8

SELECT `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` ASC
# [24-Mar-2025 12:29:45] /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
# [24-Mar-2025 12:29:45] /mygregor/www/bg/ajax/users/bar.html?_=1742812186657 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` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:29:45] /mygregor/www/bg/ajax/basket/qty.html?_=1742812186657 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                 LIMIT 1
# [24-Mar-2025 12:29:45] /mygregor/www/bg/ajax/products/prices.html?_=1742812186658 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'
# [24-Mar-2025 12:29:50] /mygregor/www/en/ 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:29:51] /mygregor/www/en/ajax/users/bar.html?_=1742812191996 167.99.142.201
# [24-Mar-2025 12:29:51] /mygregor/www/en/ajax/basket/qty.html?_=1742812191997 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

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                 LIMIT 1
# [24-Mar-2025 12:29:51] /mygregor/www/en/ajax/products/prices.html?_=1742812191998 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'
# [24-Mar-2025 12:29:58] /mygregor/www/en/products.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:29:58] /mygregor/www/en/ajax/users/bar.html?_=1742812199691 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
# [24-Mar-2025 12:29:58] /mygregor/www/en/ajax/products/prices.html?_=1742812199692 167.99.142.201
# [24-Mar-2025 12:29:58] /mygregor/www/en/ajax/basket/qty.html?_=1742812199691 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'

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                 LIMIT 1
# [24-Mar-2025 12:30:36] /mygregor/www/en/products/mygregor-drive-white.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:30:36] /mygregor/www/en/ajax/basket/qty.html?_=1742812237394 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                 LIMIT 1
# [24-Mar-2025 12:30:36] /mygregor/www/en/ajax/users/bar.html?_=1742812237394 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
# [24-Mar-2025 12:30:36] /mygregor/www/en/ajax/products/prices.html?_=1742812237395 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 ('4') AND
                `Language` = 'en'
# [24-Mar-2025 12:30:38] /mygregor/www/en/ajax/basket/add.html?_=1742812239009 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [24-Mar-2025 12:30:38] /mygregor/www/en/ajax/basket/qty.html?_=1742812239092 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                 LIMIT 1
# [24-Mar-2025 12:30:44] /mygregor/www/en/ajax/promocodes.html?_=1742812245894 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPromoCode') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:30:49] /mygregor/www/en/ajax/promocodes.html?_=1742812249960 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPromoCode') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:32:01] /mygregor/www/en/ajax/promocodes.html?_=1742812322349 167.99.142.201

set names utf8

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

UPDATE
                    `basket`
                SET
                    `LastUpdate` = NOW(),
                    `PromoCodeID` = 5
                WHERE
                    `ClientID`= 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPromoCode','LDiscount','LTotalPrice') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:32:08] /mygregor/www/en/order.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:32:08] /mygregor/www/en/ajax/users/bar.html?_=1742812329531 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
# [24-Mar-2025 12:34:01] /mygregor/www/en/ajax/orders/submit.html?_=1742812442162 167.99.142.201

set names utf8

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorFullName','ErrorPhone','ErrorEMail','ErrorCountry','ErrorProvince','ErrorTown','ErrorPostalCode','ErrorAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:34:14] /mygregor/www/en/ajax/orders/submit.html?_=1742812455260 167.99.142.201

set names utf8

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorDeliveryStreetName') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:34:25] /mygregor/www/en/ajax/orders/submit.html?_=1742812466225 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `Language` = 'en', `LastUpdate` = '2025-03-24 12:34:25', `BasketID` = '321', `UserID` = 16, `Data` = 'G5bDdEOTUky4UdwZMJIks0oGvZt_IbBRGNLI4G1M9T_qfgPDonhGxX57CENAv7RONgxZe_KLn9AhNX4qtfsusjvPWy7TZ_-dvkCkdc5ZFahg7YTnxqTLe2wMkUqDA_U1Gi5Nf7ZDAC5NMbpFPvwrSN247i9CvJW52dS8TzY0cMliTwVD6dnSi4_0vQJq9otNCkKK_Hc4F8MnL_ErhynSxxULbb2Y4NXkfIy12_gnkPlDg5i-mjx38mO7YHysLhfAQ51xfoBbekour-UHJ9tY8BgQrUMb9QDZj-kf9ZeZWrPLmVSasWgE8gBavoaNjQu8ifQkYy8iF-AdfmbEAhMwyzbE3lQxPa5kS9S_dSpTM1NyNnZZImNuhQWAeDWHVRVEGiuIQGgQOKpGNBUdEgYgpoJqvNcbHt_rre4glJaYU3Pr6rsfO9tX6konmo5ZCrsIZafm5um1yG-TmZgeQneaXj_KmWsUwtNzx_z5r6yUhaxotT-YtnUzwfVMQha5lV9dx5OKQ4bhgdWcXxyhwWHP4J41Ds9IavAdeq5j1gMjElWEbHzyX8ZmpjSU6780zM2OQebgkzZgSuMS-mEl9CHikiN3dhMe80hnlbKBxFkamsAPvJgoWbeHy5LFiye7ALvl_oddLuYLzF5vyFGSGW20haYg2bzVrlHbtPxdOk-UyAUSOhShgMQq3xt24qnptyRbN1qlreDj26qlfpfnEHtLVd0OVafBuCiCfdDEwDi8fGy6-riYvgYy7cH7Dn-_IT93_PRnJkACfHhF1rPWiMCvfuU348XsuGP6Pjlh0D3FbhygdA0i4bhUE4kRI0cHzv1nlxXRxc2JBsWKhcP0U7WQfPLznxNIAAe4voz7h2ibSi36-kCPlFNPu4QvdKzfoK-Z9fHa6DBLc89o-0SSES_VWwRaaG7zHCvmGD86HeT5HIgTkeJO8tt52DmPDmQf3VRCM0ziiEMmIQcarq9LTqL20g5AzpmScnWOcBKpLaUyLwoXB4bGWrmKwf_c2n1q273iuwd7l7syA8xs_XkR0hDzZTCsIcomoo313AIc0LDGuN6YH4DBH1JrnbsQhyFS3P2dV-j1GEryjdjK8Mr5DM48j4ptq2WfcAnoWlHCdiiXN0dv6wBLu7m3v7NV6py14CoM1lKicRZCp_Wh7H1vXSc7Tntw71qwtKDjEeznHPZFvBTOBHdSiPMbD7-aGMlGzKHH72O7yRBae7fWwGgIey_F7WP08OCtQSAt6sniuCs4AOAAZBlee6KoDNJfMGr7Sak8Uh8RZZ7g5iHq4IaD64uUuPvJRPrGwlMMhmmb8lFwh1f7019MAo89rtnUQerM8G_qBl920WbVi8gd9qI5cmNiVCnaLtCg2Sq_b-m50LO6fGfWHgjYyanhmR5PiKE-9-eMOz7NLSm2WYSmVoVElv9mvwODQQrRCLUrTZjXpQHtct9MsS9x-_R2w3TSU2m4NctRs87YHmxUuJCZpEqiLR01fhN1ZHrL6UjwvRLeBbmHD58SLVKne6AG9ktrQVsRGNshTVW9N04ygfa5zaiqOsmJcg3q9zrUguWTYPZj9CftdFko3-Ki46ir6L4HsIUwjC1Yd4xSx9z-EsD7RZjxmoFgIwNE9vnvWA_MDm5Ex9jyBLHlTctSzLxOerIP9hJDLYbK1c-ElpU-Gbz7X3CsDE9_HfnaMnVSiTkZeh7iJF2KJ_G1kn4K6Hpzxh0aLzWNYdwGs25fFs3b3PF_u37RIaTlRA', `SearchKey` = 'wrDDhcOGw6PCrsOZwrLDqMK0wqCwrDDhcK2wwrHCisOGw6fCpswrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwrHCn8OYwwrrCi8OUw57CscK0w5zDoMK2w4XDpMOCw4fDmMwqXCrMKyw6TCp8OZw', `PostDate` = '2025-03-24 12:34:25'

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'orders' AND `Action` = 'preview' AND `Visible` = 1 LIMIT 1
# [24-Mar-2025 12:34:25] /mygregor/www/en/order/preview.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-03-24 12:34:25', `Data` = 'L6IyJSfdTEt41SpvFx1280DPtWBLrszi5FJYZuBh-ygGoqQFQ5ozU3hK1KcNo-jHKPD7BjZV3Hy8OHs35JdcAl7DokU71RljBNWpyviMnnBOpQLVCr-cb1Xq5qH4wH4JofxR-olnvCH5bd1LLZL04nK4FzDOr2oIFBeDQAwH4vcLwq_AMD6EgDMzsqp-ZQfrIM5cn3CMwDg50E1rih-waYFkBqDdXjBZMf4y7UFSap2uX7O9dTx1Fi1REdvqP0RJHmsNzMWZW7LAVQuWkCKp3i7Wan7UBKgMOYkPpXxoV9M3yfuQ8zA2rpELOTN1G_ZE1Vw4L5WHBo5KrbansLiy8Lcoz__Levm7G5gW74Do5G_wW0Ta8CLERqidnDRLBsyeBYRSTUUrkadfYPrSsog9K0l2KeV6M-UCoTEnFsDm_MiRxcaWWou-KtPWuTFQeeBBfD5LefJbiZLCBblODTO1r6JbrX0Y5XaJel_6-YsbhnOvhhSNmfHy3aGYqUcX9SDzwrDRD9S99PDK0k5YYaOtunpOc6M6He_KPIZAkci8lFbfbw_2PckGC5H0YAQyEoSkkPmQO5cbiUzBsjFj5FTmgX9M9DAsgp_AdeCasrCHRC08mDvePXoe_qv7K5a_syiH05zVIle8pAZML79ppbT7vvPCWgsw3G9u36tIOlFZb-zlIyk9r8KWplgXKL1oCYfS769ttUSavsTIkcRGyhm9OMmQlwgeZHwbvaQNAwvQcMpvvBiZwvrSgDcg1U2l1yUk-gON5ryw2nJESBfduebdGGn2l8pgltlwK6Fl6TSqYT70AokXE_0gYvPpKRdgLUn4J2UD7uJ9FrRdPZMeJ3QBpVyhy-7CyetdyF4Rk60AQmGS4DWtQivDM5FKWid9whFTiHi5eNq-Hiha9aVMa-tDxzHcflIbU4UrRnqw2L4JJpF2KFPVYaGbLNJ_jJtOKcsLBv8JnoaKtp0rCpyyKC_06MI3Q4ysCtC207lnl05HI6LF3hn4IdwS3Y2JztDOcB43gek69AK_hxUp1Yxr8zGQr1uGqT9oIRpxni_346NkVib6qf2XiFFegB21dYfAJ7VkGaNU_Yoi1joxlOSQLMwuKpmT9gJggjammx7wyqTzNkP2Phz6sVV4y1x12c6QgbyH-PAz8yBCiLMx-mqygFsDbVy61JmdJ36rg2k5MY2d3CdpETktzb8h3m81z_8bE_vPv_SIAAE0Y2EMU-cFBJ2Ei2GtBNxXH5n4SVFEunaIASVhfJJeUADc-4Uu9zhMwpSFv2tM3v2Q2p9wvp4DPr7bOIB5qyrPAJoZsSahidGT28VSTT2qKCKKfduuaP_XyJjAgCxGsDY9bXKazZq9Jday8cWlA-JoizICyeawihlY9W7121Wh4hwXN0Qeg1yTUKRhx6FVSer0p5u-0PoVa-brxqunu_RPWOQmyAQeLHEgLDiE_plioT1txLPMLXfQKVIVHljDAveUGuu2MsyADfi4AFZJvKXi_9vPNRhJonbk3osikoElwGHJS2GcUkep3fM0uU7mmNt9rHGyuFMDP2egJ8xFadHQ0gjWPhvsHR2khniy6axW2NLKkpRimetF2wu87VGtxj7UltX3eCss5rvW4f67EOft9Tj-4Gv3S-mbTKFocGD7U_K75rHyInY8hBhejKP8Ni5GS_ImxLAgRd3ye4B8vvRw7qEaS8Ck2uSSKduiBFFMVS4nvZlpOdTQtnkbSZ5aWs_MNQlLNw84FuAPIjbWqFnUm5pYM6ZMr7IUyqazUb8XZaFDvyt_vOkmREUa14dBqHc0h2P2t1kJCw8KVQ' WHERE `ID` = '174'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:34:25] /mygregor/www/en/ajax/users/bar.html?_=1742812466483 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
# [24-Mar-2025 12:35:11] /mygregor/www/en/ajax/orders/confirm.html?_=1742812512258 167.99.142.201

set names utf8

SELECT
                    `orders`.`ID`,
                    `orders`.`Data`
                FROM
                    `orders`
                    INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
                WHERE
                    `basket`.`ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa' AND
                    `orders`.`Status` < 2
                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 ('ErrorName','ErrorPhone','ErrorEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-03-24 12:35:11', `Data` = 'p_ubU1wH6FDAnMGt-hbCnr0YyTq-pH9lvqopOiZwZTHhSDA9QdIKkRFAU8MR0C9gdF1NUPHg475k9TfmElnqK616V6-ulYA4fn4RTS_lKMkHpunv7vtAgZuAe1XXlGGw2YU1UsBECYRLrub2MlBiIOv3-HK0bX1I104-MtE_Q2FGZKWmjWfrgKCEHp5UvDKVUZR9skMKHO3kSaKMrLdLJebqGsr7iLw4IsWCNt7GmqzA54XRTzDy7mIBPi4M9CxSjA0YoFj9_YvKg2nwAB5MxVxX5MCB227pNFBd72q-cfb4t51L4J5hrerGkgpYaPy3VCimT3tkK3-uGtgh-PTdcOcKSP7I_JZNEErC6gVQSVh-2tGRuMLq0RYbhk4DQ8BzPsHEVHfnagKhB6976zFWOgUy6YfT_9AR6qWlDCGX5xEdXSX6a80mhGuA8dFrS37YMxkT7yxyc4dokGqCHOWTfj9228h8b7xkerOAvLG_cW60bdoAoJ1HzNcX54FBWAaJ__mGPSEX-xhwqSeDQEQ6aWlQPEesL9Q2FNa_o9CljrLTFTBoFen1fddXN2ZtzE9FczTk1qst3yR1iOF0GLk8xgEIgERCEMQPBAbL7DXX84ZQnTxtifJpwXCodCve9168giNHSqZsD_pw-i16aLRYUAmtw73h4rqIeiYEl1JV1BlRzb53hSy-tIcv7fx8hxUzPGGpxUlgmKCj75AzXraP9PkNLiEEbVwS96ZSypmgv6UEE_LbfA6cFyH3Ym1TrXuO2FKqsGVN5-sHbfVm_INoPfNK4ylVXpe6qbvGaf75RAspJCtB5bmf3Ki5oNJ6vKJnMQexeqJWTEO008070RibOXRHnJkc3h6-OniHALqHv1OStJ5GguB-1oBTsGpepSm0ftdEHLCDZbW9GvKHJcH7V2scgl8xCBRsc0FoBFduqAFOzjG31xhf1CPmo_J_HId4qKBsk3veYfItMFQXSjbWjqMHEC_Kdqli8uGxyOgTSb0MPIW73QPyVbN6JSStYUyyeRFEkjQZbQ-Y46EmODSNUKtX8A7Jpl56CII6XCKWM_wXkSgs0GgocJbFxVNiF-vM7P4WmfZ6mPksuQzddRHvprFDAE5tadZGPgArF9uvNXgAlswX0A6WFi09HmkPA7PWgzFyEzrijmPPWE8PXrQpq7iimYOpbBjVmKdOOUy6rjf7V12PyeuuZv1U8VSt4v8JIr9pw2v4AfI5MQRzXr4ZNIQ_u8mpY_59La2EEw4KAVOeJNd4Pg_IPMEgWB-QJAA13cJiunZCKqbbw3ZO0ThF3RRIk-s7asCpdZj35eeMw7gkmbFVeiF6fPUS3PvgBb-8Ix6KHzUxKasCmFSmFFJGTiH2DKdvK-kHCpJkAbYklCIpgRw0zHGl_ad_z-mbqbDX4JeIljqdFK9G1I4lgVLco0B1onPTLq2FVtQzHqvpfJlw9zHiNsv1-GovKrXdHLUPikaYIR-K92l7GhRAvmiHhYsPaD5BQfYRoHg-r9svjeSlAXyFZ9SQW19eTddJRBCid_ZbrXoESGpjnKUeO79R6JFpiqaoEWq3tufTr1ofm6LimSR5SHx5IBRNno_QoWIqDkTniio2nBUe0SSPIld7OKguixmQ40UFln2wXMN_wevPStDkdBudm5Kt9m73G8pvqsi3hjv97vY_sUjUs1iPVsfMSA761ZPCEPyu06fnQlCngRXUVqOag5OkneSKURVv1xAPc_LRuGGNpfju9ye2T9tRp2GKm1cEZ18M5AYDkiYmaWUUslGyTK1c-GwVnjlevOxFz2UCLCAoYS7ax2nXyKgnV0hT3hKgBTvOtIigndZuEqEjyFSlY5BZLgmL3fUktfcin9hpx5-sOnAK761OGXm-pgD737ikPt-JIcxqqC82f9mu9vJs7QxKrarQFFJuIelbCsfur2yDWTmQ6w_bA8W-i1Cj3KtQAEb3ho_WKb1gU-SpdyAgs6oHpNUM-rheAMTvfxOyGr2cCGYOqy2dKZm_ll7uyliBtWnsdtnPrszgwOb1yhZd34Fm2EQU6Q1VMR5HMLgP0weepxg0muE4dD3KGZa2zVg0mkUMaqKDyrI', `UserID` = 16, `TotalPrice` = 107.5, `Status` = 1 WHERE `ID` = '174'

SELECT * FROM `receipts` LIMIT 1

SHOW COLUMNS FROM `receipts`

INSERT INTO `receipts` SET `Language` = 'en', `PostDate` = '2025-03-24 12:35:11', `LastUpdate` = '2025-03-24 12:35:11', `OrderID` = '174', `PaymentData` = 'z6HdUuuRuz8-HnDogl5iwbvnOgGmQXSfTWSrHqanEJcghyiGd0XqvN9W28MYqmUBdygla4ZazPnJlH_z-BSKkp85zLaVL4-S2er0E1xrVv5ffQzwyQMNkhSEtTnP4rQC3Fj-MHsePOMIvJDNERxbaCVf1nFJZZlbORS0o-g6iIRjKSxTVIKUwb8cFBPAtHtG8i54ONLoUmPwpir0gpp9QUlkOLob7Ij7ulio1UtqAc35sgGlJens7pXnD5s_TrUzzhz5Pc1d56Dd6PKDBwYYzLIqtF1KxeR1zsb0Bb-OjSsGcJPM5m5DtooOBFsW6XgjqmX2MvU8jSIbHjSroLFO5GFfOVM7t7Q9fAqqziSu2eTlkuTpCwEfzDXh5IkYM5vMp-YTbvcFNTd5kdUQ2HdutmGb9Ln6SGlMWBv8L6vZTAuA4zKDRPucz5zYz-b4LKIyh16pZVMlzzj1P5WAS6LFL7ZiD0ZJq1vRcB40E3dQ8yLqmKlywtKlhOjjmYvM9DISpu6Dx4A_O0ODq9hSCtAArIZ8UrfX90ji8IgFM4lGBT6yMnWt3QPU-0NrLfNl_T07t_bTU-EOcbyaifxWZUNc-bIYQwDga1nSplDaKgBn_Z4yRXXwAxDxLO-5E57qLnNnf5NeOrhcsorjfY-KvU5jBvCW_o29yg0W81g2F7OBE2294FZ9qfcxGFtSuHS5SX1Y295TUN_s9J7mTmJlm36dpctjJHkTranscwtFvgw5FTs', `Amount` = 107.5, `Currency` = 'EUR'

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-03-24 12:35:11', `Data` = 'mRbTvY8bLISYTuDDnVFsa6UMfToIJI0pU35fE7i-_Ac9YH1UmBMFG20sMNDU16oKbo7PlPse_h11Btmc9y-4TsXJxuRaYOhFRVQD22ZXzq1v9TYVFg_kikZgg1pojVKuO5IH0JTQGuknPnnjTr_v1o-i8S-HFV_9ur_jwMUrY_KFKCDDyBfraox6Vo1FADhVtKBI0iGmfP9whAMx3JtRq8t2vpwaGHYQy2xn4qttPC1jDHNkE2cBt-PwCkmzuYWLxfpDZLkot2_Di5bOLRZu50Zmd-g84xs7vUX-bftJZn6mHMEk6w0yHZJnGpayJPMb0A7J6ISz6zbchMNv0eDt7qHhXmLasbechPasbm0wlY2DeI_I48lhmU-3BhFok6N7I9Ll5PzUsRfZ5S_zuAtziqxfFIrnvTsK1iQLbJ9Qqsb_JNcZEpg3MdOYOXnALU5-1XWr316yMFzEq02tOvDrrnjsA9humCEHg4BtyGF_wlLsYxPqXTCd3lILQ5z_Kh84Iv3hItaT6dt9UL5CecaVjc6NEhbj0NdwAR9N0EZ0KhPSHbnyOzuCIKQqrph6SMDJp0HhNRpugQZ4nfjgI5rzLe05hpdVRR9HFmwuukJ46BheCsNPbIqWS3dpLhZLt-R4e5jzJD6HWWRMeQSttdYouoHyYLYLSK5dfPbJhAju7R2rFv0my11wqYJGGPOvZy5XKhYEV02oTU406sEZ0kE54LSR9P5AwiNJy8DGjIcMaVYA19isDeoXcnxsuyBV4unSJw_LeG22AUfU1P4SbzrfOcZfdc4Au7nGiWtSvFHNi0Si7wlOvMel-whZ-5QuU8MzezFVmnNt9fwsRv0zQVXU-XYBgccEXlU-BsXLvGBbEw47AmHegYn-SzOMFY4uFhkOtf_zLBFxxrlzCL6UsVPp23zTZxADv7yIXds312FIBvftn01GFOxO3PKmjW5hQfDNf_K6OI4noYZrngVXpIxnfKHqghLgoRez3dd-s1Ja6WX5CKuDJFcPmT1hviiLSsHuCXD7WzI3iKXJZ73MctKquxFunqZMTAEsALu6UrNdsRtbwZNmTvGhFrvG_2ihZqC_tiNML3h-rCFuP24aDlqZ2KoaOuEfXwTJeuow1dsTRes7bgnF14gYPWrtYuHGms966UPan6nuD5oFEtIH15U2S5nOro3gHfAqBBq-NmP7vjKTeD0zHGS8RUDrXlwk63VVA-DQLbd8_wXUCxrZQOUdJf90lsFKx9FiRdIl_YBexMKJiTx10TLHlZM2ivsel74mnHL9woHpywycof6ree21S9cCkiCxPSfvCZQD481PU5SpRxWNRvpe44z7oWTUnLnNJzohueo-E9g2gFqCSXKr3dvVMDpp5cKhZFV6FZM-jCXnffBlIqJo12Q5fQNzAGrmnSD7y2FaVnRCKLBBdOHCTkbo92DxgUchT5J1riR3blzyDc5BKRaGKvvW4rGA2DPQCfLfSdhK5K_p2oztxMdM1PdaG8STYqa0yZ8tQIoE-wmIiZ0rK2kCt3Y2lq3xekdC0wnrZ8m7dg3hcHcdHCeL0CINhT0L8KDfeOLcVgk95QIKeshQPZ3XB5krwEXWrXx_0taeucvAe6xNHpQmTdKSUw6K-ndY2TrySWsT7h6vQW6IkLajJQMwZq6KBA4LFhmUbdokwPDRm5bI6DnoFfSMCwAM83lNsjTL3nGHvxpdCoYpMDljbk6Ki89sJi1pUbcA3u11TxesTDC2jmZV81iAEmDfTmlym8VBbV8ZEhSiHTBZih46hYOLSETDvwgIK2XXpoSH-CBamHzQTxYRoh7bGdvylnsvHUiwpqkuphO_dK0tIsu4IGD8DT0w7P4tHpsIrAcO5UAo03ganAriwflYjFIagVyYpSGd6A4iL0imFfEEGqP82ovPUoPLUsh2bwJr5WMwagAMTPwiZ8aZbQ5NXTjO7awZaUX91HCZEMP7huLoLYvOIMCvGEcGuncqj6eNeaxSst4_zKDEga8MmMQDTwFYb4BBi1dW9IBt863gCxqB2HH7woYLK0awjLeqaAEUOi4OUoKx7dTp-6t5nq0EQL5qhxBZ0Y75gUfR83838Xo' WHERE `ID` = '174'

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

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

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

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

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

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

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

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

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

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

SELECT * FROM `invoices` LIMIT 1

SHOW COLUMNS FROM `invoices`

INSERT INTO `invoices` SET `Language` = 'en', `OrderID` = '174', `PostDate` = '2025-03-24 12:35:11', `LastUpdate` = '2025-03-24 12:35:11', `Data` = 'E9TYyf7yf439LdSlNOpMCriBWxF2074JeC6RC26MBKo3ptulnqJQplpyqw7kQWIyfEz4ieiENsE2WBuE_FCXHa2KPOpo9IUrH0RdDvz5BqYTNQhqDF1bNmZ8SlIES8PeMBdjfT6t1tyjHjuD3WpKZ5c5mj62PCOE4Oxn5lO-AKFJVWoYElIXLGWdR-Hhtrpj5nf7O9UNyMNRbaA68XcdKpYdaf--QY7PKmHpwjYGtQUwdnKnaiH_3vjwmeHtfzhypD5Uas9FDFcz3xJqA_LxvPext8nA6bp_ZX8fbYRBD2iR7yPcX2kbBI4G-a_gapjC09K7toCqawKfH1QIb_oA5PP7WVqmR1UwMVcV1XKSKtYOWsxHJTo_g90ZMZUKANuC13DeL3kJNOJfWYK-BQhKIFugr0uqnKL75YEjmrKi_F9JI8O2N_1NHiGs66WExj8dn7iAjMu54fnJZvGYhTPKKWBzD0duRWgRzw1TgOvyUOAmffWpEEk_-nZy6XNCSYk3hn0RGq5tKKhPbdyz6ccdrEMTswp8GLqOfcuNqQ29LL4GWAl9Eorz2znIFY1GtJ3ktqSf8bO0FK-oKjUKlIWxEibamuVsjtJ7bJK26Sj3AZWNZ6Uqur97IvoJPq8kDfsu7il4Kk8HyFAgv6WfhdMVB9T2LbJsmbSLT2EGL3cRk4KNcLvfCrdEPLah7Z1nd2O7BPXCHs4RHkbCkzD5Xe-QmaP1mCV-kfbYHG__JqKd6NQJYvN7sGnSfenuOYbenzqbGjQlzYEkpoKEQ8JSiR2iCb9qhZGzS_3z2fdLahIlczu6YBLGOs-Cu5aaVRaIKE31', `SearchKey` = 'wrvCn8OGw6jCscwrvCn8OGw6jCscwrnCsMOcw5zCsMOZw4LDosK1wovCwrHCoMK6w57CscOZwwrrCoMK6w6TCr8ODwwrDCisKpw5nCp8wqXCrMKyw6TCp8OZw'

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

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

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

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

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

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

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

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'orders' AND `Action` = 'success' AND `Language` = 'en' AND `Visible` = 1 LIMIT 1
# [24-Mar-2025 12:35:15] /mygregor/www/en/orders/success/174.html 167.99.142.201

set names utf8

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

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

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

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

SELECT
                `Data`
            FROM
                `orders`
            WHERE
                `ID` = 174
            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
# [24-Mar-2025 12:35:15] /mygregor/www/en/ajax/users/bar.html?_=1742812516449 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
# [24-Mar-2025 12:57:23] /mygregor/www/en/ajax/users/bar.html?_=1742813844425 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
# [24-Mar-2025 12:57:23] /mygregor/www/en/ajax/basket/qty.html?_=1742813844426 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                 LIMIT 1
# [24-Mar-2025 12:57:30] /mygregor/www/en/products.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:57:30] /mygregor/www/en/ajax/users/bar.html?_=1742813851196 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
# [24-Mar-2025 12:57:30] /mygregor/www/en/ajax/basket/qty.html?_=1742813851196 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                 LIMIT 1
# [24-Mar-2025 12:57:30] /mygregor/www/en/ajax/products/prices.html?_=1742813851197 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'
# [24-Mar-2025 12:57:32] /mygregor/www/en/products/mygregor-drive-anthracite.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:57:33] /mygregor/www/en/ajax/products/prices.html?_=1742813853896 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 ('5') AND
                `Language` = 'en'
# [24-Mar-2025 12:57:33] /mygregor/www/en/ajax/users/bar.html?_=1742813853894 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
# [24-Mar-2025 12:57:33] /mygregor/www/en/ajax/basket/qty.html?_=1742813853894 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                 LIMIT 1
# [24-Mar-2025 12:57:34] /mygregor/www/en/ajax/basket/add.html?_=1742813855035 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [24-Mar-2025 12:57:34] /mygregor/www/en/ajax/basket/qty.html?_=1742813855106 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                 LIMIT 1
# [24-Mar-2025 12:57:36] /mygregor/www/en/order.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:57:36] /mygregor/www/en/ajax/users/bar.html?_=1742813857123 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
# [24-Mar-2025 12:58:06] /mygregor/www/en/ajax/orders/submit.html?_=1742813887352 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `Language` = 'en', `LastUpdate` = '2025-03-24 12:58:06', `BasketID` = '322', `UserID` = 16, `Data` = 'CmrMWxMzYfWZTXpI66cyboJSHL7UkfviQeh3bHH5lfrsMlt3ECdFWB86dxxcyywhlTt9YTw1ZWmoMm_Hr5amGgl9D6EuVBcKgGTmSSymKxZvS6kgw5KJpFBob8enfWfEQ6dFL6KCAwvKpZhi42wFTZi9VM8HlgK0YXnMHP8p4lDtxT0EyeWPOXaEsGhTd55efpR_SkfpPrMeaT6XFEO310lakZfIIIngrg_ZhWoSJwRLGGga2f9IusmipaR7aLppCElHuXc1v2y2JRN4oxrBKgIYqo2z1NT_V3fOnTUtqrqWLv9UCV_EHsgMq0aiTwyZUYQ6yWScGZEJnTwEI9iAvl-gJ_vq-_R7urX0N7vXCGmVGk9Vjggu4KU2QA0_A3xDGtxFt66p3HkrWcfb-YbgJsKliFC44-DKsWUlxfcfCuuZobXH8U1On7yY8TJY70_wMAsB60dtb34dlBI3IHXGpJ161jSYcw9rKL_3eET9FX_uH1lo_LXE7QD40l1K76Pu5jvCyuyKzi_9rlA5KdKIRdioVyNN6ApqgbRp3VXHTb5HOWWzgqrmOwWyLuTBy-tqLb49S1ALoc3z4RbejKh3yIz51ccxHECYqmbr2RkQrEvuGPFQ1ujm84JNRluBpK2WyJQKIaC4lKlLld2-pGN6l5IScky4vXplqnvCDaat-i_uwfzYo91CmMpXqS-j_zP1PoUwvJFHsJePffeQLn7UyL4aFez8lvksfSX8iRhe9upJq_QGJxxRzSD-b0S1XUfxqq_L7ZlXFVVj95aKJCiwEbQw3GGxHILWVr_bHRYUxh0KJfHudVLzQUqgpPLNiaU0w5WOH7LE9-UvkkvWD1iO0-VLkonP8WQt7fITpoOSU7OZVnfFo_R-W9w6pSPV_vAGJsvlyUi3BKhVGUPIqU96pxxTjNV5opEDVf3ZfpVhoRwZ_wPk4Q7ocM9ioAWK5BlL9gekc3rzM7ZzRqHXeQ-SdA6AIAeC1FltvJSgsWJCeP5ejEof5EZgG5IEtie_1-QBPALeOaBc9AjhAJz11ku0azgZ0Sbkg7oFmbWx-3NfFo-LBWPw4rqVgn4C3k5Dt34dMGdw66VeuozTWlKP-B9UNxl1ytL2QR1QDTMi6A7BP3iamPERCO4b1fOQnMsjHhpVobPLM6Wc2lNucF4cLihxzyA_qVDOeaM3ziMI7wQPQkXLAz69lAOXcKO-SRXhygZQ9ItSaheRZMUpS3LjgCDn5A6ztRc_uqI0DVPDLq-efaXTsZSDH19rzqcTtntc0j7q4sSN1aP7WR6Hxtf6t52215v23uyGOKd9DhQ0WfiAQTN41_ifNVVzt24JUQrh21hkAzGP_hax60RjYZM0l5xHqLWL1HX66HCnK1a39JLzUW58NuLqH67gBGo6UFVSqqQfYmsOtzhnXAyHYHrI15yBTG1LyGoAIEWalbRnEFjzlw_ql8SluycglKt4n8lCBuh8lHxBoANzMWIBy8iMG62d9K2OAwEzbZ8I_gHXNfvjnMKrLueroYIQgUmHqEVndVul', `SearchKey` = 'wrvCn8OGw6jCscwrvCn8OGw6jCscwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwrHCn8OYwwrrCi8OUw57CscK0w5zDoMK2w4XDpMOCw4fDmM', `PostDate` = '2025-03-24 12:58:06'

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'orders' AND `Action` = 'preview' AND `Visible` = 1 LIMIT 1
# [24-Mar-2025 12:58:06] /mygregor/www/en/order/preview.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-03-24 12:58:06', `Data` = 'frUF_WU9iUYol0mttKCkCM0ZasQYrhfxoequxHCjLQXwjK6h-A1SfXMIdeRpgRfb7u9KF2SjwmqbfM8LDGPjVsUs44vxQCOd85ZbLs60tlIvbeXflzeP7SgLoUl64cweH1RDhJtrs89I-ubv9VaqqpPeAgD6y8F4sDfxSC6Klhp65zPugYV0RafYL7NBD0jf1bXD4WXuZ0L1sYHA6E1dEO4NDrQnZt-MZeqJdENqI5ffHwdnt_9IXc56HGRkfBZBN4hLvBU0AQQqnIxaVV_uQDzPW9ifLVh9tUC69VU0x_aEi-FYzMAxHV-2D2QBXREZechdhjEVIhgoXMWlNXyJ7KOYam46OPk2_aHYTNkpGgsfZyXFpSuFpMBSMeGw-VOnnx_7ANzBjABayaQTcz6tyj-EdFwAqQQdhhtAedwaVOCWTbI0Akx7y1wi5GkiM_mXCIuskuDeYn9_i6JBvOjhcm7RY2l7WMknysVapPYYEsWz5ZXTXZ8UMVUYtGSUNP4iBpTrolUf--8B8PwFUzJNbI4Bz9dfYSTRnYj8N-tx-19e67uYA73PSu9kQNFFKYQHSnEtsyuOzZr18oH4o7-ImuJzxSGLX0td36y6pYeQi0TBZY7nN0cFpBFMwLfXsQK4X6TEdSuOVn5l0zUqs6lb1k6HCF5lXPQqXhkyQRx_u16Lz3wSvk7T2IsZjPFSL16A5zLT2x2JToxN4fvskyvDBamIan7OvE6CgaMCkhF_t_ffxYi4j0m2kDvKcoPf5HSiGqhCjoPZM5z6LHvUGnHD9duVAkZr52W337n1qAs3_JfTMoNTZi8uv2N1bWxnu_Y9l2JovM4mFUEId20ne1r17VLWqg5t-23Sy7bhrvyFXG1TCwcbajBrNuq_J_E3uFVx1af7gXJNH2eYRDRa8HTrr3564mnWgrFVhjg06OVlO3CdIPgMfuO_E_U2ipSz8wrH1XuZgXDTEQetL9QIOJdQGDwJIjminYe2pQoBLOS13SHlnEisLlJoiThUCm716yD7CNaBu4D98ecshUNj8RvrAzEiu9pXO5OhvxgDCoEn9iaaF9I7u60xH3iMc9oROxzA_8QQ71v-UzdC16gf0UiWkTJLYECPy4tNtKNzVID_wUUJLCcEb5jL9PpHtokRp5KY5pRguVosDwzg40B58Iv_qENtbTgRLMJo5WKUHP3AyevTv676Yu7vDZn15akkVswrUB-sIrRWQ_VEaGCKQ2xDSUON3qF336IaHJoaVQKSTr1gQXW_1Lw7XlcNCmlqc3WGX06mvTuNU-MVtMXcnCNn4QS63x3-9zJNihfml4gg1PvTZs_Nf2PvS_dhKS9QUsh_Pva1_LSrGGRGXzlYRUUr8o1427_Oocq7-c95_G5_19WLeWXo-SnJfmJM-f4gYqLTdgs81o31DyOiyY_3flY83ke3eyfgk9fs7q-IgMMOXp10anDtLCDoaQ5CvmRIbkQ9IGyB0qKTyAofDYpICaqxYnhYgY-y5TXuMSsf1UPzf5oSTFMyrc8cQmblyF94amp-NafgwmjY70WQwy-NhzshDaoAl2BtJGyG4dlF_BCi0agZ5fQbv0l2WbPeXtxZYQjL' WHERE `ID` = '175'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:58:06] /mygregor/www/en/ajax/users/bar.html?_=1742813887611 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
# [24-Mar-2025 13:09:03] /mygregor/www/en/order/preview.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-03-24 13:09:03', `Data` = 'CXgCLJz0zvm6vV8VabVh7L3-ODNh7Mpks67N4nucn-SEDcf1RlDx8mtsG_mNUeeuVtZJAqI034Wpzk3EKeu45LD2U1pfQCuZgKgQ1uqP6ujO0aFfsu_2Z0RE0daObUhtDZ7-qfnnAaq9TKxj5GCGwy2z1YyhqRtn0-0NWtcruBybBm8uCzDGyj-3-y9kw6AufA_3G1P1NdcQ5E3YhESpWqlg5zyB6vN0RRsbsQ_5snHtxPfaK9S-XfKsRulQiOHhHt8A1Tukqr-H5lGlSucE2ev25miJta1-_3nw45yebHee55Cn-CW7H9ZSBRjz4Alq9Klymd9WgGnuIL2gPjZxOg353eYd1OnW5JvmehTHpYBRWVX1MX5gkktN2GU0j_gr2-7NNAtTpK38AcaDqYoIpIX4SfPEbElYWILsQEcelLS_euDLdhTDV-csNfqPSW4xQagR5PmUID_MIz6cO9J5vFv_AKK3ZKeGjqsG9gv47ClaE787IDOboyWFP1322fHWcLYdDDbp4yZF1eZ7Ck6x5mcvamMOfP4ggf68JtY-c2RSOzmqFZfqnNKij9fHXlBAlYn4N3WJCWvdqfOCPvwdIMWX4n_LQccnCe4PDya-tAnhaT0z1RrvEJ0q9OcTQ7-uQjD7YrfKKu4Rbi4W6Sasb9qwxpAf47Md-hJyIU3W1l6cgXfQd1pQRkoYYKd_lm47gqV5CmDZLmbzt4SbNnK4WWYy0auo107HvE3-NkPiBjcKDUPAUGgbMu5F3H8lWs7PshIV5yHY2_qurdBqsZVH4QA4M-wdBdxp5CBreUTN8MGe6VcV1AZpk1tdWkipDFi80IsdrhfPd5SCJyVZWkOuPRnmXuOrz476hMPyNa5DtFNeS02o3jJRNyxcTdLa49k0YuJW0VrhmDFyx17wm545h4geL2qSXrEy2bT0XMpJvmgbTaevjNajUqWODQUZQGkVnU007nZme4Auy9cDV8s5kNPgdC0bP3iEZGJ7YYKSAaqiZ1MGUls-5N1IV4uypoIDlnJS-wBClzit4VBl3BKklhnsqyxC_KFgIdMSpJaQwFIqy-hV7f8WSpePX4Z7JvRuGaVwHH_6xPXY51raZK0XlygHfkd9fHib0dZVVfZolb7e9COS-lmzopJZkMNG8_nPIjZCjXRcyGIg32aUS70XG6cMABUXBGvUyoumMxX85Gg2Kdud8w8mJ1awMQcNrVJKde87V3qLbwscwdOa93oLYM0m5hpEoP03T_kDw-Ne0XvGpUqONw9zKVVf9rGWvmOwjKq458YnvDcqtdw6bHZFRlvKFW_w7pnwa8_nG3PS0KpiE6gKkA3UxHDTUbwJF37wIF2ltPnw-Oo8FNVljN4Lq8MaEn3heeKtpUn3EgZ28eQM2vsbVJqnpbA3OMzi_XehO8ATNCosKWE75rmM5TRa_8BIswKFzMBBy70RnEciSbDJ-4y9emauAMyY6LQock_yJws_EvW9M-zn7oqjgwFMmzzMlQXpdiZRoTrK9Gv0zn3I5UTb3nxlmCVHx9Jsv5v5tBI13JMRL5f6WENvLp1eDaMiU1j8y_BtZC5aI8Z7nauFd7naWh5qiBFnbK66m5Mm' WHERE `ID` = '175'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 13:09:03] /mygregor/www/en/ajax/users/bar.html?_=1742814544213 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
# [24-Mar-2025 13:09:59] /mygregor/www/en/order.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','SupportPhone','
        ') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 13:09:59] /mygregor/www/en/ajax/users/bar.html?_=1742814600365 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
# [24-Mar-2025 13:21:14] /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
# [24-Mar-2025 13:21:14] /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
# [24-Mar-2025 13:21:15] /mygregor/www/bg/ajax/users/bar.html?_=1742815276161 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` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 13:21:15] /mygregor/www/bg/ajax/products/prices.html?_=1742815276163 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'
# [24-Mar-2025 13:21:17] /mygregor/www/mgVh5s90Z/bg/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` = 'bg'
                
            ORDER BY  `ID` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1
# [24-Mar-2025 13:21:20] /mygregor/www/mgVh5s90Z/bg/invoices/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 `invoices` WHERE 1 ORDER BY `ID` DESC LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM `invoices` WHERE 1 ORDER BY `ID` DESC) AS CountTable
# [24-Mar-2025 13:21:29] /mygregor/www/mgVh5s90Z/bg/ajax/invoices/form/clone/1000000019.html?pid=1000000019&_=1742815290780 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
                `invoices`
            WHERE
                `ID` = 1000000019
            LIMIT 1

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