Rating
Castaways Resort and Spa
Mission Beach QLD 4852
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=22702 or tblfeedback.strbusinessname='Castaways Resort and Spa' or tblfeedback.strbusinessname='Castaways Resort and Spa') 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
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
Lumberjacks events wedding venue
Herveys Range QLD 4817
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=43576 or tblfeedback.strbusinessname='Lumberjacks events wedding venue' or tblfeedback.strbusinessname='Lumberjacks events wedding venue') 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
Townsville Heritage Centre
Townsville QLD 4810
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=25961 or tblfeedback.strbusinessname='Townsville Heritage Centre' or tblfeedback.strbusinessname='Townsville Heritage Centre') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Villa Botanica
Woodwark QLD 4802
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=21931 or tblfeedback.strbusinessname='Villa Botanica' or tblfeedback.strbusinessname='Villa Botanica') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cape Gloucester Resort
Hideaway Bay QLD 4800
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=35731 or tblfeedback.strbusinessname='Cape Gloucester Resort' or tblfeedback.strbusinessname='Cape Gloucester Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Greenmount Homestead
Walkerston QLD 4751
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=25691 or tblfeedback.strbusinessname='Greenmount Homestead' or tblfeedback.strbusinessname='Greenmount Homestead') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Ville Resort Casino
Townsville QLD 4810
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=43627 or tblfeedback.strbusinessname='The Ville Resort Casino' or tblfeedback.strbusinessname='The Ville Resort Casino') 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
HerveyRange Heritage Tea Rooms
Townsville QLD 4817
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=38501 or tblfeedback.strbusinessname='HerveyRange Heritage Tea Rooms' or tblfeedback.strbusinessname='HerveyRange Heritage Tea Rooms') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Elite Barn Weddings
Hervey Range QLD 4817
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=41744 or tblfeedback.strbusinessname='Elite Barn Weddings' or tblfeedback.strbusinessname='Elite Barn Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
St James Cathedral
Townsville QLD 4810
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=26157 or tblfeedback.strbusinessname='St James Cathedral' or tblfeedback.strbusinessname='St James Cathedral') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Whitsunday Sands Resort
Bowen QLD 4805
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=41645 or tblfeedback.strbusinessname='Whitsunday Sands Resort' or tblfeedback.strbusinessname='Whitsunday Sands Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
South Pacific Bridal
Cairns QLD 4870
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=27068 or tblfeedback.strbusinessname='South Pacific Bridal' or tblfeedback.strbusinessname='South Pacific Bridal') 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
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
Rating
Holiday Inn Hotels
Townsville QLD 4810
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=18949 or tblfeedback.strbusinessname='Holiday Inn Hotels' or tblfeedback.strbusinessname='Holiday Inn Hotels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tradewinds Chapel by the Sea
Cairns QLD 4870
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=15575 or tblfeedback.strbusinessname='Tradewinds Chapel by the Sea' or tblfeedback.strbusinessname='Tradewinds Chapel by the Sea') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15