Rating
Mercure Hotel & Convention Centre
St Leonards NSW 2065
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=1961 or tblfeedback.strbusinessname='Mercure Hotel &%%semi%% Convention Centre' or tblfeedback.strbusinessname='Mercure Hotel & Convention 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
Barnaby's Waterfront Restaurants
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=2201 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
Sydney Opera House
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=11653 or tblfeedback.strbusinessname='Sydney Opera House' or tblfeedback.strbusinessname='Sydney Opera House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pacific International Suites
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=10802 or tblfeedback.strbusinessname='Pacific International Suites' or tblfeedback.strbusinessname='Pacific International Suites') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dee Why Function Rooms
Dee Why NSW 2099
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=8970 or tblfeedback.strbusinessname='Dee Why Function Rooms' or tblfeedback.strbusinessname='Dee Why Function Rooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
St George Rowing Club
Arncliffe NSW 2205
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=11519 or tblfeedback.strbusinessname='St George Rowing Club' or tblfeedback.strbusinessname='St George Rowing Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Allan N.T.W.
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=2156 or tblfeedback.strbusinessname='Allan N.T.W.' or tblfeedback.strbusinessname='Allan N.T.W.') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Revesby Workers Club
Revesby NSW 2212
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=18290 or tblfeedback.strbusinessname='Revesby Workers Club' or tblfeedback.strbusinessname='Revesby Workers Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Banksia Centre
Wentworthville NSW 2145
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=2196 or tblfeedback.strbusinessname='Banksia Centre' or tblfeedback.strbusinessname='Banksia Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Quay West
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=11089 or tblfeedback.strbusinessname='Quay West' or tblfeedback.strbusinessname='Quay West') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
White Pearl Receptions
Bonnyrigg NSW 2177
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=12033 or tblfeedback.strbusinessname='White Pearl Receptions' or tblfeedback.strbusinessname='White Pearl Receptions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A 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=2124 or tblfeedback.strbusinessname='A Villa Caprese' or tblfeedback.strbusinessname='A Villa Caprese') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bosphorus Reception Lounge
Auburn NSW 2144
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=8295 or tblfeedback.strbusinessname='Bosphorus Reception Lounge' or tblfeedback.strbusinessname='Bosphorus Reception Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian Jockey Club
Warwick Farm 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=2184 or tblfeedback.strbusinessname='Australian Jockey Club' or tblfeedback.strbusinessname='Australian Jockey Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
DA Florentino Ristorante
North Sydney NSW 2060
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=8892 or tblfeedback.strbusinessname='DA Florentino Ristorante' or tblfeedback.strbusinessname='DA Florentino Ristorante') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Le Meridien 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=10170 or tblfeedback.strbusinessname='Le Meridien Sydney' or tblfeedback.strbusinessname='Le Meridien Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Hurstville Entertainment Centre
Hurstville NSW 2220
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=9770 or tblfeedback.strbusinessname='Hurstville Entertainment Centre' or tblfeedback.strbusinessname='Hurstville Entertainment Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Clarence House Function Centre
Belmore NSW 2192
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=1999 or tblfeedback.strbusinessname='Clarence House Function Centre' or tblfeedback.strbusinessname='Clarence House 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
Aussie Pub Tours
Leppington 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=7946 or tblfeedback.strbusinessname='Aussie Pub Tours' or tblfeedback.strbusinessname='Aussie Pub Tours') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Palais Function Centre
Leichhardt NSW 2040
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=2039 or tblfeedback.strbusinessname='Palais Function Centre' or tblfeedback.strbusinessname='Palais Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Italian Village The Rocks
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=18273 or tblfeedback.strbusinessname='Italian Village The Rocks' or tblfeedback.strbusinessname='Italian Village The Rocks') 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
Roseville Golf Club The
Roseville NSW 2069
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=11236 or tblfeedback.strbusinessname='Roseville Golf Club The' or tblfeedback.strbusinessname='Roseville Golf Club The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ocean Spirit Cruises
Pyrmont NSW 2009
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=10760 or tblfeedback.strbusinessname='Ocean Spirit Cruises' or tblfeedback.strbusinessname='Ocean Spirit Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fontainebleau Inn The
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=9325 or tblfeedback.strbusinessname='Fontainebleau Inn The' or tblfeedback.strbusinessname='Fontainebleau Inn The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harbour Trek
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=9608 or tblfeedback.strbusinessname='Harbour Trek' or tblfeedback.strbusinessname='Harbour Trek') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Villa Caprese Italian Restaurant
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=11893 or tblfeedback.strbusinessname='Villa Caprese Italian Restaurant' or tblfeedback.strbusinessname='Villa Caprese Italian Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Villa Rosa Receiption Lounge
Leichhardt NSW 2040
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=1983 or tblfeedback.strbusinessname='Villa Rosa Receiption Lounge' or tblfeedback.strbusinessname='Villa Rosa Receiption Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Concord Function Centre
Concord NSW 2137
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=8774 or tblfeedback.strbusinessname='Concord Function Centre' or tblfeedback.strbusinessname='Concord Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Grotta Capri Restaurant
Kensington NSW 2033
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=9575 or tblfeedback.strbusinessname='Grotta Capri Restaurant' or tblfeedback.strbusinessname='Grotta Capri Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roslyn Gardens & Rosebowl
Peakhurst NSW 2210
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=11239 or tblfeedback.strbusinessname='Roslyn Gardens &%%semi%% Rosebowl' or tblfeedback.strbusinessname='Roslyn Gardens & Rosebowl') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Liberte
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=10205 or tblfeedback.strbusinessname='Liberte' or tblfeedback.strbusinessname='Liberte') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Arristo Pty Ltd
Dundas Valley NSW 2117
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=2178 or tblfeedback.strbusinessname='Arristo Pty Ltd' or tblfeedback.strbusinessname='Arristo Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bel Paese Ristorante
North Sydney NSW 2060
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=8143 or tblfeedback.strbusinessname='Bel Paese Ristorante' or tblfeedback.strbusinessname='Bel Paese Ristorante') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rydges Cronulla Beach
Cronulla NSW 2230
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=11267 or tblfeedback.strbusinessname='Rydges Cronulla Beach' or tblfeedback.strbusinessname='Rydges Cronulla Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Duxton Hotel North Sydney
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=1964 or tblfeedback.strbusinessname='Duxton Hotel North Sydney' or tblfeedback.strbusinessname='Duxton Hotel North Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A LA Gondola Reception Lounge
Earlwood NSW 2206
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=2119 or tblfeedback.strbusinessname='A LA Gondola Reception Lounge' or tblfeedback.strbusinessname='A LA Gondola Reception Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dedes Restaurant
Abbotsford 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=18261 or tblfeedback.strbusinessname='Dedes Restaurant' or tblfeedback.strbusinessname='Dedes Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bankstown Paceway Function Centre
Bankstown NSW 2200
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=2198 or tblfeedback.strbusinessname='Bankstown Paceway Function Centre' or tblfeedback.strbusinessname='Bankstown Paceway Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harbord Diggers Memorial Club
Harbord NSW 2096
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=18267 or tblfeedback.strbusinessname='Harbord Diggers Memorial Club' or tblfeedback.strbusinessname='Harbord Diggers Memorial Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
James Craig
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=9871 or tblfeedback.strbusinessname='James Craig' or tblfeedback.strbusinessname='James Craig') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abcot International Motor Inn
Sylvania NSW 2224
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=2134 or tblfeedback.strbusinessname='Abcot International Motor Inn' or tblfeedback.strbusinessname='Abcot International Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Royal Prince Alfred Yacht Club
Newport 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=11252 or tblfeedback.strbusinessname='Royal Prince Alfred Yacht Club' or tblfeedback.strbusinessname='Royal Prince Alfred Yacht Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harbour Watch The
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=1975 or tblfeedback.strbusinessname='Harbour Watch The' or tblfeedback.strbusinessname='Harbour Watch The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Northshore Charters
Taylors Point 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=10736 or tblfeedback.strbusinessname='Northshore Charters' or tblfeedback.strbusinessname='Northshore Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Maxims
Bankstown NSW 2200
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=10423 or tblfeedback.strbusinessname='Maxims' or tblfeedback.strbusinessname='Maxims') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 444 Sort search results alphabetically