# [14-Aug-2025 07:00:41] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`PostDate` DESC

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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

SELECT
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `products`.`Price`,
                    `products`.`PromoPrice`,
                    `products`.`OnlinePrice`,
                    `products`.`PromoOnlinePrice`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' LIMIT 1

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 32 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 100

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'абонамент'
                LIMIT 1

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`Visible`,
                `subscriptions`.`IntDate`,
                `subscriptions`.`Months`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`,
                `subscriptions`.`Digital`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `subscriptions` ON `products`.`ID` = `subscriptions`.`ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `groups`.`URLLabel` = 'абонамент' AND
                `products`.`Visible` = 1 AND
                `subscriptions`.`InIndex` = 1
            GROUP BY
                `products`.`ID`
            ORDER BY
                `subscriptions`.`Months` DESC,
                `products`.`PostDate` DESC

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [14-Aug-2025 07:00:43] /spisanie8/root/ajax/basket/popup.html?_=1755144043094 108.61.209.243

set names utf8

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

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

SELECT ID FROM `orders` WHERE `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' AND `Status` = 0 LIMIT 1
# [14-Aug-2025 07:00:44] /spisanie8/root/orders/checkout/10114889.html 108.61.209.243

set names utf8

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [14-Aug-2025 07:00:46] /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
# [14-Aug-2025 07:00:48] /spisanie8/root/ajax/users/login.html?_=1755144048757 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` = 'ca57e134020b3d05a5bee40354a5c7be' WHERE `ID` = 13602
# [14-Aug-2025 07:00:48] /spisanie8/root/orders/checkout/10114889.html 108.61.209.243

set names utf8

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

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

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

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

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

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114889
                AND `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            LIMIT 1

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

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

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            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
# [14-Aug-2025 07:01:22] /spisanie8/root/ajax/orders/submit/10114889.html?_=1755144082448 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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 = 'Speedy', DeliveryPrice = 0, PaymentMethod = 'Cash', DeliveryData = '{"DeliveryMethod":"Speedy","DeliveryCountry":"България","DeliveryCity":"София","DeliveryCityID":68134,"DeliveryAddress":"ул. Зорница 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","CashOnDelivery":1}', LastUpdate = '2025-08-14 07:01:22' WHERE ID = '10114889'

DELETE FROM `order_products` WHERE `OrderID` = 10114889

DELETE FROM `order_vouchers` WHERE `OrderID` = 10114889

DELETE FROM `gifts` WHERE `OrderID` = 10114889

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

SELECT
                `Basket`
            FROM
                `basket`
            WHERE
                `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' AND
                `Basket` LIKE '%d%'
            LIMIT 1
# [14-Aug-2025 07:01:22] /spisanie8/root/orders/confirm/10114889.html 108.61.209.243

set names utf8

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

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

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

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

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114889
                AND `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            LIMIT 1

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

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"DeliveryMethod":"Speedy","DeliveryCountry":"\\u0411\\u044a\\u043b\\u0433\\u0430\\u0440\\u0438\\u044f","DeliveryCity":"\\u0421\\u043e\\u0444\\u0438\\u044f","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.21,"TotalPrice":4}',
                                `TotalPrice` = 4
                            WHERE
                                `ID` = 10114889 AND
                                `Status` = 0
                            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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` = 10114889 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` = 10114889 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
# [14-Aug-2025 07:01:22] /spisanie8/root/ajax/orders/total/10114889.html?_=1755144082946 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114889
                AND `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            LIMIT 1

UPDATE `orders` SET `DeliveryPrice` = '12.66' WHERE `ID` = 10114889
# [14-Aug-2025 07:01:41] /spisanie8/root/ajax/orders/confirm/10114889.html?_=1755144101782 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114889 AND
                `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            LIMIT 1

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

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

UPDATE
                    `orders`
                SET
                    `PostDate` = NOW(),
                    `LastUpdate` = NOW(),
                    `SendDate` = NOW(),
                    `IAgree` = 1,
                    `Status` = 1
                WHERE
                    `ID` = 10114889 AND
                    `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' AND
                    `Status` = 0
# [14-Aug-2025 07:02:11] /spisanie8/root/orders/confirm/10114889.html 108.61.209.243

set names utf8

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

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

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

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

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114889
                AND `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            LIMIT 1

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

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"DeliveryMethod":"Speedy","DeliveryCountry":"\\u0411\\u044a\\u043b\\u0433\\u0430\\u0440\\u0438\\u044f","DeliveryCity":"\\u0421\\u043e\\u0444\\u0438\\u044f","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.21,"TotalPrice":4}',
                                `TotalPrice` = 4
                            WHERE
                                `ID` = 10114889 AND
                                `Status` = 0
                            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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` = 10114889 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` = 10114889 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
# [14-Aug-2025 07:02:11] /spisanie8/root/ajax/orders/total/10114889.html?_=1755144131761 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114889
                AND `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            LIMIT 1

UPDATE `orders` SET `DeliveryPrice` = '12.66' WHERE `ID` = 10114889
# [14-Aug-2025 07:02:17] /spisanie8/root/ajax/orders/confirm/10114889.html?_=1755144137254 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114889 AND
                `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            LIMIT 1

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

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

UPDATE
                    `orders`
                SET
                    `PostDate` = NOW(),
                    `LastUpdate` = NOW(),
                    `SendDate` = NOW(),
                    `IAgree` = 1,
                    `Status` = 1
                WHERE
                    `ID` = 10114889 AND
                    `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' AND
                    `Status` = 0
# [14-Aug-2025 07:03:31] /spisanie8/root/orders/confirm/10114889.html 108.61.209.243

set names utf8

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

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

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

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

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114889
                AND `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            LIMIT 1

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

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"DeliveryMethod":"Speedy","DeliveryCountry":"\\u0411\\u044a\\u043b\\u0433\\u0430\\u0440\\u0438\\u044f","DeliveryCity":"\\u0421\\u043e\\u0444\\u0438\\u044f","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.21,"TotalPrice":4}',
                                `TotalPrice` = 4
                            WHERE
                                `ID` = 10114889 AND
                                `Status` = 0
                            LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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` = 10114889 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` = 10114889 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
# [14-Aug-2025 07:03:31] /spisanie8/root/ajax/orders/total/10114889.html?_=1755144211840 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114889
                AND `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            LIMIT 1

UPDATE `orders` SET `DeliveryPrice` = '12.66' WHERE `ID` = 10114889
# [14-Aug-2025 07:03:33] /spisanie8/root/ajax/orders/confirm/10114889.html?_=1755144213854 108.61.209.243

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114889 AND
                `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            LIMIT 1

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

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

UPDATE
                    `orders`
                SET
                    `PostDate` = NOW(),
                    `LastUpdate` = NOW(),
                    `SendDate` = NOW(),
                    `IAgree` = 1,
                    `Status` = 1
                WHERE
                    `ID` = 10114889 AND
                    `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' AND
                    `Status` = 0
# [14-Aug-2025 07:05:08] /spisanie8/root/списание-8-на-живо-духовните-водачи-на-българия-билет.html 108.61.209.243

set names utf8

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'списание-8-на-живо-духовните-водачи-на-българия-билет'
                LIMIT 1

SELECT
                    `ID`,
                    `URLLabel`,
                    `MetaTitle`,
                    `MetaDescription`,
                    `Title`,
                    `Annotation`,
                    `Image`,
                    `Module`
                FROM
                    `groups`
                WHERE
                    `URLLabel` = 'списание-8-на-живо-духовните-водачи-на-българия-билет'
                LIMIT 1

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Image`,
                `products`.`Gallery`,
                `products`.`URLLabel`,
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
                INNER JOIN `groups` ON `products`.`GroupID` = `groups`.`ID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `groups`.`URLLabel` = 'списание-8-на-живо-духовните-водачи-на-българия-билет' AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' LIMIT 1

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

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

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

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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
# [14-Aug-2025 07:05:43] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`PostDate` DESC

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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

SELECT
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `products`.`Price`,
                    `products`.`PromoPrice`,
                    `products`.`OnlinePrice`,
                    `products`.`PromoOnlinePrice`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' 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
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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
# [14-Aug-2025 07:05:48] /spisanie8/root/списание/списание-8-брой-112009-г.html 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'magazine'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`PostDate` DESC

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

SELECT `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
# [14-Aug-2025 07:13:54] /spisanie8/root/списание/списание-8-брой-112009-г.html 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'magazine'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`PostDate` DESC

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

SELECT `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
# [14-Aug-2025 07:14:08] /spisanie8/root/списание/списание-8-брой-112009-г.html 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'magazine'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`PostDate` DESC

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

SELECT `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
# [14-Aug-2025 07:14:44] /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

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

SELECT `Months`, `Digital` FROM `subscriptions` WHERE `ProductID` = 903 LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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` = 903 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` = 903 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 `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
# [14-Aug-2025 07:15:37] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`PostDate` DESC

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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

SELECT
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `products`.`Price`,
                    `products`.`PromoPrice`,
                    `products`.`OnlinePrice`,
                    `products`.`PromoOnlinePrice`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' 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
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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
# [14-Aug-2025 07:16:50] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`PostDate` DESC

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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

SELECT
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `products`.`Price`,
                    `products`.`PromoPrice`,
                    `products`.`OnlinePrice`,
                    `products`.`PromoOnlinePrice`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' 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
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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
# [14-Aug-2025 07:23:15] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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
# [14-Aug-2025 07:23:20] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`PostDate` DESC

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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

SELECT
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `products`.`Price`,
                    `products`.`PromoPrice`,
                    `products`.`OnlinePrice`,
                    `products`.`PromoOnlinePrice`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' 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
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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
# [14-Aug-2025 07:24:18] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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
# [14-Aug-2025 07:24:21] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

SELECT
                *
	        FROM
	        	`blocks`
                INNER JOIN `block_position` ON `blocks`.`ID` = `block_position`.`BlockID`
	    	WHERE
                `block_position`.`Position` = 'homepage'
         AND `blocks`.`Visible` = 1 ORDER BY `blocks`.`PostDate` DESC

SELECT
                `products`.`ID`,
                `products`.`PostDate`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Annotation`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE 1
                 AND `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1
                AND (`products`.`Title` LIKE '%11/2009%' OR `products`.`Title` LIKE '%11/2010%' OR `products`.`Title` LIKE '%11/2011%')
            ORDER BY
                `products`.`PostDate` DESC

SELECT
                    `articles`.`ID`,
                    `articles`.`IntDate`,
                    `articles`.`PostDate`,
                    `articles`.`Title`,
                    `articles`.`Annotation`,
                    `articles`.`Section`,
                    `articles`.`Gallery`,
                    `articles`.`VideoURL`,
                    `articles`.`URLLabel`,
                    `articles`.`Featured`,
                    `articles`.`OnlineSub`,
                    `articles`.`Visible`,
                    `groups`.`MenuLabel` AS GroupLabel,
                    `groups`.`URLLabel` AS GroupURLLabel
                FROM
                    `articles`
                    INNER JOIN `groups` ON `groups`.`ID` = `articles`.`GroupID`
                    INNER JOIN `block_articles` ON `block_articles`.`ArticleID` = `articles`.`ID`
                WHERE
                    `block_articles`.`BlockID` = 39 AND
                    `articles`.`Gallery` != '' AND
                    `articles`.`PostDate` <= NOW()
                     AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 10

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

SELECT
                    `products`.`ID`,
                    `products`.`PostDate`,
                    `products`.`Title`,
                    `products`.`Annotation`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`URLLabel`,
                    `products`.`Price`,
                    `products`.`PromoPrice`,
                    `products`.`OnlinePrice`,
                    `products`.`PromoOnlinePrice`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                    LEFT JOIN `block_products` ON
                        `block_products`.`BlockID` = 31 AND
                        `block_products`.`ProductID` = `products`.`ID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
`products`.`Visible` = 1 AND
                    (
                        `block_products`.`ProductID` IS NOT NULL
                         OR `products`.`Featured` = 1
                    )
                ORDER BY
                    `products`.`PostDate` DESC
             LIMIT 100

SELECT `Favorites` FROM `favorites` WHERE `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' 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
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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
# [14-Aug-2025 07:24:25] /spisanie8/root/книги/дневниците-ни-със-слава-севрюкова-книга-3.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` = 'дневниците-ни-със-слава-севрюкова-книга-3'
            LIMIT 1

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

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

SELECT `Months`, `Digital` FROM `subscriptions` WHERE `ProductID` = 896 LIMIT 1

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'ca57e134020b3d05a5bee40354a5c7be'
                        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` = 896 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` = 896 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 `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
# [14-Aug-2025 07:24:26] /spisanie8/root/ajax/basket/update/popup.html?_=1755145466914 108.61.209.243

set names utf8

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

UPDATE `basket` SET `UpdateDate` = NOW(), `Basket` = '{"46":1,"896":1}', `Num` = '2' WHERE `BasketID`= 'ca57e134020b3d05a5bee40354a5c7be' LIMIT 1

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

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

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

SELECT
                    `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` = 896
                LIMIT 1

SELECT ID FROM `orders` WHERE `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be' AND `Status` = 0 LIMIT 1
# [14-Aug-2025 07:24:28] /spisanie8/root/orders/checkout/10114890.html 108.61.209.243

set names utf8

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

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

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

SELECT
                    `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` = 896
                LIMIT 1

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

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

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 10114890
                AND `BasketID` = 'ca57e134020b3d05a5bee40354a5c7be'
            LIMIT 1

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

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

SELECT
                `products`.`Price`,
                `products`.`PromoPrice`,
                `products`.`OnlinePrice`,
                `products`.`PromoOnlinePrice`
            FROM
                `products`
            WHERE
                `products`.`ID` = 896 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` = 'ca57e134020b3d05a5bee40354a5c7be'
            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
