# [30-Oct-2024 11:09:12] /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
# [30-Oct-2024 11:17:36] /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
# [30-Oct-2024 11:17:40] /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
# [30-Oct-2024 11:17:40] /aria/www/bg/ajax/requests/form.html?_=1730279860433 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
# [30-Oct-2024 11:17:40] /aria/www/bg/ajax/calendar.json?_=1730279860536 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);
# [30-Oct-2024 11:18:50] /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
# [30-Oct-2024 11:18:51] /aria/www/bg/ajax/requests/form.html?_=1730279931439 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
# [30-Oct-2024 11:18:51] /aria/www/bg/ajax/calendar.json?_=1730279931605 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);
# [30-Oct-2024 11:18:53] /aria/www/bg/cookies-policy.html 108.61.209.243

set names utf8

SELECT
                `Module`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'cookies-policy'
         AND `Visible` = 1 LIMIT 1

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'terms' AND
                `FooterLabel` <> '' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'terms' AND
	    		`URLLabel` = 'cookies-policy'
         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` = 'cookies-policy' 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
# [30-Oct-2024 11:18:57] /aria/www/bg/card-policy.html 108.61.209.243

set names utf8

SELECT
                `Module`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'card-policy'
         AND `Visible` = 1 LIMIT 1

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'terms' AND
                `FooterLabel` <> '' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'terms' AND
	    		`URLLabel` = 'card-policy'
         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` = 'card-policy' 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
# [30-Oct-2024 11:19:03] /aria/www/bg/cookies-policy.html 108.61.209.243

set names utf8

SELECT
                `Module`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `URLLabel` = 'cookies-policy'
         AND `Visible` = 1 LIMIT 1

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'terms' AND
                `FooterLabel` <> '' AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'terms' AND
	    		`URLLabel` = 'cookies-policy'
         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` = 'cookies-policy' 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
