Rating
Anthony Rogers Wedding Photos & Videos
Wynyard TAS 7325
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=25754 or tblfeedback.strbusinessname='Anthony Rogers Wedding Photos &%%semi%% Videos' or tblfeedback.strbusinessname='Anthony Rogers Wedding Photos & Videos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ashton Howe Videography
Latrobe TAS 7307
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=27733 or tblfeedback.strbusinessname='Ashton Howe Videography' or tblfeedback.strbusinessname='Ashton Howe Videography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Taz Drone Solutions
Sheffield TAS 7306
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=27682 or tblfeedback.strbusinessname='Taz Drone Solutions' or tblfeedback.strbusinessname='Taz Drone Solutions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coach House Video
Burnie TAS 7320
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=5395 or tblfeedback.strbusinessname='Coach House Video' or tblfeedback.strbusinessname='Coach House Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coach House Video
Burnie TAS 7320
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=3791 or tblfeedback.strbusinessname='Coach House Video' or tblfeedback.strbusinessname='Coach House Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Video View
Burnie TAS 7320
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=3840 or tblfeedback.strbusinessname='Video View' or tblfeedback.strbusinessname='Video View') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
John Young Video Productions
Devonport TAS 7310
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=3806 or tblfeedback.strbusinessname='John Young Video Productions' or tblfeedback.strbusinessname='John Young Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15