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.
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.
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.
Kerri McAuley Photography
Moggill QLD 4070
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=44569 or tblfeedback.strbusinessname='Kerri McAuley Photography' or tblfeedback.strbusinessname='Kerri McAuley 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
Perspectives Photo + Cinema
Auckland 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=29290 or tblfeedback.strbusinessname='Perspectives Photo +%%semi%% Cinema' or tblfeedback.strbusinessname='Perspectives Photo + Cinema') 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
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
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
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
Madelyn Holmes Photographics
Frenchville QLD 4701
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=26616 or tblfeedback.strbusinessname='Madelyn Holmes Photographics' or tblfeedback.strbusinessname='Madelyn Holmes Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Manuel Brandao
Brisbane QLD 4005
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=46536 or tblfeedback.strbusinessname='Manuel Brandao' or tblfeedback.strbusinessname='Manuel Brandao') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Glenn Hunt 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=43501 or tblfeedback.strbusinessname='Glenn Hunt Photographer' or tblfeedback.strbusinessname='Glenn Hunt Photographer') 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
Photography by Zee
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=46318 or tblfeedback.strbusinessname='Photography by Zee' or tblfeedback.strbusinessname='Photography by Zee') 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
Blackpalm collective
Gold Coast & 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=43969 or tblfeedback.strbusinessname='Blackpalm collective' or tblfeedback.strbusinessname='Blackpalm collective') 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
J'Adore Wedding Films & Photography
Gold Coast 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=22885 or tblfeedback.strbusinessname='J''Adore Wedding Films & Photography' or tblfeedback.strbusinessname='J''Adore Wedding Films & 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
Bernadette Draffin Photography
Moggill QLD 4070
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=21313 or tblfeedback.strbusinessname='Bernadette Draffin Photography' or tblfeedback.strbusinessname='Bernadette Draffin 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
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
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
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
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
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
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
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
Rochelle James Photography
Brightview QLD 4342
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=23601 or tblfeedback.strbusinessname='Rochelle James Photography' or tblfeedback.strbusinessname='Rochelle James Photography') 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
Evernew Studio
Coopers Plain QLD 4108
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=21926 or tblfeedback.strbusinessname='Evernew Studio' or tblfeedback.strbusinessname='Evernew Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jaques & Co 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=44583 or tblfeedback.strbusinessname='Jaques &%%semi%% Co Photography' or tblfeedback.strbusinessname='Jaques & Co Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Daniel Neucom Photography
Eagleby 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=43336 or tblfeedback.strbusinessname='Daniel Neucom Photography' or tblfeedback.strbusinessname='Daniel Neucom Photography') 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
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
Mick Porter
East Brisbane QLD 4169
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=26005 or tblfeedback.strbusinessname='Mick Porter' or tblfeedback.strbusinessname='Mick Porter') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Shae Estella Photo
Sunshine Coast QLD 4551
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=38126 or tblfeedback.strbusinessname='Shae Estella Photo' or tblfeedback.strbusinessname='Shae Estella Photo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kate Wall
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=26953 or tblfeedback.strbusinessname='Kate Wall' or tblfeedback.strbusinessname='Kate Wall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Serenity 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=27345 or tblfeedback.strbusinessname='Serenity Photography' or tblfeedback.strbusinessname='Serenity 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
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
NAK 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=27441 or tblfeedback.strbusinessname='NAK Photography' or tblfeedback.strbusinessname='NAK Photography') 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
Precious Moments 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=29223 or tblfeedback.strbusinessname='Precious Moments Photography' or tblfeedback.strbusinessname='Precious Moments Photography') 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
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