# [08-Aug-2024 12:02:00] /aria/www/aD4rbSw2A0/bg/ajax/users/login.html?_=1723107725469 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'N2EzMzMyZTM2NTFkMWQ1YzU1ZTM1NTBiYTNkMjVlMTUMDRlMDNlZGJlODkyODMwYTBjNzc0YTlkOTYxNjIzMWU%'
            LIMIT 1
# [08-Aug-2024 12:02:00] /aria/www/aD4rbSw2A0/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 3 AND
                                CRC32(`UserKey`) = 1185355588 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
# [08-Aug-2024 12:02:18] /aria/www/aD4rbSw2A0/bg/reviews/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [08-Aug-2024 12:02:23] /aria/www/aD4rbSw2A0/bg/ajax/reviews/form/5.html?_=1723107748391 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 5 AND
                `Language` = 'bg'
            LIMIT 1
# [08-Aug-2024 12:02:26] /aria/www/aD4rbSw2A0/en/ajax/reviews/form/5.html?_=1723107751359 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 5 AND
                `Language` = 'en'
            LIMIT 1

SELECT * FROM `reviews` WHERE `ID` = 5 LIMIT 1
# [08-Aug-2024 12:02:29] /aria/www/aD4rbSw2A0/en/ajax/reviews/insert/5.html?_=1723107754504 108.61.209.243

set names utf8

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

SELECT * FROM `reviews` LIMIT 1

SHOW COLUMNS FROM `reviews`

INSERT INTO `reviews` SET `ID` = '5', `Language` = 'en', `PostDate` = '2024-08-05 12:02:29', `LastUpdate` = '2024-08-08 12:02:29', `UploadID` = '2847834028', `Image` = 'default-avatar-2020-16.jpg', `FullName` = 'Lia T', `Rate` = '5', `Review` = 'Everything was AMAZING! The food was delicious, the service was excellent and the staff were polite and respectful! We had an awesome meal. It’s a great place to gather with friends!', `Media` = 'Tripadvisor', `MediaURL` = 'https://www.tripadvisor.com/ShowUserReviews-g294452-d27886811-r956727694-Aria_Restaurant_Sofia-Sofia_Sofia_Region.html', `HomePage` = 1, `Visible` = 1
# [08-Aug-2024 12:02:30] /aria/www/aD4rbSw2A0/bg/reviews/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [08-Aug-2024 12:02:32] /aria/www/aD4rbSw2A0/bg/ajax/reviews/form/8.html?_=1723107757263 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 8 AND
                `Language` = 'bg'
            LIMIT 1
# [08-Aug-2024 12:02:36] /aria/www/aD4rbSw2A0/en/ajax/reviews/form/8.html?_=1723107760951 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 8 AND
                `Language` = 'en'
            LIMIT 1

SELECT * FROM `reviews` WHERE `ID` = 8 LIMIT 1
# [08-Aug-2024 12:02:38] /aria/www/aD4rbSw2A0/en/ajax/reviews/insert/8.html?_=1723107763480 108.61.209.243

set names utf8

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

SELECT * FROM `reviews` LIMIT 1

SHOW COLUMNS FROM `reviews`

INSERT INTO `reviews` SET `ID` = '8', `Language` = 'en', `PostDate` = '2024-08-05 12:02:38', `LastUpdate` = '2024-08-08 12:02:38', `UploadID` = '2853422207', `Image` = '1712836271997.jpg', `FullName` = 'Peter Lozanov', `Rate` = '5', `Review` = 'One of the best places to be when looking for an exquisite quisine and amazing atmosphere right in the city center.
Will get back soon!', `Media` = 'Google', `MediaURL` = 'https://g.co/kgs/BDn6nZG', `HomePage` = 1, `Visible` = 1
# [08-Aug-2024 12:02:38] /aria/www/aD4rbSw2A0/bg/reviews/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [08-Aug-2024 12:02:42] /aria/www/aD4rbSw2A0/bg/ajax/reviews/form/7.html?_=1723107766991 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 7 AND
                `Language` = 'bg'
            LIMIT 1
# [08-Aug-2024 12:02:47] /aria/www/aD4rbSw2A0/bg/ajax/reviews/form/6.html?_=1723107771629 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 6 AND
                `Language` = 'bg'
            LIMIT 1
# [08-Aug-2024 12:02:50] /aria/www/aD4rbSw2A0/bg/ajax/reviews/form/7.html?_=1723107774974 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 7 AND
                `Language` = 'bg'
            LIMIT 1
# [08-Aug-2024 12:02:53] /aria/www/aD4rbSw2A0/en/ajax/reviews/form/7.html?_=1723107778015 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 7 AND
                `Language` = 'en'
            LIMIT 1

SELECT * FROM `reviews` WHERE `ID` = 7 LIMIT 1
# [08-Aug-2024 12:02:55] /aria/www/aD4rbSw2A0/en/ajax/reviews/insert/7.html?_=1723107780184 108.61.209.243

set names utf8

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

SELECT * FROM `reviews` LIMIT 1

SHOW COLUMNS FROM `reviews`

INSERT INTO `reviews` SET `ID` = '7', `Language` = 'en', `PostDate` = '2024-08-05 12:02:55', `LastUpdate` = '2024-08-08 12:02:55', `UploadID` = '2852940697', `Image` = 'depositphotos-51584483-xl1.jpg', `FullName` = 'Nina Stoycheva', `Rate` = '5', `Review` = 'The food was delicious, the staff were very friendly and we were extremely satisfied with our experience! They have a great selection of wines as well!
I highly recommend and will definitely visit again!', `Media` = 'Google', `MediaURL` = 'https://g.co/kgs/JruFsXJ', `HomePage` = 0, `Visible` = 1
# [08-Aug-2024 12:02:55] /aria/www/aD4rbSw2A0/bg/reviews/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [08-Aug-2024 12:02:58] /aria/www/aD4rbSw2A0/bg/ajax/reviews/form/1.html?_=1723107782687 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [08-Aug-2024 12:03:01] /aria/www/aD4rbSw2A0/bg/ajax/reviews/form/4.html?_=1723107786326 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 4 AND
                `Language` = 'bg'
            LIMIT 1
# [08-Aug-2024 12:03:04] /aria/www/aD4rbSw2A0/en/ajax/reviews/form/4.html?_=1723107789279 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 4 AND
                `Language` = 'en'
            LIMIT 1

SELECT * FROM `reviews` WHERE `ID` = 4 LIMIT 1
# [08-Aug-2024 12:03:05] /aria/www/aD4rbSw2A0/en/ajax/reviews/insert/4.html?_=1723107790448 108.61.209.243

set names utf8

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

SELECT * FROM `reviews` LIMIT 1

SHOW COLUMNS FROM `reviews`

INSERT INTO `reviews` SET `ID` = '4', `Language` = 'en', `PostDate` = '2024-08-04 12:03:05', `LastUpdate` = '2024-08-08 12:03:05', `UploadID` = '2764020679', `Image` = 'default-avatar-2020-56.jpg', `FullName` = 'Gabriela K', `Rate` = '5', `Review` = 'Very interesting interpretation of traditional Bulgarian salad. Definitely recommend for a classy dinner. The atmosphere is nice and the staff is very polite.', `Media` = 'Tripadvisor', `MediaURL` = 'https://www.tripadvisor.com/ShowUserReviews-g294452-d27886811-r960179896-Aria_Restaurant_Sofia-Sofia_Sofia_Region.html', `HomePage` = 0, `Visible` = 1
# [08-Aug-2024 12:03:05] /aria/www/aD4rbSw2A0/bg/reviews/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [08-Aug-2024 12:03:07] /aria/www/aD4rbSw2A0/bg/ajax/reviews/form/3.html?_=1723107792447 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 3 AND
                `Language` = 'bg'
            LIMIT 1
# [08-Aug-2024 12:03:10] /aria/www/aD4rbSw2A0/bg/ajax/reviews/form/2.html?_=1723107794702 108.61.209.243

set names utf8

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

SELECT
                *
            FROM
                `reviews`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [08-Aug-2024 12:03:18] /aria/www/aD4rbSw2A0/en/reviews/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'en'
         ORDER BY `PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'en'
         ORDER BY `PostDate` DESC) AS CountTable
# [08-Aug-2024 12:03:20] /aria/www/aD4rbSw2A0/bg/reviews/list.html 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `Rate`,
                `FullName`,
                `Media`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg'
         ORDER BY `PostDate` DESC) AS CountTable
# [08-Aug-2024 12:03:34] /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` = 'reservations' 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
# [08-Aug-2024 12:03:35] /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` = 'reservations' 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
# [08-Aug-2024 12:03:36] /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` = 'reviews' 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 `MenuLabel`, `URLLabel`, `Annotation` FROM `pages` WHERE`Language` = 'bg' AND
	`Module` = 'reservations' 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
                `UploadID`,
                `Rate`,
                `Image`,
                `FullName`,
                `Review`,
                `Media`,
                `MediaURL`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg' AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

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
# [08-Aug-2024 12:03:38] /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` = 'reviews' 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 `MenuLabel`, `URLLabel`, `Annotation` FROM `pages` WHERE`Language` = 'bg' AND
	`Module` = 'reservations' 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
                `UploadID`,
                `Rate`,
                `Image`,
                `FullName`,
                `Review`,
                `Media`,
                `MediaURL`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg' AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

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
# [08-Aug-2024 12:03:41] /aria/www/en/ 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' 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` != 'en' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'en' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

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

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

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

SELECT `Annotation` FROM `pages` WHERE`Module` = 'reviews' AND
	`URLLabel` = 'reviews' AND
	`Language` = 'en' AND
	`Visible` = 1 LIMIT 1

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

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

SELECT `MenuLabel`, `URLLabel`, `Annotation` FROM `pages` WHERE`Language` = 'en' AND
	`Module` = 'reservations' AND
	`Action` = 'index' AND
	`Visible` = 1 AND
	`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('AltLogo') AND
                `Language` = 'en'
             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` = 'en'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [08-Aug-2024 12:03:42] /aria/www/en/reviews.html 108.61.209.243

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'en' AND
                `Module` = 'reviews' AND
	    		`URLLabel` = 'reviews'
         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` != 'en' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'en' AND
                P1.`URLLabel` = 'reviews' AND
                P1.`Visible` = 1

SELECT `MenuLabel`, `URLLabel`, `Annotation` FROM `pages` WHERE`Language` = 'en' AND
	`Module` = 'reservations' AND
	`Action` = 'index' AND
	`Visible` = 1 AND
	`Visible` = 1 LIMIT 1

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

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

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

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'en' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [08-Aug-2024 12:03:46] /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` = 'reservations' 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
# [08-Aug-2024 12:03:48] /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` = 'reviews' 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 `MenuLabel`, `URLLabel`, `Annotation` FROM `pages` WHERE`Language` = 'bg' AND
	`Module` = 'reservations' 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
                `UploadID`,
                `Rate`,
                `Image`,
                `FullName`,
                `Review`,
                `Media`,
                `MediaURL`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg' AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

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
