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
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
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
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
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
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
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
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
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
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
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
Gunghalin lakes golf club
Gunghalin 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=44304 or tblfeedback.strbusinessname='Gunghalin lakes golf club' or tblfeedback.strbusinessname='Gunghalin lakes golf club') 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
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
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
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
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
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
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
Grazing
Gundaroo NSW 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=21825 or tblfeedback.strbusinessname='Grazing' or tblfeedback.strbusinessname='Grazing') 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
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
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
Belconnen Hotel/Motel & Serviced Apartments
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=5630 or tblfeedback.strbusinessname='Belconnen Hotel/Motel &%%semi%% Serviced Apartments' or tblfeedback.strbusinessname='Belconnen Hotel/Motel & Serviced Apartments') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
University House Hotel
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=3906 or tblfeedback.strbusinessname='University House Hotel' or tblfeedback.strbusinessname='University House Hotel') 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
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
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
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
Chairman & Yip 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=3926 or tblfeedback.strbusinessname='Chairman &%%semi%% Yip Restaurant' or tblfeedback.strbusinessname='Chairman & Yip Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Lobby Restaurant
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=19230 or tblfeedback.strbusinessname='The Lobby Restaurant' or tblfeedback.strbusinessname='The Lobby Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Embassy Motel
Deakin 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=3930 or tblfeedback.strbusinessname='Embassy Motel' or tblfeedback.strbusinessname='Embassy Motel') 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
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
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
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
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
Murrumbateman Winery
Murrumbateman 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=10602 or tblfeedback.strbusinessname='Murrumbateman Winery' or tblfeedback.strbusinessname='Murrumbateman Winery') 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 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
Rydges Eagle Hawk Resort 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=3959 or tblfeedback.strbusinessname='Rydges Eagle Hawk Resort Canberra' or tblfeedback.strbusinessname='Rydges Eagle Hawk Resort Canberra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
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
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
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
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
1 - 50 of 121 Sort search results alphabetically