Antique Rose Florist
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=18400 or tblfeedback.strbusinessname='Antique Rose Florist' or tblfeedback.strbusinessname='Antique Rose Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Antique Rose Florist with over 20 years experience will design for you a presentation you will be proud of.We cover all floral stages of your special day. Free bridal throw away also provided.We have access to the best flower growers in the country so
Brides in Bloom
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=18410 or tblfeedback.strbusinessname='Brides in Bloom' or tblfeedback.strbusinessname='Brides in Bloom') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
We create gorgeous bridal bouquets, ceremony displays, reception flowers, and fabulous cakes to take your breath away.
Flowers by Helen Brown
Ermington NSW 2115
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=22673 or tblfeedback.strbusinessname='Flowers by Helen Brown' or tblfeedback.strbusinessname='Flowers by Helen Brown') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Pia+Jade
Nowra NSW 2541
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=43261 or tblfeedback.strbusinessname='Pia+%%semi%%Jade' or tblfeedback.strbusinessname='Pia+Jade') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Make Haus
Manly NSW 2095
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=35859 or tblfeedback.strbusinessname='The Make Haus' or tblfeedback.strbusinessname='The Make Haus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Camden Florist
Camden NSW 2570
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=39895 or tblfeedback.strbusinessname='Camden Florist' or tblfeedback.strbusinessname='Camden Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Best Buds
Chippendale NSW 2008
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=30256 or tblfeedback.strbusinessname='Best Buds' or tblfeedback.strbusinessname='Best Buds') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Clementine & Rose
Epping NSW 2121
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=29584 or tblfeedback.strbusinessname='Clementine &%%semi%% Rose' or tblfeedback.strbusinessname='Clementine & Rose') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Georgia Floral Stylist
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=29744 or tblfeedback.strbusinessname='Georgia Floral Stylist' or tblfeedback.strbusinessname='Georgia Floral Stylist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Aleksandra
Dural NSW 2158
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=27672 or tblfeedback.strbusinessname='Aleksandra' or tblfeedback.strbusinessname='Aleksandra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Libs Little Studio
Thirlmere NSW 2572
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=38157 or tblfeedback.strbusinessname='Libs Little Studio' or tblfeedback.strbusinessname='Libs Little Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Inspired by Happiness
Parramatta NSW 2150
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=25659 or tblfeedback.strbusinessname='Inspired by Happiness' or tblfeedback.strbusinessname='Inspired by Happiness') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lost in Emerald Floral Design
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=41494 or tblfeedback.strbusinessname='Lost in Emerald Floral Design' or tblfeedback.strbusinessname='Lost in Emerald Floral Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Willow and Bear
Sydney NSW 2230
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=43047 or tblfeedback.strbusinessname='Willow and Bear' or tblfeedback.strbusinessname='Willow and Bear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wedding Flowers By Jody
Blacktown NSW 2148
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=26784 or tblfeedback.strbusinessname='Wedding Flowers By Jody' or tblfeedback.strbusinessname='Wedding Flowers By Jody') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Petal Met Sugar
Woolloomooloo NSW 2011
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=41345 or tblfeedback.strbusinessname='Petal Met Sugar' or tblfeedback.strbusinessname='Petal Met Sugar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Let Life Sparkle
Wetherill Park NSW 2164
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=25863 or tblfeedback.strbusinessname='Let Life Sparkle' or tblfeedback.strbusinessname='Let Life Sparkle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wish Sydney
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=36174 or tblfeedback.strbusinessname='Wish Sydney' or tblfeedback.strbusinessname='Wish Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Green Seed Camden
Camden NSW 2570
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=43135 or tblfeedback.strbusinessname='The Green Seed Camden' or tblfeedback.strbusinessname='The Green Seed Camden') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Gather Australia
Currumbin Waters QLD 4223
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=46003 or tblfeedback.strbusinessname='Gather Australia' or tblfeedback.strbusinessname='Gather Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rosemerin
Armidale NSW 2350
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=18456 or tblfeedback.strbusinessname='Rosemerin' or tblfeedback.strbusinessname='Rosemerin') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Urban Flower
Concord NSW 2137
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=27616 or tblfeedback.strbusinessname='Urban Flower' or tblfeedback.strbusinessname='Urban Flower') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wildflower Styling
Camden NSW 2570
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=25829 or tblfeedback.strbusinessname='Wildflower Styling' or tblfeedback.strbusinessname='Wildflower Styling') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
So Daisy Flowers
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=27959 or tblfeedback.strbusinessname='So Daisy Flowers' or tblfeedback.strbusinessname='So Daisy Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Knot & Beau
Narellan NSW 2567
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=46789 or tblfeedback.strbusinessname='Knot &%%semi%% Beau' or tblfeedback.strbusinessname='Knot & Beau ') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sierra Blooms Floral Design
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=24905 or tblfeedback.strbusinessname='Sierra Blooms Floral Design' or tblfeedback.strbusinessname='Sierra Blooms Floral Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lime Tree Bower
Roseville NSW 2069
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=37739 or tblfeedback.strbusinessname='Lime Tree Bower' or tblfeedback.strbusinessname='Lime Tree Bower') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Nature Reflections
Mortdale NSW 2223
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=25181 or tblfeedback.strbusinessname='Nature Reflections' or tblfeedback.strbusinessname='Nature Reflections') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Pink Orchid
Parkes NSW 2870
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=36145 or tblfeedback.strbusinessname='Pink Orchid' or tblfeedback.strbusinessname='Pink Orchid') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
El Khair Florist
Punchbowl NSW 2196
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=37553 or tblfeedback.strbusinessname='El Khair Florist' or tblfeedback.strbusinessname='El Khair Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A & L Florist
Bossley Park NSW 2176
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=26080 or tblfeedback.strbusinessname='A &%%semi%% L Florist' or tblfeedback.strbusinessname='A & L Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
John Emmanuel Floral Events
St Wetherill Park NSW 2164
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=24453 or tblfeedback.strbusinessname='John Emmanuel Floral Events' or tblfeedback.strbusinessname='John Emmanuel Floral Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Aisle of Eden
Kurnell NSW 2231
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=26588 or tblfeedback.strbusinessname='Aisle of Eden' or tblfeedback.strbusinessname='Aisle of Eden') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The styled bouquet by Michelle Baerken
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=44677 or tblfeedback.strbusinessname='The styled bouquet by Michelle Baerken' or tblfeedback.strbusinessname='The styled bouquet by Michelle Baerken') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sarah Jay & Co
Smeaton Grange NSW 2567
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=29849 or tblfeedback.strbusinessname='Sarah Jay &%%semi%% Co' or tblfeedback.strbusinessname='Sarah Jay & Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mona Vale Florist and Nursery
Mona Vale NSW 2103
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=26963 or tblfeedback.strbusinessname='Mona Vale Florist and Nursery' or tblfeedback.strbusinessname='Mona Vale Florist and Nursery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Clementine Posy
Camden NSW 2570
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=39809 or tblfeedback.strbusinessname='Clementine Posy' or tblfeedback.strbusinessname='Clementine Posy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Floral Events By Sahar
Horningsea Park NSW 2171
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=44118 or tblfeedback.strbusinessname='Floral Events By Sahar' or tblfeedback.strbusinessname='Floral Events By Sahar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Fabled Florette
St Peters ACT 2044
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=40995 or tblfeedback.strbusinessname='The Fabled Florette' or tblfeedback.strbusinessname='The Fabled Florette') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Wildflower Workroom
Sydney Hills 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=35630 or tblfeedback.strbusinessname='The Wildflower Workroom' or tblfeedback.strbusinessname='The Wildflower Workroom') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Fine Flowers Katoomba
Katoomba NSW 2780
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=41144 or tblfeedback.strbusinessname='Fine Flowers Katoomba' or tblfeedback.strbusinessname='Fine Flowers Katoomba') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
5th Ave Florist
Kearns NSW 2560
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=27195 or tblfeedback.strbusinessname='5th Ave Florist' or tblfeedback.strbusinessname='5th Ave Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Flowers by Florry
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=44522 or tblfeedback.strbusinessname='Flowers by Florry' or tblfeedback.strbusinessname='Flowers by Florry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Melissa Dcruz Floral
Seven Hills NSW 2147
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=45861 or tblfeedback.strbusinessname='Melissa Dcruz Floral' or tblfeedback.strbusinessname='Melissa Dcruz Floral') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Parks & Fields Florist
Wetherill Park NSW 2164
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=25595 or tblfeedback.strbusinessname='Parks &%%semi%% Fields Florist' or tblfeedback.strbusinessname='Parks & Fields Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Merci Bouquet
Bowral NSW 2576
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=22423 or tblfeedback.strbusinessname='Merci Bouquet' or tblfeedback.strbusinessname='Merci Bouquet') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Admire Florist & Gifts
Bexley North ACT 2207
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=41416 or tblfeedback.strbusinessname='Admire Florist &%%semi%% Gifts' or tblfeedback.strbusinessname='Admire Florist & Gifts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Flowers By Emma
Berrima NSW 2577
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=25138 or tblfeedback.strbusinessname='Flowers By Emma' or tblfeedback.strbusinessname='Flowers By Emma') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Little Willow Floral Design
Berkely Vale NSW 2261
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=38295 or tblfeedback.strbusinessname='Little Willow Floral Design' or tblfeedback.strbusinessname='Little Willow Floral Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Flowers with Elegance
Concord NSW 2137
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=38358 or tblfeedback.strbusinessname='Flowers with Elegance' or tblfeedback.strbusinessname='Flowers with Elegance') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15