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 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 year(getdate())-year(dtmadded)<=15