Rating
Enriched Productions
Melbourne VIC 3000
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=25573 or tblfeedback.strbusinessname='Enriched Productions' or tblfeedback.strbusinessname='Enriched Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Andersen Video Productions
Traralgon VIC 3844
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=13685 or tblfeedback.strbusinessname='Andersen Video Productions' or tblfeedback.strbusinessname='Andersen Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Anthony Reynolds
Warragul VIC 3820
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=13695 or tblfeedback.strbusinessname='Anthony Reynolds' or tblfeedback.strbusinessname='Anthony Reynolds') and year(getdate())-year(dtmadded)<=15
Rating
Gracol Videoing
Warragul VIC 3820
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=13903 or tblfeedback.strbusinessname='Gracol Videoing' or tblfeedback.strbusinessname='Gracol Videoing') and year(getdate())-year(dtmadded)<=15
Rating
Video Expressions
Yinnar VIC 3869
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=14209 or tblfeedback.strbusinessname='Video Expressions' or tblfeedback.strbusinessname='Video Expressions') and year(getdate())-year(dtmadded)<=15
Rating
Riviera Productions
Bairnsdale VIC 3875
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=14951 or tblfeedback.strbusinessname='Riviera Productions' or tblfeedback.strbusinessname='Riviera Productions') and year(getdate())-year(dtmadded)<=15
Rating
Video Celebrations
Sale VIC 3850
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=18193 or tblfeedback.strbusinessname='Video Celebrations' or tblfeedback.strbusinessname='Video Celebrations') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating