# [18-Apr-2026 10:48:50] /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 `MenuLabel`, `URLLabel`, `Annotation` FROM `pages` WHERE`Language` = 'bg' AND
	`Module` = 'requests' AND
	`Action` = 'index' AND
	`Visible` = 1 AND
	`Visible` = 1 LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('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
# [18-Apr-2026 10:48:50] /aria/www/bg/ajax/cookies.html?_=1776498530628 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
# [18-Apr-2026 10:49:16] /aria/www/aD4rbSw2A0/bg/ajax/users/login.html?_=1776498556643 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'NzkzYjAzNGI1NTAwNmYyNjE4ZTE0YTgxNTRhMjY0MTIYjFhNTYxNzFmZThiOWY0YjI0NWU5MzU5Mzg0NTk5NTc%'
            LIMIT 1
# [18-Apr-2026 10:49:16] /aria/www/aD4rbSw2A0/bg/pages/list.html 108.61.209.243

set names utf8

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

SELECT
                `pages`.`ID`,
                `pages`.`Language`,
                `pages`.`Module`,
                `pages`.`Action`,
                `pages`.`PostDate`,
                `pages`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` IS NULL, `pages`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `pages`.`URLLabel`)) AS `URLLabel`,
                `pages`.`Visible`
            FROM
                `pages`
                LEFT JOIN `pages` AS `Parent` ON
                    `Parent`.`ParentID` = 1 AND
                    `pages`.`ParentID` = `Parent`.`ID` AND
                    `pages`.`Language` = `Parent`.`Language`
            WHERE
                `pages`.`Language` = 'bg'
         ORDER BY `pages`.`PostDate` ASC
# [18-Apr-2026 10:49:21] /aria/www/aD4rbSw2A0/bg/halls/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `HallName`,
                `Visible`
            FROM
                `halls`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC
# [18-Apr-2026 10:49:23] /aria/www/aD4rbSw2A0/bg/ajax/halls/form.html?_=1776498563197 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [18-Apr-2026 10:49:27] /aria/www/aD4rbSw2A0/bg/ajax/halls/form/1.html?_=1776498567468 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `halls`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [18-Apr-2026 10:49:33] /aria/www/aD4rbSw2A0/bg/tables/list.html 108.61.209.243

set names utf8

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

SELECT
                `halls`.`HallName`,
                `tables`.`ID`,
                `tables`.`PostDate`,
                `tables`.`LastUpdate`,
                `tables`.`Number`,
                `tables`.`Seats`,
                `tables`.`AdSeats`,
                `tables`.`Visible`
            FROM
                `tables`
                INNER JOIN `halls` ON `tables`.`HallID` = `halls`.`ID` AND `halls`.`Language` = 'bg'
            GROUP BY `tables`.`ID`
         ORDER BY `PostDate` DESC
# [18-Apr-2026 10:49:38] /aria/www/aD4rbSw2A0/bg/ajax/tables/form/127.html?_=1776498578404 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `tables`
            WHERE
                `ID` = 127
            LIMIT 1

SELECT
                `ID`,
                `HallName`
            FROM
                `halls`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` ASC
# [18-Apr-2026 10:51:15] /aria/www/aD4rbSw2A0/bg/calendar/list.html 108.61.209.243

set names utf8

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

SELECT
                `calendar`.`ID`,
                `calendar`.`Date`,
                `calendar`.`StartFrom`,
                `calendar`.`EndTo`,
                `halls`.`HallName`
            FROM
                `calendar`
                LEFT JOIN `halls` ON `calendar`.`HallID` = `halls`.`ID` AND `halls`.`Language` = 'bg'
         ORDER BY `Date` DESC
# [18-Apr-2026 10:51:17] /aria/www/aD4rbSw2A0/bg/ajax/calendar/form.html?_=1776498677020 108.61.209.243

set names utf8

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

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