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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Rosevears Estate Wines Pty Ltd
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=3586 or tblfeedback.strbusinessname='Rosevears Estate Wines Pty Ltd' or tblfeedback.strbusinessname='Rosevears Estate Wines 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
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
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
Albert Hall Convention Centre 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=3541 or tblfeedback.strbusinessname='Albert Hall Convention Centre The' or tblfeedback.strbusinessname='Albert Hall Convention Centre The') 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1 - 50 of 63 Sort search results alphabetically