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
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
Gardenia Bankstown
Bass Hill NSW 2197
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=9411 or tblfeedback.strbusinessname='Gardenia Bankstown' or tblfeedback.strbusinessname='Gardenia Bankstown') 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
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
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
Macquarie Graduate School of Management (Mgsm)
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=10314 or tblfeedback.strbusinessname='Macquarie Graduate School of Management (%%semi%%Mgsm)%%semi%%' or tblfeedback.strbusinessname='Macquarie Graduate School of Management (Mgsm)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Star Room
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=18292 or tblfeedback.strbusinessname='Star Room' or tblfeedback.strbusinessname='Star Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cronulla Cruises
Cronulla NSW 2229
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=8850 or tblfeedback.strbusinessname='Cronulla Cruises' or tblfeedback.strbusinessname='Cronulla Cruises') 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
Palais The
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=10809 or tblfeedback.strbusinessname='Palais The' or tblfeedback.strbusinessname='Palais The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
L'Incontro Restaurant
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=10221 or tblfeedback.strbusinessname='L'%%semi%%Incontro Restaurant' or tblfeedback.strbusinessname='L'Incontro Restaurant') 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
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
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
Barclay Reception 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=2200 or tblfeedback.strbusinessname='Barclay Reception Centre' or tblfeedback.strbusinessname='Barclay Reception Centre') 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
Stamford Grand North Ryde
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=18291 or tblfeedback.strbusinessname='Stamford Grand North Ryde' or tblfeedback.strbusinessname='Stamford Grand North Ryde') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fontana DI Trevi Pty Ltd
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=9326 or tblfeedback.strbusinessname='Fontana DI Trevi Pty Ltd' or tblfeedback.strbusinessname='Fontana DI Trevi Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Seal Cruises
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=11331 or tblfeedback.strbusinessname='Seal Cruises' or tblfeedback.strbusinessname='Seal Cruises') 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
Twin Restaurant
Alexandria NSW 2015
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=11814 or tblfeedback.strbusinessname='Twin Restaurant' or tblfeedback.strbusinessname='Twin Restaurant') 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
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
Frank Oliveri Room
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=9363 or tblfeedback.strbusinessname='Frank Oliveri Room' or tblfeedback.strbusinessname='Frank Oliveri Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Absolutely Fabulous 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=2138 or tblfeedback.strbusinessname='Absolutely Fabulous Harbour Trek' or tblfeedback.strbusinessname='Absolutely Fabulous Harbour Trek') 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
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
Sydney Showboats
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=11656 or tblfeedback.strbusinessname='Sydney Showboats' or tblfeedback.strbusinessname='Sydney Showboats') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mary Elizabeth House
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=2025 or tblfeedback.strbusinessname='Mary Elizabeth House' or tblfeedback.strbusinessname='Mary Elizabeth House') 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
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
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
Wentworth Sydney 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=12006 or tblfeedback.strbusinessname='Wentworth Sydney The' or tblfeedback.strbusinessname='Wentworth Sydney The') 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
Isabelles Reception Centre
Eastwood NSW 2122
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=9842 or tblfeedback.strbusinessname='Isabelles Reception Centre' or tblfeedback.strbusinessname='Isabelles Reception Centre') 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
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
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
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
Highbury House B & B
Eastwood NSW 2122
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=9691 or tblfeedback.strbusinessname='Highbury House B &%%semi%% B' or tblfeedback.strbusinessname='Highbury House B & B') 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
Easts Rugby Function & Conference Centre
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=9110 or tblfeedback.strbusinessname='Easts Rugby Function &%%semi%% Conference Centre' or tblfeedback.strbusinessname='Easts Rugby Function & Conference Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mercure
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=2028 or tblfeedback.strbusinessname='Mercure' or tblfeedback.strbusinessname='Mercure') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tie the Knot Wedding Co-Ordinators
Rozelle NSW 2039
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=11722 or tblfeedback.strbusinessname='Tie the Knot Wedding Co-Ordinators' or tblfeedback.strbusinessname='Tie the Knot Wedding Co-Ordinators') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Carlton Crest 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=1997 or tblfeedback.strbusinessname='Carlton Crest Hotel Sydney' or tblfeedback.strbusinessname='Carlton Crest Hotel Sydney') 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
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
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
1 - 50 of 444 Sort search results alphabetically