Rating
Overland Motel Kalgoorlie
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=26557 or tblfeedback.strbusinessname='Overland Motel Kalgoorlie' or tblfeedback.strbusinessname='Overland Motel Kalgoorlie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Core Cider House
Pickering Brook WA 6076
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=24959 or tblfeedback.strbusinessname='Core Cider House' or tblfeedback.strbusinessname='Core Cider House') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Muresk
Northam WA 6401
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=4118 or tblfeedback.strbusinessname='Muresk' or tblfeedback.strbusinessname='Muresk') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
WA School of Mines
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=7430 or tblfeedback.strbusinessname='WA School of Mines' or tblfeedback.strbusinessname='WA School of Mines') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Toko's Restaurant
Dongara WA 6525
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=7426 or tblfeedback.strbusinessname='Toko'%%semi%%s Restaurant' or tblfeedback.strbusinessname='Toko's Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Newfields Reception Centre
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=4122 or tblfeedback.strbusinessname='Newfields Reception Centre' or tblfeedback.strbusinessname='Newfields Reception Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kalgoorlie Railway Motel & Function Centre
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=4094 or tblfeedback.strbusinessname='Kalgoorlie Railway Motel &%%semi%% Function Centre' or tblfeedback.strbusinessname='Kalgoorlie Railway Motel & Function Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Albion Shamrock Motor Hotel
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=4035 or tblfeedback.strbusinessname='Albion Shamrock Motor Hotel' or tblfeedback.strbusinessname='Albion Shamrock Motor Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Eastern Goldfields Italian Club
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=4070 or tblfeedback.strbusinessname='Eastern Goldfields Italian Club' or tblfeedback.strbusinessname='Eastern Goldfields Italian Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
UniServices Kalgoorlie Pty Ltd
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=4166 or tblfeedback.strbusinessname='UniServices Kalgoorlie Pty Ltd' or tblfeedback.strbusinessname='UniServices Kalgoorlie Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mercure Inn Wintersun Geraldton
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=4111 or tblfeedback.strbusinessname='Mercure Inn Wintersun Geraldton' or tblfeedback.strbusinessname='Mercure Inn Wintersun Geraldton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15