# [07-Apr-2026 11:27:44] /animus/www/ 108.61.209.243

set names utf8

SELECT
                    *
                FROM
                    `meta`
                    INNER JOIN `pages` ON
                        `pages`.`ID` = `meta`.`ID` AND
                        `pages`.`Language` = `meta`.`Language`
                WHERE
                    `meta`.`Language` = 'bg' AND
                    `meta`.`Module` = 'pages' AND
                    `meta`.`URLLabel` = 'index'
             AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `pages`.`Title`,
                `pages`.`Annotation`,
                `meta`.`Visible`
            FROM
                `pages`
                INNER JOIN `meta` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'pages'
            WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Content`,
                `Position`,
                `Limit`
            FROM
                `blocks`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'banners' AND
                `Action` = 'home'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
            FROM
                `banners`
            WHERE
                `Language` = 'bg'
         AND `HomePage` = 1 AND
                `Visible` = 1
            
            ORDER BY
                `PostDate` ASC
         LIMIT 0, 8

SELECT
                `Content`,
                `Position`,
                `Limit`
            FROM
                `blocks`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'news' AND
                `Action` = 'home'
         AND `Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `news`.`Title`,
                `news`.`Annotation`,
                `meta`.`Visible`
            FROM
                `news`
                INNER JOIN `meta` ON
                    `news`.`ID` = `meta`.`ID` AND
                    `news`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'news'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'news'
            WHERE
                `meta`.`Language` = 'bg'
         AND `news`.`HomePage` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `news`.`ID`
            ORDER BY
                `meta`.`PostDate` DESC
         LIMIT 0, 6

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 ('Oct') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Content`,
                `Position`,
                `Limit`
            FROM
                `blocks`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'activities' AND
                `Action` = 'home'
         AND `Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `activities`.`Title`,
                `activities`.`Color`,
                `activities`.`Annotation`,
                `meta`.`Visible`
            FROM
                `activities`
                INNER JOIN `meta` ON
                    `activities`.`ID` = `meta`.`ID` AND
                    `activities`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'activities'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'activities'
            WHERE
                `meta`.`Language` = 'bg'
         AND `activities`.`HomePage` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `activities`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC
         LIMIT 0, 9

SELECT
                `Content`,
                `Position`,
                `Limit`
            FROM
                `blocks`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'publications' AND
                `Action` = 'home'
         AND `Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`) AS `URLLabels`,
                `publications`.`Title`,
                `publications`.`Image`,
                `publications`.`PDF`,
                `publications`.`Annotation`,
                `meta`.`Visible`
            FROM
                `publications`
                INNER JOIN `meta` ON
                    `publications`.`ID` = `meta`.`ID` AND
                    `publications`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'publications'
                INNER JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `Parent`.`Module` = 'publications'
            WHERE
                `meta`.`Language` = 'bg'
         AND `publications`.`HomePage` = 1 AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `publications`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC
         LIMIT 0, 6

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

SELECT COUNT(*) FROM `meta` WHERE `Module` = 'publications' and `Language` = 'bg' AND `ID` > 100000 AND `Visible` = 1

SELECT
                `Content`,
                `Position`,
                `Limit`
            FROM
                `blocks`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'financing' AND
                `Action` = 'home'
         AND `Visible` = 1 LIMIT 1

SELECT
                `meta`.`URLLabel`,
                `pages`.`Title`
            FROM
                `pages`
                INNER JOIN `meta` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'financing'
            WHERE
                `pages`.`Action` = 'home' AND
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Content`,
                `Position`,
                `Limit`
            FROM
                `blocks`
            WHERE
                `Language` = 'bg' AND
                `Module` = 'partners' AND
                `Action` = 'home'
         AND `Visible` = 1 LIMIT 1

SELECT
                *
            FROM
                `partners`
            WHERE
                `Language` = 'bg'
         AND `HomePage` = 1 AND
                `Visible` = 1
            
            ORDER BY
                `PostDate` ASC
         LIMIT 0, 12

SELECT COUNT(*) FROM `partners` WHERE `Language` = 'bg' AND `HomePage` = 0 AND `Visible` = 1

SELECT
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`) AND
                `pages`.`Language` = 'bg' AND
                `meta`.`Module` = 'partners' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                `meta`.`Module`,
                `pages`.`MenuLabel`,
                `pages`.`FooterLabel`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `meta`.`ParentID` = 1 AND
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         AND `meta`.`Visible` = 1
            GROUP BY
                `pages`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('HelpPhone','LSlogan','LMenu','LWorkingHours','WorkingHours','Address','LFollowUs','FacebookURL','InstagramURL','Phones','EMail','LFooterInfo','LContactUs','Copyright','LFundation','MGURL','MGLabel','MGAlt') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
