Read more

229 result(s) found. RatingView Your Favorites List

Rating
Cove Photography
Hallett Cove SA 5158
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=4980 or tblfeedback.strbusinessname='Cove Photography' or tblfeedback.strbusinessname='Cove Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
BM Photography
Brighton South SA 5048
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=4948 or tblfeedback.strbusinessname='BM Photography' or tblfeedback.strbusinessname='BM Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Perfect Match Photography From the Heart
Nailsworth SA 5083
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=6343 or tblfeedback.strbusinessname='Perfect Match Photography From the Heart' or tblfeedback.strbusinessname='Perfect Match Photography From the Heart') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Claudio Raschella Photography
Unley SA 5061
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=4975 or tblfeedback.strbusinessname='Claudio Raschella Photography' or tblfeedback.strbusinessname='Claudio Raschella Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Christine Hutchinson
Marion SA 5043
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=4970 or tblfeedback.strbusinessname='Christine Hutchinson' or tblfeedback.strbusinessname='Christine Hutchinson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Venus
Norwood SA 5067
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=5123 or tblfeedback.strbusinessname='Venus' or tblfeedback.strbusinessname='Venus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Joojoo Photographic Arts
Aldgate SA 5154
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=5036 or tblfeedback.strbusinessname='Joojoo Photographic Arts' or tblfeedback.strbusinessname='Joojoo Photographic Arts') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Photos by Lee
Noarlunga SA 5168
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=5078 or tblfeedback.strbusinessname='Photos by Lee' or tblfeedback.strbusinessname='Photos by Lee') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fred Bray Photographer
Modbury North SA 5092
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=5009 or tblfeedback.strbusinessname='Fred Bray Photographer' or tblfeedback.strbusinessname='Fred Bray Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hughes Portraits
Paralowie SA 5108
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=5022 or tblfeedback.strbusinessname='Hughes Portraits' or tblfeedback.strbusinessname='Hughes Portraits') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Digital FX
Golden Grove SA 5125
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=4990 or tblfeedback.strbusinessname='Digital FX' or tblfeedback.strbusinessname='Digital FX') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Windsor Studio
Elizabeth SA 5112
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=5125 or tblfeedback.strbusinessname='Windsor Studio' or tblfeedback.strbusinessname='Windsor Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Williams Tim Photography
College Park SA 5069
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=5124 or tblfeedback.strbusinessname='Williams Tim Photography' or tblfeedback.strbusinessname='Williams Tim Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hulbert Photography
Greenwith SA 5125
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=5023 or tblfeedback.strbusinessname='Hulbert Photography' or tblfeedback.strbusinessname='Hulbert Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Not Just A Hobby
Adelaide SA 5000
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=5060 or tblfeedback.strbusinessname='Not Just A Hobby' or tblfeedback.strbusinessname='Not Just A Hobby') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Finelight Photography
Prospect SA 5082
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=5003 or tblfeedback.strbusinessname='Finelight Photography' or tblfeedback.strbusinessname='Finelight Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Images of Distinction
Aberfoyle Park SA 5159
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=5026 or tblfeedback.strbusinessname='Images of Distinction' or tblfeedback.strbusinessname='Images of Distinction') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Not Just A Hobby
One Tree Hill SA 5114
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=5059 or tblfeedback.strbusinessname='Not Just A Hobby' or tblfeedback.strbusinessname='Not Just A Hobby') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Michael Royans Photographics
Glengowrie SA 5044
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=5051 or tblfeedback.strbusinessname='Michael Royans Photographics' or tblfeedback.strbusinessname='Michael Royans Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Designer Video & Photography
Payneham SA 5070
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=4989 or tblfeedback.strbusinessname='Designer Video &%%semi%% Photography' or tblfeedback.strbusinessname='Designer Video & Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jane's Daylight Black-White Photography
Sturt SA 5047
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=5031 or tblfeedback.strbusinessname='Jane'%%semi%%s Daylight Black-White Photography' or tblfeedback.strbusinessname='Jane's Daylight Black-White Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Crackerjack Photographic Studio
Belair SA 5052
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=4981 or tblfeedback.strbusinessname='Crackerjack Photographic Studio' or tblfeedback.strbusinessname='Crackerjack Photographic Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Goldline Photography
Henley Beach SA 5022
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=5012 or tblfeedback.strbusinessname='Goldline Photography' or tblfeedback.strbusinessname='Goldline Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Abbey Photographics
Crafers SA 5152
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=4935 or tblfeedback.strbusinessname='Abbey Photographics' or tblfeedback.strbusinessname='Abbey Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
SA Quick Printing & Copy Centre
Morphett Vale SA 5162
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=6344 or tblfeedback.strbusinessname='SA Quick Printing &%%semi%% Copy Centre' or tblfeedback.strbusinessname='SA Quick Printing & Copy Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Christies Beach Photographers
Christies Beach SA 5165
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=4969 or tblfeedback.strbusinessname='Christies Beach Photographers' or tblfeedback.strbusinessname='Christies Beach Photographers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Focal Vision Photographics
Modbury North SA 5092
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=5005 or tblfeedback.strbusinessname='Focal Vision Photographics' or tblfeedback.strbusinessname='Focal Vision Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Top Shot Photography
Blackwood SA 5051
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=5116 or tblfeedback.strbusinessname='Top Shot Photography' or tblfeedback.strbusinessname='Top Shot Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Studio One Photography
Adelaide SA 5000
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=5103 or tblfeedback.strbusinessname='Studio One Photography' or tblfeedback.strbusinessname='Studio One Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Buddy Photography
Kilkenny SA 5009
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=4955 or tblfeedback.strbusinessname='Buddy Photography' or tblfeedback.strbusinessname='Buddy Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Photography by Patrick O'Donne
Mt Gambier SA 5092
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=19172 or tblfeedback.strbusinessname='Photography by Patrick O'%%semi%%Donne' or tblfeedback.strbusinessname='Photography by Patrick O'Donne') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fleurieu Photographics
Huntfield Heights SA 5163
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=5004 or tblfeedback.strbusinessname='Fleurieu Photographics' or tblfeedback.strbusinessname='Fleurieu Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Matthew Burns Photography
Norwood SA 5067
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=5045 or tblfeedback.strbusinessname='Matthew Burns Photography' or tblfeedback.strbusinessname='Matthew Burns Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Southern Photo Studio
Seaford SA 5169
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=5095 or tblfeedback.strbusinessname='Southern Photo Studio' or tblfeedback.strbusinessname='Southern Photo Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lasting Impression Photographics
West Richmond SA 5033
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=4674 or tblfeedback.strbusinessname='Lasting Impression Photographics' or tblfeedback.strbusinessname='Lasting Impression Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Calico Studios
Blackwood SA 5051
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=4956 or tblfeedback.strbusinessname='Calico Studios' or tblfeedback.strbusinessname='Calico Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Marsden Photography
Valley View SA 5093
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=5044 or tblfeedback.strbusinessname='Marsden Photography' or tblfeedback.strbusinessname='Marsden Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Adelaide Modern Studio
Payneham SA 5070
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=12149 or tblfeedback.strbusinessname='Adelaide Modern Studio' or tblfeedback.strbusinessname='Adelaide Modern Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Michael Fabbro Photographers
Everard Park SA 5035
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=5050 or tblfeedback.strbusinessname='Michael Fabbro Photographers' or tblfeedback.strbusinessname='Michael Fabbro Photographers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Roxy Studios
Everard Park SA 5035
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=19187 or tblfeedback.strbusinessname='Roxy Studios' or tblfeedback.strbusinessname='Roxy Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Shutterbug Studios
Torrensville SA 5031
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=5094 or tblfeedback.strbusinessname='Shutterbug Studios' or tblfeedback.strbusinessname='Shutterbug Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Colin Leiper Photographics
Golden Grove SA 5125
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=4977 or tblfeedback.strbusinessname='Colin Leiper Photographics' or tblfeedback.strbusinessname='Colin Leiper Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Merlin Photographics
St Morris SA 5068
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=5049 or tblfeedback.strbusinessname='Merlin Photographics' or tblfeedback.strbusinessname='Merlin Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Studio Memoirs
Adelaide SA 5000
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=5101 or tblfeedback.strbusinessname='Studio Memoirs' or tblfeedback.strbusinessname='Studio Memoirs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Carlo Irlitti
Norwood SA 5067
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=4962 or tblfeedback.strbusinessname='Carlo Irlitti' or tblfeedback.strbusinessname='Carlo Irlitti') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Glamour Photography Stuido
Parafield Gardens SA 5107
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=19115 or tblfeedback.strbusinessname='Glamour Photography Stuido' or tblfeedback.strbusinessname='Glamour Photography Stuido') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Studio Mode Photographers
Prospect SA 5082
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=5102 or tblfeedback.strbusinessname='Studio Mode Photographers' or tblfeedback.strbusinessname='Studio Mode Photographers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Highlight Photographics
Glenside SA 5065
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=5019 or tblfeedback.strbusinessname='Highlight Photographics' or tblfeedback.strbusinessname='Highlight Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mc Lennan
Stepney SA 5069
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=5047 or tblfeedback.strbusinessname='Mc Lennan' or tblfeedback.strbusinessname='Mc Lennan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Photography by Tony Antonelli
Prospect SA 5082
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=5076 or tblfeedback.strbusinessname='Photography by Tony Antonelli' or tblfeedback.strbusinessname='Photography by Tony Antonelli') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 229 Sort search results alphabetically