Rating
Liz Butcher
Wyndham WA 6740
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=4565 or tblfeedback.strbusinessname='Liz Butcher' or tblfeedback.strbusinessname='Liz Butcher') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Davies Betty
Carnarvon WA 6701
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=4495 or tblfeedback.strbusinessname='Davies Betty' or tblfeedback.strbusinessname='Davies Betty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Davies
Carnarvon WA 6701
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=6767 or tblfeedback.strbusinessname='Davies' or tblfeedback.strbusinessname='Davies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Graham Felicity
Kalbarri WA 6536
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=4518 or tblfeedback.strbusinessname='Graham Felicity' or tblfeedback.strbusinessname='Graham Felicity') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Peter Dunning
Port Hedland WA 6721
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=4587 or tblfeedback.strbusinessname='Peter Dunning' or tblfeedback.strbusinessname='Peter Dunning') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Melva Elvey
Karratha WA 6714
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=17583 or tblfeedback.strbusinessname='Melva Elvey' or tblfeedback.strbusinessname='Melva Elvey') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lambie
Broome WA 6725
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=6810 or tblfeedback.strbusinessname='Lambie' or tblfeedback.strbusinessname='Lambie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15