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
296 Henley Beach Road 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
26 Alguna Cres 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
Audio Visual Impressions
Shropshire Ave 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
6 Gambia Avenue 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
240 Grote Street 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
31 Valetta Rd 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
56 Marion Road 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
328 Magill Road 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
99 Halifax Street 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
33 Holden Avenue 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
21 Gollop Crescent 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
392 Tapleys Hill Road 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
44 Levistone Street 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
Northbri Avenue 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
18 Nyonga Avenue 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
6 Field Court 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
Martindale Avenue 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
191A Montacute Road 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?
4 Arthur Street 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