Rating
Pialligo Estate
Pialligo ACT 2609
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=43024 or tblfeedback.strbusinessname='Pialligo Estate' or tblfeedback.strbusinessname='Pialligo Estate') 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
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
Nu-Lumeah Weddings
Springvale 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=43932 or tblfeedback.strbusinessname='Nu-Lumeah Weddings' or tblfeedback.strbusinessname='Nu-Lumeah Weddings') 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
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
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
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
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
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
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
The Hyatt Hotel 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='The Hyatt Hotel Canberra' or tblfeedback.strbusinessname='The Hyatt Hotel Canberra') 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
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
The Carrington Inn
Bungendore NSW 2621
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=41212 or tblfeedback.strbusinessname='The Carrington Inn' or tblfeedback.strbusinessname='The Carrington Inn') 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
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
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Federation Function Centre
Gungahlin ACT 2912
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=3932 or tblfeedback.strbusinessname='Federation Function Centre' or tblfeedback.strbusinessname='Federation Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
First Floor
Kingston ACT 2604
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=3933 or tblfeedback.strbusinessname='First Floor' or tblfeedback.strbusinessname='First Floor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Italo-Australian Club Inc.
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=3942 or tblfeedback.strbusinessname='Italo-Australian Club Inc.' or tblfeedback.strbusinessname='Italo-Australian Club Inc.') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Albert Hall
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=3911 or tblfeedback.strbusinessname='Albert Hall' or tblfeedback.strbusinessname='Albert Hall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cuppacumbalong Homestead
Tharwa 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=19080 or tblfeedback.strbusinessname='Cuppacumbalong Homestead' or tblfeedback.strbusinessname='Cuppacumbalong Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Country Comfort Greenway
Greenway 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=3927 or tblfeedback.strbusinessname='Country Comfort Greenway' or tblfeedback.strbusinessname='Country Comfort Greenway') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vivaldi Restaurant
Acton 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=3965 or tblfeedback.strbusinessname='Vivaldi Restaurant' or tblfeedback.strbusinessname='Vivaldi Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Northbourne Restaurant The
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=5637 or tblfeedback.strbusinessname='Northbourne Restaurant The' or tblfeedback.strbusinessname='Northbourne Restaurant The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goulburn Workers Club
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=9512 or tblfeedback.strbusinessname='Goulburn Workers Club' or tblfeedback.strbusinessname='Goulburn Workers Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Canberra Southern Cross Club
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=3907 or tblfeedback.strbusinessname='Canberra Southern Cross Club' or tblfeedback.strbusinessname='Canberra Southern Cross Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Trappers Motel & 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=11775 or tblfeedback.strbusinessname='Trappers Motel &%%semi%% Restaurant' or tblfeedback.strbusinessname='Trappers Motel & Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hill Station Historical Property
Hume 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=3904 or tblfeedback.strbusinessname='Hill Station Historical Property' or tblfeedback.strbusinessname='Hill Station Historical Property') 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
Harmonie German Club Inc
Narrabundah ACT 2604
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=3937 or tblfeedback.strbusinessname='Harmonie German Club Inc' or tblfeedback.strbusinessname='Harmonie German Club Inc') 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
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
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
Swaggers Steak Bar
Yass NSW 2582
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=11631 or tblfeedback.strbusinessname='Swaggers Steak Bar' or tblfeedback.strbusinessname='Swaggers Steak Bar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goulburn Club
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=9507 or tblfeedback.strbusinessname='Goulburn Club' or tblfeedback.strbusinessname='Goulburn Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Old Goulburn Brewery
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=10768 or tblfeedback.strbusinessname='Old Goulburn Brewery' or tblfeedback.strbusinessname='Old Goulburn Brewery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Italo-Australian Club Inc
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=5635 or tblfeedback.strbusinessname='Italo-Australian Club Inc' or tblfeedback.strbusinessname='Italo-Australian Club Inc') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
University House Hotel
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=3964 or tblfeedback.strbusinessname='University House Hotel' or tblfeedback.strbusinessname='University House Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lobby Restaurant The
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=3949 or tblfeedback.strbusinessname='Lobby Restaurant The' or tblfeedback.strbusinessname='Lobby Restaurant The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Quality Hotel 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=3956 or tblfeedback.strbusinessname='Quality Hotel Diplomat' or tblfeedback.strbusinessname='Quality Hotel Diplomat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hellenic Club
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=19126 or tblfeedback.strbusinessname='Hellenic Club' or tblfeedback.strbusinessname='Hellenic Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pavilion on Northbourne Hotel & Serviced Apartments
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=5638 or tblfeedback.strbusinessname='Pavilion on Northbourne Hotel &%%semi%% Serviced Apartments' or tblfeedback.strbusinessname='Pavilion on Northbourne Hotel & Serviced Apartments') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Airport Motor Inn
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=2146 or tblfeedback.strbusinessname='Airport Motor Inn' or tblfeedback.strbusinessname='Airport Motor Inn') 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=3924 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
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 Premier Inn
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=3917 or tblfeedback.strbusinessname='Belconnen Premier Inn' or tblfeedback.strbusinessname='Belconnen Premier Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 119 Sort search results alphabetically