Rating
Blush and Ivy
Northfield SA 5085
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=38283 or tblfeedback.strbusinessname='Blush and Ivy' or tblfeedback.strbusinessname='Blush and Ivy') 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
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
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
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
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
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
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
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
Fleur Social
Nurioopta SA 5355
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=38442 or tblfeedback.strbusinessname='Fleur Social' or tblfeedback.strbusinessname='Fleur Social') 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Buds and Blooms Florist
Reynella SA 5161
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=38210 or tblfeedback.strbusinessname='Buds and Blooms Florist' or tblfeedback.strbusinessname='Buds and Blooms Florist') 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
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
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
Petals Plus
Nuriootpa SA 5355
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=5968 or tblfeedback.strbusinessname='Petals Plus' or tblfeedback.strbusinessname='Petals Plus') 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
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
Tea Tree Plus Florist
Modbury SA 5092
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=6061 or tblfeedback.strbusinessname='Tea Tree Plus Florist' or tblfeedback.strbusinessname='Tea Tree Plus 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
Blooms For Brides
Ridgehaven 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=6007 or tblfeedback.strbusinessname='Blooms For Brides' or tblfeedback.strbusinessname='Blooms For Brides') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
House of Quality
Fulham SA 5024
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=6044 or tblfeedback.strbusinessname='House of Quality' or tblfeedback.strbusinessname='House of Quality') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Buds & Blooms
Morphett Vale SA 5162
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=6011 or tblfeedback.strbusinessname='Buds &%%semi%% Blooms' or tblfeedback.strbusinessname='Buds & Blooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Newton Florists
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=5998 or tblfeedback.strbusinessname='A Newton Florists' or tblfeedback.strbusinessname='A Newton Florists') 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
Edwardstown Florists
Edwardstown SA 5039
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=6020 or tblfeedback.strbusinessname='Edwardstown Florists' or tblfeedback.strbusinessname='Edwardstown Florists') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flowers by Ambrosia
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=6029 or tblfeedback.strbusinessname='Flowers by Ambrosia' or tblfeedback.strbusinessname='Flowers by Ambrosia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Prospect Florist
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=5203 or tblfeedback.strbusinessname='Prospect Florist' or tblfeedback.strbusinessname='Prospect Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Beautiful Blooms Florist
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=5997 or tblfeedback.strbusinessname='A Beautiful Blooms Florist' or tblfeedback.strbusinessname='A Beautiful Blooms Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bambacas & Allen Floral Studios
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=6003 or tblfeedback.strbusinessname='Bambacas &%%semi%% Allen Floral Studios' or tblfeedback.strbusinessname='Bambacas & Allen Floral Studios') 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
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
Turnbull's Goodwood Florist
Goodwood SA 5034
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=6065 or tblfeedback.strbusinessname='Turnbull'%%semi%%s Goodwood Florist' or tblfeedback.strbusinessname='Turnbull's Goodwood Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Blooms on The Parade
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=19049 or tblfeedback.strbusinessname='Blooms on The Parade' or tblfeedback.strbusinessname='Blooms on The Parade') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
1 - 50 of 102 Sort search results alphabetically