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
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
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
Villa Rosa Reception Lounge
Leichhardt NSW 2048
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=18302 or tblfeedback.strbusinessname='Villa Rosa Reception Lounge' or tblfeedback.strbusinessname='Villa Rosa Reception 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
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
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
Shores Restaurant
Spit Junction 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=11387 or tblfeedback.strbusinessname='Shores Restaurant' or tblfeedback.strbusinessname='Shores Restaurant') 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
Wedding Receptions
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=11991 or tblfeedback.strbusinessname='Wedding Receptions' or tblfeedback.strbusinessname='Wedding Receptions') 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
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
Waterfront Receptions
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=11957 or tblfeedback.strbusinessname='Waterfront Receptions' or tblfeedback.strbusinessname='Waterfront Receptions') 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
Emerald Function 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=9168 or tblfeedback.strbusinessname='Emerald Function Centre The' or tblfeedback.strbusinessname='Emerald Function Centre The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Buoni Amici
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=8425 or tblfeedback.strbusinessname='Buoni Amici' or tblfeedback.strbusinessname='Buoni Amici') 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
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
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
Henry Lawson & Henry Parkes
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=9673 or tblfeedback.strbusinessname='Henry Lawson &%%semi%% Henry Parkes' or tblfeedback.strbusinessname='Henry Lawson & Henry Parkes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Waitara Function Centre
Waitara NSW 2077
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=11928 or tblfeedback.strbusinessname='Waitara Function Centre' or tblfeedback.strbusinessname='Waitara Function Centre') 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
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
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
Beach Hut Le
Dolls Point 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=8117 or tblfeedback.strbusinessname='Beach Hut Le' or tblfeedback.strbusinessname='Beach Hut Le') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mandavilla Function Centre
Horsley Park NSW 2164
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=10347 or tblfeedback.strbusinessname='Mandavilla Function Centre' or tblfeedback.strbusinessname='Mandavilla Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Landmark Parkroyal Sydney
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=1952 or tblfeedback.strbusinessname='Landmark Parkroyal Sydney' or tblfeedback.strbusinessname='Landmark Parkroyal Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Torwood Lounge Function 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=11759 or tblfeedback.strbusinessname='Torwood Lounge Function Centre' or tblfeedback.strbusinessname='Torwood Lounge Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Blacktown Workers Club
Blacktown NSW 2148
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=18250 or tblfeedback.strbusinessname='Blacktown Workers Club' or tblfeedback.strbusinessname='Blacktown Workers Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Falls Function Centre The
Oxford Falls NSW 2100
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=9245 or tblfeedback.strbusinessname='Falls Function Centre The' or tblfeedback.strbusinessname='Falls Function Centre The') 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
Valintines Lounge & Reception
Brookvale NSW 2100
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=11847 or tblfeedback.strbusinessname='Valintines Lounge &%%semi%% Reception' or tblfeedback.strbusinessname='Valintines Lounge & Reception') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aboard N.T.W. Allan
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=2136 or tblfeedback.strbusinessname='Aboard N.T.W. Allan' or tblfeedback.strbusinessname='Aboard N.T.W. Allan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rydges Cronulla Beach
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=11267 or tblfeedback.strbusinessname='Rydges Cronulla Beach' or tblfeedback.strbusinessname='Rydges Cronulla Beach') 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
AJC Convention & Exhibition Centre
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=2147 or tblfeedback.strbusinessname='AJC Convention &%%semi%% Exhibition Centre' or tblfeedback.strbusinessname='AJC Convention & Exhibition Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
St George Rowing Club
Arncliffe NSW 2205
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=11519 or tblfeedback.strbusinessname='St George Rowing Club' or tblfeedback.strbusinessname='St George Rowing Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
L'aqua
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=18274 or tblfeedback.strbusinessname='L'%%semi%%aqua' or tblfeedback.strbusinessname='L'aqua') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
A 1 Caterers
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=2112 or tblfeedback.strbusinessname='A 1 Caterers' or tblfeedback.strbusinessname='A 1 Caterers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Reflections Function Venue
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=11119 or tblfeedback.strbusinessname='Reflections Function Venue' or tblfeedback.strbusinessname='Reflections Function Venue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Granville RSL Sub-Branch Club Ltd
Granville 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=9548 or tblfeedback.strbusinessname='Granville RSL Sub-Branch Club Ltd' or tblfeedback.strbusinessname='Granville RSL Sub-Branch Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mercure Hotel Lawson
Ultimo NSW 2007
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=10463 or tblfeedback.strbusinessname='Mercure Hotel Lawson' or tblfeedback.strbusinessname='Mercure Hotel Lawson') 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
Parkroyal Parramatta
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=1969 or tblfeedback.strbusinessname='Parkroyal Parramatta' or tblfeedback.strbusinessname='Parkroyal Parramatta') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sutherland Entertainment Centre
Sutherland NSW 2232
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=11625 or tblfeedback.strbusinessname='Sutherland Entertainment Centre' or tblfeedback.strbusinessname='Sutherland Entertainment Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Main Event Function Centre
Blacktown NSW 2148
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=10333 or tblfeedback.strbusinessname='Main Event Function Centre' or tblfeedback.strbusinessname='Main Event Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
1 - 50 of 444 Sort search results alphabetically