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
Timbrel Films
Central Coast NSW 2083
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=38587 or tblfeedback.strbusinessname='Timbrel Films' or tblfeedback.strbusinessname='Timbrel Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bella Photo Art
Hamlyn Terrace 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=23620 or tblfeedback.strbusinessname='Bella Photo Art' or tblfeedback.strbusinessname='Bella Photo Art') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
JNCC Films
Central Coast NSW 2260
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=41332 or tblfeedback.strbusinessname='JNCC Films' or tblfeedback.strbusinessname='JNCC Films') 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
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
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
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
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
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
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
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