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
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
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
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
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
The Tame Fox
Erina 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=44114 or tblfeedback.strbusinessname='The Tame Fox' or tblfeedback.strbusinessname='The Tame Fox') 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
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
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
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
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
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
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
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
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
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
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
Bidja Estate
Ourimbah 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=41250 or tblfeedback.strbusinessname='Bidja Estate' or tblfeedback.strbusinessname='Bidja Estate') 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
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
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
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
Avoca Beach House
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=44145 or tblfeedback.strbusinessname='Avoca Beach House' or tblfeedback.strbusinessname='Avoca Beach House') 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
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
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
Mingara Recreation Club Ltd
Tumbi Umbi 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=10513 or tblfeedback.strbusinessname='Mingara Recreation Club Ltd' or tblfeedback.strbusinessname='Mingara Recreation Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Koi Sanctuary Gardens
Glenning Valley 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=10098 or tblfeedback.strbusinessname='Koi Sanctuary Gardens' or tblfeedback.strbusinessname='Koi Sanctuary Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Winning Post Catering Service
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=2085 or tblfeedback.strbusinessname='The Winning Post Catering Service' or tblfeedback.strbusinessname='The Winning Post Catering Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Sea Sands Resort
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=1936 or tblfeedback.strbusinessname='The Sea Sands Resort' or tblfeedback.strbusinessname='The Sea Sands 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
Grumpies Restaurant
Lake Munmorah 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=9577 or tblfeedback.strbusinessname='Grumpies Restaurant' or tblfeedback.strbusinessname='Grumpies Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mutti's Coral Street Bistro
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=10610 or tblfeedback.strbusinessname='Mutti'%%semi%%s Coral Street Bistro' or tblfeedback.strbusinessname='Mutti's Coral Street Bistro') 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
North Entrance Surf Life Saving Club
The Entrance North 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=10723 or tblfeedback.strbusinessname='North Entrance Surf Life Saving Club' or tblfeedback.strbusinessname='North Entrance Surf Life Saving Club') 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
Linton Gardens Reception & Function Centre
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=10231 or tblfeedback.strbusinessname='Linton Gardens Reception &%%semi%% Function Centre' or tblfeedback.strbusinessname='Linton Gardens Reception & 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
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
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
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
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
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
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
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
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
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
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
1 - 50 of 84 Sort search results alphabetically