Rating
Forget Me Not Cottages
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
SeaWorld Nara Resort
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Townsville Plaza Hotel
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Legends Hotel
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15