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
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
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
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
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
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 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
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
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
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
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
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
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
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
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
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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