Rating
Manilla Services Club
Manilla NSW 2346
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=27853 or tblfeedback.strbusinessname='Manilla Services Club' or tblfeedback.strbusinessname='Manilla Services Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wests Tamworth
Tamworth West NSW 2340
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=37567 or tblfeedback.strbusinessname='Wests Tamworth' or tblfeedback.strbusinessname='Wests Tamworth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tangaratta Vineyards & Function Centre
Tamworth NSW 2340
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=41690 or tblfeedback.strbusinessname='Tangaratta Vineyards &%%semi%% Function Centre' or tblfeedback.strbusinessname='Tangaratta Vineyards & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Pavillion Function Centre and Gardens Tamworth
Nemingha NSW 2340
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=38458 or tblfeedback.strbusinessname='The Pavillion Function Centre and Gardens Tamworth' or tblfeedback.strbusinessname='The Pavillion Function Centre and Gardens Tamworth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Best Western Sanctuary Inn
Tamworth NSW 2340
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=26974 or tblfeedback.strbusinessname='Best Western Sanctuary Inn' or tblfeedback.strbusinessname='Best Western Sanctuary Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pavillion Function Centre
Nemingha NSW 2340
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=39891 or tblfeedback.strbusinessname='Pavillion Function Centre' or tblfeedback.strbusinessname='Pavillion Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Petersons Guesthouse and Winery
Armidale NSW 2350
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=36258 or tblfeedback.strbusinessname='Petersons Guesthouse and Winery' or tblfeedback.strbusinessname='Petersons Guesthouse and Winery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coonamble Bowling Club
Coonamble NSW 2829
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=27553 or tblfeedback.strbusinessname='Coonamble Bowling Club' or tblfeedback.strbusinessname='Coonamble Bowling Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Danica Park
Nemingha NSW 2340
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=8899 or tblfeedback.strbusinessname='Danica Park' or tblfeedback.strbusinessname='Danica Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
West Tamworth League Club
Tamworth West NSW 2340
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=12007 or tblfeedback.strbusinessname='West Tamworth League Club' or tblfeedback.strbusinessname='West Tamworth League Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
City Tavern The
Tamworth NSW 2340
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=8678 or tblfeedback.strbusinessname='City Tavern The' or tblfeedback.strbusinessname='City Tavern The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Function Centre AT the Cattlemans The
Tamworth NSW 2340
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=9381 or tblfeedback.strbusinessname='Function Centre AT the Cattlemans The' or tblfeedback.strbusinessname='Function Centre AT the Cattlemans The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kootingal Country Inn
Kootingal NSW 2352
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=10100 or tblfeedback.strbusinessname='Kootingal Country Inn' or tblfeedback.strbusinessname='Kootingal Country Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tamworth RSL Club
Tamworth NSW 2340
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=11676 or tblfeedback.strbusinessname='Tamworth RSL Club' or tblfeedback.strbusinessname='Tamworth RSL Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Powerhouse Boutique Hotels
Tamworth NSW 2340
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=11040 or tblfeedback.strbusinessname='Powerhouse Boutique Hotels' or tblfeedback.strbusinessname='Powerhouse Boutique Hotels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Country Comfort Tamworth
Tamworth NSW 2340
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=8813 or tblfeedback.strbusinessname='Country Comfort Tamworth' or tblfeedback.strbusinessname='Country Comfort Tamworth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
St Edwards Parish Hall
Tamworth NSW 2340
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=11516 or tblfeedback.strbusinessname='St Edwards Parish Hall' or tblfeedback.strbusinessname='St Edwards Parish Hall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Heritage Gardens Pavilion
Nemingha NSW 2340
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=9678 or tblfeedback.strbusinessname='Heritage Gardens Pavilion' or tblfeedback.strbusinessname='Heritage Gardens Pavilion') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15