# [02-Dec-2022 07:14: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
# [02-Dec-2022 07:14:47] /www/root/bg/ajax/contacts/form.html?_=1669958087941 167.99.142.201

set names utf8

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Dec-2022 07:14:47] /www/root/bg/ajax/users/bar.html?_=1669958087942 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
# [02-Dec-2022 07:14:47] /www/root/bg/ajax/basket/qty.html?_=1669958087942 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = '0ca66bcca4b1a07b7112836b9bb0674ca3578b0fd0503c9a8dfc0580bdce4333'
                 LIMIT 1
# [02-Dec-2022 07:14:50] /www/root/sitemap.xml 167.99.142.201

set names utf8

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

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

set names utf8

SELECT
                    `pages`.`Module`,
                    `pages`.`URLLabel`,
                    `pages`.`LastUpdate`,
                        `en`.`URLLabel` AS `enURLLabel`,
                        `en`.`LastUpdate` AS `enLastUpdate`
                     FROM `pages` 
                    LEFT JOIN `pages` AS `en` ON
                        `pages`.`ID` = `en`.`ID` AND
                        `en`.`NoIndex` = 0 AND
                        (`en`.`ExternalURL` = '' OR `en`.`ExternalURL` IS NULL) AND
                        `en`.`Language` = 'en' AND
                        `en`.`Visible` = 1
                    WHERE
                    `pages`.`NoIndex` = 0 AND
                    (`pages`.`ExternalURL` = '' OR `pages`.`ExternalURL` IS NULL) AND
                    `pages`.`Language` = 'bg' AND
                    `pages`.`Visible` = 1
                ORDER BY
                    `pages`.`PostDate` ASC

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

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

set names utf8

SELECT
                    `pages`.`Module`,
                    `pages`.`URLLabel`,
                    `pages`.`LastUpdate`,
                        `en`.`URLLabel` AS `enURLLabel`,
                        `en`.`LastUpdate` AS `enLastUpdate`
                     FROM `pages` 
                    LEFT JOIN `pages` AS `en` ON
                        `pages`.`ID` = `en`.`ID` AND
                        `en`.`NoIndex` = 0 AND
                        (`en`.`ExternalURL` = '' OR `en`.`ExternalURL` IS NULL) AND
                        `en`.`Language` = 'en' AND
                        `en`.`Visible` = 1
                    WHERE
                    `pages`.`NoIndex` = 0 AND
                    (`pages`.`ExternalURL` = '' OR `pages`.`ExternalURL` IS NULL) AND
                    `pages`.`Language` = 'bg' AND
                    `pages`.`Visible` = 1
                ORDER BY
                    `pages`.`PostDate` ASC

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

SELECT
                `URLLabel`,
                `LastUpdate`
            FROM
                `products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
# [02-Dec-2022 08:02:04] /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
# [02-Dec-2022 08:02:04] /www/root/bg/ajax/contacts/form.html?_=1669960924669 167.99.142.201

set names utf8

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [02-Dec-2022 08:02:04] /www/root/bg/ajax/users/bar.html?_=1669960924671 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
# [02-Dec-2022 08:02:04] /www/root/bg/ajax/basket/qty.html?_=1669960924671 167.99.142.201

set names utf8

SELECT
                    `Qty`
    	        FROM
    	        	`basket`
    	    	WHERE
    	    		`ClientID` = '0ca66bcca4b1a07b7112836b9bb0674ca3578b0fd0503c9a8dfc0580bdce4333'
                 LIMIT 1
# [02-Dec-2022 08:02:08] /www/root/sitemap.xml 167.99.142.201

set names utf8

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

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

set names utf8

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

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