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.
Emot Wedding Photography and Videography
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=43530 or tblfeedback.strbusinessname='Emot Wedding Photography and Videography' or tblfeedback.strbusinessname='Emot Wedding Photography and Videography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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.
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.
Kerri Vankuyck Photography
Regents Park QLD 4118
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=39682 or tblfeedback.strbusinessname='Kerri Vankuyck Photography' or tblfeedback.strbusinessname='Kerri Vankuyck Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Brittany Jayne Photography
Warwick QLD 4370
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=38546 or tblfeedback.strbusinessname='Brittany Jayne Photography' or tblfeedback.strbusinessname='Brittany Jayne Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sue Reilly Photography
Brisbane QLD 4069
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=25313 or tblfeedback.strbusinessname='Sue Reilly Photography' or tblfeedback.strbusinessname='Sue Reilly Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
White Parrot 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=38614 or tblfeedback.strbusinessname='White Parrot Photography' or tblfeedback.strbusinessname='White Parrot Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Nikki Blades Photography
Wellington Point QLD 4160
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=19775 or tblfeedback.strbusinessname='Nikki Blades Photography' or tblfeedback.strbusinessname='Nikki Blades Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bee Yourself Photography
Warwick QLD 4370
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=38261 or tblfeedback.strbusinessname='Bee Yourself Photography' or tblfeedback.strbusinessname='Bee Yourself Photography') 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
Talitha Rice 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=26284 or tblfeedback.strbusinessname='Talitha Rice Photography' or tblfeedback.strbusinessname='Talitha Rice Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Madelyn Holmes Photographics
Frenchville QLD 4701
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=26616 or tblfeedback.strbusinessname='Madelyn Holmes Photographics' or tblfeedback.strbusinessname='Madelyn Holmes Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ben Clark Photography
Enogera 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=26537 or tblfeedback.strbusinessname='Ben Clark Photography' or tblfeedback.strbusinessname='Ben Clark Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sheona Beach Photography
The Gap QLD 4061
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=29856 or tblfeedback.strbusinessname='Sheona Beach Photography' or tblfeedback.strbusinessname='Sheona Beach Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Little Media
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=43160 or tblfeedback.strbusinessname='Little Media' or tblfeedback.strbusinessname='Little Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Everlast Studios
Rothwell QLD 4022
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=23269 or tblfeedback.strbusinessname='Everlast Studios' or tblfeedback.strbusinessname='Everlast Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Deezigner Images
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=27901 or tblfeedback.strbusinessname='Deezigner Images' or tblfeedback.strbusinessname='Deezigner Images') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Papillon Studio
Alexandra Hills QLD 4161
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=16442 or tblfeedback.strbusinessname='Papillon Studio' or tblfeedback.strbusinessname='Papillon Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Figtree Wedding Photography
Casuarina NSW 2487
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=22005 or tblfeedback.strbusinessname='Figtree Wedding Photography' or tblfeedback.strbusinessname='Figtree Wedding Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ethereal 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=35678 or tblfeedback.strbusinessname='Ethereal Photography' or tblfeedback.strbusinessname='Ethereal 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
Pelizzari Photography and Film
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=23644 or tblfeedback.strbusinessname='Pelizzari Photography and Film' or tblfeedback.strbusinessname='Pelizzari Photography and Film') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Shutter and Lace
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=26895 or tblfeedback.strbusinessname='Shutter and Lace' or tblfeedback.strbusinessname='Shutter and Lace') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
About Time Co
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=43200 or tblfeedback.strbusinessname='About Time Co' or tblfeedback.strbusinessname='About Time Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Phoebe Hofsteede
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=26388 or tblfeedback.strbusinessname='Phoebe Hofsteede' or tblfeedback.strbusinessname='Phoebe Hofsteede') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Weddings with James
Brisbane QLD 4152
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=38411 or tblfeedback.strbusinessname='Weddings with James' or tblfeedback.strbusinessname='Weddings with James') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Brides best friends photography
Gold Coast QLD 4209
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=38541 or tblfeedback.strbusinessname='Brides best friends photography' or tblfeedback.strbusinessname='Brides best friends photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kat Cherry
Cotswold Hills 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=38001 or tblfeedback.strbusinessname='Kat Cherry' or tblfeedback.strbusinessname='Kat Cherry') 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
Chantal Brennan Photography
Brisbane QLD 4131
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=25343 or tblfeedback.strbusinessname='Chantal Brennan Photography' or tblfeedback.strbusinessname='Chantal Brennan Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Artography
Peachester QLD 4519
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=2757 or tblfeedback.strbusinessname='Artography' or tblfeedback.strbusinessname='Artography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Katrina Lehman Photography
Charleville QLD 4470
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=26661 or tblfeedback.strbusinessname='Katrina Lehman Photography' or tblfeedback.strbusinessname='Katrina Lehman 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
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
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
Storyteller Films
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=38430 or tblfeedback.strbusinessname='Storyteller Films' or tblfeedback.strbusinessname='Storyteller Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Samantha Bennett Photography
Warwick QLD 4370
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=27435 or tblfeedback.strbusinessname='Samantha Bennett Photography' or tblfeedback.strbusinessname='Samantha Bennett 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
Nicola Lemmon 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=21510 or tblfeedback.strbusinessname='Nicola Lemmon Photography' or tblfeedback.strbusinessname='Nicola Lemmon 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
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
Incmill Photography
Moogerah QLD 4309
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=38189 or tblfeedback.strbusinessname='Incmill Photography' or tblfeedback.strbusinessname='Incmill Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ivy & Pine
Brisbane QLD 4118
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=25238 or tblfeedback.strbusinessname='Ivy &%%semi%% Pine' or tblfeedback.strbusinessname='Ivy & Pine') 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
Serenity 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=27345 or tblfeedback.strbusinessname='Serenity Photography' or tblfeedback.strbusinessname='Serenity Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Blackpalm collective
Gold Coast & 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=43969 or tblfeedback.strbusinessname='Blackpalm collective' or tblfeedback.strbusinessname='Blackpalm collective') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
NAK 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=27441 or tblfeedback.strbusinessname='NAK Photography' or tblfeedback.strbusinessname='NAK Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15