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
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
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
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
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
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
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
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
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