# [19-May-2026 12:24:44] /rapsody/www/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1779182684623 108.61.209.243

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = '4luY15wDk4oiY4579jPgJwuPMWqbi487WoOzmHT75I8qxh505Xrdf8wA9TfRIaSZ'
            WHERE
                `UserKey` LIKE 'w6vCmsK9wqjCt8KhwrfCrMOew6LCpMOaw5vCuMOIwqXCmMKr%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1
# [19-May-2026 12:24:47] /rapsody/www/rpV4nz0Sa0q/bg/ajax/users/login.html?_=1779182688274 108.61.209.243

set names utf8

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

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

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `Module`,
                `Action`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [19-May-2026 12:24:50] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `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`,
                `reservations`.`ID` AS `ReservationID`,
                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` & 128)
         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`,
                `reservations`.`ID` AS `ReservationID`,
                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` & 128)
         ORDER BY `tickets`.`PostDate` DESC) AS CountTable
# [19-May-2026 12:24:51] /rapsody/www/bg/tickets/list/page_2.html 108.61.209.243

set names utf8

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [19-May-2026 12:24:59] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list.html?keyword=51244643&eid=&uid=0 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `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`,
                `reservations`.`ID` AS `ReservationID`,
                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` & 128)
         AND (`tickets`.`ID` LIKE '51244643%' OR `tickets`.`OrderID` LIKE '51244643%' OR `reservations`.`ContractID` LIKE '%51244643') 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`,
                `reservations`.`ID` AS `ReservationID`,
                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` & 128)
         AND (`tickets`.`ID` LIKE '51244643%' OR `tickets`.`OrderID` LIKE '51244643%' OR `reservations`.`ContractID` LIKE '%51244643') ORDER BY `tickets`.`PostDate` DESC) AS CountTable
# [19-May-2026 12:25:35] /rapsody/www/rpV4nz0Sa0q/bg/addoffers/list.html 108.61.209.243

set names utf8

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

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

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

set names utf8

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

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

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

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

set names utf8

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

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

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

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

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `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`,
                `reservations`.`ID` AS `ReservationID`,
                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` & 128)
         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`,
                `reservations`.`ID` AS `ReservationID`,
                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` & 128)
         ORDER BY `tickets`.`PostDate` DESC) AS CountTable
# [19-May-2026 12:25:52] /rapsody/www/bg/tickets/list/page_2.html 108.61.209.243

set names utf8

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

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

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [19-May-2026 12:25:55] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list.html?keyword=1181372&eid=&uid=0 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `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`,
                `reservations`.`ID` AS `ReservationID`,
                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` & 128)
         AND (`tickets`.`ID` LIKE '1181372%' OR `tickets`.`OrderID` LIKE '1181372%' OR `reservations`.`ContractID` LIKE '%1181372') ORDER BY `tickets`.`PostDate` DESC LIMIT 0, 100
# [19-May-2026 12:26:01] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list.html?keyword=1181372&eid=&uid=0 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `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`,
                `reservations`.`ID` AS `ReservationID`,
                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` & 128)
         AND (`tickets`.`ID` LIKE '1181372%' OR `tickets`.`OrderID` LIKE '1181372%' OR `reservations`.`ContractID` LIKE '%1181372') ORDER BY `tickets`.`PostDate` DESC LIMIT 0, 100
# [19-May-2026 12:28:23] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list.html?keyword=1181372&eid=&uid=0 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `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`,
                `reservations`.`ID` AS `ReservationID`,
                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 OR `reservations`.`Status` & 64)
         AND (`tickets`.`ID` LIKE '1181372%' OR `tickets`.`OrderID` LIKE '1181372%' OR `reservations`.`ContractID` LIKE '%1181372') 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`,
                `reservations`.`ID` AS `ReservationID`,
                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 OR `reservations`.`Status` & 64)
         AND (`tickets`.`ID` LIKE '1181372%' OR `tickets`.`OrderID` LIKE '1181372%' OR `reservations`.`ContractID` LIKE '%1181372') ORDER BY `tickets`.`PostDate` DESC) AS CountTable
# [19-May-2026 12:30:25] /rapsody/www/rpV4nz0Sa0q/bg/tickets/list.html?keyword=1181372&eid=&uid=0 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Title`
            FROM
                `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`,
                `reservations`.`ID` AS `ReservationID`,
                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 OR `reservations`.`Status` & 64)
         AND (`tickets`.`ID` LIKE '1181372%' OR `tickets`.`OrderID` LIKE '1181372%' OR `reservations`.`ContractID` LIKE '%1181372') 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`,
                `reservations`.`ID` AS `ReservationID`,
                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 OR `reservations`.`Status` & 64)
         AND (`tickets`.`ID` LIKE '1181372%' OR `tickets`.`OrderID` LIKE '1181372%' OR `reservations`.`ContractID` LIKE '%1181372') ORDER BY `tickets`.`PostDate` DESC) AS CountTable
