# [18-Nov-2022 10:28:53] /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
# [18-Nov-2022 10:28:54] /photonics/www/bg/ajax/contacts/form.html?_=1668760134229 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
# [18-Nov-2022 10:28:58] /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
                `Friday` != ''
         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
# [18-Nov-2022 10:29:01] /photonics/www/bg/orders/1.html?dt=202211181030 167.99.142.201

set names utf8

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

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

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

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

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

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

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

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

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

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