Rating
Leonie Colley Calligrapher
Davistown NSW 2251
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=1492 or tblfeedback.strbusinessname='Leonie Colley Calligrapher' or tblfeedback.strbusinessname='Leonie Colley Calligrapher') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hop To It Graphics
Tuggerawong NSW 2259
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=9720 or tblfeedback.strbusinessname='Hop To It Graphics' or tblfeedback.strbusinessname='Hop To It Graphics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pauline Stone Calligrapher
Niagara Park NSW 2250
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=10870 or tblfeedback.strbusinessname='Pauline Stone Calligrapher' or tblfeedback.strbusinessname='Pauline Stone Calligrapher') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15