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.
Storyteller 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=38430 or tblfeedback.strbusinessname='Storyteller Films' or tblfeedback.strbusinessname='Storyteller Films') 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
Studio Present
Southport 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=37511 or tblfeedback.strbusinessname='Studio Present' or tblfeedback.strbusinessname='Studio Present') 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
Papillon Studio
Alexandra Hills QLD 4161
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=16442 or tblfeedback.strbusinessname='Papillon Studio' or tblfeedback.strbusinessname='Papillon Studio') 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
Cherished Studios
Wilsonton Heights 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=29149 or tblfeedback.strbusinessname='Cherished Studios' or tblfeedback.strbusinessname='Cherished Studios') 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
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
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
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
Kerry Bergman Photographer
Edens Landing QLD 4207
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=35785 or tblfeedback.strbusinessname='Kerry Bergman Photographer' or tblfeedback.strbusinessname='Kerry Bergman Photographer') 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
Grace Ploetz
Plainland QLD 4341
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=41030 or tblfeedback.strbusinessname='Grace Ploetz' or tblfeedback.strbusinessname='Grace Ploetz') 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
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
Helen McConnell 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=26677 or tblfeedback.strbusinessname='Helen McConnell Photography' or tblfeedback.strbusinessname='Helen McConnell Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Picrama
Pinjarra Hills 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=35566 or tblfeedback.strbusinessname='Picrama' or tblfeedback.strbusinessname='Picrama') 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
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
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
Mayers Photography
Harristown 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=35769 or tblfeedback.strbusinessname='Mayers Photography' or tblfeedback.strbusinessname='Mayers 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
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=29045 or tblfeedback.strbusinessname='Ethereal Photography' or tblfeedback.strbusinessname='Ethereal Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Elope Australia
Mornington Peninsula VIC 3944
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=46401 or tblfeedback.strbusinessname='Elope Australia' or tblfeedback.strbusinessname='Elope Australia') 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
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
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
Qualis Photography
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=26453 or tblfeedback.strbusinessname='Qualis Photography' or tblfeedback.strbusinessname='Qualis 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
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
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
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
Jashan Photography
Upper Coomera 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=37436 or tblfeedback.strbusinessname='Jashan Photography' or tblfeedback.strbusinessname='Jashan Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Artography
Peachester QLD 4519
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=2757 or tblfeedback.strbusinessname='Artography' or tblfeedback.strbusinessname='Artography') 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
Light Pictures
Byron Bay NSW 2481
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=27241 or tblfeedback.strbusinessname='Light Pictures' or tblfeedback.strbusinessname='Light Pictures') 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
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
Justin Ma
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=25864 or tblfeedback.strbusinessname='Justin Ma' or tblfeedback.strbusinessname='Justin Ma') 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
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
Aleisha Edwards Weddings
Fortitude Valley 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=46875 or tblfeedback.strbusinessname='Aleisha Edwards Weddings' or tblfeedback.strbusinessname='Aleisha Edwards Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Andy Kennedy Photography
Jimboomba QLD 4280
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=44384 or tblfeedback.strbusinessname='Andy Kennedy Photography' or tblfeedback.strbusinessname='Andy Kennedy Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ingrid Coles 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=46298 or tblfeedback.strbusinessname='Ingrid Coles Photography' or tblfeedback.strbusinessname='Ingrid Coles Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
View Your Favorites List