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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Radiant Beauty by Kate
Umina Beach NSW 2257
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=41309 or tblfeedback.strbusinessname='Radiant Beauty by Kate' or tblfeedback.strbusinessname='Radiant Beauty by Kate') AND tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Simone
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=37600 or tblfeedback.strbusinessname='Simone' or tblfeedback.strbusinessname='Simone') AND tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ferrari Creative
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=38278 or tblfeedback.strbusinessname='Ferrari Creative' or tblfeedback.strbusinessname='Ferrari Creative') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Stephanie K Makeup
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=41081 or tblfeedback.strbusinessname='Stephanie K Makeup' or tblfeedback.strbusinessname='Stephanie K Makeup') AND tblfeedback.active = 1 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 tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blush Organic Beauty
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=36144 or tblfeedback.strbusinessname='Blush Organic Beauty' or tblfeedback.strbusinessname='Blush Organic Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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'%%semi%%s Hair &%%semi%% Beauty' or tblfeedback.strbusinessname='Piaf's Hair & Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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 tblfeedback.active = 1 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 tblfeedback.active = 1 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 &%%semi%% Hair Service' or tblfeedback.strbusinessname='Beautiful Bride Make-Up & Hair Service') AND tblfeedback.active = 1 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 tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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 tblfeedback.active = 1 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'%%semi%%s Eternal Beauty' or tblfeedback.strbusinessname='Kim's Eternal Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15