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
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
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
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
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