# [18-May-2026 10:34:04] /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` = 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` <> 1596 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
                `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` = 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` = 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
                `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` <> 1619 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` = 300 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` <> 1662 AND
                    `OfferID` = 300 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` = 300 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` <> 1616 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` <> 1626 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` 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` = 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` <> 1605 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` = 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` <> 1629 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` = 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
                    `StartFrom` AS `StartFrom2`,
                    `EndTo` AS `EndTo2`
                FROM
                    `programs`
                WHERE
                    `ID` <> 1606 AND
                    `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
                    MIN(`Price`) AS `MinPrice`
                FROM
                    `programs`
                WHERE
                    `Price` > 0 AND
                    `OfferID` = 261 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 50 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` <> 1623 AND
                    `OfferID` = 50 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` = 50 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` <> 1636 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` = 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` <> 1618 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` = 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` <> 1661 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` = 294 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` <> 1625 AND
                    `OfferID` = 294 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` = 294 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` <> 1665 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` = 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` <> 1664 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` = 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` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 55 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` <> 1639 AND
                    `OfferID` = 55 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` = 55 AND
                    `EndTo` >= CURDATE()
             AND `Visible` = 1

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

SELECT
                `ID` AS `ProgramID`,
                `StartFrom`,
                `EndTo`,
                `Nights`,
                `Price`,
                `PromoPrice`,
                `PromoDate`
            FROM
                `programs`
            WHERE
                `OfferID` = 296 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` <> 1638 AND
                    `OfferID` = 296 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` = 296 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` <> 1654 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` <> 1659 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` <> 1657 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` = 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` <> 1651 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` = 220 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`,
                `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
# [18-May-2026 10:34:04] /rapsody/www/bg/ajax/basket/qty.html?_=1779089644400 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '843267f3bc4db77af9457d55cfa609fc486b5d8b6fbecb042ef301759b3abb13'
            LIMIT 1
# [18-May-2026 10:34:12] /rapsody/www/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1779089652513 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '8dvZnsHkWJlk0o8tC9B4P99X566h8cp7jyjwDtI7572RdJaNRT836TyIh4D2nqH2'
            WHERE
                `UserKey` LIKE 'w6vCmsK9wqjCt8KhwrfCrMOew6LCpMOaw5vCuMOIwqXCmMKr%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [18-May-2026 10:34:15] /rapsody/www/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1779089655659 108.61.209.243

set names utf8

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

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [18-May-2026 10:34:16] /rapsody/www/rpV4nz0Sa0q/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [18-May-2026 10:34:30] /rapsody/www/rpV4nz0Sa0q/bg/addoffers/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `offers`
            ORDER BY
                `Title` ASC

SELECT
                `additionaloffers`.*,
                `offers`.`Title` AS `Offer`,
                `offers`.`Currency`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON `additionaloffers`.`OfferID` = `offers`.`ID`
                LEFT JOIN `programs` ON `additionaloffers`.`ProgramID` = `programs`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE
                `additionaloffers`.`OfferID` = 165
                
            ORDER BY  `Offer`, `PostDate` DESC
# [18-May-2026 10:34:38] /rapsody/www/rpV4nz0Sa0q/bg/addoffers/list.html?keyword=&oid=146 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `offers`
            ORDER BY
                `Title` ASC

SELECT
                `additionaloffers`.*,
                `offers`.`Title` AS `Offer`,
                `offers`.`Currency`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON `additionaloffers`.`OfferID` = `offers`.`ID`
                LEFT JOIN `programs` ON `additionaloffers`.`ProgramID` = `programs`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE
                `additionaloffers`.`OfferID` = 146
                
            ORDER BY  `Offer`, `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-May-2026 10:34:42] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`ticket_sent`.`ReservationID`, '-', `ticket_sent`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `ticket_sent` ON 
                    `reservations`.`ID` = `ticket_sent`.`ReservationID` AND 
                    `additionaloffers`.`EventID` = `ticket_sent`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 10:35:30] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`ticket_sent`.`ReservationID`, '-', `ticket_sent`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `ticket_sent` ON 
                    `reservations`.`ID` = `ticket_sent`.`ReservationID` AND 
                    `additionaloffers`.`EventID` = `ticket_sent`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 10:35:41] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html?keyword=1181291 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`ticket_sent`.`ReservationID`, '-', `ticket_sent`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `ticket_sent` ON 
                    `reservations`.`ID` = `ticket_sent`.`ReservationID` AND 
                    `additionaloffers`.`EventID` = `ticket_sent`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                 AND `reservations`.`ID` = 1181291
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 10:36:01] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181291/eid_41.html?_=1779089760906 108.61.209.243

set names utf8

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

SELECT
                `reservations`.`ID`,
                `reservations`.`ProgramID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`StartFrom`,
                `events`.`EndTo`,
                `events`.`StartTime`,
                `events`.`Currency`,
                `events`.`EventТemplateID`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ID` = 1181291 AND
                `additionaloffers`.`EventID` = 41 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Status` & 128 = 0 AND
                `reservations`.`Progress` = 5
            LIMIT 1
# [18-May-2026 10:36:24] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html?keyword=1181291 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`ticket_sent`.`ReservationID`, '-', `ticket_sent`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `ticket_sent` ON 
                    `reservations`.`ID` = `ticket_sent`.`ReservationID` AND 
                    `additionaloffers`.`EventID` = `ticket_sent`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                 AND `reservations`.`ID` = 1181291
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 10:36:31] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181291/eid_39.html?_=1779089790767 108.61.209.243

set names utf8

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

SELECT
                `reservations`.`ID`,
                `reservations`.`ProgramID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`StartFrom`,
                `events`.`EndTo`,
                `events`.`StartTime`,
                `events`.`Currency`,
                `events`.`EventТemplateID`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ID` = 1181291 AND
                `additionaloffers`.`EventID` = 39 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Status` & 128 = 0 AND
                `reservations`.`Progress` = 5
            LIMIT 1
# [18-May-2026 10:38:18] /rapsody/www/rpV4nz0Sa0q/bg/offers/list.html 108.61.209.243

set names utf8

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

SELECT
               *
            FROM
                `offers`
            WHERE 1
                
            ORDER BY  `Visible` DESC, `PostDate` DESC
# [18-May-2026 10:38:27] /rapsody/www/rpV4nz0Sa0q/bg/addoffers/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `offers`
            ORDER BY
                `Title` ASC

SELECT
                `additionaloffers`.*,
                `offers`.`Title` AS `Offer`,
                `offers`.`Currency`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON `additionaloffers`.`OfferID` = `offers`.`ID`
                LEFT JOIN `programs` ON `additionaloffers`.`ProgramID` = `programs`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE
                `additionaloffers`.`OfferID` = 165
                
            ORDER BY  `Offer`, `PostDate` DESC
# [18-May-2026 10:38:37] /rapsody/www/rpV4nz0Sa0q/bg/addoffers/list.html?keyword=&oid=146 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `offers`
            ORDER BY
                `Title` ASC

SELECT
                `additionaloffers`.*,
                `offers`.`Title` AS `Offer`,
                `offers`.`Currency`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON `additionaloffers`.`OfferID` = `offers`.`ID`
                LEFT JOIN `programs` ON `additionaloffers`.`ProgramID` = `programs`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE
                `additionaloffers`.`OfferID` = 146
                
            ORDER BY  `Offer`, `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-May-2026 10:39:02] /rapsody/www/rpV4nz0Sa0q/bg/programs/list.html 108.61.209.243

set names utf8

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

SELECT
                `programs`.`ID`,
                `programs`.`OfferID`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`,
                `programs`.`Nights`,
                `programs`.`Price`,
                `programs`.`PromoPrice`,
                `programs`.`Visible`,
                `offers`.`Currency`,
                `offers`.`Title`,
                COUNT(`reservations`.`ID`) AS `Reservations`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
                LEFT JOIN `reservations` ON
                    `programs`.`ID` = `reservations`.`ProgramID` AND
                    `programs`.`OfferID` = `reservations`.`OfferID`
            WHERE 1
                
            GROUP BY
                `programs`.`ID`
            ORDER BY
                 `programs`.`Visible` DESC, `programs`.`PostDate` DESC

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Aug') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-May-2026 14:37:46] /rapsody/www/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1779104266048 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'HBC6aMEW41t1m5iEn5MckpkAGY5OVU73091HBc6ANO4fE9H6hWDX7OCU4vYrXs2R'
            WHERE
                `UserKey` LIKE 'w6vCmsK9wqjCt8KhwrfCrMOew6LCpMOaw5vCuMOIwqXCmMKr%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [18-May-2026 14:37:49] /rapsody/www/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1779104269714 108.61.209.243

set names utf8

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

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1
            LIMIT 1
# [18-May-2026 14:37:49] /rapsody/www/rpV4nz0Sa0q/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [18-May-2026 14:37:57] /rapsody/www/rpV4nz0Sa0q/bg/addoffers/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `offers`
            ORDER BY
                `Title` ASC

SELECT
                `additionaloffers`.*,
                `offers`.`Title` AS `Offer`,
                `offers`.`Currency`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON `additionaloffers`.`OfferID` = `offers`.`ID`
                LEFT JOIN `programs` ON `additionaloffers`.`ProgramID` = `programs`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE
                `additionaloffers`.`OfferID` = 165
                
            ORDER BY  `Offer`, `PostDate` DESC
# [18-May-2026 14:38:02] /rapsody/www/rpV4nz0Sa0q/bg/addoffers/list.html?keyword=&oid=146 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `offers`
            ORDER BY
                `Title` ASC

SELECT
                `additionaloffers`.*,
                `offers`.`Title` AS `Offer`,
                `offers`.`Currency`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON `additionaloffers`.`OfferID` = `offers`.`ID`
                LEFT JOIN `programs` ON `additionaloffers`.`ProgramID` = `programs`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE
                `additionaloffers`.`OfferID` = 146
                
            ORDER BY  `Offer`, `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-May-2026 14:38:03] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`ticket_sent`.`ReservationID`, '-', `ticket_sent`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `ticket_sent` ON 
                    `reservations`.`ID` = `ticket_sent`.`ReservationID` AND 
                    `additionaloffers`.`EventID` = `ticket_sent`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 14:38:14] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181291/eid_39.html?_=1779104294565 108.61.209.243

set names utf8

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

SELECT
                `reservations`.`ID`,
                `reservations`.`ProgramID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`StartFrom`,
                `events`.`EndTo`,
                `events`.`StartTime`,
                `events`.`Currency`,
                `events`.`EventТemplateID`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ID` = 1181291 AND
                `additionaloffers`.`EventID` = 39 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Status` & 128 = 0 AND
                `reservations`.`Progress` = 5
            LIMIT 1
# [18-May-2026 14:59:28] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181291/eid_41.html?_=1779105567853 108.61.209.243

set names utf8

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

SELECT
                `reservations`.`ID`,
                `reservations`.`ProgramID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`StartFrom`,
                `events`.`EndTo`,
                `events`.`StartTime`,
                `events`.`Currency`,
                `events`.`EventТemplateID`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ID` = 1181291 AND
                `additionaloffers`.`EventID` = 41 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Status` & 128 = 0 AND
                `reservations`.`Progress` = 5
            LIMIT 1
# [18-May-2026 15:01:39] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`ticket_sent`.`ReservationID`, '-', `ticket_sent`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `ticket_sent` ON 
                    `reservations`.`ID` = `ticket_sent`.`ReservationID` AND 
                    `additionaloffers`.`EventID` = `ticket_sent`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 15:01:42] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181291/eid_39.html?_=1779105702514 108.61.209.243

set names utf8

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

SELECT
                `reservations`.`ID`,
                `reservations`.`ProgramID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`StartFrom`,
                `events`.`EndTo`,
                `events`.`StartTime`,
                `events`.`Currency`,
                `events`.`EventТemplateID`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ID` = 1181291 AND
                `additionaloffers`.`EventID` = 39 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Status` & 128 = 0 AND
                `reservations`.`Progress` = 5
            LIMIT 1
# [18-May-2026 15:04:03] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`ticket_sent`.`ReservationID`, '-', `ticket_sent`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `ticket_sent` ON 
                    `reservations`.`ID` = `ticket_sent`.`ReservationID` AND 
                    `additionaloffers`.`EventID` = `ticket_sent`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 15:04:08] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181291/eid_39.html?_=1779105847825 108.61.209.243

set names utf8

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

SELECT
                `reservations`.`ID`,
                `reservations`.`ProgramID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`StartFrom`,
                `events`.`EndTo`,
                `events`.`StartTime`,
                `events`.`Currency`,
                `events`.`EventТemplateID`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ID` = 1181291 AND
                `additionaloffers`.`EventID` = 39 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Status` & 128 = 0 AND
                `reservations`.`Progress` = 5
            LIMIT 1
# [18-May-2026 15:04:29] /rapsody/www/rpV4nz0Sa0q/bg/reservations/item/1181291.html 108.61.209.243

set names utf8

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-May-2026 15:06:21] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`ticket_sent`.`ReservationID`, '-', `ticket_sent`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `ticket_sent` ON 
                    `reservations`.`ID` = `ticket_sent`.`ReservationID` AND 
                    `additionaloffers`.`EventID` = `ticket_sent`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 15:06:26] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181291/eid_39.html?_=1779105986385 108.61.209.243

set names utf8

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

SELECT
                `reservations`.`ID`,
                `reservations`.`ProgramID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`StartFrom`,
                `events`.`EndTo`,
                `events`.`StartTime`,
                `events`.`Currency`,
                `events`.`EventТemplateID`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ID` = 1181291 AND
                `additionaloffers`.`EventID` = 39 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LTickets','LName','LEMail','LPhone','LQty','LQtyLabel','LType','LPrice','LTotal','LSent') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

INSERT INTO `tickets`
            (`PostDate`, `LastUpdate`, `OrderID`, `EventID`, `TypeID`, `Data`) VALUES
            (NOW(), NOW(), 1181291, 39, 0, '_32xAhwYAna08nT_HTlNBagE6khd25hp18UDigTEmxaSsfJCL66YTTiIY2Y-nW5iTv8fTpiVTLwufwlxlxRhMQUgDh17eC_WTRbgscL-aUsf-tFsnZuhSwL8NieAzE_ky55l2piAi8aRB3_-6EcyWjdib6pv9jCKbTApqprrI_3n-i54LYQajGUtygecefuoZ0VPS32pIhnrUXUcrFFnmx5sshs4hXxU996V5h9DcY05E5YehmrgKhsw3ikTiBbiGfGfc2ZWhqxV6RBVCX6XMmNZWeZVfA8E2IX_Ui1kEIqb1Baq3mY3G07yayXQQcJsOdVnC04XXHdMxmAs65Kz9qhBKHB5l4HkBpvZhKcxrGrfda8H9CtxRgfifLr_JOKqtcKYPqkW6HwzYm-cO-hQ08_W6wW3BtHGJHXvRbYnhNM')

SELECT
                `TicketContent`
            FROM
                `events`
            WHERE
                `ID` = 39 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                    `Content`
                FROM
                    `templates`
                WHERE
                    `ID` = '201' AND
                    `Language` = 'bg' AND
                    `Visible` = 1
                LIMIT 1

INSERT IGNORE INTO `ticket_sent`(`ReservationID`, `EventID`) VALUES (1181291, 39)
# [18-May-2026 15:07:26] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`ticket_sent`.`ReservationID`, '-', `ticket_sent`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `ticket_sent` ON 
                    `reservations`.`ID` = `ticket_sent`.`ReservationID` AND 
                    `additionaloffers`.`EventID` = `ticket_sent`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 16:12:36] /rapsody/www/rpV4nz0Sa0q/ 108.61.209.243

set names utf8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         ORDER BY `PostDate` ASC
# [18-May-2026 16:12:37] /rapsody/www/bg/ajax/basket/qty.html?_=1779109957810 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '843267f3bc4db77af9457d55cfa609fc486b5d8b6fbecb042ef301759b3abb13'
            LIMIT 1
# [18-May-2026 16:12:39] /rapsody/www/rpV4nz0Sa0q/bg/offers/list.html 108.61.209.243

set names utf8

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

SELECT
               *
            FROM
                `offers`
            WHERE 1
                
            ORDER BY  `Visible` DESC, `PostDate` DESC
# [18-May-2026 16:12:43] /rapsody/www/rpV4nz0Sa0q/bg/addoffers/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `offers`
            ORDER BY
                `Title` ASC

SELECT
                `additionaloffers`.*,
                `offers`.`Title` AS `Offer`,
                `offers`.`Currency`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON `additionaloffers`.`OfferID` = `offers`.`ID`
                LEFT JOIN `programs` ON `additionaloffers`.`ProgramID` = `programs`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE
                `additionaloffers`.`OfferID` = 165
                
            ORDER BY  `Offer`, `PostDate` DESC
# [18-May-2026 16:12:46] /rapsody/www/rpV4nz0Sa0q/bg/addoffers/list.html?keyword=&oid=146 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `offers`
            ORDER BY
                `Title` ASC

SELECT
                `additionaloffers`.*,
                `offers`.`Title` AS `Offer`,
                `offers`.`Currency`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `additionaloffers`
                INNER JOIN `offers` ON `additionaloffers`.`OfferID` = `offers`.`ID`
                LEFT JOIN `programs` ON `additionaloffers`.`ProgramID` = `programs`.`ID` AND `programs`.`OfferID` = `offers`.`ID`
            WHERE
                `additionaloffers`.`OfferID` = 146
                
            ORDER BY  `Offer`, `PostDate` DESC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('May') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-May-2026 16:12:47] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`ticket_sent`.`ReservationID`, '-', `ticket_sent`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `ticket_sent` ON 
                    `reservations`.`ID` = `ticket_sent`.`ReservationID` AND 
                    `additionaloffers`.`EventID` = `ticket_sent`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 16:12:55] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181291/eid_41.html?_=1779109975221 108.61.209.243

set names utf8

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

SELECT
                `reservations`.`ID`,
                `reservations`.`ProgramID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`StartFrom`,
                `events`.`EndTo`,
                `events`.`StartTime`,
                `events`.`Currency`,
                `events`.`EventТemplateID`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ID` = 1181291 AND
                `additionaloffers`.`EventID` = 41 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LTickets','LName','LEMail','LPhone','LQty','LQtyLabel','LType','LPrice','LTotal','LSent') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

INSERT INTO `tickets`
            (`PostDate`, `LastUpdate`, `OrderID`, `EventID`, `TypeID`, `Data`) VALUES
            (NOW(), NOW(), 1181291, 41, 0, 'wnHT5qHUuCkQuTvjMufScmycrkMToCsg0fokGI6b_n0tI2rXc-VcipY3kDpJQzjXj2lY2q8POxU6FLIZ29KqWmtOUpCoo_Yvm0aGhAs0csoUw2SD-pFfCGH2VQPie8r8-0cSpIhLJnE62XcxSMgvSzbRsvDT5h-0xJ9OgVQ1aZ26TaQINH4AbXdGAZ8iK53oKsoEqOebiD4kFHtVSnVFNMwHYe4miZij0HFyIbsdqtPg3skygHj-g3I-QhOWYp_ymlqROy7Yme46CTFPmJOSmwfitaNFbZLI7Z5kMY_84Ds9eEWGhB7Sw8Vyzz7P53CDMAdga4QvKQAJsW7mp4y4QAzN5vcX05WCJ-_gIWYRW3U2eFsSEA30P_M9iI81cuDsO3yrXBmHq9YEU-m-FpcPOeMNdjgsU9ac2wGoZXBbr98AW_zMyu7vYfG_C2eEWjMDv1xOS31kqNHsfvk8cD10_A')

SELECT
                `TicketContent`
            FROM
                `events`
            WHERE
                `ID` = 41 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                    `Content`
                FROM
                    `templates`
                WHERE
                    `ID` = '201' AND
                    `Language` = 'bg' AND
                    `Visible` = 1
                LIMIT 1

INSERT IGNORE INTO `ticket_sent`(`ReservationID`, `EventID`) VALUES (1181291, 41)
# [18-May-2026 16:16:35] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`ticket_sent`.`ReservationID`, '-', `ticket_sent`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `ticket_sent` ON 
                    `reservations`.`ID` = `ticket_sent`.`ReservationID` AND 
                    `additionaloffers`.`EventID` = `ticket_sent`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 16:16:41] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_39.html?_=1779110201212 108.61.209.243

set names utf8

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

SELECT
                `reservations`.`ID`,
                `reservations`.`ProgramID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`StartFrom`,
                `events`.`EndTo`,
                `events`.`StartTime`,
                `events`.`Currency`,
                `events`.`EventТemplateID`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ID` = 1181372 AND
                `additionaloffers`.`EventID` = 39 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LTickets','LName','LEMail','LPhone','LQty','LQtyLabel','LType','LPrice','LTotal','LSent') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

INSERT INTO `tickets`
            (`PostDate`, `LastUpdate`, `OrderID`, `EventID`, `TypeID`, `Data`) VALUES
            (NOW(), NOW(), 1181372, 39, 0, 'LwCO7wQfDztlFN00MG4sFQdukIhaHGjmO5KHqKNMku5j-BqjYqOEbTcQ_Owh66qzozLpQgkjDfi4izj4IRO5nWOBbJ3Jpphe19Q5JMZjOk2XFvh98qMFH9bmnBXGb9XDx4HADhsLlk494wKqmzvgc_yXg-gFl-pznx6Qz-z2dFjFT0Bl8Te64DlCmtgJzpQWlvsyhos6H0vHLpwMqvskrkPQeFDP5MUTZ_x5_XI4Ly0N0KfezygpumekRrSM8kOrpQD-KC6_ocYdPnDq6ftzGZ8EP0Z7hoTHSjcb-Ax_F9jjxSvACp0m8LwyGS52T9xkut4Jqa2dOMttlUwtfxuoUNcunJBzEkVqJ7kqTQJ-uIR0RihlEFunRVEBxlhbkxps5jYE_6PZNTY-l5KJwVeafyWvA7uDaDWQG2Zi9zTiaAw')

SELECT
                `TicketContent`
            FROM
                `events`
            WHERE
                `ID` = 39 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                    `Content`
                FROM
                    `templates`
                WHERE
                    `ID` = '201' AND
                    `Language` = 'bg' AND
                    `Visible` = 1
                LIMIT 1

INSERT IGNORE INTO `ticket_sent`(`ReservationID`, `EventID`) VALUES (1181372, 39)
# [18-May-2026 16:19:59] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`tickets`.`OrderID`, '-', `tickets`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `tickets` ON 
                    `reservations`.`ID` = `tickets`.`OrderID` AND 
                    `additionaloffers`.`EventID` = `tickets`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 16:22:59] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list/1599.html 108.61.209.243

set names utf8

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

SELECT
                `offers`.`Title`,
                `programs`.`StartFrom`,
                `programs`.`EndTo`
            FROM
                `programs`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `programs`.`OfferID` AND
                    `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`ID` = 1599
            LIMIT 1

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

SELECT
                `reservations`.`ID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`,
                CONCAT(`tickets`.`OrderID`, '-', `tickets`.`EventID`) AS `TicketSent`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `tickets` ON 
                    `reservations`.`ID` = `tickets`.`OrderID` AND 
                    `additionaloffers`.`EventID` = `tickets`.`EventID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            GROUP BY
                `reservations`.`ID`,
                `additionaloffers`.`EventID`
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [18-May-2026 16:23:05] /rapsody/www/rpV4nz0Sa0q/bg/reservations/item/1181372.html 108.61.209.243

set names utf8

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

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

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

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [18-May-2026 16:23:12] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_39.html?_=1779110592347 108.61.209.243

set names utf8

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

SELECT
                `reservations`.`ID`,
                `reservations`.`ProgramID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`StartFrom`,
                `events`.`EndTo`,
                `events`.`StartTime`,
                `events`.`Currency`,
                `events`.`EventТemplateID`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `tickets` ON 
                    `reservations`.`ID` = `tickets`.`OrderID` AND 
                    `additionaloffers`.`EventID` = `tickets`.`EventID`
            WHERE
                `reservations`.`ID` = 1181372 AND
                `additionaloffers`.`EventID` = 39 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5 AND
                `tickets`.`ID` IS NULL
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LTickets','LName','LEMail','LPhone','LQty','LQtyLabel','LType','LPrice','LTotal','LSent') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

INSERT INTO `tickets`
            (`PostDate`, `LastUpdate`, `OrderID`, `EventID`, `TypeID`, `Data`) VALUES
            (NOW(), NOW(), 1181372, 39, 0, 'BvrQnKfq_3R_XYXegMM3GKFGSZdwxLjJa_tI4qeNK-EKe8pNM0ETk5_SJiiLrgwcm1VA7o8c2mqP-XjviQroNMw27zzaWq0ai1dTWXJ3aNX9NBocOkQOy3oYY9QdNRmzD20dB0_ysxsXFfz7Go4PUsXxTTetv4KD-C8a4wxhATtULPbKTsmHfYcNF-9GLleWiyGa24ED1AZ7dETFoBsbINgh4QFrfdKuNls9-pbWeltyE7eH9AHy9COl8QBn2VndUrVzmhprTKANPzzQpaOzaGQphXIMYZ78eTs8USusVhyPaw86bad4RZTpQaE1PdG6bTb56_BhrVY3OIeCQhGQox5ytF2eL4rtgkc731Zuk2Nm1GOJyazbduEfVuUBRkgSHkIhUhlz4FzmnhGvIvCAPnrZxLUYFx7cZjNPIjv1SiY')

SELECT
                `TicketContent`
            FROM
                `events`
            WHERE
                `ID` = 39 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                    `Content`
                FROM
                    `templates`
                WHERE
                    `ID` = '201' AND
                    `Language` = 'bg' AND
                    `Visible` = 1
                LIMIT 1
# [18-May-2026 16:23:30] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_41.html?_=1779110610237 108.61.209.243

set names utf8

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

SELECT
                `reservations`.`ID`,
                `reservations`.`ProgramID`,
                `reservations`.`SentDate`,
                `reservations`.`ClientID`,
                `reservations`.`Data`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`StartFrom`,
                `events`.`EndTo`,
                `events`.`StartTime`,
                `events`.`Currency`,
                `events`.`EventТemplateID`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
                LEFT JOIN `tickets` ON 
                    `reservations`.`ID` = `tickets`.`OrderID` AND 
                    `additionaloffers`.`EventID` = `tickets`.`EventID`
            WHERE
                `reservations`.`ID` = 1181372 AND
                `additionaloffers`.`EventID` = 41 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5 AND
                `tickets`.`ID` IS NULL
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LTickets','LName','LEMail','LPhone','LQty','LQtyLabel','LType','LPrice','LTotal','LSent') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

INSERT INTO `tickets`
            (`PostDate`, `LastUpdate`, `OrderID`, `EventID`, `TypeID`, `Data`) VALUES
            (NOW(), NOW(), 1181372, 41, 0, 'M-UnbwDQwPWOizpJ6BJvQZkBZ06ikbK3Y6deE4_oLgwuk4SKYS5PFmQ_z6bvH8iTIbu9WFLDjUeVpen_R8TSpMKvLtoT5sGd1U7E31zsYZOWF63ee00s4WbgaJsLb7LMd3xL4ekUUguBkYHkH-sU2sE-abM8NuJvK884Ue-kVRXdoRTw6dAg011Tg_-_YyaSNBOFkz6rn7UilpCf6he39TrF9hJru9mCcrkOlaIyLhmlblydGfVZ4x7Mv-0dGR8YGZopBLPeJNJ3bbi20h0OoUNGKPmj8P34L7LdLKBz7HSvIAxtHFHUGhGiHK5_5SF-0oiCZR4cVqj1HOdLcr6pkrnOg2en3aoULXXJWVdK8oUEaLZkFrATV_GCOvOFBPV94vmOSC6rZ58Dj68v5tUTzvG8C2fHG-I9PLq9lZNjyvHndi3PT1I4bbfinIBtw3wCieHAkrgsrcfanFEx7uZ4IQ')

SELECT
                `TicketContent`
            FROM
                `events`
            WHERE
                `ID` = 41 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                    `Content`
                FROM
                    `templates`
                WHERE
                    `ID` = '201' AND
                    `Language` = 'bg' AND
                    `Visible` = 1
                LIMIT 1
