Rating
Bedroom Studio - Wedding Photography + Cinema
Birmingham Gardens NSW 2287
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=44233 or tblfeedback.strbusinessname='Bedroom Studio - Wedding Photography +%%semi%% Cinema' or tblfeedback.strbusinessname='Bedroom Studio - Wedding Photography + Cinema') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lighthouse Films
Newcastle NSW 2300
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=22290 or tblfeedback.strbusinessname='Lighthouse Films' or tblfeedback.strbusinessname='Lighthouse Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Relive the Day
Newcastle NSW 2300
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=29179 or tblfeedback.strbusinessname='Relive the Day' or tblfeedback.strbusinessname='Relive the Day') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bonnie Lass Films
Hunter Valley NSW 2320
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=36364 or tblfeedback.strbusinessname='Bonnie Lass Films' or tblfeedback.strbusinessname='Bonnie Lass Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
JNewcombe Wedding Films
Newcastle NSW 2300
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=45952 or tblfeedback.strbusinessname='JNewcombe Wedding Films' or tblfeedback.strbusinessname='JNewcombe Wedding Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wildwood Cinematic
Hunter Region NSW 2310
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=38405 or tblfeedback.strbusinessname='Wildwood Cinematic' or tblfeedback.strbusinessname='Wildwood Cinematic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Arrow Media - Shane Errington
Young NSW 2594
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=44750 or tblfeedback.strbusinessname='Arrow Media - Shane Errington' or tblfeedback.strbusinessname='Arrow Media - Shane Errington') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Design Patrol Films
Newcastle NSW 2300
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=46507 or tblfeedback.strbusinessname='Design Patrol Films' or tblfeedback.strbusinessname='Design Patrol Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Salty Skin Visuals
Newcastle NSW 2267
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=29276 or tblfeedback.strbusinessname='Salty Skin Visuals' or tblfeedback.strbusinessname='Salty Skin Visuals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sandy Feet Films
Newcastle NSW 2267
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=43880 or tblfeedback.strbusinessname='Sandy Feet Films' or tblfeedback.strbusinessname='Sandy Feet Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Switch Multimedia
Mannering Park NSW 2259
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=27186 or tblfeedback.strbusinessname='Switch Multimedia' or tblfeedback.strbusinessname='Switch Multimedia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
I Do Cinema
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=36346 or tblfeedback.strbusinessname='I Do Cinema' or tblfeedback.strbusinessname='I Do Cinema') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Inspire Films
Newcastle NSW 2267
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=41172 or tblfeedback.strbusinessname='Inspire Films' or tblfeedback.strbusinessname='Inspire Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hunter Valley Video
NSW 2320
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=21466 or tblfeedback.strbusinessname='Hunter Valley Video' or tblfeedback.strbusinessname='Hunter Valley Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Little Ruby
Newcastle NSW 2300
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=26724 or tblfeedback.strbusinessname='Little Ruby' or tblfeedback.strbusinessname='Little Ruby') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
I Do Cinema
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=36346 or tblfeedback.strbusinessname='I Do Cinema' or tblfeedback.strbusinessname='I Do Cinema') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
SMC Studios
Brisbane QLD 4000
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=30309 or tblfeedback.strbusinessname='SMC Studios' or tblfeedback.strbusinessname='SMC Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cuefocus
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=43987 or tblfeedback.strbusinessname='Cuefocus' or tblfeedback.strbusinessname='Cuefocus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
GMTMT FILMS
Newcastle NSW 2300
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=21255 or tblfeedback.strbusinessname='GMTMT FILMS' or tblfeedback.strbusinessname='GMTMT FILMS') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dion Cario Films
Tarrawanna NSW 2518
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=42868 or tblfeedback.strbusinessname='Dion Cario Films' or tblfeedback.strbusinessname='Dion Cario Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Morelife Films
Newcastle NSW 2300
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=22409 or tblfeedback.strbusinessname='Morelife Films' or tblfeedback.strbusinessname='Morelife Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Above Below Visuals
Syndey 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=46392 or tblfeedback.strbusinessname='Above Below Visuals' or tblfeedback.strbusinessname='Above Below Visuals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Say Cheese Film and Video Prod
Corlette NSW 2315
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=18356 or tblfeedback.strbusinessname='Say Cheese Film and Video Prod' or tblfeedback.strbusinessname='Say Cheese Film and Video Prod') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Aartistic Wedding Video Specialists
Newcastle NSW 2300
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=7702 or tblfeedback.strbusinessname='Aartistic Wedding Video Specialists' or tblfeedback.strbusinessname='Aartistic Wedding Video Specialists') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bush
Floraville NSW 2280
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=8434 or tblfeedback.strbusinessname='Bush' or tblfeedback.strbusinessname='Bush') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Morrow Video Productions
Newcastle NSW 2300
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=10563 or tblfeedback.strbusinessname='Morrow Video Productions' or tblfeedback.strbusinessname='Morrow Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Star Video Productions
Georgetown NSW 2298
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=11532 or tblfeedback.strbusinessname='Star Video Productions' or tblfeedback.strbusinessname='Star Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Meridian Image Video Productions
Kotara NSW 2289
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=10466 or tblfeedback.strbusinessname='Meridian Image Video Productions' or tblfeedback.strbusinessname='Meridian Image Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Digital Ghost
Newcastle NSW 2300
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=9022 or tblfeedback.strbusinessname='Digital Ghost' or tblfeedback.strbusinessname='Digital Ghost') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Civic Video
Elermore Vale NSW 2287
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=8680 or tblfeedback.strbusinessname='Civic Video' or tblfeedback.strbusinessname='Civic Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Horizon Video
Cooranbong NSW 2265
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=9723 or tblfeedback.strbusinessname='Horizon Video' or tblfeedback.strbusinessname='Horizon Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
DVD Magic
Elermore Vale NSW 2287
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=9098 or tblfeedback.strbusinessname='DVD Magic' or tblfeedback.strbusinessname='DVD Magic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gem Video
Cardiff South NSW 2285
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=9430 or tblfeedback.strbusinessname='Gem Video' or tblfeedback.strbusinessname='Gem Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Absolute Edge Video Productions
Merewether NSW 2291
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=2538 or tblfeedback.strbusinessname='Absolute Edge Video Productions' or tblfeedback.strbusinessname='Absolute Edge Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15