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
RSVP Bridal and Formal Wear
Coffs Harbour NSW 2450
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=24598 or tblfeedback.strbusinessname='RSVP Bridal and Formal Wear' or tblfeedback.strbusinessname='RSVP Bridal and Formal Wear') 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
Simmons Jack Pty Ltd (Mensland)
Coffs Harbour NSW 2450
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=11410 or tblfeedback.strbusinessname='Simmons Jack Pty Ltd (%%semi%%Mensland)%%semi%%' or tblfeedback.strbusinessname='Simmons Jack Pty Ltd (Mensland)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Port Macquarie Mensland
Port Macquarie NSW 2444
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=11025 or tblfeedback.strbusinessname='Port Macquarie Mensland' or tblfeedback.strbusinessname='Port Macquarie Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mary Vidler's Bridal Gowns
Lismore NSW 2480
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=1553 or tblfeedback.strbusinessname='Mary Vidler'%%semi%%s Bridal Gowns' or tblfeedback.strbusinessname='Mary Vidler's Bridal Gowns') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Graham's Mens Land
Wauchope NSW 2446
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=18477 or tblfeedback.strbusinessname='Graham'%%semi%%s Mens Land' or tblfeedback.strbusinessname='Graham's Mens Land') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wallaces of Byron Bay
Byron Bay NSW 2481
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=11933 or tblfeedback.strbusinessname='Wallaces of Byron Bay' or tblfeedback.strbusinessname='Wallaces of Byron Bay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wallace & Co Menswear
Ballina NSW 2478
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=11932 or tblfeedback.strbusinessname='Wallace &%%semi%% Co Menswear' or tblfeedback.strbusinessname='Wallace & Co Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hire Society
Coffs Harbour NSW 2450
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=9704 or tblfeedback.strbusinessname='Hire Society' or tblfeedback.strbusinessname='Hire Society') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Baby's Breath Bridal & Formal Wear
Banora Point NSW 2486
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=1597 or tblfeedback.strbusinessname='Baby'%%semi%%s Breath Bridal &%%semi%% Formal Wear' or tblfeedback.strbusinessname='Baby's Breath Bridal & Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Spurling Formal Hire Lismore
Lismore NSW 2480
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=11500 or tblfeedback.strbusinessname='Spurling Formal Hire Lismore' or tblfeedback.strbusinessname='Spurling Formal Hire Lismore') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lismore Bridal & Formal Hire
Lismore NSW 2480
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=1568 or tblfeedback.strbusinessname='Lismore Bridal &%%semi%% Formal Hire' or tblfeedback.strbusinessname='Lismore Bridal & Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Port Macquarie Mensland-Rays Men's World
Port Macquarie NSW 2444
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=11026 or tblfeedback.strbusinessname='Port Macquarie Mensland-Rays Men'%%semi%%s World' or tblfeedback.strbusinessname='Port Macquarie Mensland-Rays Men's World') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Spurling Formal Hire
Lismore NSW 2480
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=11499 or tblfeedback.strbusinessname='Spurling Formal Hire' or tblfeedback.strbusinessname='Spurling Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wallaces-Men for Clothes
Byron Bay NSW 2481
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=11934 or tblfeedback.strbusinessname='Wallaces-Men for Clothes' or tblfeedback.strbusinessname='Wallaces-Men for Clothes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Averil's Dress Circle
Coffs Harbour NSW 2450
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=1595 or tblfeedback.strbusinessname='Averil'%%semi%%s Dress Circle' or tblfeedback.strbusinessname='Averil's Dress Circle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15