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
Central Victorian Video Productions
Bendigo VIC 3550
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=1278 or tblfeedback.strbusinessname='Central Victorian Video Productions' or tblfeedback.strbusinessname='Central Victorian Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Bendigo Camera Centre
47 Mitchell Street Bendigo VIC 3550
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=13726 or tblfeedback.strbusinessname='Bendigo Camera Centre' or tblfeedback.strbusinessname='Bendigo Camera Centre') and year(getdate())-year(dtmadded)<=15
Rating
SGM Video Productions
Bendigo VIC 3550
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=14141 or tblfeedback.strbusinessname='SGM Video Productions' or tblfeedback.strbusinessname='SGM Video Productions') and year(getdate())-year(dtmadded)<=15