# [15-Nov-2022 15:44:17] /photonics/www/ 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `URLLabel`,
                `MenuLabel`,
                `Title`,
                `Annotation`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FirstPage` = 1
          AND `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `URLLabel` = 'services'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `URLLabel`,
                `MenuLabel`,
                `Title`,
                `Annotation`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FirstPage` = 1
          AND `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
	        	*
	        FROM
	        	`partners`
	    	WHERE 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`MenuLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`FooterLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`FooterLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [15-Nov-2022 15:44:18] /photonics/www/bg/ajax/contacts/form.html?_=1668519863231 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'form'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'terms'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'rules'
         AND `Visible` = 1 LIMIT 1
# [15-Nov-2022 20:38:17] /photonics/www/ 167.99.142.201

set names utf8

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

SELECT
                `ID`,
                `URLLabel`,
                `MenuLabel`,
                `Title`,
                `Annotation`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FirstPage` = 1
          AND `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `Title`,
                `Content`
            FROM
                `pages`
            WHERE
                `URLLabel` = 'services'
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `URLLabel`,
                `MenuLabel`,
                `Title`,
                `Annotation`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FirstPage` = 1
          AND `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
	        	*
	        FROM
	        	`partners`
	    	WHERE 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`MenuLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`FooterLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`FooterLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [15-Nov-2022 20:38:17] /photonics/www/bg/ajax/contacts/form.html?_=1668537497789 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'form'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'terms'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'rules'
         AND `Visible` = 1 LIMIT 1
# [15-Nov-2022 20:38:17] /photonics/www/bg/ajax/cookies/popup.html?_=1668537497797 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'cookies'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'rules'
         AND `Visible` = 1 LIMIT 1
# [15-Nov-2022 20:38:24] /photonics/www/bg/купи-билет.html 167.99.142.201

set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
	    		`URLLabel` = 'купи-билет' AND
                (`ExternalURL` IS NULL OR `ExternalURL` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                MAX(`Monday`) AS `1`,
                MAX(`Tuesday`) AS `2`,
                MAX(`Wednesday`) AS `3`,
                MAX(`Thursday`) AS `4`,
                MAX(`Friday`) AS `5`,
                MAX(`Saturday`) AS `6`,
                MAX(`Sunday`) AS `7`
            FROM
                `projections`
         WHERE `Visible` = 1

SELECT
                *
            FROM
                `projections`
            WHERE
                `Tuesday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`MenuLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`FooterLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`FooterLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [15-Nov-2022 20:38:24] /photonics/www/bg/ajax/cookies/popup.html?_=1668537504366 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'cookies'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'rules'
         AND `Visible` = 1 LIMIT 1
# [15-Nov-2022 20:38:26] /photonics/www/bg/orders/1.html?dt=202211151030 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
	        FROM
	        	`projections`
	    	WHERE
	    		`ID` = 1
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'orders'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Price`,
                `Price2`,
                `Price3`,
                `Price4`
	        FROM
	        	`projections`
	    	WHERE
	    		`ID` = 1
         AND `Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = '28cd1b8405bc5c803833816a4571189ec29b03bfdffe32c027be2425db761661' AND
                `Status` <= 1
            LIMIT 1

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'rules'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'terms'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`MenuLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`FooterLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`FooterLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [15-Nov-2022 20:38:26] /photonics/www/bg/ajax/cookies/popup.html?_=1668537506431 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'cookies'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'rules'
         AND `Visible` = 1 LIMIT 1
# [15-Nov-2022 20:38:56] /photonics/www/bg/ajax/orders/submit.html?_=1668537536607 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = '28cd1b8405bc5c803833816a4571189ec29b03bfdffe32c027be2425db761661' AND
                `Status` <= 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'error'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                    `Sale` + `Reserve` AS `All`
    	        FROM
    	        	`projections`
    	    	WHERE
    	    		`ID` = 1 AND
                    `Visible` = 1
                 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211151030 AND
                `OrderType` & 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2022-11-15 20:38:56', `ClientID` = '28cd1b8405bc5c803833816a4571189ec29b03bfdffe32c027be2425db761661', `ProjectionID` = '1', `Data` = 'QT7uiZUTkkJPzlyXZ0gfrCHcYgCi1ISEeMcr86Hmi9Vw2uAHWFSeMQ7UjkeLoftUVJSgoVV8npT0VtuZK2GDKBGgu-PTYyBhZ0fki_tpR1QZPuSkNdVYfVqvI848GcDWV0OhR0L8QDodQakdrkaeNrFwRzY9aNZZxkyaLeb25QPkMfZUfM9YTbAMt6OxO4_Cx7n9PcRdalnvxm55fHjXeOLJtdFYOhZFXLrh9_eEAC45zqescUi8vft7UPA6vWjDytlLx4iCJIgKuTvClYcICSx-xe6LckD4u8Qj-JYVephuJSb1IT46bhFcaRP5Ud0b', `SearchKey` = 'wrDDhMKmw4jDiMKJwr7DqsK5wwrDDhMKmw4jDiMKJwr7DqsK5wrXDhsOHwqvCn8OCw5HCtn3CwrrCs8OMw4jDicKdwqXDqcK4w4TDhswqTCsMOLwofCs8Kaw4DrcKmwrHCvcOIwpC', `SortName` = '970112', `PostDate` = '2022-11-15 20:38:56'
# [15-Nov-2022 20:38:56] /photonics/www/bg/orders/preview.html 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = '28cd1b8405bc5c803833816a4571189ec29b03bfdffe32c027be2425db761661' AND
                `Status` <= 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
	        FROM
	        	`projections`
	    	WHERE
	    		`ID` = 1
         AND `Visible` = 1 LIMIT 1

SELECT
                `Price`,
                `Price2`,
                `Price3`,
                `Price4`
	        FROM
	        	`projections`
	    	WHERE
	    		`ID` = 1
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'orders'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`MenuLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`FooterLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`FooterLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [15-Nov-2022 20:38:57] /photonics/www/bg/ajax/cookies/popup.html?_=1668537537094 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'cookies'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'rules'
         AND `Visible` = 1 LIMIT 1
# [15-Nov-2022 20:39:00] /photonics/www/bg/ajax/orders/confirm.html?_=1668537540394 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = '28cd1b8405bc5c803833816a4571189ec29b03bfdffe32c027be2425db761661' AND
                `Status` <= 1
            LIMIT 1

SELECT
                `Price`,
                `Price2`,
                `Price3`,
                `Price4`
	        FROM
	        	`projections`
	    	WHERE
	    		`ID` = 1
         AND `Visible` = 1 LIMIT 1

INSERT INTO `tickets`
            (`ID`, `PostDate`, `LastUpdate`, `OrderID`, `DateTime`, `OrderType`, `TicketType`, `Price`, `Status`) VALUES
            (NULL, NOW(), NOW(), 131, 202211151030, 1, 1, 10.00, 0)

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 131
                LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = '28cd1b8405bc5c803833816a4571189ec29b03bfdffe32c027be2425db761661' AND
                `Status` <= 1
            LIMIT 1

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = '28cd1b8405bc5c803833816a4571189ec29b03bfdffe32c027be2425db761661' AND
                `Status` <= 1
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'months'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                *
	        FROM
	        	`projections`
	    	WHERE
	    		`ID` = 1
         AND `Visible` = 1 LIMIT 1

SELECT
                `Title`
	        FROM
	        	`projections`
	    	WHERE
	    		`ID` = 1 AND
                `Visible` = 1
             LIMIT 1

SELECT
                `Price`,
                `Price2`,
                `Price3`,
                `Price4`
	        FROM
	        	`projections`
	    	WHERE
	    		`ID` = 1
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'orders'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `tickets`.*
            FROM
                `tickets`
                INNER JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
            WHERE
                `orders`.`ID` = 131 AND
                `orders`.`Status` = 1
            ORDER BY
                `tickets`.`ID` ASC

SELECT
                `Title`
	        FROM
	        	`projections`
	    	WHERE
	    		`ID` = 1 AND
                `Visible` = 1
             LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 2
                WHERE
                    `ID` = 131
                LIMIT 1

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 4
                WHERE
                    `ID` = 131
                LIMIT 1
# [15-Nov-2022 20:39:09] /photonics/www/bg/orders/success-sale.html 167.99.142.201

set names utf8

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`MenuLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`ParentID`,
                `pages`.`FooterLabel`,
                `pages`.`URLLabel`,
                `pages`.`ExternalURL`,
                `SubPages`.`ID` AS `SubPageID`
            FROM
                `pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID` AND `SubPages`.`Visible` = 1 WHERE `pages`.`FooterLabel` <> ''  AND `pages`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `pages`.`ParentID` ASC,
                `pages`.`PostDate` ASC
# [15-Nov-2022 20:39:10] /photonics/www/bg/ajax/cookies/popup.html?_=1668537550249 167.99.142.201

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'cookies'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'rules'
         AND `Visible` = 1 LIMIT 1
