Rating Jon Hewson's Photography & Video
Jon Hewson's Photography & Video
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=20091 or tblfeedback.strbusinessname='Jon Hewson'%%semi%%s Photography &%%semi%% Video' or tblfeedback.strbusinessname='Jon Hewson's Photography & Video') and year(getdate())-year(dtmadded)<=15
Stunning, Beautiful, Relaxed Photography

Rating
Launch Film Productions
Unit 2/42 Dellamarta Rd Wangara WA 6065
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=21874 or tblfeedback.strbusinessname='Launch Film Productions' or tblfeedback.strbusinessname='Launch Film Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tonita Photography & Video
Clarkson WA 6030
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=23532 or tblfeedback.strbusinessname='Tonita Photography &%%semi%% Video' or tblfeedback.strbusinessname='Tonita Photography & Video') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brides Choice Videography
73 Kookaburra Drive Mandurah WA 6210
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=7598 or tblfeedback.strbusinessname='Brides Choice Videography' or tblfeedback.strbusinessname='Brides Choice Videography') and year(getdate())-year(dtmadded)<=15
Rating
LocalTV Productions
15 Andros Road Safety Bay WA 6169
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=7600 or tblfeedback.strbusinessname='LocalTV Productions' or tblfeedback.strbusinessname='LocalTV Productions') and year(getdate())-year(dtmadded)<=15
Rating
In Shot Productions
3 Mariano Ct Rockingham WA 6169
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=17952 or tblfeedback.strbusinessname='In Shot Productions' or tblfeedback.strbusinessname='In Shot Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kingway Video
33 Trigwell Road Boyanup WA 6237
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=4398 or tblfeedback.strbusinessname='Kingway Video' or tblfeedback.strbusinessname='Kingway Video') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Goldlight Video And Photography
PO Box 610 Inglewood WA 6032
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=4365 or tblfeedback.strbusinessname='Goldlight Video And Photography' or tblfeedback.strbusinessname='Goldlight Video And Photography') and year(getdate())-year(dtmadded)<=15