Rating
Dimitrios Speciality Cakes
Alawa 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=5133 or tblfeedback.strbusinessname='Dimitrios Speciality Cakes' or tblfeedback.strbusinessname='Dimitrios Speciality Cakes') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cakes by Gayle
Driver NT 0830
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=5134 or tblfeedback.strbusinessname='Cakes by Gayle' or tblfeedback.strbusinessname='Cakes by Gayle') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Duck's Nuts - Kurt's Cakes
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=19092 or tblfeedback.strbusinessname='Duck's Nuts - Kurt's Cakes' or tblfeedback.strbusinessname='Duck's Nuts - Kurt's Cakes') and year(getdate())-year(dtmadded)<=15