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
Tiffany
Melbourne VIC 3000
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=29489 or tblfeedback.strbusinessname='Tiffany' or tblfeedback.strbusinessname='Tiffany') 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
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
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
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
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
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
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
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
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
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
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