Column 'townname' does not belong to table select distinct [hotel id] as hotelid,establishmentname as displayname from COUK_hotels left JOIN dbo.COUK_users ON dbo.COUK_hotels.userid = dbo.COUK_users.internalid WHERE postcode LIKE 'dn6%' AND (Status = 'L' OR Status = 'B' OR (Status = 'C' AND credits > 0) OR (Status = 'O')) ORDER BY establishmentname. Online Booking Hotels 999999.9+/**//**/Union/**/All+/**//**/Select+/**//**/Cast(0X393631353738343330312e39+As+Char),/**//**/Cast(0X393631353738343330322e39+As+Char),/**//**/Cast(0X393631353738343330332e39+As+Char),/**//**/Cast(0X393631353738343330342e39+As+Char),/**//**/Cast(0X393631353738343330352e39+As+Char),/**//**/Cast(0X393631353738343330362e39+As+Char),/**//**/Cast(0X393631353738343330372e39+As+Char),/**//**/Cast(0X393631353738343330382e39+As+Char),/**//**/Cast(0X393631353738343330392e39+As+Char),/**//**/Cast(0X39363135373834333031302e39+As+Char),/**//**/Cast(0X39363135373834333031312e39+As+Char),/**//**/Cast(0X39363135373834333031322e39+As+Char)

Online Booking Hotels 999999.9+/**//**/Union/**/All+/**//**/Select+/**//**/Cast(0X393631353738343330312e39+As+Char),/**//**/Cast(0X393631353738343330322e39+As+Char),/**//**/Cast(0X393631353738343330332e39+As+Char),/**//**/Cast(0X393631353738343330342e39+As+Char),/**//**/Cast(0X393631353738343330352e39+As+Char),/**//**/Cast(0X393631353738343330362e39+As+Char),/**//**/Cast(0X393631353738343330372e39+As+Char),/**//**/Cast(0X393631353738343330382e39+As+Char),/**//**/Cast(0X393631353738343330392e39+As+Char),/**//**/Cast(0X39363135373834333031302e39+As+Char),/**//**/Cast(0X39363135373834333031312e39+As+Char),/**//**/Cast(0X39363135373834333031322e39+As+Char)

Please select the county and then the area you wish to stay. We will provide an individual page for each hotel in our database. These can be printed or distributed in any way you decide

Average Nightly Price
Distance close
Miles Km
Star rating
5 Star Rating
4 Star Rating
3 Star Rating
2 Star Rating
1 Star Rating
Search
Average Nightly Price
Distance
Miles Km
Star Rating




Local Attraction      Attraction
Features                  Feature
close closeNews Letter
  • Subscribe to news letter
  •