Rating
Cheryl-Lee Florists & Bridal
Innisfail QLD 4860
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=15681 or tblfeedback.strbusinessname='Cheryl-Lee Florists &%%semi%% Bridal' or tblfeedback.strbusinessname='Cheryl-Lee Florists & Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Fiori with Love
Ingham QLD 4850
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=26796 or tblfeedback.strbusinessname='Fiori with Love' or tblfeedback.strbusinessname='Fiori with Love') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Everlasting bouquets by Tarryn
Cannonvale QLD 4802
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=27017 or tblfeedback.strbusinessname='Everlasting bouquets by Tarryn' or tblfeedback.strbusinessname='Everlasting bouquets by Tarryn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Forever After Wedding Flowers
Bundaberg QLD 4670
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=26483 or tblfeedback.strbusinessname='Forever After Wedding Flowers' or tblfeedback.strbusinessname='Forever After Wedding Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Love Them Flowers
Mareeba QLD 4880
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=29592 or tblfeedback.strbusinessname='Love Them Flowers' or tblfeedback.strbusinessname='Love Them Flowers') 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
Blossom Shoppe
Charters Towers QLD 4820
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=26825 or tblfeedback.strbusinessname='Blossom Shoppe' or tblfeedback.strbusinessname='Blossom Shoppe') 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
Flowers 'N' Lace
Cairns QLD 4870
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=15689 or tblfeedback.strbusinessname='Flowers '%%semi%%N'%%semi%% Lace' or tblfeedback.strbusinessname='Flowers 'N' Lace') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
I Do Flowers
Cairns QLD 4870
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=29716 or tblfeedback.strbusinessname='I Do Flowers' or tblfeedback.strbusinessname='I Do Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Spotlight
Townsville QLD 4881
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=29459 or tblfeedback.strbusinessname='Spotlight' or tblfeedback.strbusinessname='Spotlight') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hooked On Wedding Florals
Charters Towers QLD 4820
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=25644 or tblfeedback.strbusinessname='Hooked On Wedding Florals' or tblfeedback.strbusinessname='Hooked On Wedding Florals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Florist Gardens
Cairns QLD 4868
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=27110 or tblfeedback.strbusinessname='Florist Gardens' or tblfeedback.strbusinessname='Florist Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Florrific Flowers
Alligator Creek QLD 4737
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=27103 or tblfeedback.strbusinessname='Florrific Flowers' or tblfeedback.strbusinessname='Florrific Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Debbie's Wedding & Florist Shop
Innisfail QLD 4860
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=29555 or tblfeedback.strbusinessname='Debbie'%%semi%%s Wedding &%%semi%% Florist Shop' or tblfeedback.strbusinessname='Debbie's Wedding & Florist Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Floral Edge
Port Douglas QLD 4877
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=27032 or tblfeedback.strbusinessname='Floral Edge' or tblfeedback.strbusinessname='Floral Edge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Le Sorelle Coffee house & Florist
Bowen QLD 4805
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=23725 or tblfeedback.strbusinessname='Le Sorelle Coffee house &%%semi%% Florist' or tblfeedback.strbusinessname='Le Sorelle Coffee house & Florist') 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
Townsville Flower Market
Townsville QLD 4812
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=23422 or tblfeedback.strbusinessname='Townsville Flower Market' or tblfeedback.strbusinessname='Townsville Flower Market') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blossom Shoppe Charters Towers
Lissner QLD 4820
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=29462 or tblfeedback.strbusinessname='Blossom Shoppe Charters Towers' or tblfeedback.strbusinessname='Blossom Shoppe Charters Towers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Malpara Florist
Hermit Park QLD 4812
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=27598 or tblfeedback.strbusinessname='Malpara Florist' or tblfeedback.strbusinessname='Malpara Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blossom Shoppe
Charters Towers QLD 4820
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=27363 or tblfeedback.strbusinessname='Blossom Shoppe' or tblfeedback.strbusinessname='Blossom Shoppe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Uniquely Made XO
Mareeba QLD 4880
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=27121 or tblfeedback.strbusinessname='Uniquely Made XO' or tblfeedback.strbusinessname='Uniquely Made XO') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Charters Flowers
Charters Towers QLD 4820
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=25559 or tblfeedback.strbusinessname='Charters Flowers' or tblfeedback.strbusinessname='Charters Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ede Events
Hermit Park QLD 4812
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=27133 or tblfeedback.strbusinessname='Ede Events' or tblfeedback.strbusinessname='Ede Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Nine Blooms
Cairns QLD 4870
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=23435 or tblfeedback.strbusinessname='Nine Blooms' or tblfeedback.strbusinessname='Nine Blooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ivory and Twig Flower Hire
Edmonton QLD 4869
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=26046 or tblfeedback.strbusinessname='Ivory and Twig Flower Hire' or tblfeedback.strbusinessname='Ivory and Twig Flower Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Flower Hut
Cannonvale QLD 4802
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=26977 or tblfeedback.strbusinessname='The Flower Hut' or tblfeedback.strbusinessname='The Flower Hut') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stella Florist & Gift Gallery
Westcourt QLD 4870
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=23212 or tblfeedback.strbusinessname='Stella Florist &%%semi%% Gift Gallery' or tblfeedback.strbusinessname='Stella Florist & Gift Gallery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flinders & Mitchell
Julia Creek QLD 4823
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=27240 or tblfeedback.strbusinessname='Flinders &%%semi%% Mitchell' or tblfeedback.strbusinessname='Flinders & Mitchell') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mackay Handmade Wooden Roses
Walkerston QLD 4751
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=24665 or tblfeedback.strbusinessname='Mackay Handmade Wooden Roses' or tblfeedback.strbusinessname='Mackay Handmade Wooden Roses') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Love Them Flowers
Mareeba QLD 4880
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=29199 or tblfeedback.strbusinessname='Love Them Flowers' or tblfeedback.strbusinessname='Love Them Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Townsville Handmade Wooden Roses
Shaw QLD 4818
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=25591 or tblfeedback.strbusinessname='Townsville Handmade Wooden Roses' or tblfeedback.strbusinessname='Townsville Handmade Wooden Roses') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bud 'N' Bloom Florist
Atherton QLD 4883
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=15599 or tblfeedback.strbusinessname='Bud '%%semi%%N'%%semi%% Bloom Florist' or tblfeedback.strbusinessname='Bud 'N' Bloom Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Heaven Scent Flowers & Gifts
Ingham QLD 4850
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=25673 or tblfeedback.strbusinessname='Heaven Scent Flowers &%%semi%% Gifts' or tblfeedback.strbusinessname='Heaven Scent Flowers & Gifts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bloom drop
Port Douglas QLD 4877
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=36287 or tblfeedback.strbusinessname='Bloom drop' or tblfeedback.strbusinessname='Bloom drop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bouquets Forever
Westcourt QLD 4870
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=15597 or tblfeedback.strbusinessname='Bouquets Forever' or tblfeedback.strbusinessname='Bouquets Forever') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Smithfield Centre Florist
Smithfield QLD 4878
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=15663 or tblfeedback.strbusinessname='Smithfield Centre Florist' or tblfeedback.strbusinessname='Smithfield Centre Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Greta Love Flowers N Lace
Cairns QLD 4870
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=18944 or tblfeedback.strbusinessname='Greta Love Flowers N Lace' or tblfeedback.strbusinessname='Greta Love Flowers N Lace') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Central Flower Station
Cairns QLD 4870
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=15608 or tblfeedback.strbusinessname='Central Flower Station' or tblfeedback.strbusinessname='Central Flower Station') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gordonvale Florist & Gift Shop
Gordonvale QLD 4865
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=15635 or tblfeedback.strbusinessname='Gordonvale Florist &%%semi%% Gift Shop' or tblfeedback.strbusinessname='Gordonvale Florist & Gift Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Park Haven Florist
Townsville QLD 4810
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=15583 or tblfeedback.strbusinessname='A Park Haven Florist' or tblfeedback.strbusinessname='A Park Haven Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Designer Florist Roslyn Cook
Cairns QLD 4870
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=15614 or tblfeedback.strbusinessname='Designer Florist Roslyn Cook' or tblfeedback.strbusinessname='Designer Florist Roslyn Cook') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Edmonton Florist & Gifts
Edmonton QLD 4869
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=15616 or tblfeedback.strbusinessname='Edmonton Florist &%%semi%% Gifts' or tblfeedback.strbusinessname='Edmonton Florist & Gifts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Floral Magic
Mareeba QLD 4880
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=15623 or tblfeedback.strbusinessname='Floral Magic' or tblfeedback.strbusinessname='Floral Magic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Living Interiors
Mareeba QLD 4880
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=15650 or tblfeedback.strbusinessname='Living Interiors' or tblfeedback.strbusinessname='Living Interiors') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Country Baskets Florists
Townsville QLD 4810
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=15611 or tblfeedback.strbusinessname='Country Baskets Florists' or tblfeedback.strbusinessname='Country Baskets Florists') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Malpara Florists-Townsville
Townsville QLD 4810
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=15698 or tblfeedback.strbusinessname='Malpara Florists-Townsville' or tblfeedback.strbusinessname='Malpara Florists-Townsville') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chesterfields Florist
Cairns QLD 4870
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=15609 or tblfeedback.strbusinessname='Chesterfields Florist' or tblfeedback.strbusinessname='Chesterfields Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 74 Sort search results alphabetically