Rating
Kellyville Country Club Ltd
Kellyville NSW 2155
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=10043 or tblfeedback.strbusinessname='Kellyville Country Club Ltd' or tblfeedback.strbusinessname='Kellyville Country Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Orso Bayside 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=10792 or tblfeedback.strbusinessname='Orso Bayside Restaurant' or tblfeedback.strbusinessname='Orso Bayside Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rydges Bankstown
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=11266 or tblfeedback.strbusinessname='Rydges Bankstown' or tblfeedback.strbusinessname='Rydges Bankstown') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
212 Riley Street
Surry Hills NSW 2010
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=2110 or tblfeedback.strbusinessname='212 Riley Street' or tblfeedback.strbusinessname='212 Riley Street') 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
Australian Cruise Events Pty Ltd
Lane Cove NSW 2066
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=2182 or tblfeedback.strbusinessname='Australian Cruise Events Pty Ltd' or tblfeedback.strbusinessname='Australian Cruise Events Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abcris Holdings
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=2135 or tblfeedback.strbusinessname='Abcris Holdings' or tblfeedback.strbusinessname='Abcris Holdings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Galston Community Centre
Galston NSW 2159
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=9403 or tblfeedback.strbusinessname='Galston Community Centre' or tblfeedback.strbusinessname='Galston Community Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Beach House Restaurant
Whale Beach 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=18248 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
Parra Villa Function Lounge
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=2045 or tblfeedback.strbusinessname='Parra Villa Function Lounge' or tblfeedback.strbusinessname='Parra Villa Function Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
Holroyd Centre The
Merrylands NSW 2160
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=9713 or tblfeedback.strbusinessname='Holroyd Centre The' or tblfeedback.strbusinessname='Holroyd Centre The') 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
North Sydney Harbourview Hotel
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=10729 or tblfeedback.strbusinessname='North Sydney Harbourview Hotel' or tblfeedback.strbusinessname='North Sydney Harbourview Hotel') 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
Museum of Contemporary Art
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=10604 or tblfeedback.strbusinessname='Museum of Contemporary Art' or tblfeedback.strbusinessname='Museum of Contemporary Art') 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
Villa Rosa 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=11895 or tblfeedback.strbusinessname='Villa Rosa Lounge' or tblfeedback.strbusinessname='Villa Rosa Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Great Gatsby Charters
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=9555 or tblfeedback.strbusinessname='Great Gatsby Charters' or tblfeedback.strbusinessname='Great Gatsby Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hawkesbury River Charters & Functions
Brooklyn NSW 2083
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=9647 or tblfeedback.strbusinessname='Hawkesbury River Charters &%%semi%% Functions' or tblfeedback.strbusinessname='Hawkesbury River Charters & Functions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Enfield RSL Club Ltd
Enfield NSW 2136
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=9178 or tblfeedback.strbusinessname='Enfield RSL Club Ltd' or tblfeedback.strbusinessname='Enfield RSL Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
How To Host A Murder
Malabar NSW 2036
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=9742 or tblfeedback.strbusinessname='How To Host A Murder' or tblfeedback.strbusinessname='How To Host A Murder') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Parramatta RSL 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=10846 or tblfeedback.strbusinessname='Parramatta RSL Club' or tblfeedback.strbusinessname='Parramatta RSL 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
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=2130 or tblfeedback.strbusinessname='Abbey Restaurant The' or tblfeedback.strbusinessname='Abbey Restaurant The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Quay Grand Suites 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=11088 or tblfeedback.strbusinessname='Quay Grand Suites Sydney' or tblfeedback.strbusinessname='Quay Grand Suites Sydney') 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
Palm Beach Ferry Service
Avalon 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=10810 or tblfeedback.strbusinessname='Palm Beach Ferry Service' or tblfeedback.strbusinessname='Palm Beach Ferry Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roma Classic Lounge
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=11211 or tblfeedback.strbusinessname='Roma Classic Lounge' or tblfeedback.strbusinessname='Roma Classic Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Starlight Harbour 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=11536 or tblfeedback.strbusinessname='Starlight Harbour Cruises' or tblfeedback.strbusinessname='Starlight Harbour Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Country Comfort Inn Pennant Hills
Pennant Hills NSW 2120
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=8807 or tblfeedback.strbusinessname='Country Comfort Inn Pennant Hills' or tblfeedback.strbusinessname='Country Comfort Inn Pennant Hills') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Magistic
Darling Harbour 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=10327 or tblfeedback.strbusinessname='Magistic' or tblfeedback.strbusinessname='Magistic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
St Moritz Reception Centre
Engadine NSW 2233
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=11522 or tblfeedback.strbusinessname='St Moritz Reception Centre' or tblfeedback.strbusinessname='St Moritz Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ambassador Lounge The
Fairfield NSW 2165
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=2159 or tblfeedback.strbusinessname='Ambassador Lounge The' or tblfeedback.strbusinessname='Ambassador Lounge The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sydney Crystal Boat Charters
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=11643 or tblfeedback.strbusinessname='Sydney Crystal Boat Charters' or tblfeedback.strbusinessname='Sydney Crystal Boat Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Addison Road Community Centre
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=2140 or tblfeedback.strbusinessname='Addison Road Community Centre' or tblfeedback.strbusinessname='Addison Road Community 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
Rydges Parramatta
Rosehill 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=11269 or tblfeedback.strbusinessname='Rydges Parramatta' or tblfeedback.strbusinessname='Rydges Parramatta') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Little Mykonos
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=10250 or tblfeedback.strbusinessname='Little Mykonos' or tblfeedback.strbusinessname='Little Mykonos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sydney Glass Island
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=4632 or tblfeedback.strbusinessname='Sydney Glass Island' or tblfeedback.strbusinessname='Sydney Glass Island') 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
Grand Westella
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=9541 or tblfeedback.strbusinessname='Grand Westella' or tblfeedback.strbusinessname='Grand Westella') 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
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
Avillion 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=2186 or tblfeedback.strbusinessname='Avillion Hotel Sydney' or tblfeedback.strbusinessname='Avillion Hotel Sydney') 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
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
Rating
Southern Star Function Centre The
Yagoona NSW 2199
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=11466 or tblfeedback.strbusinessname='Southern Star Function Centre The' or tblfeedback.strbusinessname='Southern Star Function Centre The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 444 Sort search results alphabetically