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
Godwin's Work N Casual Wear
Ulladulla NSW 2539
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=9478 or tblfeedback.strbusinessname='Godwin'%%semi%%s Work N Casual Wear' or tblfeedback.strbusinessname='Godwin's Work N Casual Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ferriers Menswear
Batemans Bay NSW 2536
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=9273 or tblfeedback.strbusinessname='Ferriers Menswear' or tblfeedback.strbusinessname='Ferriers Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Man About Town
Wollongong NSW 2500
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=10344 or tblfeedback.strbusinessname='Man About Town' or tblfeedback.strbusinessname='Man About Town') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cheryl's Costume Hire
Ulladulla NSW 2539
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=8633 or tblfeedback.strbusinessname='Cheryl'%%semi%%s Costume Hire' or tblfeedback.strbusinessname='Cheryl's Costume Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Suiting You
Wollongong NSW 2500
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=1565 or tblfeedback.strbusinessname='Suiting You' or tblfeedback.strbusinessname='Suiting You') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shoalhaven Fancy Dress & Bridal Wear
Nowra NSW 2541
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=1563 or tblfeedback.strbusinessname='Shoalhaven Fancy Dress &%%semi%% Bridal Wear' or tblfeedback.strbusinessname='Shoalhaven Fancy Dress & Bridal Wear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tramps Formal Hire
Wollongong NSW 2500
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=11774 or tblfeedback.strbusinessname='Tramps Formal Hire' or tblfeedback.strbusinessname='Tramps Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
VIP Formals
Wollongong NSW 2500
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=11903 or tblfeedback.strbusinessname='VIP Formals' or tblfeedback.strbusinessname='VIP Formals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Moruya Bridal Boutique
Moruya NSW 2537
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=1554 or tblfeedback.strbusinessname='Moruya Bridal Boutique' or tblfeedback.strbusinessname='Moruya Bridal Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Graham's Mensland
Corrimal NSW 2518
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=9538 or tblfeedback.strbusinessname='Graham'%%semi%%s Mensland' or tblfeedback.strbusinessname='Graham's Mensland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Saunders Menswear (Ulladulla)
Ulladulla NSW 2539
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=11306 or tblfeedback.strbusinessname='Saunders Menswear (%%semi%%Ulladulla)%%semi%%' or tblfeedback.strbusinessname='Saunders Menswear (Ulladulla)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Formal Affair
Warrawong NSW 2502
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=1544 or tblfeedback.strbusinessname='Formal Affair' or tblfeedback.strbusinessname='Formal Affair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Stanley Johns
Nowra NSW 2541
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=11530 or tblfeedback.strbusinessname='Stanley Johns' or tblfeedback.strbusinessname='Stanley Johns') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15