# [13-Nov-2022 05:20:46] /www/root/ 167.99.142.201

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `SubTitle`,
                `URL`,
                `ButtonLabel`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

UPDATE `slides` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('2','1') AND `Language` = 'bg'

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

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

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != ''
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'events'
         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 2

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

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

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'contacts'
         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
# [13-Nov-2022 05:20:46] /www/root/bg/ajax/contacts/form.html?_=1668309648131 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorMessage','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Nov-2022 05:20:46] /www/root/bg/ajax/users/bar.html?_=1668309648135 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

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') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Nov-2022 05:21:02] /www/root/ 167.99.142.201

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `SubTitle`,
                `URL`,
                `ButtonLabel`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

UPDATE `slides` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('2','1') AND `Language` = 'bg'

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

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

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != ''
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'events'
         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 2

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

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

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'contacts'
         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
# [13-Nov-2022 05:21:02] /www/root/bg/ajax/contacts/form.html?_=1668309664056 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorMessage','ErrorIAgree') 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') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Nov-2022 05:21:02] /www/root/bg/ajax/users/bar.html?_=1668309664057 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
# [13-Nov-2022 05:21:24] /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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('2657856655','2657856656') AND
                `Visible` = 1

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('LFreeDeliveryInfo') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LTotal') 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
                        `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
# [13-Nov-2022 05:21:25] /www/root/bg/ajax/users/bar.html?_=1668309686555 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
# [13-Nov-2022 05:21:42] /www/root/ 167.99.142.201

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `SubTitle`,
                `URL`,
                `ButtonLabel`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

UPDATE `slides` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('2','1') AND `Language` = 'bg'

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

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

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != ''
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'events'
         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 2

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

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

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'contacts'
         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
# [13-Nov-2022 05:21:42] /www/root/bg/ajax/contacts/form.html?_=1668309704060 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorMessage','ErrorIAgree') 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') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Nov-2022 05:21:42] /www/root/bg/ajax/users/bar.html?_=1668309704061 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
# [13-Nov-2022 06:05:25] /www/root/sitemap.xml 167.99.142.201
# [13-Nov-2022 06:05:49] /www/root/sitemap.xml 167.99.142.201
# [13-Nov-2022 06:08:04] /www/root/sitemap.xml 167.99.142.201

set names utf8

SELECT
                MAX(`LastUpdate`)
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                MAX(`LastUpdate`)
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'en' AND
                `Visible` = 1
            LIMIT 1
# [13-Nov-2022 06:09:53] /www/root/sitemap.xml 167.99.142.201

set names utf8

SELECT
                MAX(`LastUpdate`)
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                MAX(`LastUpdate`)
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'en' AND
                `Visible` = 1
            LIMIT 1
# [13-Nov-2022 06:13:03] /www/root/sitemap.xml 167.99.142.201

set names utf8

SELECT
                MAX(`LastUpdate`)
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                MAX(`LastUpdate`)
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'en' AND
                `Visible` = 1
            LIMIT 1
# [13-Nov-2022 06:13:21] /www/root/sitemap.xml 167.99.142.201

set names utf8

SELECT
                MAX(`LastUpdate`)
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                MAX(`LastUpdate`)
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'en' AND
                `Visible` = 1
            LIMIT 1
# [13-Nov-2022 06:16:19] /www/root/sitemap.xml 167.99.142.201

set names utf8

SELECT
                MAX(`LastUpdate`)
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                MAX(`LastUpdate`)
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'en' AND
                `Visible` = 1
            LIMIT 1
# [13-Nov-2022 06:16:24] /www/root/bg/sitemap.xml 167.99.142.201
# [13-Nov-2022 06:16:53] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel` AS `URL`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:17:35] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:17:37] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:18:20] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:18:45] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:21:05] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:21:11] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:29:22] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:31:00] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:32:03] /www/root/ 167.99.142.201

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `SubTitle`,
                `URL`,
                `ButtonLabel`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

UPDATE `slides` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('2','1') AND `Language` = 'bg'

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

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

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != ''
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'events'
         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 2

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

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

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'contacts'
         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
# [13-Nov-2022 06:32:03] /www/root/bg/ajax/contacts/form.html?_=1668313924959 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorMessage','ErrorIAgree') 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') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Nov-2022 06:32:03] /www/root/bg/ajax/users/bar.html?_=1668313924959 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
# [13-Nov-2022 06:32:57] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:33:30] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:34:31] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [13-Nov-2022 06:38:38] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `URLLabel`,
                `LastUpdate`
            FROM
                `products`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
# [13-Nov-2022 06:39:33] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `URLLabel`,
                `LastUpdate`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
# [13-Nov-2022 06:40:02] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `URLLabel`,
                `LastUpdate`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
# [13-Nov-2022 06:41:21] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `URLLabel`,
                `LastUpdate`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
# [13-Nov-2022 06:41:55] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `URLLabel`,
                `LastUpdate`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
# [13-Nov-2022 06:46:06] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

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

SELECT
                `URLLabel`,
                `LastUpdate`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
# [13-Nov-2022 06:49:43] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

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

SELECT
                `URLLabel`,
                `LastUpdate`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
# [13-Nov-2022 06:49:50] /www/root/bg/sitemap.xml 167.99.142.201

set names utf8

SELECT
                `Module`,
                `URLLabel`,
                `LastUpdate`
            FROM
                `pages`
            WHERE
                `NoIndex` = 0 AND
                (
                    (`MenuLabel` != '' AND `MenuLabel` IS NOT NULL) OR
                    (`FooterLabel` != '' AND `FooterLabel` IS NOT NULL)
                ) AND
                (`ExternalURL` = '' OR `ExternalURL` IS NULL) AND
                `URLLabel` != 'index' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

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

SELECT
                `URLLabel`,
                `LastUpdate`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
# [13-Nov-2022 07:17:31] /www/root/ 167.99.142.201

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `SubTitle`,
                `URL`,
                `ButtonLabel`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

UPDATE `slides` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('2','1') AND `Language` = 'bg'

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

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

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != ''
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'events'
         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 2

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

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

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'contacts'
         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
# [13-Nov-2022 07:17:32] /www/root/bg/ajax/contacts/form.html?_=1668316652320 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorMessage','ErrorIAgree') 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') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Nov-2022 07:17:32] /www/root/bg/ajax/users/bar.html?_=1668316652321 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
# [13-Nov-2022 07:17:32] /www/root/bg/ajax/basket/qty.html?_=1668316652322 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827'
                 LIMIT 1
# [13-Nov-2022 07:17:40] /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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('2657856655','2657856656') AND
                `Visible` = 1

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('LFreeDeliveryInfo') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LTotal') 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
                        `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
# [13-Nov-2022 07:17:41] /www/root/bg/ajax/users/bar.html?_=1668316661255 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
# [13-Nov-2022 07:17:46] /www/root/bg/ajax/orders/submit.html?_=1668316666652 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('2657856655','2657856656') AND
                `Visible` = 1

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

UPDATE `orders` SET `Language` = 'bg', `LastUpdate` = '2022-11-13 07:17:46', `BasketID` = '99', `UserID` = 0, `Data` = '[encoded data, 10603 characters]', `SearchKey` = 'wrjCr8Kw6TCmsOAwwofCscOIw4DCtMK6wqCqMKDwrHCtMKsw4zDn8KdwwofCpMOEwrDgMK6wqDrcKDwqTCsMKsw4zCucKhwrHChMKhw4TCvMOWwwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwofCpMOqwrDgMK6wqCqsKDwrHCwofCpMOAw4DCtMK6wqDq8KDwrHDgMKrw5rCucKdwwofCpMOIwrDg8OgwqCocKDwqTCwqTCrMOTwpCmsOAw5PCqcKhw4LDgc' WHERE `ID` = '36'

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
# [13-Nov-2022 07:17:46] /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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('2657856655','2657856656') AND
                `Visible` = 1

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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
                        `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

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
# [13-Nov-2022 07:17:47] /www/root/bg/ajax/users/bar.html?_=1668316667039 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
# [13-Nov-2022 07:17:47] /www/root/bg/ajax/delivery/price.html?_=1668316667043 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LDelivery','LDeliveryError','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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-13 07:17:47', `Data` = '[encoded data, 10646 characters]' WHERE `ID` = '36'
# [13-Nov-2022 07:17:52] /www/root/bg/ajax/orders/send.html?_=1668316672876 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' AND
                `orders`.`Status` = 0
            LIMIT 1

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

SELECT `Data` FROM `basket` WHERE `ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('2657856655','2657856656') AND
                `Visible` = 1

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('LOrderSubject') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 4
                WHERE
                    `ID` = 36
                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
# [13-Nov-2022 07:18:52] /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
# [13-Nov-2022 07:18:53] /www/root/bg/ajax/users/bar.html?_=1668316733053 167.99.142.201
# [13-Nov-2022 07:18:53] /www/root/bg/ajax/users/form/login.html?_=1668316733051 167.99.142.201

set names utf8

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

set names utf8

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

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
# [13-Nov-2022 07:18:58] /www/root/bg/ajax/users/login.html?_=1668316737958 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'pPEPkOy31TEdZuxSadS9vpGcLHl3AC627mrL7IbK9pyGO6unz097JOxT4BhVlKwh'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' 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
# [13-Nov-2022 07:18:59] /www/root/bg/ajax/users/login.html?_=1668316738989 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` = 'pPEPkOy31TEdZuxSadS9vpGcLHl3AC627mrL7IbK9pyGO6unz097JOxT4BhVlKwh'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [13-Nov-2022 07:18:59] /www/root/mgR8sVa0D/bg/pages/list.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1
# [13-Nov-2022 07:19:03] /www/root/mgR8sVa0D/bg/users/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `PostDate`,
                `LastUpdate`,
                `Data`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            
            ORDER BY
                `users`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `PostDate`,
                `LastUpdate`,
                `Data`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            
            ORDER BY
                `users`.`LastUpdate` DESC
        ) AS CountTable
# [13-Nov-2022 07:19:10] /www/root/mgR8sVa0D/bg/ajax/users/logout.html?_=1668316750256 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [13-Nov-2022 07:19:10] /www/root/ 167.99.142.201

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `SubTitle`,
                `URL`,
                `ButtonLabel`
            FROM
                `slides`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

UPDATE `slides` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('2','1') AND `Language` = 'bg'

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

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

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != ''
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'events'
         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 2

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

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

SELECT
                `ID`,
                `Language`,
                `Title`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 1 AND
	    		`Module` = 'contacts'
         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
# [13-Nov-2022 07:19:10] /www/root/bg/ajax/contacts/form.html?_=1668316750612 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorMessage','ErrorIAgree') 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') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Nov-2022 07:19:10] /www/root/bg/ajax/users/bar.html?_=1668316750613 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
# [13-Nov-2022 07:19:12] /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
# [13-Nov-2022 07:19:13] /www/root/bg/ajax/users/form/login.html?_=1668316753136 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLoginEMail','LLogin') 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 `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
# [13-Nov-2022 07:19:13] /www/root/bg/ajax/users/bar.html?_=1668316753138 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
# [13-Nov-2022 07:19:19] /www/root/bg/ajax/users/login.html?_=1668316759697 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '6727jZdSNWZ3ZINDPXbJJENB3r44x0w53F7oFkZ4pr3s8jdTYd1pxNiENjW1Al0V'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6J-wqzDmcOVw4vCv8OewrvDlcOTw4PDksKCwrfCuQ%' 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
# [13-Nov-2022 07:19:24] /www/root/bg/ajax/users/login.html?_=1668316764245 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` = '6727jZdSNWZ3ZINDPXbJJENB3r44x0w53F7oFkZ4pr3s8jdTYd1pxNiENjW1Al0V'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserPass') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Nov-2022 07:19: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
                        `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
# [13-Nov-2022 07:19:30] /www/root/bg/ajax/users/form/forgot.html?_=1668316770742 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('InfoResetPassword','LEMail','LResetPassword') 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
# [13-Nov-2022 07:19:30] /www/root/bg/ajax/users/bar.html?_=1668316770743 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
# [13-Nov-2022 07:19:37] /www/root/bg/ajax/users/send.html?_=1668316777458 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '3fh1P38V5qVlkM1S6Ni0dJgMLP7hhM28P9LRMq9ItHyVDmv7Ev24Kq9TFTC1nuol'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6J-wqzDmcOVw4vCv8OewrvDlcOTw4PDksKCwrfCuQ%'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LResetPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Nov-2022 07:20: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
                        `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
# [13-Nov-2022 07:20:34] /www/root/bg/ajax/users/form/forgot.html?_=1668316833981 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('InfoResetPassword','LEMail','LResetPassword') 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
# [13-Nov-2022 07:20:34] /www/root/bg/ajax/users/bar.html?_=1668316833983 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
# [13-Nov-2022 07:20:42] /www/root/bg/ajax/users/send.html?_=1668316842663 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '3oZPS0NcfdbrnTDjXGIfHpP2XYmaTjELRnDeA4fi5Kty2P5ylEin3R0T2AB00dQu'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6J-wqzDmcOVw4vCv8OewrvDlcOTw4PDksKCwrfCuQ%'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LResetPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Nov-2022 07:21:38] /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
# [13-Nov-2022 07:21:38] /www/root/bg/ajax/users/bar.html?_=1668316898431 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
# [13-Nov-2022 07:21:38] /www/root/bg/ajax/users/form/forgot.html?_=1668316898430 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('InfoResetPassword','LEMail','LResetPassword') 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
# [13-Nov-2022 07:21:46] /www/root/bg/ajax/users/send.html?_=1668316906055 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'THOr8ChbyEH4t9832E4ucbdto5oiASuJ66n1UsbO68h7VJ8nkykf3cR9RH8994bK'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6J-wqzDmcOVw4vCv8OewrvDlcOTw4PDksKCwrfCuQ%'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LResetPassword') 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` = 'newpass' AND `Visible` = 1 LIMIT 1
# [13-Nov-2022 07:21:47] /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
# [13-Nov-2022 07:21:47] /www/root/bg/ajax/users/bar.html?_=1668316907469 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
# [13-Nov-2022 07:22:16] /www/root/bg/users/THOr8ChbyEH4t9832E4ucbdto5oiASuJ66n1UsbO68h7VJ8nkykf3cR9RH8994bK.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'users' AND
	    		`URLLabel` = 'reset' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1
# [13-Nov-2022 07:22:16] /www/root/bg/ajax/users/form/reset.html?_=1668316936547 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPassword','ErrorPasswords') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [13-Nov-2022 07:22:24] /www/root/bg/ajax/users/reset.html?_=1668316944142 167.99.142.201

set names utf8

SELECT
                `ID`,
                `UserKey`
            FROM
                `users`
            WHERE
                `AccessKey` = 'THOr8ChbyEH4t9832E4ucbdto5oiASuJ66n1UsbO68h7VJ8nkykf3cR9RH8994bK' AND
                `LastUpdate` > DATE_SUB(CURDATE(), INTERVAL 1 DAY)
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `UserKey` = 'w4vCvcOjw6J-wqzDmcOVw4vCv8OewrvDlcOTw4PDksKCwrfCuQe222674ddb1a3b75fa1828d8db3343d81',
                `AccessKey` = ''
            WHERE
                `ID` = 17 AND
                `AccessKey` = 'THOr8ChbyEH4t9832E4ucbdto5oiASuJ66n1UsbO68h7VJ8nkykf3cR9RH8994bK'
            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` = 'login' AND `Visible` = 1 LIMIT 1
# [13-Nov-2022 07:22:24] /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
# [13-Nov-2022 07:22:24] /www/root/bg/ajax/users/form/login.html?_=1668316944575 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LLoginEMail','LLogin') 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 `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
# [13-Nov-2022 07:22:24] /www/root/bg/ajax/users/bar.html?_=1668316944576 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
# [13-Nov-2022 07:22:31] /www/root/bg/ajax/users/login.html?_=1668316950927 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'N82ruwlWZPHiS6ebfG5pVdeRZk4s245MwFPDPyD0ThGphNGy7iSY9xZ5x6GbSil7'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6J-wqzDmcOVw4vCv8OewrvDlcOTw4PDksKCwrfCuQ%' 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
# [13-Nov-2022 07:22:33] /www/root/bg/ajax/users/login.html?_=1668316953911 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` = 'N82ruwlWZPHiS6ebfG5pVdeRZk4s245MwFPDPyD0ThGphNGy7iSY9xZ5x6GbSil7'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 17
            LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'users' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [13-Nov-2022 07:22: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
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `Data`
            FROM
                `users`
            WHERE
                `ID` = 17
            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
                        `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
# [13-Nov-2022 07:22:34] /www/root/bg/ajax/users/bar.html?_=1668316954441 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:22:41] /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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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
# [13-Nov-2022 07:22:41] /www/root/bg/ajax/users/bar.html?_=1668316961869 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:22:54] /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
# [13-Nov-2022 07:22:54] /www/root/bg/ajax/users/bar.html?_=1668316974385 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:22:57] /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` = 'products' AND
	    		`URLLabel` = 'продукти' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT * FROM `faq` WHERE `PageID` = 10 AND `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

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

SELECT
	        	*
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
                `Language` = 'bg' AND
                `Gallery` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` 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
# [13-Nov-2022 07:22:57] /www/root/bg/ajax/users/bar.html?_=1668316977683 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:22:57] /www/root/bg/ajax/products/prices.html?_=1668316977684 167.99.142.201

set names utf8

SELECT
                `ID` AS `ProductID`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `products` WHERE `ID` IN ('1245623','2657856654','2657856656')
# [13-Nov-2022 07:22:58] /www/root/bg/продукти/jersey-logo-t-shirt-100-cotton.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
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
	    		`URLLabel` = 'jersey-logo-t-shirt-100-cotton'
         AND `Visible` = 1 LIMIT 1

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

SELECT
	        	*
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
                `Language` = 'bg' AND
                `Gallery` != ''
         AND `ID` != 2657856656 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                COUNT(`ID`)
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg' AND
                `Gallery` != ''
         AND `ID` != 2657856656 AND `Visible` = 1

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

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:22:59] /www/root/bg/ajax/products/prices.html?_=1668316979276 167.99.142.201

set names utf8

SELECT
                `ID` AS `ProductID`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `products` WHERE `ID` IN ('2657856656')
# [13-Nov-2022 07:23:00] /www/root/bg/ajax/basket/add.html?_=1668316980328 167.99.142.201

set names utf8

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

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

SELECT
                `ID`,
                `UploadID`,
                `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`,
                /* *** */
                `Pairs`
            FROM
                `products`
                INNER JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'bg'
            WHERE
                `ID` = 2657856656 AND
                `Visible` = 1
            LIMIT 1

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

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

SELECT
                `ID`,
                `UploadID`,
                `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`
                INNER JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'bg'
            WHERE
                `Products` LIKE '%"2657856656"%' AND
                `Visible` = 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPromoCode') 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
# [13-Nov-2022 07:23:00] /www/root/bg/ajax/basket/qty.html?_=1668316980380 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827'
                 LIMIT 1
# [13-Nov-2022 07:23:03] /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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' LIMIT 1

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

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

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

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:23:10] /www/root/bg/ajax/orders/submit.html?_=1668316990477 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' AND
                `orders`.`Status` = 0
            LIMIT 1

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

SELECT `Data` FROM `basket` WHERE `ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `Language` = 'bg', `LastUpdate` = '2022-11-13 07:23:10', `BasketID` = '101', `UserID` = 17, `Data` = 'ThPuplKFfqAQRPDIxWSyZhuJrupNb7k2SUYu4gaFhdi8uFNBJjvlhJpJfhFzKSiSoNYeTAY9XBGFXP7rvh1fnEfqKu6EcX93Kg5XwHAGo4AT1pBXwM-82tduToHx9z8kM6kcjjjbo4nt7hBJmnyyOOj6y7OTph52toOGCx6kHZnROn-WRp-zSe_3dWwDUDoNibQ926ZG4vlLMDmOmkCScvfOrg9Z1Dxv0JGBqLQeMIfKSJLvrfNmnm1nqeL8xcrmM47gzDPRjg0fA-IdlhEx7TVbBvi0gz85MeVQF_A0sanMTpr004JMEH1BGZY2AgDMH_tcYK5nnMJXJe7dCuXDeNo2lbhlxqZpeOLiMfbnxSvGgk8GQJHcA5nrGpqZM-DXjr6qpg3ZH0rLWE6bhD8bCBs_y_9H5jK-lAEtazZEbXcSB7TuTj3MwzleKhe4q84SdZ-j_ickdH29_4r_BD-6JtxIGaOIfDLu-Lhl_mZl161IC1kn3gza-2jtn4qH153n5_AxW9P0SDhuKAI86njBk5L46hDiGREa4ynZwvgjtL_x9jHgB7yKYh8BKwVfEulWSY6ZtnvWkuTt2dZl9i0rxwbpAP1sE0Cwg166Mm9P2Z6coE82vE91rualqN-cl9Tv68rk8v2UIIlQz1DbXN-wWzh1shmXOoPkQx-c0boN-Yg1PZLM-NMy6yLYrVyIQcJEvD46fM4roWBfCFDoa4t386imVnA011ZlYQSewmOv5hSizVkoGwMSOIV9S64-1ReZPmDXmgRDrWb7v3_07h9gaxn_gQNAAzvbAulV5lG-ykcOmLqYh1GSblRjS7Ol6XoVDKnq9YPB0Tmxx69h1eja6yEtqJWB7MKerjn_WWTLPCrgPlru9uwBnuoOcyDifW-6iOYG6r8DxKfR5CO1u2bJRvxEIT3rPhsLRiXYLSGQaLgHmtD3SAeAx97OqCkKHlGP1ZYf9r0lgOONEBmNzpq6u7jHAQPwq5jUVKJIHld4sgtYLUR99NL3NBb8ZZ61M-AcqaQc2JOWXbtue2FhTMbHoUgOC527mcdyJ5iDNYsjC3spJBLjxG1AUhVYIgzLesIiriIgL_0uiNOoIJ9WLt_szZSgl0vX75waRgdJ6d820Vu85seGBNXcDAm3hXmv7bB1JYSS7_yO_dM3n7FfNuuAKxuKjewplm39jAd8DluxvIGIXc3HknL4cKbcTjZc6fEVD4dpWdqPAC4IlnScARliw9GRgZbDaKjKYmD-_RRGhEjWumPtXnzSc7NpcgrkXMyUppND-QyvJynoXJMYJX0T1o_41WGI4qm_lpPvt9EUre3ktv3j3pNUlXVzbOerD3pIFIZwvwgySi-9AieQgqnYkxfUK3mPrX3NGjACGLk3xolkcKu81eKTz6eq3OMd_w74LPMScK0HPm2SHjOWkd3uQpLX_jFZcRw3gM3B4GCSILq8jNTcvvSMb-O7naCf-_NNC-nB_2dD-gEXyvN9fs6j-mRg9Pp0jgq_UWzM6qj7yQrM4gTonWzmjhC2xRekD6tnjRUVhnQk0ZBnlkcHDC-n1wLKcuCnQhT_2R144ufMWMg0GzOGsaCTw3lYrIm1s2XLKl1rJwH-AvJTWAwH8UNYKHO2yuoQjmpzmAYW0Bg3ktE22LFTS5ElzOxKrxkoazJzp2_sjzFmmz1zOrEyoyagDEDLF1SBV43Tb7dRxrg6O7JthLUvGlSKOXz9U8D1Kvbm9WmHUfTBCrk4SsvWWD5jj5zKPf8_NKt9AyXMVgyukrWNyuyByV3Mb4P6ho5467TtAuTqHhXOeRMyDNuPBgIwQ5HR702am6q2Wpp8Sj4tOjkSiR43TzhEkWVtANfd3KA8orjyQvx3rUo2NE8t_lbK_rnclPH88owyp7x4pDwn2CApCspUvbE851KaaoOTvUQ5EifnOuMtpvqya_sihR6hoAktMySOcmcncqkO200WOkKdm3IyathSZ-awHqWoSl-9EEWarPZIwi68lGV80ql2pmO59SJfYQNMXKvEIoq4cKnz1yCW77vuN3qeATA2GJw3UZoOLw3_qgxLTYQlMngHKE_6suIwtrj68Nr_t_bmQjXdGCWSDaGAg44WA82fgeWXXrY8SgZpLvrg80fF3hZ8crGPU3WtfxXh8lF57KLwZGWmYxtcob0eLZ2Ol8O2bQqwEdjTxZ8-DzHZlBfYHUAgukczaOCYM2_O5_IoXboa19LcNKKMr_cOpAU3Uw64Jg14un0Gdb9wOJb1eq1pbTW99CWs22LqFS5YHkW8MFFhbkbT3ChNrvDdwqmE1pBfER6AC9SsT0zPuEV2qQDY0_BNApJ0lLqILPkL8Ge7fRwH8aLgUu1_ol0L10FRhMYNjQcv16HCGsjardg9sAwggHFvnZzEHQgR37xKhYMOMW7cOxQGyQvgA0DEVG4dhE1KxxDo1v7reLZYaSJuwmx3_Ry3e4ohw6Nrp0305P2vCDhI6e5AyeizkdehSa3vvgMv9301zueBPlTF89bYULgsGNLkHNGVOyQm2dZz2U94_CHAzpN7aSXTwVTwrgMvmw3lA7A5d0NuxabQ5_4zYVDlqGahYRhADl--0Xr-8WCx74vLZt0m2jv4VIgUCJmmuNjH8Y2GczEhoRuY8Xs53KVC_zcch3d9GAXtBWPDAbYIAE8WMXX8EzZCHtjZR3RBUIQrflMgLOKHSDRRXNdKNQ-eY8oP0xvIfUImMkVxktBVbiHumM_9mPZJBgvtwltKJObgxqqeF7UR184ZhjGdxO0_J-9iNCnNgJOKNcQUAbP5kXr-UsBG3TT-dwGP9l5e7Oghr3or36t4DKDw_5u8FWSPGvKbdPx5UMVlfoPLmtRh6Y42FycjQWNquwTLc3-IBxjpdavfrlRe1NDH8n9pIc2bwsQELlvpmR_0UEoZhpOVHLKXkcfHTAFxn5mzOKRj5z7A82kZpEnF_bDsmddA9ndseqXVf9l221e9fFM6JxIyNK6vcyJr_NQq4zgm5TTC-j1D9F4aIPuUrm305jYwOVaIXgxLZf3xdNyP7FPTs0PAh0urwLlBU0W89Mr3AAMNrHMR8sGbVGjz6ELdHy4WdEqqa3h1f9zS2QbpPS1VCA6WmxQIk6qgJEbvwb29v_dWapzCZOE9VyUVSDT5b9LddlnkLtImO1fA22Gj6WbfmlzAoMkUuQ09xw7kJQfp59sj381Tr0T6HCZVMsr9zDiSxYlV8UbqK84UjhLHmEKJxOpWFq0CExI4eWmaCDvVggOLfuCMV9KzikebbE2wFB-K54oXvOpF2PpjLt2Q-HA2LlQrWKHynBWtfcIqGfo0v85ixDSJI_nlYURn3qiFD5OAMnyU4PKSd3v1GhQduwPhaqifsFg9XTDOX8tc6RtMWyuzTtg0XTv3AltjTr5D6rSH8ealIN3uDOvSGwv1-EeTxUvS_SMYs19DDyTy4bNkPZTp1jztRlAskeyifPmKwKvQRVU1jL3-bYTO1oHyrVU35kOeDRDFTQIYUZezPQWsMRLQP2W1WpqNEkQx_IdRKxYrUnRLvgsnqe5P_g7vvIziyfjQSC9zercElfjF4_-72w7SJAUi9HDxoK3md_kdskeNhB9ahi33rk3e9IpjYwDFK4581Z-NGkzjL2P5yFpKKhsrme1MwMbKgSt15sXTgMUx497epKkS6WbRVxKx8q5cDE_xRxZwPDmPl1lx_tLSLfQXGKeoPO_kCA982_fBqm54Ip-UNQcDNUSjRdvFClebCZ0brUiFANy-I2WJETUrE5kCxhd86n3VH6BiSQdn_ARqFHPRw_x4GgztyT4t2S8GIDEpEJ_GVhU', `SearchKey` = 'wofCscOIw4DCtMK6wqCqMKDwrHCtMKsw4zDn8KdwwofCpMOEwrDgMK6wqDrcKDwqTCsMKsw4zCucKhwrHChMKhw4TCvMOWwwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwofCpMOqwrDgMK6wqCqsKDwrHCwofCpMOAw4DCtMK6wqDq8KDwrHDgMKrw5rCucKdwwofCpMOIwrDg8OgwqCocKDwqTCwqTCrMOTwpCmsOAw5PCqcKhw4LDgc', `PostDate` = '2022-11-13 07:23:10'

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
# [13-Nov-2022 07:23:10] /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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' LIMIT 1

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

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
# [13-Nov-2022 07:23:10] /www/root/bg/ajax/users/bar.html?_=1668316990835 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:23:10] /www/root/bg/ajax/delivery/price.html?_=1668316990837 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LDelivery','LDeliveryError','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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-13 07:23:11', `Data` = 'NBwueUzb5TdPxYopnCE-Z5kGZs4MEpM0b0c-u5Fye0BZnKrrH1ZXU_HFU4BqMjM0Hzq5CB8UDuUC7RYPniMjDmDK5sQWM8aZfQ_qSWkyrshb9mnqSjnUVBlYv0kuBEbIXn2plCuOQkYfyGBgr4nRUFJFVj3iMD9fyLDxQ-1EACEr8hY8Yk6oEaBOB2bY_hHlwPeId2mHeMD5s1pxiwzRA8BabXLZtmI7yE46EHhRLzqXBcVXUr2SOsteAz3GWaem9ThF-MeA_IYReBPq2q-FaZflKu3jDvuMzOivaysI3RrX8UAfISBitKOE005zypqISGdBhvyP-bY5fUgRnyO4AVLvtY1m3K7hg_LOXRwDvMZb39RuMYxeP_zc_Vyik4ta2_gW2-tEvQuE9SGXhKvEQ0td95f8-FQ8QaKdznU0ad-ZRGAf_nHUZAibVOidvyQLDadcZ5LyK_uKK1yN-ipDlFlmur_pCFiKQPwJkyPXrPwWb3Aa-GFTPov3ztHQd8REKKOXQqPR9bKPjwa8ykHa06LRTl9N8IeFyfvfjR6HE0KRZIBymSdNB7TzKKBKKQejkemzxoVn0LYlTmWZssnaj7QMPLbe6otFl8hwRdO8bnbaozVl6XXZ9NDSPneE3OF4H57KpsIa-xY_SPDOaIAWuCKiZYE5TXq38mKWHl2Uczhf3059UVT8tFXn1cWV4P0RQpBBieE3ZPIMwtXYtam2JvwkeRAlCIco8c4e0aRFt9mOOTlDa6K8EDw_cR9w5SP66IP3e2RDcoqijiqcCjNJA_9GSQ9cIrKOMopbc_9l8LeP7COW8DZUNBs0xfHPbAw3IqyyzQGFS7mlzG5oDj64pybq41RuCIecg6UkSifNwFX2mBEb27ATgblGcDKA07zaF0P__uj0NFSe4PZU8qhWGe-KzdevOBA_oJ7BMlaxFo9TkvPbvJXT9wZ3zw7b0Pmkh017iizbxJCdYZNahDGbpHjZ7IxwkGfSwpoWhzXr2wjUfK-xUKXFbMBfaDTwbB9xnhVtDHAalnjVojWVYCTCAa6Wi35FmwlaURfO5hFMOzLCgsiBmx1jBiYA3JxcLKID_AHxCSf5wU_IqlKnMjQ2K5Pxo2Z0jogVKbi4GjTm_SlsLkSMRaFx24y9dH2hUCwRyysb6xMxsoAqPXvNArkIC9os8a1jZOE4LTTsh0GjBNYJ8dk5hkKVMdk4yJCsIPuRtOZpUYStKmMNvJzD53anW_bKGBTiqZ3nWvCrBbsobG5L3WHx71dBhZI3oXfWocOsOrzpy8d6UyRQYKGlxL_PAVp95B1AzbyHSNMcqTxTL7HwYv7hN13PRBracz23qLYGG1RjoIfW0nJ5C4CcW4w1gOKU_yot1qKGug6EL0yosksWhquQL0yK2WN_0_G9Qh2wq8we34fGxzdnv6cwUIuGDrFYNLVF93HlI1bxPtyZ7wQFEGgKsKHlE1gbaGcD6-LmWiwPmJoOLFROebSoU6-MAo-ct9cr6ORyexQjUvMNf9TBMtmRvqgwwIdH7eLs7uSJ3G1txc5GB-oXMCqMTugKwVCzMph4gDbA2Vg6ysIEWAAP7kGGQeef3G2XJDcQ_drwL3sx3Zkx8Q9n4QVfoXywh_MT2oTeEzbs-zUHmFEbyMXZqCwIeUYE6Dt4tChaT6BinEN4npl3BebRTiMxoxree5Xdi-oEdnctHtyZsZ8pmdXglX_QESmoYwA-_RwuEqneA_sGO8W4FvCU2EknU8eoKLhVO9d8A2fXCT9Ssp9uX34aCZaNxmDl1DDsU7JmnU3iSIJvYSqfv5zJ1EZbBHko48uZvF8-0RDQE3xwAyUPSWPNzuNq2Eny3KhG1iFHpHfZYH7OUROGL7WRUGRgcIvnVphEY_SRXX9_qfZ0-zq-f24K1ZBCeIHbtOIH_gw7rzB5jLFAff9BEjujJHsXP5hfItox0aIFCC0bTisYsYu8W53R6f-QBpBKfeI3k_8JY-JRxY6uAFjyeJrPA-uy4MNT7AmXZM8ioMHXi4JKOJKUQj1Cix5IXSu80OkQrzgPaT0sEMKSENjmYL_ZiSkynEFTg7tgNdMY0JPyS5wuoyowwWlr5u_TCblq_jcJJuYaqs4nRTvIyi7yKKai8R3yGVvwQ61TXtGLE9hLyKMCU1_Wmve7G1NBGTjhfj17pUWg84uaMRQXD-imXfJX4r2K3dTlt-1HHvHjzFwhypvSkPHi_IZlnaVoatRQxtIPS1G8Na1_JiGD6q3AhBJCqRdNvQNkBUdww1uxU4-qNrv0cz8u6z4NZXE5vb7JgiwDhZgQvmzTw9EEw9_D0HTyn_shm9bIaewWmpD5fJ0_L6TMafntuXnJO8oc8Qg_dtCV9piP5lP_Vpm55p3mvx2Q_HLYcFvpKvjNpUfX37-vdgHNzHL6UyXc9vP8hJIfWe9h-5v5PlMNtQZEo780Q9U3UUttl-ciJy3CGF2VS2dcR4JAiZTMrxVYIYKbeIOeIfcyWXrwNukr4pZYCLw24SD-ENcz96nwrs62p7TK3CBrSicYDro-7d3bhkEt8gFGcZddFZvanTwv5B70iLACL6KcOd79kNuBk06qCFmfqEFSDXjtLtLwKYIpu_kMvRC0AXC7uqznyTX6LoFWghJejcy9qHJQjuMi9_nhd_x1bcmX2Nk_VpA4hLvfpx6VLD_uDUjAFhjoAwAo82bWn53ENeRFxXwQqNCdFKV7b6jxIpubs7aw-BUUwJW5prDGNcHO1EiZ8YkWB7RgdD79qwSTpV5s5CJEfEaihS-1uWqaRMpKdGw-U-ZWn0zYpOJfVVMa_3Cp29WfrelI23tqy_44M3JXN1GcOtCxqRNJ1qhc-aJn4odc2cQMpY60XFSn8Frs_4SRvRffXmYdwzhzmRv8ljc5jyj8EEVfzd4VeLEvE9reGBMCNEr75oGMGqdkONfQH8b4KEDJZt1BqNEvSNbitqOPZL7go0lXV8NsnXFNSqEByRU8-FnWmRDyZIZIuZEMojgqyaQCH2yUFz72rx4CfpeNWSNyb82zZaqVCmWRUdZmNwKQkkrmpjaVj19pPvRQJwJdcC35f1_5UripvcQeCbAy6xMWaYrT3C3yBncNhmf7nWpL4kpdjQZl6mvj6_VXcc-yRes61zlvJKiNYIRzqDieXSlxltoOF4O4NJQW8xpqwe3rxD2ttj2pcc9eZSSf8SR2IU8EeH2u1JHvMaV9JT7ym6J2mIv6ift7mCpyvhaDaxSWAuWuP3ForO_91y4Wozva_wMmjr2C8CcNKRPsQcY3Wx-2Rp1pGfg4VTdRP7IdqIqed0YU0Im_QS-uZcKSUgHUjIVTAWjWNAiYP8x8DBnIdInMEInJRRWspxjX1w6enyfGYT2-GF6G4uy_zOa6V-agdUE7YZGTcbz5b6ZRcRjEQbNA6L9GZLzlFZhT_-ZR6uWowrBA01C1CA-481a5YmPjBSJ63yV9wGdfUcpF64trlGe9UQNHGBLjQw985kvwep6KlUqsUBcnayWw1_PTdNrhqp9N4AWZI0Uu2BipKJYbQ89zMFhZ3gM7QXv6f18uTtYYq4LyTHpdiGn3LLOQZ__4-_E3JZNbLXU3BA2FEGgsc4b2UivIk6Vl09jmETFYlMyrX3hJqkou3mwdiBHeHjnIXn8RyYnMDlwnp4vjKKL75I5iIQyeSDuRC9vFqKdOrvghMAW96U3oXSkyMJ58URufR3hPHidPWBOEd9mn6aNk6RWutRsq8Cigvm24XdxZvinbfdZrLjJ1zcWsAj0vxkicJPjU-uBesJcN8DE2vifFgNQvQQrGoAxBgydlR7kSvehgVEuJ-p6Wa0htdsLp1kYOMvISt9gSm-5cDzzK9TKppFS_J4ISSA' WHERE `ID` = '37'
# [13-Nov-2022 07:23:15] /www/root/bg/ajax/orders/send.html?_=1668316995411 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' AND
                `orders`.`Status` = 0
            LIMIT 1

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

UPDATE
                `orders`
            SET
                `LastUpdate` = NOW(),
                `UserID` = 17,
                `UserData` = 'AjDZNURdqYV6qqPtTqKTDavBJICR1x_-kK1t_g7Ec_RgDkXz6uEsIEdHj-PQV9LEIcmJDswpPioUHMpHz-grR_GubfM9njWCWpdepSGa7mgIaHJohhzfp5dq4-dpQlLY0AQts9PngP6RQSlFsq-KXsw66LakC_ivt19weL8BzU60BAdvaZ6UFssM_wJjJnu4e6sTp-XhWgiXv9cd4Pinvg'
            WHERE
                `ID` = 37 AND
                `Status` = 0
            LIMIT 1

SELECT `Data` FROM `basket` WHERE `ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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` | 1
                WHERE
                    `ID` = 37
                LIMIT 1

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

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 4
                WHERE
                    `ID` = 37
                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
# [13-Nov-2022 07:40:11] /www/root/bg/поръчка/list.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` = 'list' AND `Language` = 'bg' 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
# [13-Nov-2022 07:40:11] /www/root/bg/ajax/users/bar.html?_=1668318011850 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:40:21] /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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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
# [13-Nov-2022 07:40:21] /www/root/bg/ajax/users/bar.html?_=1668318021632 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:40: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
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'products' AND
	    		`URLLabel` = 'продукти' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT * FROM `faq` WHERE `PageID` = 10 AND `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

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

SELECT
	        	*
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
                `Language` = 'bg' AND
                `Gallery` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` 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
# [13-Nov-2022 07:40:23] /www/root/bg/ajax/users/bar.html?_=1668318023695 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:40:23] /www/root/bg/ajax/products/prices.html?_=1668318023696 167.99.142.201

set names utf8

SELECT
                `ID` AS `ProductID`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `products` WHERE `ID` IN ('1245623','2657856654','2657856656')
# [13-Nov-2022 07:40:24] /www/root/bg/ajax/products/prices.html?_=1668318024871 167.99.142.201

set names utf8

SELECT
                `ID` AS `ProductID`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `products` WHERE `ID` IN ('2657856657','2657856658','2657856655')
# [13-Nov-2022 07:40:25] /www/root/bg/продукти/jersey-v-neck-t-shirt.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
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
	    		`URLLabel` = 'jersey-v-neck-t-shirt'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT
	        	*
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
                `Language` = 'bg' AND
                `Gallery` != ''
         AND `ID` != 2657856655 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                COUNT(`ID`)
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg' AND
                `Gallery` != ''
         AND `ID` != 2657856655 AND `Visible` = 1

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

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:40:26] /www/root/bg/ajax/products/prices.html?_=1668318026001 167.99.142.201

set names utf8

SELECT
                `ID` AS `ProductID`,
                `Weight`,
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `products` WHERE `ID` IN ('2657856655')
# [13-Nov-2022 07:40:27] /www/root/bg/ajax/basket/add.html?_=1668318027117 167.99.142.201

set names utf8

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

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

SELECT
                `ID`,
                `UploadID`,
                `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`,
                /* *** */
                `Pairs`
            FROM
                `products`
                INNER JOIN `product_texts` ON
                    `products`.`ID` = `product_texts`.`ProductID` AND
                    `product_texts`.`Language` = 'bg'
            WHERE
                `ID` = 2657856655 AND
                `Visible` = 1
            LIMIT 1

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

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

SELECT
                `ID`,
                `UploadID`,
                `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`
                INNER JOIN `product_sets` ON
                    `products`.`ID` = `product_sets`.`ProductID` AND
                    `product_sets`.`Language` = 'bg'
            WHERE
                `Products` LIKE '%"2657856655"%' AND
                `Visible` = 1

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

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

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'bg' AND `ParentID` = 1 AND `Module` = 'orders' AND `Action` = '' AND `Visible` = 1 LIMIT 1
# [13-Nov-2022 07:40:27] /www/root/bg/ajax/basket/qty.html?_=1668318027171 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827'
                 LIMIT 1
# [13-Nov-2022 07:40:29] /www/root/bg/ajax/basket/replace.html?_=1668318029110 167.99.142.201

set names utf8

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

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

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

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827', NOW(), NOW(), '{"eyJpZCI6IjI2NTc4NTY2NTkifQ":1}', 1)
# [13-Nov-2022 07:40:31] /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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('2657856659') AND
                `Visible` = 1

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LTotal') 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
                        `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
# [13-Nov-2022 07:40:32] /www/root/bg/ajax/users/bar.html?_=1668318032248 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:40:32] /www/root/bg/ajax/basket/qty.html?_=1668318032249 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827'
                 LIMIT 1
# [13-Nov-2022 07:40:39] /www/root/bg/ajax/orders/submit.html?_=1668318039779 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' AND
                `orders`.`Status` = 0
            LIMIT 1

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

SELECT `Data` FROM `basket` WHERE `ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('2657856659') AND
                `Visible` = 1

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `Language` = 'bg', `LastUpdate` = '2022-11-13 07:40:39', `BasketID` = '103', `UserID` = 17, `Data` = 'fudeO6avoO5D52bGBxWUi-OTJewD54w0O_Cw_kGHDGKQ7o3E7OSoPed87WSqN-qz8cBiyzeDYBwsKibsN3Nk3CZQWf6codL6PdWHg5kV1gf3BpPQDDaUuHeBz3bMsNxpg2dGa4lfrIRL0ilT1TsG73fkfjMvK_emFCSIj3Da3M5YotJw7Z1ZyJ7bhE-EXs1fw1n-j8liw1ERpWpUJo6WXGSANjLk5rCq2IkSmZmqMZSelZ54kajYSvAFpeJ4flx0i3uCtVBhOaoKBiY3GSJWaWpXolEmeT8Wr7kA-4vuI_6v-4uvrqj3DoMQ1YtXYK3kW_9ZYoXd8EX_hQSlpAlFBkFv5bT0nOPPRI-TNlvh7B9W4RF_s_C-8GkU5QonN34C2y3tWubGwKyHL72ozidEWF76ClY3lFepqBXfM2yPTyoRLOsikZFJRO866XKwiNEPwzs_i2NhArRISH1NqOzoV2w_hP1-K_P0pRr0RDhtlpU-P2WBqLY5_t_F8AZghSaTxK9TAD9WHJEwUHYKA_pu5XRBL91G_38pihME6a1Rt3BTKPgSgOeJ6VtAvv1RJ5rphSwW46XLX6EfGVGB4yzCxgoiGNHoFibFjp_q7stKz6FGZhIYuVMVvozgI3eqrvsKhTlD4KLZabN9TyMMmyTpHMGl5fbjhCqV6X8P3QaF0vCf2X-7b6cjLGzReTYjks3tFnV2w_zKjfuZ7MEGVY6xXpeg0gpRxZ5jibJ7JNCj4uSCLJ9aZjgvR5KbF33YRnPGnUJieI34K5CAHw24CrCZqvUuRKHSiYqqZPnpdLjLAYNYBJEKjNy0xRZ8-FBEcOjP7mvKK9dAQeDSpVlid8fcvHjxj2xQOSTFstUSkVpSW0s2xafHBTbBdJ8YtRflOiGQpq8T-DdJazYM6_Ttx9LquRDvK6fgAfCtyFhQQRdY-weq1siHn4fDiyyyzXof0UGXPMMg-L4IJL_MhjZMC5jAHiFe9PDSfYZ5TFDIj2hoAsJcl3JmGlyNAy68M8fm4gtWFSqnVkJaEcbTMVW8GpM8WqiZ21i3FC22WFhv5OS_KVxunM9wPiQMQsGjP3hlKYww4kh3oyCcMHHrv3RhScrBz2FtkfJBOUAymrr9w94oFkriIFpszrDaIBUxCOiTBxspxTjeCzA0wf1KFngt6LshUGmHZFsrFsv90T3WgEE31-hTaPu-rZEaCgLcqtClV1pKqMaW4x1z66nKRINXylEqKZufxjQATbt5qA-YsrlsiSs2_rLYMiw5kR1gj5Q5jYEri6VA1P25cQ9QIGqLJTfCcycE87eZ2xOZdvE1aiMrGG8WvNku1YQIX40mFR7NpiqU7SbeKVlTEe7Wkz9hgDuYqm7jBJaW808f2yFenFjjCYqaqN2_RnScWlrKEtTPPD8YxlXIMbj5fFMqBanaKaTkZr1NWr0ItaHcRboYsZc6K1v_HyQ99x3w6PBXWOoj27iT4GyeDXh---fsH-lEl-H_hD4kWsPDKTIO2BhPyHYyiVdax5qVwHkMvK_IPbzDhLSMgC2mU20Xpw9UPnrDf6rPW5ssRUyX56RBfPA7uFMMMpMaUIBFW-SlQHKHBjFQZRhlTZDelfdegWjt29VePSf9CAf6E1JzpmWTkrtXaUXjcNLC0E6Lz9fy3w9AKAM57NauWyqzXWJjVQfJ5FJVZBhHQ-Effg05QhM5ZXCTTXV_4P4Hh5ndmmpOY95USB_5MGDk0KPBn18-XUUpDn4U2mJaKjZMNY4L2Vk-bcx8Qh89OdKyer_mZ_XhikFwNh07hqorC3TgTKMWVLGtOVdkffpV9srsZOwgZ35jutuOdXSZJCRb8p9YzsMvfkq1aiUZvbO1Nk1uGAhE5QxscSc3vFpVAkeSEGIAK3vpPqG3BRvrWyNYEj-DwiHdRDIBbwZxO5AuARRFFwLpyx3SLY4Gkb_LVz1dPMNb18jXtogoUxi2NbqxCkpPcTNxdpiWFN2h3GdUMAfXBux-foqS5AWy_i656iyAB-BgJL4Oquod504mES_yKwGjs8OsZ-SNiEgBKj7uV3lKh1sSzJFbLbE0ugfpAPHohsoW6VvN1OGpqmaamDXb6-XISnQfaNqy8mT3yoZbFKQnp-CuKN5VDBGa1iaG9WMQmMLVWtMsHbT90yzFw2Ur_PdhaGvhkmKPat1cHC4dR6aOyAa6JuiwT9YYBmiAoOne0XLP-yDyJz9J6FioEDmJfXxs7X6M_zG0AxgRrpp_-qBl0WnmFM4rZZRsKBzuI3B_6f4TriYyL64EMNVG14P6Fkl4hYyUOpXOfe5pqP_hoe-VmcpQQaWD2oXzQF2UEHCwVGRXj9VlseBHab2U56Sv0DvXnBD4qFZsu3XhsWWr4uIRkbgKFfyzLZkPlx9PQKipSNzA6WxljMaLYheNTAui54w94fRKZVtieP9fM4atB6GxFPjVpP8sgujTBZr4tT7fUIkTVNQVAyeIlYEqhZVnF7mfqL4cf2BPT6wlKAKxCAiyG8GtwpzAPoHmtd_CKE8oSmLlI_PDep3f-B3d7HC9y7UnDmvzGMKXDbWgu8m92_JrT-ojs6qVC95b29upNnen2jp2GH0iMfQrrmtDuKnUpsIGj86KIMDooFKB5sP_IMSjsc-Cz-OnrMz2SWOb7MetnqnyNxO0zO7ud5YzK2-a_d5LO4UTc9fiMxo-icq_AD_fz6Twnx9jYThtz15_PZ6z_Oij-AQRNM2tJOjFfjjspXhFEmO06Cy6kd98hsrtqueRi107j5NDaRXFkyn-G6_xOSjIIWOgFBdQVQika_jiojUB1myTlGO9o1tioTvpXvm_mmevAYbvpXdnMN4c54AlAJYQgdf-CccI0oRepymmahnP-8_trBgEGENXsTmiQO1_EkE8j3mdMUxebW6lNPCQxHZ6L7BXCIOp8f8AJSvnoyYj7fflnfbCMB6nJsYDaadosgHJLgiZmPyA5g9JQrsE9nCprGboAZ8Hgorn1SUMb6gTYg3NCBASDXWI45mqzdN2oMqUuwQMhvspl-Qory6Gi9lKZaE1AhZFl9J0f6KebZBgth4zVxphpeOHE5xygI47kN4kHeqS67obzuXZG44rCDLZ2HxL3-Q8imCHiB_tO8IUuOdoC3e_LhuJJmrBSKR3DGSjk0gfHZBcGOLeT4wio6qYsptECila3B3TNxk5VWbhF2SLNQbFv0cE0tq4YiouWtn3vWC1_6vENBXzjsssFw_VNum0pWfhCGJYRWc7lepc6BN1Y_Qp4jQOnWATe7Pp2wL3owh7PAiAHyt3-5NzB_OeWbD3lv4AC_vtpcwUgeBB54Bi_ejfE5-pu9hfmAfUN20LANtRl4e4S16mfU-5Z_Fz0-YDU509I6Y2nU9ufPXbTQC3Rln_dkD_ExV53RFrSKHjMsIAR_nIUW-YCUNtd85g05LKndestlvrUBDWkgzgJXFfsRd5g1JVA3lyu-Tfc_GNfy8egQzyIU7UhasOjsvSNbv6yoxoh_vmkYb95SC8UAwZYbI8nwtJolAx-VQUNePwi_mEbztEdDrzZWbCNI51RuoaubVWwIDpN-XXiG5EhoBhqyq4lEbote8afDc_2CtDQaIc39QwpOEbaCu-fIRTSC-OTWP8SgW6cVjvnPKORJjTaKTejbnv-eN4ah-1JZdgdN3lJYJJpp3pvRP24n_jaZTz-Telicu6zoAUEKz_sn6mJFHPOeGQ35MdJaXvoVjBFUHXgLYSrpngUQ', `SearchKey` = 'wofCscOIw4DCtMK6wqCqMKDwrHCtMKsw4zDn8KdwwofCpMOEwrDgMK6wqDrcKDwqTCsMKsw4zCucKhwrHChMKhw4TCvMOWwwrHCn8K2wqDCpsOEwrbDrsK0worDwrHCisKhw5bCrsODwwrDCisKpwwofCpMOqwrDgMK6wqCqsKDwrHCwofCpMOAw4DCtMK6wqDq8KDwrHDgMKrw5rCucKdwwofCpMOIwrDg8OgwqCocKDwqTCwqTCrMOTwpCmsOAw5PCqcKhw4LDgc', `PostDate` = '2022-11-13 07:40:39'

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
# [13-Nov-2022 07:40: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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('2657856659') AND
                `Visible` = 1

SELECT
                `orders`.`ID`,
                `orders`.`Data`
            FROM
                `orders`
                INNER JOIN `basket` ON `orders`.`BasketID` = `basket`.`ID`
            WHERE
                `basket`.`ClientID` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' 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 ('LInvoice','LInvoiceCompanyName','LInvoiceCompanyNumber','LInvoiceVAT','LInvoiceAddress','LInvoicePerson','LSaveInvoiceData') 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' LIMIT 1

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

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
# [13-Nov-2022 07:40:40] /www/root/bg/ajax/users/bar.html?_=1668318040148 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:40:40] /www/root/bg/ajax/delivery/price.html?_=1668318040149 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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LDelivery','LDeliveryError','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` = 'b023bb7d15c5b9ce8c466c894dde24a070737922cdb21ffc6bedd2fdaae1f827' AND
                `orders`.`Status` = 0
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2022-11-13 07:40:40', `Data` = 'exW5XaSzooeqKG6IbEgH42GtBmptYQXx5IlPvC0v1POfrUfbI5XuBP8FR8ixWdf7MZTahGawrBTtllc2u_UAHm1dXeoD343kZZDAfF8kQT2KtpBSvlc-8PVJ5Sn_Vb-Jltjfx5WJ7WOP-OqveFTgbmYBbAvNez3RCyGdU1ji_ZLOValy2okVAHZEDp5Jo6K801PGd_6Ln9ZIXN-GNUzgr-nFqwJCSEw49YfRTIHd5U5Osdb_3MYEwUqqJhJY7Ws8n5frELNV2Xbs5a5qWJgiYQ-Wf14SU-1g9oXt06AjNHelBk4crnCbLXghtCP0NKcM_JzRav5dZGcj3K2kPqk5CCDh_KJmADnZLZTdwprrbm_XJN4ITfw1776NscbeHcETlXt1ZmvJ6Nbn3UujNZ35fCvek-1-yMbcSTbtJwNPZxrR77NukS_h8XjP4cuzg-FplYe8k3pPfO5SiOLpe-oVNwBLQ1utuZsYF51mtwPvSU6ZRHudyOa9w2_rV57ETWsgiSZ5jMpg6uBswXB_FjQkqprET8GbhM-aQyUgdJIYWXRtEusNosRzbEnbng6815GZarRjgMn5nHQiW0Nsk-8GAHncFuoZHGez7CF3AFMiFeUf_AOhiRlb7ydJyQT0N4Jyoxh___xXc8dlQlp2fyjWwTaTfbIxutTLHwK0a8Q45jlSTiCXKcIEMy3geOo7gfGYAsv-nOvCIDdCSnGQpRyNxRef1Er-hm3iZO7fZ55lSo4K7UbxF046aiSM9oFtzAjbFu44WfBjfB2eAiMIpYPcwfhfbG5NwyOjOXOGKwMTcIq4ZIVoPWQgagnG9-LyoJXkv8h2OhqGmr7gWIQqNTmaK7zmJmBGxU021Zb2L-b6rIz4wgaayoWL_7x5JA-RuzFNBZtjFRyn8wKY7NrrXr-lFCwnYkNcmyXLbYHWTPwYQ7hRF4sz9Qu1fQMVGchmBd03t7V4C655YtB9wYYwChM2C2RbI4-c52KyzQTI41oHPzvI9-V5LCvy-7uheCXqAdxC2ArPomv1mmDebfRWV6oJYjniKl0SmDItJlpFxWBlYftDoWmN4uXvKuyonRa2TDxeizRKSU8d3Vo3FQACu4Rs_1KqbZZzE7LSnj9WPDzqSZmp7K8gucDm4L9igfc37v0E3mdIEVZ8WBRfUVqL9zs1OkDr7ZiovS6xxePKjzLSs08WBdlXoNV7a12zkIwnC-FkJ1MAJ09_n8w0Mrn4oHCDq7bp52QLGpulFAtQpKiCZCGKtUfYIbvtdfF6F9TC3Bh1qtO6xfx9QQcwevmr2_OWS6PSPEbu9lntCHp0ak2YN2JNELH4artlitHIt57ZgYXWBszKlLXLlH4J1gfKqvVY3qbta4Az5FdFCDxpI9WoPZhvvPGQb6IdSgGBb5xKWj9x8Q1xQd5h6zHiK2dGoHbahRIdRMLKN3vz8573M3QELTg9PkSU7YDMTX80oIZS64SPudLfjXiyk20UI1svXO6AtgiMf-FRN7N65n4I7uC3HBu1ucmfPMnYzXHS9ygvBB1BTgjjAR8eaByYIhBzy2DlCeENL0PIP-z4LbkBwwQqwbagGc5V_-5tI5w3mNU2E3r2yeZ7zS5JSytjTUja791T_HjPAq4kAMmcsCwqTrrqy_SnBj-qzJ9C_4qx9rp0BzU8edDpEgox36nWxMxzSsVKoAMkm7f3ESmIEYoSUItVjpQHiV9SftXmCRb7rZv80xIC85DYQfeMrmZhl3gRRoFopumtmbEJVfNG3f6Z2nwEGm_1ryAo15p1DeNY_WdmOXPF9-b7foKWxS7VNOjdoa2JuQGCxuB19tO145NQNAZPoV2u6ssiGxRnjovP2f-mv-fyo1_fnqKjGbzdLqhdtDXz9dk577dESnbLQi12xHnm9F0aNgV9Up_UMUGAXmn7-hDT3lU4Xzw_PzQ-T1DoTzxvvkjwBTWKIyEczG6EH4KzFfFUUVG5dLJH-Pi5il0UerqeJzPf8vwNiWyVSAeBef2hov_lwqlyrdtTuUBZsbahkZ71HUhQXIdP2-8YI36ZufpZcStYNAYKpG-Gy0ze2btkVpRCdhx_4c8X8n02vNdp1h90Vy9ouE7mFURrvMZP1kpYhxTiC6rbaZwjiuNWVnfr69n3mi9beDJp_pwn2ZlYY4sRlNYiljidV8wcAZrdds6u9BTfIlrLnALPh1aXNW49tPai13zJtTFFkBoXRnUzXymRlEEeOWouy0M9YopO2d2fcY3nlE6HkiZo86qYkUzTjL_59R9Q2E2HFxwzF8TKKeBPmXlnmnZi_8Ef1LRHuVtFbDNVYaf4oY5Bm0Q1I0Vu1bnc6Ee8pL_8AOJiG2rSNGES9PDalh6WII45j88GmiZSbhz_knf6ImUqeAXqjO0KKLohs5vN3J087tMDjc3tcMmnzxkRwtR6FK-vxm7w_AhJekdU0b50xvMSusn_TBZRBoQ1mbtlHEHxZEGYKgKOudfbCc-asA3nMTedhMHIvta_P5_8RKdEcfEdwqQPdhgsittA2QrRh6yZVZzV43ibTOqUUFIyMFosjGJ7CFavHOQp7SVYwjhr5HatRdpWAo7FJGS8u8CC8SHRKul5PmV2Qaay_lweEnTOeTkK0l8rbPtEAHrzmCkEHivLAz7r4N_um6OXYE1xCeM6Cwg22-gNECzZwrQo5L5sO41HC009Ik3gl5UsKO4zGM-eKNxpZw5kKhS1hvlcnBUSgkwltQbFt9qt1VNEjRTTbus46fhX-M9svxVe3DZummXWlmstBI4-Pzx0Wnemu2P-31nAB8ajLWkVo8f9gpYykS39J7EL7ICCEfhxO35ebBf3wX2q2oxB5prltUT9f9D1-CGBG-_YjF5yj5A40ms-OfRaQwsI4uIWaMYudcq_Y5FwIcycPmcS5rjHm2aCn9sLoy4kzCM7tXTFeOX3eTMA4DT4pGXauLqcYWyxt-DhSd3Gi_XNIbb1znRpreQrMgEKRXd_pXMN30YGMmErBrvHTMAGbZ1cnBr1de08sWUZDEeaSHibCkzqXW8FPQrg3pVeqQ32Wlj3mUhRQc1VOk_xSWxj1_Z16VFTK1OfL0fFUN2f3tW3oCQHPT5BwjQfjX7HfianWcakjEMAoTuJBcYJ1OCAyc_W56TeM9QQllnqi2tRuflwGB7JMgTDAg8KFN0SN-mM9KTXTdYcVdfxEbNz5fpaDJ0qHS3Yz15Um2RdkhnLhNlmbbX9Ljq_Sd3ccYxXMrXT76TwR7o3eUK93D5bpkUCaZjN92UcJAczoB3jk1nMi06k1paEoyzTSEaxwTeQbIOCjbC3T-MelPOYr6mB2EVlH5n15pdV8EfQQ8jNZf4Bqc3hCKRjiqzK5wXR9l5wEX5wj9cjkOiLmZ2Fmd9shJnYtgX-c1j6l7DHo0XCnLUey-Ns3wh0ylGv6Qd9BfkIzQ70VOcuRT9jwOTs76bB8oMZNz0tAORBC8SUWkazTsFTlqL-p9QnQ3lQYma8JK8KePVzRfcahkXuhIOnq9ggTLABuIO3Q2t8rcxw_hD6aAgPjzViyvxdCJY6AQ86AJB-aRnr-XbPDEnQmMPTmvi_9YXuYpzFLqJV4t-aagzOW5N74AKM_JU2uquiqBhDa85925YYilhsj1WHranUfD-Yg6gBDR-ChQu1ilh6kUo5caGuBVeHLPOnc3n8IJnBuypJOHb5nHFvHBqIF0Qjh8NQIN2Sj2TWXrGnXNBxTkMex6cJAOzx2kwQJDFXTQ8BjXhNnGuZRGwAQUvHxaKZWscJ2ckFni39kQk2' WHERE `ID` = '38'
# [13-Nov-2022 07:41:03] /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
# [13-Nov-2022 07:41:20] /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
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `ID`,
                `PostDate`,
                `TotalPrice`,
                `Status`
            FROM
                `orders`
            WHERE
                `UserID` = 17 AND
                `Status` > :nSent

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
# [13-Nov-2022 07:41:21] /www/root/bg/ajax/users/bar.html?_=1668318081180 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:42:22] /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
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `ID`,
                `PostDate`,
                `TotalPrice`,
                `Status`
            FROM
                `orders`
            WHERE
                `UserID` = 17 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
# [13-Nov-2022 07:42:23] /www/root/bg/ajax/users/bar.html?_=1668318143246 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:52:22] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 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
# [13-Nov-2022 07:52:23] /www/root/bg/ajax/users/bar.html?_=1668318743013 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:52:56] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2
            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
# [13-Nov-2022 07:52:56] /www/root/bg/ajax/users/bar.html?_=1668318776390 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:53:26] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2
            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
# [13-Nov-2022 07:53:27] /www/root/bg/ajax/users/bar.html?_=1668318807061 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:56:27] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2
            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
# [13-Nov-2022 07:56:28] /www/root/bg/ajax/users/bar.html?_=1668318988038 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:56:53] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2
            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
# [13-Nov-2022 07:56:53] /www/root/bg/ajax/users/bar.html?_=1668319013625 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:59:17] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2
            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
# [13-Nov-2022 07:59:18] /www/root/bg/ajax/users/bar.html?_=1668319158119 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 07:59:44] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2
            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
# [13-Nov-2022 07:59:44] /www/root/bg/ajax/users/bar.html?_=1668319184561 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 08:00:18] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2
            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
# [13-Nov-2022 08:00:19] /www/root/bg/ajax/users/bar.html?_=1668319219024 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 08:01:14] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2
            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
# [13-Nov-2022 08:01:14] /www/root/bg/ajax/users/bar.html?_=1668319274916 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 08:16:31] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2
            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
# [13-Nov-2022 08:16:31] /www/root/bg/ajax/users/bar.html?_=1668320191573 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 08:16:32] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2
            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
# [13-Nov-2022 08:16:33] /www/root/bg/ajax/users/bar.html?_=1668320193229 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 08:16:48] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2
            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
# [13-Nov-2022 08:16:48] /www/root/bg/ajax/users/bar.html?_=1668320208894 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 08:19:23] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 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
# [13-Nov-2022 08:19:23] /www/root/bg/ajax/users/bar.html?_=1668320363820 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 08:19:45] /www/root/bg/поръчка/37.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` = 17 AND
                                CRC32(`UserKey`) = 3077911438 AND
                                RIGHT(`UserKey`, 1) = 1
                            LIMIT 1

SELECT
                `PostDate`,
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 37 AND
                `UserID` = 17 AND
                `Status` > 2 AND
                `Status` & 32768 /* TODO: NEGATIVE */
            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
# [13-Nov-2022 08:19:46] /www/root/bg/ajax/users/bar.html?_=1668320386110 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
# [13-Nov-2022 13:37:51] /www/root/bg/ajax/users/bar.html?_=1668339471264 167.99.142.201

set names utf8

SELECT
                                `ID`,
                                `Data`
                            FROM
                                `users`
                            WHERE
                                `ID` = 17 AND
                                CRC32(`UserKey`) = 3077911438 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
