Dreamlife Photos and Video Sydney
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=20226 or tblfeedback.strbusinessname='Dreamlife Photos and Video Sydney' or tblfeedback.strbusinessname='Dreamlife Photos and Video Sydney') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wedding photography and wedding videography
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.
Sarhn McArthur 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=18168 or tblfeedback.strbusinessname='Sarhn McArthur Photography' or tblfeedback.strbusinessname='Sarhn McArthur Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Creating images that will make you smile forever.
Xpressions 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=20269 or tblfeedback.strbusinessname='Xpressions Photography' or tblfeedback.strbusinessname='Xpressions Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Capturing amazing & emotional moments.
Fresh Images by Rose
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=18137 or tblfeedback.strbusinessname='Fresh Images by Rose' or tblfeedback.strbusinessname='Fresh Images by Rose') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Beautiful wedding images, high quality albums.
Darlene Andrews 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=18131 or tblfeedback.strbusinessname='Darlene Andrews Photography' or tblfeedback.strbusinessname='Darlene Andrews Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Darlene Andrews Photography is a small, personal and exclusive studio with a rel
Art Photography by Kira
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=18608 or tblfeedback.strbusinessname='Art Photography by Kira' or tblfeedback.strbusinessname='Art Photography by Kira') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Creative, Contemporary and Unique Images. Art Photography by Kira offers a uniqu
Rachel Gutierrez 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=38521 or tblfeedback.strbusinessname='Rachel Gutierrez Photography' or tblfeedback.strbusinessname='Rachel Gutierrez Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Georgie Newton 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=29060 or tblfeedback.strbusinessname='Georgie Newton Photography' or tblfeedback.strbusinessname='Georgie Newton Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lisa Thompson Photographer
Frenchs Forest NSW 6330
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=4405 or tblfeedback.strbusinessname='Lisa Thompson Photographer' or tblfeedback.strbusinessname='Lisa Thompson Photographer') 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
Gavin Cato Photography
Helensburgh NSW 2508
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=27670 or tblfeedback.strbusinessname='Gavin Cato Photography' or tblfeedback.strbusinessname='Gavin Cato Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Golden Touch Productions
Fairfield West NSW 2165
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=35758 or tblfeedback.strbusinessname='Golden Touch Productions' or tblfeedback.strbusinessname='Golden Touch Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Daniel Griffiths Photography
St Ives NSW 2138
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=2445 or tblfeedback.strbusinessname='Daniel Griffiths Photography' or tblfeedback.strbusinessname='Daniel Griffiths Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jack Jones Wedding Photography
Strathfield NSW 2135
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=29605 or tblfeedback.strbusinessname='Jack Jones Wedding Photography' or tblfeedback.strbusinessname='Jack Jones Wedding Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Madi Fitzgerald
Goulburn NSW 2580
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=27158 or tblfeedback.strbusinessname='Madi Fitzgerald' or tblfeedback.strbusinessname='Madi Fitzgerald') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sam Wyper Photography
Rutherford NSW 2320
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=41171 or tblfeedback.strbusinessname='Sam Wyper Photography' or tblfeedback.strbusinessname='Sam Wyper Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ryan Schembri
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=26861 or tblfeedback.strbusinessname='Ryan Schembri' or tblfeedback.strbusinessname='Ryan Schembri') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
John Princi Photography
Harrington Park NSW 2567
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=38423 or tblfeedback.strbusinessname='John Princi Photography' or tblfeedback.strbusinessname='John Princi Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hugo Photography & Film
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=22547 or tblfeedback.strbusinessname='Hugo Photography &%%semi%% Film' or tblfeedback.strbusinessname='Hugo Photography & Film') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Handprint Photography
Narellan NSW 2567
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=29365 or tblfeedback.strbusinessname='Handprint Photography' or tblfeedback.strbusinessname='Handprint 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
Colour 18 Wedding
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=26586 or tblfeedback.strbusinessname='Colour 18 Wedding' or tblfeedback.strbusinessname='Colour 18 Wedding') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ava Me 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=27817 or tblfeedback.strbusinessname='Ava Me Photography' or tblfeedback.strbusinessname='Ava Me Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Angus McKern Photography
Orange NSW 2800
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=25060 or tblfeedback.strbusinessname='Angus McKern Photography' or tblfeedback.strbusinessname='Angus McKern Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Taylah Nilsson Photography
Frenchs Forest NSW 2086
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=26016 or tblfeedback.strbusinessname='Taylah Nilsson Photography' or tblfeedback.strbusinessname='Taylah Nilsson Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Matija and Marina Kljunak
Zagreb 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=39886 or tblfeedback.strbusinessname='Matija and Marina Kljunak' or tblfeedback.strbusinessname='Matija and Marina Kljunak') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Montana Wilson 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=24786 or tblfeedback.strbusinessname='Montana Wilson Photography' or tblfeedback.strbusinessname='Montana Wilson Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Emotiva Photo and Video
Vaucluse NSW 2030
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=27417 or tblfeedback.strbusinessname='Emotiva Photo and Video' or tblfeedback.strbusinessname='Emotiva Photo and Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Nonstop Weddings
St Clair NSW 2759
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=29270 or tblfeedback.strbusinessname='Nonstop Weddings' or tblfeedback.strbusinessname='Nonstop Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
SoaP Productions
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=37771 or tblfeedback.strbusinessname='SoaP Productions' or tblfeedback.strbusinessname='SoaP Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Michelle A Smith Photography
Mount Riverview NSW 2774
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=41128 or tblfeedback.strbusinessname='Michelle A Smith Photography' or tblfeedback.strbusinessname='Michelle A Smith Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Zoe Morley Photography
Rosebery NSW 2018
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=29294 or tblfeedback.strbusinessname='Zoe Morley Photography' or tblfeedback.strbusinessname='Zoe Morley Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Macarthur Photography and Video
Elderslie NSW 2570
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=26625 or tblfeedback.strbusinessname='Macarthur Photography and Video' or tblfeedback.strbusinessname='Macarthur Photography and Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hilary Cam Photography
Darlington NSW 2010
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=21402 or tblfeedback.strbusinessname='Hilary Cam Photography' or tblfeedback.strbusinessname='Hilary Cam Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wildwood Cinematic
Hunter Region NSW 2310
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=38405 or tblfeedback.strbusinessname='Wildwood Cinematic' or tblfeedback.strbusinessname='Wildwood Cinematic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Nadine Saacks Photography
Rose Bay NSW 2029
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=37738 or tblfeedback.strbusinessname='Nadine Saacks Photography' or tblfeedback.strbusinessname='Nadine Saacks Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wendell Teodoro
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=36053 or tblfeedback.strbusinessname='Wendell Teodoro' or tblfeedback.strbusinessname='Wendell Teodoro') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
La Perouse Photography
Maroubra NSW 2033
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=27559 or tblfeedback.strbusinessname='La Perouse Photography' or tblfeedback.strbusinessname='La Perouse Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Dear Vincent
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=41058 or tblfeedback.strbusinessname='Dear Vincent' or tblfeedback.strbusinessname='Dear Vincent') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Emilio B Photography
Marsfield NSW 2122
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=25756 or tblfeedback.strbusinessname='Emilio B Photography' or tblfeedback.strbusinessname='Emilio B Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Image Haus
Sydney NSW 2570
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=26392 or tblfeedback.strbusinessname='Image Haus' or tblfeedback.strbusinessname='Image Haus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Faure Valletta Photography
Five Dock NSW 2046
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=35925 or tblfeedback.strbusinessname='Faure Valletta Photography' or tblfeedback.strbusinessname='Faure Valletta Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
MMG Photo and Cinema
Crows Nest NSW 2065
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=21390 or tblfeedback.strbusinessname='MMG Photo and Cinema' or tblfeedback.strbusinessname='MMG Photo and Cinema') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Renaissance Photobooths
Orange NSW 2800
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=25678 or tblfeedback.strbusinessname='Renaissance Photobooths' or tblfeedback.strbusinessname='Renaissance Photobooths') 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
Rachael Lenehan Photography
Murringo NSW 2586
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=41615 or tblfeedback.strbusinessname='Rachael Lenehan Photography' or tblfeedback.strbusinessname='Rachael Lenehan Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sitto Studios
Leichhardt NSW 2040
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=41492 or tblfeedback.strbusinessname='Sitto Studios' or tblfeedback.strbusinessname='Sitto Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Alexandra Penelope Photography
Camden NSW 2567
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=39771 or tblfeedback.strbusinessname='Alexandra Penelope Photography' or tblfeedback.strbusinessname='Alexandra Penelope Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Amity Photography
Woollarah NSW 2025
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=36032 or tblfeedback.strbusinessname='Amity Photography' or tblfeedback.strbusinessname='Amity Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15