Rating
Novotel Geelong
Geelong VIC 3220
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=25852 or tblfeedback.strbusinessname='Novotel Geelong' or tblfeedback.strbusinessname='Novotel Geelong') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
All Seasons Ambassador Hotel Geelong
Geelong VIC 3220
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=14262 or tblfeedback.strbusinessname='All Seasons Ambassador Hotel Geelong' or tblfeedback.strbusinessname='All Seasons Ambassador Hotel Geelong') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Quality Inn Parkside
Belmont VIC 3216
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=14624 or tblfeedback.strbusinessname='Quality Inn Parkside' or tblfeedback.strbusinessname='Quality Inn Parkside') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Derwent Hotel
Batesford VIC 3221
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=881 or tblfeedback.strbusinessname='Derwent Hotel' or tblfeedback.strbusinessname='Derwent Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Waurn Ponds Hotel-Motel
Waurn Ponds VIC 3216
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=14734 or tblfeedback.strbusinessname='Waurn Ponds Hotel-Motel' or tblfeedback.strbusinessname='Waurn Ponds Hotel-Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15