
set names utf8

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'cmr'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Language`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Visible` = 1 AND
                `Language` != 'bg' AND
                `ID` = 17

SELECT
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `AddOn` LIKE '%/contacts/%'
         AND `Visible` = 1 LIMIT 1

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` = 0 AND
                `MainNav` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` = 0 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC

SELECT
                `MenuLabel`,
                `SubTitle`,
                `URLLabel`,
                `AddOn`
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ParentID` = 3 AND
                `Footer` = 1

         AND `Visible` = 1 ORDER BY `PostDate` ASC
