Rating
Pearlin Hair and Make-Up Aristry
Carramar WA 6031
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=26077 or tblfeedback.strbusinessname='Pearlin Hair and Make-Up Aristry' or tblfeedback.strbusinessname='Pearlin Hair and Make-Up Aristry') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Isabelle De Vries
Maida Vale WA 6057
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=26731 or tblfeedback.strbusinessname='Isabelle De Vries' or tblfeedback.strbusinessname='Isabelle De Vries') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
A Brush with Colour
Perth WA 6000
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=26740 or tblfeedback.strbusinessname='A Brush with Colour' or tblfeedback.strbusinessname='A Brush with Colour') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Seashells Day Spa
Jurien Bay WA 6516
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=27041 or tblfeedback.strbusinessname='Seashells Day Spa' or tblfeedback.strbusinessname='Seashells Day Spa') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brads Barbershop
Carine WA 6023
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=27657 or tblfeedback.strbusinessname='Brads Barbershop' or tblfeedback.strbusinessname='Brads Barbershop') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Harper & Grace Beauty
Erskine 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=29088 or tblfeedback.strbusinessname='Harper & Grace Beauty' or tblfeedback.strbusinessname='Harper & Grace Beauty') 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Vikki Aldridge
Perth WA 6000
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=35689 or tblfeedback.strbusinessname='Vikki Aldridge' or tblfeedback.strbusinessname='Vikki Aldridge') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Aim for Excellence
Hamersley WA 6022
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=6668 or tblfeedback.strbusinessname='Aim for Excellence' or tblfeedback.strbusinessname='Aim for Excellence') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lejla
Perth WA 6000
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=17561 or tblfeedback.strbusinessname='Lejla' or tblfeedback.strbusinessname='Lejla') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Studio Noir
North Perth WA 6006
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=17562 or tblfeedback.strbusinessname='Studio Noir' or tblfeedback.strbusinessname='Studio Noir') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating