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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
