Rating
Bark Hut Inn
Stuart NT 0822
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=43466 or tblfeedback.strbusinessname='Bark Hut Inn' or tblfeedback.strbusinessname='Bark Hut Inn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Anantara Bophut Koh Samui
Bophut Bay VIC 84320
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=37862 or tblfeedback.strbusinessname='Anantara Bophut Koh Samui' or tblfeedback.strbusinessname='Anantara Bophut Koh Samui') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Darwin Free Spirit Resort
Holtze NT 0829
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=29184 or tblfeedback.strbusinessname='Darwin Free Spirit Resort' or tblfeedback.strbusinessname='Darwin Free Spirit Resort') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Regency Party Hire
Parap NT 0820
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=4772 or tblfeedback.strbusinessname='Regency Party Hire' or tblfeedback.strbusinessname='Regency Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
All Seasons Frontier Darwin Hotel
Darwin NT 0800
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=4757 or tblfeedback.strbusinessname='All Seasons Frontier Darwin Hotel' or tblfeedback.strbusinessname='All Seasons Frontier Darwin Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Skycity Casino
Darwin NT 0800
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=19200 or tblfeedback.strbusinessname='Skycity Casino' or tblfeedback.strbusinessname='Skycity Casino') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
All Seasons Premier Darwin Central Hotel
Darwin NT 0800
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=4760 or tblfeedback.strbusinessname='All Seasons Premier Darwin Central Hotel' or tblfeedback.strbusinessname='All Seasons Premier Darwin Central Hotel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Carlton Hotel Darwin
Darwin NT 0800
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=4762 or tblfeedback.strbusinessname='Carlton Hotel Darwin' or tblfeedback.strbusinessname='Carlton Hotel Darwin') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Centra Darwin
Darwin NT 0800
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=4763 or tblfeedback.strbusinessname='Centra Darwin' or tblfeedback.strbusinessname='Centra Darwin') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pee Wee's AT the Point
Darwin NT 0800
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=4771 or tblfeedback.strbusinessname='Pee Wee'%%semi%%s AT the Point' or tblfeedback.strbusinessname='Pee Wee's AT the Point') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Darwin Party Hire
Berrimah NT 0828
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=4765 or tblfeedback.strbusinessname='Darwin Party Hire' or tblfeedback.strbusinessname='Darwin Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
C & C Catering
Sanderson NT 0813
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=4761 or tblfeedback.strbusinessname='C &%%semi%% C Catering' or tblfeedback.strbusinessname='C & C Catering') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Darwin Surf Club
Casuarina NT 0810
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=19082 or tblfeedback.strbusinessname='Darwin Surf Club' or tblfeedback.strbusinessname='Darwin Surf Club') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Schubert's Beachfront
Casuarina NT 0810
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=4774 or tblfeedback.strbusinessname='Schubert'%%semi%%s Beachfront' or tblfeedback.strbusinessname='Schubert's Beachfront') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Shadeworks Hire
Winnellie NT 0820
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=4777 or tblfeedback.strbusinessname='Shadeworks Hire' or tblfeedback.strbusinessname='Shadeworks Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Marrara Indoor Stadium
Marrara NT 0812
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=4769 or tblfeedback.strbusinessname='Marrara Indoor Stadium' or tblfeedback.strbusinessname='Marrara Indoor Stadium') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Furlanos
Darwin NT 0800
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=4766 or tblfeedback.strbusinessname='Furlanos' or tblfeedback.strbusinessname='Furlanos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Schubert's Catering Services
Casuarina NT 0810
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=4775 or tblfeedback.strbusinessname='Schubert'%%semi%%s Catering Services' or tblfeedback.strbusinessname='Schubert's Catering Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Novotel Atrium
Darwin NT 0800
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=19163 or tblfeedback.strbusinessname='Novotel Atrium' or tblfeedback.strbusinessname='Novotel Atrium') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rydges Plaza Darwin
Darwin NT 0800
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=4773 or tblfeedback.strbusinessname='Rydges Plaza Darwin' or tblfeedback.strbusinessname='Rydges Plaza Darwin') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Territory Party Hire
Coconut Grove NT 0810
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=4778 or tblfeedback.strbusinessname='Territory Party Hire' or tblfeedback.strbusinessname='Territory Party Hire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Crustaceans on the Wharf
Darwin NT 0800
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=4764 or tblfeedback.strbusinessname='Crustaceans on the Wharf' or tblfeedback.strbusinessname='Crustaceans on the Wharf') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Pee Wees at the Point
Darwin NT 0820
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=19169 or tblfeedback.strbusinessname='Pee Wees at the Point' or tblfeedback.strbusinessname='Pee Wees at the Point') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Novotel Atrium Darwin
Darwin NT 0800
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=4770 or tblfeedback.strbusinessname='Novotel Atrium Darwin' or tblfeedback.strbusinessname='Novotel Atrium Darwin') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15