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.
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
MMG Photo & Cinema Brisbane QLD
Stones Corner QLD 4210
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=29620 or tblfeedback.strbusinessname='MMG Photo &%%semi%% Cinema Brisbane QLD' or tblfeedback.strbusinessname='MMG Photo & Cinema Brisbane QLD') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
John Pryke Photographer
Brisbne 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=39815 or tblfeedback.strbusinessname='John Pryke Photographer' or tblfeedback.strbusinessname='John Pryke Photographer') 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
Lens of Liane
Greenslopes QLD 4120
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=46011 or tblfeedback.strbusinessname='Lens of Liane' or tblfeedback.strbusinessname='Lens of Liane') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Steve Doyle 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=27563 or tblfeedback.strbusinessname='Steve Doyle Photography' or tblfeedback.strbusinessname='Steve Doyle 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
Florido Weddings
Willston 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=44283 or tblfeedback.strbusinessname='Florido Weddings' or tblfeedback.strbusinessname='Florido Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The New Life Collective
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=46578 or tblfeedback.strbusinessname='The New Life Collective' or tblfeedback.strbusinessname='The New Life Collective') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
NAK Photography
Coorparoo QLD 4151
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=27037 or tblfeedback.strbusinessname='NAK Photography' or tblfeedback.strbusinessname='NAK Photography') 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
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
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
Janice J Photography
Gympie QLD 4570
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=27182 or tblfeedback.strbusinessname='Janice J Photography' or tblfeedback.strbusinessname='Janice J Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Starlight productions
Toowong QLD 4066
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=22695 or tblfeedback.strbusinessname='Starlight productions' or tblfeedback.strbusinessname='Starlight productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Salt Studios
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=26576 or tblfeedback.strbusinessname='Salt Studios' or tblfeedback.strbusinessname='Salt Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tennille Fink Photography
Nundah QLD 4013
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=26975 or tblfeedback.strbusinessname='Tennille Fink Photography' or tblfeedback.strbusinessname='Tennille Fink 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
Always and Forever Wedding Photography
Blackbutt QLD 4314
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=39784 or tblfeedback.strbusinessname='Always and Forever Wedding Photography' or tblfeedback.strbusinessname='Always and Forever Wedding Photography') 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
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
Trent and Jessie photography and videography
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=44345 or tblfeedback.strbusinessname='Trent and Jessie photography and videography' or tblfeedback.strbusinessname='Trent and Jessie photography and videography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Willidea Studio
Calamvale QLD 4116
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=24274 or tblfeedback.strbusinessname='Willidea Studio' or tblfeedback.strbusinessname='Willidea Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bayleigh Vedelago - 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=22968 or tblfeedback.strbusinessname='Bayleigh Vedelago - Photographer' or tblfeedback.strbusinessname='Bayleigh Vedelago - Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lara Lane 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=29897 or tblfeedback.strbusinessname='Lara Lane Photography' or tblfeedback.strbusinessname='Lara Lane 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
Dan Vonhoff
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=37468 or tblfeedback.strbusinessname='Dan Vonhoff' or tblfeedback.strbusinessname='Dan Vonhoff') 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
Mac Loxton
Annerley 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=37900 or tblfeedback.strbusinessname='Mac Loxton' or tblfeedback.strbusinessname='Mac Loxton') 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
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
Moffatt Photography
Springfield Lakes 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=25730 or tblfeedback.strbusinessname='Moffatt Photography' or tblfeedback.strbusinessname='Moffatt Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Will & Manni
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=29049 or tblfeedback.strbusinessname='Will &%%semi%% Manni' or tblfeedback.strbusinessname='Will & Manni') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Photography2envy
Birkdale QLD 4159
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=41233 or tblfeedback.strbusinessname='Photography2envy' or tblfeedback.strbusinessname='Photography2envy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
NSI Productions
Burleigh Heads QLD 4220
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=27799 or tblfeedback.strbusinessname='NSI Productions' or tblfeedback.strbusinessname='NSI Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hawthorne Creative Media
Daisy Hill 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=46362 or tblfeedback.strbusinessname='Hawthorne Creative Media' or tblfeedback.strbusinessname='Hawthorne Creative Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jessica Heath 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=39868 or tblfeedback.strbusinessname='Jessica Heath Photography' or tblfeedback.strbusinessname='Jessica Heath Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Allure 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=27481 or tblfeedback.strbusinessname='Allure Photography' or tblfeedback.strbusinessname='Allure Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Inspired Focus 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=39908 or tblfeedback.strbusinessname='Inspired Focus Photography' or tblfeedback.strbusinessname='Inspired Focus Photography') 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
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
In the Booth
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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
J'Adore Wedding Films & Photography
Gold Coast 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=22885 or tblfeedback.strbusinessname='J''Adore Wedding Films & Photography' or tblfeedback.strbusinessname='J''Adore Wedding Films & Photography') 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
JC Photography
Woombye QLD 4559
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=31513 or tblfeedback.strbusinessname='JC Photography' or tblfeedback.strbusinessname='JC Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15