# [26-Jun-2024 09:40: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
                `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`,
                    CONCAT(P0.`URLLabel`, '/', P2.`URLLabel`) AS `URLLabel`
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON
                        P1.`ID` = P2.`ID` AND
                        P2.`NoIndex` = 0 AND
                        P2.`Language` != 'bg' AND
                        P2.`Visible` = 1
                    INNER JOIN `pages` AS P0 ON
                        P0.`ID` = P2.`ParentID` AND
                        P0.`Language` = P2.`Language` AND
                        P0.`NoIndex` = 0 AND
                        P0.`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`.`ID`,
                `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`.`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`.`ParentID` = 31
                 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`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 09:40: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.`Language` != 'bg' AND
                        P2.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'index' AND
                    P1.`Visible` = 1

SELECT
                `P1`.`UploadID`,
                `P1`.`URLLabel`,
                `P1`.`Icon`,
                `P1`.`Image`,
                `P1`.`MenuLabel`,
                `P1`.`Annotation`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
            WHERE
                `P1`.`Icon` <> '' AND
                `P1`.`Image` <> '' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Language` = 'bg' AND
                `P1`.`FirstPage` = 1 AND
                `P1`.`Visible` = 1
            ORDER BY `P1`.`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`)
             ORDER BY `PostDate` DESC

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

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:09:42] /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.`Language` != 'bg' AND
                        P2.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'index' AND
                    P1.`Visible` = 1

SELECT
                `P1`.`UploadID`,
                `P1`.`URLLabel`,
                `P1`.`Icon`,
                `P1`.`Image`,
                `P1`.`MenuLabel`,
                `P1`.`Annotation`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
            WHERE
                `P1`.`Icon` <> '' AND
                `P1`.`Image` <> '' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Language` = 'bg' AND
                `P1`.`FirstPage` = 1 AND
                `P1`.`Visible` = 1
            ORDER BY `P1`.`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`)
             ORDER BY `PostDate` DESC

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

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:09:47] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1719389387544 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4vDksOjw4LCpcODw5HDjcOBw6zCs8K-w43DlsObwp7CtsK9%'
            LIMIT 1
# [26-Jun-2024 11:09:47] /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
# [26-Jun-2024 11:09:51] /activa/www/aD3nVpq2C/bg/ajax/pages/form/66.html?_=1719389391313 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` = 66 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` != 66
# [26-Jun-2024 11:09:55] /activa/www/aD3nVpq2C/bg/ajax/pages/form/33.html?_=1719389395176 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'bg' AND
                `MenuLabel` <> ''
         AND `ID` != 33
# [26-Jun-2024 11:29:47] /activa/www/aD3nVpq2C/bg/ajax/pages/form/31.html?_=1719390587582 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` = 31 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` != 31
# [26-Jun-2024 11:29:56] /activa/www/aD3nVpq2C/bg/ajax/pages/form/66.html?_=1719390595804 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` = 66 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` != 66
# [26-Jun-2024 11:30:30] /activa/www/aD3nVpq2C/bg/ajax/pages/upload/8365426470.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
# [26-Jun-2024 11:31:14] /activa/www/aD3nVpq2C/bg/ajax/pages/form/35.html?_=1719390674260 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` = 35 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` != 35
# [26-Jun-2024 11:31:23] /activa/www/aD3nVpq2C/bg/ajax/pages/upload/6682191299.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
# [26-Jun-2024 11:31:26] /activa/www/aD3nVpq2C/bg/ajax/pages/update/35.html?_=1719390686286 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` = '35', `Language` = 'bg', `ParentID` = '1', `PostDate` = '2024-01-09', `LastUpdate` = '2024-06-26 11:31:26', `UploadID` = '6682191299', `MetaTitle` = 'Доверително управление', `MetaDescription` = 'Доверителното управление на личен портфейл представлява услуга за управление на индивидуални портфейли от финансови инструменти и парични средства.', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Доверително управление', `FooterLabel` = '', `URLLabel` = 'доверително-управление', `Icon` = '5.svg', `Image` = 'financial-02.jpg', `Title` = '', `Annotation` = 'Доверителното управление на личен портфейл представлява услуга за управление на индивидуални портфейли от финансови инструменти и парични средства.', `Content` = '', `AddContent` = '', `AddOn` = '', `FirstPage` = 0, `Visible` = 1 WHERE `ID` = '35' AND `Language` = 'bg'
# [26-Jun-2024 11:31:26] /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
# [26-Jun-2024 11:31:30] /activa/www/aD3nVpq2C/bg/ajax/pages/form/66.html?_=1719390690333 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` = 66 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` != 66
# [26-Jun-2024 11:31:35] /activa/www/aD3nVpq2C/bg/ajax/pages/upload/8365426470.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
# [26-Jun-2024 11:31:43] /activa/www/aD3nVpq2C/bg/ajax/pages/update/66.html?_=1719390703414 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` = '66', `Language` = 'bg', `ParentID` = '1', `PostDate` = '2024-01-06', `LastUpdate` = '2024-06-26 11:31:43', `UploadID` = '8365426470', `MetaTitle` = 'Актива Европейска Стратегия', `MetaDescription` = 'Актива Европейска Стратегия е договорен фонд по смисъла на чл. 5, ал. 2 от ЗДКИСДПКИ. Управляващото дружество “Актива Асет Мениджмънт” АД е получило разрешение за организиране и управление на Договорния Фонд № 128 – ДФ от 07.03.2024 г. от КФН.', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Актива Европейска Стратегия', `FooterLabel` = '', `URLLabel` = 'актива-европейска-стратегия', `Icon` = '61.svg', `Image` = 'financial-02.jpg', `Title` = 'Актива Европейска Стратегия', `Annotation` = 'Актива Европейска Стратегия е договорен фонд по смисъла на чл. 5, ал. 2 от ЗДКИСДПКИ. Управляващото дружество “Актива Асет Мениджмънт” АД е получило разрешение за организиране и управление на Договорния Фонд № 128 – ДФ от 07.03.2024 г. от КФН.', `Content` = '', `AddContent` = '', `AddOn` = '', `FirstPage` = 0, `Visible` = 1 WHERE `ID` = '66' AND `Language` = 'bg'
# [26-Jun-2024 11:31:43] /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
# [26-Jun-2024 11:31:49] /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.`Language` != 'bg' AND
                        P2.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'index' AND
                    P1.`Visible` = 1

SELECT
                `P1`.`UploadID`,
                `P1`.`URLLabel`,
                `P1`.`Icon`,
                `P1`.`Image`,
                `P1`.`MenuLabel`,
                `P1`.`Annotation`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
            WHERE
                `P1`.`Icon` <> '' AND
                `P1`.`Image` <> '' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Language` = 'bg' AND
                `P1`.`FirstPage` = 1 AND
                `P1`.`Visible` = 1
            ORDER BY `P1`.`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`)
             ORDER BY `PostDate` DESC

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

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:31:57] /activa/www/aD3nVpq2C/bg/ajax/pages/form/35.html?_=1719390717182 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` = 35 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` != 35
# [26-Jun-2024 11:32:00] /activa/www/aD3nVpq2C/bg/ajax/pages/update/35.html?_=1719390720598 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` = '35', `Language` = 'bg', `ParentID` = '1', `PostDate` = '2024-01-09', `LastUpdate` = '2024-06-26 11:32:00', `UploadID` = '6682191299', `MetaTitle` = 'Доверително управление', `MetaDescription` = 'Доверителното управление на личен портфейл представлява услуга за управление на индивидуални портфейли от финансови инструменти и парични средства.', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Доверително управление', `FooterLabel` = '', `URLLabel` = 'доверително-управление', `Icon` = '5.svg', `Image` = 'financial-02.jpg', `Title` = '', `Annotation` = 'Доверителното управление на личен портфейл представлява услуга за управление на индивидуални портфейли от финансови инструменти и парични средства.', `Content` = '', `AddContent` = '', `AddOn` = '', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '35' AND `Language` = 'bg'
# [26-Jun-2024 11:32:00] /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
# [26-Jun-2024 11:32:03] /activa/www/aD3nVpq2C/bg/ajax/pages/form/35.html?_=1719390723581 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` = 35 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` != 35
# [26-Jun-2024 11:32:09] /activa/www/aD3nVpq2C/bg/ajax/pages/form/66.html?_=1719390729100 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` = 66 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` != 66
# [26-Jun-2024 11:32:12] /activa/www/aD3nVpq2C/bg/ajax/pages/update/66.html?_=1719390731799 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` = '66', `Language` = 'bg', `ParentID` = '1', `PostDate` = '2024-01-06', `LastUpdate` = '2024-06-26 11:32:12', `UploadID` = '8365426470', `MetaTitle` = 'Актива Европейска Стратегия', `MetaDescription` = 'Актива Европейска Стратегия е договорен фонд по смисъла на чл. 5, ал. 2 от ЗДКИСДПКИ. Управляващото дружество “Актива Асет Мениджмънт” АД е получило разрешение за организиране и управление на Договорния Фонд № 128 – ДФ от 07.03.2024 г. от КФН.', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Актива Европейска Стратегия', `FooterLabel` = '', `URLLabel` = 'актива-европейска-стратегия', `Icon` = '61.svg', `Image` = 'financial-02.jpg', `Title` = 'Актива Европейска Стратегия', `Annotation` = 'Актива Европейска Стратегия е договорен фонд по смисъла на чл. 5, ал. 2 от ЗДКИСДПКИ. Управляващото дружество “Актива Асет Мениджмънт” АД е получило разрешение за организиране и управление на Договорния Фонд № 128 – ДФ от 07.03.2024 г. от КФН.', `Content` = '', `AddContent` = '', `AddOn` = '', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '66' AND `Language` = 'bg'
# [26-Jun-2024 11:32:12] /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
# [26-Jun-2024 11:32:13] /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.`Language` != 'bg' AND
                        P2.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'index' AND
                    P1.`Visible` = 1

SELECT
                `P1`.`UploadID`,
                `P1`.`URLLabel`,
                `P1`.`Icon`,
                `P1`.`Image`,
                `P1`.`MenuLabel`,
                `P1`.`Annotation`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
            WHERE
                `P1`.`Icon` <> '' AND
                `P1`.`Image` <> '' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Language` = 'bg' AND
                `P1`.`FirstPage` = 1 AND
                `P1`.`Visible` = 1
            ORDER BY `P1`.`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`)
             ORDER BY `PostDate` DESC

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

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:32:30] /activa/www/bg/актива-европейска-стратегия/инвестиционна-стратегия.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'актива-европейска-стратегия' -- AND
                -- `ParentID` = 1 AND // TODO: FULL TEST
                -- (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

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

SELECT
                    P1.`MenuLabel` AS `ParentTitle`,
                    IF(`P2`.`Image` <> '',
                            CONCAT('pages/', `P2`.`UploadID`, '/i_', `P2`.`Image`),
                            CONCAT('pages/', `P1`.`UploadID`, '/i_', `P1`.`Image`)
                    ) AS `HeaderImage`,
                    P2.*
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON P2.`ParentID` = P1.`ID` AND P2.`Language` = P1.`Language`
                WHERE
                    -- P1.`ParentID` = 1 AND // TODO: FULL TEST
                    P1.`URLLabel` = 'актива-европейска-стратегия' AND
                    P2.`Language` = 'bg' AND
                    P2.`Module` = 'pages' AND
                    P2.`URLLabel` = 'инвестиционна-стратегия'
             AND P2.`Visible` = 1 LIMIT 1

SELECT
                    P2.`Language`,
                    CONCAT(P0.`URLLabel`, '/', P2.`URLLabel`) AS `URLLabel`
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON
                        P1.`ID` = P2.`ID` AND
                        P2.`NoIndex` = 0 AND
                        P2.`Language` != 'bg' AND
                        P2.`Visible` = 1
                    INNER JOIN `pages` AS P0 ON
                        P0.`ID` = P2.`ParentID` AND
                        P0.`Language` = P2.`Language` AND
                        P0.`NoIndex` = 0 AND
                        P0.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'инвестиционна-стратегия' AND
                    P1.`Visible` = 1

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:32:37] /activa/www/aD3nVpq2C/bg/ajax/pages/form/66.html?_=1719390757101 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` = 66 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` != 66
# [26-Jun-2024 11:32:44] /activa/www/aD3nVpq2C/bg/ajax/pages/update/66.html?_=1719390764294 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` = '66', `Language` = 'bg', `ParentID` = '1', `PostDate` = '2024-01-06', `LastUpdate` = '2024-06-26 11:32:44', `UploadID` = '8365426470', `MetaTitle` = 'Актива Европейска Стратегия', `MetaDescription` = 'Актива Европейска Стратегия е договорен фонд по смисъла на чл. 5, ал. 2 от ЗДКИСДПКИ. Управляващото дружество “Актива Асет Мениджмънт” АД е получило разрешение за организиране и управление на Договорния Фонд № 128 – ДФ от 07.03.2024 г. от КФН.', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Актива Европейска Стратегия', `FooterLabel` = '', `URLLabel` = 'актива-европейска-стратегия', `Icon` = '61.svg', `Image` = 'financial-02.jpg', `Title` = 'Актива Европейска Стратегия', `Annotation` = 'Актива Европейска Стратегия е 
договорен фонд по смисъла на чл. 5, ал. 2 от ЗДКИСДПКИ. Управляващото 
дружество “Актива Асет Мениджмънт” АД е получило разрешение за 
организиране и управление на Договорния Фонд № 128 – ДФ от 07.03.2024 г.
 от КФН. Управляващото Дружество управлява Фонда под постоянния надзор 
на КФН.<br>Основни цели на Договорния Фонд е осигуряването на 
дългосрочен ръст на стойността на неговите инвестиции, както и 
нарастване на стойността на инвестициите на притежателите на дялове на 
Фонда чрез реализиране на максимален възможен доход при поемане на висок
 риск и осигуряване на висока ликвидност на инвестициите на 
притежателите на дялове.', `Content` = '', `AddContent` = '', `AddOn` = '', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '66' AND `Language` = 'bg'
# [26-Jun-2024 11:32:44] /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
# [26-Jun-2024 11:32:46] /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`,
                    CONCAT(P0.`URLLabel`, '/', P2.`URLLabel`) AS `URLLabel`
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON
                        P1.`ID` = P2.`ID` AND
                        P2.`NoIndex` = 0 AND
                        P2.`Language` != 'bg' AND
                        P2.`Visible` = 1
                    INNER JOIN `pages` AS P0 ON
                        P0.`ID` = P2.`ParentID` AND
                        P0.`Language` = P2.`Language` AND
                        P0.`NoIndex` = 0 AND
                        P0.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'инвестиционна-стратегия' AND
                    P1.`Visible` = 1

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:32:47] /activa/www/ 108.61.209.243

set names utf8

SELECT
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `Language` = 'bg' AND
                    `Module` = 'pages' AND
    	    		`URLLabel` = 'index'
             AND `Visible` = 1 LIMIT 1

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

SELECT
                `P1`.`UploadID`,
                `P1`.`URLLabel`,
                `P1`.`Icon`,
                `P1`.`Image`,
                `P1`.`MenuLabel`,
                `P1`.`Annotation`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
            WHERE
                `P1`.`Icon` <> '' AND
                `P1`.`Image` <> '' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Language` = 'bg' AND
                `P1`.`FirstPage` = 1 AND
                `P1`.`Visible` = 1
            ORDER BY `P1`.`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`)
             ORDER BY `PostDate` DESC

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

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:33:00] /activa/www/aD3nVpq2C/bg/ajax/pages/form/66.html?_=1719390780364 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` = 66 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` != 66
# [26-Jun-2024 11:33:05] /activa/www/aD3nVpq2C/bg/ajax/pages/update/66.html?_=1719390785293 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` = '66', `Language` = 'bg', `ParentID` = '1', `PostDate` = '2024-01-06', `LastUpdate` = '2024-06-26 11:33:05', `UploadID` = '8365426470', `MetaTitle` = 'Актива Европейска Стратегия', `MetaDescription` = 'Актива Европейска Стратегия е договорен фонд по смисъла на чл. 5, ал. 2 от ЗДКИСДПКИ. Управляващото дружество “Актива Асет Мениджмънт” АД е получило разрешение за организиране и управление на Договорния Фонд № 128 – ДФ от 07.03.2024 г. от КФН.', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Актива Европейска Стратегия', `FooterLabel` = '', `URLLabel` = 'актива-европейска-стратегия', `Icon` = '61.svg', `Image` = 'financial-02.jpg', `Title` = 'Актива Европейска Стратегия', `Annotation` = 'Актива Европейска Стратегия е 
договорен фонд по смисъла на чл. 5, ал. 2 от ЗДКИСДПКИ. Управляващото 
дружество “Актива Асет Мениджмънт” АД е получило разрешение за 
организиране и управление на Договорния Фонд № 128 – ДФ от 07.03.2024 г.
 от КФН. Управляващото Дружество управлява Фонда под постоянния надзор 
на КФН.<br>', `Content` = '', `AddContent` = '', `AddOn` = '', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '66' AND `Language` = 'bg'
# [26-Jun-2024 11:33: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
# [26-Jun-2024 11:33:07] /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.`Language` != 'bg' AND
                        P2.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'index' AND
                    P1.`Visible` = 1

SELECT
                `P1`.`UploadID`,
                `P1`.`URLLabel`,
                `P1`.`Icon`,
                `P1`.`Image`,
                `P1`.`MenuLabel`,
                `P1`.`Annotation`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
            WHERE
                `P1`.`Icon` <> '' AND
                `P1`.`Image` <> '' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Language` = 'bg' AND
                `P1`.`FirstPage` = 1 AND
                `P1`.`Visible` = 1
            ORDER BY `P1`.`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`)
             ORDER BY `PostDate` DESC

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

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:33: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`,
                    CONCAT(P0.`URLLabel`, '/', P2.`URLLabel`) AS `URLLabel`
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON
                        P1.`ID` = P2.`ID` AND
                        P2.`NoIndex` = 0 AND
                        P2.`Language` != 'bg' AND
                        P2.`Visible` = 1
                    INNER JOIN `pages` AS P0 ON
                        P0.`ID` = P2.`ParentID` AND
                        P0.`Language` = P2.`Language` AND
                        P0.`NoIndex` = 0 AND
                        P0.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'инвестиционна-стратегия' AND
                    P1.`Visible` = 1

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:33:20] /activa/www/aD3nVpq2C/bg/ajax/pages/form/35.html?_=1719390800695 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` = 35 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` != 35
# [26-Jun-2024 11:33:25] /activa/www/aD3nVpq2C/bg/ajax/pages/update/35.html?_=1719390804925 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` = '35', `Language` = 'bg', `ParentID` = '1', `PostDate` = '2024-01-09', `LastUpdate` = '2024-06-26 11:33:25', `UploadID` = '6682191299', `MetaTitle` = 'Доверително управление', `MetaDescription` = 'Доверителното управление на личен портфейл представлява услуга за управление на индивидуални портфейли от финансови инструменти и парични средства.', `MetaImage` = '', `NoIndex` = 0, `MenuLabel` = 'Доверително управление', `FooterLabel` = '', `URLLabel` = 'доверително-управление', `Icon` = '5.svg', `Image` = 'financial-02.jpg', `Title` = '', `Annotation` = 'Доверителното управление на личен портфейл представлява услуга за 
управление на индивидуални портфейли от финансови инструменти и парични 
средства. Актива Асет Мениджмънт има отговорността да управлява активите
 Ви в съответствие с договорените условия, предпочитаната от Вас 
инвестиционна стратегия и приемливо ниво на риск.', `Content` = '', `AddContent` = '', `AddOn` = '', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '35' AND `Language` = 'bg'
# [26-Jun-2024 11:33:25] /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
# [26-Jun-2024 11:33:27] /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.`Language` != 'bg' AND
                        P2.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'index' AND
                    P1.`Visible` = 1

SELECT
                `P1`.`UploadID`,
                `P1`.`URLLabel`,
                `P1`.`Icon`,
                `P1`.`Image`,
                `P1`.`MenuLabel`,
                `P1`.`Annotation`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
            WHERE
                `P1`.`Icon` <> '' AND
                `P1`.`Image` <> '' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Language` = 'bg' AND
                `P1`.`FirstPage` = 1 AND
                `P1`.`Visible` = 1
            ORDER BY `P1`.`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`)
             ORDER BY `PostDate` DESC

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

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:33:42] /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`,
                    CONCAT(P0.`URLLabel`, '/', P2.`URLLabel`) AS `URLLabel`
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON
                        P1.`ID` = P2.`ID` AND
                        P2.`NoIndex` = 0 AND
                        P2.`Language` != 'bg' AND
                        P2.`Visible` = 1
                    INNER JOIN `pages` AS P0 ON
                        P0.`ID` = P2.`ParentID` AND
                        P0.`Language` = P2.`Language` AND
                        P0.`NoIndex` = 0 AND
                        P0.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'инвестиционна-стратегия' AND
                    P1.`Visible` = 1

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:34:40] /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`,
                    CONCAT(P0.`URLLabel`, '/', P2.`URLLabel`) AS `URLLabel`
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON
                        P1.`ID` = P2.`ID` AND
                        P2.`NoIndex` = 0 AND
                        P2.`Language` != 'bg' AND
                        P2.`Visible` = 1
                    INNER JOIN `pages` AS P0 ON
                        P0.`ID` = P2.`ParentID` AND
                        P0.`Language` = P2.`Language` AND
                        P0.`NoIndex` = 0 AND
                        P0.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'инвестиционна-стратегия' AND
                    P1.`Visible` = 1

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:35:11] /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`,
                    CONCAT(P0.`URLLabel`, '/', P2.`URLLabel`) AS `URLLabel`
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON
                        P1.`ID` = P2.`ID` AND
                        P2.`NoIndex` = 0 AND
                        P2.`Language` != 'bg' AND
                        P2.`Visible` = 1
                    INNER JOIN `pages` AS P0 ON
                        P0.`ID` = P2.`ParentID` AND
                        P0.`Language` = P2.`Language` AND
                        P0.`NoIndex` = 0 AND
                        P0.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'инвестиционна-стратегия' AND
                    P1.`Visible` = 1

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:42:42] /activa/www/en/ 108.61.209.243

set names utf8

SELECT
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `Language` = 'en' AND
                    `Module` = 'pages' AND
    	    		`URLLabel` = 'index'
             AND `Visible` = 1 LIMIT 1

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

SELECT
                `P1`.`UploadID`,
                `P1`.`URLLabel`,
                `P1`.`Icon`,
                `P1`.`Image`,
                `P1`.`MenuLabel`,
                `P1`.`Annotation`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
            WHERE
                `P1`.`Icon` <> '' AND
                `P1`.`Image` <> '' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Language` = 'en' AND
                `P1`.`FirstPage` = 1 AND
                `P1`.`Visible` = 1
            ORDER BY `P1`.`PostDate` ASC

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

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

SELECT
                `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`)
             ORDER BY `PostDate` DESC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ndf') AND
                `Language` = 'en'
             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` = 'en' AND
                    P2.`Module` = 'events'
             AND P2.`Visible` = 1 LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewAllNews') AND
                `Language` = 'en'
             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`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'en' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:43:55] /activa/www/en/terms-and-conditions.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
	    		`URLLabel` = 'terms-and-conditions' -- 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` = 'en' AND
                    `Module` = 'terms' AND
    	    		`URLLabel` = 'terms-and-conditions'
             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.`Language` != 'en' AND
                        P2.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'en' AND
                    P1.`URLLabel` = 'terms-and-conditions' AND
                    P1.`Visible` = 1

SELECT
                `P1`.`ID`,
                `P1`.`URLLabel`
	        FROM
	        	`pages` `P1`
                INNER JOIN `pages` `P2` ON
                    `P1`.`ID` = `P2`.`ID` AND
                    `P2`.`Language` = 'en' AND
                    `P2`.`URLLabel` = 'terms-and-conditions'
	    	WHERE
                `P1`.`Language` = 'bg'
         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`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'en' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'en'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:43: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
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `Language` = 'bg' AND
                    `Module` = 'terms' 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.`Language` != 'bg' AND
                        P2.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'условия-на-сайта' AND
                    P1.`Visible` = 1

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:44:29] /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.`Language` != 'bg' AND
                        P2.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'index' AND
                    P1.`Visible` = 1

SELECT
                `P1`.`UploadID`,
                `P1`.`URLLabel`,
                `P1`.`Icon`,
                `P1`.`Image`,
                `P1`.`MenuLabel`,
                `P1`.`Annotation`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
            WHERE
                `P1`.`Icon` <> '' AND
                `P1`.`Image` <> '' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Language` = 'bg' AND
                `P1`.`FirstPage` = 1 AND
                `P1`.`Visible` = 1
            ORDER BY `P1`.`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`)
             ORDER BY `PostDate` DESC

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

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:44:32] /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`,
                    CONCAT(P0.`URLLabel`, '/', P2.`URLLabel`) AS `URLLabel`
                FROM
                    `pages` AS P1
                    INNER JOIN `pages` AS P2 ON
                        P1.`ID` = P2.`ID` AND
                        P2.`NoIndex` = 0 AND
                        P2.`Language` != 'bg' AND
                        P2.`Visible` = 1
                    INNER JOIN `pages` AS P0 ON
                        P0.`ID` = P2.`ParentID` AND
                        P0.`Language` = P2.`Language` AND
                        P0.`NoIndex` = 0 AND
                        P0.`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`.`ID`,
                `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`.`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`.`ParentID` = 31
                 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`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language` AND
                    `P2`.`MenuLabel` <> ''
            WHERE
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:44:34] /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 `Action` FROM `pages` WHERE`Module` = 'contacts' AND
	`URLLabel` = 'контакти' AND
	`Language` = 'bg' 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` = 'contacts' AND
                    P2.`URLLabel` = 'контакти'
             AND P2.`Visible` = 1 LIMIT 1

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

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:44:35] /activa/www/bg/ajax/contacts/form.html?_=1719391475476 108.61.209.243

set names utf8

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

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

SELECT
                    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` = 'terms'
             AND P2.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:44:38] /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` = 'terms' 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.`Language` != 'bg' AND
                        P2.`Visible` = 1
                WHERE
                    P1.`NoIndex` = 0 AND
                    P1.`Language` = 'bg' AND
                    P1.`URLLabel` = 'условия-на-сайта' AND
                    P1.`Visible` = 1

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Jun-2024 11:49:09] /activa/www/ 108.61.209.243

set names utf8

SELECT
                    *,
                    CONCAT('pages/', `UploadID`, '/i_', `Image`) AS `HeaderImage`
    	        FROM
    	        	`pages`
    	    	WHERE
                    -- `ParentID` = 1 AND // TODO: full test
                    `Language` = 'bg' AND
                    `Module` = 'pages' AND
    	    		`URLLabel` = 'index'
             AND `Visible` = 1 LIMIT 1

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

SELECT
                `P1`.`UploadID`,
                `P1`.`URLLabel`,
                `P1`.`Icon`,
                `P1`.`Image`,
                `P1`.`MenuLabel`,
                `P1`.`Annotation`,
                (SELECT `URLLabel` FROM `pages` WHERE `ParentID` = `P1`.`ID` AND `P1`.`ParentID` = 1 AND `Language` = `P1`.`Language` ORDER BY `PostDate` LIMIT 1) AS `ChildURLLabel`
            FROM
                `pages` AS `P1`
            WHERE
                `P1`.`Icon` <> '' AND
                `P1`.`Image` <> '' AND
                `P1`.`MenuLabel` <> '' AND
                `P1`.`Language` = 'bg' AND
                `P1`.`FirstPage` = 1 AND
                `P1`.`Visible` = 1
            ORDER BY `P1`.`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`)
             ORDER BY `PostDate` DESC

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

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

SELECT `Title`, `URLLabel` FROM `pages` WHERE`Module` = 'pages' AND
	`Action` = 'top' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `P1`.`FooterLabel`,
                `P1`.`URLLabel`,
                `P2`.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS `P1`
                LEFT JOIN `pages` AS `P2` ON
                    `P2`.`ID` = `P1`.`ParentID` AND
                    `P2`.`Language` = `P1`.`Language`
            WHERE
                `P1`.`FooterLabel` <> '' AND
                `P1`.`Visible` = 1 AND
                `P1`.`Language` = 'bg'
            GROUP BY
                `P1`.`ID`
            ORDER BY
                `P1`.`ParentID` ASC,
                `P1`.`PostDate` ASC

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