Inside The Frame
1 9 Sussex Street GLENORCHY TAS 7010
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=29612 or tblfeedback.strbusinessname='Inside The Frame' or tblfeedback.strbusinessname='Inside The Frame') and year(getdate())-year(dtmadded)<=15
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 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 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 & 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=20223 or tblfeedback.strbusinessname='Dreamlife Photo &%%semi%% Video' or tblfeedback.strbusinessname='Dreamlife Photo & Video') 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 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 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.
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 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.
Passion 8 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='Passion 8 Photography' or tblfeedback.strbusinessname='Passion 8 Photography') 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.
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 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 year(getdate())-year(dtmadded)<=15
A boutique style wedding studio offering a high-end service & product.
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 year(getdate())-year(dtmadded)<=15
Relaxed photography, the true you. My approach is somewhat different.
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 year(getdate())-year(dtmadded)<=15
Natural & candid style combined with a professional & friendly approach
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 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 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 year(getdate())-year(dtmadded)<=15
David Anthony Williams AT Heartworks
14 Gloucester Road 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 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 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 year(getdate())-year(dtmadded)<=15
AJ Photography
37 Glendale Drive 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 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 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 year(getdate())-year(dtmadded)<=15
Mighty Vision
2/579 High St 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 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 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 year(getdate())-year(dtmadded)<=15
Reid Studios
79-81 Reid Street 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 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 year(getdate())-year(dtmadded)<=15
Alan Rogers
10 Elvie St 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 year(getdate())-year(dtmadded)<=15
Venus Films and Photography
4/103 Loongana Avenue 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 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 year(getdate())-year(dtmadded)<=15
Sheehan Studios
2 Lyons Court 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 year(getdate())-year(dtmadded)<=15
31Studio Photography
121 Greensborough Rd 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 year(getdate())-year(dtmadded)<=15
Aria Photography
7 Lockhart Rd 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 year(getdate())-year(dtmadded)<=15
Viva Photography
Cnr Collie & Pakenham Street 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 year(getdate())-year(dtmadded)<=15
Tales of Tingewick Photography
146 Pakington Street 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 year(getdate())-year(dtmadded)<=15
In the Booth
PO Box 359 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 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 year(getdate())-year(dtmadded)<=15
Amanda Kilbourn Photography
Carlisle Rd Ferntree Gully VIC 3156
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=27463 or tblfeedback.strbusinessname='Amanda Kilbourn Photography' or tblfeedback.strbusinessname='Amanda Kilbourn Photography') 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 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 year(getdate())-year(dtmadded)<=15
Astir Images
438 Sydney Road 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 year(getdate())-year(dtmadded)<=15
Happy Medium Photo Lynda Nguyen
23 Butler St 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 year(getdate())-year(dtmadded)<=15
Eva After Photography
Broadford VIC 3658
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=25549 or tblfeedback.strbusinessname='Eva After Photography' or tblfeedback.strbusinessname='Eva After Photography') 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 year(getdate())-year(dtmadded)<=15
Scarr 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=25662 or tblfeedback.strbusinessname='Scarr Photography' or tblfeedback.strbusinessname='Scarr Photography') and year(getdate())-year(dtmadded)<=15
Alana Taylor Photography
Cranbourne East NSW 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=25805 or tblfeedback.strbusinessname='Alana Taylor Photography' or tblfeedback.strbusinessname='Alana Taylor Photography') and year(getdate())-year(dtmadded)<=15
T-One Image Photography Melbourne
205 Victoria Parade Collingwood VIC 3066
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=25846 or tblfeedback.strbusinessname='T-One Image Photography Melbourne' or tblfeedback.strbusinessname='T-One Image Photography Melbourne') and year(getdate())-year(dtmadded)<=15
BLVD Media
355 Docklands Dr 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=26268 or tblfeedback.strbusinessname='BLVD Media' or tblfeedback.strbusinessname='BLVD Media') and year(getdate())-year(dtmadded)<=15
Luke Mitrousis Photography
Melbourne VIC 3002
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=22664 or tblfeedback.strbusinessname='Luke Mitrousis Photography' or tblfeedback.strbusinessname='Luke Mitrousis Photography') and year(getdate())-year(dtmadded)<=15
Phenomena Photography and Cinematic
163A Williams Road South Yarra VIC 3141
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=20852 or tblfeedback.strbusinessname='Phenomena Photography and Cinematic' or tblfeedback.strbusinessname='Phenomena Photography and Cinematic') and year(getdate())-year(dtmadded)<=15
ATEIA
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=24551 or tblfeedback.strbusinessname='ATEIA' or tblfeedback.strbusinessname='ATEIA') and year(getdate())-year(dtmadded)<=15
