# [14-Oct-2024 15:23:44] /efam/www/ 108.61.209.243

set names utf8

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

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

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

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

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

SELECT
                `Fund`,
                `PostDate` + INTERVAL - 1 DAY AS `Date1`,
                `PostDate`,
                `NsaPerShare`,
                `NSA`,
                `Shares`,
                `YearBegin`,
                `YearAgo`,
                `Deviation`
            FROM
                `assets`
            WHERE
                `ID` IN (SELECT MAX(`ID`) FROM `assets` GROUP BY `Fund`)
             ORDER BY `PostDate` DESC

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LAttention','AttentionText') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Oct-2024 15:23:45] /efam/www/bg/ajax/cookies.html?_=1728908626008 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
# [14-Oct-2024 15:23:54] /efam/www/eF8R4nsA9B/bg/ajax/users/login.html?_=1728908635477 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'w4XDlsObwr3DkcK3w6nClcOHw5vDisK1w5fDjsOow5jCvcK5woDCvMOL%'
            LIMIT 1
# [14-Oct-2024 15:23:54] /efam/www/eF8R4nsA9B/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 2170544426 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
# [14-Oct-2024 15:24:06] /efam/www/eF8R4nsA9B/bg/pages/list.html?Language=bg&keyword=Изпратено успешно 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 2170544426 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'
         AND (
                                `pages`.`MenuLabel` LIKE '%изпратено%успешно%' OR
                                `pages`.`FooterLabel` LIKE '%изпратено%успешно%' OR
                                `pages`.`Annotation` LIKE '%изпратено%успешно%' OR
                                `pages`.`Content` LIKE '%изпратено%успешно%'
                            )
                        
                                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
# [14-Oct-2024 15:24:09] /efam/www/eF8R4nsA9B/bg/ajax/pages/form/21.html?_=1728908649680 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 2170544426 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
# [14-Oct-2024 15:30:33] /efam/www/eF8R4nsA9B/bg/pages/list.html?Language=bg&keyword=Изпратено успешно 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 2170544426 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'
         AND (
                                `pages`.`MenuLabel` LIKE '%изпратено%успешно%' OR
                                `pages`.`FooterLabel` LIKE '%изпратено%успешно%' OR
                                `pages`.`Annotation` LIKE '%изпратено%успешно%' OR
                                `pages`.`Content` LIKE '%изпратено%успешно%'
                            )
                        
                                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
# [14-Oct-2024 15:30:38] /efam/www/eF8R4nsA9B/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 2170544426 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
# [14-Oct-2024 15:30:43] /efam/www/eF8R4nsA9B/bg/pages/list.html?Language=bg&keyword=Вашето запитване е изпратено успешно. 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 2170544426 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'
         AND (
                                `pages`.`MenuLabel` LIKE '%вашето%запитване%е%изпратено%успешно%' OR
                                `pages`.`FooterLabel` LIKE '%вашето%запитване%е%изпратено%успешно%' OR
                                `pages`.`Annotation` LIKE '%вашето%запитване%е%изпратено%успешно%' OR
                                `pages`.`Content` LIKE '%вашето%запитване%е%изпратено%успешно%'
                            )
                        
                                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
# [14-Oct-2024 15:30:50] /efam/www/eF8R4nsA9B/bg/ajax/pages/form/21.html?_=1728909050904 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 2170544426 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
# [14-Oct-2024 15:31:01] /efam/www/eF8R4nsA9B/bg/ajax/pages/form/21.html?_=1728909061647 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 4 AND
                                CRC32(`UserKey`) = 2170544426 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
# [14-Oct-2024 15:31:05] /efam/www/eF8R4nsA9B/bg/ajax/pages/urllabel/21.html?URLLabel=0YPRgdC_0LXRiNC90L4&_=1728909066444 108.61.209.243

set names utf8

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

SELECT
                        COUNT(*)
                    FROM
                        `pages`
                    WHERE
                        `URLLabel` = 'успешно'  AND `ID` != '21' AND `Language` = 'bg'
