# [21-Nov-2024 07:00:58] /spisanie8/root/ 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `slider`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
            LIMIT 6

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'index'
                LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '2221' AND
                            `Access` = '2' AND
                            `SecureKey` = '75d741bc75d6b96f10be7cde3774d68c'
                        LIMIT 1

SELECT `EMail` FROM users WHERE ID = 2221 LIMIT 1

SELECT
                            `orders`.`ID`
                        FROM
                            `orders`
                            INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                            INNER JOIN `subscriptions` ON `order_products`.`ProductID` = `subscriptions`.`ProductID`
                        WHERE
                            CURDATE() BETWEEN  `order_products`.`StartDate` AND `order_products`.`EndDate` AND
                            `order_products`.`Months` > 1 AND
                            `subscriptions`.`Months` > 1 AND
                            `subscriptions`.`Digital` = 1 AND
                            (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                            `orders`.`Status` & 256 = 0 AND
                            `orders`.`EMail` = 'naiden@pro-rock.net'

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                WHERE
                    `articles`.`Gallery` != '' AND
                    (CASE WHEN `articles`.`GroupID` = 41 THEN `articles`.`PostDate` >= '2024-11-21' ELSE `articles`.`PostDate` BETWEEN '2024-10-24' AND '2024-11-21 23:59:59' END) AND 
                `articles`.`PostDate` <= NOW()
             AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 0, 100

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 13:56:40] /spisanie8/root/ 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `slider`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
            LIMIT 6

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'index'
                LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                WHERE
                    `articles`.`Gallery` != '' AND
                    (CASE WHEN `articles`.`GroupID` = 41 THEN `articles`.`PostDate` >= '2024-11-21' ELSE `articles`.`PostDate` BETWEEN '2024-10-24' AND '2024-11-21 23:59:59' END) AND 
                `articles`.`PostDate` <= NOW()
             AND `articles`.`OnlineSub` = 0 AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 0, 100

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         AND `OnlineSub` = 0 ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 13:56:41] /spisanie8/root/ajax/basket/check.html?_=1732190201739 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '065256d59ca5e3b05b25080f58f21536'
# [21-Nov-2024 13:56:46] /spisanie8/root/ajax/banners/popup.html?_=1732190206750 108.61.209.243

set names utf8

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 7 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 12 LIMIT 1
# [21-Nov-2024 13:58:28] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         AND `OnlineSub` = 0 ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 13:58:35] /spisanie8/root/ajax/users/login.html?_=1732190314955 108.61.209.243

set names utf8

SELECT
                `ID`,
                `FullName`,
                `Password`,
                `Access`,
                `SecureKey`
            FROM
                `users`
            WHERE
                `EMail` = 'maxgraphic' OR `UserName` = 'maxgraphic'
            LIMIT 1

UPDATE `users` SET `SecureKey` = '065256d59ca5e3b05b25080f58f21536' WHERE `ID` = 1
# [21-Nov-2024 13:58:35] /spisanie8/root/admin/articles/list.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
         LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
        ) AS CountTable

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 13:58:41] /spisanie8/root/admin/articles/list.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
         LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
        ) AS CountTable

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 13:58:43] /spisanie8/root/admin/ajax/articles/form.html?_=1732190323927 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

INSERT INTO `articles` SET ID = NULL;

SELECT MAX(ID) FROM `articles`;

DELETE FROM `articles` WHERE ID = 16697;

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `groups`
            WHERE
                `Module` = 'articles'
            ORDER BY
                `PostDate` DESC

SELECT
                `products`.`ID`,
                `products`.`Title`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
            WHERE
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
# [21-Nov-2024 14:47:55] /spisanie8/root/ 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `slider`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
            LIMIT 6

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'index'
                LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                WHERE
                    `articles`.`Gallery` != '' AND
                    (CASE WHEN `articles`.`GroupID` = 41 THEN `articles`.`PostDate` >= '2024-11-21' ELSE `articles`.`PostDate` BETWEEN '2024-10-24' AND '2024-11-21 23:59:59' END) AND 
                `articles`.`PostDate` <= NOW()
             AND `articles`.`OnlineSub` = 0 AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 0, 100

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         AND `OnlineSub` = 0 ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 15:35:24] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         AND `OnlineSub` = 0 ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 15:35:27] /spisanie8/root/ajax/users/login.html?_=1732196127645 108.61.209.243

set names utf8

SELECT
                `ID`,
                `FullName`,
                `Password`,
                `Access`,
                `SecureKey`
            FROM
                `users`
            WHERE
                `EMail` = 'maxgraphic' OR `UserName` = 'maxgraphic'
            LIMIT 1

UPDATE `users` SET `SecureKey` = '065256d59ca5e3b05b25080f58f21536' WHERE `ID` = 1
# [21-Nov-2024 15:35:27] /spisanie8/root/admin/articles/list.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
         LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
        ) AS CountTable

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 15:35:30] /spisanie8/root/admin/articles/list.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
         LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
        ) AS CountTable

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 15:35:36] /spisanie8/root/admin/ajax/articles/form/16696.html?_=1732196135972 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
                `articles`.*,
                `magazine_articles`.`MagazineID`
            FROM
                `articles`
                LEFT JOIN `magazine_articles` ON `magazine_articles`.`ArticleID` = `articles`.`ID`
            WHERE
                `ID` = 16696
            LIMIT 1

SELECT
                `articles`.*,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `articles`
                INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
            WHERE
                `articles`.`ID` IN (16673) AND
                `articles`.`PostDate` <= NOW() AND
                `articles`.`Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `groups`
            WHERE
                `Module` = 'articles'
            ORDER BY
                `PostDate` DESC

SELECT
                `products`.`ID`,
                `products`.`Title`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
            WHERE
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
# [21-Nov-2024 15:37:04] /spisanie8/root/admin/articles/list.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
         LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
        ) AS CountTable

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 15:37:06] /spisanie8/root/admin/ajax/articles/form.html?_=1732196226317 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

INSERT INTO `articles` SET ID = NULL;

SELECT MAX(ID) FROM `articles`;

DELETE FROM `articles` WHERE ID = 16698;

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `groups`
            WHERE
                `Module` = 'articles'
            ORDER BY
                `PostDate` DESC

SELECT
                `products`.`ID`,
                `products`.`Title`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
            WHERE
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
# [21-Nov-2024 15:40:29] /spisanie8/root/admin/ajax/articles/form/16696.html?_=1732196429025 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
                `articles`.*,
                `magazine_articles`.`MagazineID`
            FROM
                `articles`
                LEFT JOIN `magazine_articles` ON `magazine_articles`.`ArticleID` = `articles`.`ID`
            WHERE
                `ID` = 16696
            LIMIT 1

SELECT
                `articles`.*,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `articles`
                INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
            WHERE
                `articles`.`ID` IN (16673) AND
                `articles`.`PostDate` <= NOW() AND
                `articles`.`Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `ID`,
                `MenuLabel`
            FROM
                `groups`
            WHERE
                `Module` = 'articles'
            ORDER BY
                `PostDate` DESC

SELECT
                `products`.`ID`,
                `products`.`Title`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
            WHERE
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
# [21-Nov-2024 15:43:29] /spisanie8/root/ajax/basket/popup.html?_=1732196609196 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = '065256d59ca5e3b05b25080f58f21536' LIMIT 1

SELECT
                    `products`.`ID`,
                    `products`.`URLLabel`,
                    `products`.`Title`,
                    `products`.`Price`,
                    `products`.`PromoPrice`,
                    `products`.`OnlinePrice`,
                    `products`.`PromoOnlinePrice`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`Weight`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
                    `products`.`ID` = 905
                LIMIT 1

SELECT
                    `products`.`ID`,
                    `products`.`URLLabel`,
                    `products`.`Title`,
                    `products`.`Price`,
                    `products`.`PromoPrice`,
                    `products`.`OnlinePrice`,
                    `products`.`PromoOnlinePrice`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`Weight`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
                    `products`.`ID` = 904
                LIMIT 1

SELECT
                    `products`.`ID`,
                    `products`.`URLLabel`,
                    `products`.`Title`,
                    `products`.`Price`,
                    `products`.`PromoPrice`,
                    `products`.`OnlinePrice`,
                    `products`.`PromoOnlinePrice`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`Weight`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
                    `products`.`ID` = 902
                LIMIT 1

SELECT ID FROM `orders` WHERE `BasketID` = '065256d59ca5e3b05b25080f58f21536' AND `Status` = 0 LIMIT 1
# [21-Nov-2024 15:43:29] /spisanie8/root/uf/products/905/thumb_book-cover.jpeg 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 15:43:55] /spisanie8/root/search.html?q=test&x=27&y=19 108.61.209.243

set names utf8

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `products`.`Image`,
                `products`.`VideoURL`,
                `products`.`URLLabel`,
                `products`.`Visible`,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `products`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`Title` LIKE '%test%' OR
                `products`.`Annotation` LIKE '%test%' OR
                `products`.`Content` LIKE '%test%'
            ORDER BY
                CASE
                    WHEN `products`.`Title` LIKE 'test%' THEN 0
                    WHEN `products`.`Annotation` LIKE 'test%' THEN 1
                    ELSE 2
                END
         LIMIT 0, 100

SELECT
                `articles`.`ID`,
                `articles`.`IntDate`,
                `articles`.`PostDate`,
                `articles`.`Title`,
                `articles`.`Annotation`,
                `articles`.`Section`,
                `articles`.`Gallery`,
                `articles`.`VideoURL`,
                `articles`.`URLLabel`,
                `articles`.`Visible`,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `articles`
                INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
            WHERE
                `articles`.`Title` LIKE '%test%' OR
                `articles`.`Annotation` LIKE '%test%' OR
                `articles`.`Content` LIKE '%test%'
            ORDER BY
                CASE
                    WHEN `articles`.`Title` LIKE 'test%' THEN 0
                    WHEN `articles`.`Annotation` LIKE 'test%' THEN 1
                    ELSE 2
                END
         LIMIT 0, 100

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 15:44:21] /spisanie8/root/мистерии-загадки-извънземни/2024/0913/кви-са-шансовете-6-еднакви-числа-в-тото-лотарията-да-се-паднат-п.html 108.61.209.243

set names utf8

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'мистерии-загадки-извънземни'
                LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                    `articles`.*,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                WHERE
                    `articles`.`IntDate` = 20240913 AND
                    `articles`.`URLLabel` = 'кви-са-шансовете-6-еднакви-числа-в-тото-лотарията-да-се-паднат-п' AND
                    `articles`.`PostDate` <= NOW() AND
                    `articles`.`Visible` = 1
                LIMIT 1

SELECT
                `products`.`ID`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Gallery`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 1

SELECT
                `articles`.*,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `articles`
                INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
            WHERE
                `articles`.`ID` IN (15730,15071,12347) AND
                `articles`.`PostDate` <= NOW() AND
                `articles`.`Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 15:44:25] /spisanie8/root/ 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `slider`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
            LIMIT 6

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'index'
                LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT `EMail` FROM users WHERE ID = 1 LIMIT 1

SELECT
                            `orders`.`ID`
                        FROM
                            `orders`
                            INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                            INNER JOIN `subscriptions` ON `order_products`.`ProductID` = `subscriptions`.`ProductID`
                        WHERE
                            CURDATE() BETWEEN  `order_products`.`StartDate` AND `order_products`.`EndDate` AND
                            `order_products`.`Months` > 1 AND
                            `subscriptions`.`Months` > 1 AND
                            `subscriptions`.`Digital` = 1 AND
                            (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                            `orders`.`Status` & 256 = 0 AND
                            `orders`.`EMail` = 'info@maxgraphic.eu'

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                WHERE
                    `articles`.`Gallery` != '' AND
                    (CASE WHEN `articles`.`GroupID` = 41 THEN `articles`.`PostDate` >= '2024-11-21' ELSE `articles`.`PostDate` BETWEEN '2024-10-24' AND '2024-11-21 23:59:59' END) AND 
                `articles`.`PostDate` <= NOW()
             AND `articles`.`OnlineSub` = 0 AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 0, 100

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 15:54:09] /spisanie8/root/книги.html 108.61.209.243

set names utf8

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'книги'
                LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'книги'
                LIMIT 1

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
                INNER JOIN `groups` ON `products`.`GroupID` = `groups`.`ID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '065256d59ca5e3b05b25080f58f21536' LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 15:55:31] /spisanie8/root/ 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `slider`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
            LIMIT 6

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'index'
                LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT `EMail` FROM users WHERE ID = 1 LIMIT 1

SELECT
                            `orders`.`ID`
                        FROM
                            `orders`
                            INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                            INNER JOIN `subscriptions` ON `order_products`.`ProductID` = `subscriptions`.`ProductID`
                        WHERE
                            CURDATE() BETWEEN  `order_products`.`StartDate` AND `order_products`.`EndDate` AND
                            `order_products`.`Months` > 1 AND
                            `subscriptions`.`Months` > 1 AND
                            `subscriptions`.`Digital` = 1 AND
                            (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                            `orders`.`Status` & 256 = 0 AND
                            `orders`.`EMail` = 'info@maxgraphic.eu'

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                WHERE
                    `articles`.`Gallery` != '' AND
                    (CASE WHEN `articles`.`GroupID` = 41 THEN `articles`.`PostDate` >= '2024-11-21' ELSE `articles`.`PostDate` BETWEEN '2024-10-24' AND '2024-11-21 23:59:59' END) AND 
                `articles`.`PostDate` <= NOW()
             AND `articles`.`OnlineSub` = 0 AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 0, 100

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 16:00:50] /spisanie8/root/ 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `slider`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
            LIMIT 6

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'index'
                LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT `EMail` FROM users WHERE ID = 1 LIMIT 1

SELECT
                            `orders`.`ID`
                        FROM
                            `orders`
                            INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                            INNER JOIN `subscriptions` ON `order_products`.`ProductID` = `subscriptions`.`ProductID`
                        WHERE
                            CURDATE() BETWEEN  `order_products`.`StartDate` AND `order_products`.`EndDate` AND
                            `order_products`.`Months` > 1 AND
                            `subscriptions`.`Months` > 1 AND
                            `subscriptions`.`Digital` = 1 AND
                            (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                            `orders`.`Status` & 256 = 0 AND
                            `orders`.`EMail` = 'info@maxgraphic.eu'

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                WHERE
                    `articles`.`Gallery` != '' AND
                    (CASE WHEN `articles`.`GroupID` = 41 THEN `articles`.`PostDate` >= '2024-11-21' ELSE `articles`.`PostDate` BETWEEN '2024-10-24' AND '2024-11-21 23:59:59' END) AND 
                `articles`.`PostDate` <= NOW()
             AND `articles`.`OnlineSub` = 0 AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 0, 100

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 16:06:13] /spisanie8/root/книги.html 108.61.209.243

set names utf8

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'книги'
                LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'книги'
                LIMIT 1

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
                INNER JOIN `groups` ON `products`.`GroupID` = `groups`.`ID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '065256d59ca5e3b05b25080f58f21536' LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 16:33:03] /spisanie8/root/книги.html 108.61.209.243

set names utf8

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'книги'
                LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'книги'
                LIMIT 1

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
                INNER JOIN `groups` ON `products`.`GroupID` = `groups`.`ID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '065256d59ca5e3b05b25080f58f21536' LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 16:33:35] /spisanie8/root/книги.html 108.61.209.243

set names utf8

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'книги'
                LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'книги'
                LIMIT 1

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
                INNER JOIN `groups` ON `products`.`GroupID` = `groups`.`ID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '065256d59ca5e3b05b25080f58f21536' LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [21-Nov-2024 16:34:56] /spisanie8/root/книги.html 108.61.209.243

set names utf8

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'книги'
                LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'книги'
                LIMIT 1

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
                INNER JOIN `groups` ON `products`.`GroupID` = `groups`.`ID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '065256d59ca5e3b05b25080f58f21536' LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 4 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '065256d59ca5e3b05b25080f58f21536'
                        LIMIT 1

SELECT
                `ID`,
                `ParentID`,
                `Colour`,
                `MenuLabel`,
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ParentID` > 0 AND
                `Visible` = 1
         ORDER BY `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
