# [12-Oct-2022 06:01:07] /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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
# [12-Oct-2022 06:01:07] /www/root/bg/ajax/users/bar.html?_=1665543668484 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
# [12-Oct-2022 07:49:50] /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
# [12-Oct-2022 07:49:50] /www/root/bg/ajax/contacts/form.html?_=1665550191659 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
# [12-Oct-2022 07:49:50] /www/root/bg/ajax/users/bar.html?_=1665550191660 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
                `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
# [12-Oct-2022 07:49:52] /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
# [12-Oct-2022 07:49:52] /www/root/bg/ajax/users/bar.html?_=1665550193838 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
# [12-Oct-2022 07:49:52] /www/root/bg/ajax/products/prices.html?_=1665550193842 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')
# [12-Oct-2022 07:49:53] /www/root/bg/ajax/products/prices.html?_=1665550194628 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')
# [12-Oct-2022 07:49:53] /www/root/bg/ajax/products/prices.html?_=1665550194644 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 ('2657856658','2657856655')
# [12-Oct-2022 07:49:54] /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
# [12-Oct-2022 07:49:54] /www/root/bg/ajax/users/bar.html?_=1665550195436 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
# [12-Oct-2022 07:49:54] /www/root/bg/ajax/products/prices.html?_=1665550195437 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')
# [12-Oct-2022 07:49:56] /www/root/bg/ajax/basket/add.html?_=1665550196942 167.99.142.201

set names utf8

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

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b', 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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
# [12-Oct-2022 07:49:56] /www/root/bg/ajax/basket/qty.html?_=1665550197001 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 LIMIT 1
# [12-Oct-2022 07:57:31] /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
# [12-Oct-2022 07:57:32] /www/root/bg/ajax/users/bar.html?_=1665550653256 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
# [12-Oct-2022 07:57:32] /www/root/bg/ajax/products/prices.html?_=1665550653258 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')
# [12-Oct-2022 07:58:54] /www/root/bg/ajax/products/price/2657856655.html?_=1665550734887 167.99.142.201

set names utf8

SELECT
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `products`
            WHERE
                `ID` = 2657856655
            LIMIT 1
# [12-Oct-2022 07:58:55] /www/root/bg/ajax/basket/add.html?_=1665550736206 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTUiLCJzaXplIjoiWFMifQ":1,"eyJpZCI6IjI2NTc4NTY2NTUiLCJzZW5zb3IiOjEsInNpemUiOiJYUyJ9":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            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`,
                /* *** */
                `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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
# [12-Oct-2022 07:58:55] /www/root/bg/ajax/basket/qty.html?_=1665550736259 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 LIMIT 1
# [12-Oct-2022 07:59:47] /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
# [12-Oct-2022 07:59:47] /www/root/bg/ajax/users/bar.html?_=1665550788757 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
# [12-Oct-2022 07:59:47] /www/root/bg/ajax/products/prices.html?_=1665550788758 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')
# [12-Oct-2022 08:02:12] /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
# [12-Oct-2022 08:02:13] /www/root/bg/ajax/users/bar.html?_=1665550934340 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
# [12-Oct-2022 08:02:13] /www/root/bg/ajax/products/prices.html?_=1665550934342 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')
# [12-Oct-2022 08:02:19] /www/root/bg/ajax/basket/add.html?_=1665550940423 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTUiLCJzaXplIjoiWFMifQ":1,"eyJpZCI6IjI2NTc4NTY2NTUiLCJzZW5zb3IiOjEsInNpemUiOiJYUyJ9":3}',
                                `Qty` = 4
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            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`,
                /* *** */
                `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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
# [12-Oct-2022 08:02:19] /www/root/bg/ajax/basket/qty.html?_=1665550940482 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 LIMIT 1
# [12-Oct-2022 08:02:32] /www/root/bg/ajax/basket/replace.html?_=1665550953792 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTUiLCJzaXplIjoiWFMifQ":1}',
                                `Qty` = 1
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            LIMIT 1

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTUiLCJzaXplIjoiWFMifQ":1,"eyJpZCI6IjI2NTc4NTY2NTkiLCJzZW5zb3IiOjF9":3}',
                                `Qty` = 4
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            LIMIT 1
# [12-Oct-2022 08:02:45] /www/root/bg/ajax/basket/update.html?_=1665550966397 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTUiLCJzaXplIjoiWFMifQ":1,"eyJpZCI6IjI2NTc4NTY2NTkiLCJzZW5zb3IiOjF9":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            LIMIT 1
# [12-Oct-2022 08:02:45] /www/root/bg/ajax/basket/update.html?_=1665550966535 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTUiLCJzaXplIjoiWFMifQ":1,"eyJpZCI6IjI2NTc4NTY2NTkiLCJzZW5zb3IiOjF9":1,"eyJpZCI6IjI2NTc4NTY2NTYifQ":1}',
                                `Qty` = 3
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            LIMIT 1
# [12-Oct-2022 08:02:48] /www/root/bg/ajax/basket/remove.html?_=1665550969607 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTUiLCJzaXplIjoiWFMifQ":1,"eyJpZCI6IjI2NTc4NTY2NTkiLCJzZW5zb3IiOjF9":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            LIMIT 1
# [12-Oct-2022 08:02:51] /www/root/bg/ajax/basket/update.html?_=1665550972127 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTUiLCJzaXplIjoiWFMifQ":1,"eyJpZCI6IjI2NTc4NTY2NTkiLCJzZW5zb3IiOjF9":1,"eyJpZCI6IjI2NTc4NTY2NTYifQ":1}',
                                `Qty` = 3
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            LIMIT 1
# [12-Oct-2022 08:02:56] /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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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','2657856659','2657856656') AND
                `Visible` = 1

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LDelivery','LDeliveryToAddress','LDeliveryToOffice','LCountry','LProvince','LTown','LPostalCode','LDeliveryAddress','LDeliveryAddressDetails','LDeliveryOfficeAddress','LDeliveryComment','LPayOnDelivery') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceNeed','LInvoiceComany','LInvoiceNumber','LInvoiceVATNumber','LVATRegistration','LInvoiceAddress','LInvoicePerson') 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
# [12-Oct-2022 08:02:57] /www/root/bg/ajax/users/bar.html?_=1665550978113 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
# [12-Oct-2022 08:02:57] /www/root/bg/ajax/basket/qty.html?_=1665550978115 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 LIMIT 1
# [12-Oct-2022 08:02:59] /www/root/bg/ajax/basket/remove.html?_=1665550980294 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTUiLCJzaXplIjoiWFMifQ":1,"eyJpZCI6IjI2NTc4NTY2NTkiLCJzZW5zb3IiOjF9":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            LIMIT 1
# [12-Oct-2022 08:02:59] /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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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','2657856659') AND
                `Visible` = 1

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LDelivery','LDeliveryToAddress','LDeliveryToOffice','LCountry','LProvince','LTown','LPostalCode','LDeliveryAddress','LDeliveryAddressDetails','LDeliveryOfficeAddress','LDeliveryComment','LPayOnDelivery') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceNeed','LInvoiceComany','LInvoiceNumber','LInvoiceVATNumber','LVATRegistration','LInvoiceAddress','LInvoicePerson') 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
# [12-Oct-2022 08:02:59] /www/root/bg/ajax/basket/qty.html?_=1665550980701 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 LIMIT 1
# [12-Oct-2022 08:02:59] /www/root/bg/ajax/users/bar.html?_=1665550980700 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
# [12-Oct-2022 08:03:00] /www/root/bg/ajax/basket/remove.html?_=1665550981774 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTUiLCJzaXplIjoiWFMifQ":1}',
                                `Qty` = 1
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            LIMIT 1
# [12-Oct-2022 08:03:00] /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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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') AND
                `Visible` = 1

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LDelivery','LDeliveryToAddress','LDeliveryToOffice','LCountry','LProvince','LTown','LPostalCode','LDeliveryAddress','LDeliveryAddressDetails','LDeliveryOfficeAddress','LDeliveryComment','LPayOnDelivery') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceNeed','LInvoiceComany','LInvoiceNumber','LInvoiceVATNumber','LVATRegistration','LInvoiceAddress','LInvoicePerson') 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
# [12-Oct-2022 08:03:01] /www/root/bg/ajax/users/bar.html?_=1665550982186 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
# [12-Oct-2022 08:03:01] /www/root/bg/ajax/basket/qty.html?_=1665550982187 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 LIMIT 1
# [12-Oct-2022 08:03:03] /www/root/bg/ajax/basket/remove.html?_=1665550984006 167.99.142.201

set names utf8

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

DELETE FROM `basket` WHERE `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' LIMIT 1
# [12-Oct-2022 08:03: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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
# [12-Oct-2022 08:03:03] /www/root/bg/ajax/users/bar.html?_=1665550984399 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
# [12-Oct-2022 08:03:03] /www/root/bg/ajax/basket/qty.html?_=1665550984399 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 LIMIT 1
# [12-Oct-2022 08:03:05] /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
# [12-Oct-2022 08:03:05] /www/root/bg/ajax/users/bar.html?_=1665550986396 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
# [12-Oct-2022 08:03:05] /www/root/bg/ajax/basket/qty.html?_=1665550986396 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 LIMIT 1
# [12-Oct-2022 08:03:06] /www/root/bg/ajax/products/prices.html?_=1665550987389 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')
# [12-Oct-2022 08:03:07] /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
# [12-Oct-2022 08:03:07] /www/root/bg/ajax/users/bar.html?_=1665550988627 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
# [12-Oct-2022 08:03:07] /www/root/bg/ajax/basket/qty.html?_=1665550988628 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 LIMIT 1
# [12-Oct-2022 08:03:07] /www/root/bg/ajax/products/prices.html?_=1665550988629 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')
# [12-Oct-2022 08:03:10] /www/root/bg/ajax/products/price/2657856655.html?_=1665550990991 167.99.142.201

set names utf8

SELECT
                `Price`,
                `PromoPrice`,
                `SensorPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `products`
            WHERE
                `ID` = 2657856655
            LIMIT 1
# [12-Oct-2022 08:03:10] /www/root/bg/ajax/basket/add.html?_=1665550991662 167.99.142.201

set names utf8

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

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b', NOW(), NOW(), '{"eyJpZCI6IjI2NTc4NTY2NTUiLCJzZW5zb3IiOjEsInNpemUiOiJYUyJ9":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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
# [12-Oct-2022 08:03:10] /www/root/bg/ajax/basket/qty.html?_=1665550991715 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 LIMIT 1
# [12-Oct-2022 08:03:16] /www/root/bg/ajax/basket/replace.html?_=1665550997544 167.99.142.201

set names utf8

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

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

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

INSERT INTO  `basket`
                            (`ClientID`, `PostDate`, `LastUpdate`, `Data`, `Qty`) VALUES
                            ('fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b', NOW(), NOW(), '{"eyJpZCI6IjI2NTc4NTY2NTkiLCJzZW5zb3IiOjF9":1}', 1)
# [12-Oct-2022 08:03:19] /www/root/bg/ajax/basket/update.html?_=1665550999904 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTkiLCJzZW5zb3IiOjF9":1,"eyJpZCI6IjI2NTc4NTY2NTgifQ":1}',
                                `Qty` = 2
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            LIMIT 1
# [12-Oct-2022 08:03:21] /www/root/bg/ajax/basket/update.html?_=1665551002215 167.99.142.201

set names utf8

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

UPDATE
                                `basket`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"eyJpZCI6IjI2NTc4NTY2NTkiLCJzZW5zb3IiOjF9":2,"eyJpZCI6IjI2NTc4NTY2NTgifQ":1}',
                                `Qty` = 3
                            WHERE
                                `ClientID`= 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                            LIMIT 1
# [12-Oct-2022 08:03:25] /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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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','2657856658') AND
                `Visible` = 1

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LName','LPhone','LEMail','LDelivery','LDeliveryToAddress','LDeliveryToOffice','LCountry','LProvince','LTown','LPostalCode','LDeliveryAddress','LDeliveryAddressDetails','LDeliveryOfficeAddress','LDeliveryComment','LPayOnDelivery') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceNeed','LInvoiceComany','LInvoiceNumber','LInvoiceVATNumber','LVATRegistration','LInvoiceAddress','LInvoicePerson') 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
# [12-Oct-2022 08:03:25] /www/root/bg/ajax/users/bar.html?_=1665551006464 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
# [12-Oct-2022 08:03:25] /www/root/bg/ajax/basket/qty.html?_=1665551006466 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b'
                 LIMIT 1
# [12-Oct-2022 09:48:54] /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
# [12-Oct-2022 09:48:55] /www/root/bg/ajax/users/bar.html?_=1665557339722 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
# [12-Oct-2022 09:48:55] /www/root/bg/ajax/products/prices.html?_=1665557339723 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')
# [12-Oct-2022 13:49:47] /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
# [12-Oct-2022 13:49:48] /www/root/bg/ajax/users/bar.html?_=1665571793280 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
# [12-Oct-2022 13:49:48] /www/root/bg/ajax/contacts/form.html?_=1665571793279 167.99.142.201

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('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
# [12-Oct-2022 13:49:49] /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
# [12-Oct-2022 13:49:49] /www/root/bg/ajax/users/bar.html?_=1665571794762 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
# [12-Oct-2022 13:49:49] /www/root/bg/ajax/products/prices.html?_=1665571794763 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','2657856657','2657856658','2657856655')
# [12-Oct-2022 13:49:50] /www/root/bg/поръчка.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'поръчка' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '') AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        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` = '0ff2675e182854b27b5c0ba1475ac125b4f959e81649088051158142bd77f786' 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','2657856655') AND
                `Visible` = 1

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

SELECT `PromoCodeID` FROM `basket` WHERE `ClientID` = '0ff2675e182854b27b5c0ba1475ac125b4f959e81649088051158142bd77f786' 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') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LInvoice','LInvoiceNeed','LInvoiceComany','LInvoiceNumber','LInvoiceVATNumber','LVATRegistration','LInvoiceAddress','LInvoicePerson') 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
# [12-Oct-2022 13:49:50] /www/root/bg/ajax/users/bar.html?_=1665571795848 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
