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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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'%%semi%%s' or tblfeedback.strbusinessname='Sfera's') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Glen Ewin Estate
Houghton SA 5131
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=21722 or tblfeedback.strbusinessname='Glen Ewin Estate' or tblfeedback.strbusinessname='Glen Ewin Estate') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Woodstock Wine Estate
McLaren Flat SA 5171
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=6543 or tblfeedback.strbusinessname='Woodstock Wine Estate' or tblfeedback.strbusinessname='Woodstock Wine Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Inglewood Inn
Inglewood SA 5133
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=36295 or tblfeedback.strbusinessname='Inglewood Inn' or tblfeedback.strbusinessname='Inglewood Inn') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Howard's Vineyard Nairne
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=37450 or tblfeedback.strbusinessname='Howard'%%semi%%s Vineyard Nairne' or tblfeedback.strbusinessname='Howard's Vineyard Nairne') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 &%%semi%% Garden' or tblfeedback.strbusinessname='Mandalay House & Garden') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Marche Club Incorporated
Paradise SA 5075
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=6459 or tblfeedback.strbusinessname='Marche Club Incorporated' or tblfeedback.strbusinessname='Marche Club Incorporated') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flagstaff Hill Golf & Country Club Inc
Flagstaff Hill SA 5159
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=6413 or tblfeedback.strbusinessname='Flagstaff Hill Golf &%%semi%% Country Club Inc' or tblfeedback.strbusinessname='Flagstaff Hill Golf & Country Club Inc') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
CK Food at the Art Gallery
South Australia 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=5182 or tblfeedback.strbusinessname='CK Food at the Art Gallery' or tblfeedback.strbusinessname='CK Food at the Art Gallery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ruggiero Reception Centre
Hendon SA 5014
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=6503 or tblfeedback.strbusinessname='Ruggiero Reception Centre' or tblfeedback.strbusinessname='Ruggiero Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
St Mark's College Incorporated
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=6517 or tblfeedback.strbusinessname='St Mark'%%semi%%s College Incorporated' or tblfeedback.strbusinessname='St Mark's College Incorporated') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Athelstone Football Club
Paradise SA 5075
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=6363 or tblfeedback.strbusinessname='Athelstone Football Club' or tblfeedback.strbusinessname='Athelstone Football Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Middlebrook Winery Restaurant
Mclaren Vale SA 5171
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=6463 or tblfeedback.strbusinessname='Middlebrook Winery Restaurant' or tblfeedback.strbusinessname='Middlebrook Winery Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sunnybrae
Regency 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=6524 or tblfeedback.strbusinessname='Sunnybrae' or tblfeedback.strbusinessname='Sunnybrae') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Renaissance Tower Restaurant & Function Centre
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=6498 or tblfeedback.strbusinessname='Renaissance Tower Restaurant &%%semi%% Function Centre' or tblfeedback.strbusinessname='Renaissance Tower Restaurant & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dexter's Fish Cafe
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=6403 or tblfeedback.strbusinessname='Dexter'%%semi%%s Fish Cafe' or tblfeedback.strbusinessname='Dexter's Fish Cafe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Central District Function Centre
Elizabeth SA 5112
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=6386 or tblfeedback.strbusinessname='Central District Function Centre' or tblfeedback.strbusinessname='Central District Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 205 Sort search results alphabetically