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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating