# [14-May-2025 08:15:52] /rapsody/root/ 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'index' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                `offers`.`ID`,
                `offers`.`UploadID`,
                `offers`.`HeaderImages`,
                `offers`.`URLLabel`,
                `offers`.`VideoURL`,
                `offers`.`Currency`,
                `offers`.`Title`,
                `offers`.`Visible`
	        FROM
	        	`offers`
                INNER JOIN `programs` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
	    	WHERE
                `HeaderImages` <> '' AND
	    		`TopOffer` = 1 AND
                `offers`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `offers`.`Visible` = 1  ORDER BY `offers`.`PostDate` ASC LIMIT 1

SELECT
                `TopOffers`.`ID`,
                `TopOffers`.`UploadID`,
                `TopOffers`.`Image`,
                `TopOffers`.`Size`,
                `TopOffers`.`TripType`,
                `TopOffers`.`Currency`,
                `TopOffers`.`Title`,
                `TopOffers`.`URLLabel`,
                `TopOffers`.`Annotation`,
                `TopOffers`.`Visible`,
                `SubOffers`.`ID` AS `SubOffers`
            FROM
                `offers` AS `TopOffers`
                INNER JOIN `programs` ON `TopOffers`.`ID` = `programs`.`OfferID` AND `TopOffers`.`Language` = `programs`.`Language`
                LEFT JOIN `offers` AS `SubOffers` ON `SubOffers`.`ParentID` = `TopOffers`.`ID` AND `TopOffers`.`Language` = `SubOffers`.`Language`
            WHERE
                `TopOffers`.`ParentID` = 0 AND
                `TopOffers`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 AND `TopOffers`.`Image` <> '' AND `TopOffers`.`Visible` = 1 GROUP BY `TopOffers`.`ID` ORDER BY `TopOffers`.`Row` ASC, `TopOffers`.`PostDate` ASC

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'offers' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'offers' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 208 AND
                `Language` = 'bg' AND
                `EndTo` >= CURDATE()
         AND `Visible` = 1
            ORDER BY
                CASE
                    WHEN `PromoDate` >= CURDATE() THEN 0
                    ELSE 1
                END,
                `PromoDate` ASC,
                `StartFrom` ASC
            LIMIT 1

SELECT
                    `StartFrom` AS `StartFrom2`,
                    `EndTo` AS `EndTo2`
                FROM
                    `programs`
                WHERE
                    `ID` <> 1276 AND
                    `OfferID` = 208 AND
                    `Language` = 'bg' AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1
            ORDER BY
                CASE
                    WHEN `PromoDate` >= CURDATE() THEN 0
                    ELSE 1
                END,
                `PromoDate` ASC,
                `StartFrom` ASC
            LIMIT 1

SELECT
                    MIN(`Price`) AS `MinPrice`
                FROM
                    `programs`
                WHERE
                    `Price` > 0 AND
                    `OfferID` = 208 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPriceFrom') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `offers`.`ID`,
                `offers`.`UploadID`,
                `offers`.`Image`,
                `offers`.`Size`,
                `offers`.`TripType`,
                `offers`.`Currency`,
                `offers`.`Title`,
                `offers`.`URLLabel`,
                `offers`.`Annotation`,
                `offers`.`Visible`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `offers`.`ParentID` = 208 AND
                `offers`.`Language` = 'bg' AND
                `offers`.`MenuLabel` <> '' AND
                `programs`.`EndTo` >= CURDATE() AND
                `offers`.`Visible` = 1
         AND `offers`.`Image` <> '' AND `offers`.`Visible` = 1 GROUP BY `offers`.`ID` ORDER BY `offers`.`Row` ASC, `offers`.`PostDate` ASC

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 254 AND
                `Language` = 'bg' AND
                `EndTo` >= CURDATE()
         AND `Visible` = 1
            ORDER BY
                CASE
                    WHEN `PromoDate` >= CURDATE() THEN 0
                    ELSE 1
                END,
                `PromoDate` ASC,
                `StartFrom` ASC
            LIMIT 1

SELECT
                    `StartFrom` AS `StartFrom2`,
                    `EndTo` AS `EndTo2`
                FROM
                    `programs`
                WHERE
                    `ID` <> 1457 AND
                    `OfferID` = 254 AND
                    `Language` = 'bg' AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1
            ORDER BY
                CASE
                    WHEN `PromoDate` >= CURDATE() THEN 0
                    ELSE 1
                END,
                `PromoDate` ASC,
                `StartFrom` ASC
            LIMIT 1

SELECT
                    MIN(`Price`) AS `MinPrice`
                FROM
                    `programs`
                WHERE
                    `Price` > 0 AND
                    `OfferID` = 254 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `PostDate`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Visible`
            FROM
                `articles`
            WHERE
                `ID` != 0 AND
                `Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC LIMIT 2

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'articles' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LRecentBlogPosts','LReadMore','LSeeMore') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language` AND
                    `SubPages`.`Visible` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Visible` = 1
             GROUP BY
                `pages`.`ID`
             ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                    `offers`.`ID` + 1000 AS `ID`,
                    `offers`.`TripType`,
                    `offers`.`MenuLabel`,
                    `offers`.`URLLabel`,
                    `calendar`.`URLLabel` AS `CalendarURLLabel`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `offers`.`ID` = `programs`.`OfferID` AND
                        `offers`.`Language` = `programs`.`Language` AND
                        `programs`.`Visible` = 1
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language` AND
                        `calendar`.`Visible` = 1
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE() AND
                    `offers`.`Visible` = 1
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [14-May-2025 08:15:53] /rapsody/root/bg/ajax/basket/qty.html?_=1747199753484 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [14-May-2025 08:16:04] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1747199764289 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'kieV42S5E44TyDxv0342Vtq4qA72s7Bl3M78wNhhJHW3BtVmYJMmemL0E013XdJ2'
            WHERE
                `UserKey` LIKE 'w5jCmcK3wp3DpXTDiMKVw6fDo8Kyw47DrMODw5fDmMKswqnCsMKVwq_Ctg%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [14-May-2025 08:16:06] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1747199766517 167.99.142.201

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS Access
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = 'kieV42S5E44TyDxv0342Vtq4qA72s7Bl3M78wNhhJHW3BtVmYJMmemL0E013XdJ2'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1462881527
            LIMIT 1
# [14-May-2025 08:16:06] /rapsody/root/rpV4nz0Sa0q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881527 AND
                                CRC32(`UserKey`) = 33772506 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [14-May-2025 22:29:12] /rapsody/root/bg/нашите-пътувания.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'нашите-пътувания' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language` AND
                    `SubPages`.`Visible` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Visible` = 1
             GROUP BY
                `pages`.`ID`
             ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                    `offers`.`ID` + 1000 AS `ID`,
                    `offers`.`TripType`,
                    `offers`.`MenuLabel`,
                    `offers`.`URLLabel`,
                    `calendar`.`URLLabel` AS `CalendarURLLabel`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `offers`.`ID` = `programs`.`OfferID` AND
                        `offers`.`Language` = `programs`.`Language` AND
                        `programs`.`Visible` = 1
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language` AND
                        `calendar`.`Visible` = 1
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE() AND
                    `offers`.`Visible` = 1
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [14-May-2025 23:02:57] /rapsody/root/bg/events/2600_https:/mgin.dev/rapsody/root/bg/events/tomorrowland-belgium-2025-week-1-rapsody-dream-package-plus.html 167.99.142.201

set names utf8

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language` AND
                    `SubPages`.`Visible` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Visible` = 1
             GROUP BY
                `pages`.`ID`
             ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                    `offers`.`ID` + 1000 AS `ID`,
                    `offers`.`TripType`,
                    `offers`.`MenuLabel`,
                    `offers`.`URLLabel`,
                    `calendar`.`URLLabel` AS `CalendarURLLabel`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `offers`.`ID` = `programs`.`OfferID` AND
                        `offers`.`Language` = `programs`.`Language` AND
                        `programs`.`Visible` = 1
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language` AND
                        `calendar`.`Visible` = 1
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE() AND
                    `offers`.`Visible` = 1
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [14-May-2025 23:03:00] /rapsody/root/bg/events/1600_https:/mgin.dev/rapsody/root/bg/events/tomorrowland-belgium-2025-week-1-rapsody-dream-package-plus.html 167.99.142.201

set names utf8

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language` AND
                    `SubPages`.`Visible` = 1
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Visible` = 1
             GROUP BY
                `pages`.`ID`
             ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                    `offers`.`ID` + 1000 AS `ID`,
                    `offers`.`TripType`,
                    `offers`.`MenuLabel`,
                    `offers`.`URLLabel`,
                    `calendar`.`URLLabel` AS `CalendarURLLabel`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `offers`.`ID` = `programs`.`OfferID` AND
                        `offers`.`Language` = `programs`.`Language` AND
                        `programs`.`Visible` = 1
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language` AND
                        `calendar`.`Visible` = 1
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE() AND
                    `offers`.`Visible` = 1
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
