Rating
Belles And Beaux
Newcastle NSW 2300
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=1534 or tblfeedback.strbusinessname='Belles And Beaux' or tblfeedback.strbusinessname='Belles And Beaux') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Wedding Shoppe
Dubbo NSW 2830
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=25308 or tblfeedback.strbusinessname='The Wedding Shoppe' or tblfeedback.strbusinessname='The Wedding Shoppe') 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
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
Rundle Australia
Broadmeadow NSW 2292
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=11259 or tblfeedback.strbusinessname='Rundle Australia' or tblfeedback.strbusinessname='Rundle Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger David
Garden City NSW 2289
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=11197 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
Pure Classic Fashions
Singleton NSW 2330
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=11079 or tblfeedback.strbusinessname='Pure Classic Fashions' or tblfeedback.strbusinessname='Pure Classic Fashions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger David
Newcastle NSW 2300
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=11194 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
West Terrace Menswear
Newcastle NSW 2300
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=12008 or tblfeedback.strbusinessname='West Terrace Menswear' or tblfeedback.strbusinessname='West Terrace Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gentlemens Outfitters
Newcastle NSW 2300
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=9435 or tblfeedback.strbusinessname='Gentlemens Outfitters' or tblfeedback.strbusinessname='Gentlemens Outfitters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Beveridge's Menswear & Formal Hire
Cessnock NSW 2325
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=8193 or tblfeedback.strbusinessname='Beveridge'%%semi%%s Menswear &%%semi%% Formal Hire' or tblfeedback.strbusinessname='Beveridge's Menswear & Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ferarri Formal Hire
Charlestown NSW 2290
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=9268 or tblfeedback.strbusinessname='Ferarri Formal Hire' or tblfeedback.strbusinessname='Ferarri Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Abercrombie Mens & Boys Wear
Mayfield NSW 2304
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=7708 or tblfeedback.strbusinessname='Abercrombie Mens &%%semi%% Boys Wear' or tblfeedback.strbusinessname='Abercrombie Mens & Boys Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Science Formal Wear Hire Service
Newcastle West NSW 2302
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=11317 or tblfeedback.strbusinessname='Science Formal Wear Hire Service' or tblfeedback.strbusinessname='Science Formal Wear Hire Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rundle Tailoring
Newcastle West NSW 2302
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=11260 or tblfeedback.strbusinessname='Rundle Tailoring' or tblfeedback.strbusinessname='Rundle Tailoring') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gentlemens Outfitters
Charlestown NSW 2290
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=9436 or tblfeedback.strbusinessname='Gentlemens Outfitters' or tblfeedback.strbusinessname='Gentlemens Outfitters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Grace Bros Mens Formal Hire
Charlestown NSW 2290
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=1842 or tblfeedback.strbusinessname='Grace Bros Mens Formal Hire' or tblfeedback.strbusinessname='Grace Bros Mens Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Catcha Dream Suit Hire
Tanilba Bay NSW 2319
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=8562 or tblfeedback.strbusinessname='Catcha Dream Suit Hire' or tblfeedback.strbusinessname='Catcha Dream Suit Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger David
Maitland NSW 2320
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=11196 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
Singleton Formal Hire
Singleton NSW 2330
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=11424 or tblfeedback.strbusinessname='Singleton Formal Hire' or tblfeedback.strbusinessname='Singleton Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lane Ken Mensland
Maitland NSW 2320
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=10147 or tblfeedback.strbusinessname='Lane Ken Mensland' or tblfeedback.strbusinessname='Lane Ken Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hiltop Formal Hire
Charlestown NSW 2290
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=9702 or tblfeedback.strbusinessname='Hiltop Formal Hire' or tblfeedback.strbusinessname='Hiltop Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harvey's Men's Wear
Maitland NSW 2320
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=9627 or tblfeedback.strbusinessname='Harvey'%%semi%%s Men'%%semi%%s Wear' or tblfeedback.strbusinessname='Harvey's Men's Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15