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

SELECT
				`PromoDate`
			FROM
				`programs`
			WHERE
				`ID` = 1455 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-Apr-2025 12:50:56] /rapsody/root/bg/ajax/rooms/empty-bed-price/23774.html?_=1744019456687 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` = 23774 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [07-Apr-2025 12:50:57] /rapsody/root/bg/ajax/rooms/empty-bed-price/23774.html?_=1744019457170 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` = 23774 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [07-Apr-2025 12:50:57] /rapsody/root/bg/ajax/rooms/empty-bed-price/23774.html?_=1744019457439 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` = 23774 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [07-Apr-2025 12:51:00] /rapsody/root/bg/ajax/reservations/guests/1127941/progress_2.html?_=1744019460489 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` = 1127941 AND `Status` = 0 LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') 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` = 1455 AND
                    `accommodation`.`ID` = 19 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-04-07 12:51:00', `ProgramID` = '1455', `AccommodationID` = '19', `Data` = 'rW4w5secqtoykSbzBqr-WFzvWNmfyENwps3mBUHDnBJP-ViBhfYcYiXA2wzendCFQniup6P942Mg_mkGCM87EaoTs9vnSTBWHoOiZiyx-SDilrFLUnVhDQI1jLXSIKtUYvZ22kTnKgXc6sUECViVxc6BZuJsW9JGA69IrXB3XJasygnufoyE9sH3hfCV0gU8mbt3uBny7w_xCStiZjHDjOyoAmN5I-rWuvJ2JTtiy2nk3wtr-BKEaLsuUx3QA7XyeUtPp-6XhPjhh6XiVEgdjTBsXMMhPysPBLTzu1JYFjMKD5oGAWV73s70mUUVG3YN_z4in3AzY83yefteQCU-sASD1IaBS8jyRrbyEe3APtPGuJpCFxM9Ju53Yc53PFj-0EFRDxOc_xN7fdmn5UIPaEaDaPp4Y95YEC2FwRic4kQATZ2WeF8K63K7d2Lqxry7WhsMD5pU8d7AK586sggLoODgqcuI1-7AE6pDXJfnyBS6Og-PlqEJFKPbyi2SmiDlCNWhJmLYdpFHjWdGRm8vN2suXk1EsJd7nZXw7dV3ILkRji-20MFh0-396bE1C5VXIDE4VTfF2NEThR_7MzNpHlAjlJL8mGLefgZEb80vkU0q_7iuEeHf1Tix78HsJG0ZIbLgUc-8e2qbY-_JxEDmL-YDouX8dY3DfIRtWsHyMZOJ_58j9qC_9m_m5Q1tNU26PBf-cqEFbq2zdARUUL31EYxF5OfTwFMrqNqoVxLWhi5IFXvtfKhqqbmJJ81ipmwn58B_f0XinYkkGHBTSX0GFA', `Progress` = '2' WHERE `ID` = '1127941'

SELECT * FROM `reservations` WHERE `ID` = 1127941 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` = 23774 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-Apr-2025 12:53:00] /rapsody/root/bg/ajax/reservations/additionaloffers/1127941/progress_3.html?_=1744019580867 167.99.142.201

set names utf8

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

SELECT * FROM `reservations` WHERE `ID` = 1127941 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` = 23774 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:53:00', `SentDate` = '2025-04-07', `Data` = 'ir3UtSZN0DTqghhp9EIU4Jxh2Lde-_JBRPRfR7mmkD2hGAHUsIBJ6Z1_EiwOXOXV2p9UDN_DknjSTfRBv3_5YPaFt1uJN7K6ZLIjYI2RrpOaOVbwYuX9a8nye6ucNEEOn7neaBipZIO9hN8A_gZ6rDhA2UqTVE2SWBj8e_I2WC1SwUuhCPHVcfNIKMC0Dh4TxnObguAFSNHAeMlFcXerWlt6KqhHYdKbh49FgFkqMwEx9QXWcEkC0YKfAYH42LQ8453bGT3gFWcZqlpRHMhT4DrPzEErOUP_LOhUdMvjg5yIafY6p6s4_sKS3YiqvKOaCqn09TuoYneWSkifJ8zM_m8GPwjNnrmKBOARLw-p9jK-1Bl8u7zjQbDDkxxX0EHo29vGaB9GaO5pX-12ayWpleWZG4iYIc9yHN5QSw4Tq1iiD3g6nIMTYOehma8nSXCvWfS8nqtnJ0r2SIP9F8mG8WMguhGSP4k0pGU8opTwqCFPtD2VZ9om0OrzNw4Oj8Qwt7U0XlXEgSqzbmJs3BcOZQghVMg4MCQtxGfgXnwCK-HOA1psxL9SJVFWXIFiG3LUWanc32Cdo0SPcjCCUic9vaWM9u1MMbvpw5jOCoxACGhUTD8gMXBtrlxBA2lbRHSVDh0b4_oX1PbOjs9MQcldm5OaE6X9_3XoBjUScFBDxqf0azMNcYlhryzujR6OlLUWWav77fwRwigJAvhfoPD5UOwfSovhSK7JOqJq5Zw0tOgHd5rXkk1w4EUCFL9qif-iTy5CA6-3qb3HqR-LjCWwE4_ofzD7kY4564tEJYy3sl47NlkBA2zlUS3eb64JitqMbtZ6zDz54k9bOgy9QRxV6JcK__2lJPV2BRWRoK3UmGcMaCg8sjm7xEVNc5R_FqFX-mapXtTXqM9E8n9S5o-gHdTarQZ_YrUlH2SqEOjEnqjYZeiiXupi90K58AIwHgsHzAoG4xacJT6MYRA9D_cJk7iYaTPM6ahJXoh8W53QjiYTUUciCnFsix5Aan5onbArCfQyYxvh_rqc_HGQXyyhCMm3iOCP1AVPa2pnL7185CZKvgprK5_xBR7rpe5sQh1R4Z4A63O-QNTaugTT1oyYwTTGv2PcQGfP0dDy3WV9wSTjJ9TOnxcziYQNn_PJkXzA820qs-issUreXfbmUXLCo2UL9aQ7oUjYmb4Ol2SOlQ3zEd2z_-8bKZ3umkmVzTTEZGVRwvFkzSEKquskpRZOx0MfN6NrKTOuSrFvcu2lop39cMRR2iOwaYfl_yGgJV6Hiir8Gzbyn2hiTFYEH9oklbFJBQdFjvPwqY5hahiNeRo490BAybn3mZef6WMXDjbUtSlji5gkgrn6NWST-3isnSI1RRY75WMvXMpDGDFvhOfJ5JaKrbFVwWPocyaT85R5mtukKDYPg_jUoqztA3APG57FsFuwp12qdoNV1uY7xuMYzEIh-NzGxpR_Wqc_DHh9z4jHhsMGFD40CKUYOndjMkcFeXhMzdxa00u2sEDitj7lgupjuEHuM010UF8sJvT2LwqeDM0mQu3o0XjKxrgR6AMqviEDAoc1p_Uz0I5m242raZZaWWHQovADLpIoxS1OwzYk8A0IijS8pSZonxkVeicrTxAFUcfVGcaapyUlUdphVAsRmhHt8NqetSa6P8pU9QZqOnSWqpQjTS9s0dtzXBoXsN2Dr0K8-n8wCTO8YAYlAACAk1fmfKtPq0-r6hwyiVHyNY4Kph-gj_Jls_gxDc9M8gvNJhJekHlb6HUh0VvyDOAjH31A6peUUk-f14oofkYXUGKfI0-ANFixrpRu8asMCUVxgq7Q45Z1lWWgqt5jqPOnex3zqqr_Zi7Bohzs7X8TCpTDawyCk7l_1ZCPSfWf_mxDLqmyaZ8ZkPQEGc90yEAzTSOll_c_myWN-mOKgZkY0DhTPSnDD26N2p2eKmtc1JVu3UgR5mX4eazB4wo7F6OuX-1L3y0Hk9jm-7hcD2u1xkHGJzfmw9HVzMJSrnfvKA-cBewfrcWIdfFzfO4Y5h0eMVRCEKwhAFUMHv6yfySW-jdIY60Nvd9Z4lyVfd0Kq8JeaBkgtUA7ZtDnGz0ib3FCA9or-5lo5E3Rfn5SlAt1Et2lR6E39UiVjV28EvRwQOa-IJLZO0yM5zyri1piZpkNxWVziTJb27axpRjpHScBiIwYyeEg8BA1WzmgAS_rqTk9tVW6btY3QL64oCWSmGO016exz19dzB6DNoqZ3b0QXnPm_yGUnOI7cw6F3GigUyvtpI2FODketCYzKRfdX7TE_HrHgujbrdpmCNJQXQ1ja0K1OqLEFrit1ByXw4cFmi9UuesrhQ4T8VmZPjl6Rdl-CWleCa6tvoqXUv-Sh-hv_6nUOd3XA8RD_LeS2sGbH1zeSLvd1o2179zvx-98vzAjqSCHAshb1OJSVN0r6YVk-xH81EbX146MKeTwU-Lz9iF1S-qcIJGzWroIY42pnd9JMYeGBBDetaN8yneDrYKi0fQS31aGHiGGB1my6P6oSjkN9BJgFPdYPYBkqDV8ATAbRKSK4brq-zvPQM2BWHYYPUS0PcRa_Vg4pbZRWA5XN2XQAzas9DAeF15NLjm7boJ83RuGYiKzA_DDxh0HNUjgjd4i8kao6dlymHUqKdAcCxQS3m3YkGzQi0gGQR0fpXxqKWVlRCRjh20X5ZC32wCs3eLAyQwNv3nDXr8R8Xo9RybiCEif6fFD1YldBBFBywGzR7g294_630w5OAxLi9dSiBxkAvCB55QGaOZ2iS1pWLOCsrKAXwuDxPn9BtMsXMVagGQhVPC-zgvPVDHQqSKNH25VLlRNARdOIRAkmidxq4r2NVgD4VXilD8KIL4', `Progress` = '3' WHERE `ID` = '1127941'

SELECT * FROM `reservations` WHERE `ID` = 1127941 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
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23774 AND
				`Visible` = 1
			LIMIT 1

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

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

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

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23774 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` = 69 AND
                `additionaloffers`.`Language` = 'bg' AND
                (`additionaloffers`.`ProgramID` = 1455 OR `additionaloffers`.`ProgramID` = 0)
         AND `additionaloffers`.`Visible` = 1 AND `offers`.`Visible` = 1 ORDER BY `additionaloffers`.`PostDate` ASC

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

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

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23774 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-Apr-2025 12:53:51] /rapsody/root/bg/ajax/reservations/summary/1127941/progress_4.html?_=1744019631963 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127941 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` = 23774 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:53:51', `SentDate` = '2025-04-07', `Data` = '[encoded data, 7446 characters]', `Progress` = '4' WHERE `ID` = '1127941'

SELECT * FROM `reservations` WHERE `ID` = 1127941 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` = 23774 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23774 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23774 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23774 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127941 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` = 1127941
            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` = 1455 AND
                    `accommodation`.`ID` = 19 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` = 1455 AND
                `Language` = 'bg' 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` = 69 AND
                `additionaloffers`.`Language` = 'bg' AND
                (`additionaloffers`.`ProgramID` = 1455 OR `additionaloffers`.`ProgramID` = 0)
         AND `additionaloffers`.`Visible` = 1 AND `offers`.`Visible` = 1 ORDER BY `additionaloffers`.`PostDate` ASC

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `ID`
            FROM
                `promocodes`
            WHERE
                `OfferID` = 69 AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                (`ProgramID` = 1455 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` = 1127941 AND `Status` = 0 LIMIT 1
# [07-Apr-2025 12:53:58] /rapsody/root/bg/ajax/reservations/confirm/1127941/progress_5.html?_=1744019638207 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127941 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` = 23774 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23774 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23774 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23774 AND
				`rooms`.`ProgramID` = 1455 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` = 1127941 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` = 23774 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:53:58', `SentDate` = '2025-04-07', `Keywords` = 'b2ZmaWNldGVzdAc2tpb25lbWFyaXluYWF2dnZnbWFpbGNvbQdHdvc2tpdAaHJlZQZm91cg', `Data` = '[encoded data, 7659 characters]', `Progress` = '5' WHERE `ID` = '1127941'

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

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 1127941
                LIMIT 1
# [07-Apr-2025 12:53:58] /rapsody/root/bg/ajax/reservations/send/1127941.html?_=1744019638261 167.99.142.201

set names utf8

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

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

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

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

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1455 AND
                    `accommodation`.`ID` = 19 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` = 1455 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
				`rooms`.*
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 23774 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`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` = 69 AND
                `additionaloffers`.`Language` = 'bg' AND
                (`additionaloffers`.`ProgramID` = 1455 OR `additionaloffers`.`ProgramID` = 0)
         AND `additionaloffers`.`Visible` = 1 AND `offers`.`Visible` = 1 ORDER BY `additionaloffers`.`PostDate` ASC

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') 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
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

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

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

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

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

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

INSERT INTO `reservation_rooms`(`ReservationID`, `RoomID`) VALUES (1127941, 23774)

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

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

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 6
                WHERE
                    `ID` = 1127941
                LIMIT 1
# [07-Apr-2025 12:54:06] /rapsody/root/bg/ajax/basket/qty.html?_=1744019646783 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'c8dd7184762b0b649a0f36898b481eedc5c1e839d2342a98ebe2c5f5c2cac847'
            LIMIT 1
# [07-Apr-2025 12:54:07] /rapsody/root/bg/ajax/reservations/accommodation/oid_69/pid_1455.html?_=1744019647692 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `reservations`
            WHERE
                `ClientID` = 'c8dd7184762b0b649a0f36898b481eedc5c1e839d2342a98ebe2c5f5c2cac847' AND
                `OfferID` = 69 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` = 69 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` = 69 AND
                `Language` = 'bg' AND
                `Visible` = 1

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

INSERT INTO `reservations` SET `ClientID` = 'c8dd7184762b0b649a0f36898b481eedc5c1e839d2342a98ebe2c5f5c2cac847', `PostDate` = '2025-04-07 12:54:07', `LastUpdate` = '2025-04-07 12:54:07', `OfferID` = '69', `ProgramID` = '1455', `AccommodationID` = 0, `Data` = 'F3STmQv5tBQuUx1104XCwnqECpXo5uZ2UsS-OkZU-HazeYQF20XahzKQokyMwPA2jggUSR45TlSH0ovQ_wRHjvAAwSHmYvUFmhDLQzjaIMBEoFcBNGz2K9hrgsNCYFoXX-QTtg7S1H0y1YmKZkysGE_CmHiBY_SKNy4a5OKJtn_KMfUGe2B22_6NTTisHP8KREy2ZH-4jY4FJbZoHobbsVC2yBOIyk-zbjiRdEV1iKHZv7RFZ0OBBIZX3a8Ct77LAOZBjD3z--gYaH424j_HIr8BuELMU1n3sChtG3SudlWxhc6pJjIv4XkV5mTdC-YqZTNT1BXVl6DCU4qEtHT4dHyY2wFMpgfvgP1eQcifUWakjs6gWh2pXxZEad8n5Ncz', `Progress` = 1

SELECT * FROM `reservations` WHERE `ID` = 1127942 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` = 69

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` = 69 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` = 1455 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` = 19 AND
			    `ProgramID` = 1455 AND
			    `Language` = 'bg' AND
			    `Visible` = 1
			ORDER BY `Price` ASC
			LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-Apr-2025 12:54:09] /rapsody/root/bg/ajax/reservations/rooms/pid_1455/aid_19.html?_=1744019649108 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` = 19 AND
						R1.`ProgramID` = 1455 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` = 19 AND
				`rooms`.`ProgramID` = 1455 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` = 1455 AND
				`offers`.`Language` = 'bg'
			LIMIT 1

SELECT
				`PromoDate`
			FROM
				`programs`
			WHERE
				`ID` = 1455 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-Apr-2025 12:54:13] /rapsody/root/bg/ajax/rooms/empty-bed-price/23773.html?_=1744019653081 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` = 23773 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [07-Apr-2025 12:54:13] /rapsody/root/bg/ajax/rooms/empty-bed-price/23773.html?_=1744019653349 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` = 23773 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [07-Apr-2025 12:54:15] /rapsody/root/bg/ajax/reservations/guests/1127942/progress_2.html?_=1744019655038 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` = 1127942 AND `Status` = 0 LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') 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` = 1455 AND
                    `accommodation`.`ID` = 19 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-04-07 12:54:15', `ProgramID` = '1455', `AccommodationID` = '19', `Data` = 'k_GSKjBXLxl6-SsQnt-PCfbEg5a8xhAHqEfI-Ql9D_XWZ6wi9AloQmOHyLyV19GtgTKNRo88fZmkuvdMx5LVAaryYUeZKUsGvWwJR7oGMDD4UFzVTxSz2Wpk2oaF1ckWEsrIVFOsV9spXepu9TILfiOfR28L_V7ETqiZwYf--uFDG6f8kFUXI0JeEADwlekiObSH3Pfhq_rzd7U2UpES5gy7UBHmPYOUvwxO0hcYRtHxy6nChmuS3E63n8DlD1_5aCIfYw8wOEvAQN-lWrwBIW8aZ3rxrNc3oWwULh70t-uDzGPXPGENQS-JLLuE2S9YFFlf2oM_74qmUIyf7OE3Lg_kz6VPwBwJasfTulG9BMjSkN3bP6XJuzx6PIeMJNK8l9lWHpXh5w9LC3Jkh9WNnxlNMKFMNydqUQhIbQKpxWIBYYDmCJsdiJldpXAbgA3u2zGvRiN1UZF68z5iDyeqlszVmq27wCgmHmwJKp2qRgegI2kUz3aZ-sYaxn8mwGvg3vS9d45PNeTuYr3gkqCqZ9T6lDpFhCb7fFAIm18mO2EEvlcWissQ0VLHxrLjEEzeuNYFjLvdYKfjrFp3TK-69K8-3UGrf3vfyId1ixVkjk9yhbrBv0fA_6mZVxHU3bcS8P1IVPgi_uFnbPF4LlW4x6GQGUHXnPrFbw4xuek2g-G9iwpUHDAQYajNbkhdiPJfeAEvbNwSz9sbuULeIfa1xQmwFrSvdXefgX-ukiSN81Q3l8nmk9wQpDgBzRVYVvDboPHQjpxbKZkRazeKb3KvBQ', `Progress` = '2' WHERE `ID` = '1127942'

SELECT * FROM `reservations` WHERE `ID` = 1127942 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` = 23773 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-Apr-2025 12:55:06] /rapsody/root/bg/ajax/reservations/additionaloffers/1127942/progress_3.html?_=1744019706373 167.99.142.201

set names utf8

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

SELECT * FROM `reservations` WHERE `ID` = 1127942 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` = 23773 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:55:06', `SentDate` = '2025-04-07', `Data` = 'd5gjea0ymK3_3HnX7hxX1Dyko7XOHZcjobLcAKK6124cmI_RyvUXL0EHBh7XhOfUBNYPdfpwv5WOzVuQLKcT3fWEdCHQ-1PsFsz_QYQG-WWaHoq5BJOLVB_JwkGbUVFk4EhFpQxG9lxe4GwWouCF0RBEB8N7eRTaDdl3Cm8bswQ3RQEoZiLySE55wQLepiGNp91gt9M_1Y7Miri698TLCJDc-HuY7evgl2LuF8Z-7jjMZvZZSkzBGQhdFPAx0t1GXewoWbkjtOjqQTfqlBFaKYAslEnVwMtcbYDZ9DF_YFN7PYFdj8L_UAjt4UyEPsjElEoOAheEfqZvmRzm2kmX5O3etpUOEjquwZ_4Ptq7idApvO2nLVaQTMl8RACRYj7MpUh_7axNGxkAl3F_z2b-E_XMZL82e1aJup_-CCHAmOgzVJUJn0ONT0wmhug8QoedthOX_ZoWqCH-RsQwn7M7iVr0RDoJblnP2jAvEAysm3_av6Yty0uo-cHayE8cKY0P6BpVvo8vqBKcu-hOuU-sJaEP-u5D7Gn9y-KZVb_R6H9Dlz39jgkPvSBzWFr_YvzUSjqPkv46Dnmrphjw_SE6WK3FPEO4xBlz8ouZZTs3UTZp7E0v9Avkvhek2DUr-yt0pwo_CcU44aqcwGEpfag7cQuD5J36yki5xd1NgoQz5_ByvBskROFLLkhbRd0sUbtNSXdrkQkSBKdnJMFiiWBlI0F5lUbdmZoP9wAtdMyfSK3el-A40rLFJipeAcqv9tozQSJswbs9R0AfSspEIy9At8TaIwKTim-GjEvXd-TQvabdQVjOGVyD-yoot_uG7ysg0ETjaftIUI_I7L4pV1it0JhqKOm0Z17qdK8I8xhJQzV8QU0uG5jX8Bvotp2LSknOfNcZguxYwqwdnsab5qN7d6QPYjDA05o2F4dQuNFmI7uwpD9q3JemGcy0OcYzLn10qTvnetKgo6HQlIlgVMkZVugSp15InAjhDMyCYje-KmvJN0gFLRdt_B-y3aPSPeuCulHPPB1vPyvm8_p15azLjKXh5lPK_H93f84-LvYoKIbKQW2a5Rk7Wc4UwNVWdFKFV0pDFNxm0hnUhJvSDXWo46N_hys5Nw03In8EWKWjiWTJuWyhUUyea3RNHucEiSZBBcb5QnHi1k_m-PZDqnKIW8FzqqIHII8RN6f9nKUD1VpQ7V1H5OAhFki_JrFNT2kveOofY-YURG5_eu8Aqr348X0oERcgvHEKUVmggED4Cdhqyz75QnhouatJnc1Hy86t4go6HszmRia5euZYGr1CeGi6dK3CML1hP38H6Bs_uhZpyXYc74XrX6TS1RszYhnK9rkKibP9iIQPVVKMudfecvNMEzHqKih3yHvOTFaY4NifnHNtppCORcSpziduBf-BPJ5gKOjyQe2NlxJjh58QDpb5xn15QLaQtcTxYyS2iWWke5qiaFIetCzm7Wo-bxHb1JgNn9ziIDCIEhYnX_SyT7IQCWvXg82z4F9x0SG8wJ0FChlm84JC3C4p5_kpPM9Gts5CK4ThCWEm8g24Du9UjxGfG9A1tU7SNuxUphjeEJZdOixq-7P_Iy13RAhLSyYUJAVq6MnPnMY8hFljC1846H3opJiGjDbh5CjsQOVBpfS8SyTv58KNLnGYISMPiGW1p0tpC0X-HLuGf4Bo2KTsnB26KwHseDfcPfi4UGZ8W_G8bhGnmPAWJHIm7pDATPnBkmXZToEeol0uHLS0cIdoJtyfriT0fjsTcYLzcqU1KPF59sVy9bxJL77oaNejC5qBIkpFMU8Zu6r72LasYDFIBgxuNREsQGhlEUlWHfI_EOl5yH-FHPOX2IWSUsCAJ0kBlhwqQUIUTClWwOLK0VPdYWFjwsOZrrO3AIGk9HqfI1qJBALOFluzwTCBXLa4j7WLrMQR02bfhUB_RTLOWhms9QrR9alfry4vL1WHgrzUz5XlK74h4YsvPgMq8nvH56lNqSGczkR3XpM7tp6d8Lej49jIau5mr7raAuHDFKqFrL9ElhD5fTmQB5_jL3zysGPTk13cQh2wGZVCg2S_fDA53g', `Progress` = '3' WHERE `ID` = '1127942'

SELECT * FROM `reservations` WHERE `ID` = 1127942 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` = 23773 AND
				`Visible` = 1
			LIMIT 1

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

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23773 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` = 69 AND
                `additionaloffers`.`Language` = 'bg' AND
                (`additionaloffers`.`ProgramID` = 1455 OR `additionaloffers`.`ProgramID` = 0)
         AND `additionaloffers`.`Visible` = 1 AND `offers`.`Visible` = 1 ORDER BY `additionaloffers`.`PostDate` ASC

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23773 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-Apr-2025 12:55:13] /rapsody/root/bg/ajax/reservations/summary/1127942/progress_4.html?_=1744019713515 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127942 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` = 23773 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:55:13', `SentDate` = '2025-04-07', `Data` = 'WHu-qi_4PKof8WCugftIdu2vA09NaUPWdviEBtbuLaV0VDhqzT9m6hpbxRjd73c07f5zWiTdILoGnc6KJfo6YFTEBfBPJ19t8mjfemJLIRHF3yCrdp5qYUIZkJOa7JqXhn9LvNPoFWt7QhTHPB83V-dt7lapCuYuh6zZDnMotiHd3IO2PNuKKBb0eAdB2Jnf4DTzHYa7f5EpXwY72j6YeeCOQZ1AkfMD3GiLe5F2XGjkaAj4BjnpbPiwdIz9th_R8Fc8cJ5KQ6HE59W_MtRDQXOZkkRU5INUWnRqT_fZy_bGePh7SoMxd5X1adzBbGBMk7K7YugPN-6okYr0DglOZP4qwDKXh-M-CSoLyn3v8DYcH3NQ8xayVR7cFxMrioA0HxZaqi0QPkRNcK7r6KQZq-NRz_ROyyA3MkyEQYQJKOHa6PZwAeAySNewRKoTOWZtlJ2OOF5Mf5MJFZMeeFuJ0Vx_Lh4Kgs2xU_HfwOS7VMW7WmCBc_s3ZSh4pDjgBJNN5tj51VB67qelX7Wh0LMysHlXJq7w4r1ZhOHOMW-WnQ0fZJZBzPDLDsyYS-1-jueDH48Eo1rIs3ksyZDd9EefZiTEwNwmzLLfjPjg8rDYolK5P9T6zmncll5sNAvSY6mkHUftc1evYw4UnD7zctPDOoBuLVXIus3kQ2w9mEJ66p8k8Uu_x7vPFXZ5TPUGl77bWU5xUDN4g1uQhG8uHMbKud14ydjg6OcpLEJLRoacwhWW5F2TN1LYIPjT7kz8e3663jHtHfF0zCYUiUjgNzsKuUX1wn2HAJ51WEyEtSSGfiPc38in9cWqEcwcFbaitBOhCFPVJ6pv50WayeZapOed1mUw4GLzO_Z9i4iPBliiuFXe8v5ZYqknciXaQbiqDsOkX9zZw-LF5Ac4LIeYOZkHwT7HG7cx7MVczjwyknLj7YnL_HcmXISLu051fuu4ocfirJrbeV7tcjrzUX8eqDS08PxuKY5Oc3IfjnaO8JF0kc57PVIKKX7ZLY6RCPrRpZbw9RX7lMpTo85KbFYxnpGKdk_D4EnTlEU6T7D68JlzjARM4VLQlWVGya_3rqOnICFOGwMEKI0QlWWl_JiDnIkEJhn0s716UID2OSoXkLbWy0jA8tQHrJq0kGUMDjiOKlKBOgtvK1om8HChDKe1FB35wXZdrmM7uraH4gkjOHRR6bUe-Jd1R06CXJnoWpbAOboKswbX50KR4K6BKuPf-AiiE02gFGTJUA1dNF1XDaTDGoPWstrriyVUVzLhi7YciiW_aYsLcs8bowoAUGOKkn_iuPDol3sodZ9Tr50d4YspkzlGrCUpZ4_-7MWIFmA8LJoyuNQlIBJVinOPkgL4S0J591XoPfOl3Da1UloQRK6RoDRYAN5SlwHGY3T0ObKtk25uVzbFIoquWC0mhFJrv7WgQjpOANzCoupsQNkOfMaCRGZ72OwIWSLCotV5bw6RHLF6DFJJaYyJalXGTHKc1S-6UhzshCjiu2aDvBCv2Vmu06lfPiIDChN_DD_Q81wr_Aj0CRChy22bWUQ30AT62LMEm2V8VjfN2kTWMg9Rmgj7pRMvVB_Z0eVlk-iKWtrlsQ_Lo9Uh6tvDiik_b1fLVo07MtKvdeM8mSLI_hJJX-rHBveryib3idMTEIdbiC-Ga9vhx7Ls3Trxb9D8GO_xGduzLdAPZBP5RU_LRCfalsRIjLk6VzP9GkHNu4vSGNKzYG5L_a52VG5t4dI8SPEgIb1Hc0q84mbEZtrq3WstNR9vvzXumtDJ7injs00a3pJNNeF_GKak3PY9WvcOTec9nb4oRxWN1Z_yk-F1v8Ol5vuvKMfkwzoWawHugZZNOQZrnBGEtxKT2WaV_EnNtNW40B0bLOAKUoAgLNyEqZOcaBG7rvD7Y6CTgc0qpH9mAv6qu1AQvxP40CsgsN62lDipBPOJ7WMh2lhOe6PxQkbRVhpHQCHlsXIhcdgsVKuCgDEaml8Wwy9giwMgUtjWW8vsGle2VKLRRSstpj8TuhtkvCSPmsbmp1oyYYk6nhly6-5q4xMDQjw4Ssm8vZneGnxx2Mj0eWbevhqgnQNivbLqdH6vr2ocsn1hG8oHYpvLJBgMDhOTzEZETERqwsDy94tBs6cpiT0BKY4HI-7cbUkvoevXh1RTavjhqeYOs42qbq6xBSSIS0bbMf1DriokHKqvPPbgI5DlV7oVCE4TbwchEXKR6nBW6CtkU4EiR1XCOTqZoecybrXAQlWFYnNC2PKweIkGvEjUnBMi-soZB7ZafIXCWPwQqJZGv94d9PFARDTl27N1', `Progress` = '4' WHERE `ID` = '1127942'

SELECT * FROM `reservations` WHERE `ID` = 1127942 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` = 23773 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23773 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127942 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` = 1127942
            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` = 1455 AND
                    `accommodation`.`ID` = 19 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` = 1455 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `ID`
            FROM
                `promocodes`
            WHERE
                `OfferID` = 69 AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                (`ProgramID` = 1455 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` = 1127942 AND `Status` = 0 LIMIT 1
# [07-Apr-2025 12:55:28] /rapsody/root/bg/ajax/reservations/confirm/1127942/progress_5.html?_=1744019728692 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127942 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` = 23773 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23773 AND
				`rooms`.`ProgramID` = 1455 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` = 1127942 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` = 23773 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:55:28', `SentDate` = '2025-04-07', `Keywords` = 'b2ZmaWNldGVzdAb25lbWFyaXlhbmF2Z2FtaWxjb20dHdv', `Data` = 'aG1FJwG_CLMCqGrYfuHC8d3TGnSTmpCbotK0hfT-3_76UftDDw9pLzsQlBLia2MXzPNtoXIOv2Kiy7JkXcbaFNkjfjvJ2R9pdm5lf7uP2bmZn2UPLOuBg3FdWCY7l5dxC3rHaL8Il1s8HpaBSLOj0i7olgRZv30EmHDOmpl5LC0BywiFh63GT71oemZh2T5EKLrHTH0W3hixjgBb3vhggCOyo2pqbvHQ1an6MTkLUpV6S4WiFnzGHcsn3PTIKpZhidJh_7Wnje-TbJWWhoQPCfPuuLJZKIF6hMmCOIxWst54m844Fr6VrMWAzBZmr5iSctBlKbfvszZc1XMIlCbKPCZhVPSWhTsbVbYVHvX4UK9CWTJMAq6CfHdbXq6L4n_BICT_I93ZU5g_8qOYeibVTOWdMg9AY5XdCy3KYR_S2f_xTvP4lHtcN6SvYY5MBDjNo2VieGjmo57RGJCmnSG6C70rt2PZL5MPOAroGLR1yTBjWKQh7t6Iai-SKJLBFtLVG2osGWXyKcgOzMIPTWaGqOpV3klpjQOF6pqfGU-pDHU2GeOga87vXKMugCKOKNJTiN9ygOKtNaw79jqTAS4ZhEsNkQp7xLyTKieHYtF--6A43YbtrSrvZaYvNMrhlNbVeC5xy1qpwLciZHg1NhSrzYgmauN3E6ONSB6LYGeTTl1udJQph9vLHqgUnJDOYmouyVQ_sPXhIFVSCeUdmiZSSLn768NJNSrmRTNYOUAdd8l27sPOsJSXskDyzkweNqFJ8mtrq9wID7ZbYpXFOWLmSvB4zbpz9OHsSwIItHDHH8bcK7WlT2jA7udJg7Te2A5BhaW55nXrOpsBj-8_1aM7TuKA7bvomvUMxNk2PCsDg19kaTCbucZlYi03dDW47HAYF6CwAsoR5RyryHKMEdOFt6qAUmonOA9TCtVPabMZ_Ec5ZkBnUlpW3j-wGdYKyQQCMjeCGk5dSfcTtpY7OFV1POqXc8OLzbYxi63hNsr3bnPDImDtoUwW_9sEM_Ax_ghi0oUfyK7IQyR64J0gQ19yW1RdGEpEmMXnRgqIk8bu7Pvqe9uiSFTBJAFyOA_MWIuEzGpAJCph3mTXzK01zc4HgzMRI7Ky_rMYn-ZE_JleMhlyx1VuxvDU56w-amX75MF04wH-b6Xwtcto265977mYkXwsBU5KNWZFjzORFbSnPCJ_jpZUPYWdCPb8c1MPzULK3ccFj0NE2L-GHhR2mWmCdaUW8h-VDCLXfHHHTvE_AgLUrJw8_zBIMsHTsPwDHm4G7MzAg7kemOdYXr5VwbszenqgAQzvaLLJtPovR-PT9ddRxzvsP-wb166Jng0_mAO8KpEBxhfhxPz9_G-DN_KT8VsKgRmJXiB1ZVSYSfKYND4cax-AXyrP8lMDV-_GsvaRPZhCqK8laN14_bILWJNG8IJQxm8DyeJE42RSVtIt30NoemGhij7wrLYNMgYPYq-CctISWT0tilEbBxr8Lio5Nwp8jppm1YhErZR0tN2vXaGkc19v_h7khIojZYgnh_c8mY3Lp1ah1Bxb0pECq4SGzIsK29WyxSUJp5pwoMp9Pia-LXls7Vu-Sc-yNYwRzHh5SnCtx37dAb5Rca_kdbSSBFGqlRFL2DWOT8Lk-pF2GwVqFq-QR1sRcoEn3_JWqLTo0IvRQpmrTfGf0BOHjtEbiRARV_qyec1650ICSPtd1ggmuXxAF6rk_gQsG6nJVFd2Av3ocdwHaAm9xNvB4nUXc6ojHaULVyvs6exW0uFcr0f1OM1f6Slu2uC6n-RitA4iNEmJI5TvWVW49AokP6CzvHsjI0hD6A4cRqbdgbqh7M0TR-burVCOxf0CVnPYeWRRxwzdcYwIo9t0eujHw0npXAazwWjPOC_sRlU3e5tHoB8HF_LD-uyKmNDb8iOdE2Chhh-nhzgo9IeLB3R-JOtF3Br70jNMdmdGy4j7zdE5BGaB9szCsGTtwQInDEhrBgYqytGTWV8QCKjJTL1zhYn5vUzA86971MQTUcmLnfJbo7_V0qVOAM9rLJgJ9M7GTnKaGDSSOznqm55v6c3uI3c2keeBZEN_gwiThWPNuPTTDWqhsgHpIk_9PrpcUL7fEExaI_uWQabnHSskZU7z9qHV0o__SRIkOLtPBn_pCDTbmnALDli0r9Pzub2DGHGyWU99WXIvm1I5ZzLYf5N9TpuTR5IjqMfXsPL_OajkZbokVSJYyNc8V8T_mfG3ySZU-3ciFF5I9X_KOGoqykgIgWMKyCuBngNuzJ5GvpJCUFWzW_WMrqrep1towUg2t6QRbTY6j1YJSpI4Kkf4XdUDZ11sLfFTpuz8jqaFjRrbaDUWYBdqIOLgrROMFDBWhyCZg-AKZHgeqKnaoamMNtyz4vVb9LjuTSIJ1OxHH9vO4OwzgSg4q7OIBBmANHyHNKsH-Yc2roDfxmQaVpObzt6JxDHvCyu1LSRP2MRkJRh5p9lvOVzKjNUOUqm5K4Mxmk-Zj8us', `Progress` = '5' WHERE `ID` = '1127942'

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

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 1127942
                LIMIT 1
# [07-Apr-2025 12:55:28] /rapsody/root/bg/ajax/reservations/send/1127942.html?_=1744019728737 167.99.142.201

set names utf8

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

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

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

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

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1455 AND
                    `accommodation`.`ID` = 19 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` = 1455 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') 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
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

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

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

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

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

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

INSERT INTO `reservation_rooms`(`ReservationID`, `RoomID`) VALUES (1127942, 23773)

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

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

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 6
                WHERE
                    `ID` = 1127942
                LIMIT 1
# [07-Apr-2025 12:55:33] /rapsody/root/rpV4nz0Sa0q/bg/les-2-alpes-ekskurzia.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
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'les-2-alpes-ekskurzia' AND `Language` = 'bg' LIMIT 1

SELECT
                `TopOffers`.*,
                `SubOffers`.`ID` AS `SubOffers`
	        FROM
	        	`offers` AS `TopOffers`
                LEFT JOIN `offers` AS `SubOffers` ON
                    `SubOffers`.`ParentID` = `TopOffers`.`ID` AND
                    `SubOffers`.`Language` = `TopOffers`.`Language`
	    	WHERE
                `TopOffers`.`Language` = 'bg' AND
                `TopOffers`.`URLLabel` = 'les-2-alpes-ekskurzia'
         LIMIT 1

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

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

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

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

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

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

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

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

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language`
            WHERE
                `pages`.`Language` = 'bg' AND
                `pages`.`MenuLabel` <> ''
             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`
                    LEFT JOIN `calendar` ON
                        `offers`.`ID` = `calendar`.`OfferID` AND
                        `offers`.`Language` = `calendar`.`Language`
                WHERE
                    `offers`.`Language` = 'bg' AND
                    `offers`.`MenuLabel` <> '' AND
                    `programs`.`EndTo` >= CURDATE()
                GROUP BY
                    `offers`.`ID`
                ORDER BY
                    `offers`.`TripType` ASC,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         ORDER BY `PostDate` ASC
# [07-Apr-2025 12:55:33] /rapsody/root/bg/ajax/basket/qty.html?_=1744019733635 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'c8dd7184762b0b649a0f36898b481eedc5c1e839d2342a98ebe2c5f5c2cac847'
            LIMIT 1
# [07-Apr-2025 12:55:34] /rapsody/root/bg/ajax/reservations/accommodation/oid_69/pid_1455.html?_=1744019734486 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `reservations`
            WHERE
                `ClientID` = 'c8dd7184762b0b649a0f36898b481eedc5c1e839d2342a98ebe2c5f5c2cac847' AND
                `OfferID` = 69 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` = 69 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` = 69 AND
                `Language` = 'bg' AND
                `Visible` = 1

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

INSERT INTO `reservations` SET `ClientID` = 'c8dd7184762b0b649a0f36898b481eedc5c1e839d2342a98ebe2c5f5c2cac847', `PostDate` = '2025-04-07 12:55:34', `LastUpdate` = '2025-04-07 12:55:34', `OfferID` = '69', `ProgramID` = '1455', `AccommodationID` = 0, `Data` = 'DPcmljohsA-4W1ZZ_prlRwP4NWgy083e_utOKHPC4852rT3Ir5s5ohqqm2ikJnDhov50PmnIFYDbV5yHNsGZ3eRqbTMyj8x7ser4l7YNUWBghyu8vu-3CqpB_qdUP8vntk59dE8PyWtCFBhqkW8OwMdDpXQ9sjq086xr5wY7XyUmS2ZeOjoDfxegXzSjr-9n4lG6ZU_Gn6Rt47bpE0C8zrCk7crp2ir1Gc8zmJQd-PWwjEDmuOTRn2WIM2Sy3b3O_2nxZYdcwPJlupEoiPdLjHORAXFduvtrKVv5VzVCIwg_PcTk1eU-0fxmMNuj20CI-X9PW6i-MP4eUsjmVNN021ERz5P5_MEeAi3jxJEnNi85Xk-q8f9nobeI0N7cCVtU', `Progress` = 1

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 69

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` = 69 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` = 1455 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` = 19 AND
			    `ProgramID` = 1455 AND
			    `Language` = 'bg' AND
			    `Visible` = 1
			ORDER BY `Price` ASC
			LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-Apr-2025 12:55:35] /rapsody/root/bg/ajax/reservations/rooms/pid_1455/aid_19.html?_=1744019735757 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` = 19 AND
						R1.`ProgramID` = 1455 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` = 19 AND
				`rooms`.`ProgramID` = 1455 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` = 1455 AND
				`offers`.`Language` = 'bg'
			LIMIT 1

SELECT
				`PromoDate`
			FROM
				`programs`
			WHERE
				`ID` = 1455 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-Apr-2025 12:55:36] /rapsody/root/bg/блог.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'блог' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

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

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

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

SELECT COUNT(*) AS NumRows FROM (SELECT
                `ID`,
                `UploadID`,
                `PostDate`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`,
                `Visible`
            FROM
                `articles`
            WHERE
                `Rapsody` = 1 AND
                `Language` = 'bg'
         AND `Visible` = 1 ORDER BY `PostDate` DESC) AS CountTable

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LRapsodyBlog') 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-Apr-2025 12:55:40] /rapsody/root/bg/ajax/basket/qty.html?_=1744019735899 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5c2879910ea36bf6f4782b5731506287a8dfe854497b10faef0a2f4cf8ab12aa'
            LIMIT 1
# [07-Apr-2025 12:55:41] /rapsody/root/bg/контакти.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'контакти' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'контакти' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [07-Apr-2025 12:55:41] /rapsody/root/bg/ajax/rooms/empty-bed-price/23775.html?_=1744019741731 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` = 23775 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [07-Apr-2025 12:55:41] /rapsody/root/bg/ajax/rooms/empty-bed-price/23775.html?_=1744019741910 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` = 23775 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [07-Apr-2025 12:55:43] /rapsody/root/bg/ajax/contacts/form.html?_=1744019740170 167.99.142.201

set names utf8

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

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

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'terms' AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1
# [07-Apr-2025 12:55:43] /rapsody/root/bg/ajax/basket/qty.html?_=1744019740170 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'ced5ffc212c1af73353338395eb17ade4a69b98f04d243986fc7932abbab7ef3'
            LIMIT 1
# [07-Apr-2025 12:55:43] /rapsody/root/bg/ajax/reservations/guests/1127943/progress_2.html?_=1744019743666 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` = 1127943 AND `Status` = 0 LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') 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` = 1455 AND
                    `accommodation`.`ID` = 19 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-04-07 12:55:43', `ProgramID` = '1455', `AccommodationID` = '19', `Data` = 'FwSKiwHCIbaj3SEvMj5ZB4io8aC4sZ0Pvk6Tf7TsVj7w0RFc_dRmYr8jdT5vlBIIklaLVJSa2OZ89jfQuRG7fQ5PJ7hMPqOwwVZuS3KDgi6I-tiZM5yitsVv20fpgVeQPTlHA_c8X0KWSaXZjBZdfPiumN8DNXKd5bmksOAPXCvN5epP1YmpchPKy49h-u-TLzK6hwJL8diKbJ2bOg7wVGpOnzLwjAYBAfE6-aE82LGEC8OP59HabWaZluvKononJQhOqIO50L7oOssTXLrn64Edgz3p-S0Q42b3-uL9Xk-HU4PCZHZCeK8w5ik_LBN0aZGSYyDdDhKl_gZnvUy8ewnns2ZyZ-8-Y5LCSZHnifUw90_923OQucPpLuQAla8g54GYAqTvVMlJSmeoNT8c8UXtvAms7cpk-7LT89oVKussXMdqJ5pk6SfYbv6olcOgYBHreqqEPTJPFmDUKH25KzFTqTfls8axoXAzC_8VrSbW1oqgbjHUFxJFtRlFlS9LmmtODDMtA-NLYgh8peoY6AOZsjtygK5AdB21u7s1dkSukFc5-2rh5DERKq6gtxIbxNaKxgPQRaw4To7bi5NBZKbMR3HQ42LZREXp621v55e1-jLJBG8bRyg9LjTg6RXknX6tbieEFPUuc0z39L6pjHM1-a6yfum4PdeUyAx0Ia3OB0shklp-1N8I3o006bdCqk86Y_wjteuJYcHcUFezM_ZCXeKJyH1CbXjWOrLdfoimAbxvIDU6iMPGrQqhnYCVMf6bEyUdnmcgb21Bm4mgGA', `Progress` = '2' WHERE `ID` = '1127943'

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 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-Apr-2025 12:57:05] /rapsody/root/bg/ajax/reservations/additionaloffers/1127943/progress_3.html?_=1744019825848 167.99.142.201

set names utf8

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

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:57:05', `SentDate` = '2025-04-07', `Data` = 'oqbfQFXf0d06RAdgoBPHMbQiBfkXL0Nrlha1inBFVElU2iGJhZcCMpDd4qEULt2hpcCkr2Hg9ie8XO8otIsLE4u-PAe8PvObnB2BXSe_93c_F92RSdWSzetg46vTxZJQRR9bnFqVfzZGY1TSe-mJZqn4SKDbpmvy8pPMfLJ6qQDG9a__kU-Hz4MlmDneFrvZOzBh5erSX7Ui4qjRobJA2OYLopJye6w5oQpskcX7n6JVhSLePaHpRe7vVs8vurPXqupARzglY7xoYUFh_jF1WKgn88dgjuK8QAow8dPE4proEpom_1VdHdjdoB2TlSA3WjfekJArpZ5keARSF1kKi2QhOUy0cu9V5d6D-V3hDoO_Nuna7VDs4WawT0_j8e9Gdw5zW0dBXK-0xHbvL633tzRubGuudVUdep4f7PFHA5ttrleTeJRnKGs6OMF2xOroXnqy1IkSnRQdfE2t3Z-rVhXwPVT9luxpWn44uAsdj1kSg8mbLWsUP7g_BBeD_PgBhxDRVnSZwi_gorIDj-EhDyKU_raDG2p-pkVy3XfKFLxECK1y9uh9O1Z5u4_vRiY86SNGxbECqqq7sPFB2m9JGNp3n19euhIwZc2Uwbo37w3qltxEotaPpUyURrJfBPw0xSIy45mGPMzCoYi_tlt50U0mPoP5yrSBcIFX7BhDzrRzQNPIae_FLIT9M6MeKsuAeKm4SBf4EHjkV8N2rNPTLhs6XIYkbaHm_SZCZw42z2pd-FAlfpK7dsjuZFvJq8pxg9HHeYg8MMYpzIBs-70Q8S6S_DLjfyP05MC-KSvojHrxvTvk9VSNnA16ENkkoE3ZufhCE1AtseoAdKng7Cj8yiHWQsYzZy8gSFw0cRQbEjINHdwMxHI-nNYY4oSFc_3iuIQE2aw7ZvzbV-M2birz05YS-Sm5b7JcuHKobnHjMwlCRbHYfO2PtWwTHKlR7OUZrs0gvRxHDOI-3q7w0gvXV6Z94TBR0JIEEQ1XVyGre6_CUnnF1v7TSXXIoHpO5h6lnUAvOlDvb2fELy7QGVfhkt6ZxySzHjgVtL0E7ZGi7L1_sPBGa1F-_0_I6F1p_nEFEWp0lcqBBSiAofLQrE6Mx3Suo_H5cG7-BN6P3Ny2KOGV7M4lItVsg_CINI4Qxwape6RMJUWQYDqahEOyV8d2aHQZvLbjGuqOeDcahnmyJt9JBes2VRHw-5bGLo0EWMs03883f8pLbhNVcgBq0jvIP1WNB9EXQI-cY4VRuIB1esOqiG21D2VYP-wyxWj3d_CkPG--O_5kXxUhNqcp2_iLkghI424LaiIyPo8dklLa1uFUfpjiKjx_lUQkfPrJji97pxXKo3bp2v1Dty1Im7Ql9CE0VMQOgSEewFOJrp6xE1hJYGrO8utVt0jzD5PjgNf1dME1Mc-nnU7iv9HKoXuy1Fc7BSjrKY640YjVoacxYSB83dF-GLBCkDG0SxN8AiEmq_bS5U7TTuA-UozRFB23S4qj6Bl8NEpyXIL_JXrdRScSCFUqMUiGMcNgK6ziRkK9oMlvXv0FN7w5Z4kmwYkQwaK53WT5mqMK3ALapmIQRkuTteo4xgmPWrxbhe52gxl7DVw7d7p3VPSx0Fx9IO9i_gyO_MZEjpUwL3itv0S0i8_YCIyFK0-Bl-_zXudJAtjQUCKT2cMBQ11eAnPcZ_DP-Ge8CEMaR1f-an2bnzkNpTMRAF1R4cXXgVLnMtBb0ZRFiL_fW23kbPFDFrgIRU5iwsJUPbS6mqyTmCDo-LGywrC_XFWZDsQ5Pi1yAQFVySIbUK0hLdjyAp-suciYx9e2_4vauZETZelrTTf7PW8LDHR7xnZy2lLfCZ2W22OQ9BZGh7e5Ndh7NNnG7w-j8cZZKmoMaTHub0lFNbO0mt1DwuqG5rTEL9uhCMBF6ekEGBwvavW_XMAIm9Dr0y-_C8cvQ36D-e5dYdkHrOLotsp_JcOb8CZDIoIQAfpTybuhA5Y_Z3fXwFwLPbyXp77_D_k9T6l16HCXsmAQ78p2yXwg69-NjurjEs51K8DngVprvoAydcQBgRvXCKgGg-fJ9MLgPosebGH4TqSVs7Pmzny5iByBAw9A4BQN88-ytKhbe6atktATm2a1FEg-tK6U-_ea8CU3mTMQCbNmaVhsDI71x6E', `Progress` = '3' WHERE `ID` = '1127943'

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 AND
				`Visible` = 1
			LIMIT 1

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

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23775 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` = 69 AND
                `additionaloffers`.`Language` = 'bg' AND
                (`additionaloffers`.`ProgramID` = 1455 OR `additionaloffers`.`ProgramID` = 0)
         AND `additionaloffers`.`Visible` = 1 AND `offers`.`Visible` = 1 ORDER BY `additionaloffers`.`PostDate` ASC

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23775 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-Apr-2025 12:57:24] /rapsody/root/bg/ajax/reservations/summary/1127943/progress_4.html?_=1744019844714 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:57:24', `SentDate` = '2025-04-07', `Data` = 'RJPOuoDyemOuvdKSimErnEar5YyqLYzS1qswNckvvEtYxSZuHWx5glzptv4jlFP5wTqEb4D_KOauhN_oaL3J6MZH-nG2_slTAY8P1YeMcz8oJW38He9owCJcwRVDIAZO5Wp_jjhr91mrOT0tI2aqZoijVx_1KAlaXQLSKRL3LgxG46gUxa6TKkqHlWSA2QkK_2tfLbXQSfej82bqtFl74lkzzWJuk5dX24qv9OVWydWRcQiLOUnt_ivBjechYHIbYUkpXEr3ysEP4AoZFk4GC_3gfnaC9d6hfqTRiaW4SXHBsWIssZv3yc-8Nh5eOXgwGC5ROtaVjTet3wvddZXKjGwTeqXyJYr5r6gnu32_BmpAcwaJalzNmS1hN_onffiAkqKFuG5X5nScgDqK08YWwlnBzAkgpANraRMa0dz4BTXDEGOyQPe4_OoDp91AZAXexVvyyK0VkuslUClVjU0ZFZLiUs8clpyJNVMDOhYdu5mEDMuDhI-3lojbMI4PiebO3Vx4-BY7jNyY0LzHKrJ08cmcQH_kBPd2Pen5MxFmeCTRgzfdDHgaqI0BdYtoSx9bOTt6Np-0NjcDcyuquwv-YPCa-ApnxcWe3tU_ylPgjhCGuvrLpPTQyP0hFh2_YpmdDVMmpxqTLZGPwi0WWx9wz49B71MvZMEkxdKJEBO7ZSSiwBZZf-9esGliVKYoqG4vNVYjpMtmZKrDwvsB9xXsp5RX5PFWS3ZrUKyIs7H0qAkKLcuDU5LBGuDiodUSafsjfhyGR4JEMNFBSAo-rjrUGcrUaGDtuSSwmNwHbf1IKsbRun28m-vGsYuMHudoN8t15lxoEmLdRieOrYFVa7GEP_LVSS-Q5taIprwoIsHGTO-1OCr80xNs7bTOGn-blYTr9GOY2TSeCbsPVVeODMeSurayWf3iWn17hV0UwdjVvFmStfPsQxvGtVyvwjLmWLivloilat2uCnomItf_AytaYEH50BPDWqcHPJZ1kOKnPtunuBvD-WnwdJN-K-oVSkKLpKYrgYTDV9skdJVlneLdLtk4J5-nBAWwXOn0qF-Wk2kR2HjLGXsu2bkb6ub5cluIEGP_b_rFpp1MvRCP2esU_zeXGjt9fJREcY2C4xobbQX_eoG5dg9axq_lvAJ8eSmj_OED9jw7awTKnM_EDsY6evzqVYXH944nnGrQ2oU62m2p0SU-J4K2Rs5xgHZVoLH0bv5tnEvWK6OJa2xOm8S2jiyD-bipSwnILcnsL7nxP-i3EIJ4QkUHa9yXv2bqtmsHLzEY2Drf7nilaMN_9uQr149VYwW9t5jVGeqUfE9QQQ6wQQoCPvTL4Fbyg_G-8GZi-zZCoQWG9YkedBEC_QC3MNxD1N8ktiTofqUWJ3hn5V34pR5fyYetUbJycyfY2c3yMiAXhsBqiXw1ItpQJPW3UBX-kFJirD6PVgUgAx5D4Lw4GNDjEEjzK6hXNJ1ixmw2zXQ--f1UoJ7QBAUWWu09sFw_1IjgESBYhsLETJbedLMO4lwtnggFd1WYWS_HUoij_D92bWNBoRFIDnHYrj_-1HgQGKt6P7mRgG3iYf0qYCsIG50FGIkM5Lpg3czbDgC8dULPrQiyyyQMUy29gvr71086KBd1dG100zyho4xnJ_uufmSnDfPqsoD72WX2z4BeXLfWeXjnEUiC4ZNUXnAo4euPMpCB2WrMRs3lpP5qK1OzU2E9DNOB_r3QiCgiUOyB05J8jYY9f85LnxnwQK6t8oyI9CB41BW5sWbW9DDRPTrsZKpW9vV-gLNMidZYc9URHMLkap1JTsigQjnxvVRGxOP5WXO2sBuPyoHM0-Ip2Yw_i17zx4lbYBGtT64jlsXs5vjCjOf_o0r1ePZzbgq_WPpRu_66NJaw0-7589b_jos-vJ0mm8kPFfbGk3NMzzUeUj0DE9d6CpFxVkhHtDchysELeMz77F-jKuOBZyaNKLkvz5CGlG1LMYpZEz3huxvR5rR-YO_SgTJu-hdJ7p7qbbec55sZbp-9H3g11yP3C3WlodmjHpAftZgN88F_T1hlw4eeTY0pRpFilL_g0D4iOKpeCF7nXweqFRECK9_Yt7W32eQoVlycUSIOp8gpJDwH-P03hdNEIUAquiLYhUjy62NTME6LFn2MP8wNgb6rPFoZXX8rIu-zGfr71u9Tw4OAoZlDG1v3f4YM5WgtTt4pR7GJLAhFQfKgnyfdv8wWXlEdOwJzsnByG8cgcxnS-G9LrVxPrljGBKgVBEcFYkIgNMJ_DtGmx8J4adAIIur34vmuWz_RLgWkLT1uJM9BCcNI', `Progress` = '4' WHERE `ID` = '1127943'

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23775 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 1127943
            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` = 1455 AND
                    `accommodation`.`ID` = 19 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` = 1455 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `ID`
            FROM
                `promocodes`
            WHERE
                `OfferID` = 69 AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                (`ProgramID` = 1455 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` = 1127943 AND `Status` = 0 LIMIT 1
# [07-Apr-2025 12:57:28] /rapsody/root/bg/ajax/reservations/confirm/1127943/progress_5.html?_=1744019848866 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23775 AND
				`rooms`.`ProgramID` = 1455 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
# [07-Apr-2025 12:57:39] /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-Apr-2025 12:57:51] /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-Apr-2025 12:57:57] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127942.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` = 1127942 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` = 1127942
         ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') 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
# [07-Apr-2025 12:58:09] /rapsody/root/bg/ajax/reservations/accommodation/oid_184/pid_1454.html?_=1744019889412 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `reservations`
            WHERE
                `ClientID` = 'c8dd7184762b0b649a0f36898b481eedc5c1e839d2342a98ebe2c5f5c2cac847' AND
                `OfferID` = 184 AND
                `Status` = 0
            LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127940 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` = 184

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` = 184 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` = 1454 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` = 587 AND
			    `ProgramID` = 1454 AND
			    `Language` = 'bg' AND
			    `Visible` = 1
			ORDER BY `Price` ASC
			LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-Apr-2025 12:58:11] /rapsody/root/bg/ajax/basket/qty.html?_=1744019891009 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'c8dd7184762b0b649a0f36898b481eedc5c1e839d2342a98ebe2c5f5c2cac847'
            LIMIT 1
# [07-Apr-2025 12:58:11] /rapsody/root/bg/ajax/reservations/accommodation/oid_69/pid_1455.html?_=1744019891853 167.99.142.201

set names utf8

SELECT
                `ID`
            FROM
                `reservations`
            WHERE
                `ClientID` = 'c8dd7184762b0b649a0f36898b481eedc5c1e839d2342a98ebe2c5f5c2cac847' AND
                `OfferID` = 69 AND
                `Status` = 0
            LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 69

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` = 69 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` = 1455 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` = 19 AND
			    `ProgramID` = 1455 AND
			    `Language` = 'bg' AND
			    `Visible` = 1
			ORDER BY `Price` ASC
			LIMIT 1

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

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` = 19 AND
						R1.`ProgramID` = 1455 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` = 19 AND
				`rooms`.`ProgramID` = 1455 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` = 1455 AND
				`offers`.`Language` = 'bg'
			LIMIT 1

SELECT
				`PromoDate`
			FROM
				`programs`
			WHERE
				`ID` = 1455 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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [07-Apr-2025 12:58:12] /rapsody/root/bg/ajax/rooms/empty-bed-price/23775.html?_=1744019892014 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` = 23775 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [07-Apr-2025 12:58:16] /rapsody/root/bg/ajax/reservations/guests/1127943/progress_2.html?_=1744019896769 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` = 1127943 AND `Status` = 0 LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Mar') 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` = 1455 AND
                    `accommodation`.`ID` = 19 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` 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` = 23775 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:58:16', `ProgramID` = '1455', `AccommodationID` = '19', `SentDate` = '2025-04-07', `Data` = 'Ru6u0oEb9cK-ASBShT44lOJbzv9NknXEgeKc-omK6hO1wW4H7ON6gmF_gf9j2VFseYalgADOEd9U54ANLer-wOPRdUFQXyz_skRT69IhpCiLNheRd_IL8kpSGit4UvZgfOIXMAoRAnV9sE11sw4OXCA7BTDIEoqwHg7f9tmtRTloFzb4RJZ3xEPyOkVSYa871t4EsSLDCXY4q3O9M_TMkHwkK4lQsXc-eWafRe84dF5a0w1r6L8WNPWy2FnT8c76p_geEvpkCq1r9h5b2GoPpVMehHKnZQcD24k-h6I5w_-WY3eVDpj_RViKalWlOv4w2pdn09mhdHaLWsgvhCFQDHHInWEyVS7oGH8yTzjHfw19NAWgdI61L-5HgWahhblYA2aSfqFEOVtj2ChiAjaOt2zjVWS6_MlDK7pMb-hASVj8pYSrqyx0LbY7J-11psNFJOmtQx2MIxdbO2YbUNhBPqqidbfEIOtBYlxZgl35Qd4uCyrwsUBQdGmWDAELQwTZWm4XJePDxVUKyKB01kxeQRVsczmAa1AVqMvCd1hk35isWbDTkBr0O8X3OI5K7A_mwzxudtfRap-49lJ-HL_hxV4vJgeBWjGH8pg_tjMUS2GvXK5JfpUP9WzQINnfGBTkZFEme1xB4UTr_WASJwFyGKItZuDf32wk26Bb73ylQzb2JS19L3ALg0S3ARkrE0r1cPOEU1aIOgqSX7NaMo9gl8r2flQed9SBgIUG2B0i6l8JzaeMaYtBTqSoTOLsxrGyVyvf7aVk5Rj7Uee58LBSwD6n-qC9Vw2K0hJnKWz4cQVW6_Imlk76odrvBT0GAycsOjRkK1jbD0FkT6F48FYWjSDfFrXNrphyym7ZOkvG3Gc-Lg3Xk07yaXv_DQlGJSvox8GUqG8DNoyClWaoG8tS41Fu9Sq2g5ZeOwge8cEAJSoj6_aDn7ywCAQXiH8u7FZgFAS4C86DKAonIXJyXCpvwJ0jvVO3k5pnnW_KlVypdQTgCHna0LqgPO-8Kvs_gM9lK0xcRdyQtj2R3SVhyKcHEtk2OBFdU_lKJJsgykmM-H1kK2R7EU5iu70wOz6PmUYVAZjdoo9yTWqb7lp1i_NmSH4qBQpU-fC0tAPabcbYrZajjC1oRm1yTsuVNyk8hbFgS_9FRT-cELmtScZmVGtyd35BX5Qp6Bnw4jEFTurYNnd2wZ_4CDhw__kNDl21-dGWXyqaMnt-1UIg8pNozwhaD4WZRKE8GSPtlqtFe60OoHH3UwTIDBY491Wlt8lwwnBT39KJ4tyiwnDOYdt_LRxC8Wiu26KjDzUsjb1D6u5kNJnDS2kJ4ycJR4G0sV_2gg3Hi_Nmpc6Yon7QeeAKiyMQ8yQrwgBEhUxzhjGx8MRZP392CSO7KoaDtdnh2mQy6idiq-54QsNQr6o1BkiIzWxCMPBef2O8VMHoE3hAIZ07SkghNzJ9u12mh8ktMV_MuGMwjnXnRDdrWOJkMx8UxyPj-JpCReWao_by7NenaXgGrQhBw0X0VkRsIfNJHC3avJWonQmYsGUwDJJcrcdbZXA-m2p04szxoVS38YZDoU3OXFQEVTw7yQYEdJ6MguxhC61kycveuR0tTMYEnuV3v_xVctfV216ZUKV_wVDm9zR0LHkjHWmK84Dxj4zi4oWisQwbsVUOL3Hv1dAmuV2fHKhg3cDCyT8MjcxRP3uHh_6lpm4Ok3rqXjhtLrfNkcdUfWQ7yuiFb8vk5LX8lRdzk5Qacw' WHERE `ID` = '1127943'

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 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-Apr-2025 12:58:21] /rapsody/root/bg/ajax/reservations/additionaloffers/1127943/progress_3.html?_=1744019901258 167.99.142.201

set names utf8

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

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:58:21', `SentDate` = '2025-04-07', `Data` = 'mYj7iY47qHNixBxd7NZZ9ppKTymOr1KXRbd_G33XJYl8oK7fED_zB0XmZ6ltdo1sQ3wIHVRlTiDyie5RLG_lq5u91xGwT3dHk1tSBL_32B-PSMj4Q5wrJyJc-Ev1kOWwHvtPBIfV1puWhXbyJ7Ew758_Z0W9z09_Hw4fpf-xbin2SIv3EtB-z15VCelpcrzslAwFp5mSA7ntYEJt6AgeshkUz50LN_5tz8439nCzjCx2Ot_ApKt3TdaC-TLAjgAwYZ7s9GHGg7fDAgABIpIpRIB8iq9nPHIckcbFTRAElGB_WC3qLRu6FXgGkS0kBnyFtF2V9JYgFwBAQwsqNNALbnG_KswOvw84rTwEJGY2coB5NfWEPQ45S5oPYXJW454q4JpxfE4zZxno_NG14g8vtdRyQNrl23mZzONBPyzGTEQ4PtMzNzgcWPxCrCqfKHa5kf2ggzOJ6o9N-A9hYXh05HrV8839LyhIYuZsdvemp0OKemCgd6jmfy6gM9__lF5o67LJGhrsdTQ4DsSID5ANsN7ifCNP1eC3jscf11h45IvRHtd3Qtu65VSUaTEXAoqJFAtgeqPuLiKUBvAhzG1b0dwgOrCbNYn-Lwzahl23AAiCdr2W2TZQrVuIuRyANAidE-OJzagcLJY__fvExq8kFxp1KXKoE5UJvAmPSsYq2uNUTSiTrLygQ3htF_22IqJm94G9V26O9fBxd6KxXbqNEBnRfHMTRp44X1m9PNSurZ4zbfjGdaTRqN9xIrF3Dnw7nh-GTW7PU67lYr6ZlOH2ZdZgSqzPcSVOODCQ-29Tmm-d5IaR8OWlgpNa9Y_q-NexpqtUdPxriBnFJD3wc2uH9IH96EzrmtOTR3uE2P-0hr-5Rek0Iy0dlTINoI3GShWC6M-1zItw3Yd7BkbXjaji_xzp8b0b_TUfZtYt5sQxInW8TT5wQKHLbY0a_iPQl09ogiHolWlkXKprIO4IcdA1gJ3T_XtnjWqTVF2Wu7gMAZ800tks5Fkjtqs3PYc9vRte3BgrFFQc2Hmhl0yPSjmWPeEoXg6OVDWfaB-EdUq2mJbVkxikG-jML9swGumCcDhIhaW25JcJmwOXqobe_Y4H_0A4bjaXgLsQu99zx3bZLqnw_NXQo6S7Je1oBp-_UZysAjdxypOZ-iDi5aKB3Gbnio_lEuTTOQJESwtJ0u1HTS0vDinzCcFQKrvG7x0CCAvVIyep_Zn1WJ5GBhFWYVk3vO2FrVmNOyTh9GgZYb8maar03Rk8RWBcqouKQpf_0iJa3SaVtb1iRx1Ji-03rNSl0wgiDck8QTpafohSLPxuMv_-bbBdUxcgIJ9xV6q8atx4vgsIlh9qiseosCWiIzLRFWxOk0t-AvmUnoSrljb3LkcP5xUhhNhFRjWvoZaaKlrolU7ghZM2yxa-mfowZQBfESuqMhWyS9otyDOVRYWUIE7wniLl48WxdMbQDHi8_jIG-LYORTqulaealejgOuM-umpWL6dHlDttO0jyvxMYftt3YNTeETsXQe4tJsnZs7qswpDCSDBP8_P79Vj-O0tLwTTPPpRKUzZoA9q4ObXdu0qQb7endxfOiY4u55eQocg91bV9Cp3GEbdNaQcUOfbuanvqwZyC9p_yYpPu8XNg6RUaBXirVitKxHBh5y2Q-aGw0gIZqRf4DxJ6IuZuL8NhlZmZ8NAwj4p8uqLBRr5i8Lw5KTvzurkMZ36y9UIQagNQW8Z88j56uJuQbvDezvNZdJDaU1uURYFktUclzyfQKlgNuVdA9WIR1aAozNlWgNxRl5LjNs2pQOVAD0_VjL_lR9YIu0YNz4xO2gFu7WWL2DcumL5Rj_P6ZtvD65_YHOZxIxGtxF-yDhceLe3G1OUfYY5VlQuzYy79ssDRJqofdhWlurtgotP2qeI0TK-IRbNbE-bEZvwRDGc1iFRdmoBf52kJleKO2ZTj2TI-PrdtbndqDqdHMtEpUKGme84vIUHF6CdNW63_JjaE6CRbx6uBUp1490UutCn9mdESMcun6-Ygwjazao1CSkltpbOgNwBLNODreo8c0Hp4epC1wnRqS3TgP5dEULihl2Wd6pLQTCOTOD3tSL7sQT7mA1e13hr2RxDtf7azw635lEAsKbT5mz_xbwacAqYArw1apQxu9Z0sIQ-txUa_aBUC_k4moNvAoFp4VuTLYvBnwIpOuHWwdfcAA-yFFFqm0szoobeARMO_n2j89261NehxdXa06XMyI6nmYOhmZTmEOKCNx37rsKzDtl5euzOm5ImOt6BUq6c' WHERE `ID` = '1127943'

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 AND
				`Visible` = 1
			LIMIT 1

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

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23775 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` = 69 AND
                `additionaloffers`.`Language` = 'bg' AND
                (`additionaloffers`.`ProgramID` = 1455 OR `additionaloffers`.`ProgramID` = 0)
         AND `additionaloffers`.`Visible` = 1 AND `offers`.`Visible` = 1 ORDER BY `additionaloffers`.`PostDate` ASC

SELECT
				`Title`,
				`Beds`,
				`Price`,
			    `PromoPrice`,
			    `Child12Price`,
			    `PromoChild12Price`,
			    `Child3Price`,
			    `PromoChild3Price`,
			    `PriceEmptyBed`
			FROM
				`rooms`
			WHERE
				`ID` = 23775 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-Apr-2025 12:58:25] /rapsody/root/bg/ajax/reservations/summary/1127943/progress_4.html?_=1744019905150 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:58:25', `SentDate` = '2025-04-07', `Data` = 'Sd0b8xVYJJlqHFzv6_bVQ86GPGbrDHaM56DSRL81j7cSl-LIC-eS26kwvhUeXDbDCuyX4ex5Xh_izkDHYeOcH0waLZDLuxI-w7Qz5ITvKSCzyZth6H6sLms6vkjXuZGQqQT04ZcAlaW6jlJzyxt02rYPy2tMENTxGMwJTQG4dHalXQaFk1V7tA-_WTyrPXTjBWmTPqVVocmwc7SMatno5Y8WzSm8ywLq8hMAAZO6dqKWSKxX8S9q0YU3LyNqZKmYd5Y9-7QdD79AuQCwHbRcZ48fRW8K-414zvdvlnFny7F6TrtsWSdaKtJCJULUNLC9LdIPMFLPmAmaiDkrOrZbqw8DxVTGFzBxKCFAYyNYNQjNRoROqv3GWptVlUQKX8u_6KeCyGX67LaRMDHMeIK4EV3an8d0TH15oAtEwGfqMS4w9leMEBvkmAOYigihEW0QVYrvZ7lj4BV-iDaIqmsUAX-seYJJhd5jtovVZLIu7rBZSNG5Dil2DEp7I7eW9zN4OTm_jitLhuIsfs_KrOYWxc8roLJP1GWXqDaXwVTpLfQI8eoKFxlqvRJRBtyXQd8sZOwCDrgs_0U8MCOlJLlxEaVmkKc3QzQUYzDSlomPYOyo73fTSf6ccXk_W6v5zW8_ixSady9mEU00RcMjCV6NqCxfYnF-WzbOldOpfryogUcTpeQBcjO8lvVkoP-UHuiJifMvZyMRJi943gIPCDSGVAcIVE0OQoDpJnuwiqC86MsKOSz_GfAbgFJN_3obW5tOok7xkvJkRf_u3d6x_L9IZPozlW41C5UjRyzZBF7WHogj84PspOBod-wsMbpQFlvi0UzNvXbzW5VNathcYNo-2RAxCNLzXFN0Geeiv6hVhFAemzENVDLsdpX2LblwVefqUm8LXCY_PH7ECROar6Jyxz1k8u56pQ3ynl7chHTip1OxtHDCQOhcjgntQ1ra7rjoQTxwDerXyUH6YfSEfsfw6g7IPeujSyOY1aEm6ic0hTpyBQBiOebsNwTTbdXRYPjH-3XwUW7iPfHf8-8GFNvrhWXRsgnx5MsNJ7tfDQYOoAR3tufHHNC-NCXyZXoaZwVh_48o1Scd-EkEQ0khBDpBmQm-P3myFiYKRleZwfcDsiPtFCmvPC2Rqc5NUS5M04aW_s_wGXyAUUPO8AIXhxFoBL4VzAenU8KqLYQrAHT2WUJTw3J3p0Gp0cMvUrTeAaanGSLVs-w6UkC5MA3KUo04si6xRqMgKILyXL5Iv5N0D82DQVnmrsgytqlFw4FjxCXQb5qRiWQKnn823fpzq4FSAix_mG7EPbG8BcQaHyL7NeEm1F7VyhdoMzp4aMeJthglXT46APCgHLBjHVlGL7y-uQPzxaVfjlMmsZHDSHlrNxhNjT5bKm9shPPMpwo0b8Ufj0TB3pDG1YPJSr4BM8sJFD5dVtadI9GQyOn_mgPDobCxlDM_QXhXVAU-fcJdtc243UaF0G6j28rwxfe8_vn06B1t_VB1ZmGQn88otbDkkwPE2Vve0iZX-Rsl401etAV4a8sOo9s8wiLftFKWOAMXq-yaFZfaYF2BzRlGNarIJAUmOOnJ3FBAnxkbvcHnI7O3qd3HXhUPhYWeJh2H83vXR68LSn7lmv0LXt_XLh2Aw9DX9fDO_HHDRYfaxC2XOFRBWItuAHYCNmSWhm-mMotCpnTmKOvhZJ7q235NN42bLp6lTdtW7BfIBMrd6oN5WOn73CL9TKtA_LOXrR3n3wPdra0jzp8KAPnoQBEPPJjw7X_V0ZT8gzGdWl4rc0xbXS7hQnKcDqEq7ugqf73VOEJIsEMEPFJH6i1ceELOQYtActC5eexSFyedbmlaUIZYH_2dQOYi32V8f9bamKn1fq24-O3PuIFNfjbv3kPoMHZ4dCIH2WvtxdDZrHJ8eRTrGlGve08L8XVRYz0quME7t68mlF51L7gCntytaQKGBd-9IYcWfhfEHeVHxlimOMfTJ2EEqIxxFmObxxcyEuo9V9Gs_sK96C5H43YdHpOZFvpkmLDMspZkaexrF5BswASfX_AB-7Eh59vCwJU1EuW0rM7_9KE5Ei9Ot_nZsjNL7oh9xzmY41ZrXEJ66kRWRiGKG9kOtC-8VZuxG3MqfiB0mzKrIfKoWVYChqfocrL5T3wsz77Uh6am3hlLpt8SDvWJldN7IWTV9oxI-4yCXo1H5Mx0BSGhDOeiwuoaw1_Cd4dYZLJhkWlxmU_Ql2DCYwL0Dh5U0ayrVClhd4TDPHGhfEDqKxRRjxCjvawaUpzpTpMWLIpzYKXkODYqZJYN7iREDui2acDtiknzfts6W5NW-cud2hDvdvOq1B7_00U4xaTFb-I' WHERE `ID` = '1127943'

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23775 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 1127943
            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` = 1455 AND
                    `accommodation`.`ID` = 19 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` = 1455 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `ID`
            FROM
                `promocodes`
            WHERE
                `OfferID` = 69 AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                (`ProgramID` = 1455 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` = 1127943 AND `Status` = 0 LIMIT 1
# [07-Apr-2025 12:58:30] /rapsody/root/bg/ajax/reservations/confirm/1127943/progress_5.html?_=1744019910606 167.99.142.201

set names utf8

SELECT * FROM `reservations` WHERE `ID` = 1127943 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` = 23775 AND
				`rooms`.`ProgramID` = 1455 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			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` = 23775 AND
				`rooms`.`ProgramID` = 1455 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` = 1127943 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` = 23775 AND
				`rooms`.`Language` = 'bg' AND
				`offers`.`Visible` = 1 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1
			LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-04-07 12:58:30', `SentDate` = '2025-04-07', `Keywords` = 'b2ZmaWNldGVzdAdnYbWFyaXlhbmFhYXZnbWFpbGNvbQbW0', `Data` = '6CLI-ezfCWAdOZBNT4qNohe_4KP8HKpXk793owaQUwIPZ16DiqyGNyJv2LWch4oDch4QTQsnEURlzgm-GcaOrQQ9xp91f8rpbn7WecJFOHwjpyoVzBQHV-FOA5U1FZOV3uRpp3Fgmp8gV7hH54ce_oVREp-4_mz5h7DQ2zzfTj7al7uvZRzPUSPovHEL0__w4NWZgm3CkSwvLN5oo9a-wQQP3A3FMvy8sI8o9eZSJdoufS2mX_cqFo_gc-GOPMJ_fNK3NmK-wDPA7nslNvGaYZ1x-cx8VRVy0Ifa-VUL2p5hbfORmTYr6lqi-TH-VClMbwokESEgtrmfTsttj1iLuX6ykRYrKDFA3akTUNvwI553Ph4vK1lFBOzud4mZ4eHQEK-BCpNYfwVXwitYvqnwiM1TTSIbryfOQf1hj4VpWP-JN42ybqfe118lSakAWySKlAldsoigUXT4U8Ds839zxP_-THla5KS4va7hTvrqC6u_Dos1iYk4KWjMA3NpSy8H4CmEWe70wpbaki7VSR0mwVBSoHF4HpIBmKqMEMtSHa_pN5L-fhv7i9c_pO-C5tDMU-MQRYNYqGk04Hibezko2mvUD9KBH8Il3sf_vmBSiipKDwNnTLoB7qz-9lQsaK7hkBYZxBnuzkXDvc2EUCUlfID9_tC9dKZrPIOQMX8M-fY_BRyG8aVUdWQcBc3UPW89U_kfy9fwZ5XEhzWga07DLMw6HU3eSMMNptV04hVc9PccOfp_RlyikHGSkBJ0zWrJl5NoXqhEibGNXhsdEIyrjmFxg7hYGGDiBbOlK2Jk8xNyzy7S_dWWCyQOZUBmmHo87VkRS833NVQoSExJaAr62L3alKfesGQClxQiW36_AY94HiR3hO4NzflTdRsOKKGPZjnxjavGIEL9yjAOUIXaEBGwY5oybGZR2HVpkTFLa4UNPjs-7b5AIkP18Kn1fvnKeUTRwflVaA-D-8mNSUFSk38Io5gWZLn7uchT4oRJPJUnKWHR2K_BjkcA717MeYSIYweKzGOYdysj67FDpr1NEYotSp7wh4d29IhNsyK7wqA6QJmiDBnoozAUo3pXRN4hIdfhv12R5sep0wd8Z8mSksZBrpACw4HS8DakeR9n_1xvE_o7UMnzyeMzmguceVH4E-KUfmPsnoEaflo8J8KpCTMfdroHXlnARHbIKZYghvpuUJrlauCqB0bw-m1zgUN2VDGF1XZYMLKoutHDL5DBY4L8B9nYgAJFNPkwWVHX8w-5ZPzB5DZcrWQh7OUV_T_7Tp-wNv73b0d78HJ04uWhRH5bXJQymfl_kRmjZzNhcHjymK3OW1K_hRM7AYSKG55-bEC1Er7LBUFQeGcLqmDXxEooyizd2qrd-jRAaEKHK0wA5wMbQEDU2AUR9ob9sq70RWqtksiYNVwooaQO3jjjKVisb_6894LZbB9nh7zaNAQCmBLjtt9fyLodMXliMDgSSjrWe5vrMYCThm5Hbq7erCbOMXCfEuPPM8g04OG0v3IpYfqjyAzktbSa2Nvc3B0n_Bsk5qwJN67bfITYQ76qAYlbPtElIcMEwJUl3Xo5XTafijEFOpwTVuUyTw7zXQi1cCZ0TO-4f21qeCOMksjhUj-yoxAdwFwB23WFJIbSuR1hX4RlXNvzri8MI8DJer8INTRMedy6Y6BXndqWKZURP2uMPV7YwTN8o2FuHNUHEgRN_7iikzHqjkmFyKgjazWyi4IqybapEheQPikhKuXDqWKzUh1DplitqrKMzrRfFj0PCgwTjVpkA2atQKURXCZ45JXYEfJA5uTbz7lv7yHQGKgqAEezIseYp8NRrRv6yqjeTfW8FHPK9CFpyMR-XRBYXSQXwE9DKVMvbhDSGv4GLb8gCqJAV6-YZ8PbKohILBndqgUlTOqwntxPWhHaPFzCmzZvhrnsel-7hDnVKeBL1LmfdS8K4jBX628LBfkt6QcgNCCabWE0zyke5LxgGLBkZLuWplfO5uMKGjwLxq9WCzpPzSe2pOIhquowqNsJVIyzbMFaeLKhuMGmAShm39FlDZZ7A-PTmCe8aNfYKgGYcpiOXOeEoGtqXbhIqNI-HY8UPjS0VbfzM29o7SFf9fZvYYTCcoSw_0QI5Nvn5IZLpYnltUgCT41l2xuhfhT_x_RA81glQ2XWdsS8ywGk7m4WHn2bRXHNXBsm9EO6yrPGiK3V8kMFXEhClaW-s0wDEi2kixJFTsZsihCkAn1lhm2JSd_N91xBvq92YnluMMVk-zzKL0_rT-m8ueZv4RjS0h2BBDOH00nFL05f5UaDRsEEsbUPNjqi0oh72N467ghKv1kBQd1ROeqboEprkcN0b6aeH_EHGex-FIsgStNVV-CGMlnXaJ6zbVSWqHJ9jA5SQl2l2PfNJ_r0gg1BYmELZy7QHst2YHlCSkMMqEYieI0wrw_NSJ61aRFDkUu--q1D6C6LU2jch1cvum44g2bTpflN9uMggUP-HLNVrtCp2Vi-fe--3VUVUBGUENGnlbUKg-fK4NpNfdoFc2nV_7fU1-8', `Progress` = '5' WHERE `ID` = '1127943'

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

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 1127943
                LIMIT 1
# [07-Apr-2025 12:58:30] /rapsody/root/bg/ajax/reservations/send/1127943.html?_=1744019910652 167.99.142.201

set names utf8

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

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

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

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

SELECT
                    `accommodation`.`ID`,
                    `accommodation`.`Title`,
                    `accommodation`.`Stars`,
                    COUNT(`rooms`.`ID`) AS `All`,
                    COUNT(`reservation_rooms`.`RoomID`) AS `Reserved`
                FROM
                    `offers`
                    INNER JOIN `programs` ON
                        `programs`.`OfferID` = `offers`.`ID` AND
                        `programs`.`Language` = `offers`.`Language` AND
                        `programs`.`Visible` = 1
                    INNER JOIN `accommodation` ON
                        `accommodation`.`OfferID` = `programs`.`OfferID` AND
                        `accommodation`.`Language` = `programs`.`Language` AND
                        `accommodation`.`Visible` = 1
                    INNER JOIN `rooms` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`Visible` = 1
                    LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
                WHERE
                    `offers`.`Visible` = 1 AND
                    `offers`.`BookURL` = '' AND
                    `programs`.`ID` = 1455 AND
                    `accommodation`.`ID` = 19 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` = 1455 AND
                `Language` = 'bg' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') 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
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 69 AND
                `CardKey` = '69075137c6b57aba8cb48aeee4b1654d' AND
                `Visible` = 1
            LIMIT 1

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

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

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

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

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

INSERT INTO `reservation_rooms`(`ReservationID`, `RoomID`) VALUES (1127943, 23775)

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

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

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 6
                WHERE
                    `ID` = 1127943
                LIMIT 1
# [07-Apr-2025 12:59:28] /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
