Rating
Alpha Calligraphy
Kirrwan QLD 4817
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=1673 or tblfeedback.strbusinessname='Alpha Calligraphy' or tblfeedback.strbusinessname='Alpha Calligraphy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cairns Calligraphy Centre
Cairns QLD 4870
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=1682 or tblfeedback.strbusinessname='Cairns Calligraphy Centre' or tblfeedback.strbusinessname='Cairns Calligraphy Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dorothy Lucas
Mount Louisa QLD 4814
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=15190 or tblfeedback.strbusinessname='Dorothy Lucas' or tblfeedback.strbusinessname='Dorothy Lucas') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cairns Calligraphy Centre The
Cairns QLD 4870
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=15187 or tblfeedback.strbusinessname='Cairns Calligraphy Centre The' or tblfeedback.strbusinessname='Cairns Calligraphy Centre The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alpha Calligraphy
Kirwan QLD 4817
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=1656 or tblfeedback.strbusinessname='Alpha Calligraphy' or tblfeedback.strbusinessname='Alpha Calligraphy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15