Rating
Spicers Clovelly Estate
Montville QLD 4560
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=37764 or tblfeedback.strbusinessname='Spicers Clovelly Estate' or tblfeedback.strbusinessname='Spicers Clovelly Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Chapel Montville
Montville QLD 4560
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=37686 or tblfeedback.strbusinessname='The Chapel Montville' or tblfeedback.strbusinessname='The Chapel Montville') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Weddings at Tiffany's
Maleny QLD 4552
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=25719 or tblfeedback.strbusinessname='Weddings at Tiffany'%%semi%%s' or tblfeedback.strbusinessname='Weddings at Tiffany's') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Annabella Chapel
Ilkley QLD 4554
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=35763 or tblfeedback.strbusinessname='Annabella Chapel' or tblfeedback.strbusinessname='Annabella Chapel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beerwah Hideaway
Beerwah QLD 4519
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=26818 or tblfeedback.strbusinessname='Beerwah Hideaway' or tblfeedback.strbusinessname='Beerwah Hideaway') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Obi Obi Hall
Obi Obi QLD 4574
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=37932 or tblfeedback.strbusinessname='Obi Obi Hall' or tblfeedback.strbusinessname='Obi Obi Hall') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sandstone Point Hotel
Sandstone Point QLD 4511
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=35679 or tblfeedback.strbusinessname='Sandstone Point Hotel' or tblfeedback.strbusinessname='Sandstone Point Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pelican Waters Golf Club
Pelican Waters QLD 4551
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=38314 or tblfeedback.strbusinessname='Pelican Waters Golf Club' or tblfeedback.strbusinessname='Pelican Waters Golf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Glengariff Historic Estate
Dayboro QLD 4521
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=18943 or tblfeedback.strbusinessname='Glengariff Historic Estate' or tblfeedback.strbusinessname='Glengariff Historic Estate') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Old Petrie Town
Whiteside QLD 4503
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=22036 or tblfeedback.strbusinessname='Old Petrie Town' or tblfeedback.strbusinessname='Old Petrie Town') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Clear Mountain Lodge
Clear Mountain QLD 4500
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=27087 or tblfeedback.strbusinessname='Clear Mountain Lodge' or tblfeedback.strbusinessname='Clear Mountain Lodge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Novotel Twin Waters Resort
Twin Waters QLD 4564
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=18702 or tblfeedback.strbusinessname='Novotel Twin Waters Resort' or tblfeedback.strbusinessname='Novotel Twin Waters Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cupid's Garden Weddings
Burpengary QLD 4505
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=15573 or tblfeedback.strbusinessname='Cupid'%%semi%%s Garden Weddings' or tblfeedback.strbusinessname='Cupid's Garden Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kallangur Memorial Bowls Club
Kallangur QLD 4503
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=18955 or tblfeedback.strbusinessname='Kallangur Memorial Bowls Club' or tblfeedback.strbusinessname='Kallangur Memorial Bowls Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating