Rating
Carlton Hotel
The Esplanade Darwin NT 0800
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=19060 or tblfeedback.strbusinessname='Carlton Hotel' or tblfeedback.strbusinessname='Carlton Hotel') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cullen Bay Apartments
26 Marina Blv Larrakeyah NT 0810
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=19079 or tblfeedback.strbusinessname='Cullen Bay Apartments' or tblfeedback.strbusinessname='Cullen Bay Apartments') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating