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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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 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
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
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
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
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 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
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
Lindisfarne Rowing 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=20835 or tblfeedback.strbusinessname='Lindisfarne Rowing Club' or tblfeedback.strbusinessname='Lindisfarne Rowing Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tornies Catering
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=3605 or tblfeedback.strbusinessname='Tornies Catering' or tblfeedback.strbusinessname='Tornies Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abfab Function Planners
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=5344 or tblfeedback.strbusinessname='Abfab Function Planners' or tblfeedback.strbusinessname='Abfab Function Planners') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Huon Manor
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=3567 or tblfeedback.strbusinessname='Huon Manor' or tblfeedback.strbusinessname='Huon Manor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Eliza's Reception Centre
Lenah Valley 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=5349 or tblfeedback.strbusinessname='Eliza'%%semi%%s Reception Centre' or tblfeedback.strbusinessname='Eliza's Reception Centre') 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
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
The Pines
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=3535 or tblfeedback.strbusinessname='The Pines' or tblfeedback.strbusinessname='The Pines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tandoor & Curry House
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=3601 or tblfeedback.strbusinessname='Tandoor &%%semi%% Curry House' or tblfeedback.strbusinessname='Tandoor & Curry House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Century Room
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=3553 or tblfeedback.strbusinessname='Century Room' or tblfeedback.strbusinessname='Century Room') 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
Prospect House
Richmond TAS 7025
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=3582 or tblfeedback.strbusinessname='Prospect House' or tblfeedback.strbusinessname='Prospect House') 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
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
Motor Yacht Club Of Tasmania
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=3574 or tblfeedback.strbusinessname='Motor Yacht Club Of Tasmania' or tblfeedback.strbusinessname='Motor Yacht Club Of Tasmania') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 86 Sort search results alphabetically