SELECT DISTINCT `AA Rating`,`RAC Rating`,TouristBoardRating,EstablishmentName,`Rooms From`,`Hotel Id`,Latitude,Longitude,`Address1`,`Geo Town`,`Geo County`,`DescriptionEn` AS Description ,`LongDescriptionEn` AS LongDescription,`Visa`,`Switch`,`American Express`,`Diners Card`,IF(hotel.`Hotel Id`>1000000,(`Rooms From`*1.3),`Rooms From`) AS adjusted, `External Image URL`
   			FROM `hotel`	
			WHERE (`Geo County` = 'Gwynedd') AND `DescriptionEn` != ""			
			ORDER BY 'adjusted'
			LIMIT 0,5