Rating
Anthony Rogers Wedding Photos & Videos
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=25754 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
Prime Perspectives
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=37989 or tblfeedback.strbusinessname='Prime Perspectives' or tblfeedback.strbusinessname='Prime Perspectives') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Folktale Films
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=29704 or tblfeedback.strbusinessname='Folktale Films' or tblfeedback.strbusinessname='Folktale Films') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Yamina Gold
Gravelly Beach TAS 7276
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=25990 or tblfeedback.strbusinessname='Yamina Gold' or tblfeedback.strbusinessname='Yamina Gold') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tassie Visuals
Summerhill 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=35784 or tblfeedback.strbusinessname='Tassie Visuals' or tblfeedback.strbusinessname='Tassie Visuals') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Video Image Productions
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=5398 or tblfeedback.strbusinessname='Video Image Productions' or tblfeedback.strbusinessname='Video Image Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Steve Radford Videography
Trevallyn 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=3829 or tblfeedback.strbusinessname='Steve Radford Videography' or tblfeedback.strbusinessname='Steve Radford Videography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15