Read more

229 result(s) found. RatingView Your Favorites List

Rating
Karyn Kent 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=29213 or tblfeedback.strbusinessname='Karyn Kent Photography' or tblfeedback.strbusinessname='Karyn Kent Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Joshue Geelen
Adelaide South Australia 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=26191 or tblfeedback.strbusinessname='Joshue Geelen' or tblfeedback.strbusinessname='Joshue Geelen') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Michael Young
Sheidow Park 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=35691 or tblfeedback.strbusinessname='Michael Young' or tblfeedback.strbusinessname='Michael Young') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Photos Xposed Photography
Plympton 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=25606 or tblfeedback.strbusinessname='Photos Xposed Photography' or tblfeedback.strbusinessname='Photos Xposed Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dale Wowk
Canberra ACT 2607
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=26372 or tblfeedback.strbusinessname='Dale Wowk' or tblfeedback.strbusinessname='Dale Wowk') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mark Mezzino
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=36281 or tblfeedback.strbusinessname='Mark Mezzino' or tblfeedback.strbusinessname='Mark Mezzino') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Shadows Farm Photography
Windsor SA 5501
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=26278 or tblfeedback.strbusinessname='Shadows Farm Photography' or tblfeedback.strbusinessname='Shadows Farm Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Glenn Hawke Photography
Port Adelaide SA 5015
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=19116 or tblfeedback.strbusinessname='Glenn Hawke Photography' or tblfeedback.strbusinessname='Glenn Hawke Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bliss Images
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=35532 or tblfeedback.strbusinessname='Bliss Images' or tblfeedback.strbusinessname='Bliss Images') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Evermore Photographics
Strathalbyn SA 5255
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=4995 or tblfeedback.strbusinessname='Evermore Photographics' or tblfeedback.strbusinessname='Evermore Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ivory Fox 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=25625 or tblfeedback.strbusinessname='Ivory Fox Photography' or tblfeedback.strbusinessname='Ivory Fox Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jonathon Colovos 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=26113 or tblfeedback.strbusinessname='Jonathon Colovos Photography' or tblfeedback.strbusinessname='Jonathon Colovos Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Acacia Rachel 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=27427 or tblfeedback.strbusinessname='Acacia Rachel Photography' or tblfeedback.strbusinessname='Acacia Rachel Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Alice Bell Photographics
Port Elliot SA 5212
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=25597 or tblfeedback.strbusinessname='Alice Bell Photographics' or tblfeedback.strbusinessname='Alice Bell Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Ciej Photography
Hindmarsh SA 5007
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=4972 or tblfeedback.strbusinessname='Ciej Photography' or tblfeedback.strbusinessname='Ciej Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
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
Susanne Zerk
Parkside SA 5063
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=5106 or tblfeedback.strbusinessname='Susanne Zerk' or tblfeedback.strbusinessname='Susanne Zerk') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A1 Wedding Video & Photography
Allenby Gardens 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=4934 or tblfeedback.strbusinessname='A1 Wedding Video &%%semi%% Photography' or tblfeedback.strbusinessname='A1 Wedding Video & Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hewett
Park Holme 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=5018 or tblfeedback.strbusinessname='Hewett' or tblfeedback.strbusinessname='Hewett') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Caruso Photo Studio
Newton SA 5074
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=4963 or tblfeedback.strbusinessname='Caruso Photo Studio' or tblfeedback.strbusinessname='Caruso Photo Studio') 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
Third Eye Photographics
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=5110 or tblfeedback.strbusinessname='Third Eye Photographics' or tblfeedback.strbusinessname='Third Eye Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Greg Woods Photography
Gawler SA 5118
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=5015 or tblfeedback.strbusinessname='Greg Woods Photography' or tblfeedback.strbusinessname='Greg Woods Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Impact Image 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=5029 or tblfeedback.strbusinessname='Impact Image Photography' or tblfeedback.strbusinessname='Impact Image Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Catz 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=4964 or tblfeedback.strbusinessname='Catz Photography' or tblfeedback.strbusinessname='Catz Photography') 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
D'Angelo
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=4984 or tblfeedback.strbusinessname='D'%%semi%%Angelo' or tblfeedback.strbusinessname='D'Angelo') 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
Ralph's Photo Gallery
Welland SA 5007
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=5085 or tblfeedback.strbusinessname='Ralph'%%semi%%s Photo Gallery' or tblfeedback.strbusinessname='Ralph's Photo Gallery') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chippendale Enterprises Pty Ltd
Keswick 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=4967 or tblfeedback.strbusinessname='Chippendale Enterprises Pty Ltd' or tblfeedback.strbusinessname='Chippendale Enterprises Pty Ltd') 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 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
Parkholme Photos
Park Holme 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=5064 or tblfeedback.strbusinessname='Parkholme Photos' or tblfeedback.strbusinessname='Parkholme Photos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jardine Photographic Studios
Elizabeth Downs SA 5113
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=5033 or tblfeedback.strbusinessname='Jardine Photographic Studios' or tblfeedback.strbusinessname='Jardine Photographic Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Glamour Photography Studio
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=5011 or tblfeedback.strbusinessname='Glamour Photography Studio' or tblfeedback.strbusinessname='Glamour Photography Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Thompson Geoff Photographics
Plympton Park 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=5112 or tblfeedback.strbusinessname='Thompson Geoff Photographics' or tblfeedback.strbusinessname='Thompson Geoff Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Foster Photographiques
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=5007 or tblfeedback.strbusinessname='Foster Photographiques' or tblfeedback.strbusinessname='Foster Photographiques') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Red Fish Foto
Walkerville SA 5081
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=19180 or tblfeedback.strbusinessname='Red Fish Foto' or tblfeedback.strbusinessname='Red Fish Foto') 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
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
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
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
Triple Image Videography
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=5119 or tblfeedback.strbusinessname='Triple Image Videography' or tblfeedback.strbusinessname='Triple Image Videography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gainsborough
Collinswood SA 5081
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=5010 or tblfeedback.strbusinessname='Gainsborough' or tblfeedback.strbusinessname='Gainsborough') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
Cipriano
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=4973 or tblfeedback.strbusinessname='Cipriano' or tblfeedback.strbusinessname='Cipriano') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 229 Sort search results alphabetically