Rating
Lake House Daylesford
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=19524 or tblfeedback.strbusinessname='Lake House Daylesford' or tblfeedback.strbusinessname='Lake House Daylesford') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Lake House Daylesford
Rating Dirty Weekend Shop
Dirty Weekend Shop
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=19582 or tblfeedback.strbusinessname='Dirty Weekend Shop' or tblfeedback.strbusinessname='Dirty Weekend Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Hens and Bucks Party Supplies.

Rating
Pinot & Picasso
Australia wide TAS 7001
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=44076 or tblfeedback.strbusinessname='Pinot &%%semi%% Picasso' or tblfeedback.strbusinessname='Pinot & Picasso') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating