# [06-Feb-2024 07:51:47] /activa/www/ 108.61.209.243

set names utf8

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') 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
# [06-Feb-2024 07:51:49] /activa/www/bg/ajax/cookies.html?_=1707198708723 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Feb-2024 07:51:52] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1707198712331 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 's7s7TE0AdicGRahwaCD9hKvQEryIQ2lsDWuuWFlZ9idlWBG2O79AiFBPCc8h89zE'
            WHERE
                `UserKey` LIKE 'w4vDksOjw4LCpcODw5HDjcOBw6zCs8K-w43DlsObwp7CtsK9%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [06-Feb-2024 07:51:54] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1707198713787 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` = 's7s7TE0AdicGRahwaCD9hKvQEryIQ2lsDWuuWFlZ9idlWBG2O79AiFBPCc8h89zE'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [06-Feb-2024 07:51:54] /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
# [06-Feb-2024 07:52:22] /activa/www/aD3nVpq2C/bg/documents/list.html 108.61.209.243

set names utf8

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

SELECT
                `documents`.*,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Page`
            FROM
                `documents`
                INNER JOIN `pages` ON `pages`.`ID` = `documents`.`PageID` AND `pages`.`Language` = `documents`.`Language`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `documents`.`Language` = 'bg'
         ORDER BY `documents`.`PostDate` ASC
# [06-Feb-2024 07:52:24] /activa/www/aD3nVpq2C/bg/ajax/documents/form/1.html?_=1707198744045 108.61.209.243

set names utf8

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

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`Module`,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Label`
                -- `MenuLabel` AS `Label`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Language` = 'bg' AND
                `pages`.`AddContent` LIKE '%documents%'
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [06-Feb-2024 07:53:37] /activa/www/aD3nVpq2C/bg/documents/list.html 108.61.209.243

set names utf8

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

SELECT
                `documents`.*,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Page`
            FROM
                `documents`
                INNER JOIN `pages` ON `pages`.`ID` = `documents`.`PageID` AND `pages`.`Language` = `documents`.`Language`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `documents`.`Language` = 'bg'
         ORDER BY `documents`.`PostDate` ASC
# [06-Feb-2024 07:53:38] /activa/www/aD3nVpq2C/bg/ajax/documents/form/1.html?_=1707198818343 108.61.209.243

set names utf8

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

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`Module`,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Label`
                -- `MenuLabel` AS `Label`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Language` = 'bg' AND
                `pages`.`AddContent` LIKE '%documents%'
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [06-Feb-2024 07:57:55] /activa/www/aD3nVpq2C/bg/documents/list.html 108.61.209.243

set names utf8

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

SELECT
                `documents`.*,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Page`
            FROM
                `documents`
                INNER JOIN `pages` ON `pages`.`ID` = `documents`.`PageID` AND `pages`.`Language` = `documents`.`Language`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `documents`.`Language` = 'bg'
         ORDER BY `documents`.`PostDate` ASC
# [06-Feb-2024 07:57:57] /activa/www/aD3nVpq2C/bg/ajax/documents/form/1.html?_=1707199076983 108.61.209.243

set names utf8

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

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`Module`,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Label`
                -- `MenuLabel` AS `Label`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Language` = 'bg' AND
                `pages`.`AddContent` LIKE '%documents%'
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [06-Feb-2024 07:58:08] /activa/www/aD3nVpq2C/bg/ajax/documents/update/1.html?_=1707199087781 108.61.209.243

set names utf8

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

SELECT * FROM `documents` LIMIT 1

SHOW COLUMNS FROM `documents`

UPDATE `documents` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2024-01-30', `LastUpdate` = '2024-02-06 07:58:08', `UploadID` = '6590656872', `PageID` = '38', `MetaTitle` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam id dapibus felis.', `MetaDescription` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam id dapibus felis. Nam iaculis velit sed justo semper, nec ultrices tellus tincidunt. Proin sed elit neque. Nam semper turpis et turpis aliquet viverra.', `MetaKeywords` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam id dapibus felis. Nam iaculis velit sed justo semper, nec ultrices tellus tincidunt. Proin sed elit neque. Nam semper turpis et turpis aliquet viverra. Vestibulum at aliquet nulla, vitae gravida ipsum. Etiam lorem velit, tempus et consequat a, sagittis id libero. Vivamus at leo vitae dolor dapibus mollis non at erat. Curabitur commodo dictum elementum. Suspendisse cursus tellus id pellentesque porttitor. Pellentesque justo risus, malesuada pretium est et, ullamcorper fringilla mauris. Aliquam sollicitudin ligula ut egestas varius. Etiam congue, ex vel convallis ornare, nisi elit molestie ante, sit amet rhoncus neque diam eget nunc. ', `FileName` = '4870849591.pdf', `Title` = 'wertwrtwert', `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [06-Feb-2024 07:58:08] /activa/www/aD3nVpq2C/bg/documents/list.html 108.61.209.243

set names utf8

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

SELECT
                `documents`.*,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Page`
            FROM
                `documents`
                INNER JOIN `pages` ON `pages`.`ID` = `documents`.`PageID` AND `pages`.`Language` = `documents`.`Language`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `documents`.`Language` = 'bg'
         ORDER BY `documents`.`PostDate` ASC
# [06-Feb-2024 07:58:09] /activa/www/aD3nVpq2C/bg/ajax/documents/form/1.html?_=1707199089597 108.61.209.243

set names utf8

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

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`Module`,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Label`
                -- `MenuLabel` AS `Label`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Language` = 'bg' AND
                `pages`.`AddContent` LIKE '%documents%'
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [06-Feb-2024 07:58:19] /activa/www/aD3nVpq2C/bg/ajax/documents/form/2.html?_=1707199099449 108.61.209.243

set names utf8

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

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`Module`,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Label`
                -- `MenuLabel` AS `Label`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Language` = 'bg' AND
                `pages`.`AddContent` LIKE '%documents%'
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [06-Feb-2024 07:58:32] /activa/www/aD3nVpq2C/bg/ajax/documents/update/2.html?_=1707199111755 108.61.209.243

set names utf8

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

SELECT * FROM `documents` LIMIT 1

SHOW COLUMNS FROM `documents`

UPDATE `documents` SET `ID` = '2', `Language` = 'bg', `PostDate` = '2024-02-03', `LastUpdate` = '2024-02-06 07:58:32', `UploadID` = '6955977904', `PageID` = '38', `MetaTitle` = 'Suspendisse vehicula placerat tortor ac elementum. ', `MetaDescription` = 'Suspendisse vehicula placerat tortor ac elementum. Vestibulum a tellus rhoncus massa sodales sodales vel at massa. Mauris egestas nulla ac venenatis maximus. Pellentesque auctor ante eu mauris pellentesque, quis accumsan odio ornare. ', `MetaKeywords` = 'Suspendisse vehicula placerat tortor ac elementum. Vestibulum a tellus rhoncus massa sodales sodales vel at massa. Mauris egestas nulla ac venenatis maximus. Pellentesque auctor ante eu mauris pellentesque, quis accumsan odio ornare. Sed vel tellus nulla. Curabitur in dignissim nulla, eget accumsan orci. Donec quis maximus erat. Cras quis cursus est, vel tempus dolor. Duis vitae urna scelerisque, feugiat lectus ut, egestas magna. Quisque ultricies rutrum pharetra. Proin in varius nulla. Ut vel consequat nunc. Ut rhoncus bibendum lacus semper semper. ', `FileName` = '10385-240103-bulinfo.pdf', `Title` = 'Нова, персонализирана услуга - „Управление на индивидуален портфейл“', `Visible` = 1 WHERE `ID` = '2' AND `Language` = 'bg'
# [06-Feb-2024 07:58:32] /activa/www/aD3nVpq2C/bg/documents/list.html 108.61.209.243

set names utf8

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

SELECT
                `documents`.*,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Page`
            FROM
                `documents`
                INNER JOIN `pages` ON `pages`.`ID` = `documents`.`PageID` AND `pages`.`Language` = `documents`.`Language`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `documents`.`Language` = 'bg'
         ORDER BY `documents`.`PostDate` ASC
# [06-Feb-2024 07:58:36] /activa/www/aD3nVpq2C/bg/reports/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
                `reports`.*,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Page`
            FROM
                `reports`
                INNER JOIN `pages` ON `pages`.`ID` = `reports`.`PageID` AND `pages`.`Language` = `reports`.`Language`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `reports`.`Language` = 'bg'
         ORDER BY `reports`.`PostDate` ASC
# [06-Feb-2024 07:58:38] /activa/www/aD3nVpq2C/bg/ajax/reports/form/1.html?_=1707199117583 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
                `reports`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`Module`,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Label`
                -- `MenuLabel` AS `Label`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Language` = 'bg' AND
                `pages`.`AddContent` LIKE '%reports%'
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [06-Feb-2024 07:58:49] /activa/www/aD3nVpq2C/bg/ajax/reports/update/1.html?_=1707199129644 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 `reports` LIMIT 1

SHOW COLUMNS FROM `reports`

UPDATE `reports` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2024-01-30', `LastUpdate` = '2024-02-06 07:58:49', `UploadID` = '6590789842', `PageID` = '63', `MetaTitle` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam id dapibus felis.', `MetaDescription` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam id dapibus felis. Nam iaculis velit sed justo semper, nec ultrices tellus tincidunt. Proin sed elit neque. Nam semper turpis et turpis aliquet viverra. ', `MetaKeywords` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam id dapibus felis. Nam iaculis velit sed justo semper, nec ultrices tellus tincidunt. Proin sed elit neque. Nam semper turpis et turpis aliquet viverra. Vestibulum at aliquet nulla, vitae gravida ipsum. Etiam lorem velit, tempus et consequat a, sagittis id libero. Vivamus at leo vitae dolor dapibus mollis non at erat. Curabitur commodo dictum elementum. Suspendisse cursus tellus id pellentesque porttitor. Pellentesque justo risus, malesuada pretium est et, ullamcorper fringilla mauris. Aliquam sollicitudin ligula ut egestas varius. Etiam congue, ex vel convallis ornare, nisi elit molestie ante, sit amet rhoncus neque diam eget nunc. ', `FileName` = '4871995096.pdf', `Year` = '2012', `Title` = 'Брандиран Schaeffler чадър', `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [06-Feb-2024 07:58:50] /activa/www/aD3nVpq2C/bg/reports/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
                `reports`.*,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Page`
            FROM
                `reports`
                INNER JOIN `pages` ON `pages`.`ID` = `reports`.`PageID` AND `pages`.`Language` = `reports`.`Language`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `reports`.`Language` = 'bg'
         ORDER BY `reports`.`PostDate` ASC
# [06-Feb-2024 07:58:51] /activa/www/aD3nVpq2C/bg/ajax/reports/form/2.html?_=1707199131208 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
                `reports`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`Module`,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Label`
                -- `MenuLabel` AS `Label`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Language` = 'bg' AND
                `pages`.`AddContent` LIKE '%reports%'
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [06-Feb-2024 07:59:03] /activa/www/aD3nVpq2C/bg/ajax/reports/update/2.html?_=1707199143313 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 `reports` LIMIT 1

SHOW COLUMNS FROM `reports`

UPDATE `reports` SET `ID` = '2', `Language` = 'bg', `PostDate` = '2024-01-30', `LastUpdate` = '2024-02-06 07:59:03', `UploadID` = '6590932997', `PageID` = '63', `MetaTitle` = 'Suspendisse vehicula placerat tortor ac elementum. ', `MetaDescription` = 'Suspendisse vehicula placerat tortor ac elementum. Vestibulum a tellus rhoncus massa sodales sodales vel at massa. Mauris egestas nulla ac venenatis maximus. Pellentesque auctor ante eu mauris pellentesque, quis accumsan odio ornare. ', `MetaKeywords` = 'Suspendisse vehicula placerat tortor ac elementum. Vestibulum a tellus rhoncus massa sodales sodales vel at massa. Mauris egestas nulla ac venenatis maximus. Pellentesque auctor ante eu mauris pellentesque, quis accumsan odio ornare. Sed vel tellus nulla. Curabitur in dignissim nulla, eget accumsan orci. Donec quis maximus erat. Cras quis cursus est, vel tempus dolor. Duis vitae urna scelerisque, feugiat lectus ut, egestas magna. Quisque ultricies rutrum pharetra. Proin in varius nulla. Ut vel consequat nunc. Ut rhoncus bibendum lacus semper semper.', `FileName` = '4871776808.pdf', `Year` = '2012', `Title` = 'Каталог за професионалисти', `Visible` = 1 WHERE `ID` = '2' AND `Language` = 'bg'
# [06-Feb-2024 07:59:03] /activa/www/aD3nVpq2C/bg/reports/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
                `reports`.*,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Page`
            FROM
                `reports`
                INNER JOIN `pages` ON `pages`.`ID` = `reports`.`PageID` AND `pages`.`Language` = `reports`.`Language`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `reports`.`Language` = 'bg'
         ORDER BY `reports`.`PostDate` ASC
# [06-Feb-2024 07:59:05] /activa/www/aD3nVpq2C/bg/ajax/reports/form/2.html?_=1707199145111 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
                `reports`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`Module`,
                IF(`Parent`.`MenuLabel` <> '' AND `pages`.`ParentID` > 1, CONCAT(`Parent`.`MenuLabel`, ' / ', `pages`.`MenuLabel`), `pages`.`MenuLabel`) AS `Label`
                -- `MenuLabel` AS `Label`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Language` = 'bg' AND
                `pages`.`AddContent` LIKE '%reports%'
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [06-Feb-2024 08:15:56] /activa/www/aD3nVpq2C/bg/ajax/users/logout.html?_=1707200156206 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
# [06-Feb-2024 08:15:56] /activa/www/ 108.61.209.243

set names utf8

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') 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
# [06-Feb-2024 08:15:57] /activa/www/bg/ajax/cookies.html?_=1707200157571 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Feb-2024 08:16:02] /activa/www/bg/search.html?q=test 108.61.209.243

set names utf8

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

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

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

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `UploadID`,
                `FileName`
            FROM
                `documents`
            WHERE
                `Language` = 'bg' AND
                (
                    `MetaTitle` LIKE '%test%' OR
                    `MetaDescription` LIKE '%test%' OR
                    `MetaKeywords` LIKE '%test%'
                ) AND
                `Visible` = 1
            ORDER BY CASE
                WHEN `MetaTitle` LIKE 'test%' THEN 0
                WHEN `MetaDescription` LIKE 'test%' THEN 1
                WHEN `MetaTitle` LIKE '% test%' THEN 2
                WHEN `MetaDescription` LIKE '% test%' THEN 3
                ELSE 4
            END
# [06-Feb-2024 08:16:23] /activa/www/bg/search.html?q=test 108.61.209.243

set names utf8

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

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

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

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

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

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

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

SELECT
                `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
# [06-Feb-2024 08:16:24] /activa/www/bg/ajax/cookies.html?_=1707200183983 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [06-Feb-2024 08:16:35] /activa/www/bg/search.html?q=Suspendisse  108.61.209.243

set names utf8

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

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

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

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

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

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

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

SELECT
                `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
# [06-Feb-2024 08:17:14] /activa/www/bg/search.html?q=Suspendisse  108.61.209.243

set names utf8

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

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

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

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

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

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

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

SELECT
                `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
# [06-Feb-2024 08:17:46] /activa/www/bg/search.html?q=Suspendisse  108.61.209.243

set names utf8

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

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

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

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

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

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

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

SELECT
                `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
# [06-Feb-2024 08:19:02] /activa/www/bg/search.html?q=Suspendisse  108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

SELECT
                `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
# [06-Feb-2024 08:19:34] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1707200373726 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'BxIBKTowzY8ihEhJyXLDIdvyd5N55f4fcHj4Uynbg9706qcV9h7dtCpOZo1nCbNi'
            WHERE
                `UserKey` LIKE 'w4vDksOjw4LCpcODw5HDjcOBw6zCs8K-w43DlsObwp7CtsK9%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [06-Feb-2024 08:19:34] /activa/www/aD3nVpq2C/bg/ajax/users/login.html?_=1707200374613 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` = 'BxIBKTowzY8ihEhJyXLDIdvyd5N55f4fcHj4Uynbg9706qcV9h7dtCpOZo1nCbNi'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [06-Feb-2024 08:19:34] /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
# [06-Feb-2024 08:19:42] /activa/www/aD3nVpq2C/bg/ajax/pages/form/32.html?_=1707200382392 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 32 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` != 32
# [06-Feb-2024 08:19:54] /activa/www/aD3nVpq2C/bg/ajax/users/logout.html?_=1707200394669 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
# [06-Feb-2024 08:19:55] /activa/www/ 108.61.209.243

set names utf8

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') 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
# [06-Feb-2024 08:19:58] /activa/www/bg/search.html?q=Балансиран  108.61.209.243

set names utf8

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

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

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

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

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `UploadID`,
                `FileName`
            FROM
                `reports`
            WHERE
                `Language` = 'bg' AND
                (
                    `MetaTitle` LIKE '%балансиран%' OR
                    `MetaDescription` LIKE '%балансиран%' OR
                    `MetaKeywords` LIKE '%балансиран%'
                ) AND
                `Visible` = 1
            ORDER BY CASE
                WHEN `MetaTitle` LIKE 'балансиран%' THEN 0
                WHEN `MetaDescription` LIKE 'балансиран%' THEN 1
                WHEN `MetaTitle` LIKE '% балансиран%' THEN 2
                WHEN `MetaDescription` LIKE '% балансиран%' THEN 3
                ELSE 4
            END

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

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

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

SELECT
                `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
