SELECT DISTINCT `AA Rating`,`RAC Rating`,TouristBoardRating,FrenchRating,EstablishmentName,`Rooms From`,hotel.`Hotel Id`,Latitude,Longitude,`Address1`,`Geo Town`,`Geo County`,`Geo Borough`,`DescriptionEn` AS Description ,`LongDescriptionEn` AS LongDescription,`Visa`,`Switch`,`American Express`,`Diners Card`
			FROM `hotel`, `specials` 	
			WHERE (`Geo County` LIKE '%Gwent and Glamorgan%' OR `Geo Town` LIKE '%Gwent and Glamorgan%') AND hotel.`Hotel Id` = specials.`Hotel Id` &&  `Start Date` < CURDATE() && `End Date` > CURDATE()
			ORDER BY 'Rooms From'
			LIMIT 0,15