Dreamlife Photo and Video Brisbane
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=20227 or tblfeedback.strbusinessname='Dreamlife Photo and Video Brisbane' or tblfeedback.strbusinessname='Dreamlife Photo and Video Brisbane') 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.
Reyment 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=18826 or tblfeedback.strbusinessname='Reyment Photographics' or tblfeedback.strbusinessname='Reyment Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A leading wedding photography and portrait photography studio based in Brisbane. We offer a range of wedding photography options for our clients. Our candid photography approach ensures our images filled with emotion that will make you laugh and cry!
Marina G 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=20139 or tblfeedback.strbusinessname='Marina G Photography' or tblfeedback.strbusinessname='Marina G Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Natural - Beautiful - Affordable.
nrphotography
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=19673 or tblfeedback.strbusinessname='nrphotography' or tblfeedback.strbusinessname='nrphotography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Creative and relaxed approach.
Action Studio
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=19536 or tblfeedback.strbusinessname='Action Studio' or tblfeedback.strbusinessname='Action Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Candid and artistic, capturing meaningful moments.
Studio Present
Southport QLD 4215
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=37511 or tblfeedback.strbusinessname='Studio Present' or tblfeedback.strbusinessname='Studio Present') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Special Memories Photography & Media
Springwood QLD 4127
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=21529 or tblfeedback.strbusinessname='Special Memories Photography &%%semi%% Media' or tblfeedback.strbusinessname='Special Memories Photography & Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Brodie James Photography
Chandler QLD 4155
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=44378 or tblfeedback.strbusinessname='Brodie James Photography' or tblfeedback.strbusinessname='Brodie James Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Dallas Love Photography
South Brisbane QLD 4101
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=24530 or tblfeedback.strbusinessname='Dallas Love Photography' or tblfeedback.strbusinessname='Dallas Love Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Deezigner
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=26402 or tblfeedback.strbusinessname='Deezigner' or tblfeedback.strbusinessname='Deezigner') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ben Clark Photography
Enoggera QLD 4051
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=29636 or tblfeedback.strbusinessname='Ben Clark Photography' or tblfeedback.strbusinessname='Ben Clark Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kerry Bergman Photographer
Edens Landing QLD 4207
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=35785 or tblfeedback.strbusinessname='Kerry Bergman Photographer' or tblfeedback.strbusinessname='Kerry Bergman Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Say Milk Photography
Brisbane QLD 4001
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=26210 or tblfeedback.strbusinessname='Say Milk Photography' or tblfeedback.strbusinessname='Say Milk Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Foy & Co
South Brisbane QLD 4101
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=29344 or tblfeedback.strbusinessname='Foy &%%semi%% Co' or tblfeedback.strbusinessname='Foy & Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lizzy Keleher Photography
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=27406 or tblfeedback.strbusinessname='Lizzy Keleher Photography' or tblfeedback.strbusinessname='Lizzy Keleher Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kerri McAuley Photography
Moggill QLD 4070
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=44569 or tblfeedback.strbusinessname='Kerri McAuley Photography' or tblfeedback.strbusinessname='Kerri McAuley Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Glenn Hunt Photographer
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=43501 or tblfeedback.strbusinessname='Glenn Hunt Photographer' or tblfeedback.strbusinessname='Glenn Hunt Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Princess Photography
Toowoomba QLD 4350
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=26243 or tblfeedback.strbusinessname='Princess Photography' or tblfeedback.strbusinessname='Princess Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Raw Design Media
Indooroopilly QLD 4068
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=27410 or tblfeedback.strbusinessname='Raw Design Media' or tblfeedback.strbusinessname='Raw Design Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Heli Weddings
Queenstown QLD 9300
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=29932 or tblfeedback.strbusinessname='Heli Weddings' or tblfeedback.strbusinessname='Heli Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Grace Ploetz
Plainland QLD 4341
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=41030 or tblfeedback.strbusinessname='Grace Ploetz' or tblfeedback.strbusinessname='Grace Ploetz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rochelle James Photography
Brightview QLD 4342
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=23601 or tblfeedback.strbusinessname='Rochelle James Photography' or tblfeedback.strbusinessname='Rochelle James Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Justin Ma
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=25864 or tblfeedback.strbusinessname='Justin Ma' or tblfeedback.strbusinessname='Justin Ma') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hannah Photography
Norman Park QLD 4170
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=26384 or tblfeedback.strbusinessname='Hannah Photography' or tblfeedback.strbusinessname='Hannah Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Turbulent Photography
Cleveland QLD 4163
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=24951 or tblfeedback.strbusinessname='Turbulent Photography' or tblfeedback.strbusinessname='Turbulent Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
JnS Photographics
Mount Gravatt East QLD 4112
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=21505 or tblfeedback.strbusinessname='JnS Photographics' or tblfeedback.strbusinessname='JnS Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Forever & More Collective
Scarborough QLD 4020
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=46406 or tblfeedback.strbusinessname='Forever &%%semi%% More Collective' or tblfeedback.strbusinessname='Forever & More Collective') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Matt Edwards Photography
Toowoomba QLD 4350
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=41591 or tblfeedback.strbusinessname='Matt Edwards Photography' or tblfeedback.strbusinessname='Matt Edwards Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Daisy and the Duke
Brisbane QLD 4101
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=24923 or tblfeedback.strbusinessname='Daisy and the Duke' or tblfeedback.strbusinessname='Daisy and the Duke') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Shae Estella Photo
Sunshine Coast QLD 4551
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=38126 or tblfeedback.strbusinessname='Shae Estella Photo' or tblfeedback.strbusinessname='Shae Estella Photo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Trish Anderson Photography
Samford QLD 4520
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=24962 or tblfeedback.strbusinessname='Trish Anderson Photography' or tblfeedback.strbusinessname='Trish Anderson Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Divine Studios Photography
Albion QLD 4010
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=38562 or tblfeedback.strbusinessname='Divine Studios Photography' or tblfeedback.strbusinessname='Divine Studios Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Romana Saeheng Photography
Thornlands QLD 4164
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=21537 or tblfeedback.strbusinessname='Romana Saeheng Photography' or tblfeedback.strbusinessname='Romana Saeheng Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Kwintowski Photography
Holland Park West QLD 4121
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=27197 or tblfeedback.strbusinessname='Kwintowski Photography' or tblfeedback.strbusinessname='Kwintowski Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Requelle Aiken Weddings
Spring Hill 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=45957 or tblfeedback.strbusinessname='Requelle Aiken Weddings' or tblfeedback.strbusinessname='Requelle Aiken Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Nakita Maree Photography
Ipswich QLD 4305
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=38272 or tblfeedback.strbusinessname='Nakita Maree Photography' or tblfeedback.strbusinessname='Nakita Maree Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Knight Photography
Brisbane QLD 4103
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=27931 or tblfeedback.strbusinessname='Knight Photography' or tblfeedback.strbusinessname='Knight Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lane Photo
Hermit Park QLD 4812
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=23982 or tblfeedback.strbusinessname='Lane Photo' or tblfeedback.strbusinessname='Lane Photo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lauren Olivia Photography
Redland Bay QLD 4165
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=27925 or tblfeedback.strbusinessname='Lauren Olivia Photography' or tblfeedback.strbusinessname='Lauren Olivia Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ben Yew
Como WA 6152
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=25844 or tblfeedback.strbusinessname='Ben Yew' or tblfeedback.strbusinessname='Ben Yew') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tim Harris Photography
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=33391 or tblfeedback.strbusinessname='Tim Harris Photography' or tblfeedback.strbusinessname='Tim Harris Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sage & Co Photography
Ipswich QLD 4300
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=45950 or tblfeedback.strbusinessname='Sage &%%semi%% Co Photography' or tblfeedback.strbusinessname='Sage & Co Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Evoke Studios
Springwood QLD 4127
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=19870 or tblfeedback.strbusinessname='Evoke Studios' or tblfeedback.strbusinessname='Evoke Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A & A Images
Victoria Point QLD 4165
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=29930 or tblfeedback.strbusinessname='A &%%semi%% A Images' or tblfeedback.strbusinessname='A & A Images') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Made For This
Toowoomba QLD 4350
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=25758 or tblfeedback.strbusinessname='Made For This' or tblfeedback.strbusinessname='Made For This') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Cordare photography
wilston QLD 4051
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=23350 or tblfeedback.strbusinessname='Cordare photography' or tblfeedback.strbusinessname='Cordare photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jeps Weddings
North Lakes QLD 4509
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=44085 or tblfeedback.strbusinessname='Jeps Weddings' or tblfeedback.strbusinessname='Jeps Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ivory and Rose Wedding Photography
Forest Lake QLD 4078
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=26550 or tblfeedback.strbusinessname='Ivory and Rose Wedding Photography' or tblfeedback.strbusinessname='Ivory and Rose Wedding 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