Rating
So Glamorous
241 Mulgoa Road 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
3/38 William Street 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
Shop 5, 113 Rankin Street 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
1/93 Faulkner Street 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
65 Catherine Dr 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
24 Church St 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
Divinity Studio of Beauty
160 New South Head Road 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
P.O. Box 1157 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 &%%semi%% Hair Service' or tblfeedback.strbusinessname='Beautiful Bride Make-Up & Hair Service') and year(getdate())-year(dtmadded)<=15
Rating
Burwood Skin Care
Ste 2-7/63 Burwood Rd 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
24/4 20 Bay Street 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
92 Madagascar Drive 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'%%semi%%s Eternal Beauty' or tblfeedback.strbusinessname='Kim's Eternal Beauty') and year(getdate())-year(dtmadded)<=15
Rating
Piaf's Hair & Beauty
664 Darling St 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'%%semi%%s Hair &%%semi%% Beauty' or tblfeedback.strbusinessname='Piaf's Hair & Beauty') and year(getdate())-year(dtmadded)<=15