# [03-Feb-2025 17:18:34] /mygregor/www/bg/documents/item/1.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`documents`
	    	WHERE
                `Language` = 'bg' AND
	    		`ID` = 1
         AND `Visible` = 1 LIMIT 1

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

SELECT `ModuleName`, `UserID`, `ParentID` 
        FROM `rating`
        WHERE `ParentID` = 1 AND `UserID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'

SELECT
            ParentID,
            AVG(Vote) AS AverageVote
        FROM
            `rating`
        GROUP BY
            ParentID;

SELECT `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` ASC

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

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

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

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'bg'
	    	WHERE
                `products`.`ParentID` = 18 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'bg' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `product_texts`.`FooterLabel`,
                CONCAT(`pages`.`URLLabel`, '/', `product_texts`.`URLLabel`) AS `URL`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID` AND `pages`.`Language` = 'bg'
	    	WHERE
                `products`.`ParentID` = 12 AND
                `products`.`Gallery` != '' AND
                `product_texts`.`Language` = 'bg' AND
                `product_texts`.`FooterLabel` != ''
         AND `products`.`Visible` = 1 ORDER BY `products`.`PostDate` ASC, `products`.`LastUpdate` ASC

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`,
                `NoIndex`
            FROM
                `pages`
            WHERE
                `ParentID` = 1000 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `FooterLabel`,
                `URLLabel`,
                `ExternalURL`,
                `NoIndex`
            FROM
                `pages`
            WHERE
                `ParentID` = 10010 AND
                `Module` IN ('pages', 'products') AND
                `FooterLabel` <> '' AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `ParentID` ASC, `PostDate` ASC LIMIT 10

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMyGregorAddress','LSupportText1','LSupportText2','SupportEMail','LPhone','SupportPhone','
        ') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Feb-2025 17:18:34] /mygregor/www/bg/ajax/basket/qty.html?_=1738595913615 167.99.142.201

set names utf8

SELECT
                    `Qty`
                FROM
                    `basket`
                WHERE
                    `ClientID` = '7cd1a093616c7fc511288a4b77b0e2abd739c649bc61e31a69349f7224e9d8a7'
                 LIMIT 1
# [03-Feb-2025 17:18:34] /mygregor/www/bg/ajax/users/bar.html?_=1738595913614 167.99.142.201
# [03-Feb-2025 17:18:34] /mygregor/www/bg/ajax/geolocation/languages.html?_=1738595913615 167.99.142.201

set names utf8

SELECT `Language`, `Label` FROM `languages` WHERE `Visible` = 1 ORDER BY `ID` ASC

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
