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
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
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
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
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
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
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
All the Rage Formal Wear
Marrickville NSW 2204
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=7805 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
Grace Bros Mens Formal Hire
Roselands NSW 2196
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=9523 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
Everafter Bridal & Formal Wear
Prospect 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=1819 or tblfeedback.strbusinessname='Everafter Bridal &%%semi%% Formal Wear' or tblfeedback.strbusinessname='Everafter Bridal & Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classics 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=1657 or tblfeedback.strbusinessname='Classics Formal Wear' or tblfeedback.strbusinessname='Classics Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roger David
Warringah Mall 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=11206 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
M&S suit city
Fairfield NSW 2165
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=18480 or tblfeedback.strbusinessname='M&%%semi%%S suit city' or tblfeedback.strbusinessname='M&S suit city') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Classics Formal Wear
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=8712 or tblfeedback.strbusinessname='Classics Formal Wear' or tblfeedback.strbusinessname='Classics Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Chorleys
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=8652 or tblfeedback.strbusinessname='Chorleys' or tblfeedback.strbusinessname='Chorleys') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Donas Bridal & Formal Hire
Campsie NSW 2194
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=1805 or tblfeedback.strbusinessname='Donas Bridal &%%semi%% Formal Hire' or tblfeedback.strbusinessname='Donas Bridal & Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Allen Bros of Hurstville
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=7814 or tblfeedback.strbusinessname='Allen Bros of Hurstville' or tblfeedback.strbusinessname='Allen Bros of Hurstville') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bride of Fantasy Made To Measure Hire
Clovelly 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=8384 or tblfeedback.strbusinessname='Bride of Fantasy Made To Measure Hire' or tblfeedback.strbusinessname='Bride of Fantasy Made To Measure 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
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
star ratingstar ratingstar ratingstar ratingstar rating
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
star ratingstar ratingstar ratingstar ratingstar rating
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
Formals of Auburn
Auburn NSW 2144
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=9341 or tblfeedback.strbusinessname='Formals of Auburn' or tblfeedback.strbusinessname='Formals of Auburn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
Roger David
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=11199 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
Kenrays Informals
Caringbah NSW 2229
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=10054 or tblfeedback.strbusinessname='Kenrays Informals' or tblfeedback.strbusinessname='Kenrays Informals') 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
Esdaile Hire Collection
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=9186 or tblfeedback.strbusinessname='Esdaile Hire Collection' or tblfeedback.strbusinessname='Esdaile Hire Collection') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
Peppers Formal Wear Pty Ltd
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=10902 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
Spurling Formal Wear
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=11510 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
Donas Bridal & Menswear
Campsie NSW 2194
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=9052 or tblfeedback.strbusinessname='Donas Bridal &%%semi%% Menswear' or tblfeedback.strbusinessname='Donas Bridal & Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Christina's Bridal & Formal Hire & Sales
Bankstown NSW 2200
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=1647 or tblfeedback.strbusinessname='Christina'%%semi%%s Bridal &%%semi%% Formal Hire &%%semi%% Sales' or tblfeedback.strbusinessname='Christina's Bridal & Formal Hire & Sales') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Grace Bros Mens Formal Hire
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=9522 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
Spurling Formal Wear
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=11507 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 Wetherill Park
Wetherill Park NSW 2176
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=18474 or tblfeedback.strbusinessname='Calabro Formal Wear Wetherill Park' or tblfeedback.strbusinessname='Calabro Formal Wear Wetherill Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jean Fox Hire for Him
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=9898 or tblfeedback.strbusinessname='Jean Fox Hire for Him' or tblfeedback.strbusinessname='Jean Fox Hire for Him') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Baymen Menswear
Ashfield NSW 2131
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=1602 or tblfeedback.strbusinessname='Baymen Menswear' or tblfeedback.strbusinessname='Baymen Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kenrays Informals
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=10052 or tblfeedback.strbusinessname='Kenrays Informals' or tblfeedback.strbusinessname='Kenrays Informals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roger David
Roselands NSW 2196
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=11202 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
Grace Bros Mens Formal Hire
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=9521 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
Spurling 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=11503 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
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
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
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
1 - 50 of 123 Sort search results alphabetically