Rating
The Chapel Studio
Naracoorte SA 5271
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=26182 or tblfeedback.strbusinessname='The Chapel Studio' or tblfeedback.strbusinessname='The Chapel Studio') 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
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
Magic Memories by Erika
Port Augusta SA 5700
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=25766 or tblfeedback.strbusinessname='Magic Memories by Erika' or tblfeedback.strbusinessname='Magic Memories by Erika') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
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
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
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
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