# [24-Mar-2025 10:53: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
# [24-Mar-2025 10:53:37] /tropicana/www/en/ 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` = 'en' AND
                `meta`.`Module` = 'pages' AND
	    		`meta`.`URLLabel` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

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` = 'en' 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` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 10:53:43] /tropicana/www/en/ 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` = 'en' AND
                `meta`.`Module` = 'pages' AND
	    		`meta`.`URLLabel` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

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` = 'en' 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` = 'en'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 10:53:45] /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
# [24-Mar-2025 10:54:00] /tropicana/www/bg/galeria.html 108.61.209.243

set names utf8

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

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'gallery' AND
	    		`meta`.`URLLabel` = 'galeria'
         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` = 'gallery' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'galeria' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Images`,
                `MenuLabel`,
                `Title`
            FROM
                `gallery`
            WHERE
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` DESC

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
# [24-Mar-2025 10:54:08] /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
# [24-Mar-2025 11:52:21] /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
# [24-Mar-2025 11:52: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
# [24-Mar-2025 11:52:35] /tropicana/www/bg/ajax/users/form/login.html?_=1742809955458 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
# [24-Mar-2025 11:55:53] /tropicana/www/bg/ajax/users/form/login.html?_=1742810153217 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
# [24-Mar-2025 12:00:53] /tropicana/www/tR7v2Spz9Wa/bg/ajax/users/login.html?_=1742810453393 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
# [24-Mar-2025 12:00:53] /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
# [24-Mar-2025 12:01:14] /tropicana/www/tR7v2Spz9Wa/bg/index.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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 12:02:40] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742810560988 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 12:02:42] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10003.json?_=1742810562182 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 12:04:26] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/form/pages/1.html?_=1742810666916 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`
# [24-Mar-2025 12:08:57] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/update/1.html?_=1742810937100 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-24 12:08:57', `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>На 350 м. от оживения център</li>
            <li>На около 400 м. от южния център</li>
            <li>Открит паркинг</li><li>Панорамен изглед към морето</li>
        </ul>
        <p>Всички помещения в Хотел „Тропикана“ са климатизирани, с прилежащи тераси, разполагат със собствен санитарен възел (повечето с душ-кабини). Помещенията са оборудвани с хладилник, електрическа кана, климатик, телевизор.&nbsp;</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'
# [24-Mar-2025 12:08:57] /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
# [24-Mar-2025 12:08:59] /tropicana/www/tR7v2Spz9Wa/bg/index.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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 12:08:59] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742810940037 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 12:09:27] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10002.json?_=1742810967789 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 12:10:10] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10003.json?_=1742811010621 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 12:10:51] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/form/pages/1.html?_=1742811051391 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`
# [24-Mar-2025 12:11:16] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/update/1.html?_=1742811076286 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-24 12:11:16', `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>На 350 м. от оживения център</li>
            <li>На около 400 м. от южния център</li><li>Панорамен изглед към морето</li>
        </ul>
        <p>Всички помещения в Хотел „Тропикана“ са климатизирани, с прилежащи тераси, разполагат със собствен санитарен възел (повечето с душ-кабини). Помещенията са оборудвани с хладилник, електрическа кана, климатик, телевизор.&nbsp;</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'
# [24-Mar-2025 12:11:16] /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
# [24-Mar-2025 12:11:31] /tropicana/www/tR7v2Spz9Wa/bg/index.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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 12:11:34] /tropicana/www/tR7v2Spz9Wa/bg/nastaniavane.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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'nastaniavane'
         LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'accommodation' AND
	    		`meta`.`URLLabel` = 'nastaniavane'
         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` = 'accommodation' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'nastaniavane' AND
                P1.`Visible` = 1

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

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'
        
            GROUP BY
                `accommodation`.`ID`
            ORDER BY
                `meta`.`PostDate` 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
                `pages`.`Language` = 'bg' AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '') AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages' OR `meta`.`Module` = `Parent`.`Module`)
        
            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
# [24-Mar-2025 12:11:34] /tropicana/www/tR7v2Spz9Wa/bg/index.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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 12:11:35] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742811095567 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 12:11:36] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10003.json?_=1742811096415 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 12:11:42] /tropicana/www/tR7v2Spz9Wa/bg/index.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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 12:11:43] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742811103534 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 12:11:44] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10003.json?_=1742811104649 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 12:11:50] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/form.html?_=1742811110582 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`.`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`
# [24-Mar-2025 12:13:24] /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
# [24-Mar-2025 12:13:30] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/form/accommodation/200.html?_=1742811210354 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` = 200 AND
                `meta`.`Module` = 'accommodation' 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`
# [24-Mar-2025 12:16:34] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/upload/2811110491.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
# [24-Mar-2025 12:16:38] /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
# [24-Mar-2025 12:16:39] /tropicana/www/bg/index.html 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
# [24-Mar-2025 12:16:40] /tropicana/www/bg/nastaniavane.html 108.61.209.243

set names utf8

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

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'accommodation' AND
	    		`meta`.`URLLabel` = 'nastaniavane'
         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` = 'accommodation' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'nastaniavane' AND
                P1.`Visible` = 1

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

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

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
# [24-Mar-2025 12:16:41] /tropicana/www/bg/galeria.html 108.61.209.243

set names utf8

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

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'gallery' AND
	    		`meta`.`URLLabel` = 'galeria'
         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` = 'gallery' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'galeria' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Images`,
                `MenuLabel`,
                `Title`
            FROM
                `gallery`
            WHERE
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` DESC

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
# [24-Mar-2025 12:16:46] /tropicana/www/bg/rezervacia.html 108.61.209.243

set names utf8

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

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reservations' AND
	    		`meta`.`URLLabel` = 'rezervacia'
         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` = 'reservations' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'rezervacia' AND
                P1.`Visible` = 1

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
# [24-Mar-2025 12:16:46] /tropicana/www/bg/ajax/reservations/form.html?_=1742811406767 108.61.209.243

set names utf8

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFullName','LPhone','LEMail','LAccommodation','LStayDates','LAdultsNum','LChildrenNum','LChildrenAge','InfoChildrenAge','LAdditionalRequests','InfoAdditionalRequests','LSendRequest') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorNumber','ErrorName','ErrorPhone','ErrorEMail','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC

SELECT
                `accommodation`.`Title`
            FROM
                `accommodation`
                INNER JOIN `meta` ON
                    `accommodation`.`ID` = `meta`.`ID` AND
                    `accommodation`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'accommodation'
                WHERE
                    `meta`.`Visible` = 1
                ORDER BY
                    `meta`.`PostDate` ASC

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` = 'terms' AND
                `pages`.`Action` = 'privacy'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [24-Mar-2025 12:16:50] /tropicana/www/bg/galeria.html 108.61.209.243

set names utf8

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

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'gallery' AND
	    		`meta`.`URLLabel` = 'galeria'
         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` = 'gallery' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'galeria' AND
                P1.`Visible` = 1

SELECT
                `ID`,
                `UploadID`,
                `Images`,
                `MenuLabel`,
                `Title`
            FROM
                `gallery`
            WHERE
                `Language` = 'bg' AND
                `Images` != ''
         AND `Visible` = 1
            ORDER BY
                `PostDate` DESC

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
# [24-Mar-2025 12:18:29] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=0LfQsC3QvdCw0YE&_=1742811509961 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 12:19:39] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/insert.html?_=1742811579659 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 MAX(`ID`) + 1 FROM `meta` WHERE `Module` = 'pages'

SELECT IF(COUNT(`ID`) > 0, TRUE, FALSE) FROM `meta` WHERE `ID` <> 2 AND `Module` = 'pages' AND `URLLabel` = 'za-nas'

SELECT * FROM `meta` LIMIT 1

SHOW COLUMNS FROM `meta`

INSERT INTO `meta` SET `ID` = 2, `Module` = 'pages', `Language` = 'bg', `ParentID` = '1', `PostDate` = '2025-03-24', `LastUpdate` = '2025-03-24 12:19:39', `UploadID` = '2811110491', `MetaTitle` = 'За нас хотел „Тропикана“ в Приморско', `MetaDescription` = 'Стъпил на дюните на северния плаж в Приморско Хотел „Тропикана“  е с отлично местоположение, до пясъчната плажна ивица,  на 350м от оживения център и на около 400м от южния плаж но града. В близост до супермаркет и ресторанти.', `MetaImage` = '', `MetaKeywords` = '', `NoIndex` = 0, `URLLabel` = 'za-nas', `NoCache` = 0, `Visible` = 1

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

INSERT INTO `pages` SET `ID` = 2, `Language` = 'bg', `Action` = 'index', `Images` = '["16170153543695-1.jpg"]', `MenuLabel` = 'За нас', `FooterLabel` = 'За нас', `Title` = 'За нас', `Annotation` = 'Отдайте се на безценно безвремие на морския бряг!', `Content` = '<div><h3>ЗА НАС:&nbsp;</h3></div><div>Хотел „Тропикана“ разполага с леглова база от 94 места.&nbsp;</div><div>Обслужването на рецепция е денонощно.&nbsp;</div><div>Настаняването е с включена богата и разнообразна закуска на блок маса (или сет меню в крилата на сезона, според заетостта).&nbsp;</div><div>Хотелът предлага на своите гости открит басейн с джакузи, шезлонги и чадъри.</div><div>На разположение на гостите е малък детски кът непосредствено до басейна.&nbsp;&nbsp;</div><div>Всички стаи са светли и просторни, с хубави тераси около 4кв.м. Четвърти и пети етаж разполагат с големи панорамни тераси към всяка стая, с площ от 10кв.м. до 40кв.м., на които има шезлонги.&nbsp;</div><div>Хотелът предлага двойни, тройни и четворни стаи със стандартни размери на всички легла за оптимален комфорт на нашите гости.</div><div>Всички стаи в хотела разполагат със собствен санитарен възел (повечето с душ-кабини). Помещенията са оборудвани с хладилник, електрическа кана, климатик, телевизор.</div><div>Освен редовните легла, има възможност за поставяне на допълнително легло и/или детска сгъваема кошара.&nbsp;</div><div>Закуската се сервира на блок маса с топли (кафе, чай) и студени (мляко, сок, вода) напитки.</div><div><br></div>', `Blocks` = '', `AddOn` = ''
# [24-Mar-2025 12:19:44] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/insert.html?_=1742811584346 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 MAX(`ID`) + 1 FROM `meta` WHERE `Module` = 'pages'

SELECT IF(COUNT(`ID`) > 0, TRUE, FALSE) FROM `meta` WHERE `ID` <> 3 AND `Module` = 'pages' AND `URLLabel` = 'za-nas'
# [24-Mar-2025 12:19:44] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742811584538 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 12:19:46] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742811586603 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 12:19:50] /tropicana/www/tR7v2Spz9Wa/bg/index.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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 12:19:56] /tropicana/www/tR7v2Spz9Wa/bg/index.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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 12:19:57] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742811597910 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 12:19:59] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10003.json?_=1742811599394 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 12:20:00] /tropicana/www/tR7v2Spz9Wa/bg/index.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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 12:20:01] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742811601416 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 12:20:01] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10003.json?_=1742811601465 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 12:20:02] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10002.json?_=1742811602177 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 12:20:05] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742811605603 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 12:20:20] /tropicana/www/tR7v2Spz9Wa/bg/za-nas.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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'za-nas'
         LIMIT 1

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` = 'za-nas'
         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` = 'za-nas' AND
                P1.`Visible` = 1

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`)
        
            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
# [24-Mar-2025 12:20:31] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/2.json?_=1742811631939 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 12:20:42] /tropicana/www/tR7v2Spz9Wa/bg/usloviya-na-sayta.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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'usloviya-na-sayta'
         LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
	    		`meta`.`URLLabel` = 'usloviya-na-sayta'
         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` = 'terms' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'usloviya-na-sayta' AND
                P1.`Visible` = 1

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`)
        
            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
# [24-Mar-2025 12:20:43] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/terms/3.json?_=1742811643231 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 3 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms'
            LIMIT 1
# [24-Mar-2025 12:20:44] /tropicana/www/tR7v2Spz9Wa/bg/politika-za-biskvitki.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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'politika-za-biskvitki'
         LIMIT 1

SELECT
                *
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms' AND
	    		`meta`.`URLLabel` = 'politika-za-biskvitki'
         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` = 'terms' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'politika-za-biskvitki' AND
                P1.`Visible` = 1

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`)
        
            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
# [24-Mar-2025 12:20:44] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/terms/4.json?_=1742811644430 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 4 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'terms'
            LIMIT 1
# [24-Mar-2025 12:20:48] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742811648340 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 12:20:56] /tropicana/www/tR7v2Spz9Wa/bg/za-nas.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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'za-nas'
         LIMIT 1

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` = 'za-nas'
         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` = 'za-nas' AND
                P1.`Visible` = 1

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`)
        
            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
# [24-Mar-2025 12:20:57] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/2.json?_=1742811657124 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 12:21:02] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/form/terms/2.html?_=1742811662460 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` = 2 AND
                `meta`.`Module` = 'terms' 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`
# [24-Mar-2025 12:21:04] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/terms/2.json?URLLabel=cG9saXRpa2EtemEtcG92ZXJpdGVsbm9zdA&_=1742811664469 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'politika-za-poveritelnost'  AND `ID` != '2' AND `Module` = 'terms' AND `Language` = 'bg'
# [24-Mar-2025 12:21:24] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFzLXphLW5hcw&_=1742811684965 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas-za-nas'
# [24-Mar-2025 12:21:24] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/insert.html?_=1742811685045 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 MAX(`ID`) + 1 FROM `meta` WHERE `Module` = 'pages'

SELECT IF(COUNT(`ID`) > 0, TRUE, FALSE) FROM `meta` WHERE `ID` <> 3 AND `Module` = 'pages' AND `URLLabel` = 'za-nas-za-nas'

SELECT * FROM `meta` LIMIT 1

SHOW COLUMNS FROM `meta`

INSERT INTO `meta` SET `ID` = 3, `Module` = 'pages', `Language` = 'bg', `ParentID` = '1', `PostDate` = '2025-03-24', `LastUpdate` = '2025-03-24 12:21:24', `UploadID` = '2811110491', `MetaTitle` = 'За нас хотел „Тропикана“ в Приморско', `MetaDescription` = 'Стъпил на дюните на северния плаж в Приморско Хотел „Тропикана“  е с отлично местоположение, до пясъчната плажна ивица,  на 350м от оживения център и на около 400м от южния плаж но града. В близост до супермаркет и ресторанти.', `MetaImage` = '', `MetaKeywords` = '', `NoIndex` = 0, `URLLabel` = 'za-nas-za-nas', `NoCache` = 0, `Visible` = 1

SELECT * FROM `pages` LIMIT 1

SHOW COLUMNS FROM `pages`

INSERT INTO `pages` SET `ID` = 3, `Language` = 'bg', `Action` = 'index', `Images` = '["16170153543695-1.jpg"]', `MenuLabel` = 'За нас', `FooterLabel` = 'За нас', `Title` = 'За нас', `Annotation` = 'Отдайте се на безценно безвремие на морския бряг!', `Content` = '<div><h3>ЗА НАС:&nbsp;</h3></div><div>Хотел „Тропикана“ разполага с леглова база от 94 места.&nbsp;</div><div>Обслужването на рецепция е денонощно.&nbsp;</div><div>Настаняването е с включена богата и разнообразна закуска на блок маса (или сет меню в крилата на сезона, според заетостта).&nbsp;</div><div>Хотелът предлага на своите гости открит басейн с джакузи, шезлонги и чадъри.</div><div>На разположение на гостите е малък детски кът непосредствено до басейна.&nbsp;&nbsp;</div><div>Всички стаи са светли и просторни, с хубави тераси около 4кв.м. Четвърти и пети етаж разполагат с големи панорамни тераси към всяка стая, с площ от 10кв.м. до 40кв.м., на които има шезлонги.&nbsp;</div><div>Хотелът предлага двойни, тройни и четворни стаи със стандартни размери на всички легла за оптимален комфорт на нашите гости.</div><div>Всички стаи в хотела разполагат със собствен санитарен възел (повечето с душ-кабини). Помещенията са оборудвани с хладилник, електрическа кана, климатик, телевизор.</div><div>Освен редовните легла, има възможност за поставяне на допълнително легло и/или детска сгъваема кошара.&nbsp;</div><div>Закуската се сервира на блок маса с топли (кафе, чай) и студени (мляко, сок, вода) напитки.</div><div><br></div>', `Blocks` = '', `AddOn` = ''
# [24-Mar-2025 12:21:29] /tropicana/www/tR7v2Spz9Wa/bg/za-nas.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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'za-nas'
         LIMIT 1

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` = 'za-nas'
         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` = 'za-nas' AND
                P1.`Visible` = 1

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`)
        
            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
# [24-Mar-2025 12:21:32] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/insert.html?_=1742811692637 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 MAX(`ID`) + 1 FROM `meta` WHERE `Module` = 'pages'

SELECT IF(COUNT(`ID`) > 0, TRUE, FALSE) FROM `meta` WHERE `ID` <> 4 AND `Module` = 'pages' AND `URLLabel` = 'za-nas-za-nas'
# [24-Mar-2025 12:21:38] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFzLXphLW5hcw&_=1742811698637 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas-za-nas'
# [24-Mar-2025 12:21:38] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/insert.html?_=1742811698725 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 MAX(`ID`) + 1 FROM `meta` WHERE `Module` = 'pages'

SELECT IF(COUNT(`ID`) > 0, TRUE, FALSE) FROM `meta` WHERE `ID` <> 4 AND `Module` = 'pages' AND `URLLabel` = 'za-nas-za-nas'
# [24-Mar-2025 12:21:51] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFzLXphLW5hcw&_=1742811711461 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas-za-nas'
# [24-Mar-2025 12:21:52] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/2.json?_=1742811712221 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 12:27:46] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742812066078 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 12:27:46] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/insert.html?_=1742812066166 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 MAX(`ID`) + 1 FROM `meta` WHERE `Module` = 'pages'

SELECT IF(COUNT(`ID`) > 0, TRUE, FALSE) FROM `meta` WHERE `ID` <> 4 AND `Module` = 'pages' AND `URLLabel` = 'za-nas'
# [24-Mar-2025 12:27:48] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742812068766 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 12:27:54] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/terms/2.json?URLLabel=cG9saXRpa2EtemEtcG92ZXJpdGVsbm9zdA&_=1742812074407 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'politika-za-poveritelnost'  AND `ID` != '2' AND `Module` = 'terms' AND `Language` = 'bg'
# [24-Mar-2025 12:28:01] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/terms/2.json?URLLabel=cG9saXRpa2EtemEtcG92ZXJpdGVsbm9zdA&_=1742812081911 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'politika-za-poveritelnost'  AND `ID` != '2' AND `Module` = 'terms' AND `Language` = 'bg'
# [24-Mar-2025 12:28:03] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742812083270 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 12:59:48] /tropicana/www/tR7v2Spz9Wa/ 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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 12:59:49] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742813990117 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 13:07:00] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10002.json?_=1742814420614 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 13:07:03] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/terms/2.json?URLLabel=cG9saXRpa2EtemEtcG92ZXJpdGVsbm9zdA&_=1742814423447 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'politika-za-poveritelnost'  AND `ID` != '2' AND `Module` = 'terms' AND `Language` = 'bg'
# [24-Mar-2025 13:07:07] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814427943 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:08] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814429119 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:09] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814429280 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:10] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814430528 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:12] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814432600 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:13] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814433999 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:16] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814436616 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:16] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814436768 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:18] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814438304 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:20] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814440512 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:21] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814441752 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:22] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814443005 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:23] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814443344 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:23] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814443864 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:24] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814444144 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:24] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814444512 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:24] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742814445081 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 13:07:27] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/terms/2.json?URLLabel=cG9saXRpa2EtemEtcG92ZXJpdGVsbm9zdA&_=1742814447744 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'politika-za-poveritelnost'  AND `ID` != '2' AND `Module` = 'terms' AND `Language` = 'bg'
# [24-Mar-2025 13:07:33] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/form/pages/1.html?_=1742814453336 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`
# [24-Mar-2025 13:48:42] /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
# [24-Mar-2025 13:54:39] /tropicana/www/tR7v2Spz9Wa/ 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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 13:54:40] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742817280860 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 13:56:54] /tropicana/www/tR7v2Spz9Wa/ 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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 13:56:55] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742817415992 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 13:57:19] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742817439265 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 14:29:57] /tropicana/www/tR7v2Spz9Wa/ 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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 14:29:57] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10002.json?_=1742819398120 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 14:29:58] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742819398580 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 14:30:10] /tropicana/www/tR7v2Spz9Wa/ 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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 14:30:11] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742819411374 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 15:02:49] /tropicana/www/tR7v2Spz9Wa/ 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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 15:02:50] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742821370409 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 15:02:51] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742821372095 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 15:04:03] /tropicana/www/tR7v2Spz9Wa/ 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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 15:04:04] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742821445041 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 15:04:06] /tropicana/www/tR7v2Spz9Wa/ 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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 15:04:08] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742821448985 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 15:07:04] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742821625102 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 15:07:10] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/form/terms/2.html?_=1742821630557 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` = 2 AND
                `meta`.`Module` = 'terms' 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`
# [24-Mar-2025 15:07:13] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/terms/2.json?URLLabel=cG9saXRpa2EtemEtcG92ZXJpdGVsbm9zdA&_=1742821633550 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'politika-za-poveritelnost'  AND `ID` != '2' AND `Module` = 'terms' AND `Language` = 'bg'
# [24-Mar-2025 15:07:14] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10003.json?_=1742821634581 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 15:07:16] /tropicana/www/tR7v2Spz9Wa/bg/ajax/products/admin/10004.json?_=1742821636461 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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'products'
         LIMIT 1
# [24-Mar-2025 15:07:19] /tropicana/www/tR7v2Spz9Wa/bg/za-nas.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`.`Module`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
	    		`meta`.`URLLabel` = 'za-nas'
         LIMIT 1

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` = 'za-nas'
         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` = 'za-nas' AND
                P1.`Visible` = 1

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`)
        
            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
# [24-Mar-2025 15:07:20] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/2.json?_=1742821640493 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 15:09:24] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742821764889 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 15:09:31] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742821772088 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 15:09:31] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/insert.html?_=1742821772178 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 MAX(`ID`) + 1 FROM `meta` WHERE `Module` = 'pages'

SELECT IF(COUNT(`ID`) > 0, TRUE, FALSE) FROM `meta` WHERE `ID` <> 4 AND `Module` = 'pages' AND `URLLabel` = 'za-nas'
# [24-Mar-2025 15:09:33] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742821774161 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 15:09:35] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742821776041 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 15:09:36] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742821777113 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 15:09:47] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFzLXphLW5hcw&_=1742821788009 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas-za-nas'
# [24-Mar-2025 15:09:47] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/insert.html?_=1742821788081 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 MAX(`ID`) + 1 FROM `meta` WHERE `Module` = 'pages'

SELECT IF(COUNT(`ID`) > 0, TRUE, FALSE) FROM `meta` WHERE `ID` <> 4 AND `Module` = 'pages' AND `URLLabel` = 'za-nas-za-nas'
# [24-Mar-2025 15:09:56] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742821796385 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 15:09:57] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742821797417 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 15:10:12] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742821813130 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 15:10:15] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/terms/2.json?URLLabel=cG9saXRpa2EtemEtcG92ZXJpdGVsbm9zdA&_=1742821815746 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'politika-za-poveritelnost'  AND `ID` != '2' AND `Module` = 'terms' AND `Language` = 'bg'
# [24-Mar-2025 15:10:20] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/terms/2.json?URLLabel=cG9saXRpa2EtemEtcG92ZXJpdGVsbm9zdA&_=1742821820594 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'politika-za-poveritelnost'  AND `ID` != '2' AND `Module` = 'terms' AND `Language` = 'bg'
# [24-Mar-2025 15:10:50] /tropicana/www/tR7v2Spz9Wa/ 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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 15:10:53] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742821853435 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 15:11:11] /tropicana/www/tR7v2Spz9Wa/bg/index.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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 15:11:11] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742821871827 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 15:12:18] /tropicana/www/tR7v2Spz9Wa/ 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
                *
	        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'
         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'
         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'
        
            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`)
        
            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
# [24-Mar-2025 15:13:12] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742821992887 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 15:13:13] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/admin/1.json?_=1742821993634 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`.`Module`,
                `meta`.`Language`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'pages'
            LIMIT 1
# [24-Mar-2025 15:18:45] /tropicana/www/tR7v2Spz9Wa/bg/ajax/meta/pages.json?URLLabel=emEtbmFz&_=1742822325463 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
                        COUNT(*)
                    FROM
                        `meta`
                    WHERE
                        `URLLabel` = 'za-nas'
# [24-Mar-2025 17:09:24] /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
# [24-Mar-2025 17:09:33] /tropicana/www/tR7v2Spz9Wa/bg/ajax/pages/form.html?_=1742828975093 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`.`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`
