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
Shop 4/12 Murray St 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
Davallia Rd Shop 6 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
2/1 Galbraith Loop 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 &%%semi%% Grace Beauty' or tblfeedback.strbusinessname='Harper & Grace Beauty') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Allure Beauty
Hudson Road 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' or tblfeedback.strbusinessname='Allure Beauty') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Aim for Excellence
17 Ambridge Street 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
Mobile 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
450b Fitzgerald Street 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