Rating
Dimitrios Speciality Cakes
Shop 2 Alawa Crescent <BR>Alawa Village 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
3 McInnis Circuit 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
GPO Box 1037 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'%%semi%%s Nuts - Kurt'%%semi%%s Cakes' or tblfeedback.strbusinessname='Duck's Nuts - Kurt's Cakes') and year(getdate())-year(dtmadded)<=15