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