# [16-May-2026 13:43:45] /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
# [16-May-2026 13:43:45] /rapsody/www/bg/ajax/basket/qty.html?_=1778928225409 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '843267f3bc4db77af9457d55cfa609fc486b5d8b6fbecb042ef301759b3abb13'
            LIMIT 1
# [16-May-2026 13:44:07] /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
# [16-May-2026 13:44:07] /rapsody/www/bg/ajax/basket/qty.html?_=1778928246959 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '843267f3bc4db77af9457d55cfa609fc486b5d8b6fbecb042ef301759b3abb13'
            LIMIT 1
# [16-May-2026 13:44:19] /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
# [16-May-2026 13:44: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
# [16-May-2026 13:44:31] /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
# [16-May-2026 13:44:32] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 13:45:33] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 13:46:01] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 13:47:33] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 13:47:46] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 13:48: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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 13:51:44] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 13:51:51] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 13:53:27] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:04:21] /rapsody/www/rpV4nz0Sa0q/bg/reservations/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`.`StartFrom`,
                `programs`.`EndTo`,
                `offers`.`Title`
            FROM
                `programs`
                INNER JOIN `offers` ON `offers`.`ID` = `programs`.`OfferID` AND `offers`.`Language` = `programs`.`Language`
            WHERE
                `programs`.`EndTo` >= CURDATE() AND
                `programs`.`Language` = 'bg'
            ORDER BY
                `offers`.`Title` ASC,
                `programs`.`StartFrom` ASC

SELECT
               `reservations`.*,
               `accommodation`.`VoucherID`,
               `contracts`.`Revision`
            FROM
                `reservations`
                INNER JOIN `accommodation` ON `reservations`.`AccommodationID` = `accommodation`.`ID`
                -- INNER JOIN `offers` ON `reservations`.`OfferID` = `offers`.`ID`
                LEFT JOIN `contracts` ON `reservations`.`ID` = `contracts`.`ReservationID`
            WHERE
         `Status` > 1 AND `Progress` > 3 GROUP BY `reservations`.`ID` ORDER BY `reservations`.`SentDate` DESC, `reservations`.`LastUpdate` DESC LIMIT 0, 50

SELECT COUNT(*) AS NumRows FROM (SELECT
               `reservations`.*,
               `accommodation`.`VoucherID`,
               `contracts`.`Revision`
            FROM
                `reservations`
                INNER JOIN `accommodation` ON `reservations`.`AccommodationID` = `accommodation`.`ID`
                -- INNER JOIN `offers` ON `reservations`.`OfferID` = `offers`.`ID`
                LEFT JOIN `contracts` ON `reservations`.`ID` = `contracts`.`ReservationID`
            WHERE
         `Status` > 1 AND `Progress` > 3 GROUP BY `reservations`.`ID` ORDER BY `reservations`.`SentDate` DESC, `reservations`.`LastUpdate` DESC) AS CountTable
# [16-May-2026 14:04:23] /rapsody/www/bg/reservations/list/page_2.html? 108.61.209.243

set names utf8

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [16-May-2026 14:04:28] /rapsody/www/rpV4nz0Sa0q/bg/reservations/item/1181437.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` = 1181437 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` = 1181437
         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 ('Jun') 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
# [16-May-2026 14:05: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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:06:07] /rapsody/www/rpV4nz0Sa0q/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
                `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
# [16-May-2026 14:06:07] /rapsody/www/bg/ajax/basket/qty.html?_=1778929566875 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '843267f3bc4db77af9457d55cfa609fc486b5d8b6fbecb042ef301759b3abb13'
            LIMIT 1
# [16-May-2026 14:06:27] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:06:34] /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
                `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
# [16-May-2026 14:06:35] /rapsody/www/bg/ajax/basket/qty.html?_=1778929594549 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '843267f3bc4db77af9457d55cfa609fc486b5d8b6fbecb042ef301759b3abb13'
            LIMIT 1
# [16-May-2026 14:06:40] /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
# [16-May-2026 14:06:55] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:07:00] /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
# [16-May-2026 14:07:19] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:07:23] /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
# [16-May-2026 14:26:00] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:26:17] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:26:33] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:26:43] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:26:48] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_39.html?_=1778930807659 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
# [16-May-2026 14:27:13] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:31:14] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_41.html?_=1778931074000 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
# [16-May-2026 14:31:51] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:31:55] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_41.html?_=1778931114996 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` = 41 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Status` & 128 = 0 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, 41, 0, 'HfQzlfsq6vuvxuYx5bcn8NwbWmZSsC7aRPsunB82-kLdJHlSPuO38aH9vOTPSZXQEOgVmeRsi02uYtry3kdka_sFTVl94nq5xgzwIGr_3XufjD3IbfyWPgE7I3yddKcjduk9JK3jCvt8-6bC-179Ke5zmynlUgs6MJ3PGMhMiz681AocyIfYd8m0m0UCt5lzLvcBiRFuZt0oAHCCC0sDNUigC13WAVdU-Sd2qnjuOhVrCCN7yEeUzOxLknvEOTM9zd2LnVwObHgNZRp0GAmK98qhf5ouR9IrH3-xL-rre4ounbLQao8Xus9mHu-scqADsbJ81yuu35hMO-0hAexf9ZlizWTRq-USEX6KutbA7tiDF9xv4pPOaeXX4HGUZijvQgH1rsZAoZSt2BYArB_n0BnxSPxaNObC-sHrvvapLC5MVfj_6zRtyh06Qr69JmrbXYfqSnryDeCqtQpIb2CRRw')

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

DELETE FROM `tickets` WHERE `ID` = 1277283944 AND `OrderID` = 1181372 LIMIT 1
# [16-May-2026 14:32:17] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:32:26] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_39.html?_=1778931145902 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`.`Status` & 128 = 0 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, 'cfBU2aOcrq0D3v8qdD4wiBfnuXC89mT7U_TyzUh7cvB1e_FA6T6Sis4zqNQWXItZI36g_ZPIDws6b9Iuy1YmSYwgYwq-GV9rLa-MveXs2zM-nh-4Z-DHJ5WLZ4AlswsVBmeRikdkpTJoNUmVU3ywIH_Fs4vmf9JdOUIa5CJEpPcg1Upk5YzY68lW7YyC0SoUZhzIsClnWoX3oI_wbZQwYDqobBxMcPJGo5U2NifkDz8HQYupXiQXuG12qw5ma8h0iPR2C_vKNWvS4WPTHoqb98BfhDO2dr23YrnGvuF5vWzCbwMitgejF8Zf_XRwp4VvuAw2IFC4Idj84Bk-a6DALQv6Rqr0O8Bg_COewnv9jTfylcRMPzps8cNdCrLYxxaFP0m2wAjxLAOT6genE6_CcD-MTpj7p4y4ZjHxD2YEhas')

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

DELETE FROM `tickets` WHERE `ID` = 1277283945 AND `OrderID` = 1181372 LIMIT 1
# [16-May-2026 14:33:54] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:34:02] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_41.html?_=1778931241702 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` = 41 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Status` & 128 = 0 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, 41, 0, 'Lvmyg6KsafbbH5Or0FJcLdKPoFjKg29LXDFgRit6xIxMzJBVWeYVUMk0bUh5opt6r2gXhriaogn8lCmZUPaZaR5OzHnGEQ9XeDWPAp4V0ePWI9vJrIMP9gqVlYkzWsytgaldzOqAwW1vVJ0OvquGS-pKopPUlpJuMESEAiT8EkTuGp9Yuo_OWHXqrAICBy9ct_jZT5I5y1ItVRpOQSYQGXXc_XJufJbkP-cG203-T7MXEX_2SOftzYgkxyctEcvpLA8SoteJilVcabzNX1S7lBs6MB5ySixZPHrCwCn6ExLZddTI10qDzoR0rmUUXT_XZKcBSGCkF8Z2qUJls77mAxgG8Y2drpyIi-NoISv0k9PcSpN_-Ec9u3MKzlvgd_71L-FMveS3Muz5K-OLz60yuKgydiAmbkJLHnIjmDVTO4Fj5Zh9U61_pRPnLohpX2oRYPn9gW7jeJOf9ztK6UyD3w')

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

DELETE FROM `tickets` WHERE `ID` = 1277283946 AND `OrderID` = 1181372 LIMIT 1
# [16-May-2026 14:36:25] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:36:32] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_41.html?_=1778931391844 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` = 41 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Status` & 128 = 0 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, 41, 0, 'u2ay_5AUH6QzaiLndMKvfrru9ff2P32fD0v_4iJC1kRvd7ZHXUMLz5vC1pzyxy4iS47Zfm_LL25lut2WeiQjHruvfT8rXLmWm57MYdh4I9PdWKDYDfPMH6o6fdzEa5d8wQx2JJ9X0TOveLul0x92zLtsGnuPmcP_3fKGNJponFjBYfj9CEGRYXBwXfnYH2adQ1mQJ_nWgb2myzFqTkZiAbNeLX900AQx-h7Y498oya1oaFSkrFFrVbozor636pu4p9Od1fvG1HfuDxEphFmItuVg3DG7eJ7EvLTxoRHEHaMqA7vWsvUzZqpv-sdYYIsznp8tgi1fwr64Zxw2ZS5SA9WjvtvdxrEv8LjjLfCJtQkOyXb83eF7n6U8zB5b8FMBeqdE38Rztn8pYJQ1nMXMmh_mldVBHYD5nBxKReqOzCw-jLwg8ieu1GBJ7POFzIuE38OJ6xSR0VPTJzaZWrb8Iw')

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

DELETE FROM `tickets` WHERE `ID` = 1277283947 AND `OrderID` = 1181372 LIMIT 1
# [16-May-2026 14:36:49] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:36:55] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_41.html?_=1778931414772 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` = 41 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Status` & 128 = 0 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, 41, 0, '4wqxi3tQOI4TGmm4NToFgtv7WtTP-qEF4QCTwXbl8cNxLUgtPCeMHu4sy4R7cTOgviU9fvnEdCyNuk0nvb8jgWjwWh1sLRMoEpicw3XwvZtsTYSrXkkQX6xTex0K8P80A9voCzTyvlajb7uZOfaAmcqaZtbuZdxKRSOyDDcTbzT-XK21uXKyMBuuf_W7i2wl_NMLRDJ0daoX26Ei-yK54I7umSW5QiHyM6M7nqj3bfH9evP_npkXVxaDuUIt14lfb0SXzZ_98kUbJAWtu4Q4tSc2IGTwOK87Yw6plw7KGEIuDXmKEq06Q538sqkgcp1YTfo9DbcxVrHsUR-OpzOo5t6Pd_vE-HJaKEv26qGq-P3eb5wuDW8zQG_7ktEvDLfzGj_muqirbkSN7uJhlbMzLVmvXJjgcV7hiS7pWIOx9xyYFXiDB3P4B-dC8TKaplgLl_2ewxf57jPkE2htRtdHFw')

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

DELETE FROM `tickets` WHERE `ID` = 1277283948 AND `OrderID` = 1181372 LIMIT 1
# [16-May-2026 14:45:12] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:45:16] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_41.html?_=1778931916257 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
# [16-May-2026 14:46:05] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:46:09] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_41.html?_=1778931968492 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
# [16-May-2026 14:46:28] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:46:31] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_41.html?_=1778931991196 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` = 41 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Status` & 128 = 0 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, 41, 0, 'wkPHtCpW1fEo-S8_cPblpX3Cc2fKznCg5R68kctR4uZMqap-fpXbjjcN9I40zyimUqXmU99XNADlo8tcbwnt5YixoaYcNG-XEuc2ahldtWuVQzGB5Kj7cP7IvTpgDgXEdrCdjxFjgqu_RW_EHcctN3kgZXsGBXDgQI7aEDAbmil87vzcQAyEs04wOBj-oaej1g6aOBENj5Xc05aG28sad73vLXvdwDXZh_Vn-M2IbfiAEs__p88LYsKuuOE3kSP9iANuAKV6CnyaH3bDXbqwimw8BXCb53aABY63UKJ3IaXZC9SI9JgTSFB6yRVvNIhtHDuaNWwLjXAetKTsegeLYTuVFSYDkgnf1KfuEk3ou10QH7Xo1eCIZ8Mmqf_ZDLu5-Ugnb5W55EpTuO2k2Gu8wC6lvo5MRhMEURwaIVxEUsmQFhfmkUZgu1V2Sn3pD7uFpafv1gdjWl9WB_rea7HgzA')

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 (1181372, 41)
# [16-May-2026 14:47:43] /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`,
                `reservations`.`Status` & 128 AS `Sent`,
                `additionaloffers`.`Price`,
                `additionaloffers`.`Child12Price`,
                `additionaloffers`.`Child3Price`,
                `additionaloffers`.`ID` AS `AddOfferID`,
                `additionaloffers`.`EventID`,
                `events`.`Title`,
                `events`.`Currency`
            FROM
                `reservations`
                INNER JOIN `additionaloffers` ON `reservations`.`ProgramID` = `additionaloffers`.`ProgramID`
                INNER JOIN `events` ON `additionaloffers`.`EventID` = `events`.`ID`
            WHERE
                `reservations`.`ProgramID` = 1599 AND
                (`reservations`.`Status` & 16 OR `reservations`.`Status` & 64) AND
                `reservations`.`Progress` = 5
                
            ORDER BY
                `reservations`.`SentDate` DESC,
                `reservations`.`LastUpdate`
# [16-May-2026 14:51:09] /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
# [16-May-2026 14:53:45] /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`
# [16-May-2026 14:55:31] /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`
# [16-May-2026 14:56: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(`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`
# [16-May-2026 14:57:10] /rapsody/www/rpV4nz0Sa0q/bg/ajax/tickets/send/1181372/eid_39.html?_=1778932629675 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`.`Status` & 128 = 0 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, 'bmdETzQhxTIEHXmny3gGKlKmDQRx85iDju06GTYgjz1ZcWpwtxrUq41eBYXAJN2gvM9zOiilSD-HIIFocGEhSz83mSrCXhgDu6E4clE-qvkD4yYu9cLnaZDBXgAqXatYW5z_TGUEduLlc6AQNVmgJFglh9Wru-qrn08V7oH3GQQeTylIx182T2q2ttNC1YN1Sb2DMHQR-EiLml0EJy_9iqSv_0QjF84epdZ_uPczIwJWHKndXT-_CnS-AiKCwXg2AfyZLPr34KrR3bnxuNfh3uRzlLCj_bRmpeJY5AQneT_qXYrs9wh1G8j2FnbdvLoROjeFBnnb6MdWbvl3OP6Su3rcQsoWo9igM8nKKT2Qh2gIFoFFvsa9WisRhNCDkkM5jPAaFSSaxCsMwTtDjAmBSjijPX9yFqjJ1fEwbT444oM')

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)
# [16-May-2026 14:57:15] /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`
