Vibe Hotels
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' or tblfeedback.strbusinessname='Vibe Hotels') 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!
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 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 year(getdate())-year(dtmadded)<=15
The Wattle Park Chalet (1928) is heritage-listed offering a range of facilities for weddings.
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 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
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 year(getdate())-year(dtmadded)<=15
Located in the poets corner of Elwood, a premiere venue.
Park Hyatt Melbourne
1 Parliament Pl East Melbourne VIC 3002
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=1121 or tblfeedback.strbusinessname='Park Hyatt Melbourne' or tblfeedback.strbusinessname='Park Hyatt Melbourne') and year(getdate())-year(dtmadded)<=15
Chateau Wyuna
170 Swansea Rd
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 year(getdate())-year(dtmadded)<=15
Montsalvat
7 Hillcrest Avenue Eltham VIC 3095
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=1012 or tblfeedback.strbusinessname='Montsalvat' or tblfeedback.strbusinessname='Montsalvat') and year(getdate())-year(dtmadded)<=15
Leonda by the Yarra
2 Wallen Road Hawthorn VIC 3122
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 year(getdate())-year(dtmadded)<=15
Overnewton Castle
51 Overnewton Rd 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 year(getdate())-year(dtmadded)<=15
All Smiles Waterfront Venue
55 New Quay Promenade 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=25655 or tblfeedback.strbusinessname='All Smiles Waterfront Venue' or tblfeedback.strbusinessname='All Smiles Waterfront Venue') and year(getdate())-year(dtmadded)<=15
Cammeray Waters
140 Taylor Rd 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 year(getdate())-year(dtmadded)<=15
Ballara Receptions
1435 Main Road Eltham VIC 3095
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 year(getdate())-year(dtmadded)<=15
Brighton Savoy
150 The Esplanade 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=966 or tblfeedback.strbusinessname='Brighton Savoy' or tblfeedback.strbusinessname='Brighton Savoy') and year(getdate())-year(dtmadded)<=15
Ascot House Receptions
50 Fenton Street Ascot Vale VIC 3032
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=878 or tblfeedback.strbusinessname='Ascot House Receptions' or tblfeedback.strbusinessname='Ascot House Receptions') and year(getdate())-year(dtmadded)<=15
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 year(getdate())-year(dtmadded)<=15
Simple, effortless and natural venue.
Mercetta
115 Main Street, Mornington
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 year(getdate())-year(dtmadded)<=15
Settlers Run Golf and Country Club
1 Settlers Run Botanic Ridge VIC 3977
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=24889 or tblfeedback.strbusinessname='Settlers Run Golf and Country Club' or tblfeedback.strbusinessname='Settlers Run Golf and Country Club') and year(getdate())-year(dtmadded)<=15
The Vibe Savoy
630 Little Collins St 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=24958 or tblfeedback.strbusinessname='The Vibe Savoy' or tblfeedback.strbusinessname='The Vibe Savoy') and year(getdate())-year(dtmadded)<=15
The Budgie Smuggler
1/166 Maroondah Hwy Ringwood VIC 3134
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=25144 or tblfeedback.strbusinessname='The Budgie Smuggler' or tblfeedback.strbusinessname='The Budgie Smuggler') and year(getdate())-year(dtmadded)<=15
The International of Brighton
81 Bay Street 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 year(getdate())-year(dtmadded)<=15
LA Mirage Reception & Convention Centre
210 Hume Highway Somerton VIC 3062
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=14495 or tblfeedback.strbusinessname='LA Mirage Reception &%%semi%% Convention Centre' or tblfeedback.strbusinessname='LA Mirage Reception & Convention Centre') and year(getdate())-year(dtmadded)<=15
Lakeside Banquet & Convention Centre
65 Melton Hwy Taylors Lakes VIC 3038
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=14499 or tblfeedback.strbusinessname='Lakeside Banquet &%%semi%% Convention Centre' or tblfeedback.strbusinessname='Lakeside Banquet & Convention Centre') and year(getdate())-year(dtmadded)<=15
Marybrooke Receptions
10 Sherbrooke Road 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 year(getdate())-year(dtmadded)<=15
Sheldon Reception & Convention Centre
608/614 Somerville Road 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 year(getdate())-year(dtmadded)<=15
Lakeside
65 Melton Highway Taylors Lakes VIC 3038
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=14697 or tblfeedback.strbusinessname='Lakeside' or tblfeedback.strbusinessname='Lakeside') and year(getdate())-year(dtmadded)<=15
Reggio Calabria Club
476 Brunswick Rd 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 year(getdate())-year(dtmadded)<=15
The Substation
1 Market St Newport VIC 3015
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=26566 or tblfeedback.strbusinessname='The Substation' or tblfeedback.strbusinessname='The Substation') and year(getdate())-year(dtmadded)<=15
Roomba's at Mt Aitken
33 Cadana Rd 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 year(getdate())-year(dtmadded)<=15
Witchmount Estate Winery
557 Leakes Road 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 year(getdate())-year(dtmadded)<=15
All Smiles Sorrento
250 Ocean Beach Rd Sorrento VIC 3943
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=27609 or tblfeedback.strbusinessname='All Smiles Sorrento' or tblfeedback.strbusinessname='All Smiles Sorrento') and year(getdate())-year(dtmadded)<=15
Flowerdale Estate
2285 Broadford-Flowerdale Rd 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 year(getdate())-year(dtmadded)<=15
Bridges Restaurant
1075 Heidelberg - Kinglake Road Hurstbridge VIC 3099
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=24987 or tblfeedback.strbusinessname='Bridges Restaurant' or tblfeedback.strbusinessname='Bridges Restaurant') and year(getdate())-year(dtmadded)<=15
The Riverstone Estate
105 Skye Rd 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 year(getdate())-year(dtmadded)<=15
Stones of the Yarra Valley
14 St Huberts Rd 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 year(getdate())-year(dtmadded)<=15
Werribee Mansion
Gate 2, K Road 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=24000 or tblfeedback.strbusinessname='Werribee Mansion' or tblfeedback.strbusinessname='Werribee Mansion') and year(getdate())-year(dtmadded)<=15
Bram Leigh Receptions
383 Mount Dandenong Road 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 year(getdate())-year(dtmadded)<=15
Elizabethan Lodge
604-610 Middleborough Road Blackburn North VIC 3130
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=14394 or tblfeedback.strbusinessname='Elizabethan Lodge' or tblfeedback.strbusinessname='Elizabethan Lodge') and year(getdate())-year(dtmadded)<=15
Mont De Lancey Historical Home & Museum
75 Wellington Road 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 year(getdate())-year(dtmadded)<=15
Sandringham Yacht Club
Jetty Rd Sandringham VIC 3191
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=26486 or tblfeedback.strbusinessname='Sandringham Yacht Club' or tblfeedback.strbusinessname='Sandringham Yacht Club') and year(getdate())-year(dtmadded)<=15
Werribee Racing Club
Bulban Rd 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 year(getdate())-year(dtmadded)<=15
Meadowbank Receptions
1 Eldon St 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 year(getdate())-year(dtmadded)<=15
SkyHigh Mt Dandenong
26 Observatory Rd 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=26696 or tblfeedback.strbusinessname='SkyHigh Mt Dandenong' or tblfeedback.strbusinessname='SkyHigh Mt Dandenong') and year(getdate())-year(dtmadded)<=15
The Park
36 Lakeside Drive 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 year(getdate())-year(dtmadded)<=15
Eagle Ridge Weddings
215 Browns Rd 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 year(getdate())-year(dtmadded)<=15
Showtime Events Centre
61 S Wharf Promenade South Wharf VIC 3006
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=26767 or tblfeedback.strbusinessname='Showtime Events Centre' or tblfeedback.strbusinessname='Showtime Events Centre') and year(getdate())-year(dtmadded)<=15
Manor On High
519 High St 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=27526 or tblfeedback.strbusinessname='Manor On High' or tblfeedback.strbusinessname='Manor On High') and year(getdate())-year(dtmadded)<=15
Crown Palladium
Level 1 Crown Towers Southbank VIC 3006
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=26988 or tblfeedback.strbusinessname='Crown Palladium' or tblfeedback.strbusinessname='Crown Palladium') and year(getdate())-year(dtmadded)<=15
Immerse Yarra Valley
1548 Melba Hwy Dixon's Creek 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=27742 or tblfeedback.strbusinessname='Immerse Yarra Valley' or tblfeedback.strbusinessname='Immerse Yarra Valley') and year(getdate())-year(dtmadded)<=15
Gisborne Golf Club
25 Daly St Gisborne 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=27796 or tblfeedback.strbusinessname='Gisborne Golf Club' or tblfeedback.strbusinessname='Gisborne Golf Club') and year(getdate())-year(dtmadded)<=15
