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
The Bay Apartments Hervey Bay
Hervey Bay QLD 4655
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=21528 or tblfeedback.strbusinessname='The Bay Apartments Hervey Bay' or tblfeedback.strbusinessname='The Bay Apartments Hervey Bay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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 &%%semi%% B' or tblfeedback.strbusinessname='Auckland Hill B & B') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15