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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kissed The Bride
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=36288 or tblfeedback.strbusinessname='Kissed The Bride' or tblfeedback.strbusinessname='Kissed The Bride') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 tblfeedback.active = 1 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'%%semi%%s Professional Hair &%%semi%% Beauty' or tblfeedback.strbusinessname='Marro's Professional Hair & Beauty') AND tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15