Rating
Park Hyatt Canberra
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=27337 or tblfeedback.strbusinessname='Park Hyatt Canberra' or tblfeedback.strbusinessname='Park Hyatt Canberra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Thredbo Alpine Hotel
Thredbo NSW 2625
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=39917 or tblfeedback.strbusinessname='Thredbo Alpine Hotel' or tblfeedback.strbusinessname='Thredbo Alpine Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hotel Kurrajong
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=3939 or tblfeedback.strbusinessname='Hotel Kurrajong' or tblfeedback.strbusinessname='Hotel Kurrajong') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gold Creek Station
Hall ACT 2618
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=37678 or tblfeedback.strbusinessname='Gold Creek Station' or tblfeedback.strbusinessname='Gold Creek Station') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Blackfire Restaurant
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=25685 or tblfeedback.strbusinessname='Blackfire Restaurant' or tblfeedback.strbusinessname='Blackfire Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Town of 1770 Golf Course
Round Hill ACT 4677
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=35850 or tblfeedback.strbusinessname='Town of 1770 Golf Course' or tblfeedback.strbusinessname='Town of 1770 Golf Course') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mount Imlay National Park
Marulan NSW 2580
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=27370 or tblfeedback.strbusinessname='Mount Imlay National Park' or tblfeedback.strbusinessname='Mount Imlay National Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ottoman Cuisine
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=23781 or tblfeedback.strbusinessname='Ottoman Cuisine' or tblfeedback.strbusinessname='Ottoman Cuisine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Astor Hotel Motel
Goulburn NSW 2580
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=27303 or tblfeedback.strbusinessname='Astor Hotel Motel' or tblfeedback.strbusinessname='Astor Hotel Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tuggeranong Homestead
Richardson ACT 2905
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=5640 or tblfeedback.strbusinessname='Tuggeranong Homestead' or tblfeedback.strbusinessname='Tuggeranong Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Decadent
Canberra ACT 2900
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=26699 or tblfeedback.strbusinessname='Decadent' or tblfeedback.strbusinessname='Decadent') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Riversdale Homestead
Goulburn NSW 2580
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=26876 or tblfeedback.strbusinessname='Riversdale Homestead' or tblfeedback.strbusinessname='Riversdale Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kangaroo Valley Bush Retreat
Kangaroo Valley NSW 2577
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=25182 or tblfeedback.strbusinessname='Kangaroo Valley Bush Retreat' or tblfeedback.strbusinessname='Kangaroo Valley Bush Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
St.Edwards of the Riverina
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=27395 or tblfeedback.strbusinessname='St.Edwards of the Riverina' or tblfeedback.strbusinessname='St.Edwards of the Riverina') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Siesta Villa resort
Jindabyne East NSW 2627
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=24973 or tblfeedback.strbusinessname='Siesta Villa resort' or tblfeedback.strbusinessname='Siesta Villa resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Athenian The
Phillip ACT 2606
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=3913 or tblfeedback.strbusinessname='Athenian The' or tblfeedback.strbusinessname='Athenian The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cavalier Restaurant
Red Hill ACT 2603
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=3908 or tblfeedback.strbusinessname='Cavalier Restaurant' or tblfeedback.strbusinessname='Cavalier Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bicentennial Function Centre
Queanbeyan NSW 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=1955 or tblfeedback.strbusinessname='Bicentennial Function Centre' or tblfeedback.strbusinessname='Bicentennial Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
West Belconnen Leagues 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=3966 or tblfeedback.strbusinessname='West Belconnen Leagues Club' or tblfeedback.strbusinessname='West Belconnen Leagues Club') 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
Rating
Juniperberry
Parkes 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=3944 or tblfeedback.strbusinessname='Juniperberry' or tblfeedback.strbusinessname='Juniperberry') 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
Central Motel Reception Centre
Queanbeyan NSW 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=8591 or tblfeedback.strbusinessname='Central Motel Reception Centre' or tblfeedback.strbusinessname='Central Motel Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Burra Station Homestead
Burra Creek NSW 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=8430 or tblfeedback.strbusinessname='Burra Station Homestead' or tblfeedback.strbusinessname='Burra Station Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goulburn Golf Club Ltd
Goulburn NSW 2580
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=9509 or tblfeedback.strbusinessname='Goulburn Golf Club Ltd' or tblfeedback.strbusinessname='Goulburn Golf Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Boffins
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=5631 or tblfeedback.strbusinessname='Boffins' or tblfeedback.strbusinessname='Boffins') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Connoisseur Catering
Belconnen ACT 2617
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=3909 or tblfeedback.strbusinessname='Connoisseur Catering' or tblfeedback.strbusinessname='Connoisseur Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Southern Star Inn
Goulburn NSW 2580
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=11467 or tblfeedback.strbusinessname='Southern Star Inn' or tblfeedback.strbusinessname='Southern Star Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brassey of Canberra The
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=3920 or tblfeedback.strbusinessname='Brassey of Canberra The' or tblfeedback.strbusinessname='Brassey of Canberra The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Riversdale National Trust
Goulburn NSW 2580
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=11163 or tblfeedback.strbusinessname='Riversdale National Trust' or tblfeedback.strbusinessname='Riversdale National Trust') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rydges Lakeside Canberra
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=3960 or tblfeedback.strbusinessname='Rydges Lakeside Canberra' or tblfeedback.strbusinessname='Rydges Lakeside Canberra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Billabong Wedding Reception Venue The
Goulburn NSW 2580
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=8207 or tblfeedback.strbusinessname='Billabong Wedding Reception Venue The' or tblfeedback.strbusinessname='Billabong Wedding Reception Venue The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Deck at Regatta Point
Parkes 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=19223 or tblfeedback.strbusinessname='The Deck at Regatta Point' or tblfeedback.strbusinessname='The Deck at Regatta Point') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Chifley On Northbourne
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=3962 or tblfeedback.strbusinessname='The Chifley On Northbourne' or tblfeedback.strbusinessname='The Chifley On Northbourne') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Western District Rugby Union Club
Macquarie ACT 2614
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=5641 or tblfeedback.strbusinessname='Western District Rugby Union Club' or tblfeedback.strbusinessname='Western District Rugby Union Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Best Western Centretown Goulburn
Goulburn NSW 2580
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=8189 or tblfeedback.strbusinessname='Best Western Centretown Goulburn' or tblfeedback.strbusinessname='Best Western Centretown Goulburn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Diplomat
Manuka ACT 2603
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=3928 or tblfeedback.strbusinessname='Diplomat' or tblfeedback.strbusinessname='Diplomat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Canberra R S L Memorial & Citizens Club Ltd
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=5632 or tblfeedback.strbusinessname='Canberra R S L Memorial &%%semi%% Citizens Club Ltd' or tblfeedback.strbusinessname='Canberra R S L Memorial & Citizens Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pelican Sheep Station Restaurant
Goulburn NSW 2580
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=10884 or tblfeedback.strbusinessname='Pelican Sheep Station Restaurant' or tblfeedback.strbusinessname='Pelican Sheep Station Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian Institute of Sport
Bruce ACT 2617
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=3915 or tblfeedback.strbusinessname='Australian Institute of Sport' or tblfeedback.strbusinessname='Australian Institute of Sport') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chifley on Northbourne The
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=5633 or tblfeedback.strbusinessname='Chifley on Northbourne The' or tblfeedback.strbusinessname='Chifley on Northbourne The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Old Parliament House
Parkes 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=3952 or tblfeedback.strbusinessname='Old Parliament House' or tblfeedback.strbusinessname='Old Parliament House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rydges Capital Hill Canberra
Forrest ACT 2603
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=3958 or tblfeedback.strbusinessname='Rydges Capital Hill Canberra' or tblfeedback.strbusinessname='Rydges Capital Hill Canberra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gallery Function Centre The
Watson 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=3934 or tblfeedback.strbusinessname='Gallery Function Centre The' or tblfeedback.strbusinessname='Gallery Function Centre The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Belconnen Hotel/Motel & Services Apartments
Hawker Belconnen ACT 2617
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=3916 or tblfeedback.strbusinessname='Belconnen Hotel/Motel &%%semi%% Services Apartments' or tblfeedback.strbusinessname='Belconnen Hotel/Motel & Services Apartments') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kamberra Wine Company
Lyneham 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=3945 or tblfeedback.strbusinessname='Kamberra Wine Company' or tblfeedback.strbusinessname='Kamberra Wine Company') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Abbey Function Centre
Nicholls ACT 2913
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=19219 or tblfeedback.strbusinessname='The Abbey Function Centre' or tblfeedback.strbusinessname='The Abbey Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jamison Inn Hotel Motel
Belconnen ACT 2617
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=3943 or tblfeedback.strbusinessname='Jamison Inn Hotel Motel' or tblfeedback.strbusinessname='Jamison Inn Hotel Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hellenic Club of Canberra Ltd
Woden ACT 2606
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=5634 or tblfeedback.strbusinessname='Hellenic Club of Canberra Ltd' or tblfeedback.strbusinessname='Hellenic Club of Canberra Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
1 - 50 of 116 Sort search results alphabetically