Rating
Aqua Princess Charters
Berowra Waters NSW 2082
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=2170 or tblfeedback.strbusinessname='Aqua Princess Charters' or tblfeedback.strbusinessname='Aqua Princess Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Macquarie Princess Charter Ferry Pty Ltd
Castle Hill NSW 2154
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=10315 or tblfeedback.strbusinessname='Macquarie Princess Charter Ferry Pty Ltd' or tblfeedback.strbusinessname='Macquarie Princess Charter Ferry Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Orion Function Centre
Campsie NSW 2194
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=10791 or tblfeedback.strbusinessname='Orion Function Centre' or tblfeedback.strbusinessname='Orion Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Broadway Function Centre
Punchbowl NSW 2196
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=8397 or tblfeedback.strbusinessname='Broadway Function Centre' or tblfeedback.strbusinessname='Broadway Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
North Ryde RSL
North Ryde NSW 2113
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=18283 or tblfeedback.strbusinessname='North Ryde RSL' or tblfeedback.strbusinessname='North Ryde RSL') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Waterview Restaurant
Berowra Waters NSW 2082
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=14968 or tblfeedback.strbusinessname='Waterview Restaurant' or tblfeedback.strbusinessname='Waterview Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Bankstown 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=2197 or tblfeedback.strbusinessname='Bankstown Function Centre' or tblfeedback.strbusinessname='Bankstown Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
WatersEdge
Walsh Bay 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=1934 or tblfeedback.strbusinessname='WatersEdge' or tblfeedback.strbusinessname='WatersEdge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Endeavour Room Reception Centre Woolooware Golf Club Ltd
Woolooware 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=9177 or tblfeedback.strbusinessname='Endeavour Room Reception Centre Woolooware Golf Club Ltd' or tblfeedback.strbusinessname='Endeavour Room Reception Centre Woolooware Golf Club Ltd') 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
Renaissance Sydney Hotel
Circular Quay 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=11130 or tblfeedback.strbusinessname='Renaissance Sydney Hotel' or tblfeedback.strbusinessname='Renaissance Sydney Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Venue Collection 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=11860 or tblfeedback.strbusinessname='Venue Collection The' or tblfeedback.strbusinessname='Venue Collection The') 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
The American Club
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=4738 or tblfeedback.strbusinessname='The American Club' or tblfeedback.strbusinessname='The American Club') 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
Carnarvon Golf Club
Lidcombe NSW 2141
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=18254 or tblfeedback.strbusinessname='Carnarvon Golf Club' or tblfeedback.strbusinessname='Carnarvon Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elizabeth Bay House
Elizabeth Bay 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=9144 or tblfeedback.strbusinessname='Elizabeth Bay House' or tblfeedback.strbusinessname='Elizabeth Bay House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sebel Of Sydney The
Elizabeth Bay 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=2072 or tblfeedback.strbusinessname='Sebel Of Sydney The' or tblfeedback.strbusinessname='Sebel Of Sydney The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bass And Flinders Cruise Centre
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=2203 or tblfeedback.strbusinessname='Bass And Flinders Cruise Centre' or tblfeedback.strbusinessname='Bass And Flinders Cruise Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fresh Ketch Restaurant
Mosman NSW 2088
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=9371 or tblfeedback.strbusinessname='Fresh Ketch Restaurant' or tblfeedback.strbusinessname='Fresh Ketch Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dreamweaver Cruises
Neutral Bay NSW 2089
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=9076 or tblfeedback.strbusinessname='Dreamweaver Cruises' or tblfeedback.strbusinessname='Dreamweaver Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Comedy Cruise
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=2117 or tblfeedback.strbusinessname='A Comedy Cruise' or tblfeedback.strbusinessname='A Comedy Cruise') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Constellation Cruises
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=1950 or tblfeedback.strbusinessname='Constellation Cruises' or tblfeedback.strbusinessname='Constellation Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gables The
Lidcombe NSW 2141
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=9391 or tblfeedback.strbusinessname='Gables The' or tblfeedback.strbusinessname='Gables The') 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
The Sunnybrook Hotel
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=18299 or tblfeedback.strbusinessname='The Sunnybrook Hotel' or tblfeedback.strbusinessname='The Sunnybrook Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Parramatta Leagues Club
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=2047 or tblfeedback.strbusinessname='Parramatta Leagues Club' or tblfeedback.strbusinessname='Parramatta Leagues Club') 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
GCR Restaurant
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=9427 or tblfeedback.strbusinessname='GCR Restaurant' or tblfeedback.strbusinessname='GCR Restaurant') 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
Sydneyside 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=11663 or tblfeedback.strbusinessname='Sydneyside Cruises' or tblfeedback.strbusinessname='Sydneyside Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Canterbury-Hurlstone Park RSL Club Ltd
Hurlstone Park NSW 2193
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=1935 or tblfeedback.strbusinessname='Canterbury-Hurlstone Park RSL Club Ltd' or tblfeedback.strbusinessname='Canterbury-Hurlstone Park RSL Club Ltd') 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
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
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
Mariners Cove
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=1986 or tblfeedback.strbusinessname='Mariners Cove' or tblfeedback.strbusinessname='Mariners Cove') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hyde Park Barracks Cafe
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=14973 or tblfeedback.strbusinessname='Hyde Park Barracks Cafe' or tblfeedback.strbusinessname='Hyde Park Barracks Cafe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Swiss Grand Resort Bondi
Bondi Beach NSW 2026
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=18294 or tblfeedback.strbusinessname='Swiss Grand Resort Bondi' or tblfeedback.strbusinessname='Swiss Grand Resort Bondi') 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
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
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
Hunts Motel 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=9768 or tblfeedback.strbusinessname='Hunts Motel Function Centre' or tblfeedback.strbusinessname='Hunts Motel Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Prestige Function Centre
Kogarah NSW 2217
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=11051 or tblfeedback.strbusinessname='Prestige Function Centre' or tblfeedback.strbusinessname='Prestige Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Clarence House
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=18257 or tblfeedback.strbusinessname='Clarence House' or tblfeedback.strbusinessname='Clarence House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mercedes Charters
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=10461 or tblfeedback.strbusinessname='Mercedes Charters' or tblfeedback.strbusinessname='Mercedes Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Water Transport
Balmain NSW 2041
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=11956 or tblfeedback.strbusinessname='Water Transport' or tblfeedback.strbusinessname='Water Transport') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Grace Hotel 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=9528 or tblfeedback.strbusinessname='Grace Hotel The' or tblfeedback.strbusinessname='Grace Hotel The') 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
1 - 50 of 444 Sort search results alphabetically