Rating
Josef Chromy Winery
Relbia TAS 7258
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=24095 or tblfeedback.strbusinessname='Josef Chromy Winery' or tblfeedback.strbusinessname='Josef Chromy Winery') 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
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
Quamby Estate
Hagley TAS 7292
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=24941 or tblfeedback.strbusinessname='Quamby Estate' or tblfeedback.strbusinessname='Quamby Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Elmslie Tasmania
Legana TAS 7277
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=27662 or tblfeedback.strbusinessname='Elmslie Tasmania' or tblfeedback.strbusinessname='Elmslie Tasmania') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Quamby Estate
Hagley TAS 7292
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=23467 or tblfeedback.strbusinessname='Quamby Estate' or tblfeedback.strbusinessname='Quamby Estate') 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
Cataract on Paterson
Launceston TAS 7250
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=22117 or tblfeedback.strbusinessname='Cataract on Paterson' or tblfeedback.strbusinessname='Cataract on Paterson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Aspect Tamar Valley Resort
Grindelwald TAS 7277
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=37778 or tblfeedback.strbusinessname='Aspect Tamar Valley Resort' or tblfeedback.strbusinessname='Aspect Tamar Valley Resort') 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
Stonefield
Brighton TAS 7030
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=3597 or tblfeedback.strbusinessname='Stonefield' or tblfeedback.strbusinessname='Stonefield') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tailrace Centre
Riverside TAS 7250
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=38205 or tblfeedback.strbusinessname='Tailrace Centre' or tblfeedback.strbusinessname='Tailrace Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tailrace Centre
Riverside TAS 7250
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=24124 or tblfeedback.strbusinessname='Tailrace Centre' or tblfeedback.strbusinessname='Tailrace Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tamar Valley Resort
Grindelwald TAS 7277
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=23977 or tblfeedback.strbusinessname='Tamar Valley Resort' or tblfeedback.strbusinessname='Tamar Valley Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Entally Lodge
Hadspen TAS 7290
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=24581 or tblfeedback.strbusinessname='Entally Lodge' or tblfeedback.strbusinessname='Entally Lodge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brickendon
Longford TAS 7301
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=3549 or tblfeedback.strbusinessname='Brickendon' or tblfeedback.strbusinessname='Brickendon') 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
Summerdale Community Centre
Summerdale TAS 7250
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=3599 or tblfeedback.strbusinessname='Summerdale Community Centre' or tblfeedback.strbusinessname='Summerdale Community Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mowbray The-Your Venue
Mowbray TAS 7248
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=5357 or tblfeedback.strbusinessname='Mowbray The-Your Venue' or tblfeedback.strbusinessname='Mowbray The-Your Venue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rostella Restaurant
Dilston TAS 7252
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=3587 or tblfeedback.strbusinessname='Rostella Restaurant' or tblfeedback.strbusinessname='Rostella Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hallam's Waterfront Licensed Restaurant
Launceston TAS 7250
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=3560 or tblfeedback.strbusinessname='Hallam'%%semi%%s Waterfront Licensed Restaurant' or tblfeedback.strbusinessname='Hallam's Waterfront Licensed Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Gorge Restaurant
Launceston TAS 7250
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=3534 or tblfeedback.strbusinessname='The Gorge Restaurant' or tblfeedback.strbusinessname='The Gorge Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Strathmore
Evandale TAS 7212
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=3598 or tblfeedback.strbusinessname='Strathmore' or tblfeedback.strbusinessname='Strathmore') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
No 10 Reception Centre
Invermay TAS 7248
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=5358 or tblfeedback.strbusinessname='No 10 Reception Centre' or tblfeedback.strbusinessname='No 10 Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sandors on the Park
Launceston TAS 7250
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=3591 or tblfeedback.strbusinessname='Sandors on the Park' or tblfeedback.strbusinessname='Sandors on the Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Grindelwald Resort
Grindelwald TAS 7277
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=3527 or tblfeedback.strbusinessname='Grindelwald Resort' or tblfeedback.strbusinessname='Grindelwald Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Edelweiss Restaurant
Grindelwald TAS 7277
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=5348 or tblfeedback.strbusinessname='Edelweiss Restaurant' or tblfeedback.strbusinessname='Edelweiss Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Northern Club Tavern The
Launceston TAS 7250
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=3531 or tblfeedback.strbusinessname='Northern Club Tavern The' or tblfeedback.strbusinessname='Northern Club Tavern The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mowbray, The-Your Venue
Mowbray TAS 7248
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=3575 or tblfeedback.strbusinessname='Mowbray, The-Your Venue' or tblfeedback.strbusinessname='Mowbray, The-Your Venue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The International Hotel
Launceston TAS 7250
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=19228 or tblfeedback.strbusinessname='The International Hotel' or tblfeedback.strbusinessname='The International Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Quigley's Balfour Terrace
Launceston TAS 7250
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=3584 or tblfeedback.strbusinessname='Quigley'%%semi%%s Balfour Terrace' or tblfeedback.strbusinessname='Quigley's Balfour Terrace') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Silk's Catering
Launceston TAS 7250
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=3533 or tblfeedback.strbusinessname='Silk'%%semi%%s Catering' or tblfeedback.strbusinessname='Silk's Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Happy Chef
Hagley TAS 7292
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=19227 or tblfeedback.strbusinessname='The Happy Chef' or tblfeedback.strbusinessname='The Happy Chef') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Mill
Carrick TAS 7291
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=3602 or tblfeedback.strbusinessname='The Mill' or tblfeedback.strbusinessname='The Mill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Western Video Pty Ltd
Norwood TAS 7250
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=5366 or tblfeedback.strbusinessname='Western Video Pty Ltd' or tblfeedback.strbusinessname='Western Video Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Colonial Motor Inn
Launceston TAS 7250
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=3526 or tblfeedback.strbusinessname='Colonial Motor Inn' or tblfeedback.strbusinessname='Colonial Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Burwood
Invermay TAS 7248
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=3550 or tblfeedback.strbusinessname='Burwood' or tblfeedback.strbusinessname='Burwood') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fresh on Charles
Launceston TAS 7250
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=56 or tblfeedback.strbusinessname='Fresh on Charles' or tblfeedback.strbusinessname='Fresh on Charles') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gorge Restaurant The
Launceston TAS 7250
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=5351 or tblfeedback.strbusinessname='Gorge Restaurant The' or tblfeedback.strbusinessname='Gorge Restaurant The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mill The
Carrick TAS 7291
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=5355 or tblfeedback.strbusinessname='Mill The' or tblfeedback.strbusinessname='Mill The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Carrick Inn
Carrick TAS 7291
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=3551 or tblfeedback.strbusinessname='Carrick Inn' or tblfeedback.strbusinessname='Carrick Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Archers' Manor
Alanvale TAS 7248
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=5346 or tblfeedback.strbusinessname='Archers'%%semi%% Manor' or tblfeedback.strbusinessname='Archers' Manor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Novotel Launceston
Launceston TAS 7250
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=3579 or tblfeedback.strbusinessname='Novotel Launceston' or tblfeedback.strbusinessname='Novotel Launceston') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Food for Thought
Launceston TAS 7250
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=3558 or tblfeedback.strbusinessname='Food for Thought' or tblfeedback.strbusinessname='Food for Thought') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Marion's Vineyard
Deviot TAS 7275
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=3571 or tblfeedback.strbusinessname='Marion'%%semi%%s Vineyard' or tblfeedback.strbusinessname='Marion's Vineyard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Matsons Function Centre
Launceston TAS 7250
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=3530 or tblfeedback.strbusinessname='Matsons Function Centre' or tblfeedback.strbusinessname='Matsons Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tamar River Cruises
Launceston TAS 7250
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=3600 or tblfeedback.strbusinessname='Tamar River Cruises' or tblfeedback.strbusinessname='Tamar River Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
St Matthias Vineyard
Rosevears TAS 7277
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=3596 or tblfeedback.strbusinessname='St Matthias Vineyard' or tblfeedback.strbusinessname='St Matthias Vineyard') 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
Burwood Reception Centre
Invermay TAS 7248
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=19055 or tblfeedback.strbusinessname='Burwood Reception Centre' or tblfeedback.strbusinessname='Burwood Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 57 Sort search results alphabetically