# [18-Jul-2025 09:06:07] /rapsody/root/ 167.99.142.201

set names utf8

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

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

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

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

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

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 238 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` <> 1361 AND
                    `OfferID` = 238 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` = 238 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` = 108 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` <> 1473 AND
                    `OfferID` = 108 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` = 108 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 112 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` <> 1485 AND
                    `OfferID` = 112 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` = 112 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` <> 1535 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` = 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` = 205 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` <> 1507 AND
                    `OfferID` = 205 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` = 205 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 246 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` = 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` <> 1542 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` = 77 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` <> 1504 AND
                    `OfferID` = 77 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` = 77 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 117 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` <> 1505 AND
                    `OfferID` = 117 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` = 117 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` = 202 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` = 202 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` = 202 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` = 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` <> 1511 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` = 225 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` <> 1459 AND
                    `OfferID` = 225 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` = 225 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 243 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` = 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` <> 1458 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` = 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` <> 1514 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` <> 1400 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` = 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
                    `StartFrom` AS `StartFrom2`,
                    `EndTo` AS `EndTo2`
                FROM
                    `programs`
                WHERE
                    `ID` <> 1477 AND
                    `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
                    MIN(`Price`) AS `MinPrice`
                FROM
                    `programs`
                WHERE
                    `Price` > 0 AND
                    `OfferID` = 201 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 106 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` <> 1460 AND
                    `OfferID` = 106 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` = 106 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 206 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` <> 1262 AND
                    `OfferID` = 206 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` = 206 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` = 206 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` = 216 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` <> 1474 AND
                    `OfferID` = 216 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` = 216 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 242 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` <> 1456 AND
                    `OfferID` = 242 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` = 242 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [18-Jul-2025 09:06:07] /rapsody/root/bg/ajax/basket/qty.html?_=1752818767703 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '9830eaba058de57347d0993eb6d8c05009562d7fee4547bc5bafa8ab78efb411'
            LIMIT 1
# [18-Jul-2025 09:06:10] /rapsody/root/bg/sunset-sensation-албания.html 167.99.142.201

set names utf8

SELECT
                        `Module`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `URLLabel` = 'sunset-sensation-албания' 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` = 'sunset-sensation-албания'
         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` = 112 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`
				LEFT JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`rooms`.`ProgramID` = 1485 AND
				`rooms`.`Visible` = 1 AND
				`reservation_rooms`.`RoomID` IS NULL
			LIMIT 1

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

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

SELECT
                    `accommodation`.*,
                    `programs`.`PromoDate`
                FROM
                    `accommodation`
                    INNER JOIN `offers` ON
                        `accommodation`.`OfferID` = `offers`.`ID` AND
                        `offers`.`Language` = `accommodation`.`Language`
                    INNER JOIN `rooms` ON
                        `rooms`.`AccommodationID` = `accommodation`.`ID` AND
                        `rooms`.`Language` = `accommodation`.`Language` AND
                        `rooms`.`ProgramID` = 1485
                    LEFT JOIN `programs` ON
                        `rooms`.`ProgramID` = `programs`.`ID` AND
                        `programs`.`Language` = `accommodation`.`Language`
                WHERE
                    `accommodation`.`OfferID` = 112 AND
                    `accommodation`.`Language` = 'bg'
             AND `accommodation`.`Visible` = 1 AND `offers`.`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` = 1485 AND
                `accommodation`.`Visible` = 1 AND
                `programs`.`Visible` = 1 AND
                `offers`.`Visible` = 1 AND
                `rooms`.`Visible` = 1 AND
                `reservation_rooms`.`RoomID` IS NULL
            GROUP BY 
                `rooms`.`Beds`
            ORDER BY 
                `rooms`.`Beds` ASC

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`reservation_rooms`.`RoomID` IS NULL AND
				`AccommodationID` = 713 AND
				`ProgramID` = 1485 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Beds`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`reservation_rooms`.`RoomID` IS NULL AND
				`AccommodationID` = 732 AND
				`ProgramID` = 1485 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Beds`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`reservation_rooms`.`RoomID` IS NULL AND
				`AccommodationID` = 838 AND
				`ProgramID` = 1485 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Beds`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT
				`rooms`.`ID`,
				`rooms`.`Beds`,
				`rooms`.`Title`,
				`rooms`.`Gallery`,
				`rooms`.`UploadID`,
				`rooms`.`Price`,
				`rooms`.`PromoPrice`
			FROM
				`rooms`
				LEFT OUTER JOIN `reservation_rooms` ON `reservation_rooms`.`RoomID` = `rooms`.`ID`
			WHERE
				`reservation_rooms`.`RoomID` IS NULL AND
				`AccommodationID` = 839 AND
				`ProgramID` = 1485 AND
				`Language` = 'bg' AND
				`Visible` = 1
			GROUP BY
				`rooms`.`Beds`
			ORDER BY
				`Beds` ASC,
				`Price` ASC

SELECT * FROM `faq` WHERE `OfferID` = 112 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,
                    `offers`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [18-Jul-2025 09:06:11] /rapsody/root/bg/ajax/basket/qty.html?_=1752818771081 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '9830eaba058de57347d0993eb6d8c05009562d7fee4547bc5bafa8ab78efb411'
            LIMIT 1
# [18-Jul-2025 09:06:12] /rapsody/root/bg/ajax/reservations/accommodation/oid_112/pid_1485.html?_=1752818771956 167.99.142.201

set names utf8

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

INSERT INTO `reservations` SET `ClientID` = '9830eaba058de57347d0993eb6d8c05009562d7fee4547bc5bafa8ab78efb411', `PostDate` = '2025-07-18 09:06:12', `LastUpdate` = '2025-07-18 09:06:12', `OfferID` = '112', `ProgramID` = '1485', `AccommodationID` = 0, `Data` = 'rmB8ds86G_LRpq02QzfH6kI1tSmKFXgAbTW21vuFZisy4JqCKsswYSn5CPiEcXIdPvDN8tVP4gFTU7JRRhEuZFZ6RIIjPQlbRMx0M5orltrYkKX8g2M9Vq8aC4wI_e1_JWpsoQLw-rK80sLJBoXiFnBVM0A1PTYhLX2gkY7RyInYVs0yZtaWoJb7c4BDzTD0TsuE-_nZBfrphtamUA7smfxHEVcNQpn671ptecEviNwOedzUtJ7uTQMnK21jNj-3DKhG2vQzOKZnoxc7jd61wW3vsLdv1W6JJRnMDhSW0muTao6IK5JPhWBp3TUL0zr3tVMC0pG3t_GRlXEJ4U14Zb-D55n6tQBF2zu9SSnqo_LyIKJ9wljZWZ8hsfyBi7ot', `Progress` = 1

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

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` = 112 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` = 1485 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` = 713 AND
			    `ProgramID` = 1485 AND
			    `Language` = 'bg' AND
			    `Visible` = 1
			ORDER BY `Price` ASC
			LIMIT 1

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-Jul-2025 09:06:14] /rapsody/root/bg/ajax/reservations/rooms/pid_1485/aid_713.html?_=1752818774274 167.99.142.201

set names utf8

SELECT
				`rooms`.* ,
				(
					SELECT
						GROUP_CONCAT(R1.`ID`)
					FROM
						`rooms` AS R1
						LEFT OUTER JOIN `reservation_rooms` AS RR1 ON RR1.`RoomID` = R1.`ID`
					WHERE
						R1.`AccommodationID` = 713 AND
						R1.`ProgramID` = 1485 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` = 713 AND
				`rooms`.`ProgramID` = 1485 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` = 1485 AND
				`offers`.`Language` = 'bg'
			LIMIT 1

SELECT
				`PromoDate`
			FROM
				`programs`
			WHERE
				`ID` = 1485 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
# [18-Jul-2025 09:06:17] /rapsody/root/bg/ajax/rooms/empty-bed-price/26831.html?_=1752818776937 167.99.142.201

set names utf8

SELECT
				`rooms`.`PriceEmptyBed`,
				`offers`.`Currency`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 26831 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [18-Jul-2025 09:06:17] /rapsody/root/bg/ajax/rooms/empty-bed-price/26831.html?_=1752818777651 167.99.142.201

set names utf8

SELECT
				`rooms`.`PriceEmptyBed`,
				`offers`.`Currency`
			FROM
				`rooms`
				INNER JOIN `accommodation` ON
					`rooms`.`AccommodationID` = `accommodation`.`ID` AND
					`rooms`.`Language` = `accommodation`.`Language`
				INNER JOIN `offers` ON
					`accommodation`.`OfferID` = `offers`.`ID` AND
					`accommodation`.`Language` = `offers`.`Language`
			WHERE
				`rooms`.`ID` = 26831 AND
				`rooms`.`Visible` = 1
			LIMIT 1
# [18-Jul-2025 09:06:18] /rapsody/root/bg/ajax/reservations/guests/14/progress_2.html?_=1752818778731 167.99.142.201

set names utf8

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Sep') 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` = 1485 AND
                    `accommodation`.`ID` = 713 AND
                    `programs`.`StartFrom` > CURDATE() AND
                    `reservation_rooms`.`RoomID` IS NULL
                GROUP BY
                    `accommodation`.`ID`
                ORDER BY
                    `accommodation`.`PostDate` ASC

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-07-18 09:06:18', `ProgramID` = '1485', `AccommodationID` = '713', `Data` = 'os7Z8GZTJl9fJPgApS6pR_ZkvMm9vNTu5nLuovBN8URfSZwv5dTj9uP2teM1ot9asgIT3pE2Cyhk1yCZw4q7ChENGMoGuvcAR4sCgsf_fdGK6WhJRTbX6M_i2eSELm6PLGuynjbHfE_-X2D1DkgxfCe6bK5t8kuSf5LgLn_oX0wMk0rYaDPW4osea6hFW5bonWrOJVvXYitF6cXsPtylewlYflFhseizVk6KtT_RH0Jd8ECLyVt8ECM2pLj6RiIXl8RWx2MoKbJj6JM4PRdSgf4wV0G1YzMwdXaM0aBH1OaP_6nE8q4Q2zDIeiW1-DDMxmFpTW2TTK2jJtmjrMbMgFtWRjUB6UIDShVuU2JLQo2k7PE-j6HqdqQCnezoAwJKEtWHcuUlndLNV6IZQsy8eM36Os97USrqCVrmEJFwjVsM6H7Omms1sgEfOXT6F8spt3dVmdoLkbPYbtrhR4scqdqVpYEpSp96ZBmt-Td7-opWvd4DOF41ju0UH8OhWWHaug8iwWsSlooWoOYie1itN83h8YcdmrxiM_Rz2Xw67f8P3rBmsNVpGmZ6Sry0DS4JVVUGehTbWdQ5znawxrGL8EOppeGputPhNdSy0V1QNlXUeYiUggJrbPBU4i4gKl3V4g2xr9dXGaZkwFmmWpWSLBiTCtKlS74K7_hWZui2JAIiscnYE8AI6kZ_mO9wpQHADqDUroxa3l5h7yh3rW2rHDPzz_N7i5kXVTTmwLom2TfmOB9pRan_FleAME6jxhJK', `Progress` = '2' WHERE `ID` = '14'

SELECT * FROM `reservations` WHERE `ID` = 14 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` = 26831 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
# [18-Jul-2025 09:06:29] /rapsody/root/bg/ajax/reservations/additionaloffers/14/progress_3.html?_=1752818789756 167.99.142.201

set names utf8

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-07-18 09:06:29', `Data` = 'dlk-eMduG_xRhAW4B8vRutrRYm2Af55y-U_xB8f1dDbFh6d-EmES3x9mkg0zl7cq0Rxuq72xlMjnloNtEqijyt9dgHktt9U6Y661dcIMt9Lc-Somwr3X3OdtZI_mqgG0q_s3h375Sd64_C0jr6dEDccsv9COn12UItvFwpg1ETvgSdoZU7iozqrRsb7otxNpEucixYkf6sYv1Y3yayZFJd0fxWeKZKq5p-wgQyezR4VpntdocG9waDp4yZejfR1CS4PTkj_RMlxRV7TAJOttvmFJw8iyiCnfaL1GwlsbUtckdu_BLhdbw85VK7SG7NLkCccRqe1Excx1MDhy3rpk3GLhJjF0RoCdh2ZsIozvvv4kHx4Ec0jRx2ndolt6h-yoCvPg7Lja_yloEpdG_W_oeGMWO52ksnukf2LyApoSoSEntcV0D4Xbw_EpGlyuI25x8Bj_GVgDrLvXyz9-_x5gkp9s06a-Fx6YsrarHb81Ike7mzqr9U6zsJk6RgjPJH86mb3oki4CdDZ8kBBt9r3A59QhT-TuEI2WVA-t7ceehJDj2h7WpK_G-8yl0TAoC4o4iUC_TL66X2LPD0BLPNJ7LZVEaMvFFHplWevnmkIiO7kFhhQNsapMRjat-yWh7-O7voI3h6n1N9qrE4ADkp7E2hjXkwq_su13VkxpggT9AI394Ho8oc_k_NyqEohovxhofDjvdyq0cWllYvSUYZhdWdpviY67Y2hP1QEj4tZnSN3L36WB75IsySE_axSkPfIW-0t-nACv_prkoBAMFzVdI6rO8u39Dgua8Zfocwp5pt5M93yAb9o4GKixaG2R2CPAufvlwo8wND6lHIwdG5PgQufDYJcnc7tl9jOXGIcZs1ym3XzSFFEj527YwuyrOscGhoRxFME_1vLeLWMdKYl-SDzNjnsUNUtHZhaWIS-6rEba_lTQOXBipATZyg3PusN5DYoyAUZrK1B5aluMZGWrfWIuIdt6ZXLafROHajl0BBlMWyDL4hBb9aT-NgKciV4NOX6eHdR60jkVhBe4T5sYOLr42YCG2iVEqsjl5gdN9rBklCjbTUuVqG3iz3buFJbPbjVqtRIzBfJloZA7W3ZMnTwYWSFy3Y8jPH2Nq-RMFt-LjDB5Yfl2dRFGpweXgCHkj-IoGyUlB4PLnEHmAjUnSWPysyaQUYzKzUvvhXMSy1omjWJi1SRuL47wd1IwqOsVL5UN2b4HlLBwm9Fhy19uvyPkCdK5oZvugj43wLpdwNVlB4OWipnsDEfVH2FaENEXC6EqL_9A3sjDyNp8x0KdiJPIsZhZcoSYAdVBBDFmgzwMR5QwyE71M3E6s_u5CDFa', `Progress` = '3' WHERE `ID` = '14'

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LBook','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-Jul-2025 09:06:33] /rapsody/root/bg/ajax/reservations/summary/14/progress_4.html?_=1752818793162 167.99.142.201

set names utf8

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

SELECT * FROM `reservations` LIMIT 1

SHOW COLUMNS FROM `reservations`

UPDATE `reservations` SET `LastUpdate` = '2025-07-18 09:06:33', `Data` = 'sle70FxgsOoqGDFGWftlwnQdZYIh6gwkifaQtjVkH8D4cElcaqGCHyyeW1A0lMnf66Aa2VtGWvOiolyDn4rBV4zSnKynVYRyaLPXzdrSGmkYLDAJ-wlvD26SoaPHD_rqzpAKR7NyzOiNU8p7V0Dl8CTWC1QxTX83OOTEYcjiIWWG1UmaYNSPK0sViM3pIQuX7GrGaSMlZ75nWZ2LcozntKDtGPbhj-NsWyWufva7Hr8lTMG06RT_HNfUpFbAh4lynxqXP-43hWFXWp3J4h6qsxJ9hVSd1sHGslVleKutwFFWTE9hRA88zvn7Y0NKpSYU2v3JkH-rD1_dPC7StrefZi4TyN3MellRHeqaGkyU5QfndZmw3eYRZJkigtxvSwrCbHCUQTFbeaK8s-6MDhH38j0uRYV1r8b6v83W1ajOGbMReHh3rHZ9vvjSiN3c2Szm_TPJ-I5ouzs0YEH2FyUuR21DWdP8JWJkvF8jS0wEnOOYQWPwLgWIU2DGRLsFLzXcGF0iDUK3vrWx7WlP-yNk5oF2BvBDFp9w9wW8CHPe74QFewIbJA39US6FVTxfVu55NvF6eYmmkrAA4YObgU2i6KAXuK7XCAV_9bBM95h94urr0yJMZxWgKj9TOiWvEZvJ5sGPeI5pjdXPdo0-3iONrcO-Y7BDUXE9mHfiTAklyPf3f5g1ZzavEnl2lIkrjxXbpln4KS8KrUe_M22oXzV2G8_ez7d-dSmIwJWQBA9P9YJ55vVXj-WLtfsoT_Y2RPFFFe6j--2oeKsWAtT2h_RJaZxLtwZrjJD5w-g6VqFL-aSVVtijhbRPUc_690NtSbC4IIkvCJKtV7GQmqsfZzg8sOQM7hCzDZc6F_jlY5dhegcTstnBQ396hJ8iZcAg06P6uBRM13hzrNjBCuN_EFv2wbKcDn4uFj4YufjLrMX1I4EtGDqMQRKffiMN9NEimRP6D_a2YvN0P_ewHicsI3H7EhCvnYeLsqxmdpl3IUgtny6IGZxg5KAEhChn6o3OUCJ5_vcq-jkl-sX3IJjM590jLBj9VkEWNfdSFiPJ0DdfTW4z62616OwT7GYq_oIqWYWpyx39ydg1JbyvdKA3Wh8KQavFlc7DyPx7pLlhYmuMrt0p2WWCzuV5-40d3oAHzI-zWW_snC1xcZ7vM28FIlYDEmdVQSEcBqNwk366K-Tw0ZyiUQuzKB8wEd2Nk6srjLrd6rECOqM_AMJU8Ha47PZxfLdNlEBsE9EbP5Y4YpKcXnd8DVzk419k7CprC42XjiveemUyOrTnjNkIvCJoAiCD2oM2W4cYDkQd8VpRdFAurN0SxbJJU3vh64y815uv65nV-lJpTdTeRGl-rhA7UeKEDw', `Progress` = '4' WHERE `ID` = '14'

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LEarlyBookingDiscount','LLoyalCustomerDiscount','LDeposit','LIntermediatePayment','LFinalPayment','LChildren12','LGuest','LChild12','LName','LBirthDate','LEMail','LEGN','LLKPassport','LPhone','LAccommodation','LAgreeMsg','LAgreeGeneralRules','LAgreeTourist','LAgreeBuletin','LFreeBedsPayment','LReservationInfo','LCheckIn','LCheckOut','LRoomsNum','LAdults','LHolder','LEditData','LTotal','LAdult','LPrice','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` = 14
            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` = 1485 AND
                    `accommodation`.`ID` = 713 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` = 1485 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` = 26831 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` = 112 AND
                `CardKey` = 'efeadeceb5f1077e0839d03893ae3cb5' AND
                `Visible` = 1
            LIMIT 1

SELECT
                `Discount`
            FROM
                `client_cards`
            WHERE
                `OfferID` = 112 AND
                `CardKey` = 'a2d417fff285a99cd412c58b0dd6584e' AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                *
            FROM
                `program_payments`
            WHERE
                `ProgramID` = 1485
            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

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