Rating Noosa Boathouse
Noosa Boathouse
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=19543 or tblfeedback.strbusinessname='Noosa Boathouse' or tblfeedback.strbusinessname='Noosa Boathouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
When unique is what you're looking for....

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
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=27544 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
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
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
King Fisher Bay Resort
Fraser Island QLD 4581
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=23526 or tblfeedback.strbusinessname='King Fisher Bay Resort' or tblfeedback.strbusinessname='King Fisher Bay Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
AnnaBella The Wedding 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 The Wedding Chapel' or tblfeedback.strbusinessname='AnnaBella The Wedding Chapel') 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
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
The Barn Cooroibah
Cooroibah QLD 4565
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=43096 or tblfeedback.strbusinessname='The Barn Cooroibah' or tblfeedback.strbusinessname='The Barn Cooroibah') 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
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
Ocean View Estates Winery and Restaurant
Ocean View 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=22071 or tblfeedback.strbusinessname='Ocean View Estates Winery and Restaurant' or tblfeedback.strbusinessname='Ocean View Estates Winery and Restaurant') 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
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
Montvale at 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=43402 or tblfeedback.strbusinessname='Montvale at Montville' or tblfeedback.strbusinessname='Montvale at Montville') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rosendals Tradgard
Sweden NSW 2000
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=41702 or tblfeedback.strbusinessname='Rosendals Tradgard' or tblfeedback.strbusinessname='Rosendals Tradgard') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Old Dairy Maleny
Bald Knob 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=42856 or tblfeedback.strbusinessname='The Old Dairy Maleny' or tblfeedback.strbusinessname='The Old Dairy Maleny') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Purnella Park Coachhouse
Hervey Bay QLD 4655
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=41631 or tblfeedback.strbusinessname='Purnella Park Coachhouse' or tblfeedback.strbusinessname='Purnella Park Coachhouse') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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