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
Des Pinsons Mens & Surf Wear
Port Lincoln SA 5606
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=6086 or tblfeedback.strbusinessname='Des Pinsons Mens &%%semi%% Surf Wear' or tblfeedback.strbusinessname='Des Pinsons Mens & Surf Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Doug Watson's Mens & Boys Wear
Port Lincoln SA 5606
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=6087 or tblfeedback.strbusinessname='Doug Watson'%%semi%%s Mens &%%semi%% Boys Wear' or tblfeedback.strbusinessname='Doug Watson's Mens & Boys Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15