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
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
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
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
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=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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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 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
Avoca Beach Bowling & Recreation Club
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=2187 or tblfeedback.strbusinessname='Avoca Beach Bowling &%%semi%% Recreation Club' or tblfeedback.strbusinessname='Avoca Beach Bowling & Recreation Club') 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
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
Rating
Hibiscus Lakeside Motel
Budgewoi NSW 2262
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=9688 or tblfeedback.strbusinessname='Hibiscus Lakeside Motel' or tblfeedback.strbusinessname='Hibiscus Lakeside Motel') 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
Rating
Metro Motor Inn Gosford
Gosford North 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=10470 or tblfeedback.strbusinessname='Metro Motor Inn Gosford' or tblfeedback.strbusinessname='Metro Motor Inn Gosford') 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
Trez's Castle of Horror
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=11785 or tblfeedback.strbusinessname='Trez'%%semi%%s Castle of Horror' or tblfeedback.strbusinessname='Trez's Castle of Horror') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Country Comfort 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=8814 or tblfeedback.strbusinessname='Country Comfort Terrigal' or tblfeedback.strbusinessname='Country Comfort Terrigal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wedding Connection The
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=11980 or tblfeedback.strbusinessname='Wedding Connection The' or tblfeedback.strbusinessname='Wedding Connection The') 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
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
Wyee Party Hire
Wyee 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=12096 or tblfeedback.strbusinessname='Wyee Party Hire' or tblfeedback.strbusinessname='Wyee Party Hire') 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
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
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
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
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
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
Gosford Race Club Ltd
Gosford West 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=9506 or tblfeedback.strbusinessname='Gosford Race Club Ltd' or tblfeedback.strbusinessname='Gosford Race Club Ltd') 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
Bellbird Resort
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=1937 or tblfeedback.strbusinessname='Bellbird Resort' or tblfeedback.strbusinessname='Bellbird Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Old Sydney Town
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=10769 or tblfeedback.strbusinessname='Old Sydney Town' or tblfeedback.strbusinessname='Old Sydney Town') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Apollo Resort Wamberal
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=2167 or tblfeedback.strbusinessname='Apollo Resort Wamberal' or tblfeedback.strbusinessname='Apollo Resort Wamberal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Central Coast Marine Booking Office
Booker Bay 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=8587 or tblfeedback.strbusinessname='Central Coast Marine Booking Office' or tblfeedback.strbusinessname='Central Coast Marine Booking Office') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Winning Post Catering Service The
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=12065 or tblfeedback.strbusinessname='Winning Post Catering Service The' or tblfeedback.strbusinessname='Winning Post Catering Service The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 81 Sort search results alphabetically