Rating
Bryant
Thornton NSW 2322
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=8410 or tblfeedback.strbusinessname='Bryant' or tblfeedback.strbusinessname='Bryant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kimway Designer Signs
Wallsend NSW 2287
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=10080 or tblfeedback.strbusinessname='Kimway Designer Signs' or tblfeedback.strbusinessname='Kimway Designer Signs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Margaret Lia
Charlestown NSW 2290
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=10372 or tblfeedback.strbusinessname='Margaret Lia' or tblfeedback.strbusinessname='Margaret Lia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Davies
Cardiff NSW 2285
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=8936 or tblfeedback.strbusinessname='Davies' or tblfeedback.strbusinessname='Davies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Collene Kalb
Warners Bay NSW 2282
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=8758 or tblfeedback.strbusinessname='Collene Kalb' or tblfeedback.strbusinessname='Collene Kalb') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15