SELECT DISTINCT `AA Rating`,`RAC Rating`,`photo`,TouristBoardRating,InternationalRating,EstablishmentName,`Rooms From`,hotel.`Hotel Id`,Latitude,Longitude,`Geo Town`,`Geo County`,`Description`,`LongDescription`,IF(hotel.`Hotel Id`<100000,(`Rooms From`*1.3),`Rooms From`) AS adjusted
   			FROM `hotel`	
			WHERE `Geo Region` LIKE '%Roscommon%' || `Geo County` = 'Roscommon'
			ORDER BY 'Rooms From'
			LIMIT 0,15