Rating
Kirribilli Ex-Service Community & Bowling Club
Lavender Bay 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=10089 or tblfeedback.strbusinessname='Kirribilli Ex-Service Community &%%semi%% Bowling Club' or tblfeedback.strbusinessname='Kirribilli Ex-Service Community & Bowling Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Haldon Function Centre
Lakemba NSW 2195
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=9595 or tblfeedback.strbusinessname='Haldon Function Centre' or tblfeedback.strbusinessname='Haldon Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Atrium
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=2180 or tblfeedback.strbusinessname='The Atrium' or tblfeedback.strbusinessname='The Atrium') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Little Mykonos The
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=10251 or tblfeedback.strbusinessname='Little Mykonos The' or tblfeedback.strbusinessname='Little Mykonos The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elim
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=9137 or tblfeedback.strbusinessname='Elim' or tblfeedback.strbusinessname='Elim') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Ainslee Lodge Function Centre
Bexley NSW 2207
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=2145 or tblfeedback.strbusinessname='Ainslee Lodge Function Centre' or tblfeedback.strbusinessname='Ainslee Lodge Function Centre') 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
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
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
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
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
Georges River Cruises
East Hills NSW 2213
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=9446 or tblfeedback.strbusinessname='Georges River Cruises' or tblfeedback.strbusinessname='Georges River Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gap Bluff Centre The
Watsons Bay NSW 2030
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=9406 or tblfeedback.strbusinessname='Gap Bluff Centre The' or tblfeedback.strbusinessname='Gap Bluff Centre The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Newport Mirage
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=10672 or tblfeedback.strbusinessname='Newport Mirage' or tblfeedback.strbusinessname='Newport Mirage') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Edessa Reception & Function Lounge
Greenfield Park NSW 2176
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=9117 or tblfeedback.strbusinessname='Edessa Reception &%%semi%% Function Lounge' or tblfeedback.strbusinessname='Edessa Reception & Function Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
KMP Wedding Coordination
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=10093 or tblfeedback.strbusinessname='KMP Wedding Coordination' or tblfeedback.strbusinessname='KMP Wedding Coordination') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vaucluse House
Vaucluse NSW 2030
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=11855 or tblfeedback.strbusinessname='Vaucluse House' or tblfeedback.strbusinessname='Vaucluse House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blue Line Cruises
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=8248 or tblfeedback.strbusinessname='Blue Line Cruises' or tblfeedback.strbusinessname='Blue Line Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Balgowlah RSL Memorial Club
Seaforth NSW 2092
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=2194 or tblfeedback.strbusinessname='Balgowlah RSL Memorial Club' or tblfeedback.strbusinessname='Balgowlah RSL Memorial Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Proclaim Charters
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=11070 or tblfeedback.strbusinessname='Proclaim Charters' or tblfeedback.strbusinessname='Proclaim Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sydney Turf Club
Canterbury 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=1901 or tblfeedback.strbusinessname='Sydney Turf Club' or tblfeedback.strbusinessname='Sydney Turf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Banjo Paterson Cottage Restaurant
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=1990 or tblfeedback.strbusinessname='Banjo Paterson Cottage Restaurant' or tblfeedback.strbusinessname='Banjo Paterson Cottage Restaurant') 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
Rating
Cranbrook International Hotel
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=8831 or tblfeedback.strbusinessname='Cranbrook International Hotel' or tblfeedback.strbusinessname='Cranbrook International Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Miramare Function Centre
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=10516 or tblfeedback.strbusinessname='Miramare Function Centre' or tblfeedback.strbusinessname='Miramare Function Centre') 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
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
Ambrosia Seafood Restaurant
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=2160 or tblfeedback.strbusinessname='Ambrosia Seafood Restaurant' or tblfeedback.strbusinessname='Ambrosia Seafood Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Nilla Reception Lounge
Ashfield NSW 2131
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=10693 or tblfeedback.strbusinessname='Nilla Reception Lounge' or tblfeedback.strbusinessname='Nilla Reception Lounge') 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
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
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
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
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
Coronation 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=8790 or tblfeedback.strbusinessname='Coronation Function Centre' or tblfeedback.strbusinessname='Coronation Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Grand Barclay
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=9539 or tblfeedback.strbusinessname='Grand Barclay' or tblfeedback.strbusinessname='Grand Barclay') 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
White Castle Receptions
Lakemba NSW 2195
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=12028 or tblfeedback.strbusinessname='White Castle Receptions' or tblfeedback.strbusinessname='White Castle Receptions') 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
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
Manor House Boutique Hotel
Darlinghurst 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=10356 or tblfeedback.strbusinessname='Manor House Boutique Hotel' or tblfeedback.strbusinessname='Manor House Boutique Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Macleay Restaurant AT the Landmark Park Royal
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=10309 or tblfeedback.strbusinessname='Macleay Restaurant AT the Landmark Park Royal' or tblfeedback.strbusinessname='Macleay Restaurant AT the Landmark Park Royal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Manly Pacific Parkroyal
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=2018 or tblfeedback.strbusinessname='Manly Pacific Parkroyal' or tblfeedback.strbusinessname='Manly Pacific Parkroyal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abcot Int 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=2133 or tblfeedback.strbusinessname='Abcot Int Motor Inn' or tblfeedback.strbusinessname='Abcot Int Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Liverpool Golf Club Ltd
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=10254 or tblfeedback.strbusinessname='Liverpool Golf Club Ltd' or tblfeedback.strbusinessname='Liverpool Golf Club Ltd') 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
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
1 - 50 of 443 Sort search results alphabetically