Rating
Salt Bar Kingscliff
Kingscliff NSW 2487
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=23139 or tblfeedback.strbusinessname='Salt Bar Kingscliff' or tblfeedback.strbusinessname='Salt Bar Kingscliff') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Byron Bay Weddings
Ewingsdale 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=25546 or tblfeedback.strbusinessname='Byron Bay Weddings' or tblfeedback.strbusinessname='Byron Bay Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Figtree Resturant
Ewingsdale 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=21967 or tblfeedback.strbusinessname='Figtree Resturant' or tblfeedback.strbusinessname='Figtree Resturant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Belongil
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=27221 or tblfeedback.strbusinessname='The Belongil' or tblfeedback.strbusinessname='The Belongil') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lord Byron Resort
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=10269 or tblfeedback.strbusinessname='Lord Byron Resort' or tblfeedback.strbusinessname='Lord Byron Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Beach Cafe Byron Bay
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=2212 or tblfeedback.strbusinessname='Beach Cafe Byron Bay' or tblfeedback.strbusinessname='Beach Cafe Byron Bay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Byron Bay Beach Club
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=8446 or tblfeedback.strbusinessname='Byron Bay Beach Club' or tblfeedback.strbusinessname='Byron Bay Beach Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pass Cafe The
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=10863 or tblfeedback.strbusinessname='Pass Cafe The' or tblfeedback.strbusinessname='Pass Cafe The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15