# [21-Oct-2022 11:23:07] /mygr/www/en/products.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [21-Oct-2022 11:23:08] /mygr/www/en/ajax/basket/qty.html?_=1666340597238 167.99.142.201

set names utf8

SELECT
                `Qty`
	        FROM
	        	`basket`
	    	WHERE
	    		`ClientID` = '49fc1052a119f2deff06df01c4e8cea4568032c2cd806bad906348c10d6569b8'
             LIMIT 1
# [21-Oct-2022 11:23:08] /mygr/www/en/ajax/users/bar.html?_=1666340597238 167.99.142.201

set names utf8

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

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

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

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

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

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [21-Oct-2022 11:23:08] /mygr/www/en/ajax/products/prices.html?_=1666340597238 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('2','4','6') AND
                `Language` = 'en'
# [21-Oct-2022 11:23:11] /mygr/www/en/user/register.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [21-Oct-2022 11:23:11] /mygr/www/en/ajax/users/form/register.html?_=1666340600000 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSignupEMail','LSignup') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [21-Oct-2022 11:23:11] /mygr/www/en/ajax/users/bar.html?_=1666340600001 167.99.142.201

set names utf8

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [21-Oct-2022 11:23:11] /mygr/www/en/ajax/basket/qty.html?_=1666340600001 167.99.142.201

set names utf8

SELECT
                `Qty`
	        FROM
	        	`basket`
	    	WHERE
	    		`ClientID` = '49fc1052a119f2deff06df01c4e8cea4568032c2cd806bad906348c10d6569b8'
             LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextIAgree','ErrorIAgree') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [21-Oct-2022 11:23:27] /mygr/www/en/ajax/users/register.html?_=1666340615539 167.99.142.201

set names utf8

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPassword','ErrorPasswords','ErrorFullName','ErrorPhone','ErrorIAgree') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [21-Oct-2022 11:23:47] /mygr/www/en/ajax/users/register.html?_=1666340635831 167.99.142.201

set names utf8

INSERT INTO `users`(
                `PostDate`,
                `LastUpdate`,
                `UserKey`,
                `Data`,
                `SearchKey`,
                `SortName`,
                `SortEMail`)
            VALUES (
                NOW(),
                NOW(),
                'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQa9af9bc42a96e901f1ab6bb39480aa941',
                'SASNOXHJkRvgYmIfOzg54SKlDACNz5xlowbq-zGHSYOBu7o-LCPMVAsq2jJ-_H1z_9PXSZN3tAzcpenlKmvUCAl4qPsITDtA57T09sKtzPmuJffTL_yIErW5DolaXwsCyzZFQUxfwpOoNBWNWe5WYvh1aRy1xwRSUyV3_9Bxq6A',
                'wrHCi8K6w5rCp8KewqXDwrvCn8OGw6jCscwrnCsMOcw5zCsMOZw4LDosK1wovCwrDCisKpw',
                1090121,
                1160101
            );

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'success' AND `Visible` = 1 LIMIT 1
# [21-Oct-2022 11:23:47] /mygr/www/en/user/success.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [21-Oct-2022 11:23:47] /mygr/www/en/ajax/users/bar.html?_=1666340636415 167.99.142.201

set names utf8

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

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

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

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

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

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [21-Oct-2022 11:23:47] /mygr/www/en/ajax/basket/qty.html?_=1666340636415 167.99.142.201

set names utf8

SELECT
                `Qty`
	        FROM
	        	`basket`
	    	WHERE
	    		`ClientID` = '49fc1052a119f2deff06df01c4e8cea4568032c2cd806bad906348c10d6569b8'
             LIMIT 1
# [21-Oct-2022 11:26:08] /mygr/www/en/users/api.html?u=test@mygregor.com 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQ%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [21-Oct-2022 11:26:57] /mygr/www/en/users/api.html?u=test@mygregor.com 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQ%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [21-Oct-2022 11:27:08] /mygr/www/en/users/api.html?u=test@mygregor.com 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQ%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [21-Oct-2022 14:40:30] /mygr/www/en/products.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [21-Oct-2022 14:40:33] /mygr/www/en/ajax/users/bar.html?_=1666352442707 167.99.142.201
# [21-Oct-2022 14:40:33] /mygr/www/en/ajax/basket/qty.html?_=1666352442707 167.99.142.201

set names utf8

SELECT
                `Qty`
	        FROM
	        	`basket`
	    	WHERE
	    		`ClientID` = '49fc1052a119f2deff06df01c4e8cea4568032c2cd806bad906348c10d6569b8'
             LIMIT 1

set names utf8

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

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

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

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

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

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [21-Oct-2022 14:40:34] /mygr/www/en/ajax/products/prices.html?_=1666352442708 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('2','4','6') AND
                `Language` = 'en'
# [21-Oct-2022 14:40:58] /mygr/www/ 167.99.142.201

set names utf8

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

SELECT
	        	*,
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
                `Language` = 'en' AND
                `Selected` = 1 AND
                `Gallery` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSupportText1','LSupportText2','SupportPhone','SupportEMail') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [21-Oct-2022 14:40:59] /mygr/www/en/ajax/users/bar.html?_=1666352467813 167.99.142.201

set names utf8

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

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

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

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

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

SELECT
                        `MenuLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `Module` = 'users' AND `Action` = 'register' AND `Visible` = 1 LIMIT 1
# [21-Oct-2022 14:40:59] /mygr/www/en/ajax/basket/qty.html?_=1666352467813 167.99.142.201

set names utf8

SELECT
                `Qty`
	        FROM
	        	`basket`
	    	WHERE
	    		`ClientID` = '49fc1052a119f2deff06df01c4e8cea4568032c2cd806bad906348c10d6569b8'
             LIMIT 1
# [21-Oct-2022 14:40:59] /mygr/www/en/ajax/products/prices.html?_=1666352467814 167.99.142.201

set names utf8

SELECT
                `ProductID`,
                `Price`,
                `PromoPrice`,
                 (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
            FROM
                `product_texts` WHERE `ProductID` IN ('2','4','6') AND
                `Language` = 'en'
# [21-Oct-2022 15:12:29] /mygr/www/mgVh5s90Z/en/pages/list.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1
# [21-Oct-2022 15:12:32] /mygr/www/mgVh5s90Z/en/pages/list.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Language` = 'en' AND `ParentID` = 1 AND `Module` = 'orders' LIMIT 1
# [21-Oct-2022 15:27:56] /mygr/www/bg/users/api.html?u=test@mygregor.com&p=sdflkj 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQ%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [21-Oct-2022 15:29:17] /mygr/www/bg/users/api.html?u=test@mygregor.com&p=sdflkj 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQ%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [21-Oct-2022 15:36:04] /mygr/www/bg/users/api.html?u=test@mygregor.com&p=sdflkj 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQ%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [21-Oct-2022 16:16:16] /mygr/www/en/users/api.html?u=test@mygregor.com&p=123123 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQa9af9bc42a96e901f1ab6bb39480aa94%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [21-Oct-2022 16:16:43] /mygr/www/en/users/api.html?u=test@mygregor.com&p=123123 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQa9af9bc42a96e901f1ab6bb39480aa94%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [21-Oct-2022 16:19:36] /mygr/www/en/users/api.html?u=test@mygregor.com&p=123123 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQa9af9bc42a96e901f1ab6bb39480aa94%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [21-Oct-2022 16:22:16] /mygr/www/en/users/api.html?u=test@myg--regor.com&p=123123 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8KAwoXDnsK_w4zDmsOMwp3Ct8OEwr8a9af9bc42a96e901f1ab6bb39480aa94%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [21-Oct-2022 16:22:20] /mygr/www/en/users/api.html?u=test@mygregor.com&p=123123 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw6XDm8OFwr3Dk8OJw5fCmcK9w57DgQa9af9bc42a96e901f1ab6bb39480aa94%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
