Rating
Saskia Pridham Makeup
Sanders St 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
90 Lyons Road 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 &%%semi%% 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'%%semi%%s Studio Of Hair &%%semi%% 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
2/42-48 Garden Terrace 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
11 Springvale Drive 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
Shop 5 665 Grange Road 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
20 Birrell Street 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'%%semi%%s Beauty' or tblfeedback.strbusinessname='Josie's Beauty') and year(getdate())-year(dtmadded)<=15
Rating
Marro's Professional Hair & Beauty
171 Glynburn Road 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'%%semi%%s Professional Hair &%%semi%% 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
36 East Terrace 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
80 Commercial Street 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