# [07-May-2025 11:18:13] /rapsody/root/bg/account.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'login' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Module` = 'account' 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
# [07-May-2025 11:18:13] /rapsody/root/bg/ajax/account/form/login.html?_=1746605893562 167.99.142.201
# [07-May-2025 11:18:13] /rapsody/root/bg/ajax/basket/qty.html?_=1746605893562 167.99.142.201

set names utf8

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '43ba590f6a0c0b3690b00c93ab54127505d0f8eb88c7656fde784c7bb85b2dc3'
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorContractID','ErrorValidEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-May-2025 11:18:34] /rapsody/root/bg/ajax/account/login.html?_=1746605914037 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000008558
            LIMIT 1
# [07-May-2025 11:18:34] /rapsody/root/bg/account/payments.html 167.99.142.201

set names utf8

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOvernights','LRoomsNum','LAdults','LEmptyBeds','LEmptyBedsPrice','LHolder','LName','LEGN','LLKPassport','LPhone','LEMail','LChildren12','LAccommodation','LTotal','LAccommodationPrice','LTotalAccommodationPrice','LAddOffers','LAddOffersPrice','LDiscount','LTotalDeposit','LTotalPrice') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') 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
# [07-May-2025 11:18:34] /rapsody/root/bg/ajax/basket/qty.html?_=1746605914657 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '43ba590f6a0c0b3690b00c93ab54127505d0f8eb88c7656fde784c7bb85b2dc3'
            LIMIT 1
# [07-May-2025 12:23:29] /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
# [07-May-2025 12:23:29] /rapsody/root/bg/ajax/basket/qty.html?_=1746609809898 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [07-May-2025 12:23:30] /rapsody/root/rpV4nz0Sa0q/bg/reservations/list.html 167.99.142.201

set names utf8

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

SELECT
                `programs`.`ID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`,
                `offers`.`Title`
            FROM
                `programs`
                INNER JOIN `offers` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`EndTo` >= CURDATE() AND
                `programs`.`Language` = 'bg'
            ORDER BY
                `offers`.`Title` ASC,
                `programs`.`StartFrom` ASC

SELECT
               `reservations`.*,
               `contracts`.`Revision`
            FROM
                `reservations`
                INNER JOIN `offers` ON `reservations`.`OfferID` = `offers`.`ID`
                LEFT JOIN `contracts` ON `reservations`.`ID` = `contracts`.`ReservationID`
            WHERE
         `Status` >= 1 AND `Progress` > 3 GROUP BY `reservations`.`ID` ORDER BY `reservations`.`SentDate` DESC, `reservations`.`LastUpdate` DESC LIMIT 0, 50

SELECT COUNT(*) AS NumRows FROM (SELECT
               `reservations`.*,
               `contracts`.`Revision`
            FROM
                `reservations`
                INNER JOIN `offers` ON `reservations`.`OfferID` = `offers`.`ID`
                LEFT JOIN `contracts` ON `reservations`.`ID` = `contracts`.`ReservationID`
            WHERE
         `Status` >= 1 AND `Progress` > 3 GROUP BY `reservations`.`ID` ORDER BY `reservations`.`SentDate` DESC, `reservations`.`LastUpdate` DESC) AS CountTable
# [07-May-2025 12:23:36] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127957.html 167.99.142.201

set names utf8

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOvernights','LRoomsNum','LAdults','LEmptyBeds','LEmptyBedsPrice','LHolder','LName','LEGN','LLKPassport','LPhone','LEMail','LChildren12','LAccommodation','LTotal','LAccommodationPrice','LTotalAccommodationPrice','LAddOffers','LAddOffersPrice','LDiscount','LTotalDeposit','LTotalPrice') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-May-2025 12:23:39] /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
# [07-May-2025 12:23:40] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127957.html 167.99.142.201

set names utf8

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOvernights','LRoomsNum','LAdults','LEmptyBeds','LEmptyBedsPrice','LHolder','LName','LEGN','LLKPassport','LPhone','LEMail','LChildren12','LAccommodation','LTotal','LAccommodationPrice','LTotalAccommodationPrice','LAddOffers','LAddOffersPrice','LDiscount','LTotalDeposit','LTotalPrice') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-May-2025 12:24:31] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127957.html 167.99.142.201

set names utf8

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOvernights','LRoomsNum','LAdults','LEmptyBeds','LEmptyBedsPrice','LHolder','LName','LEGN','LLKPassport','LPhone','LEMail','LChildren12','LAccommodation','LTotal','LAccommodationPrice','LTotalAccommodationPrice','LAddOffers','LAddOffersPrice','LDiscount','LTotalDeposit','LTotalPrice') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-May-2025 12:25:10] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127957.html 167.99.142.201

set names utf8

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOvernights','LRoomsNum','LAdults','LEmptyBeds','LEmptyBedsPrice','LHolder','LName','LEGN','LLKPassport','LPhone','LEMail','LChildren12','LAccommodation','LTotal','LAccommodationPrice','LTotalAccommodationPrice','LAddOffers','LAddOffersPrice','LDiscount','LTotalDeposit','LTotalPrice') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-May-2025 12:27:21] /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
# [07-May-2025 12:27:21] /rapsody/root/bg/ajax/basket/qty.html?_=1746610042042 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [07-May-2025 12:30:28] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127957.html 167.99.142.201

set names utf8

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOvernights','LRoomsNum','LAdults','LEmptyBeds','LEmptyBedsPrice','LHolder','LName','LEGN','LLKPassport','LPhone','LEMail','LChildren12','LAccommodation','LTotal','LAccommodationPrice','LTotalAccommodationPrice','LAddOffers','LAddOffersPrice','LDiscount','LTotalDeposit','LTotalPrice') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-May-2025 15:24:16] /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
# [07-May-2025 15:24:18] /rapsody/root/bg/ajax/basket/qty.html?_=1746620658274 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '2d9f8cb077987a55b76223675306286dbbb1e673830965050042d329c03b6da0'
            LIMIT 1
# [07-May-2025 15:24:19] /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
# [07-May-2025 15:24:20] /rapsody/root/bg/ajax/basket/qty.html?_=1746620660790 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '66634313890fda2d633c5d1d8d494e0d898ff4183e3fc906c2c7e37bc0905308'
            LIMIT 1
# [07-May-2025 15:24:45] /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
# [07-May-2025 15:24:54] /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
# [07-May-2025 15:25:06] /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
# [07-May-2025 15:25:06] /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
# [07-May-2025 15:25:07] /rapsody/root/bg/ajax/basket/qty.html?_=1746620707415 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '73e7b58db78e4abf22806d1f2c2ac5e0f59e2cf1a9b74f9de5ab184bd6b11959'
            LIMIT 1
# [07-May-2025 15:25:42] /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
# [07-May-2025 16:12:33] /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
# [07-May-2025 16:12:34] /rapsody/root/bg/ajax/basket/qty.html?_=1746623553999 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [07-May-2025 16:12:35] /rapsody/root/bg/ajax/reservations/offers.html?_=1746623555318 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
# [07-May-2025 16:12:36] /rapsody/root/bg/ajax/reservations/accommodation/oid_254.html?_=1746623556449 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-07 16:12:36', `LastUpdate` = '2025-05-07 16:12:36', `OfferID` = '254', `ProgramID` = 0, `AccommodationID` = 0, `Data` = 'wh0kDeo1iqEkkkrZw-KzRTIi5vFN0YUcbD0wfYLQ3qIXkLpqgmYFNT3tFrHYfcvCfe0eZAG12NKFLeCcTa2XgMEVKlnYc-2B7z6M8WES4dQX2oD03j-PZrkkjX-2ajrysr05HpGh0SZPeUpYrdfb1HT0h96VfRy8OIyoyFdYvL7zUyRUj7zccIEZNuVtpCt1ecmQ1Inx8JngmqzUmO_7vLprSsI7m5jQuTBiknfYdNXVDR_3wonmTCU3QXgzDDMPCxpp-Avp-vl-GdA7plc_9oC6vRGcz7dDRMboR0k4H4VjyDKqJ9ErBGUP_Z3vP7Npo6BLmXj0-_WQjbBF5O0zblCOAoyDXH1oMDIhlgZiQjX9PpGZpYaVZqY6IqSG_puSenBolLMwSAhFSBqt-LTVbuEPhNxNdI17fMzlYRDxUos', `Progress` = 1

SELECT * FROM `reservations` WHERE `ID` = 1127958 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
# [07-May-2025 16:12:39] /rapsody/root/bg/ajax/reservations/rooms/pid_1457/aid_795.html?_=1746623559503 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
# [07-May-2025 16:12:41] /rapsody/root/bg/ajax/rooms/empty-bed-price/23743.html?_=1746623561161 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
# [07-May-2025 16:12:42] /rapsody/root/bg/ajax/reservations/guests/1127958/progress_2.html?_=1746623562583 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` = 1127958 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-07 16:12:42', `ProgramID` = '1457', `AccommodationID` = '795', `Data` = '6gz8neOHzrPZQ6njsY7PGHZYrXzj--0uj_iG8loMQ6WMBOH-I75OZDIkT4_w-KwoTDwMkH2k2NXp4q9my9BqU_jaKW5XfuY04-Uhmb75yrXwYRCL8RI9YDh6j2OoVZ0574g1tInqmjLdkXJZKmL--e9PpuGnLVyqumcBWCjDmZMWrDfaWyJE-1SoI3daKlPw-x3CBmX9zPVYfze1aXAbKlKC8vKHsQ85dU5BJ_ktf_EPIJUWw5GXAYRxGrWODMs9FpTFdLdw7D-jRFfGKaGj1v2TEQ7R3vcr0rr9eEvG0HLPNr8FwRosiKr5-F4lM_h0FGHwMw00yHIrLrNX6kA7_bs9JfZ367EzHfdXVnFRAGkN3H3rw80Znl26YUtTDNv-TotIHK6JsK0W4mfFqD1gYQ_CnNHChUrQmxkylIjWVV4HaVI395kqgExnLJsJB5mDANL82Wm9WBqtLs1j23UrFDoyL579llvExpMpTLQcBeOrcklB8k7vKpP2h_-Sr5Zb5cdJZz7inCcfmz23F-YIE41WSwIzoNZKGbx-aW1B27jgXAN0OfTtCrlQR92Q0Ws0i3vhHp3a7JszJ9RUz2-R98HYhCPb5V2P80eBxLZrHMB5oE6sYcArK5exCOVea6hI4kJp3XFdEzFQHnitLoINl9BOirGCoqTH2paExKyizAu2Wf22suBj8nAEVYGrFy4o2RRej4AyI90hcm7sxu-SGPdfVaXPgvp6YJjp2lqucUMKSx1gP6aw2EwTMhbk5FNvJWx9PBpeXKWbtxLNFv3YdjAlkMglnXQvUu0eNzfWjeU', `Progress` = '2' WHERE `ID` = '1127958'

SELECT * FROM `reservations` WHERE `ID` = 1127958 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
# [07-May-2025 16:13:21] /rapsody/root/bg/ajax/reservations/additionaloffers/1127958/progress_3.html?_=1746623601215 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` = 1127958 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-07 16:13:21', `SentDate` = '2025-05-07', `Data` = 'uZBXuiYQIoky_pyERbJKMvCBXBv0BoNGT4LOzGkb4mLGD_rWzhZtAMcBoQrY2cFwrJjQ_sDyGEnOMH_GaP_cHHcNW-FOWi2tTxgh1drcATW14q-9YRcOERJc4ohgIWKsMEK9saIQs9wNNTmfI-T9ow3HUGAg1CDmicBdhPuYWgKlwGFJLoFnzH1c8gPUDWiCB39F8Dvsm_f3Dk527ymaK3z1Hqv1VDXkGMEDVgwqt3RoKFOLER_ok3GZ91YwIXZsNEZEHDxcemwJQxU3l8MIZ8iZ8q2-9DX9cEZl3TEJrPcr0Fxj2_63q3ThT8upUmqXCVQ7R2MdAnKoFZSuYV3Bj0XFWukVT-syV5Ctoiz1LPlU2ZAtFlZ-Nizm_aRvJCA148VCIaSodn7I_3drHgu_olmg17Tmlw-4aibRA44YyQxBDRl8gR_0nvCaOuymHQ9cr_dibQZXBTf7FpV7Ny8xEl4VwnIOPB5Sp7GTOtOf4JE-oOU7oeLMjZiYymBO3-cwrJy6pEbROSpSJ-_39yYV5cMmfh6gM5XBe7SLQi0BaxNP9_L_BSVu2w-Quqxcl2mCjHO5NwqFOYAwLxJt3U8HpTWpgFdTuWCNwOLjfBOi9qVM-7OL9ckIW25iQA_rv48vJLXd1iSZACeRpbX-xK2jDNdsBVEBI0AsfLH0c9a6IucSxCwyOl824qlsFdjALYrEggNuzVt5QA0MXqkziQqvNMgFZJu072B7uPp5JcAvmRy70L7dZ48RwLgu65ka63Jt7UjytWbJbjC0NyNq0WZfg_GvT3nYJrUjLP4JWw0UlcJSfGkj93H8WGwPtb7ccs-I9sK6jmEEgbMRmL9U05vEqgD6KX-Ojv3giECN89vyTZcNOcjVPfdNHhEYxm5QjVvNySdhnv6yPuwQWCPKEbhR6L_bCyDHzz2NKJHlHdTM7YxSC38jOC_YQHyNyex1KQhA_zSk270T-fTy7jR9V0NM3xpsik9xVbEOl1UiGyUpP8avPvASQgiGEATk5azKQLsy_YA1dFozHMjxOEP-4PG8RTHEpKyHXz3CcWqDpJbsa4ccxu9w3EdvJaUz1a_RFAaYErGr7VYtYV3DPuj6ihVQ3g37dQwtNr5TF6rmk88Zhqazojju5EiocktJ0HQdtoY5CpucfPcQL-8lqy16SfhaeB_2fNu4Slq4-_W55a8redaZ633bBzleosS7dgQYGSUmXFs3eGIOgdy6a43ObxjborBbQpOJ0aIaHjfJWLJUSfvtv68Ap2zD4DS6azX5ovefRxz2POOMaPqw3MHCdLBFal7G_9Ku8WSNjRJhagYOGA5wf_NXLvhJ27FsoFNBdi6_8fOk6Po_DYnDF7WIlo7r82aveQugGANzb1vSlKmX_qjKpEfAgQv3QQeRb-1OsMIvfEyt8IB0If80FCUQ_yhtcBlrSWvV2cG0WiQA9gG5hE64WnfEuWESbSO608GNjpjqDglU0ZAVp2ykdJJ8dECYgUXjl7Pqoa7leL3sm4ZztzkOsLiz12KHshNSz35swm1mn1mum0jQ6OeSfeSdj7py-0e6JzBsAUGyqZNWIx9YZexxjlTaIGeYR8jVPQPdq1_IwgYh8T1PqdNsnEl5nRqbRNLwe0wOQxxA3St6FyKQ5uXqNsj5RqWsqpPTXIIflN_tjYOrjmXDAyYjRKPygbRYT_IB2Xig3_3qASYToFsc-CYuku8CLd6krmBngmdjw7b_esaVQUUyC_Fd-AZLeTx62A', `Progress` = '3' WHERE `ID` = '1127958'

SELECT * FROM `reservations` WHERE `ID` = 1127958 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
# [07-May-2025 16:13:22] /rapsody/root/bg/ajax/reservations/summary/1127958/progress_4.html?_=1746623602949 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127958 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-07 16:13:22', `SentDate` = '2025-05-07', `Data` = '5OaPdd6DFO5Wt_RI9lidZ3PWN4MYbvB0jdEJnowMLvKuoWAvrHC2B7HGiAphzcJOAHqHkZELuC-9SdGr5eXqxdA2swO0svTDBBfzgI9qsywMHWsu4GJH6oOfKB_PWY9xh1HE6VzWxjA_S8yPr76QtoTOTUfyKez5y_u27cm8Un0B0XvtaGYKIwW8yqaWIn4qJ8RM21oLvgOwlgA-tuQ8ClBwFd4AuxCW4dn8KObzERHvMkilpFc32lzrYGKRgPigBAa2Z-dZHJaOrCN1r_8wDYHDcy9s2lw8QW1skfWzz0j4-DR6QBrAzgjN4wE4FFSFhBHZcLNUD1iYUtCtqCow-N42HKS3YWVX-oHQoG8L-LxdgmruTMyFpbE1TOpuhcIBCSmhuS4ZVCPGVaTxuJjclrmEiFCRshO-3ichqedw2_hSPyqq-varfa_cAMPi0uolueaN7gLaqdvYKw2dl1X8vPd5-01LfWlviAoBwQgNLUuHVC9BZYHVxHbLp2hLJwRVz8VMVtFlbeqUlOU5wyV5MrVF9KV_3FtzTM7O_iXKRRLF9cGN8Y22CQkESRh8kikZXdAyrglc3aszmBVg1nCs63zKpEKKECtkaujof-MFfOSi1sA8gziJuPgh_7_VQE02qIoPWhhdB4Oa29CRPqmadRrM5Q0TsmwyGVrm5Zz4ePDNAURQTkUyNk5DNltRvx-rg_Yt7Ut7kmGXO3OYYmMOOvC9mpSwlUTW3mnqrXQXr-WZcng9u4rqBmBtkvbR76f-ZemuxXBQrd5Ba7iPNoBC2PUvvwlqeZEVsSVAJLYlFrIIHmJeReRV2xz1ap9Yxr88nnp-dX4sFUz9MVYvfJ2Y45P_XhM_D5orlRzgs94F7lvdjcRwvj6ljWCP7iTaN81bXJrQkmTKT4oJhXMU3NfCgBNu0CzvarsiBN4-R1VX-J_uwIU8hCCGOc3GpEkAQPsKFwTkXugv1OTiA7Tr_NINyeDDaQnNDySayLjTrtLbJDHzN1SwsC7bedQU36MZTn4Ckk6aDMuza-QhH6N4pCuVtYEx_nxOp0hVqv9tJw2D2VgY6c-E909F6cb7diARBabiAmeiCwQJKxJ6nxYKLd-Be81--geWs3AWd8xso2qP8LCPqzVWrGXr9z8ZyOBuWB4HS9a0jxaStDRJNAaa7BquSUS5FOquBpmlpjQNkaJKe2a8dO9ZLn5xdCXZyUo1WiyXso_vUefhtTMVKIAtG9kJRrxEevfYeKekecs6tWtyaNQxybMYQMgVxkNKjXyfRoAE9HaJHvGQXdgSfQ23DAIzCiuCzIsUKYWiI_uICS93w7Irdlwp8vMgkUsviJTSY2qlVKwlL_2dng_FwLJ4weS5oTPrahqQ0Qa1zD0UAh-KILJ0lc8jzOdW5q-Lm8jrp0j3p-bG0XUDE_mYkfa1sm7_LG3E0hdRLs-LbSlQMwDg7TlBTp46mNHUSjZWkGa5nsOX1r19tNjLWjeNScijzuNKuK_XLK4DuJz6d7zArG3gcNTqDsaRXBZu1FTq9srcsieVyEULspv9zYdHylnGKalDtE4kk8cMNsE5wL3rQg79Z-SZb4WM-Xo_ZGKdnFIcL588A74SbfSU1NT-rg-o_8wGS31WOql_Fe-cTOnNbvq21QfGPWWymxqBY5EgzdTvFN2QDa9x_T6ST1JeDpHpQMc4obo0AyuxOn1pkR8itRvCkHxaZpnl5hJofhsLqwZt1v4JNkeukoeI2j-nzyihcxvikMicWXVQEfhTB_QzbKg9ybGXaNQ9fSl1GnjrbV5_8VA0_Jx74868DTHwfDDvnW9Z6BUifMTv9g1C6gHippCKGsr_3GwcItiPkh9CUhtHzko4', `Progress` = '4' WHERE `ID` = '1127958'

SELECT * FROM `reservations` WHERE `ID` = 1127958 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` = 1127958 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` = 1127958
            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` = 1127958 AND `Status` = 0 LIMIT 1
# [07-May-2025 16:13:28] /rapsody/root/bg/ajax/reservations/confirm/1127958/progress_5.html?_=1746623608246 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127958 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` = 1127958 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-07 16:13:28', `SentDate` = '2025-05-07', `Keywords` = 'Y2FyZAdGVzdAZGF2YXJza2lnbWlhaWxjb20', `Data` = 'LSMv3_JOjTZGalhxfbt-A5xCIp8RAJQBvp5mEbEntCEv1p--0IUpk2-4ksfzXyP2QWYA1aAW5DZrY23fe7Hj23NhSPkhwuU4Qo98WVcfIf0ATH0QVecvFmpWQwC1dD_nzfbs-WJoyZWXWPAWWyiGHLF-64HN1CJ7wvU8UPd29qMdV0O7mJqETkYxRHOI5RqbCg4GuEOLdO4xkHCGFqN2o1eNv_2CjE0mxR8bhqWhE-Wn5nAQzidmHFxNMIjU591tn9sPkvrOQJWAJasr3ZcCY91eqxHQkC3Vnm7CgnytLYj5uNzVjnLCaGZH1WFSy5gfgCimOIkrMpdueMk_N_YorPh9dWIuzpXAgIWNk4CVPeYpmKNRsy-TbdiZbvCBHWc8Utg3kiJ-bBUHLkdnt0UpseLmQZOKkb3ufg-od50Co_0B1J-giaMamm-F0LZ6MfdGPJxvlSbaTXjtFFUVJPlUxG2PbMA4j_q1RFH98QQ2s4w8KGTB67NMYYDMJ5nO9vfX0LamgFzqKn9PySVYe5FNlfYNkOD5eoWJ5RRSxEluJomv8L9JUiLZbJ3SplWX_NACKP2bXl5w65GtnnxA5M2K36C1JlBMb95SZa4pZ-bRgyLqtT0YZt21kE_MKwepulMd1RIbaVAKZwi6ByLfMdivvWl6D80Ylx8bDEvMsgGhXPZw-9n8iiuB0LSWAlb0vodntcSgjTwfjWKj1zhExCmokPS2pEx0WWr8tVMsNwU2F1mhqte0pwcSFweanoIaD9RD7UZNN1QrrHc8HmlaQ_coUX_oFxfWimWFWd7lNw9HhVNvW5fhiebl6rhVVTSWyfbY-3_IOOY2LGr79-ghEbvg6BrwK_THK8tkMGFRAGxQ12lTLbJMYAi9KpgClg0QjgVFNMRSgrJom7r9chKD2hAi9Pey_70beQvAMmRTbfD_qpwiIk-AyWrpi7AxRI3skxSEVZjm6o98_BHCFyNbpecAHnMBptD44OGeop9wWKsVPldov4MFAcNTEpl8r04oyr-JHtfxgDu-rWOozO2nI0Z818oOzJ6uWtlfUgtPFizs7ocb4vRzEUKYeU_z8asbjWt3E_5KX-3-9T3jTeL1kJa4VrARHJuM_ldIw1MdcJRQVdx82AJTW2JFxasolN_Em6QqR7uyv9ZHI0Xu8kha1w1vM7LvNDaZdLLvvmhKrcmZVN1g-XG8UWFTEX_hCrS-ZHU7GBf2P0FkDwywSGtfwH4MVLWPNf5mfbEdYiGG1E3QEjFfxUVeYmuARwtS4hNaXcMGzpmvKHctIau1RVlFa9xOGmjL2jfLuLX3eG-Gm9KIbXk4TmzSMd7Wdyz3y301m9z2KPR7IdOgAc1MnzeXXwzs6LqPlyOx6Uczf3gDhV9UPDU-yYJohswDeeoUigp0R007hH7wwCSyldGFzwhMi0sSsNrH_0qb5fqil4E-0xfK3LFffnZjcdAm2sOT1y98TIDlmzS4YKvwg_cmSEgHI43dgFLQn2rmJkgb8AmpmRucvjubLgbmMUq3goXOItStzUIYkYLFZiJ8yXBdwXFhRu5C35QaBexI4YxIs7T6gEwMTbS-pNM9p6sWcWURdU058ChOnX_BwEM7Dh98Z3CmOByl3BfeM5OiEgiKus22sBZF0DXgpPhXL7weJy1S3LWxAh1vSh2r-27UNqa_5gs_UqgKRe6kqBKO5M84uMPF7rCM-CO-zmv1OGlRMpD6vMmm_EedwbODdJIzqrCkcFnL4VzhIhPDZAyzn44jAf5cbqRh5XLhbtVSMpwXUc4qCDj4UjK-BSB-F2YWBVQaIGbIS6LSh57d5Bp_RmA0ERZILmxyn3TsFPmoFKZkBVVnOHZEgSJiXXvXnMubF8-3vzlDMSj7HSjU1EYFAVuZJeSfGQfRDZJ73gyk4YbAOL3VVDNV_k_vadS9V4or-5Slz-WGi3vTyzcqn1FctpVuaJx9X0sCl-24pJeEbLQrl-w0eB2Im86XjnQb--no4wSbftzAODsq3YFxPBT3HksEjfnIGY6KOKXR0CFgAvSHDo1LIboVie-h', `Progress` = '5' WHERE `ID` = '1127958'

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

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 1127958
                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', 1127958, '', 391.17)
# [07-May-2025 16:15:26] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

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

UPDATE
                                `borica`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"ACTION":"3","RC":"-19","STATUSMSG":"Authentication failed. The error has occurred on ACS or Directory Server","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"391.17","CURRENCY":"BGN","ORDER":"001008","LANG":"","TIMESTAMP":"20250507131526","TRAN_DATE":"","APPROVAL":"","RRN":"","INT_REF":"","PARES_STATUS":"","AUTH_STEP_RES":"","CARDHOLDERINFO":"","ECI":"","CARD":"5100XXXXXXXX0022","CARD_BRAND":"MCC","NONCE":"A5A6099220FEC3ED6179BD649A83CD7A","P_SIGN":"376DF95E6289DE24B4D156134A7D10007F0E63460C1EF49E9DABA3807A8478C88287628707D57937B56C80EC9FF6ACECB8CAFD124F6BCBCB8B4102B7D5CAAA1CF16CFE56DA8CF754656347A490E15E8F6D1078E400E3C07DD0BB32AA1E6CF76BA19969625BFB3F24EAF359EA2E14B5C1669CC6A691AA25AB113C1827B9AAD90513E358AB611941EAECB659EA30EB08C63E3CF3980D8A2D3487E04767570C51C0BBA5322C4428071B7BE2DFFAEE3657D9B6CD330BB8DB493D9A604FA74F4173F386C1D7058D7F4A78C59793D21DE645CF44C60EF5A8BD3B63E25A6A3C09E5F97B3415B5ECF113CB332BD02D0E7823CDE3E11361661B2D003B6625A2CC9D48B757"}',
                                `ResponseCode` = '{"ACTION":"3","RC":"-19","STATUSMSG":"Authentication failed. The error has occurred on ACS or Directory Server","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"391.17","CURRENCY":"BGN","ORDER":"001008","LANG":"","TIMESTAMP":"20250507131526","TRAN_DATE":"","APPROVAL":"","RRN":"","INT_REF":"","PARES_STATUS":"","AUTH_STEP_RES":"","CARDHOLDERINFO":"","ECI":"","CARD":"5100XXXXXXXX0022","CARD_BRAND":"MCC","NONCE":"A5A6099220FEC3ED6179BD649A83CD7A","P_SIGN":"376DF95E6289DE24B4D156134A7D10007F0E63460C1EF49E9DABA3807A8478C88287628707D57937B56C80EC9FF6ACECB8CAFD124F6BCBCB8B4102B7D5CAAA1CF16CFE56DA8CF754656347A490E15E8F6D1078E400E3C07DD0BB32AA1E6CF76BA19969625BFB3F24EAF359EA2E14B5C1669CC6A691AA25AB113C1827B9AAD90513E358AB611941EAECB659EA30EB08C63E3CF3980D8A2D3487E04767570C51C0BBA5322C4428071B7BE2DFFAEE3657D9B6CD330BB8DB493D9A604FA74F4173F386C1D7058D7F4A78C59793D21DE645CF44C60EF5A8BD3B63E25A6A3C09E5F97B3415B5ECF113CB332BD02D0E7823CDE3E11361661B2D003B6625A2CC9D48B757"}'Code
                            WHERE
                                `ID` = 1008
                            LIMIT 1
# [07-May-2025 16:15:26] /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
# [07-May-2025 16:15:26] /rapsody/root/bg/ajax/basket/qty.html?_=1746623726600 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [07-May-2025 16:18:50] /rapsody/root/bg/ajax/reservations/offers.html?_=1746623930246 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
# [07-May-2025 16:18:51] /rapsody/root/bg/ajax/reservations/accommodation/oid_254.html?_=1746623931164 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-07 16:18:51', `LastUpdate` = '2025-05-07 16:18:51', `OfferID` = '254', `ProgramID` = 0, `AccommodationID` = 0, `Data` = 'DgH8dj-xaW4EGNqN8KmP0__FDm37DW47T5j5R6UgfAdlLqHqd8ejQ-C14tL6guAC9x3ZhTg44XemiLvq1yWh5dTdtD-UZ9ayeLC4Tg1789-ZKgpV4VCBIBDHKvqer9eShvgCvrm8U75hiOBN1larozNaHf5htmPJZhRa1LOvcJQYd_IWauIedmpNpAwwe1DqWmTCSeI2sPqxEprI3faq3I0oJ196aq4Q13EwD90_xBLBHWExfFc6EfwpcC2wCFzzX5wPtLY_95k764awH5wJ3v9Fd_DNlHV_0yRryAxOykQdm_pq9sV8Sd0hw4gjgMHlwktJ-vFiRS7IQjkqjlreB4-E-F0QUG8K_BgBT-1H7qX1gLJuRhVAEwMQx2XBWgCiBixfER3fqPwfGZwO80viU_ZVtTs08uR1EuoHrSPTDRw', `Progress` = 1

SELECT * FROM `reservations` WHERE `ID` = 1127959 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
# [07-May-2025 16:18:53] /rapsody/root/bg/ajax/reservations/rooms/pid_1457/aid_795.html?_=1746623933252 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
# [07-May-2025 16:18:55] /rapsody/root/bg/ajax/rooms/empty-bed-price/23743.html?_=1746623935379 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
# [07-May-2025 16:18:56] /rapsody/root/bg/ajax/reservations/guests/1127959/progress_2.html?_=1746623936909 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` = 1127959 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-07 16:18:56', `ProgramID` = '1457', `AccommodationID` = '795', `Data` = 'zsUo4MAQZx6hsk_oVdhTfTrCX4njWUvLNXWRh_Atf6BH_fT0NGHZNKAqGc4DixdUtKwQdQzrEjoXaduf9e9mWQfQRX1gBKvl5InOw-GJ9Jm8ICJiV0CZvBXyH9YXPeTFf_THK3mt9fvpx6BRxZ7Wk9RwWrNFa4r-JVPjk3irXD9a5HNGWM_qVa6GFpgkO9UYLAQ9qqngYIKoSDmxZKBo5LgrvJc00_J-WQIRSHdeDi2-4-X9TGAtF-ySGzlAI61ay0K6ZV-QIlxZGM7Uh7b_l5cE5iVVibrop0uE9E7y02EfWWc_8iHuQ7roxMJ65phhNBsbC6_oIxHdNHPYhO4ofSL1z-EXz9X8HsY_U4HVZB2Q3k0huDayW_zD-0ouRNnO0W6JANHI7BtRi_hgE-lMA6OSjOShTbxKnT5uprD-z4CUoD5UH6WRMn1jyX3dkELks9eBC60QBnfjm1GXtRg77utndCk5C6EVAndjMLet0YGNS1ZJaBAcCUqimFBoOL15Q2EvGKK09d0HQv5uJXF5RnKnVqA63pgaO8M-2SOo0lDiJO1l8Pp_dCowtuwYFtIKDUUNU1EKwQm5U_1gg8NLQK6rhNuiKFsd_p_W-VPaWE6dnqPUzg-S_kfO8__A2ddBzd_ncCWR0yMKltqkIaO_8x4_8vqECfWNeO56LcdwbtackP02gBpghaNtM56hIbD9a3MCrnz1kJ2xaPkbK8LY7vIW5SrT0-sSzGbjzB8Qmod9ZehtQ9qqGj_IFK4lXneZp1zZ-7MnzpiG9iDx76HYb-n58V_MpEvndJQ3gkd0T8o', `Progress` = '2' WHERE `ID` = '1127959'

SELECT * FROM `reservations` WHERE `ID` = 1127959 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
# [07-May-2025 16:19:20] /rapsody/root/bg/ajax/reservations/additionaloffers/1127959/progress_3.html?_=1746623960398 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` = 1127959 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-07 16:19:20', `SentDate` = '2025-05-07', `Data` = 'xl59GKqbkY51y9yqE4p0t71LRwMrDm2ROMBdt_KpkJqz6DuIDp8aTuxTRmKecBGeo91ACsYmKqTlrFGduVghhrOuzMe2LHe9L9LUc-XsS-Yg4f1lZlSJhuFjtpelMYeux1kyOyzbl7N9mTsYare_MSTelgyHSsGcxD5ew7pKA6jwjb8t34TT9YJehwyn7XM80kFG1yInBmB7y9bq8zj-UgI04mNHGEyyUb5xV66CQz--QONyA7VJWLYVXg_gWDpsBnYcWQ7UN0TdC0U7pq_tPGUwQKOsICT6afF84Nfj5zgiGhUfgUsIwQb9ekQtKbVsiMxxTLtwNgyHetADYQudMLNU0F1DzVzpgubbtaJJxCDSeiqSMSE6MPHYvaD4CEzGWqxG0TYkCvulpYWq9Hjt9G-aWUXgWMaSGKEX3CP3lZj4wKsnvEUtm8RR66GonEzR9TPYPe0sWgfUaIma9oHMHV7i61n_fssaeiVXmxxuC6SOLbhMwR5lAY26jEELdIXOSelJii3m6xH1FQmm2P4mSrgbeRRGFPEADVPwHqTA2xLCkyzfgyZK-GFhWfyWx9O1nBCoacwAluOtOXhTbiiN3tVnTpvRdPPyW18eEulNblElGvHdj4BbF_XMH58rGEIUSEzOaJVKFbC5X6LYw0YqHHJ7f3osCg3unHEFaUeTLkhromm1IesfQpMRdGdmUXQlPwvMtb9Rr1aOTFTWogduU5eSfxlZT1MoF5r28mTsdWaoWD2_oGgslCtqCdv5aVLSTsbI7UnY6sw2SCl3Ngtf-IvqWSdUvtb-_JCMb7eJqJlO85LoZ3rJfVwQhduSWAgULOQd6hxKqlNbi9YL7X7Bg74lvSjn3VOeSAEKpVkmDcOMQD6R6V2N-g90MIzcvgtDP1pMUhW8eRDba7zlVt4QwQRAdKSRopTNWcxUonboVVmllyzkxh0s0XytfaxniBTtDSfinYrHiW816ErVNDmTYnxSVaWjL4gvt7Ih297lBet7RNAE6cRFeMxU0uY_AJCbUPfIDU96hG54Yncp5ltawuNl4Y7qPy8X2q00wgntDIvbjb7oFXC3ZTUsmbqgRygaIMpIXNKajDtxA16XBcY8xMtrNXgCqxa-gRhOlaEFH3ARnLQktUYRiYV1YxDDh3q7SDoTgWBWY8l93aEI7nZTKDfrxOoLI4sIvfRwHNENjezIw3VZHaTCH9qWmMoqd-whQstXU8rEpIkO6F5huYmdl3ZZCMEFQm70fykyzd29_o98sAUuB3QJZIs5EeiYUX3CXmEk_ucykge9qG6huLpSmhVLsakAFQzEavQ63JBcBLsaxK2SA-gb5mqaCxMEdGIaYOxxUUq54A2Av715YB4EV2J9f_sbr-uMEtk4_ISshVyunkhYWoqrQj8cmy75YsLoLrCug9pgm8ucEwdAhI_mroNlfyUoNw374enZqfbvbFzIUVoqGMSTw47brYIfMXOQ8m-fbHFOJ3TYJURU4-I7rBI387B7V9ukuyMwY0ZqA_PLy47Y-zeumKCY8RP527ZLNx4sgG8Pehr_HwgenmQrME9-KichilLiGTe_upL1IKObXeqOTFrmmmPaOWMp3SQKu_IjFn1YoXxptZXOIbGXM0Bm5hlBCC1Lk1CQWZf9tdqsdy3pbvzCbX31LA-XP_H9fw6ZKl1kdlTDEUqcUxBlhYyZhogsRRH_55--4Ou-LMu4b-0Wrq5ym7D3C_fYIRRUYK_J5rvXl_KsjYnLfc-YDw', `Progress` = '3' WHERE `ID` = '1127959'

SELECT * FROM `reservations` WHERE `ID` = 1127959 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
# [07-May-2025 16:19:22] /rapsody/root/bg/ajax/reservations/summary/1127959/progress_4.html?_=1746623961948 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127959 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-07 16:19:22', `SentDate` = '2025-05-07', `Data` = 'nnVM6rAMC6GCpblDmHdave2c0pKf5tO4BpULhzyZ_Mmzv2unCZrnq7sC8C_RXG_CwY0Ty9Rx2onIX3CowjsV1piZe8uEjMoeqLFVuWihA0dideKjXqVZzyDC8CxwxYOsWBhWMwJiDP9zQnlhkQZKw_ZDz9cgp7095Wg_j-XEfk7SJx3qTdpTtg7_svL88ZdZ37Cfuayb2PVInRe2Lzeq8LJVtdKPHWLl0YdTBvQhJWLXn0bkBOdmRIqXMUU56K9Po7Urp4qnoZO1ijr-raJIsqwjKVaG43h-aACzJnZ6RB1ihgxbdABxs2x7yMszUxygnTSf_aGXB6KRmwH-r37CsclcElc5ArDaeRjb3qZUhcDxA3X_dWY5H75RwlP8hOP1umzfKfYuXQNpsI-NieoIOUBo6r6VxrB6VSkDAVVD_7zuYnM5mRqa0jLlCK1P4nel5lfmOc15eQqCRLyTcc5Z2YIrYj5iLcz5LiS6uiUYLcLvU5RyGwkw64mBcC6uFRGo72chlrZKd4CLj98sidl87WoR3tlwFZ2MvXCI8i5jyRSmxsv4fTycqsKOz2vVDBydMDjTnk-dvRwdIh2tAkY_KgdRcgUKHeqvUYvehII5gvw9Gxf8tlNyG1O-gkJYm2W4CpvlfTcuECe9Et95KHmei2c74lE33WXE6mxnIDWdxKhauXF0euyBdbOGDR4hz3i0X1mLwqLXy9oxkMb3r9RY1rOXQeatWSC6iptb_edd4eanaCnnvIgd3cG_HDBQ73OJI76YyqTEliNg3rs9CS-SqmlE1gv6pCwsUiT-tbldIrCS6f-6ZTggU2sL_meEjUeh0CByM6e6VyFbNAG_8m_mwTMImYrRPmnfxBATOLxYPCF-We_rbXmCgUhHV1JBU_0bVK1pXkymX4c7cxh0mtkTZ2I_ZEqxsEdpf_ANWUFqXz4t03rXOZQoGnEsQDXo3jawA3j3i0E6MkeHAXlowxwuuXabVO1gGoDqBVo18FXUeMi9d2RjHo3fG7x212AJTyTwU-KActzM-zN6T_XwUXdnODHL9RPD51uhY5ihgMYt3p04vj4lIbPdmGc9vND3Z_iK94sUXtqxUnN2_qk0_hGEO6vVBrZ_IqjS17K-OH4IfRSPblCvxfSinuXYNU96Ndz0hwH4NpYXhaGalg5tmVQCC2Xyo6VVH10ezkFsGWM9D7uZ14po9jF4YxwL6LLyoG-7OgOFiWz_vx2xqL-tFQfO9fZZ46D5mAxMNvaCyM88TDc7Ln7INYA4DT1zhSGKDZ6M0xYazOQZGmLrodjs_WwB2CrNVeTwup4KVUC9BGZjO4mL3RgNbkAp6Q1e2FJrw539v7jaG1mYm92kqq9mqG5qAetGDA9cwNY450FHYJK30O8aeY-S9wPg1PqY8c_I76w8SYeA4MT4M1kxQ3nOKFNGPkut9my2sGtWLDVfalfgDUtFiGH4dPxJQzWTsbhLt3-ACXRHxbV3tbr421xP_Z3_mI9xnrS8HjE61ANmRBIwQGw36YCaAmaB8zYJFiRg2xv9AnvWygzGauWaZrq8ZCsH1zd92Get1lZhOYkA8PQVgwQy496uhFs6pD567zQwuuXhRSxSqSFgbsNNMw1ynwpw3fQqLNHxrNGqBJ4pkfT7_uigOy_ltm9SpqbUJpmZ5HaQKRaf-mnS75q_XE2F559zsXjhTNa11pwUJxBIBfzott2eUp4A641X4x3LIQJSrK0Xv2hSO7OwYVR0c-SzarV__xoAEgRh6IKZvp5xSg7_1CDoqA1yDCFRi_uUD-InrYL0OV40DntpZJ6KiYbyw0hf4-V1ZfuGJkpKswmoPiGCqbG-tK6AT8D_yCh3GwXvcayA', `Progress` = '4' WHERE `ID` = '1127959'

SELECT * FROM `reservations` WHERE `ID` = 1127959 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` = 1127959 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` = 1127959
            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` = 1127959 AND `Status` = 0 LIMIT 1
# [07-May-2025 16:19:26] /rapsody/root/bg/ajax/reservations/confirm/1127959/progress_5.html?_=1746623966028 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127959 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` = 1127959 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-07 16:19:26', `SentDate` = '2025-05-07', `Keywords` = 'Y2FyZAdGVzdAZGF2YXJza2lnbWlhbGNvbQ', `Data` = '2FHZspm8bR0qX193DiaAQxax6GQQCMRncE9_QNom4pne5ZomV-JbKG62MBq07Kqp9ZX37QFA00CH7NEEjQExnUwReuW0bWrbdXjzgra3g9OHRkHC9OIDcczYdSYWurLuWgILY0IyjC52z7O_C-6iDj1xviJQowfRdOo9eyXzATf2ucdqIfx7iYF2ZOdnnD-Fo4piYn-Rmbi8oKkO_U9yxETjLJEQ6bfyoOrNfOTY8z4vvAv5-E9wzKb9kABOheG-6dS_NRuL2IJCLnKI1znOS8gIpZxsUgZX6VdWy6V8tvcLH7EJ8vk3Oze4h_GfTTOiEuF5attJW4ttl3agOkyBu8CsIeBqleIhkJmEvFJu6xiniwKNSYoNIxZ_xD3pUiL5nWsr_fgWJqgyGpLaoYt5hkt4D9e3h8ld9pVX7ne9lkL4Lgst4bZPz9Ki-W2Wk8Ky1tm29ymhRzXWTFTzW2pZZ2CvkcaMGrjRMRm2Eu-7IhL-JwX4SgJOHe06Ahkbv77uSg0tuprzWHQAqQc0r0-5SyDjKwyQlFSRVjRhqcvVj2B_f6M8oO3VkYWI8e141FLwPUnjQSdxMdYzjhQETx0g2EbIJZUHOD-wps3K-KJC5PPI3lg06k-qzEsEcCZVw8vch6UeKtf8rtSq0-OTBqLs_9f-g52tbnW4WaWKyW2JBey4XmaGBG8J2287Sy83sVm5D0ARyK4AueIz_gTBm5eNsoeJqCDZk8RhQUw7Jmwc7d99J3uNoB7PexuErHmroTTV8fsmjXRx5tthpgDTUhy8fZyPAri1XrOzoB5VUaI2k6X2AelaKpNF78sZMZqJ9Q_zc948RYHjdxbsQHJrGHdfbBkLkqlSvNqhXDj6uT4dvUBZ78yVt0QL7C21YhTVnlFHIx-j7F8N-2d2trDMewz-8Sma3CBXwJDtfifrlJm8VhfE7KKQ7Cu_jhxOaRIdQ22AcoQ4uc9rZhZYWRyzPF8_0xssg0-IElswBhoTXYy_jx7GU192dfuyW-kttydrdBsUZiTUPqCvhKN22Dx2GShdFMy-ORSSHQWReDQk3bZRZZeAH6OboAiaMhGUDCsMmT9yZWKKOsez2_V53obxMkPKyoKstIDEMuiDFCIJDtIBc5CycOiTJXN7l51VTIxeoGCkUFQbDqP-7KoO11tFisDbK63N4uNYu9ONF0zaTLE_FIaX50_33DL1kwfqG0jhSqR9_nFPszyumAZXe79N6MWUshiNT1JYAWQ2x2a8JF48fDP_cV-54aLcOgl9I61LFUmiy7sCBYQgC2tynEcqN4nW4bdOlXxQjQNpWf2o5ZRw-yxtwT_FEtIHgkEPSMR83UiXzvo7kPY3uV1Iu47ak4xSllLu8NUwJMq75GJyH0jALB_McMttHuqdytULrbbQsv4SB7pPXFVqmjTRkAxP_73u6e2Ji5UBapyVt7yelj3jbFsFUa7TbYP0jEqENofseCiE-7rv7NC4V-kRY1kqKz4jfdEmco6WCoER45jS6cgBzTj6DKGCcBnSK4ukkcGDMbPfTkGYkUedS0soUh8wzg6Ntz3BbCydW8ZbIIY4bGfDMiz6-4rYChoHLvBCqz2Y2fm803-1BjSxkR5KCnYIe8mI7N7t0Tcyf6XBHItAUOKDhert4cpAa017F3gKg7xoFBp_AB9Ez2vDthmk8CkMjJn-FP3QJDCcxsxnJ6o_kpUbJ_vHfV3yDF8FHagiEpXF3LgkENHH2bo4mom07B0VnFrnihGGgFDLxymT54DkqN2hNSeczRPC0zppkIp02UHbnnAyfE9yZkAuwuwdJAOYwFVIteenySnKSUkmURaLgF9yNkPsY6YL2KiaowPoihWx0GlcVXQXG_VsDA-98yAmIZhCiKo_ic3-M-K4k6GhmeWSQO9SFaCLcv7rGpj514Syu_ozkpwAST5oEIjFXT4lGIJadmxItcA98hC3_900SxhpdemjLsShAhFugLAX_m6bOS5Gkm7pDgExjC9yZ0b4ghNIxCZHid0x3hzuDm-nS1YKmmzMABFV5YhDogFxU7tVBZqd', `Progress` = '5' WHERE `ID` = '1127959'

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

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 1127959
                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', 1127959, '', 391.17)
# [07-May-2025 16:20:08] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

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

UPDATE
                                `borica`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"ACTION":"3","RC":"-19","STATUSMSG":"Authentication failed. The error has occurred on ACS or Directory Server","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"391.17","CURRENCY":"BGN","ORDER":"001009","LANG":"","TIMESTAMP":"20250507132008","TRAN_DATE":"","APPROVAL":"","RRN":"","INT_REF":"","PARES_STATUS":"","AUTH_STEP_RES":"","CARDHOLDERINFO":"","ECI":"","CARD":"5100XXXXXXXX0022","CARD_BRAND":"MCC","NONCE":"763FF0194220E6CCD181C9C6F4C2A8EA","P_SIGN":"73179E7125CE6A64A119B9DDEB134033D7DBF64695BB525C4EFB89A60D93C257CC0F68BAF84FA09646C8033670474779169213E4ACDD8C976DD67D184E271487DB4A8497407493EBA71298BF05E5F022A45C549E69477C29CB428AC20AD8DAE5EB6C1B5DC011E7494154460E782AABB4D478B1EE0C00B1088B2860F76FC9E6748AB77A8455314CDF46C4D676D7C56287FA70628BD3B6665C1B01272298AF06AC7EFB2C9AFE17B13DEA24369EF387484C0B8B2167E22104F110265EDC4738B9C2DDFF16019418AF1148CB8A45652F6FE23DCA650DA4DC2B81AFF5336FB463FF488FD1CD3B3A0D71FAFCF9B760C831935EE8F2EDA4A8C8109A081D2F866EC143F9"}',
                                `ResponseCode` = '{"ACTION":"3","RC":"-19","STATUSMSG":"Authentication failed. The error has occurred on ACS or Directory Server","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"391.17","CURRENCY":"BGN","ORDER":"001009","LANG":"","TIMESTAMP":"20250507132008","TRAN_DATE":"","APPROVAL":"","RRN":"","INT_REF":"","PARES_STATUS":"","AUTH_STEP_RES":"","CARDHOLDERINFO":"","ECI":"","CARD":"5100XXXXXXXX0022","CARD_BRAND":"MCC","NONCE":"763FF0194220E6CCD181C9C6F4C2A8EA","P_SIGN":"73179E7125CE6A64A119B9DDEB134033D7DBF64695BB525C4EFB89A60D93C257CC0F68BAF84FA09646C8033670474779169213E4ACDD8C976DD67D184E271487DB4A8497407493EBA71298BF05E5F022A45C549E69477C29CB428AC20AD8DAE5EB6C1B5DC011E7494154460E782AABB4D478B1EE0C00B1088B2860F76FC9E6748AB77A8455314CDF46C4D676D7C56287FA70628BD3B6665C1B01272298AF06AC7EFB2C9AFE17B13DEA24369EF387484C0B8B2167E22104F110265EDC4738B9C2DDFF16019418AF1148CB8A45652F6FE23DCA650DA4DC2B81AFF5336FB463FF488FD1CD3B3A0D71FAFCF9B760C831935EE8F2EDA4A8C8109A081D2F866EC143F9"}'Code
                            WHERE
                                `ID` = 1009
                            LIMIT 1
# [07-May-2025 16:20:09] /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
# [07-May-2025 16:20:09] /rapsody/root/bg/ajax/basket/qty.html?_=1746624009210 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [07-May-2025 16:20:22] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

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

UPDATE
                                `borica`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"ACTION":"7","RC":"-19","STATUSMSG":"Authentication failed. The error has occurred on ACS or Directory Server","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"391.17","CURRENCY":"BGN","ORDER":"001009","LANG":"","TIMESTAMP":"20250507132022","TRAN_DATE":"","APPROVAL":"","RRN":"","INT_REF":"","PARES_STATUS":"","AUTH_STEP_RES":"","CARDHOLDERINFO":"","ECI":"","CARD":"5100XXXXXXXX0022","CARD_BRAND":"MCC","NONCE":"763FF0194220E6CCD181C9C6F4C2A8EA","P_SIGN":"60039CEA511A664084EC265E6412B40CA5A86F5C78DC9D4D21D67B663F0705D090CC751084EEA94AE10D720D588771A369D1BCAAB48182D292EB71AA5F752CBACD135F7D3501863A3DC4B03921A59AC440242A483A6057700D329D0CEF0D0CCC01399EA89F12196AE252FCA29461EB7F2197D9C5B8CF27F4EA251ED8CFFE95EFCC2DC258ED728413C9E6B052A0F8374356D113D98345A4BD808990234264115F46CD50F61FF1355CE35099155AB5A3511D2E7036A1C86B9070E241467A8FFE7DB228AE868657B46E094EC1542F8FBF85FE222A8A0B574F81934387061F0762D682B9EEE43CD1465AD77D9366659681D6DE5358BEAECB11777C0DBF4D9DAEF447"}',
                                `ResponseCode` = '{"ACTION":"7","RC":"-19","STATUSMSG":"Authentication failed. The error has occurred on ACS or Directory Server","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"391.17","CURRENCY":"BGN","ORDER":"001009","LANG":"","TIMESTAMP":"20250507132022","TRAN_DATE":"","APPROVAL":"","RRN":"","INT_REF":"","PARES_STATUS":"","AUTH_STEP_RES":"","CARDHOLDERINFO":"","ECI":"","CARD":"5100XXXXXXXX0022","CARD_BRAND":"MCC","NONCE":"763FF0194220E6CCD181C9C6F4C2A8EA","P_SIGN":"60039CEA511A664084EC265E6412B40CA5A86F5C78DC9D4D21D67B663F0705D090CC751084EEA94AE10D720D588771A369D1BCAAB48182D292EB71AA5F752CBACD135F7D3501863A3DC4B03921A59AC440242A483A6057700D329D0CEF0D0CCC01399EA89F12196AE252FCA29461EB7F2197D9C5B8CF27F4EA251ED8CFFE95EFCC2DC258ED728413C9E6B052A0F8374356D113D98345A4BD808990234264115F46CD50F61FF1355CE35099155AB5A3511D2E7036A1C86B9070E241467A8FFE7DB228AE868657B46E094EC1542F8FBF85FE222A8A0B574F81934387061F0762D682B9EEE43CD1465AD77D9366659681D6DE5358BEAECB11777C0DBF4D9DAEF447"}'Code
                            WHERE
                                `ID` = 1009
                            LIMIT 1
# [07-May-2025 16:20:22] /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
# [07-May-2025 16:20:23] /rapsody/root/bg/ajax/basket/qty.html?_=1746624022983 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [07-May-2025 16:20:24] /rapsody/root/bg/ajax/reservations/offers.html?_=1746624024149 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
# [07-May-2025 16:20:25] /rapsody/root/bg/ajax/reservations/accommodation/oid_254.html?_=1746624025021 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-07 16:20:25', `LastUpdate` = '2025-05-07 16:20:25', `OfferID` = '254', `ProgramID` = 0, `AccommodationID` = 0, `Data` = 'TGvORZ1NdWo9cCGelokwGgFWv7pHx-jKhPrkcSiyMqM4B7bKYtffdTI3Ftv0YuTh9X_9NRP_YItSNCA2S-LFUeSg0LvNv5j7JIVZmiWNAqrygTALRo-dC3mVL6cuooOU7yxbGxqih_0olWw2CoXysrJhDlmISvr3xysU5AageAqLalAsnyPGmE7nTyTv-WiTTKaYkgAAhrzPNf-LxiAutNgHMrwHfH5YCqgfrcrTysuA9g5DuX6uPMNtaypKwO2Sheca9XV87QDvgy-xduOCfUrEPsUajGN3wIDnSTTbL9Bsy9cvSDQhN2Sf3mQvRFOIflSivGjLFW2-321CDzB-GzIx7hQE5VhRGtaevqL2isqsVIaTclyv-3gZZ87pwVHqMbwIMzp8RNNLFX2DNn1PDnuEygETeUH2RxqpcSh46U0', `Progress` = 1

SELECT * FROM `reservations` WHERE `ID` = 1127960 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
# [07-May-2025 16:20:27] /rapsody/root/bg/ajax/reservations/rooms/pid_1457/aid_795.html?_=1746624027694 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
# [07-May-2025 16:20:29] /rapsody/root/bg/ajax/rooms/empty-bed-price/23743.html?_=1746624029459 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
# [07-May-2025 16:20:30] /rapsody/root/bg/ajax/reservations/guests/1127960/progress_2.html?_=1746624030868 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` = 1127960 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-07 16:20:30', `ProgramID` = '1457', `AccommodationID` = '795', `Data` = 'zQyjzAGHsHbltxFL3O9KP-ZUppssAFN9rGPs4Go-6bnM7Ng1z79qlB1VY2yG11096oe2Ylr5FByP_mUKV5FWTGo2abEbYiJ7KZI5C7hFdjHevdunyyKQ3A51qHBNAxZmzlkdneGy1hxtrPC7MjIaU6FS2ZPQA7hWAAnvAXIc1Onh8Nguy41c9oKVCQZaxrNLNhTy6x52w8PZtGFFCP5wW3M8YK2_bUSxGsp5bnJQQ0qhKPlmiXyU7V14b64bFxvxbA4tXNCk3Qo4IU-x1PZ0Qf8t9DpfJkk-9iHs_D7_vU1EpwPGV-t52e6ZDDRQ72gpOmtaXk7BE2YxS5LmNhklslsKK8vFmFp3XEja0WBkwk416u8teGXQbHAx_xP80XDX6GLzf2iHZ9e96lS3ZFEkxhRfWLqFOJ0vWTPxcS8rxdAyCAhqbcFxE2m1zb5ZrBs1m3IMM4_awupJMFRxBWFaahOw05GBDSPDxuHnF0YPNJ48ZSp0V7eh2PTQ-hUXCw2e8ClNeqHf1cei3PdwdcFvt_jDR3plXpn4euxVGtJBNqtGylolGQ83CxN3AaDlklohakqZALU4JT1O07JKdj1J4Il-IRrdRPtTegCuG6mAACDQ5obYDDtHtLANLzClmJAHI1lRbGSElaxjx8EoUe4XDj7aLiEClZST0AsUtyBh_sH2SO6EjjKYCi5Ouvlgvmqg8UwiGdz5r0D-p06WrkSETNgvMYj-GjjN1u1VyZprp2ZN8GD9MeDnncAFQx_zYOO0epZk6R3Q6xMoj8nmlZsqev9cWzL_kFDRApCAzW5O0xQ', `Progress` = '2' WHERE `ID` = '1127960'

SELECT * FROM `reservations` WHERE `ID` = 1127960 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
# [07-May-2025 16:21:11] /rapsody/root/bg/ajax/reservations/additionaloffers/1127960/progress_3.html?_=1746624071260 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` = 1127960 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-07 16:21:11', `SentDate` = '2025-05-07', `Data` = 'T16bw15WsAAatqZUrmW3AoexySemMA-Zdf-QTcd92Y9-Qn8EoNbhpkGr4A-EPt6c87rp5necxZqmNEDcAGFDH5pWXZcceeraZrOIYsaSG8GN-AiAmzfZIJBGlQvqufRqmeMJj78z8sU-qFk40yq7pmTG3VZoy-GzeGdc5-ARXsTOJ83nhkRmDsC2rJrMYf6WrOFb4R35JSjMy2pa2g_tT03b4xI_0753yAOdeCR0bj5ZaZfY0Juj-wznJ3DLcCj3xKz0Sif4wtGd50weZuytLEBfCXux3ekLdOpeZxILKPkP7Gej9z5u2fjKR12Vo7mvvCrwZmXP6AEhVjBnzX1b6nGCReVkVKJRVlkV4a2BPDvuZddAUXFNRorrqQ3mQkW1wewG4hDYOcMiBUZXxrU8Ow24MNCMRf8vbA0b6xqaP4Ln9haDgg4ZcLzcXo3LXGIKu_JWnm1kHKfQD4fm_YZhVt4dhexmzlr98ft1yLwWSvBLgIOdZgfEwtwTuVRtevWcM3DkBmpfT6NN6Ly2Qs2UnNbCQ1KTNW9e5JrWqKDsAavkS0kYDksvw7O2jf2XJdT7Bes5RUjuMUisTB80epcPTKyj-78HxhnN2tJVbRgiO2mim5r5YCvmJZScACKmy-NZB4tTe0aEy2g4j96chgLItTUqb2N6kWzZeWZ91bQm9_BPXWKwhoimKyArWu8FiGzkGHg1vfmoXiQE_4-iJruHc0sIq_QBs4StgtZurBgFAJiKV7frVPetEMe_2IWqMxRGzU-4KNfEq5BzC16SLfHaWTTw9__s6AA_uB_M8NcHHJn-94Myn9ckiVEuOoW2zGWO9xx0H8CxWs0PwFEE9sf6crZJ3PtrVvHRNrI7sBBGYJeUJDBA5GdTuooGH2_AHq4DpnsmZoMicR8K7LyCYVPQQ3XgxHtaHNoSyz2y__xrqIBNqrOppNLqq_6SafFjcs3y3c3-krf6fbe2gQ1iR7qbhjfBuJnYWNiZBa_dVGAJ0t61nTUIAAUCXhY5I1IRykog_ddOpIYcbp70QAJG0GLANXCYz3vhI33FB1DKvIyNRFrLSyh0q2nT0qwN2Y-Hj8MuvGA_MkwZQlpGv8oJ9qmFFHF4FfNTu6x6yabAuV8pvyaFzryajQ4bF3LULtZp-3JiT60T3ij-SOGWrRjg5qaP-PTGTDfudDHVAKy_x0Rm21yLWaoiv7Ef4YU6pliiqQI_FEVwC3Gxkms-5rLi4wAxW2sJ3_UxV5KjgEz5kpKFxH5oQfFn1-UB56MURui8isHHBv0mbBY6wv3-XFiYm669xmjpCJ7K3CKbjrUVcHhjI2g-FU5dQHQfczvWtsaCCVI_nWbh8JWD9tZ9rBVjl28_l3LF2s7fDOl0AIHGITdg5Sv2LVF8Ke4G_z6mqlbKcwxJEiGCqIC_vJoUIn7rA-A46_IfxpHMSdz1E3wYE0HcUjtBOx8lyUkOIEGA9NtDl4bGh0zndgS_4lAwTF9NxIk9SvYUzVzDEwEIUVTo9Get7uZ0bsVfVAFIl3nVoZpDtFaZpWsRbmqVIJ60fIchG9sfmcIlwGAkVFrNs2CMqgC40o_poiMnacD5wdLbvhgeCy4SkvHURJM5kTyHFY-ztmrQ8Ws8WYjid1s89fsyspvhTdKqpFB95KQKiMeSiRGfccIC3xeEdDZWu2F59b_k3veuG4L3TaiCjRJtRRvPbwGfJslNJ-K-w6uhPFDD5ja4DiiAnSNnxEB8wp7S4Q7sqFiHkg', `Progress` = '3' WHERE `ID` = '1127960'

SELECT * FROM `reservations` WHERE `ID` = 1127960 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
# [07-May-2025 16:21:12] /rapsody/root/bg/ajax/reservations/summary/1127960/progress_4.html?_=1746624072892 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127960 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-07 16:21:12', `SentDate` = '2025-05-07', `Data` = 'YC8H-awB0vhOF8rnSyK8RP6Qg6AuXp45lRxelUMRJCMyiQku0KgclZ25SovNRf6jsC843QNIYhPNQat0-55JKXMLJa3S8p-NxySZf8Qd_UQDgyFqbgTgFwMHYQNxpeihQWpFi5cilhzN9clUR9qxgkYra9isTqL_yupD-lMxEWRO93CgGEcoDFzpyqTJgJF-K4x7av8r4w8AVH_CLSflY3Q0LyfJc8z5yO1_gissrVtG2y-9U_D9Jc5LxeydbIWbJRwvmohqUHpgC7gbZtB0_xr0-FhB_mT-zpdLwiSL3-YOC-kkVhvA6bFoTk6peICC4_IwJ9E2PDLwfr24oH7HtMfQ6YUUVd1AU1efUEXow3moSfMDysuuWX-wbXyypgV-a08Xd969R-uSJH1ueKXJ7ZteCQGhePvGX6_ysS3SQ6DAOwZaAKEX9CA9L7VSv247n2nF0pJMcXx0XHti2ipQHPpf2AtX-nk752S_Lxq56ddOCQdBRyx5SCtbTPi1fOwYn93f5OLO1qEm9omprwegaYeBFxp7xse_9s9gq4VQpCeAl6kwUHmnwsfstIAo4XZwtAPcy5ttFBMpbrvwmwVHq_yUTl_HtGWbjL7SCsQ3cJ7pCobdiLdBmObHnHBg-WENfp4lZTQ_ABsB8ZznGSgbcsSsEFh62dwwMDm7u2gGZJpy04GXJc7iLOgNAL0a5a1VAxNiBAfQD23Ev0YVTGkXzi6tDdIhasaK2NcLvt-HOSZXpmGssg5eGfdxcCETZ09wjFhby8A9sRRxFokj-R7QbWkjOII1RGUitP6DK7jDJV4i5i-iF1Z_GuSLhcPp0jWloYs8ysDI3AuvKSnDhszdkQmiNu9olS86x3AcRVXiaib_hxykf7qfmx324AU_zcZADyIq24N34TgkELETP1aqSEnpuYebQCmsxjF9B1MMRKavkG0034FdmCyk_ueMFSVTXL33DJDHv07pLhQE_03SFnlaGUq0Uahc8_Cb83JSi0zlgDkBdLiLkSbABwtmPhBCmt_lD00qBQDv7k5OXv8T_Dy3C5TU_JD22jPbcALwiXQ5owHs4955OuzuY0cRUJGUPAbDmHy9mDdcIbjAuT31gpEto8iYVB0_VI3ZYCdVY5edWlyNyJRtIhzo9NgxNptN4EigEHJikbRnjk_C5zqytKxXgUNidSOycEb4TehPerHa44uG3c64eXRFX8X_QHzs94-o4I_ETPg7gYed9o68j8mTioiqYt-Ex4rJeblQO_PRAJQZJNx-KBh6z0q_8lSxKfkPuBdsziXNhF09_KCDZXZh4Hyr-NGFgdjNKTkgubagSh_1dbxybouQaGcy5uOi1sxxobiyjxcqHjj55O6ya-II-dB1MKyT_lMuJQrQnpRsagCZnMvyGlTvaCj7LXcrMy5AMyEZTPOVVsOS_CRb8seQvs_2z5bNeMyGjy0M8U4wqD4VdtMkvlTCkWq6dH6hL2p71zEl8v8ukK-WC87tpxv9AI0c81NVrUgmQD9wNdEJ5tFLBQ_Xz_vT3Am46ZECDG1FcDOcT1_kFYZNAqzFGzTVcPaGoVP6-wSmlbbGK9HGs5fxBQihcNkR6E38lvPCNmSub8nlG-vOVk7CzQZtxgLG9MvzxFzhcog7GqrgvxOx2VzBqjSehuDWZtp88S8Jzmk-vsO3pQba3ZLcp3PQ-DIvHnDlEvBfLnWA2neErrpLRAZdapeZM_MPnpq5jirqN-eGcOgqZeb1-gE9NDRk6rNfVwUAFU_V_onbFpvT6iDujMx_Qhj3yEcPOyGPVpZ_BnmFv9wfwxSCDihzTAecXFcj-r1ZUBEfzGdUJet4fJtNR2HM1gXiCD2P_pbEO_2E', `Progress` = '4' WHERE `ID` = '1127960'

SELECT * FROM `reservations` WHERE `ID` = 1127960 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` = 1127960 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` = 1127960
            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` = 1127960 AND `Status` = 0 LIMIT 1
# [07-May-2025 16:21:18] /rapsody/root/bg/ajax/reservations/confirm/1127960/progress_5.html?_=1746624078357 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127960 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` = 1127960 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-07 16:21:18', `SentDate` = '2025-05-07', `Keywords` = 'Y2FyZAdGVzdAdHNldAZGF2YXJza2lnbWFpbGNvbQ', `Data` = '-uGoF6xjP0J2G3vGnHEGj_rqgVt5O7qVgs1OhUZn_aaobVLk4421PSFkJY2Uw9SO7-QNrD15W7ovv6eUMsyjyMmRWuDkliEjtt8lN1c0SoVTVi2gy83m2_S2hKO5YMiLrRJROxl5HgVtnDFsyKfxM20lZw8L2xxLUlB9eLHtnyPEnM77Q184TtoU4aR42hSz8AdXRs3PhvYwnx1x0xC1rwORX6Xrw9xF8eGb2W6bkuhXG81bJLvFyKpbF5IIiCGa9vIfNvKgEq-3T8ukemlv9vqSMnmsYaxr3s5uepVci7CpPSB_pnJAwxXD9VbfKUjSLru_VT1obX_JAK6HiQh__Cux-4VsE4cbBRgq1sO6cHwdXWtTvoAH7rORRR-poWB_uAjja0duu0d4xkcrWMYOn-Oci6M8jsLt-sUO_91mJAQNcAMYGOugRoyGUZ7AQZTYfE_UEdmH5VB-oXch_KYST36k3KMfsQlLgHZw2AFgb0VgFnFJouZv-J7TqRmBzKsfdz9myoCMdf5rLii5y4D7kWv_WM5M9xUEogka8JPJyeCzNFCB4R5RZXZo8-e7BQmFx80J4B6ge6lss3LQ4Lrt058KubnhbZQexeRv_bc6zgVu92CoQng3Qur4aIcXezmncZaHRjz8BW9fK0sAVZi9w9iMCs0-6MO6IlV4FNsA9nZtTUoEMencFyImiVECUe51jaLENh9GNsEE-aY-O8LiIj8dV5NVKD405q3Z7bk8XYvraYURsD92syO-sIABVJh4OTrthBWcWDQ3rIHlLI25nCxmb2nwJxfzQW2HmXXRsgjoMSVeyjPFFc-IsTTHenRSJ1gMcj6mF-8t12J2KtxjqwMj1c0PV_B5DLWQya5ViQ_nnnoGuEriP3ElipvAKlh_tpSrV88vWXJOisSooG_qFv-PAUR2uhQmI_LD1xVGXaipnPpfdki8UD1iu2ich9d6uS5Vc2ilZhEfZDJMYT8rNitlK4GqQs-TiO7gpWqe0hmHfOF75406ayETU3Q9BpEs--ao46f_JF_XV05G40xl5EHfPIN7iEzLxncVLQVqNGGQyS2h4FIRrxqwyu9TTy8PJYgBsxwfPfKKf557XdsvunpuglYJFdcE3o7VO8o9MLcTKs_ctVcZityG8ukHhnwycSJlTIXtMCuqKEdTjtUIJb6blCZ0AMBLN-wSETjDlsn4wYrSRR-kfncLW7TGF9dODhZJn9iZciMGRtWc8Qcotdxoi_gj44IOSGNlq3oWmU1n1OB92csOV9PxUJCw8uxSjVBzBozu_xn9wMeUmSGHufIRBshtIGv_v_odo-NMqRkpCgedlSXvoaTY5GRY7bXiZE-ZMAoGWYzut2xZD7O3qIxkfMWsIfJpAELofWvf9sscvs39k9dGzyjgE6cwaPGoR__0WSg_F1-ve63jUc6qdP-3hm8aEMEqixQ7k3W9RfLhGOZ5vhjrD93FUz73ZIk-AjGxcfugNoSo0gR_0kzER__vk8D8GEEf9MzgJljwjP6reLyWsYDhLChipam-dzWcwjVqfb8eCHVR5afU4XqxmxHJDJ5TtZ1Ao-ClY7YL54UbYUfW3t_HfWO6LlKyP4pVtxC9GNM9Hoep_jO-xEFCs6_2jJb-0zkm0_ETasy0fH8GCjI2QU3EaFGSbpnHrT1c-kspyAgpALgIPQkF46mOFBTK9bU0579zZRGIZTdvoX_hdN9dP-jnUq0fo-9D4PGDnBMNzE2I4OcRmOSwQuCu6FfPrv657iwa1WXSTpN7cqP5KDfASf4L1j0XuKdIfbQIJDZ2CTdBwu3HDV-cc3OswOyw2F6uW31OCybZLvOyEGUff9FxKrVLtPbiR562gvKEZL0c07va4Mtkrn6Tyr_gFFUDDJdmbT0tueG8X0uavbslTH761h-WB1aeUPYPHukjHiXnkvCIfPfjBi_21Tm6MJdYQfaswzv1OlZGpYqrD9SDzFakigBfZG3JQTWaAZWeorRvb0P9nFGdpf6uNtKaF-jkGuLAljCGE4Qaw4y0WWWmEj_7_c3jpSKz0VtHO4zQ', `Progress` = '5' WHERE `ID` = '1127960'

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

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 1127960
                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', 1127960, '', 0.5)
# [07-May-2025 16:21:32] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

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

UPDATE
                                `borica`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"ACTION":"3","RC":"-19","STATUSMSG":"Authentication failed. The error has occurred on ACS or Directory Server","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"0.50","CURRENCY":"BGN","ORDER":"001010","LANG":"","TIMESTAMP":"20250507132131","TRAN_DATE":"","APPROVAL":"","RRN":"","INT_REF":"","PARES_STATUS":"","AUTH_STEP_RES":"","CARDHOLDERINFO":"","ECI":"","CARD":"5100XXXXXXXX0022","CARD_BRAND":"MCC","NONCE":"00B6FDA672578B421EF3ED2AF5C8D136","P_SIGN":"2DDFB1F2393FCCA41E128E574C626A594FF8FF444BFEA9534BA00FDAA17B94E3F3130E5B0AF63BC27E9F1F99C168B059F94E80CB082AC5609C2FD090432034FD86820DB7575EA727A9B666889DD9B8C95D0CAFE0A417687736109CA87E6BCA6BD78BFDE1C5A7C6D3E6CC199E5BC7C4C6E3B6F74DAACAD459FF02E6A645702AA948FDF321D09777CC46C4240681229027C79269E78846239EEBBF034A2D45EFCC4581958335F96E916DAB3B32EB2F4D47D2239A60F4FA327096CA8C3C67EC132D64DDEDED4232681F1790099225069B7367A076601A3272F817D679B6C69BBD60D4CC13692C6A25206813FAE7AF9D1F1C2F405F918B79D4F192BA2F331585735E"}',
                                `ResponseCode` = '{"ACTION":"3","RC":"-19","STATUSMSG":"Authentication failed. The error has occurred on ACS or Directory Server","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"0.50","CURRENCY":"BGN","ORDER":"001010","LANG":"","TIMESTAMP":"20250507132131","TRAN_DATE":"","APPROVAL":"","RRN":"","INT_REF":"","PARES_STATUS":"","AUTH_STEP_RES":"","CARDHOLDERINFO":"","ECI":"","CARD":"5100XXXXXXXX0022","CARD_BRAND":"MCC","NONCE":"00B6FDA672578B421EF3ED2AF5C8D136","P_SIGN":"2DDFB1F2393FCCA41E128E574C626A594FF8FF444BFEA9534BA00FDAA17B94E3F3130E5B0AF63BC27E9F1F99C168B059F94E80CB082AC5609C2FD090432034FD86820DB7575EA727A9B666889DD9B8C95D0CAFE0A417687736109CA87E6BCA6BD78BFDE1C5A7C6D3E6CC199E5BC7C4C6E3B6F74DAACAD459FF02E6A645702AA948FDF321D09777CC46C4240681229027C79269E78846239EEBBF034A2D45EFCC4581958335F96E916DAB3B32EB2F4D47D2239A60F4FA327096CA8C3C67EC132D64DDEDED4232681F1790099225069B7367A076601A3272F817D679B6C69BBD60D4CC13692C6A25206813FAE7AF9D1F1C2F405F918B79D4F192BA2F331585735E"}'Code
                            WHERE
                                `ID` = 1010
                            LIMIT 1
# [07-May-2025 16:21: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
# [07-May-2025 16:21:32] /rapsody/root/bg/ajax/basket/qty.html?_=1746624092271 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a357e2fe1fa884b3c8368e9a7763738472ee07480a51e3c9f13cc66006db2755'
            LIMIT 1
# [07-May-2025 16:23:56] /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
# [07-May-2025 16:23:56] /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
# [07-May-2025 16:23:59] /rapsody/root/bg/ajax/basket/qty.html?_=1746624234679 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'a238c04c2520b9da36e6980f962e3e6a4829ce7b11675945d33c295728dcf865'
            LIMIT 1
# [07-May-2025 16:23:59] /rapsody/root/bg/ajax/basket/qty.html?_=1746624234764 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'f78ee3a97d1e9c6e3cb6c411e184264c16ed514d6d57abf4ba3553ed25f96ff0'
            LIMIT 1
# [07-May-2025 16:24:20] /rapsody/root/bg/ajax/reservations/offers.html?_=1746624259980 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
# [07-May-2025 16:24:21] /rapsody/root/bg/ajax/reservations/accommodation/oid_254.html?_=1746624260947 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-07 16:24:21', `LastUpdate` = '2025-05-07 16:24:21', `OfferID` = '254', `ProgramID` = 0, `AccommodationID` = 0, `Data` = 'NlluCWXKpo8WEvTDYX2xE_q9OvsEOCsQRkgyUSTr5vE_CRsK35V7jtmOsM1nQLUX2x1dwWYx6HwdqMRagXmjOZLuMDRQNr6tLVUA_-CEsogHz4pXycYEOn4Il0SrdX2OXeP88kK7vFIEmx-ybs7cqs3K9EkjW0I1yKl9lULUdJQdtpIZDccHNGIoAbgMqm6jBojP3JYMfBkC1xOx1rxqmjiRJZd7ORLr4OuPyEgm5eSB11cssJlf_XJQ9Tii5GB4Sfy36hk5keTrVhG3Kv2jd6Y64rZ2DQ1TEXXnRpszWzbais3_RjYpOc6-QMKjUfXZNuMGT8e4BLSZp4LFTsD9ycH2Nk-iDFE_6eekHoxPvnn99B_ZqWS7bIxh1nXUzqhceQiD2ATlbQ09EaRdRrlRbXqlL6_12L4dJjXWATuogiw', `Progress` = 1

SELECT * FROM `reservations` WHERE `ID` = 1127961 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
# [07-May-2025 16:24:22] /rapsody/root/bg/ajax/reservations/rooms/pid_1457/aid_795.html?_=1746624262734 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
# [07-May-2025 16:24:24] /rapsody/root/bg/ajax/rooms/empty-bed-price/23743.html?_=1746624264173 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
# [07-May-2025 16:24:25] /rapsody/root/bg/ajax/reservations/guests/1127961/progress_2.html?_=1746624265507 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` = 1127961 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-07 16:24:25', `ProgramID` = '1457', `AccommodationID` = '795', `Data` = '3o0ex1meZ3gKb1ICXV5PLwugVWRKa40TDLegWvUiyrfUAA-BO2InsSJN3UK62D7jqlvlqpOeaQcCvRP5Bmk9wWhVf7bY0dGNCjAh1TYvriZKiprX5veQMnV_QsNx2VnaVceL-naNHN3Uf76srBpXP6aUAOVM2CIOKnw0Y91DMJgmEkZ9e8y3fJpANkzsuzoHBJL2uYCHGvDflOVp0X9udAY8U1df_xsmISqx7cDvxcMiNeKrQP-TOxnbuAA2XAg6tpmzqgIFnuLX1RYnvp0Tsn-Big6wXY3JwuENM5OJW8iK-ARoZw1YhMVf59ay5o2OMgEZz2wfw1rO9VP-fzz9pp6KEl_dzXqmaRzvc_nYP55KjvAo6DBHxdES1OaS4Rs_6ysvjCzEiWiowl2skJVEqw5AgIbmIVH6ajN3noOmOu-G3Lb5SLa-JzakqD-WeEaqnxecURfN38Jpo-9Dlx-EUp8GHnVas7Aal05_HXbouVIXXx-iEqXrjzZA9oVONqBQy88Yy38xic7WvBpss6YowUai7iMTIeKjdYW7liXKmsXH1cYKnP71G6jKg9F5S6643KlxtkgBzlBUedWBhatP9y34kxjza5fhzKpIKUkKwn0Zqo6vRA68CBOciucGgHItb1ogYkW80AGeqVZ4TrKog62dk370HS51nuQr9YyfjArtrJJi5tSa52kpER_q5fXxh0fLGnDxxZVaEpV8_LPNoFIxNeOPnMCPrO-5i7Tw0W2dbApRKbp1_XsYFuqEAhWVgCR46B4dOeFPI28B3WDebRaMBWQC91NPnW9EYJCGsZ8', `Progress` = '2' WHERE `ID` = '1127961'

SELECT * FROM `reservations` WHERE `ID` = 1127961 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
# [07-May-2025 16:24:56] /rapsody/root/bg/ajax/reservations/additionaloffers/1127961/progress_3.html?_=1746624296604 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` = 1127961 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-07 16:24:56', `SentDate` = '2025-05-07', `Data` = 'P5PstobDDh_IRpdorq_vJ2VRXpVR1JPiwN_TA2ruc8Y5YTvdIkBeJAPZ58y4woTUpBf9agKoKcEIqPlH0m46gPuTfQuO4sWv4jZZwR6XBRC7DeGRpOr_1Bh96uzgupopnhVTov_7GYJkWklzMRDyaI8WXddhcUMtTnrH81yqQWFKZKPbJ9VmJ7V05uRrDBgoYODFBZLKK8XKRI-bK6fWlxRCc9paNATd3MnYHJgcdVWOF61sjk5InjA7q3QVoKhWdj6LqXP52aLYPn77FYbH7ynlNyoU4bOwMArk3JbYmXMFYVmwV6hCLtpfW-9wL9Jgcyka0_1gOLylVosP2SHIHe3QCkWFnJ6qybMKf2sfKXl61VzHIFcQ3ulIiYd8bwB5ozMGHAB6SLaNesC0i69ZzEngxQLepfDf7-Axtw3GpnWyIomfqwuMmXN0jOAs1GxXqUIqZ_JU0k_j19VlHxkOiYcbsWP-N91JtmokWcpMc87NjRIYBh5ZDZp4C1T21Xa7zUVHXfH_MSilJE__aY0Gi-EhsKaJPeJvASXWuQwPttXOal7hnB_CTcU7ElaZ-fwyUGTOod4yogbCpiVAuXybf0T31y1TUobKDQLyi2_y-qIum1x25yOhtG5GJnS7YyM1-AB3yVmQFxhKTEX2F70DcN5_Rr31oQ2un21vL0CI8XlPtQ5oc6jdYDjJwhfBOqojpPAF1RxQj-yaZ27EfHwbkxeFwmkhCe-2cy8O08RWXOetUgWxTnnVcudR1DWYAILqJ4pvCsI_fBlDRbRiWsMjGzOTJppU9fLocER3iIe6qPzu0Q4flX44HbayQRHfc-1oG-UYIlNjhrvW9kU-h-AoM_JuYcRVr7tSfl0S-5V9WywF__FaOI9HUTnQ5UL2bt31ExR9XECzUt96-qPYxufNDpGZHiGaAS6tbDr8wU24kGX9JT4XPr659xD5H93a0f1g7J7XHjTcVZ7qRo7XIttlav3TWHXItojgp_UYUB0g86cxLIJP5VXY-P7AWNm6JdsDJRE8ay9kPLm5VyT2Qk799SIms877QMQay84GakxupowJc3T0TDiz32y1EQT71FPeVyaxKEPxqvLtN0P6HnF7VQPSeyJCmKI0b8n5N0UOMeoqpMNGyFAwGazsUBI0p-2HSEacW6ubTCeMYCO_m3QxeHcKUTkDOVwmI_gZmqlP6RT1w8KJre-ykx1Qko2d2IBJTWocJFmVdht6wyUMF0u18OSuwqSCVp04fHQrQk-2XLeVPcnHrEdL3kpVaQiC7N3Uvmzp5f2foxRGloJBcdQbhRVhOVrtGNo7npRsN8APCCfQE81pDonzqPXuy7gTb-3fI3Lwp5b_D-of67NsL-X14CWJ0vErjpdNKEgQggoy5E8sGZsYfj0UgUKJuSUw4x4I0XGqdrIEC9D6lWN_2tXNvK_ER4zEJ-ux1TlyCCuraCQQZRAFNq_VIEK6KwDe4XKK9KpHACE0t2xYJyyF5El5ZJxf_S6iulGkdioqgzSNVQEOuk9xgPUC-_bD8kk9z8xgQWk_pmVdUDyAtJ-pJXHii5_Cgwqh44fLdRpbh2LWBGYIVsuaSb4l1ZXP76FpWteou3H4B_3Et4Uj83DUsT2rpFwdddp9spBCcjrFJ0RFkzwrPT9CFou3dGcR3ij9B1dyJewO7nD8hSvk-1vBs0wiz86vLItBZkqSbwVWnmwr3DF9E2IdNKnIy70hCJQQEt7z3JI8_a5bt8B_zr7fv_PodQ', `Progress` = '3' WHERE `ID` = '1127961'

SELECT * FROM `reservations` WHERE `ID` = 1127961 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
# [07-May-2025 16:24:58] /rapsody/root/bg/ajax/reservations/summary/1127961/progress_4.html?_=1746624297995 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127961 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-07 16:24:58', `SentDate` = '2025-05-07', `Data` = '_IaK3pO3q524MArpq-XXDivUv_KvjvMD-VvQOVI4f_ojbJMT2CcX9pye_fdZHEKIf29qwEGvvaTjfDW_D1o0rF515W5p5xKY5ec2BbeZqq-pyjIwJc3uT5OvwxvrvqOfJXWTJR9KtwwtrujOEq5lrkUaRBbS4wNNIt7KUo8BdV7tfWJrwYH0ru6_jst9WSx49t27ntFheLbDS2PduekVSX_7kHzsHW-RfK9P5RiMA5RjDxJbyOX6yYBaFTU9Qd3MmpiqaiFo5FPDGy2XkCIPiJAqPG6h59hKQJ6Fa0HE73thKC4mxSEEswX0YSofFhlIco3IOhH77E3rByayxEOuNo2NBkuFnsXanZIIbcgnbhFgb0aP0QS4hZZyCLNm3VGlP63VHHN_1rWVt4oWlqyFN-2gDzrH2IBkHZh2I1piXk61IrRI7LV7emJRUXqF27imJR4osyyEkb8LDMEZTgSuI3fLhuMTrb3SYioG5pnmGftc03LP9U2mtlHBAvWscbHI2twLnrzgGpJJnV4pIASq86G4YuyaCcVsq6ZMWN_F9V8rhYWtbMJp7oyR2ZfwK-E7_0vRBnwyxcbeb8cyk4C5myiN8j3Lm-suxcORup61W7l7loy1Bg3G2q08xTfPAAkaA3pJIeZlgXJbAdoYvvJJsQSQl7C2Iu6N7iJpJ6R26K4n4TqR_v2w3uAD6HORAHgKoB1kpGMm7AfvzRSZE9Y-NWt84CTLEDTwcH0pPEki9BHa8fGArhYKbeqFF21_NU9diku5B3MmPTAYAVDD7zHj3Eozi804QaWrGjh_XHBXN4FygQDcKC_1wYlQsTkxBV1NsuW48Ga3gxP5IJh7lBX4NzbPgWnP9K6wyGS538C9StoRo-X7EydARuxmN3FolEwevzCHpP3oTPqT4gKeqU0GnN0PSFeSGxKPCzqMJNN9QxTX7h1-bRFkQ8_JU-f630b7jHxXDoUwIFqFCLX8tIkHd1B2wIYHp8rTjfMuej-d7BQ9DNZlb16siBHjTYMyVJ8cxIr3SjpX4D66nk_olAn83OnXOJ4fQOzLyTa8XzbqzpD6FnrXUvjJTgiafQz_WQB-EmVeTpmexbDtP9feI4zt93QpcIzsLIzX64J5EQqIOGTZzuCVKHBNkWnzvqiHUP_uYoOPdAaTThUOXGCw9YUo-wZ3G_gOQlzdzAQXUY8XWBYfwrKHdTeKzMFE1vg4Qlj7OTcH7Sc713rRCetqVJUN0872j6ClRvLyyP4AyGBTtbufZEQcYyaeLZfZv2w0IBCgilU4d9P_Vf65ZGCLGnru7-elSTDnP1oRXHWmEyt524ooYx3N8NwsH5n2kkEeuPTEiOan9EQXd83pjWhRx1HQN6KFG9RGyaaWFnf8PUq6f5CEQxaNQl0zvsFKUYbmnJcXg4oQpgloNI8CJzFIfvZnAXD7FYe8XN7E_1p4z1D2XihrICJuuYYjy9J2UZPNjlodTg5PVYva9E6zH85loNmak5YSLyBg4SIvaFABXn20NdQw_Q231Ex0hAvrjFLlg8Si--baZ_aDF-YCBnNm57GzQngVwtDzD2OlaODa2FLOYXJXuFxxqF0zAFlo12QZU4g8Ei9Hnu6r3ZHF041P-eXyZ_7dfaR-oSESd32S37CuEYlggOUONDh3G6ZIa9GkkCJJ5XjYPezrsY_JkoY3HVIurEs4TTfdieu_xA9L4PMM-vWeuyF5LwmlqMA5UuCyzAXQOlYGGgNxsoa6a2B3T9gbUeHg2lVWhxb77Fy_1YkeWI1xTLxTTytQHQC8INbMAcVZpNiBQNswb5Y5E-QPRqw45f9DOSFLm0-gs1L7RaggVRq4pgjfHtwbbdDbLdH392a69lqlovC-Ve73QWlpo9IAYA', `Progress` = '4' WHERE `ID` = '1127961'

SELECT * FROM `reservations` WHERE `ID` = 1127961 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` = 1127961 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` = 1127961
            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` = 1127961 AND `Status` = 0 LIMIT 1
# [07-May-2025 16:25:01] /rapsody/root/bg/ajax/reservations/confirm/1127961/progress_5.html?_=1746624301700 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127961 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` = 1127961 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-07 16:25:01', `SentDate` = '2025-05-07', `Keywords` = 'Y2FyZAc3dkZ3R3ZXId2VydHdlcnQZGF2YXJza2lnbWFpbGNvbQ', `Data` = 'd6sV96MrnQpWgPn17JN8QLuRMhCRsoDqmSBuqtiIvY-yA6pTxMtA96S5kQxO6vJIOo19o2to9P6n-Z9tJK4GWBeoLNN1E-ytl3rzkHXcacpIjq49rWfrj-s275UFRsATvhVBXtxTIvMPiUXNq2YywncroQVmEebOcYYGHi4ydimAwEclnkTNT2UqYFBBaUo46WoSRpgqZVpdSh8RFU_UfMh0J6ko-g1BY_1v--zPEzyFKevX2yIa7h7L-PrYPFmr_NRD0Ru4Kzu9-4WuqZxdvkXztVqiB5bHS5GZyhG78DdogjkffBnO9byIQVa7ymWeD7qWLXoyq5QXUVdDyFQNXvrP1pXJGwgYCdp25UxoAD2iNPZ0MyyUeGsCEzLtDRAl7A2DOTMEHDNlA_p-mhC4gq2Nojuf8q8wqMZxmrX067oodOmS8MeuAlFHc2g712_i_Lm_G47q0-o17OgT8n-93cEc08xP9-QyyrpWqbivaXU2uAAQd6ADShspcOGBIy9tEUkskZQAP972_2vkh0-6MctSQpDSB3mIFxEOqpctKFZCAIy43EQiEPhgeZBGsggODmaRE9XG65vgxat4FTEadsiaJ7GHS1LKtFJc8eZp16h45xZGZnL-we5EkVNBw0LsYX7vOTUVtWRsVU8FKVPVy2GTyYqWJXgeUPp_nYeT6iyDF2bSwbvk8SYpntne5pixMJbxzIINczUCS15pkW0Lf_Z8lrCw8ODi9RHN23kq2eWdU9AyY23dzrbR_B7haVVXn3iwXXaFNjM_VortbXK-L54Sc-QrOyv0WCoaZT8hxaK2kou54coVURHh27ngD2u3ZWq1_CcMPvALaSZmt1JaVeEevfqp9oPWFmIti1UEAGDI6MDG2f5vLLVq0iBKh33r8PP9MuXQz15hAf552M--MzYjuD3Gj-R8Xw4TOtjpIq7j0ja-YoWzPvMOlhkGUynJSv67vKAJ1Q6fd-M6Q31dfZtKH8WoB4Z8g4q4Hcp72U-2PytF61ASYIwUEwBXIgvGcIxwgMRG7R-zJXyXqIOzqlKOjMUVdmxo2j1mJu4-FUbgli1N7pd06AzWg0jl5B5992pRRj5wkOPgZkgAe8cK8yeNBUcTVVevGrMvCQRbn7dPPSzg2D-x3HCNmYC-2SD4_PJC07fNMLsJzFe2o72GidlUtDMSzjyhdjhtJLVxVr97WP_nVrGTDcEFCpXOEZMbdkiVsWhIrlyStbhC_yD_uTOVp_kMTLzcECa_O0DZZ0vtlx88jpcLYXhyeVVx-GgHACgSiIZVE5G3NiymMPQmdg3jA2pOwabG0pYcasyPG8OnG5t0uCvichytbQxFT9P_T66eWGG_157YF-X_8uKB5TvykOAqeToxxroOdu6deCw6YjB85MzSMJRlL9IbwOuCAjCCVPd0eWJTAnQ7nkO6FORxX1UUTl8BtTTOzm1nrrCeuos-Aod7jaX6FjthOG-5fFpb7W6Pvvb-ofVHVXOFF2YyeMgc-PeAKsAqEjJEUD9STjVqROb0JwgzREoNTxdCsKP_zI8HIHPvWPls2eEsGn2UYJPgZruRjuj6oxwszAb3KL79hnVQj5ht8YZaU6sM_4CRtUfYHfqH9MsPfFX3VXCtBzzKiSkNqdW6PD5RJsYPDNGAW8dw9TGhE-CCRryZIDEqojBLEfmm90LtVK2uqWRsud5ta3-G_WXI-zDXOEqCPzai4L_BHt6CQqM5Y5_wIAuMkqzZITdnyumc4ic-8QNo3FhLDqaSHpHOCY1AX7q8eIIE3SuMWLx7ETOQuGp7Ckyt-z9WTFPx53ktt82tLLjdi3SUWEinPpz-cu8074Pt6Gg181X55A9P9i2SDiCzR2qmJwgJ0spM-DdqEv423ZUvnK5KWVKjMacYcSfbY90mMfItctXUYE6NJF3UTEezqeN8CW1xWmFoaAVpjSFYn3RvfX5Hu9U-1urHWMSCsupSTGqRBTNZuQ4qoJwLKSU2016DbHCs3IIih9zXmltqKCPQWeN8uMSJlQdk40zSTSBCfWni2F-jF_qzAWWLOgIR6TdGU8bhchf9SFf0VVAJVgbfOQZ2U2qO5PAseTXsc3I', `Progress` = '5' WHERE `ID` = '1127961'

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

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 1127961
                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', 1127961, '', 0.5)
# [07-May-2025 16:25:17] /rapsody/root/bg/payments/response/borica.html 167.99.142.201

set names utf8

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

UPDATE
                                `borica`
                            SET
                                `LastUpdate` = NOW(),
                                `Data` = '{"ACTION":"3","RC":"-19","STATUSMSG":"Authentication failed. The error has occurred on ACS or Directory Server","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"0.50","CURRENCY":"BGN","ORDER":"001011","LANG":"","TIMESTAMP":"20250507132517","TRAN_DATE":"","APPROVAL":"","RRN":"","INT_REF":"","PARES_STATUS":"","AUTH_STEP_RES":"","CARDHOLDERINFO":"","ECI":"","CARD":"5100XXXXXXXX0022","CARD_BRAND":"MCC","NONCE":"41BC62CD5353404FCCBCB56ABC3E0690","P_SIGN":"9A7F9660F0855B078BB9EE376217FB424B1E88406EF61B90D285F4E0D2218B30EC4577E538133814F464CF6496016A51A48B2D1B1A6BE4B27D6668575D291CEF74CD7EF5663AC57229107E2ECBE312E4627753FA9DA9EEF043C94F061C630D55B8B5ADDEB989A90172C66C1AA52FDB587570F490B1AD59F1B54347F9B7EC1BEC3B954ADA84B602A7FFA77483863CC16FC0290304BB9877CAEAE5B29656C34C928AF7C42D70F389B854F920233A8CFF18C8BC73A9564A634ABBC299CB3569464ABD6D3EB2BEAB3473047C2ED9677F3FFB2CDD827180731AA6320F12BC2BD50645FB68D8F4B79434D2EC1954995E944425E704534DE7A58E1ABB247B884556BBC3"}',
                                `ResponseCode` = '{"ACTION":"3","RC":"-19","STATUSMSG":"Authentication failed. The error has occurred on ACS or Directory Server","TERMINAL":"V5402091","TRTYPE":"1","AMOUNT":"0.50","CURRENCY":"BGN","ORDER":"001011","LANG":"","TIMESTAMP":"20250507132517","TRAN_DATE":"","APPROVAL":"","RRN":"","INT_REF":"","PARES_STATUS":"","AUTH_STEP_RES":"","CARDHOLDERINFO":"","ECI":"","CARD":"5100XXXXXXXX0022","CARD_BRAND":"MCC","NONCE":"41BC62CD5353404FCCBCB56ABC3E0690","P_SIGN":"9A7F9660F0855B078BB9EE376217FB424B1E88406EF61B90D285F4E0D2218B30EC4577E538133814F464CF6496016A51A48B2D1B1A6BE4B27D6668575D291CEF74CD7EF5663AC57229107E2ECBE312E4627753FA9DA9EEF043C94F061C630D55B8B5ADDEB989A90172C66C1AA52FDB587570F490B1AD59F1B54347F9B7EC1BEC3B954ADA84B602A7FFA77483863CC16FC0290304BB9877CAEAE5B29656C34C928AF7C42D70F389B854F920233A8CFF18C8BC73A9564A634ABBC299CB3569464ABD6D3EB2BEAB3473047C2ED9677F3FFB2CDD827180731AA6320F12BC2BD50645FB68D8F4B79434D2EC1954995E944425E704534DE7A58E1ABB247B884556BBC3"}'Code
                            WHERE
                                `ID` = 1011
                            LIMIT 1
# [07-May-2025 16:25:17] /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
# [07-May-2025 16:25:17] /rapsody/root/bg/ajax/basket/qty.html?_=1746624317543 167.99.142.201

set names utf8

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