Bundaberg Services Club
17 Quay Street Bundaberg QLD 4670
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=25589 or tblfeedback.strbusinessname='Bundaberg Services Club' or tblfeedback.strbusinessname='Bundaberg Services Club') and year(getdate())-year(dtmadded)<=15
Millers Beach Bar and Grill
1 Banfield Parade
Wongaling Beach QLD 4852
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=25609 or tblfeedback.strbusinessname='Millers Beach Bar and Grill' or tblfeedback.strbusinessname='Millers Beach Bar and Grill') and year(getdate())-year(dtmadded)<=15
Pepper's Resort Airlie Beach
Mount Whitsunday Drive
Airlie Beach QLD 4802
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=26206 or tblfeedback.strbusinessname='Pepper'%%semi%%s Resort Airlie Beach' or tblfeedback.strbusinessname='Pepper's Resort Airlie Beach') and year(getdate())-year(dtmadded)<=15
Windmill Motel & Reception Centre
5 Highway Plaza Mackay QLD 4740
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=26254 or tblfeedback.strbusinessname='Windmill Motel &%%semi%% Reception Centre' or tblfeedback.strbusinessname='Windmill Motel & Reception Centre') and year(getdate())-year(dtmadded)<=15
Coral Sea Resort Airlie Beach
25 Ocean View Ave Airlie Beach QLD 4802
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=26361 or tblfeedback.strbusinessname='Coral Sea Resort Airlie Beach' or tblfeedback.strbusinessname='Coral Sea Resort Airlie Beach') and year(getdate())-year(dtmadded)<=15
Harrup Park Country Club
Juliet St
Mackay QLD 4740
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=25689 or tblfeedback.strbusinessname='Harrup Park Country Club' or tblfeedback.strbusinessname='Harrup Park Country Club') and year(getdate())-year(dtmadded)<=15
The Knightclub Function Centre Ingham
38 Herbert St Ingham QLD 4850
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=25809 or tblfeedback.strbusinessname='The Knightclub Function Centre Ingham' or tblfeedback.strbusinessname='The Knightclub Function Centre Ingham') and year(getdate())-year(dtmadded)<=15
Sugar Wharf
Dixie St Port Douglas QLD 4877
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=27952 or tblfeedback.strbusinessname='Sugar Wharf' or tblfeedback.strbusinessname='Sugar Wharf') and year(getdate())-year(dtmadded)<=15
Cape Gloucester
128 Gloucester Avenue Hideaway Bay QLD 4800
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=29533 or tblfeedback.strbusinessname='Cape Gloucester' or tblfeedback.strbusinessname='Cape Gloucester') and year(getdate())-year(dtmadded)<=15
Mercure Inn Townsville
166 Woolcock St Townsville QLD 4810
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=29563 or tblfeedback.strbusinessname='Mercure Inn Townsville' or tblfeedback.strbusinessname='Mercure Inn Townsville') and year(getdate())-year(dtmadded)<=15
Cairns Colonial Club
18-26 Cannon St Cairns QLD 4870
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=25242 or tblfeedback.strbusinessname='Cairns Colonial Club' or tblfeedback.strbusinessname='Cairns Colonial Club') and year(getdate())-year(dtmadded)<=15
The Capricornian Restaurant
17 Esmond St Emerald QLD 4720
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=23799 or tblfeedback.strbusinessname='The Capricornian Restaurant' or tblfeedback.strbusinessname='The Capricornian Restaurant') and year(getdate())-year(dtmadded)<=15
Kingfisher Bay Resort & Village
410 Queen St, Brisbane City Urangan QLD 4655
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=16783 or tblfeedback.strbusinessname='Kingfisher Bay Resort &%%semi%% Village' or tblfeedback.strbusinessname='Kingfisher Bay Resort & Village') and year(getdate())-year(dtmadded)<=15
Glenmore Homestead
48 Belmont Rd Parkhurst QLD 4702
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=16750 or tblfeedback.strbusinessname='Glenmore Homestead' or tblfeedback.strbusinessname='Glenmore Homestead') and year(getdate())-year(dtmadded)<=15
Grand Hotel Gladstone
79 Goondoon St Gladstone QLD 4680
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=16759 or tblfeedback.strbusinessname='Grand Hotel Gladstone' or tblfeedback.strbusinessname='Grand Hotel Gladstone') and year(getdate())-year(dtmadded)<=15
Penny Lane Gardens Restaurant
57 Gorlicks Rd Branyan QLD 4670
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=16861 or tblfeedback.strbusinessname='Penny Lane Gardens Restaurant' or tblfeedback.strbusinessname='Penny Lane Gardens Restaurant') and year(getdate())-year(dtmadded)<=15
The Beach House
344 Esplanade Hervey Bay QLD 4655
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=26603 or tblfeedback.strbusinessname='The Beach House' or tblfeedback.strbusinessname='The Beach House') and year(getdate())-year(dtmadded)<=15
Cafe @1928
6 MT Perry Road Bundaberg QLD 4670
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=25524 or tblfeedback.strbusinessname='Cafe @1928' or tblfeedback.strbusinessname='Cafe @1928') and year(getdate())-year(dtmadded)<=15
All Souls and Saint Gabriels
30 Dr George Ellis Dr Charters Towers QLD 4820
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=25646 or tblfeedback.strbusinessname='All Souls and Saint Gabriels' or tblfeedback.strbusinessname='All Souls and Saint Gabriels') and year(getdate())-year(dtmadded)<=15
Rainforest Ranch
76 Yaxleys Rd Byfield QLD 4703
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=25815 or tblfeedback.strbusinessname='Rainforest Ranch' or tblfeedback.strbusinessname='Rainforest Ranch') and year(getdate())-year(dtmadded)<=15
Eleven Acres Bundaberg
363 Branyan Drive
Bundaberg QLD 4670
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=26050 or tblfeedback.strbusinessname='Eleven Acres Bundaberg' or tblfeedback.strbusinessname='Eleven Acres Bundaberg') and year(getdate())-year(dtmadded)<=15
Villa Botanica
Botanica Dr Woodwark QLD 4802
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=21931 or tblfeedback.strbusinessname='Villa Botanica' or tblfeedback.strbusinessname='Villa Botanica') and year(getdate())-year(dtmadded)<=15
Rockhampton Leagues Club
Cambridge St Rockhampton QLD 4700
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=22045 or tblfeedback.strbusinessname='Rockhampton Leagues Club' or tblfeedback.strbusinessname='Rockhampton Leagues Club') and year(getdate())-year(dtmadded)<=15
Mackay Surf Lifesaving Club
Lot 67 E Point Dr Mackay Harbour QLD 4740
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=24866 or tblfeedback.strbusinessname='Mackay Surf Lifesaving Club' or tblfeedback.strbusinessname='Mackay Surf Lifesaving Club') and year(getdate())-year(dtmadded)<=15
Clarion hotel Mackay Marina
Mulherin Dr Mackay Marina QLD 4740
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=24868 or tblfeedback.strbusinessname='Clarion hotel Mackay Marina' or tblfeedback.strbusinessname='Clarion hotel Mackay Marina') and year(getdate())-year(dtmadded)<=15
Fairymead House
Thornhill St Bundaberg North QLD 4670
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=26062 or tblfeedback.strbusinessname='Fairymead House' or tblfeedback.strbusinessname='Fairymead House') and year(getdate())-year(dtmadded)<=15
Kelly's Beach Resort
6 Trevors Rd Bundaberg QLD 4670
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=27518 or tblfeedback.strbusinessname='Kelly'%%semi%%s Beach Resort' or tblfeedback.strbusinessname='Kelly's Beach Resort') and year(getdate())-year(dtmadded)<=15
The Royal Hotel Ingham
44/40-46 Lannercost St Ingham QLD 4850
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=26100 or tblfeedback.strbusinessname='The Royal Hotel Ingham' or tblfeedback.strbusinessname='The Royal Hotel Ingham') and year(getdate())-year(dtmadded)<=15
Henderson Park Farm Retreat
88 C H Barretts Rd Barmoya QLD 4703
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=23386 or tblfeedback.strbusinessname='Henderson Park Farm Retreat' or tblfeedback.strbusinessname='Henderson Park Farm Retreat') and year(getdate())-year(dtmadded)<=15
Maroochy River Golf Club
374-514 David Low Way Bli Bli QLD 4560
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=26498 or tblfeedback.strbusinessname='Maroochy River Golf Club' or tblfeedback.strbusinessname='Maroochy River Golf Club') and year(getdate())-year(dtmadded)<=15
Herveys Range Heritage Tea Rooms
37 Thornton's Gap Road Townsville QLD 4817
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=26497 or tblfeedback.strbusinessname='Herveys Range Heritage Tea Rooms' or tblfeedback.strbusinessname='Herveys Range Heritage Tea Rooms') and year(getdate())-year(dtmadded)<=15
Stoney Creek Farmstay
Stoney Creek Rd Eton QLD 4741
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=26722 or tblfeedback.strbusinessname='Stoney Creek Farmstay' or tblfeedback.strbusinessname='Stoney Creek Farmstay') and year(getdate())-year(dtmadded)<=15
H20 Burnett Riverside
7 Quay St Bundaberg QLD 4670
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=26788 or tblfeedback.strbusinessname='H20 Burnett Riverside' or tblfeedback.strbusinessname='H20 Burnett Riverside') and year(getdate())-year(dtmadded)<=15
Hamilton Island Yacht Club
Front St Hamilton Island QLD 4803
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=26790 or tblfeedback.strbusinessname='Hamilton Island Yacht Club' or tblfeedback.strbusinessname='Hamilton Island Yacht Club') and year(getdate())-year(dtmadded)<=15
Souths Leagues Club
181 Milton St Mackay QLD 4740
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=29339 or tblfeedback.strbusinessname='Souths Leagues Club' or tblfeedback.strbusinessname='Souths Leagues Club') and year(getdate())-year(dtmadded)<=15
Mercure Townsville
166 Woolcock St Townsville QLD 4812
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=27132 or tblfeedback.strbusinessname='Mercure Townsville' or tblfeedback.strbusinessname='Mercure Townsville') and year(getdate())-year(dtmadded)<=15
Rockhampton Herritage Village
Boundary Rd Parkhurst QLD 4702
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=27130 or tblfeedback.strbusinessname='Rockhampton Herritage Village' or tblfeedback.strbusinessname='Rockhampton Herritage Village') and year(getdate())-year(dtmadded)<=15
The Old Station Teahouse
231 Cape Hillsborough Rd Cape Hillsborough QLD 4741
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=27341 or tblfeedback.strbusinessname='The Old Station Teahouse' or tblfeedback.strbusinessname='The Old Station Teahouse') and year(getdate())-year(dtmadded)<=15
Whitsunday Marine Club
7 Altmann Avenue Cannonvale QLD 4802
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=27815 or tblfeedback.strbusinessname='Whitsunday Marine Club' or tblfeedback.strbusinessname='Whitsunday Marine Club') and year(getdate())-year(dtmadded)<=15
Kewarra Beach Resort & Spa
80 Kewarra St Kewarra Beach QLD 4879
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=29032 or tblfeedback.strbusinessname='Kewarra Beach Resort &%%semi%% Spa' or tblfeedback.strbusinessname='Kewarra Beach Resort & Spa') and year(getdate())-year(dtmadded)<=15
The Ville
Sir Leslie Thiess Dr
Townsville City QLD 4810
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=29076 or tblfeedback.strbusinessname='The Ville' or tblfeedback.strbusinessname='The Ville') and year(getdate())-year(dtmadded)<=15
Magpies Sporting Club
1 Glenella Rd Mackay QLD 4740
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=2257 or tblfeedback.strbusinessname='Magpies Sporting Club' or tblfeedback.strbusinessname='Magpies Sporting Club') and year(getdate())-year(dtmadded)<=15
Beach House Restaurant
Catseye Beach Hamilton Island QLD 4803
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=18620 or tblfeedback.strbusinessname='Beach House Restaurant' or tblfeedback.strbusinessname='Beach House Restaurant') and year(getdate())-year(dtmadded)<=15
Rainbow Beach Motor Inn
Rainbow Beach QLD 4581
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=16879 or tblfeedback.strbusinessname='Rainbow Beach Motor Inn' or tblfeedback.strbusinessname='Rainbow Beach Motor Inn') and year(getdate())-year(dtmadded)<=15
Raphaels Restaurant
564 The Esplanade Urangan QLD 4655
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=16880 or tblfeedback.strbusinessname='Raphaels Restaurant' or tblfeedback.strbusinessname='Raphaels Restaurant') and year(getdate())-year(dtmadded)<=15
Reef Gateway Motor Inn
11 Takalvan Street Bundaberg QLD 4670
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=16883 or tblfeedback.strbusinessname='Reef Gateway Motor Inn' or tblfeedback.strbusinessname='Reef Gateway Motor Inn') and year(getdate())-year(dtmadded)<=15
Restaurant 98
98 Victoria Parade Rockhampton QLD 4700
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=16885 or tblfeedback.strbusinessname='Restaurant 98' or tblfeedback.strbusinessname='Restaurant 98') and year(getdate())-year(dtmadded)<=15
Rivers Restaurant
1209 Upper Ross River Road Rasmussen QLD 4815
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=16888 or tblfeedback.strbusinessname='Rivers Restaurant' or tblfeedback.strbusinessname='Rivers Restaurant') and year(getdate())-year(dtmadded)<=15
Rowers on the River
Quay Street Bundaberg QLD 4670
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=16894 or tblfeedback.strbusinessname='Rowers on the River' or tblfeedback.strbusinessname='Rowers on the River') and year(getdate())-year(dtmadded)<=15
Spinnaker Restaurant & Bar
1A Quay Street Bundaberg QLD 4670
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=16912 or tblfeedback.strbusinessname='Spinnaker Restaurant &%%semi%% Bar' or tblfeedback.strbusinessname='Spinnaker Restaurant & Bar') and year(getdate())-year(dtmadded)<=15
