Rating
Ed Harry
Hindmarsh SA 5007
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=26719 or tblfeedback.strbusinessname='Ed Harry' or tblfeedback.strbusinessname='Ed Harry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ken Camerons Menswear Town & Country
Mornington VIC 3931
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=13125 or tblfeedback.strbusinessname='Ken Camerons Menswear Town &%%semi%% Country' or tblfeedback.strbusinessname='Ken Camerons Menswear Town & Country') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Formal Wear of Mornington
Mornington VIC 3931
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=13107 or tblfeedback.strbusinessname='Formal Wear of Mornington' or tblfeedback.strbusinessname='Formal Wear of Mornington') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15