Rating
Ed Harry
Hindmarsh SA 5007
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=26719 or tblfeedback.strbusinessname='Ed Harry' or tblfeedback.strbusinessname='Ed Harry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Made With Love Bridal
Varsity Lakes QLD 4227
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=26976 or tblfeedback.strbusinessname='Made With Love Bridal' or tblfeedback.strbusinessname='Made With Love Bridal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ed Harry
Hindmarsh SA 5007
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=26719 or tblfeedback.strbusinessname='Ed Harry' or tblfeedback.strbusinessname='Ed Harry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roger David
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=13163 or tblfeedback.strbusinessname='Roger David' or tblfeedback.strbusinessname='Roger David') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Men Only Suit Hire
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=13139 or tblfeedback.strbusinessname='Men Only Suit Hire' or tblfeedback.strbusinessname='Men Only Suit Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jennal's Bridal Boutique Hire & Sales
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=230 or tblfeedback.strbusinessname='Jennal'%%semi%%s Bridal Boutique Hire &%%semi%% Sales' or tblfeedback.strbusinessname='Jennal's Bridal Boutique Hire & Sales') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
MAC Whirter's Menswear
Gisborne VIC 3437
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=13131 or tblfeedback.strbusinessname='MAC Whirter'%%semi%%s Menswear' or tblfeedback.strbusinessname='MAC Whirter's Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
For Weddings & A Formal
Bendigo VIC 3550
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=73 or tblfeedback.strbusinessname='For Weddings &%%semi%% A Formal' or tblfeedback.strbusinessname='For Weddings & A Formal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lavender Place
Macedon VIC 3440
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=247 or tblfeedback.strbusinessname='Lavender Place' or tblfeedback.strbusinessname='Lavender Place') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Norris Mens Land
Bendigo VIC 3550
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=13143 or tblfeedback.strbusinessname='Norris Mens Land' or tblfeedback.strbusinessname='Norris Mens Land') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Walter Davis & Co Pty Ltd
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=358 or tblfeedback.strbusinessname='Walter Davis &%%semi%% Co Pty Ltd' or tblfeedback.strbusinessname='Walter Davis & Co Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bendigo Formal Hire
Bendigo VIC 3550
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=13069 or tblfeedback.strbusinessname='Bendigo Formal Hire' or tblfeedback.strbusinessname='Bendigo Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Anita Moore
Echuca VIC 3564
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=96 or tblfeedback.strbusinessname='Anita Moore' or tblfeedback.strbusinessname='Anita Moore') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Messer & Opie Pty Ltd
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=282 or tblfeedback.strbusinessname='Messer &%%semi%% Opie Pty Ltd' or tblfeedback.strbusinessname='Messer & Opie Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15