# [31-Mar-2025 12:30:01] /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
# [31-Mar-2025 12:30:01] /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
# [31-Mar-2025 12:30:01] /mygregor/www/bg/ajax/users/bar.html?_=1743413401893 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
# [31-Mar-2025 12:30:01] /mygregor/www/bg/ajax/basket/qty.html?_=1743413401894 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = 'ce8db3154da66ac75857bb4c5f6c8e03796a36e97f5a299b6bfcce7ad0eb89aa'
                 LIMIT 1
# [31-Mar-2025 12:30:01] /mygregor/www/bg/ajax/products/prices.html?_=1743413401895 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'
# [31-Mar-2025 12:30:05] /mygregor/www/bg/order.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' 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` = 'bg' 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` = 'bg' 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` = 'bg'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'bg'
            WHERE
                `ID` IN ('5') AND
                `InStock` = 1 AND
                `Visible` = 1

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

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

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

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

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

SELECT DISTINCT `PostCode`, `City` FROM `econt_offices` ORDER BY `City`ASC

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSend') AND
                `Language` = 'bg'
             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` = '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','SupportPhone','
        ') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [31-Mar-2025 12:30:05] /mygregor/www/bg/ajax/users/bar.html?_=1743413405740 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
# [31-Mar-2025 12:30:10] /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
# [31-Mar-2025 12:30:10] /mygregor/www/en/ajax/users/bar.html?_=1743413410966 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
# [31-Mar-2025 12:30:11] /mygregor/www/en/ajax/products/prices.html?_=1743413410968 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'
# [31-Mar-2025 12:30:12] /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
# [31-Mar-2025 12:30:12] /mygregor/www/en/ajax/users/bar.html?_=1743413412369 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
# [31-Mar-2025 12:30:18] /mygregor/www/en/ajax/orders/submit.html?_=1743413418236 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
                `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`

UPDATE `orders` SET `Language` = 'en', `LastUpdate` = '2025-03-31 12:30:18', `BasketID` = '322', `UserID` = 16, `Data` = 'fySgATkkHCglDdxbxwcLCHnSrv5Ohha9NtUOEclpRWZFXyMAkz5OVTxihHT3Ioi9_YIqbpJ0ZMSiaqrxulSQnkljnJ48C_-OWCJYrD8L4yu7KdOLiUICAPupSHbb-5ncx9oHksRFs_2TYAOGUGdkyWcv6RpnC34wkw0zxP-B6r0QVss58BBloD3du8h_YP5_xz1m_0BsWe72nf67WP02SkA63uFE2s_0KShTOpRiG809G9BLiVIEHy_U9vB8scX3j5soaKY1un5v4637bCN-KJgvnp4Ce8rhKvz1e-c7ygknRPNFwDa6xK64jA7jbORFJWkFKR1Ub2Dm7vw_es6wGv9M1kpHAcWzE6FOuS8Y17zKoYaGqHUym6qvD6tYvqK51hqRmoqWkfP6qTAfylXMRqorkqNWiWr537HfebvYeIdIZGCT4bHpbQ-UMXZpcxydvX3ckNExzTfJNh2kMopEF2tKnWlaVezD5de8jVZtKIPOXnbLWTK6TiGtk56F6yiWkQwJCY2At-HD4RNxNihNUkQNtcXKl83w3Ca7mEAI94OsQJJdcUsTFwwwWZLePSQK77P3kRKc4BrWvArUsDYvHOk-n2-yT1NhznSQPUXcFkKAjI2cfoiDdgggH3F_h_HSUS5XWkB9_zpiVSToYd1EGU5TzmKMEQECypY1lWC9QvBVNzjc_d-aIocgATj9bJIbaBGzpAwUvp1v_BjcFyKuOI38E1rky6tXqyc0QPSHs43CdjkocZWg18J6Zf1J4Qx9sSvjHAl8JlRMRb1iN1Ugnm654TZshj8vaPx5KRCm8UVgZ-f0STnGk99lHGHcco6BECx1Jd8mDr9co0O2dBYjQGuvdkArstEZWYJC7Lfy91i5xbOKPCKUk1-uCrTB-ladtfO5HqbQPCYI6GrUn5wJv4ZSITG2RBk6h0r_pFnsiFW55VFiEhSaZ0Qi6XN3zOWlmvWBdQtth2cUWxmkNjbf6MvD3pXE1a09JVqXW8lbo21NPrcz-4I0R8GN7yskwlanKOXmwAkTfkOuPLuIdgjWUj73wiHZCMxDVQx9QoYNU4jomTvIfwrn8L29p3Tc2n-662jQpSHDmHxUHbxe_ENvl-o0TAG01tSbSmSqCjoIzSLEP_Ogmwajg3-N7WAOHGqLDu6-rECV5nO86B3MWtdilJMNs7XdXHkDwF0dQdvqEglKZ3nFxnaRROoWmPa3AzS18Ex_vHMybvYAtL9totR8OPFaJDuIM0fKE8NsFAq0CBsfBTFKik-uR-D4hNWtsUz4HUROaAKvY38aWEsMF8mV0PlwBhMWUSQx6byRYnHI7CDaObKeGQmK6v1239npdYFz0QazhABe2n9IzvTa1gJDTf9FxYxFpMC6N3gTGAiWL5s21MqZRNjliHPwfZWXxeaa0_v2RI0LWgHIcM-nrWEo0PKKr4o1As3A0ErIbKp_W2a-k2zfwx6BFn-bz0ExHv59zuzYB-hC83gxOFAGu0Z0sXYlOBv8x0vueVcrvnKjMmyJihmjULxizb5w7D5HjEGA', `SearchKey` = 'wrvCn8OGw6jCscwrvCn8OGw6jCscwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwrHCn8OYwwrrCi8OUw57CscK0w5zDoMK2w4XDpMOCw4fDmM' WHERE `ID` = '175'

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
# [31-Mar-2025 12:30:18] /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-31 12:30:18', `Data` = 'nG-oYzpwvFxA2RIJLxTLSqBxvEtSrV2NKkmkNDnWa3YBDf9zWbHs77oBUB-7mGYuDHXvwHKdpqvpJLL_Q4ztlPagqFLjt5FTTVR7i_Ai6llTmKKMFQDS719JcscyWONz0vrn-4KU486XA7BiiabcKBhY1TfEoJkooofMNwCPPsVqAaHMn6lmn9lP6Rm50Av27JWljrn07aSBRH_yioZu7yidVV8DjzM7PeEN7DtPDTUyj53VJfnsfvFiel-22emTS6EqLzJq1Gh3OGAnX7KYwTD655ra7jfkcKDLEIx6V0Oe-ZMm8EZsgcO548Cc7-DPLPw8h8P2Y6P3hKiPjgXEcVexvgxbZmST5tyEGxlmT28wJdENAjoK8HpkVRbm8rbswOMztk9f2Q6kt4j5jmX4Y6nyRlmeiteB_wWZlsoo9N0xzb9ZLrzgVwnxVJOhkM06x6IUP8zkN7FciKkVz35uMMtxKqAp9phELTKBGpSm-rpEwXDA8vOXb3GBtdvppUnMtvLoDLNZA0I6LXM6tC-MWjv2c2bsDgDm81iS6ZfoqxTDCREtxV2RimMcIyRgiBEb46cBrJFGev3MFWwK2LhlvJW9EU1BujgaYBgvUMWQH7siZUowybsm5HmenGwCbijtqesNqnsD3QShiFxtOzZWq6PtQuvoopZFgAblPeqovYu98YVuP-vzjpDF8f8zhhufHJQWCsYrbEt8HhTWmctJ9QKDtP-3fEC6IByzrLpYMoDwIUrChuIB4Ma2ruosNx2-QJIInr-DdgXtkOm2Qbkmwx5CbBXTdSR2tD41SuS_icVlJW6KMS_t6Vb-hVBGtGMqYIFtlz3Cp0R2UI5I04fnw2cb3PfxBomPcRc5t1JE_1i5smvQ8HNT1Ix-0-VfFdIP2Ye9ipZLicPqknvVEjXZKg9b8MhVG7SZqhEabCeBLEHU6Bccp2vKisM-s46Zse0FNoUGvCvLR3UnqqCc0OSMBczfMyyWJjGfjxWM-C09s-_5BBWRrxMeX1cnfYkcXdl_0wecMPvelkklOi0LTakmz8EjPkVEPYPfFORbUXBRTDPAk1ZBN50QyStr-rADO8-xRGTwdmBQ_c1PMe081NbaDINLmKSoDbFpsHhZmV-T5uttrOY4fZPM9YkpJ7KCw2yD9DuoBLb4TOUJPzFkevXMuoCQP1eBMWdDziYBwTrqJ2ZRC0YNVyHiDlwAYcvzLSME3D387Xx5mFcdqIpEwCKwCR0Y5z1je3SvZIecI-UX6D9ZkoimivZBq49qN7tvQdg1Cd1i0ErHOZIq3IS8DXLksHqB4xbXQ5MPneHqlu2jMaXC7tGg3S9SXGEWghIDRoAaj04qQ6WHGa4Y6i3aGN4zt4DcB24FsdHGoBXM6EG3-lMGqjUQ8uTb2KvohFwMWoDDTMHOi7MUrNEWro8coZ3ZAMVQlfWcVZcb6shpQPHXF9bvV6hQa9JzIktjAKTFUh-B0l5E3mPtvQja9SRsyKtV7PQsOpYClDXY8IHja2iv6y9U5gPC_-iNEKxIq3n8Mis4BtAoNHYDwJmxbyoaR2ynHDYJn5Gh6QYDq9iD7b-PdBr8Woo-OJ2lMiNn88Txh1H-' 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
# [31-Mar-2025 12:30:18] /mygregor/www/en/ajax/users/bar.html?_=1743413418488 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
# [31-Mar-2025 12:30:20] /mygregor/www/en/ajax/users/bar.html?_=1743413420331 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
# [31-Mar-2025 12:30:22] /mygregor/www/en/ajax/orders/submit.html?_=1743413422732 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorFullName','ErrorPhone','ErrorEMail','ErrorCountry','ErrorProvince','ErrorTown','ErrorPostalCode','ErrorAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [31-Mar-2025 12:30:26] /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` = 'a2086af837687a7371ae250e7bff1433db9467adddb6003a622ca4fbc050fadd' AND
                    `orders`.`Status` < 2
                LIMIT 1

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'en' AND
                `Module` = 'orders' AND
                `Action` = 'empty'
         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
# [31-Mar-2025 12:31:38] /mygregor/www/en/ajax/orders/submit.html?_=1743413497992 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorFullName','ErrorPhone','ErrorEMail','ErrorCountry','ErrorProvince','ErrorTown','ErrorPostalCode','ErrorAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [31-Mar-2025 12:33:58] /mygregor/www/en/ajax/orders/submit.html?_=1743413638120 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorFullName','ErrorPhone','ErrorEMail','ErrorCountry','ErrorProvince','ErrorTown','ErrorPostalCode','ErrorAddress') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [31-Mar-2025 12:35:32] /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
# [31-Mar-2025 12:35:32] /mygregor/www/en/ajax/users/bar.html?_=1743413732570 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
# [31-Mar-2025 12:35:33] /mygregor/www/en/ajax/orders/submit.html?_=1743413733803 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
                `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`

UPDATE `orders` SET `Language` = 'en', `LastUpdate` = '2025-03-31 12:35:33', `BasketID` = '322', `UserID` = 16, `Data` = '0fpVcEAD4vwypSkj1pnNVJGoMJLiiJNAeHnLeLzTZIkWohGvxEomqiUNrvMC2E_eSDzuT05xTe5Yc2pYQQ3Gb-T0FNiV3z5ErZ8rSZD_mqCDFwENH9tKU9KPIGNGSVPBiplC8BAmGQ2-5z3_ZOrbeq4qXgf07srA2VxIZdlbHM0obbT5KFaCeO9hif6TPLuU7KT29bY0XTx7FzAwQhWnPl10q-SJPX-aSLuKh6E0Xj93NHkSQKJ2cSv6Bu0RLmWmt2Fnno9Ssatk9mWJOtLPRM122Ul9h1yHcWCSzYccmWZVTPtvkpFyHI2jhExXXsN_n3eQOnqU_hCiziojXA_kdLGi8tqXklOWtURYbuehXwL_X9TQ8w-KPis2rn-Ufyi7zZgGrJAEAxueRoGbHqQCVHMyFJHsnLU9hDb8u2r3zquC16IBZN0BOGrVBz1Sj9-KreoU3IC2QKfVU_eQ6XISb-dpeKCDzsz2_tTNq4-SLnp-k2pX3iKLAb6EkahrKlTIsc0ybA7EhDMMCXSjFuBiicFgQosXxk9zKfALJMwRK2IeWK693n0veAVqASDvZHjVkVBTymTAxQdOyAzxgQS7HqjazDQ7o5Uz8I92MLICX9yuvnhqlaHZfEIfFvzmUq8BfzKn88CdlwAuXGnmRYXcyS0VM3P9gVtJGC5kFZaXtcUlluJkvLhjxUtQtCKA0lBZ5w-WUmO3y7ktOCun-2bNk8LA9WNRsh22dMVB11CcDFA5SGQjti_LKEwj68wrnkTqK4RNYsUr2hfRRaLoJqDtMpCb29Hqr5UDzI68u_AoL0lUMBuyktj4SB4CQIdFDKeD6cYPLDNf-BBaOQLonA9n4CE1llYRFARgWPxNG9sFKCQ9eMYqj8hrxyfX_M61adc7P0fAxphx_HK6pFf7BT103djan3YXDuHV2iyFM-QgdXUidyWz673Xj1s69nbPkyogpjg8Dm20qUViHkxb1rc8IW2457uNJwLdAqIz1uWkJIbXvucVed6o_G_rMJ9v9DZ_nEhiaNaXo128-P1i5ohnQ0s_t1lzPlfUFGY4fxT4WY9dwEwp7k_zsNTfzcpeCdDnXfw9gZcITWtkQ844SbgHJa1S1zAffhnxqZ2QMmyTuMF7hmELX1e4rjjCh9a4AK98oVBsrT_cpXiFFCjZbPrGlRCADeuqYsCOLx3RzQ609vWnoQbcB_pyUfF8zeE7TNkaQ9ZcR3t0SMQQT7HMpw7dp0itBFy5TxjUVMPUAlMXCfx97Ad1_94Z7gLS9SRecLmnU3RXG0mLSUg8Qk4F7gyIqzaNQpVFUyK4BCMxAJtSYKxRrX_Ywz8-RMxKJk6lkLiRhmbQoZOLbjZzEu_3iou58uZy15cKnNCGUv8Bk5rBjvoSFVfYLq4dFFA-5jTWkj5HXL8PeaQY-STRuNIG6wDbBAMSoFq4_leQrLByfFUkITx_VhIpLoqq2CtCdoUbXyT5cCn0DFQ6tY33KRZIjYBuOobcrInhDMrkY7_r-uLs4x_v4AImQmy_ifCguNn7wibm', `SearchKey` = 'wrvCn8OGw6jCscwrvCn8OGw6jCscwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwrHCn8OYwwrrCi8OUw57CscK0w5zDoMK2w4XDpMOCw4fDmM' WHERE `ID` = '175'

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
# [31-Mar-2025 12:35:33] /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-31 12:35:33', `Data` = 'NWJPQWkwSOV2j6ciYaaESkb04_SMGEmb6D9aBkRTHoFQB0zoNhm3-QXLeNbKTvsiuhPjktQhIA0rE-XNhjSTBLLkRAysLhLndnbdYbx2RxEoPB2BX5wKMQFogA_fvHYpUTuT4-oIzf2aiLOLY6TpHCl2Ga_GYxGYssVc0BiV1ZauRxKzK4CHiZ8XxhBFVAvQ0yMsZjvkYeg67EVCQRlNx_tCrG3nJtQd5x8urL32JEj6XmBW1MqPrw96xPAr0Wtl4W8KZXKi_qGdWrIVN7Hr1dKBAR0RyCWXScHqoZ3KSLtQCXOFCmaV1pKgpR8OfZH2M_ME2rKPAH-mVTUMEJn0VhyPyOFbf57YhR2renlOxUjunLtWzyR1mQvl7Wc_2wkkuF4JSIsAxkQZrVeENlhG-ClYWFdY95WxolDWSLkuHPbrdpykjWDS3bF5Ewiv2vt6913kyb4jt5bjo1vC2JVPfVUXlO1LydQhFfGZadikZUjRyaPzAJtOmyAzRJbM7zQ96X8CcL8tN8swQpGn6uIHE7-FEXOf9D8xKo1X4GSOKljYycTDOHOOwydFAF5tBby2xd3GghBWtzu1ykt0Qnp03fQFYelpZwySlFQneeUTjjrYhhEzMh1fIvQgp_PvG22DHxe4F44WtPBCqwft6vkEzs1ezNebRPbnczlyuGh3Ej-Rt7-d_kcu3IAqlQzskB5sIYAgCn3izxMV_NbYKQRQpf_-IRw-bUbuYwQ9xcr9pyLT62O9EXGXLNGVZIDhqxvKjgz9tQlkpCColEcPOMY2xypyxCfA5NaoGrjd7zzIJnxWpkGWObQTwPfdm8LtYgU9vO3DsHcxqSt5d2hu9QQzMGOFT9x5GSCudwcFIGDdn3iKpkjcn6dVr-GW5hSMHb7bv73xvCHXi8PwwRqWMRZ3f_J-_pOTN6wnJLIM09USnzMaM2b4sNOqxzSlgl0JIuLRTiHwcOL0_TeLsnPTV-p2EuePaSPjLQcD3Z-Rod2uEcYrpjeDCYoBW90ARHOCggljI445iygUl-VNtntYvOU9rgL2xHcgEgAMDsQu85TbfIbparANvk8EqyjFfgigHA24ZOHrGrkFhALPvQZzsgOd9qJzPBb6iC9lAoIwNN9UddyAbzxJLDaFkS-WJ-w6aRBOmEYiwivzBXy0dShlsEM06UkCEIn1UH3VuraJCkzVe_P4vpcQBZTprS_uH8LGmDTtTH99ynUw7YxHWq6XL4qj3DBrluwNGST4ifCHd42Gd7n8OVAtO-JeaVRr5p1st3Vw091QbFseKjlUx50YOdWvRNPYVFs4PUvptkURONMdUyj24DRsLOA3VvjHjpKqF8KACAqYXHrXh_2w6F_SVdAJs-pLDP1wAqE1yRfIcB6SET_n3oBdD7u8QQ5_qsIGLJaHQZe_rxs7mQrP7afUnn8bewKEor_ELFDXJAPv509LkHtF1IQMwHq5I-UwAjmEf8rOI3uiBVSktKfp4DdQkiX2CtV9WZdsw3IGOjn0vJCgPbo2dSeX8BdblwK-E2gwNOfaqSwSRhEpTdYMVFqjSQj6xlMYBpfziOCz8JRMi4RAP0pyyjXk9mu1xe-e0mtHwrir' 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
# [31-Mar-2025 12:35:34] /mygregor/www/en/ajax/users/bar.html?_=1743413734094 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
