Port of Call Restaurant & Function Centre
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=18286 or tblfeedback.strbusinessname='Port of Call Restaurant &%%semi%% Function Centre' or tblfeedback.strbusinessname='Port of Call Restaurant & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
With seating for up to 150 and room for 300 socialising any size or style of wedding can be arranged. Our wedding co-ordinator is excitedly waiting to assist you. From walking down the aisle at the ceremony to exiting the reception as husband and wife, all can be organised by Port of Call Restaurant and Function Centre.
Racine Restaurant
Nashdale NSW 2800
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=24455 or tblfeedback.strbusinessname='Racine Restaurant' or tblfeedback.strbusinessname='Racine Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Green House Eatery
Medowie NSW 2318
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=27936 or tblfeedback.strbusinessname='The Green House Eatery' or tblfeedback.strbusinessname='The Green House Eatery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mindaribba house
Mindaribba NSW 2320
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=25185 or tblfeedback.strbusinessname='Mindaribba house' or tblfeedback.strbusinessname='Mindaribba house') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Saltwater Restaurant
Fingal Bay NSW 2315
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=43020 or tblfeedback.strbusinessname='Saltwater Restaurant' or tblfeedback.strbusinessname='Saltwater Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Redhead Surf Lifesaving Club
Redhead NSW 2290
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=27287 or tblfeedback.strbusinessname='Redhead Surf Lifesaving Club' or tblfeedback.strbusinessname='Redhead Surf Lifesaving Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hunter Valley Gardens and Chapel
Pokolbin NSW 2320
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=18271 or tblfeedback.strbusinessname='Hunter Valley Gardens and Chapel' or tblfeedback.strbusinessname='Hunter Valley Gardens and Chapel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Weddings at mirannie
Mirannie NSW 2330
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=25994 or tblfeedback.strbusinessname='Weddings at mirannie' or tblfeedback.strbusinessname='Weddings at mirannie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Point Restaurant
Soldiers Point NSW 2317
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=26250 or tblfeedback.strbusinessname='The Point Restaurant' or tblfeedback.strbusinessname='The Point Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Greenfield Farm Estate
Martinsville NSW 2265
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=25632 or tblfeedback.strbusinessname='Greenfield Farm Estate' or tblfeedback.strbusinessname='Greenfield Farm Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Caves Beach Bar and Bungalows (NSW)
Caves Beach NSW 2281
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=29180 or tblfeedback.strbusinessname='Caves Beach Bar and Bungalows (NSW)' or tblfeedback.strbusinessname='Caves Beach Bar and Bungalows (NSW)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Raffertys Resort
Cams Wharf NSW 2281
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=30571 or tblfeedback.strbusinessname='Raffertys Resort' or tblfeedback.strbusinessname='Raffertys Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Little Beach Boathouse
Nelson Bay NSW 2315
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=35848 or tblfeedback.strbusinessname='Little Beach Boathouse' or tblfeedback.strbusinessname='Little Beach Boathouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Walka Water Works
Oakhampton Heights NSW 2320
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=29316 or tblfeedback.strbusinessname='Walka Water Works' or tblfeedback.strbusinessname='Walka Water Works') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Gibraltar Country Club
Bowral NSW 2576
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=26197 or tblfeedback.strbusinessname='Gibraltar Country Club' or tblfeedback.strbusinessname='Gibraltar Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Riverwood Downs
Monkerai NSW 2415
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=27886 or tblfeedback.strbusinessname='Riverwood Downs' or tblfeedback.strbusinessname='Riverwood Downs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Swansea RSL
Swansea NSW 2281
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=26853 or tblfeedback.strbusinessname='Swansea RSL' or tblfeedback.strbusinessname='Swansea RSL') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bidja Estate
Ourimbah NSW 2258
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=41250 or tblfeedback.strbusinessname='Bidja Estate' or tblfeedback.strbusinessname='Bidja Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Broughtons at the Bay
Nelson Bay NSW 2315
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=27034 or tblfeedback.strbusinessname='Broughtons at the Bay' or tblfeedback.strbusinessname='Broughtons at the Bay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Shoal Bay Country Club
Shoal Bay NSW 2315
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=39911 or tblfeedback.strbusinessname='Shoal Bay Country Club' or tblfeedback.strbusinessname='Shoal Bay Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Estate Tuscany
Hunter Valley NSW 2320
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=23119 or tblfeedback.strbusinessname='Estate Tuscany' or tblfeedback.strbusinessname='Estate Tuscany') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Stanley Park
Fullerton Cove NSW 2318
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=27789 or tblfeedback.strbusinessname='Stanley Park' or tblfeedback.strbusinessname='Stanley Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mystwood Retreats
Wollombi NSW 2325
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=24574 or tblfeedback.strbusinessname='Mystwood Retreats' or tblfeedback.strbusinessname='Mystwood Retreats') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Sebel Spa and Resort (Winsdor)
Windsor NSW 2756
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=21642 or tblfeedback.strbusinessname='The Sebel Spa and Resort (%%semi%%Winsdor)%%semi%%' or tblfeedback.strbusinessname='The Sebel Spa and Resort (Winsdor)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Peterson House
Pokolbin NSW 2320
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=25178 or tblfeedback.strbusinessname='Peterson House' or tblfeedback.strbusinessname='Peterson House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Club Macquarie Argenton
Argenton NSW 2284
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=25069 or tblfeedback.strbusinessname='Club Macquarie Argenton' or tblfeedback.strbusinessname='Club Macquarie Argenton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tocal Homestead
Paterson NSW 2421
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=24945 or tblfeedback.strbusinessname='Tocal Homestead' or tblfeedback.strbusinessname='Tocal Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Maitland City Bowling Club Ltd
Rutherford NSW 2320
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=10334 or tblfeedback.strbusinessname='Maitland City Bowling Club Ltd' or tblfeedback.strbusinessname='Maitland City Bowling Club Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Seahorse Inn Boydtown
Boydtown NSW 2551
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=44017 or tblfeedback.strbusinessname='Seahorse Inn Boydtown' or tblfeedback.strbusinessname='Seahorse Inn Boydtown') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Heaven Gardens Wedding and Events
Salt Ash NSW 2318
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=44273 or tblfeedback.strbusinessname='Heaven Gardens Wedding and Events' or tblfeedback.strbusinessname='Heaven Gardens Wedding and Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Peppers Creek Chapel & Barrel Room
Polkobin NSW 2320
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=46718 or tblfeedback.strbusinessname='Peppers Creek Chapel & Barrel Room' or tblfeedback.strbusinessname='Peppers Creek Chapel & Barrel Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Longworth House
Newcastle NSW 2300
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=25792 or tblfeedback.strbusinessname='Longworth House' or tblfeedback.strbusinessname='Longworth House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Chateau Elan at The Vintage
Rothbury, Hunter Valley NSW 2320
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=21392 or tblfeedback.strbusinessname='Chateau Elan at The Vintage' or tblfeedback.strbusinessname='Chateau Elan at The Vintage') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Cypress Lakes Golf & Country Club
Polkobin NSW 2320
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=27001 or tblfeedback.strbusinessname='Cypress Lakes Golf &%%semi%% Country Club' or tblfeedback.strbusinessname='Cypress Lakes Golf & Country Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Merewether Surfhouse
Merewether Beach NSW 2291
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=21900 or tblfeedback.strbusinessname='Merewether Surfhouse' or tblfeedback.strbusinessname='Merewether Surfhouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Greystone Estate
Pokolbin NSW 2320
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=43963 or tblfeedback.strbusinessname='Greystone Estate' or tblfeedback.strbusinessname='Greystone Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Customs House Hotel
Newcastle NSW 2300
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=8883 or tblfeedback.strbusinessname='Customs House Hotel' or tblfeedback.strbusinessname='Customs House Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Calvin Estate
Luskintyre NSW 2321
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=26303 or tblfeedback.strbusinessname='Calvin Estate' or tblfeedback.strbusinessname='Calvin Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Brown Sugar Resturant & Functions
Warners Bay NSW 2282
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=26536 or tblfeedback.strbusinessname='Brown Sugar Resturant &%%semi%% Functions' or tblfeedback.strbusinessname='Brown Sugar Resturant & Functions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Catherine Hill Bowling Club
Catherine Hill Bay NSW 2281
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=26097 or tblfeedback.strbusinessname='Catherine Hill Bowling Club' or tblfeedback.strbusinessname='Catherine Hill Bowling Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Goosewing Cottage
Mount View NSW 2325
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=43263 or tblfeedback.strbusinessname='Goosewing Cottage' or tblfeedback.strbusinessname='Goosewing Cottage') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Harrigans Irish Pub
Pokolbin NSW 2320
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=29217 or tblfeedback.strbusinessname='Harrigans Irish Pub' or tblfeedback.strbusinessname='Harrigans Irish Pub') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kirkton Park Hunter Valley
Pokolbin NSW 2320
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=26805 or tblfeedback.strbusinessname='Kirkton Park Hunter Valley' or tblfeedback.strbusinessname='Kirkton Park Hunter Valley') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Newcastle City Hall Function & Convention Centre
Newcastle NSW 2300
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=10668 or tblfeedback.strbusinessname='Newcastle City Hall Function &%%semi%% Convention Centre' or tblfeedback.strbusinessname='Newcastle City Hall Function & Convention Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Potters - Hotel. Brewery. Resort
Nulkaba NSW 2325
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=26725 or tblfeedback.strbusinessname='Potters - Hotel. Brewery. Resort' or tblfeedback.strbusinessname='Potters - Hotel. Brewery. Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
enzo
Pokolbin NSW 2320
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=42814 or tblfeedback.strbusinessname='enzo' or tblfeedback.strbusinessname='enzo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wallalong House
Wallalong NSW 2320
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=27462 or tblfeedback.strbusinessname='Wallalong House' or tblfeedback.strbusinessname='Wallalong House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Adams Peak Country Estate
Broke NSW 2330
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=29481 or tblfeedback.strbusinessname='Adams Peak Country Estate' or tblfeedback.strbusinessname='Adams Peak Country Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hunter Valley Resort
Pokolbin NSW 2320
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=9765 or tblfeedback.strbusinessname='Hunter Valley Resort' or tblfeedback.strbusinessname='Hunter Valley Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Peterson House
Pokolbin NSW 2320
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=27168 or tblfeedback.strbusinessname='Peterson House' or tblfeedback.strbusinessname='Peterson House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
View Your Favorites List
