Rating
Baked by jess
Geelong VIC 3220
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=29442 or tblfeedback.strbusinessname='Baked by jess' or tblfeedback.strbusinessname='Baked by jess') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sweet designs by Claire
Belmont VIC 3216
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=22949 or tblfeedback.strbusinessname='Sweet designs by Claire' or tblfeedback.strbusinessname='Sweet designs by Claire') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
ILMA Cakes
Warrnambool VIC 3280
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=29416 or tblfeedback.strbusinessname='ILMA Cakes' or tblfeedback.strbusinessname='ILMA Cakes') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Merle's Cakes
Grovedale VIC 3216
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=17803 or tblfeedback.strbusinessname='Merle's Cakes' or tblfeedback.strbusinessname='Merle's Cakes') and year(getdate())-year(dtmadded)<=15
Rating
Merle's Home Made Cakes
Grovedale VIC 3216
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=12681 or tblfeedback.strbusinessname='Merle's Home Made Cakes' or tblfeedback.strbusinessname='Merle's Home Made Cakes') and year(getdate())-year(dtmadded)<=15
Rating
Professional Cake Decorating
Newtown VIC 3220
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=12685 or tblfeedback.strbusinessname='Professional Cake Decorating' or tblfeedback.strbusinessname='Professional Cake Decorating') and year(getdate())-year(dtmadded)<=15