Rating
Shakey
Fremantle WA 6160
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=29469 or tblfeedback.strbusinessname='Shakey' or tblfeedback.strbusinessname='Shakey') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mystrie
Perth WA 6000
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=29361 or tblfeedback.strbusinessname='Mystrie' or tblfeedback.strbusinessname='Mystrie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Calligraphy Plus
Willetton WA 6155
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=3620 or tblfeedback.strbusinessname='Calligraphy Plus' or tblfeedback.strbusinessname='Calligraphy Plus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Feather and Floret
Riverton WA 6148
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=29448 or tblfeedback.strbusinessname='Feather and Floret' or tblfeedback.strbusinessname='Feather and Floret') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lannah Sawers-Diggins
Applecross WA 6153
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=3641 or tblfeedback.strbusinessname='Lannah Sawers-Diggins' or tblfeedback.strbusinessname='Lannah Sawers-Diggins') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rosemary Johnston
Fremantle WA 6160
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=6707 or tblfeedback.strbusinessname='Rosemary Johnston' or tblfeedback.strbusinessname='Rosemary Johnston') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ceejae Designs
Craigie WA 6025
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=3621 or tblfeedback.strbusinessname='Ceejae Designs' or tblfeedback.strbusinessname='Ceejae Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Calligraphy by Angi
Duncraig WA 6023
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=3619 or tblfeedback.strbusinessname='Calligraphy by Angi' or tblfeedback.strbusinessname='Calligraphy by Angi') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Classique Calligraphy
Atwell WA 6164
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=3623 or tblfeedback.strbusinessname='Classique Calligraphy' or tblfeedback.strbusinessname='Classique Calligraphy') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Moira's Calligraphy Services
Woodvale WA 6026
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=3645 or tblfeedback.strbusinessname='Moira'%%semi%%s Calligraphy Services' or tblfeedback.strbusinessname='Moira's Calligraphy Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15