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.
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
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
Inc.mill Photography
Boonah 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='Inc.mill Photography' or tblfeedback.strbusinessname='Inc.mill Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Mattography
Brisbane QLD 4006
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=25785 or tblfeedback.strbusinessname='Mattography' or tblfeedback.strbusinessname='Mattography') 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
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
Kelsea K Photography
Springfield 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=27408 or tblfeedback.strbusinessname='Kelsea K Photography' or tblfeedback.strbusinessname='Kelsea K Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Soul Echo
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=41100 or tblfeedback.strbusinessname='The Soul Echo' or tblfeedback.strbusinessname='The Soul Echo') 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
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
Studio SW19
Brisbane QLD 4017
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=35854 or tblfeedback.strbusinessname='Studio SW19' or tblfeedback.strbusinessname='Studio SW19') 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
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
George Bowden
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=38460 or tblfeedback.strbusinessname='George Bowden' or tblfeedback.strbusinessname='George Bowden') 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
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
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
Linda Pasfield Photographer
Eagle Heights QLD 4271
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=16381 or tblfeedback.strbusinessname='Linda Pasfield Photographer' or tblfeedback.strbusinessname='Linda Pasfield Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
KCL 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=26216 or tblfeedback.strbusinessname='KCL Photography' or tblfeedback.strbusinessname='KCL 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
Tenille 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='Tenille Fink Photography' or tblfeedback.strbusinessname='Tenille Fink 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
Blueberry Skies Photography
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=27494 or tblfeedback.strbusinessname='Blueberry Skies Photography' or tblfeedback.strbusinessname='Blueberry Skies Photography') 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
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
Divine Studios
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' or tblfeedback.strbusinessname='Divine Studios') 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
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
Unveil Films and Photography
Brisbane 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=38176 or tblfeedback.strbusinessname='Unveil Films and Photography' or tblfeedback.strbusinessname='Unveil Films and Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
All The Love In The World Photography
Maroochydore QLD 4458
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=23525 or tblfeedback.strbusinessname='All The Love In The World Photography' or tblfeedback.strbusinessname='All The Love In The World Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Alcorn Images
Stafford QLD 4053
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=36359 or tblfeedback.strbusinessname='Alcorn Images' or tblfeedback.strbusinessname='Alcorn Images') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Talitha Rice
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=24431 or tblfeedback.strbusinessname='Talitha Rice' or tblfeedback.strbusinessname='Talitha Rice') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sneaky 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=29712 or tblfeedback.strbusinessname='Sneaky Photography' or tblfeedback.strbusinessname='Sneaky Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Von Maedler Photography
Keperra QLD 4055
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=27810 or tblfeedback.strbusinessname='Von Maedler Photography' or tblfeedback.strbusinessname='Von Maedler Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ben and Hope Photography
Tarraginidi 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=23036 or tblfeedback.strbusinessname='Ben and Hope Photography' or tblfeedback.strbusinessname='Ben and Hope 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
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
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
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
Inexpensive Wedding 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=26320 or tblfeedback.strbusinessname='Inexpensive Wedding Photography' or tblfeedback.strbusinessname='Inexpensive Wedding 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
Dale Wowk
Canberra ACT 2607
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=26372 or tblfeedback.strbusinessname='Dale Wowk' or tblfeedback.strbusinessname='Dale Wowk') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sophie Baker Photography
Tamborine Mountain QLD 4272
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=23122 or tblfeedback.strbusinessname='Sophie Baker Photography' or tblfeedback.strbusinessname='Sophie Baker Photography') 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
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
