# [31-Jan-2026 17:38:46] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 17:38:52] /spisanie8/root/ajax/banners/popup.html?_=1769873939134 108.61.209.243

set names utf8

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 12 LIMIT 1
# [31-Jan-2026 17:44:24] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 17:46:35] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 17:58:19] /spisanie8/root/книги/петър-дънов-за-пътя-на-човешката-душа.html 108.61.209.243

set names utf8

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

SELECT
                `products`.*,
                `groups`.`URLLabel` AS Section,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `products`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND `products`.`Visible` = 1  AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`URLLabel` = 'петър-дънов-за-пътя-на-човешката-душа'
            LIMIT 1

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

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

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

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:02:08] /spisanie8/root/книги/петър-дънов-за-пътя-на-човешката-душа.html 108.61.209.243

set names utf8

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

SELECT
                `products`.*,
                `groups`.`URLLabel` AS Section,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `products`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND `products`.`Visible` = 1  AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`URLLabel` = 'петър-дънов-за-пътя-на-човешката-душа'
            LIMIT 1

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

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

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

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

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

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

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

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

SELECT
                `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
# [31-Jan-2026 18:04:13] /spisanie8/root/книги/петър-дънов-за-пътя-на-човешката-душа.html 108.61.209.243

set names utf8

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

SELECT
                `products`.*,
                `groups`.`URLLabel` AS Section,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `products`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND `products`.`Visible` = 1  AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`URLLabel` = 'петър-дънов-за-пътя-на-човешката-душа'
            LIMIT 1

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

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

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

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

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

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

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

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

SELECT
                `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
# [31-Jan-2026 18:04:48] /spisanie8/root/ajax/basket/update/popup.html?_=1769875495199 108.61.209.243

set names utf8

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

UPDATE `basket` SET `UpdateDate` = NOW(), `Basket` = '{"899":1,"903":1}', `Num` = '2' WHERE `BasketID`= 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

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

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

SELECT
                    `products`.`ID`,
                    `products`.`URLLabel`,
                    `products`.`Title`,
                    `products`.`Price`,
                    `products`.`PromoPrice`,
                    `products`.`OnlinePrice`,
                    `products`.`PromoOnlinePrice`,
                    `products`.`Image`,
                    `products`.`Gallery`,
                    `products`.`Weight`,
                    `groups`.`URLLabel` AS `GroupURLLabel`
                FROM
                    `products`
                    INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
                WHERE
                    `products`.`PostDate` <= NOW() AND
                    `products`.`ID` = 899
                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` = 903
                LIMIT 1

SELECT ID FROM `orders` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND `Status` = 0 LIMIT 1
# [31-Jan-2026 18:04:58] /spisanie8/root/orders/checkout/10114897.html 108.61.209.243

set names utf8

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

SELECT
                `Browser`,
                `IP`,
                `GA`
            FROM
                guests
            WHERE
                BasketID = 'df4ab14b02e0238bbae4eea156f78815' 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
# [31-Jan-2026 18:05:51] /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
# [31-Jan-2026 18:05:56] /spisanie8/root/ajax/users/login.html?_=1769875563046 108.61.209.243

set names utf8

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

UPDATE `users` SET `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815' WHERE `ID` = 13602
# [31-Jan-2026 18:05:56] /spisanie8/root/orders/checkout/10114897.html 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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
# [31-Jan-2026 18:06:04] /spisanie8/root/ajax/delivery/econt/form.html?_=1769875571540 108.61.209.243

set names utf8

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

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

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

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1
# [31-Jan-2026 18:06:24] /spisanie8/root/ajax/basket/delete/checkout.html?_=1769875591346 108.61.209.243

set names utf8

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

UPDATE `basket` SET `UpdateDate` = NOW(), `Basket` = '{"903":1}', `Num` = '1' WHERE `BasketID`= 'df4ab14b02e0238bbae4eea156f78815' LIMIT 1

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

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

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

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

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

SELECT
                            `Access`
                        FROM
                            `users`
                        WHERE
                            `ID` = '13602' AND
                            `Access` = '1' AND
                            `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815'
                        LIMIT 1
# [31-Jan-2026 18:06:24] /spisanie8/root/orders/checkout/10114897.html 108.61.209.243

set names utf8

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

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

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

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

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

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

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
# [31-Jan-2026 18:06:31] /spisanie8/root/orders/checkout/10114897.html 108.61.209.243

set names utf8

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

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

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

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

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

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

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
# [31-Jan-2026 18:06:34] /spisanie8/root/orders/checkout/10114897.html 108.61.209.243

set names utf8

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

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

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

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

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

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

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
# [31-Jan-2026 18:06:35] /spisanie8/root/ajax/delivery/econt/form.html?_=1769875602467 108.61.209.243

set names utf8

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

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1
# [31-Jan-2026 18:06:50] /spisanie8/root/ajax/orders/submit/10114897.html?_=1769875616924 108.61.209.243

set names utf8

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

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

DELETE FROM `order_products` WHERE `OrderID` = 10114897

DELETE FROM `order_vouchers` WHERE `OrderID` = 10114897

DELETE FROM `gifts` WHERE `OrderID` = 10114897

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

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

set names utf8

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

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

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

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

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `ProductsNum` = 1,
                    `AllProducts` = '[{"ID":903,"Title":"\\u0417\\u0430 \\u043f\\u044a\\u0442\\u044f \\u043d\\u0430 \\u0447\\u043e\\u0432\\u0435\\u0448\\u043a\\u0430\\u0442\\u0430 \\u0434\\u0443\\u0448\\u0430","Qty":1,"Price":5.08,"PriceTotal":5.08}]'
                WHERE
                    `ID` = 10114897 AND
                    `Status` = 0
                LIMIT 1

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"DeliveryMethod":"Econt","DeliveryCountry":"\\u0411\\u044a\\u043b\\u0433\\u0430\\u0440\\u0438\\u044f","DeliveryCity":"\\u0421\\u041e\\u0424\\u0418\\u042f","DeliveryCityID":"68134","DeliveryAddress":"\\u0443\\u043b. \\u0417\\u043e\\u0440\\u043d\\u0438\\u0446\\u0430 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","TotalWeight":0.2,"TotalPrice":5.08}',
                                `TotalPrice` = 5.08
                            WHERE
                                `ID` = 10114897 AND
                                `Status` = 0
                            LIMIT 1

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:06:50] /spisanie8/root/ajax/orders/total/10114897.html?_=1769875617309 108.61.209.243

set names utf8

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

UPDATE `orders` SET `DeliveryPrice` = '9.5640087' WHERE `ID` = 10114897
# [31-Jan-2026 18:08:06] /spisanie8/root/ajax/orders/confirm/10114897.html?_=1769875693156 108.61.209.243

set names utf8

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

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

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

UPDATE
                    `orders`
                SET
                    `PostDate` = NOW(),
                    `LastUpdate` = NOW(),
                    `SendDate` = NOW(),
                    `IAgree` = 1,
                    `Status` = 1
                WHERE
                    `ID` = 10114897 AND
                    `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND
                    `Status` = 0
# [31-Jan-2026 18:11:21] /spisanie8/root/orders/confirm/10114897.html 108.61.209.243

set names utf8

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

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

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

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

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `ProductsNum` = 1,
                    `AllProducts` = '[{"ID":903,"Title":"\\u0417\\u0430 \\u043f\\u044a\\u0442\\u044f \\u043d\\u0430 \\u0447\\u043e\\u0432\\u0435\\u0448\\u043a\\u0430\\u0442\\u0430 \\u0434\\u0443\\u0448\\u0430","Qty":1,"Price":5.08,"PriceTotal":5.08}]'
                WHERE
                    `ID` = 10114897 AND
                    `Status` = 0
                LIMIT 1

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"DeliveryMethod":"Econt","DeliveryCountry":"\\u0411\\u044a\\u043b\\u0433\\u0430\\u0440\\u0438\\u044f","DeliveryCity":"\\u0421\\u041e\\u0424\\u0418\\u042f","DeliveryCityID":"68134","DeliveryAddress":"\\u0443\\u043b. \\u0417\\u043e\\u0440\\u043d\\u0438\\u0446\\u0430 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","TotalWeight":0.2,"TotalPrice":5.08}',
                                `TotalPrice` = 5.08
                            WHERE
                                `ID` = 10114897 AND
                                `Status` = 0
                            LIMIT 1

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:11:22] /spisanie8/root/ajax/orders/total/10114897.html?_=1769875888738 108.61.209.243

set names utf8

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

UPDATE `orders` SET `DeliveryPrice` = '9.5640087' WHERE `ID` = 10114897
# [31-Jan-2026 18:12:34] /spisanie8/root/orders/confirm/10114897.html 108.61.209.243

set names utf8

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

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

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

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

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `ProductsNum` = 1,
                    `AllProducts` = '[{"ID":903,"Title":"\\u0417\\u0430 \\u043f\\u044a\\u0442\\u044f \\u043d\\u0430 \\u0447\\u043e\\u0432\\u0435\\u0448\\u043a\\u0430\\u0442\\u0430 \\u0434\\u0443\\u0448\\u0430","Qty":1,"Price":5.08,"PriceTotal":5.08}]'
                WHERE
                    `ID` = 10114897 AND
                    `Status` = 0
                LIMIT 1

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"DeliveryMethod":"Econt","DeliveryCountry":"\\u0411\\u044a\\u043b\\u0433\\u0430\\u0440\\u0438\\u044f","DeliveryCity":"\\u0421\\u041e\\u0424\\u0418\\u042f","DeliveryCityID":"68134","DeliveryAddress":"\\u0443\\u043b. \\u0417\\u043e\\u0440\\u043d\\u0438\\u0446\\u0430 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","TotalWeight":0.2,"TotalPrice":5.08}',
                                `TotalPrice` = 5.08
                            WHERE
                                `ID` = 10114897 AND
                                `Status` = 0
                            LIMIT 1

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:12:34] /spisanie8/root/ajax/orders/total/10114897.html?_=1769875961100 108.61.209.243

set names utf8

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

UPDATE `orders` SET `DeliveryPrice` = '9.5640087' WHERE `ID` = 10114897
# [31-Jan-2026 18:12:47] /spisanie8/root/ajax/orders/confirm/10114897.html?_=1769875974333 108.61.209.243

set names utf8

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

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

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

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

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

SELECT
                `FullName`,
                `EMail`
            FROM
                `users`
            WHERE
                `Access` & 2 AND
                `Settings` & 2
# [31-Jan-2026 18:12:55] /spisanie8/root/orders/confirm/10114897.html 108.61.209.243

set names utf8

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

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

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

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

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `ProductsNum` = 1,
                    `AllProducts` = '[{"ID":903,"Title":"\\u0417\\u0430 \\u043f\\u044a\\u0442\\u044f \\u043d\\u0430 \\u0447\\u043e\\u0432\\u0435\\u0448\\u043a\\u0430\\u0442\\u0430 \\u0434\\u0443\\u0448\\u0430","Qty":1,"Price":5.08,"PriceTotal":5.08}]'
                WHERE
                    `ID` = 10114897 AND
                    `Status` = 0
                LIMIT 1

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"DeliveryMethod":"Econt","DeliveryCountry":"\\u0411\\u044a\\u043b\\u0433\\u0430\\u0440\\u0438\\u044f","DeliveryCity":"\\u0421\\u041e\\u0424\\u0418\\u042f","DeliveryCityID":"68134","DeliveryAddress":"\\u0443\\u043b. \\u0417\\u043e\\u0440\\u043d\\u0438\\u0446\\u0430 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","TotalWeight":0.2,"TotalPrice":5.08}',
                                `TotalPrice` = 5.08
                            WHERE
                                `ID` = 10114897 AND
                                `Status` = 0
                            LIMIT 1

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:12:55] /spisanie8/root/ajax/orders/total/10114897.html?_=1769875982104 108.61.209.243

set names utf8

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

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

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

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

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

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

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

UPDATE `orders` SET `DeliveryPrice` = '9.5640087' WHERE `ID` = 10114897
# [31-Jan-2026 18:13:06] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT `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
# [31-Jan-2026 18:13:13] /spisanie8/root/книги/петър-дънов-за-пътя-на-човешката-душа.html 108.61.209.243

set names utf8

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

SELECT
                `products`.*,
                `groups`.`URLLabel` AS Section,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `products`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND `products`.`Visible` = 1  AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`URLLabel` = 'петър-дънов-за-пътя-на-човешката-душа'
            LIMIT 1

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

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

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

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

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

SELECT
            `orders`.`ID`
        FROM
            `orders`
            INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
            INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
        WHERE
            `products`.`ID` = 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
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` = '0000-00-00') AND
                `Section` = 6 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:13:15] /spisanie8/root/ajax/basket/update/popup.html?_=1769876001934 108.61.209.243

set names utf8

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

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

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

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

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

SELECT ID FROM `orders` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND `Status` = 0 LIMIT 1
# [31-Jan-2026 18:13:17] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

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

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

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

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

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

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:13:20] /spisanie8/root/ajax/delivery/econt/form.html?_=1769876007259 108.61.209.243

set names utf8

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

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1
# [31-Jan-2026 18:13:36] /spisanie8/root/ajax/orders/submit.html?_=1769876022690 108.61.209.243

set names utf8

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET UserID = 13602, FullName = 'Hristo Davarski', EMail = 'davarski@gmail.com', Phone = '0885068345', TotalPrice = 0, DeliveryMethod = 'Econt', DeliveryPrice = 0, PaymentMethod = 'Cash', DeliveryData = '{"DeliveryMethod":"Econt","DeliveryCountry":"България","DeliveryCity":"СОФИЯ","DeliveryCityID":"68134","DeliveryAddress":"ул. Зорница 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","CashOnDelivery":1}', BasketID = 'df4ab14b02e0238bbae4eea156f78815', LastUpdate = '2026-01-31 18:13:36', PostDate = '2026-01-31 18:13:36', Status = 0, IAgree = 0

DELETE FROM `order_products` WHERE `OrderID` = 10114898

DELETE FROM `order_vouchers` WHERE `OrderID` = 10114898

DELETE FROM `gifts` WHERE `OrderID` = 10114898

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

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

set names utf8

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

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

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

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

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `ProductsNum` = 1,
                    `AllProducts` = '[{"ID":903,"Title":"\\u0417\\u0430 \\u043f\\u044a\\u0442\\u044f \\u043d\\u0430 \\u0447\\u043e\\u0432\\u0435\\u0448\\u043a\\u0430\\u0442\\u0430 \\u0434\\u0443\\u0448\\u0430","Qty":1,"Price":5.08,"PriceTotal":5.08}]'
                WHERE
                    `ID` = 10114898 AND
                    `Status` = 0
                LIMIT 1

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"DeliveryMethod":"Econt","DeliveryCountry":"\\u0411\\u044a\\u043b\\u0433\\u0430\\u0440\\u0438\\u044f","DeliveryCity":"\\u0421\\u041e\\u0424\\u0418\\u042f","DeliveryCityID":"68134","DeliveryAddress":"\\u0443\\u043b. \\u0417\\u043e\\u0440\\u043d\\u0438\\u0446\\u0430 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","CashOnDelivery":1,"TotalWeight":0.2,"TotalPrice":5.08}',
                                `TotalPrice` = 5.08
                            WHERE
                                `ID` = 10114898 AND
                                `Status` = 0
                            LIMIT 1

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

SELECT
                `order_products`.`ProductID`,
                `products`.`Image`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                FLOOR(`magazines`.`IntDate` / 10000) AS `Year`
            FROM
                `order_products`
                INNER JOIN `products` ON `order_products`.`ProductID` = `products`.`ID`
                INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
            WHERE
                `order_products`.`OrderID` = 10114898 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` = 10114898 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
# [31-Jan-2026 18:13:36] /spisanie8/root/ajax/orders/total/10114898.html?_=1769876022994 108.61.209.243

set names utf8

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

UPDATE `orders` SET `DeliveryPrice` = '9.5248921' WHERE `ID` = 10114898
# [31-Jan-2026 18:13:47] /spisanie8/root/ajax/orders/confirm/10114898.html?_=1769876033867 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

DELETE FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
# [31-Jan-2026 18:13:48] /spisanie8/root/orders/success/10114898.html 108.61.209.243

set names utf8

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:14:00] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:14:01] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

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

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

                UNION ALL

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

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

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

                UNION ALL

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

                UNION ALL

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:14:03] /spisanie8/root/ajax/users/logout.html?_=1769876050589 108.61.209.243

set names utf8

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

UPDATE `users` SET `SecureKey` = '' WHERE `ID` = 13602
# [31-Jan-2026 18:14:04] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `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
# [31-Jan-2026 18:14:04] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:14:18] /spisanie8/root/ajax/users/login.html?_=1769876064667 108.61.209.243

set names utf8

SELECT
                `ID`,
                `FullName`,
                `Password`,
                `Access`,
                `SecureKey`
            FROM
                `users`
            WHERE
                `EMail` = 'maxgraphic' OR `UserName` = 'maxgraphic'
            LIMIT 1

UPDATE `users` SET `SecureKey` = 'df4ab14b02e0238bbae4eea156f78815' WHERE `ID` = 1
# [31-Jan-2026 18:14:18] /spisanie8/root/admin/articles/list.html 108.61.209.243

set names utf8

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

SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
         LIMIT 0, 30

SELECT COUNT(*) AS NumRows FROM (SELECT
               *,
                `articles`.`PostDate` > NOW() AS Upcomming
            FROM
                `articles`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
        ) AS CountTable

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:14:23] /spisanie8/root/admin/orders/list.html 108.61.209.243

set names utf8

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:15:48] /spisanie8/root/admin/users/account.html 108.61.209.243

set names utf8

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

SELECT * FROM users WHERE ID = 1 LIMIT 1

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

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

                UNION ALL

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

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

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

                UNION ALL

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

                UNION ALL

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:15:50] /spisanie8/root/ajax/users/logout.html?_=1769876156922 108.61.209.243

set names utf8

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

UPDATE `users` SET `SecureKey` = '' WHERE `ID` = 1
# [31-Jan-2026 18:15: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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:15:52] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:15:56] /spisanie8/root/ajax/users/login.html?_=1769876163254 108.61.209.243

set names utf8

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

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

set names utf8

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

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

                UNION ALL

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

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

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

                UNION ALL

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

                UNION ALL

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:15:59] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT `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
# [31-Jan-2026 18:16:02] /spisanie8/root/книги/нишка.html 108.61.209.243

set names utf8

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

SELECT
                `products`.*,
                `groups`.`URLLabel` AS Section,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `products`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND `products`.`Visible` = 1  AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`URLLabel` = 'нишка'
            LIMIT 1

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

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

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

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

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

SELECT
            `orders`.`ID`
        FROM
            `orders`
            INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
            INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
        WHERE
            `products`.`ID` = 880 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` = 880 AND
            `products`.`OnlinePrice` > 0 AND
            `products`.`Visible` = 1
        GROUP BY
            `products`.`ID`
        LIMIT 1

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

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:16:10] /spisanie8/root/книги/новата-медицина.html 108.61.209.243

set names utf8

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

SELECT
                `products`.*,
                `groups`.`URLLabel` AS Section,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `products`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND `products`.`Visible` = 1  AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`URLLabel` = 'новата-медицина'
            LIMIT 1

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

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

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

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

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

SELECT
            `orders`.`ID`
        FROM
            `orders`
            INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
            INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
        WHERE
            `products`.`ID` = 823 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` = 823 AND
            `products`.`OnlinePrice` > 0 AND
            `products`.`Visible` = 1
        GROUP BY
            `products`.`ID`
        LIMIT 1

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

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:16:11] /spisanie8/root/ajax/basket/update/popup.html?_=1769876178577 108.61.209.243

set names utf8

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

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

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

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

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

SELECT ID FROM `orders` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815' AND `Status` = 0 LIMIT 1
# [31-Jan-2026 18:16:14] /spisanie8/root/orders/checkout.html 108.61.209.243

set names utf8

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

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

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

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

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

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:16:18] /spisanie8/root/ajax/delivery/econt/form.html?_=1769876184753 108.61.209.243

set names utf8

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

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1
# [31-Jan-2026 18:16:36] /spisanie8/root/ajax/orders/submit.html?_=1769876202959 108.61.209.243

set names utf8

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET UserID = 13602, FullName = 'Hristo Davarski', EMail = 'davarski@gmail.com', Phone = '0885068345', TotalPrice = 0, DeliveryMethod = 'Econt', DeliveryPrice = 0, PaymentMethod = 'Borica', DeliveryData = '{"DeliveryMethod":"Econt","DeliveryCountry":"България","DeliveryCity":"СОФИЯ","DeliveryCityID":"68134","DeliveryAddress":"ул. Зорница 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com"}', BasketID = 'df4ab14b02e0238bbae4eea156f78815', LastUpdate = '2026-01-31 18:16:36', PostDate = '2026-01-31 18:16:36', Status = 0, IAgree = 0

DELETE FROM `order_products` WHERE `OrderID` = 10114899

DELETE FROM `order_vouchers` WHERE `OrderID` = 10114899

DELETE FROM `gifts` WHERE `OrderID` = 10114899

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

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

set names utf8

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

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

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

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

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `ProductsNum` = 1,
                    `AllProducts` = '[{"ID":823,"Title":"\\u041d\\u043e\\u0432\\u0430\\u0442\\u0430 \\u043c\\u0435\\u0434\\u0438\\u0446\\u0438\\u043d\\u0430","Qty":1,"Price":10.2,"PriceTotal":10.2}]'
                WHERE
                    `ID` = 10114899 AND
                    `Status` = 0
                LIMIT 1

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"DeliveryMethod":"Econt","DeliveryCountry":"\\u0411\\u044a\\u043b\\u0433\\u0430\\u0440\\u0438\\u044f","DeliveryCity":"\\u0421\\u041e\\u0424\\u0418\\u042f","DeliveryCityID":"68134","DeliveryAddress":"\\u0443\\u043b. \\u0417\\u043e\\u0440\\u043d\\u0438\\u0446\\u0430 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","TotalWeight":0.25,"TotalPrice":10.2}',
                                `TotalPrice` = 10.2
                            WHERE
                                `ID` = 10114899 AND
                                `Status` = 0
                            LIMIT 1

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

SELECT
                `order_products`.`ProductID`,
                `products`.`Image`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                FLOOR(`magazines`.`IntDate` / 10000) AS `Year`
            FROM
                `order_products`
                INNER JOIN `products` ON `order_products`.`ProductID` = `products`.`ID`
                INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
            WHERE
                `order_products`.`OrderID` = 10114899 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` = 10114899 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
# [31-Jan-2026 18:16:36] /spisanie8/root/ajax/orders/total/10114899.html?_=1769876203217 108.61.209.243

set names utf8

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

UPDATE `orders` SET `DeliveryPrice` = '9.5640087' WHERE `ID` = 10114899
# [31-Jan-2026 18:16:42] /spisanie8/root/ajax/orders/confirm/10114899.html?_=1769876208995 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

DELETE FROM `basket_code` WHERE `BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
# [31-Jan-2026 18:19:25] /spisanie8/root/orders/confirm/10114899.html 108.61.209.243

set names utf8

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:22:15] /spisanie8/root/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT `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
# [31-Jan-2026 18:22:19] /spisanie8/root/книги/бъди-вода-приятелю.html 108.61.209.243

set names utf8

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

SELECT
                `products`.*,
                `groups`.`URLLabel` AS Section,
                `groups`.`MenuLabel` AS GroupLabel,
                `groups`.`URLLabel` AS GroupURLLabel
            FROM
                `products`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND `products`.`Visible` = 1  AND
                `groups`.`URLLabel` = 'книги' AND
                `products`.`URLLabel` = 'бъди-вода-приятелю'
            LIMIT 1

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

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

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

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

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

SELECT
            `orders`.`ID`
        FROM
            `orders`
            INNER JOIN `order_products` ON `orders`.`ID` = `order_products`.`OrderID`
            INNER JOIN `products` ON `products`.`ID` = `order_products`.`ProductID`
        WHERE
            `products`.`ID` = 821 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` = 821 AND
            `products`.`OnlinePrice` > 0 AND
            `products`.`Visible` = 1
        GROUP BY
            `products`.`ID`
        LIMIT 1

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

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

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

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

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:22:20] /spisanie8/root/ajax/basket/update/popup.html?_=1769876547371 108.61.209.243

set names utf8

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

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

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

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

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

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

set names utf8

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

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

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

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

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

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

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

SELECT
                `URLLabel`,
                `MenuLabel`,
                `Rules`,
                `Payments`
            FROM
                `pages`
            WHERE
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [31-Jan-2026 18:22:25] /spisanie8/root/ajax/delivery/econt/form.html?_=1769876551806 108.61.209.243

set names utf8

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

SELECT * FROM users WHERE ID = 13602 LIMIT 1

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

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

SELECT
                `vouchers`.`Amount`
            FROM
                `vouchers`
                INNER JOIN `basket_code` ON `basket_code`.`Voucher` = `vouchers`.`VoucherCode`
            WHERE
                `basket_code`.`BasketID` = 'df4ab14b02e0238bbae4eea156f78815'
            LIMIT 1
# [31-Jan-2026 18:22:34] /spisanie8/root/ajax/orders/submit.html?_=1769876561353 108.61.209.243

set names utf8

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET UserID = 13602, FullName = 'Hristo Davarski', EMail = 'davarski@gmail.com', Phone = '0885068345', TotalPrice = 0, DeliveryMethod = 'Econt', DeliveryPrice = 0, PaymentMethod = 'Cash', DeliveryData = '{"DeliveryMethod":"Econt","DeliveryCountry":"България","DeliveryCity":"СОФИЯ","DeliveryCityID":"68134","DeliveryAddress":"ул. Зорница 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","CashOnDelivery":1}', BasketID = 'df4ab14b02e0238bbae4eea156f78815', LastUpdate = '2026-01-31 18:22:34', PostDate = '2026-01-31 18:22:34', Status = 0, IAgree = 0

DELETE FROM `order_products` WHERE `OrderID` = 10114900

DELETE FROM `order_vouchers` WHERE `OrderID` = 10114900

DELETE FROM `gifts` WHERE `OrderID` = 10114900

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

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

set names utf8

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

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

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

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

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `ProductsNum` = 1,
                    `AllProducts` = '[{"ID":821,"Title":"\\u0411\\u044a\\u0434\\u0438 \\u0432\\u043e\\u0434\\u0430, \\u043f\\u0440\\u0438\\u044f\\u0442\\u0435\\u043b\\u044e","Qty":1,"Price":10.2,"PriceTotal":10.2}]'
                WHERE
                    `ID` = 10114900 AND
                    `Status` = 0
                LIMIT 1

UPDATE
                                `orders`
                            SET
                                `LastUpdate` = NOW(),
                                `DeliveryData` = '{"DeliveryMethod":"Econt","DeliveryCountry":"\\u0411\\u044a\\u043b\\u0433\\u0430\\u0440\\u0438\\u044f","DeliveryCity":"\\u0421\\u041e\\u0424\\u0418\\u042f","DeliveryCityID":"68134","DeliveryAddress":"\\u0443\\u043b. \\u0417\\u043e\\u0440\\u043d\\u0438\\u0446\\u0430 1","DeliveryPostalCode":"1000","DeliveryOfficeAddress":"","DeliveryOfficeID":"","DeliveryComment":"","DeliveryFullName":"Hristo Davarski","DeliveryPhone":"0885068345","DeliveryEMail":"davarski@gmail.com","CashOnDelivery":1,"TotalWeight":0.35,"TotalPrice":10.2}',
                                `TotalPrice` = 10.2
                            WHERE
                                `ID` = 10114900 AND
                                `Status` = 0
                            LIMIT 1

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

SELECT
                `order_products`.`ProductID`,
                `products`.`Image`,
                `products`.`Gallery`,
                `magazines`.`IntDate`,
                FLOOR(`magazines`.`IntDate` / 10000) AS `Year`
            FROM
                `order_products`
                INNER JOIN `products` ON `order_products`.`ProductID` = `products`.`ID`
                INNER JOIN `magazines` ON `products`.`ID` = `magazines`.`ProductID`
            WHERE
                `order_products`.`OrderID` = 10114900 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` = 10114900 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
# [31-Jan-2026 18:22:35] /spisanie8/root/ajax/orders/total/10114900.html?_=1769876561711 108.61.209.243

set names utf8

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

UPDATE `orders` SET `DeliveryPrice` = '4.94' WHERE `ID` = 10114900
