Rating
Coast to Coast Golden Roast Canberra
Belconnen ACT 2616
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=24237 or tblfeedback.strbusinessname='Coast to Coast Golden Roast Canberra' or tblfeedback.strbusinessname='Coast to Coast Golden Roast Canberra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coast to Coast Golden Roast Townsville
Currajong QLD 4812
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=23726 or tblfeedback.strbusinessname='Coast to Coast Golden Roast Townsville' or tblfeedback.strbusinessname='Coast to Coast Golden Roast Townsville') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Round the way Bagels
Victoria VIC 3000
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=44528 or tblfeedback.strbusinessname='Round the way Bagels' or tblfeedback.strbusinessname='Round the way Bagels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
St Bee's Catering and Events
SA
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=41668 or tblfeedback.strbusinessname='St Bee'%%semi%%s Catering and Events' or tblfeedback.strbusinessname='St Bee's Catering and Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Two Chefs Catering
Mildura VIC 3500
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=24156 or tblfeedback.strbusinessname='Two Chefs Catering' or tblfeedback.strbusinessname='Two Chefs Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating