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
Dragonfly Catering and Events
Katherine NT 0850
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=24396 or tblfeedback.strbusinessname='Dragonfly Catering and Events' or tblfeedback.strbusinessname='Dragonfly Catering and 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
Regency Party Hire
Parap NT 0820
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=4772 or tblfeedback.strbusinessname='Regency Party Hire' or tblfeedback.strbusinessname='Regency Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
C & C Catering
Sanderson NT 0813
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=4761 or tblfeedback.strbusinessname='C &%%semi%% C Catering' or tblfeedback.strbusinessname='C & C Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
C&C Catering
Karama NT 0812
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=19056 or tblfeedback.strbusinessname='C&%%semi%%C Catering' or tblfeedback.strbusinessname='C&C Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Schubert's Catering Services
Casuarina 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=4775 or tblfeedback.strbusinessname='Schubert'%%semi%%s Catering Services' or tblfeedback.strbusinessname='Schubert's Catering Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Magnum's the Mobile Spit Roast Specialists
Casuarina 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=5135 or tblfeedback.strbusinessname='Magnum'%%semi%%s the Mobile Spit Roast Specialists' or tblfeedback.strbusinessname='Magnum's the Mobile Spit Roast Specialists') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Darwin Party Hire
Berrimah NT 0828
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=4765 or tblfeedback.strbusinessname='Darwin Party Hire' or tblfeedback.strbusinessname='Darwin Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Schubert's Beachfront
Casuarina 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=4774 or tblfeedback.strbusinessname='Schubert'%%semi%%s Beachfront' or tblfeedback.strbusinessname='Schubert's Beachfront') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Territory Party Hire
Coconut Grove 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=4778 or tblfeedback.strbusinessname='Territory Party Hire' or tblfeedback.strbusinessname='Territory Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating