Rating
Made With Love Bridal
Varsity Lakes QLD 4227
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=26976 or tblfeedback.strbusinessname='Made With Love Bridal' or tblfeedback.strbusinessname='Made With Love Bridal') 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
Ron Bennett
Rosebery NSW 2018
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=11218 or tblfeedback.strbusinessname='Ron Bennett' or tblfeedback.strbusinessname='Ron Bennett') 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
Hugs for Brides
Rockdale NSW 2216
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=1547 or tblfeedback.strbusinessname='Hugs for Brides' or tblfeedback.strbusinessname='Hugs for Brides') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bargo Party Hire
Narellan NSW 2567
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=26531 or tblfeedback.strbusinessname='Bargo Party Hire' or tblfeedback.strbusinessname='Bargo Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sweethearts Bridal Boutique
Blacktown NSW 2148
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=24906 or tblfeedback.strbusinessname='Sweethearts Bridal Boutique' or tblfeedback.strbusinessname='Sweethearts Bridal Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Premodain
Double Bay NSW 2028
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=11049 or tblfeedback.strbusinessname='Premodain' or tblfeedback.strbusinessname='Premodain') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Spurling Formal Wear
Sydney NSW 2000
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=11506 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Calabro Formal Wear
Liverpool NSW 2170
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=8472 or tblfeedback.strbusinessname='Calabro Formal Wear' or tblfeedback.strbusinessname='Calabro Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harts
Chatswood NSW 2067
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=18478 or tblfeedback.strbusinessname='Harts' or tblfeedback.strbusinessname='Harts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger David
Castle Hill NSW 2154
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=11205 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
All the Rage Formal Wear
Kingsford NSW 2032
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=7807 or tblfeedback.strbusinessname='All the Rage Formal Wear' or tblfeedback.strbusinessname='All the Rage Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rosemont Formal Hire
Spit Junction NSW 2088
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=11234 or tblfeedback.strbusinessname='Rosemont Formal Hire' or tblfeedback.strbusinessname='Rosemont Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Formal Image
Parramatta NSW 2150
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=9337 or tblfeedback.strbusinessname='Formal Image' or tblfeedback.strbusinessname='Formal Image') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vivianne LA Costa Mens Wear & Formal Hire
Bexley NSW 2207
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=11914 or tblfeedback.strbusinessname='Vivianne LA Costa Mens Wear &%%semi%% Formal Hire' or tblfeedback.strbusinessname='Vivianne LA Costa Mens Wear & Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Spurling Formal Wear
Burwood NSW 2134
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=11509 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Krystal Carlisle Mens Formal
Sans Souci NSW 2219
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=10113 or tblfeedback.strbusinessname='Krystal Carlisle Mens Formal' or tblfeedback.strbusinessname='Krystal Carlisle Mens Formal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
After Six Formal Wear
Wetherill Park NSW 2164
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=7759 or tblfeedback.strbusinessname='After Six Formal Wear' or tblfeedback.strbusinessname='After Six Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Suit Hire-Man About Town
Sydney NSW 2000
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=11593 or tblfeedback.strbusinessname='Suit Hire-Man About Town' or tblfeedback.strbusinessname='Suit Hire-Man About Town') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger David
Blacktown NSW 2148
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=11203 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
Pagewood NSW 2035
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=11198 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
Formal Wear Rentals Pty Ltd
Wetherill Park NSW 2164
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=9340 or tblfeedback.strbusinessname='Formal Wear Rentals Pty Ltd' or tblfeedback.strbusinessname='Formal Wear Rentals Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Calabro Formal Wear
Parramatta NSW 2150
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=8473 or tblfeedback.strbusinessname='Calabro Formal Wear' or tblfeedback.strbusinessname='Calabro Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
David Jones Ltd
Sydney NSW 2000
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=8925 or tblfeedback.strbusinessname='David Jones Ltd' or tblfeedback.strbusinessname='David Jones Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Calabro Formal Wear Miranda
Miranda NSW 2228
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=18475 or tblfeedback.strbusinessname='Calabro Formal Wear Miranda' or tblfeedback.strbusinessname='Calabro Formal Wear Miranda') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kenrays Informals
Miranda NSW 2228
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=10053 or tblfeedback.strbusinessname='Kenrays Informals' or tblfeedback.strbusinessname='Kenrays Informals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Spurling Formal Wear
Chatswood NSW 2067
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=11508 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Grace Bros Formal Hire
Parramatta NSW 2150
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=1840 or tblfeedback.strbusinessname='Grace Bros Formal Hire' or tblfeedback.strbusinessname='Grace Bros Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jackson Wellesley L Pty Ltd
North Sydney NSW 2060
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=9863 or tblfeedback.strbusinessname='Jackson Wellesley L Pty Ltd' or tblfeedback.strbusinessname='Jackson Wellesley L Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Calabro Formal Wear
Wetherill Park NSW 2164
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=8474 or tblfeedback.strbusinessname='Calabro Formal Wear' or tblfeedback.strbusinessname='Calabro Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Peppers Formal Wear Pty Ltd
Cremorne NSW 2090
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=10903 or tblfeedback.strbusinessname='Peppers Formal Wear Pty Ltd' or tblfeedback.strbusinessname='Peppers Formal Wear Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Boston for Men
Randwick NSW 2031
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=8296 or tblfeedback.strbusinessname='Boston for Men' or tblfeedback.strbusinessname='Boston for Men') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Man About Town Suit Hire
Sydney NSW 2000
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=10345 or tblfeedback.strbusinessname='Man About Town Suit Hire' or tblfeedback.strbusinessname='Man About Town Suit Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Liverpool Wedding Specialists
Liverpool NSW 2170
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=10255 or tblfeedback.strbusinessname='Liverpool Wedding Specialists' or tblfeedback.strbusinessname='Liverpool Wedding Specialists') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Spurling Formal Wear
Neutral Bay NSW 2089
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=11505 or tblfeedback.strbusinessname='Spurling Formal Wear' or tblfeedback.strbusinessname='Spurling Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bridal Collections, Formal Wear and Hire
Dee Why NSW 2099
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=18473 or tblfeedback.strbusinessname='Bridal Collections, Formal Wear and Hire' or tblfeedback.strbusinessname='Bridal Collections, Formal Wear and Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Greys Mens Formal Wear Hire Pty Ltd
Neutral Bay NSW 2089
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=1846 or tblfeedback.strbusinessname='Greys Mens Formal Wear Hire Pty Ltd' or tblfeedback.strbusinessname='Greys Mens Formal Wear Hire Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dial A Suit Hire
Wetherill Park NSW 2164
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=1803 or tblfeedback.strbusinessname='Dial A Suit Hire' or tblfeedback.strbusinessname='Dial A Suit Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Park Avenue
Parramatta NSW 2150
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=1557 or tblfeedback.strbusinessname='Park Avenue' or tblfeedback.strbusinessname='Park Avenue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Calabro Formal Wear
Miranda NSW 2228
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=8471 or tblfeedback.strbusinessname='Calabro Formal Wear' or tblfeedback.strbusinessname='Calabro Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger David
Sydney NSW 2000
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=11195 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
Hurstville NSW 2220
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=11200 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
Dee Why Formal Hire
Brookvale NSW 2100
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=1800 or tblfeedback.strbusinessname='Dee Why Formal Hire' or tblfeedback.strbusinessname='Dee Why Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Grace Bros Mens Formal Hire
Sydney NSW 2000
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=9519 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
Helene Esdaile
Neutral Bay NSW 2089
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=1546 or tblfeedback.strbusinessname='Helene Esdaile' or tblfeedback.strbusinessname='Helene Esdaile') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
National Formal Wear Group Pty Ltd
Liverpool NSW 2170
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=10627 or tblfeedback.strbusinessname='National Formal Wear Group Pty Ltd' or tblfeedback.strbusinessname='National Formal Wear Group Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
MCP Painting & Decorating Service
Belfield NSW 2191
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=10448 or tblfeedback.strbusinessname='MCP Painting &%%semi%% Decorating Service' or tblfeedback.strbusinessname='MCP Painting & Decorating Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classics Formal Wear
Wetherill Park NSW 2164
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=1658 or tblfeedback.strbusinessname='Classics Formal Wear' or tblfeedback.strbusinessname='Classics Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 123 Sort search results alphabetically