Rating Samaria's Manchester
Samaria's Manchester
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=17267 or tblfeedback.strbusinessname='Samaria'%%semi%%s Manchester' or tblfeedback.strbusinessname='Samaria's Manchester') and year(getdate())-year(dtmadded)<=15
A perfect 'quick gift'
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
Chocoholic Tours
14 Rae Street Hawthorn VIC 3122
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=17719 or tblfeedback.strbusinessname='Chocoholic Tours' or tblfeedback.strbusinessname='Chocoholic Tours') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating