# [10-Sep-2024 09:44:53] /ski/www/ 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Country`,
                `Resort`
            FROM
                `destinations`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `offers`.`Gallery`,
                `meta`.`URLLabel`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Beds`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `offers`.`Annotation`
            FROM
                `offers`
                INNER JOIN `meta` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1 AND
                (`offers`.`StartFrom` IS NULL OR `offers`.`StartFrom` <= CURDATE()) AND
                (`offers`.`EndTo` IS NULL OR `offers`.`EndTo` >= CURDATE())
            
            GROUP BY
                `offers`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reviews' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `FullName`,
                `Review`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg' AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reviews' AND
	    		`meta`.`URLLabel` = 'отзиви'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'articles' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `articles`.`Image`,
                `meta`.`URLLabel`,
                `articles`.`Title`,
                `articles`.`Annotation`
            FROM
                `articles`
                INNER JOIN `meta` ON
                    `articles`.`ID` = `meta`.`ID` AND
                    `articles`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'articles'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `articles`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'articles' AND
	    		`meta`.`URLLabel` = 'блог'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                *
            FROM
                `partners`
            WHERE
                `Language` = 'bg'

         AND `Visible` = 1
            ORDER BY
                `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
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages') AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '')
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LContacts','Domain','FacebookURL','LFacebook','InstagramURL','LInstagram','Phone','EMail','LHome','LHowOffer','InfoNewsletter','SubscribeURL','LSubscribe','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Sep-2024 09:46:11] /ski/www/sKiEsnZ9sp2/bg/ajax/users/login.html?_=1725950770811 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'NzkzYjAzNGI1NTAwNmYyNjE4ZTE0YTgxNTRhMjY0MTIYjFhNTYxNzFmZThiOWY0YjI0NWU5MzU5Mzg0NTk5NTc%'
            LIMIT 1
# [10-Sep-2024 09:46:16] /ski/www/sKiEsnZ9sp2/ 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

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

SELECT
                `ID`,
                `Country`,
                `Resort`
            FROM
                `destinations`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers' AND
                `pages`.`Action` = 'index'
         LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `offers`.`Gallery`,
                `meta`.`URLLabel`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Beds`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `offers`.`Annotation`
            FROM
                `offers`
                INNER JOIN `meta` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
        
            GROUP BY
                `offers`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers' AND
	    		`meta`.`URLLabel` = 'оферти'
         LIMIT 1

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

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reviews' AND
                `pages`.`Action` = 'index'
         LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `FullName`,
                `Review`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg' AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reviews' AND
	    		`meta`.`URLLabel` = 'отзиви'
         LIMIT 1

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'articles' AND
                `pages`.`Action` = 'index'
         LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `articles`.`Image`,
                `meta`.`URLLabel`,
                `articles`.`Title`,
                `articles`.`Annotation`
            FROM
                `articles`
                INNER JOIN `meta` ON
                    `articles`.`ID` = `meta`.`ID` AND
                    `articles`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'articles'
            WHERE
                `meta`.`Language` = 'bg'
        
            GROUP BY
                `articles`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'articles' AND
	    		`meta`.`URLLabel` = 'блог'
         LIMIT 1

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

SELECT
                *
            FROM
                `partners`
            WHERE
                `Language` = 'bg'

        
            ORDER BY
                `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
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages') AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '')
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LContacts','Domain','FacebookURL','LFacebook','InstagramURL','LInstagram','Phone','EMail','LHome','LHowOffer','InfoNewsletter','SubscribeURL','LSubscribe','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Sep-2024 09:46:17] /ski/www/sKiEsnZ9sp2/bg/ajax/pages/admin/1.json?_=1725950777202 108.61.209.243

set names utf8
# [10-Sep-2024 09:46:17] /ski/www/sKiEsnZ9sp2/bg/ajax/pages/admin/8.json?_=1725950777203 108.61.209.243

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            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`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages')
            LIMIT 1

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            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`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `meta`.`ID` = 8 AND
                `meta`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages')
            LIMIT 1
# [10-Sep-2024 09:46:17] /ski/www/sKiEsnZ9sp2/bg/ajax/reviews/admin/4.json?_=1725950777203 108.61.209.243
# [10-Sep-2024 09:46:17] /ski/www/sKiEsnZ9sp2/bg/ajax/reviews/admin/3.json?_=1725950777203 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [10-Sep-2024 09:46:17] /ski/www/sKiEsnZ9sp2/bg/ajax/reviews/admin/2.json?_=1725950777204 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `ID` = 3 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `ID` = 4 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Sep-2024 09:46:17] /ski/www/sKiEsnZ9sp2/bg/ajax/reviews/admin/1.json?_=1725950777204 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Sep-2024 09:46:17] /ski/www/sKiEsnZ9sp2/bg/ajax/pages/admin/7.json?_=1725950777204 108.61.209.243
# [10-Sep-2024 09:46:17] /ski/www/sKiEsnZ9sp2/bg/ajax/partners/admin/1.json?_=1725950777205 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            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`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `meta`.`ID` = 7 AND
                `meta`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages')
            LIMIT 1
# [10-Sep-2024 09:46:17] /ski/www/sKiEsnZ9sp2/bg/ajax/partners/admin/2.json?_=1725950777205 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `partners`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `partners`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Sep-2024 09:46:22] /ski/www/sKiEsnZ9sp2/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            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')
         ORDER BY `meta`.`PostDate` ASC
# [10-Sep-2024 09:46:46] /ski/www/sKiEsnZ9sp2/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            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')
         ORDER BY `meta`.`PostDate` ASC
# [10-Sep-2024 09:46:48] /ski/www/sKiEsnZ9sp2/bg/ajax/pages/form/1.html?_=1725950808537 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `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`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages')
            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` <> ''
# [10-Sep-2024 09:48:03] /ski/www/sKiEsnZ9sp2/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            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')
         ORDER BY `meta`.`PostDate` ASC
# [10-Sep-2024 09:48:04] /ski/www/sKiEsnZ9sp2/bg/ajax/pages/form/1.html?_=1725950884618 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `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`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages')
            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` <> ''
# [10-Sep-2024 09:48:13] /ski/www/sKiEsnZ9sp2/bg/ajax/pages/form/3.html?_=1725950892873 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `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` = 3 AND
                `meta`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages')
            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` <> ''
# [10-Sep-2024 09:48:18] /ski/www/sKiEsnZ9sp2/bg/ajax/pages/form/5.html?_=1725950897912 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `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` = 5 AND
                `meta`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages')
            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` <> ''
# [10-Sep-2024 09:48:25] /ski/www/sKiEsnZ9sp2/bg/offers/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC) AS CountTable
# [10-Sep-2024 09:48:28] /ski/www/sKiEsnZ9sp2/bg/ajax/meta/visible/offers/1001.html?_=1725950908443 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

UPDATE
                    `meta`
                SET
                    `Visible` = IF(`Visible` = 1, 0, 1)
                WHERE
                    `ID` = '1001' AND `Module` = 'offers' AND `Language` = 'bg'
                LIMIT 1

SELECT
                    `Visible`
                FROM
                    `meta`
                WHERE
                    `ID` = '1001' AND `Module` = 'offers' AND `Language` = 'bg'
                LIMIT 1
# [10-Sep-2024 09:48:30] /ski/www/sKiEsnZ9sp2/bg/offers/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC) AS CountTable
# [10-Sep-2024 09:48:34] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/form/1001.html?_=1725950914387 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1001 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers'
            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` = 'offers' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''
# [10-Sep-2024 09:48:38] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/update/1001.html?_=1725950917935 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT * FROM `meta` LIMIT 1

SHOW COLUMNS FROM `meta`

UPDATE `meta` SET `ID` = '1001', `Module` = 'offers', `Language` = 'bg', `ParentID` = '8', `PostDate` = '2024-08-19', `LastUpdate` = '2024-09-10 09:48:38', `UploadID` = '4071094787', `MetaTitle` = 'Мета заглавие тест нев', `MetaDescription` = 'Мета описание', `MetaImage` = 'france.png', `NoIndex` = 0, `URLLabel` = 'france-tighes', `NoCache` = 0, `Visible` = 1 WHERE `ID` = '1001' AND `Module` = 'offers' AND `Language` = 'bg'

SELECT * FROM `offers` LIMIT 1

SHOW COLUMNS FROM `offers`

UPDATE `offers` SET `ID` = '1001', `Language` = 'bg', `StartFrom` = '2024-08-05', `EndTo` = '2024-08-31', `DateFrom` = '2024-08-05', `DateTo` = '2024-08-31', `Currency` = 'EUR', `Flag` = '', `Country` = 'France', `BookURL` = 'https://maxgraphic.bg', `Beds` = '5', `Facilities` = 'breakfast,parking,wifi,swimingpool', `Nights` = '7', `Price` = '1200.00', `Resort` = 'Tignes', `Annotation` = NULL, `Gallery` = '["restaurants-aria-d.jpg","house.jpg","bmw-i4.jpg"]', `Content` = '
                            <p>
                                Chalet Morgane се намира в очарователния курорт La Tania, който се
                                намира между Мерибел и Куршевел като част от обширната ски зона 3
                                Vallées. Самoто шале е разположено само на 200 метра от пистата и
                                лифта. Центърът е само на пет минути пеша, където ще откриете
                                ресторанти, магазини и няколко клуба.
                            </p>
                            Шалето разполага с:
                            <ul>
                                <li>външно джакузи</li>
                                <li>камина</li>
                                <li>безплатен WI-FI</li>
                                <li>6 спални /всяка със собствена баня/, разположени на 2 етажа.</li>
                            </ul>
                            На приземния етаж има:
                            <ul>
                                <li>всекидневна и трапезария с кът за сядане</li>
                                <li>телевизор</li>
                                <li>печка на дърва</li>
                                <li>напълно оборудвана кухня</li>
                                <li>външно джакузи</li>
                                <li>спалня с 2 единични легла (80 х 190 см) и самостоятелна баня.</li>
                                <li>ски стая с електрическа сушилня за ски обувки.</li>
                            </ul>
                            Първият етаж разполага с:
                            <ul>
                                <li>4 двойни спални (80 x 190 см) и двойна спалня (140 x 190 см), всяка със самостоятелна баня.</li>
                            </ul>', `Offer` = '
                            <p>
                                Chalet Morgane се намира в очарователния курорт La Tania, който се
                                намира между Мерибел и Куршевел като част от обширната ски зона 3
                                Vallées. Самoто шале е разположено само на 200 метра от пистата и
                                лифта. Центърът е само на пет минути пеша, където ще откриете
                                ресторанти, магазини и няколко клуба.
                            </p>
                            Шалето разполага с:
                            <ul>
                                <li>външно джакузи</li>
                                <li>камина</li>
                                <li>безплатен WI-FI</li>
                                <li>6 спални /всяка със собствена баня/, разположени на 2 етажа.</li>
                            </ul>
                            На приземния етаж има:
                            <ul>
                                <li>всекидневна и трапезария с кът за сядане</li>
                                <li>телевизор</li>
                                <li>печка на дърва</li>
                                <li>напълно оборудвана кухня</li>
                                <li>външно джакузи</li>
                                <li>спалня с 2 единични легла (80 х 190 см) и самостоятелна баня.</li>
                                <li>ски стая с електрическа сушилня за ски обувки.</li>
                            </ul>
                            Първият етаж разполага с:
                            <ul>
                                <li>4 двойни спални (80 x 190 см) и двойна спалня (140 x 190 см), всяка със самостоятелна баня.</li>
                            </ul>' WHERE `ID` = '1001' AND `Language` = 'bg'
# [10-Sep-2024 09:48:38] /ski/www/sKiEsnZ9sp2/bg/offers/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC) AS CountTable
# [10-Sep-2024 09:48:43] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/form/1001.html?_=1725950923649 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1001 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers'
            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` = 'offers' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''
# [10-Sep-2024 09:48:57] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/update/1001.html?_=1725950937524 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT * FROM `meta` LIMIT 1

SHOW COLUMNS FROM `meta`

UPDATE `meta` SET `ID` = '1001', `Module` = 'offers', `Language` = 'bg', `ParentID` = '8', `PostDate` = '2024-08-19', `LastUpdate` = '2024-09-10 09:48:57', `UploadID` = '4071094787', `MetaTitle` = 'Мета заглавие тест нев', `MetaDescription` = 'Мета описание', `MetaImage` = 'france.png', `NoIndex` = 0, `URLLabel` = 'france-tighes', `NoCache` = 0, `Visible` = 1 WHERE `ID` = '1001' AND `Module` = 'offers' AND `Language` = 'bg'

SELECT * FROM `offers` LIMIT 1

SHOW COLUMNS FROM `offers`

UPDATE `offers` SET `ID` = '1001', `Language` = 'bg', `StartFrom` = '2024-08-05', `EndTo` = '2024-10-31', `DateFrom` = '2024-08-05', `DateTo` = '2024-10-31', `Currency` = 'EUR', `Flag` = '', `Country` = 'France', `BookURL` = 'https://maxgraphic.bg', `Beds` = '5', `Facilities` = 'breakfast,parking,wifi,swimingpool', `Nights` = '7', `Price` = '1200.00', `Resort` = 'Tignes', `Annotation` = NULL, `Gallery` = '["restaurants-aria-d.jpg","house.jpg","bmw-i4.jpg"]', `Content` = '
                            <p>
                                Chalet Morgane се намира в очарователния курорт La Tania, който се
                                намира между Мерибел и Куршевел като част от обширната ски зона 3
                                Vallées. Самoто шале е разположено само на 200 метра от пистата и
                                лифта. Центърът е само на пет минути пеша, където ще откриете
                                ресторанти, магазини и няколко клуба.
                            </p>
                            Шалето разполага с:
                            <ul>
                                <li>външно джакузи</li>
                                <li>камина</li>
                                <li>безплатен WI-FI</li>
                                <li>6 спални /всяка със собствена баня/, разположени на 2 етажа.</li>
                            </ul>
                            На приземния етаж има:
                            <ul>
                                <li>всекидневна и трапезария с кът за сядане</li>
                                <li>телевизор</li>
                                <li>печка на дърва</li>
                                <li>напълно оборудвана кухня</li>
                                <li>външно джакузи</li>
                                <li>спалня с 2 единични легла (80 х 190 см) и самостоятелна баня.</li>
                                <li>ски стая с електрическа сушилня за ски обувки.</li>
                            </ul>
                            Първият етаж разполага с:
                            <ul>
                                <li>4 двойни спални (80 x 190 см) и двойна спалня (140 x 190 см), всяка със самостоятелна баня.</li>
                            </ul>', `Offer` = '
                            <p>
                                Chalet Morgane се намира в очарователния курорт La Tania, който се
                                намира между Мерибел и Куршевел като част от обширната ски зона 3
                                Vallées. Самoто шале е разположено само на 200 метра от пистата и
                                лифта. Центърът е само на пет минути пеша, където ще откриете
                                ресторанти, магазини и няколко клуба.
                            </p>
                            Шалето разполага с:
                            <ul>
                                <li>външно джакузи</li>
                                <li>камина</li>
                                <li>безплатен WI-FI</li>
                                <li>6 спални /всяка със собствена баня/, разположени на 2 етажа.</li>
                            </ul>
                            На приземния етаж има:
                            <ul>
                                <li>всекидневна и трапезария с кът за сядане</li>
                                <li>телевизор</li>
                                <li>печка на дърва</li>
                                <li>напълно оборудвана кухня</li>
                                <li>външно джакузи</li>
                                <li>спалня с 2 единични легла (80 х 190 см) и самостоятелна баня.</li>
                                <li>ски стая с електрическа сушилня за ски обувки.</li>
                            </ul>
                            Първият етаж разполага с:
                            <ul>
                                <li>4 двойни спални (80 x 190 см) и двойна спалня (140 x 190 см), всяка със самостоятелна баня.</li>
                            </ul>' WHERE `ID` = '1001' AND `Language` = 'bg'
# [10-Sep-2024 09:48:57] /ski/www/sKiEsnZ9sp2/bg/offers/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC) AS CountTable
# [10-Sep-2024 09:48:59] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/form/1001.html?_=1725950939474 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                *
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language`
            WHERE
                `meta`.`ID` = 1001 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers'
            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` = 'offers' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`ParentID` = 1 AND
                `pages`.`MenuLabel` <> ''
# [10-Sep-2024 09:49:31] /ski/www/sKiEsnZ9sp2/bg/ajax/offers/update/1001.html?_=1725950970930 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT * FROM `meta` LIMIT 1

SHOW COLUMNS FROM `meta`

UPDATE `meta` SET `ID` = '1001', `Module` = 'offers', `Language` = 'bg', `ParentID` = '8', `PostDate` = '2024-08-19', `LastUpdate` = '2024-09-10 09:49:31', `UploadID` = '4071094787', `MetaTitle` = 'Мета заглавие тест нев', `MetaDescription` = 'Мета описание', `MetaImage` = 'france.png', `NoIndex` = 0, `URLLabel` = 'france-tighes', `NoCache` = 0, `Visible` = 1 WHERE `ID` = '1001' AND `Module` = 'offers' AND `Language` = 'bg'

SELECT * FROM `offers` LIMIT 1

SHOW COLUMNS FROM `offers`

UPDATE `offers` SET `ID` = '1001', `Language` = 'bg', `StartFrom` = '2024-08-05', `EndTo` = '2024-10-31', `DateFrom` = '2024-08-05', `DateTo` = '2024-10-31', `Currency` = 'EUR', `Flag` = '', `Country` = 'France', `BookURL` = 'https://maxgraphic.bg', `Beds` = '5', `Facilities` = 'breakfast,parking,wifi,swimingpool', `Nights` = '7', `Price` = '1200.00', `Resort` = 'Tignes', `Annotation` = NULL, `Gallery` = '["restaurants-aria-d.jpg","house.jpg","bmw-i4.jpg"]', `Content` = '
                            <p>
                                Chalet Morgane се намира в очарователния курорт La Tania, който се
                                намира между Мерибел и Куршевел като част от обширната ски зона 3
                                Vallées. Самoто шале е разположено само на 200 метра от пистата и
                                лифта. Центърът е само на пет минути пеша, където ще откриете
                                ресторанти, магазини и няколко клуба.
                            </p>
                            Шалето разполага с:
                            <ul>
                                <li>външно джакузи</li>
                                <li>камина</li>
                                <li>безплатен WI-FI</li>
                                <li>6 спални /всяка със собствена баня/, разположени на 2 етажа.</li>
                            </ul>
                            На приземния етаж има:
                            <ul>
                                <li>всекидневна и трапезария с кът за сядане</li>
                                <li>телевизор</li>
                                <li>печка на дърва</li>
                                <li>напълно оборудвана кухня</li>
                                <li>външно джакузи</li>
                                <li>спалня с 2 единични легла (80 х 190 см) и самостоятелна баня.</li>
                                <li>ски стая с електрическа сушилня за ски обувки.</li>
                            </ul>
                            Първият етаж разполага с:
                            <ul>
                                <li>4 двойни спални (80 x 190 см) и двойна спалня (140 x 190 см), всяка със самостоятелна баня.</li>
                            </ul>', `Offer` = '
                            <p>
                                Chalet Morgane се намира в очарователния курорт La Tania, който се
                                намира между Мерибел и Куршевел като част от обширната ски зона 3
                                Vallées. Самoто шале е разположено само на 200 метра от пистата и
                                лифта. Центърът е само на пет минути пеша, където ще откриете
                                ресторанти, магазини и няколко клуба.
                            </p>
                            Шалето разполага с:
                            <ul>
                                <li>външно джакузи</li>
                                <li>камина</li>
                                <li>безплатен WI-FI</li>
                                <li>6 спални /всяка със собствена баня/, разположени на 2 етажа.</li>
                            </ul>
                            На приземния етаж има:
                            <ul>
                                <li>всекидневна и трапезария с кът за сядане</li>
                                <li>телевизор</li>
                                <li>печка на дърва</li>
                                <li>напълно оборудвана кухня</li>
                                <li>външно джакузи</li>
                                <li>спалня с 2 единични легла (80 х 190 см) и самостоятелна баня.</li>
                                <li>ски стая с електрическа сушилня за ски обувки.</li>
                            </ul>
                            Първият етаж разполага с:
                            <ul>
                                <li>4 двойни спални (80 x 190 см) и двойна спалня (140 x 190 см), всяка със самостоятелна баня.</li>
                            </ul>' WHERE `ID` = '1001' AND `Language` = 'bg'
# [10-Sep-2024 09:49:31] /ski/www/sKiEsnZ9sp2/bg/offers/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC LIMIT 0, 100

SELECT COUNT(*) AS NumRows FROM (
            SELECT
                `meta`.`ID`,
                `meta`.`Language`,
                `meta`.`Module`,
                `meta`.`PostDate`,
                `meta`.`LastUpdate`,
                IF(`Parent`.`URLLabel` IS NULL, `meta`.`URLLabel`, CONCAT(`Parent`.`URLLabel`, '/', `meta`.`URLLabel`)) AS `URLLabel`,
                `offers`.`StartFrom`,
                `offers`.`EndTo`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `meta`.`Visible`
            FROM
                `meta`
                INNER JOIN `offers` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         ORDER BY `meta`.`PostDate` DESC) AS CountTable
# [10-Sep-2024 09:49:41] /ski/www/sKiEsnZ9sp2/bg/ajax/users/logout.html?_=1725950981087 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 1 AND
                                CRC32(`UserKey`) = 1449405464 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [10-Sep-2024 09:49:41] /ski/www/ 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Country`,
                `Resort`
            FROM
                `destinations`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `offers`.`Gallery`,
                `meta`.`URLLabel`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Beds`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `offers`.`Annotation`
            FROM
                `offers`
                INNER JOIN `meta` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1 AND
                (`offers`.`StartFrom` IS NULL OR `offers`.`StartFrom` <= CURDATE()) AND
                (`offers`.`EndTo` IS NULL OR `offers`.`EndTo` >= CURDATE())
            
            GROUP BY
                `offers`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers' AND
	    		`meta`.`URLLabel` = 'оферти'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reviews' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `FullName`,
                `Review`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg' AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reviews' AND
	    		`meta`.`URLLabel` = 'отзиви'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'articles' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `articles`.`Image`,
                `meta`.`URLLabel`,
                `articles`.`Title`,
                `articles`.`Annotation`
            FROM
                `articles`
                INNER JOIN `meta` ON
                    `articles`.`ID` = `meta`.`ID` AND
                    `articles`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'articles'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `articles`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'articles' AND
	    		`meta`.`URLLabel` = 'блог'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                *
            FROM
                `partners`
            WHERE
                `Language` = 'bg'

         AND `Visible` = 1
            ORDER BY
                `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
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages') AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '')
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LContacts','Domain','FacebookURL','LFacebook','InstagramURL','LInstagram','Phone','EMail','LHome','LHowOffer','InfoNewsletter','SubscribeURL','LSubscribe','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Sep-2024 09:49:43] /ski/www/bg/оферти/france-tighes.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` = 'оферти'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                *
	        FROM
	        	`offers`
                INNER JOIN `meta` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
	    	WHERE
	    		`meta`.`URLLabel` = 'france-tighes'
         AND
                `meta`.`Visible` = 1  AND
                (`offers`.`StartFrom` IS NULL OR `offers`.`StartFrom` <= CURDATE()) AND
                (`offers`.`EndTo` IS NULL OR `offers`.`EndTo` >= CURDATE())
            
            GROUP BY
                `offers`.`ID`
            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` = 'offers' AND
                P1.`Language` = 'bg' AND
                P1.`URLLabel` = 'оферти' AND
                P1.`Visible` = 1

SELECT
                `meta`.`UploadID`,
                `pages`.`Images`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `pages`.`Images` <> '' AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers' AND
	    		`meta`.`URLLabel` = 'оферти'
         AND `meta`.`Visible` = 1 LIMIT 1

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

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

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `offers`.`Gallery`,
                `meta`.`URLLabel`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Beds`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `offers`.`Annotation`
            FROM
                `offers`
                INNER JOIN `meta` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         AND `meta`.`ID` != 1001 AND
                `meta`.`Visible` = 1 AND
                (`offers`.`StartFrom` IS NULL OR `offers`.`StartFrom` <= CURDATE()) AND
                (`offers`.`EndTo` IS NULL OR `offers`.`EndTo` >= CURDATE())
            
            GROUP BY
                `offers`.`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
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages') AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '')
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LContacts','Domain','FacebookURL','LFacebook','InstagramURL','LInstagram','Phone','EMail','LHome','LHowOffer','InfoNewsletter','SubscribeURL','LSubscribe','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Sep-2024 09:49:45] /ski/www/bg/ajax/offers/gallery/1001.html?_=1725950985281 108.61.209.243

set names utf8

SELECT
                `meta`.`UploadID`,
                `offers`.`Gallery`
	        FROM
	        	`offers`
                INNER JOIN `meta` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
	    	WHERE
	    		`offers`.`ID` = 1001
         AND
                `meta`.`Visible` = 1  AND
                (`offers`.`StartFrom` IS NULL OR `offers`.`StartFrom` <= CURDATE()) AND
                (`offers`.`EndTo` IS NULL OR `offers`.`EndTo` >= CURDATE())
            
            GROUP BY
                `offers`.`ID`
            LIMIT 1
# [10-Sep-2024 09:50:09] /ski/www/ 108.61.209.243

set names utf8

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

SELECT
                `ID`,
                `Country`,
                `Resort`
            FROM
                `destinations`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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

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

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `offers`.`Gallery`,
                `meta`.`URLLabel`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Beds`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `offers`.`Annotation`
            FROM
                `offers`
                INNER JOIN `meta` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1 AND
                (`offers`.`StartFrom` IS NULL OR `offers`.`StartFrom` <= CURDATE()) AND
                (`offers`.`EndTo` IS NULL OR `offers`.`EndTo` >= CURDATE())
            
            GROUP BY
                `offers`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers' AND
	    		`meta`.`URLLabel` = 'оферти'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reviews' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `FullName`,
                `Review`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg' AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reviews' AND
	    		`meta`.`URLLabel` = 'отзиви'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'articles' AND
                `pages`.`Action` = 'index'
         AND `meta`.`Visible` = 1 LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `articles`.`Image`,
                `meta`.`URLLabel`,
                `articles`.`Title`,
                `articles`.`Annotation`
            FROM
                `articles`
                INNER JOIN `meta` ON
                    `articles`.`ID` = `meta`.`ID` AND
                    `articles`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'articles'
            WHERE
                `meta`.`Language` = 'bg'
         AND
                `meta`.`Visible` = 1
            
            GROUP BY
                `articles`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'articles' AND
	    		`meta`.`URLLabel` = 'блог'
         AND `meta`.`Visible` = 1 LIMIT 1

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

SELECT
                *
            FROM
                `partners`
            WHERE
                `Language` = 'bg'

         AND `Visible` = 1
            ORDER BY
                `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
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages') AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '')
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LContacts','Domain','FacebookURL','LFacebook','InstagramURL','LInstagram','Phone','EMail','LHome','LHowOffer','InfoNewsletter','SubscribeURL','LSubscribe','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Sep-2024 10:06:55] /ski/www/sKiEsnZ9sp2/bg/ajax/users/login.html?_=1725952015754 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'MDdiMjRmNjFlZDU5NjQwOTJlMzM4ZmYzZTliNTZjY2QYzFiNTQ4ZWQyZjdlNTg4NzFkN2ZhM2M1MmMyZmY5M2M%'
            LIMIT 1
# [10-Sep-2024 10:07:09] /ski/www/sKiEsnZ9sp2/bg/ajax/users/login.html?_=1725952028970 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'MDdiMjRmNjFlZDU5NjQwOTJlMzM4ZmYzZTliNTZjY2QYzFiNTQ4ZWQyZjdlNTg4NzFkN2ZhM2M1MmMyZmY5M2M%'
            LIMIT 1
# [10-Sep-2024 10:07:22] /ski/www/sKiEsnZ9sp2/ 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

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

SELECT
                `ID`,
                `Country`,
                `Resort`
            FROM
                `destinations`
            WHERE
                `Language` = 'bg' AND
                `Visible` = 1
            ORDER BY `PostDate` ASC

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
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers' AND
                `pages`.`Action` = 'index'
         LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `offers`.`Gallery`,
                `meta`.`URLLabel`,
                `offers`.`DateFrom`,
                `offers`.`DateTo`,
                `offers`.`Beds`,
                `offers`.`Country`,
                `offers`.`Resort`,
                `offers`.`Annotation`
            FROM
                `offers`
                INNER JOIN `meta` ON
                    `offers`.`ID` = `meta`.`ID` AND
                    `offers`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'offers'
            WHERE
                `meta`.`Language` = 'bg'
        
            GROUP BY
                `offers`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'offers' AND
	    		`meta`.`URLLabel` = 'оферти'
         LIMIT 1

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

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reviews' AND
                `pages`.`Action` = 'index'
         LIMIT 1

SELECT
                `ID`,
                `UploadID`,
                `Image`,
                `FullName`,
                `Review`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `Language` = 'bg' AND
                `Image` != '' AND
                `Visible` = 1
            ORDER BY `PostDate` DESC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'reviews' AND
	    		`meta`.`URLLabel` = 'отзиви'
         LIMIT 1

SELECT
                `meta`.`URLLabel`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`ParentID` < 2 AND
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'articles' AND
                `pages`.`Action` = 'index'
         LIMIT 1

SELECT
                `meta`.`ID`,
                `meta`.`PostDate`,
                `meta`.`UploadID`,
                `articles`.`Image`,
                `meta`.`URLLabel`,
                `articles`.`Title`,
                `articles`.`Annotation`
            FROM
                `articles`
                INNER JOIN `meta` ON
                    `articles`.`ID` = `meta`.`ID` AND
                    `articles`.`Language` = `meta`.`Language` AND
                    `meta`.`Module` = 'articles'
            WHERE
                `meta`.`Language` = 'bg'
        
            GROUP BY
                `articles`.`ID`
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `pages`.`ID`,
                `pages`.`Annotation`
	        FROM
	        	`meta`
                INNER JOIN `pages` ON
                    `pages`.`ID` = `meta`.`ID` AND
                    `pages`.`Language` = `meta`.`Language`
	    	WHERE
                `meta`.`Language` = 'bg' AND
                `meta`.`Module` = 'articles' AND
	    		`meta`.`URLLabel` = 'блог'
         LIMIT 1

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

SELECT
                *
            FROM
                `partners`
            WHERE
                `Language` = 'bg'

        
            ORDER BY
                `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
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages') AND
                (`pages`.`MenuLabel` <> '' OR `pages`.`FooterLabel` <> '')
            ORDER BY
                `meta`.`PostDate` ASC

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LContacts','Domain','FacebookURL','LFacebook','InstagramURL','LInstagram','Phone','EMail','LHome','LHowOffer','InfoNewsletter','SubscribeURL','LSubscribe','Copyright') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Sep-2024 10:07:23] /ski/www/sKiEsnZ9sp2/bg/ajax/pages/admin/1.json?_=1725952042869 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            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`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `meta`.`ID` = 1 AND
                `meta`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages')
            LIMIT 1
# [10-Sep-2024 10:07:23] /ski/www/sKiEsnZ9sp2/bg/ajax/pages/admin/8.json?_=1725952042871 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            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`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `meta`.`ID` = 8 AND
                `meta`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages')
            LIMIT 1
# [10-Sep-2024 10:07:23] /ski/www/sKiEsnZ9sp2/bg/ajax/reviews/admin/4.json?_=1725952042872 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `ID` = 4 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Sep-2024 10:07:23] /ski/www/sKiEsnZ9sp2/bg/ajax/reviews/admin/3.json?_=1725952042873 108.61.209.243
# [10-Sep-2024 10:07:23] /ski/www/sKiEsnZ9sp2/bg/ajax/reviews/admin/2.json?_=1725952042875 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1
# [10-Sep-2024 10:07:23] /ski/www/sKiEsnZ9sp2/bg/ajax/reviews/admin/1.json?_=1725952042876 108.61.209.243

set names utf8

set names utf8

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `ID` = 3 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `reviews`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Sep-2024 10:07:23] /ski/www/sKiEsnZ9sp2/bg/ajax/pages/admin/7.json?_=1725952042877 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            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`
                LEFT JOIN `meta` AS `Parent` ON
                    `meta`.`ParentID` = `Parent`.`ID` AND
                    `meta`.`Language` = `Parent`.`Language`
            WHERE
                `meta`.`ID` = 7 AND
                `meta`.`Language` = 'bg' AND
                (`meta`.`Module` = 'pages' OR `Parent`.`Module` = 'pages')
            LIMIT 1
# [10-Sep-2024 10:07:23] /ski/www/sKiEsnZ9sp2/bg/ajax/partners/admin/1.json?_=1725952042877 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `partners`
            WHERE
                `ID` = 1 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Sep-2024 10:07:23] /ski/www/sKiEsnZ9sp2/bg/ajax/partners/admin/2.json?_=1725952042879 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            LIMIT 1

SELECT
                `ID`,
                `Language`,
                `Visible`
            FROM
                `partners`
            WHERE
                `ID` = 2 AND
                `Language` = 'bg'
            LIMIT 1
# [10-Sep-2024 10:07:27] /ski/www/sKiEsnZ9sp2/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            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')
         ORDER BY `meta`.`PostDate` ASC
# [10-Sep-2024 10:09:20] /ski/www/bg/ajax/requests/form.html?_=1725952160288 108.61.209.243

set names utf8

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

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('ErrorWeek','ErrorBeds','ErrorResort','ErrorAccommodation','ErrorNames','ErrorPhone','ErrorEMail','ErrorIAgree') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [10-Sep-2024 12:28:19] /ski/www/sKiEsnZ9sp2/bg/ajax/users/login.html?_=1725960499275 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'NzNmYWNlMWIyNzU5MmE5M2FiMzg5M2M0ZDI4M2ZiMjkYzFiNTQ4ZWQyZjdlNTg4NzFkN2ZhM2M1MmMyZmY5M2M%'
            LIMIT 1
# [10-Sep-2024 12:28:30] /ski/www/sKiEsnZ9sp2/bg/ajax/users/login.html?_=1725960510252 108.61.209.243

set names utf8

SELECT
                `ID`,
                CRC32(`UserKey`) AS `User`,
                RIGHT(`UserKey`, 1) AS `Access`
            FROM
                `users`
            WHERE
                `UserKey` LIKE 'MDdiMjRmNjFlZDU5NjQwOTJlMzM4ZmYzZTliNTZjY2QYzFiNTQ4ZWQyZjdlNTg4NzFkN2ZhM2M1MmMyZmY5M2M%'
            LIMIT 1
# [10-Sep-2024 12:28:30] /ski/www/sKiEsnZ9sp2/bg/pages/list.html 108.61.209.243

set names utf8

SELECT
                                `ID`
                            FROM
                                `users`
                            WHERE
                                `ID` = 2 AND
                                CRC32(`UserKey`) = 849692055 AND
                                RIGHT(`UserKey`, 1) = 2
                            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')
         ORDER BY `meta`.`PostDate` ASC
