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
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
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
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
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
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
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
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
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
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
Gomersal Wines
Gomersal SA 5352
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=38591 or tblfeedback.strbusinessname='Gomersal Wines' or tblfeedback.strbusinessname='Gomersal Wines') 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Glandore Community Centre
Glandore SA 5037
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=6423 or tblfeedback.strbusinessname='Glandore Community Centre' or tblfeedback.strbusinessname='Glandore Community Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adelaide Meridien
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=6351 or tblfeedback.strbusinessname='Adelaide Meridien' or tblfeedback.strbusinessname='Adelaide Meridien') 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
Post Office Restaurant The
Happy Valley 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=6491 or tblfeedback.strbusinessname='Post Office Restaurant The' or tblfeedback.strbusinessname='Post Office Restaurant The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lion Hotel The
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=6454 or tblfeedback.strbusinessname='Lion Hotel The' or tblfeedback.strbusinessname='Lion Hotel The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Stella Restaurant
Henley Beach SA 5022
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=6520 or tblfeedback.strbusinessname='Stella Restaurant' or tblfeedback.strbusinessname='Stella Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cafe Nova
Gawler SA 5118
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=6381 or tblfeedback.strbusinessname='Cafe Nova' or tblfeedback.strbusinessname='Cafe Nova') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Royal South Australian Yacht Squadron
Outer Harbor 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=6501 or tblfeedback.strbusinessname='Royal South Australian Yacht Squadron' or tblfeedback.strbusinessname='Royal South Australian Yacht Squadron') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Plantscape Interiors
Kent Town SA 5071
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=6485 or tblfeedback.strbusinessname='Plantscape Interiors' or tblfeedback.strbusinessname='Plantscape Interiors') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Function AT the Mirage
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=6420 or tblfeedback.strbusinessname='Function AT the Mirage' or tblfeedback.strbusinessname='Function AT the Mirage') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 206 Sort search results alphabetically