# [17-Nov-2022 09:37:19] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 09:37:24] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:55:37] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:55:39] /photonics/tickets/bg/projections.html?d=2022-11-18 167.99.142.201

set names utf8

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
                `Friday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:55:40] /photonics/tickets/bg/projections.html?d=2022-11-19 167.99.142.201

set names utf8

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
                `Saturday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:55:41] /photonics/tickets/bg/projections.html?d=2022-11-20 167.99.142.201

set names utf8

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
                `Sunday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:55:41] /photonics/tickets/bg/projections.html?d=2022-11-21 167.99.142.201

set names utf8

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
                `Monday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:55:42] /photonics/tickets/bg/projections.html?d=2022-11-22 167.99.142.201

set names utf8

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
# [17-Nov-2022 10:55:43] /photonics/tickets/bg/projections.html?d=2022-11-23 167.99.142.201

set names utf8

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
                `Wednesday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:55:44] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:55:46] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:56:13] /photonics/tickets/bg/ajax/tickets.html?_=1668675373229 167.99.142.201

set names utf8

SELECT
                `tickets`.`DateTime`,
                `tickets`.`OrderType`,
                `tickets`.`TicketType`,
                `tickets`.`Price`,
                `tickets`.`Status`,
                `projections`.`Title`
            FROM
                `tickets`
                INNER JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
                INNER JOIN `projections` ON `orders`.`ProjectionID` = `projections`.`ID`
            WHERE
                `tickets`.`ID` = 173893607
# [17-Nov-2022 10:56:27] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:56:28] /photonics/tickets/bg/orders/1.html?dt=202211171030 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
         LIMIT 1

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 2

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
# [17-Nov-2022 10:56:35] /photonics/tickets/bg/ajax/orders/submit.html?_=1668675395663 167.99.142.201

set names utf8

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 3

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `PostDate` = '2022-11-17 10:56:35', `LastUpdate` = '2022-11-17 10:56:35', `ProjectionID` = '1', `Data` = 'IJsAYHkICxGOaMU6oan_8vKAyQtUpV5oxwsL0Z02YZRvvhYFWxOcdc9NI399Ya2CR_2mgt7-t4wq9JjPHntTGKTKqmTnPf7G51ag5ng4NQePXTbwgtlKhhSonA3amF3lwJvdxzlBA0N3CmnydOh-Tzb7pjdspBL25R2zooX6ZVP6-Gdi96sfWgJavsDs7bjUa5nAn41DTY65vxXuxrlHbA', `SearchKey` = 'wofCuMOWwqPDmMKkwrPCtsKHwrnC', `SortName` = '10821072', `Status` = 16

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(), 133, 202211171030, 1, 1, 10.00, 0)

INSERT INTO `tickets`
            (`ID`, `PostDate`, `LastUpdate`, `OrderID`, `DateTime`, `OrderType`, `TicketType`, `Price`, `Status`) VALUES
            (NULL, NOW(), NOW(), 133, 202211171030, 1, 1, 10.00, 0)
# [17-Nov-2022 10:56:36] /photonics/tickets/bg/orders/preview/133.html 167.99.142.201

set names utf8

SELECT
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 133
            LIMIT 1

SELECT
                `tickets`.*,
                `projections`.`Title`
            FROM
                `tickets`
                INNER JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
                INNER JOIN `projections` ON `orders`.`ProjectionID` = `projections`.`ID`
            WHERE
                `tickets`.`OrderID` = 133
            ORDER BY
                `tickets`.`ID` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'orders'
             ORDER BY
                `labels`.`Label` ASC
# [17-Nov-2022 10:56:50] /photonics/tickets/bg/orders/resv/1.html?dt=202211171030 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
         LIMIT 1

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 2

SELECT
                `orders`.`ID`,
                `orders`.`PostDate`,
                COUNT(`tickets`.`ID`) AS `All`,
                SUM(`tickets`.`Status`) AS `Used`,
                SUM(`tickets`.`Price`) AS `TotalPrice`
            FROM
                `orders`
                INNER JOIN `tickets` ON `orders`.`ID` = `tickets`.`OrderID`
            WHERE
                `orders`.`ProjectionID` = 1 AND
                `tickets`.`DateTime` = 202211171030 AND
                `tickets`.`OrderType` = 2
            GROUP BY
                `orders`.`ID`
             ORDER BY
                `orders`.`PostDate` ASC
# [17-Nov-2022 10:56:53] /photonics/tickets/bg/orders/sales/1.html?dt=202211171030 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
         LIMIT 1

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 2

SELECT
                `orders`.`ID`,
                `orders`.`PostDate`,
                COUNT(`tickets`.`ID`) AS `All`,
                SUM(`tickets`.`Status`) AS `Used`,
                SUM(`tickets`.`Price`) AS `TotalPrice`
            FROM
                `orders`
                INNER JOIN `tickets` ON `orders`.`ID` = `tickets`.`OrderID`
            WHERE
                `orders`.`ProjectionID` = 1 AND
                `tickets`.`DateTime` = 202211171030 AND
                `tickets`.`OrderType` = 1
            GROUP BY
                `orders`.`ID`
             ORDER BY
                `orders`.`PostDate` ASC
# [17-Nov-2022 10:56:57] /photonics/tickets/bg/orders/preview/133.html 167.99.142.201

set names utf8

SELECT
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 133
            LIMIT 1

SELECT
                `tickets`.*,
                `projections`.`Title`
            FROM
                `tickets`
                INNER JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
                INNER JOIN `projections` ON `orders`.`ProjectionID` = `projections`.`ID`
            WHERE
                `tickets`.`OrderID` = 133
            ORDER BY
                `tickets`.`ID` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'orders'
             ORDER BY
                `labels`.`Label` ASC
# [17-Nov-2022 10:57:07] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:57:10] /photonics/tickets/bg/orders/1.html?dt=202211171030 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
         LIMIT 1

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 2

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
# [17-Nov-2022 10:57:20] /photonics/tickets/bg/ajax/orders/submit.html?_=1668675439834 167.99.142.201

set names utf8

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 3

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `PostDate` = '2022-11-17 10:57:20', `LastUpdate` = '2022-11-17 10:57:20', `ProjectionID` = '1', `Data` = 'iJRPs0YSMwkXgEd2uKT28gZMG7you6O4KpDhzWQMEmcfa2mFztmUsrjpLRFYToqy0ly1MYJBQOQKYo6aYeLmYao38J596po0LutdMbJnBt0dRCqAwTMDUL3RDnwCLTaVpNo_GmLGpupN1eE9vQ9Tl80240y2nYhqLGW00BDTOA-F7J147Qb-b2hGATdR740RKusOQ-lVPaV86kxKkFwHow', `SearchKey` = 'wofCuMOWwqPDmMKkwrPCtsKHwrnC', `SortName` = '10821072', `Status` = 16

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(), 134, 202211171030, 1, 1, 10.00, 0)

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `tickets`
            (`ID`, `PostDate`, `LastUpdate`, `OrderID`, `DateTime`, `OrderType`, `TicketType`, `Price`, `Status`) VALUES
            (NULL, NOW(), NOW(), 134, 202211171030, 1, 1, 10.00, 0)
# [17-Nov-2022 10:57:20] /photonics/tickets/bg/orders/preview/134.html 167.99.142.201

set names utf8

SELECT
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 134
            LIMIT 1

SELECT
                `tickets`.*,
                `projections`.`Title`
            FROM
                `tickets`
                INNER JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
                INNER JOIN `projections` ON `orders`.`ProjectionID` = `projections`.`ID`
            WHERE
                `tickets`.`OrderID` = 134
            ORDER BY
                `tickets`.`ID` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'orders'
             ORDER BY
                `labels`.`Label` ASC
# [17-Nov-2022 10:57:23] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:57:25] /photonics/tickets/bg/orders/1.html?dt=202211171030 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
         LIMIT 1

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 2

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
# [17-Nov-2022 10:57:30] /photonics/tickets/bg/ajax/orders/submit.html?_=1668675450269 167.99.142.201

set names utf8

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 3
# [17-Nov-2022 10:57:32] /photonics/tickets/bg/ajax/orders/submit.html?_=1668675452497 167.99.142.201

set names utf8

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 3
# [17-Nov-2022 10:57:36] /photonics/tickets/bg/ajax/orders/submit.html?_=1668675456597 167.99.142.201

set names utf8

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 3

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `PostDate` = '2022-11-17 10:57:36', `LastUpdate` = '2022-11-17 10:57:36', `ProjectionID` = '1', `Data` = 'P9rBYrTMjpEX9TmHyHbDg08e3ROb5m8EN3Vi59M9J7VIWsqZYRUxDqDOCqWE6uNe3Wbsr9v-MkpQkvbsULCzDdm0t-p4l2WL6ayN7IzR1aBojTN7Bm3j4OmG3P5mMmcAZFiQy8r7Zl6GkY_ilC0noyIuJyNwfsLIJZpZNySehx0tPDfjre1rvqEYPWEo7BA9Av6Rh8bAiPJJTgTwMgm0_A', `SearchKey` = 'wofCuMOWwqPDmMKkwrPCtsKHwrnC', `SortName` = '10821072', `Status` = 16

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(), 135, 202211171030, 1, 1, 10.00, 0)

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

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

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

INSERT INTO `tickets`
            (`ID`, `PostDate`, `LastUpdate`, `OrderID`, `DateTime`, `OrderType`, `TicketType`, `Price`, `Status`) VALUES
            (NULL, NOW(), NOW(), 135, 202211171030, 1, 1, 10.00, 0)
# [17-Nov-2022 10:57:36] /photonics/tickets/bg/orders/preview/135.html 167.99.142.201

set names utf8

SELECT
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 135
            LIMIT 1

SELECT
                `tickets`.*,
                `projections`.`Title`
            FROM
                `tickets`
                INNER JOIN `orders` ON `tickets`.`OrderID` = `orders`.`ID`
                INNER JOIN `projections` ON `orders`.`ProjectionID` = `projections`.`ID`
            WHERE
                `tickets`.`OrderID` = 135
            ORDER BY
                `tickets`.`ID` ASC

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'orders'
             ORDER BY
                `labels`.`Label` ASC
# [17-Nov-2022 10:57:43] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:57:45] /photonics/tickets/bg/orders/1.html?dt=202211171030 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
         LIMIT 1

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 2

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
# [17-Nov-2022 10:57:46] /photonics/tickets/bg/orders/sales/1.html?dt=202211171030 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
         LIMIT 1

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211171030 AND
                `OrderType` & 2

SELECT
                `orders`.`ID`,
                `orders`.`PostDate`,
                COUNT(`tickets`.`ID`) AS `All`,
                SUM(`tickets`.`Status`) AS `Used`,
                SUM(`tickets`.`Price`) AS `TotalPrice`
            FROM
                `orders`
                INNER JOIN `tickets` ON `orders`.`ID` = `tickets`.`OrderID`
            WHERE
                `orders`.`ProjectionID` = 1 AND
                `tickets`.`DateTime` = 202211171030 AND
                `tickets`.`OrderType` = 1
            GROUP BY
                `orders`.`ID`
             ORDER BY
                `orders`.`PostDate` ASC
# [17-Nov-2022 10:59:47] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:59:49] /photonics/tickets/bg/projections.html?d=2022-11-23 167.99.142.201

set names utf8

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
                `Wednesday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:59:51] /photonics/tickets/bg/projections.html?d=2022-11-23 167.99.142.201

set names utf8

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
                `Wednesday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:59:52] /photonics/tickets/bg/projections.html?d=2022-11-22 167.99.142.201

set names utf8

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
# [17-Nov-2022 10:59:52] /photonics/tickets/bg/projections.html?d=2022-11-21 167.99.142.201

set names utf8

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
                `Monday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:59:53] /photonics/tickets/bg/projections.html?d=2022-11-20 167.99.142.201

set names utf8

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
                `Sunday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:59:54] /photonics/tickets/bg/projections.html?d=2022-11-19 167.99.142.201

set names utf8

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
                `Saturday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:59:54] /photonics/tickets/bg/projections.html?d=2022-11-18 167.99.142.201

set names utf8

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
                `Friday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:59:55] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:59:56] /photonics/tickets/bg/projections.html?d=2022-11-19 167.99.142.201

set names utf8

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
                `Saturday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 10:59:57] /photonics/tickets/bg/projections.html?d=2022-11-20 167.99.142.201

set names utf8

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
                `Sunday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 11:05:49] /photonics/tickets/bg/projections.html?d=2022-11-21 167.99.142.201

set names utf8

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
                `Monday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 11:05:53] /photonics/tickets/bg/projections.html 167.99.142.201

set names utf8

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
                `Thursday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 11:06:00] /photonics/tickets/bg/projections.html?d=2022-11-18 167.99.142.201

set names utf8

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
                `Friday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 11:06:02] /photonics/tickets/bg/projections.html?d=2022-11-19 167.99.142.201

set names utf8

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
                `Saturday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 11:06:03] /photonics/tickets/bg/projections.html?d=2022-11-20 167.99.142.201

set names utf8

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
                `Sunday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 11:06:04] /photonics/tickets/bg/projections.html?d=2022-11-21 167.99.142.201

set names utf8

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
                `Monday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [17-Nov-2022 11:07:49] /photonics/tickets/bg/projections.html?d=2022-11-22 167.99.142.201

set names utf8

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
