# [09-Sep-2024 10:28:29] /eventssp8/root/ 108.61.209.243

set names utf8

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

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

SELECT * FROM `lecturers` WHERE `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                *
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

SELECT
                `Videos`
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [09-Sep-2024 10:28:29] /eventssp8/root/bg/ajax/cookies.html?_=1725866909706 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [09-Sep-2024 10:28:54] /eventssp8/root/ 108.61.209.243

set names utf8

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

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

SELECT * FROM `lecturers` WHERE `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                *
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

SELECT
                `Videos`
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [09-Sep-2024 10:28:55] /eventssp8/root/bg/ajax/cookies.html?_=1725866935878 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [09-Sep-2024 10:39:46] /eventssp8/root/ 108.61.209.243

set names utf8

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

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

SELECT * FROM `lecturers` WHERE `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                *
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

SELECT
                `Videos`
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [09-Sep-2024 10:39:47] /eventssp8/root/bg/ajax/cookies.html?_=1725867587082 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('TextCookies','LUnderstood') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [09-Sep-2024 10:40:24] /eventssp8/root/bg/купи-билет.html 108.61.209.243

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'купи-билет' AND
                `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'orders' AND
	    		`URLLabel` = 'купи-билет'
         AND `Visible` = 1 LIMIT 1

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'купи-билет' AND
                P1.`Visible` = 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [09-Sep-2024 10:40:24] /eventssp8/root/bg/ajax/seats.json?_=1725867624562 108.61.209.243

set names utf8

SELECT
                `seats`.`ID`,
                `seats`.`Price`
            FROM
                `seats`
                LEFT JOIN `reserved` ON
                    `reserved`.`SeatID` = `seats`.`ID` AND
                    `reserved`.`ClientID` != '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116' AND
                    `reserved`.`PostDate` >= NOW() - INTERVAL 10 MINUTE
            WHERE
                `seats`.`Status` = 0 AND
                `reserved`.`SeatID` IS NULL
# [09-Sep-2024 10:40:35] /eventssp8/root/bg/ajax/orders/reserve.html?_=1725867635217 108.61.209.243

set names utf8

DELETE FROM `reserved` WHERE `ClientID` = '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116'

INSERT INTO `reserved` (`ClientID`, `PostDate`, `SeatID`) VALUES ('30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116', NOW(), 'p-r2-m28')
# [09-Sep-2024 10:40:35] /eventssp8/root/bg/orders/form.html 108.61.209.243

set names utf8

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

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

SELECT
                `reserved`.`SeatID`,
                `seats`.`Price`
            FROM
                `reserved`
                INNER JOIN `seats` ON `reserved`.`SeatID` = `seats`.`ID`
            WHERE
                `seats`.`Status` = 0 AND
                `reserved`.`ClientID` = '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116' AND
                `reserved`.`PostDate` >= NOW() - INTERVAL 20 MINUTE

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorFullName','ErrorPhone','ErrorEMail','ErrorMessage','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ID`,
                `Data`,
                `PromoCodeID`,
                `TotalPrice`
            FROM
                `orders`
            WHERE
                `ClientID` = '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116' AND
                `Status` < 4
            LIMIT 1

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

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

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [09-Sep-2024 10:41:13] /eventssp8/root/bg/ajax/orders/submit.html?_=1725867673578 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`,
                `PromoCodeID`,
                `TotalPrice`
            FROM
                `orders`
            WHERE
                `ClientID` = '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116' AND
                `Status` < 4
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorFullName','ErrorPhone','ErrorEMail','ErrorMessage','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                SUM(`seats`.`Price`)
            FROM
                `reserved`
                INNER JOIN `seats` ON `reserved`.`SeatID` = `seats`.`ID`
            WHERE
                `seats`.`Status` = 0 AND
                `reserved`.`ClientID` = '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116' AND
                `reserved`.`PostDate` >= NOW() - INTERVAL 20 MINUTE

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2024-09-09 10:41:13', `ClientID` = '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116', `TotalPrice` = '65.00', `Data` = 'tjNW7qXNdymnMwDlnUJqYcIxbHtRggDYwMncXamO-21KnMp1P5BF8h8MlXrreMpRvc-BKPjirg_kivTy6JMY7yK1WBtnD3F_l9REL1iFQ2Q6UMSjxYkJGq-g_OogL0CgGa73-oHrBy7kjPDYTd4jgV9RXvxL_gCjOJC48HXIxeU', `SearchKey` = 'wrvCs8K6w4zDicwrDDg8K2w4bDhsKtwwrnDmcOQw4TDh8KIw6TDnMK8wwrnDg8KqwobCv8KJwrbDnMK6wrTDoMOAwqvCwqXDlsKlw4rCtMKqw4HDrcKkw4HDhcOJwqDC', `PostDate` = '2024-09-09 10:41:13'
# [09-Sep-2024 10:41:13] /eventssp8/root/bg/orders/preview.html 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`,
                `PromoCodeID`,
                `TotalPrice`
            FROM
                `orders`
            WHERE
                `ClientID` = '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116' AND
                `Status` < 4
            LIMIT 1

SELECT
                `reserved`.`SeatID`,
                `seats`.`Price`
            FROM
                `reserved`
                INNER JOIN `seats` ON `reserved`.`SeatID` = `seats`.`ID`
            WHERE
                `seats`.`Status` = 0 AND
                `reserved`.`ClientID` = '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116' AND
                `reserved`.`PostDate` >= NOW() - INTERVAL 20 MINUTE

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

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

SELECT
                `PromoCodeID`,
                `TotalPrice`
            FROM
                `orders`
            WHERE
                `ClientID`= '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116' AND
                `Status` < 4
            LIMIT 1

SELECT
                `PromoCode`,
                `Discount`,
                `DiscountType`
            FROM
                `promocodes`
            WHERE
                `ID` = 0 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Visible` = 1
            LIMIT 1

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

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [09-Sep-2024 10:41:21] /eventssp8/root/bg/ajax/orders/confirm.html?_=1725867681609 108.61.209.243

set names utf8

SELECT
                `ID`,
                `Data`,
                `PromoCodeID`,
                `TotalPrice`
            FROM
                `orders`
            WHERE
                `ClientID` = '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116' AND
                `Status` < 4
            LIMIT 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

UPDATE `orders` SET `LastUpdate` = '2024-09-09 10:41:21', `TotalPrice` = '65.00', `Data` = 'NyOu9Hs17I50mZx3AwIyoT7ZJksHVXj4xs2AGSmGPsFXvDiGRKuqqnb2YIBuKPJbzzWk2j0ZcUj6N9oa3vW4v3QMqgm_lIMiNszpfc9y-SV5_FjmMo_xiz40UG8UN4tfeP-gZZelzG6Yf88aMOoO6MxOXrIyFC3FDP5YwuP2yxo', `SearchKey` = 'wrvCs8K6w4zDicwrDDg8K2w4bDhsKtwwrnDmcOQw4TDh8KIw6TDnMK8wwrnDg8KqwobCv8KJwrbDnMK6wrTDoMOAwqvCwqXDlsKlw4rCtMKqw4HDrcKkw4HDhcOJwqDC', `Status` = 1 WHERE `ID` = '1354'

UPDATE
                `reserved`
                INNER JOIN `seats` ON `reserved`.`SeatID` = `seats`.`ID`
            SET
                `reserved`.`PostDate` = NOW()
            WHERE
                `seats`.`Status` = 0 AND
                `reserved`.`ClientID` = '30b9dc69a6c754fef2dca05ba77cddc9436fda38339833c457d01c7027957116' AND
                `reserved`.`PostDate` >= NOW() - INTERVAL 20 MINUTE
# [09-Sep-2024 10:43:58] /eventssp8/root/ 108.61.209.243

set names utf8

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

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

SELECT * FROM `lecturers` WHERE `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                *
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

SELECT
                `Videos`
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC
# [09-Sep-2024 10:44:10] /eventssp8/root/ 108.61.209.243

set names utf8

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

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

SELECT * FROM `lecturers` WHERE `Language` = 'bg' AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                *
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

SELECT
                `Videos`
            FROM
                `gallery`
            WHERE
                `Language` = 'bg'
            LIMIT 1

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