Rating
Bay of Fires Bush Retreat
Binnalong Bay TAS 7216
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=41661 or tblfeedback.strbusinessname='Bay of Fires Bush Retreat' or tblfeedback.strbusinessname='Bay of Fires Bush Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Low Head Beach House
Low Head TAS 7253
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=38016 or tblfeedback.strbusinessname='Low Head Beach House' or tblfeedback.strbusinessname='Low Head Beach House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating