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
Park Hotel
Ballarat VIC 3350
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=14586 or tblfeedback.strbusinessname='Park Hotel' or tblfeedback.strbusinessname='Park Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mercure Inn Belltower-Ballarat
Ballarat VIC 3350
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=14534 or tblfeedback.strbusinessname='Mercure Inn Belltower-Ballarat' or tblfeedback.strbusinessname='Mercure Inn Belltower-Ballarat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Rating
Mid-City Motor Inn
Ballarat VIC 3350
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=14537 or tblfeedback.strbusinessname='Mid-City Motor Inn' or tblfeedback.strbusinessname='Mid-City Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Craig's Royal Hotel
Ballarat VIC 3350
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=14365 or tblfeedback.strbusinessname='Craig'%%semi%%s Royal Hotel' or tblfeedback.strbusinessname='Craig's Royal Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15