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