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
Bourke Bridge Inn
Bourke NSW 2840
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=26366 or tblfeedback.strbusinessname='Bourke Bridge Inn' or tblfeedback.strbusinessname='Bourke Bridge Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Yamba Golf Club
Yamba NSW 2464
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=22491 or tblfeedback.strbusinessname='Yamba Golf Club' or tblfeedback.strbusinessname='Yamba Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Summerland House Farm
Alstonville NSW 2477
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=37646 or tblfeedback.strbusinessname='Summerland House Farm' or tblfeedback.strbusinessname='Summerland House Farm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Corner Restaurant
Port Macquarie NSW 2444
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=29005 or tblfeedback.strbusinessname='The Corner Restaurant' or tblfeedback.strbusinessname='The Corner Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Annuka 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=32647 or tblfeedback.strbusinessname='Annuka Beach Resort' or tblfeedback.strbusinessname='Annuka Beach Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Two Tails Wines
Nana Glen 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=27246 or tblfeedback.strbusinessname='Two Tails Wines' or tblfeedback.strbusinessname='Two Tails Wines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Angourie Resort Yamba
Yamba NSW 2464
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=39730 or tblfeedback.strbusinessname='Angourie Resort Yamba' or tblfeedback.strbusinessname='Angourie Resort Yamba') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ballina RSL Function Centre
Ballina NSW 2478
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=20218 or tblfeedback.strbusinessname='Ballina RSL Function Centre' or tblfeedback.strbusinessname='Ballina RSL Function Centre ') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Villa Vivante
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=26862 or tblfeedback.strbusinessname='Villa Vivante' or tblfeedback.strbusinessname='Villa Vivante') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rafferty's Resort
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=26425 or tblfeedback.strbusinessname='Rafferty'%%semi%%s Resort' or tblfeedback.strbusinessname='Rafferty's Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Club Old Bar
Old Bar NSW 2430
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=27763 or tblfeedback.strbusinessname='Club Old Bar' or tblfeedback.strbusinessname='Club Old Bar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Armidale City Bowling Club
Armidale NSW 2350
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=26816 or tblfeedback.strbusinessname='Armidale City Bowling Club' or tblfeedback.strbusinessname='Armidale City Bowling Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Castaway Norfolk Island
Norfolk Island NSW 2899
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=27374 or tblfeedback.strbusinessname='Castaway Norfolk Island' or tblfeedback.strbusinessname='Castaway Norfolk Island') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Summergrove Estate
Carool NSW 2486
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=29892 or tblfeedback.strbusinessname='Summergrove Estate' or tblfeedback.strbusinessname='Summergrove Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Shoal Bay Country Club
Shoal Bay NSW 2315
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=39911 or tblfeedback.strbusinessname='Shoal Bay Country Club' or tblfeedback.strbusinessname='Shoal Bay Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bonville International Golf Resort
Bonville NSW 2441
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=8290 or tblfeedback.strbusinessname='Bonville International Golf Resort' or tblfeedback.strbusinessname='Bonville International Golf Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Osteria Casuarina
Kingscliff NSW 2487
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=27278 or tblfeedback.strbusinessname='Osteria Casuarina' or tblfeedback.strbusinessname='Osteria Casuarina') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Best Western Sanctuary Inn
Tamworth NSW 2340
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=26974 or tblfeedback.strbusinessname='Best Western Sanctuary Inn' or tblfeedback.strbusinessname='Best Western Sanctuary Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coonamble Bowling Club
Coonamble NSW 2829
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=27553 or tblfeedback.strbusinessname='Coonamble Bowling Club' or tblfeedback.strbusinessname='Coonamble Bowling Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Macksville RSL
Macksville NSW 2447
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=24595 or tblfeedback.strbusinessname='Macksville RSL' or tblfeedback.strbusinessname='Macksville RSL') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Inverell Golf Club
Inverell NSW 2360
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=27261 or tblfeedback.strbusinessname='Inverell Golf Club' or tblfeedback.strbusinessname='Inverell Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Babalou Weddings and Events
Kingscliff NSW 2487
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=35686 or tblfeedback.strbusinessname='Babalou Weddings and Events' or tblfeedback.strbusinessname='Babalou Weddings and Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
BreakFree 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=33228 or tblfeedback.strbusinessname='BreakFree Aanuka Beach Resort' or tblfeedback.strbusinessname='BreakFree Aanuka Beach Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Little Fish Cafe
Port Macquarie NSW 2444
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=35542 or tblfeedback.strbusinessname='Little Fish Cafe' or tblfeedback.strbusinessname='Little Fish Cafe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hamiltons Oysters
Tuncurry NSW 2428
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=27446 or tblfeedback.strbusinessname='Hamiltons Oysters' or tblfeedback.strbusinessname='Hamiltons Oysters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bonville Golf Resort
Bonville NSW 2441
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=39762 or tblfeedback.strbusinessname='Bonville Golf Resort' or tblfeedback.strbusinessname='Bonville Golf Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sails Resort Port Macquarie
Port Macquarie NSW 2444
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=11274 or tblfeedback.strbusinessname='Sails Resort Port Macquarie' or tblfeedback.strbusinessname='Sails Resort Port Macquarie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Salt Bar Kingscliff
Kingscliff NSW 2487
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=23139 or tblfeedback.strbusinessname='Salt Bar Kingscliff' or tblfeedback.strbusinessname='Salt Bar Kingscliff') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Riverside Ranch
Yamba NSW 2464
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=26859 or tblfeedback.strbusinessname='Riverside Ranch' or tblfeedback.strbusinessname='Riverside Ranch') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Eagles Rest Weddings
Valla Beach NSW 2448
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=25030 or tblfeedback.strbusinessname='Eagles Rest Weddings' or tblfeedback.strbusinessname='Eagles Rest Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Glen Innes Services Club
Glen Innes NSW 2370
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=26660 or tblfeedback.strbusinessname='Glen Innes Services Club' or tblfeedback.strbusinessname='Glen Innes Services Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coffs Harbour Surf Club
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=25026 or tblfeedback.strbusinessname='Coffs Harbour Surf Club' or tblfeedback.strbusinessname='Coffs Harbour Surf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Anchors Wharf Cafe
Urunga NSW 2455
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=27094 or tblfeedback.strbusinessname='Anchors Wharf Cafe' or tblfeedback.strbusinessname='Anchors Wharf Cafe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cedar Bar and Kitchen
Bellingen NSW 2454
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=29109 or tblfeedback.strbusinessname='Cedar Bar and Kitchen' or tblfeedback.strbusinessname='Cedar Bar and Kitchen') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Friday Creek Retreat
Upper Orara 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=37445 or tblfeedback.strbusinessname='Friday Creek Retreat' or tblfeedback.strbusinessname='Friday Creek Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Smoky Cape Lighthouse
Arakoon NSW 2431
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=25703 or tblfeedback.strbusinessname='Smoky Cape Lighthouse' or tblfeedback.strbusinessname='Smoky Cape Lighthouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bens Falls Retreat
Emmaville NSW 2371
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=26389 or tblfeedback.strbusinessname='Bens Falls Retreat' or tblfeedback.strbusinessname='Bens Falls Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Figtree Resturant
Ewingsdale NSW 2481
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=21967 or tblfeedback.strbusinessname='Figtree Resturant' or tblfeedback.strbusinessname='Figtree Resturant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Canvas & Kettle Restaurant & Auditorium The
Murwillumbah NSW 2484
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=8503 or tblfeedback.strbusinessname='Canvas &%%semi%% Kettle Restaurant &%%semi%% Auditorium The' or tblfeedback.strbusinessname='Canvas & Kettle Restaurant & Auditorium The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pass Cafe The
Byron Bay NSW 2481
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=10863 or tblfeedback.strbusinessname='Pass Cafe The' or tblfeedback.strbusinessname='Pass Cafe The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Crystal Castle
Mullumbimby NSW 2482
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=8859 or tblfeedback.strbusinessname='Crystal Castle' or tblfeedback.strbusinessname='Crystal Castle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ballina Beach Resort
Ballina NSW 2478
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=1988 or tblfeedback.strbusinessname='Ballina Beach Resort' or tblfeedback.strbusinessname='Ballina Beach Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Byron Bay Beach Club
Byron Bay NSW 2481
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=8446 or tblfeedback.strbusinessname='Byron Bay Beach Club' or tblfeedback.strbusinessname='Byron Bay Beach Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Nautilus 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=18282 or tblfeedback.strbusinessname='Nautilus Resort' or tblfeedback.strbusinessname='Nautilus Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pioneer Country Trail Rides
Tweed Heads South NSW 2486
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=10998 or tblfeedback.strbusinessname='Pioneer Country Trail Rides' or tblfeedback.strbusinessname='Pioneer Country Trail Rides') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Maxim's Chinese Restaurant
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=10424 or tblfeedback.strbusinessname='Maxim'%%semi%%s Chinese Restaurant' or tblfeedback.strbusinessname='Maxim's Chinese Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Port Macquarie Gold Club Ltd
Port Macquarie NSW 2444
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=2099 or tblfeedback.strbusinessname='Port Macquarie Gold Club Ltd' or tblfeedback.strbusinessname='Port Macquarie Gold Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Blue Gum
Lismore NSW 2480
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=8246 or tblfeedback.strbusinessname='Blue Gum' or tblfeedback.strbusinessname='Blue Gum') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Port Macquarie RSL Club
Port Macquarie NSW 2444
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=11027 or tblfeedback.strbusinessname='Port Macquarie RSL Club' or tblfeedback.strbusinessname='Port Macquarie RSL Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 112 Sort search results alphabetically