Rating Dreamlife Photo & Video
Dreamlife Photo & Video
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=20226 or tblfeedback.strbusinessname='Dreamlife Photo &%%semi%% Video' or tblfeedback.strbusinessname='Dreamlife Photo & Video') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Wedding photography and wedding videography

Rating Arian Film Productions
Arian Film Productions
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=17226 or tblfeedback.strbusinessname='Arian Film Productions' or tblfeedback.strbusinessname='Arian Film Productions') and year(getdate())-year(dtmadded)<=15
Unsurpassed quality in telling the video story of your wedding day.

Rating
Paper Crane Productions
by appointment Artarmon NSW 2064
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=20131 or tblfeedback.strbusinessname='Paper Crane Productions' or tblfeedback.strbusinessname='Paper Crane Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
MMG Photo and Cinema
Crows Nest NSW 2065
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=21390 or tblfeedback.strbusinessname='MMG Photo and Cinema' or tblfeedback.strbusinessname='MMG Photo and Cinema') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Iconic Films
16 Fennell Street Parramatta NSW 2150
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=21413 or tblfeedback.strbusinessname='Iconic Films' or tblfeedback.strbusinessname='Iconic Films') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Goodness Gracious Films
Freshwater NSW 2096
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=26017 or tblfeedback.strbusinessname='Goodness Gracious Films' or tblfeedback.strbusinessname='Goodness Gracious Films') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Skeedvision
Chiswick NSW 2046
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=23058 or tblfeedback.strbusinessname='Skeedvision' or tblfeedback.strbusinessname='Skeedvision') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Puzzleman Productions
Hyde Parade Cambelltown NSW 2560
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=24065 or tblfeedback.strbusinessname='Puzzleman Productions' or tblfeedback.strbusinessname='Puzzleman Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cinemotive
1a Duck St Auburn NSW 2144
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=26408 or tblfeedback.strbusinessname='Cinemotive' or tblfeedback.strbusinessname='Cinemotive') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Angelica Peady
Hadley Pl Jamisontown NSW 2750
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=26812 or tblfeedback.strbusinessname='Angelica Peady' or tblfeedback.strbusinessname='Angelica Peady') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Emotiva Photo and Video
Vaucluse NSW 2030
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=27417 or tblfeedback.strbusinessname='Emotiva Photo and Video' or tblfeedback.strbusinessname='Emotiva Photo and Video') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wedding Movies
Melbourne & Sydney 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=25554 or tblfeedback.strbusinessname='Wedding Movies' or tblfeedback.strbusinessname='Wedding Movies') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Video Innovations
134 Mitchell Drive Glossodia NSW 2756
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=25615 or tblfeedback.strbusinessname='Video Innovations' or tblfeedback.strbusinessname='Video Innovations') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Anchored Love Photography
Frenchs Forest NSW 2086
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=26311 or tblfeedback.strbusinessname='Anchored Love Photography' or tblfeedback.strbusinessname='Anchored Love Photography') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Marry Me Movies
Suite 18 5 Vuko Place Warriewood NSW 2102
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=25660 or tblfeedback.strbusinessname='Marry Me Movies' or tblfeedback.strbusinessname='Marry Me Movies') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wild Souls
13A/8 Henry Rose Place Auckland NSW 0632
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=29482 or tblfeedback.strbusinessname='Wild Souls' or tblfeedback.strbusinessname='Wild Souls') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Avro Film & Video Productions
14/40 Strathalbyn Drive North Parramatta NSW 2151
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=7996 or tblfeedback.strbusinessname='Avro Film &%%semi%% Video Productions' or tblfeedback.strbusinessname='Avro Film & Video Productions') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Avro Film & Video Productions
12 Harrod Street Prospect NSW 2148
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=7997 or tblfeedback.strbusinessname='Avro Film &%%semi%% Video Productions' or tblfeedback.strbusinessname='Avro Film & Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Caras Peter Videoman
Earlwood NSW 2206
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=8510 or tblfeedback.strbusinessname='Caras Peter Videoman' or tblfeedback.strbusinessname='Caras Peter Videoman') and year(getdate())-year(dtmadded)<=15
Rating
Cavalier Video Recording Services
139 Long Street Smithfield NSW 2164
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=8565 or tblfeedback.strbusinessname='Cavalier Video Recording Services' or tblfeedback.strbusinessname='Cavalier Video Recording Services') and year(getdate())-year(dtmadded)<=15
Rating
Cheers Video Productions
Marrickville NSW 2204
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=8625 or tblfeedback.strbusinessname='Cheers Video Productions' or tblfeedback.strbusinessname='Cheers Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Cherished Moments Wedding Videos
42 Alleyne Avenue North Narrabeen NSW 2101
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=8627 or tblfeedback.strbusinessname='Cherished Moments Wedding Videos' or tblfeedback.strbusinessname='Cherished Moments Wedding Videos') and year(getdate())-year(dtmadded)<=15
Rating
Creative Moving Pictures
31 Wyuna Avenue Harbord NSW 2096
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=8840 or tblfeedback.strbusinessname='Creative Moving Pictures' or tblfeedback.strbusinessname='Creative Moving Pictures') and year(getdate())-year(dtmadded)<=15
Rating
Digiera Video Productions
Carramar NSW 2163
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=9021 or tblfeedback.strbusinessname='Digiera Video Productions' or tblfeedback.strbusinessname='Digiera Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
DSM Video Production
419 Parramatta Road Leichhardt NSW 2040
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=9083 or tblfeedback.strbusinessname='DSM Video Production' or tblfeedback.strbusinessname='DSM Video Production') and year(getdate())-year(dtmadded)<=15
Rating
E Milan Video Production
Seven Hills NSW 2147
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=9103 or tblfeedback.strbusinessname='E Milan Video Production' or tblfeedback.strbusinessname='E Milan Video Production') and year(getdate())-year(dtmadded)<=15
Rating
Ellison Video Productions
2 Laurel Chase Forestville NSW 2087
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=9161 or tblfeedback.strbusinessname='Ellison Video Productions' or tblfeedback.strbusinessname='Ellison Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Elvis Video Camera Productions
54 Market Street Smithfield NSW 2164
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=9166 or tblfeedback.strbusinessname='Elvis Video Camera Productions' or tblfeedback.strbusinessname='Elvis Video Camera Productions') and year(getdate())-year(dtmadded)<=15
Rating
Gap Wedding Videos
Baulkham Hills NSW 2153
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=9408 or tblfeedback.strbusinessname='Gap Wedding Videos' or tblfeedback.strbusinessname='Gap Wedding Videos') and year(getdate())-year(dtmadded)<=15
Rating
Grand Video Productions
Edensor Park NSW 2176
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=9540 or tblfeedback.strbusinessname='Grand Video Productions' or tblfeedback.strbusinessname='Grand Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Halpin Videography
Unit 7 5-7 Koorabel Avenue Gymea NSW 2227
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=9598 or tblfeedback.strbusinessname='Halpin Videography' or tblfeedback.strbusinessname='Halpin Videography') and year(getdate())-year(dtmadded)<=15
Rating
Hi-Tech Video Productions
71/3 Riverpark Drive Liverpool NSW 2170
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=9706 or tblfeedback.strbusinessname='Hi-Tech Video Productions' or tblfeedback.strbusinessname='Hi-Tech Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
I-Do Video Productions
Prospect NSW 2148
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=9788 or tblfeedback.strbusinessname='I-Do Video Productions' or tblfeedback.strbusinessname='I-Do Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Impressive Effects Video Productions
19 Lachlan Street Bossley Park NSW 2176
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=9806 or tblfeedback.strbusinessname='Impressive Effects Video Productions' or tblfeedback.strbusinessname='Impressive Effects Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
KK Video Productions
76 Talara Road Gymea NSW 2227
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=10092 or tblfeedback.strbusinessname='KK Video Productions' or tblfeedback.strbusinessname='KK Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Kramar Productions
Petersham NSW 2049
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=10105 or tblfeedback.strbusinessname='Kramar Productions' or tblfeedback.strbusinessname='Kramar Productions') and year(getdate())-year(dtmadded)<=15
Rating
Lifetime Video
12 Wall Avenue Asquith NSW 2077
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=10208 or tblfeedback.strbusinessname='Lifetime Video' or tblfeedback.strbusinessname='Lifetime Video') and year(getdate())-year(dtmadded)<=15
Rating
Martin Heald Video Production
Gymea NSW 2227
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=10403 or tblfeedback.strbusinessname='Martin Heald Video Production' or tblfeedback.strbusinessname='Martin Heald Video Production') and year(getdate())-year(dtmadded)<=15
Rating
Mc Lellan Video Productions
46 Austin Avenue North Curl Curl NSW 2099
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=10442 or tblfeedback.strbusinessname='Mc Lellan Video Productions' or tblfeedback.strbusinessname='Mc Lellan Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Monsoon Digital Video Productions
Newport NSW 2106
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=10542 or tblfeedback.strbusinessname='Monsoon Digital Video Productions' or tblfeedback.strbusinessname='Monsoon Digital Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Mvideo Productions
46 Austin Avenue Brookvale NSW 2100
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=10611 or tblfeedback.strbusinessname='Mvideo Productions' or tblfeedback.strbusinessname='Mvideo Productions') and year(getdate())-year(dtmadded)<=15
Rating
Ants Pants Video Productions
27 Clements Pde Kirrawee NSW 2232
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=2611 or tblfeedback.strbusinessname='Ants Pants Video Productions' or tblfeedback.strbusinessname='Ants Pants Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Arena Collins Video Productions
10 Bridge St Granville NSW 2142
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=2616 or tblfeedback.strbusinessname='Arena Collins Video Productions' or tblfeedback.strbusinessname='Arena Collins Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
Artform Photography & Video
153 Brook Street Coogee NSW 2034
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=2622 or tblfeedback.strbusinessname='Artform Photography &%%semi%% Video' or tblfeedback.strbusinessname='Artform Photography & Video') and year(getdate())-year(dtmadded)<=15
Rating
Aussie Flicks Video Production
Kirrawee NSW 2232
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=2632 or tblfeedback.strbusinessname='Aussie Flicks Video Production' or tblfeedback.strbusinessname='Aussie Flicks Video Production') and year(getdate())-year(dtmadded)<=15
Rating
Acclaim Video Productions-Wedding Specialist
Church Street Parramatta NSW 2150
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=2543 or tblfeedback.strbusinessname='Acclaim Video Productions-Wedding Specialist' or tblfeedback.strbusinessname='Acclaim Video Productions-Wedding Specialist') and year(getdate())-year(dtmadded)<=15
Rating
ACE of Hearts Video Productions
Level 1 463 Church Street North Parramatta NSW 2151
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=2544 or tblfeedback.strbusinessname='ACE of Hearts Video Productions' or tblfeedback.strbusinessname='ACE of Hearts Video Productions') and year(getdate())-year(dtmadded)<=15
Rating
ACE Web Wedding Video
Parramatta NSW 2150
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=2546 or tblfeedback.strbusinessname='ACE Web Wedding Video' or tblfeedback.strbusinessname='ACE Web Wedding Video') and year(getdate())-year(dtmadded)<=15
Rating
Active Photography & Video Production
54 Bronte Road Bondi Junction NSW 2022
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=2549 or tblfeedback.strbusinessname='Active Photography &%%semi%% Video Production' or tblfeedback.strbusinessname='Active Photography & Video Production') and year(getdate())-year(dtmadded)<=15
Rating
Albert's Photography & Video
18 Macquarie Street Fairfield NSW 2165
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=2566 or tblfeedback.strbusinessname='Albert'%%semi%%s Photography &%%semi%% Video' or tblfeedback.strbusinessname='Albert's Photography & Video') and year(getdate())-year(dtmadded)<=15
1 - 50 of 77 Sort search results alphabetically