Logo

Look & Book

Find your perfect hotel

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

Our sponsors

Xpressjobs is designed to bring all the UK’s leading hospitality, hotel and leisure employer vacancies under one roof, providing job seekers and employers with the most effective recruitment platform in the UK hospitality, hotel and leisure sector. Integrated with one of the UK’s leading in-house recruitment management platforms, Recruit Genie, and a network of other leading recruitment sites, Xpressjobs.co.uk features vacancies direct from most of the UK’s leading hotel and leisure employers. You can search and apply direct for the very latest and best hotel jobs, restaurant jobs, leisure jobs and bar jobs, both permanent and temporary, at every level, as soon as they are posted.

WINNER SELECT * FROM ( SELECT * FROM v2_Hotels LEFT JOIN v2_Winners ON ( hotel_id = winner_hotel AND winner_year = 2019 ) 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 = 2019 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