                            SELECT
                                `ID`,
                                `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:02:17] /ngobg/root/bg/ajax/organizations/form.html?_=1722499337244 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:03:55] /ngobg/root/bg/users/register/ngo.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:03:56] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722499436222 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:03:56] /ngobg/root/bg/ajax/users/bar.html?_=1722499436223 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:03:56] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499436224 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:04:04] /ngobg/root/bg/ajax/organizations/form.html?_=1722499444080 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:04:23] /ngobg/root/bg/ajax/organizations/register.html?_=1722499463702 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:06:16] /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:06:17] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722499577069 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:06:17] /ngobg/root/bg/ajax/users/bar.html?_=1722499577071 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:06:17] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499577072 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:06:18] /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:06:19] /ngobg/root/bg/ajax/users/form/login.html?_=1722499578931 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:06:19] /ngobg/root/bg/ajax/users/bar.html?_=1722499578934 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:06:19] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499578935 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:06:21] /ngobg/root/bg/ajax/users/login.html?_=1722499581350 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:06:21] /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:06:23] /ngobg/root/css/boxes.css-?1722499583 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:06:23] /ngobg/root/css/nav.css-?1722499583 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:06:25] /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:06:26] /ngobg/root/css/boxes.css-?1722499586 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:06:26] /ngobg/root/css/nav.css-?1722499586 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:06:27] /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:06:28] /ngobg/root/css/boxes.css-?1722499587 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:06:28] /ngobg/root/css/nav.css-?1722499587 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:06: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:06:29] /ngobg/root/css/boxes.css-?1722499589 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:06:29] /ngobg/root/css/nav.css-?1722499589 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:06:32] /ngobg/root/bg/ajax/users/logout.html?_=1722499591907 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:06:32] /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:06:32] /ngobg/root/bg/ajax/users/bar.html?_=1722499592337 167.99.142.201
# [01-Aug-2024 11:06:32] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499592338 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:06:34] /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:06:34] /ngobg/root/bg/ajax/users/form/login.html?_=1722499594062 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:06:34] /ngobg/root/bg/ajax/users/bar.html?_=1722499594065 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:06:34] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499594066 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:06: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:06:44] /ngobg/root/bg/ajax/users/bar.html?_=1722499604111 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:06:44] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499604112 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:06: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:06:45] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722499605004 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:06:45] /ngobg/root/bg/ajax/users/bar.html?_=1722499605006 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:06:45] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499605007 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:06:55] /ngobg/root/bg/ajax/organizations/form.html?_=1722499615495 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:07:14] /ngobg/root/bg/ajax/organizations/register.html?_=1722499634126 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:08:25] /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:08:25] /ngobg/root/bg/ajax/users/form/login.html?_=1722499705321 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:08:25] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499705323 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:08:25] /ngobg/root/bg/ajax/users/bar.html?_=1722499705322 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:08:35] /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:08:36] /ngobg/root/bg/ajax/users/bar.html?_=1722499715914 167.99.142.201
# [01-Aug-2024 11:08:36] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499715915 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
                        )

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:08:36] /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:08:37] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722499717005 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
# [01-Aug-2024 11:08:37] /ngobg/root/bg/ajax/users/bar.html?_=1722499717007 167.99.142.201

set names utf8

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

SELECT
                `Content`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'users/register/ngo'
            LIMIT 1
# [01-Aug-2024 11:08:37] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499717007 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:08:50] /ngobg/root/bg/ajax/organizations/form.html?_=1722499730309 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:10:00] /ngobg/root/bg/users/login.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

SELECT `Label`, `Value` FROM `labels` WHERE `Language` = 'bg' AND `Module` = 'footer'
# [01-Aug-2024 11:10:00] /ngobg/root/bg/ajax/users/form/login.html?_=1722499800522 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:10:00] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499800525 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:10:00] /ngobg/root/bg/ajax/users/bar.html?_=1722499800524 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:10:02] /ngobg/root/bg/ajax/users/login.html?_=1722499802660 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:10:03] /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:10:05] /ngobg/root/css/boxes.css-?1722499804 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:05] /ngobg/root/css/nav.css-?1722499804 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:06] /ngobg/root/admin/bg/messages.html 167.99.142.201

set names utf8

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

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

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

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:08] /ngobg/root/css/nav.css-?1722499808 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:09] /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:10:10] /ngobg/root/css/boxes.css-?1722499810 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:10] /ngobg/root/css/nav.css-?1722499810 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:12] /ngobg/root/admin/bg/users.html 167.99.142.201

set names utf8

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

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

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

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:12] /ngobg/root/css/nav.css-?1722499812 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:15] /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:10:15] /ngobg/root/css/boxes.css-?1722499815 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:15] /ngobg/root/css/nav.css-?1722499815 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:16] /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:10:16] /ngobg/root/css/boxes.css-?1722499816 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:16] /ngobg/root/css/nav.css-?1722499816 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:17] /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:10:18] /ngobg/root/css/boxes.css-?1722499818 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:18] /ngobg/root/css/nav.css-?1722499818 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:18] /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:10:18] /ngobg/root/css/boxes.css-?1722499818 167.99.142.201
# [01-Aug-2024 11:10:19] /ngobg/root/css/nav.css-?1722499818 167.99.142.201

set names utf8

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

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT JOIN `organizations` ON `organizations`.`UserID` = `users`.`ID`
                                WHERE
                                    `users`.`ID` = 10408 AND
                                    CRC32(`users`.`EMailKey`) = 2871078449 AND
                                    RIGHT(`users`.`UserKey`, 1) = '8'
                                LIMIT 1
# [01-Aug-2024 11:10:25] /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:10:25] /ngobg/root/css/boxes.css-?1722499825 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:25] /ngobg/root/css/nav.css-?1722499825 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:26] /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:10:26] /ngobg/root/css/boxes.css-?1722499826 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:26] /ngobg/root/css/nav.css-?1722499826 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:36] /ngobg/root/bg/ajax/users/logout.html?_=1722499835969 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:10:36] /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:10:36] /ngobg/root/bg/ajax/users/bar.html?_=1722499836402 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:10:36] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499836404 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:10: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:10:40] /ngobg/root/bg/ajax/users/bar.html?_=1722499840378 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:10:40] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499840379 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:10: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:10:41] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722499841306 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:10:41] /ngobg/root/bg/ajax/users/bar.html?_=1722499841310 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:10:41] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722499841312 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:10:51] /ngobg/root/bg/ajax/organizations/form.html?_=1722499851373 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:13:31] /ngobg/root/bg/users/register/ngo.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

set names utf8

set names utf8

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

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` = '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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:13:34] /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:13:34] /ngobg/root/bg/ajax/users/bar.html?_=1722500014066 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:13:34] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722500014067 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:13:36] /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:13:36] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722500016361 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:13:36] /ngobg/root/bg/ajax/users/bar.html?_=1722500016364 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:13:36] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722500016365 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:13:43] /ngobg/root/bg/ajax/organizations/form.html?_=1722500023054 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:16:54] /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:16:55] /ngobg/root/bg/ajax/users/form/login.html?_=1722500214868 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:16:55] /ngobg/root/bg/ajax/users/bar.html?_=1722500214872 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:16:55] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722500214873 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:16:56] /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:16:56] /ngobg/root/bg/ajax/users/bar.html?_=1722500216624 167.99.142.201
# [01-Aug-2024 11:16:56] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722500216626 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 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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:16:57] /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:16:57] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722500217647 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:16:57] /ngobg/root/bg/ajax/users/bar.html?_=1722500217648 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:16:57] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722500217649 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:17:04] /ngobg/root/bg/ajax/organizations/form.html?_=1722500224252 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:20:15] /ngobg/root/bg/users/register/ngo.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

set names utf8
# [01-Aug-2024 11:20:16] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722500415822 167.99.142.201

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'error'
             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 << (9 - 1) & `Pages` AND
                                `Visible` = 1
                            ORDER BY RAND()
                            LIMIT 1
                        )
                     UNION 
                        (
                            SELECT
                                `ID`,
                                `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
                        )

set names utf8

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

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN ('766','755')
# [01-Aug-2024 11:20:26] /ngobg/root/bg/ajax/organizations/form.html?_=1722500426214 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:22:22] /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:23] /ngobg/root/bg/ajax/users/form/ngo.html?_=1722500542871 167.99.142.201
# [01-Aug-2024 11:22:23] /ngobg/root/bg/ajax/users/bar.html?_=1722500542873 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
                `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:23] /ngobg/root/bg/ajax/banners.html?pos=11,12,13,14,31,32,33,34,21,22&width=1433&_=1722500542873 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:23] /ngobg/root/bg/users/login.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

set names utf8

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

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

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

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:22:28] /ngobg/root/css/nav.css-?1722500548 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:22:31] /ngobg/root/admin/bg/organizations.html 167.99.142.201

set names utf8

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

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

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

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:22:31] /ngobg/root/css/nav.css-?1722500551 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:22:32] /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:22:33] /ngobg/root/css/boxes.css-?1722500553 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:22:33] /ngobg/root/css/nav.css-?1722500553 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:22:34] /ngobg/root/admin/bg/organizations.html 167.99.142.201

set names utf8

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

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

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

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:22:34] /ngobg/root/css/nav.css-?1722500554 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:22:36] /ngobg/root/bg/ajax/users/logout.html?_=1722500556457 167.99.142.201

set names utf8

SELECT
                                    `users`.`ID`,
                                    `users`.`Data`,
                                    `organizations`.`ID` AS `OrgID`
                                FROM
                                    `users`
                                    LEFT 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:22:36] /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

