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=36174 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
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=36174 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
T & M Weddings Events and Special Occasions
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=27505 or tblfeedback.strbusinessname='T &%%semi%% M Weddings Events and Special Occasions' or tblfeedback.strbusinessname='T & M Weddings Events and Special Occasions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gracious Mae Gifts and Hire
Smithton TAS 7330
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=25285 or tblfeedback.strbusinessname='Gracious Mae Gifts and Hire' or tblfeedback.strbusinessname='Gracious Mae Gifts and Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Air Liquide Australia Ltd
Invermay TAS 7248
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=5423 or tblfeedback.strbusinessname='Air Liquide Australia Ltd' or tblfeedback.strbusinessname='Air Liquide Australia Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Balloon Saloon
Exeter TAS 7275
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=5426 or tblfeedback.strbusinessname='Balloon Saloon' or tblfeedback.strbusinessname='Balloon Saloon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Launceston Linen Service
Kings Meadows TAS 7249
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=5431 or tblfeedback.strbusinessname='Launceston Linen Service' or tblfeedback.strbusinessname='Launceston Linen Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Balloonland
Launceston TAS 7250
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=5422 or tblfeedback.strbusinessname='Balloonland' or tblfeedback.strbusinessname='Balloonland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
BOC
Launceston TAS 7250
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=5420 or tblfeedback.strbusinessname='BOC' or tblfeedback.strbusinessname='BOC') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Florist
Launceston TAS 7250
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=5421 or tblfeedback.strbusinessname='Florist' or tblfeedback.strbusinessname='Florist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Premier Goodwill Products
Launceston TAS 7250
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=5419 or tblfeedback.strbusinessname='Premier Goodwill Products' or tblfeedback.strbusinessname='Premier Goodwill Products') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Launceston Linen Supply
Kings Meadows TAS 7249
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=5458 or tblfeedback.strbusinessname='Launceston Linen Supply' or tblfeedback.strbusinessname='Launceston Linen Supply') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15