# [01-Dec-2022 07:13:10] /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
# [01-Dec-2022 07:13:11] /photonics/tickets/bg/orders/1.html?dt=202212011030 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` = 202212011030 AND
                `OrderType` & 1

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202212011030 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
# [01-Dec-2022 07:13:13] /photonics/tickets/bg/ajax/orders/submit.html?_=1669871593975 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` = 202212011030 AND
                `OrderType` & 3

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `PostDate` = '2022-12-01 07:13:13', `LastUpdate` = '2022-12-01 07:13:13', `ProjectionID` = '1', `Data` = 'bQj4YIwCp-70TeyrCiamllm_ybyT6oCPQDsNiF3v7dNNZGbzdU8tBvpyLJBWNl-kq44sXGLzk5AmbUX6bYtc0snFXjudO97i2fJnj_YJmIydHdO9rGbzWThOkxrp15MSVYroNG7rvuYHPAblAdoQfD7-2vnnCnM9OsLFBBTI6lihXsrli0wLv47F8jiGXMbzpt_mPjsskv_hYipZWpyYCg', `SearchKey` = 'wofCuMOWwqPDmMKkwrPCtsKHwrnC', `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(), 145, 202212011030, 1, 1, 10.00, 0)
# [01-Dec-2022 07:13:14] /photonics/tickets/bg/orders/preview/145.html 167.99.142.201

set names utf8

SELECT
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 145
            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` = 145
            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
# [01-Dec-2022 07:13:27] /photonics/tickets/bg/ajax/tickets.html?_=1669871607549 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` = 117389403

UPDATE
                `tickets`
            SET
                `LastUpdate` = NOW(),
                `Status` = 1
            WHERE
                `ID` = 117389403
            LIMIT 1

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
# [01-Dec-2022 07:13:35] /photonics/tickets/bg/ajax/tickets.html?_=1669871615275 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` = 117389403
# [01-Dec-2022 07:28:39] /photonics/tickets/bg/ajax/tickets.html?_=1669872519549 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` = 117389394

UPDATE
                `tickets`
            SET
                `LastUpdate` = NOW(),
                `Status` = 1
            WHERE
                `ID` = 117389394
            LIMIT 1

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
# [01-Dec-2022 07:58:13] /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
# [01-Dec-2022 07:58:13] /photonics/www/bg/ajax/contacts/form.html?_=1669874293410 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
# [01-Dec-2022 07:58:13] /photonics/www/bg/ajax/cookies/popup.html?_=1669874293411 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

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` = 'rules'
         AND `Visible` = 1 LIMIT 1
# [01-Dec-2022 07:58:35] /photonics/www/bg/orders/send.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
# [01-Dec-2022 07:58:35] /photonics/www/bg/ajax/cookies/popup.html?_=1669874315772 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
# [01-Dec-2022 08:06:04] /photonics/www/bg/orders/send.html 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `Status` & 1 AND
                `Status` & 4 = 0 AND
                `Status` & 16
            LIMIT 1

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
# [01-Dec-2022 08:06:04] /photonics/www/bg/ajax/cookies/popup.html?_=1669874764397 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
# [01-Dec-2022 08:06:25] /photonics/www/bg/orders/send.html 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `Status` & 1 AND
                `Status` & 4 = 0 AND
                `Status` & 16
            LIMIT 1

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
# [01-Dec-2022 08:06:26] /photonics/www/bg/ajax/cookies/popup.html?_=1669874786166 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
# [01-Dec-2022 08:10:32] /photonics/www/bg/orders/send.html 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `Status` & 1 AND
                `Status` & 4 = 0 AND
                `Status` & 16
            LIMIT 1

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
# [01-Dec-2022 08:10:32] /photonics/www/bg/ajax/cookies/popup.html?_=1669875032920 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
# [01-Dec-2022 08:15:09] /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
# [01-Dec-2022 08:15:10] /photonics/tickets/bg/orders/1.html?dt=202212011030 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` = 202212011030 AND
                `OrderType` & 1

SELECT
                COUNT(`ID`)
            FROM
                `tickets`
            WHERE
                `DateTime` = 202212011030 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
# [01-Dec-2022 08:15:13] /photonics/tickets/bg/ajax/orders/submit.html?_=1669875313078 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` = 202212011030 AND
                `OrderType` & 3

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `PostDate` = '2022-12-01 08:15:13', `LastUpdate` = '2022-12-01 08:15:13', `ProjectionID` = '1', `Data` = 'KI5IeQWVi9UPsST3axTWUkJb9LUJhrGW2r4NafFwFgQMlAFgJSotOcF0yGe2GDeU9kZPs5p8ULhkS9sIfQebm2YC-AF952jVLi7bBLtZPiQl4y6A8J2WSvjnwi1iBNCVZavTyqGndXgdJF9dCy9W05SxVzdXIiV60BL0KEpa8BfHQ2V-KstOXDpsdhsOGhStIChMILnuL00eqDAJvP7ZTw', `SearchKey` = 'wofCuMOWwqPDmMKkwrPCtsKHwrnC', `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(), 146, 202212011030, 1, 1, 10.00, 0)
# [01-Dec-2022 08:15:13] /photonics/tickets/bg/orders/preview/146.html 167.99.142.201

set names utf8

SELECT
                `Data`,
                `Status`
            FROM
                `orders`
            WHERE
                `ID` = 146
            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` = 146
            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
# [01-Dec-2022 08:16:33] /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
# [01-Dec-2022 08:16:33] /photonics/www/bg/ajax/contacts/form.html?_=1669875393903 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
# [01-Dec-2022 08:16:33] /photonics/www/bg/ajax/cookies/popup.html?_=1669875393908 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
# [01-Dec-2022 08:16:35] /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
                `Thursday` != ''
         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
# [01-Dec-2022 08:16:35] /photonics/www/bg/ajax/cookies/popup.html?_=1669875395727 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
# [01-Dec-2022 08:16:38] /photonics/www/bg/orders/1.html?dt=202212011030 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
                `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
# [01-Dec-2022 08:18:46] /photonics/www/bg/orders/1.html?dt=202212011030 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` = '81c8212af632a6ac628aaa97258760113c34f899b1b9bfce06876ae3704194e4' 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
# [01-Dec-2022 08:18:58] /photonics/www/bg/ajax/orders/submit.html?_=1669875538751 167.99.142.201

set names utf8

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

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

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2022-12-01 08:18:58', `ClientID` = '81c8212af632a6ac628aaa97258760113c34f899b1b9bfce06876ae3704194e4', `ProjectionID` = '1', `Data` = '1e_X1tg-vAhxpgn4BdnW-wIIYMRocKB95bgFt1FRJCcQMiPDWPQkCNdwfCkeEQWDxDuKAIgjCTe7p3fvApkxSGk8alfJY4ltqXuSA0iy0ImCyUTF2cMBXGxK1lZz4ZtaGirqUPANT9R5dLTpqmIvdOLyWwy6b15G3-Rue_9kqYXuHvEpkiMaTQlzXbcdP8HxPBD9mdeNcN51RuNKxOK7QZLybsDxSD3pzo9v6WgMWzdCQyqXrHXHlO0koF9nIfNWUS_teOCF2dUs4MVeEG32ayhZK0kUlb7vv52BO_nFm5qmmgIctZpJsLlwafj3eERkps5iY3_8JHrm_AyDjJYs6w', `SearchKey` = 'wrjCtMKuw4LDiMKJwr7DwrHCs8KqwoTCvsKuwrbDrsK4wpDwrHCs8KqwoTCvsKuwrbDrsK4wpDwrHCnsKVwrrDhsKtwwrDCnsKdwwqTCsMOLwobCs8Kqwq3CpsKmwrHDhcKAwqDC', `PostDate` = '2022-12-01 08:18:58'
# [01-Dec-2022 08:18:58] /photonics/www/bg/orders/preview.html 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = '81c8212af632a6ac628aaa97258760113c34f899b1b9bfce06876ae3704194e4' 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
# [01-Dec-2022 08:19:03] /photonics/www/bg/ajax/orders/confirm.html?_=1669875543124 167.99.142.201

set names utf8

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

UPDATE
                    `orders`
                SET
                    `LastUpdate` = NOW(),
                    `Status` = `Status` | 1
                WHERE
                    `ID` = 147
                LIMIT 1
# [01-Dec-2022 10:06:38] /photonics/www/bg/orders/send.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
# [01-Dec-2022 10:06:40] /photonics/www/bg/orders/send.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
# [01-Dec-2022 14:56:46] /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
# [01-Dec-2022 14:56:46] /photonics/www/bg/ajax/contacts/form.html?_=1669899411085 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
# [01-Dec-2022 14:56:48] /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
                `Thursday` != ''
         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
# [01-Dec-2022 14:56:49] /photonics/www/bg/orders/1.html?dt=202212011030 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` = '1f36343039525a9c7d7d7af258954f09f2f7f44623ad4aae5de078ad808c376a'
                `Status` & 4 = 0 AND
            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
# [01-Dec-2022 14:57:11] /photonics/www/bg/orders/1.html?dt=202212011030 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` = '1f36343039525a9c7d7d7af258954f09f2f7f44623ad4aae5de078ad808c376a' AND
                `Status` & 4 = 0
            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
# [01-Dec-2022 14:57:21] /photonics/www/bg/ajax/orders/submit.html?_=1669899445159 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = '1f36343039525a9c7d7d7af258954f09f2f7f44623ad4aae5de078ad808c376a' AND
                `Status` & 4 = 0
            LIMIT 1

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

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

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

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

SELECT * FROM `orders` LIMIT 1

SHOW COLUMNS FROM `orders`

INSERT INTO `orders` SET `LastUpdate` = '2022-12-01 14:57:21', `ClientID` = '1f36343039525a9c7d7d7af258954f09f2f7f44623ad4aae5de078ad808c376a', `ProjectionID` = '1', `Data` = '95PxEnd-a8YAT9oMrOKkm9NdDx9Ca1Nh3U0X5eF_ucswPL_QE4a7U2GthNc4LZeJZiXcYXpPXweIb8wRBvaCbqdOCsbZDgw4RrWD_-gyOGT5UPymdqF1cZX2yehjMk0IJfgJunhVS8zMb9eeIIlz2ob72M-9j1DlDshH4fPVwxNxFyeHyMol9D5EhICFCWkQHRx6VfcIr_N8SK7oXHUB3s4nQ1CwtUqMgGnjKx0P1DNCahSqcjU5ZahNV24T4STPVIMiVIHrRRJj2BQ6tdpNRhqbevnjfX9xNl4v-Tnu7glGEAp7rURRmMw-hQt7rcsswyNZE0rzfylb8cp7b7Ylrw', `SearchKey` = 'wrjCtMKuw4LDiMKJwr7DwrHCs8KqwoTCvsKuwrbDrsK4wpDwrHCs8KqwoTCvsKuwrbDrsK4wpDwrHCnsKVwrrDhsKtwwrDCnsKdwwqTCsMOLwobCs8Kqwq3CpsKmwrHDhcKAwqDC', `PostDate` = '2022-12-01 14:57:21'
# [01-Dec-2022 14:57:21] /photonics/www/bg/orders/preview.html 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = '1f36343039525a9c7d7d7af258954f09f2f7f44623ad4aae5de078ad808c376a' AND
                `Status` & 4 = 0
            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
# [01-Dec-2022 14:57:23] /photonics/www/bg/ajax/orders/confirm.html?_=1669899447348 167.99.142.201

set names utf8

SELECT
                `ID`,
                `Data`
            FROM
                `orders`
            WHERE
                `ClientID` = '1f36343039525a9c7d7d7af258954f09f2f7f44623ad4aae5de078ad808c376a' AND
                `Status` & 4 = 0
            LIMIT 1

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