Rating
Riversleigh Bairnsdale
Bairnsdale VIC 3875
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=39751 or tblfeedback.strbusinessname='Riversleigh Bairnsdale' or tblfeedback.strbusinessname='Riversleigh Bairnsdale') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The FarmHouse Meletos
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Milton Boutique Apartments
Corryong VIC 3707
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=42812 or tblfeedback.strbusinessname='The Milton Boutique Apartments' or tblfeedback.strbusinessname='The Milton Boutique Apartments') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sundowner Chain Motor Inn-Traralgon
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cedar Lodge Motor Inn
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hacienda International Motor Inn
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Drouin Motor Inn
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15