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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Hens and Bucks Party Supplies.

Rating
Botanica Day Spa
81 Boat Harbour Drive Pialba QLD 4655
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=18625 or tblfeedback.strbusinessname='Botanica Day Spa' or tblfeedback.strbusinessname='Botanica Day Spa') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating