Vicki Miller 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=23724 or tblfeedback.strbusinessname='Vicki Miller Photography' or tblfeedback.strbusinessname='Vicki Miller Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A Sunchasing, Visual Storyteller, with a love for the country lifestyle & all the moments in life
MaryAnne Law 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=18819 or tblfeedback.strbusinessname='MaryAnne Law Photography' or tblfeedback.strbusinessname='MaryAnne Law Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Professionalism, attention to detail and local knowledge are the key elements that make my wedding photography unique. Personalised to your individual needs to create a special record of your special day. Creating photographs that you will treasure forever.
Posh 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=19520 or tblfeedback.strbusinessname='Posh Photography' or tblfeedback.strbusinessname='Posh Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The very best in natural photography.
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
Peppermint Lane Photo & Film
Smithfield QLD 4878
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=29242 or tblfeedback.strbusinessname='Peppermint Lane Photo & Film' or tblfeedback.strbusinessname='Peppermint Lane Photo & Film') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sally Batt Photography
Millchester QLD 4820
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=44271 or tblfeedback.strbusinessname='Sally Batt Photography' or tblfeedback.strbusinessname='Sally Batt Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Robert Blauw Photography
Yorkeys Knob QLD 4878
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=29590 or tblfeedback.strbusinessname='Robert Blauw Photography' or tblfeedback.strbusinessname='Robert Blauw Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Madison Magatelli Photography
Townsville QLD 4810
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=41108 or tblfeedback.strbusinessname='Madison Magatelli Photography' or tblfeedback.strbusinessname='Madison Magatelli Photography') 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
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
Pure In Essence Photography
Cairns QLD 4870
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=21579 or tblfeedback.strbusinessname='Pure In Essence Photography' or tblfeedback.strbusinessname='Pure In Essence Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Josephine Carter Photography
Townsville QLD 4815
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=38344 or tblfeedback.strbusinessname='Josephine Carter Photography' or tblfeedback.strbusinessname='Josephine Carter Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tiara jade Photography
Mission Beach QLD 4852
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=46502 or tblfeedback.strbusinessname='Tiara jade Photography' or tblfeedback.strbusinessname='Tiara jade 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
Lee-Ann Wilson Photography
Bundaberg QLD 4670
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=27517 or tblfeedback.strbusinessname='Lee-Ann Wilson Photography' or tblfeedback.strbusinessname='Lee-Ann Wilson 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
Sass Studio Photography
Port Douglas QLD 4877
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=23342 or tblfeedback.strbusinessname='Sass Studio Photography' or tblfeedback.strbusinessname='Sass Studio Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wild Flora Photography
Mount Low, Townsville QLD 4818
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=46314 or tblfeedback.strbusinessname='Wild Flora Photography' or tblfeedback.strbusinessname='Wild Flora Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Forever Treasures Photography
Cairns QLD 4870
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=41119 or tblfeedback.strbusinessname='Forever Treasures Photography' or tblfeedback.strbusinessname='Forever Treasures Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Digital Studio Maldives
Maldives 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=29802 or tblfeedback.strbusinessname='Digital Studio Maldives' or tblfeedback.strbusinessname='Digital Studio Maldives') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
CharLeigh Photography
Townsville QLD 4810
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=38469 or tblfeedback.strbusinessname='CharLeigh Photography' or tblfeedback.strbusinessname='CharLeigh Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
J Create Photography
Cairns QLD 4870
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=30261 or tblfeedback.strbusinessname='J Create Photography' or tblfeedback.strbusinessname='J Create Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tella Photography
Townsville QLD 4817
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=25960 or tblfeedback.strbusinessname='Tella Photography' or tblfeedback.strbusinessname='Tella Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Love Lane Design
Kirwan QLD 4818
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=38433 or tblfeedback.strbusinessname='Love Lane Design' or tblfeedback.strbusinessname='Love Lane Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Cairns Beaches Photography
Clifton Beach QLD 4879
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=27067 or tblfeedback.strbusinessname='Cairns Beaches Photography' or tblfeedback.strbusinessname='Cairns Beaches Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
K & L Capturing Moments Video and Photography
Bowen QLD 4805
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=41643 or tblfeedback.strbusinessname='K &%%semi%% L Capturing Moments Video and Photography' or tblfeedback.strbusinessname='K & L Capturing Moments Video and Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Amy Steed Photography
Mackay QLD 4740
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=27101 or tblfeedback.strbusinessname='Amy Steed Photography' or tblfeedback.strbusinessname='Amy Steed Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Chiara Borsato Photography
Innisfail QLD 4860
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=29732 or tblfeedback.strbusinessname='Chiara Borsato Photography' or tblfeedback.strbusinessname='Chiara Borsato Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rebecca O'Grady Photographics
Yeppoon QLD 4703
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=22869 or tblfeedback.strbusinessname='Rebecca O''Grady Photographics' or tblfeedback.strbusinessname='Rebecca O''Grady Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Andrew Rankin Photography
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=39847 or tblfeedback.strbusinessname='Andrew Rankin Photography' or tblfeedback.strbusinessname='Andrew Rankin Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Martin Saxon - Saxon photography
Townsville QLD 4811
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=38350 or tblfeedback.strbusinessname='Martin Saxon - Saxon photography' or tblfeedback.strbusinessname='Martin Saxon - Saxon photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
House of Lucie
Airlie Beach QLD 4740
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=41735 or tblfeedback.strbusinessname='House of Lucie' or tblfeedback.strbusinessname='House of Lucie') 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
Empire Captures by Shayna
Sarina QLD 4740
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=26596 or tblfeedback.strbusinessname='Empire Captures by Shayna' or tblfeedback.strbusinessname='Empire Captures by Shayna') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Lost and Wild
Airlie Beach QLD 4802
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=43070 or tblfeedback.strbusinessname='The Lost and Wild' or tblfeedback.strbusinessname='The Lost and Wild') 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
Wildheart Imagery
Townsville QLD 4814
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=25187 or tblfeedback.strbusinessname='Wildheart Imagery' or tblfeedback.strbusinessname='Wildheart Imagery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tropix Photography
Airlie Beach QLD 4802
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=26673 or tblfeedback.strbusinessname='Tropix Photography' or tblfeedback.strbusinessname='Tropix Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Katie Purling Photography
Cairns QLD 4870
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=29198 or tblfeedback.strbusinessname='Katie Purling Photography' or tblfeedback.strbusinessname='Katie Purling Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Zen Images
Townsville QLD 4810
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=26212 or tblfeedback.strbusinessname='Zen Images' or tblfeedback.strbusinessname='Zen Images') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Phil Copp Photos
Kelso QLD 4815
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=27016 or tblfeedback.strbusinessname='Phil Copp Photos' or tblfeedback.strbusinessname='Phil Copp Photos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kalinda Photography
Mareeba QLD 4880
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=24130 or tblfeedback.strbusinessname='Kalinda Photography' or tblfeedback.strbusinessname='Kalinda Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Richard Curzon Photography
Innisfail QLD 4860
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=39708 or tblfeedback.strbusinessname='Richard Curzon Photography' or tblfeedback.strbusinessname='Richard Curzon Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lubo Markovsky Media
Cairns QLD 4870
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=44510 or tblfeedback.strbusinessname='Lubo Markovsky Media' or tblfeedback.strbusinessname='Lubo Markovsky Media') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Denim & Lace Photography
Dimbulah QLD 4872
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=43128 or tblfeedback.strbusinessname='Denim &%%semi%% Lace Photography' or tblfeedback.strbusinessname='Denim & Lace Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Louise Myers Photography
Cairns QLD 4870
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=26592 or tblfeedback.strbusinessname='Louise Myers Photography' or tblfeedback.strbusinessname='Louise Myers Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Luminosity Studios
Cairns QLD 4870
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=26235 or tblfeedback.strbusinessname='Luminosity Studios' or tblfeedback.strbusinessname='Luminosity Studios') 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
Tamara Kate Photography
Cairns QLD 4879
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=27108 or tblfeedback.strbusinessname='Tamara Kate Photography' or tblfeedback.strbusinessname='Tamara Kate Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Alison Jones Photography
Earlville QLD 4870
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=35759 or tblfeedback.strbusinessname='Alison Jones Photography' or tblfeedback.strbusinessname='Alison Jones Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15