# [08-Apr-2025 10:02:21] /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
# [08-Apr-2025 13:02:39] /rapsody/root/rpV4nz0Sa0q/bg/ajax/reservations/status/1127943/status_16.html?_=1744106558896 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

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

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

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

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

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

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

UPDATE
                    `reservations`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 64
                WHERE
                    `ID` = 1127943
                LIMIT 1
# [08-Apr-2025 13:02: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
# [08-Apr-2025 13:02:48] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127943.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` = 1127943 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` = 1127943
         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
# [08-Apr-2025 13:03:29] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1744106609716 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '8c4zUbRM8xDIG5yO2UB2sSNRm9Dkv5FQQE1Z5GxTfVCru433hBh82C7V1iL21W35'
            WHERE
                `UserKey` LIKE 'w5jCmcK3wp3DpXTDiMKVw6fDo8Kyw47DrMODw5fDmMKswqnCsMKVwq_Ctg%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [08-Apr-2025 13:03:31] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1744106611859 167.99.142.201

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS Access
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = '8c4zUbRM8xDIG5yO2UB2sSNRm9Dkv5FQQE1Z5GxTfVCru433hBh82C7V1iL21W35'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1462881527
            LIMIT 1
# [08-Apr-2025 13:03:32] /rapsody/root/rpV4nz0Sa0q/bg/pages/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
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [08-Apr-2025 13:03:35] /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
# [08-Apr-2025 13:03:39] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127939.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` = 1127939 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` = 1127939
         ORDER BY `PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:03:40] /rapsody/root/rpV4nz0Sa0q/bg/ajax/contracts/form/1127943.html?_=1744106620465 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
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ID` = 1127943
            LIMIT 1

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

SELECT
                *
            FROM
                `payments`
            WHERE
                `ReservationID` = 1127943
         ORDER BY `PostDate` ASC
# [08-Apr-2025 13:03:43] /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
# [08-Apr-2025 13:03:46] /rapsody/root/rpV4nz0Sa0q/bg/reservations/contract/1127943.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` = 1127943
            LIMIT 1
# [08-Apr-2025 13:03:50] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127943.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` = 1127943 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` = 1127943
         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
# [08-Apr-2025 13:03:52] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127939.html?_=1744106632857 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127939', `PostDate` = '2025-04-08 13:03:52', `GuestIndex` = '0', `Amount` = '431.4', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:03:56] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127939.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` = 1127939 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` = 1127939
         ORDER BY `PostDate` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:04:44] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127943.html?_=1744106684152 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127943', `PostDate` = '2025-04-08 13:04:44', `GuestIndex` = '0', `Amount` = '500', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:04:46] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127943.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` = 1127943 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` = 1127943
         ORDER BY `PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('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
# [08-Apr-2025 13:08:12] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127939.html?_=1744106892585 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127939', `PostDate` = '2025-04-08 13:08:12', `GuestIndex` = '1', `Amount` = '80', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:08:15] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127939.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` = 1127939 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` = 1127939
         ORDER BY `PostDate` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:08:23] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127939.html?_=1744106903759 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127939', `PostDate` = '2025-04-08 13:08:23', `GuestIndex` = '1', `Amount` = '200', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:08:25] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127939.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` = 1127939 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` = 1127939
         ORDER BY `PostDate` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Dec') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:08:54] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127939.html?_=1744106934840 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127939', `PostDate` = '2025-04-08 13:08:54', `GuestIndex` = '0', `Amount` = '537.6', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:08:57] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127939.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` = 1127939 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` = 1127939
         ORDER BY `PostDate` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:09:19] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127939.html?_=1744106959006 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127939', `PostDate` = '2025-04-08 13:09:19', `GuestIndex` = '1', `Amount` = '7.4', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:09:20] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127939.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` = 1127939 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` = 1127939
         ORDER BY `PostDate` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:09:48] /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
# [08-Apr-2025 13:09:59] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127942.html?_=1744106999214 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127942', `PostDate` = '2025-04-08 13:09:59', `GuestIndex` = '0', `Amount` = '600', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:10:01] /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 ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [08-Apr-2025 13:10:24] /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 ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [08-Apr-2025 13:10:41] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127941.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` = 1127941 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` = 1127941
         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
# [08-Apr-2025 13:10:56] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127941.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` = 1127941 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` = 1127941
         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
# [08-Apr-2025 13:11:07] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127941.html?_=1744107067332 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127941', `PostDate` = '2025-04-08 13:11:07', `GuestIndex` = '0', `Amount` = '300', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:11:09] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127941.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` = 1127941 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` = 1127941
         ORDER BY `PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('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
# [08-Apr-2025 13:11:27] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127941.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` = 1127941 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` = 1127941
         ORDER BY `PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('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
# [08-Apr-2025 13:11:44] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127941.html?_=1744107104076 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127941', `PostDate` = '2025-04-08 13:11:44', `GuestIndex` = NULL, `Amount` = '900', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:11:46] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127941.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` = 1127941 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` = 1127941
         ORDER BY `PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('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
# [08-Apr-2025 13:19:54] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127943.html?_=1744107594781 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127943', `PostDate` = '2025-04-08 13:19:54', `GuestIndex` = NULL, `Amount` = '700', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:19:57] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127943.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` = 1127943 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` = 1127943
         ORDER BY `PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('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
# [08-Apr-2025 13:20:34] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127943.html?_=1744107634892 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127943', `PostDate` = '2025-04-08 13:20:34', `GuestIndex` = NULL, `Amount` = '1000', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:20:37] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127943.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` = 1127943 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` = 1127943
         ORDER BY `PostDate` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:24:45] /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 ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [08-Apr-2025 13:24:53] /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 ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [08-Apr-2025 13:24:55] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1744107895100 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'UEm81LApb48ttQY0N58ia67Sq5ooNSxoAP6N4QkvJzBFRnBMJPTDq4Q6xUZ1oVBU'
            WHERE
                `UserKey` LIKE 'w6vCmsK9wqjCt8KhwrfCrMOew6LCpMOaw5vCuMOIwqXCmMKr%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [08-Apr-2025 13:24:57] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1744107897683 167.99.142.201

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                SUBSTRING(`UserKey`, -33, 32) AS `PassKey`,
                RIGHT(`UserKey`, 1) AS Access
            FROM
                `users`
            WHERE
                RIGHT(`UserKey`, 1) > 0 AND
                `LastUpdate` >= DATE_SUB(NOW(), INTERVAL 1 MINUTE) AND
                `AccessKey` = 'UEm81LApb48ttQY0N58ia67Sq5ooNSxoAP6N4QkvJzBFRnBMJPTDq4Q6xUZ1oVBU'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [08-Apr-2025 13:24:57] /rapsody/root/rpV4nz0Sa0q/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [08-Apr-2025 13:25:00] /rapsody/root/rpV4nz0Sa0q/bg/reservations/list.html 167.99.142.201

set names utf8

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

SELECT
                `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
# [08-Apr-2025 13:25:03] /rapsody/root/bg/reservations/list/page_2.html? 167.99.142.201

set names utf8

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [08-Apr-2025 13:25:09] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127942.html?_=1744107909029 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127942', `PostDate` = '2025-04-08 13:25:09', `GuestIndex` = NULL, `Amount` = '600', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:25:10] /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 ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [08-Apr-2025 13:25:12] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127942.html 167.99.142.201

set names utf8

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

SELECT * FROM `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 ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [08-Apr-2025 13:26:32] /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 ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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
# [08-Apr-2025 13:28:21] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127942.html?_=1744108101484 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 `payments` LIMIT 1

SHOW COLUMNS FROM `payments`

INSERT INTO `payments` SET `ReservationID` = '1127942', `PostDate` = '2025-04-08 13:28:21', `GuestIndex` = '0', `Amount` = '429', `Currency` = 'BGN', `PaymentType` = 'office', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:28:23] /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 ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:29:27] /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
# [08-Apr-2025 13:29:42] /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 ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 13:32:16] /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 ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 14:44:11] /rapsody/root/rpV4nz0Sa0q/bg/reservations/contract/1127930.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` = 1127930
            LIMIT 1
# [08-Apr-2025 14:44:16] /rapsody/root/rpV4nz0Sa0q/bg/reservations/contract/1127930.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` = 1127930
            LIMIT 1
# [08-Apr-2025 14:44:20] /rapsody/root/rpV4nz0Sa0q/bg/reservations/contract/1127930.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` = 1127930
            LIMIT 1
# [08-Apr-2025 14:44:28] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127932.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` = 1127932 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` = 1127932
         ORDER BY `PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 15:17:55] /rapsody/root/rpV4nz0Sa0q/ 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
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'index' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language`
            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
# [08-Apr-2025 15:17:56] /rapsody/root/bg/ajax/basket/qty.html?_=1744114676038 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '59497424ae11ede31456f8676495b66d7d83f4b32c7db1d74d9676edc5471f85'
            LIMIT 1
# [08-Apr-2025 15:18:01] /rapsody/root/rpV4nz0Sa0q/ 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
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'index' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language`
            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
# [08-Apr-2025 15:18:01] /rapsody/root/bg/ajax/basket/qty.html?_=1744114681617 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '59497424ae11ede31456f8676495b66d7d83f4b32c7db1d74d9676edc5471f85'
            LIMIT 1
# [08-Apr-2025 15:18:03] /rapsody/root/rpV4nz0Sa0q/bg/events.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
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'events' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

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

SELECT
                `events`.*,
                (CURDATE() BETWEEN `SaleFrom` AND `SaleTo` OR `SaleTo` IS NULL) AS `InSale`,
                COUNT(`tickets`.`ID`) AS `Sold`
            FROM
                `events`
                LEFT JOIN `tickets` ON `events`.`ID` = `tickets`.`EventID`
            WHERE
                `Language` = 'bg'
        
            GROUP BY
                `events`.`ID`
            ORDER BY
                `events`.`PostDate` DESC
         LIMIT 0, 10

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sat') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` 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 ('Sun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

SELECT COUNT(*) AS NumRows FROM (SELECT
                `events`.*,
                (CURDATE() BETWEEN `SaleFrom` AND `SaleTo` OR `SaleTo` IS NULL) AS `InSale`,
                COUNT(`tickets`.`ID`) AS `Sold`
            FROM
                `events`
                LEFT JOIN `tickets` ON `events`.`ID` = `tickets`.`EventID`
            WHERE
                `Language` = 'bg'
        
            GROUP BY
                `events`.`ID`
            ORDER BY
                `events`.`PostDate` DESC
        ) AS CountTable

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

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

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

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language`
            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
# [08-Apr-2025 15:18:04] /rapsody/root/bg/ajax/basket/qty.html?_=1744114683995 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '59497424ae11ede31456f8676495b66d7d83f4b32c7db1d74d9676edc5471f85'
            LIMIT 1
# [08-Apr-2025 15:18:05] /rapsody/root/rpV4nz0Sa0q/bg/rapsodyevents.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` = 'rapsodyevents' AND `Language` = 'bg' LIMIT 1

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'rapsodyevents' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         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`
            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
# [08-Apr-2025 15:18:05] /rapsody/root/bg/ajax/basket/qty.html?_=1744114685649 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '59497424ae11ede31456f8676495b66d7d83f4b32c7db1d74d9676edc5471f85'
            LIMIT 1
# [08-Apr-2025 15:18:06] /rapsody/root/rpV4nz0Sa0q/ 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
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'index' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language`
            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
# [08-Apr-2025 15:18:07] /rapsody/root/bg/ajax/basket/qty.html?_=1744114687084 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '59497424ae11ede31456f8676495b66d7d83f4b32c7db1d74d9676edc5471f85'
            LIMIT 1
# [08-Apr-2025 15:18:08] /rapsody/root/rpV4nz0Sa0q/bg/studentskaekskurzija.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` = 'studentskaekskurzija' 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` = 'studentskaekskurzija'
         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` = 176 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` = 1452 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` = 1452
         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` = 1452
                    LEFT JOIN `programs` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `programs`.`Language` = `accommodation`.`Language`
                WHERE
                    `accommodation`.`OfferID` = 176 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` = 454 AND
			    `ProgramID` = 1452 AND
			    `Language` = 'bg' AND
			    `Visible` = 1
			ORDER BY `Price` ASC
			LIMIT 1

SELECT * FROM `faq` WHERE `OfferID` = 176 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
# [08-Apr-2025 15:18:08] /rapsody/root/bg/ajax/basket/qty.html?_=1744114688693 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '59497424ae11ede31456f8676495b66d7d83f4b32c7db1d74d9676edc5471f85'
            LIMIT 1
# [08-Apr-2025 15:18:10] /rapsody/root/rpV4nz0Sa0q/ 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
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'index' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         LIMIT 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`Module`,
                `pages`.`ExternalURL`,
                `pages`.`Class`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON
                    `pages`.`ID` = `SubPages`.`ParentID` AND
                    `pages`.`Language` = `SubPages`.`Language`
            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
# [08-Apr-2025 15:18:10] /rapsody/root/bg/ajax/basket/qty.html?_=1744114690731 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '59497424ae11ede31456f8676495b66d7d83f4b32c7db1d74d9676edc5471f85'
            LIMIT 1
# [08-Apr-2025 15:18:12] /rapsody/root/rpV4nz0Sa0q/bg/offers/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
               *
            FROM
                `offers`
            WHERE 1
                
            ORDER BY  `PostDate` DESC
# [08-Apr-2025 15:18:14] /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
# [08-Apr-2025 15:20:11] /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 ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 15:28:40] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127943.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` = 1127943 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` = 1127943
         ORDER BY `PostDate` ASC

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [08-Apr-2025 15:28:47] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127943.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` = 1127943 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` = 1127943
         ORDER BY `PostDate` ASC

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

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

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