# [08-May-2025 07:31:41] /rapsody/root/ 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [08-May-2025 07:31:43] /rapsody/root/bg/ajax/reservations/offers.html?_=1746678703424 167.99.142.201

set names utf8

SELECT
                `offers`.`ID`,
                `offers`.`UploadID`,
                `offers`.`Title`,
                `offers`.`Image`,
                COUNT(`rooms`.`ID`) AS `All`,
                COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`Image` <> '' AND
                `offers`.`BookURL` = '' AND
                `offers`.`MenuLabel` <> '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY
                `offers`.`ID`
            ORDER BY
                `programs`.`StartFrom` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LChooseVacation') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 07:31:44] /rapsody/root/bg/ajax/reservations/accommodation/oid_254.html?_=1746678704550 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `reservations`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755' AND
                `OfferID` = 254 AND
                `Status` = 0
            LIMIT 1

SELECT
                `programs`.`OfferID`,
                `offers`.`Title`,
                `programs`.`PromoDate`,
                `programs`.`Deposit`,
                `offers`.`Currency`,
                COUNT(`rooms`.`ID`) AS `All`,
                COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`ID` = 254 AND
                `offers`.`BookURL` = '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `reservation_rooms`.`RoomID` IS NULL
            ORDER BY
                `programs`.`StartFrom` ASC
            LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `additionaloffers`
            WHERE
                `OfferID` = 254 AND
                `Language` = 'bg' AND
                `Visible` = 1

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

INSERT INTO `reservations` SET `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755', `PostDate` = '2025-05-08 07:31:44', `LastUpdate` = '2025-05-08 07:31:44', `OfferID` = '254', `ProgramID` = 0, `AccommodationID` = 0, `Data` = 'W5d0_NSlr3gsLzfaeyhoKn0uSp_1CRiQBGsPt0_0pjwkvQ0UpFRXKUo0cUDDt1oyU7fGRRKUyOcH5b31abljvpKkl2B7_ip2j-hrGz_oT4ks7KokqLCQApMDlbNmqR0RAV-gP6D3KiPfzAj5epVhLuLDFUODo1r5SDgGaffdYF_Cz07A5UGNLp8kvKX1c_KhQSKwUt7jJ_aPrVf1YycNQ2i0ICBbDgqskmKKSiphzCfDxAeYlZ3XYfnxkw3Z1INxOdtetRSkJrngjDVN0-oEp_r-_IPmXYsdnNCHs89p5gYYLe_E9g3L8C_R9wTjPTZ9J_lTGAVXpnHFrkMFdjoEGa1D-CD8HVIhTMdnahPshUHokSb_DTVd3e_rIbswIAPQQGipRyU8F3VUR8HJHl5S4zbXhp5odk0A8u9zYRUt30Q', `Progress` = 1

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1

SELECT
				COUNT(`rooms`.`ID`) - COUNT(`reservation_rooms`.`RoomID`) AS `Avl`
			FROM
				`programs`
				INNER JOIN `accommodation` ON
					`accommodation`.`OfferID` = `programs`.`OfferID` AND
					`accommodation`.`Language` = `programs`.`Language` AND
					`accommodation`.`Visible` = 1
				INNER JOIN `rooms` ON
					`rooms`.`ProgramID` = `programs`.`ID` AND
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language` AND
					`rooms`.`Visible` = 1
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`programs`.`Visible` = 1 AND
				`programs`.`OfferID` = 254

SELECT
                `programs`.`ID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`BookURL` = '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `programs`.`OfferID` = 254 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY
                `programs`.`ID`
            ORDER BY
                `programs`.`StartFrom` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LRoomsReserve','LAdults','LChildren12','LAccommodation','ErrorRoomNum') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

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

SELECT
                `PromoDate`
            FROM
                `programs`
            WHERE
                `ID` = 1457
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 07:31:46] /rapsody/root/bg/ajax/reservations/rooms/pid_1457/aid_795.html?_=1746678706616 167.99.142.201

set names utf8

SELECT
				`rooms`.* ,
				(
					SELECT
						GROUP_CONCAT(R1.`ID`)
					FROM
						`rooms` AS R1
						LEFT OUTER JOIN `reservation_rooms` AS RR1 ON RR1.`RoomID` = R1.`ID`
					WHERE
						R1.`AccommodationID` = 795 AND
						R1.`ProgramID` = 1457 AND
						`rooms`.`Title` = R1.`Title` AND
						`rooms`.`Beds` = R1.`Beds` AND
						`rooms`.`Price` = R1.`Price` AND
						R1.`Visible` = 1 AND
						RR1.`RoomID` IS NULL
				) AS `IDs`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`AccommodationID` = 795 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`rooms`.`Price` ASC,
				`rooms`.`PromoPrice` ASC

SELECT
				`offers`.`Currency`
			FROM
				`offers`
				INNER JOIN `programs` ON
					`programs`.`OfferID` = `offers`.`ID` AND
					`programs`.`Language` = `offers`.`Language`
			WHERE
				`programs`.`ID` = 1457 AND
				`offers`.`Language` = 'bg'
			LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorGuestNum','LRoomTypeQuestion','ErrorOption','LEmptyBedsInfo') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 07:31:49] /rapsody/root/bg/ajax/rooms/empty-bed-price/23743.html?_=1746678709220 167.99.142.201

set names utf8

SELECT
				`rooms`.`PriceEmptyBed`,
				`offers`.`Currency`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [08-May-2025 07:31:50] /rapsody/root/bg/ajax/reservations/guests/1127962/progress_2.html?_=1746678710655 167.99.142.201

set names utf8

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

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1

SELECT
                `StartFrom`,
                `EndTo`,
                `Deposit`,
                `PromoDate`,
                `Nights`
            FROM
                `programs`
            WHERE
                `ID` = 1457 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `accommodation`.`ID` = 795 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 07:31:50', `ProgramID` = '1457', `AccommodationID` = '795', `Data` = 'aUfbNpwY9UrYaA75_j7JGTtVkYQn04sacGBDcL0EH719-e-5NSH2UxSXxeEXBmwXC-436vOOYB2zDcauynbWpIQO8BhFBZgIqTi9sGNQS6ES-a6aRUAFUvvwDf3ENhZS5KyBGMny6tj5wVrexpdtwdPRD39uZZkqgkVGnA-Slm9TVgeUcJPlfdXwkBS_ky5_l6mLWmlaTKAUWkmOPEQf06tCKxnsM3u_jPCUSzke12KtChwzAeZBZSGeQcpOxkAQs9ZhyHZro786cG-wvnbnI9jPMo4PVAGuJ6Ej9bU0_esptPYL0sLjRRIvCX92YDzku0aTleEGlFJvjWUsR88GsN1wgfU2MsN_3P6kdhHhIiiOzgw8s9dvggbpoeae5clgxOhZzI1x1W2Kulb4Pjo-BWYpTOwd6yxICukQUgbPaOSRNiSjrB3OMJ1OWw2aTG1SMw8kwpBZ0rzTJiJtVaX185jXiVA5sHNmFjjI1KbBlAhYBrF_F2HTceBqnHCjlrc0LS1HIVGuXJFl6XGS-TO5d2-bJoGZ6oQReX0770UWxTZyyzZcJDv25Uc3K0cg1UQjMzsFLCBcLS-tWxnv1Kcam4kqvkr-on-TJM-BNeEEmLvIb-pDOneV_SN_qjr4Twm91XEDuN1LMxU1wqum4S6KYhXwiM8DINDUFXuOyDWp7rbVIdYoSQbG8kaJzpfnV1QRQD9K_SINJyzjTJPgbGrHzPLTWjRY1mQbnUB_Iy88VE-MTFXMGasQpxk81TXfZBi5VDbgy8e7WIjajF68YsYS2NoQOpAo7IEPSqj9u2EUQlg', `Progress` = '2' WHERE `ID` = '1127962'

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorFullNameLatin','ErrorPIN','ErrorPassport','ErrorExpiryDate','ErrorValidEMail','ErrorPhone') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LFullNameLatin','LEGN','LPassport','LExpiryDate','LBirthDate','LEMail','LPhone','LGuest','LChild12','LFillLess','LFillAll','LAgreeText','LAgreeData','ErrorIAgreeCheck') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 07:32:18] /rapsody/root/bg/ajax/reservations/additionaloffers/1127962/progress_3.html?_=1746678738072 167.99.142.201

set names utf8

SELECT
				`Beds`
			FROM
				`rooms`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 07:32:18', `SentDate` = '2025-05-08', `Data` = 'Ysg9QKbzdg2Epw4n2Yscsl7l1oRvukpjuyvl3_SCf_NxXKAyI92ozt2UNCSa-EsH_M5SEIxuGAFmZMyXY8qIN6PYkJmQYtveLB3DWAVsrG9g82aGYGEJM3vh83SCI1syEHa_LZ9iVTE7CfmJBapfI4ivYNqEA7iM-5EBWcMFNE6_4b1mztEnxzV90uSvmS2v4LF_Bi11nwokcenn52-Bl31KwJoboKsmwZulQE3nXfa8u0CZxfVeT_tPWT1CguzVmWMQeyKHTWkw09Bg-Qnf6hyOgHidyWvR2tKN8DgsTojxCBm2sBp4kyf0K0zXGSazdLoR2SXKTQ_vwX6fXUOG5_sS0vGkRXB4VDtHvJCpzDgX_Cn9OO_RD8ibN7wsXlYW_C3qapsvqSNv2gk1S3_fda4k3cuCUtFg6XPOX9YM7BHPhnqaOk0fiIltled_xGsIETuun-W7PtR_7XGEcVKunsWQ4txx3GQQmiUO1uyYbBCgc21fsooCh-gOS-P4DCVrn0MzxPNBWgXXqYkEoz7e3MkeX8PhK8O9k7iloZOW5y8yEr3mK4sayPn4GtbBp3VX0vr-HofLZ3Op1Zd-mEsLQxmFX21hTfZ43-5k0WKmXM7_pWhOreIA8zjbU2SWathvKeHbA2LPbJVLweDhp7XMgJ0B0TO0b9yVgK7-44BVfd_Dcg_py-Fs3ACgVduFvtDs21U-6pfiDUznOvqIZ085k5pWWjKjAQdAhTDfuDhcLaGfyHtsarr0k6LFzy_YVBho4SUViBGi8LFjjcmxdqbDkd9tIX2S712A09Y08yt7moQ9ZHDCcJXCCptz7sbIeqOjQSKUWQ0eqwEl9THxVcrfi6pUEvp0hTTRjy4wUXhPlTz4A7oJcUy-p2jETwUXNRdu_mfql8YmHgMGK08kcfRlxdwQbohlDmX4YzdGotNE6znOSxksazpz9zuh1ymk0C0VOPdK5LmHE_e_e4apXlSsaa_fK-Wuhov1yHf_WfQu-XJRzKR00qpzH9mcKdqCamM-MhP-IthSzRVcguxoyKtWevGYu1ccC8StkZ5AwMNTcn5IVQWCwuhzWfQJAKR3MNssknn7EPON8m6GQVwHWgoxoRdgXB5tvTmfCDL-nqwThNLKsKBs4_BYsnih4HhRulB6NEwGwwjzqbwjfP9prDw_S0RO_3D1F1UrRnWyE4lK8vjN5to-5uC_01qIr3WJX5T1o7mqG74xvSa73fVAhAJ-ehykkJ9r1WpbhO77xd-7C1jQvzNzGYRHJZxEV-sb5g6Z4cvMv-R1DRvYJArJvQtOlmRduBxxFl0TvlJirzNy5JdVs8GHjGROseJjfOp1uhlyLukTONyCIO8WJsWTTkSCMswti9PTkH1Lk51C3ssEPCrxhV0G-6Lg3q0acnF2PCopfP-7X-XKV0VUutKIIjPkyBxmZbsdy0f-_EVNcodmc3L1coUYVu0OIsg_42KppDsI9ztw-yrBjAXqUdTwdLqzw79yPSO6xI_zbjepoTPwpswGMmkq03r0Y25WSvOsrXUefJO0rSQC84cUa1Waqaf8M0XSjtcUEph_oqaF7fHxySRoDzg3r6WSy-Pm0EbCq0crTI0J4Nv5XNVWyqt5kzO_MU0Pp9ywPqyyVto7uEsUFKDNY5aovWkP-18UyL46_JEup64XPc5w1ANTuFSDG4Z1DtORybW9d5CiA4BjEV6CPbWDD2EZtpWFE0XMZHNWVWnj6lShA_iJKEYyom-GILm74w', `Progress` = '3' WHERE `ID` = '1127962'

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1

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

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

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23743 AND
				`Visible` = 1
			LIMIT 1

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23743 AND
				`Visible` = 1
			LIMIT 1

SELECT
                `additionaloffers`.*,
                `offers`.`Currency`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON
                    `additionaloffers`.`OfferID` = `offers`.`ID` AND
                    `additionaloffers`.`Language` = `offers`.`Language`
            WHERE
                `additionaloffers`.`OfferID` = 254 AND
                `additionaloffers`.`Language` = 'bg' AND
                (`additionaloffers`.`ProgramID` = 1457 OR `additionaloffers`.`ProgramID` = 0)
         AND `additionaloffers`.`Visible` = 1 AND `offers`.`Visible` = 1 ORDER BY `additionaloffers`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 07:32:19] /rapsody/root/bg/ajax/reservations/summary/1127962/progress_4.html?_=1746678739615 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 07:32:19', `SentDate` = '2025-05-08', `Data` = 'xLxZCh1GTw-kd1MVh-ZxWiEZSlg0bhYkHCq_XQN2n6QEx2z2bKAV8mwbDSEdbc1tHNFDdU6IL2gDqEPXI7yzezLVD4TYSbhTQAEdfCfOtIitJ1SUsd45qGoPJhc43SyTXT6I_7fOXSA1XapZdu9ssbQUtLOceRVUIEfvsJJJge21b_zyJHsttTPk4TWdspLMEgwgD0l9i32rO6Xz-LQ1kvU4udt3JRK5LoxwEK9My3WgURo_mEo2mP1lGE2EHXk5pt4rNFsV99z0b639cgDXvSMkYBmKCHDv0X_saRYxlh1qPHrkJb_QL6CC0InYMby2NZekWbuosGkuUjFKX4IGsMdD4mllgyrCy1vh_alewn-s753myfQHDkwXiEXzL9_7PezkQsPvdaw1O8n_FhXOCp9S3aP68z4XYHNd4ZGUe-4brY-auWX3A4qZMzIjjpDRtHjJLPGCSTTOGmS9hR2ajWB3k4rYCMMrGBkmtgcW2GRNTOlMlEvYnk6AcVOIndkKt4DN7PU47ATaWIkZdoP13sD2gMoHL06plNNz1DRleZ2D1LdQ244aSC4Z_gUrY5OOG1WpSdLkAOSLGRM23eZDKchx0oyhNmHsdHYKtrAdIUhHSMtNu7lCGHddbfdhBdY00Rfu9YT3LQsJ26R6IkP735ZiBqPm9fFqIcRS99B6SK8kmV0-Nu6m-6-K7Oae9tJKaV2_OhBHkURzmlgbwIkcwSaRVq5Gwy60nSNKFmctzwT9XGwdGJLpKVymxmH94GU2B82pcMw1ofUxeRkyJdLR9kk09rVVLNxZLI-XQ7JVJz-M9U_AXcxLqUVDEQz9zQpy22QZ9wuDh_25avfRP_rX6pkB6IwGUFf56TJVYAZqRGEat9LsmEMzBUMfYeD3EYaBmhO7jnbYhirsm0PovyjIwomcmzZ1fFdfKrhD1pGTtWrwXDXwp8RsW1M-rAqa8hau4obJKNLDs8oesGqycpJH_f2ubCDNTuK2WF8wQh3sil3vyy_3tJlXlgqa7Nr-DKNUjStBjRLWjy5QsPjuXi5wWs1QjaQ12kTeRrZVeZakW-A_E4nRwXOAt04_wn1hEiibhCAG_MJYznEwqaVZx_Asw5pPTqzsdSh0VEzLWqRybumfq7xXMr6xVnNmFJamXNXtnfqQ1s-RgFJYDSbhYsku7_xXOjTVLQ3nZs8NJ0PAx9s5blbWMf-hErefPnDwPbYsp1uSoHFBBbeioOtQ0wnoPMu2vzCz3A2wZq_J1D1KvH-of-r2pjCoQEf6mtnZPgd3inn0NOo3U7xanBpgL3lUfQzT5FBmR2Hqud7RlKEEOSskdw0A4HeFtVSrRccvirv5cLzh_SB0p7EHq8hAGIYt4mmFo8OUYg6VrsNoUMWa306dDn8IsCsiEuW3UagYBnBDjG_z8RU7jMTNQe6UmZpzK_ypmjGuXVjq13BIrY2ekmOlrUrREpIoTUN1tK4U2luh1FEZtkrqY2H-Dy5y7JIzv73GvW0fDR0LxKYZd9WNjAOXAA9CksloAIzTfCLdi7j6gAjCH9D-CZph1RFtD894ARjh0J0bu4RCXMFCFDokDgeHaowTHFtpdpkVGDmsVN5i8PKRZfvkCa3MjS5Yuzka8ELHoxO5iuBvTm9siYsyD_0CalKnOps0OFnksbn8cU7wokbjEy3Vq5fxmqVaV7oSl1w4Qlw8tavYKdgjhRMAQwjFDr-qYAocFLkS1qiNcTCRsB-CsCi-uTpJrJ5-gDR5YAzohjM-gEU7BpWXPRUih4OKDpZhnwh2hBOc7FcgVgwDw2EUqSZ3Jcy3ci94xfe_UGUHO_Q7H_AIF-UWC3lt724GmtIngsBH-Bm2lm5SfyNxaFLnulp3VDt_WL9miwst5w', `Progress` = '4' WHERE `ID` = '1127962'

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.`AccommodationID`,
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`,
				`reservation_rooms`.`ReservationID`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEarlyBookingDiscount','LLoyalCustomerDiscount','LDeposit','LIntermediatePayment','LFinalPayment','LChildren12','LGuest','LChild12','LName','LBirthDate','LEMail','LEGN','LLKPassport','LPhone','LAccommodation','LAgreeMsg','LAgreeGeneralRules','LAgreeTourist','LAgreeBuletin','LFreeBedsPayment','LReservationInfo','LCheckIn','LCheckOut','LRoomsNum','LAdults','LHolder','LEditData','LTotal','LAdult','LPrice','LPayWithCard','LLearnedAboutTrip','LBusFellow','LPromoCode','LApply','ErrorPromoCode','LPaymentType','LPaymentDates','LTotalSum','LFreeBedsNum','LSum','LChoosePayment','LPaymentCard','LPaymentBank','LPaymentCash','LChoosePaymentSum','LPayAll','LPaymentSum') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

UPDATE
                `reservations`
            SET
                `LastUpdate` = NOW(),
                `Progress` = 4
            WHERE
                `ID` = 1127962
            LIMIT 1

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `accommodation`.`ID` = 795 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

SELECT
                `StartFrom`,
                `EndTo`,
                `Deposit`,
                `PromoDate`,
                `Nights`
            FROM
                `programs`
            WHERE
                `ID` = 1457 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 254 AND
                `CardKey` = '9ea5b1a195a495aa246c63781bcbb860' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `ID`
            FROM
                `promocodes`
            WHERE
                `OfferID` = 254 AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                (`ProgramID` = 1457 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                `Visible` = 1
            LIMIT 1

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

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

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1
# [08-May-2025 07:32:24] /rapsody/root/bg/ajax/reservations/confirm/1127962/progress_5.html?_=1746678744286 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.`AccommodationID`,
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`,
				`reservation_rooms`.`ReservationID`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 07:32:24', `SentDate` = '2025-05-08', `Keywords` = 'Y2FyZAdGVzdAZGF2YXJza2lnbWFpbGNvbQ', `Data` = '7d-bi2_7uQFUx-NvD42mlE17TxBrN_MkTgcnCIOmSveCVRWj0ghuFXdRvBYoLmRUPfka76eFCTQ8l7NPsoT_Rxcz8BWOVPI9naT8Yw3p21Pzgz-OgryjlWNnpMWmUjJiVRYTOZA8HtMLls1n_IZgvEvV-nVx6swCKlLK3p-2blnDzycP8PBdMZh_Op7FAwiSpQi2GHgOZxGJXnQ-KBJHI73bDRcmkmQ4eekB6F4tAZO7DmpM6xsy1lTzrQhmeSTJrhpugQrh6IcshEQIt5eY-fykZAJ8d2k6G6THVEEV-xkTBmHv5YpFhBBjD4tc7VXclUiK1pRKt88jGaMkQZpm74rF9hn3Io603hnuJcE_2D3ViLMjt-mS5g15mie18aKMW29pF0WxYt6H7QBtLWPgYHOu_EccoID4oyi1JckzQjX1BR_fUAdpRmvqgn723EPcAjUO9Zzn_9_BbTOcsN2p3nwnzPxSwrYIVEOS5St2d5QAWt5ytjDo0Q3t8rWtQELKZIOaiU93Ls4Yj8XfPvmJNk0INGI9cGtmQ_xU21sPYyE5eS4JZLdYZHreP1FIUFAzvJ7qFsUyFyzpG1VPZtOmUEn7XOsbomd9_nkx9aAYEk5pxcukEpVDoDzkrZf_vgtXl_STJgKpDcHyC783Ofl_GzB-iGMrdQnaAyCnCfEE77RLib3-ZDf4BaVIGh_YYy5tfdWTIErFyoT9BuMQHJw61wbl1kkexRRXWZ6dkSFUzZjttOBp-Hopg2oplTVskB0o9dyURyrtMpDq6uWzBZ0-_cfwZ51QYRNmsZJ6nmcbDAXIccKybs905kiFfM0whwIKCuMIPTKOFKxQSU3jsjFt4jRlDYrBv99fsP9E95QzbqjtpHx7WEE8M0kZD-dsiYWbpvZ65apBtZDVyGlsboZ-ooI52HdytUMRCi9kp0CVTo3ja6bhKdk5t2HMiaujrZfPAfic99Jst_o6ak_SezyPV-lM9jkoiAjauX2wZ5B-pA_5365uw7zZ7H0XlgV7txqwyx2u0QljJEbh-bpKIqnQIuoTXbyMfOwf0fIjQThzfAr69QfYfgXZed7fw1yYEGaMAu_2J60DCnzYXm48b4mGix3UlXjChLyIAmAlrKurZ3lFzMOM5RgkXzx5Icp6wCUGGsPPUaRm6zJt-mirnYyemEENQ45cVIg-NO44y8voBkx_YnCVpNpgxPIYaowrID3RIG5Yxv5QAvqLCbD_Bve1Mo4UvBVg3IOaVX_8vk9kySPmfObf0W69ZiC17DskViOm8TGpWwsl_dOMw9P__fhUeYMTPh_IIJH0UZiAPSPrcyUH7e_vOdIGw3V9RON_HMp0YQIAmcOsFTccq8022SWpZ6tq432WxeohyRFiVrBH1V5HC-VjTmfPu_PLCw6edIXaL0N3cT_x3Z_1L_6i1fi7lMGm8pR6YZ0aAmJDSPXtTiWyAr-DhAdnl-PiSjqZIiip_5HYuA-IX7rq90tQLBM9gy9g6RaN6Hs5U3p-e5QdHeFjLTtYecKgluGg8hRzKrqyo_MytPz8x6WTkQDVgWaxtkkAzz9I07NV4TjBrLhaooao92hZM8ktXQQ2AMqojKMVmylRi-GgZn7U7aKnJbk_521u-k2fNt5vCukN8GQGy1EZUVHf4OmcRD1fIWLMS_QJXRqfZBuIMLZ_RJH_GsohemMiJCc7HyOLoMwKnmV83k1AYCs4QCVrzg3_kUjXqcN-Bgun0dV2jnJ9H-2_uOYhbxT3EaYNZAhzC_CzlHfQTfdCmHVfYyMDSwGKP4TlMjWyfdAexzaSC-4L7iFYbNh0k21OFB2HBvDlmEHZr8csUxPD_ZMDag4VVei9pgpGkjzJgSnb2IIpN0oQ4u0KzyIM7hdnhCjX4Pwc2cGxxJdT0InHMdFatr78Y23MqtIMq9SaYpMip0aZShZzb6A8ryHNpsr1iVy7QpdTRuC3QFHBOdWJkFLL3Genov01dpEcEhQGm3Scj5XxoeRYmB_scAh3ySxrAMYTPb6JpDnGZoZmhl-s6Ll2IGo5dGLrBTolwTrcApcVpQltmkvNXMHySYlHkA', `Progress` = '5' WHERE `ID` = '1127962'

SELECT * FROM `reservations` WHERE `ID` = 1127962 AND `Status` = 0 LIMIT 1

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 1127962
                LIMIT 1

SELECT
                    `Exchange`
                FROM
                    `currencies`
                WHERE
                    `CharCode` = 'BGN'
             AND `Visible` = 1 LIMIT 1

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Info`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1127962, '', 0.5)
# [08-May-2025 07:33:32] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

SELECT
                            `Language`,
                            `Module`,
                            `ModuleID`,
                            `Data`
                        FROM
                            `borica`
                        WHERE
                            `ID` = 1012 AND
                            `Amount` = 0.5 AND
                            `Data` IS NULL AND
                            `ResponseCode` IS NULL
                        LIMIT 1

UPDATE
                                `borica`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"ACTION":"0","RC":"00","STATUSMSG":"Approved. No errors","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"0.50","CURRENCY":"BGN","ORDER":"001012","LANG":"","TIMESTAMP":"20250508043331","TRAN_DATE":"20250508073330","APPROVAL":"S20001","RRN":"512801460069","INT_REF":"1BAF91E54E03DF87","PARES_STATUS":"","AUTH_STEP_RES":"ARES_Y","CARDHOLDERINFO":"","ECI":"05","CARD":"4341XXXXXXXX0044","CARD_BRAND":"VISA","NONCE":"3003F827E1ED8C5E632CCEFDABB5B01B","P_SIGN":"64D38047416107AC9FBD3C759885A40299C57B1D5FE33CD8BEB87BDE6355263223795BBBC9A9A7B9EBE12E71EDD22AEEFBFDAA396A62E7FC0A191D35EF393D4C415339515F8C0CE4AFDCFDE2DD312F894990C58A9C82B12F7F304D076850E20196C62D4B8CABE60C7595B16A68827DDC48F501F7649E2791E9C6AF1E8BD5E1A4F9C45D93C1C8571A3094ABCA68178E2E29197226788E71051BA54467C20BD1AB141002E01F00D3A5EFEF32D46C1409EA717A4CF345E7EC18A0B7E091C8ED57EF70B24F3247A179EFC3B3FE1D6C9B252ADDB8908F34FDB8376663EAEEC07ED794DA28F15E3FF8CEA82A4D16D28113B1BD6285158C41504D7CDFD5F8BA32ADDBC3"}',
                                `ResponseCode` = '{"ACTION":"0","RC":"00","STATUSMSG":"Approved. No errors","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"0.50","CURRENCY":"BGN","ORDER":"001012","LANG":"","TIMESTAMP":"20250508043331","TRAN_DATE":"20250508073330","APPROVAL":"S20001","RRN":"512801460069","INT_REF":"1BAF91E54E03DF87","PARES_STATUS":"","AUTH_STEP_RES":"ARES_Y","CARDHOLDERINFO":"","ECI":"05","CARD":"4341XXXXXXXX0044","CARD_BRAND":"VISA","NONCE":"3003F827E1ED8C5E632CCEFDABB5B01B","P_SIGN":"64D38047416107AC9FBD3C759885A40299C57B1D5FE33CD8BEB87BDE6355263223795BBBC9A9A7B9EBE12E71EDD22AEEFBFDAA396A62E7FC0A191D35EF393D4C415339515F8C0CE4AFDCFDE2DD312F894990C58A9C82B12F7F304D076850E20196C62D4B8CABE60C7595B16A68827DDC48F501F7649E2791E9C6AF1E8BD5E1A4F9C45D93C1C8571A3094ABCA68178E2E29197226788E71051BA54467C20BD1AB141002E01F00D3A5EFEF32D46C1409EA717A4CF345E7EC18A0B7E091C8ED57EF70B24F3247A179EFC3B3FE1D6C9B252ADDB8908F34FDB8376663EAEEC07ED794DA28F15E3FF8CEA82A4D16D28113B1BD6285158C41504D7CDFD5F8BA32ADDBC3"}'Code
                            WHERE
                                `ID` = 1012
                            LIMIT 1
# [08-May-2025 07:33:32] /rapsody/root/bg/payments/cancel.html 167.99.142.201

set names utf8

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [08-May-2025 10:34:43] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

SELECT
                            `Language`,
                            `Module`,
                            `ModuleID`,
                            `Data`
                        FROM
                            `borica`
                        WHERE
                            `ID` = 3 AND
                            `Amount` = 0.5 AND
                            `Data` IS NULL AND
                            `ResponseCode` IS NULL
                        LIMIT 1
# [08-May-2025 10:34:43] /rapsody/root/bg/payments/cancel.html 167.99.142.201

set names utf8

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [08-May-2025 10:36:32] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

SELECT
                            `Language`,
                            `Module`,
                            `ModuleID`,
                            `Data`
                        FROM
                            `borica`
                        WHERE
                            `ID` = 100557 AND
                            `Amount` = 0.5 AND
                            `Data` IS NULL AND
                            `ResponseCode` IS NULL
                        LIMIT 1
# [08-May-2025 10:36:32] /rapsody/root/bg/payments/cancel.html 167.99.142.201

set names utf8

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [08-May-2025 10:38:53] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

SELECT
                            `Language`,
                            `Module`,
                            `ModuleID`,
                            `Data`
                        FROM
                            `borica`
                        WHERE
                            `ID` = 100557 AND
                            `Amount` = 0.5 AND
                            `Data` IS NULL AND
                            `ResponseCode` IS NULL
                        LIMIT 1
# [08-May-2025 10:38:53] /rapsody/root/bg/payments/cancel.html 167.99.142.201

set names utf8

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [08-May-2025 10:43:51] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

SELECT
                            `Language`,
                            `Module`,
                            `ModuleID`,
                            `Data`
                        FROM
                            `borica`
                        WHERE
                            `ID` = 100515 AND
                            `Amount` = 0.5 AND
                            `Data` IS NULL AND
                            `ResponseCode` IS NULL
                        LIMIT 1
# [08-May-2025 10:43:51] /rapsody/root/bg/payments/cancel.html 167.99.142.201

set names utf8

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [08-May-2025 10:45:26] /rapsody/root/bg/ajax/reservations/offers.html?_=1746690325684 167.99.142.201

set names utf8

SELECT
                `offers`.`ID`,
                `offers`.`UploadID`,
                `offers`.`Title`,
                `offers`.`Image`,
                COUNT(`rooms`.`ID`) AS `All`,
                COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`Image` <> '' AND
                `offers`.`BookURL` = '' AND
                `offers`.`MenuLabel` <> '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY
                `offers`.`ID`
            ORDER BY
                `programs`.`StartFrom` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LChooseVacation') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 10:45:27] /rapsody/root/bg/ajax/reservations/accommodation/oid_254.html?_=1746690327283 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `reservations`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755' AND
                `OfferID` = 254 AND
                `Status` = 0
            LIMIT 1

SELECT
                `programs`.`OfferID`,
                `offers`.`Title`,
                `programs`.`PromoDate`,
                `programs`.`Deposit`,
                `offers`.`Currency`,
                COUNT(`rooms`.`ID`) AS `All`,
                COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`ID` = 254 AND
                `offers`.`BookURL` = '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `reservation_rooms`.`RoomID` IS NULL
            ORDER BY
                `programs`.`StartFrom` ASC
            LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `additionaloffers`
            WHERE
                `OfferID` = 254 AND
                `Language` = 'bg' AND
                `Visible` = 1

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

INSERT INTO `reservations` SET `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755', `PostDate` = '2025-05-08 10:45:27', `LastUpdate` = '2025-05-08 10:45:27', `OfferID` = '254', `ProgramID` = 0, `AccommodationID` = 0, `Data` = 'yISjys7oJEyJ5WUZpaDb-M9b2cggB6udnoIJT1Bgbw80N5EYKAqodwSW_mhURxlrRFfEzXZZz8I_zI4iR-egqUM_BQAIDbZwlVH6PtgDFvg803JOVoX59tn8bVS36KkwyYjBbgAUVSkTvqAgImQSjz2gsxxhY6OCTVl662mp09v9QtmZwnXg17vw3UtB8g6fhUGXjzGFeiAR46kapvsrA0HQoWU7yP2GYZYa1jDAdGlDr_gqlzFFqjR4IgiPcGZFIpBD3K9Tln2bga1pJz5RI6ZEySPcxMcgRUe4Tm-2zC_tefatv1pQxAmtnQvYLk3R7PbVQ2ri8fi4Bue20PANCJmWWVipxTIImkbHpfhqAOq9Fzs1AOSCyMU2GHN5rAFOZFU4hw2yo5o8r-zPAN_-aeNt_i3ssBhGDaj1_s0tlAA', `Progress` = 1

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1

SELECT
				COUNT(`rooms`.`ID`) - COUNT(`reservation_rooms`.`RoomID`) AS `Avl`
			FROM
				`programs`
				INNER JOIN `accommodation` ON
					`accommodation`.`OfferID` = `programs`.`OfferID` AND
					`accommodation`.`Language` = `programs`.`Language` AND
					`accommodation`.`Visible` = 1
				INNER JOIN `rooms` ON
					`rooms`.`ProgramID` = `programs`.`ID` AND
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language` AND
					`rooms`.`Visible` = 1
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`programs`.`Visible` = 1 AND
				`programs`.`OfferID` = 254

SELECT
                `programs`.`ID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`BookURL` = '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `programs`.`OfferID` = 254 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY
                `programs`.`ID`
            ORDER BY
                `programs`.`StartFrom` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LRoomsReserve','LAdults','LChildren12','LAccommodation','ErrorRoomNum') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

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

SELECT
                `PromoDate`
            FROM
                `programs`
            WHERE
                `ID` = 1457
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 10:45:29] /rapsody/root/bg/ajax/reservations/rooms/pid_1457/aid_795.html?_=1746690329147 167.99.142.201

set names utf8

SELECT
				`rooms`.* ,
				(
					SELECT
						GROUP_CONCAT(R1.`ID`)
					FROM
						`rooms` AS R1
						LEFT OUTER JOIN `reservation_rooms` AS RR1 ON RR1.`RoomID` = R1.`ID`
					WHERE
						R1.`AccommodationID` = 795 AND
						R1.`ProgramID` = 1457 AND
						`rooms`.`Title` = R1.`Title` AND
						`rooms`.`Beds` = R1.`Beds` AND
						`rooms`.`Price` = R1.`Price` AND
						R1.`Visible` = 1 AND
						RR1.`RoomID` IS NULL
				) AS `IDs`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`AccommodationID` = 795 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`rooms`.`Price` ASC,
				`rooms`.`PromoPrice` ASC

SELECT
				`offers`.`Currency`
			FROM
				`offers`
				INNER JOIN `programs` ON
					`programs`.`OfferID` = `offers`.`ID` AND
					`programs`.`Language` = `offers`.`Language`
			WHERE
				`programs`.`ID` = 1457 AND
				`offers`.`Language` = 'bg'
			LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorGuestNum','LRoomTypeQuestion','ErrorOption','LEmptyBedsInfo') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 10:45:31] /rapsody/root/bg/ajax/rooms/empty-bed-price/23743.html?_=1746690331351 167.99.142.201

set names utf8

SELECT
				`rooms`.`PriceEmptyBed`,
				`offers`.`Currency`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [08-May-2025 10:45:33] /rapsody/root/bg/ajax/reservations/guests/1127963/progress_2.html?_=1746690332906 167.99.142.201

set names utf8

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

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1

SELECT
                `StartFrom`,
                `EndTo`,
                `Deposit`,
                `PromoDate`,
                `Nights`
            FROM
                `programs`
            WHERE
                `ID` = 1457 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `accommodation`.`ID` = 795 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 10:45:33', `ProgramID` = '1457', `AccommodationID` = '795', `Data` = 'XRB-fHVRGmUHTwNs6OtNhSk5pR4BvVN7aI1pp4RM2zA8x5Au18eeYBayFRxHJIm32nXZBoEM9hjXkoxzEy6fQAGWgt4p6Lc34uBhJ1J5QvsDb9LrAf8cTl0g3LkzrztAAFpSVZYIQt97AHuyx82ASMPkj6dhEpchMgpbzWIIqcPmNKWT1YekQlDzcWV2fSUFwp2QuTnQBasJ34_mLcc5ebpUXwmQvk0LHfDq5yMK5JQegGoO5nETU3SGnldhkhbsGnItEHmJOvb_OTDVZ5AQUnEqQ0stoTcj32QMBnmrDtmrzg28hHBqI9tI3ZiSQ01nI3FoRypOvdzhf2RbD7ijwFxoiXLkf2YW0Wgukpcj36qDHlg0rBb31HeS8Wibi7gAbLs00FPaJwym-nYbLCwdzZM-TM6F3swAzfGRjJl-1H4DjewzopMRFJs6x7mC6H1n2F3qY5shKbT29VbK9DxdZfcLiFRA2ojj_l6so86lJqi6Fb2jPpN6gnWE3jpcduIPU2GiPuzCDq5sY0694PrkfAKRrPzWmDEgzGbfsJ5RfraZs8qG7OI_4SVkUCp28FpOGJv0tRZO-KmUZ0JlVIFOYGLKV4Lj21m8bq-3_GRq5za96PIdRBnPF9OF61GT5KfTNjGVTnSMqPa2MeU_Uthhr6N8KyJBRLusrtvbUAJwtr-SRGxrkv3v3F5LEdj6We_A4WyvIgG6eQw8FTJlttWnC9uMMnE3WJhl_uiwtih5HlQmA2CFjGHHhukDrJl9OJcm0InnhKsnyMzyjKnGe2g1VMJeGf1r5beI9RSQEtQW4G0', `Progress` = '2' WHERE `ID` = '1127963'

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorFullNameLatin','ErrorPIN','ErrorPassport','ErrorExpiryDate','ErrorValidEMail','ErrorPhone') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LFullNameLatin','LEGN','LPassport','LExpiryDate','LBirthDate','LEMail','LPhone','LGuest','LChild12','LFillLess','LFillAll','LAgreeText','LAgreeData','ErrorIAgreeCheck') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 10:52:03] /rapsody/root/bg/ajax/reservations/additionaloffers/1127963/progress_3.html?_=1746690723242 167.99.142.201

set names utf8

SELECT
				`Beds`
			FROM
				`rooms`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 10:52:03', `SentDate` = '2025-05-08', `Data` = 'zSa0HcenDjO46wtiZysKkYzdTdi7Qsj1EC8E5xhBrHY6CY_jj4tS51ChGSCCNGo2gqrXB-W69lhSeU1qoO8SCPndeFPFehGTN_oPSaqT16cj05F7uGGST4t_AJD3fojZdvw-c2zGjJ-GpkysgYSJuqhVi7CxiYA-J6lTvhZ6jqY9vde6_AaMjUuky9OXt9zLe1oLcftmhGF0v_lpMsCXrZRXIxEaUUgYwLvwAeNyk2BB7p-mf0t_MKQMwT557fqJDf07P4sI6xuP2vuir-ewipGCylBenPsi_im6Y2TDwbIkNLQb4bi2EwIh1LqmEocCDhzp_L4Pz2hrfjzn9z3mrpophNX699YdphNJeQ4EdVQrRkvmkqsEh5TD2NBZA1aT895Vd4dB8bzUO_XK7I6yr-j0znFRr9ONiiUSVbc0-XbguLcU6ThnrheZ8VLFtGbydhadHSSpEJ7HpsFONql-clUs7rj_cCJZE9aRpRjQzWvdbxfV6diCYJwZ9-qLyY_GUfhNJXiH0TKwbJUETft3DRV-LAG8C0JtBQCkXKKNq87Ptmf1ikDWPjVOAJ8oFfMJ1NkPzdBY5P3n_LDCHs9JIeYvxDN7R0Uv5pZYahwTrIUgSBzeSYtHE7Lck8CoVQMfVTR_2ktdyK8QBWf0RazIoz3q8xhIwKFL8NdYTuvZ2pDlsJbfdwjxQ9a6Uu4H5VmUN4fE7V4unozP7OD1E6ga0ayOBhU69szi6_uWzRid7YQ2BRx3j1gAegAbUjMIqyZq8aKE2cPvw308SsePSTzeuLpc2oXcGQdHChMv0cm5OUfd2afzI1x0sN5Zl0llc79aUJExEcDp1mRET0TKPk5UM0g5_vlHTN2uwepVrdseenGXxwziT8nS6zdIhYVAB_TVeqecUkotirfmRTqGeGdntFTVFajVnzmdocb1NFIkd7NproHagrpO96L9PmjuGc4YnyYENQ7msz4WzGkG2bJzZMPeb32pc1w_2hPMuYX_4knTQ2DG2EdnCzz8pNycEh6bax0gRQ1czmoYJ3jxMNFhQzCPX9Gn3qtQBBxG054o3ea5klejadz4OGKyCarTk1ZslUwH50qgktRZ8qz4exi4YV0ecuT9gPx7CtkcRdepuBKrMlY-mkHiC0RPHxH6YRIP3CogCLjkCLzh8XkAHq108xlV30RQUc5LPjXYIaCCtK4P7k711I1ABPKyCqTRts_LPOWiIUHMvJN8dmG46SREuppy12ZZaOJt8Fn4Vbf5Any0M2tzc2uo92uWbFYNpOUZx2-s5fmWlTI0XqMASvrm0m46IR81tPmsapGVnuz_FaVN17zmWP6qdxN52MNZFd8dSaisvBs13QAUiuGECTx4uFJhNubyeogNaZc5ceHCpzckgV9bROAY_tiKNyjqZl8JgXdkWKFIr8rV6aKTp6gedXIy55g2AudlYie0Mfy7lcCc9n-dWotOPQUZbDjotT5NlmL-Cvw0bCP-OUsd8j_0dj_MUyeeslMvrlrykkufCNtGrLqE_EeEJuDa_wADz2gIcGm81Xpij3Xn0SbNR37y9jP4dx2grnQp-KDGlPv5NhAEkit3YiSfFjta7m6ymgsDj0OwbZG1Lwn8xJVtOYgSBKrbP7wFpSjaK8SoqbDC3zvTvA6FS6_7fPNa5pdUZKkDFcqLZcOmA45BvhjtwhI4HoBlHFVjaP8YPSIOQb_wkt5S6tOsPPBEf0eQ2zcePNkdjDsrW-fT9F8KQrxZ_D4ebw', `Progress` = '3' WHERE `ID` = '1127963'

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1

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

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

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23743 AND
				`Visible` = 1
			LIMIT 1

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23743 AND
				`Visible` = 1
			LIMIT 1

SELECT
                `additionaloffers`.*,
                `offers`.`Currency`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON
                    `additionaloffers`.`OfferID` = `offers`.`ID` AND
                    `additionaloffers`.`Language` = `offers`.`Language`
            WHERE
                `additionaloffers`.`OfferID` = 254 AND
                `additionaloffers`.`Language` = 'bg' AND
                (`additionaloffers`.`ProgramID` = 1457 OR `additionaloffers`.`ProgramID` = 0)
         AND `additionaloffers`.`Visible` = 1 AND `offers`.`Visible` = 1 ORDER BY `additionaloffers`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 10:52:05] /rapsody/root/bg/ajax/reservations/summary/1127963/progress_4.html?_=1746690725025 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 10:52:05', `SentDate` = '2025-05-08', `Data` = 'KtwhrkstH-v_DXgn88YlUiqBtVOFExw9Q8Rf5708pv7SvR2A_3OUMmnwfVzKBHnOkmp2A5dRhGRlEEWQwvlqMNl75UgFx_mYAYTmMZy2LLS5zzyR2cU-4iUeyQmPlamkQt1OHd743sYgynm-Wn0l6bBV-SVppMJZI650JOZydh-l_BbeYULaqmmwpeLX18ajshLAIeB37VjwIO0qw15fBsS7tUNYDL_cmFnn8wc-Q3u36W3fTO8wLKOEqar80TywR6cFM5v9V3p3oaJqnMi-PiJatsFTqURvW0iMgQ8vvncclF2RjSicXCNYw2vlKRlhSe-1bvb6WMnAJ07C5vqvakDbQimigFK5_qddwYDT6mpNBGf3Gf7r2-3OUHs-hE7vjNxa05Lhks7lwCfWe5SDlHAu_KlNoGINahjsAXZwx0zfM6FqKmsZYtB3U-SB6bN5TERSlGnnFhmk_3UoGZ1kX_zAbGQ5RkuNPcpmmbywOMhjWdJJWqdYDjlJCvSl5ZNcCbRRGI8bCf5rfGVrWkc3pqFoMdxVOqWdqf_YteXOMzslPAlKe5YfQ65N4s22X_-MeG3_mXluVWWx9M3AOsa3YfZ9bJXfvBFdPQb1SJzLLwSe3cuHt6cUSOeCEdUeazYxPE5n_2l6ElYzxMe4_q4sWuj6fFz9mXmlYrVy8gRblZ7NY1oDpZdYLygUuF1wOYujxTmW6WZrWC300-gtQbXSEpK8a5YjrsKiRrnw230cq_Sz_PWoTRG0eHmQG6wFgX4NXEWqx8i_KDkZS9-mca25W_QQv27m8umhOEZskzTRtrgV5RJ23O7RQrZ-9MA8JQbDLOegrnF6zKMLtIihtplK5809qT0G8NOy6nOuQCUhy2fVKaQTmvFRhxDbnllBJ5fSu4XucKul_s2yP-A0WZ6HioBgIOjK4ADW38HTHlk11xNmxs_deaGKpfkpxDM69v7dt9zxc4-vxSgkMjezHnohUDG5fP4LeC-Sit_3dIMm8lJ1iZsIxMY5S5dGS_w4prmcx6umoA12jLLbFJ5ABJIq1YvnFYvwjdo9oJpc179QsSJTbYSwMokCiOkQWGpKeE-3FIBqTzJ84iDdW1esWzIMsc1cTioPwnNdsQkFe0RMBO1FhAad6qJtc8lnbfs0zN_TcW6PBnZsNVFAFbC_hk9Gc-1daFqJ8EkKSUNHgHGtwrP6DUaUsd-eciN10GLez5Fo5VX4gz7FZYcJb_FbHkwJ9J37GVCK9LAZupI9p95SfJQ0J9TbtiXdBcfMGDDTMBKkdvXI763JZMEDUGNXt511nVaC2Nx0PuWbIGChMlX0mJ8o1PzzLr-0z8DeI-aQuZEHaJPHF_YTngz_A99uWhptTYNTkn1GDHLSs2SKppnPcQgnhvIjZQv-BDo3NQShnGClDDy-_sFq8uozYVrzJ5Nsl8QBTkNORwgWwxrVgZPqyglLwswFdYOKjSNnZHa3gdmzox6TIiKg8l9QRXo0L_i_BQgJCP8l0gVW919Z4_DfX2XcEaYuICBR0bPa_xX_ByUR41kK8vvC6BlsDsPzwNCkBSutLTFePuD3V9i5K4FP9QFN2udDqqb8k3T6dXtNS7PiikocnA_pupnJ5Vm8uCNRaHTPIH515iBCr9dfQY3Q1tfcVFZwk2bWEW-5xG2hmAK--FIehUWGR6L2Lqf18QBWPoGveQU1jTV-CygGY9ZiWo6hXCW7svnu2049wI_bmqNZ2Og0Yb3Rtui5E1bsWTEWBTKlrwyx0N2sa0SBtME7JC_5rgBBiqFI_93ZqdU1JNWA8vvZACfSwhadyMROdr5EJm0qMnz4iRz1MjxuT5oD7KInBdKqWc17M1l_UAhDN8qt', `Progress` = '4' WHERE `ID` = '1127963'

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.`AccommodationID`,
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`,
				`reservation_rooms`.`ReservationID`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEarlyBookingDiscount','LLoyalCustomerDiscount','LDeposit','LIntermediatePayment','LFinalPayment','LChildren12','LGuest','LChild12','LName','LBirthDate','LEMail','LEGN','LLKPassport','LPhone','LAccommodation','LAgreeMsg','LAgreeGeneralRules','LAgreeTourist','LAgreeBuletin','LFreeBedsPayment','LReservationInfo','LCheckIn','LCheckOut','LRoomsNum','LAdults','LHolder','LEditData','LTotal','LAdult','LPrice','LPayWithCard','LLearnedAboutTrip','LBusFellow','LPromoCode','LApply','ErrorPromoCode','LPaymentType','LPaymentDates','LTotalSum','LFreeBedsNum','LSum','LChoosePayment','LPaymentCard','LPaymentBank','LPaymentCash','LChoosePaymentSum','LPayAll','LPaymentSum') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

UPDATE
                `reservations`
            SET
                `LastUpdate` = NOW(),
                `Progress` = 4
            WHERE
                `ID` = 1127963
            LIMIT 1

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `accommodation`.`ID` = 795 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

SELECT
                `StartFrom`,
                `EndTo`,
                `Deposit`,
                `PromoDate`,
                `Nights`
            FROM
                `programs`
            WHERE
                `ID` = 1457 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 254 AND
                `CardKey` = '3ee8ae3cfb900cf6c7a0b82d7eacd001' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `ID`
            FROM
                `promocodes`
            WHERE
                `OfferID` = 254 AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                (`ProgramID` = 1457 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                `Visible` = 1
            LIMIT 1

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

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

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1
# [08-May-2025 10:52:12] /rapsody/root/bg/ajax/reservations/confirm/1127963/progress_5.html?_=1746690731707 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.`AccommodationID`,
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`,
				`reservation_rooms`.`ReservationID`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 10:52:12', `SentDate` = '2025-05-08', `Keywords` = 'Y2FyZAdGVzdAZGF2YXJza2lnbWFpbGNvbQ', `Data` = 'PbRaUQPOkNdh3wYbsrjEbTTQ35xqhx0e581QmCZ_THAk0rEeeE2MSO8zygzj8xll0FQ4r5qsO02YnONath3Y3MpuJ_Xe9aOB7X_9ELBwnvUpLKOpdIA27QmPTwxVgB3DakJMdQMnKDV0rh8f0flTSBfeJO9ID0NWFlLiKvqaNu5IjdYwzJtpP7NC2AyZXd50akHgAbL_xUu60qn7mIyN35aHXh6MIIhV6lX6rHS-mBLSeH0xRV2gnJMbcdZ2g-LaCgYYg4vR2B8cZdZfFd6PrVu0rqsiSyiNqQGUFYkoIPK2P1EjxFxaa-FCJUIomNE5V6Cb4RIS4YsikXeLIS0mNBGmvVUD5xz1D1l1a0YQbgFsn1bn0lx3vHN4sJ2DgLq2le4UgJtxUYGus3oxNEGJhEmtg8B0riem7nnjjDG4FAcj2o0IJxpBHGzllWocgP3U-n-Sg8wg6Vu2tqsaSaHjX0t4DnjY4bLkN8kGTzphi7KIRqwHCjrYvK2uorDLmt2gNVGNWgL2R16RSMPHiJy1dkASk6qVDT9md7Quu1BSl4mw9qT65UhwOR6IX8dk9ScYMmL6z8ix5ZchPKty1WZzTtxsclFOexhL3JMAXqkUSdOaS2H4EP10aXdAbNEv9nm8x22x931P_zxaUJVpTuWi0hedOo4J4kxxP7rila5aZNB3XxMKjzr_tYUddO-qGi0UR3tB50h3VLOVk5WYBa-vIsP13l980SQJEj7y9KGFcx-Et9oMvJFawe-_QrOBpBN-6YLJsT-D-mZUuKxAD6nJyyQ91XejEGx-7HEfdeoPaMmAeIGJ5tMLadfehyY1lDgHRt2W0Kvqa8r3ylWYZoXU-xGM75S-x_F5V8rR0fpOB25fZWPvelaS_Wn5Ch7eD8yre23dgLMaG56nQnkjIunJHSWD70Q3yEpvCnqtT0fTXejU1xy9nUbU85PHGgeSdKPpP0FAZv6OUGxL1JsIpQ8qAX5Su6HKrOTNja771gpPR7DHGIb2OMaSOtp61tb9HJAEwOCFytmt_Bs-JKFI_DNRRDR7D6JbtgiWZA-j78gO6theRqpmSehCD4abKobJGsdUgs6l1E_zwALgZgikxFK7WllYapqVkTi_oF2jGiY1vJvz1tu-e7DV37-BYyEgWw4FM32jpdxExph-joxfIdyzOnF1ca-3SexCjnVvCsed-qrAYg1WgIU20TaqyP7BWtp8VnGxE0uqhXgvE_LBPvQSTNX0mtMf940rm6QeNfSA-DAwtCt7SrbO-0oySs2qVHfnFGh4FrD0VGHIWajxTe5_znfKBzrIrejaaF70_fxWjbxO4yqe2HkqcQp1eNmvzWeX2rUHZ1NGQLi5rER5T5EpAdg35LfWvT3bbH20GbuAPiCeXYkVGOWUthmhk9Jfei5Y0ofA5TkeykXEMhGOUJgf-R4pon8UYNxkqcpYEh81MsG5wcqNhu-zk_A8dWxrnHiLWtEHsXSUrUoXnUUr2qNdNVsCr9Rw5W6lYJ9QhotrREoyXpdgk7TpL4gC531dU1xtkqlXc4Ntqq4eFwUkkcZIn_rTURJqk6qJl3h2X_HozwlEw8LOnNloYEiqx52zIiHY3ScDcXLo1tMJfBo_N4YjH8cp1bk3LOSBzowxpjGiheStpYn7BbSowbj8rVrGbjP3NHfwR6rbv5cjZIty94ryfXUx4zYNLQlFeAymm-ydOj7iymGk9Os-lXlbBslMi6VGO2YW8I0G7bO3hssgV10gPH4U04RRx8frBmjd9tPA_M30MR508_2cJ0Gm2p5zmnVVXtIVXXaeh2LCReqgdJTYfWCN3MA7gLNfoPfe_P0kKI1eGntKTiW7TE22x-jhpkLwvxwi6uOAyHiSZcrka_IwjwpnvqUjZDKvp_60bb-psq9N0VjEC11p9Ji1OnPPzmK3JdHSxvshgZgwp9kwqD1e8rRgRqcpS_EStImLFuTl1y0sBlvcDa3xD-5ZgY3xVRiU9ljV9qoLrRQcowNf8D50MutyTMrMdxY2_8Q7ODMNAFnM2PrILv1nPp2K1tGQduFInfS2vEg07FmwHWDd1A0vyg', `Progress` = '5' WHERE `ID` = '1127963'

SELECT * FROM `reservations` WHERE `ID` = 1127963 AND `Status` = 0 LIMIT 1

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 1127963
                LIMIT 1

SELECT
                    `Exchange`
                FROM
                    `currencies`
                WHERE
                    `CharCode` = 'BGN'
             AND `Visible` = 1 LIMIT 1

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Info`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1127963, '', 0.5)
# [08-May-2025 10:52:38] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

SELECT
                            `Language`,
                            `Module`,
                            `ModuleID`,
                            `Data`
                        FROM
                            `borica`
                        WHERE
                            `ID` = 1013 AND
                            `Amount` = 0.5 AND
                            `Data` IS NULL AND
                            `ResponseCode` IS NULL
                        LIMIT 1

UPDATE
                                `borica`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"ACTION":"0","RC":"00","STATUSMSG":"Approved. No errors","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"0.50","CURRENCY":"BGN","ORDER":"001013","LANG":"","TIMESTAMP":"20250508075238","TRAN_DATE":"20250508105237","APPROVAL":"S30460","RRN":"512801460085","INT_REF":"51B31D543BA838AA","PARES_STATUS":"","AUTH_STEP_RES":"ARES_Y","CARDHOLDERINFO":"","ECI":"05","CARD":"4341XXXXXXXX0044","CARD_BRAND":"VISA","NONCE":"B0DD11B5D2978287C7AF641A326C8188","P_SIGN":"4898D9460282D27A44F53E0824D932B0D0CA1DC5935D78BF86CC65E3D1E09EF3E522232748441AE6E43D2B3D5A5944E19C2AC86FB636FA22B0437C30F12DC27121EC43BFE3065A1B7614A9851A46A3C6562A0BE43F16AFBD5ABF2825A1062121EB53C74FC73CD9534DB19649760A2F8BFF3135D477CA7D95B88D58B41A166376A33CDB0CDBAFFACB96CB16958A7D6D0DD4690FB9FC47044FA3A49008B0001413329646AD5997232010F0D92E141661E9EED17E7416C39D57457386F950B15CEEA8765156A27F9E0D407873C8B00C403AA433DEE8451887CE7814A29821CF0641F4267CFA39482286E32217C9573AFAE17B63132E6420BDB0D27EEDED54E42463"}',
                                `ResponseCode` = '{"ACTION":"0","RC":"00","STATUSMSG":"Approved. No errors","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"0.50","CURRENCY":"BGN","ORDER":"001013","LANG":"","TIMESTAMP":"20250508075238","TRAN_DATE":"20250508105237","APPROVAL":"S30460","RRN":"512801460085","INT_REF":"51B31D543BA838AA","PARES_STATUS":"","AUTH_STEP_RES":"ARES_Y","CARDHOLDERINFO":"","ECI":"05","CARD":"4341XXXXXXXX0044","CARD_BRAND":"VISA","NONCE":"B0DD11B5D2978287C7AF641A326C8188","P_SIGN":"4898D9460282D27A44F53E0824D932B0D0CA1DC5935D78BF86CC65E3D1E09EF3E522232748441AE6E43D2B3D5A5944E19C2AC86FB636FA22B0437C30F12DC27121EC43BFE3065A1B7614A9851A46A3C6562A0BE43F16AFBD5ABF2825A1062121EB53C74FC73CD9534DB19649760A2F8BFF3135D477CA7D95B88D58B41A166376A33CDB0CDBAFFACB96CB16958A7D6D0DD4690FB9FC47044FA3A49008B0001413329646AD5997232010F0D92E141661E9EED17E7416C39D57457386F950B15CEEA8765156A27F9E0D407873C8B00C403AA433DEE8451887CE7814A29821CF0641F4267CFA39482286E32217C9573AFAE17B63132E6420BDB0D27EEDED54E42463"}'Code
                            WHERE
                                `ID` = 1013
                            LIMIT 1
# [08-May-2025 10:52:38] /rapsody/root/bg/payments/cancel.html 167.99.142.201

set names utf8

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [08-May-2025 10:55:56] /rapsody/root/bg/ajax/reservations/offers.html?_=1746690955818 167.99.142.201

set names utf8

SELECT
                `offers`.`ID`,
                `offers`.`UploadID`,
                `offers`.`Title`,
                `offers`.`Image`,
                COUNT(`rooms`.`ID`) AS `All`,
                COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`Image` <> '' AND
                `offers`.`BookURL` = '' AND
                `offers`.`MenuLabel` <> '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY
                `offers`.`ID`
            ORDER BY
                `programs`.`StartFrom` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LChooseVacation') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 10:55:57] /rapsody/root/bg/ajax/reservations/accommodation/oid_254.html?_=1746690956679 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `reservations`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755' AND
                `OfferID` = 254 AND
                `Status` = 0
            LIMIT 1

SELECT
                `programs`.`OfferID`,
                `offers`.`Title`,
                `programs`.`PromoDate`,
                `programs`.`Deposit`,
                `offers`.`Currency`,
                COUNT(`rooms`.`ID`) AS `All`,
                COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`ID` = 254 AND
                `offers`.`BookURL` = '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `reservation_rooms`.`RoomID` IS NULL
            ORDER BY
                `programs`.`StartFrom` ASC
            LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `additionaloffers`
            WHERE
                `OfferID` = 254 AND
                `Language` = 'bg' AND
                `Visible` = 1

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

INSERT INTO `reservations` SET `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755', `PostDate` = '2025-05-08 10:55:57', `LastUpdate` = '2025-05-08 10:55:57', `OfferID` = '254', `ProgramID` = 0, `AccommodationID` = 0, `Data` = 'gDnc-bR17uLIqDkyi6KMefljGn-yDlEqwnwo3CE_pAEKiSJt2oLPAQ85QT2LIvtmW9mRTBoV_ql3wA00UhZ2g4jiV6z4IizzFyHBg83MMYXy12awAtMSJqoOKq_rUEqPwaaq9hE6qmTKiam0XRGgB9Kx_MPr8WQYJ7oZzRwG2tNV_JqHimzCPr0ALIjwFXeboO47ZVo1xooSrmUIfDTSD24H397vufBYrn6wgXDDDcwXLlQNtxpuYxBQT4bNN73Q2cKaA7C-HRIz5LKi_bl9WFjIJWIbMFHMWALB5fpB0fkMOam80ctpYvyP-B-Y-QaFKF0xo4c1dV3X4GRaxTMImeTrAa2AQ6Ed7b_NQbUorB8ml5Lu00WCRCCAnPxjb91w1UG2AV6YJgBzsJRHE3oFegakFgYg0HXD4tJyyHLy9uQ', `Progress` = 1

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1

SELECT
				COUNT(`rooms`.`ID`) - COUNT(`reservation_rooms`.`RoomID`) AS `Avl`
			FROM
				`programs`
				INNER JOIN `accommodation` ON
					`accommodation`.`OfferID` = `programs`.`OfferID` AND
					`accommodation`.`Language` = `programs`.`Language` AND
					`accommodation`.`Visible` = 1
				INNER JOIN `rooms` ON
					`rooms`.`ProgramID` = `programs`.`ID` AND
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language` AND
					`rooms`.`Visible` = 1
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`programs`.`Visible` = 1 AND
				`programs`.`OfferID` = 254

SELECT
                `programs`.`ID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`BookURL` = '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `programs`.`OfferID` = 254 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY
                `programs`.`ID`
            ORDER BY
                `programs`.`StartFrom` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LRoomsReserve','LAdults','LChildren12','LAccommodation','ErrorRoomNum') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

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

SELECT
                `PromoDate`
            FROM
                `programs`
            WHERE
                `ID` = 1457
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 10:55:58] /rapsody/root/bg/ajax/reservations/rooms/pid_1457/aid_795.html?_=1746690958512 167.99.142.201

set names utf8

SELECT
				`rooms`.* ,
				(
					SELECT
						GROUP_CONCAT(R1.`ID`)
					FROM
						`rooms` AS R1
						LEFT OUTER JOIN `reservation_rooms` AS RR1 ON RR1.`RoomID` = R1.`ID`
					WHERE
						R1.`AccommodationID` = 795 AND
						R1.`ProgramID` = 1457 AND
						`rooms`.`Title` = R1.`Title` AND
						`rooms`.`Beds` = R1.`Beds` AND
						`rooms`.`Price` = R1.`Price` AND
						R1.`Visible` = 1 AND
						RR1.`RoomID` IS NULL
				) AS `IDs`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`AccommodationID` = 795 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`rooms`.`Price` ASC,
				`rooms`.`PromoPrice` ASC

SELECT
				`offers`.`Currency`
			FROM
				`offers`
				INNER JOIN `programs` ON
					`programs`.`OfferID` = `offers`.`ID` AND
					`programs`.`Language` = `offers`.`Language`
			WHERE
				`programs`.`ID` = 1457 AND
				`offers`.`Language` = 'bg'
			LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorGuestNum','LRoomTypeQuestion','ErrorOption','LEmptyBedsInfo') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 10:56:00] /rapsody/root/bg/ajax/rooms/empty-bed-price/23743.html?_=1746690960420 167.99.142.201

set names utf8

SELECT
				`rooms`.`PriceEmptyBed`,
				`offers`.`Currency`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [08-May-2025 10:56:02] /rapsody/root/bg/ajax/reservations/guests/1127964/progress_2.html?_=1746690962129 167.99.142.201

set names utf8

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

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1

SELECT
                `StartFrom`,
                `EndTo`,
                `Deposit`,
                `PromoDate`,
                `Nights`
            FROM
                `programs`
            WHERE
                `ID` = 1457 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `accommodation`.`ID` = 795 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 10:56:02', `ProgramID` = '1457', `AccommodationID` = '795', `Data` = 'OzkJ5LGnOlOxYJfqVjuiXZFUCw_Z9QpTxe0Jq2PtcFOE6XFYb78cWYZPVeFaLdSPnZ7Eo9yPvZeBgIluiW6Sj_kNJvHOBYRBgVdoOaCP3DbAUCdUflRlkiPS2L1w-9AMa0R6yr3uNLba9QoF7qxYaUKRXOnGKJtt5BwtTkYBgON68bAvkcEu0XjadWfefdXm5J6rjWJIG0Lq_mluX3BbGM_u35wST7Sb9LafH6LjjfmzF-bf2mEHeDjxze6M0osEUM1y_Y9R3PLT_L6EhUKqt5XFkk-2K2J6OV0QfFuIHgVTkECaamUHg182Zjw6Nj94LsPe9aoHGZ1sdeGgY0npXiixUhLwRLwZhVyQZVBIPD5QR6gMZY3-TmjGEq8fr1zYj0fKcTXJwWd7UAJa1F8C-y0xnaYeIU-UApN7v-MQa3l5PDROIfcV3-B3-Ghtwayi08RmuQu7en64FvtGyZodS4RzIeRQAF_vCWLCR1mXrxOnfSw0XB21q953d6KONwFcdGrZ7fc4P3yeVRj7_RLsaAosrIJmWSpvRk72wlrqjEBbKycz0g2sBej5kk41ZTLBPk6nAn4xkGRmpgqXsgGjdCiUjzlAbMaQSxDhlI8_TR3UgqHMvd1uobaVyuvYJUXbyzhUh_qPguJW8bpJf-rq38xXt_C4el2k3BqkttdOz6hkSRr0nKBfpeHvG6FPIeMsl51aS4HSu3xWy9Db-Gd1Q6sEVIIN2QU_2oMkjlhhrZ6P_Ph95n340Wr4G4wDVA_YY_M5giDZv8x1CQLq6G19Gd_nl9ZfKrYVD4pzj4nnlMc', `Progress` = '2' WHERE `ID` = '1127964'

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorFullNameLatin','ErrorPIN','ErrorPassport','ErrorExpiryDate','ErrorValidEMail','ErrorPhone') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LFullNameLatin','LEGN','LPassport','LExpiryDate','LBirthDate','LEMail','LPhone','LGuest','LChild12','LFillLess','LFillAll','LAgreeText','LAgreeData','ErrorIAgreeCheck') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 10:56:06] /rapsody/root/bg/ajax/reservations/additionaloffers/1127964/progress_3.html?_=1746690966072 167.99.142.201

set names utf8

SELECT
				`Beds`
			FROM
				`rooms`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 10:56:06', `SentDate` = '2025-05-08', `Data` = '366AHlhS7AqDqJ2f7T8F0iSY7iLG70lgbEspsWVkLEINlykIiUPdzM9PDBlgU4KN8biEN_h8lUfS302f8xIz3JYHD3hPU9NMXCEG1mnQjzswpmTw8ZNByfcn1LPFh8krU0rM1aedDCg1H-68iqq2qppLRVhmfGPJxZkHW5OC5yDVrcHTWqapnojrDWoD6iQ9025MPGFX-vb_P7U9CP1KscXIduEEToOSnhHbBtBD1JhNRjw6559z_IP0wx09EDZUEOB5XxXM819f24U0Mpe3KGcIuYWRlvJ6xxuRHC2eMbt4WeeC2JgdeOksxsXhlTuNN3FjEJQZaJO9xQrOsx1o8FdZwTyyME6sjhTeuycH6On4k4qh-adwAU4xuZ9zCqPjD9sVeXSAA6EtfaC9qR1R7S1FysgyO3jllto5iV9OxDyTtoMMXxBs-2Qsd_o9ysdTiEcPuFGLLaUtyac_GOb6CtOiNZFIFLVC8FiH83qyVDfxsHfuNDOVZFitgsD3aembQ28yURumXeZAvKsEi4PA0ELprP4ughTqOPvFw_UHlCNRR0EUc1MYZ_wxNAYKaVYcSNTO54XxJoRLDsEP25oe_UcftFKe3a5MxJxZD_3PSLScDWEVVlCOE6-oh_5ivR_0WTDdh5wcVcNknpA6_QU88P_EKkVGjsS4KV1pD7lUYpAMsR5FIFWJ5VX-adWWw1-CmUT-HsqbG5MIsUHThsdWGovqJVAxPMNr8L8I1N4v5Km08J58DNkjTe4SpEAZoj7yk8wH3N9B_rVkWTrt-dsOqyY-VUenYEUu6OsDo-mnFE0v-dHhd_-mxaQZzD8xaxHo5jwrnmh7_l3lhUspAs6VJnnxBc6HAiHV3QilEEBzMqO66Eyt9A0_IWmJHhWFUtlBs1Vovj0MoQ8djLsRsg3BPY9urY_pwbyIFMYIXKZUr9sKifvn_yg3XqXCcYYWB4dm1WcSbm29kicKYng2N-j-YfMsD2vqZNHnIb5Rxj4D8Gx5j-ZLwCbTtYGm-_Dd5UWHzfJturfKbMBnaS1U5sGxEJQwbQRjTdZEVejf4Pwul7aQSVJVjjpLvQvXsCQE342Aa5oHeeCufMiJk9FLTwXztvFog66NPEjMJJyFniu2loK_ZgtHnD1wTD7OESvzgk6WUB2h5NIUmfZJKUMJWJdqGZ1RWWOB1r59zFK-Pz_4jEUJEUD6meIuRA9m9gWRzMl0CUOfzKy7jW7vcUqjIMNp5as58XFOdr3_eF5J0TsVm2IgKVggzE5rbuwtg1wFJKNQHIGcttY8L8-PSgkRfQ97cVZIv1k7XJJsElzaCscLf1u8MoZthfGzqUjAHoitsn0jRFM5iYrws-_Fk1y5B2Mr5QYW8d96t97Wb1BjPsJZP_RINDd-8nQfK1Ny-b1sWKypIct2XOTUuDxjWCC2Dtjs3lI4NSnWBw-mBq9t1ohNB98wFaQ0DNsVKWlzeclIDIC2b24mldLJ6Z2CZDz38Yhj6oG1tESXFLaejyKI_TU9pcWaCXbZlSAzbkqpQpxdfWlpvND9iCHddQzD3qnbWBt7RBZirtyJ6HKjw8U4S1ZE7o2QhfUbJv0PUhJp_YEzu1Ttsc1npf6neolVoESo_Oz3tb75Zz-nIoKBMoMG-guYgW9I0AKqYXzcliivTS5Pm1edFXapXFtgeuRXuVGaE7FgLy0StR6enGXWactSLzNxff5M-8dxk8MqTe9PJx5NLA6-exMd8yP49ZCBFYxp4zTxBg', `Progress` = '3' WHERE `ID` = '1127964'

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1

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

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

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23743 AND
				`Visible` = 1
			LIMIT 1

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23743 AND
				`Visible` = 1
			LIMIT 1

SELECT
                `additionaloffers`.*,
                `offers`.`Currency`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON
                    `additionaloffers`.`OfferID` = `offers`.`ID` AND
                    `additionaloffers`.`Language` = `offers`.`Language`
            WHERE
                `additionaloffers`.`OfferID` = 254 AND
                `additionaloffers`.`Language` = 'bg' AND
                (`additionaloffers`.`ProgramID` = 1457 OR `additionaloffers`.`ProgramID` = 0)
         AND `additionaloffers`.`Visible` = 1 AND `offers`.`Visible` = 1 ORDER BY `additionaloffers`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 10:56:08] /rapsody/root/bg/ajax/reservations/summary/1127964/progress_4.html?_=1746690967618 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 10:56:08', `SentDate` = '2025-05-08', `Data` = 'gWKPrdIQUf05fO_uHswADKtBOSup0UT8yhTjkD9VBDd65wqA9nW4BP7-fWbk6yJZ_5mdGdz7dVXyKocmZvHg5UX6QFsjUPMXRhFg-vPixplZxelkhpHgbrnCiI89BENtEppT5Z8Qs7ifg4k9bQTZ8DYPjXG7im1R0OXQ2YoYfUMhiLY76WrQvN5SnadvqzuN1Z99GI3XA-OZ5j5FhLEE2uRmtwQ0ew2HOfKr-wDalYA3RG4h3KiNxlLNY54G2FWTM0fV_Zjq5vYK-L6SlY4qAvNDoBlldZDTqsbI5ATumwa-sVpw3cLtfEAGT4iCm3w1a3AqZQfKTc9tJjiXNIfUW5osqw5_tQMf-UwOuUbIQSXcBMX_HhpmIfdykUPmQ-jKOO8Z4Ns_kWl04QPFdTNCw24UwN4nHn5W2fDRHz6DQzIwe8at0dfjyeSv1Wcox8maBXkT_t384j-O1HxUQ2Q-RnE8yII7TkgM-MzdHGrvzctkU3-sY6KAaP5L7SEqz_0GCC53eGqzZgWgO9HdW-6Ho0G950gseeusuvWDRXp6YlDTYFHz-x0JJiwV8_ZUQSj-wAfguHBENfmkvc9omDHqlkKy8yTcXtOuoZiBsJC05okahD5l2Mo7wyvzd7Bt_XhtwB7Ya4rbNhJMhGRFBdJXe49K_yDWT0z_zz8X1C1UOYDByzhf0Lp6B13u0AyiztXath1ugF_4lxt8gMAMjB3fE-uFOwgcNwMnf1SW5EqnM_PGCwcdblBbm2tQq4eGugBlSpJsGw08jtrbfxUf0dNJlNgAsRnljehybxl6mbQYviirEWxLkEWNh-UrF9tFuJUqe43SH-1etxM1TXklwUIc74ihX7097zjEw3AwTtP0aX6ChXmREKEB4nkI5B8UidmTN7D9SZYgeK0OLcbLeW2nEwj3nQ6tpsXXP7JePlr_9R4bSJA4HNnUWciexd5VDi6QbsVb597623HXzJ3PFUHF8gWzQaoi3TDI20zeWOxhDnjcwfO59RytrL0tSIGJ5Oo3R3zc7ssDIJY68ukMQKV0uSBitDRhBETcB4ksRf5ghyP2yDeYBgQPKqfCTeK9LFA6S_VmToIop_hWLtywDF9groe62rgGs3c029W2Dp1ceZ2M15NGU804nR9GpjR-_vv0izRx4XZ5HuOEHK15Eb4FYGwsZ4I-b1Yy6-DNzmkYOLAigrmZQ5AEkMf9NUX0WmjaDDCVSoLamVN63yIKJCdpCFBVxydR2aQHbNoh9-1ds7z2l_GDKxulFx8YW5cff3gMYn7_vDsf0nQXu5f6dothu-PEXnFAppPniIuxVdDb6JadS7kngD-sof9wXxUScSDLQXdbvQ3fxPl9G88tQIYIvqw-p66fBnjPqsP53a7cn3m_s4l_PTF6PkOgpXp10MdDZmSnZqXQT_vvfqM0NtG0RgSbpGisQ93iAdQV_cYj4Zy5reLkLy9i09LbgEsYNnrhHPo1XWtgOmwwJx5JX_h8X4p_HMr2rga7ZgCI8pL243Sd-lQ_4AFedzTB6t4FC0YDpvmyQzTxJmbcX8Ub_kZIA5wtz9eUXM6g_G9evIZ10EBPV-KZUjC2kscaKQ03v52vynnrkOAQK6hNxrghaV0UGjxPTJ-FuJ3rn-fUuTAZG3iePCoZkQSuLE_sK-7VtdAXa5yXk9xDUTDRaXLoj3-7G6JXkSveH7cGhTXfGZm7oblJSjaXElfTMA9A7sh9Jx4VVRP6j5Nq3szNO8bV-KQzd9bpTfCOYdKFEBX2-fM-YU1VpheCdCzALbuALmastFsSsUrcyZAJdS6del_xzFRfePuYGeOhSz5gA4ShFFoZIAFstNYx7EVchJxtR2cgK6HU', `Progress` = '4' WHERE `ID` = '1127964'

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.`AccommodationID`,
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`,
				`reservation_rooms`.`ReservationID`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEarlyBookingDiscount','LLoyalCustomerDiscount','LDeposit','LIntermediatePayment','LFinalPayment','LChildren12','LGuest','LChild12','LName','LBirthDate','LEMail','LEGN','LLKPassport','LPhone','LAccommodation','LAgreeMsg','LAgreeGeneralRules','LAgreeTourist','LAgreeBuletin','LFreeBedsPayment','LReservationInfo','LCheckIn','LCheckOut','LRoomsNum','LAdults','LHolder','LEditData','LTotal','LAdult','LPrice','LPayWithCard','LLearnedAboutTrip','LBusFellow','LPromoCode','LApply','ErrorPromoCode','LPaymentType','LPaymentDates','LTotalSum','LFreeBedsNum','LSum','LChoosePayment','LPaymentCard','LPaymentBank','LPaymentCash','LChoosePaymentSum','LPayAll','LPaymentSum') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

UPDATE
                `reservations`
            SET
                `LastUpdate` = NOW(),
                `Progress` = 4
            WHERE
                `ID` = 1127964
            LIMIT 1

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `accommodation`.`ID` = 795 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

SELECT
                `StartFrom`,
                `EndTo`,
                `Deposit`,
                `PromoDate`,
                `Nights`
            FROM
                `programs`
            WHERE
                `ID` = 1457 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 254 AND
                `CardKey` = '40033382cb6335bf978a6843301bbf62' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `ID`
            FROM
                `promocodes`
            WHERE
                `OfferID` = 254 AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                (`ProgramID` = 1457 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                `Visible` = 1
            LIMIT 1

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

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

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1
# [08-May-2025 10:56:13] /rapsody/root/bg/ajax/reservations/confirm/1127964/progress_5.html?_=1746690973162 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.`AccommodationID`,
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`,
				`reservation_rooms`.`ReservationID`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 10:56:13', `SentDate` = '2025-05-08', `Keywords` = 'Y2FyZAdGVzdAZGF2YXJza2lnbWFpbGNvbQ', `Data` = 'qL17C_uD-er9qZyfrO1Z2QBv5erL6R-LgZPDAi1UZaT9KDBqeU--aYAh_qnCpV2WLh8oIw8FEfaIFkZR60zGVs8yW8E2lR3-SpUXkG-Sw8iENyXSg4XkRHZPeoqEGliE3YfKN7OhZAq1cg0IGUumiMhJ9yNWm07eY_HkfFLvjbrgS9L-YESs_rep1IverrIFjRkv31xbKOyq5MtX2qrlu1O1-9l4k7N4N1MJgeMtB6DpOMckBMNJAP_Daxnp4sZYmxs7E0UA-Orpa601In9vvYVxZy3VXEOS12rax5omTunGFmXU5m12WgU6fFYvq4cUJqEQjdBxC0GmX8r-h6asO2IKIQYGYMjvu-lGjHEJ8-M3sHCbUYD5gLR7HdPO9A6oS8FZDNQsGvCXjR4ZZmVKCDe7vz0iCmxqjpigDYhkRLeQ5Sa25OqnagFNfy13Tf9i-eLOCjAB7CWmXq59BWTNiJ15VwtnT-0xi35M_dWFgrAwUTNcF_gEPmPTO_ThfGDKd7kpaHvAeSC6w3qC5Hx7hTvGk8w1ThWTBRQ4R9hSxIOzfBXRablKls31cIcM98Wmk8i3PVJ4tGeTla0Wv3kDRvaokWpms3Ti-F4UeEfi_OhImwkugCOFMekuEgA7TWR9tQoQ675bL3v95X9yiePnof5gwsISJIHIw5Dzkpmccl9YBbhcfLXz0rHnssgh5Ghe-FZbba2BhJyJXVEZuzfnlGgNYu8F_5_qegJmJOHmooqRofUuF9sIyAC6vYau4XwOwBV2-Qd4fzsYTWGTGh_7g4ZkOo4YEY_Vqv8DJcMaE6DrG1MY67bZMcC8UifMOeQbf-rV50R5GwPEbtsVmp_SBEemr5ZcfIzwFivE0C49bbQu-u8hb_OEgBno8TuWqNyPlwVcu_WSjNZk7JIQwXNuZ--7DOchs9bKUWBTCsQOtC0QAk0EjI9PkNuQ6uJBaDLBE1VihME8KxA1k9fXrBCisJ-3Yn0X1P4F6ruZNV3uVc_lyelw3EI_pWdUGVvUX3xlhELg2TlgfmE4EGmEoX7FDlpK4Ld_sRzC1frj79QkjarbfvZwp1od-2ouhVJYCvoZCUEM2E_V75PxkOrPlKofi8Z5ZjqMPoIswxwt-SfawdN8zd9BixVqMalgsy9s4CaruEYdsr1LJgSpN4XbodKD21AFw0zNY2yLBCkTTdToRkJm5uM7N_iT2NQGvSZiUqbmzPhhOIBnr4CJYHCOQrqkTK6wKwNTe1cGiY_FAxBmkmYauPhgQWg9aoCtTw2OGbybopjQeZ2J6kdFGO1eqA7fsdOAdJswGq4-sEVCDcaHY6YoFI3UHivsQv7DXwNWlxxDTX0b2nIePq6qB7ji0cgPkizEuG3Wo_Ab7KRDmUnSRX3GVFiRIovO4ZTmLMQS9MEE6IBpKICYyfEoIZUvy8eyQ3ESCf4L-hwikZ-8oEA3n1aV0-TvL3rRjf8JlrJOByyj_hCj91NGKYlXbWcrRB7kLIvPU0AQWIPZFSojIyVLomxKBg2h6uHcRVY-L_bTm_0GKGlRd-sgUS9OkMnoQYzBX0TeWXYVCOOmDvYT3TN_Q2MUCZFZ5DUscjMvkFP35Jf85LxrF8-NHP8tWT_syloQN7qu8Ojy2J68CoDxvFmQYONH_zBARJB-Vyib3QLTq8bohTVhqSfSqbABPMgChdLiKFLqR_Z2OuFTgs4oOPxNdap_jv_0UEqw_miwYY5s0OYBPrfuWgP8TsCuZ7mFTGp4dVLdcNM7L9CfG_1qMWU6aASFVoynXhKQ8KJRJ2R3pWjgpAkQ-VvenB8oe5ozba4uTjSUfgj-paUUc7uuklCyXBiKdUBEJGkUcX7jeYTsb8pUhC-Dph6B03yL7DZB9AHZKuEewexU6gfSgBry-itul2ZAA_9_0ZXJMcnIG-7TdntiTirZZtQZdaporpUhy6txtxWHkPtvuzZq-pvac-tKRX04o2NNIe0uiwFYQEoz4wLMZ2Z4jekPtN46FGGF7VtbcjcjILq-nB0r1oZIrm3XbxenmC-ylQDtwOnPzZGHkSrG', `Progress` = '5' WHERE `ID` = '1127964'

SELECT * FROM `reservations` WHERE `ID` = 1127964 AND `Status` = 0 LIMIT 1

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 1127964
                LIMIT 1

SELECT
                    `Exchange`
                FROM
                    `currencies`
                WHERE
                    `CharCode` = 'BGN'
             AND `Visible` = 1 LIMIT 1

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Info`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1127964, '', 0.5)
# [08-May-2025 11:03:10] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

SELECT
                            `Language`,
                            `Module`,
                            `ModuleID`,
                            `Data`
                        FROM
                            `borica`
                        WHERE
                            `ID` = 1013 AND
                            `Amount` = 0.5 AND
                            `Data` IS NULL AND
                            `ResponseCode` IS NULL
                        LIMIT 1

UPDATE
                                `borica`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"ACTION":"1","RC":"00","STATUSMSG":"Approved. No errors","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"0.50","CURRENCY":"BGN","ORDER":"001013","LANG":"","TIMESTAMP":"20250508080310","TRAN_DATE":"20250508105237","APPROVAL":"S30460","RRN":"512801460085","INT_REF":"51B31D543BA838AA","PARES_STATUS":"","AUTH_STEP_RES":"ARES_Y","CARDHOLDERINFO":"","ECI":"05","CARD":"4341XXXXXXXX0044","CARD_BRAND":"VISA","NONCE":"B0DD11B5D2978287C7AF641A326C8188","P_SIGN":"1B8274BA2329BECF7BC88BC880F8AA99F4C970A459248DCFC7470E533D22FA0257CB84813DE41B5A64C34183C1258AA01E6E265C3B3D3659A72160F7AFF3F55FB80DABB260F903341CA614C589BF9CAC7A02B1495CEA410A4857B5FE556211DCA544C99ADC4836F985D2B4E2B126E45B15F47A32E86D6333994655D1A2DA6032A9026EB81101DA1E0F4777C15A4E71C76B9B9D01D3AFA918DBFE8E57C116F9C445662C79EBE257806B9CFEE5C11242F6369B7F4BCDFC7BFFBF2EAE7D3E3E2F846E84B05B4AE18014AAF5191C15F04BC9CFD2144883D693AA61C46AC95E31E34607A87836807241AA1D5E65EDCA4F074FC44A6F05997F323747D50C26DD373CB7"}',
                                `ResponseCode` = '00'
                            WHERE
                                `ID` = 1013
                            LIMIT 1
# [08-May-2025 11:03:11] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

SELECT
                            `Language`,
                            `Module`,
                            `ModuleID`,
                            `Data`
                        FROM
                            `borica`
                        WHERE
                            `ID` = 100515 AND
                            `Amount` = 0.5 AND
                            `Data` IS NULL AND
                            `ResponseCode` IS NULL
                        LIMIT 1
# [08-May-2025 11:03:11] /rapsody/root/bg/payments/cancel.html 167.99.142.201

set names utf8

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [08-May-2025 11:03:13] /rapsody/root/bg/ajax/reservations/offers.html?_=1746691392648 167.99.142.201

set names utf8

SELECT
                `offers`.`ID`,
                `offers`.`UploadID`,
                `offers`.`Title`,
                `offers`.`Image`,
                COUNT(`rooms`.`ID`) AS `All`,
                COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`Image` <> '' AND
                `offers`.`BookURL` = '' AND
                `offers`.`MenuLabel` <> '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY
                `offers`.`ID`
            ORDER BY
                `programs`.`StartFrom` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LChooseVacation') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 11:03:14] /rapsody/root/bg/ajax/reservations/accommodation/oid_254.html?_=1746691393631 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `reservations`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755' AND
                `OfferID` = 254 AND
                `Status` = 0
            LIMIT 1

SELECT
                `programs`.`OfferID`,
                `offers`.`Title`,
                `programs`.`PromoDate`,
                `programs`.`Deposit`,
                `offers`.`Currency`,
                COUNT(`rooms`.`ID`) AS `All`,
                COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`ID` = 254 AND
                `offers`.`BookURL` = '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `reservation_rooms`.`RoomID` IS NULL
            ORDER BY
                `programs`.`StartFrom` ASC
            LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `additionaloffers`
            WHERE
                `OfferID` = 254 AND
                `Language` = 'bg' AND
                `Visible` = 1

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

INSERT INTO `reservations` SET `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755', `PostDate` = '2025-05-08 11:03:14', `LastUpdate` = '2025-05-08 11:03:14', `OfferID` = '254', `ProgramID` = 0, `AccommodationID` = 0, `Data` = 'N4g_KdgE8V1H_fUJDZLIxsj_K8YrDd8m6N1V3b9A1DeZ-TdzujY493yX6_9eL0fKrQqql-xz_Yog25kDES_mDBPBr0P-WamwWbfzQclR1T3IL-ZPOXBSt4IqdX0toS89tHzSIOh4OmVbkB4uQVCJ5KDS8aywqo0nbGqe0s9PgGarkibzh-ZvvvgCx5Dlmbw2uZ64g9H_Vp6iuMxicX0JDTSXAQuC90qiK1-6TrhqivIkXpCTL0vOrEvlCZx6En8hLZmVvWEMpxHI1nqVEuuay2dPq9OkSKvpum01rM0DLVt8_Q-LrC5TP_CmexMUz01oV0uoSY5kWPXJbZ3ho9-sxYXD2nWhr831Sb2UFjKsK-HShC_-ylfQJM9kcY1lisOFkf3qsV9TE-bkeJOzVJbEoufkngDujyuMOME2SPyw1zs', `Progress` = 1

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1

SELECT
				COUNT(`rooms`.`ID`) - COUNT(`reservation_rooms`.`RoomID`) AS `Avl`
			FROM
				`programs`
				INNER JOIN `accommodation` ON
					`accommodation`.`OfferID` = `programs`.`OfferID` AND
					`accommodation`.`Language` = `programs`.`Language` AND
					`accommodation`.`Visible` = 1
				INNER JOIN `rooms` ON
					`rooms`.`ProgramID` = `programs`.`ID` AND
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language` AND
					`rooms`.`Visible` = 1
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`programs`.`Visible` = 1 AND
				`programs`.`OfferID` = 254

SELECT
                `programs`.`ID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `offers`
                INNER JOIN `programs` ON
                    `programs`.`OfferID` = `offers`.`ID` AND
                    `programs`.`Language` = `offers`.`Language` AND
                    `programs`.`Visible` = 1
                INNER JOIN `accommodation` ON
                    `accommodation`.`OfferID` = `programs`.`OfferID` AND
                    `accommodation`.`Language` = `programs`.`Language` AND
                    `accommodation`.`Visible` = 1
                INNER JOIN `rooms` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`Language` = `accommodation`.`Language` AND
                    `rooms`.`Visible` = 1
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `offers`.`BookURL` = '' AND
                `offers`.`Visible` = 1 AND
                `programs`.`StartFrom` > CURDATE() AND
                `programs`.`OfferID` = 254 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY
                `programs`.`ID`
            ORDER BY
                `programs`.`StartFrom` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LRoomsReserve','LAdults','LChildren12','LAccommodation','ErrorRoomNum') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

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

SELECT
                `PromoDate`
            FROM
                `programs`
            WHERE
                `ID` = 1457
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 11:03:16] /rapsody/root/bg/ajax/reservations/rooms/pid_1457/aid_795.html?_=1746691395784 167.99.142.201

set names utf8

SELECT
				`rooms`.* ,
				(
					SELECT
						GROUP_CONCAT(R1.`ID`)
					FROM
						`rooms` AS R1
						LEFT OUTER JOIN `reservation_rooms` AS RR1 ON RR1.`RoomID` = R1.`ID`
					WHERE
						R1.`AccommodationID` = 795 AND
						R1.`ProgramID` = 1457 AND
						`rooms`.`Title` = R1.`Title` AND
						`rooms`.`Beds` = R1.`Beds` AND
						`rooms`.`Price` = R1.`Price` AND
						R1.`Visible` = 1 AND
						RR1.`RoomID` IS NULL
				) AS `IDs`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`AccommodationID` = 795 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`rooms`.`Price` ASC,
				`rooms`.`PromoPrice` ASC

SELECT
				`offers`.`Currency`
			FROM
				`offers`
				INNER JOIN `programs` ON
					`programs`.`OfferID` = `offers`.`ID` AND
					`programs`.`Language` = `offers`.`Language`
			WHERE
				`programs`.`ID` = 1457 AND
				`offers`.`Language` = 'bg'
			LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorGuestNum','LRoomTypeQuestion','ErrorOption','LEmptyBedsInfo') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 11:03:17] /rapsody/root/bg/ajax/rooms/empty-bed-price/23743.html?_=1746691397173 167.99.142.201

set names utf8

SELECT
				`rooms`.`PriceEmptyBed`,
				`offers`.`Currency`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [08-May-2025 11:03:18] /rapsody/root/bg/ajax/reservations/guests/1127965/progress_2.html?_=1746691398487 167.99.142.201

set names utf8

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

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1

SELECT
                `StartFrom`,
                `EndTo`,
                `Deposit`,
                `PromoDate`,
                `Nights`
            FROM
                `programs`
            WHERE
                `ID` = 1457 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `accommodation`.`ID` = 795 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 11:03:18', `ProgramID` = '1457', `AccommodationID` = '795', `Data` = '2sA4ndkz3GkNgKkN-g1Y7RxPj9pK9lHPWZMwTeibl3Nn-YQe2B7gJ9xGfvuqDJkl88oKwdVPqc_ZrQ2jvitP40eTPsi_LAPa3eO8-rCelZe6rK88sWvImrqDr0evwfbEVPgxsPw5TiTFZoQAFo4FpKmqO6xgFRQo-QG6XHzlxcAncsBpOVX1NLGdrzzj_zliEA3FfA7zVKRsxnAqbaCAfxUQktdXMsAKfqloZ09WVFMOTbdxV2agnV4ChoELkkcHuC_ph299rcDiJy2ZfnZfqYw5ejMkAYJNrKUNOJUYbmYd_71Zjm11tqfKZkNTatQP95ec878o9hVL31fQ8VvQ474AYfLwLUI3YxhGuti367grmPUsBMQL5WtBXbl8a4cZ3LyYuwDaAQt8N7dJRIVYtq9kaF0ZHAvaasux6cSG5phLW7ApDWSOb_Ryr1LTCAquTgAOCyoTtqW5LFyKtjn_lje77xKNEGobTij3dSp3-TiS3Z_7wACm2tks-v69GG4cOFSkXpFNcsIkUXhOpgy9mFqLnWinxf0xAGGOvjBg37DzBq3O6pNHDUxhmv6sRK7NMBYFI9wYIi4BvjIU7L7uU7jVJtmruWMBGyDQxVO4oryAm21_Cja6naIZmVCM8PcHwhS_0iVJUowbBCvD9-tGjp1-zbvMCAKqqckBI3kTPN97ZN1DYsKBcYNLUkw8838E02ovaPAqE6ZjHH6rOB4CIQWbmvfp9RGd01evZySEWyDIg4aQyC3eBrFA0xkD24Qy9pczfzk59ss-k7nwIXoD_IG9DexJwiZTgoGro6FCV0s', `Progress` = '2' WHERE `ID` = '1127965'

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorFullNameLatin','ErrorPIN','ErrorPassport','ErrorExpiryDate','ErrorValidEMail','ErrorPhone') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LFullNameLatin','LEGN','LPassport','LExpiryDate','LBirthDate','LEMail','LPhone','LGuest','LChild12','LFillLess','LFillAll','LAgreeText','LAgreeData','ErrorIAgreeCheck') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 11:03:24] /rapsody/root/bg/ajax/reservations/additionaloffers/1127965/progress_3.html?_=1746691404535 167.99.142.201

set names utf8

SELECT
				`Beds`
			FROM
				`rooms`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 11:03:24', `SentDate` = '2025-05-08', `Data` = '4mBuU-d4OOs4bFG1y6NFmVhIU8iS640WV51rcrYuDBroDvvlX13UE285IVJdI4xYNXgihshXTSFG1FVpLeQ02giERmLGsnfJsy_jDvafCrBfQKgyVX_skKich6cXK4PZ9t4-Zd5mxX-1ScGjz_P3ZJtoLiFXtYzbWfhKWWwTnKouclWgok5bcW4oSc4279BWKle3ktM2bqu4n0f5cRPlk7PuatGDKkuIQ99h2xuyMKLcuObdXjreRnPalGV2xFaQSncJdKBdgSY5dfrxDkmD8_bZ8cuJQwMWPOXNt_ABe1YjYocLPZKrjULvHT3UvtUSsy9eSZsMvt9N8wDvqMZ46kwlAi6-aQZs-7bm_HMZffkScQeCKh2hdbx3qiLhL9U9y73BrGVHauSOSgCQt6YiH2M8mMtt2ppNKQVbN8FDYD8bYD_rfNDoLyb3TemYHEW2Jt9vbjnJ4BA2E_oG-fklWvNpPZbsWLMl2ZhSuETOhIbnKNt0YlunLTEz7rxPP-QFotjtRhaP0JXvVtTLCubQKvQEy3gg-Bmj_qbdXpWqsSae4bIRvjsR-g4kCw8pPijTc8RtyhxSBqTC9k7eE42npyxAtnj-F8nFLQPHMeX2rHWT0ywFD4e5SwC3Q1w2qt7-IHF7o5mxlCL4X71SRVSYAsS6GGr8InuPLGYiqFTw2zEfj1oZBj5yJCCBA6tZQnMWdTmGNDbFB_SM5DI2bCw_rlZpPPdTkGWuMwV-2wv-I0o5OltzsFX-7AK_UZeaFXJakx3eJugizg1sDYIkDUdTlkTW_VqTiuRUgmzLA6eWr9so6r8TirUbvU4ITxrz-lpWxzt9L8vSRFMM6gg-IFkNTkE2yhRp4ob84blvIwmy43pll5V4JKtgZIXKkhN4cDhVE6CWvoGOKlQFir2XOBdhSiSvau_7UzSw2-uKr1gFHmsay59WTq6IhjgcnCm46KzM_O-zVf4wtKJAq5bqgPJoT9t-XcKxSHcVQINDCAEs8ivrnbIWFjUH2PvMgTEMzFMmCa9j_Dz1IO5ijvRjp3mbX4EumRGvZrWqLLNrsu4b4x26APQnrSAyFNK1W7rcefFYMK1vH7lCi7dmINGNEeeueK-qavPvj5LT7c8Hs8OibXPK2BVi8wuQAnWeVyVFXIj5mItzyI2iRbXhCg1oynIe22XAqZfcz97Wi_EqcwADEhdacEjcILN6a80eahUx1iQp6MDkTAbQNX3vRcoPN9StKdRk8WwFU8mEgjyofJKMyqzC4GohKX2KG3ArbLL614WM1DQN2Y7vk6kcagDBzOo_p69tWtkg8U2pbSpIUTpz6aMMvvrD2EzttxhVr4K6DXNXQLAhU-5kpqYuyRuVXTWfGc396nxjr6Dseu7Cer87eexXQsBW4vwpsRg2cjdm4SxcxIp3oqA-E8RQxbZ4I0BOgLyDhAX971eH7aY9b7Pelf_0bz73eDlROt2eYNmHLsgLx39LSOPUSCmPFcMO-KHcbm_OTpvPMRMTXuesMJJnNvBVcdXQ_Un5Z5xld7WZxER0gbZl8-JDgVXtP4XoCw3F7xfcVO4nZoAfh1fUXIc08fKm7IHjEuEKapvmjLW5nmpo1vOpXMy1mUpEIGH1XBvE-v3kYB8hrHciz0TPtQygKQ7iIHBx8xYUUi1W_erSqdrS2cBghAScCN2N5KDDDcH8xrSJdQ6wljl2VL9fFN3iain2H11RKmTJh7aFIL53DQebV938OIJCByum1cPXwFoGGg', `Progress` = '3' WHERE `ID` = '1127965'

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1

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

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

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23743 AND
				`Visible` = 1
			LIMIT 1

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23743 AND
				`Visible` = 1
			LIMIT 1

SELECT
                `additionaloffers`.*,
                `offers`.`Currency`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON
                    `additionaloffers`.`OfferID` = `offers`.`ID` AND
                    `additionaloffers`.`Language` = `offers`.`Language`
            WHERE
                `additionaloffers`.`OfferID` = 254 AND
                `additionaloffers`.`Language` = 'bg' AND
                (`additionaloffers`.`ProgramID` = 1457 OR `additionaloffers`.`ProgramID` = 0)
         AND `additionaloffers`.`Visible` = 1 AND `offers`.`Visible` = 1 ORDER BY `additionaloffers`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-May-2025 11:03:43] /rapsody/root/bg/ajax/reservations/summary/1127965/progress_4.html?_=1746691422671 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 11:03:43', `SentDate` = '2025-05-08', `Data` = 'O4js690gg3hK_iw-uAMxqWjA2BVpd3UISY3WPIi6BHEkwLFZ2qk3taxhRxBN3NmYu_VgwWPoGLF5iKSGV1MPNmJ4jUXY0MsZ2XnefOLsS7v8LQQlMld0lXT8XmEdKZGjwpGyV59BvUCDwxBmq_ajP8q85r6PuX09LY3zaBKCi6uryIfUjNlHDMUMSRwHHMjE52N5PxTaaZ5k_eThN-f607RSnUXKHrs9iEK2eyMPLdjL4dxFRhZDfOavugEpWs7BPAHmQgX20JibLnUc_1DYcofHu-Wytw4Lth4UrTcShaE3OC-SxwHRbg8NEJJxLAKxm0gyKd3skbPrX9M3LyTiEg0lUBCG_YOt93-AtyqDtBi_2Kcr1cvNDkrltDcrGAuNFLS-ULUGX1IJH-lNiT0IxujJuf5SEqHvzkBVyX-kloZjMId1KrgaoYrCiq_JtE-bHhOoSSaGsJ50qQKoZcrKC73MTT0UOazoSyZ8dw7OBmJoiwBwMW7qemV203ydQGwcxmcMt-dUCa1HUz8ufNwrgIUJqtF1JN_6HqBBFxhKIl57wiHcKFoAviwC98ygY2QECJQagPl8A4_DFF4Dp407_wmy1_LZF50pRNolcNUHBySn2OeFilXmeoi2tCeXP5kjDg7b0luBE1waFBRqCMwsZFqoIOglvj0Jf74H1I6lSkwjfm22syrg-DYQ68a61z7szH_AaOjfqkiD5g0BeqHLrGHi9H6JiJA2FGJIyhMTxkPtjHzxcMT0qnzo-t4mK04A35wOJRtLLjmgk3OXAENAXPeBMAwQqHmZUYMPddHJ_GpDgeGtiKtQv_9GwmtSH9zGZbBMccRN9L2UAe8JegfD78aIpghcsVtd5gDrBYGavMlOFzFQZVQzkqVDJ_FUuuj0qHgNnlC6a_1afct6v9SkzPAd191RYOeVRwG-J6l--f1PGoLkQxt2yJe5QQikMYkLecZXYaqWzJM3T6nTpvWlelYcBMZK4ABlWmozsvpRAg4QKpwk__jin_jFmZlrbmiCnXoyJuEJIfu-cUyiiwF8fuWEfCsfEzIwtonf0yd-JUir92bCMD6EYLM7UIOnCTiSqOGG1NMs4CVb2duDeJN5TgIH42UVMHkhEYsLFcImxWAc6ZlXDLEmFUOmBBVd6gDRYcwuigH7ra0mZP3pW8SB8ZJcO8mBvlAwn3TkgdPGdDXmj1FTzawyPZzoh896v1ckwmXb8YsTfbzaJMPnRqxxt9mPQcT033tcwN9igFAeqkAIcT6NnMQpI9oIv1zJ7IQ1Fay_lPNuROiXi7hqtYqFiQJwYnJWNoL8yb2fQEEXesx7Ug1ShgtNP_hRxuKCHl7o2fTilr3nWRMItECsmq636vCreaBW3H9l68OgtAu7hnEgCM59konQNoDRPOcMCu1ktsf50W2Wdb1TNsMIJgRwSbm64A4QW2KTOKYcK0uAQFY8eobiMAD16lQW8q14-SwYLtX0dEHkNTg3x7Tn7mu9m62JX1L2Ozo0dHpekXcSTXWyAyB3yZU15SpyqRKzod9mhgm7nN9gaVXYzG4IJSEjiLM1Qi23w8bfTt3-vQHAYR56L7sa5m1GbrpHnglVjoY0ytliawEgNIaOCMq0qRHeSi6IepS4tu7dhtb2r8Ycjb0Bnwi1FlyrhsaNWQzgo-Fi5xGmX5GD6mEUvOP6Zxz6x_zDVmYA_pMXAVitbWkRk8H7OBA6drqlchB0ddxbHDKgZs5CUGjMeYZQHeMMrmNftOnx5p2hDz6OOEx0Wb98vKttNSHSAdjf4FCP-88AoX-T7UCSWXqFMcoZBYQPvC6GUieG3YPU78fwxpMccAjDNmD5AICkluIsjkZE53cGgSaE', `Progress` = '4' WHERE `ID` = '1127965'

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.`AccommodationID`,
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`,
				`reservation_rooms`.`ReservationID`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEarlyBookingDiscount','LLoyalCustomerDiscount','LDeposit','LIntermediatePayment','LFinalPayment','LChildren12','LGuest','LChild12','LName','LBirthDate','LEMail','LEGN','LLKPassport','LPhone','LAccommodation','LAgreeMsg','LAgreeGeneralRules','LAgreeTourist','LAgreeBuletin','LFreeBedsPayment','LReservationInfo','LCheckIn','LCheckOut','LRoomsNum','LAdults','LHolder','LEditData','LTotal','LAdult','LPrice','LPayWithCard','LLearnedAboutTrip','LBusFellow','LPromoCode','LApply','ErrorPromoCode','LPaymentType','LPaymentDates','LTotalSum','LFreeBedsNum','LSum','LChoosePayment','LPaymentCard','LPaymentBank','LPaymentCash','LChoosePaymentSum','LPayAll','LPaymentSum') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

UPDATE
                `reservations`
            SET
                `LastUpdate` = NOW(),
                `Progress` = 4
            WHERE
                `ID` = 1127965
            LIMIT 1

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `accommodation`.`ID` = 795 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

SELECT
                `StartFrom`,
                `EndTo`,
                `Deposit`,
                `PromoDate`,
                `Nights`
            FROM
                `programs`
            WHERE
                `ID` = 1457 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 254 AND
                `CardKey` = '1e4c94d5597d3f951a491c7991e843d9' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `ID`
            FROM
                `promocodes`
            WHERE
                `OfferID` = 254 AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                (`ProgramID` = 1457 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                `Visible` = 1
            LIMIT 1

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

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

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1
# [08-May-2025 11:03:46] /rapsody/root/bg/общи-условия-за-ползване.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'общи-условия-за-ползване' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'общи-условия-за-ползване' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'общи-условия-за-ползване' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [08-May-2025 11:03:50] /rapsody/root/bg/ajax/reservations/confirm/1127965/progress_5.html?_=1746691429647 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.`AccommodationID`,
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`,
				`reservation_rooms`.`ReservationID`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`ProgramID` = 1457 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1457
            ORDER BY
                `PaymentDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-05-08 11:03:50', `SentDate` = '2025-05-08', `Keywords` = 'Y2FyZAdGVzdAZGF2YXJza2lnbWFpbGNvbQ', `Data` = 'eD61OGZF1_QU_IQaLo8Kdcqk8TPe7A9bqRafm5W2_gd6A_MZrvJzWpydwJxWbvgr83fnNiIURHEQTH6jYdWmFjiO_JYLj7qVq0pUuDymuH2hd53awKgTJecML__-R0f7etpQErsmQHZ_BS_SE0E-3uUr1zTRKFlGM67ac7fYIvdQx-vd2MJp9T1eyojYR4NNucgrVns8Lkc9fpF8UG0Rwn9QDM6V8UvGbjpwdfsxaxfln0fPgYJKsIlk1uGMIYbnfYj7ZRrwV3q74RepUc8m_xaxWTh48ipgW_6L6USTZQuQGShnopn7a8nh-X7niRzyiK5KMp-ukc4y5CIWye-HkDbiQn8A2huPHeqCsMyJqUby2DpsSYRqK4JJhExEJmQbe2vmLrw4NDFFOoNcWf7NkX_zqrJJ8tWH1dAYTKvE9tnpUuzFh5_zQmCGYTeTFkyXyIjsY7aSDu2UDdfxHYRpdrll-yE1PI9jty-eiLb4CDqiNnDOQCkpnfHKrzgnZy0t24AGxUJ0CLQ-tij9go5AndwD-LdHKnZnpCGMm-Pt0nW4fBF0adqZ_JtQGNJZPnuc9MArbvfRH3zaiDbPcIF_F5chCT31a2tCNdcvwuaXCKhYEWYteUx-jJuPVuP85ndyPnWc4ciE9MwR8_b_qCQUdasd5yiHVAumkVvfvBMPYdRyI9FvJeXWzB5v0risV3WGuTVPFfZaA8_CvaLABjx-XGcbm-erOmPokgpJld9jkydnpLGfHAwyGxitDB2ejF9QYCjcB-v1A9fg7S5ujLWrB_he-0eWtcLu2l3I-VOP_xIXaVHF3zmdP4SJuCoZbeBIz4twuk28g_D7R6bIl4mG56g8ZjHQ7O--4cO9cG71oUJ4AfxboyP-f_1q0kAMsDn2btAkNKyFxKyDViEN9U3bREqj1rdpsNztT2SUzSivkkcXm8gtC-zgBDxIDizaLnSbhA6URICH-gw7ygSmC_zYb-uHJkqor3aYQYdyZBoMUsjaXKfHpCpSu-iHhoDttVgKACwN_U_1B30qjrh6WCqkD6trBYx6dwKPMn5cqUDCuVXSoBVJNTINs5Tkg1s-8a6h7kJI73flwig2Kwq4RwzTJLL0-uOCHhBpE0fPfpFpvbWmpOwSPXn-GQUHt6CTD8Sk24PsgONkmr7WKS05ovzdRCgzgUGEIFcegm97wOl_wYsZ4GI2rXOSBerYoYjH0Pl73uAM_FMDI8YzeB22v8gbYCh5cO702qPaeEjXYwYPBRrbPgD36C4Sf69mfkhJ5iFryeP7mAddKfQ8dF1jgt7XlyOax8FaFJbr9shACIUnsxFeqtyl8baBP9aYL0wc144iCAUSFUlXBSSnRmW_LRe9DCE69s-SWMEJUSgw9rXS_Junpwyal8Lgm18ge7Gtje3NFcHMeH6EIagZt8nkQpnA9SwqLLZmxFVYmKuRiDHbVebKx2Ai6KOVlS2My1cBzCpE3PbM6y9LgxVVS9rwl_KceeZ_1AaZ7WIrU1kzwKfpgXfvBzwS2tohVvDCLb3--xnC3LQN3ycN53RJVwVz09NXIKaoHsfeY_Tp7a9rkJgwHO_AIiVJu41oBXyRPaaJZc0kQIbbf2fM8v2EzPBjenRx_sjct2PO4U35jBfRQ2yAqO-IbWZAvuQBxnOkR2etSsy41-FFjWWRHHPc7jpMP2xEgt76N9TLnl87DiPpMRn5X5TDsLXGMJPFQWnqasWiblriiba_v7UAQxHMp9Z747bS55g-Ub7cjxP29WnJi0nttk-T_u-rk5TKJ_QjGSd7wNcFP1xpXhwzXV2mAypv_Hrl9qs85c4W6l35Yg1O-7KIgQ3gtVcT0ioJzS2UH-2_3Fh2pGuPSAk8LcUrGTyq6P-NGBEOSMHqtTo6sPORUGtT6q58B8Gbk6_2_DYUqMsPAuInrO-aB_DN09K0lmzhnh0quZqBFx9lEQYtUpp4-jawMxYl3vcIERIahB7e17zD6dPiYUFdjilQIZxmsJe6SoU-Zt1Aa73DGo1KnzOGXwic0RgzyVYm14zUcSqelIwnDGos', `Progress` = '5' WHERE `ID` = '1127965'

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` = 0 LIMIT 1

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 1127965
                LIMIT 1

SELECT
                    `Exchange`
                FROM
                    `currencies`
                WHERE
                    `CharCode` = 'BGN'
             AND `Visible` = 1 LIMIT 1

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Info`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1127965, '', 0.5)
# [08-May-2025 11:04:06] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

SELECT
                            `Language`,
                            `Module`,
                            `ModuleID`,
                            `Data`
                        FROM
                            `borica`
                        WHERE
                            `ID` = 1015 AND
                            `Amount` = 0.5 AND
                            `Data` IS NULL AND
                            `ResponseCode` IS NULL
                        LIMIT 1

UPDATE
                                `borica`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"ACTION":"0","RC":"00","STATUSMSG":"Approved. No errors","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"0.50","CURRENCY":"BGN","ORDER":"001015","LANG":"","TIMESTAMP":"20250508080406","TRAN_DATE":"20250508110404","APPROVAL":"S36905","RRN":"512801460088","INT_REF":"479D2A742BCCEA27","PARES_STATUS":"","AUTH_STEP_RES":"ARES_Y","CARDHOLDERINFO":"","ECI":"05","CARD":"4341XXXXXXXX0044","CARD_BRAND":"VISA","NONCE":"DC5BC77B1E2672ED415CBB93989C3DC1","P_SIGN":"7982A6868DAB55B9DB122CC920C4514B625099B18F19A5B7A042086081B538E8723D5D33B96EF5DE5D4A83AF6928A05C351F6364E16CAD3FDBA6CAC7CF6532FD2602FBEC26811DA1A454B41D983F6D44DD309E1D70DE8440D83DB12300FEC10EF8902C10BE6266CEDE078AC23189D76950EC3F79D58787AD9D3BBCDA10B767BBC450183B26AF69ABCEFB8132BD2DD4F5972D95F6D3BF8DF03E9956EB755864132130D02EC700CD03E73542F3D46ACA4958B25C82C39710C32DDF8A7A87D5D64CFA7D2BCB2E81CC1D36FB1B318C1EDA74B15EDE390CF45F57886E93CEB7D85FE8FD5433B74E6F94D1C6D88156A7829C0209B391E1635D8C371C8A3C38EDBFDB3A"}',
                                `ResponseCode` = '00'
                            WHERE
                                `ID` = 1015
                            LIMIT 1
# [08-May-2025 11:04:06] /rapsody/root/bg/payments/paid/borica/1127965_reservations.html 167.99.142.201

set names utf8

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 16
                WHERE
                    `ID` = 1127965
                LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` & 1 LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` & 1 LIMIT 1

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [08-May-2025 11:04:06] /rapsody/root/bg/ajax/reservations/send/1127965.html?_=1746691446125 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` & 1 LIMIT 1

SELECT
                `ID`,
                `Title`,
                `URLLabel`
            FROM
                `offers`
            WHERE
                `ID` = 254 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` & 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEarlyBookingDiscount','LLoyalCustomerDiscount','LDeposit','LIntermediatePayment','LFinalPayment','LChildren12','LGuest','LChild12','LName','LBirthDate','LEMail','LEGN','LLKPassport','LPhone','LAccommodation','LAgreeMsg','LAgreeGeneralRules','LAgreeTourist','LAgreeBuletin','LFreeBedsPayment','LReservationInfo','LCheckIn','LCheckOut','LRoomsNum','LAdults','LHolder','LEditData','LTotal','LAdult','LPrice','LPayWithCard','LLearnedAboutTrip','LBusFellow','LPromoCode','LApply','ErrorPromoCode','LPaymentType','LPaymentDates','LTotalSum','LFreeBedsNum','LSum','LChoosePayment','LPaymentCard','LPaymentBank','LPaymentCash','LChoosePaymentSum','LPayAll','LPaymentSum') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1457 AND
                    `accommodation`.`ID` = 795 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

SELECT
                `StartFrom`,
                `EndTo`,
                `Deposit`,
                `PromoDate`,
                `Nights`
            FROM
                `programs`
            WHERE
                `ID` = 1457 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23743 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 254 AND
                `CardKey` = '1e4c94d5597d3f951a491c7991e843d9' AND
                `Visible` = 1
            LIMIT 1

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

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

SELECT
                `ID`
            FROM
                `promocodes`
            WHERE
                `OfferID` = 254 AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                (`ProgramID` = 1457 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                `Visible` = 1
            LIMIT 1
# [08-May-2025 11:04:06] /rapsody/root/bg/ajax/basket/qty.html?_=1746691446129 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1

SELECT
                    `Content`
                FROM
                    `templates`
                WHERE
                    `TplName` = 'card' AND
                    `Language` = 'bg' AND
                    `Visible` = 1
                LIMIT 1

SELECT
                `EMailInfo`
            FROM
                `programs`
            WHERE
                `ID` = 1457 AND
                `OfferID` = 254 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                `UploadID`,
                `Attachments`
            FROM
                `templates`
            WHERE
                `TplName` = 'card' AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `reservations`.`ClientID`,
                `reservations`.`ContractID`,
                `reservations`.`OfferID`,
                `reservations`.`Data`,
                `reservations`.`SentDate`,
                `offers`.`Title`,
                `templates`.`Content` AS `ContractTpl`,
                `programs`.`Route`,
                `programs`.`Transport`,
                `programs`.`Insurance`,
                `programs`.`AddServices`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`,
                `programs`.`Nights`,
                `accommodation`.`Title` AS `Accommodation`,
                `accommodation`.`Stars`,
                `accommodation`.`Food`
            FROM
                `reservations`
                INNER JOIN `offers` ON
                    `reservations`.`OfferID` = `offers`.`ID` AND
                    `offers`.`Language` = 'bg'
                INNER JOIN `programs` ON
                    `reservations`.`ProgramID` = `programs`.`ID` AND
                    `programs`.`Language` = 'bg'
                INNER JOIN `accommodation` ON
                    `reservations`.`AccommodationID` = `accommodation`.`ID` AND
                    `accommodation`.`Language` = 'bg'
                INNER JOIN `templates` ON
                    `programs`.`ContractTemplateID` = `templates`.`ID` AND
                    `templates`.`Language` = 'bg'
            WHERE
                `reservations`.`ID` = 1127965
            LIMIT 1

SELECT MAX(`ContractID`) + 1 FROM `reservations`

UPDATE
                        `reservations`
                    SET
                        `LastUpdate` = NOW(),
                        `ContractID` = 1000008561
                    WHERE
                        `reservations`.`ID` = 1127965 AND
                        `reservations`.`ContractID` = 0
                    LIMIT 1

SELECT
                *
            FROM
                `payments`
            WHERE
                `ReservationID` = 1127965
         ORDER BY `PostDate` ASC

INSERT INTO `reservation_rooms`(`ReservationID`, `RoomID`) VALUES (1127965, 23743)

UPDATE
                `reservations`
            SET
                `LastUpdate` = NOW(),
                `Progress` = 5
            WHERE
                `ID` = 1127965
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationNo','LDate','LLocation','LPassportValid','LHotel','LRoomType','LTotalContract','LTotalAccommodation','LFreeBeds','LAdditionalServices','LNum') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 6
                WHERE
                    `ID` = 1127965
                LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127965 AND `Status` & 16 LIMIT 1
# [08-May-2025 11:04:09] /rapsody/root/bg/reservations/info/sent.html 167.99.142.201

set names utf8

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [08-May-2025 11:05:25] /rapsody/root/bg/хърватия--словения-загреб-плитвички-езера-постойна-опатия.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'хърватия--словения-загреб-плитвички-езера-постойна-опатия' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                `TopOffers`.*,
                `SubOffers`.`ID` AS `SubOffers`
	        FROM
	        	`offers` AS `TopOffers`
                LEFT JOIN `offers` AS `SubOffers` ON
                    `SubOffers`.`ParentID` = `TopOffers`.`ID` AND
                    `SubOffers`.`Language` = `TopOffers`.`Language`
	    	WHERE
                `TopOffers`.`Language` = 'bg' AND
                `TopOffers`.`URLLabel` = 'хърватия--словения-загреб-плитвички-езера-постойна-опатия'
         AND `TopOffers`.`Visible` = 1 LIMIT 1

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

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

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

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

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

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

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

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

SELECT * FROM `faq` WHERE `OfferID` = 254 AND `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '647ef4ca827cb5801e7545e4066b6b7bbb6c67a3ffe04ef310521cadff519eeb'
            LIMIT 1
# [08-May-2025 11:05:31] /rapsody/root/bg/reservations/guestform/rid_MTEyNzk2NS0w.html 167.99.142.201

set names utf8

SELECT
                `ClientID`,
                `Data`
            FROM
                `reservations`
            WHERE
                `ID` = 1127965
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGuestData','LFullNameLatin','LEGN','LPassport','LExpiryDate','LBirthDate','LEMail','ErrorValidEMail','LPhone','ErrorPhone','LSend') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '647ef4ca827cb5801e7545e4066b6b7bbb6c67a3ffe04ef310521cadff519eeb'
            LIMIT 1
