# [26-Feb-2024 11:25:08] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708939508847 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '5j6qnvU2D5mBHQcLXKq52Bb62aysHUSpniWbrr0aNTwM9FLGk1an6X8uudkixy0g'
            WHERE
                `UserKey` LIKE 'wr7DjsOSw4DDjsK7w5zCtsKaw6fCs8OGw4zDn8OZw6DCvMK_wrXCiMOGw5M%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [26-Feb-2024 11:29:40] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708939780079 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '5j6qnvU2D5mBHQcLXKq52Bb62aysHUSpniWbrr0aNTwM9FLGk1an6X8uudkixy0g'
            LIMIT 1
# [26-Feb-2024 11:29:56] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708939796813 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '5j6qnvU2D5mBHQcLXKq52Bb62aysHUSpniWbrr0aNTwM9FLGk1an6X8uudkixy0g'
            LIMIT 1
# [26-Feb-2024 11:30:00] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708939800114 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '5j6qnvU2D5mBHQcLXKq52Bb62aysHUSpniWbrr0aNTwM9FLGk1an6X8uudkixy0g'
            LIMIT 1
# [26-Feb-2024 11:30:00] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708939800238 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '5j6qnvU2D5mBHQcLXKq52Bb62aysHUSpniWbrr0aNTwM9FLGk1an6X8uudkixy0g'
            LIMIT 1
# [26-Feb-2024 11:34:17] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708940057294 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '5j6qnvU2D5mBHQcLXKq52Bb62aysHUSpniWbrr0aNTwM9FLGk1an6X8uudkixy0g'
            LIMIT 1
# [26-Feb-2024 11:46:37] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708940798036 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '5j6qnvU2D5mBHQcLXKq52Bb62aysHUSpniWbrr0aNTwM9FLGk1an6X8uudkixy0g'
            LIMIT 1
# [26-Feb-2024 11:46:39] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708940799144 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '5j6qnvU2D5mBHQcLXKq52Bb62aysHUSpniWbrr0aNTwM9FLGk1an6X8uudkixy0g'
            LIMIT 1
# [26-Feb-2024 11:56:02] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708941362542 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '5j6qnvU2D5mBHQcLXKq52Bb62aysHUSpniWbrr0aNTwM9FLGk1an6X8uudkixy0g'
            LIMIT 1
# [26-Feb-2024 11:56:03] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708941363549 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '5j6qnvU2D5mBHQcLXKq52Bb62aysHUSpniWbrr0aNTwM9FLGk1an6X8uudkixy0g'
            LIMIT 1
# [26-Feb-2024 12:09:24] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708942164133 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'hojn2GL9anXbX06XsbcE6M26pRB1OJk2F8GmrOe692iY1sg0PlPclR1yBnxnM7kq'
            WHERE
                `UserKey` LIKE 'wr7DjsOSw4DDjsK7w5zCtsKaw6fCs8OGw4zDn8OZw6DCvMK_wrXCiMOGw5M%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [26-Feb-2024 12:09:40] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708942180552 108.61.209.243

set names utf8

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

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 2
            LIMIT 1
# [26-Feb-2024 12:09:40] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 2982949230 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-Feb-2024 16:45:08] /activa/www/aD3nVpq2C/bg/pages/list.html?sort=30 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 2982949230 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`.`URLLabel` ASC
# [26-Feb-2024 16:45:10] /activa/www/aD3nVpq2C/bg/pages/list.html?sort=31 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 2982949230 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`.`URLLabel` DESC
# [26-Feb-2024 16:45:10] /activa/www/aD3nVpq2C/bg/pages/list.html?sort=20 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 2982949230 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`.`MenuLabel` ASC
# [26-Feb-2024 16:45:13] /activa/www/aD3nVpq2C/bg/pages/list.html?sort=30 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 2982949230 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`.`URLLabel` ASC
# [26-Feb-2024 16:45:14] /activa/www/aD3nVpq2C/bg/pages/list.html?sort=01 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 2982949230 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`.`PostDate` DESC
# [26-Feb-2024 16:45:15] /activa/www/aD3nVpq2C/bg/pages/list.html?sort=11 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 2982949230 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`.`LastUpdate` DESC
# [26-Feb-2024 16:50:28] /activa/www/aD3nVpq2C/bg/pages/list.html?sort=11 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 2982949230 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`.`LastUpdate` DESC
# [26-Feb-2024 16:50:31] /activa/www/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [26-Feb-2024 16:50:35] /activa/www/aD3nVpq2C/bg/events/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 16:52:01] /activa/www/aD3nVpq2C/bg/events/list.html?sort=00 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` ASC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` ASC) AS CountTable
# [26-Feb-2024 16:52:03] /activa/www/aD3nVpq2C/bg/events/list.html?sort=01 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 16:52:42] /activa/www/aD3nVpq2C/bg/ajax/events/form/2.html?_=1708959163135 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 16:53:19] /activa/www/aD3nVpq2C/en/ajax/events/form/2.html?_=1708959200214 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2
            LIMIT 1
# [26-Feb-2024 16:58:01] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/2.html?URLLabel=0YHQtdCz0LzQtdC90YIt0LfQsC3QsdC-0YDRgdC-0LLQvi3RgtGK0YDQs9GD0LLQsNC90Lgt0L_RgNC-0LTRg9C60YLQuA&_=1708959481647 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'сегмент-за-борсово-търгувани-продукти'  AND `ID` != '2' AND `Language` = 'en'
# [26-Feb-2024 16:58:17] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/2.html?URLLabel=ZXhjaGFuZ2UtdHJhZGVkLWZ1bmQ&_=1708959498140 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'exchange-traded-fund'  AND `ID` != '2' AND `Language` = 'en'
# [26-Feb-2024 16:59:10] /activa/www/aD3nVpq2C/bg/events/list.html?sort=01 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 16:59:16] /activa/www/aD3nVpq2C/bg/ajax/events/form/2.html?_=1708959556924 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 16:59:17] /activa/www/aD3nVpq2C/en/ajax/events/form/2.html?_=1708959558612 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2
            LIMIT 1
# [26-Feb-2024 16:59:43] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/2.html?URLLabel=ZXhjaGFuZ2UtdHJhZGVkLWZ1bmQ&_=1708959584524 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'exchange-traded-fund'  AND `ID` != '2' AND `Language` = 'en'
# [26-Feb-2024 16:59:45] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/2.html?URLLabel=ZXhjaGFuZ2UtdHJhZGVkLWZ1bmQ&_=1708959586061 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'exchange-traded-fund'  AND `ID` != '2' AND `Language` = 'en'
# [26-Feb-2024 16:59:45] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/2.html?URLLabel=ZXhjaGFuZ2UtdHJhZGVkLWZ1bmQ&_=1708959586069 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'exchange-traded-fund'  AND `ID` != '2' AND `Language` = 'en'
# [26-Feb-2024 16:59:47] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/2.html?URLLabel=ZXhjaGFuZ2UtdHJhZGVkLWZ1bmQ&_=1708959588707 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'exchange-traded-fund'  AND `ID` != '2' AND `Language` = 'en'
# [26-Feb-2024 17:01:05] /activa/www/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '51roE2aQDEwud8188NaGg65RDXEYVaD0ao4n1SAKOi185Flog965a6YzVQTFC7H1'
            WHERE
                `UserKey` LIKE 'w4vDksOjw4LCpcODw5HDjcOBw6zCs8K-w43DlsObwp7CtsK9%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [26-Feb-2024 17:01:10] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1708959670660 108.61.209.243

set names utf8

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

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [26-Feb-2024 17:01:10] /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-Feb-2024 17:01:15] /activa/www/aD3nVpq2C/bg/events/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 17:01:20] /activa/www/aD3nVpq2C/bg/ajax/events/form/2.html?_=1708959680835 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
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 17:01:23] /activa/www/aD3nVpq2C/en/ajax/events/form/2.html?_=1708959683318 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
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2
            LIMIT 1
# [26-Feb-2024 17:02:17] /activa/www/aD3nVpq2C/bg/events/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 17:02:19] /activa/www/aD3nVpq2C/bg/ajax/events/form/2.html?_=1708959739507 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
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 17:02:24] /activa/www/aD3nVpq2C/bg/ajax/events/update/2.html?_=1708959744677 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 `events` LIMIT 1

SHOW COLUMNS FROM `events`

UPDATE `events` SET `ID` = '2', `Language` = 'bg', `PostDate` = '2022-04-05', `StartFrom` = NULL, `EndTo` = NULL, `LastUpdate` = '2024-02-26 17:02:24', `UploadID` = '7287887167', `MetaTitle` = 'Борсово 123 търгуван фонд "Актива Балансиран ETF" - Въвеждане за търговия на „Сегмент за борсово търгувани продукти” на БФБ АД', `MetaDescription` = 'Уведомяваме Ви, че Комисията за финансов надзор с Решение № 193-ДФ/11.03.2022 г., издаде одобрение на Управляващо дружество "Актива Асет Мениджмънт" АД за промяна в Правилата на управлявания от него Борсово търгуван фонд "Актива Балансиран ETF". ', `MetaImage` = '', `NoIndex` = 0, `Title` = 'Борсово търгуван фонд "Актива Балансиран ETF" - Въвеждане за търговия на „Сегмент за борсово търгувани продукти” на БФБ АД', `URLLabel` = 'сегмент-за-борсово-търгувани-продукти', `Annotation` = 'Уведомяваме Ви, че Комисията за финансов надзор с Решение № 193-ДФ/11.03.2022 г., издаде одобрение на Управляващо дружество "Актива Асет Мениджмънт" АД за промяна в Правилата на управлявания от него Борсово търгуван фонд "Актива Балансиран ETF". ', `Content` = 'Уведомяваме Ви, че Комисията за финансов надзор с Решение № 193-ДФ/11.03.2022 г., издаде одобрение на Управляващо дружество "Актива Асет Мениджмънт" АД за промяна в Правилата на управлявания от него Борсово търгуван фонд "Актива Балансиран ETF". Във връзка с горното Борсово търгуван фонд "Актива Балансиран ETF" се въвежда за търговия на „Сегмент за борсово търгувани продукти” на 06.04.2022 г.<br><ul><li>ЕИК на фонда: 175373053;</li><li>LEI код на фонда: 74780060663HISKHE671;</li><li>ISIN код на емисията: BG9000019075;</li><li>Борсов код на емисията: ACTB;</li><li>CFI код на емисията: CIOIRS;</li><li>Вид на дяловете: безналични, поименни, свободно прехвърляеми;</li><li>Размер на емисията: променлив;</li><li>Номинална стойност на един дял: 10.00 /десет/ лв.;</li><li>Валута на издаване: лева;</li><li>Валута на търговия: лева;</li><li>Дата на въвеждане за търговия: 06.04.2022 г. (сряда);</li><li>Сегментен MIC: ZBUL;</li><li>Пазарна партида (лот): един дял;</li><li>Индикативна референтна цена за първата търговска сесия: 2.1650 лв.;</li></ul>', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '2' AND `Language` = 'bg'
# [26-Feb-2024 17:02:24] /activa/www/aD3nVpq2C/bg/events/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 17:02:27] /activa/www/aD3nVpq2C/bg/ajax/events/form/2.html?_=1708959747988 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
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 17:02:34] /activa/www/aD3nVpq2C/bg/ajax/events/update/2.html?_=1708959754405 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 `events` LIMIT 1

SHOW COLUMNS FROM `events`

UPDATE `events` SET `ID` = '2', `Language` = 'bg', `PostDate` = '2022-04-05', `StartFrom` = NULL, `EndTo` = NULL, `LastUpdate` = '2024-02-26 17:02:34', `UploadID` = '7287887167', `MetaTitle` = 'Борсово търгуван фонд "Актива Балансиран ETF" - Въвеждане за търговия на „Сегмент за борсово търгувани продукти” на БФБ АД', `MetaDescription` = 'Уведомяваме Ви, че Комисията за финансов надзор с Решение № 193-ДФ/11.03.2022 г., издаде одобрение на Управляващо дружество "Актива Асет Мениджмънт" АД за промяна в Правилата на управлявания от него Борсово търгуван фонд "Актива Балансиран ETF". ', `MetaImage` = '', `NoIndex` = 0, `Title` = 'Борсово търгуван фонд "Актива Балансиран ETF" - Въвеждане за търговия на „Сегмент за борсово търгувани продукти” на БФБ АД', `URLLabel` = 'сегмент-за-борсово-търгувани-продукти', `Annotation` = 'Уведомяваме Ви, че Комисията за финансов надзор с Решение № 193-ДФ/11.03.2022 г., издаде одобрение на Управляващо дружество "Актива Асет Мениджмънт" АД за промяна в Правилата на управлявания от него Борсово търгуван фонд "Актива Балансиран ETF". ', `Content` = 'Уведомяваме Ви, че Комисията за финансов надзор с Решение № 193-ДФ/11.03.2022 г., издаде одобрение на Управляващо дружество "Актива Асет Мениджмънт" АД за промяна в Правилата на управлявания от него Борсово търгуван фонд "Актива Балансиран ETF". Във връзка с горното Борсово търгуван фонд "Актива Балансиран ETF" се въвежда за търговия на „Сегмент за борсово търгувани продукти” на 06.04.2022 г.<br><ul><li>ЕИК на фонда: 175373053;</li><li>LEI код на фонда: 74780060663HISKHE671;</li><li>ISIN код на емисията: BG9000019075;</li><li>Борсов код на емисията: ACTB;</li><li>CFI код на емисията: CIOIRS;</li><li>Вид на дяловете: безналични, поименни, свободно прехвърляеми;</li><li>Размер на емисията: променлив;</li><li>Номинална стойност на един дял: 10.00 /десет/ лв.;</li><li>Валута на издаване: лева;</li><li>Валута на търговия: лева;</li><li>Дата на въвеждане за търговия: 06.04.2022 г. (сряда);</li><li>Сегментен MIC: ZBUL;</li><li>Пазарна партида (лот): един дял;</li><li>Индикативна референтна цена за първата търговска сесия: 2.1650 лв.;</li></ul>', `FirstPage` = 1, `Visible` = 1 WHERE `ID` = '2' AND `Language` = 'bg'
# [26-Feb-2024 17:02:34] /activa/www/aD3nVpq2C/bg/events/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 17:03:15] /activa/www/aD3nVpq2C/bg/ajax/events/form/1.html?_=1708959795875 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
                `events`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 17:03:20] /activa/www/aD3nVpq2C/en/ajax/events/form/1.html?_=1708959800279 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
                `events`
            WHERE
                `ID` = 1 AND
                `Language` = 'en'
            LIMIT 1
# [26-Feb-2024 17:03:26] /activa/www/aD3nVpq2C/bg/ajax/events/form/2.html?_=1708959807043 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
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 17:03:29] /activa/www/aD3nVpq2C/en/ajax/events/form/2.html?_=1708959809798 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
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2
            LIMIT 1
# [26-Feb-2024 17:26:04] /activa/www/aD3nVpq2C/bg/events/list.html?sort=01 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 17:26:11] /activa/www/aD3nVpq2C/bg/ajax/events/form/2.html?_=1708961171927 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 17:26:21] /activa/www/aD3nVpq2C/en/ajax/events/form/2.html?_=1708961182474 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2
            LIMIT 1
# [26-Feb-2024 17:26:34] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/2.html?URLLabel=ZXhjaGFuZ2UtdHJhZGVkLWZ1bmQ&_=1708961194913 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'exchange-traded-fund'  AND `ID` != '2' AND `Language` = 'en'
# [26-Feb-2024 17:26:35] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/2.html?URLLabel=ZXhjaGFuZ2UtdHJhZGVkLWZ1bmQ&_=1708961196263 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'exchange-traded-fund'  AND `ID` != '2' AND `Language` = 'en'
# [26-Feb-2024 17:26:35] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/2.html?URLLabel=ZXhjaGFuZ2UtdHJhZGVkLWZ1bmQ&_=1708961196270 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'exchange-traded-fund'  AND `ID` != '2' AND `Language` = 'en'
# [26-Feb-2024 17:26:36] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/2.html?URLLabel=ZXhjaGFuZ2UtdHJhZGVkLWZ1bmQ&_=1708961197612 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'exchange-traded-fund'  AND `ID` != '2' AND `Language` = 'en'
# [26-Feb-2024 17:26:47] /activa/www/aD3nVpq2C/en/ajax/events/insert/2.html?_=1708961207832 108.61.209.243

set names utf8

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

SELECT * FROM `events` LIMIT 1

SHOW COLUMNS FROM `events`

INSERT INTO `events` SET `ID` = '2', `Language` = 'en', `PostDate` = '2022-04-05', `StartFrom` = NULL, `EndTo` = NULL, `LastUpdate` = '2024-02-26 17:26:47', `UploadID` = '7287887167', `MetaTitle` = 'Exchange Traded Fund ACTIVA BALANCED ETF - Admission to trading on the Exchange Traded Products Segment of the BSE Main Market', `MetaDescription` = 'We would like to inform you that the Financial Supervision Commission by Decision № 193-DF / 11.03.2022 issued an approval to the MC "Activa Asset Management" AD to change the Rules of the Exchange Traded Fund ACTIVA BALANCED ETF.', `MetaImage` = '', `NoIndex` = 0, `Title` = 'Exchange Traded Fund ACTIVA BALANCED ETF - Admission to trading on the Exchange Traded Products Segment of the BSE Main Market', `URLLabel` = 'exchange-traded-fund', `Annotation` = 'We would like to inform you that the Financial Supervision Commission by Decision № 193-DF / 11.03.2022 issued an approval to the MC "Activa Asset Management" AD to change the Rules of the Exchange Traded Fund ACTIVA BALANCED ETF.', `Content` = 'We would like to inform you that the Financial Supervision Commission by Decision № 193-DF / 11.03.2022 issued an approval to the MC "Activa Asset Management" AD to change the Rules of the Exchange Traded Fund ACTIVA BALANCED ETF. In connection with the above, Exchange traded fund ACTIVA BALANCED ETF is starting for trading on Exchange Traded Products Segment of the BSE Main Market on 06.04.2022.<br><div><ul><li>UIC: 175373053</li><li>LEI code of the fund: 74780060663HISKHE671</li><li>ISIN of the issue of units: BG9000019075</li><li>BSE code of the issue of units: ACTB</li><li>CFI code of the issue: CIOIRS</li><li>Type of units: Dematerialised, registered and freely transferable</li><li>Amount of the issue: Floating</li><li>Nominal value per unit: BGN 10.00 /ten Bulgarian leva/</li><li>Issuance currency: BGN</li><li>Currency of trading: BGN</li><li>Segment MIC: ZBUL</li><li>One trading lot: One (1) unit</li><li>Starting date of trading: 06 April 2022 (Wednesday)</li><li>The indicative reference price set for the first trading session is BGN 2.1650.</li></ul></div>', `FirstPage` = 1, `Visible` = 1
# [26-Feb-2024 17:26:47] /activa/www/aD3nVpq2C/bg/events/list.html?sort=01 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 17:26:49] /activa/www/aD3nVpq2C/bg/ajax/events/form/2.html?_=1708961210061 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 17:26:50] /activa/www/aD3nVpq2C/en/ajax/events/form/2.html?_=1708961211726 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 2 AND
                `Language` = 'en'
            LIMIT 1
# [26-Feb-2024 17:32:06] /activa/www/aD3nVpq2C/bg/ajax/events/form/3.html?_=1708961527212 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 3 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 17:32:19] /activa/www/aD3nVpq2C/en/ajax/events/form/3.html?_=1708961540328 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 3 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 3
            LIMIT 1
# [26-Feb-2024 17:33:07] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/3.html?URLLabel=dG8tdGhlLXNoYXJlaG9sZGVycw&_=1708961587921 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'to-the-shareholders'  AND `ID` != '3' AND `Language` = 'en'
# [26-Feb-2024 17:33:11] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/3.html?URLLabel=dG8tdGhlLXNoYXJlaG9sZGVycw&_=1708961592657 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'to-the-shareholders'  AND `ID` != '3' AND `Language` = 'en'
# [26-Feb-2024 17:34:46] /activa/www/aD3nVpq2C/bg/events/list.html?sort=01 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 17:34:54] /activa/www/aD3nVpq2C/bg/ajax/events/form/3.html?_=1708961695426 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 3 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 17:34:56] /activa/www/aD3nVpq2C/en/ajax/events/form/3.html?_=1708961697041 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 3 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 3
            LIMIT 1
# [26-Feb-2024 17:35:10] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/3.html?URLLabel=dG8tdGhlLXNoYXJlaG9sZGVycw&_=1708961711368 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'to-the-shareholders'  AND `ID` != '3' AND `Language` = 'en'
# [26-Feb-2024 17:35:12] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/3.html?URLLabel=dG8tdGhlLXNoYXJlaG9sZGVycw&_=1708961713051 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'to-the-shareholders'  AND `ID` != '3' AND `Language` = 'en'
# [26-Feb-2024 17:35:12] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/3.html?URLLabel=dG8tdGhlLXNoYXJlaG9sZGVycw&_=1708961713065 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'to-the-shareholders'  AND `ID` != '3' AND `Language` = 'en'
# [26-Feb-2024 17:35:13] /activa/www/aD3nVpq2C/en/ajax/events/urllabel/3.html?URLLabel=dG8tdGhlLXNoYXJlaG9sZGVycw&_=1708961714646 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `events`
                    WHERE
                        `URLLabel` = 'to-the-shareholders'  AND `ID` != '3' AND `Language` = 'en'
# [26-Feb-2024 17:35:41] /activa/www/aD3nVpq2C/en/ajax/events/insert/3.html?_=1708961741732 108.61.209.243

set names utf8

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

SELECT * FROM `events` LIMIT 1

SHOW COLUMNS FROM `events`

INSERT INTO `events` SET `ID` = '3', `Language` = 'en', `PostDate` = '2022-01-20', `StartFrom` = NULL, `EndTo` = NULL, `LastUpdate` = '2024-02-26 17:35:41', `UploadID` = '7288257111', `MetaTitle` = 'TO THE SHAREHOLDERS OF MF ACTIVA BALANCED', `MetaDescription` = 'We would like to inform you that at its meeting on December 15, 2021, the Board of Directors of Activa Asset Management AD decided to admit the units of the Mutual Fund "Activa Balanced" to trading on a regulated market - Bulgarian Stock Exchange AD.', `MetaImage` = '', `NoIndex` = 0, `Title` = 'TO THE SHAREHOLDERS OF MF ACTIVA BALANCED', `URLLabel` = 'to-the-shareholders', `Annotation` = 'We would like to inform you that at its meeting on December 15, 2021, the Board of Directors of Activa Asset Management AD decided to admit the units of the Mutual Fund "Activa Balanced" to trading on a regulated market - Bulgarian Stock Exchange AD.', `Content` = '<b>DEAR INVESTORS,</b><div><br></div><div>We would like to inform you that at its meeting on December 15, 2021, the Board of Directors of Activa Asset Management AD decided to admit the units of the Mutual Fund "Activa Balanced" to trading on a regulated market - Bulgarian Stock Exchange AD. In this regard, it is necessary to eliminate the possibility of issuing partial units of the Fund.<br></div><div>Considering the above, we kindly ask you by January 27, 2022, to request redemption of the partial units held by you. In case no action is taken by you by this date, your investment in partial units will be supplemented to an integer at the expense of MC Activa Asset Management AD.<br></div><div>Thank you in advance for your understanding and cooperation!</div><div><b>Respectfully<br></b></div><div><b>Olga Yordanova, CEO<br></b></div><div><b>Iva Mitkova, Procurator</b><br></div><div><br></div>', `FirstPage` = 1, `Visible` = 1
# [26-Feb-2024 17:35:41] /activa/www/aD3nVpq2C/bg/events/list.html?sort=01 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 17:35:46] /activa/www/aD3nVpq2C/bg/events/list.html?sort=01 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 17:35:48] /activa/www/aD3nVpq2C/bg/ajax/events/form/3.html?_=1708961749642 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 3 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 17:35:50] /activa/www/aD3nVpq2C/en/ajax/events/form/3.html?_=1708961751753 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 3 AND
                `Language` = 'en'
            LIMIT 1
# [26-Feb-2024 17:36:23] /activa/www/aD3nVpq2C/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 2982949230 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-Feb-2024 17:36:26] /activa/www/aD3nVpq2C/bg/ajax/pages/form/22.html?_=1708961787737 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 22 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` != 22
# [26-Feb-2024 17:36:29] /activa/www/aD3nVpq2C/en/ajax/pages/form/22.html?_=1708961790746 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'en' AND
                `MenuLabel` <> ''
         AND `ID` != 22
# [26-Feb-2024 17:36:36] /activa/www/aD3nVpq2C/bg/ajax/pages/form/21.html?_=1708961797248 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 21 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` != 21
# [26-Feb-2024 17:36:38] /activa/www/aD3nVpq2C/en/ajax/pages/form/21.html?_=1708961798889 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'en' AND
                `MenuLabel` <> ''
         AND `ID` != 21
# [26-Feb-2024 17:36:48] /activa/www/aD3nVpq2C/bg/ajax/pages/form/20.html?_=1708961809176 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 20 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` != 20
# [26-Feb-2024 17:37:09] /activa/www/en/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [26-Feb-2024 17:37:12] /activa/www/en/activa-asset-management/contacts.html 108.61.209.243

set names utf8

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

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

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'en' AND
                P1.`URLLabel` = 'activa-asset-management/contacts' AND
                P1.`Visible` = 1

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

SELECT
                P1.`URLLabel`
	        FROM
	        	`pages` P1
                INNER JOIN `pages` P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`Language` = 'en' AND
                    P2.`URLLabel` = 'activa-asset-management'
	    	WHERE
                P1.`Language` = 'en'
         AND P1.`Visible` = 1 LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [26-Feb-2024 17:37:38] /activa/www/aD3nVpq2C/en/ajax/pages/form/20.html?_=1708961859381 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'en' AND
                `MenuLabel` <> ''
         AND `ID` != 20
# [26-Feb-2024 17:38:10] /activa/www/aD3nVpq2C/bg/ajax/pages/form/20.html?_=1708961891605 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 20 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` != 20
# [26-Feb-2024 17:38:14] /activa/www/aD3nVpq2C/en/ajax/pages/form/20.html?_=1708961895198 108.61.209.243

set names utf8

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

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

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                ((`Module` = 'pages' AND `ParentID` = 1) OR `Module` = 'contacts') AND
                `Language` = 'en' AND
                `MenuLabel` <> ''
         AND `ID` != 20
# [26-Feb-2024 17:39:14] /activa/www/aD3nVpq2C/bg/events/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

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'
             LIMIT 1

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `StartFrom`,
                `EndTo`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `events`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [26-Feb-2024 17:39:17] /activa/www/aD3nVpq2C/bg/ajax/events/form/4.html?_=1708961957826 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 4 AND
                `Language` = 'bg'
            LIMIT 1
# [26-Feb-2024 17:41:34] /activa/www/aD3nVpq2C/en/ajax/events/form/4.html?_=1708962095067 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 4 AND
                `Language` = 'en'
            LIMIT 1

SELECT
                *
            FROM
                `events`
            WHERE
                `ID` = 4
            LIMIT 1
