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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Joy Parry
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=5837 or tblfeedback.strbusinessname='Joy Parry' or tblfeedback.strbusinessname='Joy Parry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mc Ternan
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=5853 or tblfeedback.strbusinessname='Mc Ternan' or tblfeedback.strbusinessname='Mc Ternan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kelly
Nelson 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=5840 or tblfeedback.strbusinessname='Kelly' or tblfeedback.strbusinessname='Kelly') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bessie Scott
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=5792 or tblfeedback.strbusinessname='Bessie Scott' or tblfeedback.strbusinessname='Bessie Scott') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ted Jordan
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=5884 or tblfeedback.strbusinessname='Ted Jordan' or tblfeedback.strbusinessname='Ted Jordan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tiddy
Millicent SA 5280
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=5887 or tblfeedback.strbusinessname='Tiddy' or tblfeedback.strbusinessname='Tiddy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15