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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Princess Collection
274B Main North Road 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
International Linen Service Pty Ltd
59 Stephens Avenue 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 year(getdate())-year(dtmadded)<=15
Rating
Xtraclean Dry Cleaners
44 John Street 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 year(getdate())-year(dtmadded)<=15