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.
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
Richard Grainger
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=27176 or tblfeedback.strbusinessname='Richard Grainger' or tblfeedback.strbusinessname='Richard Grainger') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Matt Beale
Capalaba QLD 4157
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=26709 or tblfeedback.strbusinessname='Matt Beale' or tblfeedback.strbusinessname='Matt Beale') 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
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
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
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
Eli Samuelu
Ashgrove QLD 4060
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=26989 or tblfeedback.strbusinessname='Eli Samuelu' or tblfeedback.strbusinessname='Eli Samuelu') 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
Nicola Brander Photography
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=29437 or tblfeedback.strbusinessname='Nicola Brander Photography' or tblfeedback.strbusinessname='Nicola Brander Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lilyfern 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=21302 or tblfeedback.strbusinessname='Lilyfern Photography' or tblfeedback.strbusinessname='Lilyfern Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Puremotion Studio
Holland Park 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=41169 or tblfeedback.strbusinessname='Puremotion Studio' or tblfeedback.strbusinessname='Puremotion Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jess Marks Photography
Brisbane QLD 4012
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=39864 or tblfeedback.strbusinessname='Jess Marks Photography' or tblfeedback.strbusinessname='Jess Marks 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
Matthew Eastgate 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=29632 or tblfeedback.strbusinessname='Matthew Eastgate Photography' or tblfeedback.strbusinessname='Matthew Eastgate Photography') 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
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
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
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
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
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
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
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
Emma Cleary
New york 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=24202 or tblfeedback.strbusinessname='Emma Cleary' or tblfeedback.strbusinessname='Emma Cleary') 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
Nevermist 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=42937 or tblfeedback.strbusinessname='Nevermist Photography' or tblfeedback.strbusinessname='Nevermist Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Studio SW19 Wedding Photography
Sandgate QLD 4027
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=25446 or tblfeedback.strbusinessname='Studio SW19 Wedding Photography' or tblfeedback.strbusinessname='Studio SW19 Wedding Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Leigh Warner Photography
Varsity Lakes QLD 4227
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=21027 or tblfeedback.strbusinessname='Leigh Warner Photography' or tblfeedback.strbusinessname='Leigh Warner Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Carrot Patch Photography
Morayfield QLD 4506
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=44503 or tblfeedback.strbusinessname='Carrot Patch Photography' or tblfeedback.strbusinessname='Carrot Patch Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Gavin Field 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=24975 or tblfeedback.strbusinessname='Gavin Field Photography' or tblfeedback.strbusinessname='Gavin Field Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jessica Nichols Photography
Blackbutt QLD 4306
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=21338 or tblfeedback.strbusinessname='Jessica Nichols Photography' or tblfeedback.strbusinessname='Jessica Nichols Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Robinson Creative
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=36066 or tblfeedback.strbusinessname='Robinson Creative' or tblfeedback.strbusinessname='Robinson Creative') 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
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
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
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
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
One Stop Wedding Shop
Brendale QLD 4500
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=27813 or tblfeedback.strbusinessname='One Stop Wedding Shop' or tblfeedback.strbusinessname='One Stop Wedding Shop') 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
Dan Vonhoff 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=41366 or tblfeedback.strbusinessname='Dan Vonhoff Photography' or tblfeedback.strbusinessname='Dan Vonhoff 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
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
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
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