# [03-Mar-2026 09:49:18] /rapsody/www/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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` = 176 AND
                `Language` = 'bg' AND
                `EndTo` >= CURDATE()
         AND `Visible` = 1
            ORDER BY
                CASE
                    WHEN `PromoDate` >= CURDATE() THEN 0
                    ELSE 1
                END,
                `PromoDate` ASC,
                `StartFrom` ASC
            LIMIT 1

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

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

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

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

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

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` = 67 AND
                `offers`.`Language` = 'bg' AND
                `offers`.`MenuLabel` <> '' AND
                `programs`.`EndTo` >= CURDATE() AND
                `offers`.`Visible` = 1
         AND `offers`.`Image` <> '' AND `offers`.`Visible` = 1 GROUP BY `offers`.`ID` ORDER BY `offers`.`Row` ASC, `offers`.`PostDate` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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` = 270 AND
                `offers`.`Language` = 'bg' AND
                `offers`.`MenuLabel` <> '' AND
                `programs`.`EndTo` >= CURDATE() AND
                `offers`.`Visible` = 1
         AND `offers`.`Image` <> '' AND `offers`.`Visible` = 1 GROUP BY `offers`.`ID` ORDER BY `offers`.`Row` ASC, `offers`.`PostDate` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Mar-2026 09:49:19] /rapsody/www/bg/ajax/basket/qty.html?_=1772524167863 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'b63211f22113fcc94b91ff9473d72fabdd0968404afb1b9d4d75ad670813be4e'
            LIMIT 1
# [03-Mar-2026 09:49:53] /rapsody/www/bg/studentskaekskurzija.html 108.61.209.243

set names utf8

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

SELECT
                `TopOffers`.*,
                `SubOffers`.`ID` AS `SubOffers`
	        FROM
	        	`offers` AS `TopOffers`
                LEFT JOIN `offers` AS `SubOffers` ON
                    `SubOffers`.`ParentID` = `TopOffers`.`ID` AND
                    `SubOffers`.`Language` = `TopOffers`.`Language`
	    	WHERE
                `TopOffers`.`Language` = 'bg' AND
                `TopOffers`.`URLLabel` = 'studentskaekskurzija'
         AND `TopOffers`.`Visible` = 1 LIMIT 1

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

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

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON 
					`rooms`.`AccommodationID` = `accommodation`.`ID`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `accommodation`.`OfferID` AND
                    `offers`.`Language` = `accommodation`.`Language`
                INNER JOIN `programs` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1594 AND
				`accommodation`.`Visible` = 1 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON 
					`rooms`.`AccommodationID` = `accommodation`.`ID`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1594 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                    `accommodation`.*,
                    `programs`.`PromoDate`,
                    MIN(`rooms`.`Price`) AS `Price`,
                    MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
                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` = 1594
                    INNER JOIN `programs` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `programs`.`Language` = `accommodation`.`Language`
                WHERE
                    `accommodation`.`OfferID` = 176 AND
                    `accommodation`.`Language` = 'bg'
             AND 
                `accommodation`.`Visible` = 1 AND 
                `offers`.`Visible` = 1 AND
                `rooms`.`Visible` = 1
            
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

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

SELECT DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1594 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 454 AND
			    `rooms`.`ProgramID` = 1594 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 454 AND
				`ProgramID` = 1594 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [03-Mar-2026 09:49:54] /rapsody/www/bg/ajax/basket/qty.html?_=1772524202698 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'b63211f22113fcc94b91ff9473d72fabdd0968404afb1b9d4d75ad670813be4e'
            LIMIT 1
# [03-Mar-2026 09:49:55] /rapsody/www/bg/ajax/reservations/accommodation/oid_176/pid_1594/1772524193.html?_=1772524203513 108.61.209.243

set names utf8

SELECT
                `ID`
            FROM
                `reservations`
            WHERE
                `ClientID` = 'b63211f22113fcc94b91ff9473d72fabdd0968404afb1b9d4d75ad670813be4e' AND
                `OfferID` = 176 AND
                `Status` = 0
            LIMIT 1

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:49:58] /rapsody/www/bg/ajax/reservations/guests/1172325/progress_2.html?_=1772524207248 108.61.209.243

set names utf8

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

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

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

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

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

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2026-03-03 09:49:58', `ProgramID` = '1594', `AccommodationID` = '454', `SentDate` = '2026-03-03', `Data` = 'vqfi2Ml3xAQzQJrN_LdJ7wh98Fr9vKjL6-fiTrrnFFgT7mFl0O5uYNKIubIsTm8pRILDtWLCvbP2BbOgFGwfGlsVOHSaCcKoMarv3O_zGHT6G9_zPoqAC5Zor2kWKfBi4aIHLi2oyCottOyit1Qx6viwFB35eUj6nagrvz-DaYEkzewIgqbkhquAqZoppvmjiRR4bmkA523iDvWq4WVDxRDGiPC1H48Ng1gfU3ksI27vs-EmUG1_ZkLCLKJCQ87HXE07U_8GXZ9fKoZ58-5ZkuvAZMp9bsuix_GrfUH4xg3Cv10hRYF6rZlZKucGV02yKg0_b5G2N0PX70NhuE1O7sJ6NJEGrQneppjQzK_Er3QpH3WzBZcaV0GbehjDshKwQOhBePLRO8S577bVMcLr4IwGLN3pA9_aMqVsY5gAvAYRjA8ABDSVL4Y1oFaAk98r9gtoMuTHmJQDLHmXrumKyVCOYkCtmvT2P0e3mXeKBceNp8AqC9mh_N3-u3uGubTp-ZytrkfrJwhezrP7981YR9mu_KM_Wx0jHEMW2aLFzUq4TZBeJxv3Riu48KnsFWuBuX-6Vm8R6FNYxVUDxXFF12D1GTFE9yfZ0d6YIUfHSeOzuNEKpOSFinCF-nDeyT8XO5oTUiq3Z9EvEiRIC8RoaZI9yso3ENcfwRPdkfNBJQh4PS53jDQEk30MqgI56C6r6Bvb2bthpIBTEQlkhvqC8HnM3dhnvsOP0xEv36OBx5NphuepLZrLUU9esmlvF13KDJ1fvm_dtQKWEJu-BhO0vKEZ8mom3M7K-DO14LzZ-sUjXhaLPz5lPh-lNhDg7vmJLBmJAHjF5dwgsCVVr9Intw7FX-7c9QXpHM_b30Kz4R_VgJ_jacdPlkYnDPphuRRzr4woy_snEIaer-LbtoLe7JUnRgnE-ADtawbdMFTCe9U80B_Wjuex1FYntsRZdMhxRmk1xm4v3ZOR-C6PMVJgkUAR4Exzpk3_4GO8JUWMU0h18HhlICidK3nXNUlnZb7NtztNU1OGUaenmrjh6dpjfIH4eSPfMM8doBcAteJFtmQGNRLB_5tnN3DcnlSz2oCyf1qSUVYWmxmd5tTHZ_xHIhzmzH2F7-L-Sh04fVDce31Y4crfFn6qoOMPt4Ow-Op5cPvTE5aarcFKJwRNEi80BXAC4kqLFhYsRAx7_shFABxphYV7mZFI17b622ldE6qobk7f7Kwx2zyg9xDfQh4Snv30BLgS0GRfSmHti2fToi-Z-TUT8ISgcSkwLeyiqKbpjCODd-8MU0MfrHjBb3OMMAf9by6wohDt-HfQPmR87exd-doPR2AxzAmyCPEzbHv8Dfg_N-GaX_s3fZgxWgwc6f_tTbfX24vTnKbrMrXimmGdM5aH5G91LD_7JCM9FZKRP8r6eAMv-AW4K0oSl839C5oZvQSCGlu55WCSzfGdAuI8UABoLAYKMdgarEE-4aXpD-1sJMmspw1Q52OU7COqUE7YfjFALY9F-C-SJRT2lV4', `Progress` = '2' WHERE `ID` = '1172325'

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:50:02] /rapsody/www/bg/ajax/reservations/additionaloffers/1172325/progress_3.html?_=1772524210837 108.61.209.243

set names utf8

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

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

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2026-03-03 09:50:02', `SentDate` = '2026-03-03', `Data` = 'Z_77otG6cRjjyLy-BZYpz7fnttSqP__3Z_XWzFD3KFs69_noLUqg9M6uLdAABWqDx4cnDm8zXQ9tABu3SarZaaMarDXvXSvyULv3MEXQRYexBqDpwPHr49USUeJ30aXJ7xKLrKfBqO8q5G0wdBZ8Ka5kvLxaha826wWAfwtYxZMs7auQ0B0iWOfCJDbY3Wo_iSalU6fI8pE-Q3zw_zrirhS5d6Iz5JHGM4aOhnfvEmdHLL9RUKCMHgataeU59Acu9xQVsH-sPRTjSOqUub-EQY8OEYsmPR3xkSUzrkPum4jjeBdXnBaax5q5ycnPw_64VkmGOH8S04_0k-gxhgs2EN-S3JLwNFWfJBjZszy0WJPSbjwnrdcrUrMEJUSzxPNflcsjRibCYp7lv_Hj8ftKsDAJCELpLy3rTXVJ-wdVPemvUPGd_2znxT6QNBiVUoE0VkegaYKjTXM4IdNuwqdiKZJU7zIawLhQ-uT5Pt5_WRAnwHxQOMxp1jZGL3zR-8UkEHHWabeURYy5vLLZ8h1Y-Amc1aTt0h4VKBQjPUhI9YJ6yhYjVF0L01Gczznw4HOQ7hrcLk4ZwOEEBEBo-Q2G0XcoAMHXPS-HVdb8vMkta0QvbolEhMfYiONzRoeGIqDPnjwiDunQzsiY494TsByywpTEjdjcRhkyZA0bTtWYxliz4nNFa20EXXoXWA5sMzg9qFQK83dgs8ZNYV9goNOVikwf0ExQTKE5KwPIKVWM8ZN7Zp7bfHJplIHf3YM9rXHgnjUUshoPtCMvIwABeZnZhT5ar2oZcrx7THWbAYMslx-Tl1QNDk2_D60ZSu0qNfctwy29qdR7yRetqwZFsZK3CilbRcoZN3_3EbltJiKluFfU9q20TynLhQcVqVtG0-u2YQEs8PCGRF5xTqXg9rV0e9vwPOUB9PGM_GS1U9lOTHmb02hG0x5Z_a5PBOsS2LRhe1bECduUa61rU8ZGDoX4EbGdZHanq0CJEdMMrbTcR3ZquoigPpCvqvIR_EDmAbmWm0HpMkhMf5bb9iWwsbDLS3vYHXgPYdVPwbmgi6T-MTdMPn4HaUHXOVeBC3zE7RE4h-lKud203uc3ubpneuontxcWu5dwipjultbRV8bNyehQtudG9Zi_q5fxil2LMMCV0OqasK3QOcU400IeYW6ZErC5symDYGui4o0DBLntP1TuuRVgxxqQU01NIKgd9M-u2FBAZmM8wTU-CXpcFLiJBJIzhfwP5CFvy2AWZE2MByDl0b2OttQH7YlEwJgaT91ENVpQmfNDx5n4XCMlEO36w127CmmqYy7Z4dhyZQMK1uH-p-7UH4RJzXjhYzMEtBTN7RSRqbTukSYe3Fh_Vbk91G9XB5BXquyAEszXpRtibXeQAHijIzjawy8z9Ajd71M2Gzl-_F8cg2uo0idEG9x9Epbfc1NOlzovfSJ_1yx8h7ZkdDr7BnmzC0zmAJTjg7wmeLDgnsl2_roqxqT5e6tzHzjkGQeDUKPaoVtG_QlRbVXxkz2fvgOTC8jQlaHzsAC3cFbeaRd0yUbKJZnkivovirVC3LQYzi7lHpgbiDnBtmpHEOAOM16qYOo01aVfh9U2j9ULRjd0_6R1e88mX4wIsicDFcOAIRhy5n00FRWxHOtZ93dhQq_UdxAxEZh6eBIauRK5ofN1dHmzYvWb2y5EyCbWY-OxogoUfL17yByx-Vz3YH_CmY0w4E8Nz11mtPXfM3s36P1X8WPITPbeCSQvOTL6IRodRgnVKbmYaKlTUuQSbaOLhNM3tFa19psQ9p2ty_9dYDBgv8G9XoWv-zyXaK_lf8HIrWXWkVwUEEsN_QWpH6yfqALSfkrqWLr4Ak27UEUq3xrOxC5saQBWzg4URBqHSLMDYEb1GieQWc_uFfvdYkwdv8bm3q4IpH9BJpThQdPO54AcTPv43dqivhgc-Q', `Progress` = '3' WHERE `ID` = '1172325'

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:50:04] /rapsody/www/bg/ajax/reservations/summary/1172325/progress_4.html?_=1772524212925 108.61.209.243

set names utf8

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

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2026-03-03 09:50:04', `SentDate` = '2026-03-03', `Data` = 'JjCpSYHc7yjWT9OwzrPwNDgfRIrnXJ-mb_IMlUyV1cw-AiozfaB2LaTSIHsQeBk73qmtff1L_Jz0vP369KQD194tFDnfIY9y8U0CqieAoD2SBhnemnzscA6LvlWahWmMZmlY9lCzwn-cL3bu_iZ-iNI5gIXUNRP_TpIKOeEqJuAM53sPn1vKZv4LYIx_omxbc-4nk_6BYsoqb-fRyuQoUZ-NyZUJhJoZAti2Q99ra2OTw67_BxgoAb6zAC_Jir_0X1_ufmtXSzuUEFx-5wz0tCnCMM5erjr8b0Fr5SSJOxna2grgCJ3x7uPbXBrMllRywDgEM3ZEk5XzRE9fvfqu4VCAVfvYtY_L96Ki7wTrlI57wHJUbl7W_4uGYM0WS-31XlPKQMpzOqJhGRQVwyMJVO1W_Ywa-unuko70y06eI2_yuQZnpSLpZHBhdz4-sx8Pm8ZK-oeVKXy0zI1W_dfepmuktE3UzT6lAJPFve6_8Qp7mtfTYv6KUfz72lPuje4S0Lgc_0_nyUGLzvJBinIlakYczI51O1Jz4h6nC1OOBfbkoLJKTAOemJQPQ5v6ZbWSNK8glwAmAzV4FSJ9R-4LqYjyZhvrSkPlx3gq1SL7q234zeKmvEps2yIQBICio_JdFNtxMEqSoNKpYa8de5d5LsCGyCkvW0DU7I-Q3EP8bEgqnq_JtLnZSs0tb1ZyYuWF-bqejCgqpjFgs1O59QWT647eRKVNuejcq5run7Khyh9WlIiq4y4tZHtlmmNvkvd6J5Z5bT8mk8-PzPLFGU2JjRQtwE4r2NTvo5JaftJVKSIyCjmRnG7sTlPs1Vw2KCp_Vkg_wcoLPD6tluh0XacvHPRA_YPIH12F_D0rSwCaKy0u7Lw_VtEgotjtHX02U1SluvkQZEoOoclovrVMqpFknrQQ3d653fD-fkXhW5YlcTv2zWfAgg2cHHZR7yc4bXUf-ROR7xES3Bz_nI3oQxH4CsfvoFRsOm0vxG7TqDhRaJBTvnEizjjjGq0kppcx7GLtUek_9MqkJnUqTdFOiDl2vBvEmYOYpIA4uD7J1-96LIUeTbwvG-J45TUNvwdAg4P-2QxBFijKWQjUAeBD6hXqqMT2IcBmzRr9iirAm-UJVqs_pEQBHlYAwtm0RejJtiN6cp_OAilIGqEw8PL422Pmj6yNtrWSNe0fVZWfOavN6rOmgCzPFAJAi6dBDlcWlbvb1Z4ulmE716S837wO2uHvyua_002ZsoMEgxWUNVHRqfCsNO7Bbu4bJGZsrkpjjk98Fon_OvRUrt9GH2EmxC4rnA9DfDLLKnoM20BjqCxmJw9G7IXBYjm8fZ5A5u6q6K-53dsqOhKBXID7Ut80lrfUeSTgjaMsOmL1TrWnUyeUVTleVmo7iTHu9vNTj_BF1B3OmJTzzLNS7agokxR6IhZ4DpG1Q6HApu25bTZCr1hd3dzGuSvsdulaQ2CT0_WMATyYFI9dwt2iJfdqy3MEX88H9BxIRy5DfS67n_asJkJOdbgLXUoBmri1K3yQtJ7xYOWGhgDTYHTWyEIVFP9DRGanuF28RxfxfUmoIhNMr1RwLLnzETJ3VwIjOFzJb4e6Fhf9N2amSiED0SSFuNY1Z1Hwvc_MNuIh1T2vSMreXWJq15LhXo49NNIa1mXehcef21edvIC8-whOlu4vCV2kisS7qdyhDiqQr72gxGmU61Oq18sx7ZjHN7kclraoIeswq4rP_TvobJW0NquXksAVkIOGUp5s7Biu5zXHMNICnSqlXqIOVA6E9_JeLS8KwxuFNgQ5ukKEILetxUuV3wMT6kpSMiflJzpZWTBE0XjBDozXX9eFQ1YB962W8cj2fgyFqRdkeLrj8TIq2T09bGuBfed5jFet0QXekrgvs6xWTh-zxx3P714jEXwuhz9pgbQX__CPHjYVB8vj0hKssAi5tIvxpA', `Progress` = '4' WHERE `ID` = '1172325'

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

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

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

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

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

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

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

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

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 176 AND
                `CardKey` = '87d78cdcc90c8560c87c5846702177df' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:50:08] /rapsody/www/bg/ajax/promocodes/1172325.html?PromoCode=KL123&_=1772524216400 108.61.209.243

set names utf8

SELECT
                `promocodes`.`ID`
            FROM
                `promocodes`
                INNER JOIN `reservations` ON
                    (`promocodes`.`OfferID` = `reservations`.`OfferID` OR `promocodes`.`OfferID` = 0) AND
                    (`promocodes`.`ProgramID` = 0 OR `promocodes`.`ProgramID` = `reservations`.`ProgramID`)
            WHERE
                `reservations`.`ID` = 1172325 AND
                `promocodes`.`PromoCode` = 'KL123' AND
                (CURDATE() BETWEEN `promocodes`.`StartFrom` AND `promocodes`.`EndTo` OR `promocodes`.`EndTo` IS NULL) AND
                `promocodes`.`Visible` = 1
            LIMIT 1

UPDATE
                `reservations`
            SET
                `LastUpdate` = NOW(),
                `PromoCodeID` = 1155
            WHERE
                `ID` = 1172325
            LIMIT 1
# [03-Mar-2026 09:50:08] /rapsody/www/bg/ajax/reservations/summary/1172325.html?_=1772524216449 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 176 AND
                `CardKey` = '87d78cdcc90c8560c87c5846702177df' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:50:16] /rapsody/www/bg/ajax/reservations/confirm/1172325/progress_5.html?_=1772524224972 108.61.209.243

set names utf8

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

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

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

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

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2026-03-03 09:50:16', `SentDate` = '2026-03-03', `Keywords` = 'Y2FyZAdGVzdAZGF2YXJza2lnbWFpbGNvbQ', `Data` = 'JsCT8s-9jJw_FtYbVEfOLoreuIfR6EpJ-epu3HYPFnXZzk3KwWlvZh5CzZ-kFtCbqMNE0miVpI-u8FkA7HWcSRzrQaU1zcQ2x8s3XmoQMUvS_07b0EQxnkmTa_IPM8LNeoIQbhTDZN7r7n46pHtveaMQU9kfxVoqpthYeJboO-1dEc2zy76Ix5yqqwPqeW2toDoIA19H2F5nh1qgu-kj60jyZCjPeXmMQhcqJC6OYJTs3PPX4vTMDfvmZ-ZLr-Z1Q0_udLom1remW4itYLpNoc23xqLBLe86GPhBUL4jXWBT1tDTwBMo-lE2VKD3OHaC1-7xTn9w4Te7LLv-OpG0RSVokW0moOdQ5M3LzxmlFGguY2olHuQU4uOwEcKE0AiA931jSsM657vvLOWfTzqw0lXc82Od7g3t6wC4FLTPJ-NHsxa7WqfH8CQ0JoWHv0aCxQ43WPY9un9SEPf0D3l6c-J66rLbOAys5g0HnCypUDwTHBsgWsGPUrJRbHw3N3T7hs3bfBMu6MBHiAy4m-WrBpIRMndymL2J1a7ipeJW2wPZnX5zsjo_3E564zDWzUaKjRogpQcET5bvi0e-40zdgxtlyy3rVRqpE8navlN9v7a4z2q17nud1Z6pOv2n31QpXZ-4q-cpM4eq0oZXd_IKJIprL80Gd1BCcV0qV6KSgZzMSvGdgYgukvCW4JCoFjH0YDd3urO_qURozeOa4b-Tq3MinueLGZZPpBXxYUTIy05Jfr7dBCBoyKfIA6I5NinMwjbZ3QZc9zhYJFbJOPg6D3r9ygvoLgiQn70tQFNXrf_JF1J1NOqAcGBizWqhzWF49e0AGUIkaP4-2yESBLtoOJem6IZCr3dzyi-90k6W6AJAuz8_DYHQcvzND1_TeDyiZJn0esXtMeDWHMJ_-Sx6eD6KVbaYKOdSZskz2FN4FV5PhrUqIKAcUaR2gf373O0xES3s5EDTMw5W2lO2tdw6vPxuUrXPJx0YkcOkl0jLvIToXzIXI0Do04gg0nbEliE-EnpBBvzXHI4MhiqSTBYSgYCxwk5MuKEF7gDyomtcDyhFdCaxe35iEfHUT55aXs6Sw5ejUlZBdmGj2AVPvw4d57pYgePwqrhrCzCu2yYjaMy0MacMbanit4XlMhrtyjA5yFNFo2OnyxYNwFYx-DCBswnMj65tpDYjBqq7OQnD9H21OqC1fCwkL6qeI1t5VHS-UsRJfvG0tV4cMse3n-9xuYwvj4Do8l0xFswRUw3YGhCFNFuEIvVgyEfCRwYHAfZetSLFMGBORYs-OPSKGNW92o6tHR8XOQRpz470VMUTmAjS8NwkOdxpncr10yqi32SKn_IC0d3qM9HlmvBd6BrM178rq8LpjaP0xX24Pk019d759wbJ63GClXpZ67EOlHrFGdRINBfVrTiTjpwUOansU1jL9UGepJWiKHhHW7b2X_EEk-DPy1cyC70jYHQr_su9xVTgpKC6oAGRvyBgn_LzZ6byOprCsHyxiWsWqK5fqPd_keQZnE8kDrgME47e2pwbu5Mfs-ZdYBx3LtEawStdpJIfo0Y6LcxsDRa_SXgCEIn_104Col3ZDLClrBgySKjJ_3K1QIm1H98a5fWycl78BjHkJrraWykuV_zyLDWVPN0EuR_nX-XuQAcfK9pV-qrADXS4JQGrFeU62e4W_ltllbhpJHfcK3z4LMB5pTYjfubUMEFCDnoXhv0cXi_OUqFuWQMXq6faTtrgTB8DVm61cOI2Q79C1cEVJxrSUJ5ftlOKG6CvwKVmyHn6rkAP4mWaVhaLzB1QjLmr8zq5_ymMzw_b7AV5Z4WAF36FicBzeoM_JkCKwSPCtZxHOh4n0EZ0D532pamB7IQCISnQ8bdd8pbCEKJIH_XzjwEsdKPdZEqQ4bqxIgnhySrdI3A17h63lvxqyGI7M1HgPQGhV9VR5L9nlfTU1e9u5Z8qUb8xRoy_45Z8IRoLG73pVE50h1PgCNY1qKZt3qSdNhQ7tilw0P5cKRUPTI82vKzi2aWmy8uUphjEOEM5uK1F25Fns9CMoqvKs0i4_M94RV5WQRZewzgSEi4p4_olOWZ-HM61GtObouNgmcU4Up5PL5X5RvaS5gAVTi7otARFKG2AruF5NQ', `Progress` = '5' WHERE `ID` = '1172325'

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

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

SELECT
                    `Exchange`
                FROM
                    `currencies`
                WHERE
                    `CharCode` = 'BGN'
             AND `Visible` = 1 LIMIT 1
# [03-Mar-2026 09:50:16] /rapsody/www/bg/ajax/reservations/send/1172325.html?_=1772524225032 108.61.209.243

set names utf8

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

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

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

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

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

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

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

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 176 AND
                `CardKey` = '87d78cdcc90c8560c87c5846702177df' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

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

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

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

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

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

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

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

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

SELECT
				`Title`
			FROM
				`rooms`
			WHERE
				`ID` = 35149 AND
				`Language` = 'bg' AND
				`Visible` = 1
			LIMIT 1

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    ('2026-03-03' BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

INSERT INTO `reservation_rooms`(`ReservationID`, `RoomID`) VALUES (1172325, 35149)

UPDATE
                `reservations`
            SET
                `LastUpdate` = NOW(),
                `Progress` = 5
            WHERE
                `ID` = 1172325
            LIMIT 1
# [03-Mar-2026 09:50:20] /rapsody/www/bg/studentskaekskurzija.html 108.61.209.243

set names utf8

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

SELECT
                `TopOffers`.*,
                `SubOffers`.`ID` AS `SubOffers`
	        FROM
	        	`offers` AS `TopOffers`
                LEFT JOIN `offers` AS `SubOffers` ON
                    `SubOffers`.`ParentID` = `TopOffers`.`ID` AND
                    `SubOffers`.`Language` = `TopOffers`.`Language`
	    	WHERE
                `TopOffers`.`Language` = 'bg' AND
                `TopOffers`.`URLLabel` = 'studentskaekskurzija'
         AND `TopOffers`.`Visible` = 1 LIMIT 1

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

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

SELECT
				`rooms`.`ID`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON 
					`rooms`.`AccommodationID` = `accommodation`.`ID`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `accommodation`.`OfferID` AND
                    `offers`.`Language` = `accommodation`.`Language`
                INNER JOIN `programs` ON
                    `rooms`.`ProgramID` = `programs`.`ID` AND
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1594 AND
				`accommodation`.`Visible` = 1 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
				`rooms`.`Price`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON 
					`rooms`.`AccommodationID` = `accommodation`.`ID`
				INNER JOIN `programs` ON 
					`rooms`.`ProgramID` = `programs`.`ID`
				LEFT JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`programs`.`StartFrom` > CURDATE() AND
				`rooms`.`ProgramID` = 1594 AND
				`accommodation`.`Visible` = 1 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

SELECT
                    `accommodation`.*,
                    `programs`.`PromoDate`,
                    MIN(`rooms`.`Price`) AS `Price`,
                    MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
                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` = 1594
                    INNER JOIN `programs` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `programs`.`Language` = `accommodation`.`Language`
                WHERE
                    `accommodation`.`OfferID` = 176 AND
                    `accommodation`.`Language` = 'bg'
             AND 
                `accommodation`.`Visible` = 1 AND 
                `offers`.`Visible` = 1 AND
                `rooms`.`Visible` = 1
            
            GROUP BY `accommodation`.`ID`
            ORDER BY `accommodation`.`PostDate` ASC

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

SELECT DISTINCT
                `rooms`.`Beds`,
                COALESCE(NULLIF(`rooms`.`Label`, ''), `rooms`.`Title`) AS `RoomLabel`
            FROM
                `accommodation`
                INNER JOIN `programs` ON `programs`.`OfferID` = `accommodation`.`OfferID`
                INNER JOIN `offers` ON `offers`.`ID` = `accommodation`.`OfferID`
                INNER JOIN `rooms` ON
                    `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                    `rooms`.`ProgramID` = `programs`.`ID`
                LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
            WHERE
                `programs`.`ID` = 1594 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Gallery` <> '' AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				MIN(`rooms`.`Price`) AS `Price`,
				MIN(`rooms`.`PromoPrice`) AS `PromoPrice`
			FROM
			    `rooms`
			    LEFT OUTER JOIN `reservation_rooms` ON 
					`reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
			    `reservation_rooms`.`RoomID` IS NULL AND
    			`rooms`.`Price` > 0 AND
			    `rooms`.`AccommodationID` = 454 AND
			    `rooms`.`ProgramID` = 1594 AND
			    `rooms`.`Language` = 'bg' AND
			    `rooms`.`Visible` = 1
			LIMIT 1

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`,
				`reservation_rooms`.`RoomID` AS `ResRoomID`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				-- `reservation_rooms`.`RoomID` IS NULL AND
				(`reservation_rooms`.`RoomID` IS NULL OR `rooms`.`Price` = 0) AND
				`AccommodationID` = 454 AND
				`ProgramID` = 1594 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Title`,
				`rooms`.`Beds`,
				`rooms`.`Price`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

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

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

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

UPDATE
                `promocodes`
            SET
                `Visible` = 0
            WHERE
                `ID` = 1155 AND
                `PromoCode` LIKE 'KL%' 
            LIMIT 1

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1
# [03-Mar-2026 09:53:41] /rapsody/www/bg/ajax/reservations/accommodation/oid_176/pid_1594/1772524193.html?_=1772524429339 108.61.209.243

set names utf8

SELECT
                `ID`
            FROM
                `reservations`
            WHERE
                `ClientID` = 'b63211f22113fcc94b91ff9473d72fabdd0968404afb1b9d4d75ad670813be4e' AND
                `OfferID` = 176 AND
                `Status` = 0
            LIMIT 1

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

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

INSERT INTO `reservations` SET `ClientID` = 'b63211f22113fcc94b91ff9473d72fabdd0968404afb1b9d4d75ad670813be4e', `PostDate` = '2026-03-03 09:53:41', `LastUpdate` = '2026-03-03 09:53:41', `OfferID` = '176', `ProgramID` = '1594', `AccommodationID` = 0, `Data` = 'Mux2ZOQ3M9C1TJwl7HnvWNkMolSRYUrWmqL0tBhimqLg6h8fUCceCrvBN2wwtWaA_V8Jdyuo6GvShnW32015GKA7uhrcBOInmbEkyL6GTtH6KG-Um0tNwYhhlAh5ELOwYlYktTnlvKKErUiPINesQvqo5GwltHda5eU_OlHoY8Xiwmtd7FgEZygGbE0XA-ViMYdXu80SvcU-dND3oWW59QFJ6j2hG8LPXm2pSYs0KeVSs02gn-y27ETwX03qPIEDz6kclMa6DLek9cYXeyrV2VXQ3T_RAirIWLKhoUKlVf9kn0Vt-3rHKURdSFGSiFAEJVYtipp5fHV_-xKdAYnLDiZ5mNuOnzlE5Rn95g7KIg8vuT-nclHP7BBDf_E9yzbQGop_cJPQ-ckVTdgX7jo_fg', `Progress` = 1

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:53:43] /rapsody/www/bg/ajax/reservations/rooms/pid_1594/aid_454.html?_=1772524431468 108.61.209.243

set names utf8

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorGuestNum','LRoomTypeQuestion','ErrorOption','LEmptyBedsInfo') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:53:45] /rapsody/www/bg/ajax/reservations/guests/1172331/progress_2.html?_=1772524433762 108.61.209.243

set names utf8

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

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

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

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

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2026-03-03 09:53:45', `ProgramID` = '1594', `AccommodationID` = '454', `Data` = 'Eds5A297URWJCfqSLvigoV9RLz80TirwQOHfY_2N6xlGKcOiRArXGG69rqyA3SvJ-EBBp6gqBHBiOy0y5RQKa_qHmJAfvu_mJIM-Tm09e5K4j3Y87xBaQWWTeTDwdnuyutyhT4pxPbzQOpAtnwjcmAt1sUbwps6ZiUW8xE1y2-cvyYdBN51f9iKbAcWubCNGTWf68Un8cTENosQfI8JAWDo4TQWeeOn5uNFAluzZB-6DcLacgKqZYYZEEZO4_LgLvTnDN2JhkfIldmkfOwnCsp-ZMkv9qLO5TY-TxqLmoIwHPJgAcILuoBlGNRC0u5MAGLCkHS7MEeW0xT6cU8P5ccf47IaobH469Tkaa60hRO5CJtfd3wikARftN6XfAdQ-LDPIeb6zS8waNmg9vXfNaMgaqCL1aZCODcwo5YGYoUn7-fF9DRdKrvo5sNh1273_MZAPT1Q9T4TuhDbXCq8SpzDO2yOLV2cxH9GH6_KWzFBwxnANC4hFJwZ_FyWnMknCmwjNVaOgG2VwVPXqM3XHzqPg6eB5pRFZQTknXmS94K0nVuko9Pa0pPnf4zH10B7EAShl24u12xyCoHS5h-w_ZFcyz8EGHOj-ZAY1BFQvvu3tXzRiKzMYWRFHrj_CeZo9FmUJEuMarnUAQlNiJ7usdOkQjI9WFbt0p2hbXptsCbmU5LJjldaAfmFakaiu-fnezvh3AN5zvMV_BCtonioNKHlfyYwRwwhoT3WFjZn8ZveW-Cm1rJkecAMG6hwg3NPt_sgieynPnYKzxswmKrOpb1ka97a-PugHOWeesoyczqzQvV7sMxOUNi-hUtSx6-b-', `Progress` = '2' WHERE `ID` = '1172331'

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:54:03] /rapsody/www/bg/ajax/reservations/additionaloffers/1172331/progress_3.html?_=1772524451548 108.61.209.243

set names utf8

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

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

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

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2026-03-03 09:54:03', `SentDate` = '2026-03-03', `Data` = 'MZSD8RVbLGwjclsHVoVHjqtBTKKUWmGCt_TqaVBcCH0fnfdGW9jKIgPxl6BzNjMxWNQ42WshwYIKmAZb6n9RbneFm6DBdQkZpt5WIK1Pa6nRvzPPhFjWxQ7oN2hozOGt0q1SI6V03aK6_VqvXXaBz5adU_YrtOIhBnsnSWcFGLweOyAWX9qNp20W7R9rsV4s0_D-bbFEEi_RCjOLvq-3AA49z256UBZkKM-aEmS06J4bMrUseNOmcEf9ap9zoqZtgZaZ6zhAGnxVr746ZVJqQ9Mtf07Eh7SjpE4daboZD71irarLUvqVn-sK8H-2aXioGdsTd14O5Hl2AocyEh2amZFniunWVvRJdbEbi_gOgUgBVxzILU8_Nrj1v8kuOlnpV0guuWdyhvW3um1LueYgHGa1J2XOjeqF83_4cOKWkWFV8mHWjyiViAwdcl8Ft5OwnkEaoq5C5k7SbmoSA9QMyecv_oMJKGerpcN9EqTXBIPlLvGSVGZYhM2580diKhVWJilDHJPost5IOb7AYKMEeWYvgtOVMM-PiYTheMApqJDZz3fZcfhwfH1May2-Niw541nqAfqaifASJSeyAIXmJKfd8ZDU6dr0gXWHO7cXKhihh1S-o_jgwaAnzonT8qQoS7pGGj4Ca6BEgAeNFbOXJKZEkRUd4NwpRMAUWfz8clpWghax8xeXa1vzS_gB09_9KxEDflSsaajkfaiu8OC1x0wHRWlq1pvDaay2NUJRmuYGKNpcugl8GDXwYMk8Fff9RvrhEeidORDz2jDVFBBM54ZD71VBhJBIniC2Tsjtk63FTa6b3e1ID3iVv9fGMRXBF0GYAxOBe5lE_ki3O8dD4-yXexxNZulu488-6OV2_ERE1NX74laq7RaMX5LRPx2plmvN29TrAnYa8Loeyoz41kGlhmvcPJ2yBP5U3u5CXuZuONdTRqeN7Ev67v5Phy08jdAAoOvAKeULzogmlW8KuZcwAtyKx_kP8orl6GLmOJRFRtRfGilP4Pzr3rdbJ7Fo3QagVe_WE8dFwKw-xRPDTUSdDN5NLeou1TAXiFpKCJlbw2mV8gY41-fEiOkKoO73sYVBijr3Ovy2JkKCWtn6vlnSKCp2h2CbK9K9orN-y6_-w3A4AHRQltRIHmy41jlRcWDjnyFB9Y-PuT3BBbrIdfZ7zGStm5aiYQ4N5z2tlL-owa5F6J5d_OA1ga1zr_x-qAB4Glg6WmEzl4zmygxH5bAKBbn7gvEPL5u-5jBE9ZYiHOi8sEDmK3DjQv-CalWNc0Q0e0Fcm1Jn9QvldfFugR0ik2gXYsb80I8GvLtZVP3QwDrNbjuBmbbMaWFSMpgVvwQLVgortvamD9JNIu8BqoZssJ9aaW3LoUtB8qvQohdbE9cMNlkFWf2l9PMPkWoEc7ylJCecdfVPrVIUjcsfaCH2PcknFDSEvgzrIho4SnO7QjtSyRuXjApHrjA2zeSpfJ_qojXxovbRwreyMTWSZniYyvfd8T3Yr_XA7fj3B_x3RnnTUUd-acaNuacQiGsLAbujoNMC40xiGpL-YAxPAIA_XV9UDDx5VfNjliA4KcyPNY90ocabgdCwq8E_gcVWIiRNd6GS5PNtBnPI4A_JZKbh8C81R-xjFW_JTrv7JhNAxirhIYWoo-Q_W9-9wMWy6O44sKLj-h7tXlwqotpRZSvS56h9Fv2uXKjTKHldsolB93EmR_i-BkcuFFC3hsGi', `Progress` = '3' WHERE `ID` = '1172331'

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:54:04] /rapsody/www/bg/ajax/reservations/summary/1172331/progress_4.html?_=1772524453180 108.61.209.243

set names utf8

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

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

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2026-03-03 09:54:04', `SentDate` = '2026-03-03', `Data` = 'l41a1gUXN-bZJ_Gfd-4hLDPkZsCYtDYX7cq8rA0VXPU6aUge3VwOiCHZph3gonhgubYHys7OEO1vKxuj6Xa0SNc97EbfKEVEFFtWfhGAhyTwE8NKsWvg6RplyLlIeJnfiBaXlZZebKVjlt_LsMR8Tz4srhKl1iGD98URU0eZ-GeV0z2rPiSxuEBc3WSO1tgXYytFq1xLHQn1w1qRMzQcNOUVgqSElQj8EhZLkeafCCzm3Du82tUi6gnGe1P0yV5xauxqOBNOcdBxXdxtl-i7t5OQxu6IlrUDI91vCYjEFt_pWXjZ8xNpvpfi8oWNsAJ3McAK6m_mxQgxJh6cBB9-TBQ10uRoc_elTFZ1pYcWYVj8dcW3u7H_kuYxdUfdtSC40tE-f6hTrT1LaxMZKCh5fubjEfTZQAaoEJLd69o2xhcxNtmoRty47hFAfgnWj-_V-0Cfng-rUJDSFz1gOY4gbmvT0gna0lHMMwmRo0ATGCGkGUVHVOHSTd86oi9uQuhGKE9TaZgP0_a1kjVkOQZj8-TpA1zJryOE3FAcObeZIeZvBqOSZT671lZnAolrwGMYXJYse2UtMsAkBcaDMYHsX7lrsXtf_CtaMopRobwOY63-rzez4MvLgjH4YvWiPJEy7wNvm4sAK0V85siDrzSfiTvyOYI6gh8dHmg4A29g1YJpMF_RM1vQPLykhmY3H_ziBfrJz2y-N0R-_vyiHL0WLHiZ47J23oW43N2SSR9-PfxgCiws2HRLm1RJpTxD_j6-VAkrVz8qY1XxXU7vnjPg6drPXJNVZLIa7zOCaWtzNz_oAB9Sq_crcr1gj3-qioZ361zi72bNh8cAD1KV9u6kVqZ9EivNc-Mom5-_So4HiRMQ1iBo7Y7pWJUs1OQIchW-vPFa_UOMbLq3kGZuzgg5bggkkc938RjLiWJEHUGFdKNOyQeWswE6LNndHfE5YSix6edyrVyJO8izHe4nzakTzlKCivzGgF3UFy0hSEeBzep4dajUEE7HaoOmtSR10wkogV951TB44mpox8Xmv5anYhQ_LD_OqJ0gxyXdZPbgIk7LWnHCU0b9Yj3V20hMIOFwR3asHY3-IRYhuCcOvoT6uPZy96TPaK84XlklnnIeDpXTxRjzqYkwwMStJP7YazpFgHAAT4Z0mt-5BPsUh3yeW8CYuaozEaoNzobvj0z2GokAOCV91mXZMWDUyeWBpsk1BFjIdgs8oC03ckbYXYUqFirMFyX4vBHPHTG5tiUqTB6KQ3fXoS5AqDBuC2YG6ixFDLsii60G_zuWsmEhedreHZib_ye7EEDFOqm92mxnNHy31G3r7NJcy1adtL1dYi2JJQIFa8zB17HdefCj1TQzfhHzYRlGo3xxtOCcwckel97D9HCYNqvgr-g5WN1Cyli-fVS0INWAmXfJ_bRJxNdXoNxY9Nh4ymD1pWRGIQ-t5N7203cD5I4mm8HY0bKITJiM09NMCJ6EbTFjQv7djq46WiER7WGNrfB7YdqERbXuDn9PqxJEUXCN7q80U5op1t_Z0ru0Cq-tuI4b-nduZPzHM0E0El_YsBoQcCsN3VgkP3Nz5v2FJIIpYl3j5v_f6VRplU5FXGqFLiGhMvde3HHJZB74qMAwQeVxHp32LQiDH1TQwzxCJSXNbv6JZqyegi3cu3XHM2u5xdiHVWmuwglcz-Re2SiMNqr5R2FntzykahZEyrjRGQcHgLfEAFqnioGhYKn6AydcXMoq3oawqjgQkru5dy_YhX0B5LfRmWRGExarRaYNWs_OxipLBjBfC_8e', `Progress` = '4' WHERE `ID` = '1172331'

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

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

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

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

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

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

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

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

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 176 AND
                `CardKey` = 'a41ad980349bfd520a21ea59f7d25c1a' AND
                `Visible` = 1
            LIMIT 1

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:54:16] /rapsody/www/bg/ajax/reservations/additionaloffers/1172331.html?_=1772524464560 108.61.209.243

set names utf8

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:54:17] /rapsody/www/bg/ajax/reservations/summary/1172331.html?_=1772524465729 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 176 AND
                `CardKey` = 'a41ad980349bfd520a21ea59f7d25c1a' AND
                `Visible` = 1
            LIMIT 1

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:54:21] /rapsody/www/bg/ajax/promocodes/1172331.html?PromoCode=KL123&_=1772524470146 108.61.209.243

set names utf8

SELECT
                `promocodes`.`ID`
            FROM
                `promocodes`
                INNER JOIN `reservations` ON
                    (`promocodes`.`OfferID` = `reservations`.`OfferID` OR `promocodes`.`OfferID` = 0) AND
                    (`promocodes`.`ProgramID` = 0 OR `promocodes`.`ProgramID` = `reservations`.`ProgramID`)
            WHERE
                `reservations`.`ID` = 1172331 AND
                `promocodes`.`PromoCode` = 'KL123' AND
                (CURDATE() BETWEEN `promocodes`.`StartFrom` AND `promocodes`.`EndTo` OR `promocodes`.`EndTo` IS NULL) AND
                `promocodes`.`Visible` = 1
            LIMIT 1

UPDATE
                `reservations`
            SET
                `LastUpdate` = NOW(),
                `PromoCodeID` = 1155
            WHERE
                `ID` = 1172331
            LIMIT 1
# [03-Mar-2026 09:54:21] /rapsody/www/bg/ajax/reservations/summary/1172331.html?_=1772524470197 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 176 AND
                `CardKey` = 'a41ad980349bfd520a21ea59f7d25c1a' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Mar-2026 09:54:30] /rapsody/www/bg/ajax/reservations/confirm/1172331/progress_5.html?_=1772524479191 108.61.209.243

set names utf8

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

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

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

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

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2026-03-03 09:54:30', `SentDate` = '2026-03-03', `Keywords` = 'Y2FyZAdGVzdAZGF2YXJza2lnbWFpbGNvbQ', `Data` = 'M7ZLjwunSKMYr_6iu9bGq43k9fUjFkpStCilPry2LVDT8OF8DLw-8foF0fd3JUt-FUPaBZPGZ0Tg068I4oK-2JrztLppQwKWD0Ply63Hvax8zerjyZHKrPB46FISCfGzFZWRW7ycXOUs1cl5GOlEsJtg6d0NsMp9RyZw2FeWz7nYENz28f9mNlR8yU-CS2R6eqF57p37sskyXJ0bTitwO3UTJ41DpOCrZgqwpRsJ16dIzQ-sEO92lnI6mXimJF6PzKKBDN24Z9yeREo8yxq2NuNzrPIbpIcWomFo18Ytonv8ZLp3wCK28HdUPjO2PHtd2gfbQf4GQ6VNCsDai9yaN100LgHepeMWkQTLQm-44abLKLaFunBn9K_4cPvZoU_WHyEeqaNguoweeIW1CRj1ql8I5_dDvjeYxDEi6WZTtwHQDFYuhk7_tz2geA5BFWmfx-wvnBhbL9h-0i_XvwOPnrNyDok9_OmjcDN4nziXRDMPWMG0m2gdy3ip3DF3BBva26Qpa1wXqVFwva23-ubBq-_d8iPl6Ja-se3Rvaow1a0XP-VuLaTXgajsHZP2oXvM7h3hf_q3C0ojW2tH0SE8riYKClaewqaadj91TFerf1LsvUAdHn-jwAOxOMJohxM00RsptfGEp1KzdTV6h-B8V91J1bZ-ahnvzZ3UVd6yGI0aX7uMGagikmC7fUReztDmbDsevqvWilVJXTjbnNZjsaHrlWYXKn6XSz3r3zKZCu5A8HanpY2YFxl1PGH6NfQPnK2O9CwQIKpcpHCkhMQdcHEMKXZ4_TqA_T4OdvV5LxWh-VwvQ_zPOmC5s_Asyf_c3QgKUNKUZPIVUVRZxbkk2HDDqNo_iVxo62UE7Ct0bcigQMQVwqxaRMRli_B-s7oG5iKGZD1QwIWT_Rt1SR8Bsre5uvxqqapxZnQarmVIZOO8I0qr-QQM319QJEOo6PurAiow1HIYmms6RbuZ_eQRv9l4qXtflhsIkhfcsvFSyVItHz-9eS3CQDmrU21n_h3jTBBSaoOPlg0qP-2pTBOrL1teymGj_IzESR_REPnmTJuypxwKFmX7-e-nxl-bLSgkPJMbIETCRLxmzxxVTIxuTnXKLUMT89EOVyUo6tvRfxIsbaaPnK7Pl4WsZSrh4DngXvSM-a7uq-opa4JThfDrphp2GNZUYH6bGnDwBQIOjJv8vOC4PhOX_UJ0HXcPQI1K20ju1sm3kyuS54yOyJO6mRG2IEqXG0p1678HfQE3MFheusvX6M8gmBYZLTef5JKOsFWflPG4rzlNBn6ID0csX00GS9DnevvoX3Cqzr1kqkFpQNcbXDuH-3oZyRHRLrN8XQiDyiotqTnt55PWhOMecwRPnZRf3ye22sgoxCV6R760-spW99CQFG3185zZaYV769J02McSmApvWk_ULgoplXd1GkQ1YvEtN_nRbxaaHnzyGTrlkD-6zPd9gJ5-xWu4gR-hKUM_x-A-ZcnHsSvNpdGGCZiS-Z7xTQ35ADdv-y1-V7inbNBrtLvSwvyi24BomQJKTJ87XfmLJ-Ts-0qPcTgvMuqukbICJSJ5uQsuOhsh_5EKV3rJRYyxpVW5Jazd7RPa5la7rx4zDUGJrf41OyWjT-aE84YSs3zqUrQcSs-X7NgkEHLIHJ0NmmUwo3UmcJdwclUElfHUwAoqEgyI-40ofFUuISiFb9RS0fKHHO3ykIGMNXNrW1Oo9cIUg75PRNn0H_7WTocdQp1IIa1vwrvJWP8noAxtq2eUszHXnFYsglqsGOCVWHbxoQNkF5qeQmnefWT2xH0Uq5Ov98BfuMwyp-zn2OppWUoCxBZepPHv2SMzzisRaWVmjaOdAlRHAsV0uy6kwMU1WF-HoDj4Bw69dhzUk_KQSZZRXXcxaLwxwzAvYyEwz1bmeOi-PHZxtuzmvBgq3X_672-rRCtf-wZrNJy2LXGgGa3oUZsb2OOPdMtBLggjTMfdCjAt10YHYqMKYOmE2sP9Qk42A93-Z4q85f6xTJgElFVhQi6jdj8glbO_V6v-uoD3YWqXzHdQPXB4YHvMtxn19mL6uOEmyweEud0qCTMuyJRv50dyQAKGst1y5-PPKrAyNXUSs3kwcCzlQ8sDhT1NCwYQZDLJnw', `Progress` = '5' WHERE `ID` = '1172331'

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

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

SELECT
                    `Exchange`
                FROM
                    `currencies`
                WHERE
                    `CharCode` = 'BGN'
             AND `Visible` = 1 LIMIT 1
# [03-Mar-2026 09:54:30] /rapsody/www/bg/ajax/reservations/send/1172331.html?_=1772524479248 108.61.209.243

set names utf8

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

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

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

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

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

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

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

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 176 AND
                `CardKey` = 'a41ad980349bfd520a21ea59f7d25c1a' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

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

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

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

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

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

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

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

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

SELECT
				`Title`
			FROM
				`rooms`
			WHERE
				`ID` = 35150 AND
				`Language` = 'bg' AND
				`Visible` = 1
			LIMIT 1

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    ('2026-03-03' BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

INSERT INTO `reservation_rooms`(`ReservationID`, `RoomID`) VALUES (1172331, 35150)

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

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

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

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

SELECT
                    *
                FROM
                    `promocodes`
                WHERE
                    `ID` = 1155 AND
                    (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                    (`ProgramID` = 1594 OR `ProgramID` = 0 OR `ProgramID` IS NULL) AND
                    `Visible` = 1
                LIMIT 1

UPDATE
                `promocodes`
            SET
                `Visible` = 0
            WHERE
                `ID` = 1155 AND
                `PromoCode` LIKE 'KL%' 
            LIMIT 1

SELECT
                    `Content`
                FROM
                    `templates`
                WHERE
                    `TplName` = 'promocode' AND
                    `Language` = 'bg' AND
                    `Visible` = 1
                LIMIT 1
# [03-Mar-2026 09:58:34] /rapsody/www/bg/ajax/reservations/offers.html?_=1772524722593 108.61.209.243

set names utf8

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

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