# [03-Nov-2025 00:47:24] /rapsody/www/bg/япония.html 108.61.209.243

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` = 264 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` = 1534 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1534 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`OfferID` = 264 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 863 AND
			    `rooms`.`ProgramID` = 1534 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 863 AND
				`ProgramID` = 1534 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 264 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 01:47:57] /rapsody/www/bg/valfrejus.html 108.61.209.243

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'valfrejus' 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` = 'valfrejus'
         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` = 77 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` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1571 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`OfferID` = 77 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 30 AND
			    `rooms`.`ProgramID` = 1504 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 30 AND
				`ProgramID` = 1504 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 77 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 02:43:28] /rapsody/www/bg/япония.html 108.61.209.243

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` = 264 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` = 1534 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1534 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`OfferID` = 264 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 863 AND
			    `rooms`.`ProgramID` = 1534 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 863 AND
				`ProgramID` = 1534 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 264 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 03:53:57] /rapsody/www/bg/шри-ланка.html 108.61.209.243

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` = 202 AND
                `programs`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 GROUP BY `programs`.`ID` ORDER BY `programs`.`StartFrom` ASC

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 0 AND
                `accommodation`.`OfferID` = 202 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`Visible` = 1
            
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

SELECT * FROM `faq` WHERE `OfferID` = 202 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 04:58:35] /rapsody/www/bg/япония.html 108.61.209.243

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` = 264 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` = 1534 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1534 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`OfferID` = 264 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 863 AND
			    `rooms`.`ProgramID` = 1534 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 863 AND
				`ProgramID` = 1534 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 264 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 06:04:15] /rapsody/www/bg/valfrejus.html 108.61.209.243

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'valfrejus' 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` = 'valfrejus'
         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` = 77 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` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1571 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`OfferID` = 77 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 30 AND
			    `rooms`.`ProgramID` = 1504 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 30 AND
				`ProgramID` = 1504 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 77 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 07:12:53] /rapsody/www/bg/япония.html 108.61.209.243

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` = 264 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` = 1534 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1534 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`OfferID` = 264 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 863 AND
			    `rooms`.`ProgramID` = 1534 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 863 AND
				`ProgramID` = 1534 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 264 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 08:13:51] /rapsody/www/bg/шри-ланка.html 108.61.209.243

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` = 202 AND
                `programs`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 GROUP BY `programs`.`ID` ORDER BY `programs`.`StartFrom` ASC

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 0 AND
                `accommodation`.`OfferID` = 202 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`Visible` = 1
            
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

SELECT * FROM `faq` WHERE `OfferID` = 202 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 09:13:55] /rapsody/www/bg/shop.html 108.61.209.243

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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 09:14:18] /rapsody/www/bg/ajax/basket/qty.html?_=1762154037022 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5e45fe417d73519c4a11cf5c76519460e810564c389e6f938d6bbfc39b796163'
            LIMIT 1
# [03-Nov-2025 09:26:17] /rapsody/www/bg/япония.html 108.61.209.243

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` = 264 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` = 1534 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1534 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`OfferID` = 264 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 863 AND
			    `rooms`.`ProgramID` = 1534 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 863 AND
				`ProgramID` = 1534 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 264 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 10:23:40] /rapsody/www/bg/valfrejus.html 108.61.209.243

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'valfrejus' 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` = 'valfrejus'
         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` = 77 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` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1571 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`OfferID` = 77 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 30 AND
			    `rooms`.`ProgramID` = 1504 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 30 AND
				`ProgramID` = 1504 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 77 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 11:30:14] /rapsody/www/bg/япония.html 108.61.209.243

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` = 264 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` = 1534 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1534 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`OfferID` = 264 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 863 AND
			    `rooms`.`ProgramID` = 1534 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 863 AND
				`ProgramID` = 1534 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 264 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 12:27:00] /rapsody/www/bg/шри-ланка.html 108.61.209.243

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` = 202 AND
                `programs`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 GROUP BY `programs`.`ID` ORDER BY `programs`.`StartFrom` ASC

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 0 AND
                `accommodation`.`OfferID` = 202 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`Visible` = 1
            
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

SELECT * FROM `faq` WHERE `OfferID` = 202 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 13:34:46] /rapsody/www/bg/япония.html 108.61.209.243

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` = 264 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` = 1534 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1534 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`OfferID` = 264 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 863 AND
			    `rooms`.`ProgramID` = 1534 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 863 AND
				`ProgramID` = 1534 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 264 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 14:31:26] /rapsody/www/bg/valfrejus.html 108.61.209.243

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'valfrejus' 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` = 'valfrejus'
         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` = 77 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` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1571 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`OfferID` = 77 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 30 AND
			    `rooms`.`ProgramID` = 1504 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 30 AND
				`ProgramID` = 1504 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 77 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 15:25:39] /rapsody/www/bg/япония.html 108.61.209.243

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` = 264 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` = 1534 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1534 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`OfferID` = 264 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1534 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 863 AND
			    `rooms`.`ProgramID` = 1534 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 863 AND
				`ProgramID` = 1534 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 264 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 16:02:39] /rapsody/www/bg/карнавалът-в-рио.html 108.61.209.243

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` = 243 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` = 1522 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1522 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1522 AND
                `accommodation`.`OfferID` = 243 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1522 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 872 AND
			    `rooms`.`ProgramID` = 1522 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 872 AND
				`ProgramID` = 1522 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 243 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 16:37:15] /rapsody/www/bg/шри-ланка.html 108.61.209.243

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` = 202 AND
                `programs`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 GROUP BY `programs`.`ID` ORDER BY `programs`.`StartFrom` ASC

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 0 AND
                `accommodation`.`OfferID` = 202 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`Visible` = 1
            
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

SELECT * FROM `faq` WHERE `OfferID` = 202 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 17:20:31] /rapsody/www/bg/valfrejus.html 108.61.209.243

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'valfrejus' 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` = 'valfrejus'
         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` = 77 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` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1571 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`OfferID` = 77 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 30 AND
			    `rooms`.`ProgramID` = 1504 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 30 AND
				`ProgramID` = 1504 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 77 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 17:59:38] /rapsody/www/bg/доминикана-пунта-кана.html 108.61.209.243

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` = 201 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` = 1477 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1477 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1477 AND
                `accommodation`.`OfferID` = 201 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1477 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 810 AND
			    `rooms`.`ProgramID` = 1477 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 810 AND
				`ProgramID` = 1477 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 201 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 18:37:14] /rapsody/www/bg/виетнам-и-камбоджа-изгубени-империи.html 108.61.209.243

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` = 217 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` = 1531 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1531 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1531 AND
                `accommodation`.`OfferID` = 217 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1531 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 553 AND
			    `rooms`.`ProgramID` = 1531 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 553 AND
				`ProgramID` = 1531 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 217 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 19:26:13] /rapsody/www/bg/valfrejus.html 108.61.209.243

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'valfrejus' 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` = 'valfrejus'
         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` = 77 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` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1571 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`OfferID` = 77 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 30 AND
			    `rooms`.`ProgramID` = 1504 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 30 AND
				`ProgramID` = 1504 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 77 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 19:57:14] /rapsody/www/bg/карнавалът-в-рио.html 108.61.209.243

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` = 243 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` = 1522 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1522 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1522 AND
                `accommodation`.`OfferID` = 243 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1522 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 872 AND
			    `rooms`.`ProgramID` = 1522 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 872 AND
				`ProgramID` = 1522 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 243 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 20:25:52] /rapsody/www/bg/шри-ланка.html 108.61.209.243

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` = 202 AND
                `programs`.`Language` = 'bg' AND
                `programs`.`EndTo` >= CURDATE()
         AND `programs`.`Visible` = 1 GROUP BY `programs`.`ID` ORDER BY `programs`.`StartFrom` ASC

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 0 AND
                `accommodation`.`OfferID` = 202 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`Visible` = 1
            
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

SELECT * FROM `faq` WHERE `OfferID` = 202 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 21:02:38] /rapsody/www/bg/valfrejus.html 108.61.209.243

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'valfrejus' 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` = 'valfrejus'
         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` = 77 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` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1571 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`OfferID` = 77 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 30 AND
			    `rooms`.`ProgramID` = 1504 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 30 AND
				`ProgramID` = 1504 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 77 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 21:31:11] /rapsody/www/bg/доминикана-пунта-кана.html 108.61.209.243

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` = 201 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` = 1477 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1477 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1477 AND
                `accommodation`.`OfferID` = 201 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1477 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 810 AND
			    `rooms`.`ProgramID` = 1477 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 810 AND
				`ProgramID` = 1477 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 201 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 22:04:04] /rapsody/www/bg/виетнам-и-камбоджа-изгубени-империи.html 108.61.209.243

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` = 217 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` = 1531 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1531 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1531 AND
                `accommodation`.`OfferID` = 217 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1531 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 553 AND
			    `rooms`.`ProgramID` = 1531 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 553 AND
				`ProgramID` = 1531 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 217 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 22:32:11] /rapsody/www/bg/нова-година-доминикана.html 108.61.209.243

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` = 261 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` = 1497 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1497 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1497 AND
                `accommodation`.`OfferID` = 261 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1497 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 847 AND
			    `rooms`.`ProgramID` = 1497 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 847 AND
				`ProgramID` = 1497 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 261 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 23:07:39] /rapsody/www/bg/valfrejus.html 108.61.209.243

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'valfrejus' 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` = 'valfrejus'
         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` = 77 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` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1571 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1504 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`OfferID` = 77 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1504 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 30 AND
			    `rooms`.`ProgramID` = 1504 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 30 AND
				`ProgramID` = 1504 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 77 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Nov-2025 23:35:22] /rapsody/www/bg/карнавалът-в-рио.html 108.61.209.243

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` = 243 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` = 1522 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1522 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                `accommodation`.*,
                `programs`.`PromoDate`
            FROM
                `accommodation`
                INNER JOIN `programs` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `programs`.`Language` = `accommodation`.`Language`
            WHERE
                `programs`.`ID` = 1522 AND
                `accommodation`.`OfferID` = 243 AND
                `accommodation`.`Language` = 'bg'
         AND 
                `accommodation`.`Visible` = 1 AND 
                `programs`.`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 DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1522 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 872 AND
			    `rooms`.`ProgramID` = 1522 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 872 AND
				`ProgramID` = 1522 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 243 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,
                    `calendar`.`URLLabel` DESC,
                    `offers`.`PostDate` ASC

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