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
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
Dimitri's Bar & Restaurant
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=9026 or tblfeedback.strbusinessname='Dimitri'%%semi%%s Bar &%%semi%% Restaurant' or tblfeedback.strbusinessname='Dimitri's Bar & Restaurant') 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
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
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
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
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
Silver Spirit
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=11408 or tblfeedback.strbusinessname='Silver Spirit' or tblfeedback.strbusinessname='Silver Spirit') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chinese Garden of Friendship
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=8642 or tblfeedback.strbusinessname='Chinese Garden of Friendship' or tblfeedback.strbusinessname='Chinese Garden of Friendship') 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
Cafe De Como
Como NSW 2226
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=8462 or tblfeedback.strbusinessname='Cafe De Como' or tblfeedback.strbusinessname='Cafe De Como') 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
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
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
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
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
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
Harbord Diggers 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=9606 or tblfeedback.strbusinessname='Harbord Diggers Club' or tblfeedback.strbusinessname='Harbord Diggers Club') 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
All Sydney Harbour Boat Charters
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=2155 or tblfeedback.strbusinessname='All Sydney Harbour Boat Charters' or tblfeedback.strbusinessname='All Sydney Harbour Boat Charters') 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
ANZ Conservation Theatre
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=2164 or tblfeedback.strbusinessname='ANZ Conservation Theatre' or tblfeedback.strbusinessname='ANZ Conservation Theatre') 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
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
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
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
Captain Cook 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=1900 or tblfeedback.strbusinessname='Captain Cook Cruises' or tblfeedback.strbusinessname='Captain Cook Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mosman Art Gallery & Community Centre
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=10566 or tblfeedback.strbusinessname='Mosman Art Gallery &%%semi%% Community Centre' or tblfeedback.strbusinessname='Mosman Art Gallery & Community Centre') 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
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
Trade Winds Hotel
Maroubra NSW 2035
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=11773 or tblfeedback.strbusinessname='Trade Winds Hotel' or tblfeedback.strbusinessname='Trade Winds Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Allegro Function Centre
Kenthurst NSW 2156
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=18244 or tblfeedback.strbusinessname='Allegro Function Centre' or tblfeedback.strbusinessname='Allegro Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
A Aquablue Charters
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=7631 or tblfeedback.strbusinessname='A Aquablue Charters' or tblfeedback.strbusinessname='A Aquablue Charters') 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
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
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
Lincoln Room
WestGuildford NSW 2161
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=18278 or tblfeedback.strbusinessname='Lincoln Room' or tblfeedback.strbusinessname='Lincoln Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
AA All City Harbour Venue Weddings
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=2128 or tblfeedback.strbusinessname='AA All City Harbour Venue Weddings' or tblfeedback.strbusinessname='AA All City Harbour Venue Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goodies Restaurant
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=9496 or tblfeedback.strbusinessname='Goodies Restaurant' or tblfeedback.strbusinessname='Goodies Restaurant') 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
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
Pruniers Restaurant
Woolahra 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=18287 or tblfeedback.strbusinessname='Pruniers Restaurant' or tblfeedback.strbusinessname='Pruniers Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Argyle
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=18296 or tblfeedback.strbusinessname='The Argyle' or tblfeedback.strbusinessname='The Argyle') 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
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
Choice Charters
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=8649 or tblfeedback.strbusinessname='Choice Charters' or tblfeedback.strbusinessname='Choice Charters') 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
1 - 50 of 444 Sort search results alphabetically