Logo

Look & Book

Find your perfect hotel

  • from
  • Search by region Click here to enlarge map
  • Nominate a hotel

Thank you to our sponsors

... ... ...
WINNER SELECT * FROM ( SELECT * FROM v2_Hotels LEFT JOIN v2_Winners ON ( hotel_id = winner_hotel AND winner_year = 2020 ) LEFT JOIN v2_Images ON hotel_id = img_hotel WHERE hotel_member = 'Yes' ORDER BY FIELD(winner_category, 'Scottish Hotel of the Year') DESC, FIELD(winner_awarded,'Scottish Hotel of the Year','National Winner','Regional Winner','Class Winner') ASC, hotel_name ASC, img_sort ASC ) as xxx WHERE winner_year = 2020 AND ( winner_awarded = 'National Winner' OR winner_awarded = 'Scottish Hotel of the Year' ) GROUP BY hotel_id ORDER BY FIELD(winner_category, 'Scottish Hotel of the Year') DESC, winner_category ASC, hotel_name ASC
ORTHER

...

...