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