
set names utf8

SELECT
                `pages`.*,
                `SubPages`.`ID` AS `SubPageID`
	        FROM
	        	`pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID`
	    	WHERE
	    		`pages`.`URLLabel` = 'index'
         AND `pages`.`Visible` = 1 LIMIT 1

SELECT
                `products`.`ID`,
                `products`.`Title`,
                `products`.`URLLabel`,
                `products`.`Gallery`,
                `products`.`Visible`,
                `pages`.`ID` AS `GroupID`,
                `pages`.`ParentID`,
                `pages`.`Title` AS `GroupTitle`,
                `pages`.`URLLabel` AS `GroupURLLabel`,
                `ParentPages`.`Title` AS `PageTitle`,
                `ParentPages`.`Logo`,
                `ParentPages`.`URLLabel` AS `PageURLLabel`
            FROM
                `products`
                INNER JOIN `pages` ON `products`.`ParentID` = `pages`.`ID`
                INNER JOIN `pages` AS `ParentPages` ON `pages`.`ParentID` = `ParentPages`.`ID`
            WHERE
                `pages`.`Module` = 'products' AND
                `products`.`HomePage` = 1
         AND `products`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC, `products`.`PostDate` DESC

SELECT
	        	`machines`.`ID`,
                `machines`.`Title`,
                `machines`.`Annotation`,
                `machines`.`URLLabel`,
                `machines`.`Gallery`,
                `machines`.`Visible`,
                `pages`.`MenuLabel` AS `PageMenuLabel`,
                `pages`.`URLLabel` AS `PageURLLabel`
	        FROM
	        	`machines`
                INNER JOIN `pages` ON `machines`.`ParentID` = `pages`.`ID`
	    	WHERE 1
         AND `machines`.`HomePage` = 1 AND `machines`.`Visible` = 1 ORDER BY `machines`.`PostDate` DESC

SELECT
	        	`services`.`ID`,
                `services`.`Title`,
                `services`.`URLLabel`,
                `services`.`Icon`,
                `services`.`Annotation`,
                `services`.`Visible`,
                `pages`.`URLLabel` AS `PageURLLabel`
	        FROM
	        	`services`
                INNER JOIN `pages` ON `services`.`ParentID` = `pages`.`ID`
	    	WHERE 1
         AND `services`.`HomePage` = 1 AND `services`.`Visible` = 1 ORDER BY `services`.`PostDate` DESC

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `MLabel` = 'reviews'
         AND `Visible` = 1 LIMIT 1

SELECT
	        	*
	        FROM
	        	`reviews`
	    	WHERE 1
         AND `HomePage` = 1 AND `Visible` = 1 ORDER BY `PostDate` DESC

SELECT
                P1.`ID`,
                P1.`PostDate`,
                P1.`HeaderImage`,
                P1.`Title`,
                P1.`URLLabel`,
                P1.`Annotation`,
                P1.`Visible`,
                P2.`URLLabel` AS `ParentURLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON P1.`ParentID` = P2.`ID`
            WHERE
                P1.`Module` = 'news' AND
                P2.`Module` = 'news'
         AND P1.`Visible` = 1 ORDER BY P1.`PostDate` ASC LIMIT 3

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

SELECT
                0 AS `ID`,
                `machines`.`Title` AS `MenuLabel`,
                `machines`.`URLLabel`,
                `pages`.`URLLabel` AS `PageURLLabel`
            FROM
                `machines`
                INNER JOIN `pages` ON `machines`.`ParentID` = `pages`.`ID`
         WHERE `machines`.`Visible` = 1 ORDER BY `machines`.`PostDate` DESC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topleft'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topright'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `services`
            WHERE
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

SELECT
                `pages`.*,
                `SubPages`.`ID` AS `SubPageID`
	        FROM
	        	`pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID`
	    	WHERE
	    		`pages`.`URLLabel` = 'контакти'
         AND `pages`.`Visible` = 1 LIMIT 1

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

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

SELECT
                0 AS `ID`,
                `machines`.`Title` AS `MenuLabel`,
                `machines`.`URLLabel`,
                `pages`.`URLLabel` AS `PageURLLabel`
            FROM
                `machines`
                INNER JOIN `pages` ON `machines`.`ParentID` = `pages`.`ID`
         WHERE `machines`.`Visible` = 1 ORDER BY `machines`.`PostDate` DESC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topleft'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topright'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `services`
            WHERE
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

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

set names utf8

SELECT
                `pages`.*,
                `SubPages`.`ID` AS `SubPageID`
	        FROM
	        	`pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID`
	    	WHERE
	    		`pages`.`URLLabel` = 'контакти'
         AND `pages`.`Visible` = 1 LIMIT 1

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

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

SELECT
                0 AS `ID`,
                `machines`.`Title` AS `MenuLabel`,
                `machines`.`URLLabel`,
                `pages`.`URLLabel` AS `PageURLLabel`
            FROM
                `machines`
                INNER JOIN `pages` ON `machines`.`ParentID` = `pages`.`ID`
         WHERE `machines`.`Visible` = 1 ORDER BY `machines`.`PostDate` DESC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topleft'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topright'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `services`
            WHERE
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

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

set names utf8

SELECT
                `pages`.*,
                `SubPages`.`ID` AS `SubPageID`
	        FROM
	        	`pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID`
	    	WHERE
	    		`pages`.`URLLabel` = 'контакти'
         AND `pages`.`Visible` = 1 LIMIT 1

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

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

SELECT
                0 AS `ID`,
                `machines`.`Title` AS `MenuLabel`,
                `machines`.`URLLabel`,
                `pages`.`URLLabel` AS `PageURLLabel`
            FROM
                `machines`
                INNER JOIN `pages` ON `machines`.`ParentID` = `pages`.`ID`
         WHERE `machines`.`Visible` = 1 ORDER BY `machines`.`PostDate` DESC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topleft'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topright'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `services`
            WHERE
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

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

set names utf8

SELECT
                `pages`.*,
                `SubPages`.`ID` AS `SubPageID`
	        FROM
	        	`pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID`
	    	WHERE
	    		`pages`.`URLLabel` = 'контакти'
         AND `pages`.`Visible` = 1 LIMIT 1

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

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

SELECT
                0 AS `ID`,
                `machines`.`Title` AS `MenuLabel`,
                `machines`.`URLLabel`,
                `pages`.`URLLabel` AS `PageURLLabel`
            FROM
                `machines`
                INNER JOIN `pages` ON `machines`.`ParentID` = `pages`.`ID`
         WHERE `machines`.`Visible` = 1 ORDER BY `machines`.`PostDate` DESC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topleft'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topright'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `services`
            WHERE
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

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

set names utf8

SELECT
                `pages`.*,
                `SubPages`.`ID` AS `SubPageID`
	        FROM
	        	`pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID`
	    	WHERE
	    		`pages`.`URLLabel` = 'контакти'
         AND `pages`.`Visible` = 1 LIMIT 1

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

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

SELECT
                0 AS `ID`,
                `machines`.`Title` AS `MenuLabel`,
                `machines`.`URLLabel`,
                `pages`.`URLLabel` AS `PageURLLabel`
            FROM
                `machines`
                INNER JOIN `pages` ON `machines`.`ParentID` = `pages`.`ID`
         WHERE `machines`.`Visible` = 1 ORDER BY `machines`.`PostDate` DESC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topleft'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topright'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `services`
            WHERE
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

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

set names utf8

SELECT
                `pages`.*,
                `SubPages`.`ID` AS `SubPageID`
	        FROM
	        	`pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID`
	    	WHERE
	    		`pages`.`URLLabel` = 'контакти'
         AND `pages`.`Visible` = 1 LIMIT 1

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

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

SELECT
                0 AS `ID`,
                `machines`.`Title` AS `MenuLabel`,
                `machines`.`URLLabel`,
                `pages`.`URLLabel` AS `PageURLLabel`
            FROM
                `machines`
                INNER JOIN `pages` ON `machines`.`ParentID` = `pages`.`ID`
         WHERE `machines`.`Visible` = 1 ORDER BY `machines`.`PostDate` DESC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topleft'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topright'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `services`
            WHERE
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

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

set names utf8

SELECT
                `pages`.*,
                `SubPages`.`ID` AS `SubPageID`
	        FROM
	        	`pages`
                LEFT JOIN `pages` AS `SubPages` ON `pages`.`ID` = `SubPages`.`ParentID`
	    	WHERE
	    		`pages`.`URLLabel` = 'контакти'
         AND `pages`.`Visible` = 1 LIMIT 1

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

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

SELECT
                0 AS `ID`,
                `machines`.`Title` AS `MenuLabel`,
                `machines`.`URLLabel`,
                `pages`.`URLLabel` AS `PageURLLabel`
            FROM
                `machines`
                INNER JOIN `pages` ON `machines`.`ParentID` = `pages`.`ID`
         WHERE `machines`.`Visible` = 1 ORDER BY `machines`.`PostDate` DESC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topleft'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `pages`.`MenuLabel`,
                `pages`.`URLLabel`
            FROM
                `pages`
            WHERE
                `pages`.`MenuLabel` <> '' AND
                `pages`.`Position` = 'topright'
         AND `pages`.`Visible` = 1 ORDER BY `pages`.`PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `FooterLabel`,
                `URLLabel`
            FROM
                `services`
            WHERE
                `FooterLabel` <> ''
         AND `Visible` = 1 ORDER BY `PostDate` ASC

set names utf8

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