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.
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
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
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
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
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
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
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
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
By ebony
Burpengary QLD 4054
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=46324 or tblfeedback.strbusinessname='By ebony' or tblfeedback.strbusinessname='By ebony') 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
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
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
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
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
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
Ivory + Rose 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=37754 or tblfeedback.strbusinessname='Ivory +%%semi%% Rose Photography' or tblfeedback.strbusinessname='Ivory + Rose Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Linda Pasfield Photography
Beauty Point TAS 7270
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=38204 or tblfeedback.strbusinessname='Linda Pasfield Photography' or tblfeedback.strbusinessname='Linda Pasfield 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
Yoko's 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=38229 or tblfeedback.strbusinessname='Yoko'%%semi%%s Photography' or tblfeedback.strbusinessname='Yoko's Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Milque Photography & Films
Fortitude Valley 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=23925 or tblfeedback.strbusinessname='Milque Photography & Films' or tblfeedback.strbusinessname='Milque Photography & Films') 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
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
Alison Cooke Photography
Lawnton QLD 4501
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=2737 or tblfeedback.strbusinessname='Alison Cooke Photography' or tblfeedback.strbusinessname='Alison Cooke 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
Soda Photography
Brisbane QLD 4011
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=25947 or tblfeedback.strbusinessname='Soda Photography' or tblfeedback.strbusinessname='Soda Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bernadette Rose Photography
Manly West 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=44208 or tblfeedback.strbusinessname='Bernadette Rose Photography' or tblfeedback.strbusinessname='Bernadette Rose Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Zen Photography Qld
Sunshine Coast QLD 4560
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=45838 or tblfeedback.strbusinessname='Zen Photography Qld' or tblfeedback.strbusinessname='Zen Photography Qld') 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
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
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
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
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
Jeps Weddings
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=44085 or tblfeedback.strbusinessname='Jeps Weddings' or tblfeedback.strbusinessname='Jeps Weddings') 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
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
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
Flipside Concepts
Taromeo 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=37585 or tblfeedback.strbusinessname='Flipside Concepts' or tblfeedback.strbusinessname='Flipside Concepts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Juliette Lichman Photography
Sydney NSW 2000
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=26160 or tblfeedback.strbusinessname='Juliette Lichman Photography' or tblfeedback.strbusinessname='Juliette Lichman Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
DHC Photography
Wynnum QLD 4178
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=36320 or tblfeedback.strbusinessname='DHC Photography' or tblfeedback.strbusinessname='DHC 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
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
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
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