# [02-Feb-2026 06:59:08] /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` = 15 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
# [02-Feb-2026 06:59:11] /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
# [02-Feb-2026 06:59:15] /spisanie8/root/ajax/users/login.html?_=1770008363063 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` = 'df4ab14b02e0238bbae4eea156f78815' WHERE `ID` = 1
# [02-Feb-2026 06:59:15] /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` = 'df4ab14b02e0238bbae4eea156f78815'
                        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
# [02-Feb-2026 06:59:19] /spisanie8/root/admin/orders/list.html 108.61.209.243

set names utf8

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

SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`PostDate` DESC
                 LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
                    SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`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
# [02-Feb-2026 06:59:24] /spisanie8/root/ajax/banners/popup.html?_=1770008372038 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
# [02-Feb-2026 06:59:45] /spisanie8/root/ajax/orders/item/10114884.html?_=1770008392343 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114884
                
            LIMIT 1
# [02-Feb-2026 06:59:49] /spisanie8/root/ajax/orders/item/10114887.html?_=1770008396215 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114887
                
            LIMIT 1
# [02-Feb-2026 07:01:25] /spisanie8/root/admin/orders/list.html 108.61.209.243

set names utf8

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

SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`PostDate` DESC
                 LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
                    SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`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
# [02-Feb-2026 07:01:31] /spisanie8/root/ajax/orders/item/10121530.html?_=1770008498904 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10121530
                
            LIMIT 1
# [02-Feb-2026 07:03:17] /spisanie8/root/admin/orders/list.html 108.61.209.243

set names utf8

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

SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`PostDate` DESC
                 LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
                    SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`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
# [02-Feb-2026 07:03:20] /spisanie8/root/ajax/orders/item/10121533.html?_=1770008607562 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10121533
                
            LIMIT 1
# [02-Feb-2026 07:03:23] /spisanie8/root/ajax/orders/item/10121532.html?_=1770008611137 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10121532
                
            LIMIT 1
# [02-Feb-2026 07:03:25] /spisanie8/root/ajax/orders/item/10121533.html?_=1770008612921 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10121533
                
            LIMIT 1
# [02-Feb-2026 07:03:32] /spisanie8/root/ajax/orders/item/10121533.html?_=1770008619480 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10121533
                
            LIMIT 1
# [02-Feb-2026 07:06:42] /spisanie8/root/admin/orders/list.html 108.61.209.243

set names utf8

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

SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`PostDate` DESC
                 LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
                    SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`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
# [02-Feb-2026 07:08:26] /spisanie8/root/admin/orders/list.html 108.61.209.243

set names utf8

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

SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`PostDate` DESC
                 LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
                    SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`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
# [02-Feb-2026 07:09:40] /spisanie8/root/admin/orders/list.html 108.61.209.243

set names utf8

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

SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`PostDate` DESC
                 LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
                    SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`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
# [02-Feb-2026 07:11:08] /spisanie8/root/admin/users/account.html 108.61.209.243

set names utf8

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

SELECT * FROM users WHERE ID = 1 LIMIT 1

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

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

                UNION ALL

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

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

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

                UNION ALL

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

                UNION ALL

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [02-Feb-2026 07:11:10] /spisanie8/root/ajax/users/logout.html?_=1770009077482 108.61.209.243

set names utf8

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

UPDATE `users` SET `SecureKey` = '' WHERE `ID` = 1
# [02-Feb-2026 07:11:10] /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` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        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
# [02-Feb-2026 07:11:12] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '1' AND
                            `Access` = '2' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        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
# [02-Feb-2026 07:11:16] /spisanie8/root/ajax/users/login.html?_=1770009083244 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
# [02-Feb-2026 07:11:16] /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
# [02-Feb-2026 07:11:18] /spisanie8/root/ajax/basket/popup.html?_=1770009086040 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` = 821
                LIMIT 1

SELECT ID FROM `orders` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND `Status` = 0 LIMIT 1
# [02-Feb-2026 07:11:27] /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` = 821
                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
# [02-Feb-2026 07:12:34] /spisanie8/root/search.html?q=Любов, секс и пробуждане&x=0&y=0 108.61.209.243

set names utf8

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `products`.`Image`,
                `products`.`VideoURL`,
                `products`.`URLLabel`,
                `products`.`Visible`,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `products`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                (`products`.`Title` LIKE '%Любов, секс и пробуждане%' OR
                `products`.`Annotation` LIKE '%Любов, секс и пробуждане%' OR
                `products`.`Content` LIKE '%Любов, секс и пробуждане%')
                 AND `products`.`Visible` = 1
            ORDER BY
                CASE
                    WHEN `products`.`Title` LIKE 'Любов, секс и пробуждане%' THEN 0
                    WHEN `products`.`Annotation` LIKE 'Любов, секс и пробуждане%' THEN 1
                    ELSE 2
                END
         LIMIT 0, 100

SELECT
                `articles`.`ID`,
                `articles`.`IntDate`,
                `articles`.`PostDate`,
                `articles`.`Title`,
                `articles`.`Annotation`,
                `articles`.`Section`,
                `articles`.`Gallery`,
                `articles`.`VideoURL`,
                `articles`.`URLLabel`,
                `articles`.`Visible`,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `articles`
                INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
            WHERE
                (`articles`.`Title` LIKE '%Любов, секс и пробуждане%' OR
                `articles`.`Annotation` LIKE '%Любов, секс и пробуждане%' OR
                `articles`.`Content` LIKE '%Любов, секс и пробуждане%')
                 AND `articles`.`Visible` = 1
            ORDER BY
                CASE
                    WHEN `articles`.`Title` LIKE 'Любов, секс и пробуждане%' THEN 0
                    WHEN `articles`.`Annotation` LIKE 'Любов, секс и пробуждане%' THEN 1
                    ELSE 2
                END
         LIMIT 0, 100

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
# [02-Feb-2026 07:12:37] /spisanie8/root/книги/любов-секс-и-пробуждане.html 108.61.209.243

set names utf8

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

SELECT
                `products`.*,
                `groups`.`URLLabel` AS Section,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `products`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND `products`.`Visible` = 1  AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`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 `Months`, `Digital` FROM `subscriptions` WHERE `ProductID` = 1014 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`
        WHERE
            `products`.`ID` = 1014 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`
        WHERE
            `gifts`.`UserID` = 13602 AND
            `gifts`.`GiftType` IN (1,2) AND
            `products`.`ID` = 1014 AND
            `products`.`OnlinePrice` > 0 AND
            `products`.`Visible` = 1
        GROUP BY
            `products`.`ID`
        LIMIT 1

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'product' 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`,
                `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 `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
# [02-Feb-2026 07:12:48] /spisanie8/root/ajax/basket/update/popup.html?_=1770009175186 108.61.209.243

set names utf8

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

UPDATE `basket` SET `UpdateDate` = NOW(), `Basket` = '{"821":1,"1014":1}', `Num` = '2' WHERE `BasketID`= 'df4ab14b02e0238bbae4eea156f78815' LIMIT 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` = 821
                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` = 1014
                LIMIT 1

SELECT ID FROM `orders` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND `Status` = 0 LIMIT 1
# [02-Feb-2026 07:12:50] /spisanie8/root/ajax/basket/delete/popup.html?_=1770009177950 108.61.209.243

set names utf8

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

UPDATE `basket` SET `UpdateDate` = NOW(), `Basket` = '{"1014":1}', `Num` = '1' WHERE `BasketID`= 'df4ab14b02e0238bbae4eea156f78815' LIMIT 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` = 1014
                LIMIT 1

SELECT ID FROM `orders` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND `Status` = 0 LIMIT 1
# [02-Feb-2026 07:12:51] /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` = 1014
                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
# [02-Feb-2026 07:12:56] /spisanie8/root/ajax/delivery/store/form.html?_=1770009184112 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` = 1014 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
# [02-Feb-2026 07:13:02] /spisanie8/root/ajax/orders/submit.html?_=1770009189169 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 = 'Bank', BasketID = 'df4ab14b02e0238bbae4eea156f78815', LastUpdate = '2026-02-02 07:13:02', PostDate = '2026-02-02 07:13:02', Status = 0, IAgree = 0

DELETE FROM `order_products` WHERE `OrderID` = 10121534

DELETE FROM `order_vouchers` WHERE `OrderID` = 10121534

DELETE FROM `gifts` WHERE `OrderID` = 10121534

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

SELECT
                `Basket`
            FROM
                `basket`
            WHERE
                `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND
                `Basket` LIKE '%d%'
            LIMIT 1
# [02-Feb-2026 07:13:02] /spisanie8/root/orders/confirm/10121534.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` = 1014
                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` = 10121534
                AND `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `ProductsNum` = 1,
                    `AllProducts` = '[{"ID":1014,"Title":"\\u041b\\u044e\\u0431\\u043e\\u0432, \\u0441\\u0435\\u043a\\u0441 \\u0438 \\u043f\\u0440\\u043e\\u0431\\u0443\\u0436\\u0434\\u0430\\u043d\\u0435","Qty":1,"Price":12.27,"PriceTotal":12.27}]'
                WHERE
                    `ID` = 10121534 AND
                    `Status` = 0
                LIMIT 1

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"TotalWeight":0.25,"TotalPrice":12.27}',
                                `TotalPrice` = 12.27
                            WHERE
                                `ID` = 10121534 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` = 10121534 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` = 10121534 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
# [02-Feb-2026 07:13:02] /spisanie8/root/ajax/orders/total/10121534.html?_=1770009189638 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10121534
                AND `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1
# [02-Feb-2026 07:13:13] /spisanie8/root/orders/checkout/10121534.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` = 1014
                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` = 10121534
                AND `BasketID` = '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
# [02-Feb-2026 07:13:16] /spisanie8/root/ajax/delivery/store/form.html?_=1770009203375 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` = 1014 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
# [02-Feb-2026 07:13:19] /spisanie8/root/ajax/orders/submit/10121534.html?_=1770009206407 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`

UPDATE `orders` SET UserID = 13602, FullName = 'Hristo Davarski', EMail = 'davarski@gmail.com', Phone = '0885068345', TotalPrice = 0, DeliveryMethod = 'Store', DeliveryPrice = 0, PaymentMethod = 'Bank', LastUpdate = '2026-02-02 07:13:19' WHERE ID = '10121534'

DELETE FROM `order_products` WHERE `OrderID` = 10121534

DELETE FROM `order_vouchers` WHERE `OrderID` = 10121534

DELETE FROM `gifts` WHERE `OrderID` = 10121534

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

SELECT
                `Basket`
            FROM
                `basket`
            WHERE
                `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND
                `Basket` LIKE '%d%'
            LIMIT 1
# [02-Feb-2026 07:13:19] /spisanie8/root/orders/confirm/10121534.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` = 1014
                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` = 10121534
                AND `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `ProductsNum` = 1,
                    `AllProducts` = '[{"ID":1014,"Title":"\\u041b\\u044e\\u0431\\u043e\\u0432, \\u0441\\u0435\\u043a\\u0441 \\u0438 \\u043f\\u0440\\u043e\\u0431\\u0443\\u0436\\u0434\\u0430\\u043d\\u0435","Qty":1,"Price":12.27,"PriceTotal":12.27}]'
                WHERE
                    `ID` = 10121534 AND
                    `Status` = 0
                LIMIT 1

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"TotalWeight":0.25,"TotalPrice":12.27}',
                                `TotalPrice` = 12.27
                            WHERE
                                `ID` = 10121534 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` = 10121534 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` = 10121534 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
# [02-Feb-2026 07:13:19] /spisanie8/root/ajax/orders/total/10121534.html?_=1770009206731 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10121534
                AND `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1
# [02-Feb-2026 07:14:47] /spisanie8/root/orders/checkout/10121534.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` = 1014
                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` = 10121534
                AND `BasketID` = '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
# [02-Feb-2026 07:14:49] /spisanie8/root/ajax/delivery/econt/form.html?_=1770009296728 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 `Basket` FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

SELECT
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`ID` = 1014 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
# [02-Feb-2026 07:14:59] /spisanie8/root/ajax/orders/submit/10121534.html?_=1770009306372 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`

UPDATE `orders` SET UserID = 13602, FullName = 'Hristo Davarski', EMail = 'davarski@gmail.com', Phone = '0885068345', TotalPrice = 0, DeliveryMethod = 'Econt', DeliveryPrice = 0, PaymentMethod = 'Cash', DeliveryData = '{"DeliveryMethod":"Econt","DeliveryCountry":"България","DeliveryCity":"СОФИЯ","DeliveryCityID":"68134","DeliveryAddress":"ул. Зорница 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","CashOnDelivery":1}', LastUpdate = '2026-02-02 07:14:59' WHERE ID = '10121534'

DELETE FROM `order_products` WHERE `OrderID` = 10121534

DELETE FROM `order_vouchers` WHERE `OrderID` = 10121534

DELETE FROM `gifts` WHERE `OrderID` = 10121534

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

SELECT
                `Basket`
            FROM
                `basket`
            WHERE
                `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND
                `Basket` LIKE '%d%'
            LIMIT 1
# [02-Feb-2026 07:14:59] /spisanie8/root/orders/confirm/10121534.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` = 1014
                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` = 10121534
                AND `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `ProductsNum` = 1,
                    `AllProducts` = '[{"ID":1014,"Title":"\\u041b\\u044e\\u0431\\u043e\\u0432, \\u0441\\u0435\\u043a\\u0441 \\u0438 \\u043f\\u0440\\u043e\\u0431\\u0443\\u0436\\u0434\\u0430\\u043d\\u0435","Qty":1,"Price":12.27,"PriceTotal":12.27}]'
                WHERE
                    `ID` = 10121534 AND
                    `Status` = 0
                LIMIT 1

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"DeliveryMethod":"Econt","DeliveryCountry":"\\u0411\\u044a\\u043b\\u0433\\u0430\\u0440\\u0438\\u044f","DeliveryCity":"\\u0421\\u041e\\u0424\\u0418\\u042f","DeliveryCityID":"68134","DeliveryAddress":"\\u0443\\u043b. \\u0417\\u043e\\u0440\\u043d\\u0438\\u0446\\u0430 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","CashOnDelivery":1,"TotalWeight":0.25,"TotalPrice":12.27}',
                                `TotalPrice` = 12.27
                            WHERE
                                `ID` = 10121534 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` = 10121534 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` = 10121534 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
# [02-Feb-2026 07:14:59] /spisanie8/root/ajax/orders/total/10121534.html?_=1770009306731 108.61.209.243

set names utf8

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

UPDATE `orders` SET `DeliveryPrice` = '5.15' WHERE `ID` = 10121534
# [02-Feb-2026 07:15:10] /spisanie8/root/ajax/orders/confirm/10121534.html?_=1770009317853 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10121534 AND
                `BasketID` = '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` = 1014
                LIMIT 1

UPDATE
                    `orders`
                SET
                    `PostDate` = NOW(),
                    `LastUpdate` = NOW(),
                    `SendDate` = NOW(),
                    `IAgree` = 1,
                    `Status` = 1
                WHERE
                    `ID` = 10121534 AND
                    `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND
                    `Status` = 0

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10121534 AND
                `Status` & 2 = 0
            LIMIT 1

SELECT
                `FullName`,
                `EMail`
            FROM
                `users`
            WHERE
                `Access` & 2 AND
                `Settings` & 2

UPDATE `orders` SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 2
                WHERE `ID` = 10121534

SELECT
                    `BasketID`
                FROM
                    `orders`
                WHERE
                    `ID` = 10121534
                LIMIT 1

UPDATE `orders` SET
                `LastUpdate` = NOW(),
                `BasketID` = ''
            WHERE `ID` = 10121534

DELETE FROM `basket` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815';

DELETE FROM `guests` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'

DELETE FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
# [02-Feb-2026 07:15:11] /spisanie8/root/orders/success/10121534.html 108.61.209.243

set names utf8

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
# [02-Feb-2026 07:15:16] /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
# [02-Feb-2026 07:15:18] /spisanie8/root/ajax/users/logout.html?_=1770009325722 108.61.209.243

set names utf8

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

UPDATE `users` SET `SecureKey` = '' WHERE `ID` = 13602
# [02-Feb-2026 07:15:18] /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` = 15 LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        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
# [02-Feb-2026 07:15:19] /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
                `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
# [02-Feb-2026 07:15:23] /spisanie8/root/ajax/users/login.html?_=1770009330932 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` = 'df4ab14b02e0238bbae4eea156f78815' WHERE `ID` = 1
# [02-Feb-2026 07:15:23] /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` = 'df4ab14b02e0238bbae4eea156f78815'
                        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
# [02-Feb-2026 07:15:27] /spisanie8/root/admin/orders/list.html 108.61.209.243

set names utf8

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

SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`PostDate` DESC
                 LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (
                    SELECT
                        `orders`.*,
                        `order_vouchers`.`ProductID` AS `Voucher`,
                        `promocodes`.`PromoCode`,
                        `promocode_orders`.`Amount` AS `PromoCodeAmount`,
                        `vouchers`.`VoucherCode`,
                        `voucher_orders`.`Amount` AS `VoucherAmount`,
                        IF(`patreon`.`EMail` IS NULL, 0, 1) AS `Patreon`
                    FROM
                        `orders`
                        LEFT JOIN `order_vouchers` ON `orders`.`ID` = `order_vouchers`.`OrderID`
                        LEFT JOIN `promocode_orders` ON `orders`.`ID` = `promocode_orders`.`OrderID`
                        LEFT JOIN `promocodes` ON `promocode_orders`.`PromoCodeID` = `promocodes`.`ID`
                        LEFT JOIN `voucher_orders` ON `orders`.`ID` = `voucher_orders`.`OrderID`
                        LEFT JOIN `vouchers` ON `voucher_orders`.`VoucherID` = `vouchers`.`ID`
                        LEFT JOIN `patreon` ON `orders`.`EMail` = `patreon`.`EMail`
                    WHERE
                        `Status` > 0
                        
                    ORDER BY  `orders`.`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
