Rating
St Josephs Subiaco
Subiaco WA 6008
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=41779 or tblfeedback.strbusinessname='St Josephs Subiaco' or tblfeedback.strbusinessname='St Josephs Subiaco') 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
Quarry Farm WA
Whitby WA 6123
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=38154 or tblfeedback.strbusinessname='Quarry Farm WA' or tblfeedback.strbusinessname='Quarry Farm WA') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Solitaire Homestead
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=43759 or tblfeedback.strbusinessname='Solitaire Homestead' or tblfeedback.strbusinessname='Solitaire Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Barn Country Style Wedding Venue
Hopeland WA 6125
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=27679 or tblfeedback.strbusinessname='The Barn Country Style Wedding Venue' or tblfeedback.strbusinessname='The Barn Country Style Wedding Venue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Old tower house
Perth WA 6000
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=44814 or tblfeedback.strbusinessname='Old tower house' or tblfeedback.strbusinessname='Old tower house') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beaumaris Park
Ocean Reef WA 6027
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=29176 or tblfeedback.strbusinessname='Beaumaris Park' or tblfeedback.strbusinessname='Beaumaris Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Baldivis Farm Stay
Baldivis WA 6171
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=27780 or tblfeedback.strbusinessname='Baldivis Farm Stay' or tblfeedback.strbusinessname='Baldivis Farm Stay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mulberry Estate
Caversham WA 6055
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=22371 or tblfeedback.strbusinessname='Mulberry Estate' or tblfeedback.strbusinessname='Mulberry Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rosendals Tradgard
Sweden NSW 2000
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=41702 or tblfeedback.strbusinessname='Rosendals Tradgard' or tblfeedback.strbusinessname='Rosendals Tradgard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Maple & Rose House
North Perth WA 6000
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=27251 or tblfeedback.strbusinessname='Maple &%%semi%% Rose House' or tblfeedback.strbusinessname='Maple & Rose House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Canvas Cafe - Fremantle Arts Centre
Fremantle WA 6160
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=38302 or tblfeedback.strbusinessname='Canvas Cafe - Fremantle Arts Centre' or tblfeedback.strbusinessname='Canvas Cafe - Fremantle Arts Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
St Georges Cathedral
Perth WA 6000
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=36015 or tblfeedback.strbusinessname='St Georges Cathedral' or tblfeedback.strbusinessname='St Georges Cathedral') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Old Tower House Perth
Perth WA 6000
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=44615 or tblfeedback.strbusinessname='Old Tower House Perth' or tblfeedback.strbusinessname='Old Tower House Perth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Vines Resort
The Vines 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=41338 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
Kings Park and Botanic Gardens
West Perth WA 6005
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=17592 or tblfeedback.strbusinessname='Kings Park and Botanic Gardens' or tblfeedback.strbusinessname='Kings Park and Botanic Gardens') 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
Mandurah Off Shore Fishing and Sailing Club
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=41328 or tblfeedback.strbusinessname='Mandurah Off Shore Fishing and Sailing Club' or tblfeedback.strbusinessname='Mandurah Off Shore Fishing and Sailing Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Burswood on Swan
Burswood WA 6100
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=37599 or tblfeedback.strbusinessname='Burswood on Swan' or tblfeedback.strbusinessname='Burswood on Swan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Assured Ascot Quays
Ascot WA 6104
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=26672 or tblfeedback.strbusinessname='Assured Ascot Quays' or tblfeedback.strbusinessname='Assured Ascot Quays') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rendezvous Hotel (Scarborough)
Scarborough WA 6018
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=17965 or tblfeedback.strbusinessname='Rendezvous Hotel (%%semi%%Scarborough)%%semi%%' or tblfeedback.strbusinessname='Rendezvous Hotel (Scarborough)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Quarry Adventure Park
Meadow Springs 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=36250 or tblfeedback.strbusinessname='Quarry Adventure Park' or tblfeedback.strbusinessname='Quarry Adventure Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The University Club of Western Australia
Crawley WA 6009
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=25096 or tblfeedback.strbusinessname='The University Club of Western Australia' or tblfeedback.strbusinessname='The University Club of Western Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Caversham House
Caversham WA 6055
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=17394 or tblfeedback.strbusinessname='Caversham House' or tblfeedback.strbusinessname='Caversham House') 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
Christ the King Church
Beaconsfield WA 6162
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=17590 or tblfeedback.strbusinessname='Christ the King Church' or tblfeedback.strbusinessname='Christ the King Church') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wesley Uniting Church
Perth WA 6000
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=17598 or tblfeedback.strbusinessname='Wesley Uniting Church' or tblfeedback.strbusinessname='Wesley Uniting Church') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tawarri Reception Centre
Dalkeith WA 6009
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=4155 or tblfeedback.strbusinessname='Tawarri Reception Centre' or tblfeedback.strbusinessname='Tawarri Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Waterfront at Mindarie
Perth 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=17596 or tblfeedback.strbusinessname='The Waterfront at Mindarie' or tblfeedback.strbusinessname='The Waterfront at Mindarie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
St Brigid's Catholic Church
Perth WA 6103
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=17594 or tblfeedback.strbusinessname='St Brigid'%%semi%%s Catholic Church' or tblfeedback.strbusinessname='St Brigid's Catholic Church') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Marmion Angling and Aquatic Club
North Beach WA 6020
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=17593 or tblfeedback.strbusinessname='Marmion Angling and Aquatic Club' or tblfeedback.strbusinessname='Marmion Angling and Aquatic Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
St Marys Catholic Church
Leederville WA 6007
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=17595 or tblfeedback.strbusinessname='St Marys Catholic Church' or tblfeedback.strbusinessname='St Marys Catholic Church') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15