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
Rating
Auckland Hill B & B
15 Yarroon St Gladstone QLD 4680
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=19010 or tblfeedback.strbusinessname='Auckland Hill B &%%semi%% B' or tblfeedback.strbusinessname='Auckland Hill B & B') and year(getdate())-year(dtmadded)<=15
Rating
Rose Bay Resort
2 Pandanus St Bowen QLD 4805
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=19016 or tblfeedback.strbusinessname='Rose Bay Resort' or tblfeedback.strbusinessname='Rose Bay Resort') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coopers Couples Retreat
850 Gooburrum Road Bundaberg QLD 4670
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=19913 or tblfeedback.strbusinessname='Coopers Couples Retreat' or tblfeedback.strbusinessname='Coopers Couples Retreat ') and year(getdate())-year(dtmadded)<=15