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
Kerin Burford Photography
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=5038 or tblfeedback.strbusinessname='Kerin Burford Photography' or tblfeedback.strbusinessname='Kerin Burford 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
SMC Studios
Brisbane QLD 4000
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=30309 or tblfeedback.strbusinessname='SMC Studios' or tblfeedback.strbusinessname='SMC Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Renni Maitland 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=46038 or tblfeedback.strbusinessname='Renni Maitland Photography' or tblfeedback.strbusinessname='Renni Maitland Photography') 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
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
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
Shae Estella Photo
Sunshine Coast QLD 4551
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=38126 or tblfeedback.strbusinessname='Shae Estella Photo' or tblfeedback.strbusinessname='Shae Estella Photo') 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
Elope Australia
Mornington Peninsula VIC 3944
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=46401 or tblfeedback.strbusinessname='Elope Australia' or tblfeedback.strbusinessname='Elope Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
La Moment Photography
Melbourne VIC 3000
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=43976 or tblfeedback.strbusinessname='La Moment Photography' or tblfeedback.strbusinessname='La Moment Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jade Norwood
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=21470 or tblfeedback.strbusinessname='Jade Norwood' or tblfeedback.strbusinessname='Jade Norwood') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bubbles of Sunshine Photography
Whyalla SA 5608
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=42857 or tblfeedback.strbusinessname='Bubbles of Sunshine Photography' or tblfeedback.strbusinessname='Bubbles of Sunshine Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
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
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