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