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
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
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
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
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
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
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