                            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 09:10:29] /ngobg/root/bg/ajax/users/bar.html?_=1722492629097 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 09:10:30] /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 09:10:30] /ngobg/root/bg/ajax/users/bar.html?_=1722492630214 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 09:10:30] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722492630214 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 09:10:30] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492630215 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
                        )

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 09:10:40] /ngobg/root/bg/ajax/organizations/form.html?_=1722492640450 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 09:11:14] /ngobg/root/bg/ajax/organizations/register.html?_=1722492674546 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 09:11:14', `UserKey` = 'w4jCu8OXw4LCjcOMw6zCtsKbw4nDgsK2a9af9bc42a96e901f1ab6bb39480aa942', `Data` = '_AiDFfD6IL6tRy0dSXcV3rqRFG9mCYtjxB9eZU4hdS04xriFb4N01QgIWZPMNAvEZQIm0Jce1QsWtOkAqriacuKuoc5_m6eOxiqwgeksdoVCMC5ItSXnVs9uSoFsePYKvMcokzgKnOQJ27TiqrNeVSlJxf2z6kQxCALubj87sYw', `SearchKey` = 'wrXDg8KdwwrfCicK2wrrCscKdwrDi8ORwwq7CncKdwwrjCncK6w4jCscwq3CrsKywwq3CrsKyw', `EMailKey` = 'b8d5e5a543f9505c297df9638d04f43a661f810961ecc323828e1fead72b3819', `Sort` = '1060111'

SELECT * FROM `organizations` LIMIT 1

SHOW COLUMNS FROM `organizations`

INSERT INTO `organizations` SET `RegDate` = '2024-08-01', `FirstRegDate` = '2024-08-01', `LastUpdate` = '2024-08-01', `UserID` = 10481, `UploadID` = '2024/08/01/2492640660', `FilePath` = '', `OrgName` = 'wq3CrsKywrnCpsODw4fCvcOQwprC', `OrgNameEN` = 'wq3CrsKywrnCpsODw4fCvcOGw4DCnc', `OrgNameKey` = 'e93ccf5ffc90eefcc0bdb81f87d25d1a', `OrgType` = '1', `Statute` = '1', `Data` = 'ISVXNmwRVpiHd94zL4ioekTr_QhgdnkIrfrGByr-z2jGkq579iFsHF2f6wkzI8eGHd6TdI1503kYaLi36y43T8bD9pKef3P-XO1nnguICXP9jCvLKFj3kQrOB0gN4YmsMsl5LcsbIrW_tdforjfT_rUZR5JRhoTGo965K2FUJ3iTMMplb0uauLDHEl5vjuGuU_Da-wSKNri_g6MnPrvyOvuTZTE1fY3Uj3b0FO7__GWlQfOefJMsINkFMyEFzugpJf08UGgSE3wGIkCCto137BlAliPcbkQFlSnlAl4xp6zwrZB-idme0uH5J2IB30vpj-Sbwmjh7DwiyveJEnPcibYYZvXILlgbTwrVtbr6WuGhmkLhE6N0Skp0zg5fH0VHM_cb9sa5D6XeZd-tz2xWALpv19YC9onxJVw1nyWoxF9q67WopruOTzEOBcZ3p_CtLlYDIDyd45s44-tz4c5hmxv8g8Bm7rbRpWHOoplJHIHt4PnUAbAltg-mJpRF4O2xWBDwTOVoDpNwa1kFJjzyaXIunjVG7UlmSk1ahko4jrirUS-zDH4bB9fZHgVxt8T4ng5tcp4RWknOL2PLGeEq8KCWQbvK_dtmvyDYVKVNcvBGYLagUlKjFL8AX88MnkXSXPFML0-ae7MvpYt8V1QWPY8hMtsEXQM4tT1SiCWzLNo_vMrjkRBlvuVPc6kjgz3q-M-o-DxdBQ3lDncA8zMMw2v-ahquMQJJ_sjEa8bCMgiG2mJXrT_ur2DCXyqFxP2NSibyyzjgjEixVQtvXFVIxiYQ6smn7FQOat9mkFoVLcQ', `Address` = 'woTCosKswpDgsKkwrzDicKdwrTCn8KjwrzDn8K6wojCm8KewrCssOfwqnCnMKYwp3CtMKewrbDn8wrfCiMKdwrvCrsOCwwqHCqsK9w4XCmswq3CrcKVw4XCrsKyw6XCgsOOwqCpcK6wqrCs8OBwwrfCncKqw4fCrsKew53CusOSw', `ScopeOfActivity` = 512, `Members` = '', `Representative` = '', `FinancialInfo` = '1', `Volunteers` = 0, `Sort` = '970115'

SELECT
                `users`.`Data`,
                IF(`bulletin_users`.`ID` IS NULL, 0, 1) AS `Bulletin`
            FROM
                `users`
                LEFT JOIN `bulletin_users` ON `users`.`EMailKey` = `bulletin_users`.`EMailKey`
            WHERE
                `users`.`ID` = 10481
            LIMIT 1

SELECT
                    GROUP_CONCAT(`Title` SEPARATOR '; ') AS `Activities`
                FROM
                    `activities`
                WHERE
                    1 << (`ID` - 1) & 512 AND
                    `Language` = 'bg'

SELECT `Title` FROM `org_types` WHERE `ID` = 1 AND `Language` = 'bg' LIMIT 1

SELECT `Title` FROM `org_statutes` WHERE `ID` = 1 AND `Language` = 'bg' LIMIT 1

SELECT * FROM `org_data` LIMIT 1

SHOW COLUMNS FROM `org_data`

REPLACE INTO `org_data` SET `OrgID` = 113074, `OrgName` = 'asdasdsa', `URLLabel` = 'asdasdsa', `OrgNameEN` = 'asdasdasd', `URLLabelEN` = 'asdasdasd', `YearOfRegistration` = '', `Abbreviation` = '', `AbbreviationEN` = '', `Representative` = 'te', `Members` = 'te', `ContactPerson` = '', `Region` = 'Благоевград', `Town` = 'Sofia', `PosteCode` = '', `Address` = '1600 Amphitheatre Parkway', `Phone` = '0878555206', `Mobile` = '', `Fax` = '', `EMail` = 'asdasdasdasd@asd', `WebSite` = '', `FacebookLink` = '', `YouTubeLink` = '', `Mission` = '', `Target` = '', `LastProject` = '', `LastProjectDescription` = '', `History` = '', `AdditionalInfo` = ''
# [01-Aug-2024 09:12:14] /ngobg/root/bg/users/login.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` = 10481 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/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 09:12:14] /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` = 10481 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 09:12:14] /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` = 10481 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 09:12:14] /ngobg/root/bg/ajax/users/form/login.html?_=1722492734284 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` = 10481 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 09:12:14] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492734287 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` = 10481 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
                        )
# [01-Aug-2024 09:12:14] /ngobg/root/bg/ajax/users/bar.html?_=1722492734285 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` = 10481 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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 09:12:14] /ngobg/root/bg/ajax/recaptcha/appkey.html?_=1722492734343 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` = 10481 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 09:12:54] /ngobg/root/bg/users/login.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` = 10481 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/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 09:12:54] /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` = 10481 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 09:12:54] /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` = 10481 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 09:12:55] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492774963 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` = 10481 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
                        )
# [01-Aug-2024 09:12:55] /ngobg/root/bg/ajax/users/form/login.html?_=1722492774961 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` = 10481 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC
# [01-Aug-2024 09:12:55] /ngobg/root/bg/ajax/users/bar.html?_=1722492774963 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` = 10481 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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 09:12:55] /ngobg/root/bg/ajax/recaptcha/appkey.html?_=1722492775016 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` = 10481 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 09:12:58] /ngobg/root/bg/ajax/users/logout.html?_=1722492778638 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` = 10481 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 09:12:58] /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 09:12:59] /ngobg/root/bg/ajax/users/bar.html?_=1722492779046 167.99.142.201
# [01-Aug-2024 09:12:59] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492779047 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 09:13:00] /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 09:13:00] /ngobg/root/bg/ajax/users/form/login.html?_=1722492780606 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 09:13:00] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492780607 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 09:13:00] /ngobg/root/bg/ajax/users/bar.html?_=1722492780606 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 09:13:02] /ngobg/root/bg/ajax/users/login.html?_=1722492782641 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 09:13:02] /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 09:13:04] /ngobg/root/css/boxes.css-?1722492784 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 09:13:04] /ngobg/root/css/nav.css-?1722492784 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 09:13:08] /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 09:13:08] /ngobg/root/css/boxes.css-?1722492788 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 09:13:08] /ngobg/root/css/nav.css-?1722492788 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 09:13:11] /ngobg/root/admin/bg/ajax/organizations/delete/113074.html?_=1722492791398 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 `organizations` WHERE `ID` = '113074'
# [01-Aug-2024 09:13:11] /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 09:13:11] /ngobg/root/css/boxes.css-?1722492791 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 09:13:11] /ngobg/root/css/nav.css-?1722492791 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 09:13:12] /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 09:13:12] /ngobg/root/css/boxes.css-?1722492792 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 09:13:12] /ngobg/root/css/nav.css-?1722492792 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 09:13:15] /ngobg/root/admin/bg/ajax/users/delete/10481.html?_=1722492795045 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` = '10481'
# [01-Aug-2024 09:13:15] /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 09:13:15] /ngobg/root/css/boxes.css-?1722492795 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 09:13:15] /ngobg/root/css/nav.css-?1722492795 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 09:13:28] /ngobg/root/bg/ajax/users/logout.html?_=1722492808157 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 09:13: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 09:13:28] /ngobg/root/bg/ajax/users/bar.html?_=1722492808535 167.99.142.201

set names utf8
# [01-Aug-2024 09:13:28] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492808536 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
                        )

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 09:13:29] /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 09:13:30] /ngobg/root/bg/ajax/users/bar.html?_=1722492809979 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 09:13:30] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492809979 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 09:13:30] /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 09:13:30] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722492810803 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 09:13:30] /ngobg/root/bg/ajax/users/bar.html?_=1722492810804 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 09:13:30] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492810805 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 09:13:54] /ngobg/root/bg/ajax/organizations/form.html?_=1722492834257 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` = '0c935bc13c7419545753d3730228b47effe872715300dc324cdd45865ed0c483' 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 09:14:24] /ngobg/root/bg/ajax/organizations/register.html?_=1722492864360 167.99.142.201

set names utf8

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

SELECT * FROM `organizations` LIMIT 1

SHOW COLUMNS FROM `organizations`

INSERT INTO `organizations` SET `RegDate` = '2024-08-01', `FirstRegDate` = '2024-08-01', `LastUpdate` = '2024-08-01', `UserID` = 'ERROR:{"field":"EMail","msg":"\u041d\u0435\u0432\u0430\u043b\u0438\u0434\u043d\u043e \u043f\u043e\u0442\u0440\u0435\u0431\u0438\u0442\u0435\u043b\u0441\u043a\u043e \u0438\u043c\u0435 \u0438\u043b\u0438 \u043f\u0430\u0440\u043e\u043b\u0430"}', `UploadID` = '2024/08/01/2492834498', `FilePath` = '', `OrgName` = 'wrjCncK6w4jCsc', `OrgNameEN` = 'wrjCncK6w4jCsc', `OrgNameKey` = '033bd94b1168d7e4f0d644c3c95e35bf', `OrgType` = '1', `Statute` = '1', `Data` = 'TF6eng94-VsHYKIXHluzjX8dJT0LhbEff7aSQsyxVenzqzGv_Mu9CMcmod2kiDzQ9RdpzV5zGgpDgyc3FSfhTdywdoXQKo8WszBeb7hot8G2AAnf90Ja86yi-haF-xhOfnhQDNtaTfkWNi0yUTTXnaH5X5L1qu4IE2uzzpPlHW7516o1cuA7OFT1qNm4A8Kx-mP1BkLeOSiV19RE5iMU9Mt8ppmgKwz3Rzg2qijopFD_HEfcKWBqOr-X395STUKN3YHibUQUy9XuLo0ENAVhtPHevOElneKGKHLQaEwAo-NxGggjJIMiDYd7dEAa2v2JiH8HNyU-Ud2e8IH6hQoSHX1gwtnAXG3E4gorXOkcuLxqePMHGr1M7GRwXDYIqr_BfmCSPYjE_Bj2NWaHnlPmDIcX35zFu_TJq2tNI4EvczMIpwyolJN1zBntiVm5aZMef9TssVeXJP876Z0pHt4y0zcswPU4-bF-hT7JohwBhLeKdhrx-q2NXTwpqa16UdX55zv4EQs9ZSAiVI0zlRSLo8MwDGI6muO-sOYLCAfky8fHgGCS4uurkKHgbggPAV7URNvRbo1n8B6Iqug8d0sGt-HO6BxYXBpudJjb3Nz_9r5_OD9vrntW15REj3Ypzb-nSBKfgj9eLhGHyGXqjHFhDolBy28SH32qi_CMeW_MeB89vV2x5hZXSz9_eZxndBzxiKMXdB2r_uOgHXvSaX6QIRuKpHYTXYRC7KgXq88JM29PXe6s15LS09wimGcAU_g98LBhl5Mt5GPBVy6pNn22Ug', `Address` = 'woTCosKswpDgsKkwrzDicKdwrTCn8KjwrzDn8K6wojCm8KewrCssOfwqnCnMKYwp3CtMKewrbDn8wrfCiMKdwrvCrsOCwwqHCqsK9w4XCmswq3CrcKVw4XCrsKyw6XCgsOOwqCpcK6wqrCs8OBwwrfCncKqw4fCrsKew53CusOSw', `ScopeOfActivity` = 4096, `Members` = '', `Representative` = '', `FinancialInfo` = '1', `Volunteers` = 0, `Sort` = '1160101'
# [01-Aug-2024 09:15:34] /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 09:15:34] /ngobg/root/bg/ajax/users/bar.html?_=1722492934350 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 09:15:34] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722492934349 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 09:15:34] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492934350 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 09:15:40] /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 09:15:40] /ngobg/root/bg/ajax/users/bar.html?_=1722492940486 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 09:15:40] /ngobg/root/bg/ajax/users/form/login.html?_=1722492940484 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 09:15:40] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492940486 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 09:15:42] /ngobg/root/bg/ajax/users/login.html?_=1722492942368 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 09:15:42] /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 09:15:44] /ngobg/root/css/boxes.css-?1722492944 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 09:15:44] /ngobg/root/css/nav.css-?1722492944 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 09:15:47] /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 09:15:47] /ngobg/root/css/boxes.css-?1722492947 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 09:15:48] /ngobg/root/css/nav.css-?1722492947 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 09:15:49] /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 09:15:49] /ngobg/root/css/boxes.css-?1722492949 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 09:15:49] /ngobg/root/css/nav.css-?1722492949 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 09:15:52] /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 09:15:53] /ngobg/root/css/boxes.css-?1722492953 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 09:15:53] /ngobg/root/css/nav.css-?1722492953 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 09:15: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 09:15:55] /ngobg/root/css/boxes.css-?1722492955 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 09:15:55] /ngobg/root/css/nav.css-?1722492955 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 09:16:06] /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 09:16:06] /ngobg/root/css/boxes.css-?1722492966 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 09:16:06] /ngobg/root/css/nav.css-?1722492966 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 09:16:09] /ngobg/root/bg/ajax/users/logout.html?_=1722492969135 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 09:16:09] /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 09:16:09] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492969558 167.99.142.201
# [01-Aug-2024 09:16:09] /ngobg/root/bg/ajax/users/bar.html?_=1722492969556 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 09:16:11] /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 09:16:11] /ngobg/root/bg/ajax/users/bar.html?_=1722492971475 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 09:16:11] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492971475 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 09:16:12] /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 09:16:12] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722492972307 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 09:16:12] /ngobg/root/bg/ajax/users/bar.html?_=1722492972307 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 09:16:12] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722492972308 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 09:16:27] /ngobg/root/bg/ajax/organizations/form.html?_=1722492986938 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` = '6d14b4680ceecfa36909bd31bf361d48cd2622227a09b9faae194d473a65c438' 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 09:16:52] /ngobg/root/bg/ajax/organizations/register.html?_=1722493012049 167.99.142.201

set names utf8

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

SELECT * FROM `organizations` LIMIT 1

SHOW COLUMNS FROM `organizations`

INSERT INTO `organizations` SET `RegDate` = '2024-08-01', `FirstRegDate` = '2024-08-01', `LastUpdate` = '2024-08-01', `UserID` = 'ERROR:{"field":"EMail","msg":"\u041d\u0435\u0432\u0430\u043b\u0438\u0434\u043d\u043e \u043f\u043e\u0442\u0440\u0435\u0431\u0438\u0442\u0435\u043b\u0441\u043a\u043e \u0438\u043c\u0435 \u0438\u043b\u0438 \u043f\u0430\u0440\u043e\u043b\u0430"}', `UploadID` = '2024/08/01/2492987169', `FilePath` = '', `OrgName` = 'wrjCncK6w4jCsc', `OrgNameEN` = 'wq3CrsKywrnCpsODw4fCvcOGw4DCnc', `OrgNameKey` = '033bd94b1168d7e4f0d644c3c95e35bf', `OrgType` = '1', `Statute` = '1', `Data` = 'jfAQmafnwcaQOal4YeFrN90JzKzglDwF4dFTJnoUXCD6Z3SDbPLZ810NARlu-yneDVmjeGZ8nZZcE5mhQLNVUDLYjmG6ekbTffTCnrbn5-AMu5-Wb9V-OPSMTA829rm9VTyVJuI7fLhgNzEhEq0CkfwxDi5d76IFHOExawxNgdSKSzhjm0e6xJGGzSkw5wW4wrAajRpV6_PPaoa4IQNNz8pVDE5cOfQBwklu7P-zxnAill9I7Wbx8K1NjYUUKdsb02_wDaDUZiGeS_kDJJow6KSPkar-CRCKS3i58_pnmoPEOX-YU6573t2r6tMUbPrqomqbR4Z6rw8i5kyTWOq8teWvtIyMVbxpoUmLuViBGa7Uf7s7a7LjpVhLr0nttyz_FmTrv_20Y9RDjV9PI2q5QzzPiyF5_RaPC63C4MHQeFm5GQ2xOz_mja4f_7na_8ilTKuWeUISF14GZ1_8QxgeO408tHH-zLvKLZpAB3GCKl7o3HxEBlY4b_OwKWb7SKdAayzaFxrEqTRGPjbloyQzOcn1hIIjbJciP3kucC30YwrwOad1aLGYq4LQHspLT_Hv24j_7c8MFVPyrBXx3yg2FcQFfM6LmdzrhBfzlTgaFBXg5NilAJWbr-Rvxl1RrX6XrX-8pbta6EpOmo0KtIXikdzoEgEnMCMfCtcL07cGO5w1k31CYyEpn2IZa35WkJtDKmDVk_wJCpTV8aBXyIStHXoHt5yu7A3vujHw37o5qEobWO7_q8bATtbbAVAZ7zU4nDEM8jY9ii6S2s7IQEWh4UObCthjPehhRn_IJ-Asw-g', `Address` = 'woTCosKswpDgsKkwrzDicKdwrTCn8KjwrzDn8K6wojCm8KewrCssOfwqnCnMKYwp3CtMKewrbDn8wrbCrcKdf8Kvw5nDi8K6w47Cv8wrjDg8OQwrrCscwqHCqsK9w4XCmswq3CrcKVw4XCrsKyw6XCgsOOwqCpcK6wqrCs8OBwwrfCncKqw4fCrsKew53CusOSw', `ScopeOfActivity` = 1024, `Members` = '', `Representative` = '', `FinancialInfo` = '1', `Volunteers` = 0, `Sort` = '1160101'
# [01-Aug-2024 09:17:15] /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 09:17:16] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722493035958 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 09:17:16] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722493035957 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 09:17:16] /ngobg/root/bg/ajax/users/bar.html?_=1722493035958 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 09:17:21] /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 09:17:22] /ngobg/root/bg/ajax/users/form/login.html?_=1722493041915 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 09:17:22] /ngobg/root/bg/ajax/users/bar.html?_=1722493041916 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 09:17:22] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722493041917 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 09:17:23] /ngobg/root/bg/ajax/users/login.html?_=1722493043424 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 09:17:23] /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 09:17:25] /ngobg/root/css/boxes.css-?1722493045 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 09:17:25] /ngobg/root/css/nav.css-?1722493045 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 09:17:28] /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 09:17:29] /ngobg/root/css/boxes.css-?1722493049 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 09:17:29] /ngobg/root/css/nav.css-?1722493049 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 09:17:30] /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 09:17:30] /ngobg/root/css/boxes.css-?1722493050 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 09:17:30] /ngobg/root/css/nav.css-?1722493050 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 09:17:32] /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 09:17:32] /ngobg/root/css/boxes.css-?1722493052 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 09:17:32] /ngobg/root/css/nav.css-?1722493052 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 09:17:44] /ngobg/root/bg/ajax/users/logout.html?_=1722493064574 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 09:17:44] /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 09:17:45] /ngobg/root/bg/ajax/users/bar.html?_=1722493065091 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 09:17:45] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722493065093 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 09:17:48] /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 09:17:48] /ngobg/root/bg/ajax/users/bar.html?_=1722493068654 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 09:17:48] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722493068654 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 09:17:49] /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 09:17:50] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722493069929 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 09:17:50] /ngobg/root/bg/ajax/users/bar.html?_=1722493069930 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 09:17:50] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722493069930 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 09:35:06] /ngobg/root/bg/ajax/organizations/form.html?_=1722494106364 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` = '6d14b4680ceecfa36909bd31bf361d48cd2622227a09b9faae194d473a65c438' 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 09:40:30] /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 09:40:31] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1195&_=1722494431633 167.99.142.201
# [01-Aug-2024 09:40:31] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722494431631 167.99.142.201

set names utf8

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
                        )

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
# [01-Aug-2024 09:40:31] /ngobg/root/bg/ajax/users/bar.html?_=1722494431633 167.99.142.201

set names utf8

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

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 09:40:41] /ngobg/root/bg/ajax/organizations/form.html?_=1722494441135 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 09:41:10] /ngobg/root/bg/ajax/organizations/register.html?_=1722494470606 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 09:41:10', `UserKey` = 'w4jCu8OXw4LCjcOMw6zCtsKbw4nDgsK2a9af9bc42a96e901f1ab6bb39480aa942', `Data` = 'BZpuE-ZYGbRQ6LfgW6xyidufqlPlvxzPb7Djb_0wqGQs-8-64izUJrKawWe4HIOzffGkD4J2Ik7302ofFLNd8EFMlkNs6XWccRzXNKLK9lXDJekJXEim1Ua2PYbJq_Ffvpc4xooStl9o7SN7MeX2Am8Vg7AgYqSF9PAeRyUk0u4', `SearchKey` = 'wrXDg8KdwwrfCicK2wrrCscKdwrDi8ORwwq7CncKdwwrjCncK6w4jCscwq3CrsKywwq3CrsKyw', `EMailKey` = 'b8d5e5a543f9505c297df9638d04f43a661f810961ecc323828e1fead72b3819', `Sort` = '1060111'

SELECT * FROM `organizations` LIMIT 1

SHOW COLUMNS FROM `organizations`

INSERT INTO `organizations` SET `RegDate` = '2024-08-01', `FirstRegDate` = '2024-08-01', `LastUpdate` = '2024-08-01', `UserID` = 10482, `UploadID` = '2024/08/01/2494441367', `FilePath` = '', `OrgName` = 'wrjCncK6w4jCsc', `OrgNameEN` = 'wq3CrsKywrnCpsODw4fCvcOGw4DCnc', `OrgNameKey` = '033bd94b1168d7e4f0d644c3c95e35bf', `OrgType` = '1', `Statute` = '1', `Data` = 'IfZjNyJqAOoraS8c9FYgGv8BTkLhj5PO9MrjZiQxbhg3ZqXuJnpW4IxF8taDZH_90heMShvxo0YW3wOQ4o7HBmJBbtTYAikR3L1uHUidxCigu88DnP1mqLYKiCgSGTYBIiQr4P1ypsodVYH6MHzNAKP246USDStObI82ILnM3kouAXhq_3icYdj8WzjORupAIvAjSDpQl7yhURWAxG-i8SFn0rWyahyF327o7hrvjc0PSugltRjodmC8fWEdrOo00_7jT0ftDyIujoBKxKjQD2q5lAPqo7G-2rG3KBXpRU4-hkhYIQ11MtrxxUgN9sTrt6Uf-yzZDUhIdSZPXs7DfdOhdNIPWbDAf1i6zSr2SSVRL7_9Guu-apG7yalcAiRWXT-ivlM2-FaM6tYd_roNHplLQjQ1DsRizbEGFXvITz7CaJie75hwBpeK9Y-GWMZ5cdIGtAXSXUcNgt3ExNihKxBByxb2Qx5zX0LWgMl9dsCu92KX0mQtQmSyHs8U478zXH4KUgvQYkyJJkJNNFvO107cq6JP3EO5veRqk2rutDcc11BHTuM_OONE1_9YIO1f6VE_F-DdzxqGI7duf0nN-wJWQXlsqUgbBtGJcr2Hb3qsV_VeEfWmJ7CWINAv0lb3Ro5cA-GcYKJxFV01Xyblx0OZotloQIy3qwFv997Q8G5TCHhJFqlz5caPYQB3iUABc8uoCJAl4Z7_TG1H3feM7M0Chhz-PmXtOjKzq4FsawV_mvbXaZ42rDRSPvF1nPaZTt0b83ta_G9NDv6yx9xeVfrdZCVxTAAF4LYHGqhfLsQ', `Address` = 'woTCosKswpDgsKkwrzDicKdwrTCn8KjwrzDn8K6wojCm8KewrCssOfwqnCnMKYwp3CtMKewrbDn8wrbCrcKdf8Kvw5nDi8K6w47Cv8wrjDg8OQwrrCscwoTCosKswqDCtMKkwrzCwoTCosKwwpDgsK5w4DClcKdwrTChsKkwqCucK6w', `ScopeOfActivity` = 128, `Members` = '', `Representative` = '', `FinancialInfo` = '1', `Volunteers` = 0, `Sort` = '1160101'

SELECT
                `users`.`Data`,
                IF(`bulletin_users`.`ID` IS NULL, 0, 1) AS `Bulletin`
            FROM
                `users`
                LEFT JOIN `bulletin_users` ON `users`.`EMailKey` = `bulletin_users`.`EMailKey`
            WHERE
                `users`.`ID` = 10482
            LIMIT 1

SELECT
                    GROUP_CONCAT(`Title` SEPARATOR '; ') AS `Activities`
                FROM
                    `activities`
                WHERE
                    1 << (`ID` - 1) & 128 AND
                    `Language` = 'bg'

SELECT `Title` FROM `org_types` WHERE `ID` = 1 AND `Language` = 'bg' LIMIT 1

SELECT `Title` FROM `org_statutes` WHERE `ID` = 1 AND `Language` = 'bg' LIMIT 1

SELECT * FROM `org_data` LIMIT 1

SHOW COLUMNS FROM `org_data`

REPLACE INTO `org_data` SET `OrgID` = 113075, `OrgName` = 'TEST', `URLLabel` = 'test', `OrgNameEN` = 'asdasdasd', `URLLabelEN` = 'asdasdasd', `YearOfRegistration` = '', `Abbreviation` = '', `AbbreviationEN` = '', `Representative` = 'te', `Members` = 'te', `ContactPerson` = '', `Region` = 'Благоевград', `Town` = 'Mountain View', `PosteCode` = '', `Address` = 'бул. Витоша 29', `Phone` = '0878555206', `Mobile` = '', `Fax` = '', `EMail` = 'test@asf.com', `WebSite` = '', `FacebookLink` = '', `YouTubeLink` = '', `Mission` = '', `Target` = '', `LastProject` = '', `LastProjectDescription` = '', `History` = '', `AdditionalInfo` = ''
# [01-Aug-2024 09:50:11] /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` = 10482 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 09:50:11] /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` = 10482 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 09:50:11] /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` = 10482 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 09:50:11] /ngobg/root/bg/ajax/users/bar.html?_=1722495011786 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` = 10482 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 09:50:11] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722495011784 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` = 10482 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 09:50:11] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1722495011786 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` = 10482 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 09:50:12] /ngobg/root/bg/ajax/recaptcha/appkey.html?_=1722495011841 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` = 10482 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 09:50:15] /ngobg/root/bg/ajax/users/logout.html?_=1722495015634 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` = 10482 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 09:50:15] /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

