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
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
Mil Lel Memorial Hall
Mil Lel SA 5291
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=38335 or tblfeedback.strbusinessname='Mil Lel Memorial Hall' or tblfeedback.strbusinessname='Mil Lel Memorial Hall') 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
Margaret's Salon
Kingston Se SA 5275
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=6460 or tblfeedback.strbusinessname='Margaret'%%semi%%s Salon' or tblfeedback.strbusinessname='Margaret's Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
Chardonnay Lodge
Coonawarra SA 5263
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=6387 or tblfeedback.strbusinessname='Chardonnay Lodge' or tblfeedback.strbusinessname='Chardonnay Lodge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
Bordertown Hotel
Bordertown SA 5268
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=6376 or tblfeedback.strbusinessname='Bordertown Hotel' or tblfeedback.strbusinessname='Bordertown Hotel') 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