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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Welcome Inn Kingston
Kingston TAS 7050
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=3536 or tblfeedback.strbusinessname='Welcome Inn Kingston' or tblfeedback.strbusinessname='Welcome Inn Kingston') 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
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
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
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
Moorilla 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=3538 or tblfeedback.strbusinessname='Moorilla Estate' or tblfeedback.strbusinessname='Moorilla Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Rating
Cartela
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=3552 or tblfeedback.strbusinessname='Cartela' or tblfeedback.strbusinessname='Cartela') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Woodstock
South 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=5368 or tblfeedback.strbusinessname='Woodstock' or tblfeedback.strbusinessname='Woodstock') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hobart Vista 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=5353 or tblfeedback.strbusinessname='Hobart Vista Hotel' or tblfeedback.strbusinessname='Hobart Vista Hotel') 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
Runnymede
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=3532 or tblfeedback.strbusinessname='Runnymede' or tblfeedback.strbusinessname='Runnymede') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ye Olde Commodore Inn
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=5369 or tblfeedback.strbusinessname='Ye Olde Commodore Inn' or tblfeedback.strbusinessname='Ye Olde Commodore Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Barilla
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=3546 or tblfeedback.strbusinessname='Barilla' or tblfeedback.strbusinessname='Barilla') 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
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
Willows Tavern The
East Risdon TAS 7017
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=5367 or tblfeedback.strbusinessname='Willows Tavern The' or tblfeedback.strbusinessname='Willows Tavern The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Prosser's On The Beach
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=3583 or tblfeedback.strbusinessname='Prosser'%%semi%%s On The Beach' or tblfeedback.strbusinessname='Prosser's On The Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Waterline 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=3609 or tblfeedback.strbusinessname='Waterline Restaurant' or tblfeedback.strbusinessname='Waterline Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 85 Sort search results alphabetically