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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
