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
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
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
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
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
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
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