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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
Regent Flowers
Unley 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=6056 or tblfeedback.strbusinessname='Regent Flowers' or tblfeedback.strbusinessname='Regent 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
Walters Florist
Kensington Park SA 5068
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=6067 or tblfeedback.strbusinessname='Walters Florist' or tblfeedback.strbusinessname='Walters 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
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
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
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
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
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
Merrilyn Stoilov Florist
Seaton 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=19155 or tblfeedback.strbusinessname='Merrilyn Stoilov Florist' or tblfeedback.strbusinessname='Merrilyn Stoilov Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Petal Occasions
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=6055 or tblfeedback.strbusinessname='Petal Occasions' or tblfeedback.strbusinessname='Petal Occasions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flower Gallery
Somerton Park 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=6025 or tblfeedback.strbusinessname='Flower Gallery' or tblfeedback.strbusinessname='Flower Gallery') 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
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
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
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
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
Essential Flowers
HappyValley SA 5159
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=19096 or tblfeedback.strbusinessname='Essential Flowers' or tblfeedback.strbusinessname='Essential Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 103 Sort search results alphabetically