# [23-Apr-2025 09:35:46] /bros/www/ 108.61.209.243

set names utf8

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

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

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

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

SELECT
                `bros_properties`.`propertyid`,
                `bros_properties`.`rating`,
                `bros_properties`.`name`,
                `bros_properties`.`image`,
                CONCAT_WS(', ', `bros_locations`.`name`, `bros_locations`.`region`, `bros_locations`.`country`) AS `Location`,
                `bros_property_description`.`Description`
            FROM
                `bros_properties`
                INNER JOIN `bros_locations` ON
                    `bros_properties`.`locationid` = `bros_locations`.`locationid`
                LEFT JOIN `bros_property_description` ON
                    `bros_properties`.`propertyid` = `bros_property_description`.`PropertyID` AND
                    `bros_property_description`.`Language` = 'bg'
            WHERE
                `bros_properties`.`propertyid` IN ('3','4','5')

SELECT
                `Label`,
                `Value`
            FROM
                `labels`
            WHERE
                `Label` IN ('LFeatured') AND
                `Language` = 'bg'
             ORDER BY
                `labels`.`Label` ASC
# [23-Apr-2025 09:35:55] /bros/www/ 108.61.209.243

set names utf8

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

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

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

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

SELECT
                `bros_properties`.`propertyid`,
                `bros_properties`.`rating`,
                `bros_properties`.`name`,
                `bros_properties`.`image`,
                CONCAT_WS(', ', `bros_locations`.`name`, `bros_locations`.`region`, `bros_locations`.`country`) AS `Location`,
                `bros_property_description`.`Description`
            FROM
                `bros_properties`
                INNER JOIN `bros_locations` ON
                    `bros_properties`.`locationid` = `bros_locations`.`locationid`
                LEFT JOIN `bros_property_description` ON
                    `bros_properties`.`propertyid` = `bros_property_description`.`PropertyID` AND
                    `bros_property_description`.`Language` = 'bg'
            WHERE
                `bros_properties`.`propertyid` IN ('3','4','5')

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