Rating
Coolibah Downs
Nerang QLD 4211
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=18641 or tblfeedback.strbusinessname='Coolibah Downs' or tblfeedback.strbusinessname='Coolibah Downs') 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
All Souls and Saint Gabriels
Charters Towers QLD 4820
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=25645 or tblfeedback.strbusinessname='All Souls and Saint Gabriels' or tblfeedback.strbusinessname='All Souls and Saint Gabriels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Port Douglas Weddings
Port Douglas QLD 4871
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=16872 or tblfeedback.strbusinessname='Port Douglas Weddings' or tblfeedback.strbusinessname='Port Douglas Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hampton Estate Wines Tamborine Mountain
Tambourine Mountain QLD 4272
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=43733 or tblfeedback.strbusinessname='Hampton Estate Wines Tamborine Mountain' or tblfeedback.strbusinessname='Hampton Estate Wines Tamborine Mountain') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
All Souls and Saint Gabriels
Charters Towers QLD 4820
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=25646 or tblfeedback.strbusinessname='All Souls and Saint Gabriels' or tblfeedback.strbusinessname='All Souls and Saint Gabriels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Preston Manor and Village Chapel
Toowoomba QLD 4352
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=27707 or tblfeedback.strbusinessname='Preston Manor and Village Chapel' or tblfeedback.strbusinessname='Preston Manor and Village Chapel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bracknell Lodge
Wyreema QLD 4352
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=43337 or tblfeedback.strbusinessname='Bracknell Lodge' or tblfeedback.strbusinessname='Bracknell Lodge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
St. Mary's by the Sea
Port Douglas QLD 4871
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=18994 or tblfeedback.strbusinessname='St. Mary'%%semi%%s by the Sea' or tblfeedback.strbusinessname='St. Mary's by the Sea') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Palm Meadows Golf Course
Palm Meadows QLD 4211
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=18975 or tblfeedback.strbusinessname='Palm Meadows Golf Course' or tblfeedback.strbusinessname='Palm Meadows Golf Course') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
St Mary's by the Sea
Port Douglas QLD 4871
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=15574 or tblfeedback.strbusinessname='St Mary'%%semi%%s by the Sea' or tblfeedback.strbusinessname='St Mary's by the Sea') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15