Rating
Galleria Ettalong
Ettalong Beach NSW 2257
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=35924 or tblfeedback.strbusinessname='Galleria Ettalong' or tblfeedback.strbusinessname='Galleria Ettalong') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Fires Creek Winery
Holgate NSW 2250
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=26856 or tblfeedback.strbusinessname='Fires Creek Winery' or tblfeedback.strbusinessname='Fires Creek Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Crowne Plaza Windsor
Windsor NSW 2756
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=35771 or tblfeedback.strbusinessname='Crowne Plaza Windsor' or tblfeedback.strbusinessname='Crowne Plaza Windsor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lerida Garden Weddings
Narara NSW 2250
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=10195 or tblfeedback.strbusinessname='Lerida Garden Weddings' or tblfeedback.strbusinessname='Lerida Garden Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15