Rating
Erakor Island Resort & Spa
Port Vila, Vanutau QLD 4557
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=27944 or tblfeedback.strbusinessname='Erakor Island Resort & Spa' or tblfeedback.strbusinessname='Erakor Island Resort & Spa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
King Fisher Bay Resort
Fraser Island QLD 4581
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=23526 or tblfeedback.strbusinessname='King Fisher Bay Resort' or tblfeedback.strbusinessname='King Fisher Bay Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Iririki Island Resort
Port Vila QLD
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=35656 or tblfeedback.strbusinessname='Iririki Island Resort' or tblfeedback.strbusinessname='Iririki Island Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mountain Top Community Church
Mount Mee QLD 4521
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=25866 or tblfeedback.strbusinessname='Mountain Top Community Church' or tblfeedback.strbusinessname='Mountain Top Community Church') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating