Rating
Zane Wilson
Port Macquarie NSW 2444
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=23316 or tblfeedback.strbusinessname='Zane Wilson' or tblfeedback.strbusinessname='Zane Wilson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Catseye Video Productions
Myocum NSW 2481
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=8564 or tblfeedback.strbusinessname='Catseye Video Productions' or tblfeedback.strbusinessname='Catseye Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Beam Video
Ulmarra NSW 2462
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=8121 or tblfeedback.strbusinessname='Beam Video' or tblfeedback.strbusinessname='Beam Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
David Fuller Video Productions
Coffs Harbour NSW 2450
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=8921 or tblfeedback.strbusinessname='David Fuller Video Productions' or tblfeedback.strbusinessname='David Fuller Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Watts on Video
Port Macquarie NSW 2444
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=18358 or tblfeedback.strbusinessname='Watts on Video' or tblfeedback.strbusinessname='Watts on Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coastline Video Productions
Banora Point NSW 2486
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=8741 or tblfeedback.strbusinessname='Coastline Video Productions' or tblfeedback.strbusinessname='Coastline Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Port Macquarie Video Productions
Port Macquarie NSW 2444
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=11028 or tblfeedback.strbusinessname='Port Macquarie Video Productions' or tblfeedback.strbusinessname='Port Macquarie Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15