# [19-Sep-2025 00:37:02] /processspace/www/bg/за-нас.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'за-нас' AND
                -- `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'pages' AND
	    		`URLLabel` = 'за-нас'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPhotographer') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `ID` = 74 AND `Language` = 'bg' AND `Module` = 'pages' AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubMembership') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
# [19-Sep-2025 02:42:49] /processspace/www/bg/събития.html 167.99.142.201

set names utf8

SELECT
                `Module`
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
	    		`URLLabel` = 'събития' AND
                -- `ParentID` = 1 AND
                (`Action` IS NULL OR `Action` = '')
         AND `Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`pages`
	    	WHERE
                `Language` = 'bg' AND
                `Module` = 'events' AND
	    		`URLLabel` = 'събития'
         AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LPhotographer') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
	        	*
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != ''
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LReadMore') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Feb') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Nov') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jul') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jun') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Apr') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('Jan') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                        `URLLabel`
                    FROM
                        `pages`
                    WHERE
                        1
                 AND `ID` = 74 AND `Language` = 'bg' AND `Module` = 'pages' AND `Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LClubMembership') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `ID`,
                `Module`,
                `MenuLabel`,
                `SubMenuLabel`,
                `FooterLabel`,
                `URLLabel`,
                (SELECT `ID` FROM `pages` AS `SP` WHERE `SP`.`ParentID` = `pages`.`ID`AND `Language` = 'bg' AND `Module` = 'pages' LIMIT 1) AS `ChildID`
            FROM
                `pages`
            WHERE
                `ParentID` = 1 AND
                (`MenuLabel` <> '' OR `SubMenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC

SELECT
                `MenuLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `ParentID` = 50 AND
                `Language` = 'bg' AND
                `MenuLabel` > '' AND
                `URLLabel` > '' AND
                `Module` = 'pages' AND
                `Visible` = 1
            ORDER BY
                `PostDate` ASC
