Rating
Joanne Reeve's Calligraphy
Albury NSW 2640
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=9945 or tblfeedback.strbusinessname='Joanne Reeve'%%semi%%s Calligraphy' or tblfeedback.strbusinessname='Joanne Reeve's Calligraphy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mr's Ink Well
Albury NSW 2640
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=10585 or tblfeedback.strbusinessname='Mr'%%semi%%s Ink Well' or tblfeedback.strbusinessname='Mr's Ink Well') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pen on Parchment Calligraphy
Albury NSW 2640
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=10886 or tblfeedback.strbusinessname='Pen on Parchment Calligraphy' or tblfeedback.strbusinessname='Pen on Parchment Calligraphy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15