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 tblfeedback.active = 1 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
Dalby Mid-Town Motor Inn
Dalby QLD 4405
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=19012 or tblfeedback.strbusinessname='Dalby Mid-Town Motor Inn' or tblfeedback.strbusinessname='Dalby Mid-Town Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15