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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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=2189 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
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
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
Woy Woy Bowling Club
Woy Woy 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=12090 or tblfeedback.strbusinessname='Woy Woy Bowling Club' or tblfeedback.strbusinessname='Woy Woy Bowling 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
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
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
Palms Reception Centre & Motel
Gorokan NSW 2263
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=10813 or tblfeedback.strbusinessname='Palms Reception Centre &%%semi%% Motel' or tblfeedback.strbusinessname='Palms Reception Centre & Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wyong District Masonic Centre Pty Ltd
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=12101 or tblfeedback.strbusinessname='Wyong District Masonic Centre Pty Ltd' or tblfeedback.strbusinessname='Wyong District Masonic Centre Pty Ltd') 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
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
Golden Cowrie Pty Ltd The
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=9484 or tblfeedback.strbusinessname='Golden Cowrie Pty Ltd The' or tblfeedback.strbusinessname='Golden Cowrie Pty Ltd The') 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
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
The Beachcomber
Toukley NSW 2263
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=18297 or tblfeedback.strbusinessname='The Beachcomber' or tblfeedback.strbusinessname='The Beachcomber') 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
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
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
Rating
Forest of Tranquillity Wildlife Sanctuary
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=9329 or tblfeedback.strbusinessname='Forest of Tranquillity Wildlife Sanctuary' or tblfeedback.strbusinessname='Forest of Tranquillity Wildlife Sanctuary') 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
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
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
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
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
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
1 - 50 of 84 Sort search results alphabetically