JMS Photography
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=17426 or tblfeedback.strbusinessname='JMS Photography' or tblfeedback.strbusinessname='JMS Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Johnmark photographs in a very sensitive yet natural way with the aim being to capture every candid & special moment. Photos are a celebration of special times in our lives and our aim is to ensure every special moment is remembered. Johnmark photographs in a varied mix of traditional, contemporary, classical, candid & portraits that reflect the feeling of love.
Simply Stunning
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=17460 or tblfeedback.strbusinessname='Simply Stunning' or tblfeedback.strbusinessname='Simply Stunning') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Simply Stunning, established in 1996, is an intimate studio catering to the desires and dreams of our clients on the most important day of their lives. Our approach is always one of relaxed, the more relaxed the day is greater fun the whole bridal party has. We pride ourselves on listening to our couples, what is important to them, how they would like their day to unfold.
Dreamlife Photo and Video Melbourne
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=20223 or tblfeedback.strbusinessname='Dreamlife Photo and Video Melbourne' or tblfeedback.strbusinessname='Dreamlife Photo and Video Melbourne') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Dreamlife is a dual purpose studio placing equal importance on wedding photography and wedding videography in creating a harmonious balance between time-tested still photography and high definition film making. Using only consummate professionals and state of the art technology we are creating works never before thought possible
I&J Photographics
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=17171 or tblfeedback.strbusinessname='I&%%semi%%J Photographics' or tblfeedback.strbusinessname='I&J Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wedding photography is my passion (Ian), I love everything about weddings, I love capturing the emotion, the fun and the little things
that make it your wedding. Give me a call, I would love to be your wedding photographer.
Fine Art Media
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=17170 or tblfeedback.strbusinessname='Fine Art Media' or tblfeedback.strbusinessname='Fine Art Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
For over 20 years, Fine Art Media has been at the forefront of wedding video & photography. We pioneering the art of filming in an unobtrusive manner.
Passion8 Photography
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=17441 or tblfeedback.strbusinessname='Passion8 Photography' or tblfeedback.strbusinessname='Passion8 Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The professional team at Passion8 Photography have a fun, fresh approach to wedding photography. We capture beautiful, natural images. Your Image, Our Passion.
Megan Aldridge Photography
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=17430 or tblfeedback.strbusinessname='Megan Aldridge Photography' or tblfeedback.strbusinessname='Megan Aldridge Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Relaxed, natural photography. Most couples who come to me don't feel comfortable posing in front of a camera%%semi%% my approach is to let them relax and enjoy their day.
Studio House Photography
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=14170 or tblfeedback.strbusinessname='Studio House Photography' or tblfeedback.strbusinessname='Studio House Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Approachable, flexible & non-obtrusive, images you will adore for a lifetime.
Millgrove Photography
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=29480 or tblfeedback.strbusinessname='Millgrove Photography' or tblfeedback.strbusinessname='Millgrove Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Natural & candid style combined with a professional & friendly approach
Clarisse Photography
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=22661 or tblfeedback.strbusinessname='Clarisse Photography' or tblfeedback.strbusinessname='Clarisse Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Relaxed photography, the true you. My approach is somewhat different.
Desiren Photography & 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=20055 or tblfeedback.strbusinessname='Desiren Photography &%%semi%% Video' or tblfeedback.strbusinessname='Desiren Photography & Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A boutique style wedding studio offering a high-end service & product.
Precise Moment Photography
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=19588 or tblfeedback.strbusinessname='Precise Moment Photography' or tblfeedback.strbusinessname='Precise Moment Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Love By Shae
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=23859 or tblfeedback.strbusinessname='Love By Shae' or tblfeedback.strbusinessname='Love By Shae') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Dezine by Mauro
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=25364 or tblfeedback.strbusinessname='Dezine by Mauro' or tblfeedback.strbusinessname='Dezine by Mauro') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
David Anthony Williams AT Heartworks
Ashburton VIC 3147
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=13807 or tblfeedback.strbusinessname='David Anthony Williams AT Heartworks' or tblfeedback.strbusinessname='David Anthony Williams AT Heartworks') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
AJ Photography
Leopold VIC 3224
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=25367 or tblfeedback.strbusinessname='AJ Photography' or tblfeedback.strbusinessname='AJ Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Corey Wright Photographer
Melbourne VIC 3015
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=25386 or tblfeedback.strbusinessname='Corey Wright Photographer' or tblfeedback.strbusinessname='Corey Wright Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Alison Cosker
North 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=29703 or tblfeedback.strbusinessname='Alison Cosker' or tblfeedback.strbusinessname='Alison Cosker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Vera Dogaru Photography
Cranbourne VIC 3977
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=29832 or tblfeedback.strbusinessname='Vera Dogaru Photography' or tblfeedback.strbusinessname='Vera Dogaru Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Melki Studios
Brunswick VIC 3056
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=29886 or tblfeedback.strbusinessname='Melki Studios' or tblfeedback.strbusinessname='Melki Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Will Chao Photography
Lalor VIC 3075
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=29910 or tblfeedback.strbusinessname='Will Chao Photography' or tblfeedback.strbusinessname='Will Chao Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sorrento Wedding Photography
Clifton Hill VIC 3068
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=35586 or tblfeedback.strbusinessname='Sorrento Wedding Photography' or tblfeedback.strbusinessname='Sorrento Wedding Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Stewart Leishman Photography
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=35980 or tblfeedback.strbusinessname='Stewart Leishman Photography' or tblfeedback.strbusinessname='Stewart Leishman Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Melody Monet Photography
Bundoora VIC 3083
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=37613 or tblfeedback.strbusinessname='Melody Monet Photography' or tblfeedback.strbusinessname='Melody Monet Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ladie Fox Photography
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=36039 or tblfeedback.strbusinessname='Ladie Fox Photography' or tblfeedback.strbusinessname='Ladie Fox Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
XSiGHT Photography & Video
Bentleigh East VIC 9486
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=3 or tblfeedback.strbusinessname='XSiGHT Photography & Video' or tblfeedback.strbusinessname='XSiGHT Photography & Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
IClickYOU photos
Cheltenham VIC 3978
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=27826 or tblfeedback.strbusinessname='IClickYOU photos' or tblfeedback.strbusinessname='IClickYOU photos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Alan Rogers
Doncaster East VIC 3109
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=28993 or tblfeedback.strbusinessname='Alan Rogers' or tblfeedback.strbusinessname='Alan Rogers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Venus Films and Photography
Glenroy VIC 3046
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=24998 or tblfeedback.strbusinessname='Venus Films and Photography' or tblfeedback.strbusinessname='Venus Films and Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Elsa Campbell Photography
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=24984 or tblfeedback.strbusinessname='Elsa Campbell Photography' or tblfeedback.strbusinessname='Elsa Campbell Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sheehan Studios
Keilor VIC 3042
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=25041 or tblfeedback.strbusinessname='Sheehan Studios' or tblfeedback.strbusinessname='Sheehan Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
31Studio Photography
Macleod VIC 3085
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=25046 or tblfeedback.strbusinessname='31Studio Photography' or tblfeedback.strbusinessname='31Studio Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Aria Photography
Yarra Valley VIC 3775
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=25049 or tblfeedback.strbusinessname='Aria Photography' or tblfeedback.strbusinessname='Aria Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Viva Photography
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=7373 or tblfeedback.strbusinessname='Viva Photography' or tblfeedback.strbusinessname='Viva Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tales of Tingewick Photography
Kew VIC 3101
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=14178 or tblfeedback.strbusinessname='Tales of Tingewick Photography' or tblfeedback.strbusinessname='Tales of Tingewick Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
In the Booth
Narangba QLD 4504
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=21211 or tblfeedback.strbusinessname='In the Booth' or tblfeedback.strbusinessname='In the Booth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Megan Beth Photography
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=23843 or tblfeedback.strbusinessname='Megan Beth Photography' or tblfeedback.strbusinessname='Megan Beth Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Laki Sideris Photography
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=24240 or tblfeedback.strbusinessname='Laki Sideris Photography' or tblfeedback.strbusinessname='Laki Sideris Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hidden Valley Weddings
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=29509 or tblfeedback.strbusinessname='Hidden Valley Weddings' or tblfeedback.strbusinessname='Hidden Valley Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mighty Vision
Northcote VIC 3070
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=29552 or tblfeedback.strbusinessname='Mighty Vision' or tblfeedback.strbusinessname='Mighty Vision') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ateia Photography
Docklands VIC 3008
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=29579 or tblfeedback.strbusinessname='Ateia Photography' or tblfeedback.strbusinessname='Ateia Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Emily Howlett Photography
Cranbourne North VIC 3977
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=25192 or tblfeedback.strbusinessname='Emily Howlett Photography' or tblfeedback.strbusinessname='Emily Howlett Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tess Follett
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=25304 or tblfeedback.strbusinessname='Tess Follett' or tblfeedback.strbusinessname='Tess Follett') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Reid Studios
Fitzroy North VIC 3068
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=25355 or tblfeedback.strbusinessname='Reid Studios' or tblfeedback.strbusinessname='Reid Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Studio Max
Ringwood VIC 3134
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=17437 or tblfeedback.strbusinessname='Studio Max' or tblfeedback.strbusinessname='Studio Max') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A Touch of Flash Photography
Croydon VIC 3136
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=25553 or tblfeedback.strbusinessname='A Touch of Flash Photography' or tblfeedback.strbusinessname='A Touch of Flash Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Paul Blake Photographer
Dandenong North VIC 3175
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=25571 or tblfeedback.strbusinessname='Paul Blake Photographer' or tblfeedback.strbusinessname='Paul Blake Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tree photo video studio
South Melbourne VIC 3205
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=25619 or tblfeedback.strbusinessname='Tree photo video studio' or tblfeedback.strbusinessname='Tree photo video studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Danny D'Mello Photography
Wyndham Vale VIC 3030
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=25722 or tblfeedback.strbusinessname='Danny D'%%semi%%Mello Photography' or tblfeedback.strbusinessname='Danny D'Mello Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Amber Williams Photography
Kalorama VIC 3766
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=25731 or tblfeedback.strbusinessname='Amber Williams Photography' or tblfeedback.strbusinessname='Amber Williams Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
