# [24-Feb-2024 07:51:33] /micromax/www/ 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 07:51:34] /micromax/www/bg/ajax/cookies.html?_=1708753896173 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 07:51:37] /micromax/www/bg/контакти.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'контакти' AND
                -- `ParentID` = 1 AND // TODO: FULL TEST
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'contacts' AND
	    		`URLLabel` = 'контакти'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'контакти' AND
                P1.`Visible` = 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'контакти'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'контакти'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 07:51:38] /micromax/www/bg/ajax/contacts/form.html?_=1708753900014 108.61.209.243
# [24-Feb-2024 07:51:38] /micromax/www/bg/ajax/cookies.html?_=1708753900015 108.61.209.243

set names utf8

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`Module` = 'terms' AND
	`Language` = 'bg' 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 07:51:39] /micromax/www/bg/магазини.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'магазини' AND
                -- `ParentID` = 1 AND // TODO: FULL TEST
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'stores' AND
	    		`URLLabel` = 'магазини'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'магазини' AND
                P1.`Visible` = 1

SELECT
                `S2`.*,
                (SELECT COUNT(`S1`.`Town`) FROM `stores` AS `S1` WHERE `S1`.`Town` = `S2`.`Town`) AS `Count`
            FROM
                `stores` AS `S2`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1
            GROUP BY
                `S2`.`ID`,
                `S2`.`Language`
            ORDER BY
                `Count` DESC,
                `Town` ASC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'магазини'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'магазини'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 07:51:40] /micromax/www/bg/ajax/cookies.html?_=1708753902100 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 07:51:53] /micromax/www/bg/index.html 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 07:51:58] /micromax/www/bg/search.html?q=test 108.61.209.243

set names utf8

SELECT `Content` FROM `pages` WHERE`Module` = 'search' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 07:53:24] /micromax/www/bg/search.html?q=test 108.61.209.243

set names utf8

SELECT `Content` FROM `pages` WHERE`Module` = 'search' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `pages`.`MetaTitle`,
                `pages`.`MetaDescription`,
                `pages`.`URLLabel`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `Parent`.`Language` = 'bg' AND
                    `Parent`.`ParentID` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (
                    `pages`.`MenuLabel` LIKE '%test%' OR
                    `pages`.`FooterLabel` LIKE '%test%' OR
                    `pages`.`Annotation` LIKE '%test%' OR
                    `pages`.`Content` LIKE '%test%'
                ) AND
                `pages`.`Visible` = 1
            ORDER BY CASE
                WHEN `pages`.`MenuLabel` LIKE 'test%' THEN 0
                WHEN `pages`.`FooterLabel` LIKE 'test%' THEN 1
                WHEN `pages`.`MenuLabel` LIKE '% test%' THEN 2
                WHEN `pages`.`FooterLabel` LIKE '% test%' THEN 3
                ELSE 4
            END

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 07:54:27] /micromax/www/bg/search.html?q=test 108.61.209.243

set names utf8

SELECT `Content` FROM `pages` WHERE`Module` = 'search' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `pages`.`MetaTitle`,
                `pages`.`MetaDescription`,
                `pages`.`URLLabel`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `Parent`.`Language` = 'bg' AND
                    `Parent`.`ParentID` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (
                    `pages`.`MenuLabel` LIKE '%test%' OR
                    `pages`.`FooterLabel` LIKE '%test%' OR
                    `pages`.`Annotation` LIKE '%test%' OR
                    `pages`.`Content` LIKE '%test%'
                ) AND
                `pages`.`Visible` = 1
            ORDER BY CASE
                WHEN `pages`.`MenuLabel` LIKE 'test%' THEN 0
                WHEN `pages`.`FooterLabel` LIKE 'test%' THEN 1
                WHEN `pages`.`MenuLabel` LIKE '% test%' THEN 2
                WHEN `pages`.`FooterLabel` LIKE '% test%' THEN 3
                ELSE 4
            END

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:00:48] /micromax/www/bg/search.html?q=test 108.61.209.243

set names utf8

SELECT `Content` FROM `pages` WHERE`Module` = 'search' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `pages`.`MetaTitle`,
                `pages`.`MetaDescription`,
                `pages`.`URLLabel`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `Parent`.`Language` = 'bg' AND
                    `Parent`.`ParentID` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (
                    `pages`.`MenuLabel` LIKE '%test%' OR
                    `pages`.`FooterLabel` LIKE '%test%' OR
                    `pages`.`Annotation` LIKE '%test%' OR
                    `pages`.`Content` LIKE '%test%'
                ) AND
                `pages`.`Visible` = 1
            ORDER BY CASE
                WHEN `pages`.`MenuLabel` LIKE 'test%' THEN 0
                WHEN `pages`.`FooterLabel` LIKE 'test%' THEN 1
                WHEN `pages`.`MenuLabel` LIKE '% test%' THEN 2
                WHEN `pages`.`FooterLabel` LIKE '% test%' THEN 3
                ELSE 4
            END

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:02:34] /micromax/www/bg/search.html?q=test 108.61.209.243

set names utf8

SELECT `Content` FROM `pages` WHERE`Module` = 'search' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `pages`.`MetaTitle`,
                `pages`.`MetaDescription`,
                `pages`.`URLLabel`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `Parent`.`Language` = 'bg' AND
                    `Parent`.`ParentID` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (
                    `pages`.`MenuLabel` LIKE '%test%' OR
                    `pages`.`FooterLabel` LIKE '%test%' OR
                    `pages`.`Annotation` LIKE '%test%' OR
                    `pages`.`Content` LIKE '%test%'
                ) AND
                `pages`.`Visible` = 1
            ORDER BY CASE
                WHEN `pages`.`MenuLabel` LIKE 'test%' THEN 0
                WHEN `pages`.`FooterLabel` LIKE 'test%' THEN 1
                WHEN `pages`.`MenuLabel` LIKE '% test%' THEN 2
                WHEN `pages`.`FooterLabel` LIKE '% test%' THEN 3
                ELSE 4
            END

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:03:53] /micromax/www/mCWo2ejc8QC/bg/ajax/users/login.html?_=1708754635233 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vDksOjw4LCpcODw5HDjcOBw6zCs8K-w43DlsObwp7CtsK9%'
            LIMIT 1
# [24-Feb-2024 08:03:53] /micromax/www/mCWo2ejc8QC/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` IS NULL, `pages`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`)) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`PostDate` ASC
# [24-Feb-2024 08:03:58] /micromax/www/mCWo2ejc8QC/bg/ajax/pages/form.html?_=1708754640750 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `MenuLabel` <> '' AND
                `ParentID` = 1
# [24-Feb-2024 08:04:07] /micromax/www/mCWo2ejc8QC/bg/ajax/pages/upload/8754638963.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [24-Feb-2024 08:04:10] /micromax/www/mCWo2ejc8QC/bg/ajax/pages/urllabel.html?URLLabel=dGVzdA&_=1708754652691 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [24-Feb-2024 08:04:11] /micromax/www/mCWo2ejc8QC/bg/ajax/pages/urllabel.html?URLLabel=dGVzdA&_=1708754653148 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [24-Feb-2024 08:04:17] /micromax/www/mCWo2ejc8QC/bg/ajax/pages/upload/8754638963.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [24-Feb-2024 08:04:24] /micromax/www/mCWo2ejc8QC/bg/ajax/pages/upload/8754638963.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [24-Feb-2024 08:04:28] /micromax/www/mCWo2ejc8QC/bg/ajax/pages/insert.html?_=1708754670241 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `pages`

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

INSERT INTO `pages` SET `ID` = '33', `Language` = 'bg', `PostDate` = '2024-02-24', `LastUpdate` = '2024-02-24 08:04:28', `UploadID` = '8754638963', `MetaTitle` = 'test', `MetaDescription` = 'test', `MetaImage` = 'teslax.jpg', `NoIndex` = 0, `MenuLabel` = 'test', `FooterLabel` = 'test', `URLLabel` = 'test', `Annotation` = '<img src="/micromax/www/uf/pages/8754638963/i_house.jpg">', `Content` = '<img src="/micromax/www/uf/pages/8754638963/i_house1.jpg">', `AddContent` = '', `AddOn` = '', `Visible` = 1, `ParentID` = 1, `Module` = 'pages'
# [24-Feb-2024 08:04:28] /micromax/www/mCWo2ejc8QC/bg/test.html 108.61.209.243

set names utf8

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

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'test' AND
                -- `ParentID` = 1 AND // TODO: FULL TEST
                (`Action` IS NULL OR `Action` = '')
         LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'test'
         LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'test' AND
                P1.`Visible` = 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'test'
	    	WHERE
                P1.`Language` = 'bg'
         LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'test'
	    	WHERE
                P1.`Language` = 'en'
         LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:04:31] /micromax/www/mCWo2ejc8QC/bg/ajax/pages/form/33.html?_=1708754673318 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 33 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `MenuLabel` <> '' AND
                `ParentID` = 1
         AND `ID` != 33
# [24-Feb-2024 08:04:52] /micromax/www/mCWo2ejc8QC/bg/documents/list.html 108.61.209.243

set names utf8

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

SELECT
                `documents`.*,
                `pages`.`MenuLabel` AS `Page`
            FROM
                `documents`
                INNER JOIN `pages` ON `pages`.`ID` = `documents`.`PageID` AND `pages`.`Language` = `documents`.`Language`
            WHERE
                `documents`.`Language` = 'bg'
         ORDER BY `documents`.`PostDate` ASC
# [24-Feb-2024 08:04:54] /micromax/www/mCWo2ejc8QC/bg/ajax/documents/form/1.html?_=1708754696195 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `MenuLabel` AS `Label`
            FROM
                `pages`
            WHERE
                `MenuLabel` <> '' AND
                `Language` = 'bg'
# [24-Feb-2024 08:04:58] /micromax/www/mCWo2ejc8QC/bg/ajax/documents/update/1.html?_=1708754699851 108.61.209.243

set names utf8

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

SELECT * FROM `documents` LIMIT 1

SHOW COLUMNS FROM `documents`

UPDATE `documents` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2024-02-23', `LastUpdate` = '2024-02-24 08:04:58', `UploadID` = '8697282797', `PageID` = '1', `FileName` = 'seo-content.pdf', `Title` = '1234123421 test', `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [24-Feb-2024 08:04:58] /micromax/www/mCWo2ejc8QC/bg/documents/list.html 108.61.209.243

set names utf8

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

SELECT
                `documents`.*,
                `pages`.`MenuLabel` AS `Page`
            FROM
                `documents`
                INNER JOIN `pages` ON `pages`.`ID` = `documents`.`PageID` AND `pages`.`Language` = `documents`.`Language`
            WHERE
                `documents`.`Language` = 'bg'
         ORDER BY `documents`.`PostDate` ASC
# [24-Feb-2024 08:05:03] /micromax/www/mCWo2ejc8QC/bg/stores/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `Town`,
                `Address`,
                `Visible`
            FROM
                `stores`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `Town`,
                `Address`,
                `Visible`
            FROM
                `stores`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [24-Feb-2024 08:05:05] /micromax/www/mCWo2ejc8QC/bg/ajax/stores/form/1.html?_=1708754707512 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `stores`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [24-Feb-2024 08:05:58] /micromax/www/mCWo2ejc8QC/bg/ajax/stores/update/1.html?_=1708754760378 108.61.209.243

set names utf8

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

SELECT * FROM `stores` LIMIT 1

SHOW COLUMNS FROM `stores`

UPDATE `stores` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2024-02-23', `LastUpdate` = '2024-02-24 08:05:58', `Title` = 'Schaeffler REPXPERT test', `Town` = 'София', `Address` = 'Адрес 213', `Phones` = '0888 888 888 ', `EMail` = 'davarski@gmail.com', `OpeningHours` = 'Понеделник - петък 9:00 - 18:30
Събота и неделя почивни дни', `Latitude` = '13.41234207153320', `Longitude` = '13.54234504699707', `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [24-Feb-2024 08:05:58] /micromax/www/mCWo2ejc8QC/bg/stores/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `Town`,
                `Address`,
                `Visible`
            FROM
                `stores`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Title`,
                `Town`,
                `Address`,
                `Visible`
            FROM
                `stores`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [24-Feb-2024 08:06:00] /micromax/www/mCWo2ejc8QC/bg/ajax/stores/form/1.html?_=1708754762662 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `stores`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [24-Feb-2024 08:06:10] /micromax/www/mCWo2ejc8QC/bg/ajax/users/logout.html?_=1708754771856 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [24-Feb-2024 08:06:10] /micromax/www/ 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:06:14] /micromax/www/bg/search.html?q=тест 108.61.209.243

set names utf8

SELECT `Content` FROM `pages` WHERE`Module` = 'search' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `pages`.`MetaTitle`,
                `pages`.`MetaDescription`,
                `pages`.`URLLabel`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `Parent`.`Language` = 'bg' AND
                    `Parent`.`ParentID` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (
                    `pages`.`MenuLabel` LIKE '%тест%' OR
                    `pages`.`FooterLabel` LIKE '%тест%' OR
                    `pages`.`Annotation` LIKE '%тест%' OR
                    `pages`.`Content` LIKE '%тест%'
                ) AND
                `pages`.`Visible` = 1
            ORDER BY CASE
                WHEN `pages`.`MenuLabel` LIKE 'тест%' THEN 0
                WHEN `pages`.`FooterLabel` LIKE 'тест%' THEN 1
                WHEN `pages`.`MenuLabel` LIKE '% тест%' THEN 2
                WHEN `pages`.`FooterLabel` LIKE '% тест%' THEN 3
                ELSE 4
            END

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:07:12] /micromax/www/bg/search.html?q=test 108.61.209.243

set names utf8

SELECT `Content` FROM `pages` WHERE`Module` = 'search' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `pages`.`MetaTitle`,
                `pages`.`MetaDescription`,
                `pages`.`URLLabel`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `Parent`.`Language` = 'bg' AND
                    `Parent`.`ParentID` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (
                    `pages`.`MenuLabel` LIKE '%test%' OR
                    `pages`.`FooterLabel` LIKE '%test%' OR
                    `pages`.`Annotation` LIKE '%test%' OR
                    `pages`.`Content` LIKE '%test%'
                ) AND
                `pages`.`Visible` = 1
            ORDER BY CASE
                WHEN `pages`.`MenuLabel` LIKE 'test%' THEN 0
                WHEN `pages`.`FooterLabel` LIKE 'test%' THEN 1
                WHEN `pages`.`MenuLabel` LIKE '% test%' THEN 2
                WHEN `pages`.`FooterLabel` LIKE '% test%' THEN 3
                ELSE 4
            END

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:07:16] /micromax/www/bg/test.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'test' AND
                -- `ParentID` = 1 AND // TODO: FULL TEST
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'test' AND
                P1.`Visible` = 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'test'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'test'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:07:21] /micromax/www/bg/search.html?q=test 108.61.209.243

set names utf8

SELECT `Content` FROM `pages` WHERE`Module` = 'search' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `pages`.`MetaTitle`,
                `pages`.`MetaDescription`,
                `pages`.`URLLabel`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `Parent`.`Language` = 'bg' AND
                    `Parent`.`ParentID` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (
                    `pages`.`MenuLabel` LIKE '%test%' OR
                    `pages`.`FooterLabel` LIKE '%test%' OR
                    `pages`.`Annotation` LIKE '%test%' OR
                    `pages`.`Content` LIKE '%test%'
                ) AND
                `pages`.`Visible` = 1
            ORDER BY CASE
                WHEN `pages`.`MenuLabel` LIKE 'test%' THEN 0
                WHEN `pages`.`FooterLabel` LIKE 'test%' THEN 1
                WHEN `pages`.`MenuLabel` LIKE '% test%' THEN 2
                WHEN `pages`.`FooterLabel` LIKE '% test%' THEN 3
                ELSE 4
            END

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:09:03] /micromax/www/bg/search.html?q=test 108.61.209.243

set names utf8

SELECT `Content` FROM `pages` WHERE`Module` = 'search' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `pages`.`MetaTitle`,
                `pages`.`MetaDescription`,
                `pages`.`URLLabel`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `Parent`.`Language` = 'bg' AND
                    `Parent`.`ParentID` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (
                    `pages`.`MenuLabel` LIKE '%test%' OR
                    `pages`.`FooterLabel` LIKE '%test%' OR
                    `pages`.`Annotation` LIKE '%test%' OR
                    `pages`.`Content` LIKE '%test%'
                ) AND
                `pages`.`Visible` = 1
            ORDER BY CASE
                WHEN `pages`.`MenuLabel` LIKE 'test%' THEN 0
                WHEN `pages`.`FooterLabel` LIKE 'test%' THEN 1
                WHEN `pages`.`MenuLabel` LIKE '% test%' THEN 2
                WHEN `pages`.`FooterLabel` LIKE '% test%' THEN 3
                ELSE 4
            END

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `UploadID`,
                `FileName`
            FROM
                `documents`
            WHERE
                `Language` = 'bg' AND
                (
                    `MetaTitle` LIKE '%test%' OR
                    `MetaDescription` LIKE '%test%' OR
                    `MetaKeywords` LIKE '%test%'
                ) AND
                `Visible` = 1
            ORDER BY CASE
                WHEN `MetaTitle` LIKE 'test%' THEN 0
                WHEN `MetaDescription` LIKE 'test%' THEN 1
                WHEN `MetaTitle` LIKE '% test%' THEN 2
                WHEN `MetaDescription` LIKE '% test%' THEN 3
                ELSE 4
            END
# [24-Feb-2024 08:33:24] /micromax/www/mCWo2ejc8QC/bg/ajax/users/login.html?_=1708756406142 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vDksOjw4LCpcODw5HDjcOBw6zCs8K-w43DlsObwp7CtsK9%'
            LIMIT 1
# [24-Feb-2024 08:33:24] /micromax/www/mCWo2ejc8QC/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` IS NULL, `pages`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`)) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`PostDate` ASC
# [24-Feb-2024 08:33:28] /micromax/www/mCWo2ejc8QC/bg/documents/list.html 108.61.209.243

set names utf8

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

SELECT
                `documents`.*,
                `pages`.`MenuLabel` AS `Page`
            FROM
                `documents`
                INNER JOIN `pages` ON `pages`.`ID` = `documents`.`PageID` AND `pages`.`Language` = `documents`.`Language`
            WHERE
                `documents`.`Language` = 'bg'
         ORDER BY `documents`.`PostDate` ASC
# [24-Feb-2024 08:33:30] /micromax/www/mCWo2ejc8QC/bg/ajax/documents/form.html?_=1708756411892 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `MenuLabel` AS `Label`
            FROM
                `pages`
            WHERE
                `MenuLabel` <> '' AND
                `Language` = 'bg'
# [24-Feb-2024 08:33:53] /micromax/www/mCWo2ejc8QC/bg/documents/list.html 108.61.209.243

set names utf8

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

SELECT
                `documents`.*,
                `pages`.`MenuLabel` AS `Page`
            FROM
                `documents`
                INNER JOIN `pages` ON `pages`.`ID` = `documents`.`PageID` AND `pages`.`Language` = `documents`.`Language`
            WHERE
                `documents`.`Language` = 'bg'
         ORDER BY `documents`.`PostDate` ASC
# [24-Feb-2024 08:33:55] /micromax/www/mCWo2ejc8QC/bg/ajax/documents/form.html?_=1708756437517 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `ParentID`,
                `Module`,
                `MenuLabel` AS `Label`
            FROM
                `pages`
            WHERE
                `MenuLabel` <> '' AND
                `Language` = 'bg'
# [24-Feb-2024 08:34:26] /micromax/www/mCWo2ejc8QC/bg/ajax/documents/upload/8756435730.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [24-Feb-2024 08:34:39] /micromax/www/mCWo2ejc8QC/bg/ajax/documents/insert.html?_=1708756480872 108.61.209.243

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `documents`

SELECT * FROM `documents` LIMIT 1

SHOW COLUMNS FROM `documents`

INSERT INTO `documents` SET `ID` = 1, `Language` = 'bg', `PostDate` = '2024-02-24', `LastUpdate` = '2024-02-24 08:34:39', `UploadID` = '8756435730', `PageID` = '33', `MetaTitle` = 'Документи', `MetaDescription` = 'Документи test', `MetaKeywords` = 'test ala bala', `FileName` = '240222-ooyesbg.pdf', `Title` = 'Нова, персонализирана услуга - „Управление на индивидуален портфейл“', `Visible` = 1
# [24-Feb-2024 08:34:39] /micromax/www/mCWo2ejc8QC/bg/documents/list.html 108.61.209.243

set names utf8

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

SELECT
                `documents`.*,
                `pages`.`MenuLabel` AS `Page`
            FROM
                `documents`
                INNER JOIN `pages` ON `pages`.`ID` = `documents`.`PageID` AND `pages`.`Language` = `documents`.`Language`
            WHERE
                `documents`.`Language` = 'bg'
         ORDER BY `documents`.`PostDate` ASC
# [24-Feb-2024 08:34:46] /micromax/www/mCWo2ejc8QC/bg/ajax/users/logout.html?_=1708756488463 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [24-Feb-2024 08:34:46] /micromax/www/ 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:34:51] /micromax/www/bg/search.html?q=test 108.61.209.243

set names utf8

SELECT `Content` FROM `pages` WHERE`Module` = 'search' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `pages`.`MetaTitle`,
                `pages`.`MetaDescription`,
                `pages`.`URLLabel`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `Parent`.`Language` = 'bg' AND
                    `Parent`.`ParentID` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (
                    `pages`.`MenuLabel` LIKE '%test%' OR
                    `pages`.`FooterLabel` LIKE '%test%' OR
                    `pages`.`Annotation` LIKE '%test%' OR
                    `pages`.`Content` LIKE '%test%'
                ) AND
                `pages`.`Visible` = 1
            ORDER BY CASE
                WHEN `pages`.`MenuLabel` LIKE 'test%' THEN 0
                WHEN `pages`.`FooterLabel` LIKE 'test%' THEN 1
                WHEN `pages`.`MenuLabel` LIKE '% test%' THEN 2
                WHEN `pages`.`FooterLabel` LIKE '% test%' THEN 3
                ELSE 4
            END

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `UploadID`,
                `FileName`
            FROM
                `documents`
            WHERE
                `Language` = 'bg' AND
                (
                    `MetaTitle` LIKE '%test%' OR
                    `MetaDescription` LIKE '%test%' OR
                    `MetaKeywords` LIKE '%test%'
                ) AND
                `Visible` = 1
            ORDER BY CASE
                WHEN `MetaTitle` LIKE 'test%' THEN 0
                WHEN `MetaDescription` LIKE 'test%' THEN 1
                WHEN `MetaTitle` LIKE '% test%' THEN 2
                WHEN `MetaDescription` LIKE '% test%' THEN 3
                ELSE 4
            END

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

SELECT
                `ID`,
                `Title`,
                `Town`,
                `Address`,
                `Phones`,
                `EMail`
            FROM
                `stores`
            WHERE
                `Language` = 'bg' AND
                (
                    `Title` LIKE '%test%' OR
                    `Town` LIKE '%test%' OR
                    `Address` LIKE '%test%'
                ) AND
                `Visible` = 1
            ORDER BY CASE
                WHEN `Title` LIKE 'test%' THEN 0
                WHEN `Town` LIKE 'test%' THEN 1
                WHEN `Title` LIKE '% test%' THEN 2
                ELSE 3
            END

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

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:35:01] /micromax/www/bg/магазини.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'магазини' AND
                -- `ParentID` = 1 AND // TODO: FULL TEST
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'stores' AND
	    		`URLLabel` = 'магазини'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'магазини' AND
                P1.`Visible` = 1

SELECT
                `S2`.*,
                (SELECT COUNT(`S1`.`Town`) FROM `stores` AS `S1` WHERE `S1`.`Town` = `S2`.`Town`) AS `Count`
            FROM
                `stores` AS `S2`
            WHERE
                `Language` = 'bg'
         AND `Visible` = 1
            GROUP BY
                `S2`.`ID`,
                `S2`.`Language`
            ORDER BY
                `Count` DESC,
                `Town` ASC

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'магазини'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'магазини'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:35:15] /micromax/www/bg/search.html?q=test 108.61.209.243

set names utf8

SELECT `Content` FROM `pages` WHERE`Module` = 'search' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `pages`.`MetaTitle`,
                `pages`.`MetaDescription`,
                `pages`.`URLLabel`,
                `Parent`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `Parent`.`Language` = 'bg' AND
                    `Parent`.`ParentID` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (
                    `pages`.`MenuLabel` LIKE '%test%' OR
                    `pages`.`FooterLabel` LIKE '%test%' OR
                    `pages`.`Annotation` LIKE '%test%' OR
                    `pages`.`Content` LIKE '%test%'
                ) AND
                `pages`.`Visible` = 1
            ORDER BY CASE
                WHEN `pages`.`MenuLabel` LIKE 'test%' THEN 0
                WHEN `pages`.`FooterLabel` LIKE 'test%' THEN 1
                WHEN `pages`.`MenuLabel` LIKE '% test%' THEN 2
                WHEN `pages`.`FooterLabel` LIKE '% test%' THEN 3
                ELSE 4
            END

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `UploadID`,
                `FileName`
            FROM
                `documents`
            WHERE
                `Language` = 'bg' AND
                (
                    `MetaTitle` LIKE '%test%' OR
                    `MetaDescription` LIKE '%test%' OR
                    `MetaKeywords` LIKE '%test%'
                ) AND
                `Visible` = 1
            ORDER BY CASE
                WHEN `MetaTitle` LIKE 'test%' THEN 0
                WHEN `MetaDescription` LIKE 'test%' THEN 1
                WHEN `MetaTitle` LIKE '% test%' THEN 2
                WHEN `MetaDescription` LIKE '% test%' THEN 3
                ELSE 4
            END

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

SELECT
                `ID`,
                `Title`,
                `Town`,
                `Address`,
                `Phones`,
                `EMail`
            FROM
                `stores`
            WHERE
                `Language` = 'bg' AND
                (
                    `Title` LIKE '%test%' OR
                    `Town` LIKE '%test%' OR
                    `Address` LIKE '%test%'
                ) AND
                `Visible` = 1
            ORDER BY CASE
                WHEN `Title` LIKE 'test%' THEN 0
                WHEN `Town` LIKE 'test%' THEN 1
                WHEN `Title` LIKE '% test%' THEN 2
                ELSE 3
            END

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

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'bg'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'search'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 08:35:24] /micromax/www/ 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LKeywords','LSearch') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Feb-2024 09:37:41] /micromax/www/ 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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