Rating
Pink Tulip
Noarlunga Centre SA 5168
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=29589 or tblfeedback.strbusinessname='Pink Tulip' or tblfeedback.strbusinessname='Pink Tulip') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sugar Pie Honey Bunch Flower Co
Glenelg SA 5045
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=29500 or tblfeedback.strbusinessname='Sugar Pie Honey Bunch Flower Co' or tblfeedback.strbusinessname='Sugar Pie Honey Bunch Flower Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Angelik Blossoms
Adelaide SA 5000
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=26906 or tblfeedback.strbusinessname='Angelik Blossoms' or tblfeedback.strbusinessname='Angelik Blossoms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bloomfields Floral Design
St Agnes SA 5097
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=27025 or tblfeedback.strbusinessname='Bloomfields Floral Design' or tblfeedback.strbusinessname='Bloomfields Floral Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Similpy Sublime Events
Willunga SA 5176
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=37956 or tblfeedback.strbusinessname='Similpy Sublime Events' or tblfeedback.strbusinessname='Similpy Sublime Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
wish
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=29663 or tblfeedback.strbusinessname='wish' or tblfeedback.strbusinessname='wish') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Simply Sublime Events
Willunga SA 5172
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=27677 or tblfeedback.strbusinessname='Simply Sublime Events' or tblfeedback.strbusinessname='Simply Sublime Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bella in Bloom
Salisbury South SA 5106
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=36284 or tblfeedback.strbusinessname='Bella in Bloom' or tblfeedback.strbusinessname='Bella in Bloom') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lily of the Valley flowers
Hope Valley SA 5090
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=26280 or tblfeedback.strbusinessname='Lily of the Valley flowers' or tblfeedback.strbusinessname='Lily of the Valley flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
She Runs Wild
Glengowrie SA 5044
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=37451 or tblfeedback.strbusinessname='She Runs Wild' or tblfeedback.strbusinessname='She Runs Wild') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Wedding & Flower Room
Kidman Park SA 5025
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=20050 or tblfeedback.strbusinessname='The Wedding &%%semi%% Flower Room' or tblfeedback.strbusinessname='The Wedding & Flower Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Amanda's Flowers & Gifts
Blackwood SA 5051
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=6000 or tblfeedback.strbusinessname='Amanda'%%semi%%s Flowers &%%semi%% Gifts' or tblfeedback.strbusinessname='Amanda's Flowers & Gifts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Acacia Art Florist
Port Augusta SA 5700
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=5999 or tblfeedback.strbusinessname='Acacia Art Florist' or tblfeedback.strbusinessname='Acacia Art Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
wish
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=29663 or tblfeedback.strbusinessname='wish' or tblfeedback.strbusinessname='wish') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Muscari Florist
Elizabeth SA 5113
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=26560 or tblfeedback.strbusinessname='Muscari Florist' or tblfeedback.strbusinessname='Muscari Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
In Bloom Adelaide
Adelaide SA 5000
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=22113 or tblfeedback.strbusinessname='In Bloom Adelaide' or tblfeedback.strbusinessname='In Bloom Adelaide') 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
Gawler Flower Gallery
Gawler SA 5118
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=21124 or tblfeedback.strbusinessname='Gawler Flower Gallery' or tblfeedback.strbusinessname='Gawler Flower Gallery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Scented Elegance
Salisbury SA 5108
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=27665 or tblfeedback.strbusinessname='Scented Elegance' or tblfeedback.strbusinessname='Scented Elegance') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blooming Bridal
Mawson Lakes SA 5095
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=29567 or tblfeedback.strbusinessname='Blooming Bridal' or tblfeedback.strbusinessname='Blooming Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Studio Botanic
Adelaide SA 5000
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=24400 or tblfeedback.strbusinessname='Studio Botanic' or tblfeedback.strbusinessname='Studio Botanic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Turquoise Rose
McLaren Vale SA 5171
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=26001 or tblfeedback.strbusinessname='The Turquoise Rose' or tblfeedback.strbusinessname='The Turquoise Rose') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wyld Orchids
Semaphore SA 5015
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=22921 or tblfeedback.strbusinessname='Wyld Orchids' or tblfeedback.strbusinessname='Wyld Orchids') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Botanic Phlox
Warradale SA 5046
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=29467 or tblfeedback.strbusinessname='Botanic Phlox' or tblfeedback.strbusinessname='Botanic Phlox') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flowers by Alice
Highgate SA 5064
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=29381 or tblfeedback.strbusinessname='Flowers by Alice' or tblfeedback.strbusinessname='Flowers by Alice') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Send A Basket
Unley SA 5061
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=6058 or tblfeedback.strbusinessname='Send A Basket' or tblfeedback.strbusinessname='Send A Basket') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flower Celebrations
Beaumont SA 5066
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=6023 or tblfeedback.strbusinessname='Flower Celebrations' or tblfeedback.strbusinessname='Flower Celebrations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flowers of Adelaide
Torrensville SA 5031
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=6033 or tblfeedback.strbusinessname='Flowers of Adelaide' or tblfeedback.strbusinessname='Flowers of Adelaide') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Salisbury Highway House of Flowers
Salisbury Downs SA 5108
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=6057 or tblfeedback.strbusinessname='Salisbury Highway House of Flowers' or tblfeedback.strbusinessname='Salisbury Highway House of Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Emerald Florist
Paralowie SA 5108
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=6021 or tblfeedback.strbusinessname='Emerald Florist' or tblfeedback.strbusinessname='Emerald Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lisa's Florist
Maylands SA 5069
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=6049 or tblfeedback.strbusinessname='Lisa'%%semi%%s Florist' or tblfeedback.strbusinessname='Lisa's Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hedgerow Flowers
Hyde Park SA 5061
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=6043 or tblfeedback.strbusinessname='Hedgerow Flowers' or tblfeedback.strbusinessname='Hedgerow Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Georgies Gift Baskets & Flowers
Lockleys SA 5032
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=6037 or tblfeedback.strbusinessname='Georgies Gift Baskets &%%semi%% Flowers' or tblfeedback.strbusinessname='Georgies Gift Baskets & Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lollipop Trees
Fullarton SA 5063
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=6050 or tblfeedback.strbusinessname='Lollipop Trees' or tblfeedback.strbusinessname='Lollipop Trees') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Silk Flower Creations
Pooraka SA 5095
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=6059 or tblfeedback.strbusinessname='Silk Flower Creations' or tblfeedback.strbusinessname='Silk Flower Creations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Glynde Florist
Glynde SA 5070
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=6039 or tblfeedback.strbusinessname='Glynde Florist' or tblfeedback.strbusinessname='Glynde Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jenevis House of Flowers
Prospect SA 5082
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=6046 or tblfeedback.strbusinessname='Jenevis House of Flowers' or tblfeedback.strbusinessname='Jenevis House of Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Poppies Florist
Glen Osmond SA 5064
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=19174 or tblfeedback.strbusinessname='Poppies Florist' or tblfeedback.strbusinessname='Poppies Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flowers on the Terrace
Walkerville SA 5081
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=6034 or tblfeedback.strbusinessname='Flowers on the Terrace' or tblfeedback.strbusinessname='Flowers on the Terrace') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goodie Baskets & Flowers
Adelaide SA 5000
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=6042 or tblfeedback.strbusinessname='Goodie Baskets &%%semi%% Flowers' or tblfeedback.strbusinessname='Goodie Baskets & Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Georgies Gift Baskets & Flowers
Adelaide SA 5032
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=19112 or tblfeedback.strbusinessname='Georgies Gift Baskets &%%semi%% Flowers' or tblfeedback.strbusinessname='Georgies Gift Baskets & Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Newton Florist
Firle SA 5070
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=19160 or tblfeedback.strbusinessname='Newton Florist' or tblfeedback.strbusinessname='Newton Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flower Delights Gawler Barossa Florist
Gawler SA 5118
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=6024 or tblfeedback.strbusinessname='Flower Delights Gawler Barossa Florist' or tblfeedback.strbusinessname='Flower Delights Gawler Barossa Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Campbelltown Flowers & Baskets
Campbelltown SA 5074
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=6013 or tblfeedback.strbusinessname='Campbelltown Flowers &%%semi%% Baskets' or tblfeedback.strbusinessname='Campbelltown Flowers & Baskets') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coco Floral Design
Rose Park SA 5067
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=6014 or tblfeedback.strbusinessname='Coco Floral Design' or tblfeedback.strbusinessname='Coco Floral Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gallerie Florist
Adelaide SA 5000
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=6035 or tblfeedback.strbusinessname='Gallerie Florist' or tblfeedback.strbusinessname='Gallerie Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flower Room The
Eastwood SA 5063
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=6026 or tblfeedback.strbusinessname='Flower Room The' or tblfeedback.strbusinessname='Flower Room The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wedding Petals
Norwood SA 5067
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=6068 or tblfeedback.strbusinessname='Wedding Petals' or tblfeedback.strbusinessname='Wedding Petals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bay Blooms
Glenelg SA 5045
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=6005 or tblfeedback.strbusinessname='Bay Blooms' or tblfeedback.strbusinessname='Bay Blooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 99 Sort search results alphabetically