# [29-Sep-2025 14:44:35] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 LIMIT 1

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`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 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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 1
                 AND `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`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 32 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 100

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
# [29-Sep-2025 14:44:37] /spisanie8/root/ajax/basket/check.html?_=1759146277103 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15'
# [29-Sep-2025 14:44:41] /spisanie8/root/списание/списание-8-брой-112011-г.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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 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-брой-112011-г'
            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` = 46 AND
                `articles`.`Visible` = 1
            ORDER BY
                `articles`.`PostDate` DESC

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'magazine'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`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
# [29-Sep-2025 14:44:43] /spisanie8/root/ajax/basket/update/popup.html?_=1759146283080 108.61.209.243

set names utf8

SELECT Basket FROM `basket` WHERE BasketID = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

INSERT INTO  `basket` (`BasketID`, `PostDate`, `UpdateDate`, `Basket`, `Num`) VALUES ('9d8e1cc4ad4b687eba94e71fab0ccb15', NOW(), NOW(), '{"46":1}', 1)

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15'

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

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

SELECT ID FROM `orders` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Status` = 0 LIMIT 1
# [29-Sep-2025 14:44:46] /spisanie8/root/ajax/banners/popup.html?_=1759146286237 108.61.209.243

set names utf8

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 12 LIMIT 1
# [29-Sep-2025 14:44:49] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Basket` LIKE '%d%' LIMIT 1

SELECT
                `Browser`,
                `IP`,
                `GA`
            FROM
                guests
            WHERE
                BasketID = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND
                DATE_ADD(PostDate, INTERVAL 1 WEEK) > NOW()
            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
# [29-Sep-2025 14:44:50] /spisanie8/root/ajax/guests.html?_=1759146290810 108.61.209.243

set names utf8

REPLACE INTO `guests`
                (`BasketID`, `PostDate`, `Browser`, `IP`) VALUES
                ('9d8e1cc4ad4b687eba94e71fab0ccb15', NOW(), 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0', '108.61.209.243')
# [29-Sep-2025 14:44:50] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Basket` LIKE '%d%' LIMIT 1

SELECT
                `Browser`,
                `IP`,
                `GA`
            FROM
                guests
            WHERE
                BasketID = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND
                DATE_ADD(PostDate, INTERVAL 1 WEEK) > NOW()
            LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

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

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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
# [29-Sep-2025 14:44:54] /spisanie8/root/ajax/delivery/speedy/form.html?_=1759146294730 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`ID` = 46 AND
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            LIMIT 1

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15'
            LIMIT 1
# [29-Sep-2025 14:44:57] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Basket` LIKE '%d%' LIMIT 1

SELECT
                `Browser`,
                `IP`,
                `GA`
            FROM
                guests
            WHERE
                BasketID = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND
                DATE_ADD(PostDate, INTERVAL 1 WEEK) > NOW()
            LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

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

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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
# [29-Sep-2025 14:44:59] /spisanie8/root/ajax/delivery/speedy/form.html?_=1759146299850 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`ID` = 46 AND
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            LIMIT 1

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15'
            LIMIT 1
# [29-Sep-2025 14:45:23] /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
# [29-Sep-2025 14:45:28] /spisanie8/root/ajax/users/login.html?_=1759146328371 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` = '9d8e1cc4ad4b687eba94e71fab0ccb15' WHERE `ID` = 1
# [29-Sep-2025 14:45:28] /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` = '9d8e1cc4ad4b687eba94e71fab0ccb15'
                        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
# [29-Sep-2025 14:49:37] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 LIMIT 1

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`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 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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 1
                 AND `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`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 32 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 100

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
# [29-Sep-2025 14:49:47] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 LIMIT 1

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`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 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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 1
                 AND `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`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 32 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 100

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
# [29-Sep-2025 14:51:37] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 LIMIT 1

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage' AND 
                `blocks`.`Visible` = 1
         ORDER BY `blocks`.`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 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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 1
                 AND `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`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 32 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 100

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

set names utf8

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 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` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат' AND
                    `articles`.`PostDate` <= NOW() AND
                    `articles`.`Visible` = 1
                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` = 2 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 8 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` = 3 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                *
	        FROM
	        	`blocks`
	    	WHERE
                `ID` IN (35,37) AND 
                `Visible` = 1
         ORDER BY `PostDate` DESC

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`
                    LEFT JOIN `block_articles` ON
                        `block_articles`.`BlockID` = 35 AND
                        `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1 AND
                    (
                        `block_articles`.`ArticleID` IS NOT NULL
                        AND (`articles`.`Title` LIKE '%здравослов хран%' OR `articles`.`Content` LIKE '%здравослов%хран%')
                    )
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 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 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND `products`.`Content` LIKE '%Здравослов%хран%'
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 100

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
# [29-Sep-2025 14:52:24] /spisanie8/root/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 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` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат' AND
                    `articles`.`PostDate` <= NOW() AND
                    `articles`.`Visible` = 1
                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` = 2 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 8 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` = 3 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                *
	        FROM
	        	`blocks`
	    	WHERE
                `ID` IN (35,37) AND 
                `Visible` = 1
         ORDER BY `PostDate` DESC

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`
                    LEFT JOIN `block_articles` ON
                        `block_articles`.`BlockID` = 35 AND
                        `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1 AND
                    (
                        `block_articles`.`ArticleID` IS NOT NULL
                        AND (`articles`.`Title` LIKE '%здравослов хран%' OR `articles`.`Content` LIKE '%здравослов%хран%')
                    )
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 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 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND `products`.`Content` LIKE '%Здравослов%хран%'
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 100

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
# [29-Sep-2025 14:55:11] /spisanie8/root/новини-за-8/2024/1125/сборника-подарък-при-две-години-абонамент-в-електронен-формат.html 108.61.209.243

set names utf8

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 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` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат' AND
                    `articles`.`PostDate` <= NOW() AND
                    `articles`.`Visible` = 1
                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` = 2 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 8 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` = 3 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                *
	        FROM
	        	`blocks`
	    	WHERE
                `ID` IN (35,37) AND 
                `Visible` = 1
         ORDER BY `PostDate` DESC

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`
                    LEFT JOIN `block_articles` ON
                        `block_articles`.`BlockID` = 35 AND
                        `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1 AND
                    (
                        `block_articles`.`ArticleID` IS NOT NULL
                        AND (`articles`.`Title` LIKE '%здравослов хран%' OR `articles`.`Content` LIKE '%здравослов%хран%')
                    )
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 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 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND `products`.`Content` LIKE '%Здравослов%хран%'
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 100

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
# [29-Sep-2025 14:55:28] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 LIMIT 1

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage' AND 
                `blocks`.`Visible` = 1
         ORDER BY `blocks`.`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 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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 1
                 AND `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`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 32 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 100

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

set names utf8

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 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` = 'сборника-подарък-при-две-години-абонамент-в-електронен-формат' AND
                    `articles`.`PostDate` <= NOW() AND
                    `articles`.`Visible` = 1
                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` = 2 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 8 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` = 3 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

SELECT
                *
	        FROM
	        	`blocks`
	    	WHERE
                `ID` IN (35,37) AND 
                `Visible` = 1
         ORDER BY `PostDate` DESC

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`
                    LEFT JOIN `block_articles` ON
                        `block_articles`.`BlockID` = 35 AND
                        `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1 AND
                    (
                        `block_articles`.`ArticleID` IS NOT NULL
                        AND (`articles`.`Title` LIKE '%здравослов хран%' OR `articles`.`Content` LIKE '%здравослов%хран%')
                    )
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 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 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND `products`.`Content` LIKE '%Здравослов%хран%'
            ORDER BY
                `products`.`PostDate` DESC
         LIMIT 100

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
# [29-Sep-2025 14:57:04] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 LIMIT 1

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage' AND 
                `blocks`.`Visible` = 1
         ORDER BY `blocks`.`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 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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 1
                 AND `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`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 32 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 100

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
# [29-Sep-2025 14:57:07] /spisanie8/root/списание/списание-8-брой-112011-г.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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 3 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-брой-112011-г'
            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` = 46 AND
                `articles`.`Visible` = 1
            ORDER BY
                `articles`.`PostDate` DESC

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'magazine' AND 
                `blocks`.`Visible` = 1
         ORDER BY `blocks`.`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
# [29-Sep-2025 14:57:08] /spisanie8/root/ajax/basket/popup.html?_=1759147028912 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

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

SELECT ID FROM `orders` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Status` = 0 LIMIT 1
# [29-Sep-2025 14:57:09] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Basket` LIKE '%d%' LIMIT 1

SELECT
                `Browser`,
                `IP`,
                `GA`
            FROM
                guests
            WHERE
                BasketID = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND
                DATE_ADD(PostDate, INTERVAL 1 WEEK) > NOW()
            LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

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

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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
# [29-Sep-2025 14:57:17] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Basket` LIKE '%d%' LIMIT 1

SELECT
                `Browser`,
                `IP`,
                `GA`
            FROM
                guests
            WHERE
                BasketID = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND
                DATE_ADD(PostDate, INTERVAL 1 WEEK) > NOW()
            LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

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

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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
# [29-Sep-2025 14:57:19] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Basket` LIKE '%d%' LIMIT 1

SELECT
                `Browser`,
                `IP`,
                `GA`
            FROM
                guests
            WHERE
                BasketID = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND
                DATE_ADD(PostDate, INTERVAL 1 WEEK) > NOW()
            LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

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

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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
# [29-Sep-2025 14:57:29] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Basket` LIKE '%d%' LIMIT 1

SELECT
                `Browser`,
                `IP`,
                `GA`
            FROM
                guests
            WHERE
                BasketID = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND
                DATE_ADD(PostDate, INTERVAL 1 WEEK) > NOW()
            LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

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

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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
# [29-Sep-2025 14:57:30] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Basket` LIKE '%d%' LIMIT 1

SELECT
                `Browser`,
                `IP`,
                `GA`
            FROM
                guests
            WHERE
                BasketID = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND
                DATE_ADD(PostDate, INTERVAL 1 WEEK) > NOW()
            LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

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

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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
# [29-Sep-2025 14:57:33] /spisanie8/root/ajax/delivery/speedy/form.html?_=1759147053073 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`ID` = 46 AND
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            LIMIT 1

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15'
            LIMIT 1
# [29-Sep-2025 14:58:05] /spisanie8/root/ajax/delivery/econt/form.html?_=1759147085441 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`ID` = 46 AND
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            LIMIT 1

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15'
            LIMIT 1
# [29-Sep-2025 15:00:10] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Basket` LIKE '%d%' LIMIT 1

SELECT
                `Browser`,
                `IP`,
                `GA`
            FROM
                guests
            WHERE
                BasketID = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND
                DATE_ADD(PostDate, INTERVAL 1 WEEK) > NOW()
            LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

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

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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
# [29-Sep-2025 15:00:13] /spisanie8/root/ajax/delivery/speedy/form.html?_=1759147213038 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`ID` = 46 AND
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            LIMIT 1

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15'
            LIMIT 1
# [29-Sep-2025 15:01:32] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND `Basket` LIKE '%d%' LIMIT 1

SELECT
                `Browser`,
                `IP`,
                `GA`
            FROM
                guests
            WHERE
                BasketID = '9d8e1cc4ad4b687eba94e71fab0ccb15' AND
                DATE_ADD(PostDate, INTERVAL 1 WEEK) > NOW()
            LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

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

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' 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
# [29-Sep-2025 15:01:34] /spisanie8/root/ajax/delivery/speedy/form.html?_=1759147294580 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15' LIMIT 1

SELECT
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`ID` = 46 AND
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            LIMIT 1

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = '9d8e1cc4ad4b687eba94e71fab0ccb15'
            LIMIT 1
