# [25-Mar-2024 15:14:41] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 15:14:51] /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
# [25-Mar-2024 15:14:56] /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
# [25-Mar-2024 15:15:00] /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
# [25-Mar-2024 15:15:02] /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
# [25-Mar-2024 15:15:05] /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
# [25-Mar-2024 15:15: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
                    *,
                    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
# [25-Mar-2024 15:15:09] /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
# [25-Mar-2024 15:15:15] /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
# [25-Mar-2024 15:15: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
# [25-Mar-2024 15:15: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
                `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
# [25-Mar-2024 15:15:31] /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
# [25-Mar-2024 15:15:55] /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 `Action` FROM `pages` WHERE`ID` = 51 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

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

SELECT
                `PostDate`,
                YEAR(`PostDate`) AS `Year`,
                MONTH(`PostDate`) AS `Month`,
                DAY(`PostDate`) AS `Day`,
                `NSA`,
                `NsaPerShare`
            FROM
                `assets`
            WHERE
                `Fund` = 'highyield'
         ORDER BY `PostDate` ASC

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

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

SELECT
                YEAR(`PostDate`) AS `Year`,
                MONTH(`PostDate`) AS `Month`,
                DAY(`PostDate`) AS `Day`,
                `YearBegin`
            FROM
                `assets`
            WHERE
                `PostDate` >= '2024-01-01' AND
                `Fund` = 'highyield'
            ORDER BY
                `PostDate` 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
# [25-Mar-2024 15:23: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 `Action` FROM `pages` WHERE`ID` = 51 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

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

SELECT
                `PostDate`,
                YEAR(`PostDate`) AS `Year`,
                MONTH(`PostDate`) AS `Month`,
                DAY(`PostDate`) AS `Day`,
                `NSA`,
                `NsaPerShare`
            FROM
                `assets`
            WHERE
                `Fund` = 'highyield'
         ORDER BY `PostDate` ASC

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

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

SELECT
                YEAR(`PostDate`) AS `Year`,
                MONTH(`PostDate`) AS `Month`,
                DAY(`PostDate`) AS `Day`,
                `YearBegin`
            FROM
                `assets`
            WHERE
                `PostDate` >= '2024-01-01' AND
                `Fund` = 'highyield'
            ORDER BY
                `PostDate` 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
# [25-Mar-2024 15:23:58] /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
# [25-Mar-2024 15:24:50] /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
# [25-Mar-2024 15:24:52] /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
# [25-Mar-2024 15:25:06] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 15:25:54] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1711373154365 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'dj6FQDGDgLpZ9uvm9ToMolI32QbxD3UbhLHzxj9x7g14t200c0aXe2M9u2gGgIh2'
            WHERE
                `UserKey` LIKE 'w4vDksOjw4LCpcODw5HDjcOBw6zCs8K-w43DlsObwp7CtsK9%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [25-Mar-2024 15:25:55] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1711373155337 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = 'dj6FQDGDgLpZ9uvm9ToMolI32QbxD3UbhLHzxj9x7g14t200c0aXe2M9u2gGgIh2'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [25-Mar-2024 15:25:55] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`), `pages`.`URLLabel`) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    -- `Parent`.`ParentID` = 1 AND // TODO: FULL TEST
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`ParentID` ASC, `pages`.`PostDate` ASC
# [25-Mar-2024 15:25:59] /activa/www/aD3nVpq2C/bg/ajax/pages/form.html?_=1711373159285 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
# [25-Mar-2024 15:31:07] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`), `pages`.`URLLabel`) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    -- `Parent`.`ParentID` = 1 AND // TODO: FULL TEST
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`ParentID` ASC, `pages`.`PostDate` ASC
# [25-Mar-2024 15:31:10] /activa/www/aD3nVpq2C/bg/ajax/pages/form/1.html?_=1711373470435 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 1
# [25-Mar-2024 15:31:39] /activa/www/aD3nVpq2C/bg/ajax/pages/update/1.html?_=1711373499587 108.61.209.243

set names utf8

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

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

UPDATE `pages` SET `ID` = '1', `Language` = 'bg', `ParentID` = 0, `PostDate` = '2023-11-20', `LastUpdate` = '2024-03-25 15:31:39', `UploadID` = '2127403418', `MetaTitle` = 'Актива Асет Мениджмънт', `MetaDescription` = 'Нашето дружество - Актива Асет Мениджмънт АД - е управляващо дружество лицензирано от Комисията по финансов надзор с лиценз №25-УД/16.07.2007 г.', `MetaImage` = 'financial-021.jpg', `NoIndex` = 0, `MenuLabel` = '', `FooterLabel` = 'Начало', `URLLabel` = 'index', `Icon` = '', `Image` = 'financial-02.jpg', `Title` = '', `Annotation` = '', `Content` = '', `AddContent` = 'pages,assets/table,events', `AddOn` = '', `FirstPage` = 0, `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [25-Mar-2024 15:31:39] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`), `pages`.`URLLabel`) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    -- `Parent`.`ParentID` = 1 AND // TODO: FULL TEST
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`ParentID` ASC, `pages`.`PostDate` ASC
# [25-Mar-2024 15:37:08] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`), `pages`.`URLLabel`) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    -- `Parent`.`ParentID` = 1 AND // TODO: FULL TEST
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`ParentID` ASC, `pages`.`PostDate` ASC
# [25-Mar-2024 15:37:10] /activa/www/aD3nVpq2C/bg/ajax/pages/form/1.html?_=1711373830505 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 1
# [25-Mar-2024 15:37:16] /activa/www/aD3nVpq2C/bg/ajax/users/logout.html?_=1711373836425 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [25-Mar-2024 15:37:16] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 15:37:18] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 15:37:37] /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 `Action` FROM `pages` WHERE`ID` = 45 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

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

SELECT
                `PostDate`,
                YEAR(`PostDate`) AS `Year`,
                MONTH(`PostDate`) AS `Month`,
                DAY(`PostDate`) AS `Day`,
                `NSA`,
                `NsaPerShare`
            FROM
                `assets`
            WHERE
                `Fund` = 'balanced'
         ORDER BY `PostDate` ASC

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

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

SELECT
                YEAR(`PostDate`) AS `Year`,
                MONTH(`PostDate`) AS `Month`,
                DAY(`PostDate`) AS `Day`,
                `YearBegin`
            FROM
                `assets`
            WHERE
                `PostDate` >= '2024-01-01' AND
                `Fund` = 'balanced'
            ORDER BY
                `PostDate` 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
# [25-Mar-2024 15:37:52] /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
# [25-Mar-2024 15:38:32] /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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 16:25:32] /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
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `ID` IN (SELECT MAX(`ID`) FROM `assets` GROUP BY `Fund`)

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 16:25:51] /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
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `ID` IN (SELECT MAX(`ID`) FROM `assets` GROUP BY `Fund`)

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 16:27:00] /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
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `ID` IN (SELECT MAX(`ID`) FROM `assets` GROUP BY `Fund`)

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 16:36:12] /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
                `Fund`,
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `ID` IN (SELECT MAX(`ID`) FROM `assets` GROUP BY `Fund`)

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 16:36:44] /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
                `Fund`,
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `ID` IN (SELECT MAX(`ID`) FROM `assets` GROUP BY `Fund`)

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 16:37:32] /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
                `Fund`,
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `ID` IN (SELECT MAX(`ID`) FROM `assets` GROUP BY `Fund`)

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 16:37:56] /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` = 'events' 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
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` ASC

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 16:38:05] /activa/www/bg/актива-асет-мениджмънт/новини/.html 108.61.209.243

set names utf8

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
# [25-Mar-2024 16:38:09] /activa/www/bg/актива-асет-мениджмънт/новини/.html 108.61.209.243

set names utf8

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
# [25-Mar-2024 16:38:13] /activa/www/bg/актива-асет-мениджмънт/новини/.html 108.61.209.243

set names utf8

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
# [25-Mar-2024 16:38:57] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1711377537795 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '5w85HghrZZsj88P3WGK7M1G2332Am02V4LvtaQ7W21H3j2AkW3XGYi5H6gUgvx72'
            WHERE
                `UserKey` LIKE 'w4vDksOjw4LCpcODw5HDjcOBw6zCs8K-w43DlsObwp7CtsK9%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [25-Mar-2024 16:38:58] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1711377538617 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '5w85HghrZZsj88P3WGK7M1G2332Am02V4LvtaQ7W21H3j2AkW3XGYi5H6gUgvx72'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [25-Mar-2024 16:38:58] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`), `pages`.`URLLabel`) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    -- `Parent`.`ParentID` = 1 AND // TODO: FULL TEST
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`ParentID` ASC, `pages`.`PostDate` ASC
# [25-Mar-2024 16:39:11] /activa/www/aD3nVpq2C/bg/ajax/pages/form/44.html?_=1711377551307 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 44
# [25-Mar-2024 16:39:29] /activa/www/aD3nVpq2C/bg/ajax/pages/update/44.html?_=1711377568980 108.61.209.243

set names utf8

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

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

UPDATE `pages` SET `ID` = '44', `Language` = 'bg', `ParentID` = '32', `PostDate` = '2024-02-18', `LastUpdate` = '2024-03-25 16:39:29', `UploadID` = '6848926912', `MetaTitle` = 'Цени на дялове | Актива Балансиран ETF', `MetaDescription` = 'Стойности, определени на 07 Март 2024 г. в лева. Цените са валидни за поръчки, подадени до 06 Март 2024 г. ', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Цени на дялове', `FooterLabel` = '', `URLLabel` = 'цени-на-дялове', `Icon` = '', `Image` = '', `Title` = '', `Annotation` = '', `Content` = '	 	 	 	

<h3 align="center">Стойности, определени на 07 Март 2024 г. в лева</h3><div align="center">Цените са валидни за поръчки, подадени до 06 Март 2024 г. <br></div>				
				<br><br><table>
					<tbody><tr class="caption">
						<td colspan="6">Activa Balanced ETF</td>
					</tr>
					<tr class="labels">
						<th>НСА на един дял *</th>
						<th>НСА</th>
						<th>Брой дялове в обръщение</th>
						<th>Доходност от началото на годината (Не се анюализира)</th>
						<th>Доходност за последните 12 месеца</th>
						<th>Стандартно отклонение</th>
					</tr> 	 	 	 	 	
					<tr class="data">
						<td>
							<div>НСА на един дял *</div><div>2.2702</div>
						</td>
						<td>
							<div>НСА</div><div>40,605,596.52</div>
						</td>
						<td>
							<div>Брой дялове в обръщение</div><div>17,886,479.0000</div>
						</td>
						<td>
							<div>Доходност от началото на годината (Не се анюализира)</div><div>2.73%</div>
						</td>
						<td>
							<div>Доходност за последните 12 месеца</div><div>2.72%</div>
						</td>
						<td>
							<div>Стандартно отклонение</div><div>4.77%</div>
						</td>
					</tr>
				</tbody></table><small>* Цената на емитиране и обратно изкупуване на един дял е равна на нетната стойност на активите на един дял.</small>', `AddContent` = 'assets/table', `AddOn` = '', `FirstPage` = 0, `Visible` = 1 WHERE `ID` = '44' AND `Language` = 'bg'
# [25-Mar-2024 16:39:29] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`), `pages`.`URLLabel`) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    -- `Parent`.`ParentID` = 1 AND // TODO: FULL TEST
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`ParentID` ASC, `pages`.`PostDate` ASC
# [25-Mar-2024 16:39:38] /activa/www/aD3nVpq2C/bg/ajax/pages/form/44.html?_=1711377578523 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 44
# [25-Mar-2024 16:39:50] /activa/www/aD3nVpq2C/bg/ajax/users/logout.html?_=1711377590002 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [25-Mar-2024 16:39:50] /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
                `Fund`,
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `ID` IN (SELECT MAX(`ID`) FROM `assets` GROUP BY `Fund`)

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 16:39: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 `Action` FROM `pages` WHERE`ID` = 44 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'актива-балансиран-фонд'
	    	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
# [25-Mar-2024 16:40: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
                `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 `Action` FROM `pages` WHERE`ID` = 44 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'актива-балансиран-фонд'
	    	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
# [25-Mar-2024 16:40: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
                `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 `Action` FROM `pages` WHERE`ID` = 44 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'актива-балансиран-фонд'
	    	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
# [25-Mar-2024 16:41:50] /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 `Action` FROM `pages` WHERE`ID` = 44 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `Fund` = 'balanced'
            ORDER BY
                `PostDate` DESC
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('balanced') 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
# [25-Mar-2024 16:43: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 `Action` FROM `pages` WHERE`ID` = 44 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `Fund` = 'balanced'
            ORDER BY
                `PostDate` DESC
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('balanced') 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
# [25-Mar-2024 16:44:04] /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 `Action` FROM `pages` WHERE`ID` = 44 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `Fund` = 'balanced'
            ORDER BY
                `PostDate` DESC
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('balanced') 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
# [25-Mar-2024 16:45:47] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1711377946946 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'HM7PcVUu146eStU6MmPtI7nBS7wNShPjx4Kv8PHEQZyGMOS2a6F3O96KXm5jEDJd'
            WHERE
                `UserKey` LIKE 'w4vDksOjw4LCpcODw5HDjcOBw6zCs8K-w43DlsObwp7CtsK9%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [25-Mar-2024 16:45:47] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1711377947801 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = 'HM7PcVUu146eStU6MmPtI7nBS7wNShPjx4Kv8PHEQZyGMOS2a6F3O96KXm5jEDJd'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [25-Mar-2024 16:45:48] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`), `pages`.`URLLabel`) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    -- `Parent`.`ParentID` = 1 AND // TODO: FULL TEST
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`ParentID` ASC, `pages`.`PostDate` ASC
# [25-Mar-2024 16:46:02] /activa/www/aD3nVpq2C/bg/ajax/pages/form/50.html?_=1711377962082 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 50
# [25-Mar-2024 16:46:17] /activa/www/aD3nVpq2C/bg/ajax/pages/update/50.html?_=1711377977035 108.61.209.243

set names utf8

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

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

UPDATE `pages` SET `ID` = '50', `Language` = 'bg', `ParentID` = '33', `PostDate` = '2024-02-29', `LastUpdate` = '2024-03-25 16:46:17', `UploadID` = '6849174619', `MetaTitle` = 'Цени на дялове | Актива Високодоходен Фонд', `MetaDescription` = '', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Цени на дялове', `FooterLabel` = '', `URLLabel` = 'цени-на-дялове', `Icon` = '', `Image` = '', `Title` = '', `Annotation` = '', `Content` = '', `AddContent` = 'assets/table', `AddOn` = '', `FirstPage` = 0, `Visible` = 1 WHERE `ID` = '50' AND `Language` = 'bg'
# [25-Mar-2024 16:46:17] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`), `pages`.`URLLabel`) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    -- `Parent`.`ParentID` = 1 AND // TODO: FULL TEST
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`ParentID` ASC, `pages`.`PostDate` ASC
# [25-Mar-2024 16:46:30] /activa/www/aD3nVpq2C/bg/ajax/pages/form/55.html?_=1711377989946 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 55
# [25-Mar-2024 16:46:40] /activa/www/aD3nVpq2C/bg/ajax/pages/update/55.html?_=1711378000451 108.61.209.243

set names utf8

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

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

UPDATE `pages` SET `ID` = '55', `Language` = 'bg', `ParentID` = '34', `PostDate` = '2024-02-08', `LastUpdate` = '2024-03-25 16:46:40', `UploadID` = '6849411944', `MetaTitle` = 'Цени на дялове | НДФ Актива', `MetaDescription` = '', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Цени на дялове', `FooterLabel` = '', `URLLabel` = 'цени-на-дялове', `Icon` = '', `Image` = '', `Title` = '', `Annotation` = '', `Content` = '', `AddContent` = 'assets/table', `AddOn` = '', `FirstPage` = 0, `Visible` = 1 WHERE `ID` = '55' AND `Language` = 'bg'
# [25-Mar-2024 16:46:40] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`), `pages`.`URLLabel`) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    -- `Parent`.`ParentID` = 1 AND // TODO: FULL TEST
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`ParentID` ASC, `pages`.`PostDate` ASC
# [25-Mar-2024 16:46:55] /activa/www/aD3nVpq2C/bg/ajax/pages/form/50.html?_=1711378015083 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 50
# [25-Mar-2024 16:46:56] /activa/www/aD3nVpq2C/en/ajax/pages/form/50.html?_=1711378016845 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 50 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'en' AND
                `MenuLabel` <> ''
         AND `ID` != 50
# [25-Mar-2024 16:47:05] /activa/www/aD3nVpq2C/en/ajax/pages/update/50.html?_=1711378025116 108.61.209.243

set names utf8

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

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

UPDATE `pages` SET `ID` = '50', `Language` = 'en', `ParentID` = '33', `PostDate` = '2024-02-29', `LastUpdate` = '2024-03-25 16:47:05', `UploadID` = '6849174619', `MetaTitle` = 'Share Prices | Activa High Yield Fund', `MetaDescription` = '', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Share Prices', `FooterLabel` = '', `URLLabel` = 'share-prices', `Icon` = '', `Image` = '', `Title` = 'Share Prices', `Annotation` = '', `Content` = '', `AddContent` = 'assets/table', `AddOn` = '', `FirstPage` = 0, `Visible` = 1 WHERE `ID` = '50' AND `Language` = 'en'
# [25-Mar-2024 16:47:05] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`), `pages`.`URLLabel`) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    -- `Parent`.`ParentID` = 1 AND // TODO: FULL TEST
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`ParentID` ASC, `pages`.`PostDate` ASC
# [25-Mar-2024 16:47:13] /activa/www/aD3nVpq2C/bg/ajax/pages/form/44.html?_=1711378033603 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 44
# [25-Mar-2024 16:47:15] /activa/www/aD3nVpq2C/en/ajax/pages/form/44.html?_=1711378035591 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 44 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'en' AND
                `MenuLabel` <> ''
         AND `ID` != 44
# [25-Mar-2024 16:47:28] /activa/www/aD3nVpq2C/bg/ajax/pages/form/50.html?_=1711378048674 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 50
# [25-Mar-2024 16:47:31] /activa/www/aD3nVpq2C/en/ajax/pages/form/50.html?_=1711378050940 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 50 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'en' AND
                `MenuLabel` <> ''
         AND `ID` != 50
# [25-Mar-2024 16:47:46] /activa/www/aD3nVpq2C/bg/ajax/pages/form/44.html?_=1711378066593 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 44
# [25-Mar-2024 16:47:49] /activa/www/aD3nVpq2C/en/ajax/pages/form/44.html?_=1711378069190 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 44 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'en' AND
                `MenuLabel` <> ''
         AND `ID` != 44
# [25-Mar-2024 16:48:06] /activa/www/aD3nVpq2C/bg/ajax/pages/form/55.html?_=1711378085993 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 55
# [25-Mar-2024 16:48:08] /activa/www/aD3nVpq2C/en/ajax/pages/form/55.html?_=1711378088365 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 55 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'en' AND
                `MenuLabel` <> ''
         AND `ID` != 55
# [25-Mar-2024 16:48:17] /activa/www/aD3nVpq2C/en/ajax/pages/update/55.html?_=1711378097227 108.61.209.243

set names utf8

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

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

UPDATE `pages` SET `ID` = '55', `Language` = 'en', `ParentID` = '34', `PostDate` = '2024-02-08', `LastUpdate` = '2024-03-25 16:48:17', `UploadID` = '6849411944', `MetaTitle` = 'Share Prices | NMF Activa', `MetaDescription` = '', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Share Prices', `FooterLabel` = '', `URLLabel` = 'share-prices', `Icon` = '', `Image` = '', `Title` = 'Share Prices', `Annotation` = '', `Content` = '', `AddContent` = 'assets/table', `AddOn` = '', `FirstPage` = 0, `Visible` = 1 WHERE `ID` = '55' AND `Language` = 'en'
# [25-Mar-2024 16:48:17] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`), `pages`.`URLLabel`) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    -- `Parent`.`ParentID` = 1 AND // TODO: FULL TEST
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`ParentID` ASC, `pages`.`PostDate` ASC
# [25-Mar-2024 16:49:16] /activa/www/aD3nVpq2C/bg/ajax/users/logout.html?_=1711378156233 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1261816235 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [25-Mar-2024 16:49:16] /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
                `Fund`,
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `ID` IN (SELECT MAX(`ID`) FROM `assets` GROUP BY `Fund`)

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') 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
# [25-Mar-2024 16:49: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 `Action` FROM `pages` WHERE`ID` = 44 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `Fund` = 'balanced'
            ORDER BY
                `PostDate` DESC
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('balanced') 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
# [25-Mar-2024 16:49: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
                `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 `Action` FROM `pages` WHERE`ID` = 50 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'актива-високодоходен-фонд'
	    	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
# [25-Mar-2024 17:02:01] /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 `Action` FROM `pages` WHERE`ID` = 50 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'актива-високодоходен-фонд'
	    	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
# [25-Mar-2024 17:02: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
                `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 `Action` FROM `pages` WHERE`ID` = 50 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `Fund` = 'highyield'
            ORDER BY
                `PostDate` DESC
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('highyield') 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
# [25-Mar-2024 17:02:37] /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 `Action` FROM `pages` WHERE`ID` = 55 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'bg' AND
                    P2.`URLLabel` = 'ндф-актива'
	    	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
# [25-Mar-2024 17:03:02] /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 `Action` FROM `pages` WHERE`ID` = 55 AND
	`Module` = 'pages' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `Fund` = 'ndf'
            ORDER BY
                `PostDate` DESC
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ndf') 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
