QEvents atop Q1
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=19730 or tblfeedback.strbusinessname='QEvents atop Q1' or tblfeedback.strbusinessname='QEvents atop Q1') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Breathtaking 360 degree views of the entire Gold Coast.
Currumbin Wildlife Sanctuary
Currumbin QLD 4223
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=37972 or tblfeedback.strbusinessname='Currumbin Wildlife Sanctuary' or tblfeedback.strbusinessname='Currumbin Wildlife Sanctuary') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ecostudio Fellini
Mudgeeraba QLD 4213
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=18651 or tblfeedback.strbusinessname='Ecostudio Fellini' or tblfeedback.strbusinessname='Ecostudio Fellini') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sea World Resort & Water Park
Main Beach QLD 4217
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=32532 or tblfeedback.strbusinessname='Sea World Resort & Water Park' or tblfeedback.strbusinessname='Sea World Resort & Water Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Pacific Beach Function Centre
Palm Beach QLD 4221
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=29931 or tblfeedback.strbusinessname='Pacific Beach Function Centre' or tblfeedback.strbusinessname='Pacific Beach Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Evergreen Garden Venue
Parkwood QLD 4214
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=23500 or tblfeedback.strbusinessname='Evergreen Garden Venue' or tblfeedback.strbusinessname='Evergreen Garden Venue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Easy Street Diner
Mermaid Beach QLD 4216
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=26831 or tblfeedback.strbusinessname='Easy Street Diner' or tblfeedback.strbusinessname='Easy Street Diner') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Links Hope Island
Hope Island QLD 4212
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=26600 or tblfeedback.strbusinessname='Links Hope Island' or tblfeedback.strbusinessname='Links Hope Island') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Home of the Arts (HOTA) Bundall
Surfers Paradise QLD 4217
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=42973 or tblfeedback.strbusinessname='Home of the Arts (%%semi%%HOTA)%%semi%% Bundall' or tblfeedback.strbusinessname='Home of the Arts (HOTA) Bundall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tamborine Gardens Wedding and Function Resort
Tamborine Mountain QLD 4272
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=23660 or tblfeedback.strbusinessname='Tamborine Gardens Wedding and Function Resort' or tblfeedback.strbusinessname='Tamborine Gardens Wedding and Function Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Cedar Creek Lodges
Mount Tamborine QLD 4272
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=16694 or tblfeedback.strbusinessname='Cedar Creek Lodges' or tblfeedback.strbusinessname='Cedar Creek Lodges') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Coolibah Downs Estate
Mt Nathan QLD 4211
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=35937 or tblfeedback.strbusinessname='Coolibah Downs Estate' or tblfeedback.strbusinessname='Coolibah Downs Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Coolibah Downs
Nerang QLD 4211
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=18641 or tblfeedback.strbusinessname='Coolibah Downs' or tblfeedback.strbusinessname='Coolibah Downs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sol Gardens
Currumbin Valley QLD 4223
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=36069 or tblfeedback.strbusinessname='Sol Gardens' or tblfeedback.strbusinessname='Sol Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
QT Gold Coast
Surfers Paradise QLD 4217
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=20274 or tblfeedback.strbusinessname='QT Gold Coast' or tblfeedback.strbusinessname='QT Gold Coast') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Palazzo Versace
Main Beach QLD 4217
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=35985 or tblfeedback.strbusinessname='Palazzo Versace' or tblfeedback.strbusinessname='Palazzo Versace') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sheraton Grand Gold Coast Weddings
Main Beach QLD 4217
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=26217 or tblfeedback.strbusinessname='Sheraton Grand Gold Coast Weddings' or tblfeedback.strbusinessname='Sheraton Grand Gold Coast Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
St Bernards Hotel
Mt Tamborine QLD 4272
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=26136 or tblfeedback.strbusinessname='St Bernards Hotel' or tblfeedback.strbusinessname='St Bernards Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Parkwood International Golf Course
Parkwood QLD 4214
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=2265 or tblfeedback.strbusinessname='Parkwood International Golf Course' or tblfeedback.strbusinessname='Parkwood International Golf Course') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Nerang RSL
Nerang QLD 4211
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=26094 or tblfeedback.strbusinessname='Nerang RSL' or tblfeedback.strbusinessname='Nerang RSL') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hitched at the Boomerang Farm
Mudgeeraba QLD 4215
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=26845 or tblfeedback.strbusinessname='Hitched at the Boomerang Farm' or tblfeedback.strbusinessname='Hitched at the Boomerang Farm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
An Island Hideaway
South Stradbroke Island QLD 4216
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=21388 or tblfeedback.strbusinessname='An Island Hideaway' or tblfeedback.strbusinessname='An Island Hideaway') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Royal Pines Resort
Benowa QLD 4217
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=2268 or tblfeedback.strbusinessname='Royal Pines Resort' or tblfeedback.strbusinessname='Royal Pines Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Parkwood Village
Parkwood QLD 4214
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=16859 or tblfeedback.strbusinessname='Parkwood Village' or tblfeedback.strbusinessname='Parkwood Village') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Valley Estate
Currumbin Waters QLD 4223
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=43913 or tblfeedback.strbusinessname='The Valley Estate' or tblfeedback.strbusinessname='The Valley Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ramada Resort Kooralbyn
Kooralbyn QLD 4285
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=38130 or tblfeedback.strbusinessname='Ramada Resort Kooralbyn' or tblfeedback.strbusinessname='Ramada Resort Kooralbyn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Pethers Rainforest Retreat
North Tamborine QLD 4272
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=27081 or tblfeedback.strbusinessname='Pethers Rainforest Retreat' or tblfeedback.strbusinessname='Pethers Rainforest Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hilton Surfers Paradise
Surfers Paradise QLD 4217
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=25950 or tblfeedback.strbusinessname='Hilton Surfers Paradise' or tblfeedback.strbusinessname='Hilton Surfers Paradise') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Boonah Valley Vue
Boonah QLD 4310
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=38453 or tblfeedback.strbusinessname='Boonah Valley Vue' or tblfeedback.strbusinessname='Boonah Valley Vue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Marriott Resort Surfers Paradise
Surfers Paradise QLD 4217
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=18741 or tblfeedback.strbusinessname='Marriott Resort Surfers Paradise' or tblfeedback.strbusinessname='Marriott Resort Surfers Paradise') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mount Cotton Rainforest Gardens
Mt Cotton QLD 4165
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=32308 or tblfeedback.strbusinessname='Mount Cotton Rainforest Gardens' or tblfeedback.strbusinessname='Mount Cotton Rainforest Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Fleays cafe and Events
Burleigh Heads QLD 4220
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=45956 or tblfeedback.strbusinessname='Fleays cafe and Events' or tblfeedback.strbusinessname='Fleays cafe and Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Intercontinental Sanctuary Cove
Hope island QLD 4212
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=21519 or tblfeedback.strbusinessname='Intercontinental Sanctuary Cove' or tblfeedback.strbusinessname='Intercontinental Sanctuary Cove') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
O'Reilly's Rainforest Retreat
Canugra QLD 4275
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=27934 or tblfeedback.strbusinessname='O''Reilly''s Rainforest Retreat' or tblfeedback.strbusinessname='O''Reilly''s Rainforest Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Cowbell Creek Austinville
Austinville QLD 4213
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=38448 or tblfeedback.strbusinessname='Cowbell Creek Austinville' or tblfeedback.strbusinessname='Cowbell Creek Austinville') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ricorhy Kerry - Wedding Gardens & Function Catering
Kerry QLD 4285
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=25239 or tblfeedback.strbusinessname='Ricorhy Kerry - Wedding Gardens &%%semi%% Function Catering' or tblfeedback.strbusinessname='Ricorhy Kerry - Wedding Gardens & Function Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Austinvilla Estate
Mudgeeraba QLD 4213
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=25604 or tblfeedback.strbusinessname='Austinvilla Estate' or tblfeedback.strbusinessname='Austinvilla Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rydges South Bank
Surfers Paradise QLD 4217
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=26159 or tblfeedback.strbusinessname='Rydges South Bank' or tblfeedback.strbusinessname='Rydges South Bank') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Braeside Chapel
Merrimac QLD 4226
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=21056 or tblfeedback.strbusinessname='Braeside Chapel' or tblfeedback.strbusinessname='Braeside Chapel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Oskars on Burleigh
Burleigh Heads QLD 4220
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=26008 or tblfeedback.strbusinessname='Oskars on Burleigh' or tblfeedback.strbusinessname='Oskars on Burleigh') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Surfers Paradise Marriott Resort
Surfers Paradise QLD 4217
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=16927 or tblfeedback.strbusinessname='Surfers Paradise Marriott Resort' or tblfeedback.strbusinessname='Surfers Paradise Marriott Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Southport R S L Memorial Club Inc
Southport QLD 4215
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=16652 or tblfeedback.strbusinessname='Southport R S L Memorial Club Inc' or tblfeedback.strbusinessname='Southport R S L Memorial Club Inc') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bethania Community Centre Inc
Beenleigh QLD 4207
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=2340 or tblfeedback.strbusinessname='Bethania Community Centre Inc' or tblfeedback.strbusinessname='Bethania Community Centre Inc') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Burleigh Waters Community Centre
Burleigh QLD 4220
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=2373 or tblfeedback.strbusinessname='Burleigh Waters Community Centre' or tblfeedback.strbusinessname='Burleigh Waters Community Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tall Ship
Main Beach QLD 4217
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=16655 or tblfeedback.strbusinessname='Tall Ship' or tblfeedback.strbusinessname='Tall Ship') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Waves Function Room
Tugun QLD 4224
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=16951 or tblfeedback.strbusinessname='Waves Function Room' or tblfeedback.strbusinessname='Waves Function Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Santuary Cove
Santuary Cove QLD 4212
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=2270 or tblfeedback.strbusinessname='Santuary Cove' or tblfeedback.strbusinessname='Santuary Cove') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Coolangatta Function Centre
Coolangatta QLD 4225
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=16707 or tblfeedback.strbusinessname='Coolangatta Function Centre' or tblfeedback.strbusinessname='Coolangatta Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Peppers Entertainment
Bundall QLD 4217
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=16132 or tblfeedback.strbusinessname='Peppers Entertainment' or tblfeedback.strbusinessname='Peppers Entertainment') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
View Your Favorites List
