# [28-Jan-2026 15:52:26] /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

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` = 5 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 9 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` = 'df4ab14b02e0238bbae4eea156f78815' 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`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 6 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 10 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
# [28-Jan-2026 15:52:27] /spisanie8/root/ajax/basket/check.html?_=1769608354087 108.61.209.243

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
# [28-Jan-2026 15:52:28] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [28-Jan-2026 15:52:33] /spisanie8/root/ajax/banners/popup.html?_=1769608360743 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
# [28-Jan-2026 15:52:36] /spisanie8/root/ajax/users/login.html?_=1769608363587 108.61.209.243

set names utf8

SELECT
                `ID`,
                `FullName`,
                `Password`,
                `Access`,
                `SecureKey`
            FROM
                `users`
            WHERE
                `EMail` = 'davarski@gmail.com' OR `UserName` = 'davarski@gmail.com'
            LIMIT 1

UPDATE `users` SET `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815' WHERE `ID` = 13602
# [28-Jan-2026 15:52:36] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

                UNION ALL

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

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

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

                UNION ALL

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

                UNION ALL

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

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

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

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

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
# [28-Jan-2026 15:52:41] /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

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` = 5 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 9 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` = 'df4ab14b02e0238bbae4eea156f78815' 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`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 6 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

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

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1

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

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

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
# [28-Jan-2026 15:52:43] /spisanie8/root/списание/списание-8-брой-102024-г.html 108.61.209.243

set names utf8

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'списание'
                LIMIT 1

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

SELECT
                `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` = 5 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

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

SELECT
                `products`.*,
                `magazines`.*,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND `products`.`Visible` = 1  AND
                `products`.`URLLabel` = 'списание-8-брой-102024-г'
            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1

SELECT
            `orders`.`ID`
        FROM
            `orders`
            INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
            INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID` ||
                `products`.`PostDate` BETWEEN `order_products`.`StartDate` AND `order_products`.`EndDate`
            INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
        WHERE
            `products`.`ID` = 899 AND
            `orders`.`UserID` = 13602 AND
            `products`.`OnlinePrice` > 0 AND
            `products`.`Visible` = 1 AND
            (`orders`.`Status` & 32 OR `orders`.`Status` & 64) AND
            `orders`.`Status` & 256 = 0
        LIMIT 1

SELECT
            `products`.`ID`
        FROM
            `gifts`
            INNER JOIN `products` ON `products`.`ID` = `gifts`.`ProductID`
            INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
        WHERE
            `gifts`.`UserID` = 13602 AND
            `gifts`.`GiftType` = 1 AND
            `products`.`ID` = 899 AND
            `products`.`OnlinePrice` > 0 AND
            `products`.`Visible` = 1
        GROUP BY
            `products`.`ID`
        LIMIT 1

SELECT DISTINCT
                `articles`.`ID`,
                `articles`.`IntDate`,
                `articles`.`PostDate`,
                `articles`.`Title`,
                `articles`.`Annotation`,
                `articles`.`Section`,
                `articles`.`Gallery`,
                `articles`.`URLLabel`,
                `articles`.`Featured`,
                `articles`.`Visible`,
                `articles`.`Comments`,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `articles`
                INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                INNER JOIN `magazine_articles` ON `magazine_articles`.`ArticleID` = `articles`.`ID`
            WHERE
                `magazine_articles`.`MagazineID` = 899 AND
                `articles`.`Visible` = 1
            ORDER BY
                `articles`.`PostDate` DESC

SELECT
                *
	        FROM
	        	`blocks`
	    	WHERE
                `ID` IN (31) AND 
                `Visible` = 1
         ORDER BY `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` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

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

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

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

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

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

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
# [28-Jan-2026 15:52:46] /spisanie8/root/ajax/basket/update/popup.html?_=1769608372785 108.61.209.243

set names utf8

SELECT Basket FROM `basket` WHERE BasketID = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

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

SELECT `Num` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'

SELECT `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' 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` = 899
                LIMIT 1

SELECT ID FROM `orders` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND `Status` = 0 LIMIT 1
# [28-Jan-2026 15:52:47] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' 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` = 899
                LIMIT 1

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

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
# [28-Jan-2026 15:52:51] /spisanie8/root/ajax/delivery/store/form.html?_=1769608378691 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`ID` = 899 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` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1
# [28-Jan-2026 15:52:57] /spisanie8/root/ajax/orders/submit.html?_=1769608384516 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1
# [28-Jan-2026 15:53:53] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' 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` = 899
                LIMIT 1

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

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
# [28-Jan-2026 15:53:56] /spisanie8/root/ajax/delivery/store/form.html?_=1769608443241 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`ID` = 899 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` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1
# [28-Jan-2026 15:53:59] /spisanie8/root/ajax/orders/submit.html?_=1769608446714 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1
# [28-Jan-2026 15:55:07] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' 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` = 899
                LIMIT 1

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

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
# [28-Jan-2026 15:55:10] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' 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` = 899
                LIMIT 1

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

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
# [28-Jan-2026 15:55:12] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1

SELECT `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' 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` = 899
                LIMIT 1

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

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
# [28-Jan-2026 15:55:14] /spisanie8/root/ajax/delivery/store/form.html?_=1769608521329 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`ID` = 899 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` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1
# [28-Jan-2026 15:55:18] /spisanie8/root/ajax/orders/submit.html?_=1769608525426 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET UserID = 13602, FullName = 'Hristo Davarski', EMail = 'davarski@gmail.com', Phone = '0885068345', TotalPrice = 0, DeliveryMethod = 'Store', DeliveryPrice = 0, PaymentMethod = 'CashOffice', BasketID = 'df4ab14b02e0238bbae4eea156f78815', LastUpdate = '2026-01-28 15:55:18', PostDate = '2026-01-28 15:55:18', Status = 0, IAgree = 0

DELETE FROM `order_products` WHERE `OrderID` = 10114897

DELETE FROM `order_vouchers` WHERE `OrderID` = 10114897

DELETE FROM `gifts` WHERE `OrderID` = 10114897

SELECT `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'

SELECT
                `Basket`
            FROM
                `basket`
            WHERE
                `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND
                `Basket` LIKE '%d%'
            LIMIT 1
# [28-Jan-2026 15:55:18] /spisanie8/root/orders/confirm/10114897.html 108.61.209.243

set names utf8

SELECT `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' 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` = 899
                LIMIT 1

SELECT `PromoCode` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT `Voucher` FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114897
                AND `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `ProductsNum` = 1,
                    `AllProducts` = '[{"ID":899,"Title":"\\u0421\\u043f\\u0438\\u0441\\u0430\\u043d\\u0438\\u0435 8, \\u0431\\u0440\\u043e\\u0439 10\\/2024 \\u0433.","Qty":1,"Price":8,"PriceTotal":8}]'
                WHERE
                    `ID` = 10114897 AND
                    `Status` = 0
                LIMIT 1

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"TotalWeight":0.3,"TotalPrice":8}',
                                `TotalPrice` = 8
                            WHERE
                                `ID` = 10114897 AND
                                `Status` = 0
                            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1

SELECT
                `order_products`.`ProductID`,
                `products`.`Image`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                FLOOR(`magazines`.`IntDate` / 10000) AS `Year`
            FROM
                `order_products`
                INNER JOIN `products` ON `order_products`.`ProductID` = `products`.`ID`
                INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
            WHERE
                `order_products`.`OrderID` = 10114897 AND
                `order_products`.`Months` = 1 AND
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                `gifts`.`ProductID`,
                `products`.`Image`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                FLOOR(`magazines`.`IntDate` / 10000) AS `Year`
            FROM
                `gifts`
                INNER JOIN `products` ON `gifts`.`ProductID` = `products`.`ID`
                INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
            WHERE
                `gifts`.`OrderID` = 10114897 AND
                `gifts`.`UserID` = 13602 AND
                `gifts`.`GiftType` = 1 AND
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

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

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

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
# [28-Jan-2026 15:55:18] /spisanie8/root/ajax/orders/total/10114897.html?_=1769608525702 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114897
                AND `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1
