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.
Foy and Co 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=35553 or tblfeedback.strbusinessname='Foy and Co Photography' or tblfeedback.strbusinessname='Foy and Co 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
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
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
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
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
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
Oakman 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=26312 or tblfeedback.strbusinessname='Oakman Photography' or tblfeedback.strbusinessname='Oakman 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
Tom Hall Photography
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=27774 or tblfeedback.strbusinessname='Tom Hall Photography' or tblfeedback.strbusinessname='Tom Hall Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Cloud Catcher Studio
Brisbane 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=27909 or tblfeedback.strbusinessname='Cloud Catcher Studio' or tblfeedback.strbusinessname='Cloud Catcher Studio') 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
Kayla Temple
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=29655 or tblfeedback.strbusinessname='Kayla Temple' or tblfeedback.strbusinessname='Kayla Temple') 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
Kelly Marie Photography
Brisbane 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=25633 or tblfeedback.strbusinessname='Kelly Marie Photography' or tblfeedback.strbusinessname='Kelly Marie Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Nick Murray Photography
Manly QLD 4179
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=29483 or tblfeedback.strbusinessname='Nick Murray Photography' or tblfeedback.strbusinessname='Nick Murray Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Alicia Abbott
Ormeau QLD 4208
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=37403 or tblfeedback.strbusinessname='Alicia Abbott' or tblfeedback.strbusinessname='Alicia Abbott') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Quince and Mulberry Studios
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=26821 or tblfeedback.strbusinessname='Quince and Mulberry Studios' or tblfeedback.strbusinessname='Quince and Mulberry Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Serenity Photography Studios
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=35631 or tblfeedback.strbusinessname='Serenity Photography Studios' or tblfeedback.strbusinessname='Serenity Photography Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Unveil 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=26817 or tblfeedback.strbusinessname='Unveil Films' or tblfeedback.strbusinessname='Unveil Films') 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
Evelina Photography
Newstead 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=29120 or tblfeedback.strbusinessname='Evelina Photography' or tblfeedback.strbusinessname='Evelina Photography') 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
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
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
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
Peppermint 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=38483 or tblfeedback.strbusinessname='Peppermint Photography' or tblfeedback.strbusinessname='Peppermint 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
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
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
D&M Moments 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=41274 or tblfeedback.strbusinessname='D&%%semi%%M Moments Photography' or tblfeedback.strbusinessname='D&M Moments 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
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
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
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
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
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
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
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
Harsant 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=38247 or tblfeedback.strbusinessname='Harsant Photography' or tblfeedback.strbusinessname='Harsant Photography') 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
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
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
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
LM Images Photography and Film
Whiteside QLD 4503
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=25407 or tblfeedback.strbusinessname='LM Images Photography and Film' or tblfeedback.strbusinessname='LM Images Photography and Film') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15