Rating
Carissa Morgan Videography
Mackay QLD 4740
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=25807 or tblfeedback.strbusinessname='Carissa Morgan Videography' or tblfeedback.strbusinessname='Carissa Morgan Videography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
David Pierson Films
Hervey Bay QLD 4655
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=26843 or tblfeedback.strbusinessname='David Pierson Films' or tblfeedback.strbusinessname='David Pierson Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wild Bunch Weddings
Noosa Heads QLD 4567
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=22501 or tblfeedback.strbusinessname='Wild Bunch Weddings' or tblfeedback.strbusinessname='Wild Bunch Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
JC Filmz
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=38478 or tblfeedback.strbusinessname='JC Filmz' or tblfeedback.strbusinessname='JC Filmz') AND tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Levi Appleton
Yeppoon QLD 4700
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=29789 or tblfeedback.strbusinessname='Levi Appleton' or tblfeedback.strbusinessname='Levi Appleton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
DejaVu Photo&Film
Rockhampton QLD 4700
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=22619 or tblfeedback.strbusinessname='DejaVu Photo&%%semi%%Film' or tblfeedback.strbusinessname='DejaVu Photo&Film') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flow Motion Media
Mackay QLD 4740
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=24743 or tblfeedback.strbusinessname='Flow Motion Media' or tblfeedback.strbusinessname='Flow Motion Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Myfilm
Maroochydore QLD 4655
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=21096 or tblfeedback.strbusinessname='Myfilm' or tblfeedback.strbusinessname='Myfilm') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Davies Video Productions
Hervey Bay QLD 4655
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=17132 or tblfeedback.strbusinessname='Davies Video Productions' or tblfeedback.strbusinessname='Davies Video Productions') 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
Davies Video Productions
Maryborough QLD 4650
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=17131 or tblfeedback.strbusinessname='Davies Video Productions' or tblfeedback.strbusinessname='Davies Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Specialised Video Presentations
Mackay QLD 4740
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=17148 or tblfeedback.strbusinessname='Specialised Video Presentations' or tblfeedback.strbusinessname='Specialised Video Presentations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
K & S Video Productions
Sarina QLD 4737
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=17139 or tblfeedback.strbusinessname='K &%%semi%% S Video Productions' or tblfeedback.strbusinessname='K & S Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Joe Sorbello
Andergrove QLD 4740
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=17138 or tblfeedback.strbusinessname='Joe Sorbello' or tblfeedback.strbusinessname='Joe Sorbello') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Burnett Video Productions
Bundaberg QLD 4670
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=17127 or tblfeedback.strbusinessname='Burnett Video Productions' or tblfeedback.strbusinessname='Burnett Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
IBIS Videoworks
Gladstone QLD 4680
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=17137 or tblfeedback.strbusinessname='IBIS Videoworks' or tblfeedback.strbusinessname='IBIS Videoworks') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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