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
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
Pride Productions
North Geelong VIC 3125
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=43982 or tblfeedback.strbusinessname='Pride Productions' or tblfeedback.strbusinessname='Pride Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Enriched Productions
Melbourne VIC 3000
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=25573 or tblfeedback.strbusinessname='Enriched Productions' or tblfeedback.strbusinessname='Enriched Productions') 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
Jacob Heston Weddings
Geelong VIC 3220
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=43367 or tblfeedback.strbusinessname='Jacob Heston Weddings' or tblfeedback.strbusinessname='Jacob Heston Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Love Soldier Weddings
Newtown VIC 3220
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=23688 or tblfeedback.strbusinessname='Love Soldier Weddings' or tblfeedback.strbusinessname='Love Soldier Weddings') 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
Video Station
Geelong West VIC 3218
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=14212 or tblfeedback.strbusinessname='Video Station' or tblfeedback.strbusinessname='Video Station') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ray Ferguson Video
Geelong VIC 3220
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=14109 or tblfeedback.strbusinessname='Ray Ferguson Video' or tblfeedback.strbusinessname='Ray Ferguson Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Doing Video Productions
St Albans Park VIC 3219
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=13828 or tblfeedback.strbusinessname='Doing Video Productions' or tblfeedback.strbusinessname='Doing Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Full Focus Video Productions
Barwon Heads VIC 3227
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=13879 or tblfeedback.strbusinessname='Full Focus Video Productions' or tblfeedback.strbusinessname='Full Focus Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
John Barton
Geelong VIC 3220
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=873 or tblfeedback.strbusinessname='John Barton' or tblfeedback.strbusinessname='John Barton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Accent Video Productions
Geelong VIC 3220
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=13665 or tblfeedback.strbusinessname='Accent Video Productions' or tblfeedback.strbusinessname='Accent Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15