Rating
Leogate Estate Wines
Pokolbin NSW 2320
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=25486 or tblfeedback.strbusinessname='Leogate Estate Wines' or tblfeedback.strbusinessname='Leogate Estate Wines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pericoota Station
Moama NSW 2731
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=37892 or tblfeedback.strbusinessname='Pericoota Station' or tblfeedback.strbusinessname='Pericoota Station') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Nu-Lumeah Weddings
Springvale NSW 2650
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=43932 or tblfeedback.strbusinessname='Nu-Lumeah Weddings' or tblfeedback.strbusinessname='Nu-Lumeah Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating