Rating Alyssia Coates Photography
Alyssia Coates 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=25284 or tblfeedback.strbusinessname='Alyssia Coates Photography' or tblfeedback.strbusinessname='Alyssia Coates Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating Astrid Simone Photography
Astrid Simone 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=22321 or tblfeedback.strbusinessname='Astrid Simone Photography' or tblfeedback.strbusinessname='Astrid Simone Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Telling your story, capturing real life moments

Rating
Flick Plus Dave Photography
Sheffield TAS 7306
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=25536 or tblfeedback.strbusinessname='Flick Plus Dave Photography' or tblfeedback.strbusinessname='Flick Plus Dave Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wayne Enright
Deloraine TAS 7304
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=22264 or tblfeedback.strbusinessname='Wayne Enright' or tblfeedback.strbusinessname='Wayne Enright') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Anthony Rogers Wedding Photos & Videos
Wynyard TAS 7320
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=25752 or tblfeedback.strbusinessname='Anthony Rogers Wedding Photos &%%semi%% Videos' or tblfeedback.strbusinessname='Anthony Rogers Wedding Photos & Videos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Leanne Everett Photography
Scotchtown TAS 7330
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=24968 or tblfeedback.strbusinessname='Leanne Everett Photography' or tblfeedback.strbusinessname='Leanne Everett Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stacey Jaeger Photography
Smithton TAS 7330
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=26654 or tblfeedback.strbusinessname='Stacey Jaeger Photography' or tblfeedback.strbusinessname='Stacey Jaeger Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Love All Photography
Stanley TAS 7331
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=38490 or tblfeedback.strbusinessname='Love All Photography' or tblfeedback.strbusinessname='Love All Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jacqui Beven
Port sorell TAS 7307
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=27694 or tblfeedback.strbusinessname='Jacqui Beven' or tblfeedback.strbusinessname='Jacqui Beven') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ed Jones Wedding Photography
Wynyard TAS 7325
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=25547 or tblfeedback.strbusinessname='Ed Jones Wedding Photography' or tblfeedback.strbusinessname='Ed Jones Wedding Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
By Jazza
Shearwater TAS 7307
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=27823 or tblfeedback.strbusinessname='By Jazza' or tblfeedback.strbusinessname='By Jazza') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Grant Wells Photo
Burnie TAS 7320
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=26978 or tblfeedback.strbusinessname='Grant Wells Photo' or tblfeedback.strbusinessname='Grant Wells Photo') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Matt Bennet Photography
East Devonport TAS 7310
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=25230 or tblfeedback.strbusinessname='Matt Bennet Photography' or tblfeedback.strbusinessname='Matt Bennet Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kristy L Photography
Latrobe TAS 7307
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=26651 or tblfeedback.strbusinessname='Kristy L Photography' or tblfeedback.strbusinessname='Kristy L Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
N j photography
Devonport TAS 7310
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=38340 or tblfeedback.strbusinessname='N j photography' or tblfeedback.strbusinessname='N j photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Anthony Rogers Wedding Photos
Wynyard TAS 7325
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=37746 or tblfeedback.strbusinessname='Anthony Rogers Wedding Photos' or tblfeedback.strbusinessname='Anthony Rogers Wedding Photos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tara Dunstan Photography
Forest TAS 7330
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=26128 or tblfeedback.strbusinessname='Tara Dunstan Photography' or tblfeedback.strbusinessname='Tara Dunstan Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jai Moyle Photography
Devonport TAS 7310
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=37820 or tblfeedback.strbusinessname='Jai Moyle Photography' or tblfeedback.strbusinessname='Jai Moyle Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flick & Dave Photography
Sunnyside TAS 7305
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=25319 or tblfeedback.strbusinessname='Flick &%%semi%% Dave Photography' or tblfeedback.strbusinessname='Flick & Dave Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Caylee Wilson Photography
Launceston TAS 7250
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=37776 or tblfeedback.strbusinessname='Caylee Wilson Photography' or tblfeedback.strbusinessname='Caylee Wilson Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Estella Photography and Styling
Devonport TAS 7310
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=27966 or tblfeedback.strbusinessname='Estella Photography and Styling' or tblfeedback.strbusinessname='Estella Photography and Styling') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Daydream Photography
Railton TAS 7305
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=27751 or tblfeedback.strbusinessname='Daydream Photography' or tblfeedback.strbusinessname='Daydream Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kristy Lockwood Photgraphy
Latrobe TAS 7307
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=24938 or tblfeedback.strbusinessname='Kristy Lockwood Photgraphy' or tblfeedback.strbusinessname='Kristy Lockwood Photgraphy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dear Lola Photography
Longford TAS 7301
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=29132 or tblfeedback.strbusinessname='Dear Lola Photography' or tblfeedback.strbusinessname='Dear Lola Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Murphy Photograpy
Burnie TAS 7320
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=38270 or tblfeedback.strbusinessname='Murphy Photograpy' or tblfeedback.strbusinessname='Murphy Photograpy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Triple Photography
Ulverstone TAS 7315
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=5342 or tblfeedback.strbusinessname='Triple Photography' or tblfeedback.strbusinessname='Triple Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tierney Michael Photography
Stanley TAS 7331
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=3835 or tblfeedback.strbusinessname='Tierney Michael Photography' or tblfeedback.strbusinessname='Tierney Michael Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bob Iddon Photography
Ulverstone TAS 7315
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=5313 or tblfeedback.strbusinessname='Bob Iddon Photography' or tblfeedback.strbusinessname='Bob Iddon Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fleur Mcculloch
Burnie TAS 7320
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=5321 or tblfeedback.strbusinessname='Fleur Mcculloch' or tblfeedback.strbusinessname='Fleur Mcculloch') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sport Action Photography
Cooee TAS 7320
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=5339 or tblfeedback.strbusinessname='Sport Action Photography' or tblfeedback.strbusinessname='Sport Action Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pets Allowed Photographic Studio
Devonport TAS 7310
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=3820 or tblfeedback.strbusinessname='Pets Allowed Photographic Studio' or tblfeedback.strbusinessname='Pets Allowed Photographic Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alan Lesheim A R M I T
Rosegarland TAS 7140
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=5306 or tblfeedback.strbusinessname='Alan Lesheim A R M I T' or tblfeedback.strbusinessname='Alan Lesheim A R M I T') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Brett & Annette Dawes
Smithton TAS 7330
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=3787 or tblfeedback.strbusinessname='Brett &%%semi%% Annette Dawes' or tblfeedback.strbusinessname='Brett & Annette Dawes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Triple J Photography
Ulverstone TAS 7315
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=3837 or tblfeedback.strbusinessname='Triple J Photography' or tblfeedback.strbusinessname='Triple J Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ben Huisman Photography
Gunns Plains TAS 7315
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=5310 or tblfeedback.strbusinessname='Ben Huisman Photography' or tblfeedback.strbusinessname='Ben Huisman Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pictures By Darren Rist Photographer
Devonport TAS 7310
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=3773 or tblfeedback.strbusinessname='Pictures By Darren Rist Photographer' or tblfeedback.strbusinessname='Pictures By Darren Rist Photographer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hayes Photographics
Kindred TAS 7310
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=3802 or tblfeedback.strbusinessname='Hayes Photographics' or tblfeedback.strbusinessname='Hayes Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ben Huisman Photography
Ulverstone TAS 7315
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=3784 or tblfeedback.strbusinessname='Ben Huisman Photography' or tblfeedback.strbusinessname='Ben Huisman Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Darren Rist
Devonport TAS 7310
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=5317 or tblfeedback.strbusinessname='Darren Rist' or tblfeedback.strbusinessname='Darren Rist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Darren Rist
Port Sorell TAS 7307
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=5318 or tblfeedback.strbusinessname='Darren Rist' or tblfeedback.strbusinessname='Darren Rist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mark Seaton Photographs
Latrobe TAS 7307
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=19153 or tblfeedback.strbusinessname='Mark Seaton Photographs' or tblfeedback.strbusinessname='Mark Seaton Photographs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
G L Photography
Wesley Vale TAS 7307
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=3797 or tblfeedback.strbusinessname='G L Photography' or tblfeedback.strbusinessname='G L Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Coach House Video
Burnie TAS 7320
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=3791 or tblfeedback.strbusinessname='Coach House Video' or tblfeedback.strbusinessname='Coach House Video') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mark Seaton Photographics
Latrobe TAS 7307
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=3810 or tblfeedback.strbusinessname='Mark Seaton Photographics' or tblfeedback.strbusinessname='Mark Seaton Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Enright Photography
Deloraine TAS 7304
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=5320 or tblfeedback.strbusinessname='Enright Photography' or tblfeedback.strbusinessname='Enright Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating