# [15-Apr-2025 10:22:25] /rapsody/root/rpV4nz0Sa0q/bg/ajax/payments/submit/1127944.html?_=1744701745475 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` = '1127944', `PostDate` = '2025-04-15 10:22:25', `GuestIndex` = NULL, `Amount` = '59.4', `Currency` = 'BGN', `PaymentType` = 'StudentskiCard', `Info` = '{"AdminID":1462881527}'

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservationPayment') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Apr-2025 10:22:27] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127944.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` = 1127944 AND `Status` & 1 LIMIT 1

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Apr-2025 10:22:34] /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
# [15-Apr-2025 13:37:07] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1744713427482 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'pgKYkNRkXIldndC1kgC4sweva190hzO4aFqB9JTS7RWzk80FNridz7Zdw6yV15e9'
            WHERE
                `UserKey` LIKE 'w6vCmsK9wqjCt8KhwrfCrMOew6LCpMOaw5vCuMOIwqXCmMKr%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [15-Apr-2025 13:37:10] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1744713430263 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` = 'pgKYkNRkXIldndC1kgC4sweva190hzO4aFqB9JTS7RWzk80FNridz7Zdw6yV15e9'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [15-Apr-2025 13:37:10] /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
# [15-Apr-2025 13:37:12] /rapsody/root/rpV4nz0Sa0q/bg/payments/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
                `payments`.`ID`,
                `payments`.`ReservationID`,
                `payments`.`PostDate`,
                `payments`.`Amount`,
                `payments`.`Currency`,
                `payments`.`PaymentType`,
                `reservations`.`ProgramID`,
                `programs`.`OfferID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`,
                `offers`.`Title`
            FROM
                `payments`
                INNER JOIN `reservations` ON `payments`.`ReservationID` = `reservations`.`ID`
                INNER JOIN `programs` ON `reservations`.`ProgramID` = `programs`.`ID`
                INNER JOIN `offers` ON `reservations`.`OfferID` = `offers`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE 1
         ORDER BY `payments`.`PostDate` DESC LIMIT 0, 100

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 ('Mar') 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 COUNT(*) AS NumRows FROM (
            SELECT
                `payments`.`ID`,
                `payments`.`ReservationID`,
                `payments`.`PostDate`,
                `payments`.`Amount`,
                `payments`.`Currency`,
                `payments`.`PaymentType`,
                `reservations`.`ProgramID`,
                `programs`.`OfferID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`,
                `offers`.`Title`
            FROM
                `payments`
                INNER JOIN `reservations` ON `payments`.`ReservationID` = `reservations`.`ID`
                INNER JOIN `programs` ON `reservations`.`ProgramID` = `programs`.`ID`
                INNER JOIN `offers` ON `reservations`.`OfferID` = `offers`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE 1
         ORDER BY `payments`.`PostDate` DESC) AS CountTable
# [15-Apr-2025 13:40:47] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1744713647519 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'hGRr4Z8MfdBTS0UrQ6lSXs4u0Yq8CQ6i72brvEaMhyeffQMLtsWROzI9e50A08Gw'
            WHERE
                `UserKey` LIKE 'w5jCmcK3wp3DpXTDiMKVw6fDo8Kyw47DrMODw5fDmMKswqnCsMKVwq_Ctg%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [15-Apr-2025 13:40:50] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1744713650163 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` = 'hGRr4Z8MfdBTS0UrQ6lSXs4u0Yq8CQ6i72brvEaMhyeffQMLtsWROzI9e50A08Gw'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1462881527
            LIMIT 1
# [15-Apr-2025 13:40:50] /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
# [15-Apr-2025 13:40:52] /rapsody/root/rpV4nz0Sa0q/bg/payments/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
                `payments`.`ID`,
                `payments`.`ReservationID`,
                `payments`.`PostDate`,
                `payments`.`Amount`,
                `payments`.`Currency`,
                `payments`.`PaymentType`,
                `reservations`.`ProgramID`,
                `programs`.`OfferID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`,
                `offers`.`Title`
            FROM
                `payments`
                INNER JOIN `reservations` ON `payments`.`ReservationID` = `reservations`.`ID`
                INNER JOIN `programs` ON `reservations`.`ProgramID` = `programs`.`ID`
                INNER JOIN `offers` ON `reservations`.`OfferID` = `offers`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE 1
         ORDER BY `payments`.`PostDate` DESC LIMIT 0, 100

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 ('Mar') 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 COUNT(*) AS NumRows FROM (
            SELECT
                `payments`.`ID`,
                `payments`.`ReservationID`,
                `payments`.`PostDate`,
                `payments`.`Amount`,
                `payments`.`Currency`,
                `payments`.`PaymentType`,
                `reservations`.`ProgramID`,
                `programs`.`OfferID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`,
                `offers`.`Title`
            FROM
                `payments`
                INNER JOIN `reservations` ON `payments`.`ReservationID` = `reservations`.`ID`
                INNER JOIN `programs` ON `reservations`.`ProgramID` = `programs`.`ID`
                INNER JOIN `offers` ON `reservations`.`OfferID` = `offers`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE 1
         ORDER BY `payments`.`PostDate` DESC) AS CountTable
# [15-Apr-2025 14:04:28] /rapsody/root/bg/account.html 167.99.142.201

set names utf8

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [15-Apr-2025 14:04:29] /rapsody/root/bg/ajax/account/form/login.html?_=1744715069698 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorContractID','ErrorValidEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Apr-2025 14:04:29] /rapsody/root/bg/ajax/basket/qty.html?_=1744715069699 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '18c225aa6ff79ca0f3e11db86bcf0865eefaabe7d7bf80a3d7d32d16f0e8be6a'
            LIMIT 1
# [15-Apr-2025 14:04:46] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1744715086370 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'xp0MM646ZKmen6hD1QC170ZmKIQQyi7FZjXyHVURT4tF4A4n3GgZ5I1L1Rq35eE7'
            WHERE
                `UserKey` LIKE 'w5jCmcK3wp3DpXTDiMKVw6fDo8Kyw47DrMODw5fDmMKswqnCsMKVwq_Ctg%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [15-Apr-2025 14:04:48] /rapsody/root/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1744715088595 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` = 'xp0MM646ZKmen6hD1QC170ZmKIQQyi7FZjXyHVURT4tF4A4n3GgZ5I1L1Rq35eE7'
            LIMIT 1

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1462881527
            LIMIT 1
# [15-Apr-2025 14:04:48] /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
# [15-Apr-2025 14:04:59] /rapsody/root/rpV4nz0Sa0q/bg/payments/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
                `payments`.`ID`,
                `payments`.`ReservationID`,
                `payments`.`PostDate`,
                `payments`.`Amount`,
                `payments`.`Currency`,
                `payments`.`PaymentType`,
                `reservations`.`ProgramID`,
                `programs`.`OfferID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`,
                `offers`.`Title`
            FROM
                `payments`
                INNER JOIN `reservations` ON `payments`.`ReservationID` = `reservations`.`ID`
                INNER JOIN `programs` ON `reservations`.`ProgramID` = `programs`.`ID`
                INNER JOIN `offers` ON `reservations`.`OfferID` = `offers`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE 1
         ORDER BY `payments`.`PostDate` DESC LIMIT 0, 100

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 ('Mar') 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 COUNT(*) AS NumRows FROM (
            SELECT
                `payments`.`ID`,
                `payments`.`ReservationID`,
                `payments`.`PostDate`,
                `payments`.`Amount`,
                `payments`.`Currency`,
                `payments`.`PaymentType`,
                `reservations`.`ProgramID`,
                `programs`.`OfferID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`,
                `offers`.`Title`
            FROM
                `payments`
                INNER JOIN `reservations` ON `payments`.`ReservationID` = `reservations`.`ID`
                INNER JOIN `programs` ON `reservations`.`ProgramID` = `programs`.`ID`
                INNER JOIN `offers` ON `reservations`.`OfferID` = `offers`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE 1
         ORDER BY `payments`.`PostDate` DESC) AS CountTable
# [15-Apr-2025 14:05:04] /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
# [15-Apr-2025 14:05:16] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127944.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` = 1127944 AND `Status` & 1 LIMIT 1

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Apr-2025 14:05:23] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127944.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` = 1127944 AND `Status` & 1 LIMIT 1

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Apr-2025 14:05:53] /rapsody/root/bg/ajax/account/login.html?_=1744715152857 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000008558
            LIMIT 1
# [15-Apr-2025 14:05:53] /rapsody/root/bg/account/payments.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [15-Apr-2025 14:05:53] /rapsody/root/bg/ajax/basket/qty.html?_=1744715153804 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '18c225aa6ff79ca0f3e11db86bcf0865eefaabe7d7bf80a3d7d32d16f0e8be6a'
            LIMIT 1
# [15-Apr-2025 14:06:10] /rapsody/root/bg/account.html 167.99.142.201

set names utf8

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [15-Apr-2025 14:06:10] /rapsody/root/bg/ajax/account/form/login.html?_=1744715170466 167.99.142.201
# [15-Apr-2025 14:06:10] /rapsody/root/bg/ajax/basket/qty.html?_=1744715170468 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '18c225aa6ff79ca0f3e11db86bcf0865eefaabe7d7bf80a3d7d32d16f0e8be6a'
            LIMIT 1

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorContractID','ErrorValidEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Apr-2025 15:10:24] /rapsody/root/rpV4nz0Sa0q/bg/reservations/1127944.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` = 1127944 AND `Status` & 1 LIMIT 1

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Apr-2025 15:10:32] /rapsody/root/bg/ajax/account/login.html?_=1744719031940 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000008558
            LIMIT 1
# [15-Apr-2025 15:10:32] /rapsody/root/bg/account/payments.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '18c225aa6ff79ca0f3e11db86bcf0865eefaabe7d7bf80a3d7d32d16f0e8be6a'
            LIMIT 1
# [15-Apr-2025 15:10:51] /rapsody/root/bg/account/payments.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '18c225aa6ff79ca0f3e11db86bcf0865eefaabe7d7bf80a3d7d32d16f0e8be6a'
            LIMIT 1
# [15-Apr-2025 15:10:54] /rapsody/root/bg/ajax/basket/qty.html?_=1744719053930 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '18c225aa6ff79ca0f3e11db86bcf0865eefaabe7d7bf80a3d7d32d16f0e8be6a'
            LIMIT 1
# [15-Apr-2025 15:10:56] /rapsody/root/bg/account.html 167.99.142.201

set names utf8

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '18c225aa6ff79ca0f3e11db86bcf0865eefaabe7d7bf80a3d7d32d16f0e8be6a'
            LIMIT 1
# [15-Apr-2025 15:10:56] /rapsody/root/bg/ajax/account/form/login.html?_=1744719056417 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorContractID','ErrorValidEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [15-Apr-2025 15:12:23] /rapsody/root/bg/ajax/account/login.html?_=1744719143045 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000005885
            LIMIT 1
# [15-Apr-2025 15:12:26] /rapsody/root/bg/ajax/account/login.html?_=1744719145967 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000008558
            LIMIT 1
# [15-Apr-2025 15:12:26] /rapsody/root/bg/account/payments.html 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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

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

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '18c225aa6ff79ca0f3e11db86bcf0865eefaabe7d7bf80a3d7d32d16f0e8be6a'
            LIMIT 1
