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
Michele's Bridal & Formal Wear
Shepparton VIC 3630
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=75 or tblfeedback.strbusinessname='Michele'%%semi%%s Bridal &%%semi%% Formal Wear' or tblfeedback.strbusinessname='Michele's Bridal & Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Roger David Stores Pty Ltd
Albury NSW 2640
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=11207 or tblfeedback.strbusinessname='Roger David Stores Pty Ltd' or tblfeedback.strbusinessname='Roger David Stores Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Boyz To Men
Wodonga VIC 3690
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=13073 or tblfeedback.strbusinessname='Boyz To Men' or tblfeedback.strbusinessname='Boyz To Men') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cinderella Formal Wear
Albury NSW 2640
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=8674 or tblfeedback.strbusinessname='Cinderella Formal Wear' or tblfeedback.strbusinessname='Cinderella Formal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Albury Mensland
Albury NSW 2640
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=7773 or tblfeedback.strbusinessname='Albury Mensland' or tblfeedback.strbusinessname='Albury Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Eltrym Formal Gown Hire
Wodonga VIC 3690
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=182 or tblfeedback.strbusinessname='Eltrym Formal Gown Hire' or tblfeedback.strbusinessname='Eltrym Formal Gown Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flynn Bros Mensland
Wangaratta VIC 3677
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=13105 or tblfeedback.strbusinessname='Flynn Bros Mensland' or tblfeedback.strbusinessname='Flynn Bros Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bambury Collection The
Wodonga VIC 3690
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=108 or tblfeedback.strbusinessname='Bambury Collection The' or tblfeedback.strbusinessname='Bambury Collection The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Judd's Menswear & Suit Hire
Wangaratta VIC 3677
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=13124 or tblfeedback.strbusinessname='Judd'%%semi%%s Menswear &%%semi%% Suit Hire' or tblfeedback.strbusinessname='Judd's Menswear & Suit Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Avenue The
Lavington NSW 2641
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=7987 or tblfeedback.strbusinessname='Avenue The' or tblfeedback.strbusinessname='Avenue The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dynans Menswear
Albury NSW 2640
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=9101 or tblfeedback.strbusinessname='Dynans Menswear' or tblfeedback.strbusinessname='Dynans Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15