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
King's Katering
Edenhope SA 5271
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=35579 or tblfeedback.strbusinessname='King'%%semi%%s Katering' or tblfeedback.strbusinessname='King's Katering') 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
GJ Catering
Mount Gambier SA 5290
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=5752 or tblfeedback.strbusinessname='GJ Catering' or tblfeedback.strbusinessname='GJ Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ann's Complete Catering
Mount Gambier SA 5290
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=5738 or tblfeedback.strbusinessname='Ann'%%semi%%s Complete Catering' or tblfeedback.strbusinessname='Ann's Complete Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barn Palais The
O b Flat SA 5291
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=5742 or tblfeedback.strbusinessname='Barn Palais The' or tblfeedback.strbusinessname='Barn Palais The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15