                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:39:10] /ngobg/root/bg/ajax/recaptcha/appkey.html?_=1722501550029 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10489 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:39:12] /ngobg/root/bg/ajax/users/logout.html?_=1722501552447 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10489 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:39:12] /ngobg/root/ 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'messages'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'index' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'main'
             ORDER BY
                `labels`.`Label` ASC

(SELECT `ID`, `Title`, '' AS `URLLabel`, 'annual' AS `Module` FROM `annual` WHERE `AnnualDate` = DATE_FORMAT(NOW(),'%c%d') AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            LIMIT 3

(SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'analysis' AS `Module` FROM `analysis` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'legal' AS `Module` FROM `legal` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'position' AS `Module` FROM `position` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            ORDER BY PostDate ASC, `PostDate` DESC
            LIMIT 3

SELECT
                `ID`,
                `UserID`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

(SELECT
                `ID`,
                `UserID`,
                'news' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `news`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'analysis' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `analysis`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'reportage' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `FirstPage` = 'no' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'legal' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `legal`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'position' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `position`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'live' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `live`
            WHERE
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            ORDER BY `PostDate` DESC

            LIMIT 20

(SELECT
                `ID`,
                `UserID`,
                `Title`,
                `URLLabel`,
                'ads' AS `PostType`,
                `PostDate`,
                `ValidTo`
            FROM
                `ads`
            WHERE
                `ValidTo` IS NOT NULL AND
                `ValidTo` >= CURDATE() AND
                `Visible` = 1
            LIMIT 14)

            UNION

            (SELECT
                `careers`.`ID`,
                `careers`.`UserID`,
                `careers`.`Title`,
                `careers`.`URLLabel`,
                'careers' AS `PostType`,
                `careers`.`PostDate`,
                `ActiveDate` AS `ValidTo`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
            WHERE
                `ActiveDate` IS NOT NULL AND
                `ActiveDate` >= CURDATE() AND
                `users`.`UserKey` LIKE '%2' AND
                `careers`.`Visible` = 1
            LIMIT 14)

            ORDER BY `ValidTo` DESC
            LIMIT 14;

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 9959 AND `Visible` = 1 LIMIT 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` != 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` = 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `PostDate` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) AND
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                `Visible` = 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'organizations'

SELECT
                DISTINCT `Region`
            FROM
                `regions`
            WHERE
                `Language` = 'bg' AND
                `Region` != ''
            ORDER BY `Region` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:39:13] /ngobg/root/bg/ajax/users/bar.html?_=1722501553068 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:39:13] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501553072 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:39:14] /ngobg/root/bg/users/login.html 167.99.142.201

set names utf8

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/login'
            LIMIT 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:39:15] /ngobg/root/bg/ajax/users/form/login.html?_=1722501554906 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:39:15] /ngobg/root/bg/ajax/users/bar.html?_=1722501554909 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:39:15] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501554909 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:39:18] /ngobg/root/bg/ajax/users/login.html?_=1722501558202 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT `ID`, `UserKey`, `EMailKey` FROM `users` WHERE `UserKey` LIKE 'w4jCu8OXw4LCjcOMw6zCtsKbw4nDgsK2%' LIMIT 1
# [01-Aug-2024 11:39:18] /ngobg/root/bg/users/profile.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10489 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/profile/ngo'
            LIMIT 1

SELECT
                `Title`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/profile/ngo'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'careers'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `careers`.`ID`,
                `careers`.`CareerType`,
                `careers`.`Title`,
                `careers`.`URLLabel`,
                `careers`.`Visible`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                `users`.`ID` = 10489
            ORDER BY
                `careers`.`PostDate` DESC
         LIMIT 0, 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'messages'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ads`.`ID`,
                `ads`.`PostDate`,
                'ads' AS `PostType`,
                `ads`.`URLLabel`,
                `ads`.`Title`,
                `ads`.`Visible`
            FROM
                `ads`
                INNER JOIN `organizations` ON `ads`.`UserID` = `organizations`.`UserID`
            WHERE
                `organizations`.`UserID` = 10489
            ORDER BY
                `ads`.`PostDate` DESC
         LIMIT 0, 3

SELECT
                `news`.`ID`,
                `news`.`PostDate`,
                'news' AS `PostType`,
                `news`.`URLLabel`,
                `news`.`Title`,
                `news`.`Visible`
            FROM
                `news`
                INNER JOIN `organizations` ON `news`.`UserID` = `organizations`.`UserID`
            WHERE
                `organizations`.`UserID` = 10489
            ORDER BY
                `news`.`PostDate` DESC
         LIMIT 0, 3

SELECT
                `analysis`.`ID`,
                `analysis`.`PostDate`,
                'analysis' AS `PostType`,
                `analysis`.`URLLabel`,
                `analysis`.`Title`,
                `analysis`.`Visible`
            FROM
                `analysis`
                INNER JOIN `organizations` ON `analysis`.`UserID` = `organizations`.`UserID`
            WHERE
                `organizations`.`UserID` = 10489
            ORDER BY
                `analysis`.`PostDate` DESC
         LIMIT 0, 3

SELECT
                `legal`.`ID`,
                `legal`.`PostDate`,
                'legal' AS `PostType`,
                `legal`.`URLLabel`,
                `legal`.`Title`,
                `legal`.`Visible`
            FROM
                `legal`
                INNER JOIN `organizations` ON `legal`.`UserID` = `organizations`.`UserID`
            WHERE
                `organizations`.`UserID` = 10489
            ORDER BY
                `legal`.`PostDate` DESC
         LIMIT 0, 3

SELECT
                `calendar`.`ID`,
                `calendar`.`PostDate`,
                'calendar' AS `PostType`,
                `calendar`.`URLLabel`,
                `calendar`.`Title`,
                `calendar`.`Visible`
            FROM
                `calendar`
                INNER JOIN `organizations` ON `calendar`.`UserID` = `organizations`.`UserID`
            WHERE
                `organizations`.`UserID` = 10489
            ORDER BY
                `calendar`.`PostDate` DESC
         LIMIT 0, 3

SELECT
                `position`.`ID`,
                `position`.`PostDate`,
                'position' AS `PostType`,
                `position`.`URLLabel`,
                `position`.`Title`,
                `position`.`Visible`
            FROM
                `position`
                INNER JOIN `organizations` ON `position`.`UserID` = `organizations`.`UserID`
            WHERE
                `organizations`.`UserID` = 10489
            ORDER BY
                `position`.`PostDate` DESC
         LIMIT 0, 3

SELECT
                `reportage`.`ID`,
                `reportage`.`PostDate`,
                'reportage' AS `PostType`,
                `reportage`.`URLLabel`,
                `reportage`.`Title`,
                `reportage`.`Visible`
            FROM
                `reportage`
                INNER JOIN `organizations` ON `reportage`.`UserID` = `organizations`.`UserID`
            WHERE
                `organizations`.`UserID` = 10489
            ORDER BY
                `reportage`.`PostDate` DESC
         LIMIT 0, 3

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'documents'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
            FROM
                `documents`
            WHERE
                `UserID` = 10489
            ORDER BY
                `PostDate` DESC
         LIMIT 0, 3

SELECT
                *
            FROM
                `financing`
            WHERE
                `UserID` = 10489
            ORDER BY
                `PostDate` DESC
         LIMIT 0, 3

SELECT
                *
            FROM
                `campaigns`
            WHERE
                `UserID` = 10489
            ORDER BY
                `PostDate` DESC
         LIMIT 0, 3

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/profile/ngo'
            LIMIT 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:39:18] /ngobg/root/css/boxes.css-?v5 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10489 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:39:18] /ngobg/root/css/nav.css-?v5 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10489 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:39:18] /ngobg/root/bg/ajax/users/bar.html?_=1722501558640 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10489 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:39:18] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501558640 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10489 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:39:20] /ngobg/root/bg/ajax/users/logout.html?_=1722501560119 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10489 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:39:20] /ngobg/root/ 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'messages'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'index' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'main'
             ORDER BY
                `labels`.`Label` ASC

(SELECT `ID`, `Title`, '' AS `URLLabel`, 'annual' AS `Module` FROM `annual` WHERE `AnnualDate` = DATE_FORMAT(NOW(),'%c%d') AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            LIMIT 3

(SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'analysis' AS `Module` FROM `analysis` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'legal' AS `Module` FROM `legal` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'position' AS `Module` FROM `position` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            ORDER BY PostDate ASC, `PostDate` DESC
            LIMIT 3

SELECT
                `ID`,
                `UserID`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

(SELECT
                `ID`,
                `UserID`,
                'news' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `news`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'analysis' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `analysis`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'reportage' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `FirstPage` = 'no' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'legal' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `legal`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'position' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `position`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'live' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `live`
            WHERE
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            ORDER BY `PostDate` DESC

            LIMIT 20

(SELECT
                `ID`,
                `UserID`,
                `Title`,
                `URLLabel`,
                'ads' AS `PostType`,
                `PostDate`,
                `ValidTo`
            FROM
                `ads`
            WHERE
                `ValidTo` IS NOT NULL AND
                `ValidTo` >= CURDATE() AND
                `Visible` = 1
            LIMIT 14)

            UNION

            (SELECT
                `careers`.`ID`,
                `careers`.`UserID`,
                `careers`.`Title`,
                `careers`.`URLLabel`,
                'careers' AS `PostType`,
                `careers`.`PostDate`,
                `ActiveDate` AS `ValidTo`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
            WHERE
                `ActiveDate` IS NOT NULL AND
                `ActiveDate` >= CURDATE() AND
                `users`.`UserKey` LIKE '%2' AND
                `careers`.`Visible` = 1
            LIMIT 14)

            ORDER BY `ValidTo` DESC
            LIMIT 14;

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 9959 AND `Visible` = 1 LIMIT 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` != 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` = 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `PostDate` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) AND
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                `Visible` = 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'organizations'

SELECT
                DISTINCT `Region`
            FROM
                `regions`
            WHERE
                `Language` = 'bg' AND
                `Region` != ''
            ORDER BY `Region` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:39:20] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501560565 167.99.142.201
# [01-Aug-2024 11:39:20] /ngobg/root/bg/ajax/users/bar.html?_=1722501560562 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:39:21] /ngobg/root/bg/users/regform.html 167.99.142.201

set names utf8

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/regform'
            LIMIT 1

SELECT
                `Title`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/regform'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:39:22] /ngobg/root/bg/ajax/users/bar.html?_=1722501561784 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:39:22] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501561785 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:39:23] /ngobg/root/bg/users/login.html 167.99.142.201

set names utf8

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/login'
            LIMIT 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:39:23] /ngobg/root/bg/ajax/users/form/login.html?_=1722501563171 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:39:23] /ngobg/root/bg/ajax/users/bar.html?_=1722501563173 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:39:23] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501563173 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:39:26] /ngobg/root/bg/ajax/users/login.html?_=1722501566225 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT `ID`, `UserKey`, `EMailKey` FROM `users` WHERE `UserKey` LIKE 'w4LCv8OPwr3CucOMw7LCksOaw4nDh8K5wrjDjMOnwr_DlMK1wqHDg8OT%' LIMIT 1
# [01-Aug-2024 11:39:26] /ngobg/root/admin/ 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                    `messages`.*,
                    `users`.`Data` AS `UserData`,
                    `users`.`Sort` AS `UserSort`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    `organizations`.`Sort` AS `OrgSort`
                FROM
                    `messages`
                    INNER JOIN `users` ON `messages`.`UserID` = `users`.`ID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                
                ORDER BY
                    `messages`.`LastUpdate` DESC, `messages`.`PostDate` DESC
             LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (
                SELECT
                    `messages`.*,
                    `users`.`Data` AS `UserData`,
                    `users`.`Sort` AS `UserSort`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    `organizations`.`Sort` AS `OrgSort`
                FROM
                    `messages`
                    INNER JOIN `users` ON `messages`.`UserID` = `users`.`ID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                
                ORDER BY
                    `messages`.`LastUpdate` DESC, `messages`.`PostDate` DESC
            ) AS CountTable
# [01-Aug-2024 11:39:28] /ngobg/root/css/boxes.css-?1722501568 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:28] /ngobg/root/css/nav.css-?1722501568 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:30] /ngobg/root/admin/bg/messages.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                    `messages`.*,
                    `users`.`Data` AS `UserData`,
                    `users`.`Sort` AS `UserSort`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    `organizations`.`Sort` AS `OrgSort`
                FROM
                    `messages`
                    INNER JOIN `users` ON `messages`.`UserID` = `users`.`ID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                
                ORDER BY
                    `messages`.`LastUpdate` DESC, `messages`.`PostDate` DESC
             LIMIT 0, 300
# [01-Aug-2024 11:39:31] /ngobg/root/admin/bg/organizations.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
                SELECT
                    `messages`.*,
                    `users`.`Data` AS `UserData`,
                    `users`.`Sort` AS `UserSort`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    `organizations`.`Sort` AS `OrgSort`
                FROM
                    `messages`
                    INNER JOIN `users` ON `messages`.`UserID` = `users`.`ID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                
                ORDER BY
                    `messages`.`LastUpdate` DESC, `messages`.`PostDate` DESC
            ) AS CountTable

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [01-Aug-2024 11:39:32] /ngobg/root/css/boxes.css-?1722501572 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:32] /ngobg/root/css/nav.css-?1722501572 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:34] /ngobg/root/admin/bg/organizations.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [01-Aug-2024 11:39:34] /ngobg/root/css/boxes.css-?1722501574 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:34] /ngobg/root/css/nav.css-?1722501574 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:36] /ngobg/root/admin/bg/users.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
        ) AS CountTable
# [01-Aug-2024 11:39:36] /ngobg/root/css/boxes.css-?1722501576 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:36] /ngobg/root/css/nav.css-?1722501576 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:39] /ngobg/root/admin/bg/ajax/users/delete/10489.html?_=1722501579144 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

DELETE FROM `users` WHERE `ID` = '10489'
# [01-Aug-2024 11:39:39] /ngobg/root/admin/bg/users.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
        ) AS CountTable
# [01-Aug-2024 11:39:39] /ngobg/root/css/boxes.css-?1722501579 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:39] /ngobg/root/css/nav.css-?1722501579 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:40] /ngobg/root/admin/bg/users.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
        ) AS CountTable
# [01-Aug-2024 11:39:40] /ngobg/root/css/boxes.css-?1722501580 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:40] /ngobg/root/css/nav.css-?1722501580 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:43] /ngobg/root/admin/bg/organizations.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [01-Aug-2024 11:39:43] /ngobg/root/css/boxes.css-?1722501583 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:43] /ngobg/root/css/nav.css-?1722501583 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:46] /ngobg/root/admin/bg/organizations.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [01-Aug-2024 11:39:46] /ngobg/root/css/boxes.css-?1722501586 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:46] /ngobg/root/css/nav.css-?1722501586 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:50] /ngobg/root/bg/ajax/users/logout.html?_=1722501589904 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:39:50] /ngobg/root/ 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'messages'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'index' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'main'
             ORDER BY
                `labels`.`Label` ASC

(SELECT `ID`, `Title`, '' AS `URLLabel`, 'annual' AS `Module` FROM `annual` WHERE `AnnualDate` = DATE_FORMAT(NOW(),'%c%d') AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            LIMIT 3

(SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'analysis' AS `Module` FROM `analysis` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'legal' AS `Module` FROM `legal` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'position' AS `Module` FROM `position` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            ORDER BY PostDate ASC, `PostDate` DESC
            LIMIT 3

SELECT
                `ID`,
                `UserID`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

(SELECT
                `ID`,
                `UserID`,
                'news' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `news`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'analysis' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `analysis`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'reportage' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `FirstPage` = 'no' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'legal' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `legal`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'position' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `position`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'live' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `live`
            WHERE
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            ORDER BY `PostDate` DESC

            LIMIT 20

(SELECT
                `ID`,
                `UserID`,
                `Title`,
                `URLLabel`,
                'ads' AS `PostType`,
                `PostDate`,
                `ValidTo`
            FROM
                `ads`
            WHERE
                `ValidTo` IS NOT NULL AND
                `ValidTo` >= CURDATE() AND
                `Visible` = 1
            LIMIT 14)

            UNION

            (SELECT
                `careers`.`ID`,
                `careers`.`UserID`,
                `careers`.`Title`,
                `careers`.`URLLabel`,
                'careers' AS `PostType`,
                `careers`.`PostDate`,
                `ActiveDate` AS `ValidTo`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
            WHERE
                `ActiveDate` IS NOT NULL AND
                `ActiveDate` >= CURDATE() AND
                `users`.`UserKey` LIKE '%2' AND
                `careers`.`Visible` = 1
            LIMIT 14)

            ORDER BY `ValidTo` DESC
            LIMIT 14;

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 9959 AND `Visible` = 1 LIMIT 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` != 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` = 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `PostDate` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) AND
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                `Visible` = 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'organizations'

SELECT
                DISTINCT `Region`
            FROM
                `regions`
            WHERE
                `Language` = 'bg' AND
                `Region` != ''
            ORDER BY `Region` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:39:50] /ngobg/root/bg/ajax/users/bar.html?_=1722501590400 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:39:50] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501590402 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:39:54] /ngobg/root/bg/users/regform.html 167.99.142.201

set names utf8

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/regform'
            LIMIT 1

SELECT
                `Title`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/regform'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:39:54] /ngobg/root/bg/ajax/users/bar.html?_=1722501594738 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:39:54] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501594739 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:39:55] /ngobg/root/bg/users/register/ngo.html 167.99.142.201

set names utf8

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/register/ngo'
            LIMIT 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:39:56] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722501595891 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/register/ngo'
            LIMIT 1
# [01-Aug-2024 11:39:56] /ngobg/root/bg/ajax/users/bar.html?_=1722501595893 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:39:56] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501595894 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:40:03] /ngobg/root/bg/ajax/organizations/form.html?_=1722501602904 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT `ID` FROM `users` WHERE `EMailKey` = 'b8d5e5a543f9505c297df9638d04f43a661f810961ecc323828e1fead72b3819' LIMIT 1

SELECT
                DISTINCT `Region`
            FROM
                `regions`
            WHERE
                `Language` = 'bg' AND
                `Region` != ''
            ORDER BY `Region` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `org_types`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `org_statutes`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT `ID`, `From`, `UpTo` FROM `org_financial` WHERE `Visible` = 1 ORDER BY `ID` ASC
# [01-Aug-2024 11:40:16] /ngobg/root/bg/ajax/organizations/register.html?_=1722501616659 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT `ID` FROM `users` WHERE `EMailKey` = 'b8d5e5a543f9505c297df9638d04f43a661f810961ecc323828e1fead72b3819' LIMIT 1

SELECT * FROM `users` LIMIT 1

SHOW COLUMNS FROM `users`

INSERT INTO `users` SET `RegDate` = '2024-08-01 11:40:16', `UserKey` = 'w4jCu8OXw4LCjcOMw6zCtsKbw4nDgsK2a9af9bc42a96e901f1ab6bb39480aa942', `Data` = 'WMNntZxA1mkqE-0W2q05G4fHYsUC2dQJWPPiLFrV-IRG6JStYzkAcQR1HvSXWdOUGigTHxNm25pTBHeQ_KYBRHXFPWxO65mwiWCV-86JWAcpVO2xhLgaGTVJsZKctntRqUGu8fWM56mEFU2gULHSQ3KFaUfarl8SBlc21bJnMfI', `SearchKey` = 'wrXDg8KdwwrfCicK2wrrCscKdwrDi8ORwwq7CncKdwwrjCncK6w4jCscwq3CrsKywwq3CrsKyw', `EMailKey` = 'b8d5e5a543f9505c297df9638d04f43a661f810961ecc323828e1fead72b3819', `Sort` = '1060111'
# [01-Aug-2024 11:41:37] /ngobg/root/bg/users/register/ngo.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10490 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/register/ngo'
            LIMIT 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:41:37] /ngobg/root/css/boxes.css-?v5 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10490 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:41:37] /ngobg/root/css/nav.css-?v5 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10490 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:41:38] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722501697992 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10490 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/register/ngo'
            LIMIT 1
# [01-Aug-2024 11:41:38] /ngobg/root/bg/ajax/users/bar.html?_=1722501697994 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10490 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:41:38] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501697995 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10490 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:41:38] /ngobg/root/bg/ajax/recaptcha/appkey.html?_=1722501698043 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10490 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:41:43] /ngobg/root/bg/ajax/users/logout.html?_=1722501703359 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10490 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:41:43] /ngobg/root/ 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'messages'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'index' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'main'
             ORDER BY
                `labels`.`Label` ASC

(SELECT `ID`, `Title`, '' AS `URLLabel`, 'annual' AS `Module` FROM `annual` WHERE `AnnualDate` = DATE_FORMAT(NOW(),'%c%d') AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            LIMIT 3

(SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'analysis' AS `Module` FROM `analysis` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'legal' AS `Module` FROM `legal` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'position' AS `Module` FROM `position` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            ORDER BY PostDate ASC, `PostDate` DESC
            LIMIT 3

SELECT
                `ID`,
                `UserID`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

(SELECT
                `ID`,
                `UserID`,
                'news' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `news`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'analysis' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `analysis`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'reportage' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `FirstPage` = 'no' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'legal' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `legal`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'position' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `position`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'live' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `live`
            WHERE
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            ORDER BY `PostDate` DESC

            LIMIT 20

(SELECT
                `ID`,
                `UserID`,
                `Title`,
                `URLLabel`,
                'ads' AS `PostType`,
                `PostDate`,
                `ValidTo`
            FROM
                `ads`
            WHERE
                `ValidTo` IS NOT NULL AND
                `ValidTo` >= CURDATE() AND
                `Visible` = 1
            LIMIT 14)

            UNION

            (SELECT
                `careers`.`ID`,
                `careers`.`UserID`,
                `careers`.`Title`,
                `careers`.`URLLabel`,
                'careers' AS `PostType`,
                `careers`.`PostDate`,
                `ActiveDate` AS `ValidTo`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
            WHERE
                `ActiveDate` IS NOT NULL AND
                `ActiveDate` >= CURDATE() AND
                `users`.`UserKey` LIKE '%2' AND
                `careers`.`Visible` = 1
            LIMIT 14)

            ORDER BY `ValidTo` DESC
            LIMIT 14;

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 9959 AND `Visible` = 1 LIMIT 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` != 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` = 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `PostDate` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) AND
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                `Visible` = 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'organizations'

SELECT
                DISTINCT `Region`
            FROM
                `regions`
            WHERE
                `Language` = 'bg' AND
                `Region` != ''
            ORDER BY `Region` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:41:44] /ngobg/root/bg/ajax/users/bar.html?_=1722501703904 167.99.142.201
# [01-Aug-2024 11:41:44] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501703907 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:41:45] /ngobg/root/bg/users/login.html 167.99.142.201

set names utf8

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/login'
            LIMIT 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:41:45] /ngobg/root/bg/ajax/users/form/login.html?_=1722501705107 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:41:45] /ngobg/root/bg/ajax/users/bar.html?_=1722501705109 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:41:45] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501705110 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:41:49] /ngobg/root/bg/ajax/users/login.html?_=1722501708960 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT `ID`, `UserKey`, `EMailKey` FROM `users` WHERE `UserKey` LIKE 'w4LCv8OPwr3CucOMw7LCksOaw4nDh8K5wrjDjMOnwr_DlMK1wqHDg8OT%' LIMIT 1
# [01-Aug-2024 11:41:49] /ngobg/root/admin/ 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                    `messages`.*,
                    `users`.`Data` AS `UserData`,
                    `users`.`Sort` AS `UserSort`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    `organizations`.`Sort` AS `OrgSort`
                FROM
                    `messages`
                    INNER JOIN `users` ON `messages`.`UserID` = `users`.`ID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                
                ORDER BY
                    `messages`.`LastUpdate` DESC, `messages`.`PostDate` DESC
             LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (
                SELECT
                    `messages`.*,
                    `users`.`Data` AS `UserData`,
                    `users`.`Sort` AS `UserSort`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    `organizations`.`Sort` AS `OrgSort`
                FROM
                    `messages`
                    INNER JOIN `users` ON `messages`.`UserID` = `users`.`ID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                
                ORDER BY
                    `messages`.`LastUpdate` DESC, `messages`.`PostDate` DESC
            ) AS CountTable
# [01-Aug-2024 11:41:51] /ngobg/root/css/boxes.css-?1722501711 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:41:51] /ngobg/root/css/nav.css-?1722501711 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:41:53] /ngobg/root/admin/bg/organizations.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [01-Aug-2024 11:41:54] /ngobg/root/css/boxes.css-?1722501714 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:41:54] /ngobg/root/css/nav.css-?1722501714 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:41:55] /ngobg/root/admin/bg/users.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
        ) AS CountTable
# [01-Aug-2024 11:41:55] /ngobg/root/css/boxes.css-?1722501715 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:41:55] /ngobg/root/css/nav.css-?1722501715 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:42:00] /ngobg/root/admin/bg/ajax/users/delete/10490.html?_=1722501720767 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

DELETE FROM `users` WHERE `ID` = '10490'
# [01-Aug-2024 11:42:01] /ngobg/root/admin/bg/users.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
        ) AS CountTable
# [01-Aug-2024 11:42:01] /ngobg/root/css/boxes.css-?1722501721 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:42:01] /ngobg/root/css/nav.css-?1722501721 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:42:02] /ngobg/root/admin/bg/users.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
        ) AS CountTable
# [01-Aug-2024 11:42:02] /ngobg/root/css/boxes.css-?1722501722 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:42:02] /ngobg/root/css/nav.css-?1722501722 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:42:28] /ngobg/root/bg/ajax/users/logout.html?_=1722501747824 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:42:28] /ngobg/root/ 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'messages'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'index' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'main'
             ORDER BY
                `labels`.`Label` ASC

(SELECT `ID`, `Title`, '' AS `URLLabel`, 'annual' AS `Module` FROM `annual` WHERE `AnnualDate` = DATE_FORMAT(NOW(),'%c%d') AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            LIMIT 3

(SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'analysis' AS `Module` FROM `analysis` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'legal' AS `Module` FROM `legal` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'position' AS `Module` FROM `position` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            ORDER BY PostDate ASC, `PostDate` DESC
            LIMIT 3

SELECT
                `ID`,
                `UserID`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

(SELECT
                `ID`,
                `UserID`,
                'news' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `news`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'analysis' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `analysis`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'reportage' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `FirstPage` = 'no' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'legal' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `legal`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'position' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `position`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'live' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `live`
            WHERE
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            ORDER BY `PostDate` DESC

            LIMIT 20

(SELECT
                `ID`,
                `UserID`,
                `Title`,
                `URLLabel`,
                'ads' AS `PostType`,
                `PostDate`,
                `ValidTo`
            FROM
                `ads`
            WHERE
                `ValidTo` IS NOT NULL AND
                `ValidTo` >= CURDATE() AND
                `Visible` = 1
            LIMIT 14)

            UNION

            (SELECT
                `careers`.`ID`,
                `careers`.`UserID`,
                `careers`.`Title`,
                `careers`.`URLLabel`,
                'careers' AS `PostType`,
                `careers`.`PostDate`,
                `ActiveDate` AS `ValidTo`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
            WHERE
                `ActiveDate` IS NOT NULL AND
                `ActiveDate` >= CURDATE() AND
                `users`.`UserKey` LIKE '%2' AND
                `careers`.`Visible` = 1
            LIMIT 14)

            ORDER BY `ValidTo` DESC
            LIMIT 14;

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 9959 AND `Visible` = 1 LIMIT 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` != 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` = 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `PostDate` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) AND
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                `Visible` = 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'organizations'

SELECT
                DISTINCT `Region`
            FROM
                `regions`
            WHERE
                `Language` = 'bg' AND
                `Region` != ''
            ORDER BY `Region` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:42:28] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501748458 167.99.142.201
# [01-Aug-2024 11:42:28] /ngobg/root/bg/ajax/users/bar.html?_=1722501748455 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:42:30] /ngobg/root/bg/users/regform.html 167.99.142.201

set names utf8

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/regform'
            LIMIT 1

SELECT
                `Title`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/regform'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:42:30] /ngobg/root/bg/ajax/users/bar.html?_=1722501750207 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:42:30] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501750208 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:42:31] /ngobg/root/bg/users/register/ngo.html 167.99.142.201

set names utf8

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/register/ngo'
            LIMIT 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:42:31] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722501751087 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:42:31] /ngobg/root/bg/ajax/users/bar.html?_=1722501751090 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/register/ngo'
            LIMIT 1
# [01-Aug-2024 11:42:31] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501751093 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:42:39] /ngobg/root/bg/ajax/organizations/form.html?_=1722501759172 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT `ID` FROM `users` WHERE `EMailKey` = 'b8d5e5a543f9505c297df9638d04f43a661f810961ecc323828e1fead72b3819' LIMIT 1

SELECT
                DISTINCT `Region`
            FROM
                `regions`
            WHERE
                `Language` = 'bg' AND
                `Region` != ''
            ORDER BY `Region` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `org_types`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `org_statutes`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT `ID`, `From`, `UpTo` FROM `org_financial` WHERE `Visible` = 1 ORDER BY `ID` ASC
# [01-Aug-2024 11:43:00] /ngobg/root/bg/ajax/organizations/register.html?_=1722501779865 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT `ID` FROM `users` WHERE `EMailKey` = 'b8d5e5a543f9505c297df9638d04f43a661f810961ecc323828e1fead72b3819' LIMIT 1

SELECT * FROM `users` LIMIT 1

SHOW COLUMNS FROM `users`

INSERT INTO `users` SET `RegDate` = '2024-08-01 11:43:00', `UserKey` = 'w4jCu8OXw4LCjcOMw6zCtsKbw4nDgsK2a9af9bc42a96e901f1ab6bb39480aa942', `Data` = 'TI8-YDwslG5FzNMkLkg9yu3yyCj1bqCzUcNTnIUyORHszWmXSo8mGZogxqUxO_rt8fXG6PolRJFFIMLKj5d7yqYuuePS0GUhaHtheZQB5XraCMP7HUsdIc0Tpf57DaPWKV2nCSkTu3E44Ez5h5Mlk7vETXajHO9FeIRFMEXmwQk', `SearchKey` = 'wrXDg8ODwpLCvMKdwwrfCiMKdf8Kyw5jCwrfCiMOQw4HCscOYwwrjCncK6w4jCscwq3CrsKywwq3CrsKyw', `EMailKey` = 'b8d5e5a543f9505c297df9638d04f43a661f810961ecc323828e1fead72b3819', `Sort` = '1060111'
# [01-Aug-2024 11:46:19] /ngobg/root/bg/users/register/ngo.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10491 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/register/ngo'
            LIMIT 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:46:19] /ngobg/root/css/boxes.css-?v5 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10491 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:46:19] /ngobg/root/css/nav.css-?v5 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10491 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:46:20] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722501979786 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10491 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:46:20] /ngobg/root/bg/ajax/users/bar.html?_=1722501979789 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10491 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/register/ngo'
            LIMIT 1
# [01-Aug-2024 11:46:20] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501979790 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10491 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:46:20] /ngobg/root/bg/ajax/recaptcha/appkey.html?_=1722501979861 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10491 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:46:21] /ngobg/root/bg/ajax/users/logout.html?_=1722501981183 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10491 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:46:21] /ngobg/root/ 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'messages'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'index' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'main'
             ORDER BY
                `labels`.`Label` ASC

(SELECT `ID`, `Title`, '' AS `URLLabel`, 'annual' AS `Module` FROM `annual` WHERE `AnnualDate` = DATE_FORMAT(NOW(),'%c%d') AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            LIMIT 3

(SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'analysis' AS `Module` FROM `analysis` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'legal' AS `Module` FROM `legal` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'position' AS `Module` FROM `position` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            ORDER BY PostDate ASC, `PostDate` DESC
            LIMIT 3

SELECT
                `ID`,
                `UserID`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

(SELECT
                `ID`,
                `UserID`,
                'news' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `news`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'analysis' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `analysis`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'reportage' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `FirstPage` = 'no' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'legal' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `legal`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'position' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `position`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'live' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `live`
            WHERE
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            ORDER BY `PostDate` DESC

            LIMIT 20

(SELECT
                `ID`,
                `UserID`,
                `Title`,
                `URLLabel`,
                'ads' AS `PostType`,
                `PostDate`,
                `ValidTo`
            FROM
                `ads`
            WHERE
                `ValidTo` IS NOT NULL AND
                `ValidTo` >= CURDATE() AND
                `Visible` = 1
            LIMIT 14)

            UNION

            (SELECT
                `careers`.`ID`,
                `careers`.`UserID`,
                `careers`.`Title`,
                `careers`.`URLLabel`,
                'careers' AS `PostType`,
                `careers`.`PostDate`,
                `ActiveDate` AS `ValidTo`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
            WHERE
                `ActiveDate` IS NOT NULL AND
                `ActiveDate` >= CURDATE() AND
                `users`.`UserKey` LIKE '%2' AND
                `careers`.`Visible` = 1
            LIMIT 14)

            ORDER BY `ValidTo` DESC
            LIMIT 14;

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 5088 AND `Visible` = 1 LIMIT 1

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 9959 AND `Visible` = 1 LIMIT 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` != 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) > 1 AND
                `careers`.`CareerType` = 3 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`careers`.`ID`)
            FROM
                `careers`
                INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1 AND
                `careers`.`ActiveDate` IS NOT NULL AND
                `careers`.`ActiveDate` >= CURDATE() AND
                `careers`.`Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `PostDate` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) AND
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `documents`
            WHERE
                `DocType` != 4 AND
                `Visible` = 1;

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `financing`
            WHERE
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                (
                    (`DeadlineTo` IS NOT NULL AND `DeadlineTo` >= CURDATE())
                    OR
                    `Current` = 1
                ) AND
                `Visible` = 1

SELECT
                COUNT(`ID`)
            FROM
                `publicconsultations`
            WHERE
                `Visible` = 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'organizations'

SELECT
                DISTINCT `Region`
            FROM
                `regions`
            WHERE
                `Language` = 'bg' AND
                `Region` != ''
            ORDER BY `Region` ASC

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:46:21] /ngobg/root/bg/ajax/users/bar.html?_=1722501981671 167.99.142.201
# [01-Aug-2024 11:46:21] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501981673 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (1 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:46:24] /ngobg/root/bg/users/login.html 167.99.142.201

set names utf8

SELECT
                `MetaTitle`,
                `MetaDescription`,
                `MetaImage`,
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/login'
            LIMIT 1

SELECT COUNT(ID) FROM organizations WHERE `Visible` = 1

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'search'

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ExternalURL`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MenuLabel` != '' AND
                `MenuLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'footer'
            LIMIT 1

SELECT
                `ExternalURL`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `FooterLabel` != '' AND
                `FooterLabel` IS NOT NULL AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:46:24] /ngobg/root/bg/ajax/users/form/login.html?_=1722501984125 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 11:46:24] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501984128 167.99.142.201

set names utf8

(
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 11 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 12 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 13 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 14 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 31 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 32 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 33 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 34 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 21 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `UploadID`,
                                `Images`,
                                `SourceCode`,
                                `Title`,
                                `Target`,
                                `Position`
                            FROM
                                `banners`
                            WHERE
                                (`Images` <> '' OR `SourceCode` <> '') AND
                                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                                `Position` = 22 AND
                                1 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
# [01-Aug-2024 11:46:24] /ngobg/root/bg/ajax/users/bar.html?_=1722501984127 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:46:26] /ngobg/root/bg/ajax/users/login.html?_=1722501986272 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT `ID`, `UserKey`, `EMailKey` FROM `users` WHERE `UserKey` LIKE 'w4LCv8OPwr3CucOMw7LCksOaw4nDh8K5wrjDjMOnwr_DlMK1wqHDg8OT%' LIMIT 1
# [01-Aug-2024 11:46:26] /ngobg/root/admin/ 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                    `messages`.*,
                    `users`.`Data` AS `UserData`,
                    `users`.`Sort` AS `UserSort`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    `organizations`.`Sort` AS `OrgSort`
                FROM
                    `messages`
                    INNER JOIN `users` ON `messages`.`UserID` = `users`.`ID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                
                ORDER BY
                    `messages`.`LastUpdate` DESC, `messages`.`PostDate` DESC
             LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (
                SELECT
                    `messages`.*,
                    `users`.`Data` AS `UserData`,
                    `users`.`Sort` AS `UserSort`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    `organizations`.`Sort` AS `OrgSort`
                FROM
                    `messages`
                    INNER JOIN `users` ON `messages`.`UserID` = `users`.`ID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                
                ORDER BY
                    `messages`.`LastUpdate` DESC, `messages`.`PostDate` DESC
            ) AS CountTable
# [01-Aug-2024 11:46:28] /ngobg/root/css/boxes.css-?1722501988 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:46:28] /ngobg/root/css/nav.css-?1722501988 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:46:31] /ngobg/root/admin/bg/organizations.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [01-Aug-2024 11:46:31] /ngobg/root/css/boxes.css-?1722501991 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:46:32] /ngobg/root/css/nav.css-?1722501991 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:46:33] /ngobg/root/admin/bg/users.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
        ) AS CountTable
# [01-Aug-2024 11:46:33] /ngobg/root/css/boxes.css-?1722501993 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:46:33] /ngobg/root/css/nav.css-?1722501993 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:46:36] /ngobg/root/admin/bg/ajax/users/delete/10491.html?_=1722501996167 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

DELETE FROM `users` WHERE `ID` = '10491'
# [01-Aug-2024 11:46:36] /ngobg/root/admin/bg/users.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
        ) AS CountTable
# [01-Aug-2024 11:46:36] /ngobg/root/css/boxes.css-?1722501996 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:46:36] /ngobg/root/css/nav.css-?1722501996 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:46:38] /ngobg/root/admin/bg/users.html 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `users`.`ID`,
                `users`.`RegDate`,
                `users`.`LastUpdate`,
                `users`.`Data`,
                `users`.`Sort` AS `UserSort`,
                RIGHT(`users`.`UserKey`, 1) AS `Access`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `users`
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            
            ORDER BY
                `users`.`RegDate` DESC
        ) AS CountTable
# [01-Aug-2024 11:46:38] /ngobg/root/css/boxes.css-?1722501998 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:46:38] /ngobg/root/css/nav.css-?1722501998 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:46:41] /ngobg/root/bg/ajax/users/logout.html?_=1722502000839 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:46:41] /ngobg/root/ 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'messages'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'index' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'main'
             ORDER BY
                `labels`.`Label` ASC

(SELECT `ID`, `Title`, '' AS `URLLabel`, 'annual' AS `Module` FROM `annual` WHERE `AnnualDate` = DATE_FORMAT(NOW(),'%c%d') AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 9)
            LIMIT 3

(SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'analysis' AS `Module` FROM `analysis` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'legal' AS `Module` FROM `legal` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'position' AS `Module` FROM `position` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            ORDER BY PostDate ASC, `PostDate` DESC
            LIMIT 3

SELECT
                `ID`,
                `UserID`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

(SELECT
                `ID`,
                `UserID`,
                'news' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `news`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'analysis' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `analysis`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'reportage' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `reportage`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `FirstPage` = 'no' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'legal' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `legal`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'position' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `position`
            WHERE
                /* (`CalendarDate` IS NULL OR `CalendarDate` != CURDATE()) AND */
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            UNION

            (SELECT
                `ID`,
                `UserID`,
                'live' AS `PostType`,
                `PostDate`,
                `UploadID`,
                `Gallery`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Content`
            FROM
                `live`
            WHERE
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 20)

            ORDER BY `PostDate` DESC

            LIMIT 20

(SELECT
                `ID`,
                `UserID`,
                `Title`,
                `URLLabel`,
                'ads' AS `PostType`,
                `PostDate`,
                `ValidTo`
            FROM
                `ads`
            WHERE
                `ValidTo` IS NOT NULL AND
                `ValidTo` >= CURDATE() AND
                `Visible` = 1
            LIMIT 14)

            UNION

            (SELECT
                `careers`.`ID`,
                `careers`.`UserID`,
                `careers`.`Title`,
                `careers`.`URLLabel`,
                'careers' AS `PostType`,
                `careers`.`PostDate`,
                `ActiveDate` AS `ValidTo`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
            WHERE
                `ActiveDate` IS NOT NULL AND
                `ActiveDate` >= CURDATE() AND
                `users`.`UserKey` LIKE '%2' AND
                `careers`.`Visible` = 1
            LIMIT 14)

            ORDER BY `ValidTo` DESC
            LIMIT 14;

