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
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
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
Evanslea Luxury Boutique Accommodation Mudgee
Mudgee NSW 2850
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=43342 or tblfeedback.strbusinessname='Evanslea Luxury Boutique Accommodation Mudgee' or tblfeedback.strbusinessname='Evanslea Luxury Boutique Accommodation Mudgee') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating