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
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
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
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
Highfield Historic Site
Stanley TAS 7331
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=42842 or tblfeedback.strbusinessname='Highfield Historic Site' or tblfeedback.strbusinessname='Highfield Historic Site') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Don River Railway
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=44605 or tblfeedback.strbusinessname='Don River Railway' or tblfeedback.strbusinessname='Don River Railway') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Annsleighs Garden
Ridgley 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=43651 or tblfeedback.strbusinessname='Annsleighs Garden' or tblfeedback.strbusinessname='Annsleighs Garden') 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
Spreyton Cider Co
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=37720 or tblfeedback.strbusinessname='Spreyton Cider Co' or tblfeedback.strbusinessname='Spreyton Cider Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
Mount Gnomon Farm
Penguin TAS 7316
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=44719 or tblfeedback.strbusinessname='Mount Gnomon Farm' or tblfeedback.strbusinessname='Mount Gnomon Farm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Table House Farm
Table Cape TAS 7235
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=45887 or tblfeedback.strbusinessname='Table House Farm' or tblfeedback.strbusinessname='Table House Farm') 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
Emu Valley Rhododendron Garden
Romaine 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=22471 or tblfeedback.strbusinessname='Emu Valley Rhododendron Garden' or tblfeedback.strbusinessname='Emu Valley Rhododendron Garden') 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
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lemonthyme Wilderness Retreat
Moina 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=44633 or tblfeedback.strbusinessname='Lemonthyme Wilderness Retreat' or tblfeedback.strbusinessname='Lemonthyme Wilderness Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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