Rating
Forget Me Not Cottages
20 Pine Creek Road Springbrook QLD 4213
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=19013 or tblfeedback.strbusinessname='Forget Me Not Cottages' or tblfeedback.strbusinessname='Forget Me Not Cottages') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Legends Hotel
PO Box 1587 Surfers Paradise QLD 4217
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=19014 or tblfeedback.strbusinessname='Legends Hotel' or tblfeedback.strbusinessname='Legends Hotel') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
SeaWorld Nara Resort
Seaworld Drive Main Beach QLD 4215
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=19017 or tblfeedback.strbusinessname='SeaWorld Nara Resort' or tblfeedback.strbusinessname='SeaWorld Nara Resort') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Townsville Plaza Hotel
50 Cavill Ave Surfers Paradise QLD 4217
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=19019 or tblfeedback.strbusinessname='Townsville Plaza Hotel' or tblfeedback.strbusinessname='Townsville Plaza Hotel') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating