Rating
Remember Neons
Ballarat VIC 3350
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=43452 or tblfeedback.strbusinessname='Remember Neons' or tblfeedback.strbusinessname='Remember Neons') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blaze Displays
Wodonga VIC 3690
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=41569 or tblfeedback.strbusinessname='Blaze Displays' or tblfeedback.strbusinessname='Blaze Displays') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wish Sydney
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 Sydney' or tblfeedback.strbusinessname='Wish Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wish Sydney
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 Sydney' or tblfeedback.strbusinessname='Wish Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
KC Times Co
Brisbane QLD 4000
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=44432 or tblfeedback.strbusinessname='KC Times Co' or tblfeedback.strbusinessname='KC Times Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Spiders
Albury NSW 2640
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=11483 or tblfeedback.strbusinessname='Spiders' or tblfeedback.strbusinessname='Spiders') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roman Candelabras
Thurgoona NSW 2640
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=11213 or tblfeedback.strbusinessname='Roman Candelabras' or tblfeedback.strbusinessname='Roman Candelabras') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gadds' Greenery
Kiewa VIC 3691
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=12906 or tblfeedback.strbusinessname='Gadds'%%semi%% Greenery' or tblfeedback.strbusinessname='Gadds' Greenery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Occasion Decorations
Albury North NSW 2640
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=7800 or tblfeedback.strbusinessname='All Occasion Decorations' or tblfeedback.strbusinessname='All Occasion Decorations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wangaratta Party Hire
Wangaratta VIC 3677
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=12979 or tblfeedback.strbusinessname='Wangaratta Party Hire' or tblfeedback.strbusinessname='Wangaratta Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Smith
Wangaratta VIC 3677
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=12970 or tblfeedback.strbusinessname='Smith' or tblfeedback.strbusinessname='Smith') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
RBR Party Hire & Wholesale Pty Ltd
Wodonga VIC 3690
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=12962 or tblfeedback.strbusinessname='RBR Party Hire &%%semi%% Wholesale Pty Ltd' or tblfeedback.strbusinessname='RBR Party Hire & Wholesale Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15