Home > Reception Venue Canberra

Reception Venue Canberra

119 result(s) found. View Your Favorites List

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
2 reviews

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

5 stars
1 review

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

5 stars
3 reviews

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

5 stars
1 review

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

4 stars
2 reviews

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

5 stars
2 reviews

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

4 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
8 reviews

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

4.67 stars
3 reviews

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
2 reviews

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

5 stars
1 review

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

4 stars
1 review

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5 stars
1 review

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

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

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

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

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