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.
Winbas 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=41647 or tblfeedback.strbusinessname='Winbas photography' or tblfeedback.strbusinessname='Winbas photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
At Winbas Photography, We enthusiastically serve couples who have a wild heart and a love for adventure! We believe in capturing the authentic moments that will go down in history & get passed down and cherished from generation to generation. We would be honoured to celebrate and capture your day.
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.
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.
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.
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.
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.
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
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.
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
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
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
Fika Pictures
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=41646 or tblfeedback.strbusinessname='Fika Pictures' or tblfeedback.strbusinessname='Fika Pictures') 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
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
Jiovanni Photography
Richmond ACT 3121
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=29102 or tblfeedback.strbusinessname='Jiovanni Photography' or tblfeedback.strbusinessname='Jiovanni Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Elope Australia
Mornington Peninsula VIC 3944
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=46401 or tblfeedback.strbusinessname='Elope Australia' or tblfeedback.strbusinessname='Elope Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rachel Cooper 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=26942 or tblfeedback.strbusinessname='Rachel Cooper Photography' or tblfeedback.strbusinessname='Rachel Cooper Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Paul Mulligan Photographer and Film Maker
West Melbourne VIC 3003
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=38079 or tblfeedback.strbusinessname='Paul Mulligan Photographer and Film Maker' or tblfeedback.strbusinessname='Paul Mulligan Photographer and Film Maker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mark Avellino
Maribyrnong VIC 3032
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=26047 or tblfeedback.strbusinessname='Mark Avellino' or tblfeedback.strbusinessname='Mark Avellino') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ashley K Weddings
Greensborough VIC 3088
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=22911 or tblfeedback.strbusinessname='Ashley K Weddings' or tblfeedback.strbusinessname='Ashley K Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Belle Martin 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=39896 or tblfeedback.strbusinessname='Belle Martin Photography' or tblfeedback.strbusinessname='Belle Martin Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
CamQ 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=38133 or tblfeedback.strbusinessname='CamQ Photography' or tblfeedback.strbusinessname='CamQ Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hazel Louise Photography
Bayswater VIC 3151
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=44128 or tblfeedback.strbusinessname='Hazel Louise Photography' or tblfeedback.strbusinessname='Hazel Louise Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Loco Photography
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=22055 or tblfeedback.strbusinessname='Loco Photography' or tblfeedback.strbusinessname='Loco Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
La Moment 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=43976 or tblfeedback.strbusinessname='La Moment Photography' or tblfeedback.strbusinessname='La Moment Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rosa Photography Melbourne
Rowville VIC 3178
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=46618 or tblfeedback.strbusinessname='Rosa Photography Melbourne' or tblfeedback.strbusinessname='Rosa Photography Melbourne') 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
Duuet Wedding Photography
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=23237 or tblfeedback.strbusinessname='Duuet Wedding Photography' or tblfeedback.strbusinessname='Duuet Wedding Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Alison Cosker 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=22443 or tblfeedback.strbusinessname='Alison Cosker Photography' or tblfeedback.strbusinessname='Alison Cosker Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Image Eight
Malvern East VIC 3145
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=26417 or tblfeedback.strbusinessname='Image Eight' or tblfeedback.strbusinessname='Image Eight') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
WhiteChilli 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=44171 or tblfeedback.strbusinessname='WhiteChilli photography' or tblfeedback.strbusinessname='WhiteChilli photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Flashback Feels
Melbourne VIC 3138
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=46209 or tblfeedback.strbusinessname='Flashback Feels' or tblfeedback.strbusinessname='Flashback Feels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lost in Love Photography
Prahran VIC 3181
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=37889 or tblfeedback.strbusinessname='Lost in Love Photography' or tblfeedback.strbusinessname='Lost in Love Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hyggelig Photography
Kingsville VIC 3012
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=26886 or tblfeedback.strbusinessname='Hyggelig Photography' or tblfeedback.strbusinessname='Hyggelig 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
Caitlin May Wedding Photography
Kilsyth VIC 3137
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=46047 or tblfeedback.strbusinessname='Caitlin May Wedding Photography' or tblfeedback.strbusinessname='Caitlin May Wedding Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sarah Clarke 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=41417 or tblfeedback.strbusinessname='Sarah Clarke Photography' or tblfeedback.strbusinessname='Sarah Clarke 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
Calla Esse
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=46887 or tblfeedback.strbusinessname='Calla Esse' or tblfeedback.strbusinessname='Calla Esse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Proshot Photography
Carlton North VIC 3054
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=26733 or tblfeedback.strbusinessname='Proshot Photography' or tblfeedback.strbusinessname='Proshot Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Heartstrings Photography Melbourne
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=26290 or tblfeedback.strbusinessname='Heartstrings Photography Melbourne' or tblfeedback.strbusinessname='Heartstrings Photography Melbourne') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mike Tarr Photography
Caroline Springs VIC 3037
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=27861 or tblfeedback.strbusinessname='Mike Tarr Photography' or tblfeedback.strbusinessname='Mike Tarr Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mike and Amy Photographers
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=26088 or tblfeedback.strbusinessname='Mike and Amy Photographers' or tblfeedback.strbusinessname='Mike and Amy Photographers') 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
Brooke Art Studio
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=45846 or tblfeedback.strbusinessname='Brooke Art Studio' or tblfeedback.strbusinessname='Brooke Art Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
InVision Photography
Greenvale VIC 3059
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=22333 or tblfeedback.strbusinessname='InVision Photography' or tblfeedback.strbusinessname='InVision Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15