Rating
JR's Smokehouse
Murwillimbah NSW 2484
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=43552 or tblfeedback.strbusinessname='JR'%%semi%%s Smokehouse' or tblfeedback.strbusinessname='JR's Smokehouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Figtree Resturant
Ewingsdale NSW 2481
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=21967 or tblfeedback.strbusinessname='Figtree Resturant' or tblfeedback.strbusinessname='Figtree Resturant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flamin' Pizzas
Port Macquarie NSW 2444
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=25695 or tblfeedback.strbusinessname='Flamin'%%semi%% Pizzas' or tblfeedback.strbusinessname='Flamin' Pizzas') 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
Relish catering
Narrabri NSW 2390
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=23464 or tblfeedback.strbusinessname='Relish catering' or tblfeedback.strbusinessname='Relish catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bilambil Farm Spit Roast Catering
Cudgen NSW 2487
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=23242 or tblfeedback.strbusinessname='Bilambil Farm Spit Roast Catering' or tblfeedback.strbusinessname='Bilambil Farm Spit Roast Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Manning Valley Catering
Old Bar NSW 2430
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=41383 or tblfeedback.strbusinessname='Manning Valley Catering' or tblfeedback.strbusinessname='Manning Valley Catering') 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
Larder Byron Bay The
Byron Bay NSW 2481
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=10153 or tblfeedback.strbusinessname='Larder Byron Bay The' or tblfeedback.strbusinessname='Larder Byron Bay The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Spare Chef Catering
Coffs Harbour NSW 2450
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=11470 or tblfeedback.strbusinessname='Spare Chef Catering' or tblfeedback.strbusinessname='Spare Chef Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Savouries With a Twist
Coffs Harbour NSW 2450
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=18091 or tblfeedback.strbusinessname='Savouries With a Twist' or tblfeedback.strbusinessname='Savouries With a Twist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15