# [21-Jun-2025 00:00:27] /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
                *
	        FROM
	        	`articles`
	    	WHERE
                `URLLabel` = 'фу-куок-перлата-на-виетнам' AND
	    		`Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `PostDate`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Visible`
            FROM
                `articles`
            WHERE
                `ID` != 45 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
# [21-Jun-2025 00:48:11] /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
                *
	        FROM
	        	`articles`
	    	WHERE
                `URLLabel` = 'фу-куок-перлата-на-виетнам' AND
	    		`Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `PostDate`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Visible`
            FROM
                `articles`
            WHERE
                `ID` != 45 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
# [21-Jun-2025 03:04:42] /rapsody/root/bg/блог/египет-топ-10.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
                *
	        FROM
	        	`articles`
	    	WHERE
                `URLLabel` = 'египет-топ-10' AND
	    		`Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `PostDate`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Visible`
            FROM
                `articles`
            WHERE
                `ID` != 10 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
# [21-Jun-2025 03:04:45] /rapsody/root/bg/ajax/basket/qty.html?_=1750464000010 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '341d762beff69815256dee5b3e380857156c8c1e799cee92761b23c9644919d6'
            LIMIT 1
# [21-Jun-2025 06:41:09] /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
                *
	        FROM
	        	`articles`
	    	WHERE
                `URLLabel` = 'малдиви' AND
	    		`Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `PostDate`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Visible`
            FROM
                `articles`
            WHERE
                `ID` != 15 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
# [21-Jun-2025 07:53:41] /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
# [21-Jun-2025 07:53:42] /rapsody/root/bg/ajax/basket/qty.html?_=1750481622285 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '64a5b4ee5647b8f112df28858b22022dedb11501d2cfb77316c1953fefe8f490'
            LIMIT 1
# [21-Jun-2025 07:53:49] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1750481629565 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '7648540ZK8oG4P05M9PU2ld9Vi51zq7zqSQc2b0J7kihobeqSUPxF1y40L4N5rZc'
            WHERE
                `UserKey` LIKE 'w6vCmsK9wqjCt8KhwrfCrMOew6LCpMOaw5vCuMOIwqXCmMKr%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [21-Jun-2025 07:53:52] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1750481632296 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` = '7648540ZK8oG4P05M9PU2ld9Vi51zq7zqSQc2b0J7kihobeqSUPxF1y40L4N5rZc'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [21-Jun-2025 07:53:52] /rapsody/root/rpV4nz0Sa0q/bg/pages/list.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 669839290 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
# [21-Jun-2025 07:53:55] /rapsody/root/rpV4nz0Sa0q/bg/offers/list.html 167.99.142.201

set names utf8

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

SELECT
               *
            FROM
                `offers`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
# [21-Jun-2025 07:53:57] /rapsody/root/rpV4nz0Sa0q/bg/ajax/offers/form/255.html?_=1750481637399 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `offers`
            WHERE
                `ID` = 255
            LIMIT 1

SELECT
                    `offers`.`ID`,
                    `offers`.`Title`
                FROM
                    `offers`
                    INNER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                    -- LEFT OUTER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                WHERE
                    -- `programs`.`ID` IS NULL AND
                    `programs`.`Nights` = 0 AND
                    `programs`.`Program` = '' AND
                    `offers`.`ID` != 255 AND
                    `offers`.`Title` <> '' AND
                    `offers`.`ParentID` = 0
                ORDER BY `offers`.`PostDate` ASC

SELECT DISTINCT
                `TripType`
            FROM
                `offers`
            WHERE
                `Language` = 'bg' AND
                `TripType` != '' AND
                `TripType` IS NOT NULL
            ORDER BY
                `TripType` ASC
# [21-Jun-2025 07:58:11] /rapsody/root/rpV4nz0Sa0q/bg/offers/list.html 167.99.142.201

set names utf8

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

SELECT
               *
            FROM
                `offers`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
# [21-Jun-2025 07:58:12] /rapsody/root/rpV4nz0Sa0q/bg/ajax/offers/form/255.html?_=1750481892709 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `offers`
            WHERE
                `ID` = 255
            LIMIT 1

SELECT
                    `offers`.`ID`,
                    `offers`.`Title`
                FROM
                    `offers`
                    INNER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                    -- LEFT OUTER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                WHERE
                    -- `programs`.`ID` IS NULL AND
                    `programs`.`Nights` = 0 AND
                    `programs`.`Program` = '' AND
                    `offers`.`ID` != 255 AND
                    `offers`.`Title` <> '' AND
                    `offers`.`ParentID` = 0
                ORDER BY `offers`.`PostDate` ASC

SELECT DISTINCT
                `TripType`
            FROM
                `offers`
            WHERE
                `Language` = 'bg' AND
                `TripType` != '' AND
                `TripType` IS NOT NULL
            ORDER BY
                `TripType` ASC
# [21-Jun-2025 07:59:44] /rapsody/root/rpV4nz0Sa0q/bg/ajax/offers/form/255.html?_=1750481985051 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `offers`
            WHERE
                `ID` = 255
            LIMIT 1

SELECT
                    `offers`.`ID`,
                    `offers`.`Title`
                FROM
                    `offers`
                    INNER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                    -- LEFT OUTER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                WHERE
                    -- `programs`.`ID` IS NULL AND
                    `programs`.`Nights` = 0 AND
                    `programs`.`Program` = '' AND
                    `offers`.`ID` != 255 AND
                    `offers`.`Title` <> '' AND
                    `offers`.`ParentID` = 0
                ORDER BY `offers`.`PostDate` ASC

SELECT DISTINCT
                `TripType`
            FROM
                `offers`
            WHERE
                `Language` = 'bg' AND
                `TripType` != '' AND
                `TripType` IS NOT NULL
            ORDER BY
                `TripType` ASC
# [21-Jun-2025 08:00:20] /rapsody/root/rpV4nz0Sa0q/bg/ajax/offers/update/255.html?_=1750482020797 167.99.142.201

set names utf8

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

SELECT * FROM `offers` LIMIT 1

SHOW COLUMNS FROM `offers`

UPDATE `offers` SET `ID` = '255', `Language` = 'bg', `UploadID` = '8671759971', `ParentID` = '208', `PostDate` = '2025-02-04 08:00:20', `LastUpdate` = '2025-06-21 08:00:20', `MetaTitle` = 'ФОЛКОЛРЕН ФЕСТИВАЛ В КУБА С ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“', `MetaDescription` = 'Пренасяме магията на традиционните български танци за 7 дни в Куба, заедно с ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“', `MetaImage` = 'kuba-meta-picture2.jpg', `URLLabel` = 'фолклорен-фестивал-в-куба', `HeaderImages` = '["kuba-header-picture1.jpg"]', `VideoURL` = '', `TripType` = '[3]ВАКАНЦИЯ', `Currency` = 'EUR', `Logo` = '', `Flag` = '', `Country` = NULL, `LocationURL` = 'https://www.google.com/maps/place/Chalet+Lodge+PureValley/@45.3334589,6.535628,3a,75y,90t/data=!3m8!1e2!3m6!1sAF1QipOTDoZdMUySspmHK8xVOH72zx6AqiEfyfiGS5yF!2e10!3e12!6shttps://lh3.googleusercontent.com/p/AF1QipOTDoZdMUySspmHK8xVOH72zx6AqiEfyfiGS5yF=w203-h270-k-no!7i1440!8i1920!4m15!1m7!3m6!1s0x47898750602145cf:0x1d3972e32f1aa4b7!2sLes+Menuires!8m2!3d45.3242022!4d6.5378012!16zL20vMGJiY3Rq!3m6!1s0x4789870c88c8bfff:0xfdbe1ae8a90cee58!8m2!3d45.3334667!4d6.5356809!10e5!16s/g/11jg12_912?entry=ttu&g_ep=EgoyMDI1MDYxNy4wIKXMDSoASAFQAw==', `BookURL` = '', `MenuLabel` = '', `Title` = 'ФОЛКЛОРЕН ФЕСТИВАЛ В КУБА', `Gallery` = '["followmehavana4.jpg","456539408-883592337149624-4074454190668567274-n.jpg","456405186-883594913816033-2306803731588816084-n.jpg"]', `Annotation` = 'Пренасяме магията на традиционните български танци за 7 дни в Куба, заедно с ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“', `Image` = '', `Size` = '1', `Row` = 0, `Content` = '<div style="background-color: rgb(255, 255, 255);">КУБА е страст, КУБА е музика, КУБА е танц, КУБА Е МЕЧТА!</div><div style="background-color: rgb(255, 255, 255);"><br></div><div><div style="background-color: rgb(255, 255, 255);">За да усетиш Куба, трябва да я изживееш! </div><div style="background-color: rgb(255, 255, 255);">Куба на Хемингуей, на пурите, където ромът се лее повече от вода, музиката е на всеки ъгъл, танците са горещи, коктейлите студени! </div><div style="background-color: rgb(255, 255, 255);">Куба на Кастро, където излишъкът е само в празните магазини, но сърцата на хората са пълни! </div><div style="background-color: rgb(255, 255, 255);">Куба на улицата, където всеки който те срещне казва че е твой приятел! </div><div style="background-color: rgb(255, 255, 255);">Куба, която се променя с нейно темпо, в ритъма на салсата с вкуса на рома и мириса на пури! Куба, която обичаме още повече!<br></div></div><div>Каним ви на пътешествие във времето с много музика и танци  с твоите приятели от ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“! </div><div><br></div><div>Предстои ни необикновено приключение, съчетаващо от една страна възможността, да се потопим в културното и историческо наследство на Куба и от друга страна уникално забавление и прекрасни моменти с любимите ни приятели от VANGELOFF“ & „РИПНИ-КА“! </div>', `AdditionalInfo` = '<h3 style="margin-top: 0px; background-color: rgb(255, 255, 255);">ДОПЪЛНИТЕЛНИ ЕКСКУРЗИИ*:</h3><div style="background-color: rgb(255, 255, 255);">/допълнителните екскурзии се провеждат при минимум 20 човека/ <br></div><div style="background-color: rgb(255, 255, 255);"><hr style="border-width: medium; border-style: none;"></div><div style="background-color: rgb(255, 255, 255);"><div><h4>Разходка с ретро автомобил из улиците на Хавана & сити тур на Хавана- 70 евро</h4></div><div><div><div>Разходка с ретро автомобил из улиците на Хавана & сити тур на Хавана- 70 евро/ 137.00лв.</div><div>Отправяме се на един невероятен панорамен тур на Хавана, а именно през метрополитните и модерните райони на града. Ретро автомобили ще ни вземат от хотела, с които най-добре ще усетите карибския дух на града и ще се запознаете с най- важните забележителности. Ще спрем за снимка на любимия на всички кубинци "Площада на революцията".  Ще спрем в колониалната част на града, минавайки покрай Националната сграда на Капитолия, Големия театър на Хавана, булевард „Ел Прадо“, бившия президентски дворец и Централния парк. Обиколката ни ще продължи пеша през историческата и колониална част на Старата Хавана, обявена от ЮНЕСКО за обект на световното културно наследство през 1982 г., където ще посетим площада на катедралата, площада Сан Франциско де Асис, площада Oldl, великолепните "Площад на Армията", ще преминем през емблематичния хотел Ambos Mundos в който е живял великият Ернест Хемингуей, не можем да пропуснем и двата му любими бара в които е пиел своето любимо дайкири в бар Floridita и мохито в Bodeguita del Medio.</div><div> / По време на тура не са включени напитки в посещаваните заведения/ </div></div><div><br></div><div><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_41.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;">  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_51.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_51.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_31.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_31.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_52.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_52.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_42.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_42.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_22.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_22.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><br></div></div></div><div style="background-color: rgb(255, 255, 255);"><h4>Tropicana Cabaret show с включен трансфер - 120 евро<br></h4></div><div style="background-color: rgb(255, 255, 255);"><div>/цената включва: трансфер, предварително запазени места, шоу програма, напитка за добре дошли (cava), 1/4 бутилка Havana Club с една кубинска кола на човек/</div><div><br></div><div>Кабаре Тропикана е най-известното кабаре на Куба. Открит през 1931 г., той е известен като „Раят под звездите“ и оттогава радва тълпите. Заобиколени от буйна растителност посетителите могат да се насладят на блестящ спектакъл с участието на над 200 певци, танцьори, музиканти и вокалисти.</div></div><div style="background-color: rgb(255, 255, 255);"><br></div><div style="background-color: rgb(255, 255, 255);"><div class="mgPageGallery"><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_49895948-2458081654264259-4474122515198771200-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_49895948-2458081654264259-4474122515198771200-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_49371990-2466043943468030-8536635198907875328-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_49371990-2466043943468030-8536635198907875328-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_49321373-2461924853879939-4390302624939769856-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_49321373-2461924853879939-4390302624939769856-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_47391906-2385566471515778-2343490519276978176-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_47391906-2385566471515778-2343490519276978176-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_47378636-2389571714448587-2481802399082086400-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_47378636-2389571714448587-2481802399082086400-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a></div></div><div style="background-color: rgb(255, 255, 255);"><h4>Катамаран Seafari до Кайо Бланко с включен обяд - 120 евро</h4></div><div style="background-color: rgb(255, 255, 255);"><div>/цената включва: трансфер, отворен бар на борда с местни напитки (безалкохолни, вода, бира, кубински коктейли и ром), анимация и музика, обяд в ресторант Cayo Blanco/</div><div><br></div><div>Ще се забавляваме на катамарана с много музика, танци и свежи кубински напитки. Ще се гмуркаме с шнорхел в кораловия риф. Ще посетим делфинариума, където ще имате възможността да си поиграете с делфините и да се насладите на тяхното шоу. След това ще обядваме всички заедно в ресторант Cayo Blanco. Ще ни остане и свободно време за плуване и релакс на плажа.</div></div><div style="background-color: rgb(255, 255, 255);"><br></div><div style="background-color: rgb(255, 255, 255);"><div class="mgPageGallery"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_16.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"> <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_54.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_54.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_44.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_44.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_34.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_34.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_26.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_26.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a></div></div>', `AddOn` = '', `TopOffer` = 0, `Visible` = 1 WHERE `ID` = '255' AND `Language` = 'bg'
# [21-Jun-2025 08:01:17] /rapsody/root/rpV4nz0Sa0q/bg/offers/list.html 167.99.142.201

set names utf8

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

SELECT
               *
            FROM
                `offers`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
# [21-Jun-2025 08:01:18] /rapsody/root/rpV4nz0Sa0q/bg/ajax/offers/form/255.html?_=1750482078687 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `offers`
            WHERE
                `ID` = 255
            LIMIT 1

SELECT
                    `offers`.`ID`,
                    `offers`.`Title`
                FROM
                    `offers`
                    INNER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                    -- LEFT OUTER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                WHERE
                    -- `programs`.`ID` IS NULL AND
                    `programs`.`Nights` = 0 AND
                    `programs`.`Program` = '' AND
                    `offers`.`ID` != 255 AND
                    `offers`.`Title` <> '' AND
                    `offers`.`ParentID` = 0
                ORDER BY `offers`.`PostDate` ASC

SELECT DISTINCT
                `TripType`
            FROM
                `offers`
            WHERE
                `Language` = 'bg' AND
                `TripType` != '' AND
                `TripType` IS NOT NULL
            ORDER BY
                `TripType` ASC
# [21-Jun-2025 08:11:09] /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
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'контакти' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

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

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'contacts' 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
# [21-Jun-2025 08:11:24] /rapsody/root/bg/ajax/basket/qty.html?_=1750464000010 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '341d762beff69815256dee5b3e380857156c8c1e799cee92761b23c9644919d6'
            LIMIT 1
# [21-Jun-2025 08:11:24] /rapsody/root/bg/ajax/contacts/form.html?_=1750464000011 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LSendRequest','LSend','LName','LPhone','LEMail','LMessage','LAgreeCheck','ErrorIAgreeCheck') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'terms' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1
# [21-Jun-2025 08:13:36] /rapsody/root/rpV4nz0Sa0q/bg/offers/list.html 167.99.142.201

set names utf8

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

SELECT
               *
            FROM
                `offers`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
# [21-Jun-2025 08:13:37] /rapsody/root/rpV4nz0Sa0q/bg/ajax/offers/form/255.html?_=1750482817901 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `offers`
            WHERE
                `ID` = 255
            LIMIT 1

SELECT
                    `offers`.`ID`,
                    `offers`.`Title`
                FROM
                    `offers`
                    INNER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                    -- LEFT OUTER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                WHERE
                    -- `programs`.`ID` IS NULL AND
                    `programs`.`Nights` = 0 AND
                    `programs`.`Program` = '' AND
                    `offers`.`ID` != 255 AND
                    `offers`.`Title` <> '' AND
                    `offers`.`ParentID` = 0
                ORDER BY `offers`.`PostDate` ASC

SELECT DISTINCT
                `TripType`
            FROM
                `offers`
            WHERE
                `Language` = 'bg' AND
                `TripType` != '' AND
                `TripType` IS NOT NULL
            ORDER BY
                `TripType` ASC
# [21-Jun-2025 08:14:04] /rapsody/root/rpV4nz0Sa0q/bg/ajax/offers/update/255.html?_=1750482844697 167.99.142.201

set names utf8

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

SELECT * FROM `offers` LIMIT 1

SHOW COLUMNS FROM `offers`

UPDATE `offers` SET `ID` = '255', `Language` = 'bg', `UploadID` = '8671759971', `ParentID` = '208', `PostDate` = '2025-02-04 08:14:04', `LastUpdate` = '2025-06-21 08:14:04', `MetaTitle` = 'ФОЛКОЛРЕН ФЕСТИВАЛ В КУБА С ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“', `MetaDescription` = 'Пренасяме магията на традиционните български танци за 7 дни в Куба, заедно с ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“', `MetaImage` = 'kuba-meta-picture2.jpg', `URLLabel` = 'фолклорен-фестивал-в-куба', `HeaderImages` = '["kuba-header-picture1.jpg"]', `VideoURL` = '', `TripType` = '[3]ВАКАНЦИЯ', `Currency` = 'EUR', `Logo` = '', `Flag` = '', `Country` = '', `LocationURL` = 'https://www.google.com/maps/place/Chalet+Lodge+PureValley/@45.3334589,6.535628,3a,75y,90t/data=!3m8!1e2!3m6!1sAF1QipOTDoZdMUySspmHK8xVOH72zx6AqiEfyfiGS5yF!2e10!3e12!6shttps://lh3.googleusercontent.com/p/AF1QipOTDoZdMUySspmHK8xVOH72zx6AqiEfyfiGS5yF=w203-h270-k-no!7i1440!8i1920!4m15!1m7!3m6!1s0x47898750602145cf:0x1d3972e32f1aa4b7!2sLes+Menuires!8m2!3d45.3242022!4d6.5378012!16zL20vMGJiY3Rq!3m6!1s0x4789870c88c8bfff:0xfdbe1ae8a90cee58!8m2!3d45.3334667!4d6.5356809!10e5!16s/g/11jg12_912?entry=ttu&g_ep=EgoyMDI1MDYxNy4wIKXMDSoASAFQAw==', `BookURL` = '', `MenuLabel` = '', `Title` = 'ФОЛКЛОРЕН ФЕСТИВАЛ В КУБА', `Gallery` = '["followmehavana4.jpg","456539408-883592337149624-4074454190668567274-n.jpg","456405186-883594913816033-2306803731588816084-n.jpg"]', `Annotation` = 'Пренасяме магията на традиционните български танци за 7 дни в Куба, заедно с ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“', `Image` = '', `Size` = '1', `Row` = 0, `Content` = '<div style="background-color: rgb(255, 255, 255);">КУБА е страст, КУБА е музика, КУБА е танц, КУБА Е МЕЧТА!</div><div style="background-color: rgb(255, 255, 255);"><br></div><div><div style="background-color: rgb(255, 255, 255);">За да усетиш Куба, трябва да я изживееш! </div><div style="background-color: rgb(255, 255, 255);">Куба на Хемингуей, на пурите, където ромът се лее повече от вода, музиката е на всеки ъгъл, танците са горещи, коктейлите студени! </div><div style="background-color: rgb(255, 255, 255);">Куба на Кастро, където излишъкът е само в празните магазини, но сърцата на хората са пълни! </div><div style="background-color: rgb(255, 255, 255);">Куба на улицата, където всеки който те срещне казва че е твой приятел! </div><div style="background-color: rgb(255, 255, 255);">Куба, която се променя с нейно темпо, в ритъма на салсата с вкуса на рома и мириса на пури! Куба, която обичаме още повече!<br></div></div><div>Каним ви на пътешествие във времето с много музика и танци  с твоите приятели от ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“! </div><div><br></div><div>Предстои ни необикновено приключение, съчетаващо от една страна възможността, да се потопим в културното и историческо наследство на Куба и от друга страна уникално забавление и прекрасни моменти с любимите ни приятели от VANGELOFF“ & „РИПНИ-КА“! </div>', `AdditionalInfo` = '<h3 style="margin-top: 0px; background-color: rgb(255, 255, 255);">ДОПЪЛНИТЕЛНИ ЕКСКУРЗИИ*:</h3><div style="background-color: rgb(255, 255, 255);">/допълнителните екскурзии се провеждат при минимум 20 човека/ <br></div><div style="background-color: rgb(255, 255, 255);"><hr style="border-width: medium; border-style: none;"></div><div style="background-color: rgb(255, 255, 255);"><div><h4>Разходка с ретро автомобил из улиците на Хавана & сити тур на Хавана- 70 евро</h4></div><div><div><div>Разходка с ретро автомобил из улиците на Хавана & сити тур на Хавана- 70 евро/ 137.00лв.</div><div>Отправяме се на един невероятен панорамен тур на Хавана, а именно през метрополитните и модерните райони на града. Ретро автомобили ще ни вземат от хотела, с които най-добре ще усетите карибския дух на града и ще се запознаете с най- важните забележителности. Ще спрем за снимка на любимия на всички кубинци "Площада на революцията".  Ще спрем в колониалната част на града, минавайки покрай Националната сграда на Капитолия, Големия театър на Хавана, булевард „Ел Прадо“, бившия президентски дворец и Централния парк. Обиколката ни ще продължи пеша през историческата и колониална част на Старата Хавана, обявена от ЮНЕСКО за обект на световното културно наследство през 1982 г., където ще посетим площада на катедралата, площада Сан Франциско де Асис, площада Oldl, великолепните "Площад на Армията", ще преминем през емблематичния хотел Ambos Mundos в който е живял великият Ернест Хемингуей, не можем да пропуснем и двата му любими бара в които е пиел своето любимо дайкири в бар Floridita и мохито в Bodeguita del Medio.</div><div> / По време на тура не са включени напитки в посещаваните заведения/ </div></div><div><br></div><div><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_41.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;">  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_51.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_51.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_31.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_31.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_52.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_52.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_42.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_42.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_22.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_22.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><br></div></div></div><div style="background-color: rgb(255, 255, 255);"><h4>Tropicana Cabaret show с включен трансфер - 120 евро<br></h4></div><div style="background-color: rgb(255, 255, 255);"><div>/цената включва: трансфер, предварително запазени места, шоу програма, напитка за добре дошли (cava), 1/4 бутилка Havana Club с една кубинска кола на човек/</div><div><br></div><div>Кабаре Тропикана е най-известното кабаре на Куба. Открит през 1931 г., той е известен като „Раят под звездите“ и оттогава радва тълпите. Заобиколени от буйна растителност посетителите могат да се насладят на блестящ спектакъл с участието на над 200 певци, танцьори, музиканти и вокалисти.</div></div><div style="background-color: rgb(255, 255, 255);"><br></div><div style="background-color: rgb(255, 255, 255);"><div class="mgPageGallery"><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_49895948-2458081654264259-4474122515198771200-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_49895948-2458081654264259-4474122515198771200-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_49371990-2466043943468030-8536635198907875328-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_49371990-2466043943468030-8536635198907875328-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_49321373-2461924853879939-4390302624939769856-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_49321373-2461924853879939-4390302624939769856-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_47391906-2385566471515778-2343490519276978176-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_47391906-2385566471515778-2343490519276978176-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_47378636-2389571714448587-2481802399082086400-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_47378636-2389571714448587-2481802399082086400-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a></div></div><div style="background-color: rgb(255, 255, 255);"><h4>Катамаран Seafari до Кайо Бланко с включен обяд - 120 евро</h4></div><div style="background-color: rgb(255, 255, 255);"><div>/цената включва: трансфер, отворен бар на борда с местни напитки (безалкохолни, вода, бира, кубински коктейли и ром), анимация и музика, обяд в ресторант Cayo Blanco/</div><div><br></div><div>Ще се забавляваме на катамарана с много музика, танци и свежи кубински напитки. Ще се гмуркаме с шнорхел в кораловия риф. Ще посетим делфинариума, където ще имате възможността да си поиграете с делфините и да се насладите на тяхното шоу. След това ще обядваме всички заедно в ресторант Cayo Blanco. Ще ни остане и свободно време за плуване и релакс на плажа.</div></div><div style="background-color: rgb(255, 255, 255);"><br></div><div style="background-color: rgb(255, 255, 255);"><div class="mgPageGallery"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_16.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"> <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_54.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_54.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_44.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_44.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_34.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_34.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_26.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_26.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a></div></div>', `AddOn` = '', `TopOffer` = 0, `Visible` = 1 WHERE `ID` = '255' AND `Language` = 'bg'
# [21-Jun-2025 08:14:04] /rapsody/root/rpV4nz0Sa0q/bg/offers/list.html 167.99.142.201

set names utf8

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

SELECT
               *
            FROM
                `offers`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
# [21-Jun-2025 08:14:50] /rapsody/root/rpV4nz0Sa0q/bg/ajax/offers/form/255.html?_=1750482890401 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `offers`
            WHERE
                `ID` = 255
            LIMIT 1

SELECT
                    `offers`.`ID`,
                    `offers`.`Title`
                FROM
                    `offers`
                    INNER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                    -- LEFT OUTER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                WHERE
                    -- `programs`.`ID` IS NULL AND
                    `programs`.`Nights` = 0 AND
                    `programs`.`Program` = '' AND
                    `offers`.`ID` != 255 AND
                    `offers`.`Title` <> '' AND
                    `offers`.`ParentID` = 0
                ORDER BY `offers`.`PostDate` ASC

SELECT DISTINCT
                `TripType`
            FROM
                `offers`
            WHERE
                `Language` = 'bg' AND
                `TripType` != '' AND
                `TripType` IS NOT NULL
            ORDER BY
                `TripType` ASC
# [21-Jun-2025 08:15:05] /rapsody/root/rpV4nz0Sa0q/bg/ajax/offers/update/255.html?_=1750482905681 167.99.142.201

set names utf8

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

SELECT * FROM `offers` LIMIT 1

SHOW COLUMNS FROM `offers`

UPDATE `offers` SET `ID` = '255', `Language` = 'bg', `UploadID` = '8671759971', `ParentID` = '208', `PostDate` = '2025-02-04 08:15:05', `LastUpdate` = '2025-06-21 08:15:05', `MetaTitle` = 'ФОЛКОЛРЕН ФЕСТИВАЛ В КУБА С ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“', `MetaDescription` = 'Пренасяме магията на традиционните български танци за 7 дни в Куба, заедно с ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“', `MetaImage` = 'kuba-meta-picture2.jpg', `URLLabel` = 'фолклорен-фестивал-в-куба', `HeaderImages` = '["kuba-header-picture1.jpg"]', `VideoURL` = '', `TripType` = '[3]ВАКАНЦИЯ', `Currency` = 'EUR', `Logo` = '', `Flag` = '', `Country` = 'Франция', `LocationURL` = 'https://www.google.com/maps/place/Chalet+Lodge+PureValley/@45.3334589,6.535628,3a,75y,90t/data=!3m8!1e2!3m6!1sAF1QipOTDoZdMUySspmHK8xVOH72zx6AqiEfyfiGS5yF!2e10!3e12!6shttps://lh3.googleusercontent.com/p/AF1QipOTDoZdMUySspmHK8xVOH72zx6AqiEfyfiGS5yF=w203-h270-k-no!7i1440!8i1920!4m15!1m7!3m6!1s0x47898750602145cf:0x1d3972e32f1aa4b7!2sLes+Menuires!8m2!3d45.3242022!4d6.5378012!16zL20vMGJiY3Rq!3m6!1s0x4789870c88c8bfff:0xfdbe1ae8a90cee58!8m2!3d45.3334667!4d6.5356809!10e5!16s/g/11jg12_912?entry=ttu&g_ep=EgoyMDI1MDYxNy4wIKXMDSoASAFQAw==', `BookURL` = '', `MenuLabel` = '', `Title` = 'ФОЛКЛОРЕН ФЕСТИВАЛ В КУБА', `Gallery` = '["followmehavana4.jpg","456539408-883592337149624-4074454190668567274-n.jpg","456405186-883594913816033-2306803731588816084-n.jpg"]', `Annotation` = 'Пренасяме магията на традиционните български танци за 7 дни в Куба, заедно с ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“', `Image` = '', `Size` = '1', `Row` = 0, `Content` = '<div style="background-color: rgb(255, 255, 255);">КУБА е страст, КУБА е музика, КУБА е танц, КУБА Е МЕЧТА!</div><div style="background-color: rgb(255, 255, 255);"><br></div><div><div style="background-color: rgb(255, 255, 255);">За да усетиш Куба, трябва да я изживееш! </div><div style="background-color: rgb(255, 255, 255);">Куба на Хемингуей, на пурите, където ромът се лее повече от вода, музиката е на всеки ъгъл, танците са горещи, коктейлите студени! </div><div style="background-color: rgb(255, 255, 255);">Куба на Кастро, където излишъкът е само в празните магазини, но сърцата на хората са пълни! </div><div style="background-color: rgb(255, 255, 255);">Куба на улицата, където всеки който те срещне казва че е твой приятел! </div><div style="background-color: rgb(255, 255, 255);">Куба, която се променя с нейно темпо, в ритъма на салсата с вкуса на рома и мириса на пури! Куба, която обичаме още повече!<br></div></div><div>Каним ви на пътешествие във времето с много музика и танци  с твоите приятели от ТАНЦОВ КОЛЕКТИВ „VANGELOFF“ & ТАНЦОВ КЛУБ „РИПНИ-КА“! </div><div><br></div><div>Предстои ни необикновено приключение, съчетаващо от една страна възможността, да се потопим в културното и историческо наследство на Куба и от друга страна уникално забавление и прекрасни моменти с любимите ни приятели от VANGELOFF“ & „РИПНИ-КА“! </div>', `AdditionalInfo` = '<h3 style="margin-top: 0px; background-color: rgb(255, 255, 255);">ДОПЪЛНИТЕЛНИ ЕКСКУРЗИИ*:</h3><div style="background-color: rgb(255, 255, 255);">/допълнителните екскурзии се провеждат при минимум 20 човека/ <br></div><div style="background-color: rgb(255, 255, 255);"><hr style="border-width: medium; border-style: none;"></div><div style="background-color: rgb(255, 255, 255);"><div><h4>Разходка с ретро автомобил из улиците на Хавана & сити тур на Хавана- 70 евро</h4></div><div><div><div>Разходка с ретро автомобил из улиците на Хавана & сити тур на Хавана- 70 евро/ 137.00лв.</div><div>Отправяме се на един невероятен панорамен тур на Хавана, а именно през метрополитните и модерните райони на града. Ретро автомобили ще ни вземат от хотела, с които най-добре ще усетите карибския дух на града и ще се запознаете с най- важните забележителности. Ще спрем за снимка на любимия на всички кубинци "Площада на революцията".  Ще спрем в колониалната част на града, минавайки покрай Националната сграда на Капитолия, Големия театър на Хавана, булевард „Ел Прадо“, бившия президентски дворец и Централния парк. Обиколката ни ще продължи пеша през историческата и колониална част на Старата Хавана, обявена от ЮНЕСКО за обект на световното културно наследство през 1982 г., където ще посетим площада на катедралата, площада Сан Франциско де Асис, площада Oldl, великолепните "Площад на Армията", ще преминем през емблематичния хотел Ambos Mundos в който е живял великият Ернест Хемингуей, не можем да пропуснем и двата му любими бара в които е пиел своето любимо дайкири в бар Floridita и мохито в Bodeguita del Medio.</div><div> / По време на тура не са включени напитки в посещаваните заведения/ </div></div><div><br></div><div><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_41.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;">  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_51.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_51.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_31.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_31.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_52.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_52.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_42.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_42.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a>  <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_22.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_22.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><br></div></div></div><div style="background-color: rgb(255, 255, 255);"><h4>Tropicana Cabaret show с включен трансфер - 120 евро<br></h4></div><div style="background-color: rgb(255, 255, 255);"><div>/цената включва: трансфер, предварително запазени места, шоу програма, напитка за добре дошли (cava), 1/4 бутилка Havana Club с една кубинска кола на човек/</div><div><br></div><div>Кабаре Тропикана е най-известното кабаре на Куба. Открит през 1931 г., той е известен като „Раят под звездите“ и оттогава радва тълпите. Заобиколени от буйна растителност посетителите могат да се насладят на блестящ спектакъл с участието на над 200 певци, танцьори, музиканти и вокалисти.</div></div><div style="background-color: rgb(255, 255, 255);"><br></div><div style="background-color: rgb(255, 255, 255);"><div class="mgPageGallery"><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_49895948-2458081654264259-4474122515198771200-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_49895948-2458081654264259-4474122515198771200-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_49371990-2466043943468030-8536635198907875328-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_49371990-2466043943468030-8536635198907875328-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_49321373-2461924853879939-4390302624939769856-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_49321373-2461924853879939-4390302624939769856-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_47391906-2385566471515778-2343490519276978176-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_47391906-2385566471515778-2343490519276978176-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_47378636-2389571714448587-2481802399082086400-o.jpg"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_47378636-2389571714448587-2481802399082086400-o.jpg" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a></div></div><div style="background-color: rgb(255, 255, 255);"><h4>Катамаран Seafari до Кайо Бланко с включен обяд - 120 евро</h4></div><div style="background-color: rgb(255, 255, 255);"><div>/цената включва: трансфер, отворен бар на борда с местни напитки (безалкохолни, вода, бира, кубински коктейли и ром), анимация и музика, обяд в ресторант Cayo Blanco/</div><div><br></div><div>Ще се забавляваме на катамарана с много музика, танци и свежи кубински напитки. Ще се гмуркаме с шнорхел в кораловия риф. Ще посетим делфинариума, където ще имате възможността да си поиграете с делфините и да се насладите на тяхното шоу. След това ще обядваме всички заедно в ресторант Cayo Blanco. Ще ни остане и свободно време за плуване и релакс на плажа.</div></div><div style="background-color: rgb(255, 255, 255);"><br></div><div style="background-color: rgb(255, 255, 255);"><div class="mgPageGallery"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_16.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"> <a href="https://rapsodytravel.bg/uf/offers/9497256653/i_54.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_54.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_44.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_44.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_34.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_34.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a><a href="https://rapsodytravel.bg/uf/offers/9497256653/i_26.png"><img src="https://rapsodytravel.bg/uf/offers/9497256653/l_26.png" style="border-width: medium; border-style: none; outline-color: currentcolor; outline-style: none;"></a></div></div>', `AddOn` = '', `TopOffer` = 0, `Visible` = 1 WHERE `ID` = '255' AND `Language` = 'bg'
# [21-Jun-2025 08:15:05] /rapsody/root/rpV4nz0Sa0q/bg/offers/list.html 167.99.142.201

set names utf8

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

SELECT
               *
            FROM
                `offers`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
# [21-Jun-2025 08:15:07] /rapsody/root/rpV4nz0Sa0q/bg/ajax/offers/form/255.html?_=1750482907263 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `offers`
            WHERE
                `ID` = 255
            LIMIT 1

SELECT
                    `offers`.`ID`,
                    `offers`.`Title`
                FROM
                    `offers`
                    INNER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                    -- LEFT OUTER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                WHERE
                    -- `programs`.`ID` IS NULL AND
                    `programs`.`Nights` = 0 AND
                    `programs`.`Program` = '' AND
                    `offers`.`ID` != 255 AND
                    `offers`.`Title` <> '' AND
                    `offers`.`ParentID` = 0
                ORDER BY `offers`.`PostDate` ASC

SELECT DISTINCT
                `TripType`
            FROM
                `offers`
            WHERE
                `Language` = 'bg' AND
                `TripType` != '' AND
                `TripType` IS NOT NULL
            ORDER BY
                `TripType` ASC
# [21-Jun-2025 08:15:22] /rapsody/root/rpV4nz0Sa0q/bg/ajax/offers/form/255.html?_=1750482922924 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `offers`
            WHERE
                `ID` = 255
            LIMIT 1

SELECT
                    `offers`.`ID`,
                    `offers`.`Title`
                FROM
                    `offers`
                    INNER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                    -- LEFT OUTER JOIN `programs` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
                WHERE
                    -- `programs`.`ID` IS NULL AND
                    `programs`.`Nights` = 0 AND
                    `programs`.`Program` = '' AND
                    `offers`.`ID` != 255 AND
                    `offers`.`Title` <> '' AND
                    `offers`.`ParentID` = 0
                ORDER BY `offers`.`PostDate` ASC

SELECT DISTINCT
                `TripType`
            FROM
                `offers`
            WHERE
                `Language` = 'bg' AND
                `TripType` != '' AND
                `TripType` IS NOT NULL
            ORDER BY
                `TripType` ASC
# [21-Jun-2025 09:05:42] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/logout.html?_=1750485942040 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 669839290 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [21-Jun-2025 09:05:42] /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
# [21-Jun-2025 09:05:42] /rapsody/root/bg/ajax/basket/qty.html?_=1750485942608 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '64a5b4ee5647b8f112df28858b22022dedb11501d2cfb77316c1953fefe8f490'
            LIMIT 1
# [21-Jun-2025 09:05:44] /rapsody/root/bg/rapsody-exotic.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'rapsody-exotic' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                `TopOffers`.*,
                `SubOffers`.`ID` AS `SubOffers`
	        FROM
	        	`offers` AS `TopOffers`
                LEFT JOIN `offers` AS `SubOffers` ON
                    `SubOffers`.`ParentID` = `TopOffers`.`ID` AND
                    `SubOffers`.`Language` = `TopOffers`.`Language`
	    	WHERE
                `TopOffers`.`Language` = 'bg' AND
                `TopOffers`.`URLLabel` = 'rapsody-exotic'
         AND `TopOffers`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFrom','LUntil','LBookNow','LPriceFrom','LGallery','LProgram','LReadMore','LPrices','LAccommodation','LAdditionalExcursions','LFAQ','LDays','LPrice','LDeposit') 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
                `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
# [21-Jun-2025 09:05:44] /rapsody/root/bg/ajax/basket/qty.html?_=1750485944032 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '64a5b4ee5647b8f112df28858b22022dedb11501d2cfb77316c1953fefe8f490'
            LIMIT 1
# [21-Jun-2025 09:05:46] /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
                `TopOffers`.*,
                `SubOffers`.`ID` AS `SubOffers`
	        FROM
	        	`offers` AS `TopOffers`
                LEFT JOIN `offers` AS `SubOffers` ON
                    `SubOffers`.`ParentID` = `TopOffers`.`ID` AND
                    `SubOffers`.`Language` = `TopOffers`.`Language`
	    	WHERE
                `TopOffers`.`Language` = 'bg' AND
                `TopOffers`.`URLLabel` = 'хърватия--словения-загреб-плитвички-езера-постойна-опатия'
         AND `TopOffers`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFrom','LUntil','LBookNow','LPriceFrom','LGallery','LProgram','LReadMore','LPrices','LAccommodation','LAdditionalExcursions','LFAQ','LDays','LPrice','LDeposit') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `programs`.*
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`OfferID` = 254 AND
                `programs`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 GROUP BY `programs`.`ID` ORDER BY `programs`.`StartFrom` ASC

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                *
            FROM
                `programs`
            WHERE
                `Language` = 'bg' AND
                `ID` = 1457
         AND `Visible` = 1 LIMIT 1

SELECT
                    `accommodation`.*,
                    `programs`.`PromoDate`
                FROM
                    `accommodation`
                    INNER JOIN `offers` ON
                        `accommodation`.`OfferID` = `offers`.`ID` AND
                        `offers`.`Language` = `accommodation`.`Language`
                    INNER JOIN `rooms` ON
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`ProgramID` = 1457
                    LEFT JOIN `programs` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `programs`.`Language` = `accommodation`.`Language`
                WHERE
                    `accommodation`.`OfferID` = 254 AND
                    `accommodation`.`Language` = 'bg'
             AND `accommodation`.`Visible` = 1 AND `offers`.`Visible` = 1
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

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

SELECT
			    `Price`,
			    `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
			    `AccommodationID` = 795 AND
			    `ProgramID` = 1457 AND
			    `Language` = 'bg' AND
			    `Visible` = 1
			ORDER BY `Price` ASC
			LIMIT 1

SELECT * FROM `faq` WHERE `OfferID` = 254 AND `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` 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
# [21-Jun-2025 09:05:47] /rapsody/root/bg/ajax/basket/qty.html?_=1750485947047 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '64a5b4ee5647b8f112df28858b22022dedb11501d2cfb77316c1953fefe8f490'
            LIMIT 1
# [21-Jun-2025 09:06:01] /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
                `TopOffers`.*,
                `SubOffers`.`ID` AS `SubOffers`
	        FROM
	        	`offers` AS `TopOffers`
                LEFT JOIN `offers` AS `SubOffers` ON
                    `SubOffers`.`ParentID` = `TopOffers`.`ID` AND
                    `SubOffers`.`Language` = `TopOffers`.`Language`
	    	WHERE
                `TopOffers`.`Language` = 'bg' AND
                `TopOffers`.`URLLabel` = 'хърватия--словения-загреб-плитвички-езера-постойна-опатия'
         AND `TopOffers`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFrom','LUntil','LBookNow','LPriceFrom','LGallery','LProgram','LReadMore','LPrices','LAccommodation','LAdditionalExcursions','LFAQ','LDays','LPrice','LDeposit') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `programs`.*
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`OfferID` = 254 AND
                `programs`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 GROUP BY `programs`.`ID` ORDER BY `programs`.`StartFrom` ASC

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                *
            FROM
                `programs`
            WHERE
                `Language` = 'bg' AND
                `ID` = 1457
         AND `Visible` = 1 LIMIT 1

SELECT
                    `accommodation`.*,
                    `programs`.`PromoDate`
                FROM
                    `accommodation`
                    INNER JOIN `offers` ON
                        `accommodation`.`OfferID` = `offers`.`ID` AND
                        `offers`.`Language` = `accommodation`.`Language`
                    INNER JOIN `rooms` ON
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`ProgramID` = 1457
                    LEFT JOIN `programs` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `programs`.`Language` = `accommodation`.`Language`
                WHERE
                    `accommodation`.`OfferID` = 254 AND
                    `accommodation`.`Language` = 'bg'
             AND `accommodation`.`Visible` = 1 AND `offers`.`Visible` = 1
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

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

SELECT
			    `Price`,
			    `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
			    `AccommodationID` = 795 AND
			    `ProgramID` = 1457 AND
			    `Language` = 'bg' AND
			    `Visible` = 1
			ORDER BY `Price` ASC
			LIMIT 1

SELECT * FROM `faq` WHERE `OfferID` = 254 AND `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` 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
# [21-Jun-2025 09:15:44] /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
                `TopOffers`.*,
                `SubOffers`.`ID` AS `SubOffers`
	        FROM
	        	`offers` AS `TopOffers`
                LEFT JOIN `offers` AS `SubOffers` ON
                    `SubOffers`.`ParentID` = `TopOffers`.`ID` AND
                    `SubOffers`.`Language` = `TopOffers`.`Language`
	    	WHERE
                `TopOffers`.`Language` = 'bg' AND
                `TopOffers`.`URLLabel` = 'хърватия--словения-загреб-плитвички-езера-постойна-опатия'
         AND `TopOffers`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFrom','LUntil','LBookNow','LPriceFrom','LGallery','LProgram','LReadMore','LPrices','LAccommodation','LAdditionalExcursions','LFAQ','LDays','LPrice','LDeposit') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `programs`.*
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`OfferID` = 254 AND
                `programs`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 GROUP BY `programs`.`ID` ORDER BY `programs`.`StartFrom` ASC

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                *
            FROM
                `programs`
            WHERE
                `Language` = 'bg' AND
                `ID` = 1457
         AND `Visible` = 1 LIMIT 1

SELECT
                    `accommodation`.*,
                    `programs`.`PromoDate`
                FROM
                    `accommodation`
                    INNER JOIN `offers` ON
                        `accommodation`.`OfferID` = `offers`.`ID` AND
                        `offers`.`Language` = `accommodation`.`Language`
                    INNER JOIN `rooms` ON
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`ProgramID` = 1457
                    LEFT JOIN `programs` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `programs`.`Language` = `accommodation`.`Language`
                WHERE
                    `accommodation`.`OfferID` = 254 AND
                    `accommodation`.`Language` = 'bg'
             AND `accommodation`.`Visible` = 1 AND `offers`.`Visible` = 1
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

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

SELECT
			    `Price`,
			    `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
			    `AccommodationID` = 795 AND
			    `ProgramID` = 1457 AND
			    `Language` = 'bg' AND
			    `Visible` = 1
			ORDER BY `Price` ASC
			LIMIT 1

SELECT * FROM `faq` WHERE `OfferID` = 254 AND `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` 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
# [21-Jun-2025 09:15:45] /rapsody/root/bg/ajax/basket/qty.html?_=1750486545418 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '64a5b4ee5647b8f112df28858b22022dedb11501d2cfb77316c1953fefe8f490'
            LIMIT 1
# [21-Jun-2025 09:16:19] /rapsody/root/bg/блог/valdisere-info.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
                *
	        FROM
	        	`articles`
	    	WHERE
                `URLLabel` = 'valdisere-info' AND
	    		`Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `PostDate`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Visible`
            FROM
                `articles`
            WHERE
                `ID` != 34 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
# [21-Jun-2025 10:13:40] /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
                `TopOffers`.*,
                `SubOffers`.`ID` AS `SubOffers`
	        FROM
	        	`offers` AS `TopOffers`
                LEFT JOIN `offers` AS `SubOffers` ON
                    `SubOffers`.`ParentID` = `TopOffers`.`ID` AND
                    `SubOffers`.`Language` = `TopOffers`.`Language`
	    	WHERE
                `TopOffers`.`Language` = 'bg' AND
                `TopOffers`.`URLLabel` = 'хърватия--словения-загреб-плитвички-езера-постойна-опатия'
         AND `TopOffers`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFrom','LUntil','LBookNow','LPriceFrom','LGallery','LProgram','LReadMore','LPrices','LAccommodation','LAdditionalExcursions','LFAQ','LDays','LPrice','LDeposit') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `programs`.*
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`OfferID` = 254 AND
                `programs`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 GROUP BY `programs`.`ID` ORDER BY `programs`.`StartFrom` ASC

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                *
            FROM
                `programs`
            WHERE
                `Language` = 'bg' AND
                `ID` = 1457
         AND `Visible` = 1 LIMIT 1

SELECT
                    `accommodation`.*,
                    `programs`.`PromoDate`
                FROM
                    `accommodation`
                    INNER JOIN `offers` ON
                        `accommodation`.`OfferID` = `offers`.`ID` AND
                        `offers`.`Language` = `accommodation`.`Language`
                    INNER JOIN `rooms` ON
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`ProgramID` = 1457
                    LEFT JOIN `programs` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `programs`.`Language` = `accommodation`.`Language`
                WHERE
                    `accommodation`.`OfferID` = 254 AND
                    `accommodation`.`Language` = 'bg'
             AND `accommodation`.`Visible` = 1 AND `offers`.`Visible` = 1
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

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

SELECT
			    `Price`,
			    `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
			    `AccommodationID` = 795 AND
			    `ProgramID` = 1457 AND
			    `Language` = 'bg' AND
			    `Visible` = 1
			ORDER BY `Price` ASC
			LIMIT 1

SELECT * FROM `faq` WHERE `OfferID` = 254 AND `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` 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
# [21-Jun-2025 10:13:41] /rapsody/root/bg/ajax/basket/qty.html?_=1750490021507 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '64a5b4ee5647b8f112df28858b22022dedb11501d2cfb77316c1953fefe8f490'
            LIMIT 1
# [21-Jun-2025 10:18:19] /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
                *
	        FROM
	        	`articles`
	    	WHERE
                `URLLabel` = 'град-на-бъдещето-дубай' AND
	    		`Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `PostDate`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Visible`
            FROM
                `articles`
            WHERE
                `ID` != 6 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
# [21-Jun-2025 10:19:02] /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
                `TopOffers`.*,
                `SubOffers`.`ID` AS `SubOffers`
	        FROM
	        	`offers` AS `TopOffers`
                LEFT JOIN `offers` AS `SubOffers` ON
                    `SubOffers`.`ParentID` = `TopOffers`.`ID` AND
                    `SubOffers`.`Language` = `TopOffers`.`Language`
	    	WHERE
                `TopOffers`.`Language` = 'bg' AND
                `TopOffers`.`URLLabel` = 'хърватия--словения-загреб-плитвички-езера-постойна-опатия'
         AND `TopOffers`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFrom','LUntil','LBookNow','LPriceFrom','LGallery','LProgram','LReadMore','LPrices','LAccommodation','LAdditionalExcursions','LFAQ','LDays','LPrice','LDeposit') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `programs`.*
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`OfferID` = 254 AND
                `programs`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 GROUP BY `programs`.`ID` ORDER BY `programs`.`StartFrom` ASC

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                *
            FROM
                `programs`
            WHERE
                `Language` = 'bg' AND
                `ID` = 1457
         AND `Visible` = 1 LIMIT 1

SELECT
                    `accommodation`.*,
                    `programs`.`PromoDate`
                FROM
                    `accommodation`
                    INNER JOIN `offers` ON
                        `accommodation`.`OfferID` = `offers`.`ID` AND
                        `offers`.`Language` = `accommodation`.`Language`
                    INNER JOIN `rooms` ON
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`ProgramID` = 1457
                    LEFT JOIN `programs` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `programs`.`Language` = `accommodation`.`Language`
                WHERE
                    `accommodation`.`OfferID` = 254 AND
                    `accommodation`.`Language` = 'bg'
             AND `accommodation`.`Visible` = 1 AND `offers`.`Visible` = 1
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

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

SELECT
			    `Price`,
			    `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
			    `AccommodationID` = 795 AND
			    `ProgramID` = 1457 AND
			    `Language` = 'bg' AND
			    `Visible` = 1
			ORDER BY `Price` ASC
			LIMIT 1

SELECT * FROM `faq` WHERE `OfferID` = 254 AND `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` 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
# [21-Jun-2025 11:38:06] /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
# [21-Jun-2025 11:38:06] /rapsody/root/bg/ajax/basket/qty.html?_=1750495087298 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '64a5b4ee5647b8f112df28858b22022dedb11501d2cfb77316c1953fefe8f490'
            LIMIT 1
# [21-Jun-2025 19:26:56] /rapsody/root/bg/shop.html 167.99.142.201

set names utf8

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

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

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

SELECT * FROM (SELECT
	        	*,
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AS `Promo`
	        FROM
	        	`products`
                INNER JOIN `product_texts` ON `products`.`ID` = `product_texts`.`ProductID`
	    	WHERE
                `Language` = 'bg' AND
                `Gallery` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC) AS tmp_table GROUP BY LOWER(`RefID`)

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'products' 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
