Rating
BreakFree Aanuka Beach Resort
Coffs Harbour NSW 2450
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=33228 or tblfeedback.strbusinessname='BreakFree Aanuka Beach Resort' or tblfeedback.strbusinessname='BreakFree Aanuka Beach Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mercure Inn Sandcastle Port Macquarie
Port Macquarie NSW 2444
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=10464 or tblfeedback.strbusinessname='Mercure Inn Sandcastle Port Macquarie' or tblfeedback.strbusinessname='Mercure Inn Sandcastle Port Macquarie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Salt at Shoal Bay
Shoal Bay NSW 2315
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=39912 or tblfeedback.strbusinessname='Salt at Shoal Bay' or tblfeedback.strbusinessname='Salt at Shoal Bay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating