Rating
Macadam Jim OAM
Anula 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=5155 or tblfeedback.strbusinessname='Macadam Jim OAM' or tblfeedback.strbusinessname='Macadam Jim OAM') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lovell
Woodroffe NT 0830
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=5151 or tblfeedback.strbusinessname='Lovell' or tblfeedback.strbusinessname='Lovell') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Marriage Celebrants
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=5154 or tblfeedback.strbusinessname='Marriage Celebrants' or tblfeedback.strbusinessname='Marriage Celebrants') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Stripling
Rapid Creek 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=5136 or tblfeedback.strbusinessname='Stripling' or tblfeedback.strbusinessname='Stripling') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hart
Wulagi 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=5147 or tblfeedback.strbusinessname='Hart' or tblfeedback.strbusinessname='Hart') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wright
Wanguri 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=5156 or tblfeedback.strbusinessname='Wright' or tblfeedback.strbusinessname='Wright') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kirke
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=5153 or tblfeedback.strbusinessname='Kirke' or tblfeedback.strbusinessname='Kirke') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Saxon
Malak 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=5149 or tblfeedback.strbusinessname='Saxon' or tblfeedback.strbusinessname='Saxon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Turner
Alawa 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=5150 or tblfeedback.strbusinessname='Turner' or tblfeedback.strbusinessname='Turner') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Davies
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=5139 or tblfeedback.strbusinessname='Davies' or tblfeedback.strbusinessname='Davies') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lawrie
Nightcliff 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=5152 or tblfeedback.strbusinessname='Lawrie' or tblfeedback.strbusinessname='Lawrie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wendy Kirke
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=19242 or tblfeedback.strbusinessname='Wendy Kirke' or tblfeedback.strbusinessname='Wendy Kirke') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Dawn
Nightcliff 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=5146 or tblfeedback.strbusinessname='Dawn' or tblfeedback.strbusinessname='Dawn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Andrew
Stuart Park 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=5137 or tblfeedback.strbusinessname='Andrew' or tblfeedback.strbusinessname='Andrew') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15