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
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=27394 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
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
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
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