Rating
Alana Read
North Rockhampton QLD 4701
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=15183 or tblfeedback.strbusinessname='Alana Read' or tblfeedback.strbusinessname='Alana Read') 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
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
Deb's Calligraphy
Mackay QLD 4740
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=1702 or tblfeedback.strbusinessname='Deb'%%semi%%s Calligraphy' or tblfeedback.strbusinessname='Deb's Calligraphy') 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