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
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
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
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