Rating
Novotel Geelong
10-14 Eastern Beach Road 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
700 Ballarat Road 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
Myers Street<BR>Cnr Gheringhap St 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
68 High Street 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
Princes Highway 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