Rating
Shalom Hair Care
Albury NSW 2641
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=37615 or tblfeedback.strbusinessname='Shalom Hair Care' or tblfeedback.strbusinessname='Shalom Hair Care') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Boudoir Hair Artistry
Albury NSW 2640
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=21109 or tblfeedback.strbusinessname='Boudoir Hair Artistry' or tblfeedback.strbusinessname='Boudoir Hair Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
DAACK Beauty
North Albury NSW 2640
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=41562 or tblfeedback.strbusinessname='DAACK Beauty' or tblfeedback.strbusinessname='DAACK Beauty') 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
Kelsey Mae Hair
Lavington NSW 2640
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=39801 or tblfeedback.strbusinessname='Kelsey Mae Hair' or tblfeedback.strbusinessname='Kelsey Mae Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
MUMU Makeup Artistry
Albury NSW 2640
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=25413 or tblfeedback.strbusinessname='MUMU Makeup Artistry' or tblfeedback.strbusinessname='MUMU Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Makeup by Mimi
Albury NSW 2640
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=41567 or tblfeedback.strbusinessname='Makeup by Mimi' or tblfeedback.strbusinessname='Makeup by Mimi') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ellie Harmer Makeup Artist
Wagga wagga NSW 2650
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=21996 or tblfeedback.strbusinessname='Ellie Harmer Makeup Artist' or tblfeedback.strbusinessname='Ellie Harmer Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Zen Day Spa
Albury NSW 2640
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=26382 or tblfeedback.strbusinessname='Zen Day Spa' or tblfeedback.strbusinessname='Zen Day Spa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cleopatra's Mirror
Albury NSW 2640
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=8721 or tblfeedback.strbusinessname='Cleopatra'%%semi%%s Mirror' or tblfeedback.strbusinessname='Cleopatra's Mirror') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Ribbons & Curls
Albury North NSW 2640
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=11139 or tblfeedback.strbusinessname='Ribbons &%%semi%% Curls' or tblfeedback.strbusinessname='Ribbons & Curls') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Avenue 2 Hair Design
Lavington NSW 2641
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=7985 or tblfeedback.strbusinessname='Avenue 2 Hair Design' or tblfeedback.strbusinessname='Avenue 2 Hair Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lola Wigg Hair Cafe
Albury NSW 2640
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=10263 or tblfeedback.strbusinessname='Lola Wigg Hair Cafe' or tblfeedback.strbusinessname='Lola Wigg Hair Cafe') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Studio Three Designers In Hair
Wodonga VIC 3690
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=13292 or tblfeedback.strbusinessname='Studio Three Designers In Hair' or tblfeedback.strbusinessname='Studio Three Designers In Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15