Rating
Switch Multimedia
Central Coast NSW 2250
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=26941 or tblfeedback.strbusinessname='Switch Multimedia' or tblfeedback.strbusinessname='Switch Multimedia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lighthouse Films
Newcastle NSW 2300
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=22290 or tblfeedback.strbusinessname='Lighthouse Films' or tblfeedback.strbusinessname='Lighthouse Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Into the Lens Films
Central Coast NSW 2250
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=27832 or tblfeedback.strbusinessname='Into the Lens Films' or tblfeedback.strbusinessname='Into the Lens Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A Video Reflection
Buff Point NSW 2262
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=7673 or tblfeedback.strbusinessname='A Video Reflection' or tblfeedback.strbusinessname='A Video Reflection') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Williams Productions Video
Wyong NSW 2259
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=2491 or tblfeedback.strbusinessname='Williams Productions Video' or tblfeedback.strbusinessname='Williams Productions Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Digital Video Man Productions
Avoca Beach NSW 2251
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=9024 or tblfeedback.strbusinessname='Digital Video Man Productions' or tblfeedback.strbusinessname='Digital Video Man Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Eternal Memories
Horsfield Bay NSW 2256
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=9192 or tblfeedback.strbusinessname='Eternal Memories' or tblfeedback.strbusinessname='Eternal Memories') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
In-Depth Video Productions
Umina NSW 2257
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=9811 or tblfeedback.strbusinessname='In-Depth Video Productions' or tblfeedback.strbusinessname='In-Depth Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
JP Video Reflections
Buff Point NSW 2262
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=9974 or tblfeedback.strbusinessname='JP Video Reflections' or tblfeedback.strbusinessname='JP Video Reflections') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Michael Granero Video Productions
Lake Munmorah NSW 2259
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=10480 or tblfeedback.strbusinessname='Michael Granero Video Productions' or tblfeedback.strbusinessname='Michael Granero Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15