Rating
Visibility Video
Port Douglas QLD 4871
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=17154 or tblfeedback.strbusinessname='Visibility Video' or tblfeedback.strbusinessname='Visibility Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flashback Video Camera Hire
Carrara QLD 4211
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=17135 or tblfeedback.strbusinessname='Flashback Video Camera Hire' or tblfeedback.strbusinessname='Flashback Video Camera Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Riv Video Productions
Chinchilla QLD 4413
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=17146 or tblfeedback.strbusinessname='Riv Video Productions' or tblfeedback.strbusinessname='Riv Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Stark Video
Boonah QLD 4310
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=17149 or tblfeedback.strbusinessname='Stark Video' or tblfeedback.strbusinessname='Stark Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Oak Beach Productions
Oak Beach QLD 4871
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=17143 or tblfeedback.strbusinessname='Oak Beach Productions' or tblfeedback.strbusinessname='Oak Beach Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15