Rating
Bliss Images
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=35532 or tblfeedback.strbusinessname='Bliss Images' or tblfeedback.strbusinessname='Bliss Images') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Little Darling Films
Klemzig SA 5087
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=25598 or tblfeedback.strbusinessname='Little Darling Films' or tblfeedback.strbusinessname='Little Darling Films') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wedding Films Australia
Underdale SA 5032
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=27513 or tblfeedback.strbusinessname='Wedding Films Australia' or tblfeedback.strbusinessname='Wedding Films Australia') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Vu Phan Productions
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=29468 or tblfeedback.strbusinessname='Vu Phan Productions' or tblfeedback.strbusinessname='Vu Phan Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lifesketch Films
Rostrevor SA 5073
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=29142 or tblfeedback.strbusinessname='Lifesketch Films' or tblfeedback.strbusinessname='Lifesketch Films') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Emily jade productions
Fairview Park SA 5126
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=36296 or tblfeedback.strbusinessname='Emily jade productions' or tblfeedback.strbusinessname='Emily jade productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Audio Visual Impressions
Hiillcrest SA 5086
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=19036 or tblfeedback.strbusinessname='Audio Visual Impressions' or tblfeedback.strbusinessname='Audio Visual Impressions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beyond Video Productions
HampsteadGardens SA 5086
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=19045 or tblfeedback.strbusinessname='Beyond Video Productions' or tblfeedback.strbusinessname='Beyond Video Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Coconut Productions Video
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=19072 or tblfeedback.strbusinessname='Coconut Productions Video' or tblfeedback.strbusinessname='Coconut Productions Video') and year(getdate())-year(dtmadded)<=15
Rating
SA Video Productions
Kidman Park SA 5025
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=19192 or tblfeedback.strbusinessname='SA Video Productions' or tblfeedback.strbusinessname='SA Video Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Camelot Studio
Brooklyn Park SA 5032
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=4959 or tblfeedback.strbusinessname='Camelot Studio' or tblfeedback.strbusinessname='Camelot Studio') and year(getdate())-year(dtmadded)<=15
Rating
Bogart Video Productions
Kensington Park SA 5068
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=4953 or tblfeedback.strbusinessname='Bogart Video Productions' or tblfeedback.strbusinessname='Bogart Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Coconut Productions Pty Ltd
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=4976 or tblfeedback.strbusinessname='Coconut Productions Pty Ltd' or tblfeedback.strbusinessname='Coconut Productions Pty Ltd') and year(getdate())-year(dtmadded)<=15
Rating
Designer Video & Photography
Payneham SA 5070
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=4989 or tblfeedback.strbusinessname='Designer Video &%%semi%% Photography' or tblfeedback.strbusinessname='Designer Video & Photography') and year(getdate())-year(dtmadded)<=15
Rating
Dynasty Video Productions
West Woodville SA 5011
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=4993 or tblfeedback.strbusinessname='Dynasty Video Productions' or tblfeedback.strbusinessname='Dynasty Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Festive Video
Redwood Park SA 5097
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=5002 or tblfeedback.strbusinessname='Festive Video' or tblfeedback.strbusinessname='Festive Video') and year(getdate())-year(dtmadded)<=15
Rating
Prima Photographics
Fulham Gardens SA 5024
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=5081 or tblfeedback.strbusinessname='Prima Photographics' or tblfeedback.strbusinessname='Prima Photographics') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Young Ross Photography
Hallett Cove SA 5158
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=5128 or tblfeedback.strbusinessname='Young Ross Photography' or tblfeedback.strbusinessname='Young Ross Photography') and year(getdate())-year(dtmadded)<=15
Rating
First Wave Media
Aldgate SA 5154
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=6631 or tblfeedback.strbusinessname='First Wave Media' or tblfeedback.strbusinessname='First Wave Media') and year(getdate())-year(dtmadded)<=15
Rating
Advanced Edit
Golden Grove SA 5125
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=6628 or tblfeedback.strbusinessname='Advanced Edit' or tblfeedback.strbusinessname='Advanced Edit') and year(getdate())-year(dtmadded)<=15
Rating
Cherish Video Memories
Seaton SA 5023
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=6629 or tblfeedback.strbusinessname='Cherish Video Memories' or tblfeedback.strbusinessname='Cherish Video Memories') and year(getdate())-year(dtmadded)<=15
Rating
Digiview Productions
Salisbury East SA 5109
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=6630 or tblfeedback.strbusinessname='Digiview Productions' or tblfeedback.strbusinessname='Digiview Productions') and year(getdate())-year(dtmadded)<=15
Rating
Gothic City Video
Ridgehaven SA 5097
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=6632 or tblfeedback.strbusinessname='Gothic City Video' or tblfeedback.strbusinessname='Gothic City Video') and year(getdate())-year(dtmadded)<=15
Rating
In Phase Vision
Croydon Park SA 5008
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=6634 or tblfeedback.strbusinessname='In Phase Vision' or tblfeedback.strbusinessname='In Phase Vision') and year(getdate())-year(dtmadded)<=15
Rating
KB Video Productions
Broadview SA 5083
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=6635 or tblfeedback.strbusinessname='KB Video Productions' or tblfeedback.strbusinessname='KB Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Life's Special Moments
Para Hills SA 5096
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=6636 or tblfeedback.strbusinessname='Life'%%semi%%s Special Moments' or tblfeedback.strbusinessname='Life's Special Moments') and year(getdate())-year(dtmadded)<=15
Rating
Lily Video Productions
Croydon Park SA 5008
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=6637 or tblfeedback.strbusinessname='Lily Video Productions' or tblfeedback.strbusinessname='Lily Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
M Webb Video Productions
Modbury North SA 5092
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=6638 or tblfeedback.strbusinessname='M Webb Video Productions' or tblfeedback.strbusinessname='M Webb Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Prime Time Video Productions
Golden Grove SA 5125
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=6639 or tblfeedback.strbusinessname='Prime Time Video Productions' or tblfeedback.strbusinessname='Prime Time Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Professional Video Film Photography
Glenelg SA 5045
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=6640 or tblfeedback.strbusinessname='Professional Video Film Photography' or tblfeedback.strbusinessname='Professional Video Film Photography') and year(getdate())-year(dtmadded)<=15
Rating
Prosser Video Productions
Valley View SA 5093
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=6641 or tblfeedback.strbusinessname='Prosser Video Productions' or tblfeedback.strbusinessname='Prosser Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Reel 2 Real Media Productions
Newton SA 5074
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=6642 or tblfeedback.strbusinessname='Reel 2 Real Media Productions' or tblfeedback.strbusinessname='Reel 2 Real Media Productions') and year(getdate())-year(dtmadded)<=15
Rating
Remember Then?
Toorak Gardens SA 5065
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=6643 or tblfeedback.strbusinessname='Remember Then?%%semi%%' or tblfeedback.strbusinessname='Remember Then?') and year(getdate())-year(dtmadded)<=15
Rating
Ross Young Photography
Hallett Cove SA 5158
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=6644 or tblfeedback.strbusinessname='Ross Young Photography' or tblfeedback.strbusinessname='Ross Young Photography') and year(getdate())-year(dtmadded)<=15
Rating
SA Video Productions
Lockleys SA 5032
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=6645 or tblfeedback.strbusinessname='SA Video Productions' or tblfeedback.strbusinessname='SA Video Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Scot-Oz Productions
Salisbury North SA 5108
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=6646 or tblfeedback.strbusinessname='Scot-Oz Productions' or tblfeedback.strbusinessname='Scot-Oz Productions') and year(getdate())-year(dtmadded)<=15
Rating
Timothy Nix Wedding Videos
Kurralta Park SA 5037
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=6647 or tblfeedback.strbusinessname='Timothy Nix Wedding Videos' or tblfeedback.strbusinessname='Timothy Nix Wedding Videos') and year(getdate())-year(dtmadded)<=15
Rating
Total Recall Video Productions
Broadview SA 5083
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=6649 or tblfeedback.strbusinessname='Total Recall Video Productions' or tblfeedback.strbusinessname='Total Recall Video Productions') and year(getdate())-year(dtmadded)<=15