Rating
Cinta Home Deco
Ipswich QLD 4305
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=24911 or tblfeedback.strbusinessname='Cinta Home Deco' or tblfeedback.strbusinessname='Cinta Home Deco') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tiffany's Flowers
Maleny QLD 4552
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=27313 or tblfeedback.strbusinessname='Tiffany''s Flowers' or tblfeedback.strbusinessname='Tiffany''s Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flax Flower
Coolum Beach QLD 4573
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=18933 or tblfeedback.strbusinessname='Flax Flower' or tblfeedback.strbusinessname='Flax Flower') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bella Flora
Sippy Downs QLD 4556
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=27224 or tblfeedback.strbusinessname='Bella Flora' or tblfeedback.strbusinessname='Bella Flora') 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
The Orange Blossom
Palmwoods QLD 4558
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=35999 or tblfeedback.strbusinessname='The Orange Blossom' or tblfeedback.strbusinessname='The Orange Blossom') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Maple Flowers and Decor
Coolum Beach QLD 4573
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=35558 or tblfeedback.strbusinessname='Maple Flowers and Decor' or tblfeedback.strbusinessname='Maple Flowers and Decor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Arranged Styling - Kate Tasker
Sunshine Coast QLD 4551
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=37887 or tblfeedback.strbusinessname='Arranged Styling - Kate Tasker' or tblfeedback.strbusinessname='Arranged Styling - Kate Tasker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Karinya Florist
Gympie QLD 4570
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=27184 or tblfeedback.strbusinessname='Karinya Florist' or tblfeedback.strbusinessname='Karinya Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ginger Lily & Rose Floral Studio
Caloundra QLD 4551
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=20287 or tblfeedback.strbusinessname='Ginger Lily &%%semi%% Rose Floral Studio' or tblfeedback.strbusinessname='Ginger Lily & Rose Floral Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bloodwood Botanica
Noosa QLD 4562
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=36012 or tblfeedback.strbusinessname='Bloodwood Botanica' or tblfeedback.strbusinessname='Bloodwood Botanica') 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
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
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
The Posy co
Tanawha QLD 4556
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=35915 or tblfeedback.strbusinessname='The Posy co' or tblfeedback.strbusinessname='The Posy co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bay Flowers and Gifts
Hervey Bay QLD 4655
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=24542 or tblfeedback.strbusinessname='Bay Flowers and Gifts' or tblfeedback.strbusinessname='Bay Flowers and Gifts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Willow Bud
Perwillowen QLD 4560
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=29450 or tblfeedback.strbusinessname='Willow Bud' or tblfeedback.strbusinessname='Willow Bud') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Extra Touch Designs & Hire
Murgon QLD 4605
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=26562 or tblfeedback.strbusinessname='Extra Touch Designs &%%semi%% Hire' or tblfeedback.strbusinessname='Extra Touch Designs & Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Fiesta Flora
Sunshine Coast 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=38427 or tblfeedback.strbusinessname='Fiesta Flora' or tblfeedback.strbusinessname='Fiesta Flora') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tiffany's Flowers
Malaney QLD 4552
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=36291 or tblfeedback.strbusinessname='Tiffany'%%semi%%s Flowers' or tblfeedback.strbusinessname='Tiffany's Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Orange Blossom
Maroochydore QLD 4558
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=22936 or tblfeedback.strbusinessname='The Orange Blossom' or tblfeedback.strbusinessname='The Orange Blossom') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
From the Gardens Bouquet
Imbil QLD 4570
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=21508 or tblfeedback.strbusinessname='From the Gardens Bouquet' or tblfeedback.strbusinessname='From the Gardens Bouquet') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wendy's Flowers and Event Hire
Yandina QLD 4561
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=26628 or tblfeedback.strbusinessname='Wendy'%%semi%%s Flowers and Event Hire' or tblfeedback.strbusinessname='Wendy's Flowers and Event Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jennos florist
Blackbutt QLD 4314
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=37587 or tblfeedback.strbusinessname='Jennos florist' or tblfeedback.strbusinessname='Jennos florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Townsville Wedding Flowers and Designs
Annandale QLD 4614
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=22514 or tblfeedback.strbusinessname='Townsville Wedding Flowers and Designs' or tblfeedback.strbusinessname='Townsville Wedding Flowers and Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
iBlossom Maroochydore
Maroochydore QLD 4558
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=38298 or tblfeedback.strbusinessname='iBlossom Maroochydore' or tblfeedback.strbusinessname='iBlossom Maroochydore') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flowers With Flair
Clear Mountain QLD 4500
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=18939 or tblfeedback.strbusinessname='Flowers With Flair' or tblfeedback.strbusinessname='Flowers With Flair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Val Sparks Caloundra Florist
Caloundra QLD 4551
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=19002 or tblfeedback.strbusinessname='Val Sparks Caloundra Florist' or tblfeedback.strbusinessname='Val Sparks Caloundra Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Minco Flowers
Caloundra QLD 4551
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=15700 or tblfeedback.strbusinessname='Minco Flowers' or tblfeedback.strbusinessname='Minco Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Maroochydore Floral Design Studio
Maroochydore QLD 4558
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=15654 or tblfeedback.strbusinessname='Maroochydore Floral Design Studio' or tblfeedback.strbusinessname='Maroochydore Floral Design Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mooloolaba Florist
Mooloolaba QLD 4557
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=15657 or tblfeedback.strbusinessname='Mooloolaba Florist' or tblfeedback.strbusinessname='Mooloolaba Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bouquet Preservation Forever Blooming
Caboolture QLD 4510
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=15595 or tblfeedback.strbusinessname='Bouquet Preservation Forever Blooming' or tblfeedback.strbusinessname='Bouquet Preservation Forever Blooming') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Floral Whispers
Narangba QLD 4504
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=15624 or tblfeedback.strbusinessname='Floral Whispers' or tblfeedback.strbusinessname='Floral Whispers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gumnut Florist
Morayfield QLD 4506
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=15636 or tblfeedback.strbusinessname='Gumnut Florist' or tblfeedback.strbusinessname='Gumnut Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jane's Bridal Flowers
Diddillibah QLD 4559
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=15641 or tblfeedback.strbusinessname='Jane'%%semi%%s Bridal Flowers' or tblfeedback.strbusinessname='Jane's Bridal Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tricia's Say It With Flowers Florist
Maryborough QLD 4650
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=15671 or tblfeedback.strbusinessname='Tricia'%%semi%%s Say It With Flowers Florist' or tblfeedback.strbusinessname='Tricia's Say It With Flowers Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Buderim Florist
Buderim QLD 4556
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=15600 or tblfeedback.strbusinessname='Buderim Florist' or tblfeedback.strbusinessname='Buderim Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Liz's Blossoms
Landsborough QLD 4550
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=18961 or tblfeedback.strbusinessname='Liz'%%semi%%s Blossoms' or tblfeedback.strbusinessname='Liz's Blossoms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Japata
Gayndah QLD 4625
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=15642 or tblfeedback.strbusinessname='Japata' or tblfeedback.strbusinessname='Japata') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flax Flower
Nambour QLD 4560
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=19006 or tblfeedback.strbusinessname='Flax Flower' or tblfeedback.strbusinessname='Flax Flower') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kawana Florist
Kawana Waters QLD 4575
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=15645 or tblfeedback.strbusinessname='Kawana Florist' or tblfeedback.strbusinessname='Kawana Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kawana Florist
Buddina QLD 4558
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=18956 or tblfeedback.strbusinessname='Kawana Florist' or tblfeedback.strbusinessname='Kawana Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gumnut Florist (Burpengary)
Morayfield QLD 4506
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=15694 or tblfeedback.strbusinessname='Gumnut Florist (%%semi%%Burpengary)%%semi%%' or tblfeedback.strbusinessname='Gumnut Florist (Burpengary)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Blooms of Noosa
Noosa Heads QLD 4567
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=18914 or tblfeedback.strbusinessname='Blooms of Noosa' or tblfeedback.strbusinessname='Blooms of Noosa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Impulse Craft & Variety
Maryborough QLD 4650
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=18950 or tblfeedback.strbusinessname='Impulse Craft &%%semi%% Variety' or tblfeedback.strbusinessname='Impulse Craft & Variety') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coral Orchid Florist
Coolum Beach QLD 4573
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=15682 or tblfeedback.strbusinessname='Coral Orchid Florist' or tblfeedback.strbusinessname='Coral Orchid Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Buderim Floral Art by Marlies
Buderim QLD 4556
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=15679 or tblfeedback.strbusinessname='Buderim Floral Art by Marlies' or tblfeedback.strbusinessname='Buderim Floral Art by Marlies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15