Rating Sea Temple Resort & Spa Port Douglas, Pullman
Sea Temple Resort & Spa Port Douglas, Pullman
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, Pullman' or tblfeedback.strbusinessname='Sea Temple Resort & Spa Port Douglas, Pullman') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 tblfeedback.active = 1 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
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chillagoe Cabins and Tours
Chillagoe QLD 4871
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=44701 or tblfeedback.strbusinessname='Chillagoe Cabins and Tours' or tblfeedback.strbusinessname='Chillagoe Cabins and Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating