Rating Emot Wedding Photography and Videography
Emot Wedding Photography and Videography
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=43530 or tblfeedback.strbusinessname='Emot Wedding Photography and Videography' or tblfeedback.strbusinessname='Emot Wedding Photography and Videography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating

Rating
Honey Media
Perth WA 6000
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=37788 or tblfeedback.strbusinessname='Honey Media' or tblfeedback.strbusinessname='Honey Media') 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
White Swan Productions
Perth WA 6000
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=43684 or tblfeedback.strbusinessname='White Swan Productions' or tblfeedback.strbusinessname='White Swan Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mayan, Wedding on Films
Perth WA 6000
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=27344 or tblfeedback.strbusinessname='Mayan, Wedding on Films' or tblfeedback.strbusinessname='Mayan, Wedding on Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Swift Hound Films
Toodyay WA 6566
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=38217 or tblfeedback.strbusinessname='Swift Hound Films' or tblfeedback.strbusinessname='Swift Hound Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Venture Forth Film Co
Perth WA 6000
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=41410 or tblfeedback.strbusinessname='Venture Forth Film Co' or tblfeedback.strbusinessname='Venture Forth Film Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pavillon Studio
Perth WA 6000
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=41766 or tblfeedback.strbusinessname='Pavillon Studio' or tblfeedback.strbusinessname='Pavillon Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Daisy Clover
Perth WA 6000
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=27507 or tblfeedback.strbusinessname='Daisy Clover' or tblfeedback.strbusinessname='Daisy Clover') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chapman films
Perth WA 6000
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=45877 or tblfeedback.strbusinessname='Chapman films' or tblfeedback.strbusinessname='Chapman films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Launch Film Productions
Wangara WA 6065
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=21874 or tblfeedback.strbusinessname='Launch Film Productions' or tblfeedback.strbusinessname='Launch Film Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
JC Bridal + Events
Brabham WA 6055
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=41381 or tblfeedback.strbusinessname='JC Bridal + Events' or tblfeedback.strbusinessname='JC Bridal + Events') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Partografia Photography & Film
Perth WA 6000
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=43610 or tblfeedback.strbusinessname='Partografia Photography &%%semi%% Film' or tblfeedback.strbusinessname='Partografia Photography & Film') 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
Emotions Films
Harrisdale WA 6112
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=21548 or tblfeedback.strbusinessname='Emotions Films' or tblfeedback.strbusinessname='Emotions Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Orriss Films
Fremantle WA 6160
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=25114 or tblfeedback.strbusinessname='Orriss Films' or tblfeedback.strbusinessname='Orriss Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Little Friends Films
Perth WA 6000
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=26752 or tblfeedback.strbusinessname='Little Friends Films' or tblfeedback.strbusinessname='Little Friends Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Afrotastic Productions
Joondalup WA 6027
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=26072 or tblfeedback.strbusinessname='Afrotastic Productions' or tblfeedback.strbusinessname='Afrotastic Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Perfect Day Film Co
Perth WA 6000
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=44403 or tblfeedback.strbusinessname='Perfect Day Film Co' or tblfeedback.strbusinessname='Perfect Day Film Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Castle Media
Leederville WA 6007
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=43966 or tblfeedback.strbusinessname='Castle Media' or tblfeedback.strbusinessname='Castle Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Matthew Dwyer Studio
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=41667 or tblfeedback.strbusinessname='Matthew Dwyer Studio' or tblfeedback.strbusinessname='Matthew Dwyer Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ben Chan Wedding Cinematography
Perth WA 6000
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=43217 or tblfeedback.strbusinessname='Ben Chan Wedding Cinematography' or tblfeedback.strbusinessname='Ben Chan Wedding Cinematography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Merriment Vision
Perth WA 6000
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=44298 or tblfeedback.strbusinessname='Merriment Vision' or tblfeedback.strbusinessname='Merriment Vision') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
EJ Creative
Perth WA 6009
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=25905 or tblfeedback.strbusinessname='EJ Creative' or tblfeedback.strbusinessname='EJ Creative') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Forever Wedding Videos
Perth WA 6016
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=25845 or tblfeedback.strbusinessname='Forever Wedding Videos' or tblfeedback.strbusinessname='Forever Wedding Videos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Red Empire Media
North Perth WA 6006
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=36237 or tblfeedback.strbusinessname='Red Empire Media' or tblfeedback.strbusinessname='Red Empire Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chris Martin Cinemaography
Perth WA 6000
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=42847 or tblfeedback.strbusinessname='Chris Martin Cinemaography' or tblfeedback.strbusinessname='Chris Martin Cinemaography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tonita Photo and Video
Perth WA 6006
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=21949 or tblfeedback.strbusinessname='Tonita Photo and Video' or tblfeedback.strbusinessname='Tonita Photo and Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wedding Video Productions
Perth WA 6000
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=25833 or tblfeedback.strbusinessname='Wedding Video Productions' or tblfeedback.strbusinessname='Wedding Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Freo Fox
Fremantle WA 6160
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=38303 or tblfeedback.strbusinessname='Freo Fox' or tblfeedback.strbusinessname='Freo Fox') 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
503 films
Perth WA 6000
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=27741 or tblfeedback.strbusinessname='503 films' or tblfeedback.strbusinessname='503 films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blake Projects
Margaret River WA 6285
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=43515 or tblfeedback.strbusinessname='Blake Projects' or tblfeedback.strbusinessname='Blake Projects') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Different Suns
Perth WA 6000
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=36267 or tblfeedback.strbusinessname='Different Suns' or tblfeedback.strbusinessname='Different Suns') 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
Film Co.
Perth WA 6000
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=41557 or tblfeedback.strbusinessname='Film Co.' or tblfeedback.strbusinessname='Film Co.') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mullermind Creative
Geraldton WA 6530
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=27116 or tblfeedback.strbusinessname='Mullermind Creative' or tblfeedback.strbusinessname='Mullermind Creative') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tonita Photography & Video
Clarkson WA 6030
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=23532 or tblfeedback.strbusinessname='Tonita Photography &%%semi%% Video' or tblfeedback.strbusinessname='Tonita Photography & Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
MP Videography
Perth WA 6027
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=42990 or tblfeedback.strbusinessname='MP Videography' or tblfeedback.strbusinessname='MP Videography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Emotion Videography
Joondalup WA 6027
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=26360 or tblfeedback.strbusinessname='Emotion Videography' or tblfeedback.strbusinessname='Emotion Videography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
West Wolf Media
Perth WA 6000
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=44651 or tblfeedback.strbusinessname='West Wolf Media' or tblfeedback.strbusinessname='West Wolf Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Infinite Productions
Perth WA 6000
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=44768 or tblfeedback.strbusinessname='Infinite Productions' or tblfeedback.strbusinessname='Infinite Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Recklessly Wild Media
Perth WA 6000
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=36187 or tblfeedback.strbusinessname='Recklessly Wild Media' or tblfeedback.strbusinessname='Recklessly Wild Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
In Shot Productions
Rockingham WA 6169
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=17952 or tblfeedback.strbusinessname='In Shot Productions' or tblfeedback.strbusinessname='In Shot Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
21st Century Video Productions
Spearwood WA 6163
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=4195 or tblfeedback.strbusinessname='21st Century Video Productions' or tblfeedback.strbusinessname='21st Century Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Crown Video Services
Noranda WA 6062
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=4331 or tblfeedback.strbusinessname='Crown Video Services' or tblfeedback.strbusinessname='Crown Video Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Amore Pictures
North Perth WA 6006
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=17947 or tblfeedback.strbusinessname='Amore Pictures' or tblfeedback.strbusinessname='Amore Pictures') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
David Rush Video
Ferndale WA 6148
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=4336 or tblfeedback.strbusinessname='David Rush Video' or tblfeedback.strbusinessname='David Rush Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Demic Video Productions
West Perth WA 6005
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=4340 or tblfeedback.strbusinessname='Demic Video Productions' or tblfeedback.strbusinessname='Demic Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Minshull Studios
Bayswayer WA 6053
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=17953 or tblfeedback.strbusinessname='Minshull Studios' or tblfeedback.strbusinessname='Minshull Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 67 Sort search results alphabetically