Rating
Dianne Waterton
Kalgoorlie WA 6430
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=26559 or tblfeedback.strbusinessname='Dianne Waterton' or tblfeedback.strbusinessname='Dianne Waterton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Earle
Beresford WA 6530
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=6775 or tblfeedback.strbusinessname='Earle' or tblfeedback.strbusinessname='Earle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Taylor
Moora WA 6510
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=6840 or tblfeedback.strbusinessname='Taylor' or tblfeedback.strbusinessname='Taylor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Johnstone
Toodyay WA 6566
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=6803 or tblfeedback.strbusinessname='Johnstone' or tblfeedback.strbusinessname='Johnstone') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Starr Sue
Esperance WA 6450
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=4600 or tblfeedback.strbusinessname='Starr Sue' or tblfeedback.strbusinessname='Starr Sue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mike Lalor
Esperance WA 6450
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=4576 or tblfeedback.strbusinessname='Mike Lalor' or tblfeedback.strbusinessname='Mike Lalor') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dauphin Barbara
Boulder WA 6432
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=4492 or tblfeedback.strbusinessname='Dauphin Barbara' or tblfeedback.strbusinessname='Dauphin Barbara') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tomlinson N
Mt Tarcoola WA 6530
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=4606 or tblfeedback.strbusinessname='Tomlinson N' or tblfeedback.strbusinessname='Tomlinson N') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Johnstone G
Toodyay WA 6566
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=4547 or tblfeedback.strbusinessname='Johnstone G' or tblfeedback.strbusinessname='Johnstone G') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Taylor Ron L
Moora WA 6510
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=4601 or tblfeedback.strbusinessname='Taylor Ron L' or tblfeedback.strbusinessname='Taylor Ron L') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Leighton Pat FCA
Kalgoorlie WA 6430
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=4563 or tblfeedback.strbusinessname='Leighton Pat FCA' or tblfeedback.strbusinessname='Leighton Pat FCA') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Finlayson M.R. (JP)
Kalgoorlie WA 6430
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=4513 or tblfeedback.strbusinessname='Finlayson M.R. (%%semi%%JP)%%semi%%' or tblfeedback.strbusinessname='Finlayson M.R. (JP)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tomlinson
Mount Tarcoola WA 6530
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=6844 or tblfeedback.strbusinessname='Tomlinson' or tblfeedback.strbusinessname='Tomlinson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Leighton
Kalgoorlie WA 6430
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=6811 or tblfeedback.strbusinessname='Leighton' or tblfeedback.strbusinessname='Leighton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Batten A G
Gingin WA 6503
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=4459 or tblfeedback.strbusinessname='Batten A G' or tblfeedback.strbusinessname='Batten A G') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kathleen M. Stanick
Boulder WA 6432
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=4450 or tblfeedback.strbusinessname='Kathleen M. Stanick' or tblfeedback.strbusinessname='Kathleen M. Stanick') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Everett
Kalgoorlie WA 6430
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=6784 or tblfeedback.strbusinessname='Everett' or tblfeedback.strbusinessname='Everett') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Walker Maxine J.
Toodyay WA 6566
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=4610 or tblfeedback.strbusinessname='Walker Maxine J.' or tblfeedback.strbusinessname='Walker Maxine J.') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Finlayson
Kalgoorlie WA 6430
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=6786 or tblfeedback.strbusinessname='Finlayson' or tblfeedback.strbusinessname='Finlayson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Everett Kerry Patricia (JP)
Kalgoorlie WA 6430
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=4510 or tblfeedback.strbusinessname='Everett Kerry Patricia (%%semi%%JP)%%semi%%' or tblfeedback.strbusinessname='Everett Kerry Patricia (JP)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Batten
Gingin WA 6503
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=6736 or tblfeedback.strbusinessname='Batten' or tblfeedback.strbusinessname='Batten') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Starr
Esperance WA 6450
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=6839 or tblfeedback.strbusinessname='Starr' or tblfeedback.strbusinessname='Starr') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cahill
Merredin WA 6415
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=6754 or tblfeedback.strbusinessname='Cahill' or tblfeedback.strbusinessname='Cahill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kelman James
Esperance WA 6450
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=4553 or tblfeedback.strbusinessname='Kelman James' or tblfeedback.strbusinessname='Kelman James') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Walker
Toodyay WA 6566
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=6847 or tblfeedback.strbusinessname='Walker' or tblfeedback.strbusinessname='Walker') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cahill Mrs Rewa
Merredin WA 6415
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=4480 or tblfeedback.strbusinessname='Cahill Mrs Rewa' or tblfeedback.strbusinessname='Cahill Mrs Rewa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Capricorn Ceremonies
Beresford WA 6530
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=4481 or tblfeedback.strbusinessname='Capricorn Ceremonies' or tblfeedback.strbusinessname='Capricorn Ceremonies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bonnie Stanger
Geraldton WA 6530
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=4468 or tblfeedback.strbusinessname='Bonnie Stanger' or tblfeedback.strbusinessname='Bonnie Stanger') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15