Rating
Amy Rowsell
Port Lincoln SA 5606
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=26066 or tblfeedback.strbusinessname='Amy Rowsell' or tblfeedback.strbusinessname='Amy Rowsell') 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
Courtney Hewett Photography
Whyalla SA 5600
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=36222 or tblfeedback.strbusinessname='Courtney Hewett Photography' or tblfeedback.strbusinessname='Courtney Hewett 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
Bill Cole
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=4952 or tblfeedback.strbusinessname='Bill Cole' or tblfeedback.strbusinessname='Bill Cole') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tony Carey Photographers
Port Lincoln SA 5606
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=5115 or tblfeedback.strbusinessname='Tony Carey Photographers' or tblfeedback.strbusinessname='Tony Carey Photographers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Photo-Finish Studio
Cummins SA 5631
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=5068 or tblfeedback.strbusinessname='Photo-Finish Studio' or tblfeedback.strbusinessname='Photo-Finish Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cam Cap Video & Photography
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=4958 or tblfeedback.strbusinessname='Cam Cap Video &%%semi%% Photography' or tblfeedback.strbusinessname='Cam Cap Video & Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Janet Christian Photography
Port Lincoln SA 5606
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=5032 or tblfeedback.strbusinessname='Janet Christian Photography' or tblfeedback.strbusinessname='Janet Christian Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Nicholson's Video Promotions
Wangary SA 5607
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=5056 or tblfeedback.strbusinessname='Nicholson'%%semi%%s Video Promotions' or tblfeedback.strbusinessname='Nicholson's Video Promotions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15