Rating
Cable Beach Club Resort
Cable Beach WA 6725
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=32483 or tblfeedback.strbusinessname='Cable Beach Club Resort' or tblfeedback.strbusinessname='Cable Beach Club Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pyrgos Reception Santorini
Santorini NSW
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=29694 or tblfeedback.strbusinessname='Pyrgos Reception Santorini' or tblfeedback.strbusinessname='Pyrgos Reception Santorini') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mangrove Hotel Broome
Broome WA 6725
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=29720 or tblfeedback.strbusinessname='Mangrove Hotel Broome' or tblfeedback.strbusinessname='Mangrove Hotel Broome') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mahaweli Reach Hotel
Kandy WA 20000
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=35750 or tblfeedback.strbusinessname='Mahaweli Reach Hotel' or tblfeedback.strbusinessname='Mahaweli Reach Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brookleigh Estate
Upper Swan WA 6069
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=24182 or tblfeedback.strbusinessname='Brookleigh Estate' or tblfeedback.strbusinessname='Brookleigh Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cable Beach Sand Bar and Grill
Broome WA 6725
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=17924 or tblfeedback.strbusinessname='Cable Beach Sand Bar and Grill' or tblfeedback.strbusinessname='Cable Beach Sand Bar and Grill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tambrey Centre
Karratha WA 6714
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=4154 or tblfeedback.strbusinessname='Tambrey Centre' or tblfeedback.strbusinessname='Tambrey Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Karratha International Motel Pty Ltd
Karratha WA 6714
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=4095 or tblfeedback.strbusinessname='Karratha International Motel Pty Ltd' or tblfeedback.strbusinessname='Karratha International Motel Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15