Rating
The Club Hotel
Sale VIC 3850
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=29221 or tblfeedback.strbusinessname='The Club Hotel' or tblfeedback.strbusinessname='The Club Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Traralgon Vineyard
Traralgon VIC 3844
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=29834 or tblfeedback.strbusinessname='Traralgon Vineyard' or tblfeedback.strbusinessname='Traralgon Vineyard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stellina
Traralgon VIC 3844
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=41405 or tblfeedback.strbusinessname='Stellina' or tblfeedback.strbusinessname='Stellina') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Massaros Estate
Kangaroo Ground VIC 3097
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=29421 or tblfeedback.strbusinessname='Massaros Estate' or tblfeedback.strbusinessname='Massaros Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Riverstone Estate
Coldstream VIC 3770
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=37597 or tblfeedback.strbusinessname='Riverstone Estate' or tblfeedback.strbusinessname='Riverstone Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Yallourn Golf Club
Yallourn Heights VIC 3825
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=41577 or tblfeedback.strbusinessname='Yallourn Golf Club' or tblfeedback.strbusinessname='Yallourn Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tatra Receptions
Mount Dandenong VIC 3767
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=24600 or tblfeedback.strbusinessname='Tatra Receptions' or tblfeedback.strbusinessname='Tatra Receptions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gapsted Winery Myrtleford
Myrtleford VIC 3737
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=25801 or tblfeedback.strbusinessname='Gapsted Winery Myrtleford' or tblfeedback.strbusinessname='Gapsted Winery Myrtleford') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Valley View Manor
Toongabbie VIC 3856
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=29949 or tblfeedback.strbusinessname='Valley View Manor' or tblfeedback.strbusinessname='Valley View Manor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tom's Cap Winery
Willung South VIC 3847
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=29018 or tblfeedback.strbusinessname='Tom'%%semi%%s Cap Winery' or tblfeedback.strbusinessname='Tom's Cap Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Parnassus Function Centre
Drouin East VIC 3818
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=43428 or tblfeedback.strbusinessname='Parnassus Function Centre' or tblfeedback.strbusinessname='Parnassus Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Toorongo River Chalets
Noojee VIC 3833
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=27153 or tblfeedback.strbusinessname='Toorongo River Chalets' or tblfeedback.strbusinessname='Toorongo River Chalets') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Boisdale Stables
Boisdale VIC 3860
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=27434 or tblfeedback.strbusinessname='Boisdale Stables' or tblfeedback.strbusinessname='Boisdale Stables') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Warragul Country Club
Warragul VIC 3820
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=26185 or tblfeedback.strbusinessname='Warragul Country Club' or tblfeedback.strbusinessname='Warragul Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Narkoojee Winery
Glengarry VIC 3854
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=46458 or tblfeedback.strbusinessname='Narkoojee Winery' or tblfeedback.strbusinessname='Narkoojee Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Premiere Function Centre The
Traralgon VIC 3844
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=14617 or tblfeedback.strbusinessname='Premiere Function Centre The' or tblfeedback.strbusinessname='Premiere Function Centre The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Italian Australian Sporting & Social Club of Gippsland
Morwell VIC 3840
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=14473 or tblfeedback.strbusinessname='Italian Australian Sporting &%%semi%% Social Club of Gippsland' or tblfeedback.strbusinessname='Italian Australian Sporting & Social Club of Gippsland') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coonawarra Farm Resort
Stratford VIC 3862
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=14360 or tblfeedback.strbusinessname='Coonawarra Farm Resort' or tblfeedback.strbusinessname='Coonawarra Farm Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Warragul Club
Warragul VIC 3820
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=14726 or tblfeedback.strbusinessname='Warragul Club' or tblfeedback.strbusinessname='Warragul Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bellevue Motor Inn
Lakes Entrance VIC 3909
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=14296 or tblfeedback.strbusinessname='Bellevue Motor Inn' or tblfeedback.strbusinessname='Bellevue Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Erinmore Gardens
Glengarry VIC 3854
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=14404 or tblfeedback.strbusinessname='Erinmore Gardens' or tblfeedback.strbusinessname='Erinmore Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Princeton Motor Lodge & Convention Centre
Sale VIC 3850
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=14619 or tblfeedback.strbusinessname='Princeton Motor Lodge &%%semi%% Convention Centre' or tblfeedback.strbusinessname='Princeton Motor Lodge & Convention Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elizabethan Reception Centre The
Warragul VIC 3820
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=14395 or tblfeedback.strbusinessname='Elizabethan Reception Centre The' or tblfeedback.strbusinessname='Elizabethan Reception Centre The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Logan Park
Warragul VIC 3820
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=14509 or tblfeedback.strbusinessname='Logan Park' or tblfeedback.strbusinessname='Logan Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Drouin Motor Inn
Drouin VIC 3818
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=14384 or tblfeedback.strbusinessname='Drouin Motor Inn' or tblfeedback.strbusinessname='Drouin Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Duart Reception Rooms
Maffra VIC 3860
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=14385 or tblfeedback.strbusinessname='Duart Reception Rooms' or tblfeedback.strbusinessname='Duart Reception Rooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gippsland Heritage Park
Moe VIC 3825
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=14430 or tblfeedback.strbusinessname='Gippsland Heritage Park' or tblfeedback.strbusinessname='Gippsland Heritage Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hacienda International Motor Inn
Sale VIC 3850
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=14446 or tblfeedback.strbusinessname='Hacienda International Motor Inn' or tblfeedback.strbusinessname='Hacienda International Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Colosseum The
Bairnsdale VIC 3875
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=14358 or tblfeedback.strbusinessname='Colosseum The' or tblfeedback.strbusinessname='Colosseum The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flamin Bull Bush Tucker Restaurant
Warragul VIC 3820
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=14418 or tblfeedback.strbusinessname='Flamin Bull Bush Tucker Restaurant' or tblfeedback.strbusinessname='Flamin Bull Bush Tucker Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wrenswood Garden Gallery & Restaurant
Erica VIC 3825
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=14753 or tblfeedback.strbusinessname='Wrenswood Garden Gallery &%%semi%% Restaurant' or tblfeedback.strbusinessname='Wrenswood Garden Gallery & Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
WY Yung Hotel
Wy Yung VIC 3875
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=14754 or tblfeedback.strbusinessname='WY Yung Hotel' or tblfeedback.strbusinessname='WY Yung Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cedar Lodge Motor Inn
Morwell VIC 3840
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=14336 or tblfeedback.strbusinessname='Cedar Lodge Motor Inn' or tblfeedback.strbusinessname='Cedar Lodge Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gumbuya Park
Tynong VIC 3813
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=14445 or tblfeedback.strbusinessname='Gumbuya Park' or tblfeedback.strbusinessname='Gumbuya Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Trenavin Park Country House - Chapel
Phillip Island VIC 3922
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=1143 or tblfeedback.strbusinessname='Trenavin Park Country House - Chapel' or tblfeedback.strbusinessname='Trenavin Park Country House - Chapel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Paynesville Motor Cruiser Club
Paynesville VIC 3880
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=14591 or tblfeedback.strbusinessname='Paynesville Motor Cruiser Club' or tblfeedback.strbusinessname='Paynesville Motor Cruiser Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Italian Australian
Morwell VIC 3840
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=1129 or tblfeedback.strbusinessname='Italian Australian' or tblfeedback.strbusinessname='Italian Australian') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Armadale The
Sale VIC 3850
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=14271 or tblfeedback.strbusinessname='Armadale The' or tblfeedback.strbusinessname='Armadale The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Powerscourt Country House
Maffra VIC 3860
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=14614 or tblfeedback.strbusinessname='Powerscourt Country House' or tblfeedback.strbusinessname='Powerscourt Country House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kernot Hall
Morwell VIC 3840
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=14484 or tblfeedback.strbusinessname='Kernot Hall' or tblfeedback.strbusinessname='Kernot Hall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Outpost Restaurant
Noojee VIC 3833
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=14582 or tblfeedback.strbusinessname='Outpost Restaurant' or tblfeedback.strbusinessname='Outpost Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Latrobe Motel & Convention Centre
Traralgon VIC 3844
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=14501 or tblfeedback.strbusinessname='Latrobe Motel &%%semi%% Convention Centre' or tblfeedback.strbusinessname='Latrobe Motel & Convention Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Melrossa Garden Wedding Centre
Traralgon VIC 3844
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=14532 or tblfeedback.strbusinessname='Melrossa Garden Wedding Centre' or tblfeedback.strbusinessname='Melrossa Garden Wedding Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Morwell R S L Sub Branch Inc
Morwell VIC 3840
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=14549 or tblfeedback.strbusinessname='Morwell R S L Sub Branch Inc' or tblfeedback.strbusinessname='Morwell R S L Sub Branch Inc') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sundowner Chain Motor Inn-Traralgon
Traralgon VIC 3844
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=14688 or tblfeedback.strbusinessname='Sundowner Chain Motor Inn-Traralgon' or tblfeedback.strbusinessname='Sundowner Chain Motor Inn-Traralgon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Morwell Tower Gardens
Morwell VIC 3840
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=14550 or tblfeedback.strbusinessname='Morwell Tower Gardens' or tblfeedback.strbusinessname='Morwell Tower Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15