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
Video Celebrations
C/- Post Office 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
Rating
Riviera Productions
PO Box 532 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
Andersen Video Productions
46 Swallow Grove 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
6 Palmerston Street 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
63 Biram Drive 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