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
Mini Event Wall
Townsville QLD 4810
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=38434 or tblfeedback.strbusinessname='Mini Event Wall' or tblfeedback.strbusinessname='Mini Event Wall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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