Rating Broome Weddings
Broome Weddings
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=17406 or tblfeedback.strbusinessname='Broome Weddings' or tblfeedback.strbusinessname='Broome Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Romantic weddings on Cable Beach or any other unique Kimberley location.

Rating
Cable Beach Club Resort
Cable Beach WA 6725
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=32483 or tblfeedback.strbusinessname='Cable Beach Club Resort' or tblfeedback.strbusinessname='Cable Beach Club Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating