# [24-Oct-2024 14:47:16] /ngobg/root/ 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            ORDER BY `PostDate` DESC

            LIMIT 20

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

            UNION

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

            ORDER BY `ValidTo` DESC
            LIMIT 14;

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

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

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

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

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

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

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

SELECT
                COUNT(`ID`)
            FROM
                `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 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'
# [24-Oct-2024 14:47:18] /ngobg/root/bg/ajax/users/bar.html?_=1729770437116 167.99.142.201
# [24-Oct-2024 14:47:18] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1729770437117 167.99.142.201

set names utf8

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [24-Oct-2024 14:47:21] /ngobg/root/bg/users/login.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [24-Oct-2024 14:47:22] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1729770441319 167.99.142.201

set names utf8

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

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [24-Oct-2024 14:47:22] /ngobg/root/bg/ajax/users/form/login.html?_=1729770441318 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC
# [24-Oct-2024 14:47:24] /ngobg/root/bg/ajax/users/login.html?_=1729770443242 167.99.142.201

set names utf8

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

SELECT `ID`, `UserKey`, `EMailKey` FROM `users` WHERE `UserKey` LIKE 'w4LCv8OPwr3CucOMw7LCksOaw4nDh8K5wrjDjMOnwr_DlMK1wqHDg8OT%' LIMIT 1
# [24-Oct-2024 14:47:24] /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
# [24-Oct-2024 14:47:26] /ngobg/root/css/boxes.css-?1729770445 167.99.142.201

set 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
# [24-Oct-2024 14:47:26] /ngobg/root/css/nav.css-?1729770445 167.99.142.201

set 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
# [24-Oct-2024 14:47:34] /ngobg/root/admin/bg/organizations.html 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [24-Oct-2024 14:47:35] /ngobg/root/css/boxes.css-?1729770455 167.99.142.201

set 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
# [24-Oct-2024 14:47:35] /ngobg/root/css/nav.css-?1729770455 167.99.142.201

set 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
# [24-Oct-2024 14:47:49] /ngobg/root/admin/bg/organizations.html?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
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
             WHERE `OrgName` LIKE '%woTCosKswqDCtsOfwrzCicKdwrTCn8KjwrnCucKwpjCm8KrwrvCssOhw6TCmMwoTCr8KswqDCtMOfwrxwp3CtMKuwqPCucK5wrrCkMKbwqvCu8Kyw6HDpMKYwwoTCosOWwpDgMK5wrzCisKdwrTCk8Kkwq3CucK6w%'
            ORDER BY
                `organizations`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
             WHERE `OrgName` LIKE '%woTCosKswqDCtsOfwrzCicKdwrTCn8KjwrnCucKwpjCm8KrwrvCssOhw6TCmMwoTCr8KswqDCtMOfwrxwp3CtMKuwqPCucK5wrrCkMKbwqvCu8Kyw6HDpMKYwwoTCosOWwpDgMK5wrzCisKdwrTCk8Kkwq3CucK6w%'
            ORDER BY
                `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [24-Oct-2024 14:47:49] /ngobg/root/css/boxes.css-?1729770469 167.99.142.201

set 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
# [24-Oct-2024 14:47:49] /ngobg/root/css/nav.css-?1729770469 167.99.142.201

set 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
# [24-Oct-2024 14:49:07] /ngobg/root/admin/bg/users.html 167.99.142.201

set names utf8

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

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

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

set 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
# [24-Oct-2024 14:49:07] /ngobg/root/css/nav.css-?1729770547 167.99.142.201

set 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
# [24-Oct-2024 14:49:08] /ngobg/root/admin/bg/organizations.html 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [24-Oct-2024 14:49:08] /ngobg/root/css/boxes.css-?1729770548 167.99.142.201

set 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
# [24-Oct-2024 14:49:08] /ngobg/root/css/nav.css-?1729770548 167.99.142.201

set 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
# [24-Oct-2024 14:49:12] /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 `ID`, `PostDate`, `Title`, `URLLabel`, 'news' AS `Module` FROM `news` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'calendar' AS `Module` FROM `calendar` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'analysis' AS `Module` FROM `analysis` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'legal' AS `Module` FROM `legal` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            UNION
            (SELECT `ID`, `PostDate`, `Title`, `URLLabel`, 'position' AS `Module` FROM `position` WHERE `PostDate` > DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND `Visible` = 1 ORDER BY `Hits` DESC, `PostDate` DESC LIMIT 9)
            ORDER BY PostDate ASC, `PostDate` DESC
            LIMIT 3

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

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

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            ORDER BY `PostDate` DESC

            LIMIT 20

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

            UNION

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

            ORDER BY `ValidTo` DESC
            LIMIT 14;

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

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

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

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

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

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

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

SELECT
                COUNT(`ID`)
            FROM
                `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 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'
# [24-Oct-2024 14:49:12] /ngobg/root/css/boxes.css-?v5 167.99.142.201
# [24-Oct-2024 14:49:12] /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
# [24-Oct-2024 14:49:13] /ngobg/root/bg/ajax/users/bar.html?_=1729770552286 167.99.142.201

set 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
# [24-Oct-2024 14:49:13] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1729770552290 167.99.142.201

set 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
                        )

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [24-Oct-2024 14:49:55] /ngobg/root/bg/search.html?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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'messages'
             ORDER BY
                `labels`.`Label` ASC

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

(SELECT
                            `ID`,
                            `UserID`,
                            'analysis' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `analysis`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'calendar' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `calendar`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'legal' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `legal`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'news' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `news`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'position' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `position`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'reportage' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `reportage`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'campaigns' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            '' AS `URLLabel`,
                            '' AS `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `campaigns`
                        WHERE
                            MATCH(`Title`, `Content`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'financing' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Annotation` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Annotation` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Annotation` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `financing`
                        WHERE
                            MATCH(`Title`, `Annotation`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Annotation` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Annotation` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Annotation` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'documents' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            '' AS `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Annotation` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Annotation` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Annotation` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `documents`
                        WHERE
                            MATCH(`Title`, `Annotation`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Annotation` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Annotation` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Annotation` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'careers' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            '' AS `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `careers`
                        WHERE
                            MATCH(`Title`, `Content`, `Finances`, `AdditionInfo`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                ELSE 10
                            END
                        )

                        ORDER BY
                            `SortID` ASC,
                            `PostDate` DESC
                     LIMIT 0, 20

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

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

SELECT COUNT(*) AS NumRows FROM (
                        (SELECT
                            `ID`,
                            `UserID`,
                            'analysis' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `analysis`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'calendar' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `calendar`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'legal' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `legal`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'news' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `news`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'position' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `position`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'reportage' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `reportage`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Author` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 2
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Author` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 5
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Author` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 8
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'campaigns' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            '' AS `URLLabel`,
                            '' AS `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `campaigns`
                        WHERE
                            MATCH(`Title`, `Content`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Content` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Content` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Content` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'financing' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Annotation` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Annotation` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Annotation` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `financing`
                        WHERE
                            MATCH(`Title`, `Annotation`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Annotation` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Annotation` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Annotation` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'documents' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            '' AS `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Annotation` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Annotation` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Annotation` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `documents`
                        WHERE
                            MATCH(`Title`, `Annotation`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Annotation` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 3
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Annotation` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 6
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                WHEN `Annotation` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'careers' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            '' AS `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `careers`
                        WHERE
                            MATCH(`Title`, `Content`, `Finances`, `AdditionInfo`) AGAINST ('+българска +стопанска +камара +- +съюз +на +българския +бизнес +бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'българска стопанска камара - съюз на българския бизнес бск%' THEN 0
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 1
                                WHEN `Title` LIKE '%българска стопанска камара - съюз на българския бизнес бск%' THEN 4
                                WHEN `Title` LIKE '%българска%стопанска%камара%-%съюз%на%българския%бизнес%бск%' THEN 7
                                ELSE 10
                            END
                        )

                        ORDER BY
                            `SortID` ASC,
                            `PostDate` DESC
                    ) AS CountTable

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

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

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'
# [24-Oct-2024 14:49:56] /ngobg/root/css/boxes.css-?v5 167.99.142.201
# [24-Oct-2024 14:49:56] /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
# [24-Oct-2024 14:49:56] /ngobg/root/bg/ajax/users/bar.html?_=1729770595444 167.99.142.201

set 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
# [24-Oct-2024 14:49:56] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1729770595444 167.99.142.201

set 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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [24-Oct-2024 14:50:09] /ngobg/root/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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'careers'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                    `careers`.`ID`,
                    `careers`.`CareerType`,
                    `careers`.`Title`,
                    `careers`.`URLLabel`,
                    `careers`.`UserID`,
                    RIGHT(`UserKey`, 1) AS `Access`
                FROM
                    `careers`
                    INNER JOIN `users` ON `users`.`ID` = `careers`.`UserID`
                WHERE
                    `careers`.`ActiveDate` > CURDATE() AND
                    `careers`.`Visible` = 1
                ORDER BY `careers`.`PostDate` DESC

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

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

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

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

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

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
                `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'
# [24-Oct-2024 14:50:10] /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
# [24-Oct-2024 14:50:10] /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
# [24-Oct-2024 14:50:10] /ngobg/root/bg/ajax/users/bar.html?_=1729770609376 167.99.142.201

set 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
# [24-Oct-2024 14:50:10] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1729770609377 167.99.142.201

set 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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
# [24-Oct-2024 14:50:17] /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
# [24-Oct-2024 14:50:18] /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
# [24-Oct-2024 14:50:20] /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
# [24-Oct-2024 14:50:20] /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

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
# [24-Oct-2024 14:50:22] /ngobg/root/css/boxes.css-?1729770622 167.99.142.201

set 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
# [24-Oct-2024 14:50:23] /ngobg/root/css/nav.css-?1729770622 167.99.142.201

set 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
# [24-Oct-2024 14:50:27] /ngobg/root/bg/ajax/users/bar.html?_=1729770626454 167.99.142.201
# [24-Oct-2024 14:50:27] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1729770626454 167.99.142.201

set 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

(
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (6 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [24-Oct-2024 14:50:30] /ngobg/root/bg/search.html?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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'messages'
             ORDER BY
                `labels`.`Label` ASC

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

(SELECT
                            `ID`,
                            `UserID`,
                            'analysis' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `analysis`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'calendar' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `calendar`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'legal' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `legal`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'news' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `news`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'position' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `position`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'reportage' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `reportage`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'campaigns' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            '' AS `URLLabel`,
                            '' AS `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `campaigns`
                        WHERE
                            MATCH(`Title`, `Content`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'financing' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Annotation` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Annotation` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Annotation` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `financing`
                        WHERE
                            MATCH(`Title`, `Annotation`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Annotation` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Annotation` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Annotation` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'documents' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            '' AS `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Annotation` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Annotation` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Annotation` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `documents`
                        WHERE
                            MATCH(`Title`, `Annotation`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Annotation` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Annotation` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Annotation` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'careers' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            '' AS `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Title` LIKE '%бск%' THEN 7
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `careers`
                        WHERE
                            MATCH(`Title`, `Content`, `Finances`, `AdditionInfo`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Title` LIKE '%бск%' THEN 7
                                ELSE 10
                            END
                        )

                        ORDER BY
                            `SortID` ASC,
                            `PostDate` DESC
                     LIMIT 0, 20

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

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

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

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

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

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

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

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [24-Oct-2024 14:50:30] /ngobg/root/css/boxes.css-?v5 167.99.142.201
# [24-Oct-2024 14:50:30] /ngobg/root/css/nav.css-?v5 167.99.142.201

set names utf8

set names utf8

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

SELECT
                                    `users`.`ID`,
                                    `users`.`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
# [24-Oct-2024 14:50:30] /ngobg/root/bg/ajax/users/bar.html?_=1729770629832 167.99.142.201

set names utf8
# [24-Oct-2024 14:50:30] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1729770629832 167.99.142.201

set names utf8

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

SELECT
                                    `users`.`ID`,
                                    `users`.`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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [24-Oct-2024 14:50:34] /ngobg/root/bg/search.html?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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'messages'
             ORDER BY
                `labels`.`Label` ASC

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

(SELECT
                            `ID`,
                            `UserID`,
                            'analysis' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `analysis`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'calendar' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `calendar`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'legal' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `legal`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'news' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `news`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'position' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `position`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'reportage' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            `UploadID`,
                            `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `reportage`
                        WHERE
                            MATCH(`Title`, `Content`, `Author`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Author` LIKE 'бск%' THEN 2
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Author` LIKE '%бск%' THEN 5
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Author` LIKE '%бск%' THEN 8
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'campaigns' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            '' AS `URLLabel`,
                            '' AS `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `campaigns`
                        WHERE
                            MATCH(`Title`, `Content`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Content` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Content` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Content` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'financing' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Annotation` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Annotation` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Annotation` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `financing`
                        WHERE
                            MATCH(`Title`, `Annotation`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Annotation` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Annotation` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Annotation` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'documents' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            `Annotation`,
                            '' AS `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Annotation` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Annotation` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Annotation` LIKE '%бск%' THEN 9
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `documents`
                        WHERE
                            MATCH(`Title`, `Annotation`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Annotation` LIKE 'бск%' THEN 3
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Annotation` LIKE '%бск%' THEN 6
                                WHEN `Title` LIKE '%бск%' THEN 7
                                WHEN `Annotation` LIKE '%бск%' THEN 9
                                ELSE 10
                            END
                        )

                        UNION

                        (SELECT
                            `ID`,
                            `UserID`,
                            'careers' AS `PostType`,
                            `PostDate`,
                            `Title`,
                            '' AS `UploadID`,
                            '' AS `Gallery`,
                            `URLLabel`,
                            '' AS `Annotation`,
                            `Content`,
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Title` LIKE '%бск%' THEN 7
                                ELSE 10
                            END AS `SortID`
                        FROM
                            `careers`
                        WHERE
                            MATCH(`Title`, `Content`, `Finances`, `AdditionInfo`) AGAINST ('+бск' IN BOOLEAN MODE) AND
                            
                            `Visible` = 1
                        ORDER BY
                            CASE
                                WHEN `Title` LIKE 'бск%' THEN 0
                                WHEN `Title` LIKE '%бск%' THEN 1
                                WHEN `Title` LIKE '%бск%' THEN 4
                                WHEN `Title` LIKE '%бск%' THEN 7
                                ELSE 10
                            END
                        )

                        ORDER BY
                            `SortID` ASC,
                            `PostDate` DESC
                     LIMIT 0, 20

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

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

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

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

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

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

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

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [24-Oct-2024 14:50:34] /ngobg/root/css/nav.css-?v5 167.99.142.201
# [24-Oct-2024 14:50:34] /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

set 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
# [24-Oct-2024 14:50:35] /ngobg/root/bg/ajax/users/bar.html?_=1729770634113 167.99.142.201
# [24-Oct-2024 14:50:35] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1729770634114 167.99.142.201

set 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

(
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (16 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [24-Oct-2024 14:50:37] /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
# [24-Oct-2024 14:50:38] /ngobg/root/css/boxes.css-?1729770638 167.99.142.201

set 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
# [24-Oct-2024 14:50:39] /ngobg/root/css/nav.css-?1729770638 167.99.142.201

set 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
# [24-Oct-2024 14:50:44] /ngobg/root/admin/bg/organizations.html 167.99.142.201

set names utf8

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

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

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
            
            ORDER BY
                `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [24-Oct-2024 14:50:45] /ngobg/root/css/boxes.css-?1729770644 167.99.142.201

set 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
# [24-Oct-2024 14:50:45] /ngobg/root/css/nav.css-?1729770644 167.99.142.201

set 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
# [24-Oct-2024 14:50:50] /ngobg/root/admin/bg/organizations.html?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
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
             WHERE `OrgName` LIKE '%woTCosKswqDCtMOPwrzC%'
            ORDER BY
                `organizations`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`LastUpdate`,
                `organizations`.`LastUpdateProfile`,
                `organizations`.`UserID`,
                `organizations`.`Data`,
                `organizations`.`CRData`,
                `organizations`.`Visible`,
                `organizations`.`Sort` AS `OrgSort`,
                `users`.`Data` AS `UserData`,
                `users`.`Sort` AS `UserSort`
            FROM
                `organizations`
                LEFT JOIN `users` ON `organizations`.`UserID` = `users`.`ID`
             WHERE `OrgName` LIKE '%woTCosKswqDCtMOPwrzC%'
            ORDER BY
                `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [24-Oct-2024 14:50:51] /ngobg/root/css/boxes.css-?1729770650 167.99.142.201

set 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
# [24-Oct-2024 14:50:51] /ngobg/root/css/nav.css-?1729770650 167.99.142.201

set 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
# [24-Oct-2024 14:51:03] /ngobg/root/bg/organizations.html?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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'organizations'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

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

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

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

SELECT `ID`, `From`, `UpTo` FROM `org_financial` WHERE `Visible` = 1 ORDER BY `ID` ASC

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'organizations.html?keyword=бск' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                `organizations`.`ID`,
                `organizations`.`Data`,
                `org_types`.`Title` AS `OrgType`,
                `organizations`.`Statute`,
                GROUP_CONCAT(`activities`.`Title` SEPARATOR '; ') AS `ScopeOfActivities`,
                IF(`organizations`.`LastUpdate` > DATE_ADD(CURDATE(), INTERVAL -1 YEAR), 'active', 'unactive') AS `Active`,
                `organizations`.`Volunteers`,
                `organizations`.`CRData`
            FROM
                `organizations`
                INNER JOIN `org_data` ON `organizations`.`ID` = `org_data`.`OrgID`
                LEFT JOIN `org_types` ON `org_types`.`ID` = `organizations`.`OrgType` AND `org_types`.`Language` = 'bg'
                LEFT JOIN `activities` ON 1 << (`activities`.`ID` - 1) & `organizations`.`ScopeOfActivity` AND `activities`.`Language` = 'bg'
            WHERE
                `organizations`.`Visible` = 1
            GROUP BY
                `organizations`.`ID`
            ORDER BY `organizations`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`Data`,
                `org_types`.`Title` AS `OrgType`,
                `organizations`.`Statute`,
                GROUP_CONCAT(`activities`.`Title` SEPARATOR '; ') AS `ScopeOfActivities`,
                IF(`organizations`.`LastUpdate` > DATE_ADD(CURDATE(), INTERVAL -1 YEAR), 'active', 'unactive') AS `Active`,
                `organizations`.`Volunteers`,
                `organizations`.`CRData`
            FROM
                `organizations`
                INNER JOIN `org_data` ON `organizations`.`ID` = `org_data`.`OrgID`
                LEFT JOIN `org_types` ON `org_types`.`ID` = `organizations`.`OrgType` AND `org_types`.`Language` = 'bg'
                LEFT JOIN `activities` ON 1 << (`activities`.`ID` - 1) & `organizations`.`ScopeOfActivity` AND `activities`.`Language` = 'bg'
            WHERE
                `organizations`.`Visible` = 1
            GROUP BY
                `organizations`.`ID`
            ORDER BY `organizations`.`LastUpdate` DESC
        ) AS CountTable

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

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

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'
# [24-Oct-2024 14:51:10] /ngobg/root/css/nav.css-?v5 167.99.142.201
# [24-Oct-2024 14:51:10] /ngobg/root/css/boxes.css-?v5 167.99.142.201

set names utf8

set names utf8

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

SELECT
                                    `users`.`ID`,
                                    `users`.`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
# [24-Oct-2024 14:51:10] /ngobg/root/bg/ajax/users/bar.html?_=1729770669617 167.99.142.201
# [24-Oct-2024 14:51:10] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1729770669618 167.99.142.201

set 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

(
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'users'
             ORDER BY
                `labels`.`Label` ASC
# [24-Oct-2024 14:56:37] /ngobg/root/bg/organizations.html?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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'organizations'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

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

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

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

SELECT `ID`, `From`, `UpTo` FROM `org_financial` WHERE `Visible` = 1 ORDER BY `ID` ASC

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'organizations.html?keyword=бск' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                `organizations`.`ID`,
                `organizations`.`Data`,
                `org_types`.`Title` AS `OrgType`,
                `organizations`.`Statute`,
                GROUP_CONCAT(`activities`.`Title` SEPARATOR '; ') AS `ScopeOfActivities`,
                IF(`organizations`.`LastUpdate` > DATE_ADD(CURDATE(), INTERVAL -1 YEAR), 'active', 'unactive') AS `Active`,
                `organizations`.`Volunteers`,
                `organizations`.`CRData`
            FROM
                `organizations`
                INNER JOIN `org_data` ON `organizations`.`ID` = `org_data`.`OrgID`
                LEFT JOIN `org_types` ON `org_types`.`ID` = `organizations`.`OrgType` AND `org_types`.`Language` = 'bg'
                LEFT JOIN `activities` ON 1 << (`activities`.`ID` - 1) & `organizations`.`ScopeOfActivity` AND `activities`.`Language` = 'bg'
            WHERE
                `organizations`.`Visible` = 1
            GROUP BY
                `organizations`.`ID`
            ORDER BY `organizations`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`Data`,
                `org_types`.`Title` AS `OrgType`,
                `organizations`.`Statute`,
                GROUP_CONCAT(`activities`.`Title` SEPARATOR '; ') AS `ScopeOfActivities`,
                IF(`organizations`.`LastUpdate` > DATE_ADD(CURDATE(), INTERVAL -1 YEAR), 'active', 'unactive') AS `Active`,
                `organizations`.`Volunteers`,
                `organizations`.`CRData`
            FROM
                `organizations`
                INNER JOIN `org_data` ON `organizations`.`ID` = `org_data`.`OrgID`
                LEFT JOIN `org_types` ON `org_types`.`ID` = `organizations`.`OrgType` AND `org_types`.`Language` = 'bg'
                LEFT JOIN `activities` ON 1 << (`activities`.`ID` - 1) & `organizations`.`ScopeOfActivity` AND `activities`.`Language` = 'bg'
            WHERE
                `organizations`.`Visible` = 1
            GROUP BY
                `organizations`.`ID`
            ORDER BY `organizations`.`LastUpdate` DESC
        ) AS CountTable
# [24-Oct-2024 14:56:39] /ngobg/root/bg/organizations.html?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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'organizations'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

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

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

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

SELECT `ID`, `From`, `UpTo` FROM `org_financial` WHERE `Visible` = 1 ORDER BY `ID` ASC

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'organizations.html?keyword=бск' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                `organizations`.`ID`,
                `organizations`.`Data`,
                `org_types`.`Title` AS `OrgType`,
                `organizations`.`Statute`,
                GROUP_CONCAT(`activities`.`Title` SEPARATOR '; ') AS `ScopeOfActivities`,
                IF(`organizations`.`LastUpdate` > DATE_ADD(CURDATE(), INTERVAL -1 YEAR), 'active', 'unactive') AS `Active`,
                `organizations`.`Volunteers`,
                `organizations`.`CRData`
            FROM
                `organizations`
                INNER JOIN `org_data` ON `organizations`.`ID` = `org_data`.`OrgID`
                LEFT JOIN `org_types` ON `org_types`.`ID` = `organizations`.`OrgType` AND `org_types`.`Language` = 'bg'
                LEFT JOIN `activities` ON 1 << (`activities`.`ID` - 1) & `organizations`.`ScopeOfActivity` AND `activities`.`Language` = 'bg'
            WHERE
                `organizations`.`Visible` = 1
            GROUP BY
                `organizations`.`ID`
            ORDER BY `organizations`.`LastUpdate` DESC
         LIMIT 0, 20

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `organizations`.`ID`,
                `organizations`.`Data`,
                `org_types`.`Title` AS `OrgType`,
                `organizations`.`Statute`,
                GROUP_CONCAT(`activities`.`Title` SEPARATOR '; ') AS `ScopeOfActivities`,
                IF(`organizations`.`LastUpdate` > DATE_ADD(CURDATE(), INTERVAL -1 YEAR), 'active', 'unactive') AS `Active`,
                `organizations`.`Volunteers`,
                `organizations`.`CRData`
            FROM
                `organizations`
                INNER JOIN `org_data` ON `organizations`.`ID` = `org_data`.`OrgID`
                LEFT JOIN `org_types` ON `org_types`.`ID` = `organizations`.`OrgType` AND `org_types`.`Language` = 'bg'
                LEFT JOIN `activities` ON 1 << (`activities`.`ID` - 1) & `organizations`.`ScopeOfActivity` AND `activities`.`Language` = 'bg'
            WHERE
                `organizations`.`Visible` = 1
            GROUP BY
                `organizations`.`ID`
            ORDER BY `organizations`.`LastUpdate` DESC
        ) AS CountTable

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

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

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'

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

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

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'
# [24-Oct-2024 14:56:50] /ngobg/root/css/nav.css-?v5 167.99.142.201
# [24-Oct-2024 14:56:50] /ngobg/root/css/boxes.css-?v5 167.99.142.201

set names utf8

set names utf8

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

SELECT
                                    `users`.`ID`,
                                    `users`.`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
# [24-Oct-2024 14:56:50] /ngobg/root/bg/ajax/users/bar.html?_=1729771009239 167.99.142.201
# [24-Oct-2024 14:56:50] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1920&_=1729771009239 167.99.142.201

set 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

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

(
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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 << (2 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
# [24-Oct-2024 14:56:59] /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
# [24-Oct-2024 14:56:59] /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
