Salsa Bar and Grill
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=18723 or tblfeedback.strbusinessname='Salsa Bar and Grill' or tblfeedback.strbusinessname='Salsa Bar and Grill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Salsa Bar and Grill is located on the corner of Wharf Street & Warner Street with views over the Dickson Inlet. The venue naturally lends itself to the romanticism of a special event & is ideal for a Wedding Reception, a short stroll across the park from St. Marys By The Sea Chapel.
Sea Temple Resort & Spa Port Douglas, Pullman
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=19861 or tblfeedback.strbusinessname='Sea Temple Resort &%%semi%% Spa Port Douglas, Pullman' or tblfeedback.strbusinessname='Sea Temple Resort & Spa Port Douglas, Pullman') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Sea Temple Resort & Spa Port Douglas is a stunning, luxurious five star property located at Four Mile Beach, with access to many ceremony and reception venues.
The Sebel Reef House & Spa
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=19811 or tblfeedback.strbusinessname='The Sebel Reef House &%%semi%% Spa' or tblfeedback.strbusinessname='The Sebel Reef House & Spa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sebel Reef House and Spa is the ideal venue for your wedding or reception. It has been voted "one of the most romantic places in the world".
The Elandra Mission Beach
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=19540 or tblfeedback.strbusinessname='The Elandra Mission Beach' or tblfeedback.strbusinessname='The Elandra Mission Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A boutique resort, glamorous surrounds.
Mission Beach Resort
Mission 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=29465 or tblfeedback.strbusinessname='Mission Beach Resort' or tblfeedback.strbusinessname='Mission Beach Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Port Douglas Weddings
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=29021 or tblfeedback.strbusinessname='Port Douglas Weddings' or tblfeedback.strbusinessname='Port Douglas Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Palm House Whitsunday
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=25706 or tblfeedback.strbusinessname='The Palm House Whitsunday' or tblfeedback.strbusinessname='The Palm House Whitsunday') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Birds On Barron
Mareeba QLD 4880
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=38517 or tblfeedback.strbusinessname='Birds On Barron' or tblfeedback.strbusinessname='Birds On Barron') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rockhampton Herritage Village
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Elite Barn Weddings
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=43345 or tblfeedback.strbusinessname='Elite Barn Weddings' or tblfeedback.strbusinessname='Elite Barn Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Peppers Beach Club and Spa Palm Cove
Palm Cove 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=35935 or tblfeedback.strbusinessname='Peppers Beach Club and Spa Palm Cove' or tblfeedback.strbusinessname='Peppers Beach Club and Spa Palm Cove') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Cape Gloucester Resort
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=35732 or tblfeedback.strbusinessname='Cape Gloucester Resort' or tblfeedback.strbusinessname='Cape Gloucester Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Allumbah Pocket Cottages Yungaburra
Yungaburra QLD 4884
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=37611 or tblfeedback.strbusinessname='Allumbah Pocket Cottages Yungaburra' or tblfeedback.strbusinessname='Allumbah Pocket Cottages Yungaburra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Brewery Townsville
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=27596 or tblfeedback.strbusinessname='The Brewery Townsville' or tblfeedback.strbusinessname='The Brewery Townsville') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hotel Grand Chancellor Palm Cove
Palm Cove 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=26593 or tblfeedback.strbusinessname='Hotel Grand Chancellor Palm Cove' or tblfeedback.strbusinessname='Hotel Grand Chancellor Palm Cove') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
De Brueys Boutique Wines
Mareeba QLD 4880
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=36200 or tblfeedback.strbusinessname='De Brueys Boutique Wines' or tblfeedback.strbusinessname='De Brueys Boutique Wines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Leahton Park
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=38368 or tblfeedback.strbusinessname='Leahton Park' or tblfeedback.strbusinessname='Leahton Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Whitfield House
Edge Hill 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=16957 or tblfeedback.strbusinessname='Whitfield House' or tblfeedback.strbusinessname='Whitfield House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Townsville Greek Community Centre
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=27118 or tblfeedback.strbusinessname='Townsville Greek Community Centre' or tblfeedback.strbusinessname='Townsville Greek Community Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Pullman Reef Hotel Casino
Cairns City 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=39905 or tblfeedback.strbusinessname='Pullman Reef Hotel Casino' or tblfeedback.strbusinessname='Pullman Reef Hotel Casino') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Penny Lane Gardens Restaurant
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mercure Inn Townsville
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mercure Townsville
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jam corner Townsville
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=38519 or tblfeedback.strbusinessname='Jam corner Townsville' or tblfeedback.strbusinessname='Jam corner Townsville') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Ville Resort Casino
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=43627 or tblfeedback.strbusinessname='The Ville Resort Casino' or tblfeedback.strbusinessname='The Ville Resort Casino') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Allure Events
South 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=26759 or tblfeedback.strbusinessname='Allure Events' or tblfeedback.strbusinessname='Allure Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Yorkeys Knob Boat Club
Yorkeys Knob QLD 4878
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=23211 or tblfeedback.strbusinessname='Yorkeys Knob Boat Club' or tblfeedback.strbusinessname='Yorkeys Knob Boat Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Castaways Resort and Spa
Mission 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=22702 or tblfeedback.strbusinessname='Castaways Resort and Spa' or tblfeedback.strbusinessname='Castaways Resort and Spa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mt Uncle Distillery
Walkamin QLD 4872
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=29470 or tblfeedback.strbusinessname='Mt Uncle Distillery' or tblfeedback.strbusinessname='Mt Uncle Distillery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Harrup Park Country Club
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Townsville Yacht Club
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=27018 or tblfeedback.strbusinessname='Townsville Yacht Club' or tblfeedback.strbusinessname='Townsville Yacht Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Terrace Gardens Function Centre
Mount Isa QLD 4825
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=29246 or tblfeedback.strbusinessname='Terrace Gardens Function Centre' or tblfeedback.strbusinessname='Terrace Gardens Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kelly's Beach Resort
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Reef House Restaurant
Palm Cove 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=27321 or tblfeedback.strbusinessname='Reef House Restaurant' or tblfeedback.strbusinessname='Reef House Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Laloli
Little Mulgrave QLD 4865
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=41719 or tblfeedback.strbusinessname='Laloli' or tblfeedback.strbusinessname='Laloli') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Villa Botanica
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hamilton Island Yacht Club
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Grand Chancellor Townsville
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=26146 or tblfeedback.strbusinessname='The Grand Chancellor Townsville' or tblfeedback.strbusinessname='The Grand Chancellor Townsville') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Teepee Events Whitsunday
Whitsundays 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=36201 or tblfeedback.strbusinessname='Teepee Events Whitsunday' or tblfeedback.strbusinessname='Teepee Events Whitsunday') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Pepper's Blue on Blue
Nelly Bay QLD 4819
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=26597 or tblfeedback.strbusinessname='Pepper''s Blue on Blue' or tblfeedback.strbusinessname='Pepper''s Blue on Blue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Knightclub Function Centre Ingham
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Farm Plumeria Road
Black River QLD 4818
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=35896 or tblfeedback.strbusinessname='The Farm Plumeria Road' or tblfeedback.strbusinessname='The Farm Plumeria Road') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Clarion hotel Mackay Marina
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mackay Surf Lifesaving Club
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tinaroo Lake Resort
Tinaroo QLD 4872
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=46179 or tblfeedback.strbusinessname='Tinaroo Lake Resort' or tblfeedback.strbusinessname='Tinaroo Lake Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
St Mary's by the Sea
Dixie Street 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=29717 or tblfeedback.strbusinessname='St Mary'%%semi%%s by the Sea' or tblfeedback.strbusinessname='St Mary's by the Sea') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Millers Beach Bar and Grill
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mareeba Turf Club
Mareeba QLD 4880
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=29591 or tblfeedback.strbusinessname='Mareeba Turf Club' or tblfeedback.strbusinessname='Mareeba Turf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
All Souls and Saint Gabriels
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
HerveyRange Heritage Tea Rooms
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=38501 or tblfeedback.strbusinessname='HerveyRange Heritage Tea Rooms' or tblfeedback.strbusinessname='HerveyRange Heritage Tea Rooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
View Your Favorites List
