Rating
Waterfront Whitsunday Resort
Airlie Beach QLD 4802
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=17379 or tblfeedback.strbusinessname='Waterfront Whitsunday Resort' or tblfeedback.strbusinessname='Waterfront Whitsunday Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Botanica Weddings
Woodwark QLD 4802
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=25751 or tblfeedback.strbusinessname='Botanica Weddings' or tblfeedback.strbusinessname='Botanica Weddings') 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
Villa Botanica
Woodwark QLD 4802
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=21931 or tblfeedback.strbusinessname='Villa Botanica' or tblfeedback.strbusinessname='Villa Botanica') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Port Douglas Weddings
Port Douglas QLD 4877
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=29021 or tblfeedback.strbusinessname='Port Douglas Weddings' or tblfeedback.strbusinessname='Port Douglas Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Long Island Resort
Whitsundays QLD 4802
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=18691 or tblfeedback.strbusinessname='Long Island Resort' or tblfeedback.strbusinessname='Long Island Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating