Read more

229 result(s) found. RatingView Your Favorites List

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
Deja VU Photography
Torrens Park SA 5062
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=4988 or tblfeedback.strbusinessname='Deja VU Photography' or tblfeedback.strbusinessname='Deja VU Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Festival Studios
Glandore SA 5037
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=5001 or tblfeedback.strbusinessname='Festival Studios' or tblfeedback.strbusinessname='Festival Studios') 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
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
Photography Room-Mark Trumble
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=5074 or tblfeedback.strbusinessname='Photography Room-Mark Trumble' or tblfeedback.strbusinessname='Photography Room-Mark Trumble') 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
Photography by Dale
Tea Tree Gully SA 5091
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=5075 or tblfeedback.strbusinessname='Photography by Dale' or tblfeedback.strbusinessname='Photography by Dale') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
Julius Krantz Photo & Video
Modbury 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=5037 or tblfeedback.strbusinessname='Julius Krantz Photo &%%semi%% Video' or tblfeedback.strbusinessname='Julius Krantz Photo & Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coconut Productions
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=19071 or tblfeedback.strbusinessname='Coconut Productions' or tblfeedback.strbusinessname='Coconut Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Anthony of Adelaide Light Square Studios
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=4942 or tblfeedback.strbusinessname='Anthony of Adelaide Light Square Studios' or tblfeedback.strbusinessname='Anthony of Adelaide Light Square Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Premier Photography
Salisbury 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=5080 or tblfeedback.strbusinessname='Premier Photography' or tblfeedback.strbusinessname='Premier Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Terry Dorney Photography
Wynn Vale SA 5127
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=5109 or tblfeedback.strbusinessname='Terry Dorney Photography' or tblfeedback.strbusinessname='Terry Dorney Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
Festive Video
Redwood Park SA 5097
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=5002 or tblfeedback.strbusinessname='Festive Video' or tblfeedback.strbusinessname='Festive Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Studio 2000 Photographers
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=5099 or tblfeedback.strbusinessname='Studio 2000 Photographers' or tblfeedback.strbusinessname='Studio 2000 Photographers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Barry Webb
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=4949 or tblfeedback.strbusinessname='Barry Webb' or tblfeedback.strbusinessname='Barry Webb') 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
Excel Agency
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=4996 or tblfeedback.strbusinessname='Excel Agency' or tblfeedback.strbusinessname='Excel Agency') 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
Photography by Varano
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=5077 or tblfeedback.strbusinessname='Photography by Varano' or tblfeedback.strbusinessname='Photography by Varano') 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
Private Collections
Malvern 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=5083 or tblfeedback.strbusinessname='Private Collections' or tblfeedback.strbusinessname='Private Collections') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Select Photographers
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=5093 or tblfeedback.strbusinessname='Select Photographers' or tblfeedback.strbusinessname='Select Photographers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jon Loui Avant Garde Photography
Flagstaff Hill 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=5035 or tblfeedback.strbusinessname='Jon Loui Avant Garde Photography' or tblfeedback.strbusinessname='Jon Loui Avant Garde Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lasting Impression Photography
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=19145 or tblfeedback.strbusinessname='Lasting Impression Photography' or tblfeedback.strbusinessname='Lasting Impression Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Immortal Portraits
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=5028 or tblfeedback.strbusinessname='Immortal Portraits' or tblfeedback.strbusinessname='Immortal Portraits') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lasting Impression Photographics
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=5039 or tblfeedback.strbusinessname='Lasting Impression Photographics' or tblfeedback.strbusinessname='Lasting Impression Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Imaging U
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=5027 or tblfeedback.strbusinessname='Imaging U' or tblfeedback.strbusinessname='Imaging U') 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
Mayfair Studio
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=5046 or tblfeedback.strbusinessname='Mayfair Studio' or tblfeedback.strbusinessname='Mayfair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coconut Productions Pty Ltd
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=4976 or tblfeedback.strbusinessname='Coconut Productions Pty Ltd' or tblfeedback.strbusinessname='Coconut Productions Pty Ltd') 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
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
Moments Forever Adelaide
Kent Town SA 5071
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=5053 or tblfeedback.strbusinessname='Moments Forever Adelaide' or tblfeedback.strbusinessname='Moments Forever Adelaide') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Luigi's Photo 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=5040 or tblfeedback.strbusinessname='Luigi'%%semi%%s Photo Studio' or tblfeedback.strbusinessname='Luigi's Photo Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dynasty Video Productions
West Woodville SA 5011
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=4993 or tblfeedback.strbusinessname='Dynasty Video Productions' or tblfeedback.strbusinessname='Dynasty Video Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Studio Vogue
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=5104 or tblfeedback.strbusinessname='Studio Vogue' or tblfeedback.strbusinessname='Studio Vogue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Studio 57
St Agnes SA 5097
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=5100 or tblfeedback.strbusinessname='Studio 57' or tblfeedback.strbusinessname='Studio 57') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jodi Nash
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=5034 or tblfeedback.strbusinessname='Jodi Nash' or tblfeedback.strbusinessname='Jodi Nash') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Doncaster N D
North Adelaide SA 5006
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=4991 or tblfeedback.strbusinessname='Doncaster N D' or tblfeedback.strbusinessname='Doncaster N D') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Amax Photographic Services
Plympton South SA 5038
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=4940 or tblfeedback.strbusinessname='Amax Photographic Services' or tblfeedback.strbusinessname='Amax Photographic Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classic Kids Photographers
Brooklyn Park SA 5032
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=4974 or tblfeedback.strbusinessname='Classic Kids Photographers' or tblfeedback.strbusinessname='Classic Kids Photographers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 229 Sort search results alphabetically