Ed Harry
Level 1, 125 Port Road 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 year(getdate())-year(dtmadded)<=15
Ed Harry
Level 1, 125 Port Road 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 year(getdate())-year(dtmadded)<=15
Ed Harry
Level 1, 125 Port Road 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 year(getdate())-year(dtmadded)<=15
Formal Wear Express
Suit Hire to your Door Nationwide SA 5000
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=17399 or tblfeedback.strbusinessname='Formal Wear Express' or tblfeedback.strbusinessname='Formal Wear Express') and year(getdate())-year(dtmadded)<=15
Ferrari Formalwear
1190 South Road Clovelly Park SA 5042
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=19102 or tblfeedback.strbusinessname='Ferrari Formalwear' or tblfeedback.strbusinessname='Ferrari Formalwear') and year(getdate())-year(dtmadded)<=15
Formal Wear Express
P.O. Box 1019 Stirling SA 5152
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=19108 or tblfeedback.strbusinessname='Formal Wear Express' or tblfeedback.strbusinessname='Formal Wear Express') and year(getdate())-year(dtmadded)<=15
Lady Liz Bridal
311 Payneham Road Royston SA 5070
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=19144 or tblfeedback.strbusinessname='Lady Liz Bridal' or tblfeedback.strbusinessname='Lady Liz Bridal') and year(getdate())-year(dtmadded)<=15
Roger David Suit Hire
Myer Centre, Rundle Mall Adelaide SA 5000
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=19185 or tblfeedback.strbusinessname='Roger David Suit Hire' or tblfeedback.strbusinessname='Roger David Suit Hire') and year(getdate())-year(dtmadded)<=15
Spurling Formal Wear
1st Floor 159 Rundle Mall Adelaide SA 5000
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=6111 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15
Adelaide Suit Hire
14 Grenfell Street Adelaide SA 5000
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=6076 or tblfeedback.strbusinessname='Adelaide Suit Hire' or tblfeedback.strbusinessname='Adelaide Suit Hire') and year(getdate())-year(dtmadded)<=15
Axel Beers
3 Francis Street Adelaide SA 5000
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=6077 or tblfeedback.strbusinessname='Axel Beers' or tblfeedback.strbusinessname='Axel Beers') and year(getdate())-year(dtmadded)<=15
Barlow Tony Formal Hire
70 Rundle Mall Adelaide SA 5000
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=6079 or tblfeedback.strbusinessname='Barlow Tony Formal Hire' or tblfeedback.strbusinessname='Barlow Tony Formal Hire') and year(getdate())-year(dtmadded)<=15
Chehade Bros Pty Ltd
112/118 Tynte Street North Adelaide SA 5006
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=6080 or tblfeedback.strbusinessname='Chehade Bros Pty Ltd' or tblfeedback.strbusinessname='Chehade Bros Pty Ltd') and year(getdate())-year(dtmadded)<=15
Chehade Karl Formal Wear Pty Ltd
Level 1 150 Rundle Mall Adelaide SA 5000
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=6081 or tblfeedback.strbusinessname='Chehade Karl Formal Wear Pty Ltd' or tblfeedback.strbusinessname='Chehade Karl Formal Wear Pty Ltd') and year(getdate())-year(dtmadded)<=15
Chehade Karl Formal Wear Pty Ltd
266 Glen Osmond Road Fullarton SA 5063
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=6082 or tblfeedback.strbusinessname='Chehade Karl Formal Wear Pty Ltd' or tblfeedback.strbusinessname='Chehade Karl Formal Wear Pty Ltd') and year(getdate())-year(dtmadded)<=15
Crosby's of Gawler
78-80 Murray Street Gawler SA 5118
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=6084 or tblfeedback.strbusinessname='Crosby'%%semi%%s of Gawler' or tblfeedback.strbusinessname='Crosby's of Gawler') and year(getdate())-year(dtmadded)<=15
David Jones Ltd
Adelaide SA 5000
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=6085 or tblfeedback.strbusinessname='David Jones Ltd' or tblfeedback.strbusinessname='David Jones Ltd') and year(getdate())-year(dtmadded)<=15
Fantasia Costume Hire
770 Anzac Highway Glenelg SA 5045
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=6088 or tblfeedback.strbusinessname='Fantasia Costume Hire' or tblfeedback.strbusinessname='Fantasia Costume Hire') and year(getdate())-year(dtmadded)<=15
Ferrari Formalwear Pty Ltd
1190 South Road Clovelly Park SA 5042
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=6089 or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd' or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd') and year(getdate())-year(dtmadded)<=15
Ferrari Formalwear Pty Ltd
30 Grenfell Street Adelaide SA 5000
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=6090 or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd' or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd') and year(getdate())-year(dtmadded)<=15
Ferrari Formalwear Pty Ltd
Shop 3 47-49 Elizabeth Way Elizabeth SA 5112
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=6091 or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd' or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd') and year(getdate())-year(dtmadded)<=15
Ferrari Formalwear Pty Ltd
Pimpala Road
<BR>Cnr South Rd Reynella SA 5161
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=6092 or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd' or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd') and year(getdate())-year(dtmadded)<=15
Ferrari Formalwear Pty Ltd
966 North East Road Modbury SA 5092
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=6093 or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd' or tblfeedback.strbusinessname='Ferrari Formalwear Pty Ltd') and year(getdate())-year(dtmadded)<=15
Gerry's Suit Hire
270 Payneham Road Payneham SA 5070
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=6094 or tblfeedback.strbusinessname='Gerry'%%semi%%s Suit Hire' or tblfeedback.strbusinessname='Gerry's Suit Hire') and year(getdate())-year(dtmadded)<=15
Karl Chehade Formalwear
159 Rundle Mall Adelaide SA 5000
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=6097 or tblfeedback.strbusinessname='Karl Chehade Formalwear' or tblfeedback.strbusinessname='Karl Chehade Formalwear') and year(getdate())-year(dtmadded)<=15
Karl Chehade Formalwear
266 Glen Osmond Road Fullarton SA 5063
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=6098 or tblfeedback.strbusinessname='Karl Chehade Formalwear' or tblfeedback.strbusinessname='Karl Chehade Formalwear') and year(getdate())-year(dtmadded)<=15
Mensland
92 Murray Street Gawler SA 5118
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=6099 or tblfeedback.strbusinessname='Mensland' or tblfeedback.strbusinessname='Mensland') and year(getdate())-year(dtmadded)<=15
Myer Mens Formal Hire
22 Rundle Mall Adelaide SA 5000
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=6101 or tblfeedback.strbusinessname='Myer Mens Formal Hire' or tblfeedback.strbusinessname='Myer Mens Formal Hire') and year(getdate())-year(dtmadded)<=15
Peter Shearer Formal Hire
101 Rundle Mall Adelaide SA 5000
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=6102 or tblfeedback.strbusinessname='Peter Shearer Formal Hire' or tblfeedback.strbusinessname='Peter Shearer Formal Hire') and year(getdate())-year(dtmadded)<=15
RJM Formal Suit Hire
First Floor 40 Beach Road Christies Beach SA 5165
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=6104 or tblfeedback.strbusinessname='RJM Formal Suit Hire' or tblfeedback.strbusinessname='RJM Formal Suit Hire') and year(getdate())-year(dtmadded)<=15
Roger David
Shop 211 Rundle Mall
<BR>The Myer Centre Adelaide SA 5000
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=6105 or tblfeedback.strbusinessname='Roger David' or tblfeedback.strbusinessname='Roger David') and year(getdate())-year(dtmadded)<=15
Roger David
Shop 89 Raleigh Walk
<BR>Elizabeth City Centre Elizabeth SA 5112
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=6106 or tblfeedback.strbusinessname='Roger David' or tblfeedback.strbusinessname='Roger David') and year(getdate())-year(dtmadded)<=15
Roger David
Shop 116 Tea Tree Plaza Centre Modbury SA 5092
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=6107 or tblfeedback.strbusinessname='Roger David' or tblfeedback.strbusinessname='Roger David') and year(getdate())-year(dtmadded)<=15
Roger David
Shop 1058 Marion Shopping Centre Oaklands Park SA 5046
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=6108 or tblfeedback.strbusinessname='Roger David' or tblfeedback.strbusinessname='Roger David') and year(getdate())-year(dtmadded)<=15
Roger David
Shop 71 The Colonnades Noarlunga Centre Noarlunga Centre SA 5168
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=6109 or tblfeedback.strbusinessname='Roger David' or tblfeedback.strbusinessname='Roger David') and year(getdate())-year(dtmadded)<=15
Roger David
Shop 61 West Lakes Mall West Lakes SA 5021
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=6110 or tblfeedback.strbusinessname='Roger David' or tblfeedback.strbusinessname='Roger David') and year(getdate())-year(dtmadded)<=15
Spurling Formal Wear
90 Jetty Road Glenelg SA 5045
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=6112 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15
Spurling Formal Wear
266 Glen Osmond Road Fullarton SA 5063
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=6113 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') and year(getdate())-year(dtmadded)<=15
Suits U Menswear
307 Payneham Road Royston Park SA 5070
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=6114 or tblfeedback.strbusinessname='Suits U Menswear' or tblfeedback.strbusinessname='Suits U Menswear') and year(getdate())-year(dtmadded)<=15
Tony Barlow Formal Hire
70 Rundle Mall Adelaide SA 5000
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=6117 or tblfeedback.strbusinessname='Tony Barlow Formal Hire' or tblfeedback.strbusinessname='Tony Barlow Formal Hire') and year(getdate())-year(dtmadded)<=15
Toovey & Morris Menswear
435 Portrush Road
<BR>Shop Four Burnside Plaza Glenside SA 5065
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=6118 or tblfeedback.strbusinessname='Toovey &%%semi%% Morris Menswear' or tblfeedback.strbusinessname='Toovey & Morris Menswear') and year(getdate())-year(dtmadded)<=15
Trims
322/336 King William Street Adelaide SA 5000
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=6119 or tblfeedback.strbusinessname='Trims' or tblfeedback.strbusinessname='Trims') and year(getdate())-year(dtmadded)<=15
