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
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
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
Aurora Video Cinematography
Wagga Wagga NSW 2650
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=23571 or tblfeedback.strbusinessname='Aurora Video Cinematography' or tblfeedback.strbusinessname='Aurora Video Cinematography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Orchard Media
Albury NSW 2640
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=41563 or tblfeedback.strbusinessname='Orchard Media' or tblfeedback.strbusinessname='Orchard Media') 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
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
Jim Trewarn Video
Wodonga VIC 3690
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=14946 or tblfeedback.strbusinessname='Jim Trewarn Video' or tblfeedback.strbusinessname='Jim Trewarn Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
MJ Video Service
Wodonga VIC 3690
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=14948 or tblfeedback.strbusinessname='MJ Video Service' or tblfeedback.strbusinessname='MJ Video Service') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Memories In Motion
Lavington NSW 2641
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=10457 or tblfeedback.strbusinessname='Memories In Motion' or tblfeedback.strbusinessname='Memories In Motion') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
MTV Video Productions
Albury NSW 2640
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=10587 or tblfeedback.strbusinessname='MTV Video Productions' or tblfeedback.strbusinessname='MTV Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Permanent Memories Pty Ltd
Wangaratta VIC 3677
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=14064 or tblfeedback.strbusinessname='Permanent Memories Pty Ltd' or tblfeedback.strbusinessname='Permanent Memories Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15