Rating
Found in Earth
Deloraine TAS 7304
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=25869 or tblfeedback.strbusinessname='Found in Earth' or tblfeedback.strbusinessname='Found in Earth') 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
Wedding flowers Stanley
Stanley TAS 7331
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=24969 or tblfeedback.strbusinessname='Wedding flowers Stanley' or tblfeedback.strbusinessname='Wedding flowers Stanley') 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
Bouquet Florist
Burnie TAS 7320
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=27942 or tblfeedback.strbusinessname='Bouquet Florist' or tblfeedback.strbusinessname='Bouquet Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Bouquet Florist
Burnie TAS 7320
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=27893 or tblfeedback.strbusinessname='The Bouquet Florist' or tblfeedback.strbusinessname='The Bouquet Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Spoil Me Gifts and Flowers
Burnie TAS 7320
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=26979 or tblfeedback.strbusinessname='Spoil Me Gifts and Flowers' or tblfeedback.strbusinessname='Spoil Me Gifts and Flowers') 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 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
Flower Gallery Burnie
Burnie TAS 7320
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=27398 or tblfeedback.strbusinessname='Flower Gallery Burnie' or tblfeedback.strbusinessname='Flower Gallery Burnie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flowers on Gilbert
Latrobe TAS 7307
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=22311 or tblfeedback.strbusinessname='Flowers on Gilbert' or tblfeedback.strbusinessname='Flowers on Gilbert') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hillstreet Grocer
Devonport TAS 7310
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=29232 or tblfeedback.strbusinessname='Hillstreet Grocer' or tblfeedback.strbusinessname='Hillstreet Grocer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Francie's Flowers
Deloraine TAS 7304
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=5425 or tblfeedback.strbusinessname='Francie'%%semi%%s Flowers' or tblfeedback.strbusinessname='Francie's Flowers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Forget-Me-Not Cottage
Somerset TAS 7322
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=5258 or tblfeedback.strbusinessname='Forget-Me-Not Cottage' or tblfeedback.strbusinessname='Forget-Me-Not Cottage') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Green 'N' Gorgeous
Devonport TAS 7310
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=5260 or tblfeedback.strbusinessname='Green '%%semi%%N'%%semi%% Gorgeous' or tblfeedback.strbusinessname='Green 'N' Gorgeous') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Green N Gorgeous
Devonport TAS 7310
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=19118 or tblfeedback.strbusinessname='Green N Gorgeous' or tblfeedback.strbusinessname='Green N Gorgeous') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating