Rating
The FarmHouse Meletos
12 St Huberts Rd Coldstream VIC 3770
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=29355 or tblfeedback.strbusinessname='The FarmHouse Meletos' or tblfeedback.strbusinessname='The FarmHouse Meletos') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cedar Lodge Motor Inn
1 Maryvale Crescent Morwell VIC 3840
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=14336 or tblfeedback.strbusinessname='Cedar Lodge Motor Inn' or tblfeedback.strbusinessname='Cedar Lodge Motor Inn') and year(getdate())-year(dtmadded)<=15
Rating
Drouin Motor Inn
275 Princes Way Drouin VIC 3818
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=14384 or tblfeedback.strbusinessname='Drouin Motor Inn' or tblfeedback.strbusinessname='Drouin Motor Inn') and year(getdate())-year(dtmadded)<=15
Rating
Hacienda International Motor Inn
Raymond Street<BR>Cnr Princes Hwy Sale VIC 3850
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=14446 or tblfeedback.strbusinessname='Hacienda International Motor Inn' or tblfeedback.strbusinessname='Hacienda International Motor Inn') and year(getdate())-year(dtmadded)<=15
Rating
Sundowner Chain Motor Inn-Traralgon
40 Princes Highway Traralgon VIC 3844
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=14688 or tblfeedback.strbusinessname='Sundowner Chain Motor Inn-Traralgon' or tblfeedback.strbusinessname='Sundowner Chain Motor Inn-Traralgon') and year(getdate())-year(dtmadded)<=15