# [14-Oct-2024 14:18:06] /aria/www/ 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `UploadID`,
                `Images`,
                `Title`
            FROM
                `gallery`
            WHERE
                `Language` = 'bg' AND
                `Images` != '' AND
                `HomePage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 1
# [14-Oct-2024 14:20:54] /aria/www/ 108.61.209.243

set names utf8

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                `UploadID`,
                `Images`,
                `Title`
            FROM
                `gallery`
            WHERE
                `Language` = 'bg' AND
                `Images` != '' AND
                `HomePage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` DESC
            LIMIT 1

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

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

SELECT
                `UploadID`,
                `Rate`,
                `Image`,
                `FullName`,
                `Review`,
                `Media`,
                `MediaURL`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg' AND
                `Image` != '' AND
                `HomePage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` DESC
         LIMIT 0, 4

SELECT `Annotation` FROM `pages` WHERE`Module` = 'reviews' AND
	`URLLabel` = 'отзиви' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `reviews`
            WHERE
                `Image` != '' AND
                `Language` = 'bg' AND
                `Visible` = 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('AltLogo','Address','Phone','LContactUs','AddressFooter','EMail','BrandName','LBusinessHours','LWeekDays','LFollowUs','FacebookURL','InstagramURL','TripadvisorURL') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [14-Oct-2024 14:20:55] /aria/www/bg/ajax/cookies.html?_=1728904853940 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Oct-2024 14:20:58] /aria/www/bg/резервация.html 108.61.209.243

set names utf8

SELECT
                `Module`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'резервация'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Phone','AddressFooter','EMail','BrandName','LBusinessHours','LWeekDays','LContactEMail','LContactPhone') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('AltLogo','Address','LContactUs','LFollowUs','FacebookURL','InstagramURL','TripadvisorURL') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [14-Oct-2024 14:20:59] /aria/www/bg/ajax/requests/form.html?_=1728904858327 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMakeReservation','LName','LPhone','LEMail','LSelectHall','LPeopleNum','LSpecifyDate','LSpecifyHour','LComment','LBookTable') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorGuests','ErrorDate','ErrorHour','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ID`,
                `HallName`
            FROM
                `halls`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [14-Oct-2024 14:20:59] /aria/www/bg/ajax/calendar.json?_=1728904858627 108.61.209.243

set names utf8

SELECT
                `Date`
            FROM
                `calendar`
            WHERE
                `HallID` = 0 AND
                `Date` BETWEEN CURDATE() + INTERVAL 1 DAY AND DATE_ADD(CURDATE(), INTERVAL 3 MONTH);
# [14-Oct-2024 14:22:12] /aria/www/bg/ajax/requests/send.html?_=1728904931112 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReservation','LName','LPhone','LEMail','LGuests','LHall','LDate','LTime','LComment','ErrorIAgree','bg') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorName','ErrorPhone','ErrorEMail','ErrorGuests','ErrorDate','ErrorHour') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ID`
            FROM
                `calendar`
            WHERE
                `Date` = '2024-10-31' AND
                `HallID` = 2
            LIMIT 1

SELECT * FROM `requests` LIMIT 1

SHOW COLUMNS FROM `requests`

INSERT INTO `requests` SET `Language` = 'bg', `PostDate` = '2024-10-14', `LastUpdate` = '2024-10-14 14:22:12', `Data` = 'WY_PAxjrM0As5qPslNbeF38hnP5GbE-Izb_DXszYNiIf3SjIaFa_R9pimFO8YoPo6BH3yKc0jD-lGN_DWiUSwBpU7411yNlC7JTzs_s4Iv1kMaYpdFgucmgCTvC5DsoOEv-IpiPIVuNpoviEj2UT3CU8sO9Ewn-9ZiHN__-KMmSVU9jYqoj7XU4niCWC6egsgb3lrrtHxzL-8vbc-WUuRv6D77tK4P7oFAOosJxV0VQ', `SearchKey` = 'aHJpc3RvZGF2YXJza2kZGF2YXJza2kZ21haWwY29t', `HallID` = '2', `ResDate` = '2024-10-31', `ResTime` = '17:00', `Seats` = '5'

SELECT
                    CONCAT(P1.`URLLabel`, '/', P2.`URLLabel`) AS `URL`
                FROM
                    `pages` P1
                    INNER JOIN `pages` P2 ON
                        P1.`ID` = P2.`ParentID` AND
                        P1.`Language` = P2.`Language` AND
                        P1.`Module` = P2.`Module` AND
                        P1.`Visible` = P2.`Visible`
                WHERE
                    P1.`Language` = 'bg' AND
                    P1.`ParentID` = 1 AND
                    P1.`Module` = 'requests' AND
                    P2.`Action` = 'success'
             AND P1.`Visible` = 1 AND P2.`Visible` = 1 LIMIT 1
# [14-Oct-2024 14:22:12] /aria/www/bg/резервация/успешно.html 108.61.209.243

set names utf8

SELECT
                `Module`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'резервация'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'requests' AND
	    		`URLLabel` = 'успешно'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'успешно' AND
                P1.`Visible` = 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('AltLogo','Address','Phone','LContactUs','AddressFooter','EMail','BrandName','LBusinessHours','LWeekDays','LFollowUs','FacebookURL','InstagramURL','TripadvisorURL') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [14-Oct-2024 14:23:09] /aria/res/bg/ajax/staff/login.html?c=1234&_=1728904988500 108.61.209.243

set names utf8

SELECT
                CONCAT(`ID`, '.', CRC32(`PassCode`), '.', `Visible`) AS `Key`
            FROM
                `staff`
            WHERE
                `PassCode` = '1234'
            LIMIT 1
# [14-Oct-2024 14:23:09] /aria/res/ 108.61.209.243

set names utf8

SELECT
                                `Data`
                            FROM
                                `staff`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`PassCode`) = 2615402659 AND
                                `Visible` = 1
                            LIMIT 1

SELECT
                `reservations`.`ID`,
                `reservations`.`ResDate`,
                `reservations`.`ResTime`,
                `reservations`.`Seats`,
                `reservations`.`Specials`,
                `reservations`.`Comment` AS ResComment,
                `clients`.`Phone` AS ClientPhone,
                `clients`.`FullName` AS ClientName,
                `clients`.`Specials` AS ClientSpecials,
                `clients`.`Comment` AS ClientComment,
                `res_arrived`.`ReservationID` AS Arrived,
                `res_cancellations`.`ReservationID` AS Canceled
            FROM
                `reservations`
                INNER JOIN `clients` ON `clients`.`ID` = `reservations`.`ClientID`
                LEFT JOIN `res_cancellations` ON `res_cancellations`.`ReservationID` = `reservations`.`ID`
                LEFT JOIN `res_arrived` ON `res_arrived`.`ReservationID` = `reservations`.`ID`
            WHERE
                1
        
                ORDER BY
                    `reservations`.`ResDate` DESC,
                    `reservations`.`ResTime` DESC
             LIMIT 0, 100

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40123

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40478

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40316

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 29515

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40428

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 39702

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 39883

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40315

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40097

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40403

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40457

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40450

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40275

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40409

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40262

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40477

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40433

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40393

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40454

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40448

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40440

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40059

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40447

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40417

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40467

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40432

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40127

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40484

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40466

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40445

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40431

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40427

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40385

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40451

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 37526

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40442

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40394

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40492

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40491

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40490

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40480

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40438

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40488

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40463

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40416

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40402

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40487

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40485

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40482

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40452

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40279

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40493

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40481

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40472

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40479

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40476

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40474

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40469

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40384

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40486

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40470

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40468

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40464

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40455

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40426

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40475

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40425

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40483

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40471

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40461

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40441

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40423

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40465

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40473

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40291

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40460

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40449

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40462

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40459

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40458

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40439

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40444

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40456

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40446

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40443

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40206

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40437

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40401

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40422

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40429

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40281

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40435

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40434

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40424

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40415

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40436

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40430

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40419

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40420

SELECT
                `halls`.`HallName`,
                `tables`.`Number` AS `TableNumber`
            FROM
                `reservation_tables`
                INNER JOIN `tables` ON
                    `tables`.`ID` = `reservation_tables`.`TableID` AND
                    `tables`.`Visible` = 1
                INNER JOIN `halls` ON
                    `halls`.`ID` = `tables`.`HallID` AND
                    `halls`.`Visible` = 1
            WHERE
                `ReservationID` = 40412
# [14-Oct-2024 14:23:13] /aria/res/bg/requests.html 108.61.209.243

set names utf8

SELECT
                                `Data`
                            FROM
                                `staff`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`PassCode`) = 2615402659 AND
                                `Visible` = 1
                            LIMIT 1
