# [03-Apr-2025 11:43:17] /constantinoff/root/ 167.99.142.201

set names utf8

SELECT
                    *
    	        FROM
    	        	`pages`
    	    	WHERE
                    (`ExternalURL` IS NULL OR `ExternalURL` = '') AND
                    `Language` = 'bg'
             AND `Visible` = 1 AND `URLLabel` = 'index' LIMIT 1

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

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Image` != ''
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

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

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

SELECT
                COUNT(`ID`)
            FROM
                `events`
            WHERE
                `Language` = 'bg' AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Image` != ''
         AND `Visible` = 1

SELECT
                `ID`,
                `Language`,
                `Gold`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`Module` = 'events'
         AND `Visible` = 1 LIMIT 1

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

SELECT
	        	*
	        FROM
	        	`reviews`
	    	WHERE
                `Language` = 'bg'
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 2

SELECT
                `ID`,
                `Language`,
                `Gold`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`Module` = 'reviews'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

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

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

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1
# [03-Apr-2025 11:43:18] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743669798412 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 11:43:18] /constantinoff/root/bg/ajax/cookies.html?_=1743669798413 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'cookies' 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
# [03-Apr-2025 11:43:18] /constantinoff/root/bg/ajax/reservations/form.html?_=1743669798413 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMakeReservation','LName','LPhone','LEMail','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
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'terms' AND (`Action` = '' OR `Action` IS NULL) AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('IAgreeGeneral') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 11:43:20] /constantinoff/root/cSN3dAd9/bg/ajax/users/form/login.html?_=1743669800462 167.99.142.201

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 11:43:23] /constantinoff/root/cSN3dAd9/bg/ajax/users/login.html?_=1743669803861 167.99.142.201

set names utf8

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = 'dG8RZsnFAKWc328Fus24XTQwxJM8rRQfZ90KxWprEJY8PxhW3srk4PpSCsgUE3Mk'
            WHERE
                `UserKey` LIKE 'w4vCvcOjw6LCjcOZw43DrMK6w4rDjcOKw43DlMK9wp3CtsK8%' AND
                RIGHT(`UserKey`, 1) > 0
            LIMIT 1

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 11:43:26] /constantinoff/root/cSN3dAd9/bg/ajax/users/login.html?_=1743669806750 167.99.142.201

set names utf8

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

UPDATE
                `users`
            SET
                `LastUpdate` = NOW(),
                `AccessKey` = ''
            WHERE
                `ID` = 1462881452
            LIMIT 1
# [03-Apr-2025 11:43:26] /constantinoff/root/cSN3dAd9/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 11:43:26] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743669807093 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 11:43:31] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 11:43:32] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743669812659 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 11:59:55] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 11:59:55] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743670796094 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:00:19] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 12:00:19] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743670819817 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:00:50] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 12:00:51] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743670851638 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:00:52] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form.html?_=1743670852440 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:01:40] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 12:01:41] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743670901657 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:01:42] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form.html?_=1743670902686 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:01:49] /constantinoff/root/cSN3dAd9/bg/ajax/menu/upload/3670902339.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:02:18] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 12:02:19] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743670939475 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:02:20] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form.html?_=1743670940374 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:02:23] /constantinoff/root/cSN3dAd9/bg/ajax/menu/upload/3670940028.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:08:11] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 12:08:11] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671292324 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:08:13] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form.html?_=1743671293625 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:08:16] /constantinoff/root/cSN3dAd9/bg/ajax/menu/upload/3671293284.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:09:10] /constantinoff/root/cSN3dAd9/bg/ajax/menu/upload/3671293284.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:09:18] /constantinoff/root/cSN3dAd9/bg/ajax/menu/upload/3671293284.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:09:37] /constantinoff/root/cSN3dAd9/bg/ajax/menu/insert.html?_=1743671378069 167.99.142.201

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `menu`

SELECT * FROM `menu` LIMIT 1

SHOW COLUMNS FROM `menu`

INSERT INTO `menu` SET `ID` = 1, `Language` = 'bg', `PostDate` = '2025-04-03', `LastUpdate` = '2025-04-03 12:09:37', `Title` = 'test BG', `Image` = '1000000017_2502182.pdf', `Visible` = 1
# [03-Apr-2025 12:10:10] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 12:10:10] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671410769 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:10:11] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form.html?_=1743671411431 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:10:21] /constantinoff/root/cSN3dAd9/bg/pages/list.html 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `Language`,
                `PostDate`,
                `LastUpdate`,
                `ExternalURL`,
                `MenuLabel`,
                `Title`,
                `URLLabel`,
                `Visible`
            FROM
                `pages`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:10:21] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671421799 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:10:22] /constantinoff/root/cSN3dAd9/bg/ajax/pages/form/1.html?_=1743671422861 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [03-Apr-2025 12:10:27] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 12:10:27] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671428329 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:10:28] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form.html?_=1743671428926 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:10:34] /constantinoff/root/cSN3dAd9/bg/ajax/menu/upload/3671428586.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:10:35] /constantinoff/root/cSN3dAd9/bg/ajax/menu/insert.html?_=1743671436261 167.99.142.201

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `menu`

SELECT * FROM `menu` LIMIT 1

SHOW COLUMNS FROM `menu`

INSERT INTO `menu` SET `ID` = 1, `Language` = 'bg', `PostDate` = '2025-04-03', `LastUpdate` = '2025-04-03 12:10:35', `Title` = 'tesagfdgsdfg sdfg', `FileName` = '1000000017_250218.pdf', `Visible` = 1
# [03-Apr-2025 12:10:36] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:10:36] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671436797 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:10:37] /constantinoff/root/uf/menu/0/1000000017_250218.pdf 167.99.142.201

set names utf8

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

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

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

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1
# [03-Apr-2025 12:10:38] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671438348 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:10:38] /constantinoff/root/bg/ajax/cookies.html?_=1743671438360 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'cookies' 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
# [03-Apr-2025 12:11:18] /constantinoff/root/cSN3dAd9/bg/ajax/menu/delete/1.html?_=1743671479220 167.99.142.201

set names utf8

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

DELETE FROM `menu` WHERE `ID` = '1'
# [03-Apr-2025 12:11:18] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 12:11:19] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671479751 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:11:20] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form.html?_=1743671481221 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:11:26] /constantinoff/root/cSN3dAd9/bg/ajax/menu/upload/3671480883.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:11:27] /constantinoff/root/cSN3dAd9/bg/ajax/menu/insert.html?_=1743671487797 167.99.142.201

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `menu`

SELECT * FROM `menu` LIMIT 1

SHOW COLUMNS FROM `menu`

INSERT INTO `menu` SET `ID` = 1, `Language` = 'bg', `PostDate` = '2025-04-03', `LastUpdate` = '2025-04-03 12:11:27', `UploadID` = NULL, `Title` = 'теазстдфг', `FileName` = '1000000017_250218.pdf', `Visible` = 1
# [03-Apr-2025 12:11:56] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LNoResults') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 12:11:56] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671517290 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:11:57] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form.html?_=1743671518085 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:12:03] /constantinoff/root/cSN3dAd9/bg/ajax/menu/upload/3671517744.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:12:04] /constantinoff/root/cSN3dAd9/bg/ajax/menu/insert.html?_=1743671524511 167.99.142.201

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `menu`

SELECT * FROM `menu` LIMIT 1

SHOW COLUMNS FROM `menu`

INSERT INTO `menu` SET `ID` = 1, `Language` = 'bg', `PostDate` = '2025-04-03', `LastUpdate` = '2025-04-03 12:12:04', `UploadID` = '3671517744', `Title` = 'Избрани продукти', `FileName` = '1000000017_250218.pdf', `Visible` = 1
# [03-Apr-2025 12:12:04] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:12:04] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671525077 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:12:11] /constantinoff/root/cSN3dAd9/bg/ajax/menu/visible/1.html?_=1743671531597 167.99.142.201

set names utf8

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

UPDATE
                    `menu`
                SET
                    `Visible` = IF(`Visible` = 1, 0, 1)
                WHERE
                    `ID` = '1'
                LIMIT 1

SELECT
                    `Visible`
                FROM
                    `menu`
                WHERE
                    `ID` = '1'
                LIMIT 1
# [03-Apr-2025 12:12:12] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:12:12] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671533196 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:12:13] /constantinoff/root/cSN3dAd9/bg/ajax/menu/visible/1.html?_=1743671534005 167.99.142.201

set names utf8

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

UPDATE
                    `menu`
                SET
                    `Visible` = IF(`Visible` = 1, 0, 1)
                WHERE
                    `ID` = '1'
                LIMIT 1

SELECT
                    `Visible`
                FROM
                    `menu`
                WHERE
                    `ID` = '1'
                LIMIT 1
# [03-Apr-2025 12:12:15] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form/1.html?_=1743671535603 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [03-Apr-2025 12:17:37] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:17:38] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671858439 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:17:38] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form/1.html?_=1743671859155 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [03-Apr-2025 12:18:00] /constantinoff/root/cSN3dAd9/bg/ajax/menu/update/1.html?_=1743671880350 167.99.142.201

set names utf8

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

SELECT * FROM `menu` LIMIT 1

SHOW COLUMNS FROM `menu`

UPDATE `menu` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2025-04-03', `LastUpdate` = '2025-04-03 12:18:00', `UploadID` = '3671517744', `MenuType` = 'Live & Special', `Title` = 'Избрани продукти', `FileName` = '1000000017_250218.pdf', `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [03-Apr-2025 12:18:35] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:18:36] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671916454 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:18:36] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form/1.html?_=1743671916877 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [03-Apr-2025 12:18:45] /constantinoff/root/cSN3dAd9/bg/ajax/menu/update/1.html?_=1743671926123 167.99.142.201

set names utf8

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

SELECT * FROM `menu` LIMIT 1

SHOW COLUMNS FROM `menu`

UPDATE `menu` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2025-04-03', `LastUpdate` = '2025-04-03 12:18:45', `UploadID` = '3671517744', `MenuType` = '1', `Title` = 'Избрани продукти', `FileName` = '1000000017_250218.pdf', `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [03-Apr-2025 12:18:46] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:18:46] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671926858 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:18:48] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form/1.html?_=1743671929117 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [03-Apr-2025 12:19:08] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:19:08] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743671948776 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:20:53] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:20:54] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743672054373 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:21:25] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:21:26] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743672086500 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:22:03] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:22:03] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743672124179 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:34:11] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:34:20] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:34:20] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743672860774 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:34:24] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form/1.html?_=1743672864944 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [03-Apr-2025 12:34:27] /constantinoff/root/cSN3dAd9/bg/ajax/menu/update/1.html?_=1743672867358 167.99.142.201

set names utf8

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

SELECT * FROM `menu` LIMIT 1

SHOW COLUMNS FROM `menu`

UPDATE `menu` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2025-04-03', `LastUpdate` = '2025-04-03 12:34:27', `UploadID` = '3671517744', `MenuType` = '0', `Title` = 'Избрани продукти', `FileName` = '1000000017_250218.pdf', `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [03-Apr-2025 12:34:27] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:34:27] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743672867946 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:35:55] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:35:55] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743672956044 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:35:59] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form/1.html?_=1743672959969 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [03-Apr-2025 12:36:13] /constantinoff/root/cSN3dAd9/bg/ajax/menu/update/1.html?_=1743672974007 167.99.142.201

set names utf8

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

SELECT * FROM `menu` LIMIT 1

SHOW COLUMNS FROM `menu`

UPDATE `menu` SET `ID` = '1', `Language` = 'bg', `PostDate` = '2025-04-03', `LastUpdate` = '2025-04-03 12:36:13', `UploadID` = '3671517744', `Title` = 'Нашето меню', `FileName` = '1000000017_250218.pdf', `Visible` = 1 WHERE `ID` = '1' AND `Language` = 'bg'
# [03-Apr-2025 12:36:13] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:36:14] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743672974661 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:36:17] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form.html?_=1743672978022 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:36:21] /constantinoff/root/cSN3dAd9/bg/ajax/menu/upload/3672977705.html 167.99.142.201

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1462881452 AND
                                CRC32(`UserKey`) = 2779422748 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [03-Apr-2025 12:36:33] /constantinoff/root/cSN3dAd9/bg/ajax/menu/insert.html?_=1743672994247 167.99.142.201

set names utf8

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

SELECT MAX(`ID`) + 1 FROM `menu`

SELECT * FROM `menu` LIMIT 1

SHOW COLUMNS FROM `menu`

INSERT INTO `menu` SET `ID` = '2', `Language` = 'bg', `PostDate` = '2025-04-03', `LastUpdate` = '2025-04-03 12:36:33', `UploadID` = '3672977705', `Title` = 'Live & Special', `FileName` = '1000000020-250324-credit.pdf', `Visible` = 1
# [03-Apr-2025 12:36:34] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:36:34] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743672994870 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:37:11] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form/2.html?_=1743673031737 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [03-Apr-2025 12:41:01] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form/2.html?_=1743673261239 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [03-Apr-2025 12:41:03] /constantinoff/root/cSN3dAd9/bg/ajax/menu/update/2.html?_=1743673264191 167.99.142.201

set names utf8

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

SELECT * FROM `menu` LIMIT 1

SHOW COLUMNS FROM `menu`

UPDATE `menu` SET `ID` = '2', `Language` = 'bg', `PostDate` = '2025-04-03', `LastUpdate` = '2025-04-03 12:41:03', `UploadID` = '3672977705', `Title` = 'Live & Special', `FileName` = '1000000020-250324-credit.pdf', `Special` = 1, `Visible` = 1 WHERE `ID` = '2' AND `Language` = 'bg'
# [03-Apr-2025 12:41:04] /constantinoff/root/cSN3dAd9/bg/menu/list.html 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `Language` = 'bg'
                
            ORDER BY  `PostDate` ASC
# [03-Apr-2025 12:41:04] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743673264834 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 12:41:06] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form/2.html?_=1743673266342 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [03-Apr-2025 12:41:09] /constantinoff/root/cSN3dAd9/bg/ajax/menu/form/1.html?_=1743673269679 167.99.142.201

set names utf8

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

SELECT
                *
            FROM
                `menu`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [03-Apr-2025 13:37:36] /constantinoff/root/ 167.99.142.201

set names utf8

SELECT
                    *
    	        FROM
    	        	`pages`
    	    	WHERE
                    (`ExternalURL` IS NULL OR `ExternalURL` = '') AND
                    `Language` = 'bg'
             AND `Visible` = 1 AND `URLLabel` = 'index' LIMIT 1

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

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Image` != ''
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

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

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

SELECT
                COUNT(`ID`)
            FROM
                `events`
            WHERE
                `Language` = 'bg' AND
                (CURDATE() BETWEEN `StartFrom` AND `EndTo` OR `EndTo` IS NULL) AND
                `Image` != ''
         AND `Visible` = 1

SELECT
                `ID`,
                `Language`,
                `Gold`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`Module` = 'events'
         AND `Visible` = 1 LIMIT 1

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

SELECT
	        	*
	        FROM
	        	`reviews`
	    	WHERE
                `Language` = 'bg'
         AND `FirstPage` = 1 AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 2

SELECT
                `ID`,
                `Language`,
                `Gold`,
                `Annotation`,
                `Visible`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`Module` = 'reviews'
         AND `Visible` = 1 LIMIT 1

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

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

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

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

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1
# [03-Apr-2025 13:37:36] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743676657106 167.99.142.201

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 13:37:36] /constantinoff/root/bg/ajax/reservations/form.html?_=1743676657114 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LMakeReservation','LName','LPhone','LEMail','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
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'terms' AND (`Action` = '' OR `Action` IS NULL) AND `Language` = 'bg' AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('IAgreeGeneral') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 13:37:36] /constantinoff/root/bg/ajax/cookies.html?_=1743676657115 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'cookies' 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
# [03-Apr-2025 13:37:38] /constantinoff/root/bg/меню.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'меню' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
    	        FROM
    	        	`pages`
    	    	WHERE
                    (`ExternalURL` IS NULL OR `ExternalURL` = '') AND
                    `Language` = 'bg'
             AND `Visible` = 1 AND `URLLabel` = 'меню' LIMIT 1

SELECT
	        	*
	        FROM
	        	`menu`
	    	WHERE
                `Language` = 'bg' AND
                `Special` = 0
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 1

SELECT
	        	*
	        FROM
	        	`menu`
	    	WHERE
                `Language` = 'en' AND
                `Special` = 0
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 1

SELECT
	        	*
	        FROM
	        	`menu`
	    	WHERE
                `Language` = 'bg' AND
                `Special` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 1

SELECT
	        	*
	        FROM
	        	`menu`
	    	WHERE
                `Language` = 'en' AND
                `Special` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 1

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

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

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

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1
# [03-Apr-2025 13:37:38] /constantinoff/root/bg/uf/menu/3672977705/1000000020-250324-credit.pdfjpg 167.99.142.201

set names utf8

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

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

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

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1
# [03-Apr-2025 13:37:38] /constantinoff/root/bg/uf/menu/3671517744/1000000017_250218.pdfjpg 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LOrderHome') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [03-Apr-2025 13:37:38] /constantinoff/root/bg/ajax/reservations/calendar.html?_=1743676658932 167.99.142.201

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

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

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

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

set names utf8

SELECT
                 DATE_FORMAT(`Date`, '%Y%m%d') AS `Date`
            FROM
                `calendar`
            WHERE
                `Date` BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 91 DAY)
# [03-Apr-2025 13:37:38] /constantinoff/root/bg/ajax/cookies.html?_=1743676658933 167.99.142.201

set names utf8

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'cookies' 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
# [03-Apr-2025 13:38:28] /constantinoff/root/bg/меню.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'меню' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                    *
    	        FROM
    	        	`pages`
    	    	WHERE
                    (`ExternalURL` IS NULL OR `ExternalURL` = '') AND
                    `Language` = 'bg'
             AND `Visible` = 1 AND `URLLabel` = 'меню' LIMIT 1

SELECT
	        	*
	        FROM
	        	`menu`
	    	WHERE
                `Language` = 'bg' AND
                `Special` = 0
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 1

SELECT
	        	*
	        FROM
	        	`menu`
	    	WHERE
                `Language` = 'en' AND
                `Special` = 0
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 1

SELECT
	        	*
	        FROM
	        	`menu`
	    	WHERE
                `Language` = 'bg' AND
                `Special` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 1

SELECT
	        	*
	        FROM
	        	`menu`
	    	WHERE
                `Language` = 'en' AND
                `Special` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 1

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

SELECT
                `Module`,
                `ExternalURL`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                (`ExternalURL` <> '' OR `URLLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

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

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

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-contacts' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Title`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1

SELECT
                        `Content`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `Module` = 'footer' AND `Language` = 'bg' AND `URLLabel` = 'footer-business-hours' AND (`Visible` = '' OR `Visible` IS NULL) LIMIT 1
