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
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
                 AND `products`.`Featured` = 1
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '706bf122fcdb9753207d69e3b4257441' 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`.`Featured` = 1 AND
                `articles`.`Gallery` != ''
                 AND
`articles`.`Visible` = 1
            ORDER BY
                `articles`.`PostDate` DESC
         LIMIT 0, 50

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`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`Visible`,
                `subscriptions`.`IntDate`,
                `subscriptions`.`Months`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`,
                `subscriptions`.`Digital`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `subscriptions` ON `products`.`ID` = `subscriptions`.`ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `groups`.`URLLabel` = 'абонамент' AND
                `products`.`Visible` = 1 AND
                `subscriptions`.`InIndex` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `subscriptions`.`Months` DESC,
                `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
# [12-Mar-2025 15:43:21] /spisanie8/root/списание/списание-8-брой-102024-г.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
                `products`.*,
                `magazines`.*,
                `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  AND
                `products`.`URLLabel` = 'списание-8-брой-102024-г'
            LIMIT 1

SELECT DISTINCT
                `articles`.`ID`,
                `articles`.`IntDate`,
                `articles`.`PostDate`,
                `articles`.`Title`,
                `articles`.`Annotation`,
                `articles`.`Section`,
                `articles`.`Gallery`,
                `articles`.`URLLabel`,
                `articles`.`Featured`,
                `articles`.`Visible`,
                `articles`.`Comments`,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `articles`
                INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                INNER JOIN `magazine_articles` ON `magazine_articles`.`ArticleID` = `articles`.`ID`
            WHERE
                `magazine_articles`.`MagazineID` = 899 AND
                `articles`.`Visible` = 1
            ORDER BY
                `articles`.`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`,
                    `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`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`Visible`,
                `subscriptions`.`IntDate`,
                `subscriptions`.`Months`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`,
                `subscriptions`.`Digital`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `subscriptions` ON `products`.`ID` = `subscriptions`.`ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `groups`.`URLLabel` = 'абонамент' AND
                `products`.`Visible` = 1 AND
                `subscriptions`.`InIndex` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `subscriptions`.`Months` DESC,
                `products`.`PostDate` DESC

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`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Featured` = 1 AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 0, 50

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '706bf122fcdb9753207d69e3b4257441' 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
                `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
# [12-Mar-2025 15:43:30] /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
# [12-Mar-2025 15:43:33] /spisanie8/root/ajax/users/login.html?_=1741787013048 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` = '706bf122fcdb9753207d69e3b4257441' WHERE `ID` = 1
# [12-Mar-2025 15:43:33] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:43:36] /spisanie8/root/admin/blocks/list.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
               `blocks`.*,
               GROUP_CONCAT(`block_position`.`Position` SEPARATOR ',') AS `Positions`
            FROM
                `blocks`
                LEFT JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
            WHERE 1
                
            GROUP BY
                `blocks`.`ID`
            ORDER BY  `PostDate` DESC

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
# [12-Mar-2025 15:43:38] /spisanie8/root/admin/ajax/blocks/form/31.html?_=1741787018000 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                *
            FROM
                `blocks`
            WHERE
                `ID` = 31
            LIMIT 1

SELECT
                GROUP_CONCAT(`Position` SEPARATOR ',') AS Positions
            FROM
                `block_position`
            WHERE
                `BlockID` = 31;
# [12-Mar-2025 15:43:43] /spisanie8/root/admin/ajax/blocks/update.html?_=1741787022411 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT * FROM `blocks` LIMIT 1

SHOW COLUMNS FROM `blocks`

UPDATE `blocks` SET ID = '31', PostDate = '2025-01-15', LastUpdate = '2025-03-12 15:43:43', Module = 'products', Label = '', Title = 'Избрани продукти 123', Content = '<br>', PostNum = '100', Filters = '[{"Featured":"1"}]', Visible = 1 WHERE ID = '31'

DELETE FROM `block_position` WHERE `BlockID` = '31'

INSERT INTO `block_position` (`BlockID`, `Position`) VALUES 
	('31', 'homepage');
# [12-Mar-2025 15:43:43] /spisanie8/root/admin/blocks/list.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
               `blocks`.*,
               GROUP_CONCAT(`block_position`.`Position` SEPARATOR ',') AS `Positions`
            FROM
                `blocks`
                LEFT JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
            WHERE 1
                
            GROUP BY
                `blocks`.`ID`
            ORDER BY  `PostDate` DESC

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
# [12-Mar-2025 15:43:47] /spisanie8/root/admin/users/account.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT * FROM users WHERE ID = 1 LIMIT 1

SELECT
                *
            FROM
                `orders`
            WHERE
                `UserID` = 1 AND
                `Status` > 0
            ORDER BY
                `PostDate` DESC

SELECT *
            FROM (
                (SELECT
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    `magazines`.`ProductID`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    `products`.`PDF` != '' AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0 AND
                    `magazines`.`ProductID` IS NULL
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* podaryci */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    `magazines`.`ProductID`,
                    1 AS Gift
                FROM
                    `gifts`
                    INNER JOIN `orders` ON `gifts`.`OrderID` = 0 OR
                        (`gifts`.`OrderID` = `orders`.`ID` AND
                        (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                        `orders`.`Status` & 256 = 0)
                    INNER JOIN `products` ON `products`.`ID` = `gifts`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT OUTER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                WHERE
                    `magazines`.`ProductID` IS NULL AND
                    `gifts`.`UserID` = 1 AND
                    `gifts`.`GiftType` = 2 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1
                GROUP BY
                    `products`.`ID`)

            ) A
            GROUP BY `ID`
            ORDER BY `PostDate` DESC

SELECT *
            FROM (
                (SELECT /* za otdelni spisaniq */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* za abonament */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `subscriptions` ON `order_products`.`ProductID` = `subscriptions`.`ProductID`
                    INNER JOIN `products` ON `products`.`PostDate` BETWEEN `order_products`.`StartDate` AND`order_products`.`EndDate`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `subscriptions`.`Digital` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* podaryci za otdelni spisaniq */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    1 AS Gift
                FROM
                    `gifts`
                    INNER JOIN `orders` ON `gifts`.`OrderID` = 0 OR
                        (`gifts`.`OrderID` = `orders`.`ID` AND
                        (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                        `orders`.`Status` & 256 = 0)
                    INNER JOIN `products` ON `products`.`ID` = `gifts`.`ProductID`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `gifts`.`UserID` = 1 AND
                    `gifts`.`GiftType` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1
                GROUP BY
                    `products`.`ID`)

            ) A
            GROUP BY `ID`
            ORDER BY `PostDate` DESC

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
# [12-Mar-2025 15:43:49] /spisanie8/root/ajax/users/logout.html?_=1741787028497 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

UPDATE `users` SET `SecureKey` = '' WHERE `ID` = 1
# [12-Mar-2025 15:43:49] /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`,
                `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
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1

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
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
                 AND `products`.`Featured` = 1
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '706bf122fcdb9753207d69e3b4257441' 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`.`Featured` = 1 AND
                `articles`.`Gallery` != ''
                 AND
`articles`.`Visible` = 1
            ORDER BY
                `articles`.`PostDate` DESC
         LIMIT 0, 50

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`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`Visible`,
                `subscriptions`.`IntDate`,
                `subscriptions`.`Months`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`,
                `subscriptions`.`Digital`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `subscriptions` ON `products`.`ID` = `subscriptions`.`ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `groups`.`URLLabel` = 'абонамент' AND
                `products`.`Visible` = 1 AND
                `subscriptions`.`InIndex` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `subscriptions`.`Months` DESC,
                `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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:43:53] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:43:56] /spisanie8/root/ajax/users/login.html?_=1741787035651 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` = '706bf122fcdb9753207d69e3b4257441' WHERE `ID` = 1
# [12-Mar-2025 15:43:56] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:43:58] /spisanie8/root/admin/blocks/list.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
               `blocks`.*,
               GROUP_CONCAT(`block_position`.`Position` SEPARATOR ',') AS `Positions`
            FROM
                `blocks`
                LEFT JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
            WHERE 1
                
            GROUP BY
                `blocks`.`ID`
            ORDER BY  `PostDate` DESC

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
# [12-Mar-2025 15:44:00] /spisanie8/root/admin/ajax/blocks/form/31.html?_=1741787039656 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                *
            FROM
                `blocks`
            WHERE
                `ID` = 31
            LIMIT 1

SELECT
                GROUP_CONCAT(`Position` SEPARATOR ',') AS Positions
            FROM
                `block_position`
            WHERE
                `BlockID` = 31;
# [12-Mar-2025 15:44:04] /spisanie8/root/admin/ajax/blocks/update.html?_=1741787044338 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT * FROM `blocks` LIMIT 1

SHOW COLUMNS FROM `blocks`

UPDATE `blocks` SET ID = '31', PostDate = '2025-01-15', LastUpdate = '2025-03-12 15:44:04', Module = 'products', Label = '', Title = 'Избрани продукти', Content = '<br>', PostNum = '100', Filters = '[{"Featured":"1"}]', Visible = 1 WHERE ID = '31'

DELETE FROM `block_position` WHERE `BlockID` = '31'

INSERT INTO `block_position` (`BlockID`, `Position`) VALUES 
	('31', 'homepage');
# [12-Mar-2025 15:44:05] /spisanie8/root/admin/blocks/list.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
               `blocks`.*,
               GROUP_CONCAT(`block_position`.`Position` SEPARATOR ',') AS `Positions`
            FROM
                `blocks`
                LEFT JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
            WHERE 1
                
            GROUP BY
                `blocks`.`ID`
            ORDER BY  `PostDate` DESC

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
# [12-Mar-2025 15:44:33] /spisanie8/root/admin/ajax/blocks/form.html?_=1741787073152 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

INSERT INTO `blocks` SET ID = NULL;

SELECT MAX(ID) FROM `blocks`;

DELETE FROM `blocks` WHERE ID = 34;
# [12-Mar-2025 15:44:41] /spisanie8/root// 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:44:43] /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`,
                `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
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1

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
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
                 AND `products`.`Featured` = 1
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '706bf122fcdb9753207d69e3b4257441' 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`.`Featured` = 1 AND
                `articles`.`Gallery` != ''
                 AND
`articles`.`Visible` = 1
            ORDER BY
                `articles`.`PostDate` DESC
         LIMIT 0, 50

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`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`Visible`,
                `subscriptions`.`IntDate`,
                `subscriptions`.`Months`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`,
                `subscriptions`.`Digital`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `subscriptions` ON `products`.`ID` = `subscriptions`.`ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `groups`.`URLLabel` = 'абонамент' AND
                `products`.`Visible` = 1 AND
                `subscriptions`.`InIndex` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `subscriptions`.`Months` DESC,
                `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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:44:51] /spisanie8/root/събития/2020/0207/софия-става-столица-на-3d-принтирането.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` = 20200207 AND
                    `articles`.`URLLabel` = 'софия-става-столица-на-3d-принтирането' 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
                `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
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Featured` = 1 AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 0, 50

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '706bf122fcdb9753207d69e3b4257441' 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`.`Featured` = 1 AND
                `articles`.`Gallery` != ''
                 AND
`articles`.`Visible` = 1
            ORDER BY
                `articles`.`PostDate` DESC
         LIMIT 0, 50

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`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`Visible`,
                `subscriptions`.`IntDate`,
                `subscriptions`.`Months`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`,
                `subscriptions`.`Digital`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `subscriptions` ON `products`.`ID` = `subscriptions`.`ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `groups`.`URLLabel` = 'абонамент' AND
                `products`.`Visible` = 1 AND
                `subscriptions`.`InIndex` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `subscriptions`.`Months` DESC,
                `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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:46:58] /spisanie8/root/събития/2020/0207/софия-става-столица-на-3d-принтирането.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` = 20200207 AND
                    `articles`.`URLLabel` = 'софия-става-столица-на-3d-принтирането' 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
                `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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:47:05] /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`.`Gallery`,
                `products`.`URLLabel`,
                `magazines`.`IntDate`,
                FLOOR(`IntDate` / 10000) AS `Year`,
                `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
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:47:23] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT * FROM users WHERE ID = 1 LIMIT 1

SELECT
                *
            FROM
                `orders`
            WHERE
                `UserID` = 1 AND
                `Status` > 0
            ORDER BY
                `PostDate` DESC

SELECT *
            FROM (
                (SELECT
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    `magazines`.`ProductID`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    `products`.`PDF` != '' AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0 AND
                    `magazines`.`ProductID` IS NULL
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* podaryci */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    `magazines`.`ProductID`,
                    1 AS Gift
                FROM
                    `gifts`
                    INNER JOIN `orders` ON `gifts`.`OrderID` = 0 OR
                        (`gifts`.`OrderID` = `orders`.`ID` AND
                        (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                        `orders`.`Status` & 256 = 0)
                    INNER JOIN `products` ON `products`.`ID` = `gifts`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT OUTER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                WHERE
                    `magazines`.`ProductID` IS NULL AND
                    `gifts`.`UserID` = 1 AND
                    `gifts`.`GiftType` = 2 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1
                GROUP BY
                    `products`.`ID`)

            ) A
            GROUP BY `ID`
            ORDER BY `PostDate` DESC

SELECT *
            FROM (
                (SELECT /* za otdelni spisaniq */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* za abonament */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `subscriptions` ON `order_products`.`ProductID` = `subscriptions`.`ProductID`
                    INNER JOIN `products` ON `products`.`PostDate` BETWEEN `order_products`.`StartDate` AND`order_products`.`EndDate`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `subscriptions`.`Digital` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* podaryci za otdelni spisaniq */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    1 AS Gift
                FROM
                    `gifts`
                    INNER JOIN `orders` ON `gifts`.`OrderID` = 0 OR
                        (`gifts`.`OrderID` = `orders`.`ID` AND
                        (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                        `orders`.`Status` & 256 = 0)
                    INNER JOIN `products` ON `products`.`ID` = `gifts`.`ProductID`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `gifts`.`UserID` = 1 AND
                    `gifts`.`GiftType` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1
                GROUP BY
                    `products`.`ID`)

            ) A
            GROUP BY `ID`
            ORDER BY `PostDate` DESC

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
# [12-Mar-2025 15:47:28] /spisanie8/root/articles/list.html 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` = '706bf122fcdb9753207d69e3b4257441'
                        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` >= '2025-03-12' ELSE `articles`.`PostDate` BETWEEN '2025-02-12' AND '2025-03-12 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
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Featured` = 1 AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 0, 50

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '706bf122fcdb9753207d69e3b4257441' 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`.`Featured` = 1 AND
                `articles`.`Gallery` != ''
                 AND
`articles`.`Visible` = 1
            ORDER BY
                `articles`.`PostDate` DESC
         LIMIT 0, 50

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`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`Visible`,
                `subscriptions`.`IntDate`,
                `subscriptions`.`Months`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`,
                `subscriptions`.`Digital`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `subscriptions` ON `products`.`ID` = `subscriptions`.`ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `groups`.`URLLabel` = 'абонамент' AND
                `products`.`Visible` = 1 AND
                `subscriptions`.`InIndex` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `subscriptions`.`Months` DESC,
                `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
# [12-Mar-2025 15:47:38] /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`,
                `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
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1

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
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
                 AND `products`.`Featured` = 1
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '706bf122fcdb9753207d69e3b4257441' 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`.`Featured` = 1 AND
                `articles`.`Gallery` != ''
                 AND
`articles`.`Visible` = 1
            ORDER BY
                `articles`.`PostDate` DESC
         LIMIT 0, 50

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`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`Visible`,
                `subscriptions`.`IntDate`,
                `subscriptions`.`Months`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`,
                `subscriptions`.`Digital`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `subscriptions` ON `products`.`ID` = `subscriptions`.`ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `groups`.`URLLabel` = 'абонамент' AND
                `products`.`Visible` = 1 AND
                `subscriptions`.`InIndex` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `subscriptions`.`Months` DESC,
                `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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:47:43] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT * FROM users WHERE ID = 1 LIMIT 1

SELECT
                *
            FROM
                `orders`
            WHERE
                `UserID` = 1 AND
                `Status` > 0
            ORDER BY
                `PostDate` DESC

SELECT *
            FROM (
                (SELECT
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    `magazines`.`ProductID`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    `products`.`PDF` != '' AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0 AND
                    `magazines`.`ProductID` IS NULL
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* podaryci */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    `magazines`.`ProductID`,
                    1 AS Gift
                FROM
                    `gifts`
                    INNER JOIN `orders` ON `gifts`.`OrderID` = 0 OR
                        (`gifts`.`OrderID` = `orders`.`ID` AND
                        (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                        `orders`.`Status` & 256 = 0)
                    INNER JOIN `products` ON `products`.`ID` = `gifts`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT OUTER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                WHERE
                    `magazines`.`ProductID` IS NULL AND
                    `gifts`.`UserID` = 1 AND
                    `gifts`.`GiftType` = 2 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1
                GROUP BY
                    `products`.`ID`)

            ) A
            GROUP BY `ID`
            ORDER BY `PostDate` DESC

SELECT *
            FROM (
                (SELECT /* za otdelni spisaniq */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* za abonament */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `subscriptions` ON `order_products`.`ProductID` = `subscriptions`.`ProductID`
                    INNER JOIN `products` ON `products`.`PostDate` BETWEEN `order_products`.`StartDate` AND`order_products`.`EndDate`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `subscriptions`.`Digital` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* podaryci za otdelni spisaniq */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    1 AS Gift
                FROM
                    `gifts`
                    INNER JOIN `orders` ON `gifts`.`OrderID` = 0 OR
                        (`gifts`.`OrderID` = `orders`.`ID` AND
                        (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                        `orders`.`Status` & 256 = 0)
                    INNER JOIN `products` ON `products`.`ID` = `gifts`.`ProductID`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `gifts`.`UserID` = 1 AND
                    `gifts`.`GiftType` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1
                GROUP BY
                    `products`.`ID`)

            ) A
            GROUP BY `ID`
            ORDER BY `PostDate` DESC

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
# [12-Mar-2025 15:47:45] /spisanie8/root/articles/list.html 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` = '706bf122fcdb9753207d69e3b4257441'
                        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` >= '2025-03-12' ELSE `articles`.`PostDate` BETWEEN '2025-02-12' AND '2025-03-12 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
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Featured` = 1 AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 0, 50

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '706bf122fcdb9753207d69e3b4257441' 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`.`Featured` = 1 AND
                `articles`.`Gallery` != ''
                 AND
`articles`.`Visible` = 1
            ORDER BY
                `articles`.`PostDate` DESC
         LIMIT 0, 50

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`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`Visible`,
                `subscriptions`.`IntDate`,
                `subscriptions`.`Months`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`,
                `subscriptions`.`Digital`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `subscriptions` ON `products`.`ID` = `subscriptions`.`ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `groups`.`URLLabel` = 'абонамент' AND
                `products`.`Visible` = 1 AND
                `subscriptions`.`InIndex` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `subscriptions`.`Months` DESC,
                `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
# [12-Mar-2025 15:47:53] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:48:09] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT * FROM users WHERE ID = 1 LIMIT 1

SELECT
                *
            FROM
                `orders`
            WHERE
                `UserID` = 1 AND
                `Status` > 0
            ORDER BY
                `PostDate` DESC

SELECT *
            FROM (
                (SELECT
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    `magazines`.`ProductID`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    `products`.`PDF` != '' AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0 AND
                    `magazines`.`ProductID` IS NULL
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* podaryci */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    `magazines`.`ProductID`,
                    1 AS Gift
                FROM
                    `gifts`
                    INNER JOIN `orders` ON `gifts`.`OrderID` = 0 OR
                        (`gifts`.`OrderID` = `orders`.`ID` AND
                        (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                        `orders`.`Status` & 256 = 0)
                    INNER JOIN `products` ON `products`.`ID` = `gifts`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT OUTER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                WHERE
                    `magazines`.`ProductID` IS NULL AND
                    `gifts`.`UserID` = 1 AND
                    `gifts`.`GiftType` = 2 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1
                GROUP BY
                    `products`.`ID`)

            ) A
            GROUP BY `ID`
            ORDER BY `PostDate` DESC

SELECT *
            FROM (
                (SELECT /* za otdelni spisaniq */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* za abonament */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `subscriptions` ON `order_products`.`ProductID` = `subscriptions`.`ProductID`
                    INNER JOIN `products` ON `products`.`PostDate` BETWEEN `order_products`.`StartDate` AND`order_products`.`EndDate`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `subscriptions`.`Digital` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* podaryci za otdelni spisaniq */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    1 AS Gift
                FROM
                    `gifts`
                    INNER JOIN `orders` ON `gifts`.`OrderID` = 0 OR
                        (`gifts`.`OrderID` = `orders`.`ID` AND
                        (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                        `orders`.`Status` & 256 = 0)
                    INNER JOIN `products` ON `products`.`ID` = `gifts`.`ProductID`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `gifts`.`UserID` = 1 AND
                    `gifts`.`GiftType` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1
                GROUP BY
                    `products`.`ID`)

            ) A
            GROUP BY `ID`
            ORDER BY `PostDate` DESC

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
# [12-Mar-2025 15:49:37] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT * FROM users WHERE ID = 1 LIMIT 1

SELECT
                *
            FROM
                `orders`
            WHERE
                `UserID` = 1 AND
                `Status` > 0
            ORDER BY
                `PostDate` DESC

SELECT *
            FROM (
                (SELECT
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    `magazines`.`ProductID`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    `products`.`PDF` != '' AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0 AND
                    `magazines`.`ProductID` IS NULL
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* podaryci */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    `magazines`.`ProductID`,
                    1 AS Gift
                FROM
                    `gifts`
                    INNER JOIN `orders` ON `gifts`.`OrderID` = 0 OR
                        (`gifts`.`OrderID` = `orders`.`ID` AND
                        (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                        `orders`.`Status` & 256 = 0)
                    INNER JOIN `products` ON `products`.`ID` = `gifts`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT OUTER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                WHERE
                    `magazines`.`ProductID` IS NULL AND
                    `gifts`.`UserID` = 1 AND
                    `gifts`.`GiftType` = 2 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1
                GROUP BY
                    `products`.`ID`)

            ) A
            GROUP BY `ID`
            ORDER BY `PostDate` DESC

SELECT *
            FROM (
                (SELECT /* za otdelni spisaniq */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* za abonament */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    0 AS Gift
                FROM
                    `orders`
                    INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
                    INNER JOIN `subscriptions` ON `order_products`.`ProductID` = `subscriptions`.`ProductID`
                    INNER JOIN `products` ON `products`.`PostDate` BETWEEN `order_products`.`StartDate` AND`order_products`.`EndDate`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `orders`.`UserID` = 1 AND
                    `subscriptions`.`Digital` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1 AND
                    (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                    `orders`.`Status` & 256 = 0
                GROUP BY
                    `products`.`ID`)

                UNION ALL

                (SELECT /* podaryci za otdelni spisaniq */
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `groups`.`URLLabel` AS `MLabel`,
                    `products`.`PDF`,
                    1 AS Gift
                FROM
                    `gifts`
                    INNER JOIN `orders` ON `gifts`.`OrderID` = 0 OR
                        (`gifts`.`OrderID` = `orders`.`ID` AND
                        (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
                        `orders`.`Status` & 256 = 0)
                    INNER JOIN `products` ON `products`.`ID` = `gifts`.`ProductID`
                    INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `gifts`.`UserID` = 1 AND
                    `gifts`.`GiftType` = 1 AND
                    `products`.`OnlinePrice` > 0 AND
                    `products`.`Visible` = 1
                GROUP BY
                    `products`.`ID`)

            ) A
            GROUP BY `ID`
            ORDER BY `PostDate` DESC

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
# [12-Mar-2025 15:49:40] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:49:52] /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`,
                `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
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1

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
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
                 AND `products`.`Featured` = 1
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '706bf122fcdb9753207d69e3b4257441' 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`.`Featured` = 1 AND
                `articles`.`Gallery` != ''
                 AND
`articles`.`Visible` = 1
            ORDER BY
                `articles`.`PostDate` DESC
         LIMIT 0, 50

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`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`Visible`,
                `subscriptions`.`IntDate`,
                `subscriptions`.`Months`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`,
                `subscriptions`.`Digital`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `subscriptions` ON `products`.`ID` = `subscriptions`.`ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `groups`.`URLLabel` = 'абонамент' AND
                `products`.`Visible` = 1 AND
                `subscriptions`.`InIndex` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `subscriptions`.`Months` DESC,
                `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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:49:57] /spisanie8/root/събития/2020/0207/софия-става-столица-на-3d-принтирането.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` = 20200207 AND
                    `articles`.`URLLabel` = 'софия-става-столица-на-3d-принтирането' 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
                `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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:50:05] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:50:12] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 15:50:18] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741787417864 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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
# [12-Mar-2025 15:52:44] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741787563599 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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
# [12-Mar-2025 15:53:25] /spisanie8/root/admin/ajax/articles/select.html?keyword=тест&_=1741787604596 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                `ID`,
                `Title`
            FROM
                `articles`
            WHERE
                `Title` LIKE '%тест%' AND
                `Visible` = 1
            ORDER BY
                CASE
                    WHEN `Title` LIKE 'тест%' THEN 0
                    WHEN `Title` LIKE '% тест%' THEN 1
                    ELSE 2
                END,
                `PostDate` DESC
            LIMIT 20
# [12-Mar-2025 16:06:52] /spisanie8/root/admin/blocks/list.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
               `blocks`.*,
               GROUP_CONCAT(`block_position`.`Position` SEPARATOR ',') AS `Positions`
            FROM
                `blocks`
                LEFT JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
            WHERE 1
                
            GROUP BY
                `blocks`.`ID`
            ORDER BY  `PostDate` DESC

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
# [12-Mar-2025 16:06:57] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 16:06:58] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741788417514 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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

SELECT `ID`, `Title`, `Label` FROM `blocks`
# [12-Mar-2025 16:07:14] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 16:07:16] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741788435516 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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

SELECT `ID`, `Title`, `Label` FROM `blocks`
# [12-Mar-2025 16:08:23] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741788502648 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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

SELECT `ID`, `Title`, `Label` FROM `blocks`
# [12-Mar-2025 16:12:32] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 16:12:35] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741788754722 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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

SELECT `ID`, `Title`, `Label` FROM `blocks`
# [12-Mar-2025 16:13:20] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 16:13:22] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741788801983 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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

SELECT `ID`, `Title`, `Label` FROM `blocks`
# [12-Mar-2025 16:15:10] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 16:15:12] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741788912038 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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

SELECT `ID`, `Title`, `Label` FROM `blocks`
# [12-Mar-2025 16:15:26] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 16:15: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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 16:15:37] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741788936528 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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

SELECT `ID`, `Title`, `Label` FROM `blocks`
# [12-Mar-2025 16:24:32] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 16:24:36] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741789475903 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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

SELECT `ID`, `Title`, `Label` FROM `blocks`
# [12-Mar-2025 16:29:00] /spisanie8/root/admin/ajax/articles/update.html?_=1741789739920 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT * FROM `articles` LIMIT 1

SHOW COLUMNS FROM `articles`

UPDATE `articles` SET IntDate = '20241125', PostDate = '2024-11-27 06:09:00', LastUpdate = '2025-03-12 16:29:00', GroupID = '71', MetaTitle = '4 сборника подарък при две години онлайн абонамент!', MetaDescription = '4 сборника подарък при две години онлайн абонамент за Списание 8!', Title = '4 сборника подарък при две години абонамент в електронен формат!', URLLabel = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат', Annotation = 'Предложението важи до 8 декември', Gallery = '["novina.png"]', GalleryLabels = '[""]', GalleryAlt = '', VideoURL = '', Content = '<div>Приятели, ако се <b><a href="https://spisanie8.bg/абонамент.html" target="_blank">абонирате </a></b>за две години за електронното издание на Списание 8, ще може да изберете 4 БЕЗПЛАТНИ <b><a href="https://spisanie8.bg/сборници.html" target="_blank">електронни сборника</a></b>!<br></div><div><b><br>Така само за 90 лв.:</b></div>• ще получите на по-ниска цена нови 24 броя онлайн през следващите две години<br>• ще изберете безплатно 4 електронни сборника<br>• ще подкрепите Списание 8, за да можем все така да продължим да създаваме изключително съдържание<br><br><b>Абонирайте се <a href="https://spisanie8.bg/абонамент/две-години-абонамент-в-електронен-формат-и-4-сборника-подарък.html" target="_blank">тук </a>и получете 24 броя и 4 <a href="https://spisanie8.bg/сборници.html" target="_blank">сборника </a>само за 90 лв.!</b><br><br><i>След
 като посочите вида плащане, ще имате възможност да изберете и кои сборници
 на Списание 8 желаете. След потвърждение на плащането, може да влезете в 
профила си и да прочетете/изтеглите избраните от вас сборници.</i><br><b>Предложението важи до 8 декември.</b><br><br>Сборниците на Списание 8 съдържат най-интересните статии от списанието по определени теми. <br><a href="https://spisanie8.bg/сборници.html" target="_blank">Вижте тук съдържанието </a>на всеки един от тях.', Tags = '', Author = '', AddOn = '', Subscribe = 1, Featured = 0, Visible = 1, OnlineSub = 0, RelatedArticles = '' WHERE ID = '16810'

DELETE FROM `magazine_articles` WHERE `magazine_articles`.`ArticleID` = 16810

SELECT
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ID` = 71
            LIMIT 1
# [12-Mar-2025 16:29:00] /spisanie8/root/admin/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'новини-за-8'
                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` = 20241125 AND
                    `articles`.`URLLabel` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат'
                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
                `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
# [12-Mar-2025 16:29:03] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741789742767 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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

SELECT `ID`, `Title`, `Label` FROM `blocks`
# [12-Mar-2025 16:29:40] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741789780371 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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

SELECT `ID`, `Title`, `Label` FROM `blocks`
# [12-Mar-2025 16:29:47] /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` = '706bf122fcdb9753207d69e3b4257441'
                        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
# [12-Mar-2025 16:29:50] /spisanie8/root/admin/ajax/articles/form/16810.html?_=1741789789877 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

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

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

SELECT `ID`, `Title`, `Label` FROM `blocks`
# [12-Mar-2025 16:29:57] /spisanie8/root/admin/ajax/articles/update.html?_=1741789796616 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT * FROM `articles` LIMIT 1

SHOW COLUMNS FROM `articles`

UPDATE `articles` SET IntDate = '20241125', PostDate = '2024-11-27 06:09:00', LastUpdate = '2025-03-12 16:29:57', GroupID = '71', MetaTitle = '4 сборника подарък при две години онлайн абонамент!', MetaDescription = '4 сборника подарък при две години онлайн абонамент за Списание 8!', Title = '4 сборника подарък при две години абонамент в електронен формат!', URLLabel = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат', Annotation = 'Предложението важи до 8 декември', Gallery = '["novina.png"]', GalleryLabels = '[""]', GalleryAlt = '', VideoURL = '', Content = '<div>Приятели, ако се <b><a href="https://spisanie8.bg/абонамент.html" target="_blank">абонирате </a></b>за две години за електронното издание на Списание 8, ще може да изберете 4 БЕЗПЛАТНИ <b><a href="https://spisanie8.bg/сборници.html" target="_blank">електронни сборника</a></b>!<br></div><div><b><br>Така само за 90 лв.:</b></div>• ще получите на по-ниска цена нови 24 броя онлайн през следващите две години<br>• ще изберете безплатно 4 електронни сборника<br>• ще подкрепите Списание 8, за да можем все така да продължим да създаваме изключително съдържание<br><br><b>Абонирайте се <a href="https://spisanie8.bg/абонамент/две-години-абонамент-в-електронен-формат-и-4-сборника-подарък.html" target="_blank">тук </a>и получете 24 броя и 4 <a href="https://spisanie8.bg/сборници.html" target="_blank">сборника </a>само за 90 лв.!</b><br><br><i>След
 като посочите вида плащане, ще имате възможност да изберете и кои сборници
 на Списание 8 желаете. След потвърждение на плащането, може да влезете в 
профила си и да прочетете/изтеглите избраните от вас сборници.</i><br><b>Предложението важи до 8 декември.</b><br><br>Сборниците на Списание 8 съдържат най-интересните статии от списанието по определени теми. <br><a href="https://spisanie8.bg/сборници.html" target="_blank">Вижте тук съдържанието </a>на всеки един от тях.', Tags = '', Author = '', Blocks = '["29","31"]', AddOn = '', Subscribe = 1, Featured = 0, Visible = 1, OnlineSub = 0, RelatedArticles = '' WHERE ID = '16810'

DELETE FROM `magazine_articles` WHERE `magazine_articles`.`ArticleID` = 16810

SELECT
                `URLLabel`
            FROM
                `groups`
            WHERE
                `ID` = 71
            LIMIT 1
# [12-Mar-2025 16:29:57] /spisanie8/root/admin/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'новини-за-8'
                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` = 20241125 AND
                    `articles`.`URLLabel` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат'
                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
                `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
# [12-Mar-2025 16:36:47] /spisanie8/root/admin/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'новини-за-8'
                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` = 20241125 AND
                    `articles`.`URLLabel` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат'
                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
# [12-Mar-2025 16:37:02] /spisanie8/root/admin/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'новини-за-8'
                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` = 20241125 AND
                    `articles`.`URLLabel` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат'
                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
# [12-Mar-2025 16:37:17] /spisanie8/root/admin/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'новини-за-8'
                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` = 20241125 AND
                    `articles`.`URLLabel` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат'
                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
                *
	        FROM
	        	`blocks`
	    	WHERE
                `ID` IN(:arIDs)
# [12-Mar-2025 16:37:38] /spisanie8/root/admin/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'новини-за-8'
                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` = 20241125 AND
                    `articles`.`URLLabel` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат'
                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
                *
	        FROM
	        	`blocks`
	    	WHERE
                `ID` IN (:arIDs)
# [12-Mar-2025 16:37:44] /spisanie8/root/admin/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'новини-за-8'
                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` = 20241125 AND
                    `articles`.`URLLabel` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат'
                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
                *
	        FROM
	        	`blocks`
	    	WHERE
                `ID` IN (:arIDs)
# [12-Mar-2025 16:38:17] /spisanie8/root/admin/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'новини-за-8'
                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` = 20241125 AND
                    `articles`.`URLLabel` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат'
                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
                *
	        FROM
	        	`blocks`
	    	WHERE
                `ID` IN ('["29","31"]')

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
# [12-Mar-2025 16:39:45] /spisanie8/root/admin/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'новини-за-8'
                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` = 20241125 AND
                    `articles`.`URLLabel` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат'
                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
                *
	        FROM
	        	`blocks`
	    	WHERE
                `ID` IN ('29,31')

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
# [12-Mar-2025 16:40:13] /spisanie8/root/admin/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = '706bf122fcdb9753207d69e3b4257441'
                        LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'новини-за-8'
                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` = 20241125 AND
                    `articles`.`URLLabel` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат'
                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
                *
	        FROM
	        	`blocks`
	    	WHERE
                `ID` IN ('29,31')

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
