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
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
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
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
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
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
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
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
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
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