Rating Emot Wedding Photography and Videography
Emot Wedding Photography and Videography
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=43530 or tblfeedback.strbusinessname='Emot Wedding Photography and Videography' or tblfeedback.strbusinessname='Emot Wedding Photography and Videography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

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
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
The Lost and Wild
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=43070 or tblfeedback.strbusinessname='The Lost and Wild' or tblfeedback.strbusinessname='The Lost and Wild') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
I Do Cinema
Adelaide SA 5000
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=36346 or tblfeedback.strbusinessname='I Do Cinema' or tblfeedback.strbusinessname='I Do Cinema') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
I Do Cinema
Adelaide SA 5000
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=36346 or tblfeedback.strbusinessname='I Do Cinema' or tblfeedback.strbusinessname='I Do Cinema') 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
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
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
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
SMC Studios
Brisbane QLD 4000
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=30309 or tblfeedback.strbusinessname='SMC Studios' or tblfeedback.strbusinessname='SMC Studios') 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
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
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
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 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
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
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
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