# [09-Nov-2022 13:36:23] /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
# [09-Nov-2022 13:36:24] /photonics/www/bg/ajax/contacts/form.html?_=1667993786705 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
# [09-Nov-2022 13:36: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
                `Wednesday` != ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC
# [09-Nov-2022 13:36:32] /photonics/tickets/bg/orders/1.html?dt=202211091030 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` = 202211091030 AND
                `OrderType` & 1

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211091030 AND
                `OrderType` & 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
# [09-Nov-2022 13:36:35] /photonics/tickets/bg/ajax/orders/submit.html?_=1667993797713 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` = 202211091030 AND
                `OrderType` & 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `PostDate` = '2022-11-09 13:36:35', `LastUpdate` = '2022-11-09 13:36:35', `ProjectionID` = '1', `Data` = 'N_OrNfGNfU-_yC8_KQgTpf3ZJ_-6X6dohYHbs-FwWOfNxcRr9aMcXuKjLrHXrJD3LJXVmvnk4Ps0S62dd182lOrUqkQ3Cc2O6vNcfI5irvJ0URYmWKebYp3_dfqyP3QCv43tQJGin4l4q6EJkiRolNHQPZPvptovOaykd_VAlLk3tQbSkvbP7FEqJzea3B1PDG1DdKm9REI1R8xfeb572g', `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(), 129, 202211091030, 1, 1, 10.00, 0)

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

INSERT INTO `tickets`
            (`ID`, `PostDate`, `LastUpdate`, `OrderID`, `DateTime`, `OrderType`, `TicketType`, `Price`, `Status`) VALUES
            (NULL, NOW(), NOW(), 129, 202211091030, 1, 1, 10.00, 0)
# [09-Nov-2022 13:36:35] /photonics/tickets/bg/orders/preview/129.html 167.99.142.201

set names utf8

SELECT
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 129
            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` = 129
            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
# [09-Nov-2022 13:36:51] /photonics/tickets/bg/orders/sales/1.html?dt=202211091030 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` = 202211091030 AND
                `OrderType` & 1

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

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` = 202211091030 AND
                `tickets`.`OrderType` = 1
            GROUP BY
                `orders`.`ID`
             ORDER BY
                `orders`.`PostDate` ASC
# [09-Nov-2022 13:36:54] /photonics/tickets/bg/orders/resv/1.html?dt=202211091030 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` = 202211091030 AND
                `OrderType` & 1

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

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` = 202211091030 AND
                `tickets`.`OrderType` = 2
            GROUP BY
                `orders`.`ID`
             ORDER BY
                `orders`.`PostDate` ASC
# [09-Nov-2022 13:36:59] /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
                `Wednesday` != ''
         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
# [09-Nov-2022 13:37:02] /photonics/www/bg/orders/1.html?dt=202211091130 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` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
# [09-Nov-2022 13:37:14] /photonics/www/bg/ajax/orders/submit.html?_=1667993837088 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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` = 202211091130 AND
                `OrderType` & 1

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2022-11-09 13:37:14', `ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b', `ProjectionID` = '1', `Data` = 'A4tDbJMDMayQ5TN9H0mlfKPTBI0SD7jLqheGs2qGRURhAVAS-qwz964t3ypgIatT4EmZrTLkgzpLkm9hv6NRWWD7bFrtpJo3ac3CoMfJMDcDk-oZBCrO9N04ZriPYIm8aA2xB_8DHKOnCGEVUbqfOimw2R6qNAVGTeat1zE49NiT7mt0Y7fnUhGLO0jBEMPmRirQO4Fg70xeMKU-ynkoG_BtQtXcaelUqBxE-yBhhlJwFYqudHKsCA_CAtmfWoKBqmggBM9UuG_T8sojAN8NtPNkKalR3UIRIyvMMhgSNC0', `SearchKey` = 'wrnDmcKqw4zDhsKIwwrvCs8K6w4zDicwrDDhMK2wrrDh8ODwrLDrsKkw4HDwrDDg8KuwwqTCsMOLwofCs8OAw5PDrsKlwrHDhc', `SortName` = '1100097', `PostDate` = '2022-11-09 13:37:14'
# [09-Nov-2022 13:37:14] /photonics/www/bg/orders/preview.html 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = 'fc0b3e74b4bcf27cacdc22ad825f6d7b440f070d623c8ee5f251f3e2d079741b' 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
# [09-Nov-2022 13:44:56] /photonics/tickets/bg/orders/1.html?dt=202211091130 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` = 202211091130 AND
                `OrderType` & 1

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211091130 AND
                `OrderType` & 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
# [09-Nov-2022 13:45:03] /photonics/tickets/bg/orders/sales/1.html?dt=202211091130 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` = 202211091130 AND
                `OrderType` & 1

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

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` = 202211091130 AND
                `tickets`.`OrderType` = 1
            GROUP BY
                `orders`.`ID`
             ORDER BY
                `orders`.`PostDate` ASC
# [09-Nov-2022 13:45:05] /photonics/tickets/bg/orders/resv/1.html?dt=202211091130 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` = 202211091130 AND
                `OrderType` & 1

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

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` = 202211091130 AND
                `tickets`.`OrderType` = 2
            GROUP BY
                `orders`.`ID`
             ORDER BY
                `orders`.`PostDate` ASC
# [09-Nov-2022 13:45:33] /photonics/tickets/bg/orders/2.html?dt=202211091930 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` = 2
         LIMIT 1

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'orders'
             ORDER BY
                `labels`.`Label` ASC
# [09-Nov-2022 13:45:37] /photonics/tickets/bg/projections.html?d=2022-11-14 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
# [09-Nov-2022 13:45:39] /photonics/tickets/bg/projections.html?d=2022-11-12 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
# [09-Nov-2022 13:45:40] /photonics/tickets/bg/orders/2.html?dt=202211121930 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` = 2
         LIMIT 1

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'orders'
             ORDER BY
                `labels`.`Label` ASC
# [09-Nov-2022 13:45:41] /photonics/tickets/bg/projections.html?d=2022-11-13 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
# [09-Nov-2022 13:45:44] /photonics/tickets/bg/orders/2.html?dt=202211131930 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` = 2
         LIMIT 1

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

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

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Module` = 'orders'
             ORDER BY
                `labels`.`Label` ASC
# [09-Nov-2022 13:45:46] /photonics/tickets/bg/orders/sales/2.html?dt=202211131930 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` = 2
         LIMIT 1

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

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202211131930 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` = 2 AND
                `tickets`.`DateTime` = 202211131930 AND
                `tickets`.`OrderType` = 1
            GROUP BY
                `orders`.`ID`
             ORDER BY
                `orders`.`PostDate` ASC
