# [04-Jul-2024 17:00:23] /spisanie8/root/ 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
                `products`.`ID`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Gallery`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 1

SELECT
                `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
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 6

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 0 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [04-Jul-2024 17:00:36] /spisanie8/root/ 108.61.209.243

set names utf8

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`
                WHERE
                    `articles`.`Gallery` != '' AND
                    (CASE WHEN `articles`.`GroupID` = 41 THEN `articles`.`PostDate` >= '2024-07-04' ELSE `articles`.`PostDate` BETWEEN '2024-06-06' AND '2024-07-04 23:59:59' END) AND 
                `articles`.`PostDate` <= NOW()
             AND `articles`.`OnlineSub` = 0 AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
             LIMIT 0, 16

SELECT COUNT(*) AS NumRows FROM (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`
                WHERE
                    `articles`.`Gallery` != '' AND
                    (CASE WHEN `articles`.`GroupID` = 41 THEN `articles`.`PostDate` >= '2024-07-04' ELSE `articles`.`PostDate` BETWEEN '2024-06-06' AND '2024-07-04 23:59:59' END) AND 
                `articles`.`PostDate` <= NOW()
             AND `articles`.`OnlineSub` = 0 AND
`articles`.`Visible` = 1
                ORDER BY
                    `articles`.`PostDate` DESC
            ) AS CountTable

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
                `products`.`ID`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Gallery`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 1

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

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

SELECT
                `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
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 6

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 0 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [04-Jul-2024 17:00:46] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                `products`.`ID`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Gallery`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 1
# [04-Jul-2024 17:03:00] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                `products`.`ID`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Gallery`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 1
# [04-Jul-2024 17:03:02] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                `products`.`ID`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Gallery`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 1
# [04-Jul-2024 17:04:12] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

SELECT
                `products`.`ID`,
                `products`.`URLLabel`,
                `products`.`Title`,
                `products`.`Gallery`,
                `groups`.`URLLabel` AS `MLabel`
            FROM
                `products`
                INNER JOIN `magazines` ON `ID` = `ProductID`
                INNER JOIN `groups` ON `groups`.`ID` = `products`.`GroupID`
            WHERE
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 1
# [04-Jul-2024 17:07:29] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

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

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

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

SELECT
                `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
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 6

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 0 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [04-Jul-2024 17:07:58] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

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

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

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

SELECT
                `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
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 6

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 0 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [04-Jul-2024 17:11:08] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

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

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

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

SELECT
                `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
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 6

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 0 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [04-Jul-2024 17:12:07] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

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

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

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

SELECT
                `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
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 6

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 0 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [04-Jul-2024 17:12:08] /spisanie8/root/ajax/banners/sc_MSw5LDIsMw.html?_=1720102329511 108.61.209.243
# [04-Jul-2024 17:12:08] /spisanie8/root/ajax/basket/check.html?_=1720102329513 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` IS NULL) AND
                `Section` = 1 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

set names utf8

SELECT `Num` FROM `basket` WHERE `BasketID` = '3efc06b15ce8104250444e5068f1b1a2'

SELECT
                `ID`,
                `URL`,
                `Target`,
                `Images`,
                `Source`,
                `Width`,
                `Height`,
                `Section`,
                `Rotation`,
                `Alignment`
            FROM
                `banners`
            WHERE
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Section` = 9 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` IS NULL) AND
                `Section` = 2 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

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

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 566 LIMIT 1
# [04-Jul-2024 17:12:08] /spisanie8/root/ajax/banners/impress.html?_=1720102329705 108.61.209.243

set names utf8

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN (572,566) LIMIT 1

SELECT `Impressions` FROM `banner_stats` WHERE `BannerID` = 572 AND `PostDate` = CURDATE()

INSERT INTO `banner_stats` (`BannerID`, `PostDate`, `Impressions`) VALUES (572, CURDATE(), 1)

SELECT `Impressions` FROM `banner_stats` WHERE `BannerID` = 566 AND `PostDate` = CURDATE()

INSERT INTO `banner_stats` (`BannerID`, `PostDate`, `Impressions`) VALUES (566, CURDATE(), 1)
# [04-Jul-2024 17:12:20] /spisanie8/root/users/account.html 108.61.209.243

set names utf8

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

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

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

SELECT
                `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
                `products`.`PostDate` <= NOW() AND
                `products`.`Visible` = 1
            ORDER BY
                `products`.`PostDate` DESC
            LIMIT 6

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 0 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC

SELECT
                `URLLabel`,
                `MenuLabel`
            FROM
                `pages`
            WHERE
                `Rules` = 1 AND
                `Visible` = 1
            ORDER BY
                `PostDate` DESC
# [04-Jul-2024 17:12:20] /spisanie8/root/ajax/banners/sc_MSw5LDIsMw.html?_=1720102341460 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` IS NULL) 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` IS NULL) AND
                `Section` = 9 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` IS NULL) AND
                `Section` = 2 AND
                `Visible` = 1
            ORDER BY
                `Priority` DESC,
                `Rotation` ASC,
                RAND()
            LIMIT 1

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

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

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` = 566 LIMIT 1
# [04-Jul-2024 17:12:20] /spisanie8/root/ajax/banners/impress.html?_=1720102341698 108.61.209.243

set names utf8

UPDATE `banners` SET `Impressions` = `Impressions` + 1 WHERE `ID` IN (572,566) LIMIT 1

SELECT `Impressions` FROM `banner_stats` WHERE `BannerID` = 572 AND `PostDate` = CURDATE()

UPDATE `banner_stats` SET `Impressions` = 2 WHERE `BannerID` = 572 AND PostDate = CURDATE() LIMIT 1

SELECT `Impressions` FROM `banner_stats` WHERE `BannerID` = 566 AND `PostDate` = CURDATE()

UPDATE `banner_stats` SET `Impressions` = 2 WHERE `BannerID` = 566 AND PostDate = CURDATE() LIMIT 1
