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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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