Rating
Byron Bay Kombis
Byron Bay NSW 2481
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=27423 or tblfeedback.strbusinessname='Byron Bay Kombis' or tblfeedback.strbusinessname='Byron Bay Kombis') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Lennox Hotel
Lennox Heads NSW 2478
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=26868 or tblfeedback.strbusinessname='The Lennox Hotel' or tblfeedback.strbusinessname='The Lennox Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
May The E.K Byron Bay
Bangalow NSW 2479
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=37674 or tblfeedback.strbusinessname='May The E.K Byron Bay' or tblfeedback.strbusinessname='May The E.K Byron Bay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Byron Kombi Limo
Ballina NSW 2481
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=43544 or tblfeedback.strbusinessname='Byron Kombi Limo' or tblfeedback.strbusinessname='Byron Kombi Limo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating