Rating
NK Darwin Hair & Make Up
Palmerston 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=29601 or tblfeedback.strbusinessname='NK Darwin Hair &%%semi%% Make Up' or tblfeedback.strbusinessname='NK Darwin Hair & Make Up') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Uzuri Hair Studio
Darwin city 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=46483 or tblfeedback.strbusinessname='Uzuri Hair Studio' or tblfeedback.strbusinessname='Uzuri Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Flayr
NSW
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=38132 or tblfeedback.strbusinessname='Flayr' or tblfeedback.strbusinessname='Flayr') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
First Beauty - Darwin Hair and Makeup Artist
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=27315 or tblfeedback.strbusinessname='First Beauty - Darwin Hair and Makeup Artist' or tblfeedback.strbusinessname='First Beauty - Darwin Hair and Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Galavanti Glam
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=43538 or tblfeedback.strbusinessname='Galavanti Glam' or tblfeedback.strbusinessname='Galavanti Glam') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bec Brown Hair and Makeup
Darwin 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=44157 or tblfeedback.strbusinessname='Bec Brown Hair and Makeup' or tblfeedback.strbusinessname='Bec Brown Hair and Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Scalpt Hair Salon Waterfront
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=43328 or tblfeedback.strbusinessname='Scalpt Hair Salon Waterfront' or tblfeedback.strbusinessname='Scalpt Hair Salon Waterfront') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Julay Hair Design
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=5169 or tblfeedback.strbusinessname='Julay Hair Design' or tblfeedback.strbusinessname='Julay Hair Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Australian Image Co
Larrakeyah 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=5170 or tblfeedback.strbusinessname='Australian Image Co' or tblfeedback.strbusinessname='Australian Image Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Complexions Beauty Salon
Fannie Bay 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=19074 or tblfeedback.strbusinessname='Complexions Beauty Salon' or tblfeedback.strbusinessname='Complexions Beauty Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kabuki Haircutters
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=19139 or tblfeedback.strbusinessname='Kabuki Haircutters' or tblfeedback.strbusinessname='Kabuki Haircutters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15