Rating
Oaks plaza pier
Glenelg SA 5045
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=25235 or tblfeedback.strbusinessname='Oaks plaza pier' or tblfeedback.strbusinessname='Oaks plaza pier') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stamford Grand
Glenelg SA 5045
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=19206 or tblfeedback.strbusinessname='Stamford Grand' or tblfeedback.strbusinessname='Stamford Grand') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Yatahlia Manor
Yatala Vale SA 5126
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=43829 or tblfeedback.strbusinessname='Yatahlia Manor' or tblfeedback.strbusinessname='Yatahlia Manor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Quality Inn International
Mt Gambier SA 5092
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=19177 or tblfeedback.strbusinessname='Quality Inn International' or tblfeedback.strbusinessname='Quality Inn International') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hilltop Garden Suites
Stirling SA 5152
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=19127 or tblfeedback.strbusinessname='Hilltop Garden Suites' or tblfeedback.strbusinessname='Hilltop Garden Suites') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15