Rating Belair Park Country Club
Belair Park Country Club
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=19040 or tblfeedback.strbusinessname='Belair Park Country Club' or tblfeedback.strbusinessname='Belair Park Country Club') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating

Rating
Windy Point Restaurants
Belair SA 5052
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=6542 or tblfeedback.strbusinessname='Windy Point Restaurants' or tblfeedback.strbusinessname='Windy Point Restaurants') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ayers House
Adelaide SA 5000
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=19038 or tblfeedback.strbusinessname='Ayers House' or tblfeedback.strbusinessname='Ayers House') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kuitpo Hall
Kuitpo SA 5201
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=28992 or tblfeedback.strbusinessname='Kuitpo Hall' or tblfeedback.strbusinessname='Kuitpo Hall') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Festival Functions
Findon SA 5023
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=25233 or tblfeedback.strbusinessname='Festival Functions' or tblfeedback.strbusinessname='Festival Functions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sfera's
Modbury SA 5092
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=35909 or tblfeedback.strbusinessname='Sfera's' or tblfeedback.strbusinessname='Sfera's') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Carrick Hill
Springfield SA 5062
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=6384 or tblfeedback.strbusinessname='Carrick Hill' or tblfeedback.strbusinessname='Carrick Hill') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Glenelg Golf Club
Novar Gardens SA 5040
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=6424 or tblfeedback.strbusinessname='Glenelg Golf Club' or tblfeedback.strbusinessname='Glenelg Golf Club') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Adelaide Pavilion
Adelaide SA 5000
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=6483 or tblfeedback.strbusinessname='Adelaide Pavilion' or tblfeedback.strbusinessname='Adelaide Pavilion') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mount Lofty House
Crafers SA 5152
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=6467 or tblfeedback.strbusinessname='Mount Lofty House' or tblfeedback.strbusinessname='Mount Lofty House') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cruising Yacht Club of SA
North Haven SA 5018
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=6656 or tblfeedback.strbusinessname='Cruising Yacht Club of SA' or tblfeedback.strbusinessname='Cruising Yacht Club of SA') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Watershed
Mawson Lakes SA 5095
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=26192 or tblfeedback.strbusinessname='The Watershed' or tblfeedback.strbusinessname='The Watershed') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The White House @ Hahndorf
Hahndorf SA 5245
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=26275 or tblfeedback.strbusinessname='The White House @ Hahndorf' or tblfeedback.strbusinessname='The White House @ Hahndorf') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mawson Lakes Function Centre
Mawson Lakes SA 5095
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=26279 or tblfeedback.strbusinessname='Mawson Lakes Function Centre' or tblfeedback.strbusinessname='Mawson Lakes Function Centre') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hotel Elliot
Port Elliot SA 5212
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=26318 or tblfeedback.strbusinessname='Hotel Elliot' or tblfeedback.strbusinessname='Hotel Elliot') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tickle Belly Hill
Saltia SA 5433
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=25768 or tblfeedback.strbusinessname='Tickle Belly Hill' or tblfeedback.strbusinessname='Tickle Belly Hill') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Grand Ballroom
Fulham Gardens SA 5024
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=26904 or tblfeedback.strbusinessname='The Grand Ballroom' or tblfeedback.strbusinessname='The Grand Ballroom') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
St Francis Winery
Reynella SA 5161
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=25307 or tblfeedback.strbusinessname='St Francis Winery' or tblfeedback.strbusinessname='St Francis Winery') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lyndoch Hill
Lyndoch SA 5351
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=21287 or tblfeedback.strbusinessname='Lyndoch Hill' or tblfeedback.strbusinessname='Lyndoch Hill') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Glanville Hall Weddings
Semaphore South SA 5019
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=22112 or tblfeedback.strbusinessname='Glanville Hall Weddings' or tblfeedback.strbusinessname='Glanville Hall Weddings') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Adelaide Pavillion
Adelaide SA 5000
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=26027 or tblfeedback.strbusinessname='Adelaide Pavillion' or tblfeedback.strbusinessname='Adelaide Pavillion') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Utopia @ Waterfall Gully
Waterfall Gully SA 5066
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=26035 or tblfeedback.strbusinessname='Utopia @ Waterfall Gully' or tblfeedback.strbusinessname='Utopia @ Waterfall Gully') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Al Ru Farm
Sampson Flat SA 5114
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=21626 or tblfeedback.strbusinessname='Al Ru Farm' or tblfeedback.strbusinessname='Al Ru Farm') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Krystal Function Centre
Port Adelaide SA 5015
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=21768 or tblfeedback.strbusinessname='Krystal Function Centre' or tblfeedback.strbusinessname='Krystal Function Centre') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Glenelg Pier Hotel
Glenelg SA 5045
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=26445 or tblfeedback.strbusinessname='Glenelg Pier Hotel' or tblfeedback.strbusinessname='Glenelg Pier Hotel') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Barossa Chateau
Lyndoch SA 5351
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=26458 or tblfeedback.strbusinessname='Barossa Chateau' or tblfeedback.strbusinessname='Barossa Chateau') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sferas
Modbury SA 5091
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=26544 or tblfeedback.strbusinessname='Sferas' or tblfeedback.strbusinessname='Sferas') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Benjamin on Franklin
Adelaide SA 5000
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=26669 or tblfeedback.strbusinessname='Benjamin on Franklin' or tblfeedback.strbusinessname='Benjamin on Franklin') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Longview Vineyard
Macclesfield SA 5153
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=29029 or tblfeedback.strbusinessname='Longview Vineyard' or tblfeedback.strbusinessname='Longview Vineyard') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Howard Vineyard
Nairne SA 5252
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=27023 or tblfeedback.strbusinessname='Howard Vineyard' or tblfeedback.strbusinessname='Howard Vineyard') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Portee Station Blanchetown
Blanchetown SA 5357
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=27027 or tblfeedback.strbusinessname='Portee Station Blanchetown' or tblfeedback.strbusinessname='Portee Station Blanchetown') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mandalay House & Garden
St Ives SA 5252
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=27399 or tblfeedback.strbusinessname='Mandalay House & Garden' or tblfeedback.strbusinessname='Mandalay House & Garden') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Lane Vineyard
Hahndorf SA 5245
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=27690 or tblfeedback.strbusinessname='The Lane Vineyard' or tblfeedback.strbusinessname='The Lane Vineyard') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Adelaide Town Hall
Adelaide SA 5000
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=29023 or tblfeedback.strbusinessname='Adelaide Town Hall' or tblfeedback.strbusinessname='Adelaide Town Hall') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Capri Theatre
Goodwood SA 5034
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=29204 or tblfeedback.strbusinessname='Capri Theatre' or tblfeedback.strbusinessname='Capri Theatre') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Adelaide International Motel
Glenelg SA 5045
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=19024 or tblfeedback.strbusinessname='Adelaide International Motel' or tblfeedback.strbusinessname='Adelaide International Motel') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Adelaide Town Hall
Adelaide SA 5000
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=19025 or tblfeedback.strbusinessname='Adelaide Town Hall' or tblfeedback.strbusinessname='Adelaide Town Hall') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
New Alma Hotel The
Norwood SA 5067
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=6471 or tblfeedback.strbusinessname='New Alma Hotel The' or tblfeedback.strbusinessname='New Alma Hotel The') and year(getdate())-year(dtmadded)<=15
Rating
Next Generation Memorial Drive
North Adelaide SA 5006
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=6472 or tblfeedback.strbusinessname='Next Generation Memorial Drive' or tblfeedback.strbusinessname='Next Generation Memorial Drive') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Old Adelaide Inn
North Adelaide SA 5006
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=6474 or tblfeedback.strbusinessname='Old Adelaide Inn' or tblfeedback.strbusinessname='Old Adelaide Inn') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Old Clarendon Winery
Clarendon SA 5157
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=6475 or tblfeedback.strbusinessname='Old Clarendon Winery' or tblfeedback.strbusinessname='Old Clarendon Winery') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Old South Caterers The
Eastwood SA 5063
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=6477 or tblfeedback.strbusinessname='Old South Caterers The' or tblfeedback.strbusinessname='Old South Caterers The') and year(getdate())-year(dtmadded)<=15
Rating
Old South Caterers The
Echunga SA 5153
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=6478 or tblfeedback.strbusinessname='Old South Caterers The' or tblfeedback.strbusinessname='Old South Caterers The') and year(getdate())-year(dtmadded)<=15
Rating
Park Convention Centre The
West Lakes SA 5021
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=6479 or tblfeedback.strbusinessname='Park Convention Centre The' or tblfeedback.strbusinessname='Park Convention Centre The') and year(getdate())-year(dtmadded)<=15
Rating
Parks Community Centre The
Angle Park SA 5010
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=6480 or tblfeedback.strbusinessname='Parks Community Centre The' or tblfeedback.strbusinessname='Parks Community Centre The') and year(getdate())-year(dtmadded)<=15
Rating
Partridge House Reception Centre
Glenelg SA 5045
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=6481 or tblfeedback.strbusinessname='Partridge House Reception Centre' or tblfeedback.strbusinessname='Partridge House Reception Centre') and year(getdate())-year(dtmadded)<=15
Rating
Patawalonga Motor Inn
Glenelg North SA 5045
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=6482 or tblfeedback.strbusinessname='Patawalonga Motor Inn' or tblfeedback.strbusinessname='Patawalonga Motor Inn') and year(getdate())-year(dtmadded)<=15
Rating
Paxton's Conservatory Restaurant
Adelaide SA 5000
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=6484 or tblfeedback.strbusinessname='Paxton's Conservatory Restaurant' or tblfeedback.strbusinessname='Paxton's Conservatory Restaurant') and year(getdate())-year(dtmadded)<=15
Rating
Playford Entertainment Centre
Elizabeth West SA 5113
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=6486 or tblfeedback.strbusinessname='Playford Entertainment Centre' or tblfeedback.strbusinessname='Playford Entertainment Centre') and year(getdate())-year(dtmadded)<=15
Rating
Police Club The
Adelaide SA 5000
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=6487 or tblfeedback.strbusinessname='Police Club The' or tblfeedback.strbusinessname='Police Club The') and year(getdate())-year(dtmadded)<=15
1 - 50 of 200 Sort search results alphabetically