# [05-Jul-2024 14:53:36] /ngobg/root/ 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
                `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 SUM(CR) FROM
            (
                (SELECT COUNT(`ID`) AS CR FROM `annual` WHERE `AnnualDate` = DATE_FORMAT(NOW(),'%c%d') AND `Visible` = 1 ORDER BY `PostDate` DESC)
                UNION ALL
                (SELECT COUNT(`ID`) AS CR FROM `calendar` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC)
                UNION ALL
                (SELECT COUNT(`ID`) AS CR FROM `news` WHERE `CalendarDate` = CURDATE() AND `Visible` = 1 ORDER BY `PostDate` DESC)
            ) A

(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` = 667 AND `Visible` = 1 LIMIT 1

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

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

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

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

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

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

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

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

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

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

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

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

SELECT `ID`, `UploadID`, `FilePath` FROM `organizations` WHERE `FilePath` != '' AND `UserID` = 667 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'
# [05-Jul-2024 14:53:37] /ngobg/root/css/boxes.css-?v5 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [05-Jul-2024 14:53:37] /ngobg/root/css/nav.css-?v5 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [05-Jul-2024 14:53:37] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1720180417181 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
                                `ID`,
                                `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')
# [05-Jul-2024 14:53:37] /ngobg/root/bg/ajax/users/bar.html?_=1720180417180 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jul-2024 14:54:34] /ngobg/root/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=01.11.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 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'
# [05-Jul-2024 14:54:35] /ngobg/root/css/boxes.css-?v5 167.99.142.201
# [05-Jul-2024 14:54:35] /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` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1

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
# [05-Jul-2024 14:54:35] /ngobg/root/bg/ajax/users/bar.html?_=1720180474986 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jul-2024 14:54:35] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1720180474987 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
# [05-Jul-2024 14:55:07] /ngobg/root/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=01.11.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 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'
# [05-Jul-2024 14:55:07] /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` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [05-Jul-2024 14:55:07] /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` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [05-Jul-2024 14:55:07] /ngobg/root/bg/ajax/users/bar.html?_=1720180507778 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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [05-Jul-2024 14:55:07] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1720180507779 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
# [05-Jul-2024 14:55:26] /ngobg/root/admin/ 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
                SELECT
                    `messages`.*,
                    `users`.`Data` AS `UserData`,
                    `users`.`Sort` AS `UserSort`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    `organizations`.`Sort` AS `OrgSort`
                FROM
                    `messages`
                    INNER JOIN `users` ON `messages`.`UserID` = `users`.`ID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                
                ORDER BY
                    `messages`.`LastUpdate` DESC, `messages`.`PostDate` DESC
            ) AS CountTable
# [05-Jul-2024 14:55:28] /ngobg/root/css/boxes.css-?1720180527 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
# [05-Jul-2024 14:55:28] /ngobg/root/css/nav.css-?1720180527 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
# [05-Jul-2024 14:55:28] /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
# [05-Jul-2024 14:55:47] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=01.11.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-11-01' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-11-01' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 14:55:47] /ngobg/root/css/boxes.css-?1720180547 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
# [05-Jul-2024 14:55:47] /ngobg/root/css/nav.css-?1720180547 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
# [05-Jul-2024 15:03:56] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:03:57] /ngobg/root/css/boxes.css-?1720181036 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
# [05-Jul-2024 15:03:57] /ngobg/root/css/nav.css-?1720181036 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
# [05-Jul-2024 15:09:36] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:09:36] /ngobg/root/css/boxes.css-?1720181376 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
# [05-Jul-2024 15:09:37] /ngobg/root/css/nav.css-?1720181376 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
# [05-Jul-2024 15:09:39] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:09:39] /ngobg/root/css/boxes.css-?1720181379 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
# [05-Jul-2024 15:09:39] /ngobg/root/css/nav.css-?1720181379 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
# [05-Jul-2024 15:09:41] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:09:41] /ngobg/root/css/boxes.css-?1720181381 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
# [05-Jul-2024 15:09:41] /ngobg/root/css/nav.css-?1720181381 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
# [05-Jul-2024 15:10:48] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:10:48] /ngobg/root/css/boxes.css-?1720181448 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
# [05-Jul-2024 15:10:49] /ngobg/root/css/nav.css-?1720181448 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
# [05-Jul-2024 15:11:28] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:11:28] /ngobg/root/css/boxes.css-?1720181488 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
# [05-Jul-2024 15:11:28] /ngobg/root/css/nav.css-?1720181488 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
# [05-Jul-2024 15:16:29] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:16:29] /ngobg/root/css/boxes.css-?1720181789 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
# [05-Jul-2024 15:16:29] /ngobg/root/css/nav.css-?1720181789 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
# [05-Jul-2024 15:17:50] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:17:50] /ngobg/root/css/boxes.css-?1720181870 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
# [05-Jul-2024 15:17:50] /ngobg/root/css/nav.css-?1720181870 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
# [05-Jul-2024 15:40:21] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:40:22] /ngobg/root/css/boxes.css-?1720183221 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
# [05-Jul-2024 15:40:22] /ngobg/root/css/nav.css-?1720183221 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
# [05-Jul-2024 15:53:29] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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
# [05-Jul-2024 15:55:46] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:55:47] /ngobg/root/css/boxes.css-?1720184147 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
# [05-Jul-2024 15:55:47] /ngobg/root/css/nav.css-?1720184147 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
# [05-Jul-2024 15:56:15] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=0&To=&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                             AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                             AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:56:16] /ngobg/root/css/boxes.css-?1720184175 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
# [05-Jul-2024 15:56:16] /ngobg/root/css/nav.css-?1720184175 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
# [05-Jul-2024 15:56:28] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=18.05.2023&To=01.07.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-05-18' AND '2024-07-01 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:56:28] /ngobg/root/css/boxes.css-?1720184188 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
# [05-Jul-2024 15:56:28] /ngobg/root/css/nav.css-?1720184188 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
# [05-Jul-2024 15:56:45] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=&To=&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                             AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                             AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:56:45] /ngobg/root/css/boxes.css-?1720184205 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
# [05-Jul-2024 15:56:45] /ngobg/root/css/nav.css-?1720184205 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
# [05-Jul-2024 15:58:34] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=01.06.2024&To=30.06.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2024-06-01' AND '2024-06-30 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2024-06-01' AND '2024-06-30 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 15:58:34] /ngobg/root/css/boxes.css-?1720184314 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
# [05-Jul-2024 15:58:34] /ngobg/root/css/nav.css-?1720184314 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
# [05-Jul-2024 15:59:13] /ngobg/root/admin/bg/spravki/mostoften.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
                *,
                `awards` + `campaigns` + `financing` + `calendar` + `news` + `ads` + `analysis` + `legal` + `position` + `careerswork` + `careerspractice` + `careersvolunteers` + `documents` + `documentsreports` + `documentsbuletin` AS `TotalNum`
            FROM
            (
                SELECT
                    `organizations`.`UserID`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    (SELECT COUNT(`awards`.`ID`) FROM `awards` WHERE `awards`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `awards`,
(SELECT COUNT(`campaigns`.`ID`) FROM `campaigns` WHERE `campaigns`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `campaigns`,
(SELECT COUNT(`financing`.`ID`) FROM `financing` WHERE `financing`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `financing`,
(SELECT COUNT(`calendar`.`ID`) FROM `calendar` WHERE `calendar`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `calendar`,
(SELECT COUNT(`news`.`ID`) FROM `news` WHERE `news`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `news`,
(SELECT COUNT(`ads`.`ID`) FROM `ads` WHERE `ads`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `ads`,
(SELECT COUNT(`analysis`.`ID`) FROM `analysis` WHERE `analysis`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `analysis`,
(SELECT COUNT(`legal`.`ID`) FROM `legal` WHERE `legal`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `legal`,
(SELECT COUNT(`position`.`ID`) FROM `position` WHERE `position`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `position`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 1 AND `organizations`.`UserID` > 50) AS `careerswork`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 2 AND `organizations`.`UserID` > 50) AS `careerspractice`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 3 AND `organizations`.`UserID` > 50) AS `careersvolunteers`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'document' AND `organizations`.`UserID` > 50) AS `documents`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'annualreport' AND `organizations`.`UserID` > 50) AS `documentsreports`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'buletin' AND `organizations`.`UserID` > 50) AS `documentsbuletin`
                FROM
                    `organizations`
                
            ) AS `publications`
            WHERE `awards` + `campaigns` + `financing` + `calendar` + `news` + `ads` + `analysis` + `legal` + `position` + `careerswork` + `careerspractice` + `careersvolunteers` + `documents` + `documentsreports` + `documentsbuletin` > 0
            ORDER BY `TotalNum` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                *,
                `awards` + `campaigns` + `financing` + `calendar` + `news` + `ads` + `analysis` + `legal` + `position` + `careerswork` + `careerspractice` + `careersvolunteers` + `documents` + `documentsreports` + `documentsbuletin` AS `TotalNum`
            FROM
            (
                SELECT
                    `organizations`.`UserID`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    (SELECT COUNT(`awards`.`ID`) FROM `awards` WHERE `awards`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `awards`,
(SELECT COUNT(`campaigns`.`ID`) FROM `campaigns` WHERE `campaigns`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `campaigns`,
(SELECT COUNT(`financing`.`ID`) FROM `financing` WHERE `financing`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `financing`,
(SELECT COUNT(`calendar`.`ID`) FROM `calendar` WHERE `calendar`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `calendar`,
(SELECT COUNT(`news`.`ID`) FROM `news` WHERE `news`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `news`,
(SELECT COUNT(`ads`.`ID`) FROM `ads` WHERE `ads`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `ads`,
(SELECT COUNT(`analysis`.`ID`) FROM `analysis` WHERE `analysis`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `analysis`,
(SELECT COUNT(`legal`.`ID`) FROM `legal` WHERE `legal`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `legal`,
(SELECT COUNT(`position`.`ID`) FROM `position` WHERE `position`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `position`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 1 AND `organizations`.`UserID` > 50) AS `careerswork`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 2 AND `organizations`.`UserID` > 50) AS `careerspractice`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 3 AND `organizations`.`UserID` > 50) AS `careersvolunteers`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'document' AND `organizations`.`UserID` > 50) AS `documents`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'annualreport' AND `organizations`.`UserID` > 50) AS `documentsreports`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'buletin' AND `organizations`.`UserID` > 50) AS `documentsbuletin`
                FROM
                    `organizations`
                
            ) AS `publications`
            WHERE `awards` + `campaigns` + `financing` + `calendar` + `news` + `ads` + `analysis` + `legal` + `position` + `careerswork` + `careerspractice` + `careersvolunteers` + `documents` + `documentsreports` + `documentsbuletin` > 0
            ORDER BY `TotalNum` DESC) AS CountTable

SELECT
                DISTINCT `Region`
            FROM
                `regions`
            WHERE
                `Language` = 'bg' AND
                `Region` != ''
            ORDER BY `Region` ASC
# [05-Jul-2024 15:59:23] /ngobg/root/css/boxes.css-?1720184363 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
# [05-Jul-2024 15:59:23] /ngobg/root/css/nav.css-?1720184363 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
# [05-Jul-2024 15:59:24] /ngobg/root/admin/bg/spravki/mostoften/page_2.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
                *,
                `awards` + `campaigns` + `financing` + `calendar` + `news` + `ads` + `analysis` + `legal` + `position` + `careerswork` + `careerspractice` + `careersvolunteers` + `documents` + `documentsreports` + `documentsbuletin` AS `TotalNum`
            FROM
            (
                SELECT
                    `organizations`.`UserID`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    (SELECT COUNT(`awards`.`ID`) FROM `awards` WHERE `awards`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `awards`,
(SELECT COUNT(`campaigns`.`ID`) FROM `campaigns` WHERE `campaigns`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `campaigns`,
(SELECT COUNT(`financing`.`ID`) FROM `financing` WHERE `financing`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `financing`,
(SELECT COUNT(`calendar`.`ID`) FROM `calendar` WHERE `calendar`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `calendar`,
(SELECT COUNT(`news`.`ID`) FROM `news` WHERE `news`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `news`,
(SELECT COUNT(`ads`.`ID`) FROM `ads` WHERE `ads`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `ads`,
(SELECT COUNT(`analysis`.`ID`) FROM `analysis` WHERE `analysis`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `analysis`,
(SELECT COUNT(`legal`.`ID`) FROM `legal` WHERE `legal`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `legal`,
(SELECT COUNT(`position`.`ID`) FROM `position` WHERE `position`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `position`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 1 AND `organizations`.`UserID` > 50) AS `careerswork`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 2 AND `organizations`.`UserID` > 50) AS `careerspractice`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 3 AND `organizations`.`UserID` > 50) AS `careersvolunteers`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'document' AND `organizations`.`UserID` > 50) AS `documents`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'annualreport' AND `organizations`.`UserID` > 50) AS `documentsreports`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'buletin' AND `organizations`.`UserID` > 50) AS `documentsbuletin`
                FROM
                    `organizations`
                
            ) AS `publications`
            WHERE `awards` + `campaigns` + `financing` + `calendar` + `news` + `ads` + `analysis` + `legal` + `position` + `careerswork` + `careerspractice` + `careersvolunteers` + `documents` + `documentsreports` + `documentsbuletin` > 0
            ORDER BY `TotalNum` DESC LIMIT 300, 300

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                *,
                `awards` + `campaigns` + `financing` + `calendar` + `news` + `ads` + `analysis` + `legal` + `position` + `careerswork` + `careerspractice` + `careersvolunteers` + `documents` + `documentsreports` + `documentsbuletin` AS `TotalNum`
            FROM
            (
                SELECT
                    `organizations`.`UserID`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    (SELECT COUNT(`awards`.`ID`) FROM `awards` WHERE `awards`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `awards`,
(SELECT COUNT(`campaigns`.`ID`) FROM `campaigns` WHERE `campaigns`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `campaigns`,
(SELECT COUNT(`financing`.`ID`) FROM `financing` WHERE `financing`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `financing`,
(SELECT COUNT(`calendar`.`ID`) FROM `calendar` WHERE `calendar`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `calendar`,
(SELECT COUNT(`news`.`ID`) FROM `news` WHERE `news`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `news`,
(SELECT COUNT(`ads`.`ID`) FROM `ads` WHERE `ads`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `ads`,
(SELECT COUNT(`analysis`.`ID`) FROM `analysis` WHERE `analysis`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `analysis`,
(SELECT COUNT(`legal`.`ID`) FROM `legal` WHERE `legal`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `legal`,
(SELECT COUNT(`position`.`ID`) FROM `position` WHERE `position`.`UserID` = `organizations`.`UserID` AND `organizations`.`UserID` > 50) AS `position`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 1 AND `organizations`.`UserID` > 50) AS `careerswork`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 2 AND `organizations`.`UserID` > 50) AS `careerspractice`,
(SELECT COUNT(`careers`.`ID`) FROM `careers` WHERE `careers`.`UserID` = `organizations`.`UserID` AND `careers`.`CareerType` = 3 AND `organizations`.`UserID` > 50) AS `careersvolunteers`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'document' AND `organizations`.`UserID` > 50) AS `documents`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'annualreport' AND `organizations`.`UserID` > 50) AS `documentsreports`,
(SELECT COUNT(`documents`.`ID`) FROM `documents` WHERE `documents`.`UserID` = `organizations`.`UserID` AND `documents`.`DocType` = 'buletin' AND `organizations`.`UserID` > 50) AS `documentsbuletin`
                FROM
                    `organizations`
                
            ) AS `publications`
            WHERE `awards` + `campaigns` + `financing` + `calendar` + `news` + `ads` + `analysis` + `legal` + `position` + `careerswork` + `careerspractice` + `careersvolunteers` + `documents` + `documentsreports` + `documentsbuletin` > 0
            ORDER BY `TotalNum` DESC) AS CountTable
# [05-Jul-2024 15:59:33] /ngobg/root/admin/bg/careers.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
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) <> 1
                
            ORDER BY
                `careers`.`PostDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) <> 1
                
            ORDER BY
                `careers`.`PostDate` DESC
        ) AS CountTable
# [05-Jul-2024 15:59:34] /ngobg/root/css/boxes.css-?1720184374 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
# [05-Jul-2024 15:59:34] /ngobg/root/css/nav.css-?1720184374 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
                DISTINCT `Region`
            FROM
                `regions`
            WHERE
                `Language` = 'bg' AND
                `Region` != ''
            ORDER BY `Region` ASC
# [05-Jul-2024 15:59:35] /ngobg/root/admin/bg/careers/page_2.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
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) <> 1
                
            ORDER BY
                `careers`.`PostDate` DESC
         LIMIT 20, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) <> 1
                
            ORDER BY
                `careers`.`PostDate` DESC
        ) AS CountTable
# [05-Jul-2024 15:59:42] /ngobg/root/admin/bg/careers/volunteers.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
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1
                
            ORDER BY
                `careers`.`PostDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1
                
            ORDER BY
                `careers`.`PostDate` DESC
        ) AS CountTable
# [05-Jul-2024 15:59:42] /ngobg/root/css/boxes.css-?1720184382 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
# [05-Jul-2024 15:59:42] /ngobg/root/css/nav.css-?1720184382 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
# [05-Jul-2024 15:59:43] /ngobg/root/admin/bg/careers/volunteers/page_2.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
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1
                
            ORDER BY
                `careers`.`PostDate` DESC
         LIMIT 20, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1
                
            ORDER BY
                `careers`.`PostDate` DESC
        ) AS CountTable
# [05-Jul-2024 16:00:00] /ngobg/root/admin/bg/ajax/careers/form/ct_1.html?_=1720184400762 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
                DISTINCT `Region`
            FROM
                `regions`
            WHERE
                `Language` = 'bg' AND
                `Region` != ''
            ORDER BY `Region` ASC

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

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

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC
# [05-Jul-2024 16:00:04] /ngobg/root/admin/bg/careers/volunteers.html?from=01.06.2024&to=30.06.2024&keyword= 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
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1
                 AND `careers`.`PostDate` BETWEEN '2024-06-01' AND '2024-06-30 23:59:59' 
            ORDER BY
                `careers`.`PostDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) = 1
                 AND `careers`.`PostDate` BETWEEN '2024-06-01' AND '2024-06-30 23:59:59' 
            ORDER BY
                `careers`.`PostDate` DESC
        ) AS CountTable
# [05-Jul-2024 16:00:04] /ngobg/root/css/boxes.css-?1720184404 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
# [05-Jul-2024 16:00:04] /ngobg/root/css/nav.css-?1720184404 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
# [05-Jul-2024 16:01:43] /ngobg/root/admin/bg/messages.html 167.99.142.201

set names utf8

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

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

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
# [05-Jul-2024 16:01:45] /ngobg/root/css/nav.css-?1720184504 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
# [05-Jul-2024 16:01:45] /ngobg/root/css/boxes.css-?1720184504 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
# [05-Jul-2024 16:01:45] /ngobg/root/admin/bg/messages/page_2.html 167.99.142.201

set names utf8

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

SELECT
                    `messages`.*,
                    `users`.`Data` AS `UserData`,
                    `users`.`Sort` AS `UserSort`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    `organizations`.`Sort` AS `OrgSort`
                FROM
                    `messages`
                    INNER JOIN `users` ON `messages`.`UserID` = `users`.`ID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                
                ORDER BY
                    `messages`.`LastUpdate` DESC, `messages`.`PostDate` DESC
             LIMIT 300, 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
# [05-Jul-2024 16:01:56] /ngobg/root/admin/bg/messages.html 167.99.142.201

set names utf8

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

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

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
# [05-Jul-2024 16:01:58] /ngobg/root/css/boxes.css-?1720184518 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
# [05-Jul-2024 16:01:58] /ngobg/root/css/nav.css-?1720184518 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
# [05-Jul-2024 16:01:59] /ngobg/root/admin/bg/messages/page_2.html 167.99.142.201

set names utf8

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

SELECT
                    `messages`.*,
                    `users`.`Data` AS `UserData`,
                    `users`.`Sort` AS `UserSort`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`,
                    `organizations`.`Sort` AS `OrgSort`
                FROM
                    `messages`
                    INNER JOIN `users` ON `messages`.`UserID` = `users`.`ID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                
                ORDER BY
                    `messages`.`LastUpdate` DESC, `messages`.`PostDate` DESC
             LIMIT 300, 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
# [05-Jul-2024 16:02:01] /ngobg/root/admin/bg/messages.html?from=&to=&keyword=Бъди доброволец на Open Buzludzha Fest '23 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`
                WHERE 1  AND `messages`.`Title` LIKE '%бъди%доброволец%на%open%buzludzha%fest%23%'
                ORDER BY
                    
                                CASE
                                    WHEN `messages`.`Title` LIKE 'бъди%доброволец%на%open%buzludzha%fest%23%' THEN 0
                                    WHEN `messages`.`Title` LIKE '% бъди%доброволец%на%open%buzludzha%fest%23%' THEN 1
                                    ELSE 2
                                END
                            
             LIMIT 0, 300
# [05-Jul-2024 16:02:02] /ngobg/root/css/boxes.css-?1720184522 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
# [05-Jul-2024 16:02:02] /ngobg/root/css/nav.css-?1720184522 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
# [05-Jul-2024 16:02:26] /ngobg/root/admin/bg/careers.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
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) <> 1
                
            ORDER BY
                `careers`.`PostDate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) <> 1
                
            ORDER BY
                `careers`.`PostDate` DESC
        ) AS CountTable
# [05-Jul-2024 16:02:26] /ngobg/root/css/boxes.css-?1720184546 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
# [05-Jul-2024 16:02:26] /ngobg/root/css/nav.css-?1720184546 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
# [05-Jul-2024 16:02:27] /ngobg/root/admin/bg/careers/page_2.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
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) <> 1
                
            ORDER BY
                `careers`.`PostDate` DESC
         LIMIT 20, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) <> 1
                
            ORDER BY
                `careers`.`PostDate` DESC
        ) AS CountTable
# [05-Jul-2024 16:02:29] /ngobg/root/admin/bg/careers.html?from=&to=&keyword=Бъди доброволец на Open Buzludzha Fest '23 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
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) <> 1
                 AND (`careers`.`Title` LIKE '%бъди%доброволец%на%open%buzludzha%fest%' OR `careers`.`Content` LIKE '%бъди%доброволец%на%open%buzludzha%fest%')
            ORDER BY
                
                        CASE
                            WHEN `careers`.`Title` LIKE 'бъди%доброволец%на%open%buzludzha%fest%' THEN 0
                            WHEN `careers`.`Title` LIKE '% бъди%доброволец%на%open%buzludzha%fest%' THEN 1
                            WHEN `careers`.`Content` LIKE '% бъди%доброволец%на%open%buzludzha%fest%' THEN 2
                            ELSE 3
                        END
                    
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `careers`.`ID`,
                `careers`.`PostDate`,
                `careers`.`UserID`,
                `careers`.`URLLabel`,
                `careers`.`Title`,
                `careers`.`Content`,
                `careers`.`Visible`,'',
                `careers`.`Hits`,
                `career_types`.`Title` AS `PostType`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`,
                `organizations`.`ID` AS `OrgID`,
                `organizations`.`Data` AS `OrgData`,
                `organizations`.`Sort` AS `OrgSort`
            FROM
                `careers`
                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID`
                INNER JOIN `career_types` ON `career_types`.`ID` = `careers`.`CareerType` AND `career_types`.`Language` = 'bg'
                LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
            WHERE
                RIGHT(`users`.`UserKey`, 1) <> 1
                 AND (`careers`.`Title` LIKE '%бъди%доброволец%на%open%buzludzha%fest%' OR `careers`.`Content` LIKE '%бъди%доброволец%на%open%buzludzha%fest%')
            ORDER BY
                
                        CASE
                            WHEN `careers`.`Title` LIKE 'бъди%доброволец%на%open%buzludzha%fest%' THEN 0
                            WHEN `careers`.`Title` LIKE '% бъди%доброволец%на%open%buzludzha%fest%' THEN 1
                            WHEN `careers`.`Content` LIKE '% бъди%доброволец%на%open%buzludzha%fest%' THEN 2
                            ELSE 3
                        END
                    
        ) AS CountTable
# [05-Jul-2024 16:02:30] /ngobg/root/css/boxes.css-?1720184550 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
# [05-Jul-2024 16:02:30] /ngobg/root/css/nav.css-?1720184550 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
# [05-Jul-2024 16:02:45] /ngobg/root/admin/bg/ajax/careers/form/ct_2/6283.html?_=1720184565418 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
                    `careers`.*,
                    GROUP_CONCAT(`activities`.`ID` SEPARATOR ',') AS `Activities`,
                    `users`.`Data` AS `UserData`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`
                FROM
                    `careers`
                    INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                    LEFT JOIN `activities` ON 1 << (`activities`.`ID` - 1) & `careers`.`ScopeOfActivity` AND `activities`.`Language` = 'bg'
                WHERE
                    `careers`.`ID` = 6283 AND
                    RIGHT(`users`.`UserKey`, 1) <> 1
                LIMIT 1

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

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC
# [05-Jul-2024 16:03:10] /ngobg/root/admin/bg/ajax/careers/form/ct_2/6283.html?_=1720184589937 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
                    `careers`.*,
                    GROUP_CONCAT(`activities`.`ID` SEPARATOR ',') AS `Activities`,
                    `users`.`Data` AS `UserData`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`
                FROM
                    `careers`
                    INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                    LEFT JOIN `activities` ON 1 << (`activities`.`ID` - 1) & `careers`.`ScopeOfActivity` AND `activities`.`Language` = 'bg'
                WHERE
                    `careers`.`ID` = 6283 AND
                    RIGHT(`users`.`UserKey`, 1) <> 1
                LIMIT 1

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

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC
# [05-Jul-2024 16:03:30] /ngobg/root/admin/bg/ajax/careers/form/ct_2/6283.html?_=1720184610041 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
                    `careers`.*,
                    GROUP_CONCAT(`activities`.`ID` SEPARATOR ',') AS `Activities`,
                    `users`.`Data` AS `UserData`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`
                FROM
                    `careers`
                    INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                    LEFT JOIN `activities` ON 1 << (`activities`.`ID` - 1) & `careers`.`ScopeOfActivity` AND `activities`.`Language` = 'bg'
                WHERE
                    `careers`.`ID` = 6283 AND
                    RIGHT(`users`.`UserKey`, 1) <> 1
                LIMIT 1

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

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC
# [05-Jul-2024 16:03:36] /ngobg/root/admin/bg/ajax/careers/form/ct_2/5912.html?_=1720184616474 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
                    `careers`.*,
                    GROUP_CONCAT(`activities`.`ID` SEPARATOR ',') AS `Activities`,
                    `users`.`Data` AS `UserData`,
                    `organizations`.`ID` AS `OrgID`,
                    `organizations`.`Data` AS `OrgData`
                FROM
                    `careers`
                    INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
                    LEFT JOIN `organizations` ON `users`.`ID` = `organizations`.`UserID`
                    LEFT JOIN `activities` ON 1 << (`activities`.`ID` - 1) & `careers`.`ScopeOfActivity` AND `activities`.`Language` = 'bg'
                WHERE
                    `careers`.`ID` = 5912 AND
                    RIGHT(`users`.`UserKey`, 1) <> 1
                LIMIT 1

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

SELECT
                `ID`,
                `Title`
            FROM
                `activities`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `ID` ASC
# [05-Jul-2024 16:04:54] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=01.06.2024&To=30.06.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2024-06-01' AND '2024-06-30 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2024-06-01' AND '2024-06-30 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 16:04:54] /ngobg/root/css/boxes.css-?1720184694 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
# [05-Jul-2024 16:04:54] /ngobg/root/css/nav.css-?1720184694 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
# [05-Jul-2024 16:05:56] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=01.01.2023&To=30.06.2024&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-01-01' AND '2024-06-30 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-01-01' AND '2024-06-30 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 16:05:56] /ngobg/root/css/boxes.css-?1720184756 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
# [05-Jul-2024 16:05:56] /ngobg/root/css/nav.css-?1720184756 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
# [05-Jul-2024 16:06:05] /ngobg/root/admin/bg/spravki/ownpublications.html?PostType=careersvolunteers&From=01.01.2023&To=30.11.2023&Topic=&SubTopic=&Source=&Author= 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 * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-01-01' AND '2023-11-30 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC LIMIT 0, 300

SELECT COUNT(*) AS NumRows FROM (SELECT * FROM (
                        (
                            SELECT
                                CONCAT('careers', `CareerType`) AS `PostType`,
                                `careers`.`PostDate`,
                                `careers`.`Title`,
                                '' AS `Topic`,
                                '' AS `SubTopic`,
                                '' AS `Source`,
                                '' AS `SourceLink`,
                                '' AS `Author`,
                                `careers`.`Hits`,
                                `users`.`Data` AS `UsersData`,
                                `users`.`Sort` AS `UserSort`
                            FROM
                                `careers`
                                INNER JOIN `users` ON `careers`.`UserID` = `users`.`ID` AND (`careers`.`UserID` < 51 OR `careers`.`UserID` = 7154)
                            WHERE 1  AND `careers`.`PostDate` BETWEEN '2023-01-01' AND '2023-11-30 23:59:59'  AND `careers`.`CareerType` IN ('3')
                        )
                     ) AS `publications` ORDER BY  `PostDate` DESC) AS CountTable
# [05-Jul-2024 16:06:05] /ngobg/root/css/boxes.css-?1720184765 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
# [05-Jul-2024 16:06:05] /ngobg/root/css/nav.css-?1720184765 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
