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=25671 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
Paddick's Suit Hire
Subiaco WA 6008
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=7052 or tblfeedback.strbusinessname='Paddick'%%semi%%s Suit Hire' or tblfeedback.strbusinessname='Paddick's Suit Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Formal Wear Express
Nationwide WA 6000
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=17396 or tblfeedback.strbusinessname='Formal Wear Express' or tblfeedback.strbusinessname='Formal Wear Express') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roger David
Morley WA 6062
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=7058 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
Suits
West Leederville WA 6007
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=3751 or tblfeedback.strbusinessname='Suits' or tblfeedback.strbusinessname='Suits') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roger David
Karrinyup WA 6018
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=7057 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
Esquire Formal Wear
Perth WA 6000
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=7039 or tblfeedback.strbusinessname='Esquire Formal Wear' or tblfeedback.strbusinessname='Esquire Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tony Barlow Formal Hire
Fremantle WA 6160
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=7071 or tblfeedback.strbusinessname='Tony Barlow Formal Hire' or tblfeedback.strbusinessname='Tony Barlow Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Exquisite Bridal Hire
Kingsley WA 6026
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=7040 or tblfeedback.strbusinessname='Exquisite Bridal Hire' or tblfeedback.strbusinessname='Exquisite Bridal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tony Pafumi Menswear Roman High Class Tailor
Mount Lawley WA 6050
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=7078 or tblfeedback.strbusinessname='Tony Pafumi Menswear Roman High Class Tailor' or tblfeedback.strbusinessname='Tony Pafumi Menswear Roman High Class Tailor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fineline Tailoring Co
Victoria Park WA 6100
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=7045 or tblfeedback.strbusinessname='Fineline Tailoring Co' or tblfeedback.strbusinessname='Fineline Tailoring Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rockingham Formal & Bridal Hire
Rockingham WA 6168
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=3740 or tblfeedback.strbusinessname='Rockingham Formal &%%semi%% Bridal Hire' or tblfeedback.strbusinessname='Rockingham Formal & Bridal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Renoir Formal
Perth WA 6000
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=7055 or tblfeedback.strbusinessname='Renoir Formal' or tblfeedback.strbusinessname='Renoir Formal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian Formal Wear
Leederville WA 6007
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=3673 or tblfeedback.strbusinessname='Australian Formal Wear' or tblfeedback.strbusinessname='Australian Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Legends Bridal House
Joondalup WA 6027
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=3658 or tblfeedback.strbusinessname='Legends Bridal House' or tblfeedback.strbusinessname='Legends Bridal House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
House of Tartan The
Osborne Park WA 6017
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=7047 or tblfeedback.strbusinessname='House of Tartan The' or tblfeedback.strbusinessname='House of Tartan The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tony Barlow Formal Hire
Cannington WA 6107
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=7076 or tblfeedback.strbusinessname='Tony Barlow Formal Hire' or tblfeedback.strbusinessname='Tony Barlow Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Newton's Menswear & Formal Hire
West Perth WA 6005
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=7051 or tblfeedback.strbusinessname='Newton'%%semi%%s Menswear &%%semi%% Formal Hire' or tblfeedback.strbusinessname='Newton's Menswear & Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Formal Wear Express
Perth WA 6000
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=17630 or tblfeedback.strbusinessname='Formal Wear Express' or tblfeedback.strbusinessname='Formal Wear Express') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roger David
Perth WA 6000
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=7056 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
Tony Barlow Formal Hire
Booragoon WA 6154
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=7072 or tblfeedback.strbusinessname='Tony Barlow Formal Hire' or tblfeedback.strbusinessname='Tony Barlow Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Penguins Formal Suite Hire
Perth WA 6000
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=3735 or tblfeedback.strbusinessname='Penguins Formal Suite Hire' or tblfeedback.strbusinessname='Penguins Formal Suite Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wanneroo Fancy Dress & Formal Hire
Wangara WA 6065
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=7080 or tblfeedback.strbusinessname='Wanneroo Fancy Dress &%%semi%% Formal Hire' or tblfeedback.strbusinessname='Wanneroo Fancy Dress & Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger David
Hillarys WA 6025
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=7061 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
After 5 Fashion Hire
Willetton WA 6155
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=3667 or tblfeedback.strbusinessname='After 5 Fashion Hire' or tblfeedback.strbusinessname='After 5 Fashion Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ferrari Formalwear Pty Ltd
Perth WA 6000
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=7044 or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd' or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ferrari Formalwear Pty Ltd
Joondalup WA 6027
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=7042 or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd' or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tony Barlow Formal Hire
Claremont WA 6010
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=7073 or tblfeedback.strbusinessname='Tony Barlow Formal Hire' or tblfeedback.strbusinessname='Tony Barlow Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roger David
Cloverdale WA 6105
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=7064 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
Tony Barlow Formal Hire
Morley WA 6062
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=7068 or tblfeedback.strbusinessname='Tony Barlow Formal Hire' or tblfeedback.strbusinessname='Tony Barlow Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Angelica Bridal & Formal Wear
Perth WA 6000
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=3671 or tblfeedback.strbusinessname='Angelica Bridal &%%semi%% Formal Wear' or tblfeedback.strbusinessname='Angelica Bridal & Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tony Barlow Formal Hire
Northbridge WA 6003
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=7070 or tblfeedback.strbusinessname='Tony Barlow Formal Hire' or tblfeedback.strbusinessname='Tony Barlow Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wedding Belle Boutique & Hire Service The
Perth WA 6000
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=3757 or tblfeedback.strbusinessname='Wedding Belle Boutique &%%semi%% Hire Service The' or tblfeedback.strbusinessname='Wedding Belle Boutique & Hire Service The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Britton's Formal Wear
Perth WA 6000
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=7037 or tblfeedback.strbusinessname='Britton'%%semi%%s Formal Wear' or tblfeedback.strbusinessname='Britton's Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vavaggi Formal Wear
Perth WA 6000
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=3756 or tblfeedback.strbusinessname='Vavaggi Formal Wear' or tblfeedback.strbusinessname='Vavaggi Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tony Barlow Formal Hire
Karrinyup WA 6018
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=7075 or tblfeedback.strbusinessname='Tony Barlow Formal Hire' or tblfeedback.strbusinessname='Tony Barlow Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bliss Formal Wear
West Perth WA 6005
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=3659 or tblfeedback.strbusinessname='Bliss Formal Wear' or tblfeedback.strbusinessname='Bliss Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger David
Joondalup WA 6027
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=7059 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
Roger David
Cannington WA 6107
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=7063 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
Roger David
Rockingham WA 6168
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=7065 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
Ferrari Formalwear Pty Ltd
Midland WA 6056
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=7041 or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd' or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tony's Formal Wear
Mount Hawthorn WA 6016
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=7079 or tblfeedback.strbusinessname='Tony'%%semi%%s Formal Wear' or tblfeedback.strbusinessname='Tony's Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fremantle Formalwear
Fremantle WA 6160
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=3706 or tblfeedback.strbusinessname='Fremantle Formalwear' or tblfeedback.strbusinessname='Fremantle Formalwear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brittons Formalwear
Perth WA 6000
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=17629 or tblfeedback.strbusinessname='Brittons Formalwear' or tblfeedback.strbusinessname='Brittons Formalwear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kalamunda Central Suite Hire
Kalamunda WA 6076
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=7049 or tblfeedback.strbusinessname='Kalamunda Central Suite Hire' or tblfeedback.strbusinessname='Kalamunda Central Suite Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Penguins Formal Suit Hire
Perth WA 6000
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=7053 or tblfeedback.strbusinessname='Penguins Formal Suit Hire' or tblfeedback.strbusinessname='Penguins Formal Suit Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roger David
Mirrabooka WA 6061
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=7062 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
Roger David
Booragoon WA 6154
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=7060 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
1 - 50 of 55 Sort search results alphabetically