Rating
Th3rd Dimension Media
Airlie Beach QLD 4802
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=27102 or tblfeedback.strbusinessname='Th3rd Dimension Media' or tblfeedback.strbusinessname='Th3rd Dimension Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hello Blue productions
Townsville QLD 4810
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=26705 or tblfeedback.strbusinessname='Hello Blue productions' or tblfeedback.strbusinessname='Hello Blue productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Eternal Films
Townsville QLD 4810
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=27134 or tblfeedback.strbusinessname='Eternal Films' or tblfeedback.strbusinessname='Eternal Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Threadless Films
Cairns QLD 4870
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=23983 or tblfeedback.strbusinessname='Threadless Films' or tblfeedback.strbusinessname='Threadless Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hudson Films
Cairns QLD 4870
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=36203 or tblfeedback.strbusinessname='Hudson Films' or tblfeedback.strbusinessname='Hudson Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Videoticz Photography Fiji
Fiji 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=26336 or tblfeedback.strbusinessname='Videoticz Photography Fiji' or tblfeedback.strbusinessname='Videoticz Photography Fiji') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Luminosity Studios
Cairns QLD 4870
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=27365 or tblfeedback.strbusinessname='Luminosity Studios' or tblfeedback.strbusinessname='Luminosity Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hudson Films
Cairns QLD 4870
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=22700 or tblfeedback.strbusinessname='Hudson Films' or tblfeedback.strbusinessname='Hudson Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Peppermint Lane Photo & Film
Smithfield QLD 4878
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=29242 or tblfeedback.strbusinessname='Peppermint Lane Photo &%%semi%% Film' or tblfeedback.strbusinessname='Peppermint Lane Photo & Film') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
TJ Creative
Cairns QLD 4879
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=36246 or tblfeedback.strbusinessname='TJ Creative' or tblfeedback.strbusinessname='TJ Creative') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
White Horse Productions
Kelso QLD 4815
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=17156 or tblfeedback.strbusinessname='White Horse Productions' or tblfeedback.strbusinessname='White Horse Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Play It Again Media
Townsville QLD 4810
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=17145 or tblfeedback.strbusinessname='Play It Again Media' or tblfeedback.strbusinessname='Play It Again Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coral O'Connell
Hermit Park QLD 4812
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=17129 or tblfeedback.strbusinessname='Coral O'%%semi%%Connell' or tblfeedback.strbusinessname='Coral O'Connell') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pacific Image Video Productions
Westcourt QLD 4870
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=17144 or tblfeedback.strbusinessname='Pacific Image Video Productions' or tblfeedback.strbusinessname='Pacific Image Video Productions') 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
Rating
Coral-Video
Hermit Park QLD 4812
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=17130 or tblfeedback.strbusinessname='Coral-Video' or tblfeedback.strbusinessname='Coral-Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chris Soan
Holloways Beach QLD 4878
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=17128 or tblfeedback.strbusinessname='Chris Soan' or tblfeedback.strbusinessname='Chris Soan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Memories by Marion Wedding Videos
Townsville QLD 4810
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=17142 or tblfeedback.strbusinessname='Memories by Marion Wedding Videos' or tblfeedback.strbusinessname='Memories by Marion Wedding Videos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alan Nielsen
Cairns QLD 4870
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=17119 or tblfeedback.strbusinessname='Alan Nielsen' or tblfeedback.strbusinessname='Alan Nielsen') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15