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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Auckland Hill B & B
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 & B' or tblfeedback.strbusinessname='Auckland Hill B & B') and year(getdate())-year(dtmadded)<=15
Rating
Rose Bay Resort
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
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