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
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
The Bridal Outlet
Somersby NSW 2257
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=25410 or tblfeedback.strbusinessname='The Bridal Outlet' or tblfeedback.strbusinessname='The Bridal Outlet') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Selvitex Menswear
Umina Beach NSW 2257
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=1560 or tblfeedback.strbusinessname='Selvitex Menswear' or tblfeedback.strbusinessname='Selvitex Menswear') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Manner's for Men
Gosford NSW 2250
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=10352 or tblfeedback.strbusinessname='Manner'%%semi%%s for Men' or tblfeedback.strbusinessname='Manner's for Men') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bridal Collections Hire for Him
Gosford East NSW 2250
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=1615 or tblfeedback.strbusinessname='Bridal Collections Hire for Him' or tblfeedback.strbusinessname='Bridal Collections Hire for Him') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mc Farland Scottish & Celtic Supplies
Gosford West NSW 2250
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=10436 or tblfeedback.strbusinessname='Mc Farland Scottish &%%semi%% Celtic Supplies' or tblfeedback.strbusinessname='Mc Farland Scottish & Celtic Supplies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Grace Bros Mens Formal Hire
Erina NSW 2250
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=1843 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
Little's Formal Hire
Gosford NSW 2250
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=10253 or tblfeedback.strbusinessname='Little'%%semi%%s Formal Hire' or tblfeedback.strbusinessname='Little's Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mensland Toukley
Toukley NSW 2263
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=10460 or tblfeedback.strbusinessname='Mensland Toukley' or tblfeedback.strbusinessname='Mensland Toukley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Little Angel Childrens Formal Hire
Springfield NSW 2250
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=10247 or tblfeedback.strbusinessname='Little Angel Childrens Formal Hire' or tblfeedback.strbusinessname='Little Angel Childrens Formal Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Parkers Male Fashion
The Entrance NSW 2261
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=1558 or tblfeedback.strbusinessname='Parkers Male Fashion' or tblfeedback.strbusinessname='Parkers Male Fashion') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Trend Apparel
Gosford NSW 2250
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=11780 or tblfeedback.strbusinessname='Trend Apparel' or tblfeedback.strbusinessname='Trend Apparel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
I-Do.com
Erina NSW 2250
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=18479 or tblfeedback.strbusinessname='I-Do.com' or tblfeedback.strbusinessname='I-Do.com') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Diamond Weddings
Gosford NSW 2250
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=1540 or tblfeedback.strbusinessname='Diamond Weddings' or tblfeedback.strbusinessname='Diamond Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15