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
Barton Flower Bar
Barton ACT 2600
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=41712 or tblfeedback.strbusinessname='Barton Flower Bar' or tblfeedback.strbusinessname='Barton Flower Bar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pia & Jade
Canberra ACT 2600
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=46771 or tblfeedback.strbusinessname='Pia &%%semi%% Jade' or tblfeedback.strbusinessname='Pia & Jade') 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
Flowers from the Garden
Dickson ACT 2602
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=41585 or tblfeedback.strbusinessname='Flowers from the Garden' or tblfeedback.strbusinessname='Flowers from the Garden') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
CH Floral Designs
Moonbah NSW 2627
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=23175 or tblfeedback.strbusinessname='CH Floral Designs' or tblfeedback.strbusinessname='CH Floral Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Miss Muffet's
Mawson ACT 2607
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=37384 or tblfeedback.strbusinessname='Miss Muffet'%%semi%%s' or tblfeedback.strbusinessname='Miss Muffet's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
WILUNA Flower Studio
Fyshwick ACT 2609
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=44300 or tblfeedback.strbusinessname='WILUNA Flower Studio' or tblfeedback.strbusinessname='WILUNA Flower Studio') 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
Pia+Jade
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=43261 or tblfeedback.strbusinessname='Pia+%%semi%%Jade' or tblfeedback.strbusinessname='Pia+Jade') 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
Poetry in Flowers
Gungahlin ACT 2912
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=19173 or tblfeedback.strbusinessname='Poetry in Flowers' or tblfeedback.strbusinessname='Poetry in Flowers') 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
Botanical Designs
Red Hill ACT 2603
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=26092 or tblfeedback.strbusinessname='Botanical Designs' or tblfeedback.strbusinessname='Botanical Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kettle n' petal
Canberra ACT 2602
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=43330 or tblfeedback.strbusinessname='Kettle n'%%semi%% petal' or tblfeedback.strbusinessname='Kettle n' petal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Peony n Pearl
Canberra ACT 2913
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=43313 or tblfeedback.strbusinessname='Peony n Pearl' or tblfeedback.strbusinessname='Peony n Pearl') 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
Country Bunches Flowers and Gifts
Young NSW 2594
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=26746 or tblfeedback.strbusinessname='Country Bunches Flowers and Gifts' or tblfeedback.strbusinessname='Country Bunches Flowers and Gifts') 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
Manuka Flowers
Manuka ACT 2603
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=5544 or tblfeedback.strbusinessname='Manuka Flowers' or tblfeedback.strbusinessname='Manuka Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cheree's Flowers
Young NSW 2594
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=27552 or tblfeedback.strbusinessname='Cheree'%%semi%%s Flowers' or tblfeedback.strbusinessname='Cheree's Flowers') 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
Wren & Rabbit Event Productions
Fyshwick ACT 2609
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=27469 or tblfeedback.strbusinessname='Wren &%%semi%% Rabbit Event Productions' or tblfeedback.strbusinessname='Wren & Rabbit Event Productions') 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
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
Botanical Designs
Red Hill ACT 2603
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=29250 or tblfeedback.strbusinessname='Botanical Designs' or tblfeedback.strbusinessname='Botanical Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
All About Flowers
Macquarie ACT 2614
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=19028 or tblfeedback.strbusinessname='All About Flowers' or tblfeedback.strbusinessname='All About Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Flower Man
Charnwood ACT 2615
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=19226 or tblfeedback.strbusinessname='The Flower Man' or tblfeedback.strbusinessname='The Flower Man') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Capital Flowers
Oaks Estate ACT 2620
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=19059 or tblfeedback.strbusinessname='Capital Flowers' or tblfeedback.strbusinessname='Capital Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kingston Florist
Kingston ACT 2604
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=5543 or tblfeedback.strbusinessname='Kingston Florist' or tblfeedback.strbusinessname='Kingston Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wild Iris The
Tuggeranong ACT 2900
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=5548 or tblfeedback.strbusinessname='Wild Iris The' or tblfeedback.strbusinessname='Wild Iris The') 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
A Bloom A Day
Dickson ACT 2602
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=5537 or tblfeedback.strbusinessname='A Bloom A Day' or tblfeedback.strbusinessname='A Bloom A Day') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Garden Florist The
Dickson ACT 2602
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=5541 or tblfeedback.strbusinessname='Garden Florist The' or tblfeedback.strbusinessname='Garden Florist The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Botanics Florist
Kingston ACT 2604
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=19051 or tblfeedback.strbusinessname='Botanics Florist' or tblfeedback.strbusinessname='Botanics Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Botanics on Jardine
Kingston ACT 2604
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=5538 or tblfeedback.strbusinessname='Botanics on Jardine' or tblfeedback.strbusinessname='Botanics on Jardine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Garden Florist The
Weston ACT 2611
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=5542 or tblfeedback.strbusinessname='Garden Florist The' or tblfeedback.strbusinessname='Garden Florist The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Patricia Rosewarne
Kambah ACT 2902
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=5545 or tblfeedback.strbusinessname='Patricia Rosewarne' or tblfeedback.strbusinessname='Patricia Rosewarne') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fyshwick Florist
Fyshwick ACT 2609
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=19111 or tblfeedback.strbusinessname='Fyshwick Florist' or tblfeedback.strbusinessname='Fyshwick Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Design A Bunch
Canberra City ACT 2601
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=5540 or tblfeedback.strbusinessname='Design A Bunch' or tblfeedback.strbusinessname='Design A Bunch') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Precious Posies
Queanbeyan NSW 2620
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=11043 or tblfeedback.strbusinessname='Precious Posies' or tblfeedback.strbusinessname='Precious Posies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Temple of Blooms Florist
Woden ACT 2606
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=5547 or tblfeedback.strbusinessname='Temple of Blooms Florist' or tblfeedback.strbusinessname='Temple of Blooms Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Champagne Flowers
Flynn ACT 2615
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=5539 or tblfeedback.strbusinessname='Champagne Flowers' or tblfeedback.strbusinessname='Champagne Flowers') 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
Rating
Queanbeyan Flower Shop
Queanbeyan NSW 2620
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=11090 or tblfeedback.strbusinessname='Queanbeyan Flower Shop' or tblfeedback.strbusinessname='Queanbeyan Flower Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Always In Bloom
Murrumbateman NSW 2582
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=18398 or tblfeedback.strbusinessname='Always In Bloom' or tblfeedback.strbusinessname='Always In Bloom') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Southland Flowers
Mawson ACT 2607
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=5546 or tblfeedback.strbusinessname='Southland Flowers' or tblfeedback.strbusinessname='Southland Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Wild Iris
Tuggeranong ACT 2900
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=19232 or tblfeedback.strbusinessname='The Wild Iris' or tblfeedback.strbusinessname='The Wild Iris') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15