# [06-Mar-2024 09:51:47] /activa/www/ 108.61.209.243

set names utf8

SELECT
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `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
                `UploadID`,
                `URLLabel`,
                `Icon`,
                `Image`,
                `MenuLabel`,
                `Annotation`
            FROM
                `pages`
            WHERE
                `Icon` <> '' AND
                `Image` <> '' AND
                `MenuLabel` <> '' AND
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

SELECT `MetaTitle` FROM `pages` WHERE`ID` = 1 AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                    IF(P1.`URLLabel` <> '', CONCAT(P1.`URLLabel`, '/', P2.`URLLabel`), P2.`URLLabel`) AS `URL`
                FROM
                    `pages` P2
                    LEFT JOIN `pages` P1 ON
                        P2.`ParentID` > 1 AND
                        P1.`ID` = P2.`ParentID` AND
                        P1.`Language` = P2.`Language` AND
                        P1.`Visible` = P2.`Visible`
                WHERE
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'events'
             AND P2.`Visible` = 1 LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `events`
            WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `Annotation` FROM `pages` WHERE`Module` = 'events' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

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

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

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

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

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

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

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

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 09:51:50] /activa/www/en/ 108.61.209.243

set names utf8

SELECT
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `Language` = 'en' 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` = 'en' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `UploadID`,
                `URLLabel`,
                `Icon`,
                `Image`,
                `MenuLabel`,
                `Annotation`
            FROM
                `pages`
            WHERE
                `Icon` <> '' AND
                `Image` <> '' AND
                `MenuLabel` <> '' AND
                `Language` = 'en' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

SELECT `MetaTitle` FROM `pages` WHERE`ID` = 1 AND
	`Language` = 'en' AND
	`Visible` = 1 LIMIT 1

SELECT
                    IF(P1.`URLLabel` <> '', CONCAT(P1.`URLLabel`, '/', P2.`URLLabel`), P2.`URLLabel`) AS `URL`
                FROM
                    `pages` P2
                    LEFT JOIN `pages` P1 ON
                        P2.`ParentID` > 1 AND
                        P1.`ID` = P2.`ParentID` AND
                        P1.`Language` = P2.`Language` AND
                        P1.`Visible` = P2.`Visible`
                WHERE
                    P2.`Language` = 'en' AND
                    P2.`Module` = 'events'
             AND P2.`Visible` = 1 LIMIT 1

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Module`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                `FooterLabel` <> '' AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 09:51:53] /activa/www/ 108.61.209.243

set names utf8

SELECT
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `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
                `UploadID`,
                `URLLabel`,
                `Icon`,
                `Image`,
                `MenuLabel`,
                `Annotation`
            FROM
                `pages`
            WHERE
                `Icon` <> '' AND
                `Image` <> '' AND
                `MenuLabel` <> '' AND
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

SELECT `MetaTitle` FROM `pages` WHERE`ID` = 1 AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                    IF(P1.`URLLabel` <> '', CONCAT(P1.`URLLabel`, '/', P2.`URLLabel`), P2.`URLLabel`) AS `URL`
                FROM
                    `pages` P2
                    LEFT JOIN `pages` P1 ON
                        P2.`ParentID` > 1 AND
                        P1.`ID` = P2.`ParentID` AND
                        P1.`Language` = P2.`Language` AND
                        P1.`Visible` = P2.`Visible`
                WHERE
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'events'
             AND P2.`Visible` = 1 LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `events`
            WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `Annotation` FROM `pages` WHERE`Module` = 'events' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

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

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

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

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

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

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

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

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 09:51:56] /activa/www/en/ 108.61.209.243

set names utf8

SELECT
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `Language` = 'en' 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` = 'en' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `UploadID`,
                `URLLabel`,
                `Icon`,
                `Image`,
                `MenuLabel`,
                `Annotation`
            FROM
                `pages`
            WHERE
                `Icon` <> '' AND
                `Image` <> '' AND
                `MenuLabel` <> '' AND
                `Language` = 'en' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

SELECT `MetaTitle` FROM `pages` WHERE`ID` = 1 AND
	`Language` = 'en' AND
	`Visible` = 1 LIMIT 1

SELECT
                    IF(P1.`URLLabel` <> '', CONCAT(P1.`URLLabel`, '/', P2.`URLLabel`), P2.`URLLabel`) AS `URL`
                FROM
                    `pages` P2
                    LEFT JOIN `pages` P1 ON
                        P2.`ParentID` > 1 AND
                        P1.`ID` = P2.`ParentID` AND
                        P1.`Language` = P2.`Language` AND
                        P1.`Visible` = P2.`Visible`
                WHERE
                    P2.`Language` = 'en' AND
                    P2.`Module` = 'events'
             AND P2.`Visible` = 1 LIMIT 1

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Module`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                `FooterLabel` <> '' AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 09:51:58] /activa/www/en/activa-high-yield-fund/documents.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'activa-high-yield-fund' -- AND
                -- `ParentID` = 1 AND // TODO: FULL TEST
                -- (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

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

SELECT
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'activa-high-yield-fund' AND
                    P2.`Language` = 'en' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'documents'
             AND P2.`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` = 'en' AND
                P1.`URLLabel` = 'activa-high-yield-fund/documents' AND
                P1.`Visible` = 1

SELECT * FROM `documents` WHERE `Language` = 'en' AND `PageID` = 48 AND `Visible` = 1 ORDER BY `PostDate` DESC

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'en' AND
                    P2.`URLLabel` = 'activa-high-yield-fund'
	    	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` = 'en' AND
                    P2.`URLLabel` = 'activa-high-yield-fund'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Module`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                `FooterLabel` <> '' AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 09:52:01] /activa/www/en/activa-asset-management/team.html 108.61.209.243

set names utf8

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

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

SELECT
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'activa-asset-management' AND
                    P2.`Language` = 'en' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'team'
             AND P2.`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` = 'en' AND
                P1.`URLLabel` = 'activa-asset-management/team' AND
                P1.`Visible` = 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	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` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Module`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                `FooterLabel` <> '' AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 09:52:07] /activa/www/en/activa-asset-management/about-us.html 108.61.209.243

set names utf8

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

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

SELECT
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'activa-asset-management' AND
                    P2.`Language` = 'en' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'about-us'
             AND P2.`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` = 'en' AND
                P1.`URLLabel` = 'activa-asset-management/about-us' AND
                P1.`Visible` = 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	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` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Module`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                `FooterLabel` <> '' AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 09:52:11] /activa/www/en/activa-asset-management/team.html 108.61.209.243

set names utf8

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

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

SELECT
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'activa-asset-management' AND
                    P2.`Language` = 'en' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'team'
             AND P2.`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` = 'en' AND
                P1.`URLLabel` = 'activa-asset-management/team' AND
                P1.`Visible` = 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	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` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Module`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                `FooterLabel` <> '' AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 09:52:13] /activa/www/en/activa-asset-management/documents.html 108.61.209.243

set names utf8

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

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

SELECT
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'activa-asset-management' AND
                    P2.`Language` = 'en' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'documents'
             AND P2.`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` = 'en' AND
                P1.`URLLabel` = 'activa-asset-management/documents' AND
                P1.`Visible` = 1

SELECT * FROM `documents` WHERE `Language` = 'en' AND `PageID` = 38 AND `Visible` = 1 ORDER BY `PostDate` DESC

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	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` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Module`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                `FooterLabel` <> '' AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 09:52:16] /activa/www/en/activa-asset-management/financial-statements.html 108.61.209.243

set names utf8

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

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

SELECT
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'activa-asset-management' AND
                    P2.`Language` = 'en' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'financial-statements'
             AND P2.`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` = 'en' AND
                P1.`URLLabel` = 'activa-asset-management/financial-statements' AND
                P1.`Visible` = 1

SELECT * FROM `reports` WHERE `Language` = 'en' AND `PageID` = 39 AND `Visible` = 1 ORDER BY `Year` DESC, `PostDate` DESC

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	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` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Module`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                `FooterLabel` <> '' AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 09:52:22] /activa/www/en/activa-asset-management/news.html 108.61.209.243

set names utf8

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

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

SELECT
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'activa-asset-management' AND
                    P2.`Language` = 'en' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'news'
             AND P2.`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` = 'en' AND
                P1.`URLLabel` = 'activa-asset-management/news' AND
                P1.`Visible` = 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	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` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Module`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                `FooterLabel` <> '' AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 11:44:33] /activa/content/documents.php?URL=https://activabg.com/en/activa-asset-management/documents&Language=bg&PageID=12 108.61.209.243
# [06-Mar-2024 11:44:42] /activa/content/documents.php?URL=https://activabg.com/en/activa-asset-management/documents/&Language=bg&PageID=12 108.61.209.243
# [06-Mar-2024 11:46:53] /activa/content/documents.php?URL=https://activabg.com/en/activa-asset-management/documents/&Language=bg&PageID=12 108.61.209.243
# [06-Mar-2024 11:47:40] /activa/content/documents.php?URL=https://activabg.com/en/activa-asset-management/documents/&Language=bg&PageID=12 108.61.209.243
# [06-Mar-2024 11:48:15] /activa/content/documents.php?URL=https://activabg.com/en/activa-asset-management/documents/&Language=bg&PageID=12 108.61.209.243
# [06-Mar-2024 11:50:11] /activa/content/documents.php?URL=https://activabg.com/en/activa-asset-management/documents/&Language=bg&PageID=12 108.61.209.243
# [06-Mar-2024 11:50:21] /activa/content/documents.php?URL=https://activabg.com/en/activa-asset-management/documents/&Language=bg&PageID=12 108.61.209.243
# [06-Mar-2024 11:50:45] /activa/content/documents.php?URL=https://activabg.com/en/activa-asset-management/documents/&Language=bg&PageID=12 108.61.209.243
# [06-Mar-2024 11:51:22] /activa/content/documents.php?URL=https://activabg.com/en/activa-balanced-fund/documents/&Language=bg&PageID=12 108.61.209.243
# [06-Mar-2024 12:10:39] /activa/content/documents.php?URL=https://activabg.com/en/activa-balanced-fund/documents/&Language=bg&PageID=12 108.61.209.243
# [06-Mar-2024 12:12:33] /activa/content/documents.php?URL=https://activabg.com/en/activa-balanced-fund/documents/&Language=bg&PageID=12 108.61.209.243

set names utf8

INSERT INTO
						`documents_test`(
							`ID`,
							`Language`,
							`PostDate`,
							`LastUpdate`,
							`PageID`,
							`UploadID`,
							`MetaTitle`,
							`Title`,
							`FileName`,
							`Visible`
					 	) VALUES (
					 		NULL,
					 		'bg',
					 		NOW(),
					 		NOW(),
					 		'12',
					 		'9719954283',
					 		'Summary information on the structure of the portfolio',
					 		'Summary information on the structure of the portfolio',
					 		'240305142630.pdf',
					 		1
					 	)
# [06-Mar-2024 12:13:15] /activa/content/documents.php?URL=https://activabg.com/en/activa-balanced-fund/documents/&Language=bg&PageID=12 108.61.209.243

set names utf8

INSERT INTO
						`documents_test`(
							`ID`,
							`Language`,
							`PostDate`,
							`LastUpdate`,
							`PageID`,
							`UploadID`,
							`MetaTitle`,
							`Title`,
							`FileName`,
							`Visible`
					 	) VALUES (
					 		NULL,
					 		'bg',
					 		NOW(),
					 		NOW(),
					 		'12',
					 		'9719995842',
					 		'Summary information on the structure of the portfolio',
					 		'Summary information on the structure of the portfolio',
					 		'240305142630.pdf',
					 		1
					 	)

INSERT INTO
						`documents_test`(
							`ID`,
							`Language`,
							`PostDate`,
							`LastUpdate`,
							`PageID`,
							`UploadID`,
							`MetaTitle`,
							`Title`,
							`FileName`,
							`Visible`
					 	) VALUES (
					 		NULL,
					 		'bg',
					 		NOW(),
					 		NOW(),
					 		'12',
					 		'9719996477',
					 		'Prospectus',
					 		'Prospectus',
					 		'240104132232.pdf',
					 		1
					 	)

INSERT INTO
						`documents_test`(
							`ID`,
							`Language`,
							`PostDate`,
							`LastUpdate`,
							`PageID`,
							`UploadID`,
							`MetaTitle`,
							`Title`,
							`FileName`,
							`Visible`
					 	) VALUES (
					 		NULL,
					 		'bg',
					 		NOW(),
					 		NOW(),
					 		'12',
					 		'9719996875',
					 		'KEY INFORMATION DOCUMENT (Deutsch)',
					 		'KEY INFORMATION DOCUMENT (Deutsch)',
					 		'230504135302.pdf',
					 		1
					 	)

INSERT INTO
						`documents_test`(
							`ID`,
							`Language`,
							`PostDate`,
							`LastUpdate`,
							`PageID`,
							`UploadID`,
							`MetaTitle`,
							`Title`,
							`FileName`,
							`Visible`
					 	) VALUES (
					 		NULL,
					 		'bg',
					 		NOW(),
					 		NOW(),
					 		'12',
					 		'9719997156',
					 		'KEY INFORMATION DOCUMENT',
					 		'KEY INFORMATION DOCUMENT',
					 		'230504135251.pdf',
					 		1
					 	)

INSERT INTO
						`documents_test`(
							`ID`,
							`Language`,
							`PostDate`,
							`LastUpdate`,
							`PageID`,
							`UploadID`,
							`MetaTitle`,
							`Title`,
							`FileName`,
							`Visible`
					 	) VALUES (
					 		NULL,
					 		'bg',
					 		NOW(),
					 		NOW(),
					 		'12',
					 		'9719997438',
					 		'Rules',
					 		'Rules',
					 		'230412133800.pdf',
					 		1
					 	)
# [06-Mar-2024 12:25:20] /activa/content/reports.php?URL=https://activabg.com/%d0%b0%d0%ba%d1%82%d0%b8%d0%b2%d0%b0-%d0%b1%d0%b0%d0%bb%d0%b0%d0%bd%d1%81%d0%b8%d1%80%d0%b0%d0%bd-%d1%84%d0%be%d0%bd%d0%b4/%d1%84%d0%b8%d0%bd%d0%b0%d0%bd%d1%81%d0%be%d0%b2%d0%b8-%d0%be%d1%82%d1%87%d0%b5%d1%82%d0%b8/&Language=bg&PageID=123 108.61.209.243

set names utf8

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720722397',
						 		'Обобщена информация за обявените емисионни стойности и цени ...',
						 		'Обобщена  информация за обявените емисионни стойности и цени на обратно изкупуване',
						 		'2024',
						 		'240305172159.pdf',
						 		1
						 	)

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720722754',
						 		'Информация относно прилагането на чл. 43 от Наредба №44',
						 		'Информация относно прилагането на чл. 43 от Наредба №44',
						 		'2023',
						 		'240131154009.pdf',
						 		1
						 	)

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720723033',
						 		'Доп. информация към годишния финансов отчет',
						 		'Доп. информация към годишния финансов отчет',
						 		'2022',
						 		'230330084213.pdf',
						 		1
						 	)

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720723319',
						 		'Доп. информация към годишния финансов отчет',
						 		'Доп. информация към годишния финансов отчет',
						 		'2021',
						 		'220325143606.pdf',
						 		1
						 	)

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720723606',
						 		'Годишен финансов отчет за 2020г.',
						 		'Годишен финансов отчет за 2020г.',
						 		'2020',
						 		'210401131224.pdf',
						 		1
						 	)

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720724261',
						 		'Годишен финансов отчет',
						 		'Годишен финансов отчет',
						 		'2019',
						 		'200408134004.pdf',
						 		1
						 	)

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720724751',
						 		'Обобщена информация за обявените емисионни стойности и цени ...',
						 		'Обобщена информация за обявените емисионни стойности и цени на обратно изкупуване',
						 		'2018',
						 		'190809085202.pdf',
						 		1
						 	)

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720725159',
						 		'Информация относно прилагането на чл. 43 от Наредба 44',
						 		'Информация относно прилагането на чл. 43 от Наредба 44',
						 		'2017',
						 		'190809083448.pdf',
						 		1
						 	)

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720725539',
						 		'Информация относно прилагането на чл. 43 от Наредба 44',
						 		'Информация относно прилагането на чл. 43 от Наредба 44',
						 		'2016',
						 		'190809083500.pdf',
						 		1
						 	)

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720725856',
						 		'Информация относно прилагането на чл. 43 от Наредба 44',
						 		'Информация относно прилагането на чл. 43 от Наредба 44',
						 		'2015',
						 		'190809083515.pdf',
						 		1
						 	)

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720726178',
						 		'Информация относно прилагането на чл. 43 от Наредба 44',
						 		'Информация относно прилагането на чл. 43 от Наредба 44',
						 		'2014',
						 		'190809083530.pdf',
						 		1
						 	)

INSERT INTO
							`reports_test`(
								`ID`,
								`Language`,
								`PostDate`,
								`LastUpdate`,
								`PageID`,
								`UploadID`,
								`MetaTitle`,
								`Title`,
								`Year`,
								`FileName`,
								`Visible`
						 	) VALUES (
						 		NULL,
						 		'bg',
						 		NOW(),
						 		NOW(),
						 		'123',
						 		'9720726499',
						 		'Годишен финансов отчет',
						 		'Годишен финансов отчет',
						 		'2013',
						 		'190611114755.pdf',
						 		1
						 	)
# [06-Mar-2024 12:27:38] /activa/content/reports.php?URL=https://activabg.com/%d0%b0%d0%ba%d1%82%d0%b8%d0%b2%d0%b0-%d0%b1%d0%b0%d0%bb%d0%b0%d0%bd%d1%81%d0%b8%d1%80%d0%b0%d0%bd-%d1%84%d0%be%d0%bd%d0%b4/%d1%84%d0%b8%d0%bd%d0%b0%d0%bd%d1%81%d0%be%d0%b2%d0%b8-%d0%be%d1%82%d1%87%d0%b5%d1%82%d0%b8/&Language=bg&PageID=123 108.61.209.243

set names utf8

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720858580',
							 		'Обобщена информация за обявените емисионни стойности и цени ...',
							 		'Обобщена  информация за обявените емисионни стойности и цени на обратно изкупуване',
							 		'2024',
							 		'240305172159.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720858941',
							 		'Шестмесечен финансов отчет',
							 		'Шестмесечен финансов отчет',
							 		'2023',
							 		'230728135921.xls',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720859297',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'2023',
							 		'230728135931.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720859576',
							 		'Обобщена информация за обявените емисионни стойности и цени ...',
							 		'Обобщена информация за обявените емисионни стойности и цени на обратно изкупуване',
							 		'2023',
							 		'240103130758.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720860110',
							 		'Информация относно прилагането на чл. 43 от Наредба №44',
							 		'Информация относно прилагането на чл. 43 от Наредба №44',
							 		'2023',
							 		'240131154009.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720860404',
							 		'Шестмесечен финансов отчет',
							 		'Шестмесечен финансов отчет',
							 		'2022',
							 		'220729092433.xlsx',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720860684',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'2022',
							 		'220729092441.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720860985',
							 		'Обобщена информация за обявените емисионни стойности и цени ...',
							 		'Обобщена информация за обявените емисионни стойности и цени на обратно изкупуване',
							 		'2022',
							 		'230104140123.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720861495',
							 		'Информация относно прилагането на чл. 43 от Наредба №44',
							 		'Информация относно прилагането на чл. 43 от Наредба №44',
							 		'2022',
							 		'230207093045.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720861775',
							 		'Годишен финансов отчет',
							 		'Годишен финансов отчет',
							 		'2022',
							 		'230330084116.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720862299',
							 		'Годишен финансов отчет - Форми на КФН',
							 		'Годишен финансов отчет - Форми на КФН',
							 		'2022',
							 		'230330084129.xls',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720862693',
							 		'Доп. информация към годишния финансов отчет',
							 		'Доп. информация към годишния финансов отчет',
							 		'2022',
							 		'230330084156.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720862972',
							 		'Доп. информация към годишния финансов отчет',
							 		'Доп. информация към годишния финансов отчет',
							 		'2022',
							 		'230330084213.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720863248',
							 		'Шестмесечен финансов отчет',
							 		'Шестмесечен финансов отчет',
							 		'2021',
							 		'210820123008.xlsx',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720863491',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'2021',
							 		'210730140016.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720863768',
							 		'Обобщена информация за обявените емисионни стойности и цени ...',
							 		'Обобщена информация за обявените емисионни стойности и цени на обратно изкупуване',
							 		'2021',
							 		'211231081048.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720864283',
							 		'Информация относно прилагането на чл. 43 от Наредба №44',
							 		'Информация относно прилагането на чл. 43 от Наредба №44',
							 		'2021',
							 		'220228072337.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720864562',
							 		'Годишен финансов отчет',
							 		'Годишен финансов отчет',
							 		'2021',
							 		'220325143339.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720865392',
							 		'Годишен финансов отчет - форми КФН',
							 		'Годишен финансов отчет - форми КФН',
							 		'2021',
							 		'220325143534.xls',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720865788',
							 		'Доп. информация към годишния финансов отчет',
							 		'Доп. информация към годишния финансов отчет',
							 		'2021',
							 		'220325143551.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720866031',
							 		'Доп. информация към годишния финансов отчет',
							 		'Доп. информация към годишния финансов отчет',
							 		'2021',
							 		'220325143606.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720866273',
							 		'Шестмесечен финансов отчет',
							 		'Шестмесечен финансов отчет',
							 		'2020',
							 		'200728082049.xlsx',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720866555',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'2020',
							 		'200728082100.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720866802',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'2020',
							 		'210215124854.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720867089',
							 		'Обобщена информация за обявените емисионни стойности и цени ...',
							 		'Обобщена информация за обявените емисионни стойности и цени на обратно изкупуване',
							 		'2020',
							 		'201231113411.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720867572',
							 		'Годишен финансов отчет за 2020г.',
							 		'Годишен финансов отчет за 2020г.',
							 		'2020',
							 		'210401131224.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720868176',
							 		'Шестмесечен финансов отчет',
							 		'Шестмесечен финансов отчет',
							 		'2019',
							 		'190807132946.xlsx',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720868422',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'2019',
							 		'190807133048.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720868701',
							 		'Информация отностно прилагането на чл. 43 от Наредба 44',
							 		'Информация отностно прилагането на чл. 43 от Наредба 44',
							 		'2019',
							 		'200127132307.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720868981',
							 		'Обобщена информация за обявените емисионни стойности и цени ...',
							 		'Обобщена информация за обявените емисионни стойности и цени на обратно изкупуване',
							 		'2019',
							 		'191231110252.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720869542',
							 		'Годишен финансов отчет',
							 		'Годишен финансов отчет',
							 		'2019',
							 		'200408134004.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720870020',
							 		'Шестмесечен финансов отчет',
							 		'Шестмесечен финансов отчет',
							 		'2018',
							 		'190611115545.xls',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720870375',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'Доп. информация към шестмесечния финансов отчет',
							 		'2018',
							 		'190611115607.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720870654',
							 		'Годишен финансов отчет',
							 		'Годишен финансов отчет',
							 		'2018',
							 		'190611115639.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720871167',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'2018',
							 		'190809083432.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720871446',
							 		'Обобщена информация за обявените емисионни стойности и цени ...',
							 		'Обобщена информация за обявените емисионни стойности и цени на обратно изкупуване',
							 		'2018',
							 		'190809085202.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720871764',
							 		'Шестмесечен финансов отчет',
							 		'Шестмесечен финансов отчет',
							 		'2017',
							 		'190611115431.xlsx',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720871970',
							 		'Доп. инфо към шестмесечния финансов отчет',
							 		'Доп. инфо към шестмесечния финансов отчет',
							 		'2017',
							 		'190611115448.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720872247',
							 		'Годишен финансов отчет',
							 		'Годишен финансов отчет',
							 		'2017',
							 		'190611115510.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720872769',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'2017',
							 		'190809083448.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720873086',
							 		'Годишен финансов отчет',
							 		'Годишен финансов отчет',
							 		'2016',
							 		'190611115249.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720873528',
							 		'Шестмесечен финансов отчет',
							 		'Шестмесечен финансов отчет',
							 		'2016',
							 		'190611115319.xlsx',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720873731',
							 		'Доп. инфо към шестмесечния финансов отчет',
							 		'Доп. инфо към шестмесечния финансов отчет',
							 		'2016',
							 		'190611115344.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720874009',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'2016',
							 		'190809083500.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720874326',
							 		'Шестмесечен финансов отчет',
							 		'Шестмесечен финансов отчет',
							 		'2015',
							 		'190611115142.xlsx',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720874531',
							 		'Годишен финансов отчет',
							 		'Годишен финансов отчет',
							 		'2015',
							 		'190611115207.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720875093',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'2015',
							 		'190809083515.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720875407',
							 		'Шестмесечен финансов отчет',
							 		'Шестмесечен финансов отчет',
							 		'2014',
							 		'190611114836.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720875724',
							 		'Годишен финансов отчет',
							 		'Годишен финансов отчет',
							 		'2014',
							 		'190611115036.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720876475',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'Информация относно прилагането на чл. 43 от Наредба 44',
							 		'2014',
							 		'190809083530.pdf',
							 		1
							 	)

INSERT INTO
								`reports_test`(
									`ID`,
									`Language`,
									`PostDate`,
									`LastUpdate`,
									`PageID`,
									`UploadID`,
									`MetaTitle`,
									`Title`,
									`Year`,
									`FileName`,
									`Visible`
							 	) VALUES (
							 		NULL,
							 		'bg',
							 		NOW(),
							 		NOW(),
							 		'123',
							 		'9720876793',
							 		'Годишен финансов отчет',
							 		'Годишен финансов отчет',
							 		'2013',
							 		'190611114755.pdf',
							 		1
							 	)
# [06-Mar-2024 12:41:09] /activa/www/ 108.61.209.243

set names utf8

SELECT
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `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
                `UploadID`,
                `URLLabel`,
                `Icon`,
                `Image`,
                `MenuLabel`,
                `Annotation`
            FROM
                `pages`
            WHERE
                `Icon` <> '' AND
                `Image` <> '' AND
                `MenuLabel` <> '' AND
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

SELECT `MetaTitle` FROM `pages` WHERE`ID` = 1 AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                    IF(P1.`URLLabel` <> '', CONCAT(P1.`URLLabel`, '/', P2.`URLLabel`), P2.`URLLabel`) AS `URL`
                FROM
                    `pages` P2
                    LEFT JOIN `pages` P1 ON
                        P2.`ParentID` > 1 AND
                        P1.`ID` = P2.`ParentID` AND
                        P1.`Language` = P2.`Language` AND
                        P1.`Visible` = P2.`Visible`
                WHERE
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'events'
             AND P2.`Visible` = 1 LIMIT 1

SELECT
                `PostDate`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `events`
            WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT `Annotation` FROM `pages` WHERE`Module` = 'events' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

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

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

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

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

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

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

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

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:41:13] /activa/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
                `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
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'актива-асет-мениджмънт' AND
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'документи'
             AND P2.`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 * FROM `documents` WHERE `Language` = 'bg' AND `PageID` = 38 AND `Visible` = 1 ORDER BY `PostDate` DESC

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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:41:17] /activa/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
                `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
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'актива-асет-мениджмънт' AND
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'за-нас'
             AND P2.`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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:41:19] /activa/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
                `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
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'актива-асет-мениджмънт' AND
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'екип'
             AND P2.`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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:41:22] /activa/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
                `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
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'актива-асет-мениджмънт' AND
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'финансови-отчети'
             AND P2.`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 * FROM `reports` WHERE `Language` = 'bg' AND `PageID` = 39 AND `Visible` = 1 ORDER BY `Year` DESC, `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReports') 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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:41:24] /activa/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
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `Language` = 'bg' AND
                    `Module` = 'pages' 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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:41:26] /activa/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
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `Language` = 'bg' AND
                    `Module` = 'pages' 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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:41:27] /activa/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
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `Language` = 'bg' AND
                    `Module` = 'pages' 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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:41:30] /activa/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
                `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
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'актива-балансиран-фонд' AND
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'инвестиционна-стратегия'
             AND P2.`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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:41:53] /activa/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
                `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
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'доверително-управление' AND
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'документи'
             AND P2.`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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:41:53] /activa/www/uf/pages/6682191299/i_ 108.61.209.243

set names utf8

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:42:03] /activa/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
                `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
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'доверително-управление' AND
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'консервативен-модел'
             AND P2.`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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:42:04] /activa/www/uf/pages/6682191299/i_ 108.61.209.243

set names utf8

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:42:07] /activa/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
                `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
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'доверително-управление' AND
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'балансиран-модел'
             AND P2.`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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:42:08] /activa/www/uf/pages/6682191299/i_ 108.61.209.243

set names utf8

SELECT
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:42:12] /activa/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
                `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
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'актива-високодоходен-фонд' AND
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'цени-на-дялове'
             AND P2.`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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Mar-2024 12:42:17] /activa/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
                `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
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'актива-високодоходен-фонд' AND
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'документи'
             AND P2.`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 * FROM `documents` WHERE `Language` = 'bg' AND `PageID` = 48 AND `Visible` = 1 ORDER BY `PostDate` DESC

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
                `P1`.`ID`,
                `P1`.`ParentID`,
                `P1`.`MenuLabel`,
                IF(`P2`.`URLLabel` <> '', CONCAT(`P2`.`URLLabel`, '/', `P1`.`URLLabel`), `P1`.`URLLabel`) AS `URLLabel`,
                (SELECT `ID` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 LIMIT 1) AS `ChildID`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`Module` != 'users' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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

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