Rating
Wild AT Art
Walkerville SA 5081
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=5731 or tblfeedback.strbusinessname='Wild AT Art' or tblfeedback.strbusinessname='Wild AT Art') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Calligraphy Connexion
Glengowrie SA 5044
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=5720 or tblfeedback.strbusinessname='Calligraphy Connexion' or tblfeedback.strbusinessname='Calligraphy Connexion') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Gerbera Room The
Valley View SA 5093
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=5725 or tblfeedback.strbusinessname='Gerbera Room The' or tblfeedback.strbusinessname='Gerbera Room The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Fifth Avenue of Hyde Park
Hyde Park SA 5061
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=5724 or tblfeedback.strbusinessname='Fifth Avenue of Hyde Park' or tblfeedback.strbusinessname='Fifth Avenue of Hyde Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Harrison
Windsor Gardens SA 5087
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=5726 or tblfeedback.strbusinessname='Harrison' or tblfeedback.strbusinessname='Harrison') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Calligraphy Productions
Klemzig SA 5087
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=5721 or tblfeedback.strbusinessname='Calligraphy Productions' or tblfeedback.strbusinessname='Calligraphy Productions') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Zimmermann
Flagstaff Hill SA 5159
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=5732 or tblfeedback.strbusinessname='Zimmermann' or tblfeedback.strbusinessname='Zimmermann') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lamb
Prospect SA 5082
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=5727 or tblfeedback.strbusinessname='Lamb' or tblfeedback.strbusinessname='Lamb') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sheaffer
Underdale SA 5032
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=5730 or tblfeedback.strbusinessname='Sheaffer' or tblfeedback.strbusinessname='Sheaffer') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Calligraphy by Pamela
Highbury SA 5089
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=5719 or tblfeedback.strbusinessname='Calligraphy by Pamela' or tblfeedback.strbusinessname='Calligraphy by Pamela') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Scribe Calligraphy The
Adelaide SA 5000
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=5729 or tblfeedback.strbusinessname='Scribe Calligraphy The' or tblfeedback.strbusinessname='Scribe Calligraphy The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Calligraphy Society of S A The
Rundle Mall SA 5000
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=5722 or tblfeedback.strbusinessname='Calligraphy Society of S A The' or tblfeedback.strbusinessname='Calligraphy Society of S A The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Margaret Lewis
Broadview SA 5083
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=5728 or tblfeedback.strbusinessname='Margaret Lewis' or tblfeedback.strbusinessname='Margaret Lewis') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Calligraphics
Greenwith SA 5125
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=5718 or tblfeedback.strbusinessname='Calligraphics' or tblfeedback.strbusinessname='Calligraphics') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15