Rating
Bells at Killcare
Killcare NSW 2257
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=37825 or tblfeedback.strbusinessname='Bells at Killcare' or tblfeedback.strbusinessname='Bells at Killcare') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Aanuka Beach Resort
Coffs Harbour NSW 2450
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=24966 or tblfeedback.strbusinessname='Aanuka Beach Resort' or tblfeedback.strbusinessname='Aanuka Beach Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kantara House
Green Point NSW 2251
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=29191 or tblfeedback.strbusinessname='Kantara House' or tblfeedback.strbusinessname='Kantara House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kantara House
Green Point NSW 2251
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=10008 or tblfeedback.strbusinessname='Kantara House' or tblfeedback.strbusinessname='Kantara House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jessica Banks at Mercure Kooindah
Wyong NSW 2259
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=26470 or tblfeedback.strbusinessname='Jessica Banks at Mercure Kooindah' or tblfeedback.strbusinessname='Jessica Banks at Mercure Kooindah') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pullman's Magenta Shores Resort
Magenta NSW 2261
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=27642 or tblfeedback.strbusinessname='Pullman'%%semi%%s Magenta Shores Resort' or tblfeedback.strbusinessname='Pullman's Magenta Shores Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Morisset Country Club
Morisset NSW 2264
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=26003 or tblfeedback.strbusinessname='Morisset Country Club' or tblfeedback.strbusinessname='Morisset Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Shelly Beach Golf Club
Shelly Beach NSW 2261
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=23318 or tblfeedback.strbusinessname='Shelly Beach Golf Club' or tblfeedback.strbusinessname='Shelly Beach Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Catherine Hill Bowling Club
Catherine Hill Bay NSW 2281
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=26097 or tblfeedback.strbusinessname='Catherine Hill Bowling Club' or tblfeedback.strbusinessname='Catherine Hill Bowling Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Crowne Plaza Terrigal
Terrigal NSW 2260
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=25583 or tblfeedback.strbusinessname='Crowne Plaza Terrigal' or tblfeedback.strbusinessname='Crowne Plaza Terrigal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mercure Kooindah Waters
Wyong NSW 2259
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=27013 or tblfeedback.strbusinessname='Mercure Kooindah Waters' or tblfeedback.strbusinessname='Mercure Kooindah Waters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bar Toto
Ettalong Beach NSW 2257
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=35923 or tblfeedback.strbusinessname='Bar Toto' or tblfeedback.strbusinessname='Bar Toto') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
St Aubyn's on Clairvaux
Bathurst NSW 2795
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=27217 or tblfeedback.strbusinessname='St Aubyn'%%semi%%s on Clairvaux' or tblfeedback.strbusinessname='St Aubyn's on Clairvaux') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Forbes Golf and Sportsman Hotel
Forbes NSW 2871
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=26762 or tblfeedback.strbusinessname='Forbes Golf and Sportsman Hotel' or tblfeedback.strbusinessname='Forbes Golf and Sportsman Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Whitehaven
Wamberal NSW 2260
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=27756 or tblfeedback.strbusinessname='The Whitehaven' or tblfeedback.strbusinessname='The Whitehaven') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pullman Magenta Shores
Magenta NSW 2261
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=27599 or tblfeedback.strbusinessname='Pullman Magenta Shores' or tblfeedback.strbusinessname='Pullman Magenta Shores') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Raffertys Resort Cams Wharf
Cams Wharf NSW 2281
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=26110 or tblfeedback.strbusinessname='Raffertys Resort Cams Wharf' or tblfeedback.strbusinessname='Raffertys Resort Cams Wharf') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Entrance Leagues Club
Bateau bay NSW 2261
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=25160 or tblfeedback.strbusinessname='The Entrance Leagues Club' or tblfeedback.strbusinessname='The Entrance Leagues Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Awaba House
Booragul NSW 2284
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=27831 or tblfeedback.strbusinessname='Awaba House' or tblfeedback.strbusinessname='Awaba House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Somersby Gardens Estate
Somersby NSW 2250
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=26340 or tblfeedback.strbusinessname='Somersby Gardens Estate' or tblfeedback.strbusinessname='Somersby Gardens Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kangy Gardens
Kangy Angy NSW 2258
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=38083 or tblfeedback.strbusinessname='Kangy Gardens' or tblfeedback.strbusinessname='Kangy Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Caroline Bay Brasserie Cafe & Functions
Gosford East NSW 2250
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=8532 or tblfeedback.strbusinessname='Caroline Bay Brasserie Cafe &%%semi%% Functions' or tblfeedback.strbusinessname='Caroline Bay Brasserie Cafe & Functions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pearls on the Beach
Pearl Beach NSW 2256
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=10876 or tblfeedback.strbusinessname='Pearls on the Beach' or tblfeedback.strbusinessname='Pearls on the Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Murphy's Bay Waterfront Restaurant
Koolewong NSW 2256
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=10596 or tblfeedback.strbusinessname='Murphy'%%semi%%s Bay Waterfront Restaurant' or tblfeedback.strbusinessname='Murphy's Bay Waterfront Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Galley Beach House
Terrigal NSW 2260
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=9402 or tblfeedback.strbusinessname='Galley Beach House' or tblfeedback.strbusinessname='Galley Beach House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Forresters Resort
Forresters Beach NSW 2260
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=9343 or tblfeedback.strbusinessname='Forresters Resort' or tblfeedback.strbusinessname='Forresters Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Apollo Country Resort
Wamberal NSW 2260
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=2165 or tblfeedback.strbusinessname='Apollo Country Resort' or tblfeedback.strbusinessname='Apollo Country Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ocean Beach Surf Life Saving Club
Umina NSW 2257
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=10758 or tblfeedback.strbusinessname='Ocean Beach Surf Life Saving Club' or tblfeedback.strbusinessname='Ocean Beach Surf Life Saving Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tuggerah Lakes Memorial Club
The Entrance NSW 2261
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=11799 or tblfeedback.strbusinessname='Tuggerah Lakes Memorial Club' or tblfeedback.strbusinessname='Tuggerah Lakes Memorial Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Strathavon Heritage Resort
Wyong NSW 2259
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=11568 or tblfeedback.strbusinessname='Strathavon Heritage Resort' or tblfeedback.strbusinessname='Strathavon Heritage Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Encore Brasserie
Wyoming NSW 2250
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=9174 or tblfeedback.strbusinessname='Encore Brasserie' or tblfeedback.strbusinessname='Encore Brasserie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
River Reflection
Tacoma NSW 2259
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=2064 or tblfeedback.strbusinessname='River Reflection' or tblfeedback.strbusinessname='River Reflection') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tuggerah Lakes Golf Club
Shelly Beach NSW 2261
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=18301 or tblfeedback.strbusinessname='Tuggerah Lakes Golf Club' or tblfeedback.strbusinessname='Tuggerah Lakes Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Magic Charters
Saratoga NSW 2251
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=10324 or tblfeedback.strbusinessname='Magic Charters' or tblfeedback.strbusinessname='Magic Charters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Manon's House
Forresters Beach NSW 2260
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=10355 or tblfeedback.strbusinessname='Manon'%%semi%%s House' or tblfeedback.strbusinessname='Manon's House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gosford gold Club Ltd
Gosford NSW 2250
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=2002 or tblfeedback.strbusinessname='Gosford gold Club Ltd' or tblfeedback.strbusinessname='Gosford gold Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elegance Outdoors
Forresters Beach NSW 2260
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=2001 or tblfeedback.strbusinessname='Elegance Outdoors' or tblfeedback.strbusinessname='Elegance Outdoors') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Admiral's Quarters
Gosford NSW 2250
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=2142 or tblfeedback.strbusinessname='Admiral'%%semi%%s Quarters' or tblfeedback.strbusinessname='Admiral's Quarters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Karrabee Floating Restaurant The
Gosford NSW 2250
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=10014 or tblfeedback.strbusinessname='Karrabee Floating Restaurant The' or tblfeedback.strbusinessname='Karrabee Floating Restaurant The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tavola Toscana
Avoca Beach NSW 2251
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=11686 or tblfeedback.strbusinessname='Tavola Toscana' or tblfeedback.strbusinessname='Tavola Toscana') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mantas Seafood Restaurant
Long Jetty NSW 2261
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=10360 or tblfeedback.strbusinessname='Mantas Seafood Restaurant' or tblfeedback.strbusinessname='Mantas Seafood Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Villa Sorgenti
Somersby NSW 2250
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=11896 or tblfeedback.strbusinessname='Villa Sorgenti' or tblfeedback.strbusinessname='Villa Sorgenti') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kincumber Hotel Resort
Kincumber NSW 2251
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=10082 or tblfeedback.strbusinessname='Kincumber Hotel Resort' or tblfeedback.strbusinessname='Kincumber Hotel Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wyong Rugby League Club Ltd
Kanwal NSW 2259
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=12102 or tblfeedback.strbusinessname='Wyong Rugby League Club Ltd' or tblfeedback.strbusinessname='Wyong Rugby League Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ettalong Beach Club
Ettalong Beach NSW 2257
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=9196 or tblfeedback.strbusinessname='Ettalong Beach Club' or tblfeedback.strbusinessname='Ettalong Beach Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ocean Beach Waterfront Restaurant & Function Centre
Umina Beach NSW 2257
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=10759 or tblfeedback.strbusinessname='Ocean Beach Waterfront Restaurant &%%semi%% Function Centre' or tblfeedback.strbusinessname='Ocean Beach Waterfront Restaurant & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gosford Golf Club Ltd
Gosford NSW 2250
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=9504 or tblfeedback.strbusinessname='Gosford Golf Club Ltd' or tblfeedback.strbusinessname='Gosford Golf Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Letterbox Restaurant
Terrigal NSW 2260
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=10199 or tblfeedback.strbusinessname='Letterbox Restaurant' or tblfeedback.strbusinessname='Letterbox Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Avoca Tea House The
Avoca Beach NSW 2251
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=7992 or tblfeedback.strbusinessname='Avoca Tea House The' or tblfeedback.strbusinessname='Avoca Tea House The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Starship Cruises
Gosford NSW 2250
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=2074 or tblfeedback.strbusinessname='Starship Cruises' or tblfeedback.strbusinessname='Starship Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 81 Sort search results alphabetically