Rating
Kcouture
Moana SA 5169
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=29413 or tblfeedback.strbusinessname='Kcouture' or tblfeedback.strbusinessname='Kcouture') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Xtraclean Dry Cleaners
Salisbury SA 5108
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=5989 or tblfeedback.strbusinessname='Xtraclean Dry Cleaners' or tblfeedback.strbusinessname='Xtraclean Dry Cleaners') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
International Linen Service Pty Ltd
Torrensville SA 5031
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=5953 or tblfeedback.strbusinessname='International Linen Service Pty Ltd' or tblfeedback.strbusinessname='International Linen Service Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Princess Collection
Prospect SA 5082
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=5988 or tblfeedback.strbusinessname='Princess Collection' or tblfeedback.strbusinessname='Princess Collection') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating