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
Ayers House
288 North Tce 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
772 Brookman Rd 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
292 Findon Road 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
Carrick Hill
46 Carrick Hill Drive 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
James Melrose Road 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
Veale Gardens South Terrace & Peacock Road 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
74 Summit Road 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
Windy Point Restaurants
Belair Road 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
The Watershed
665 Salisbury Hwy 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
35 The Strand 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
1640 Flinders Ranges Way 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
443 Tapleys Hill Road 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
14 Bridge St 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
1221 Barossa Valley Way 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
8 Park Ave 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
Veale Gardens, Cnr South Terrace and Peacock Road 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
170 Waterfall Gully Rd 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
1/1016 One Tree Hill Rd 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
7 Church St 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
18 Holdfast Promenade 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
35 Hermann Thumm Dr 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
191 Reservoir Rd 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
233 Franklin St 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
154 Pound Rd 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
53 Bald Hills Rd 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
4551 Murraylands Rd 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
271 Back Callington Rd 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Lane Vineyard
5 Ravenswood Ln 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
128 King William St 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
141 Goodwood Road 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
521 Anzac Highway 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
128 King William Street 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
Woodstock Winery & Coterie
Douglas Gully Road 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 Winery &%%semi%% Coterie' or tblfeedback.strbusinessname='Woodstock Winery & Coterie') and year(getdate())-year(dtmadded)<=15
Rating
Yachtclub Restaurant The
Adelphi Terrace 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=6544 or tblfeedback.strbusinessname='Yachtclub Restaurant The' or tblfeedback.strbusinessname='Yachtclub Restaurant The') and year(getdate())-year(dtmadded)<=15
Rating
Cruising Yacht Club of SA
Lady Gowrie Drive 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
Rating
New Alma Hotel The
66 Magill Road 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
War 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
160 O'Connell Street 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
Grants Gully Road 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
Greenhill Road 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
Meadows Road 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
Turner Drive 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
Cowan Street 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
38 Partridge Street 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
Adelphi Terrace 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
288 North Terrace 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'%%semi%%s Conservatory Restaurant' or tblfeedback.strbusinessname='Paxton's Conservatory Restaurant') and year(getdate())-year(dtmadded)<=15
Rating
Playford Entertainment Centre
12 Barfield Crescent 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
1 - 50 of 199 Sort search results alphabetically