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.
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.
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.
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
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.
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
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
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
D&M Moments 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=41274 or tblfeedback.strbusinessname='D&%%semi%%M Moments Photography' or tblfeedback.strbusinessname='D&M Moments Photography') 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
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
Candice Campbell Photography
Largs 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=21465 or tblfeedback.strbusinessname='Candice Campbell Photography' or tblfeedback.strbusinessname='Candice Campbell Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Xtraordinary Photos & Video
Leichhardt NSW 2232
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=23992 or tblfeedback.strbusinessname='Xtraordinary Photos &%%semi%% Video' or tblfeedback.strbusinessname='Xtraordinary Photos & Video') 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
Nigel Unsworth
Berry NSW 2535
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=27514 or tblfeedback.strbusinessname='Nigel Unsworth' or tblfeedback.strbusinessname='Nigel Unsworth') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Moments by Chris Photography
Castle Hill NSW 2154
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=22535 or tblfeedback.strbusinessname='Moments by Chris Photography' or tblfeedback.strbusinessname='Moments by Chris Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
KJR Productions
Kellyville NSW 2155
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=25782 or tblfeedback.strbusinessname='KJR Productions' or tblfeedback.strbusinessname='KJR Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Montana Wilson
Avalon NSW 2107
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=29319 or tblfeedback.strbusinessname='Montana Wilson' or tblfeedback.strbusinessname='Montana Wilson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sundstrom Images
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=23057 or tblfeedback.strbusinessname='Sundstrom Images' or tblfeedback.strbusinessname='Sundstrom Images') 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
Perfect Moment Photography
Lilyfield 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=26929 or tblfeedback.strbusinessname='Perfect Moment Photography' or tblfeedback.strbusinessname='Perfect Moment 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
Rebecca Lynne Photography
Coffs Harbour NSW 2450
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=27661 or tblfeedback.strbusinessname='Rebecca Lynne Photography' or tblfeedback.strbusinessname='Rebecca Lynne Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Branden Cain
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=27466 or tblfeedback.strbusinessname='Branden Cain' or tblfeedback.strbusinessname='Branden Cain') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Soulmade Stories
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=29741 or tblfeedback.strbusinessname='Soulmade Stories' or tblfeedback.strbusinessname='Soulmade Stories') 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
Jimmy Raper 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=35922 or tblfeedback.strbusinessname='Jimmy Raper Photography' or tblfeedback.strbusinessname='Jimmy Raper Photography') 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
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
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
Grundig Photography
Bass Hill NSW 2197
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=9578 or tblfeedback.strbusinessname='Grundig Photography' or tblfeedback.strbusinessname='Grundig Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sidd Rishi Photography
Sydenham NSW 2044
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=26196 or tblfeedback.strbusinessname='Sidd Rishi Photography' or tblfeedback.strbusinessname='Sidd Rishi Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Karen Parr Photographer
Inverell NSW 2390
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=24442 or tblfeedback.strbusinessname='Karen Parr Photographer' or tblfeedback.strbusinessname='Karen Parr Photographer') 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
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=25979 or tblfeedback.strbusinessname='Golden Touch Productions' or tblfeedback.strbusinessname='Golden Touch Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Evoke Photography
Stanmore NSW 2048
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=29953 or tblfeedback.strbusinessname='Evoke Photography' or tblfeedback.strbusinessname='Evoke 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
Mick G Photography
St Marys NSW 2760
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=35878 or tblfeedback.strbusinessname='Mick G Photography' or tblfeedback.strbusinessname='Mick G Photography') 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
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
James Thomson 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=39824 or tblfeedback.strbusinessname='James Thomson Photography' or tblfeedback.strbusinessname='James Thomson Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jessica bissett photography
Newcastle NSW 2300
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=25409 or tblfeedback.strbusinessname='Jessica bissett photography' or tblfeedback.strbusinessname='Jessica bissett photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Eternal Photography
Rockdale NSW 2216
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=9193 or tblfeedback.strbusinessname='Eternal Photography' or tblfeedback.strbusinessname='Eternal Photography') 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
a2z Weddings
Wetherill Park NSW 2164
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=23077 or tblfeedback.strbusinessname='a2z Weddings' or tblfeedback.strbusinessname='a2z Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Andrew Szopory Photography
Camden 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=24312 or tblfeedback.strbusinessname='Andrew Szopory Photography' or tblfeedback.strbusinessname='Andrew Szopory Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Serena Jones Photography
Baulkham Hills NSW 2153
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=25658 or tblfeedback.strbusinessname='Serena Jones Photography' or tblfeedback.strbusinessname='Serena Jones Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
DC Images
Hornsby heights NSW 2077
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=27226 or tblfeedback.strbusinessname='DC Images' or tblfeedback.strbusinessname='DC Images') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Wanderers
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=25834 or tblfeedback.strbusinessname='The Wanderers' or tblfeedback.strbusinessname='The Wanderers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15