Rating
Brooke Fiore Hair
Bunbury WA 6230
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=38057 or tblfeedback.strbusinessname='Brooke Fiore Hair' or tblfeedback.strbusinessname='Brooke Fiore Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Makeup and Beauty Corner
Perth WA 6210
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=21962 or tblfeedback.strbusinessname='The Makeup and Beauty Corner' or tblfeedback.strbusinessname='The Makeup and Beauty Corner') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Look in Hair and Makeup
Bunbury WA 6230
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=38056 or tblfeedback.strbusinessname='The Look in Hair and Makeup' or tblfeedback.strbusinessname='The Look in Hair and Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Abby Hair Expert
Dunsborough WA 6281
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=27730 or tblfeedback.strbusinessname='Abby Hair Expert' or tblfeedback.strbusinessname='Abby Hair Expert') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Danae's Hair and Beauty
Eaton WA 6232
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=41266 or tblfeedback.strbusinessname='Danae'%%semi%%s Hair and Beauty' or tblfeedback.strbusinessname='Danae's Hair and 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
Beautique Love
Cowaramup WA 6284
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=27546 or tblfeedback.strbusinessname='Beautique Love' or tblfeedback.strbusinessname='Beautique Love') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jasmin Ford Makeup Artistry
Bunbury WA 6230
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=41318 or tblfeedback.strbusinessname='Jasmin Ford Makeup Artistry' or tblfeedback.strbusinessname='Jasmin Ford Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cacao Health & Beauty
Augusta WA 6290
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=26553 or tblfeedback.strbusinessname='Cacao Health &%%semi%% Beauty' or tblfeedback.strbusinessname='Cacao Health & Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Innovative Hair Design By Kara
Abbey WA 6280
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=26190 or tblfeedback.strbusinessname='Innovative Hair Design By Kara' or tblfeedback.strbusinessname='Innovative Hair Design By Kara') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Allure Beauty by Amy Howes
Bunbury WA 6230
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=29229 or tblfeedback.strbusinessname='Allure Beauty by Amy Howes' or tblfeedback.strbusinessname='Allure Beauty by Amy Howes') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Finishing Touch Make Overs The
Iluka WA 6028
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=7123 or tblfeedback.strbusinessname='Finishing Touch Make Overs The' or tblfeedback.strbusinessname='Finishing Touch Make Overs The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rivers Hair Design
Margaret River WA 6285
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=17654 or tblfeedback.strbusinessname='Rivers Hair Design' or tblfeedback.strbusinessname='Rivers Hair Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15