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
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
Beauty by Tennille
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=23730 or tblfeedback.strbusinessname='Beauty by Tennille' or tblfeedback.strbusinessname='Beauty by Tennille') 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
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
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
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
Brilee Anne Makeup Artist
Echuca VIC 3564
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=39935 or tblfeedback.strbusinessname='Brilee Anne Makeup Artist' or tblfeedback.strbusinessname='Brilee Anne Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
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
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
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
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