Vibe Hotels Melbourne
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=19556 or tblfeedback.strbusinessname='Vibe Hotels Melbourne' or tblfeedback.strbusinessname='Vibe Hotels Melbourne') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Vibe Hotels offer fresh & vibrant venues for your reception & are perfectly located. We work with you to create your dream event from "will you marry me" to "I do". At Vibe, we want your wedding to be all about you, your family & friends. And lots of fun!
Inglewood Estate
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=19521 or tblfeedback.strbusinessname='Inglewood Estate' or tblfeedback.strbusinessname='Inglewood Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Set on 25 acres of private rolling country-side, Inglewood Chapel was hand built using local stone, with Antique Pews and Stained Glass Windows. Inglewood's Reception Cen
River's Edge
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=20196 or tblfeedback.strbusinessname='River'%%semi%%s Edge' or tblfeedback.strbusinessname='River's Edge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
River's Edge is Melb's riverside wedding venue. 180 degree views all year round, sun light from spring to early autumn, with sunset panorama along the Yarra during the lo
Wattle Park Chalet
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=20240 or tblfeedback.strbusinessname='Wattle Park Chalet' or tblfeedback.strbusinessname='Wattle Park Chalet') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Wattle Park Chalet (1928) is heritage-listed offering a range of facilities for weddings.
Encore St Kilda
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=20277 or tblfeedback.strbusinessname='Encore St Kilda' or tblfeedback.strbusinessname='Encore St Kilda') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Simple, effortless and natural venue.
Sandringham Yacht Club
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=26305 or tblfeedback.strbusinessname='Sandringham Yacht Club' or tblfeedback.strbusinessname='Sandringham Yacht Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
On the foreshores of Port Phillip Bay
Lyrebird Falls
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=1069 or tblfeedback.strbusinessname='Lyrebird Falls' or tblfeedback.strbusinessname='Lyrebird Falls') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A boutique Melbourne Ceremony and reception venue
Ballara Receptions
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=1009 or tblfeedback.strbusinessname='Ballara Receptions' or tblfeedback.strbusinessname='Ballara Receptions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Dickens Manor
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=1013 or tblfeedback.strbusinessname='Dickens Manor' or tblfeedback.strbusinessname='Dickens Manor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Vogue Ballroom
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=26089 or tblfeedback.strbusinessname='Vogue Ballroom' or tblfeedback.strbusinessname='Vogue Ballroom') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Werribee Mansion
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=24000 or tblfeedback.strbusinessname='Werribee Mansion' or tblfeedback.strbusinessname='Werribee Mansion') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Quat Quatta
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=1282 or tblfeedback.strbusinessname='Quat Quatta' or tblfeedback.strbusinessname='Quat Quatta') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Leonda by the Yarra
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=1045 or tblfeedback.strbusinessname='Leonda by the Yarra' or tblfeedback.strbusinessname='Leonda by the Yarra') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Park
Albert Park VIC 3206
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=26734 or tblfeedback.strbusinessname='The Park' or tblfeedback.strbusinessname='The Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Marnong Estate
Mickleham VIC 3064
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=41034 or tblfeedback.strbusinessname='Marnong Estate' or tblfeedback.strbusinessname='Marnong Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Epicurean Red Hill
Red Hill South VIC 3937
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=37890 or tblfeedback.strbusinessname='The Epicurean Red Hill' or tblfeedback.strbusinessname='The Epicurean Red Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Witchmount Estate Winery
Plumpton VIC 3335
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=14749 or tblfeedback.strbusinessname='Witchmount Estate Winery' or tblfeedback.strbusinessname='Witchmount Estate Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Nathania Springs Receptions
Monbulk VIC 3793
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=1123 or tblfeedback.strbusinessname='Nathania Springs Receptions' or tblfeedback.strbusinessname='Nathania Springs Receptions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Marybrooke Receptions
Sherbrooke VIC 3789
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=14520 or tblfeedback.strbusinessname='Marybrooke Receptions' or tblfeedback.strbusinessname='Marybrooke Receptions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Flowerdale Estate
Strath Creek VIC 3658
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=27939 or tblfeedback.strbusinessname='Flowerdale Estate' or tblfeedback.strbusinessname='Flowerdale Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Post Office Hotel
Coburg VIC 3058
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=29105 or tblfeedback.strbusinessname='Post Office Hotel' or tblfeedback.strbusinessname='Post Office Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The International of Brighton
Brighton VIC 3186
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=969 or tblfeedback.strbusinessname='The International of Brighton' or tblfeedback.strbusinessname='The International of Brighton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Yeramba Farm
Blampied VIC 3364
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=39855 or tblfeedback.strbusinessname='Yeramba Farm' or tblfeedback.strbusinessname='Yeramba Farm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Yarra Glen Racecourse
Yarra Glen VIC 3775
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=26175 or tblfeedback.strbusinessname='Yarra Glen Racecourse' or tblfeedback.strbusinessname='Yarra Glen Racecourse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mercetta
Mornington VIC 3931
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=25966 or tblfeedback.strbusinessname='Mercetta' or tblfeedback.strbusinessname='Mercetta') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Roomba's at Mt Aitken
Gisborne South VIC 3437
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=25574 or tblfeedback.strbusinessname='Roomba'%%semi%%s at Mt Aitken' or tblfeedback.strbusinessname='Roomba's at Mt Aitken') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Gum Gully Farm
Silvan VIC 3795
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=26172 or tblfeedback.strbusinessname='Gum Gully Farm' or tblfeedback.strbusinessname='Gum Gully Farm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Quat Quatta
Ripponlea VIC 3185
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=37895 or tblfeedback.strbusinessname='Quat Quatta' or tblfeedback.strbusinessname='Quat Quatta') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Reggio Calabria Club
Parkville VIC 3052
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=26325 or tblfeedback.strbusinessname='Reggio Calabria Club' or tblfeedback.strbusinessname='Reggio Calabria Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The 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=25050 or tblfeedback.strbusinessname='The Riverstone Estate' or tblfeedback.strbusinessname='The Riverstone Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Cammeray Waters
Woodend VIC 3442
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=25849 or tblfeedback.strbusinessname='Cammeray Waters' or tblfeedback.strbusinessname='Cammeray Waters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bellagio Receptions
Epping VIC 3076
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=29884 or tblfeedback.strbusinessname='Bellagio Receptions' or tblfeedback.strbusinessname='Bellagio Receptions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Meadowbank Receptions
Campbellfield VIC 3061
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=26958 or tblfeedback.strbusinessname='Meadowbank Receptions' or tblfeedback.strbusinessname='Meadowbank Receptions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Dingley International Reception Centre
Dingley VIC 3172
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=14378 or tblfeedback.strbusinessname='Dingley International Reception Centre' or tblfeedback.strbusinessname='Dingley International Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Mont De Lancey Historical Home & Museum
Wandin North VIC 3139
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=14544 or tblfeedback.strbusinessname='Mont De Lancey Historical Home &%%semi%% Museum' or tblfeedback.strbusinessname='Mont De Lancey Historical Home & Museum') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sketch
Docklands VIC 3008
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=26082 or tblfeedback.strbusinessname='Sketch' or tblfeedback.strbusinessname='Sketch') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Eagle Ridge Weddings
Boneo VIC 3939
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=27843 or tblfeedback.strbusinessname='Eagle Ridge Weddings' or tblfeedback.strbusinessname='Eagle Ridge Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Werribee Racing Club
Werribee VIC 3030
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=26949 or tblfeedback.strbusinessname='Werribee Racing Club' or tblfeedback.strbusinessname='Werribee Racing Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Oaks on Market
Melbourne VIC 3000
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=29705 or tblfeedback.strbusinessname='Oaks on Market' or tblfeedback.strbusinessname='Oaks on Market') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Abbotsford Convent
Abbotsford VIC 3067
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=37609 or tblfeedback.strbusinessname='Abbotsford Convent' or tblfeedback.strbusinessname='Abbotsford Convent') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bram Leigh Receptions
Croydon VIC 3136
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=14312 or tblfeedback.strbusinessname='Bram Leigh Receptions' or tblfeedback.strbusinessname='Bram Leigh Receptions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Eynsebury Homestead
Eynesbury VIC 3338
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=29537 or tblfeedback.strbusinessname='Eynsebury Homestead' or tblfeedback.strbusinessname='Eynsebury Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sheldon Reception & Convention Centre
Sunshine VIC 3020
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=14666 or tblfeedback.strbusinessname='Sheldon Reception &%%semi%% Convention Centre' or tblfeedback.strbusinessname='Sheldon Reception & Convention Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Lindenderry at Red Hill
Red Hill VIC 3937
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=29119 or tblfeedback.strbusinessname='Lindenderry at Red Hill' or tblfeedback.strbusinessname='Lindenderry at Red Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Chateau Wyuna
Mount Evelyn VIC 3796
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=1078 or tblfeedback.strbusinessname='Chateau Wyuna' or tblfeedback.strbusinessname='Chateau Wyuna') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Overnewton Castle
Keilor VIC 3036
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=1071 or tblfeedback.strbusinessname='Overnewton Castle' or tblfeedback.strbusinessname='Overnewton Castle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bulong Estate Winery
Yarra Junction VIC 3797
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=39882 or tblfeedback.strbusinessname='Bulong Estate Winery' or tblfeedback.strbusinessname='Bulong Estate Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Stones of the Yarra Valley
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=25388 or tblfeedback.strbusinessname='Stones of the Yarra Valley' or tblfeedback.strbusinessname='Stones of the Yarra Valley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
