Rating
Judith Mc Ginness
Geelong North VIC 3215
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=12716 or tblfeedback.strbusinessname='Judith Mc Ginness' or tblfeedback.strbusinessname='Judith Mc Ginness') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sign Lady The
Geelong North VIC 3215
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=12729 or tblfeedback.strbusinessname='Sign Lady The' or tblfeedback.strbusinessname='Sign Lady The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mc Nay
Lara VIC 3212
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=12724 or tblfeedback.strbusinessname='Mc Nay' or tblfeedback.strbusinessname='Mc Nay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15