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.
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
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.
Tracey Woodfield 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=25608 or tblfeedback.strbusinessname='Tracey Woodfield Photography' or tblfeedback.strbusinessname='Tracey Woodfield 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
Port Douglas Wedding 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=29020 or tblfeedback.strbusinessname='Port Douglas Wedding Photography' or tblfeedback.strbusinessname='Port Douglas Wedding 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
Your View Photography
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=43450 or tblfeedback.strbusinessname='Your View Photography' or tblfeedback.strbusinessname='Your View 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
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
Amy Grace 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=23420 or tblfeedback.strbusinessname='Amy Grace Photography' or tblfeedback.strbusinessname='Amy Grace 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
Haley Aplin Photography
Charters Towers ACT 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=29244 or tblfeedback.strbusinessname='Haley Aplin Photography' or tblfeedback.strbusinessname='Haley Aplin Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Matthew Allen 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=39974 or tblfeedback.strbusinessname='Matthew Allen Photography' or tblfeedback.strbusinessname='Matthew Allen 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
Matthew Evans Photography
Clifton Beach 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=22640 or tblfeedback.strbusinessname='Matthew Evans Photography' or tblfeedback.strbusinessname='Matthew Evans Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Brendan McRae
Malanda QLD 4885
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=26166 or tblfeedback.strbusinessname='Brendan McRae' or tblfeedback.strbusinessname='Brendan McRae') 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
Dreamscape Studio
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=25390 or tblfeedback.strbusinessname='Dreamscape Studio' or tblfeedback.strbusinessname='Dreamscape Studio') 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
Cairns Wedding 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=26288 or tblfeedback.strbusinessname='Cairns Wedding Photography' or tblfeedback.strbusinessname='Cairns Wedding 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
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
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
Talking Point Photography
Ayr QLD 4807
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=27595 or tblfeedback.strbusinessname='Talking Point Photography' or tblfeedback.strbusinessname='Talking Point Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
SB Creative Co.
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=21815 or tblfeedback.strbusinessname='SB Creative Co.' or tblfeedback.strbusinessname='SB Creative Co.') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lia & Stu Destination Photographers
Fiji VIC 3844
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=26334 or tblfeedback.strbusinessname='Lia &%%semi%% Stu Destination Photographers' or tblfeedback.strbusinessname='Lia & Stu Destination Photographers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Brook Elaine Photography
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=46151 or tblfeedback.strbusinessname='Brook Elaine Photography' or tblfeedback.strbusinessname='Brook Elaine Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Land & Co Photography
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=43507 or tblfeedback.strbusinessname='Land &%%semi%% Co Photography' or tblfeedback.strbusinessname='Land & Co Photography') 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
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
Renee Liddle Photography
Ingham QLD 4850
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=26793 or tblfeedback.strbusinessname='Renee Liddle Photography' or tblfeedback.strbusinessname='Renee Liddle 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
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
Lindy Hick Photography
Hughenden QLD 4821
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=27973 or tblfeedback.strbusinessname='Lindy Hick Photography' or tblfeedback.strbusinessname='Lindy Hick Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Photography by Red Sky
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=25643 or tblfeedback.strbusinessname='Photography by Red Sky' or tblfeedback.strbusinessname='Photography by Red Sky') 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
Kellie & Dennis Portraiture
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=27254 or tblfeedback.strbusinessname='Kellie &%%semi%% Dennis Portraiture' or tblfeedback.strbusinessname='Kellie & Dennis Portraiture') 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
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
Delicate Dreams 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=22600 or tblfeedback.strbusinessname='Delicate Dreams Photography' or tblfeedback.strbusinessname='Delicate Dreams Photography') 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
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
Eternal Films
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=25391 or tblfeedback.strbusinessname='Eternal Films' or tblfeedback.strbusinessname='Eternal Films') 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=41717 or tblfeedback.strbusinessname='Luminosity Studios' or tblfeedback.strbusinessname='Luminosity Studios') 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
Linda Kelso Photography
Charters Towers 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=26824 or tblfeedback.strbusinessname='Linda Kelso Photography' or tblfeedback.strbusinessname='Linda Kelso Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Outback Impressions Photography
Charters Towers 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=43575 or tblfeedback.strbusinessname='Outback Impressions Photography' or tblfeedback.strbusinessname='Outback Impressions Photography') 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
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