The Pouch Place
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=20165 or tblfeedback.strbusinessname='The Pouch Place' or tblfeedback.strbusinessname='The Pouch Place') and year(getdate())-year(dtmadded)<=15
Organza Bags, Satin Bags & Tulle circles.
Pink Frosting
35 Whyalla Street Fyshwick ACT 2609
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=20212 or tblfeedback.strbusinessname='Pink Frosting' or tblfeedback.strbusinessname='Pink Frosting') and year(getdate())-year(dtmadded)<=15
The Wedding Traders
First Ave Rodd Point NSW 2046
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=26251 or tblfeedback.strbusinessname='The Wedding Traders' or tblfeedback.strbusinessname='The Wedding Traders') and year(getdate())-year(dtmadded)<=15
Natasha Bloom Floristry
Adelaide SA 5000
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=26546 or tblfeedback.strbusinessname='Natasha Bloom Floristry' or tblfeedback.strbusinessname='Natasha Bloom Floristry') and year(getdate())-year(dtmadded)<=15
Starlight Childrens Foundation
l5/658 Church St Richmond VIC 3121
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=26611 or tblfeedback.strbusinessname='Starlight Childrens Foundation' or tblfeedback.strbusinessname='Starlight Childrens Foundation') and year(getdate())-year(dtmadded)<=15
Unique Living Gifts
Adelaide SA 5000
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=27335 or tblfeedback.strbusinessname='Unique Living Gifts' or tblfeedback.strbusinessname='Unique Living Gifts') and year(getdate())-year(dtmadded)<=15
Starlight Foundation
Sydney VIC 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=27745 or tblfeedback.strbusinessname='Starlight Foundation' or tblfeedback.strbusinessname='Starlight Foundation') and year(getdate())-year(dtmadded)<=15
Wine Jeanie
Morphett Vale SA 5162
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=29501 or tblfeedback.strbusinessname='Wine Jeanie' or tblfeedback.strbusinessname='Wine Jeanie') and year(getdate())-year(dtmadded)<=15
The Wedding Traders
First Ave Rodd Point NSW 2046
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=26251 or tblfeedback.strbusinessname='The Wedding Traders' or tblfeedback.strbusinessname='The Wedding Traders') and year(getdate())-year(dtmadded)<=15
Starlight Childrens Foundation
l5/658 Church St Richmond VIC 3121
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=26611 or tblfeedback.strbusinessname='Starlight Childrens Foundation' or tblfeedback.strbusinessname='Starlight Childrens Foundation') and year(getdate())-year(dtmadded)<=15
Pink Frosting
35 Whyalla Street Fyshwick ACT 2609
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=20212 or tblfeedback.strbusinessname='Pink Frosting' or tblfeedback.strbusinessname='Pink Frosting') and year(getdate())-year(dtmadded)<=15
Personalisedfavours.com.au
West Gosford NSW 2250
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=22032 or tblfeedback.strbusinessname='Personalisedfavours.com.au' or tblfeedback.strbusinessname='Personalisedfavours.com.au') and year(getdate())-year(dtmadded)<=15
Irene's Soap Pantry
1 Oldbury Court Wattle Grove NSW 2173
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=22536 or tblfeedback.strbusinessname='Irene'%%semi%%s Soap Pantry' or tblfeedback.strbusinessname='Irene's Soap Pantry') and year(getdate())-year(dtmadded)<=15
Starlight Foundation
Sydney VIC 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=27745 or tblfeedback.strbusinessname='Starlight Foundation' or tblfeedback.strbusinessname='Starlight Foundation') and year(getdate())-year(dtmadded)<=15
Cocolat
3/160 King William Road Hyde Park SA 5061
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=18 or tblfeedback.strbusinessname='Cocolat' or tblfeedback.strbusinessname='Cocolat') and year(getdate())-year(dtmadded)<=15
Adelaide Chocolate Factory
Happy Valley SA 5159
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=5677 or tblfeedback.strbusinessname='Adelaide Chocolate Factory' or tblfeedback.strbusinessname='Adelaide Chocolate Factory') and year(getdate())-year(dtmadded)<=15
Belle Bomboniere
305 Payneham Road Royston Park SA 5070
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=5678 or tblfeedback.strbusinessname='Belle Bomboniere' or tblfeedback.strbusinessname='Belle Bomboniere') and year(getdate())-year(dtmadded)<=15
Cherish Designs Giftware & Bomboniere
Modbury Heights SA 5092
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=5679 or tblfeedback.strbusinessname='Cherish Designs Giftware &%%semi%% Bomboniere' or tblfeedback.strbusinessname='Cherish Designs Giftware & Bomboniere') and year(getdate())-year(dtmadded)<=15
Cocolat
447 Portrush Road
<BR>Burnside Village Food Mall Glenside SA 5065
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=5680 or tblfeedback.strbusinessname='Cocolat' or tblfeedback.strbusinessname='Cocolat') and year(getdate())-year(dtmadded)<=15
Elite Chocolates
PO Box 87 Glenelg SA 5045
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=5682 or tblfeedback.strbusinessname='Elite Chocolates' or tblfeedback.strbusinessname='Elite Chocolates') and year(getdate())-year(dtmadded)<=15
Giftables
Evandale SA 5069
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=5683 or tblfeedback.strbusinessname='Giftables' or tblfeedback.strbusinessname='Giftables') and year(getdate())-year(dtmadded)<=15
Im-Press Promotions Unley
Unley SA 5061
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=5684 or tblfeedback.strbusinessname='Im-Press Promotions Unley' or tblfeedback.strbusinessname='Im-Press Promotions Unley') and year(getdate())-year(dtmadded)<=15
Lovely Weddings & Gifts
273A Marion Road Plympton North SA 5037
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=5687 or tblfeedback.strbusinessname='Lovely Weddings &%%semi%% Gifts' or tblfeedback.strbusinessname='Lovely Weddings & Gifts') and year(getdate())-year(dtmadded)<=15
Parthenon Emporium
149 Henley Beach Road Mile End SA 5031
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=5689 or tblfeedback.strbusinessname='Parthenon Emporium' or tblfeedback.strbusinessname='Parthenon Emporium') and year(getdate())-year(dtmadded)<=15
Planetary Chocolates
Holden Hill SA 5088
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=5690 or tblfeedback.strbusinessname='Planetary Chocolates' or tblfeedback.strbusinessname='Planetary Chocolates') and year(getdate())-year(dtmadded)<=15
Total Indulgence
Happy Valley SA 5159
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=5691 or tblfeedback.strbusinessname='Total Indulgence' or tblfeedback.strbusinessname='Total Indulgence') and year(getdate())-year(dtmadded)<=15
Traditions by Suzie
Mawson Lakes SA 5095
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=5692 or tblfeedback.strbusinessname='Traditions by Suzie' or tblfeedback.strbusinessname='Traditions by Suzie') and year(getdate())-year(dtmadded)<=15
Giftables
54 Payneham Road Stephney SA 5069
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=19113 or tblfeedback.strbusinessname='Giftables' or tblfeedback.strbusinessname='Giftables') and year(getdate())-year(dtmadded)<=15
