Rating
Tickle Belly Hill
Saltia SA 5433
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=25768 or tblfeedback.strbusinessname='Tickle Belly Hill' or tblfeedback.strbusinessname='Tickle Belly Hill') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mill Motel Quorn
Quorn SA 5433
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=6464 or tblfeedback.strbusinessname='Mill Motel Quorn' or tblfeedback.strbusinessname='Mill Motel Quorn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hannahville Hotel
Port Augusta SA 5700
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=6434 or tblfeedback.strbusinessname='Hannahville Hotel' or tblfeedback.strbusinessname='Hannahville Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
ANI Cooinda Club
Port Augusta SA 5700
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=6361 or tblfeedback.strbusinessname='ANI Cooinda Club' or tblfeedback.strbusinessname='ANI Cooinda Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Spear Creek Tourism & Training Centre
Stirling North SA 5710
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=6516 or tblfeedback.strbusinessname='Spear Creek Tourism &%%semi%% Training Centre' or tblfeedback.strbusinessname='Spear Creek Tourism & Training Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Foreshore Motor Inn
Whyalla SA 5600
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=6418 or tblfeedback.strbusinessname='Foreshore Motor Inn' or tblfeedback.strbusinessname='Foreshore Motor Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Grand Tasman Hotel
Port Lincoln SA 5606
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=6426 or tblfeedback.strbusinessname='Grand Tasman Hotel' or tblfeedback.strbusinessname='Grand Tasman Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Westland Hotel
Whyalla Norrie SA 5608
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=19243 or tblfeedback.strbusinessname='Westland Hotel' or tblfeedback.strbusinessname='Westland Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15