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
Saffire Freycinet
Coles Bay TAS 7215
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=41684 or tblfeedback.strbusinessname='Saffire Freycinet' or tblfeedback.strbusinessname='Saffire Freycinet') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Freycinet Lodge
Coles Bay TAS 7215
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=24577 or tblfeedback.strbusinessname='Freycinet Lodge' or tblfeedback.strbusinessname='Freycinet Lodge') 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
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
Apricus 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=42921 or tblfeedback.strbusinessname='Apricus Launceston' or tblfeedback.strbusinessname='Apricus Launceston') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Waterton Hall Wines
Rowella TAS 7270
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=42840 or tblfeedback.strbusinessname='Waterton Hall Wines' or tblfeedback.strbusinessname='Waterton Hall Wines') 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
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
Brickendon Estate
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 Estate' or tblfeedback.strbusinessname='Brickendon Estate') 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
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
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
Shaydanvale Gardens
North Motton 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=46702 or tblfeedback.strbusinessname='Shaydanvale Gardens' or tblfeedback.strbusinessname='Shaydanvale Gardens') 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
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
The Tramsheds
Launceston 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=22309 or tblfeedback.strbusinessname='The Tramsheds' or tblfeedback.strbusinessname='The Tramsheds') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bo & Barn
Jetsonville TAS 7260
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=46722 or tblfeedback.strbusinessname='Bo &%%semi%% Barn' or tblfeedback.strbusinessname='Bo & Barn') 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
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
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
Glendale Estate Vineyard
Sidmouth TAS 7270
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=42953 or tblfeedback.strbusinessname='Glendale Estate Vineyard' or tblfeedback.strbusinessname='Glendale Estate Vineyard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stonesthrow 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=41224 or tblfeedback.strbusinessname='Stonesthrow Launceston' or tblfeedback.strbusinessname='Stonesthrow Launceston') 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
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
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
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
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
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
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
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
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
Jessen Lodge
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=5354 or tblfeedback.strbusinessname='Jessen Lodge' or tblfeedback.strbusinessname='Jessen Lodge') 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
Rutherglen Holiday Village
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=3588 or tblfeedback.strbusinessname='Rutherglen Holiday Village' or tblfeedback.strbusinessname='Rutherglen Holiday Village') 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
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
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
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
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
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=3578 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
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
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
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
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
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
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
Pike's 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=3581 or tblfeedback.strbusinessname='Pike'%%semi%%s Restaurant' or tblfeedback.strbusinessname='Pike's Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Edelwiess 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=3557 or tblfeedback.strbusinessname='Edelwiess Restaurant' or tblfeedback.strbusinessname='Edelwiess Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 63 Sort search results alphabetically