# [10-Feb-2025 16:45:57] /rapsody/root/rpV4nz0Sa0q/bg/tickets/list.html 167.99.142.201

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
                `events`
            ORDER BY
                `Title` ASC

SELECT
                `ID`,
                `UserKey`
            FROM
                `users`

SELECT
                `tickets`.`ID`,
                `tickets`.`PostDate`,
                `tickets`.`Status`,
                `tickets`.`Checked`,
                `tickets`.`Data` AS `TicketData`,
                `reservations`.`ClientID`,
                CASE
                    WHEN `reservations`.`ID` IS NULL
                       THEN `orders`.`Data`
                       ELSE `reservations`.`Data`
               END AS `Data`
            FROM
                `tickets`
                LEFT JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
                LEFT JOIN `reservations` ON `tickets`.`OrderID` = `reservations`.`ID`
            WHERE
                (`orders`.`Status` & 16 OR `reservations`.`Status` & 16)
         ORDER BY `tickets`.`PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `tickets`.`ID`,
                `tickets`.`PostDate`,
                `tickets`.`Status`,
                `tickets`.`Checked`,
                `tickets`.`Data` AS `TicketData`,
                `reservations`.`ClientID`,
                CASE
                    WHEN `reservations`.`ID` IS NULL
                       THEN `orders`.`Data`
                       ELSE `reservations`.`Data`
               END AS `Data`
            FROM
                `tickets`
                LEFT JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
                LEFT JOIN `reservations` ON `tickets`.`OrderID` = `reservations`.`ID`
            WHERE
                (`orders`.`Status` & 16 OR `reservations`.`Status` & 16)
         ORDER BY `tickets`.`PostDate` DESC) AS CountTable
# [10-Feb-2025 16:45:58] /rapsody/root/rpV4nz0Sa0q/bg/ajax/orders/51242249.html?_=1739198757935 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 51242249
            LIMIT 1

SELECT
                `tickets`.`ID`,
                `tickets`.`Data`,
                `tickets`.`Status`
            FROM
                `tickets`
            WHERE
                `tickets`.`OrderID` = 51242249
            ORDER BY
                `tickets`.`ID` ASC
# [10-Feb-2025 16:46:07] /rapsody/root/bg/events.html 167.99.142.201

set names utf8

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

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

SELECT
                `events`.*,
                (CURDATE() BETWEEN `SaleFrom` AND `SaleTo` OR `SaleTo` IS NULL) AS `InSale`,
                COUNT(`tickets`.`ID`) AS `Sold`
            FROM
                `events`
                LEFT JOIN `tickets` ON `events`.`ID` = `tickets`.`EventID`
            WHERE
                `Language` = 'bg'
         AND `events`.`Visible` = 1
            GROUP BY
                `events`.`ID`
            ORDER BY
                `events`.`PostDate` DESC
         LIMIT 0, 10

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

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

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

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

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

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

SELECT COUNT(*) AS NumRows FROM (SELECT
                `events`.*,
                (CURDATE() BETWEEN `SaleFrom` AND `SaleTo` OR `SaleTo` IS NULL) AS `InSale`,
                COUNT(`tickets`.`ID`) AS `Sold`
            FROM
                `events`
                LEFT JOIN `tickets` ON `events`.`ID` = `tickets`.`EventID`
            WHERE
                `Language` = 'bg'
         AND `events`.`Visible` = 1
            GROUP BY
                `events`.`ID`
            ORDER BY
                `events`.`PostDate` DESC
        ) AS CountTable

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

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [10-Feb-2025 16:46:08] /rapsody/root/bg/ajax/basket/qty.html?_=1739198767599 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1
# [10-Feb-2025 16:46:08] /rapsody/root/bg/ajax/orders/form/12.html?_=1739198768478 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 12 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 12

SELECT `ID` FROM `orders` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND `Status` = 0 LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LFullNameLatin','LEMail','LPhone','LAgreeText','ErrorIAgreeCheck','LAgreeData','ErrorNumber') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 12

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Feb-2025 16:46:25] /rapsody/root/bg/ajax/orders/submit/12.html?_=1739198784934 167.99.142.201

set names utf8

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

SELECT `ID` FROM `orders` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND `Status` = 0 LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2025-02-10 16:46:25', `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692', `Data` = 'IwgWKD_xPAk7Sq70bokZ4nshyClHjUUll3trNRdXcaczJ7KKGi_ts58GIldBBQZTL-pBWivJg2S9_N9SEq89WRfVfcECWSV_nX61z5Ny2mfbOarfn3BrpMZ7HfZQPfZZXVVyqc03W1-609OQ0FA-KbqNUZufS1hvqBjxyVF8otQzzUedell3CiX1XBp-aqhzkuFRuw7Ux5OSpzLz8L3kne5O6V_MCMdf6GSf9_s9-Do', `PostDate` = '2025-02-10 16:46:25'

SELECT
                `Data`
            FROM
                `orders`
            WHERE
                `ID` = 51242250 AND
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 12 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 12

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

DELETE FROM `reserved` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 12

INSERT INTO `reserved`
            (`ClientID`, `PostDate`, `EventID`, `TypeID`, `Num`) VALUES
            ('f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692', NOW(), 12, 0, 1)

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Feb-2025 16:46:27] /rapsody/root/bg/ajax/orders/confirm/51242250.html?_=1739198786733 167.99.142.201

set names utf8

SELECT
                `Data`
            FROM
                `orders`
            WHERE
                `ID` = 51242250 AND
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 12 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-02-10 16:46:27', `Module` = 'tickets', `Data` = 'XbeI9n9mPWRVlIvf6FTYEVwLtPB4z6m4Vr5Ctn2Q2agmzQVc9WITRJX5Vu0ZZZGFgur_pYxqD3qJdCjVHw_tZjKbTBBZtneAW_CDJaukY0rv3bxLZV-Kx2R1EFG3ijQd2c0IZ7GOMd2GpUkS9lzofFmNt1w_WQajHxcT2VTRo1TeuTeG8djacYNSkd-2a4lEalUeYOfHtju6PvCmh8zCYBXySULT9eptkWbwCdOkUyVKBMtxtvEqJGCfMOh29wrLkUYuJfLtCfH6szxjrgy1fsi7MClKLPcWazifJqsLdWuyDz_MC_DN4Cbh42eFV-DCw-vgD-I6dT56QNg0reXEBgmCLXRbvIzZPivDZFHuHMt08UFHWHSj-B0Y15alegdqmQj1mKFOMwIfKzveQ8B_SezhRzYHWYo5p8Ead6JDJmen2-44kAQK7pw5QLlYuOqITY8uKqtyd5Y-hjnApAdLXyhpdPCJ2k4SvjnA7MoAZSO08Z9K4VhlCEunobtA2Bd0YelyPrSfARrcBuVffThIfxwMgRkfMbYWxmapEKka7plCwAcCOCn3FmOt6-MzfM18VlSgQdvzAhwad2SYYKSpBKrgH07Sx-exzaawmZUoRNFs4QmQO62q1TZXFiqlwg4E4ddqnLD-ZhwHSvHmeOwwT5x0Nd3OAT3c3v81xQMPDOgvvSGJFV63w8_qXYr78T_nEsq0uvh1rYrSIEFZ_ycclH9bTkgNMRAKT_1GSmvJzv4', `SearchKey` = 'w5t8wqDCrsObw5t8wqDCrsObw5F8wpBmw5DCjMKgwq7DmMKiww5Fne8Kcw5jCi8w5BnwoPCw4R5wrFkw4TCrsKvZcOGwrTCpsOhw4DCk8', `Status` = 1 WHERE `ID` = '51242250'

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'orders', 51242250, 0.5)
# [10-Feb-2025 16:46:27] /rapsody/root/bg/payments/paid/borica/51242250_orders.html 167.99.142.201

set names utf8

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 16
                WHERE
                    `ID` = 51242250
                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
# [10-Feb-2025 16:46:27] /rapsody/root/bg/ajax/orders/send/51242250.html?_=1739198787021 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 51242250
            LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 16
                WHERE
                    `ID` = 51242250
                LIMIT 1

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 12 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `TypeID`,
                `Num`
            FROM
                `reserved`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND
                `EventID` = 12 AND
                `PostDate` >= NOW() - INTERVAL 10 MINUTE

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

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

INSERT INTO `tickets`
            (`PostDate`, `LastUpdate`, `OrderID`, `EventID`, `TypeID`, `Data`) VALUES
            (NOW(), NOW(), 51242250, 12, 0, '6884So6o7r8Iy3DXJxjJxNwZWmdkuVenKE5ktfRmd2Al_BJJVGFBa4LbuhF4-HwN-nBIwN8haKFezXvsbsJjo3IZwvIiFvk96f36TPZ6vIXDgCiv-1S2fib0CrT9KlmeNN1su1TMj-EvBmdSecpFxll-HiqpSwDXWktl8J4Q_OGe1i70_hwVCSAiVA6_uu65Gdy094kJ2LfThQmldA7BkcaW6epxqOX4BRWSrnoxUeUjgTyjNiIgNub_dNxF0Upv42wCQdNKjUnRp9KKn0NBiI9C76Zf6y3RzyImUSu2SsxDF73-NMyMmPS8WpgONiu3_wbHRiN6KZmb15SzeOYtwQ1u5rJ3dB5zRe27uDiieinCQXVpBhd6KOlykj0HwV2RiNftnSdbcp-lftC6sUK9bFosvd2TprukaSNhurpdaus')
# [10-Feb-2025 16:46:27] /rapsody/root/bg/ajax/basket/qty.html?_=1739198787022 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1

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

DELETE FROM `reserved` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 2
                WHERE
                    `ID` = 51242250
                LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 4
                WHERE
                    `ID` = 51242250
                LIMIT 1
# [10-Feb-2025 16:46:30] /rapsody/root/bg/orders/success.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'success' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Module` = 'orders' 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
# [10-Feb-2025 16:46:30] /rapsody/root/bg/ajax/basket/qty.html?_=1739198790129 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1
# [10-Feb-2025 16:46:36] /rapsody/root/rpV4nz0Sa0q/bg/tickets/list.html 167.99.142.201

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
                `events`
            ORDER BY
                `Title` ASC

SELECT
                `ID`,
                `UserKey`
            FROM
                `users`

SELECT
                `tickets`.`ID`,
                `tickets`.`PostDate`,
                `tickets`.`Status`,
                `tickets`.`Checked`,
                `tickets`.`Data` AS `TicketData`,
                `reservations`.`ClientID`,
                CASE
                    WHEN `reservations`.`ID` IS NULL
                       THEN `orders`.`Data`
                       ELSE `reservations`.`Data`
               END AS `Data`
            FROM
                `tickets`
                LEFT JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
                LEFT JOIN `reservations` ON `tickets`.`OrderID` = `reservations`.`ID`
            WHERE
                (`orders`.`Status` & 16 OR `reservations`.`Status` & 16)
         ORDER BY `tickets`.`PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `tickets`.`ID`,
                `tickets`.`PostDate`,
                `tickets`.`Status`,
                `tickets`.`Checked`,
                `tickets`.`Data` AS `TicketData`,
                `reservations`.`ClientID`,
                CASE
                    WHEN `reservations`.`ID` IS NULL
                       THEN `orders`.`Data`
                       ELSE `reservations`.`Data`
               END AS `Data`
            FROM
                `tickets`
                LEFT JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
                LEFT JOIN `reservations` ON `tickets`.`OrderID` = `reservations`.`ID`
            WHERE
                (`orders`.`Status` & 16 OR `reservations`.`Status` & 16)
         ORDER BY `tickets`.`PostDate` DESC) AS CountTable
# [10-Feb-2025 16:46:39] /rapsody/root/rpV4nz0Sa0q/bg/ajax/orders/51242249.html?_=1739198798638 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 51242249
            LIMIT 1

SELECT
                `tickets`.`ID`,
                `tickets`.`Data`,
                `tickets`.`Status`
            FROM
                `tickets`
            WHERE
                `tickets`.`OrderID` = 51242249
            ORDER BY
                `tickets`.`ID` ASC
# [10-Feb-2025 16:46:43] /rapsody/root/rpV4nz0Sa0q/bg/ajax/orders/51242250.html?_=1739198802869 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 51242250
            LIMIT 1

SELECT
                `tickets`.`ID`,
                `tickets`.`Data`,
                `tickets`.`Status`
            FROM
                `tickets`
            WHERE
                `tickets`.`OrderID` = 51242250
            ORDER BY
                `tickets`.`ID` ASC
# [10-Feb-2025 16:47:34] /rapsody/root/bg/events.html 167.99.142.201

set names utf8

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

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

SELECT
                `events`.*,
                (CURDATE() BETWEEN `SaleFrom` AND `SaleTo` OR `SaleTo` IS NULL) AS `InSale`,
                COUNT(`tickets`.`ID`) AS `Sold`
            FROM
                `events`
                LEFT JOIN `tickets` ON `events`.`ID` = `tickets`.`EventID`
            WHERE
                `Language` = 'bg'
         AND `events`.`Visible` = 1
            GROUP BY
                `events`.`ID`
            ORDER BY
                `events`.`PostDate` DESC
         LIMIT 0, 10

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

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

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

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

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

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

SELECT COUNT(*) AS NumRows FROM (SELECT
                `events`.*,
                (CURDATE() BETWEEN `SaleFrom` AND `SaleTo` OR `SaleTo` IS NULL) AS `InSale`,
                COUNT(`tickets`.`ID`) AS `Sold`
            FROM
                `events`
                LEFT JOIN `tickets` ON `events`.`ID` = `tickets`.`EventID`
            WHERE
                `Language` = 'bg'
         AND `events`.`Visible` = 1
            GROUP BY
                `events`.`ID`
            ORDER BY
                `events`.`PostDate` DESC
        ) AS CountTable

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

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [10-Feb-2025 16:47:34] /rapsody/root/bg/ajax/basket/qty.html?_=1739198854343 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1
# [10-Feb-2025 16:47:35] /rapsody/root/bg/ajax/orders/form/30.html?_=1739198855478 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 30 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 30

SELECT `ID` FROM `orders` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND `Status` = 0 LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LFullNameLatin','LEMail','LPhone','LAgreeText','ErrorIAgreeCheck','LAgreeData','ErrorNumber') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 30

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Feb-2025 16:47:41] /rapsody/root/bg/ajax/orders/submit/30.html?_=1739198860957 167.99.142.201

set names utf8

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

SELECT `ID` FROM `orders` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND `Status` = 0 LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2025-02-10 16:47:41', `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692', `Data` = 'wUkT1B0gFQcKDihvk0KrT3I17dkkEpuFlxI3DgUKTJR5Cwcpui7JgKG6AZsI-vghFOFOebPQW7Mo2MM1IOIcQ_oGlDPuX4SSM9w7NDULbxCftAIspBkAGfRAYHkfUNmfYwAYcUREi_Q6jO7446oOfxHGTLfAEjxi7quzPJRy2RQg46MPsz2WoqbwbmXGOnG9MUesbvaz1C0dVy-U8QJPntxn31cHtMB9v7IhdHqV9Rk', `PostDate` = '2025-02-10 16:47:41'

SELECT
                `Data`
            FROM
                `orders`
            WHERE
                `ID` = 51242251 AND
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 30 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 30

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

DELETE FROM `reserved` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 30

INSERT INTO `reserved`
            (`ClientID`, `PostDate`, `EventID`, `TypeID`, `Num`) VALUES
            ('f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692', NOW(), 30, 0, 1)

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Feb-2025 16:47:42] /rapsody/root/bg/ajax/orders/confirm/51242251.html?_=1739198862181 167.99.142.201

set names utf8

SELECT
                `Data`
            FROM
                `orders`
            WHERE
                `ID` = 51242251 AND
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 30 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-02-10 16:47:42', `Module` = 'tickets', `Data` = 'kHB2YIXJGO9bqEthGTXnnKUGFtKcOEgjnF31R6lwHBph79quWSC-Oic6N5x1xSGxEMOljkUhM8OlnFlFIEsJLh_igTSqGVfC0BTApN3SN1ZFfv-sAxpz5iIKIq5Zq7MKpW77FFET8WjXRGUVju4jkwPhvlYLsQB5MsIquHaYuONmLxLa96oMGqxVcRKMQfjyTUXwqiUh2Q1ZBmivwCrxWecY9efIyz-a9ZTv7ZHBOXUhkg5rWvqOz_C6jSV1S5q7QWNEDvTYyHfvX1lhKDtYKeJfuO1IviorwU2HYwk-s3yYcGysfx1quoxm2wJ3yPBU8B0rAjaHiqrz6Sb06oGCDjYR0Lrl_Gxox2tnaZAe364fK4kxSMK8L2G4gi1aYIyh58xF9ce9yXzTd4JOzTt86z6DtX_JOfzSlF-WORvP3IJb_lLg1ZytfHTNEbv-hHcZPFY1f5wb97aRYbS3BuAwjnPSeBUr3IHO_dkTBDN7hLwxd1Owb2tpP7yRuIaqzV1pQ7F9dw-VSOmrgZZsImsMrfgQcFDmnn8jMBgl27ODZ4LLPKXC814UdU_ZnnT-Onvaua0KZrMstn6BFuwREsRuw4cBZvV_FGm0La1MXnWiHi_6yWXKorJsItw4-T9crFePnbJRo4po6AU8i_HaGHGVE_EcJGg_apccR8BTKhtodKwJYGk7xqiP2b7dkkqEaotSOOVfgCQoYjP3p5v_wvZIMMycMVum5YJLO167gJF2NDEVJuQR1vIwIlihGRsc7yP-', `SearchKey` = 'w5t8wqDCrsObw5t8wqDCrsObw5F8wpBmw5DCjMKgwq7DmMKiww5Fne8Kcw5jCi8w5BnwoPCw4R5wrFmw4XCiMKfZ8OFw4TCnMOkw4DCo8', `Status` = 1 WHERE `ID` = '51242251'

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'orders', 51242251, 0.5)
# [10-Feb-2025 16:47:42] /rapsody/root/bg/payments/paid/borica/51242251_orders.html 167.99.142.201

set names utf8

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 16
                WHERE
                    `ID` = 51242251
                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
# [10-Feb-2025 16:47:42] /rapsody/root/bg/ajax/orders/send/51242251.html?_=1739198862493 167.99.142.201

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 51242251
            LIMIT 1
# [10-Feb-2025 16:47:42] /rapsody/root/bg/ajax/basket/qty.html?_=1739198862494 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 16
                WHERE
                    `ID` = 51242251
                LIMIT 1

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 30 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `TypeID`,
                `Num`
            FROM
                `reserved`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND
                `EventID` = 30 AND
                `PostDate` >= NOW() - INTERVAL 10 MINUTE

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

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

INSERT INTO `tickets`
            (`PostDate`, `LastUpdate`, `OrderID`, `EventID`, `TypeID`, `Data`) VALUES
            (NOW(), NOW(), 51242251, 30, 0, '805CO2Y0LQZQH5ByE8vvuJeL0NjKQ1t20xmA4JhuVB1qZQYLkqoH75RorYbOMroo898ltAhyhD0FEIB49DUYPvPBt1OnsqY54igRxrKIe2Q0uYlIjB1or_VS40vdVX4U04nB-XqtwXNi8bNZvvKBtZwFErMtHWdei8Xgq5KCH5T9kqWYP8QbIao-NPzNBpr63d2WugRXwgmYrdW3Oyn-wxBE0qUxzC3hVRwHHl6k8zBmqAsaf-8PrpP7v9AdSYLdHSpAmGoobTwWw1kCUVbNJHUtd_x0SNyP0vUgAoKPpRZA6_H5yAqZKPHfiQFBXL7TPX6IhbhAvgrA04Nisj1DVC7nrBhh_DqmpVhowEGiFzOxAqFEruo9st28JvsQVd-lM7hZlMLBQS-2JpdhwrIixMD09V_g3uYHjC-343miiM48jeZmibm3YD1U-ruDMR-q')

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

DELETE FROM `reserved` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 2
                WHERE
                    `ID` = 51242251
                LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 4
                WHERE
                    `ID` = 51242251
                LIMIT 1
# [10-Feb-2025 16:47:46] /rapsody/root/bg/orders/success.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'success' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Module` = 'orders' 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
# [10-Feb-2025 16:47:47] /rapsody/root/bg/ajax/basket/qty.html?_=1739198866567 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1
# [10-Feb-2025 16:56:03] /rapsody/root/bg/events.html 167.99.142.201

set names utf8

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

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

SELECT
                `events`.*,
                (CURDATE() BETWEEN `SaleFrom` AND `SaleTo` OR `SaleTo` IS NULL) AS `InSale`,
                COUNT(`tickets`.`ID`) AS `Sold`
            FROM
                `events`
                LEFT JOIN `tickets` ON `events`.`ID` = `tickets`.`EventID`
            WHERE
                `Language` = 'bg'
         AND `events`.`Visible` = 1
            GROUP BY
                `events`.`ID`
            ORDER BY
                `events`.`PostDate` DESC
         LIMIT 0, 10

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

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

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

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

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

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

SELECT COUNT(*) AS NumRows FROM (SELECT
                `events`.*,
                (CURDATE() BETWEEN `SaleFrom` AND `SaleTo` OR `SaleTo` IS NULL) AS `InSale`,
                COUNT(`tickets`.`ID`) AS `Sold`
            FROM
                `events`
                LEFT JOIN `tickets` ON `events`.`ID` = `tickets`.`EventID`
            WHERE
                `Language` = 'bg'
         AND `events`.`Visible` = 1
            GROUP BY
                `events`.`ID`
            ORDER BY
                `events`.`PostDate` DESC
        ) AS CountTable

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

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

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

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

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [10-Feb-2025 16:56:04] /rapsody/root/bg/ajax/basket/qty.html?_=1739199363657 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1
# [10-Feb-2025 16:56:07] /rapsody/root/bg/ajax/orders/form/30.html?_=1739199367044 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 30 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 30

SELECT `ID` FROM `orders` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND `Status` = 0 LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LHolderDetails','LFullNameLatin','LEMail','LPhone','LAgreeText','ErrorIAgreeCheck','LAgreeData','ErrorNumber') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 30

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Feb-2025 16:56:13] /rapsody/root/bg/ajax/orders/submit/30.html?_=1739199372692 167.99.142.201

set names utf8

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

SELECT `ID` FROM `orders` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND `Status` = 0 LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2025-02-10 16:56:13', `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692', `Data` = 'UC5OIW2CQJz_WbNL0qAiyq4hDT6uZRa9yrd1Ep6jlR77exjH8HTIwhfsnimO_ApXhXs-YGQzsc5OFyHVm0Do9qBh3X9BtMy2vK_g1MNZAbFW_QS8sYym62Q9YBoZgbUnLU8x32LRepw4fdtFCGFDXeTg6kpZB49uJ4Byh3ktR7GVYFNfUkThYQTVx03r3hkWY8Em9mG-yMaJm1NDUgrgy6H5vi11YwhDfAh4H8VLQj8', `PostDate` = '2025-02-10 16:56:13'

SELECT
                `Data`
            FROM
                `orders`
            WHERE
                `ID` = 1 AND
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 30 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 30

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

DELETE FROM `reserved` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'

SELECT COUNT(`ID`) FROM `tickets` WHERE `EventID` = 30

INSERT INTO `reserved`
            (`ClientID`, `PostDate`, `EventID`, `TypeID`, `Num`) VALUES
            ('f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692', NOW(), 30, 0, 1)

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LGoAhead','LPay') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Feb-2025 16:56:14] /rapsody/root/bg/ajax/orders/confirm/1.html?_=1739199374403 167.99.142.201

set names utf8

SELECT
                `Data`
            FROM
                `orders`
            WHERE
                `ID` = 1 AND
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 30 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2025-02-10 16:56:14', `Module` = 'tickets', `Data` = 'SSYeQxFNS5AYqV7SFVe-lUoayR8reBQZyD5aqeWwvCWIDnIiWCQJxjCd1RmnK2cP3GmH0T1eGdVwLJSQywVsIlAGujzZ_nj9vxcUGdcbgPKlP1RiEBGS2Kye9ZllSQ9LQN_btGaLoYmYAQvKyn2gw0U--IQop9wuLNoe2tn3ueBIl8OCIzz5_6dq5AYzf4mQXIW2a9CmHTJGa5V1JzA1s9GlBKNJMWBTTLCV93E7VtNyu147FwmHAWOU_GaATP5zTFVN45qbHmgdqW4CGOeLVdSZstKxeg3x90gk-jkQzvPom-iRzDqOrmvZpam6e0B0DoJrPUvlvSsbKW3PmZMchZNEYUciw_F39lkJ0ocSW6JI86Lg8Oe2uQuA60YYL9FknEl1tFtkqBwQgoAXzXMjOMGKea0prRujpNXUCybnrrW_9wpsKtImEo6RSJTKgP7HGoTbt8Ep0T36nHvlexFTqM0CwH8pMHCuoJ4UMSgW49zQnluMv6Rtl1rYLGIXr7j25JjuhmOOI_gwu0v_-46H3hZ214tJSatSvhkq6_hFeLPmz4I19QxO-L4UCxT2QMt5rMBHAdVFJXytCEUHnq1wXs0AIHIp71fjltln8ZK-OYD8KFo4Fb7nu8eeuVrfUqPBQsUK7jJwixFbI2Cvnu6Ld7zqez1Kt4_QawRkxUGYdMY6I-7tm3ctEG0MTVZMqTCe3RaD2aHcZeLUblHTZMsg6w', `SearchKey` = 'w5t8wqDCrsObw5t8wqDCrsObw5F8wpBmw5DCjMKgwq7DmMKiww5Fne8Kcw5jCi8w5BnwoPCw4R5wrFmw4TCiMKfZ8OEwrTChMKew4HCo', `Status` = 1 WHERE `ID` = '1'

INSERT INTO `borica`
            (`Language`, `PostDate`, `LastUpdate`, `Module`, `ModuleID`, `Amount`) VALUES
            ('bg', NOW(), NOW(), 'orders', 1, 0.5)
# [10-Feb-2025 16:56:14] /rapsody/root/bg/payments/paid/borica/1_orders.html 167.99.142.201

set names utf8

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 16
                WHERE
                    `ID` = 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
# [10-Feb-2025 16:56:15] /rapsody/root/bg/ajax/orders/send/1.html?_=1739199374773 167.99.142.201
# [10-Feb-2025 16:56:15] /rapsody/root/bg/ajax/basket/qty.html?_=1739199374774 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1

set names utf8

SELECT
                *
            FROM
                `orders`
            WHERE
                `ID` = 1
            LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 16
                WHERE
                    `ID` = 1
                LIMIT 1

SELECT
                *
	        FROM
	        	`events`
	    	WHERE
	    		`ID` = 30 AND
                `Language` = 'bg'
         AND `Visible` = 1 LIMIT 1

SELECT
                `TypeID`,
                `Num`
            FROM
                `reserved`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692' AND
                `EventID` = 30 AND
                `PostDate` >= NOW() - INTERVAL 10 MINUTE

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

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

INSERT INTO `tickets`
            (`PostDate`, `LastUpdate`, `OrderID`, `EventID`, `TypeID`, `Data`) VALUES
            (NOW(), NOW(), 1, 30, 0, 'xQjZXIfT9B13yZXP-bf8cpjvk6knhuLPuPyfDoAXdTnYSg8M5Jd2bWl1I4M6p1opOUvgV69UAKIWcd834xExs-SjaT_BxXedWJTUvBwsPBWZV0ScIQXKeXVaeMFkRzJ7EvAqS1JvOICEjRjicNL6QK1pm5rMsmB_rJGEbpF5FzrdWLyGrkIZWguiILkyZK8N14F3slshmW5gYw4OZaci3S5famHt8QIMroZMA2OCatwjMqn-xL9jxZy9YOKY2SJ2niplv3KhVdEpyrN38LqRJajIE-gjwanhZoyXGiy4uvAmYtd-ghEx7DJZBo711Y5GLEdtugP2OLv4Tcaq-BOdhUglUqqE5t1kMpT2RqzwTopq6g2K2-aA93Yokwzxteu6QYCSmrRRBYG0KbV4FrxGbTB2CXMlVlIYdMVEiCKVbEistILAcsotd25QCdOsH5rX')

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

DELETE FROM `reserved` WHERE `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 2
                WHERE
                    `ID` = 1
                LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 4
                WHERE
                    `ID` = 1
                LIMIT 1
# [10-Feb-2025 16:56:17] /rapsody/root/bg/orders/success.html 167.99.142.201

set names utf8

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'success' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Module` = 'orders' 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
# [10-Feb-2025 16:56:17] /rapsody/root/bg/ajax/basket/qty.html?_=1739199377431 167.99.142.201

set names utf8

SELECT
                `Qty`
            FROM
                `basket`
            WHERE
                `ClientID` = 'f2f373b534c83c569a6eaafe559d332d368b65395a11f0ce3d8411f68ad43692'
            LIMIT 1
