Rating
Bombshell Hair Studio
Harrison ACT 2914
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=41236 or tblfeedback.strbusinessname='Bombshell Hair Studio' or tblfeedback.strbusinessname='Bombshell Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blank Canvas by Lou
Young NSW 2594
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=26745 or tblfeedback.strbusinessname='Blank Canvas by Lou' or tblfeedback.strbusinessname='Blank Canvas by Lou') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mynx Beaute
Gungahlin ACT 2912
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=46110 or tblfeedback.strbusinessname='Mynx Beaute' or tblfeedback.strbusinessname='Mynx Beaute') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Styledforyou
Goulbourn NSW 2580
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=41583 or tblfeedback.strbusinessname='Styledforyou' or tblfeedback.strbusinessname='Styledforyou') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Events Makeup and Hairstyling
Canberra ACT 2601
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=43751 or tblfeedback.strbusinessname='Events Makeup and Hairstyling' or tblfeedback.strbusinessname='Events Makeup and Hairstyling') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jessica Peris - Beautique
Harrison ACT 2914
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=21878 or tblfeedback.strbusinessname='Jessica Peris - Beautique' or tblfeedback.strbusinessname='Jessica Peris - Beautique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Elle thomas
Farrer ACT 2607
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=25686 or tblfeedback.strbusinessname='Elle thomas' or tblfeedback.strbusinessname='Elle thomas') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Auburn Mane Designs
Goulburn NSW 2580
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=29012 or tblfeedback.strbusinessname='Auburn Mane Designs' or tblfeedback.strbusinessname='Auburn Mane Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sumitra Joshi Makeup Artist
Canberra ACT 2913
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=45880 or tblfeedback.strbusinessname='Sumitra Joshi Makeup Artist' or tblfeedback.strbusinessname='Sumitra Joshi Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cassandra Lee hair and makeup artist
Higgins ACT 2615
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=44203 or tblfeedback.strbusinessname='Cassandra Lee hair and makeup artist' or tblfeedback.strbusinessname='Cassandra Lee hair and makeup artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Diana Cheetham Hair and Make up
Goulburn NSW 2580
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=29011 or tblfeedback.strbusinessname='Diana Cheetham Hair and Make up' or tblfeedback.strbusinessname='Diana Cheetham Hair and Make up') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Z & Co
Canberra City ACT 2601
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=29284 or tblfeedback.strbusinessname='Z &%%semi%% Co' or tblfeedback.strbusinessname='Z & Co') 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
Hair Talk on Bourke
Goulburn NSW 2580
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=18541 or tblfeedback.strbusinessname='Hair Talk on Bourke' or tblfeedback.strbusinessname='Hair Talk on Bourke') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Kay the Mobile Hairstylist
Chisholm ACT 2905
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=5571 or tblfeedback.strbusinessname='Kay the Mobile Hairstylist' or tblfeedback.strbusinessname='Kay the Mobile Hairstylist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Vogue
Jamison Centre ACT 2614
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=5569 or tblfeedback.strbusinessname='Hair Vogue' or tblfeedback.strbusinessname='Hair Vogue') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Mobile Snips
Canberra ACT 2601
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=5572 or tblfeedback.strbusinessname='Mobile Snips' or tblfeedback.strbusinessname='Mobile Snips') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Deborah Pobjie
Canberra ACT 2601
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=5567 or tblfeedback.strbusinessname='Deborah Pobjie' or tblfeedback.strbusinessname='Deborah Pobjie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Arpege
Evatt ACT 2617
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=5566 or tblfeedback.strbusinessname='Arpege' or tblfeedback.strbusinessname='Arpege') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Creations by Nikki
Lyneham North ACT 2602
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=5557 or tblfeedback.strbusinessname='Creations by Nikki' or tblfeedback.strbusinessname='Creations by Nikki') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Acacia Hair Design
Kaleen ACT 2617
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=5563 or tblfeedback.strbusinessname='Acacia Hair Design' or tblfeedback.strbusinessname='Acacia Hair Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A & K Evans Make-Up Artists
Oxley ACT 2903
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=5561 or tblfeedback.strbusinessname='A &%%semi%% K Evans Make-Up Artists' or tblfeedback.strbusinessname='A & K Evans Make-Up Artists') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jan Sanders
Chisholm ACT 2905
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=12152 or tblfeedback.strbusinessname='Jan Sanders' or tblfeedback.strbusinessname='Jan Sanders') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Anton's Hair Studio
Canberra City ACT 2600
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=19032 or tblfeedback.strbusinessname='Anton'%%semi%%s Hair Studio' or tblfeedback.strbusinessname='Anton's Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Head Office Hair Design
Mawson ACT 2607
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=5570 or tblfeedback.strbusinessname='Head Office Hair Design' or tblfeedback.strbusinessname='Head Office Hair Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Touch of Elegance
Canberra ACT 2601
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=5562 or tblfeedback.strbusinessname='A Touch of Elegance' or tblfeedback.strbusinessname='A Touch of Elegance') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Akita Hair Shop
Garran ACT 2605
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=5564 or tblfeedback.strbusinessname='Akita Hair Shop' or tblfeedback.strbusinessname='Akita Hair Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Epic Hair Studio
Canberra ACT 2606
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=19095 or tblfeedback.strbusinessname='Epic Hair Studio' or tblfeedback.strbusinessname='Epic Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Rumours Hair Designers
Dickson ACT 2602
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=5573 or tblfeedback.strbusinessname='Rumours Hair Designers' or tblfeedback.strbusinessname='Rumours Hair Designers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bella Makeup Artistry
RedHill ACT 2913
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=19042 or tblfeedback.strbusinessname='Bella Makeup Artistry' or tblfeedback.strbusinessname='Bella Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Serene Hair and Beauty
Fadden ACT 2904
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=19195 or tblfeedback.strbusinessname='Serene Hair and Beauty' or tblfeedback.strbusinessname='Serene Hair and Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Airbrush makeup & fantasy body tan
Ngunnawal ACT 2913
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=14966 or tblfeedback.strbusinessname='Airbrush makeup &%%semi%% fantasy body tan' or tblfeedback.strbusinessname='Airbrush makeup & fantasy body tan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Always Beautiful
Canberra ACT 2601
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=5565 or tblfeedback.strbusinessname='Always Beautiful' or tblfeedback.strbusinessname='Always Beautiful') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Totale
Kippax ACT 2615
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=5568 or tblfeedback.strbusinessname='Hair Totale' or tblfeedback.strbusinessname='Hair Totale') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15