Rating
Debbie Goerner Photography
Goolwa SA 5214
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=37954 or tblfeedback.strbusinessname='Debbie Goerner Photography' or tblfeedback.strbusinessname='Debbie Goerner 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
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 Janeway Photography
Mount Gambier SA 5290
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=22329 or tblfeedback.strbusinessname='Kristy Janeway Photography' or tblfeedback.strbusinessname='Kristy Janeway Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Todd's Photographics
Mount Gambier SA 5290
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=5114 or tblfeedback.strbusinessname='Todd'%%semi%%s Photographics' or tblfeedback.strbusinessname='Todd's Photographics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Frank Monger
Mount Gambier SA 5290
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=5008 or tblfeedback.strbusinessname='Frank Monger' or tblfeedback.strbusinessname='Frank Monger') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Morris Peter Photography
Mount Gambier SA 5290
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=5054 or tblfeedback.strbusinessname='Morris Peter Photography' or tblfeedback.strbusinessname='Morris Peter Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Graham Spring Photography
Mount Gambier SA 5290
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=5013 or tblfeedback.strbusinessname='Graham Spring Photography' or tblfeedback.strbusinessname='Graham Spring Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Telephoto
Mount Gambier SA 5290
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=5108 or tblfeedback.strbusinessname='Telephoto' or tblfeedback.strbusinessname='Telephoto') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Donna Fennell Photography
Glencoe SA 5291
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=4992 or tblfeedback.strbusinessname='Donna Fennell Photography' or tblfeedback.strbusinessname='Donna Fennell Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Telephoto
Mt Gambier SA 5290
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=19218 or tblfeedback.strbusinessname='Telephoto' or tblfeedback.strbusinessname='Telephoto') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Spring Studio
Mount Gambier SA 5290
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=5097 or tblfeedback.strbusinessname='Spring Studio' or tblfeedback.strbusinessname='Spring Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Frank Monger Photography
Mount Gambier SA 5290
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=6342 or tblfeedback.strbusinessname='Frank Monger Photography' or tblfeedback.strbusinessname='Frank Monger Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Colortech Studio
Worrolong SA 5291
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=4979 or tblfeedback.strbusinessname='Colortech Studio' or tblfeedback.strbusinessname='Colortech Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15