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.