Rating
Bloom
Adelaide SA 5000
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=5990 or tblfeedback.strbusinessname='Bloom' or tblfeedback.strbusinessname='Bloom') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bridal Fabrics Direct
Hyde Park SA 5061
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=5991 or tblfeedback.strbusinessname='Bridal Fabrics Direct' or tblfeedback.strbusinessname='Bridal Fabrics Direct') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lumaca Fabrics & Dressmakers
North Adelaide SA 5006
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=5994 or tblfeedback.strbusinessname='Lumaca Fabrics &%%semi%% Dressmakers' or tblfeedback.strbusinessname='Lumaca Fabrics & Dressmakers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Glynburn Fabrics Pty Ltd
Firle SA 5070
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=5993 or tblfeedback.strbusinessname='Glynburn Fabrics Pty Ltd' or tblfeedback.strbusinessname='Glynburn Fabrics Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
DK Fabrics
Adelaide SA 5000
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=5992 or tblfeedback.strbusinessname='DK Fabrics' or tblfeedback.strbusinessname='DK Fabrics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating