Rating
Julie Hebert Millinery
Orange NSW 2800
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=27584 or tblfeedback.strbusinessname='Julie Hebert Millinery' or tblfeedback.strbusinessname='Julie Hebert Millinery') and year(getdate())-year(dtmadded)<=15
Rating
Bonbons Wedding Accessories
Oak Flats NSW 2529
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=8283 or tblfeedback.strbusinessname='Bonbons Wedding Accessories' or tblfeedback.strbusinessname='Bonbons Wedding Accessories') and year(getdate())-year(dtmadded)<=15
Rating
Noiva De Oje Bridal Veils & Headpieces
Farmborough Heights NSW 2526
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=10708 or tblfeedback.strbusinessname='Noiva De Oje Bridal Veils & Headpieces' or tblfeedback.strbusinessname='Noiva De Oje Bridal Veils & Headpieces') and year(getdate())-year(dtmadded)<=15
Rating
Now & Forever Wedding Accessories
Nowra NSW 2541
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=10744 or tblfeedback.strbusinessname='Now & Forever Wedding Accessories' or tblfeedback.strbusinessname='Now & Forever Wedding Accessories') and year(getdate())-year(dtmadded)<=15
Rating
Formal Affair
Warrawong NSW 2502
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=1544 or tblfeedback.strbusinessname='Formal Affair' or tblfeedback.strbusinessname='Formal Affair') and year(getdate())-year(dtmadded)<=15
Rating
Shoalhaven Fancy Dress & Bridal Wear
Nowra NSW 2541
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=1563 or tblfeedback.strbusinessname='Shoalhaven Fancy Dress & Bridal Wear' or tblfeedback.strbusinessname='Shoalhaven Fancy Dress & Bridal Wear') and year(getdate())-year(dtmadded)<=15
Rating
Simply Jewellery
North Nowra NSW 2541
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=14975 or tblfeedback.strbusinessname='Simply Jewellery' or tblfeedback.strbusinessname='Simply Jewellery') and year(getdate())-year(dtmadded)<=15