Rating
Julie Williams Calligraphy
Newport NSW 2106
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=24921 or tblfeedback.strbusinessname='Julie Williams Calligraphy' or tblfeedback.strbusinessname='Julie Williams Calligraphy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Marta Lett
Nambucca Heads NSW 2448
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=10402 or tblfeedback.strbusinessname='Marta Lett' or tblfeedback.strbusinessname='Marta Lett') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lisa's Art & Calligraphy
Lismore NSW 2480
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=10237 or tblfeedback.strbusinessname='Lisa'%%semi%%s Art &%%semi%% Calligraphy' or tblfeedback.strbusinessname='Lisa's Art & Calligraphy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Top Cat Calligraphics
Evans Head NSW 2473
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=11745 or tblfeedback.strbusinessname='Top Cat Calligraphics' or tblfeedback.strbusinessname='Top Cat Calligraphics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Venner
Uki NSW 2484
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=11859 or tblfeedback.strbusinessname='Venner' or tblfeedback.strbusinessname='Venner') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15