Rating
Amelia Joy Productions
Sandy Bay TAS 7005
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=25395 or tblfeedback.strbusinessname='Amelia Joy Productions' or tblfeedback.strbusinessname='Amelia Joy Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hitman Productions
Hobart TAS 7000
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=37695 or tblfeedback.strbusinessname='Hitman Productions' or tblfeedback.strbusinessname='Hitman Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
D & B Productions
New Town TAS 7008
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=5396 or tblfeedback.strbusinessname='D &%%semi%% B Productions' or tblfeedback.strbusinessname='D & B Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Becker
Sandy Bay TAS 7006
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=5391 or tblfeedback.strbusinessname='A Becker' or tblfeedback.strbusinessname='A Becker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Max-Fx Video & Design
Moonah West TAS 7009
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=3812 or tblfeedback.strbusinessname='Max-Fx Video &%%semi%% Design' or tblfeedback.strbusinessname='Max-Fx Video & Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cameo Video Production
Lenah Valley TAS 7008
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=5394 or tblfeedback.strbusinessname='Cameo Video Production' or tblfeedback.strbusinessname='Cameo Video Production') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mr Video
Lenah Valley TAS 7008
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=5397 or tblfeedback.strbusinessname='Mr Video' or tblfeedback.strbusinessname='Mr Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blundell
Blackmans Bay TAS 7052
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=5393 or tblfeedback.strbusinessname='Blundell' or tblfeedback.strbusinessname='Blundell') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Action Video
Geilston Bay TAS 7015
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=5392 or tblfeedback.strbusinessname='Action Video' or tblfeedback.strbusinessname='Action Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
J.R. Video & Photographics
Huonville TAS 7109
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=3803 or tblfeedback.strbusinessname='J.R. Video &%%semi%% Photographics' or tblfeedback.strbusinessname='J.R. Video & Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A & R Video Productions
Lutana TAS 7009
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=5390 or tblfeedback.strbusinessname='A &%%semi%% R Video Productions' or tblfeedback.strbusinessname='A & R Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15