Rating
So Glamorous
Jamisontown NSW 2750
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=23986 or tblfeedback.strbusinessname='So Glamorous' or tblfeedback.strbusinessname='So Glamorous') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beautiful glow bathurst
Bathurst NSW 2875
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=25213 or tblfeedback.strbusinessname='Beautiful glow bathurst' or tblfeedback.strbusinessname='Beautiful glow bathurst') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jo Candelaria
Sydney NSW 2000
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=25651 or tblfeedback.strbusinessname='Jo Candelaria' or tblfeedback.strbusinessname='Jo Candelaria') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blush and Glow Makeup
Paramatta NSW 2150
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=25875 or tblfeedback.strbusinessname='Blush and Glow Makeup' or tblfeedback.strbusinessname='Blush and Glow Makeup') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sephora the Beauty Studio
Forbes NSW 2871
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=26763 or tblfeedback.strbusinessname='Sephora the Beauty Studio' or tblfeedback.strbusinessname='Sephora the Beauty Studio') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Face 2 Face Beauty Salon
Armidale NSW 2350
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=27300 or tblfeedback.strbusinessname='Face 2 Face Beauty Salon' or tblfeedback.strbusinessname='Face 2 Face Beauty Salon') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Babydoll Makeup Artistry
Dubbo NSW 2830
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=29061 or tblfeedback.strbusinessname='Babydoll Makeup Artistry' or tblfeedback.strbusinessname='Babydoll Makeup Artistry') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Spoilt Beauty
Dubbo NSW 2830
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=29080 or tblfeedback.strbusinessname='Spoilt Beauty' or tblfeedback.strbusinessname='Spoilt Beauty') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Complete Makeover Art
Sydney NSW 2000
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=29876 or tblfeedback.strbusinessname='Complete Makeover Art' or tblfeedback.strbusinessname='Complete Makeover Art') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
India Verena Dwyer
Mosman NSW 2088
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=35860 or tblfeedback.strbusinessname='India Verena Dwyer' or tblfeedback.strbusinessname='India Verena Dwyer') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Divinity Studio of Beauty
Edgecliff NSW 2027
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=9036 or tblfeedback.strbusinessname='Divinity Studio of Beauty' or tblfeedback.strbusinessname='Divinity Studio of Beauty') and year(getdate())-year(dtmadded)<=15
Rating
Rouge Beauty Consultants
Matraville NSW 2036
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=11242 or tblfeedback.strbusinessname='Rouge Beauty Consultants' or tblfeedback.strbusinessname='Rouge Beauty Consultants') and year(getdate())-year(dtmadded)<=15
Rating
Beautiful Bride Make-Up & Hair Service
Maroubra NSW 2035
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=18031 or tblfeedback.strbusinessname='Beautiful Bride Make-Up & Hair Service' or tblfeedback.strbusinessname='Beautiful Bride Make-Up & Hair Service') and year(getdate())-year(dtmadded)<=15
Rating
Burwood Skin Care
Burwood NSW 2134
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=18032 or tblfeedback.strbusinessname='Burwood Skin Care' or tblfeedback.strbusinessname='Burwood Skin Care') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Eva Karpaty Skincare
Double Bay NSW 2028
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=18034 or tblfeedback.strbusinessname='Eva Karpaty Skincare' or tblfeedback.strbusinessname='Eva Karpaty Skincare') and year(getdate())-year(dtmadded)<=15
Rating
Kim's Eternal Beauty
King's Park NSW 2148
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=18035 or tblfeedback.strbusinessname='Kim's Eternal Beauty' or tblfeedback.strbusinessname='Kim's Eternal Beauty') and year(getdate())-year(dtmadded)<=15
Rating
Piaf's Hair & Beauty
Rozelle NSW 2039
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=18037 or tblfeedback.strbusinessname='Piaf's Hair & Beauty' or tblfeedback.strbusinessname='Piaf's Hair & Beauty') and year(getdate())-year(dtmadded)<=15