# [22-Nov-2022 05:24:48] /www/root/bg/ajax/orders/submit.html?_=1669087488366 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` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT `ID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                /* Promo */
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `PromoPrice` > 0 AND
                `PromoPrice` < `Price` AS `Promo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'bg'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'bg'
            WHERE
                `ID` IN ('2657856656') AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

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

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

SELECT
                `econt_streets`.`ID`
            FROM
                `econt_streets`
                INNER JOIN `econt_towns` ON `econt_streets`.`TownID` = `econt_towns`.`ID`
            WHERE
                `econt_streets`.`Name` like '%Атанас%Дуков%' AND
                `econt_towns`.`Name` = 'София'
            LIMIT 1

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `Language` = 'bg', `LastUpdate` = '2022-11-22 05:24:48', `BasketID` = '3', `UserID` = 0, `Data` = '[encoded data, 4182 characters]', `SearchKey` = '', `PostDate` = '2022-11-22 05:24:48'

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `Module` = 'orders' AND `Action` = 'preview' AND `Visible` = 1 LIMIT 1
# [22-Nov-2022 05:26:02] /www/root/bg/потребител/login.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'потребител' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

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

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

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [22-Nov-2022 05:26:02] /www/root/bg/ajax/users/form/login.html?_=1669087562898 167.99.142.201
# [22-Nov-2022 05:26:02] /www/root/bg/ajax/users/bar.html?_=1669087562900 167.99.142.201

set names utf8

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNewAccount','LCreateAccount') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Nov-2022 05:26:19] /www/root/bg/ajax/users/login.html?_=1669087579011 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'i2Bb0H26G8eA1rlm8NBD31y58d53covQ6M4tRn5n4KLj5i2k9jwrkj21Df3y33Gi'
            WHERE
                `UserKey` LIKE 'wr_DisOZw6HDgcObwqzDocK0w5DDk8OMw4bDm8OCw5jCt8KDwrTDkg%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Nov-2022 05:26:20] /www/root/bg/ajax/users/login.html?_=1669087580207 167.99.142.201

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS Access
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = 'i2Bb0H26G8eA1rlm8NBD31y58d53covQ6M4tRn5n4KLj5i2k9jwrkj21Df3y33Gi'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserPass') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Nov-2022 05:26:23] /www/root/bg/потребител/регистрация.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'потребител' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                        `Action`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `Module` = 'users' AND `URLLabel` = 'регистрация' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'users' AND
	    		`URLLabel` = 'регистрация' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [22-Nov-2022 05:26:23] /www/root/bg/ajax/users/form/register.html?_=1669087583376 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') 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
# [22-Nov-2022 05:26:23] /www/root/bg/ajax/users/bar.html?_=1669087583377 167.99.142.201

set names utf8

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

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

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

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

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

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [22-Nov-2022 05:26:26] /www/root/bg/ajax/users/register.html?_=1669087586280 167.99.142.201

set names utf8

SELECT `ID` FROM `users` WHERE `UserKey` LIKE 'wr_DisOZw6HDgcObwqzDocK0w5DDk8OMw4bDm8OCw5jCt8KDwrTDkg%' LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPassword','ErrorPasswords','ErrorFullName','ErrorPhone','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Nov-2022 05:26:30] /www/root/bg/ajax/users/register.html?_=1669087590394 167.99.142.201

set names utf8

INSERT INTO `users`(
                `PostDate`,
                `LastUpdate`,
                `UserKey`,
                `Data`,
                `SearchKey`,
                `SortName`,
                `SortEMail`)
            VALUES (
                NOW(),
                NOW(),
                'wr_DisOZw6HDgcObwqzDocK0w5DDk8OMw4bDm8OCw5jCt8KDwrTDkge222674ddb1a3b75fa1828d8db3343d81',
                '4tcpW2V4ceX8kqy_CoD6z3t_ukGqctkWTtLN9TIslp8G8pcAvjq4v-8yaBr4fY2XooOQIy4jT8EgrmH4G0HbFb2xqFjTZ37V4kymeue5RM6I8Bh9abNG2T1Aq7wh9bO5LML8WPcFErXV29S-rmDaK8TrDBAbOudm89rLLNmeG7XUgoliy150koQlvWhiWYKl',
                'wrjCoMK6w57CsMKfwr7DwrHCn8K2wqDCpsOEwrbDrsK0worDwrjCoMK6w57CsMKfwr7DwrnCr8K2wqLCp8KfwrbDnMK2wpDlMOKwr7D',
                1040114,
                1040114
            );

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS Access
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'wr_DisOZw6HDgcObwqzDocK0w5DDk8OMw4bDm8OCw5jCt8KDwrTDkge222674ddb1a3b75fa1828d8db3343d81%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [22-Nov-2022 05:26:30] /www/root/bg/потребител.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'потребител' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `Data`
            FROM
                `users`
            WHERE
                `ID` = 22
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEMail','LName','LPhone','LPassword','LEdit','LResetPassword','LSaveChanges') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `ID`,
                `PostDate`,
                `TotalPrice`,
                `Status`
            FROM
                `orders`
            WHERE
                `UserID` = 22 AND
                `Status` > 2

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [22-Nov-2022 05:26:30] /www/root/bg/ajax/users/bar.html?_=1669087590864 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [22-Nov-2022 05:26:33] /www/root/bg/поръчка.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'поръчка' 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` = 'поръчка' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                /* Promo */
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `PromoPrice` > 0 AND
                `PromoPrice` < `Price` AS `Promo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'bg'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'bg'
            WHERE
                `ID` IN ('2657856656') AND
                `Visible` = 1

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` = 0
            LIMIT 1

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

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

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

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

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

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-22 05:26:34', `Data` = '[encoded data, 4224 characters]' WHERE `ID` = '2'

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
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [22-Nov-2022 05:26:34] /www/root/bg/ajax/users/bar.html?_=1669087594355 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [22-Nov-2022 05:26:39] /www/root/bg/ajax/orders/submit.html?_=1669087599526 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` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                /* Promo */
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `PromoPrice` > 0 AND
                `PromoPrice` < `Price` AS `Promo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'bg'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'bg'
            WHERE
                `ID` IN ('2657856656') AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

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

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

SELECT
                `econt_streets`.`ID`
            FROM
                `econt_streets`
                INNER JOIN `econt_towns` ON `econt_streets`.`TownID` = `econt_towns`.`ID`
            WHERE
                `econt_streets`.`Name` like '%Атанас%Дуков%' AND
                `econt_towns`.`Name` = 'София'
            LIMIT 1

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

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `Language` = 'bg', `LastUpdate` = '2022-11-22 05:26:39', `BasketID` = '3', `UserID` = 22, `Data` = '[encoded data, 4182 characters]', `SearchKey` = '' WHERE `ID` = '2'

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `Module` = 'orders' AND `Action` = 'preview' AND `Visible` = 1 LIMIT 1
# [22-Nov-2022 05:26:39] /www/root/bg/поръчка/преглед.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'поръчка' 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` = 'преглед' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'orders' AND
	    		`URLLabel` = 'преглед' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                /* Promo */
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `PromoPrice` > 0 AND
                `PromoPrice` < `Price` AS `Promo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'bg'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'bg'
            WHERE
                `ID` IN ('2657856656') AND
                `Visible` = 1

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` = 0
            LIMIT 1

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

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

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

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

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

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

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

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-22 05:26:39', `Data` = '[encoded data, 4224 characters]' WHERE `ID` = '2'

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

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

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

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

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

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [22-Nov-2022 05:26:39] /www/root/bg/ajax/users/bar.html?_=1669087599911 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [22-Nov-2022 05:26:44] /www/root/bg/ajax/orders/confirm.html?_=1669087604235 167.99.142.201

set names utf8

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-22 05:26:44', `Data` = '[encoded data, 4523 characters]', `TotalPrice` = 118.8, `Status` = 1 WHERE `ID` = '2'
# [22-Nov-2022 05:26:44] /www/root/bg/payments/success/2.html 167.99.142.201

set names utf8

SELECT
                `basket`.`ClientID`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `orders`.`ID` = 2 AND
                `orders`.`Status` = 1
            LIMIT 1

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

SELECT `Data` FROM `basket` WHERE `ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                COALESCE(`product_texts`.`Title`, `product_sets`.`Title`) AS `Title`,
                `Gallery`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                /* Promo */
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `PromoPrice` > 0 AND
                `PromoPrice` < `Price` AS `Promo`
            FROM
                `products`
                LEFT JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'bg'
                LEFT JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'bg'
            WHERE
                `ID` IN ('2657856656') AND
                `Visible` = 1

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' AND
                `orders`.`Status` = 0
            LIMIT 1

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

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

DELETE FROM `basket` WHERE `ClientID`= '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb' LIMIT 1

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'orders' AND `Action` = 'success' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1
# [22-Nov-2022 05:26:50] /www/root/bg/поръчка/успешно.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'поръчка' 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` = 'успешно' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'orders' AND
	    		`URLLabel` = 'успешно' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [22-Nov-2022 05:26:50] /www/root/bg/ajax/users/bar.html?_=1669087610398 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [22-Nov-2022 05:26:55] /www/root/bg/потребител.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'потребител' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `Data`
            FROM
                `users`
            WHERE
                `ID` = 22
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEMail','LName','LPhone','LPassword','LEdit','LResetPassword','LSaveChanges') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `ID`,
                `PostDate`,
                `TotalPrice`,
                `Status`
            FROM
                `orders`
            WHERE
                `UserID` = 22 AND
                `Status` > 2

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [22-Nov-2022 05:26:55] /www/root/bg/ajax/users/bar.html?_=1669087615590 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [22-Nov-2022 05:26:55] /www/root/bg/ajax/basket/qty.html?_=1669087615592 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [22-Nov-2022 05:27:30] /www/root/bg/ajax/orders/2.html?_=1669087650843 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 2 AND
                `UserID` = 22 AND
                `Status` > 2
            LIMIT 1

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Nov-2022 05:27:36] /www/root/bg/ajax/orders/2.html?_=1669087656530 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 2 AND
                `UserID` = 22 AND
                `Status` > 2
            LIMIT 1

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Nov-2022 05:28:49] /www/root/bg/ajax/orders/2.html?_=1669087729617 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 2 AND
                `UserID` = 22 AND
                `Status` > 2
            LIMIT 1

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Nov-2022 05:29:14] /www/root/bg/потребител.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'потребител' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `Data`
            FROM
                `users`
            WHERE
                `ID` = 22
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEMail','LName','LPhone','LPassword','LEdit','LResetPassword','LSaveChanges') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `ID`,
                `PostDate`,
                `TotalPrice`,
                `Status`
            FROM
                `orders`
            WHERE
                `UserID` = 22 AND
                `Status` > 2

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [22-Nov-2022 05:29:14] /www/root/bg/ajax/users/bar.html?_=1669087754679 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [22-Nov-2022 05:29:14] /www/root/bg/ajax/basket/qty.html?_=1669087754679 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [22-Nov-2022 05:29:15] /www/root/bg/ajax/orders/2.html?_=1669087755779 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 2 AND
                `UserID` = 22 AND
                `Status` > 2
            LIMIT 1

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [22-Nov-2022 05:41:02] /www/root/bg/потребител.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'потребител' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `Data`
            FROM
                `users`
            WHERE
                `ID` = 22
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEMail','LName','LPhone','LPassword','LEdit','LResetPassword','LSaveChanges') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `ID`,
                `PostDate`,
                `TotalPrice`,
                `Status`
            FROM
                `orders`
            WHERE
                `UserID` = 22 AND
                `Status` > 2

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [22-Nov-2022 05:41:02] /www/root/bg/ajax/basket/qty.html?_=1669088462900 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = '49c40b9dffab5f973783e6f696f9edf2d3d296f5b97bea6dfc1ffd9bc2a4f9bb'
                 LIMIT 1
# [22-Nov-2022 05:41:02] /www/root/bg/ajax/users/bar.html?_=1669088462899 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 22 AND
                                CRC32(`UserKey`) = 3141244906 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

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

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