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