# [01-Apr-2025 05:20:02] /processspace/www/psNr2S0bbg/pages/gideonsmilansky.com 167.99.142.201

set names utf8

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
# [01-Apr-2025 05:25:02] /processspace/www/psNr2S0bbg/pages/gideonsmilansky.com 167.99.142.201

set names utf8

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
# [01-Apr-2025 12:39:14] /processspace/www/ 167.99.142.201

set names utf8

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

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

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `HeaderFirstPage` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC LIMIT 3

SELECT
                *
            FROM
                `pages`
            WHERE
                `Language` = 'bg' AND
                `ImageHome` > '' AND
                `FirstPage` = 1
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URLLabel`,
                `Color`
	        FROM
	        	`events`
	    	WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `NoIndex` = 0 AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE())
         AND `Visible` = 1 ORDER BY `PostDate` DESC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URL`
	        FROM
	        	`videos`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 67
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` ASC

SELECT
	        	`Title`,
                `URL`
	        FROM
	        	`videos`
	    	WHERE
                `Language` = 'bg' AND
                `ParentID` = 68
         AND `Visible` = 1 ORDER BY `PostDate` ASC, `LastUpdate` 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
