Rating
Stamford Grand
2 Jetty Road 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Oaks plaza pier
16 Holdfast Promenade 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hilltop Garden Suites
11 Old Carey Gully Road 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Quality Inn International
Millicent Road 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating