Rating
Gather Round Events
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=44195 or tblfeedback.strbusinessname='Gather Round Events' or tblfeedback.strbusinessname='Gather Round Events') 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
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
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