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 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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Peppermint Lane Photo & Film
Chatham Terrace 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 year(getdate())-year(dtmadded)<=15
Rating
Chris Soan
24 Poinsettia Street 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 year(getdate())-year(dtmadded)<=15
Rating
Coral O'Connell
53 Ford Street 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 year(getdate())-year(dtmadded)<=15
Rating
Coral-Video
53 Ford Street 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 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 year(getdate())-year(dtmadded)<=15
Rating
Oak Beach Productions
16 Oak Beach Road<BR>Via Port Douglas 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 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 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 year(getdate())-year(dtmadded)<=15
Rating
Visibility Video
PO Box 839 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 year(getdate())-year(dtmadded)<=15
Rating
White Horse Productions
4 Laurel Court 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 year(getdate())-year(dtmadded)<=15