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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

SELECT `ID`, `From`, `UpTo` FROM `org_financial` WHERE `Visible` = 1 ORDER BY `ID` ASC
# [01-Aug-2024 11:25:30] /ngobg/root/bg/users/register/ngo.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

set names utf8

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

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

SELECT * FROM `users` LIMIT 1

SHOW COLUMNS FROM `users`

INSERT INTO `users` SET `RegDate` = '2024-08-01 11:25:55', `UserKey` = 'w4jCu8OXw4LCjcOMw6zCtsKbw4nDgsK2a9af9bc42a96e901f1ab6bb39480aa942', `Data` = 'HChn6OB5pJmx2W73jVUNWLSzf965y6YKNVqRSQHtgFNBMObMKAcXslslyUW4iYngupinR3OeonAL9mELW9NAb_glVN98jmTXDpxbemx326h6kK1YqhEFWrsaJrsMjxHD1GqXxsRwte_WjVKzTSAMpxjBwUslijiPe-1cTOEpbUc', `SearchKey` = 'wrXDg8KdwwrfCicK2wrrCscKdwrDi8ORwwq7CncKdwwrjCncK6w4jCscwq3CrsKywwq3CrsKyw', `EMailKey` = 'b8d5e5a543f9505c297df9638d04f43a661f810961ecc323828e1fead72b3819', `Sort` = '1060111'
# [01-Aug-2024 11:27:08] /ngobg/root/bg/users/register/ngo.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:27:09] /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` = 10487 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:27:09] /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` = 10487 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:27:09] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722500829536 167.99.142.201

set names utf8

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

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

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

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

set names utf8

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

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

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

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

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

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

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            ORDER BY `PostDate` DESC

            LIMIT 20

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

            UNION

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

            ORDER BY `ValidTo` DESC
            LIMIT 14;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

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

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

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

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

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            ORDER BY `PostDate` DESC

            LIMIT 20

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

            UNION

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

            ORDER BY `ValidTo` DESC
            LIMIT 14;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:28:26] /ngobg/root/bg/ajax/banners.html?pos=21,22&width=929&_=1722500906391 167.99.142.201

set names utf8

(
                        SELECT
                            `ID`,
                            `UploadID`,
                            `Images`,
                            `SourceCode`,
                            `Title`,
                            `Target`,
                            21 AS `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`,
                            22 AS `Position`
                        FROM
                            `banners`
                        WHERE
                            (`Images` <> '' OR `SourceCode` <> '') AND
                            (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                            `Position` >= 22 AND
                            1 << (1 - 1) & `Pages` AND
                            `Visible` = 1
                        ORDER BY RAND()
                        LIMIT 1
                    )

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:28:27] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722500907428 167.99.142.201

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            ORDER BY `PostDate` DESC

            LIMIT 20

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

            UNION

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

            ORDER BY `ValidTo` DESC
            LIMIT 14;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

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

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

set names utf8

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

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

SELECT * FROM `users` LIMIT 1

SHOW COLUMNS FROM `users`

INSERT INTO `users` SET `RegDate` = '2024-08-01 11:31:37', `UserKey` = 'w4jCu8OXw4LCjcOMw6zCtsKbw4nDgsK2a9af9bc42a96e901f1ab6bb39480aa942', `Data` = 'fcrguXL8O49Fn0i-mWia8Y5CiBGdfi4-Ew8Uw2EmJ1vcnZRdugZ1rrmh-QMp70q4UlmRSFuVUpHa-Sz0ClfIJ20MKxoZq-iefKnHjjsIPMpnWo1f-ktP_WGjXfWivMHA04ZuHWOpjB8O9wFgqDuGL1L8qe0SoJJ_Mu4RovBQg0c', `SearchKey` = 'wrXDg8ODwpLCvMKdwwrfCiMKdf8Kyw5jCwrfCiMOQw4HCscOYwwrjCncK6w4jCscwq3CrsKywwq3CrsKyw', `EMailKey` = 'b8d5e5a543f9505c297df9638d04f43a661f810961ecc323828e1fead72b3819', `Sort` = '1060111'
# [01-Aug-2024 11:36:02] /ngobg/root/bg/users/register/ngo.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:36:02] /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` = 10488 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:36:02] /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` = 10488 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:36:03] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501363234 167.99.142.201

set names utf8

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

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

set names utf8

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

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

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

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:36:08] /ngobg/root/css/nav.css-?v5 167.99.142.201
# [01-Aug-2024 11:36:08] /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` = 10488 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                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` = 10488 AND
                                    CRC32(`users`.`EMailKey`) = 3940012287 AND
                                    RIGHT(`users`.`UserKey`, 1) = '2'
                                LIMIT 1
# [01-Aug-2024 11:36:08] /ngobg/root/bg/ajax/users/bar.html?_=1722501368014 167.99.142.201

set names utf8

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

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

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

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

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

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

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

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

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            ORDER BY `PostDate` DESC

            LIMIT 20

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

            UNION

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

            ORDER BY `ValidTo` DESC
            LIMIT 14;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:36:09] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722501369544 167.99.142.201
# [01-Aug-2024 11:36:09] /ngobg/root/bg/ajax/users/bar.html?_=1722501369541 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

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

set names utf8

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

set names utf8

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

SELECT `ID`, `UserKey`, `EMailKey` FROM `users` WHERE `UserKey` LIKE 'w4LCv8OPwr3CucOMw7LCksOaw4nDh8K5wrjDjMOnwr_DlMK1wqHDg8OT%' LIMIT 1
# [01-Aug-2024 11:36: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
# [01-Aug-2024 11:36:20] /ngobg/root/css/boxes.css-?1722501380 167.99.142.201

set names utf8

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

set names utf8

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

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

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

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

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

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            UNION

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

            ORDER BY `PostDate` DESC

            LIMIT 20

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

            UNION

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

            ORDER BY `ValidTo` DESC
            LIMIT 14;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

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

set names utf8

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

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

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

set names utf8

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

set names utf8

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

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

set names utf8

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

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

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

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

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

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

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

set names utf8

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

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

SELECT * FROM `users` LIMIT 1

SHOW COLUMNS FROM `users`

INSERT INTO `users` SET `RegDate` = '2024-08-01 11:38:20', `UserKey` = 'w4jCu8OXw4LCjcOMw6zCtsKbw4nDgsK2a9af9bc42a96e901f1ab6bb39480aa942', `Data` = 'DLdSKZnbULaBgsAhcm8MyzZ76YtNaY4nPzc6ueqqS0-BJXHBYjGIs7ZWAAVDjnXgWV1i5wbe-FrvacBve4f1ybQmPXJpEJFJQ257HSmTHc3CZLWrQMtTKqEM5T7KVhksPVFFktQwHOyrkfC3yfJUd8UiPA4arhkQWqjdi5KRgSM', `SearchKey` = 'wrXDg8ODwpLCvMKdwwrfCiMKdf8Kyw5jCwrfCiMOQw4HCscOYwwrjCncK6w4jCscwq3CrsKywwq3CrsKyw', `EMailKey` = 'b8d5e5a543f9505c297df9638d04f43a661f810961ecc323828e1fead72b3819', `Sort` = '1060111'
# [01-Aug-2024 11:39:09] /ngobg/root/bg/users/register/ngo.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

set names utf8

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

set names utf8

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

set names utf8

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

set names utf8

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

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

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

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

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

set names utf8

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

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