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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Mt 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='Mt Cotton Rainforest Gardens' or tblfeedback.strbusinessname='Mt Cotton Rainforest Gardens') 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Summer House 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=16918 or tblfeedback.strbusinessname='Summer House The' or tblfeedback.strbusinessname='Summer House The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Southport Yacht Club Inc
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=16911 or tblfeedback.strbusinessname='Southport Yacht Club Inc' or tblfeedback.strbusinessname='Southport Yacht Club Inc') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Emerald Lakes Golf Club
Carrara 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=16724 or tblfeedback.strbusinessname='Emerald Lakes Golf Club' or tblfeedback.strbusinessname='Emerald Lakes Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Gold Coast Turf Club
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=16755 or tblfeedback.strbusinessname='Gold Coast Turf Club' or tblfeedback.strbusinessname='Gold Coast Turf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bearded Dragon
Tamborine Village QLD 4270
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=2337 or tblfeedback.strbusinessname='Bearded Dragon' or tblfeedback.strbusinessname='Bearded Dragon') 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
Squire's Brasserie & Bar
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=16914 or tblfeedback.strbusinessname='Squire'%%semi%%s Brasserie &%%semi%% Bar' or tblfeedback.strbusinessname='Squire's Brasserie & Bar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Parkroyal
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=2264 or tblfeedback.strbusinessname='Parkroyal' or tblfeedback.strbusinessname='Parkroyal') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mt Panorama Public Golf Course
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=16824 or tblfeedback.strbusinessname='Mt Panorama Public Golf Course' or tblfeedback.strbusinessname='Mt Panorama Public Golf Course') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15