# [29-Dec-2025 06:45:04] /arete/www/ 113.196.56.150

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            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

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'services'
             AND `Visible` = 1 LIMIT 1

SELECT
                `PostDate`,
                `UploadID`,
                `Image`,
                `URLLabel`,
                `Title`
            FROM
                `services`
            WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'projects'
             AND `Visible` = 1 LIMIT 1

SELECT
                `PostDate`,
                `UploadID`,
                `Image`,
                `URLLabel`,
                `Title`
            FROM
                `projects`
            WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Annotation` FROM `pages` WHERE`Module` = 'projects' AND
	`URLLabel` = 'проекти' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewMore') 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
                COUNT(`ID`)
            FROM
                `projects`
            WHERE
                `Language` = 'bg' AND
                `Image` != ''
         AND `Visible` = 1

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'events'
             AND `Visible` = 1 LIMIT 1

SELECT
                `PostDate`,
                `UploadID`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `events`
            WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Annotation` FROM `pages` WHERE`Module` = 'events' AND
	`URLLabel` = 'новини' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `events`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != ''
         AND `Visible` = 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('FooterInfo','FooterContactUs','FooterAddress','FooterPhone') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [29-Dec-2025 22:36:13] /arete/www/ 113.196.56.150

set names utf8

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `Title`,
                `Content`
            FROM
                `slides`
            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

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

SELECT
                P2.`Language`,
                P2.`URLLabel`
            FROM
                `pages` AS P1
                INNER JOIN `pages` AS P2 ON
                    P1.`ID` = P2.`ID` AND
                    P2.`NoIndex` = 0 AND
                    P2.`Language` != 'bg' AND
                    P2.`Visible` = 1
            WHERE
                P1.`NoIndex` = 0 AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'index' AND
                P1.`Visible` = 1

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'services'
             AND `Visible` = 1 LIMIT 1

SELECT
                `PostDate`,
                `UploadID`,
                `Image`,
                `URLLabel`,
                `Title`
            FROM
                `services`
            WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'projects'
             AND `Visible` = 1 LIMIT 1

SELECT
                `PostDate`,
                `UploadID`,
                `Image`,
                `URLLabel`,
                `Title`
            FROM
                `projects`
            WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Annotation` FROM `pages` WHERE`Module` = 'projects' AND
	`URLLabel` = 'проекти' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LViewMore') 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
                COUNT(`ID`)
            FROM
                `projects`
            WHERE
                `Language` = 'bg' AND
                `Image` != ''
         AND `Visible` = 1

SELECT
                    `URLLabel`
                FROM
                    `pages`
                WHERE
                    `Language` = 'bg' AND
                    `ParentID` = 1 AND
                    `Module` = 'events'
             AND `Visible` = 1 LIMIT 1

SELECT
                `PostDate`,
                `UploadID`,
                `Image`,
                `URLLabel`,
                `Title`,
                `Annotation`
            FROM
                `events`
            WHERE
                `Language` = 'bg' AND
                `FirstPage` = 1 AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

SELECT `Annotation` FROM `pages` WHERE`Module` = 'events' AND
	`URLLabel` = 'новини' AND
	`Language` = 'bg' AND
	`Visible` = 1 LIMIT 1

SELECT
                COUNT(`ID`)
            FROM
                `events`
            WHERE
                `Language` = 'bg' AND
                (`StartFrom` IS NULL OR `StartFrom` <= CURDATE()) AND
                (`EndTo` IS NULL OR `EndTo` >= CURDATE()) AND
                `Image` != ''
         AND `Visible` = 1

SELECT
                `Module`,
                `MenuLabel`,
                `FooterLabel`,
                `URLLabel`
            FROM
                `pages`
            WHERE
                `Module` != 'users' AND
                (`MenuLabel` <> '' OR `FooterLabel` <> '') AND
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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