Rating Sea Temple Resort & Spa Port Douglas
Sea Temple Resort & Spa Port Douglas
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=19861 or tblfeedback.strbusinessname='Sea Temple Resort &%%semi%% Spa Port Douglas' or tblfeedback.strbusinessname='Sea Temple Resort & Spa Port Douglas') and year(getdate())-year(dtmadded)<=15
The Sea Temple Resort & Spa Port Douglas is a stunning, luxurious five star property located at Four Mile Beach, with access to many ceremony and reception venues.

Rating The Sebel Reef House & Spa
The Sebel Reef House & Spa
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=19811 or tblfeedback.strbusinessname='The Sebel Reef House &%%semi%% Spa' or tblfeedback.strbusinessname='The Sebel Reef House & Spa') and year(getdate())-year(dtmadded)<=15
Sebel Reef House and Spa is the ideal venue for your wedding or reception. It has been voted "one of the most romantic places in the world".

Rating
Clarion hotel Mackay Marina
Mulherin Dr Mackay Marina QLD 4740
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=24868 or tblfeedback.strbusinessname='Clarion hotel Mackay Marina' or tblfeedback.strbusinessname='Clarion hotel Mackay Marina') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating