Rating
Marquee Hire Wynyard
Wynyard TAS 7325
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27967 or tblfeedback.strbusinessname='Marquee Hire Wynyard' or tblfeedback.strbusinessname='Marquee Hire Wynyard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hawley House
Hawley Beach TAS 7307
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3561 or tblfeedback.strbusinessname='Hawley House' or tblfeedback.strbusinessname='Hawley House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pier01 Ulverstone
Ulverstone TAS 7315
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=22323 or tblfeedback.strbusinessname='Pier01 Ulverstone' or tblfeedback.strbusinessname='Pier01 Ulverstone') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tall Timbers
Smithton TAS 7330
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27593 or tblfeedback.strbusinessname='Tall Timbers' or tblfeedback.strbusinessname='Tall Timbers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rocky Cape Tavern
Rocky Cape TAS 7321
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27754 or tblfeedback.strbusinessname='Rocky Cape Tavern' or tblfeedback.strbusinessname='Rocky Cape Tavern') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pier01
Ulverstone TAS 7315
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25016 or tblfeedback.strbusinessname='Pier01' or tblfeedback.strbusinessname='Pier01') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sandridge Estate
Boat Harbour TAS 7321
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=26130 or tblfeedback.strbusinessname='Sandridge Estate' or tblfeedback.strbusinessname='Sandridge Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ulverstone Surf Life Saving Club
Ulverstone TAS 7315
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=27506 or tblfeedback.strbusinessname='Ulverstone Surf Life Saving Club' or tblfeedback.strbusinessname='Ulverstone Surf Life Saving Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Argosy Motor Inn
Devonport TAS 7310
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=25763 or tblfeedback.strbusinessname='The Argosy Motor Inn' or tblfeedback.strbusinessname='The Argosy Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bass & Flinders Restaurant
Ulverstone TAS 7315
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=5347 or tblfeedback.strbusinessname='Bass &%%semi%% Flinders Restaurant' or tblfeedback.strbusinessname='Bass & Flinders Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shearwater Country Club
Shearwater TAS 7307
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3593 or tblfeedback.strbusinessname='Shearwater Country Club' or tblfeedback.strbusinessname='Shearwater Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Voyager Motor Inn
Burnie TAS 7320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3608 or tblfeedback.strbusinessname='Voyager Motor Inn' or tblfeedback.strbusinessname='Voyager Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
KG's
Ulverstone TAS 7315
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3568 or tblfeedback.strbusinessname='KG'%%semi%%s' or tblfeedback.strbusinessname='KG's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Spreyton Park Function Centre
Spreyton TAS 7310
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3595 or tblfeedback.strbusinessname='Spreyton Park Function Centre' or tblfeedback.strbusinessname='Spreyton Park Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jessen Lodge
Longford TAS 7310
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3529 or tblfeedback.strbusinessname='Jessen Lodge' or tblfeedback.strbusinessname='Jessen Lodge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Beachfront Voyager Motor Inn
Burnie TAS 7320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3547 or tblfeedback.strbusinessname='Beachfront Voyager Motor Inn' or tblfeedback.strbusinessname='Beachfront Voyager Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ulverstone Rowing Club
Ulverstone TAS 7315
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3606 or tblfeedback.strbusinessname='Ulverstone Rowing Club' or tblfeedback.strbusinessname='Ulverstone Rowing Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Waterfront Motor Inn The
Wynyard TAS 7325
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=5364 or tblfeedback.strbusinessname='Waterfront Motor Inn The' or tblfeedback.strbusinessname='Waterfront Motor Inn The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tooska Restaurant
Devonport TAS 7310
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3604 or tblfeedback.strbusinessname='Tooska Restaurant' or tblfeedback.strbusinessname='Tooska Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Autographs on the Beach
Devonport TAS 7310
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3543 or tblfeedback.strbusinessname='Autographs on the Beach' or tblfeedback.strbusinessname='Autographs on the Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Weindorfers Greg Food & Real Coffee
Gowrie Park TAS 7306
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3764 or tblfeedback.strbusinessname='Weindorfers Greg Food &%%semi%% Real Coffee' or tblfeedback.strbusinessname='Weindorfers Greg Food & Real Coffee') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cheers Function Centre
Devonport TAS 7310
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3525 or tblfeedback.strbusinessname='Cheers Function Centre' or tblfeedback.strbusinessname='Cheers Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Serena Lodge
Stowport TAS 7321
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3592 or tblfeedback.strbusinessname='Serena Lodge' or tblfeedback.strbusinessname='Serena Lodge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Weller's Inn
Burnie TAS 7320
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3765 or tblfeedback.strbusinessname='Weller'%%semi%%s Inn' or tblfeedback.strbusinessname='Weller's Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goodstone Entertainment Group
Ulverstone TAS 7315
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=5350 or tblfeedback.strbusinessname='Goodstone Entertainment Group' or tblfeedback.strbusinessname='Goodstone Entertainment Group') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Accents
Devonport TAS 7310
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=5345 or tblfeedback.strbusinessname='Accents' or tblfeedback.strbusinessname='Accents') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Waterfront Motor Inn
Wynyard TAS 7325
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3603 or tblfeedback.strbusinessname='The Waterfront Motor Inn' or tblfeedback.strbusinessname='The Waterfront Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Avondale Cottage
Boat Harbour TAS 7321
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3544 or tblfeedback.strbusinessname='Avondale Cottage' or tblfeedback.strbusinessname='Avondale Cottage') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tooska Theatre Restaurant
Devonport TAS 7310
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=5363 or tblfeedback.strbusinessname='Tooska Theatre Restaurant' or tblfeedback.strbusinessname='Tooska Theatre Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Yolla Tavern
Yolla TAS 7325
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3769 or tblfeedback.strbusinessname='Yolla Tavern' or tblfeedback.strbusinessname='Yolla Tavern') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15