Rating
Rosendals Tradgard
Sweden NSW 2000
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=41702 or tblfeedback.strbusinessname='Rosendals Tradgard' or tblfeedback.strbusinessname='Rosendals Tradgard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Adelaide Botanic Garden
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=23785 or tblfeedback.strbusinessname='Adelaide Botanic Garden' or tblfeedback.strbusinessname='Adelaide Botanic Garden') 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=29069 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
Serafino Wines
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=22015 or tblfeedback.strbusinessname='Serafino Wines' or tblfeedback.strbusinessname='Serafino Wines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Barns or Freeling
Freeling SA 5372
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=44518 or tblfeedback.strbusinessname='The Barns or Freeling' or tblfeedback.strbusinessname='The Barns or Freeling') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sinclair's Gully Winery
Norton Summit SA 5316
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=37906 or tblfeedback.strbusinessname='Sinclair'%%semi%%s Gully Winery' or tblfeedback.strbusinessname='Sinclair's Gully Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stevens Estate Garden
Williamstown 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=46653 or tblfeedback.strbusinessname='Stevens Estate Garden' or tblfeedback.strbusinessname='Stevens Estate Garden') 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
White Hill Estate
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=41386 or tblfeedback.strbusinessname='White Hill Estate' or tblfeedback.strbusinessname='White Hill Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
National Wine Centre of Australia
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=26114 or tblfeedback.strbusinessname='National Wine Centre of Australia' or tblfeedback.strbusinessname='National Wine Centre of Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mitolo Wines Weddings
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=46567 or tblfeedback.strbusinessname='Mitolo Wines Weddings' or tblfeedback.strbusinessname='Mitolo Wines Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Port Noarlunga Surf Life Saving Club - Functions and Events
Port Noarlunga SA 5167
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=46395 or tblfeedback.strbusinessname='Port Noarlunga Surf Life Saving Club - Functions and Events' or tblfeedback.strbusinessname='Port Noarlunga Surf Life Saving Club - Functions and Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Manor Basket Range
Basket Range SA 5138
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=43700 or tblfeedback.strbusinessname='The Manor Basket Range' or tblfeedback.strbusinessname='The Manor Basket Range') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Quince Brook 604 old bull creek road
Strathalbyn SA 5255
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=44705 or tblfeedback.strbusinessname='Quince Brook 604 old bull creek road' or tblfeedback.strbusinessname='Quince Brook 604 old bull creek road') 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
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=41784 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
Chateau Yaldara
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=38116 or tblfeedback.strbusinessname='Chateau Yaldara' or tblfeedback.strbusinessname='Chateau Yaldara') 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
Weddings at Winzor
Hillier SA 5116
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=35911 or tblfeedback.strbusinessname='Weddings at Winzor' or tblfeedback.strbusinessname='Weddings at Winzor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Old Government House
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=5902 or tblfeedback.strbusinessname='Old Government House' or tblfeedback.strbusinessname='Old Government House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
House of Chow
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=19131 or tblfeedback.strbusinessname='House of Chow' or tblfeedback.strbusinessname='House of Chow') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Botanic Gardens of Adelaide
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=19050 or tblfeedback.strbusinessname='Botanic Gardens of Adelaide' or tblfeedback.strbusinessname='Botanic Gardens of Adelaide') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
St Peter's Cathedral
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=19203 or tblfeedback.strbusinessname='St Peter'%%semi%%s Cathedral' or tblfeedback.strbusinessname='St Peter's Cathedral') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Veale Gardens
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=19238 or tblfeedback.strbusinessname='Veale Gardens' or tblfeedback.strbusinessname='Veale Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating