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
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
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
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
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
Daizies of Warragul
Warragul South VIC 3821
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=46525 or tblfeedback.strbusinessname='Daizies of Warragul' or tblfeedback.strbusinessname='Daizies of Warragul') 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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