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
Williams
Bordertown SA 5268
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=5898 or tblfeedback.strbusinessname='Williams' or tblfeedback.strbusinessname='Williams') 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
Wishart's Mensland
Naracoorte SA 5271
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=6121 or tblfeedback.strbusinessname='Wishart'%%semi%%s Mensland' or tblfeedback.strbusinessname='Wishart's Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wiese & Co
Bordertown SA 5268
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=6120 or tblfeedback.strbusinessname='Wiese &%%semi%% Co' or tblfeedback.strbusinessname='Wiese & Co') 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
Rating
Heard Bros Menswear
Naracoorte SA 5271
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=6096 or tblfeedback.strbusinessname='Heard Bros Menswear' or tblfeedback.strbusinessname='Heard Bros Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
TJ Wiese & Co
Bordertown SA 5268
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=6116 or tblfeedback.strbusinessname='TJ Wiese &%%semi%% Co' or tblfeedback.strbusinessname='TJ Wiese & Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15