# [21-Mar-2025 14:38:27] /tropicana/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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LBookNow') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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
                `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 ('Address','LFollowUs','FacebookURL','TripadvisorURL','Phone','EMail','LFooterInfo','LContactUs','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [21-Mar-2025 14:38:30] /tropicana/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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LBookNow') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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
                `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 ('Address','LFollowUs','FacebookURL','TripadvisorURL','Phone','EMail','LFooterInfo','LContactUs','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [21-Mar-2025 14:38:35] /tropicana/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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LBookNow') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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
                `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 ('Address','LFollowUs','FacebookURL','TripadvisorURL','Phone','EMail','LFooterInfo','LContactUs','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [21-Mar-2025 14:41:00] /tropicana/www/bg/ajax/users/form/login.html?_=1742560860118 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorEMail','ErrorPassword') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [21-Mar-2025 14:41:23] /tropicana/www/tR7v2Spz9Wa/bg/ajax/users/login.html?_=1742560883152 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'N2EzMzMyZTM2NTFkMWQ1YzU1ZTM1NTBiYTNkMjVlMTUNmRhNTc1ZDhiNjlhZTM3YTkxZjUzZGIwMmI1MWQzMWU%'
            LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorUserPass') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [21-Mar-2025 14:41:26] /tropicana/www/tR7v2Spz9Wa/bg/ajax/users/login.html?_=1742560886086 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'N2EzMzMyZTM2NTFkMWQ1YzU1ZTM1NTBiYTNkMjVlMTUMDRlMDNlZGJlODkyODMwYTBjNzc0YTlkOTYxNjIzMWU%'
            LIMIT 1
# [21-Mar-2025 14:41:26] /tropicana/www/tR7v2Spz9Wa/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876879 AND
                                CRC32(`UserKey`) = 3514158796 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `pages`.`Action`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `meta`.`Visible`
            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
                `pages`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         ORDER BY `meta`.`PostDate` ASC
# [21-Mar-2025 14:41:35] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/form/pages/1.html?_=1742560894963 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876879 AND
                                CRC32(`UserKey`) = 3514158796 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT
                `Parent`.`Module` AS `ParentModule`,
                `meta`.*,
                `pages`.*
            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`.`ID` = 1 AND
                `meta`.`Module` = 'pages' AND
                `meta`.`Language` = 'bg'
            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`ParentID`,
                `meta`.`Module`,
                `pages`.`MenuLabel` AS `Label`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`Module` = 'pages' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''

SELECT `Module`, `Action`, `Label` FROM `blocks`
# [21-Mar-2025 14:42:57] /tropicana/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
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LBookNow') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

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

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

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
                `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 ('Address','LFollowUs','FacebookURL','TripadvisorURL','Phone','EMail','LFooterInfo','LContactUs','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [21-Mar-2025 14:44:14] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/form/pages/1.html?_=1742561054823 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876879 AND
                                CRC32(`UserKey`) = 3514158796 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT
                `Parent`.`Module` AS `ParentModule`,
                `meta`.*,
                `pages`.*
            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`.`ID` = 1 AND
                `meta`.`Module` = 'pages' AND
                `meta`.`Language` = 'bg'
            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`ParentID`,
                `meta`.`Module`,
                `pages`.`MenuLabel` AS `Label`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`Module` = 'pages' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''

SELECT `Module`, `Action`, `Label` FROM `blocks`
# [21-Mar-2025 14:44:37] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/update/1.html?_=1742561077761 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876879 AND
                                CRC32(`UserKey`) = 3514158796 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT IF(COUNT(`ID`) > 0, TRUE, FALSE) FROM `meta` WHERE `ID` <> 1 AND `Module` = 'pages' AND `URLLabel` = 'index'

SELECT * FROM `meta` LIMIT 1

SHOW COLUMNS FROM `meta`

UPDATE `meta` SET `ID` = 1, `Module` = 'pages', `Language` = 'bg', `ParentID` = '1', `PostDate` = '2023-11-20', `LastUpdate` = '2025-03-21 14:44:37', `UploadID` = '2127403418', `MetaTitle` = 'Хотел „Тропикана“ в Приморско', `MetaDescription` = 'Хотел „Тропикана“ в Приморско - насладете се на уют, комфорт и незабравими преживявания край морето.', `MetaImage` = '', `MetaKeywords` = '', `NoIndex` = 0, `URLLabel` = 'index', `NoCache` = 0, `Visible` = 1 WHERE `ID` = 1 AND `Module` = 'pages' AND `Language` = 'bg'

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

UPDATE `pages` SET `ID` = 1, `Language` = 'bg', `Action` = 'index', `Images` = '["primorsko-beach-mobile.jpg","primorsko-beach.jpg"]', `MenuLabel` = 'Начало', `FooterLabel` = 'Начало', `Title` = 'хотел ТРОПИКАНА', `Annotation` = 'в сърцето на град Приморско на лазурния бряг!', `Content` = '<section class="f2">
    <div>
        <h3>ЗА НАС</h3>
        <p> Хотел „Тропикана“ разполага с леглова база от 94 места.<br> Обслужването на рецепция е денонощно. </p>
        <ul>
            <li>Открит басейн с джакузи</li>
            <li>Шезлонги и чадъри</li>
            <li>Детски кът непосредствено до басейна</li>
            <li>Открит паркинг</li>
        </ul>
        <p> Настаняването е с включена богата и разнообразна закуска на блок маса (или сет меню в крилата на сезона, според заетостта).<br> Закуската се сервира на блок маса с топли (кафе, чай) и студени (мляко, сок, вода) напитки. </p>
    </div>
    <div> 
        <img src="/tropicana/img/home/hotel-tropicana-primorsko.jpg" alt="хотел тропикана приморско"> 
    </div>
</section> ', `Blocks` = 'accommodation/home', `AddOn` = '' WHERE `ID` = 1 AND `Language` = 'bg'
# [21-Mar-2025 14:44:37] /tropicana/www/tR7v2Spz9Wa/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 200876879 AND
                                CRC32(`UserKey`) = 3514158796 AND
                                RIGHT(`UserKey`, 1) = 9
                            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `pages`.`Action`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`pages`.`MenuLabel` <> '', `pages`.`MenuLabel`, `pages`.`FooterLabel`) AS `Label`,
                IF(`Parent`.`URLLabel` = 'index', `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `meta`.`Visible`
            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
                `pages`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
         ORDER BY `meta`.`PostDate` ASC
