Rating
National Press Club
Barton ACT 2600
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=3950 or tblfeedback.strbusinessname='National Press Club' or tblfeedback.strbusinessname='National Press Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mr Papa
Braddon ACT 2612
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=25084 or tblfeedback.strbusinessname='Mr Papa' or tblfeedback.strbusinessname='Mr Papa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lamotte's Catering
Wagga Wagga NSW 2650
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=27396 or tblfeedback.strbusinessname='Lamotte'%%semi%%s Catering' or tblfeedback.strbusinessname='Lamotte's Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Goolabri Estate
Sutton ACT 2620
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=41537 or tblfeedback.strbusinessname='Goolabri Estate' or tblfeedback.strbusinessname='Goolabri Estate') 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
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
East Street Canberra
Canberra ACT 2601
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=41365 or tblfeedback.strbusinessname='East Street Canberra' or tblfeedback.strbusinessname='East Street Canberra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Connoisseur Catering
Canberra City ACT 2601
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=5485 or tblfeedback.strbusinessname='Connoisseur Catering' or tblfeedback.strbusinessname='Connoisseur Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ANU Union Function & Conference Centre
Canberra City ACT 2601
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=5482 or tblfeedback.strbusinessname='ANU Union Function &%%semi%% Conference Centre' or tblfeedback.strbusinessname='ANU Union Function & Conference Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jean-Jacques
Yarralumla ACT 2600
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=5488 or tblfeedback.strbusinessname='Jean-Jacques' or tblfeedback.strbusinessname='Jean-Jacques') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barocca
Canberra City ACT 2601
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=5483 or tblfeedback.strbusinessname='Barocca' or tblfeedback.strbusinessname='Barocca') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Regatta Point Restaurant
Canberra City ACT 2601
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=3910 or tblfeedback.strbusinessname='Regatta Point Restaurant' or tblfeedback.strbusinessname='Regatta Point Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hudsons of Dickson
Dickson ACT 2602
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=5487 or tblfeedback.strbusinessname='Hudsons of Dickson' or tblfeedback.strbusinessname='Hudsons of Dickson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Buffet Express
Canberra ACT 2601
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=5484 or tblfeedback.strbusinessname='Buffet Express' or tblfeedback.strbusinessname='Buffet Express') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kitchen Witchery
Canberra ACT 2601
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=3946 or tblfeedback.strbusinessname='Kitchen Witchery' or tblfeedback.strbusinessname='Kitchen Witchery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Woodhaven Green Golf Club
Holt ACT 2615
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=3967 or tblfeedback.strbusinessname='Woodhaven Green Golf Club' or tblfeedback.strbusinessname='Woodhaven Green Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15