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.
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
The Lazy Flamingo Flower Co
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=27383 or tblfeedback.strbusinessname='The Lazy Flamingo Flower Co' or tblfeedback.strbusinessname='The Lazy Flamingo Flower Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Secret Creek cafe
Lithgow NSW 2790
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=26071 or tblfeedback.strbusinessname='Secret Creek cafe' or tblfeedback.strbusinessname='Secret Creek cafe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Brushwood 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=41060 or tblfeedback.strbusinessname='Brushwood Floral Design' or tblfeedback.strbusinessname='Brushwood Floral Design') 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
Victoria's Blooms
Hassall Grove NSW 2761
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=36190 or tblfeedback.strbusinessname='Victoria'%%semi%%s Blooms' or tblfeedback.strbusinessname='Victoria's Blooms') 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
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
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
Gather Store
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=41340 or tblfeedback.strbusinessname='Gather Store' or tblfeedback.strbusinessname='Gather Store') 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
Passion for Flowers
Chipping Norton NSW 2170
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=25940 or tblfeedback.strbusinessname='Passion for Flowers' or tblfeedback.strbusinessname='Passion for Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Violet Lane Flowers
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=27149 or tblfeedback.strbusinessname='Violet Lane Flowers' or tblfeedback.strbusinessname='Violet Lane Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kaberlea
Wentworth Point NSW 2127
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=29272 or tblfeedback.strbusinessname='Kaberlea' or tblfeedback.strbusinessname='Kaberlea') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lib's 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=27160 or tblfeedback.strbusinessname='Lib'%%semi%%s Little Studio' or tblfeedback.strbusinessname='Lib's Little Studio') 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
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
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
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
Lucia Kos 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=29141 or tblfeedback.strbusinessname='Lucia Kos Floral Design' or tblfeedback.strbusinessname='Lucia Kos Floral Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
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
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
Danika Bell - Florist
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=22089 or tblfeedback.strbusinessname='Danika Bell - Florist' or tblfeedback.strbusinessname='Danika Bell - 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
The Ivy League
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=27867 or tblfeedback.strbusinessname='The Ivy League' or tblfeedback.strbusinessname='The Ivy League') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
Abelia Florist
Bonnyrigg NSW 2177
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=38365 or tblfeedback.strbusinessname='Abelia Florist' or tblfeedback.strbusinessname='Abelia Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Trille Floral
Enmore NSW 2043
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=28973 or tblfeedback.strbusinessname='Trille Floral' or tblfeedback.strbusinessname='Trille Floral') 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
The Flower Posse
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=41082 or tblfeedback.strbusinessname='The Flower Posse' or tblfeedback.strbusinessname='The Flower Posse') 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
Wow Flowers
Singleton NSW 2330
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=23700 or tblfeedback.strbusinessname='Wow Flowers' or tblfeedback.strbusinessname='Wow Flowers') 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
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
Sweet Pea and Honey Bee
Annandale NSW 2038
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=38580 or tblfeedback.strbusinessname='Sweet Pea and Honey Bee' or tblfeedback.strbusinessname='Sweet Pea and Honey Bee') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Decorations by Jelena
Sydney 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=27759 or tblfeedback.strbusinessname='Decorations by Jelena' or tblfeedback.strbusinessname='Decorations by Jelena') 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
Two Hearts Club
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=35919 or tblfeedback.strbusinessname='Two Hearts Club' or tblfeedback.strbusinessname='Two Hearts Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Blaxland Blooms
Blaxland NSW 2774
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=27348 or tblfeedback.strbusinessname='Blaxland Blooms' or tblfeedback.strbusinessname='Blaxland Blooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lovely Bridal Blooms
Wilberforce NSW 2756
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=23168 or tblfeedback.strbusinessname='Lovely Bridal Blooms' or tblfeedback.strbusinessname='Lovely Bridal Blooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Blooms & Scents Floral Studio
Kingswood NSW 2747
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=26120 or tblfeedback.strbusinessname='Blooms &%%semi%% Scents Floral Studio' or tblfeedback.strbusinessname='Blooms & Scents Floral Studio') 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