Rating Dreamlife Photos and Video Sydney
Dreamlife Photos and Video Sydney
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 Photos and Video Sydney' or tblfeedback.strbusinessname='Dreamlife Photos and Video Sydney') AND tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Unsurpassed quality in telling the video story of your wedding day.

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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Marry Me Movies
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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Avro Film & Video Productions
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Iconic Films
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Golden Touch Productions
Fairfield West 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=35755 or tblfeedback.strbusinessname='Golden Touch Productions' or tblfeedback.strbusinessname='Golden Touch Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wedding Movies
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bloom Films
Sydney NSW 2000
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=29759 or tblfeedback.strbusinessname='Bloom Films' or tblfeedback.strbusinessname='Bloom Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Video Innovations
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
NYC Films
St Ives NSW 2112
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=21883 or tblfeedback.strbusinessname='NYC Films' or tblfeedback.strbusinessname='NYC Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wild Souls
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Angelica Peady
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Puzzleman Productions
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cinemotive
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Paper Crane Productions
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blaycam Video Productions
Marsden Park NSW 2765
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=29848 or tblfeedback.strbusinessname='Blaycam Video Productions' or tblfeedback.strbusinessname='Blaycam Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Summit Photography & Video
West Pennant Hills NSW 2125
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=11596 or tblfeedback.strbusinessname='Summit Photography &%%semi%% Video' or tblfeedback.strbusinessname='Summit Photography & Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ACE of Hearts Video Productions
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ants Pants Video Productions
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hi-Tech Video Productions
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
RI Photography
Lalor Park 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=18355 or tblfeedback.strbusinessname='RI Photography' or tblfeedback.strbusinessname='RI Photography') AND tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Phase 5 Video
Willoughby NSW 2068
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=18321 or tblfeedback.strbusinessname='Phase 5 Video' or tblfeedback.strbusinessname='Phase 5 Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Motion Men Videography
Castle Hill NSW 2154
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=18354 or tblfeedback.strbusinessname='Motion Men Videography' or tblfeedback.strbusinessname='Motion Men Videography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Australian Digital Video Production
Kingsford NSW 2032
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=2510 or tblfeedback.strbusinessname='A Australian Digital Video Production' or tblfeedback.strbusinessname='A Australian Digital Video Production') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mc Lellan Video Productions
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Avro Film & 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=7997 or tblfeedback.strbusinessname='Avro Film &%%semi%% Video Productions' or tblfeedback.strbusinessname='Avro Film & Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
EuroVideo
Cecil Hills 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=18353 or tblfeedback.strbusinessname='EuroVideo' or tblfeedback.strbusinessname='EuroVideo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Albert's Photography & Video
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A1 Classic Wedding Videos
Avalon NSW 2107
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=2531 or tblfeedback.strbusinessname='A1 Classic Wedding Videos' or tblfeedback.strbusinessname='A1 Classic Wedding Videos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Active Photography & Video Production
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Flow Images Video
Drummoyne NSW 2047
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=18606 or tblfeedback.strbusinessname='Flow Images Video' or tblfeedback.strbusinessname='Flow Images Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Altitude Photography & Video
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=2588 or tblfeedback.strbusinessname='Altitude Photography &%%semi%% Video' or tblfeedback.strbusinessname='Altitude Photography & Video') AND tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ellison Video Productions
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
DVD Spirit
Caringbah NSW 2229
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=18319 or tblfeedback.strbusinessname='DVD Spirit' or tblfeedback.strbusinessname='DVD Spirit') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Take Five Video Production
Mosman NSW 2088
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=11670 or tblfeedback.strbusinessname='Take Five Video Production' or tblfeedback.strbusinessname='Take Five Video Production') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
DSM Video Production
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Arena Collins Video Productions
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Halpin Videography
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Acclaim Video Productions-Wedding Specialist
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 81 Sort search results alphabetically