Rating
SMC Studios
Brisbane QLD 4000
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=30309 or tblfeedback.strbusinessname='SMC Studios' or tblfeedback.strbusinessname='SMC Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Barn Owl Films
Braddon ACT 2612
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=29320 or tblfeedback.strbusinessname='Barn Owl Films' or tblfeedback.strbusinessname='Barn Owl Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Take of Two
Canberra ACT 2600
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=44002 or tblfeedback.strbusinessname='The Take of Two' or tblfeedback.strbusinessname='The Take of Two') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
WGM Wedding Videographers
Gundagai NSW 2722
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=24102 or tblfeedback.strbusinessname='WGM Wedding Videographers' or tblfeedback.strbusinessname='WGM Wedding Videographers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
I Do Cinema
Adelaide SA 5000
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=36346 or tblfeedback.strbusinessname='I Do Cinema' or tblfeedback.strbusinessname='I Do Cinema') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
I Do Cinema
Adelaide SA 5000
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=36346 or tblfeedback.strbusinessname='I Do Cinema' or tblfeedback.strbusinessname='I Do Cinema') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
SMC Studios
Brisbane QLD 4000
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=30309 or tblfeedback.strbusinessname='SMC Studios' or tblfeedback.strbusinessname='SMC Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Aurora Video Cinematography
Wagga Wagga NSW 2650
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=23571 or tblfeedback.strbusinessname='Aurora Video Cinematography' or tblfeedback.strbusinessname='Aurora Video Cinematography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Paper Lantern Pictures
O'Connor ACT 2602
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=19165 or tblfeedback.strbusinessname='Paper Lantern Pictures' or tblfeedback.strbusinessname='Paper Lantern Pictures') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Videoman Productions The
Palmerston ACT 2913
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=5658 or tblfeedback.strbusinessname='Videoman Productions The' or tblfeedback.strbusinessname='Videoman Productions The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kramar Productions
Goulburn NSW 2580
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=10104 or tblfeedback.strbusinessname='Kramar Productions' or tblfeedback.strbusinessname='Kramar Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Canberra Pro Video
Fyshwick ACT 2609
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=5657 or tblfeedback.strbusinessname='Canberra Pro Video' or tblfeedback.strbusinessname='Canberra Pro Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Action Video Productions
Red Hill ACT 2603
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=5656 or tblfeedback.strbusinessname='Action Video Productions' or tblfeedback.strbusinessname='Action Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Arie Photography & Video
Wanniassa ACT 2903
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=3996 or tblfeedback.strbusinessname='Arie Photography &%%semi%% Video' or tblfeedback.strbusinessname='Arie Photography & Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Schusters Video & Photography
Chapman ACT 2611
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=3989 or tblfeedback.strbusinessname='Schusters Video &%%semi%% Photography' or tblfeedback.strbusinessname='Schusters Video & Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15