Rating
Bunker Bay Beach House Cafe
Naturaliste WA 6281
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=27846 or tblfeedback.strbusinessname='Bunker Bay Beach House Cafe' or tblfeedback.strbusinessname='Bunker Bay Beach House Cafe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Black Brewing Co
Wilyabrup WA 6280
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=29547 or tblfeedback.strbusinessname='Black Brewing Co' or tblfeedback.strbusinessname='Black Brewing Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Swings & Roundabouts Winery
Yallingup WA 6282
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=26435 or tblfeedback.strbusinessname='Swings &%%semi%% Roundabouts Winery' or tblfeedback.strbusinessname='Swings & Roundabouts Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mandurah Offshore Fishing and Sailing Club
Mandurah WA 6172
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=42825 or tblfeedback.strbusinessname='Mandurah Offshore Fishing and Sailing Club' or tblfeedback.strbusinessname='Mandurah Offshore Fishing and Sailing Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
South West Italian Club
Bunbury East WA 6230
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=26357 or tblfeedback.strbusinessname='South West Italian Club' or tblfeedback.strbusinessname='South West Italian Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Eight Willows Retreat
Metricup WA 6280
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=27620 or tblfeedback.strbusinessname='Eight Willows Retreat' or tblfeedback.strbusinessname='Eight Willows Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Saint Aidan Wines
Ferguson WA 6236
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=41140 or tblfeedback.strbusinessname='Saint Aidan Wines' or tblfeedback.strbusinessname='Saint Aidan Wines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coast Port Beach
North Fremantle WA 6159
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=45865 or tblfeedback.strbusinessname='Coast Port Beach' or tblfeedback.strbusinessname='Coast Port Beach') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wellington Forest Cottages
Wellington Mill WA 6236
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=26933 or tblfeedback.strbusinessname='Wellington Forest Cottages' or tblfeedback.strbusinessname='Wellington Forest Cottages') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Millbrook Winery
Jarrahdale WA 6124
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=26765 or tblfeedback.strbusinessname='Millbrook Winery' or tblfeedback.strbusinessname='Millbrook Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Abbey Beach Resort
Busselton WA 6280
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=4031 or tblfeedback.strbusinessname='Abbey Beach Resort' or tblfeedback.strbusinessname='Abbey Beach Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Nanga Bush Camp
Dwellingup WA 6153
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=25733 or tblfeedback.strbusinessname='Nanga Bush Camp' or tblfeedback.strbusinessname='Nanga Bush Camp') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Shed at Deep Creek Road
Albany WA 6330
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=25771 or tblfeedback.strbusinessname='The Shed at Deep Creek Road' or tblfeedback.strbusinessname='The Shed at Deep Creek Road') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wise Wine
Eagle Bay WA 6281
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=22054 or tblfeedback.strbusinessname='Wise Wine' or tblfeedback.strbusinessname='Wise Wine') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Silversprings
Metricup WA 6280
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=39973 or tblfeedback.strbusinessname='Silversprings' or tblfeedback.strbusinessname='Silversprings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Peel Manor House
Karnup NSW 6176
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=20885 or tblfeedback.strbusinessname='Peel Manor House' or tblfeedback.strbusinessname='Peel Manor House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
King Road Brewing Co
Oldbury WA 6121
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=46358 or tblfeedback.strbusinessname='King Road Brewing Co' or tblfeedback.strbusinessname='King Road Brewing Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Burlington Hotel
Bunbury WA 6230
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=29228 or tblfeedback.strbusinessname='Burlington Hotel' or tblfeedback.strbusinessname='Burlington Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Old Broadwater Farm
West Busselton WA 6280
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=27547 or tblfeedback.strbusinessname='Old Broadwater Farm' or tblfeedback.strbusinessname='Old Broadwater Farm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Credaro Wines Weddings
Yallingup WA 6282
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=44028 or tblfeedback.strbusinessname='Credaro Wines Weddings' or tblfeedback.strbusinessname='Credaro Wines Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Evedon Lakeside Retreat
Burekup WA 6227
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=29510 or tblfeedback.strbusinessname='Evedon Lakeside Retreat' or tblfeedback.strbusinessname='Evedon Lakeside Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Barefoot Beach Weddings
Gnarabup WA 6285
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=37632 or tblfeedback.strbusinessname='Barefoot Beach Weddings' or tblfeedback.strbusinessname='Barefoot Beach Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Camp Quaranup (Albany WA)
Albany WA 6330
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=29359 or tblfeedback.strbusinessname='Camp Quaranup (%%semi%%Albany WA)%%semi%%' or tblfeedback.strbusinessname='Camp Quaranup (Albany WA)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Alverstoke Barn
Brunswick WA 6224
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=35808 or tblfeedback.strbusinessname='Alverstoke Barn' or tblfeedback.strbusinessname='Alverstoke Barn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Caves Road Collective
Wilyabrup WA 6280
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=35767 or tblfeedback.strbusinessname='Caves Road Collective' or tblfeedback.strbusinessname='Caves Road Collective') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Quality Hotel Lighthouse
Bunbury WA 6230
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=24692 or tblfeedback.strbusinessname='Quality Hotel Lighthouse' or tblfeedback.strbusinessname='Quality Hotel Lighthouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Gilgara Retreat
Margaret River WA 6285
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=22080 or tblfeedback.strbusinessname='Gilgara Retreat' or tblfeedback.strbusinessname='Gilgara Retreat') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kalamunda Hotel And Reception Centre
Kalamunda WA 6076
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=4093 or tblfeedback.strbusinessname='Kalamunda Hotel And Reception Centre' or tblfeedback.strbusinessname='Kalamunda Hotel And Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dymesbury Lodge
Albany WA 6330
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=4069 or tblfeedback.strbusinessname='Dymesbury Lodge' or tblfeedback.strbusinessname='Dymesbury Lodge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ravenswood Sanctuary
Pinjarra WA 6208
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=4136 or tblfeedback.strbusinessname='Ravenswood Sanctuary' or tblfeedback.strbusinessname='Ravenswood Sanctuary') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Vasse Felix Winery & Restaurant
Cowaramup WA 6284
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=7429 or tblfeedback.strbusinessname='Vasse Felix Winery &%%semi%% Restaurant' or tblfeedback.strbusinessname='Vasse Felix Winery & Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Munja Gardens Function Centre
Karnup WA 6176
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=4117 or tblfeedback.strbusinessname='Munja Gardens Function Centre' or tblfeedback.strbusinessname='Munja Gardens Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Driftwood Estate Restaurant
Yallingup WA 6282
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=4068 or tblfeedback.strbusinessname='Driftwood Estate Restaurant' or tblfeedback.strbusinessname='Driftwood Estate Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fairbridge Village
Pinjarra WA 6208
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=4078 or tblfeedback.strbusinessname='Fairbridge Village' or tblfeedback.strbusinessname='Fairbridge Village') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Admiral Motor Inn
Bunbury WA 6230
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=4032 or tblfeedback.strbusinessname='Admiral Motor Inn' or tblfeedback.strbusinessname='Admiral Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Southwest Function Centre
Bunbury WA 6230
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=4150 or tblfeedback.strbusinessname='Southwest Function Centre' or tblfeedback.strbusinessname='Southwest Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chef Excel
Currambine WA 6028
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=4060 or tblfeedback.strbusinessname='Chef Excel' or tblfeedback.strbusinessname='Chef Excel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lucieville Function Centre
Bridgetown WA 6255
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=4104 or tblfeedback.strbusinessname='Lucieville Function Centre' or tblfeedback.strbusinessname='Lucieville Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jolly Frog Function Centre
Mandurah WA 6210
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=4092 or tblfeedback.strbusinessname='Jolly Frog Function Centre' or tblfeedback.strbusinessname='Jolly Frog Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Leonda Reception & Function Centre
Byford WA 6122
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=4102 or tblfeedback.strbusinessname='Leonda Reception &%%semi%% Function Centre' or tblfeedback.strbusinessname='Leonda Reception & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wright's Garden Cafe
Bunbury WA 6230
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=4174 or tblfeedback.strbusinessname='Wright'%%semi%%s Garden Cafe' or tblfeedback.strbusinessname='Wright's Garden Cafe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mindarie Marina Hotel
Mindarie WA 6030
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=4115 or tblfeedback.strbusinessname='Mindarie Marina Hotel' or tblfeedback.strbusinessname='Mindarie Marina Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Vines Resort
Perth WA 6069
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=17942 or tblfeedback.strbusinessname='The Vines Resort' or tblfeedback.strbusinessname='The Vines Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Elizabethan Village
Bedfordale WA 6112
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=4075 or tblfeedback.strbusinessname='Elizabethan Village' or tblfeedback.strbusinessname='Elizabethan Village') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Boronia Rooms
Walliston WA 6076
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=4049 or tblfeedback.strbusinessname='Boronia Rooms' or tblfeedback.strbusinessname='Boronia Rooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Buffet House
Mandurah WA 6210
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=7392 or tblfeedback.strbusinessname='Buffet House' or tblfeedback.strbusinessname='Buffet House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Lord Forrest Hotel
Bunbury WA 6230
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=4157 or tblfeedback.strbusinessname='The Lord Forrest Hotel' or tblfeedback.strbusinessname='The Lord Forrest Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barragup Botanical
Barragup WA 6210
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=7389 or tblfeedback.strbusinessname='Barragup Botanical' or tblfeedback.strbusinessname='Barragup Botanical') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pinewood Reception & Function Centre
Gooseberry Hill WA 6076
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=4133 or tblfeedback.strbusinessname='Pinewood Reception &%%semi%% Function Centre' or tblfeedback.strbusinessname='Pinewood Reception & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Edwards Waterfront Restaurant
Mandurah WA 6210
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=4072 or tblfeedback.strbusinessname='Edwards Waterfront Restaurant' or tblfeedback.strbusinessname='Edwards Waterfront Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 75 Sort search results alphabetically