Rating
Beresford Estate
McLaren Flat SA 5171
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=46799 or tblfeedback.strbusinessname='Beresford Estate' or tblfeedback.strbusinessname='Beresford Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blok Gardens
Mt Gambier SA 5290
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=27166 or tblfeedback.strbusinessname='Blok Gardens' or tblfeedback.strbusinessname='Blok Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kuitpo Hall
Kuitpo SA 5201
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=28992 or tblfeedback.strbusinessname='Kuitpo Hall' or tblfeedback.strbusinessname='Kuitpo Hall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Commodore on the Park
Mt Gambier SA 5290
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=19073 or tblfeedback.strbusinessname='Commodore on the Park' or tblfeedback.strbusinessname='Commodore on the Park') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Barn Palais
Mount Gambier SA 5290
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=27449 or tblfeedback.strbusinessname='The Barn Palais' or tblfeedback.strbusinessname='The Barn Palais') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blok Gardens - Hayley Blok
Mount Gambier SA 5290
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=24538 or tblfeedback.strbusinessname='Blok Gardens - Hayley Blok' or tblfeedback.strbusinessname='Blok Gardens - Hayley Blok') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mount Gambier Racing Club Incorporated
Mount Gambier SA 5290
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=6465 or tblfeedback.strbusinessname='Mount Gambier Racing Club Incorporated' or tblfeedback.strbusinessname='Mount Gambier Racing Club Incorporated') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hermitage Cafe & Wine Bar
Penola SA 5277
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=6439 or tblfeedback.strbusinessname='Hermitage Cafe &%%semi%% Wine Bar' or tblfeedback.strbusinessname='Hermitage Cafe & Wine Bar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Commodore Motel
Mount Gambier SA 5290
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=6398 or tblfeedback.strbusinessname='Commodore Motel' or tblfeedback.strbusinessname='Commodore Motel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mandarin Restaurant
Mount Gambier SA 5290
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=6456 or tblfeedback.strbusinessname='Mandarin Restaurant' or tblfeedback.strbusinessname='Mandarin Restaurant') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tantanoola Cottage Gardens
Tantanoola SA 5280
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=6528 or tblfeedback.strbusinessname='Tantanoola Cottage Gardens' or tblfeedback.strbusinessname='Tantanoola Cottage Gardens') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lakes Resort Mount Gambier
Mount Gambier SA 5290
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=6452 or tblfeedback.strbusinessname='Lakes Resort Mount Gambier' or tblfeedback.strbusinessname='Lakes Resort Mount Gambier') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15