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
MONA (Museum of Old and New Art)
Berriedale TAS 7011
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=25761 or tblfeedback.strbusinessname='MONA (%%semi%%Museum of Old and New Art)%%semi%%' or tblfeedback.strbusinessname='MONA (Museum of Old and New Art)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Curringa Farm, Hamilton
Hamilton TAS 7140
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=43696 or tblfeedback.strbusinessname='Curringa Farm, Hamilton' or tblfeedback.strbusinessname='Curringa Farm, Hamilton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Steeles Island Retreat
Carlton Beach TAS 7173
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=24426 or tblfeedback.strbusinessname='Steeles Island Retreat' or tblfeedback.strbusinessname='Steeles Island Retreat') 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
Rydges Hobart
Hobart TAS 7000
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=3589 or tblfeedback.strbusinessname='Rydges Hobart' or tblfeedback.strbusinessname='Rydges Hobart') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Frogmore Creek Wines
Cambridge TAS 7170
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=22530 or tblfeedback.strbusinessname='Frogmore Creek Wines' or tblfeedback.strbusinessname='Frogmore Creek Wines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Riversdale Estate
Cambridge TAS 7170
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=24460 or tblfeedback.strbusinessname='Riversdale Estate' or tblfeedback.strbusinessname='Riversdale Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Peppermint Bay
Woodbridge TAS 7162
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=22193 or tblfeedback.strbusinessname='Peppermint Bay' or tblfeedback.strbusinessname='Peppermint Bay') 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=29162 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
Ramada Resort Seven Mile Beach
Seven Mile Beach TAS 7170
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=41293 or tblfeedback.strbusinessname='Ramada Resort Seven Mile Beach' or tblfeedback.strbusinessname='Ramada Resort Seven Mile Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Henry Jones Art Hotel
Hobart TAS 7000
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=23394 or tblfeedback.strbusinessname='The Henry Jones Art Hotel' or tblfeedback.strbusinessname='The Henry Jones Art Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Glen Albyn Estate
Taroona TAS 7053
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=21922 or tblfeedback.strbusinessname='Glen Albyn Estate' or tblfeedback.strbusinessname='Glen Albyn Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hidden Garden Estate
Berriedale TAS 7011
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=43521 or tblfeedback.strbusinessname='Hidden Garden Estate' or tblfeedback.strbusinessname='Hidden Garden Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Barilla Bay
Cambridge TAS 7170
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=35822 or tblfeedback.strbusinessname='Barilla Bay' or tblfeedback.strbusinessname='Barilla Bay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bruny Island Coastal Retreats
Alonnah TAS 7150
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=27211 or tblfeedback.strbusinessname='Bruny Island Coastal Retreats' or tblfeedback.strbusinessname='Bruny Island Coastal Retreats') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hadleys Orient Hotel
Hobart TAS 7000
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=3559 or tblfeedback.strbusinessname='Hadleys Orient Hotel' or tblfeedback.strbusinessname='Hadleys Orient Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tasmania Golf Club
Cambridge TAS 7170
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=25008 or tblfeedback.strbusinessname='Tasmania Golf Club' or tblfeedback.strbusinessname='Tasmania Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Royal Yacht Club of Tasmania
Sandy Bay TAS 7005
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=41207 or tblfeedback.strbusinessname='The Royal Yacht Club of Tasmania' or tblfeedback.strbusinessname='The Royal Yacht Club of Tasmania') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stewarts Bay Lodge
Port Arthur TAS 7182
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=26262 or tblfeedback.strbusinessname='Stewarts Bay Lodge' or tblfeedback.strbusinessname='Stewarts Bay Lodge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Old Woolstore
Hobart TAS 7000
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=27839 or tblfeedback.strbusinessname='The Old Woolstore' or tblfeedback.strbusinessname='The Old Woolstore') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pear Ridge Weddings
Margate TAS 7054
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=21738 or tblfeedback.strbusinessname='Pear Ridge Weddings' or tblfeedback.strbusinessname='Pear Ridge Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lenna of Hobart
Battery Point TAS 7004
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=3570 or tblfeedback.strbusinessname='Lenna of Hobart' or tblfeedback.strbusinessname='Lenna of Hobart') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Old Woolstore
Hobart TAS 7000
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=26714 or tblfeedback.strbusinessname='The Old Woolstore' or tblfeedback.strbusinessname='The Old Woolstore') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tasmanian Hockey Centre
New Town TAS 7008
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=27923 or tblfeedback.strbusinessname='Tasmanian Hockey Centre' or tblfeedback.strbusinessname='Tasmanian Hockey Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Old Farm, Tasmania
Port Arthur TAS 7182
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=43974 or tblfeedback.strbusinessname='The Old Farm, Tasmania' or tblfeedback.strbusinessname='The Old Farm, Tasmania') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Motor Yacht Club
Lindisfarne TAS 7015
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=35650 or tblfeedback.strbusinessname='Motor Yacht Club' or tblfeedback.strbusinessname='Motor Yacht Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Zeldas Bar & Bistro
Bagdad 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=44078 or tblfeedback.strbusinessname='Zeldas Bar &%%semi%% Bistro' or tblfeedback.strbusinessname='Zeldas Bar & Bistro') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Home Hill Winery Restaurant
Ranelagh TAS 7109
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=3565 or tblfeedback.strbusinessname='Home Hill Winery Restaurant' or tblfeedback.strbusinessname='Home Hill Winery Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Salamanca Arts Centre
Hobart TAS 7004
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=35547 or tblfeedback.strbusinessname='Salamanca Arts Centre' or tblfeedback.strbusinessname='Salamanca Arts Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mures Upper Deck
Hobart TAS 7000
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=3576 or tblfeedback.strbusinessname='Mures Upper Deck' or tblfeedback.strbusinessname='Mures Upper Deck') 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
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
Shene Estate
Pontville 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=27684 or tblfeedback.strbusinessname='Shene Estate' or tblfeedback.strbusinessname='Shene Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Willie Smiths Apple Shed
Huonville TAS 7109
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=37815 or tblfeedback.strbusinessname='Willie Smiths Apple Shed' or tblfeedback.strbusinessname='Willie Smiths Apple Shed') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wings Function Centre
Mornington TAS 7018
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=3537 or tblfeedback.strbusinessname='Wings Function Centre' or tblfeedback.strbusinessname='Wings Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Botanical Gardens Restaurant
Hobart TAS 7000
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=3548 or tblfeedback.strbusinessname='Botanical Gardens Restaurant' or tblfeedback.strbusinessname='Botanical Gardens Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pickled Pear
Sandy Bay TAS 7006
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=3580 or tblfeedback.strbusinessname='Pickled Pear' or tblfeedback.strbusinessname='Pickled Pear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Splash of Paris
Hobart TAS 7000
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=3540 or tblfeedback.strbusinessname='A Splash of Paris' or tblfeedback.strbusinessname='A Splash of Paris') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Highway Village Motor Inn
Berriedale TAS 7011
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=3562 or tblfeedback.strbusinessname='Highway Village Motor Inn' or tblfeedback.strbusinessname='Highway Village Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Howrah Sunshine Recreation Centre
Howrah TAS 7018
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=3566 or tblfeedback.strbusinessname='Howrah Sunshine Recreation Centre' or tblfeedback.strbusinessname='Howrah Sunshine Recreation Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Balmoral Motor Inn
Glenorchy TAS 7010
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=3545 or tblfeedback.strbusinessname='Balmoral Motor Inn' or tblfeedback.strbusinessname='Balmoral Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hobart Mid City Hotel
Hobart TAS 7000
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=3564 or tblfeedback.strbusinessname='Hobart Mid City Hotel' or tblfeedback.strbusinessname='Hobart Mid City Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tasmanian Cricket Association
Bellerive TAS 7018
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=5362 or tblfeedback.strbusinessname='Tasmanian Cricket Association' or tblfeedback.strbusinessname='Tasmanian Cricket Association') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Corus Hotel Hobart
Hobart TAS 7000
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=3555 or tblfeedback.strbusinessname='Corus Hotel Hobart' or tblfeedback.strbusinessname='Corus Hotel Hobart') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sisco's on the Pier
Hobart TAS 7000
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=3594 or tblfeedback.strbusinessname='Sisco'%%semi%%s on the Pier' or tblfeedback.strbusinessname='Sisco's on the Pier') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hotel Grand Chancellor
Hobart TAS 7000
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=3528 or tblfeedback.strbusinessname='Hotel Grand Chancellor' or tblfeedback.strbusinessname='Hotel Grand Chancellor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Derwent Entertainment Centre
Glenorchy TAS 7010
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=3556 or tblfeedback.strbusinessname='Derwent Entertainment Centre' or tblfeedback.strbusinessname='Derwent Entertainment Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Welcome Inn Kingston
Kingston TAS 7051
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=5365 or tblfeedback.strbusinessname='Welcome Inn Kingston' or tblfeedback.strbusinessname='Welcome Inn Kingston') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Moorilla Museum
Berriedale TAS 7011
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=19157 or tblfeedback.strbusinessname='Moorilla Museum' or tblfeedback.strbusinessname='Moorilla Museum') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 86 Sort search results alphabetically