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.
Harrigans Irish Drift Inn
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=20215 or tblfeedback.strbusinessname='Harrigans Irish Drift Inn' or tblfeedback.strbusinessname='Harrigans Irish Drift Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Stunning marquee wedding packages with breathtaking bay & marina views.
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
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
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
Boomerang Farm Golf Course The
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=16685 or tblfeedback.strbusinessname='Boomerang Farm Golf Course The' or tblfeedback.strbusinessname='Boomerang Farm Golf Course The') 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=29646 or tblfeedback.strbusinessname='Intercontinental Sanctuary Cove' or tblfeedback.strbusinessname='Intercontinental Sanctuary Cove') 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
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
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
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
O'Reilly's Rainforest Retreat
Canungra 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=36007 or tblfeedback.strbusinessname='O'%%semi%%Reilly'%%semi%%s Rainforest Retreat' or tblfeedback.strbusinessname='O'Reilly's Rainforest Retreat') 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
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
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
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
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
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
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
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
Sheraton Grand Mirage
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 Mirage' or tblfeedback.strbusinessname='Sheraton Grand Mirage') 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'%%semi%%Reilly'%%semi%%s Rainforest Retreat' or tblfeedback.strbusinessname='O'Reilly's Rainforest Retreat') 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
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
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
Intercontinental Resort 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=26285 or tblfeedback.strbusinessname='Intercontinental Resort Sanctuary Cove' or tblfeedback.strbusinessname='Intercontinental Resort Sanctuary Cove') 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
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
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
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
Braeside Wedding 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=2348 or tblfeedback.strbusinessname='Braeside Wedding Chapel' or tblfeedback.strbusinessname='Braeside Wedding Chapel') 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
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
Harrigan's Irish Pub
Jacob's Well QLD 4208
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=29633 or tblfeedback.strbusinessname='Harrigan'%%semi%%s Irish Pub' or tblfeedback.strbusinessname='Harrigan's Irish Pub') 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
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
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
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
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
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
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
Springbrook Mountain Manor Resort
Springbrook 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=16913 or tblfeedback.strbusinessname='Springbrook Mountain Manor Resort' or tblfeedback.strbusinessname='Springbrook Mountain Manor Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Village Brasserie The
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=16949 or tblfeedback.strbusinessname='Village Brasserie The' or tblfeedback.strbusinessname='Village Brasserie The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Surfers Paradise Bowls Club
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=16926 or tblfeedback.strbusinessname='Surfers Paradise Bowls Club' or tblfeedback.strbusinessname='Surfers Paradise Bowls Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Island Queen Showboat Cruises
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=16777 or tblfeedback.strbusinessname='Island Queen Showboat Cruises' or tblfeedback.strbusinessname='Island Queen Showboat Cruises') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Boomerang Farm Golf Course The
Budgeeraba 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=2345 or tblfeedback.strbusinessname='Boomerang Farm Golf Course The' or tblfeedback.strbusinessname='Boomerang Farm Golf Course The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bumbles Café
Budds 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=18628 or tblfeedback.strbusinessname='Bumbles Café%%semi%%' or tblfeedback.strbusinessname='Bumbles Café') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Cafe Santuary
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=2379 or tblfeedback.strbusinessname='Cafe Santuary' or tblfeedback.strbusinessname='Cafe Santuary') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Arundel Hills Country Club
Arundel 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=2317 or tblfeedback.strbusinessname='Arundel Hills Country Club' or tblfeedback.strbusinessname='Arundel Hills Country Club') 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
