Rating The Retreat at Amryhouse
The Retreat at Amryhouse
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=36268 or tblfeedback.strbusinessname='The Retreat at Amryhouse' or tblfeedback.strbusinessname='The Retreat at Amryhouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

Rating
Quality Resort All Seasons Bendigo
Bendigo VIC 3550
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=14263 or tblfeedback.strbusinessname='Quality Resort All Seasons Bendigo' or tblfeedback.strbusinessname='Quality Resort All Seasons Bendigo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shamrock Hotel
Bendigo VIC 3550
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=17484 or tblfeedback.strbusinessname='Shamrock Hotel' or tblfeedback.strbusinessname='Shamrock Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15