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
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
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
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
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
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
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=30997 or tblfeedback.strbusinessname='Saunders Menswear (Ulladulla)' or tblfeedback.strbusinessname='Saunders Menswear (Ulladulla)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
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
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
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
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