Tracy Vagg Photographer
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=41721 or tblfeedback.strbusinessname='Tracy Vagg Photographer' or tblfeedback.strbusinessname='Tracy Vagg Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Photographer of the 2020 Bride of the Year!!
Tracy Vagg, family, lifestyle and wedding photographer based in beautiful Hobart, Tasmania.
Angelea Galloway 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=21557 or tblfeedback.strbusinessname='Angelea Galloway Photography' or tblfeedback.strbusinessname='Angelea Galloway Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Photographer in Sorell, Tasmania
Expose Photograpy
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=21920 or tblfeedback.strbusinessname='Expose Photograpy' or tblfeedback.strbusinessname='Expose Photograpy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A fun, friendly experience, with your photographer
Life Style Images by Alexandra Grimshaw
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=24458 or tblfeedback.strbusinessname='Life Style Images by Alexandra Grimshaw' or tblfeedback.strbusinessname='Life Style Images by Alexandra Grimshaw') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Artistic and classical styles with a photojournalistic edge
Scott Donovan 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=25007 or tblfeedback.strbusinessname='Scott Donovan Photography' or tblfeedback.strbusinessname='Scott Donovan Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Considerable experience in wedding photography
Tony Lomas Island 26 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=24719 or tblfeedback.strbusinessname='Tony Lomas Island 26 Photography' or tblfeedback.strbusinessname='Tony Lomas Island 26 Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Capturing the events of your "big day" is what I love to do
Sophie Sullivan 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=24436 or tblfeedback.strbusinessname='Sophie Sullivan Photography' or tblfeedback.strbusinessname='Sophie Sullivan Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A journey that will include countless stories
Island Image
Hobart TAS 7000
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=46712 or tblfeedback.strbusinessname='Island Image' or tblfeedback.strbusinessname='Island Image') 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
Edward Noel Photo
Hobart TAS 7009
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=44687 or tblfeedback.strbusinessname='Edward Noel Photo' or tblfeedback.strbusinessname='Edward Noel Photo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
JMI Photography
St Helens TAS 7216
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=44309 or tblfeedback.strbusinessname='JMI Photography' or tblfeedback.strbusinessname='JMI Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jon Gazzignato Photographer
Hobart TAS 7004
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=41659 or tblfeedback.strbusinessname='Jon Gazzignato Photographer' or tblfeedback.strbusinessname='Jon Gazzignato Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Fred & Hannah
Hobart TAS 7000
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=21835 or tblfeedback.strbusinessname='Fred &%%semi%% Hannah' or tblfeedback.strbusinessname='Fred & Hannah') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sarah Ryan Photography
Hobart TAS 7000
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=27855 or tblfeedback.strbusinessname='Sarah Ryan Photography' or tblfeedback.strbusinessname='Sarah Ryan Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jennifer Skabo - Love Jennifer
Hobart TAS 7018
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=21521 or tblfeedback.strbusinessname='Jennifer Skabo - Love Jennifer' or tblfeedback.strbusinessname='Jennifer Skabo - Love Jennifer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Dahria Smith Photography
Glenorchy TAS 7010
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=35649 or tblfeedback.strbusinessname='Dahria Smith Photography' or tblfeedback.strbusinessname='Dahria Smith Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lifestyle Images Photography
Kingston TAS 7051
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=35164 or tblfeedback.strbusinessname='Lifestyle Images Photography' or tblfeedback.strbusinessname='Lifestyle Images 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
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
Weddings by Wittle White Wolf Photography
Hobart TAS 7000
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=24934 or tblfeedback.strbusinessname='Weddings by Wittle White Wolf Photography' or tblfeedback.strbusinessname='Weddings by Wittle White Wolf Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wilkography
Hobart TAS 7000
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=27632 or tblfeedback.strbusinessname='Wilkography' or tblfeedback.strbusinessname='Wilkography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Adam Gibson Photographer
Lindisfarne TAS 7015
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=37877 or tblfeedback.strbusinessname='Adam Gibson Photographer' or tblfeedback.strbusinessname='Adam Gibson Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Joelle Beekman Photography
Hobart TAS 7000
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=43162 or tblfeedback.strbusinessname='Joelle Beekman Photography' or tblfeedback.strbusinessname='Joelle Beekman Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Aimee Johns Photography
Montrose TAS 7010
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=25759 or tblfeedback.strbusinessname='Aimee Johns Photography' or tblfeedback.strbusinessname='Aimee Johns Photography') 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
Love Jennifer Photography
Tramere TAS 7017
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=24731 or tblfeedback.strbusinessname='Love Jennifer Photography' or tblfeedback.strbusinessname='Love Jennifer Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rose Hastie Weddings
Hobart TAS 7000
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=37801 or tblfeedback.strbusinessname='Rose Hastie Weddings' or tblfeedback.strbusinessname='Rose Hastie Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jon Jarvela Photography
Hobart QLD 7000
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=16348 or tblfeedback.strbusinessname='Jon Jarvela Photography' or tblfeedback.strbusinessname='Jon Jarvela Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Smile and Keep
Hobart TAS 7000
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=27771 or tblfeedback.strbusinessname='Smile and Keep' or tblfeedback.strbusinessname='Smile and Keep') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
By the Wilde
Hobart TAS 7000
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=46016 or tblfeedback.strbusinessname='By the Wilde' or tblfeedback.strbusinessname='By the Wilde') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Eliza Beer
Sandford TAS 7020
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=43809 or tblfeedback.strbusinessname='Eliza Beer' or tblfeedback.strbusinessname='Eliza Beer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rosie Hastie
Hobart TAS 7000
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=27683 or tblfeedback.strbusinessname='Rosie Hastie' or tblfeedback.strbusinessname='Rosie Hastie') 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
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
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
Sarah Eliza Photography
Hobart TAS 7000
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=27691 or tblfeedback.strbusinessname='Sarah Eliza Photography' or tblfeedback.strbusinessname='Sarah Eliza Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Fiona Vail Photography
Hobart TAS 7000
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=37557 or tblfeedback.strbusinessname='Fiona Vail Photography' or tblfeedback.strbusinessname='Fiona Vail Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
LU & LO - Wedding & Elopement Photography
Hobart TAS 7173
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=43380 or tblfeedback.strbusinessname='LU &%%semi%% LO - Wedding &%%semi%% Elopement Photography' or tblfeedback.strbusinessname='LU & LO - Wedding & Elopement Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Zara Maree Photography
Glenorchy TAS 7010
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=46830 or tblfeedback.strbusinessname='Zara Maree Photography' or tblfeedback.strbusinessname='Zara Maree Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Graziano Di Martino
Hobart TAS 7000
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=41513 or tblfeedback.strbusinessname='Graziano Di Martino' or tblfeedback.strbusinessname='Graziano Di Martino') 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
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
Jess Oakenfull - Wedding Photographer
Rokeby TAS 7019
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=46897 or tblfeedback.strbusinessname='Jess Oakenfull - Wedding Photographer' or tblfeedback.strbusinessname='Jess Oakenfull - Wedding Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Alison Cosker 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=22443 or tblfeedback.strbusinessname='Alison Cosker Photography' or tblfeedback.strbusinessname='Alison Cosker Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ali Davis Photography
Howrah TAS 7018
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=36245 or tblfeedback.strbusinessname='Ali Davis Photography' or tblfeedback.strbusinessname='Ali Davis Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Fat Monkey Media
Hobart TAS 7000
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=35545 or tblfeedback.strbusinessname='Fat Monkey Media' or tblfeedback.strbusinessname='Fat Monkey Media') 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
Randolph Reyes Photography
Chigwell TAS 7011
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=44718 or tblfeedback.strbusinessname='Randolph Reyes Photography' or tblfeedback.strbusinessname='Randolph Reyes Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
White Fox Photography
Hobart TAS 7000
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=44676 or tblfeedback.strbusinessname='White Fox Photography' or tblfeedback.strbusinessname='White Fox Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Billy Button Photography (Naomi)
Geeveston TAS 7116
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=46724 or tblfeedback.strbusinessname='Billy Button Photography (%%semi%%Naomi)%%semi%%' or tblfeedback.strbusinessname='Billy Button Photography (Naomi)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15