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
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
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
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
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
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
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
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
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
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
Honey Bee Blooms at Red Earth Studio
Balhannah SA 5242
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=39822 or tblfeedback.strbusinessname='Honey Bee Blooms at Red Earth Studio' or tblfeedback.strbusinessname='Honey Bee Blooms at Red Earth Studio') 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Bridal Creations by Julie
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=6010 or tblfeedback.strbusinessname='Bridal Creations by Julie' or tblfeedback.strbusinessname='Bridal Creations by Julie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Golden Ridge Flowers
Erindale 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=6040 or tblfeedback.strbusinessname='Golden Ridge Flowers' or tblfeedback.strbusinessname='Golden Ridge Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wedding Bunches and Blooms Online Shop
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=19240 or tblfeedback.strbusinessname='Wedding Bunches and Blooms Online Shop' or tblfeedback.strbusinessname='Wedding Bunches and Blooms Online Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dial-A-Basket
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=6018 or tblfeedback.strbusinessname='Dial-A-Basket' or tblfeedback.strbusinessname='Dial-A-Basket') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Blu Tulip
Findon SA 5023
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=19220 or tblfeedback.strbusinessname='The Blu Tulip' or tblfeedback.strbusinessname='The Blu Tulip') 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
Tizianas Floral Studio Design
Linden Park SA 5065
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=6062 or tblfeedback.strbusinessname='Tizianas Floral Studio Design' or tblfeedback.strbusinessname='Tizianas Floral Studio Design') 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
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
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
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
A Bay Bridal
Brighton SA 5048
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=5996 or tblfeedback.strbusinessname='A Bay Bridal' or tblfeedback.strbusinessname='A Bay Bridal') 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
Amici Flowers
Felixstow 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=6001 or tblfeedback.strbusinessname='Amici Flowers' or tblfeedback.strbusinessname='Amici Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
Flowers by Grace
Beverley SA 5009
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=6030 or tblfeedback.strbusinessname='Flowers by Grace' or tblfeedback.strbusinessname='Flowers by Grace') 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
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
1 - 50 of 103 Sort search results alphabetically