Rating
Portee Station Blanchetown
Blanchetown SA 5357
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=27027 or tblfeedback.strbusinessname='Portee Station Blanchetown' or tblfeedback.strbusinessname='Portee Station Blanchetown') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Loxton Hotel
Loxton SA 5333
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=19149 or tblfeedback.strbusinessname='Loxton Hotel' or tblfeedback.strbusinessname='Loxton Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hamley House Restaurant
Berri SA 5343
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=6433 or tblfeedback.strbusinessname='Hamley House Restaurant' or tblfeedback.strbusinessname='Hamley House Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Renmark Club The
Renmark SA 5341
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=6499 or tblfeedback.strbusinessname='Renmark Club The' or tblfeedback.strbusinessname='Renmark Club The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Barmera-Monash Football Club
Barmera SA 5345
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=6366 or tblfeedback.strbusinessname='Barmera-Monash Football Club' or tblfeedback.strbusinessname='Barmera-Monash Football Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barmera Hotel-Motel
Barmera SA 5345
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=6365 or tblfeedback.strbusinessname='Barmera Hotel-Motel' or tblfeedback.strbusinessname='Barmera Hotel-Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15