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
County Grey Clothing for Men
Mount Gambier SA 5290
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=6083 or tblfeedback.strbusinessname='County Grey Clothing for Men' or tblfeedback.strbusinessname='County Grey Clothing for Men') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Isn't She Lovely
Mount Gambier SA 5290
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=6156 or tblfeedback.strbusinessname='Isn'%%semi%%t She Lovely' or tblfeedback.strbusinessname='Isn't She Lovely') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Young's-The Mans Shop
Mount Gambier SA 5290
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=6122 or tblfeedback.strbusinessname='Young'%%semi%%s-The Mans Shop' or tblfeedback.strbusinessname='Young's-The Mans Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Thwaites Mensland
Mount Gambier SA 5290
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=6115 or tblfeedback.strbusinessname='Thwaites Mensland' or tblfeedback.strbusinessname='Thwaites Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15