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.
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. 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.
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.
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.
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.
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.
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.
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
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
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
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
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
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
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
John Luc Photography
St Albans Park VIC 3219
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=27269 or tblfeedback.strbusinessname='John Luc Photography' or tblfeedback.strbusinessname='John Luc Photography') 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
Happy Medium Photo Lynda Nguyen
Richmond VIC 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=25315 or tblfeedback.strbusinessname='Happy Medium Photo Lynda Nguyen' or tblfeedback.strbusinessname='Happy Medium Photo Lynda Nguyen') 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
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
Dale Wowk
Canberra ACT 2607
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=26372 or tblfeedback.strbusinessname='Dale Wowk' or tblfeedback.strbusinessname='Dale Wowk') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Love Is Sweet Wedding Photography
Mornington VIC 3931
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=38019 or tblfeedback.strbusinessname='Love Is Sweet Wedding Photography' or tblfeedback.strbusinessname='Love Is Sweet Wedding Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mark Davis Photography
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=26565 or tblfeedback.strbusinessname='Mark Davis Photography' or tblfeedback.strbusinessname='Mark Davis Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Doux Wedding Corp
Box Hill VIC 3128
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=38104 or tblfeedback.strbusinessname='Doux Wedding Corp' or tblfeedback.strbusinessname='Doux Wedding Corp') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ethan Slade Photography
Frankston VIC 3199
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=27104 or tblfeedback.strbusinessname='Ethan Slade Photography' or tblfeedback.strbusinessname='Ethan Slade 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
Astir Images
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=20101 or tblfeedback.strbusinessname='Astir Images' or tblfeedback.strbusinessname='Astir Images') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Prism Imaging
North Melbourne VIC 3051
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=26957 or tblfeedback.strbusinessname='Prism Imaging' or tblfeedback.strbusinessname='Prism Imaging') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mark Dayman Photographer
Box Hill VIC 3128
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=21705 or tblfeedback.strbusinessname='Mark Dayman Photographer' or tblfeedback.strbusinessname='Mark Dayman Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Angus White 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=27340 or tblfeedback.strbusinessname='Angus White Photography' or tblfeedback.strbusinessname='Angus White Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Juliette Lichman Photography
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=26160 or tblfeedback.strbusinessname='Juliette Lichman Photography' or tblfeedback.strbusinessname='Juliette Lichman Photography') 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
Freya Berwick
North Melbourne VIC 3051
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=29670 or tblfeedback.strbusinessname='Freya Berwick' or tblfeedback.strbusinessname='Freya Berwick') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Panorama Imagery and Films
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=37939 or tblfeedback.strbusinessname='Panorama Imagery and Films' or tblfeedback.strbusinessname='Panorama Imagery and Films') 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
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
Peter Kotsa Photography
Mt Waverley VIC 3149
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=17434 or tblfeedback.strbusinessname='Peter Kotsa Photography' or tblfeedback.strbusinessname='Peter Kotsa Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Peter Barlow- Image Creator
Heidelberg West VIC 3081
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=29312 or tblfeedback.strbusinessname='Peter Barlow- Image Creator' or tblfeedback.strbusinessname='Peter Barlow- Image Creator') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Dolce Vita
Pascoe Vale VIC 3044
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=37589 or tblfeedback.strbusinessname='Dolce Vita' or tblfeedback.strbusinessname='Dolce Vita') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Crystal D 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=26203 or tblfeedback.strbusinessname='Crystal D Studio' or tblfeedback.strbusinessname='Crystal D Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Vanessa Norris
Mornington VIC 3931
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=29640 or tblfeedback.strbusinessname='Vanessa Norris' or tblfeedback.strbusinessname='Vanessa Norris') 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
Jodie Drew
Kinglake VIC 3763
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=26300 or tblfeedback.strbusinessname='Jodie Drew' or tblfeedback.strbusinessname='Jodie Drew') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kerryn Lee Photography
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=26572 or tblfeedback.strbusinessname='Kerryn Lee Photography' or tblfeedback.strbusinessname='Kerryn Lee Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Nikki & Ashley Films and Stills
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=25654 or tblfeedback.strbusinessname='Nikki &%%semi%% Ashley Films and Stills' or tblfeedback.strbusinessname='Nikki & Ashley Films and Stills') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Studio 477 Photographic Art
Brunswick West VIC 3055
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=22066 or tblfeedback.strbusinessname='Studio 477 Photographic Art' or tblfeedback.strbusinessname='Studio 477 Photographic Art') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tom Field Media
Mornington VIC 3931
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=26946 or tblfeedback.strbusinessname='Tom Field Media' or tblfeedback.strbusinessname='Tom Field Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
James Barbone
Hampton VIC 3161
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=36103 or tblfeedback.strbusinessname='James Barbone' or tblfeedback.strbusinessname='James Barbone') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
