Rating
Vintage La Belle
Charlestown NSW 2290
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=29405 or tblfeedback.strbusinessname='Vintage La Belle' or tblfeedback.strbusinessname='Vintage La Belle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Baggs
Merewether NSW 2291
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=8015 or tblfeedback.strbusinessname='Baggs' or tblfeedback.strbusinessname='Baggs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Corleya Designs
Rathmines NSW 2283
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=8789 or tblfeedback.strbusinessname='Corleya Designs' or tblfeedback.strbusinessname='Corleya Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Veil World
Highfields NSW 2289
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=11857 or tblfeedback.strbusinessname='Veil World' or tblfeedback.strbusinessname='Veil World') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hats by Cathy Stuart
Morpeth NSW 2321
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=9635 or tblfeedback.strbusinessname='Hats by Cathy Stuart' or tblfeedback.strbusinessname='Hats by Cathy Stuart') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gloria David Enterprises
Thornton NSW 2322
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=9476 or tblfeedback.strbusinessname='Gloria David Enterprises' or tblfeedback.strbusinessname='Gloria David Enterprises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shar-Lin Bridal
Belmont NSW 2280
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=11355 or tblfeedback.strbusinessname='Shar-Lin Bridal' or tblfeedback.strbusinessname='Shar-Lin Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Crystal Confetti Bridal
Newcastle NSW 2300
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=8861 or tblfeedback.strbusinessname='Crystal Confetti Bridal' or tblfeedback.strbusinessname='Crystal Confetti Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tiara 2000
Mayfield NSW 2304
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=11720 or tblfeedback.strbusinessname='Tiara 2000' or tblfeedback.strbusinessname='Tiara 2000') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Just Enigma
Hamilton NSW 2303
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=9998 or tblfeedback.strbusinessname='Just Enigma' or tblfeedback.strbusinessname='Just Enigma') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dreams Come True Bridal Boutique
Charlestown NSW 2290
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=1541 or tblfeedback.strbusinessname='Dreams Come True Bridal Boutique' or tblfeedback.strbusinessname='Dreams Come True Bridal Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15