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
Daisy Girls
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=44410 or tblfeedback.strbusinessname='Daisy Girls' or tblfeedback.strbusinessname='Daisy Girls') 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
Ginger Says
Gladstone QLD 4680
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=25587 or tblfeedback.strbusinessname='Ginger Says' or tblfeedback.strbusinessname='Ginger Says') 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
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
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
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
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
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 Cottage
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=44234 or tblfeedback.strbusinessname='The Flower Cottage' or tblfeedback.strbusinessname='The Flower Cottage') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Wilds
Marrickville NSW 2204
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=29304 or tblfeedback.strbusinessname='The Wilds' or tblfeedback.strbusinessname='The Wilds') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bella Fiore Floral Designs Australia
Castle Hill NSW 2154
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=23060 or tblfeedback.strbusinessname='Bella Fiore Floral Designs Australia' or tblfeedback.strbusinessname='Bella Fiore Floral Designs Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Just Fake It Bouquets
Mt Annan 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=21707 or tblfeedback.strbusinessname='Just Fake It Bouquets' or tblfeedback.strbusinessname='Just Fake It Bouquets') 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
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
Taylor Made Bouquets - Wedding Flowers
Wollongong NSW 2500
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=43430 or tblfeedback.strbusinessname='Taylor Made Bouquets - Wedding Flowers' or tblfeedback.strbusinessname='Taylor Made Bouquets - Wedding Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Pick me flowers
Orange NSW 2800
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=36101 or tblfeedback.strbusinessname='Pick me flowers' or tblfeedback.strbusinessname='Pick me flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
White House flowers
Brookvale NSW 2099
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=43787 or tblfeedback.strbusinessname='White House flowers' or tblfeedback.strbusinessname='White House flowers') 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
Just for my little love
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=43556 or tblfeedback.strbusinessname='Just for my little love' or tblfeedback.strbusinessname='Just for my little love') 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
Sis florist
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=45997 or tblfeedback.strbusinessname='Sis florist' or tblfeedback.strbusinessname='Sis 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
Petal & Pod
Wahroonga NSW 2076
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=25871 or tblfeedback.strbusinessname='Petal &%%semi%% Pod' or tblfeedback.strbusinessname='Petal & Pod') 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
Pia & Jade
Canberra ACT 2600
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=46771 or tblfeedback.strbusinessname='Pia &%%semi%% Jade' or tblfeedback.strbusinessname='Pia & Jade') 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
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
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
Burlap Bouquet
Bathurst NSW 2795
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=24484 or tblfeedback.strbusinessname='Burlap Bouquet' or tblfeedback.strbusinessname='Burlap 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Copper Beech
Balgowlah NSW 2093
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=27878 or tblfeedback.strbusinessname='Copper Beech' or tblfeedback.strbusinessname='Copper Beech') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15