Rating
The Providore Styling
Coldstream VIC 3777
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=44803 or tblfeedback.strbusinessname='The Providore Styling' or tblfeedback.strbusinessname='The Providore Styling') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Yarra Valley Blooms
Yarra Valley VIC 2580
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=44083 or tblfeedback.strbusinessname='Yarra Valley Blooms' or tblfeedback.strbusinessname='Yarra Valley Blooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ginger Says
Gladstone QLD 4680
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=25587 or tblfeedback.strbusinessname='Ginger Says' or tblfeedback.strbusinessname='Ginger Says') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wild blooms Australia
Gold Coast QLD 4207
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=46894 or tblfeedback.strbusinessname='Wild blooms Australia' or tblfeedback.strbusinessname='Wild blooms Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gather Store
Currumbin Waters QLD 4223
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=41340 or tblfeedback.strbusinessname='Gather Store' or tblfeedback.strbusinessname='Gather Store') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Artificial Flower Co
Bunyip VIC 3815
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=46390 or tblfeedback.strbusinessname='The Artificial Flower Co' or tblfeedback.strbusinessname='The Artificial Flower Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mountain Daisy Florist
Kinglake VIC 3763
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=46191 or tblfeedback.strbusinessname='Mountain Daisy Florist' or tblfeedback.strbusinessname='Mountain Daisy Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The styled bouquet by Michelle Baerken
Sydney NSW 2000
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=44677 or tblfeedback.strbusinessname='The styled bouquet by Michelle Baerken' or tblfeedback.strbusinessname='The styled bouquet by Michelle Baerken') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Bouquet Maker
Bingara NSW 2404
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=37474 or tblfeedback.strbusinessname='The Bouquet Maker' or tblfeedback.strbusinessname='The Bouquet Maker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gather Australia
Currumbin Waters QLD 4223
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=46003 or tblfeedback.strbusinessname='Gather Australia' or tblfeedback.strbusinessname='Gather Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wish Sydney
Sydney NSW 2000
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=36174 or tblfeedback.strbusinessname='Wish Sydney' or tblfeedback.strbusinessname='Wish Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Amy's Flower Shop
Goulburn NSW 2580
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=7835 or tblfeedback.strbusinessname='Amy'%%semi%%s Flower Shop' or tblfeedback.strbusinessname='Amy's Flower Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kayes Florist
Goulburn NSW 2580
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=10025 or tblfeedback.strbusinessname='Kayes Florist' or tblfeedback.strbusinessname='Kayes Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goulburn Florist
Goulburn NSW 2580
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=9508 or tblfeedback.strbusinessname='Goulburn Florist' or tblfeedback.strbusinessname='Goulburn Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15