Rating
Elizabeth Grove Reception Centre
Liverpool NSW 2170
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=9147 or tblfeedback.strbusinessname='Elizabeth Grove Reception Centre' or tblfeedback.strbusinessname='Elizabeth Grove Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sydney Huntley Inn
Gladesville NSW 2111
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=11648 or tblfeedback.strbusinessname='Sydney Huntley Inn' or tblfeedback.strbusinessname='Sydney Huntley Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Macquarie Function Centre
Liverpool NSW 2170
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=10313 or tblfeedback.strbusinessname='Macquarie Function Centre' or tblfeedback.strbusinessname='Macquarie Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beach Hut Le
Dolls Point NSW 2219
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=8117 or tblfeedback.strbusinessname='Beach Hut Le' or tblfeedback.strbusinessname='Beach Hut Le') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gledswood Homestead Country Weddings
Catherine Field NSW 2171
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=9469 or tblfeedback.strbusinessname='Gledswood Homestead Country Weddings' or tblfeedback.strbusinessname='Gledswood Homestead Country Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Moore Park Golf Club
Moore Park NSW 2021
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=10549 or tblfeedback.strbusinessname='Moore Park Golf Club' or tblfeedback.strbusinessname='Moore Park Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bayview Conference & Function Centre
Miranda NSW 2228
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=2210 or tblfeedback.strbusinessname='Bayview Conference &%%semi%% Function Centre' or tblfeedback.strbusinessname='Bayview Conference & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elim Function Centre
Burwood NSW 2134
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=1902 or tblfeedback.strbusinessname='Elim Function Centre' or tblfeedback.strbusinessname='Elim Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
MCA
Sydney NSW 2000
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=18280 or tblfeedback.strbusinessname='MCA' or tblfeedback.strbusinessname='MCA') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
ANA Harbour Grand Hotel Sydney
Sydney NSW 2000
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=4662 or tblfeedback.strbusinessname='ANA Harbour Grand Hotel Sydney' or tblfeedback.strbusinessname='ANA Harbour Grand Hotel Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hyde Park Plaza Suites
Sydney NSW 2000
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=9775 or tblfeedback.strbusinessname='Hyde Park Plaza Suites' or tblfeedback.strbusinessname='Hyde Park Plaza Suites') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Loxley on Bellbird Hill
Kurrajong Hills NSW 2758
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=10281 or tblfeedback.strbusinessname='Loxley on Bellbird Hill' or tblfeedback.strbusinessname='Loxley on Bellbird Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Castel D'Oro Function Centre
Five Dock NSW 2046
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=8553 or tblfeedback.strbusinessname='Castel D'%%semi%%Oro Function Centre' or tblfeedback.strbusinessname='Castel D'Oro Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Honeymoons & Weddings
Sydney NSW 2000
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=7658 or tblfeedback.strbusinessname='Honeymoons &%%semi%% Weddings' or tblfeedback.strbusinessname='Honeymoons & Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Harbour Watch Restaurant
The Rocks NSW 2000
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=1903 or tblfeedback.strbusinessname='The Harbour Watch Restaurant' or tblfeedback.strbusinessname='The Harbour Watch Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Le Kiosk
Manly NSW 2095
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=18276 or tblfeedback.strbusinessname='Le Kiosk' or tblfeedback.strbusinessname='Le Kiosk') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rex Hotel Sydney The
Potts Point NSW 2011
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=11135 or tblfeedback.strbusinessname='Rex Hotel Sydney The' or tblfeedback.strbusinessname='Rex Hotel Sydney The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Star Room
Sydney NSW 2000
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=18292 or tblfeedback.strbusinessname='Star Room' or tblfeedback.strbusinessname='Star Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Abbey Restaurant The
Glebe NSW 2037
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=2129 or tblfeedback.strbusinessname='Abbey Restaurant The' or tblfeedback.strbusinessname='Abbey Restaurant The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barnaby's Waterfront Restaurants
Lansdowne NSW 2163
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=8091 or tblfeedback.strbusinessname='Barnaby'%%semi%%s Waterfront Restaurants' or tblfeedback.strbusinessname='Barnaby's Waterfront Restaurants') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A 1 Caterers
Parramatta NSW 2150
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=2112 or tblfeedback.strbusinessname='A 1 Caterers' or tblfeedback.strbusinessname='A 1 Caterers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
As You Like It! Catering
North Narrabeen NSW 2101
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=2179 or tblfeedback.strbusinessname='As You Like It!%%semi%% Catering' or tblfeedback.strbusinessname='As You Like It! Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Westside & Astra Reception Lounges
Marrickville NSW 2204
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=12015 or tblfeedback.strbusinessname='Westside &%%semi%% Astra Reception Lounges' or tblfeedback.strbusinessname='Westside & Astra Reception Lounges') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mount Pritchard & District Community Club
Mount Pritchard NSW 2170
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=10575 or tblfeedback.strbusinessname='Mount Pritchard &%%semi%% District Community Club' or tblfeedback.strbusinessname='Mount Pritchard & District Community Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Prunier's
Woollahra NSW 2025
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=11077 or tblfeedback.strbusinessname='Prunier'%%semi%%s' or tblfeedback.strbusinessname='Prunier's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Beach House Restaurant
Whale Beach NSW 2107
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=8115 or tblfeedback.strbusinessname='Beach House Restaurant' or tblfeedback.strbusinessname='Beach House Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
LA Palma Restaurant
Palm Beach NSW 2108
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=10135 or tblfeedback.strbusinessname='LA Palma Restaurant' or tblfeedback.strbusinessname='LA Palma Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mode Group The
Sydney NSW 2000
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=10531 or tblfeedback.strbusinessname='Mode Group The' or tblfeedback.strbusinessname='Mode Group The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rockdale Reception Centre
Rockdale NSW 2216
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=2066 or tblfeedback.strbusinessname='Rockdale Reception Centre' or tblfeedback.strbusinessname='Rockdale Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Killara Inn Boutique Hotel
Killara NSW 2071
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=10073 or tblfeedback.strbusinessname='Killara Inn Boutique Hotel' or tblfeedback.strbusinessname='Killara Inn Boutique Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Main Event Function Centre
Blacktown NSW 2148
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=10333 or tblfeedback.strbusinessname='Main Event Function Centre' or tblfeedback.strbusinessname='Main Event Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Harold Park Function Centre
Glebe NSW 2037
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=9618 or tblfeedback.strbusinessname='Harold Park Function Centre' or tblfeedback.strbusinessname='Harold Park Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Twin Restaurant
Alexandria NSW 2015
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=11814 or tblfeedback.strbusinessname='Twin Restaurant' or tblfeedback.strbusinessname='Twin Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aristocrat Wedding & Function Centre
Miranda NSW 2228
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=2174 or tblfeedback.strbusinessname='Aristocrat Wedding &%%semi%% Function Centre' or tblfeedback.strbusinessname='Aristocrat Wedding & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Carlingford Bowling Sports & Recreation Club
Carlingford NSW 2118
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=8519 or tblfeedback.strbusinessname='Carlingford Bowling Sports &%%semi%% Recreation Club' or tblfeedback.strbusinessname='Carlingford Bowling Sports & Recreation Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lachlan's Old Government House
Parramatta NSW 2150
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=1967 or tblfeedback.strbusinessname='Lachlan'%%semi%%s Old Government House' or tblfeedback.strbusinessname='Lachlan's Old Government House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Easts Rugby Function & Conference Centre
Rose Bay NSW 2029
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=9110 or tblfeedback.strbusinessname='Easts Rugby Function &%%semi%% Conference Centre' or tblfeedback.strbusinessname='Easts Rugby Function & Conference Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Port Vista Function Centre
Sydney NSW 2000
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=11030 or tblfeedback.strbusinessname='Port Vista Function Centre' or tblfeedback.strbusinessname='Port Vista Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Arena Collins Wedding Videos
Granville NSW 2142
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=2173 or tblfeedback.strbusinessname='Arena Collins Wedding Videos' or tblfeedback.strbusinessname='Arena Collins Wedding Videos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Landmark Parkroyal Sydney
Potts Point NSW 2011
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=1952 or tblfeedback.strbusinessname='Landmark Parkroyal Sydney' or tblfeedback.strbusinessname='Landmark Parkroyal Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Villa Caprese
Milsons Point NSW 2061
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=11892 or tblfeedback.strbusinessname='Villa Caprese' or tblfeedback.strbusinessname='Villa Caprese') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian Jockey Club
Randwick NSW 2031
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=2183 or tblfeedback.strbusinessname='Australian Jockey Club' or tblfeedback.strbusinessname='Australian Jockey Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Royal Motor Yacht Club
Point Piper NSW 2027
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=11251 or tblfeedback.strbusinessname='Royal Motor Yacht Club' or tblfeedback.strbusinessname='Royal Motor Yacht Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sutherland District Trade Union Club Ltd-The Tradies
Gymea NSW 2227
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=11624 or tblfeedback.strbusinessname='Sutherland District Trade Union Club Ltd-The Tradies' or tblfeedback.strbusinessname='Sutherland District Trade Union Club Ltd-The Tradies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aboard
Rose Bay NSW 2029
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=2113 or tblfeedback.strbusinessname='Aboard' or tblfeedback.strbusinessname='Aboard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lansdowne Motor Inn
Lansvale NSW 2166
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=10149 or tblfeedback.strbusinessname='Lansdowne Motor Inn' or tblfeedback.strbusinessname='Lansdowne Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bass & Flinders Cruises
Sans Souci NSW 2219
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=2202 or tblfeedback.strbusinessname='Bass &%%semi%% Flinders Cruises' or tblfeedback.strbusinessname='Bass & Flinders Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bannerman House
Drummoyne NSW 2047
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=2199 or tblfeedback.strbusinessname='Bannerman House' or tblfeedback.strbusinessname='Bannerman House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Weddings on Water
Sydney NSW 2106
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=18304 or tblfeedback.strbusinessname='Weddings on Water' or tblfeedback.strbusinessname='Weddings on Water') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bounty Cruises
The Rocks NSW 2000
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=8302 or tblfeedback.strbusinessname='Bounty Cruises' or tblfeedback.strbusinessname='Bounty Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 444 Sort search results alphabetically