Rating
Saskia Pridham Makeup
Port Hughes SA 5558
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=26319 or tblfeedback.strbusinessname='Saskia Pridham Makeup' or tblfeedback.strbusinessname='Saskia Pridham Makeup') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blush Girl
Holden Hill SA 5088
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=26545 or tblfeedback.strbusinessname='Blush Girl' or tblfeedback.strbusinessname='Blush Girl') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ego Brows & Beauty
Glenelg SA 5045
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=27024 or tblfeedback.strbusinessname='Ego Brows & Beauty' or tblfeedback.strbusinessname='Ego Brows & Beauty') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mel's Studio Of Hair & Beauty
Nuriootpa SA 5355
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=27029 or tblfeedback.strbusinessname='Mel's Studio Of Hair & Beauty' or tblfeedback.strbusinessname='Mel's Studio Of Hair & Beauty') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lashes by Smiles
Adelaide SA 4000
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=29036 or tblfeedback.strbusinessname='Lashes by Smiles' or tblfeedback.strbusinessname='Lashes by Smiles') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sunbar Mawson Lakes
Mawson Lakes SA 5095
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=29286 or tblfeedback.strbusinessname='Sunbar Mawson Lakes' or tblfeedback.strbusinessname='Sunbar Mawson Lakes') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
ALLURE MAKE-UP DESIGNS
Blakeview SA 5114
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=4646 or tblfeedback.strbusinessname='ALLURE MAKE-UP DESIGNS' or tblfeedback.strbusinessname='ALLURE MAKE-UP DESIGNS') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Accent on Faces
Grange SA 5022
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=5670 or tblfeedback.strbusinessname='Accent on Faces' or tblfeedback.strbusinessname='Accent on Faces') and year(getdate())-year(dtmadded)<=15
Rating
Beauty Benefits
Grange SA 5022
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=5671 or tblfeedback.strbusinessname='Beauty Benefits' or tblfeedback.strbusinessname='Beauty Benefits') and year(getdate())-year(dtmadded)<=15
Rating
Elaine Jesser
Norwood SA 5067
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=5672 or tblfeedback.strbusinessname='Elaine Jesser' or tblfeedback.strbusinessname='Elaine Jesser') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Josie's Beauty
Enfield SA 5085
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=5673 or tblfeedback.strbusinessname='Josie's Beauty' or tblfeedback.strbusinessname='Josie's Beauty') and year(getdate())-year(dtmadded)<=15
Rating
Marro's Professional Hair & Beauty
Firle SA 5070
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=5674 or tblfeedback.strbusinessname='Marro's Professional Hair & Beauty' or tblfeedback.strbusinessname='Marro's Professional Hair & Beauty') and year(getdate())-year(dtmadded)<=15
Rating
Professional Beauty Therapy
Willaston SA 5118
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=5675 or tblfeedback.strbusinessname='Professional Beauty Therapy' or tblfeedback.strbusinessname='Professional Beauty Therapy') and year(getdate())-year(dtmadded)<=15
Rating
Shades of Beauty by Louisa
Bridgewater SA 5155
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=5676 or tblfeedback.strbusinessname='Shades of Beauty by Louisa' or tblfeedback.strbusinessname='Shades of Beauty by Louisa') and year(getdate())-year(dtmadded)<=15
Rating
Anna Serdar
Adelaide SA 5000
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=19031 or tblfeedback.strbusinessname='Anna Serdar' or tblfeedback.strbusinessname='Anna Serdar') and year(getdate())-year(dtmadded)<=15
Rating
Finishing Touch Salon
Mt Gambier SA 5092
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=19104 or tblfeedback.strbusinessname='Finishing Touch Salon' or tblfeedback.strbusinessname='Finishing Touch Salon') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating