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
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Mary Mays Flower Shop
Seaford SA 5169
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=6051 or tblfeedback.strbusinessname='Mary Mays Flower Shop' or tblfeedback.strbusinessname='Mary Mays Flower Shop') 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
Divine 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=6019 or tblfeedback.strbusinessname='Divine Flowers' or tblfeedback.strbusinessname='Divine Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
Bouquets Preserved by Sandra
Fairview Park SA 5126
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=6009 or tblfeedback.strbusinessname='Bouquets Preserved by Sandra' or tblfeedback.strbusinessname='Bouquets Preserved by Sandra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Isis Flowers
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=19136 or tblfeedback.strbusinessname='Isis Flowers' or tblfeedback.strbusinessname='Isis Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
Treasured Thoughts
Trott Park SA 5158
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=6063 or tblfeedback.strbusinessname='Treasured Thoughts' or tblfeedback.strbusinessname='Treasured Thoughts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Burnside V I P Flowers
Tusmore 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=6012 or tblfeedback.strbusinessname='Burnside V I P Flowers' or tblfeedback.strbusinessname='Burnside V I P Flowers') 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
Tuni Floral Designer
Marino SA 5049
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=6064 or tblfeedback.strbusinessname='Tuni Floral Designer' or tblfeedback.strbusinessname='Tuni Floral Designer') 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
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
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
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
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
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
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
1 - 50 of 101 Sort search results alphabetically