# [27-Aug-2025 08:20:45] /rapsody/www/bg/ajax/basket/qty.html?_=1756272045866 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 08:25:16] /rapsody/www/bg/ajax/basket/qty.html?_=1756272315828 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 08:39:38] /rapsody/www/bg/ajax/basket/qty.html?_=1756273178325 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 08:46:19] /rapsody/www/bg/ajax/basket/qty.html?_=1756273579609 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:01:01] /rapsody/www/bg/account.html 108.61.209.243

set names utf8

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:01:01] /rapsody/www/bg/ajax/basket/qty.html?_=1756281662105 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:01:01] /rapsody/www/bg/ajax/account/form/login.html?_=1756281662103 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorContractID','ErrorValidEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [27-Aug-2025 11:01:07] /rapsody/www/bg/ajax/account/login.html?_=1756281667772 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1
# [27-Aug-2025 11:01:07] /rapsody/www/bg/account/details.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

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

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:01:07] /rapsody/www/bg/ajax/basket/qty.html?_=1756281668035 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:01:09] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:01:09] /rapsody/www/bg/ajax/basket/qty.html?_=1756281669574 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:01:20] /rapsody/www/bg/ajax/payments/submit/1142818.html?_=1756281680781 108.61.209.243

set names utf8

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

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Data`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1142818, '[444]', 444)
# [27-Aug-2025 11:01:26] /rapsody/www/bg/ajax/basket/qty.html?_=1756281686412 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:04:42] /rapsody/www/bg/ajax/payments/submit/1142818.html?_=1756281882892 108.61.209.243

set names utf8

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

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Data`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1142818, '{"Guest0":444}', 444)
# [27-Aug-2025 11:04:47] /rapsody/www/bg/ajax/basket/qty.html?_=1756281887567 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:05:05] /rapsody/www/bg/ajax/payments/submit/1142818.html?_=1756281906138 108.61.209.243

set names utf8

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

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Data`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1142818, '', 997)
# [27-Aug-2025 11:05:08] /rapsody/www/bg/ajax/basket/qty.html?_=1756281908559 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:05:42] /rapsody/www/bg/ajax/payments/submit/1142818.html?_=1756281942370 108.61.209.243

set names utf8

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

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Data`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1142818, '{"Guest1":444}', 444)
# [27-Aug-2025 11:05:44] /rapsody/www/bg/ajax/basket/qty.html?_=1756281944316 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:06:00] /rapsody/www/bg/ajax/payments/submit/1142818.html?_=1756281961072 108.61.209.243

set names utf8

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

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Data`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1142818, '{"Guest0":444,"Guest1":444}', 888)
# [27-Aug-2025 11:06:02] /rapsody/www/bg/ajax/basket/qty.html?_=1756281963198 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:09:21] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:09:22] /rapsody/www/bg/ajax/basket/qty.html?_=1756282162435 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:09:46] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:09:47] /rapsody/www/bg/ajax/basket/qty.html?_=1756282187505 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:10:47] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:10:47] /rapsody/www/bg/ajax/basket/qty.html?_=1756282248040 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:11:01] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:11:01] /rapsody/www/bg/ajax/basket/qty.html?_=1756282262280 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:11:14] /rapsody/www/bg/ajax/payments/submit/1142818.html?_=1756282274980 108.61.209.243

set names utf8

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

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Data`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1142818, '{"Guest0":444}', 444)
# [27-Aug-2025 11:11:17] /rapsody/www/bg/ajax/basket/qty.html?_=1756282277703 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:52:15] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:52:15] /rapsody/www/bg/ajax/basket/qty.html?_=1756284736579 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:52:18] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:52:19] /rapsody/www/bg/ajax/basket/qty.html?_=1756284739964 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:52:27] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:52:27] /rapsody/www/bg/ajax/basket/qty.html?_=1756284748242 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:52:30] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:52:30] /rapsody/www/bg/ajax/basket/qty.html?_=1756284751219 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:52:46] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:52:46] /rapsody/www/bg/ajax/basket/qty.html?_=1756284767183 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 11:53:29] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 11:53:30] /rapsody/www/bg/ajax/basket/qty.html?_=1756284810884 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 12:03:40] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 12:03:40] /rapsody/www/bg/ajax/basket/qty.html?_=1756285421333 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 12:03:41] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 12:03:41] /rapsody/www/bg/ajax/basket/qty.html?_=1756285422745 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 12:03:47] /rapsody/www/bg/ajax/payments/submit/1142818.html?_=1756285428421 108.61.209.243

set names utf8

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

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Data`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1142818, '{"Guest1":444,"Guest2":609}', 1053)
# [27-Aug-2025 12:03:50] /rapsody/www/bg/ajax/basket/qty.html?_=1756285431329 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 12:04:16] /rapsody/www/bg/account/payments.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `OfferID`,
                `ProgramID`,
                `ClientID`,
                `Data`,
                `SentDate`
            FROM
                `reservations`
            WHERE
                `ContractID` = 1000000006
            LIMIT 1

SELECT
                `Destination`,
                `LocationURL`
            FROM
                `accommodation`
            WHERE
                `ID` = 713 AND
                `Language` = 'bg'
            LIMIT 1

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [27-Aug-2025 12:04:16] /rapsody/www/bg/ajax/basket/qty.html?_=1756285457562 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
# [27-Aug-2025 12:04:24] /rapsody/www/bg/ajax/payments/submit/1142818.html?_=1756285465005 108.61.209.243

set names utf8

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

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Data`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'reservations', 1142818, '{"Guest1":444,"Guest2":609}', 1053)
# [27-Aug-2025 12:04:26] /rapsody/www/bg/ajax/basket/qty.html?_=1756285467836 108.61.209.243

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = '5da1692c10b1f12046bcc921199a883ce9409ecdc0d3b7aa36fcbb21d0988516'
            LIMIT 1
