Rating Salsa Bar and Grill
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
star ratingstar ratingstar ratingstar ratingstar rating
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.
Rating Sea Temple Resort & Spa Port Douglas
Sea Temple Resort & Spa Port Douglas
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' or tblfeedback.strbusinessname='Sea Temple Resort & Spa Port Douglas') 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.

Rating
Kingaroy Hotel
Kingaroy QLD 4610
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=26369 or tblfeedback.strbusinessname='Kingaroy Hotel' or tblfeedback.strbusinessname='Kingaroy Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Adora Downs
Mount Tyson QLD 4356
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=26211 or tblfeedback.strbusinessname='Adora Downs' or tblfeedback.strbusinessname='Adora Downs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Capricornian Restaurant
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dusty Hill Vineyard
Moffatdale QLD 4605
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=26739 or tblfeedback.strbusinessname='Dusty Hill Vineyard' or tblfeedback.strbusinessname='Dusty Hill Vineyard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mulga Country Motor Inn
Charleville QLD 4470
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=26663 or tblfeedback.strbusinessname='Mulga Country Motor Inn' or tblfeedback.strbusinessname='Mulga Country Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Preston Manor and Village Chapel
Toowoomba QLD 4352
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=27707 or tblfeedback.strbusinessname='Preston Manor and Village Chapel' or tblfeedback.strbusinessname='Preston Manor and Village Chapel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Port Douglas Weddings
Port Douglas QLD 4871
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=16872 or tblfeedback.strbusinessname='Port Douglas Weddings' or tblfeedback.strbusinessname='Port Douglas Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dalby RSL Memorial Club
Dalby QLD 4405
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=16718 or tblfeedback.strbusinessname='Dalby RSL Memorial Club' or tblfeedback.strbusinessname='Dalby RSL Memorial Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Emerald Maraboon Tavern & Motor Inn
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=16725 or tblfeedback.strbusinessname='Emerald Maraboon Tavern &%%semi%% Motor Inn' or tblfeedback.strbusinessname='Emerald Maraboon Tavern & Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roma Bowls Club
Roma QLD 4455
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=16891 or tblfeedback.strbusinessname='Roma Bowls Club' or tblfeedback.strbusinessname='Roma Bowls Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Radisson Resort
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=18716 or tblfeedback.strbusinessname='Radisson Resort' or tblfeedback.strbusinessname='Radisson Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tudor Rose Restaurant
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=16940 or tblfeedback.strbusinessname='Tudor Rose Restaurant' or tblfeedback.strbusinessname='Tudor Rose Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Whitehouse Reception Centre
Broken Hill NSW 2880
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=12038 or tblfeedback.strbusinessname='Whitehouse Reception Centre' or tblfeedback.strbusinessname='Whitehouse Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barton's Rose Farm
Kalbar QLD 4309
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=2336 or tblfeedback.strbusinessname='Barton'%%semi%%s Rose Farm' or tblfeedback.strbusinessname='Barton's Rose Farm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barkly Hotel Motel
Mt 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=2335 or tblfeedback.strbusinessname='Barkly Hotel Motel' or tblfeedback.strbusinessname='Barkly Hotel Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Time To Remember
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=16594 or tblfeedback.strbusinessname='A Time To Remember' or tblfeedback.strbusinessname='A Time To Remember') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Caddies Restaurant
Warwick QLD 4370
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=2377 or tblfeedback.strbusinessname='Caddies Restaurant' or tblfeedback.strbusinessname='Caddies Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Club Hotel-Motel
Roma QLD 4455
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=16702 or tblfeedback.strbusinessname='Club Hotel-Motel' or tblfeedback.strbusinessname='Club Hotel-Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ono's Restaurant
Blackwater QLD 4717
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=16845 or tblfeedback.strbusinessname='Ono'%%semi%%s Restaurant' or tblfeedback.strbusinessname='Ono's Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Court House Hotel
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=16712 or tblfeedback.strbusinessname='Court House Hotel' or tblfeedback.strbusinessname='Court House Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Paradise Country
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=16854 or tblfeedback.strbusinessname='Paradise Country' or tblfeedback.strbusinessname='Paradise Country') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fiorelli's Bistro
Port Douglas QLD 4871
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=16727 or tblfeedback.strbusinessname='Fiorelli'%%semi%%s Bistro' or tblfeedback.strbusinessname='Fiorelli's Bistro') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barkly Hotel Motel
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=16679 or tblfeedback.strbusinessname='Barkly Hotel Motel' or tblfeedback.strbusinessname='Barkly Hotel Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Criterion Hotel
Dalby QLD 4405
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=18643 or tblfeedback.strbusinessname='Criterion Hotel' or tblfeedback.strbusinessname='Criterion Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goondiwindi Bowls Club Inc
Goondiwindi QLD 4390
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=16758 or tblfeedback.strbusinessname='Goondiwindi Bowls Club Inc' or tblfeedback.strbusinessname='Goondiwindi Bowls Club Inc') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
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
Rating
Chung Hing Licensed Chinese Restaurant
Warwick QLD 4370
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=2406 or tblfeedback.strbusinessname='Chung Hing Licensed Chinese Restaurant' or tblfeedback.strbusinessname='Chung Hing Licensed Chinese Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jackie Howe Motel & Function Rooms
Warwick QLD 4370
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=16778 or tblfeedback.strbusinessname='Jackie Howe Motel &%%semi%% Function Rooms' or tblfeedback.strbusinessname='Jackie Howe Motel & Function Rooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abbey of the Roses
Warwick QLD 4370
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=2297 or tblfeedback.strbusinessname='Abbey of the Roses' or tblfeedback.strbusinessname='Abbey of the Roses') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chinchilla Great Western Motor Inn & Restaurant
Chinchilla QLD 4413
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=2404 or tblfeedback.strbusinessname='Chinchilla Great Western Motor Inn &%%semi%% Restaurant' or tblfeedback.strbusinessname='Chinchilla Great Western Motor Inn & Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
True Blue Home Hospitality
Lower Beechmont 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=16661 or tblfeedback.strbusinessname='True Blue Home Hospitality' or tblfeedback.strbusinessname='True Blue Home Hospitality') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aussie Tavern Alligator Creek
Alligator Creek QLD 4816
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=16675 or tblfeedback.strbusinessname='Aussie Tavern Alligator Creek' or tblfeedback.strbusinessname='Aussie Tavern Alligator Creek') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Palm Meadows Resort
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=16642 or tblfeedback.strbusinessname='Palm Meadows Resort' or tblfeedback.strbusinessname='Palm Meadows Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
'Lil Ol' Church Restaurant
Wooroolin QLD 4608
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=2288 or tblfeedback.strbusinessname=''%%semi%%Lil Ol'%%semi%% Church Restaurant' or tblfeedback.strbusinessname=''Lil Ol' Church Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Horse & Jockey Hotel/Motel
Warwick QLD 4370
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=16772 or tblfeedback.strbusinessname='Horse &%%semi%% Jockey Hotel/Motel' or tblfeedback.strbusinessname='Horse & Jockey Hotel/Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Town House Motor Inn The
Goondiwindi QLD 4390
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=16659 or tblfeedback.strbusinessname='Town House Motor Inn The' or tblfeedback.strbusinessname='Town House Motor Inn The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lorenzas of Stanthorpe
Stanthorpe QLD 4380
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=18692 or tblfeedback.strbusinessname='Lorenzas of Stanthorpe' or tblfeedback.strbusinessname='Lorenzas of Stanthorpe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
St George Sports Club
St George QLD 4487
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=16915 or tblfeedback.strbusinessname='St George Sports Club' or tblfeedback.strbusinessname='St George Sports Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Overlander Homestead Motel
Roma QLD 4455
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=16846 or tblfeedback.strbusinessname='Overlander Homestead Motel' or tblfeedback.strbusinessname='Overlander Homestead Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15