Home > Wedding Hair and Makeup Adelaide

Wedding Hair and Makeup Adelaide

67 result(s) found. RatingView Your Favorites List

Rating
Beauty to D-Zire
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=26667 or tblfeedback.strbusinessname='Beauty to D-Zire' or tblfeedback.strbusinessname='Beauty to D-Zire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Caitlin Rose Makeup Artist
Highgate SA 5063
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=25163 or tblfeedback.strbusinessname='Caitlin Rose Makeup Artist' or tblfeedback.strbusinessname='Caitlin Rose Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Chilli Hair
Mount Barker SA 5251
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=25162 or tblfeedback.strbusinessname='Chilli Hair' or tblfeedback.strbusinessname='Chilli Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Natasha Stone Bridal Makeup
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=38441 or tblfeedback.strbusinessname='Natasha Stone Bridal Makeup' or tblfeedback.strbusinessname='Natasha Stone Bridal Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Kylie Stainer Makeup Artistry
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=41608 or tblfeedback.strbusinessname='Kylie Stainer Makeup Artistry' or tblfeedback.strbusinessname='Kylie Stainer Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Makeup by Rechelle
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=37807 or tblfeedback.strbusinessname='Makeup by Rechelle' or tblfeedback.strbusinessname='Makeup by Rechelle') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Amanda Grace Nash
Unley SA 5061
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=29028 or tblfeedback.strbusinessname='Amanda Grace Nash' or tblfeedback.strbusinessname='Amanda Grace Nash') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Flayr
NSW
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=38132 or tblfeedback.strbusinessname='Flayr' or tblfeedback.strbusinessname='Flayr') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Samie Williams
Happy Valley SA 5162
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=36283 or tblfeedback.strbusinessname='Samie Williams' or tblfeedback.strbusinessname='Samie Williams') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
The Blushing Creator
Plympton Park SA 5038
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=29205 or tblfeedback.strbusinessname='The Blushing Creator' or tblfeedback.strbusinessname='The Blushing Creator') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Flayr
NSW
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=38132 or tblfeedback.strbusinessname='Flayr' or tblfeedback.strbusinessname='Flayr') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Make up by Jessica Ramsey
Aldinga beach SA 5173
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=39733 or tblfeedback.strbusinessname='Make up by Jessica Ramsey' or tblfeedback.strbusinessname='Make up by Jessica Ramsey') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
NV Makeup and Hair Styling
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=26281 or tblfeedback.strbusinessname='NV Makeup and Hair Styling' or tblfeedback.strbusinessname='NV Makeup and Hair Styling') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Serene Hair and Beauty Lounge
Kensington Park SA 5068
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=27731 or tblfeedback.strbusinessname='Serene Hair and Beauty Lounge' or tblfeedback.strbusinessname='Serene Hair and Beauty Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
NEAT Hair & Beauty
Para Hills West SA 5096
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=36282 or tblfeedback.strbusinessname='NEAT Hair &%%semi%% Beauty' or tblfeedback.strbusinessname='NEAT Hair & Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Horosho Makeup and 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=35692 or tblfeedback.strbusinessname='Horosho Makeup and Beauty' or tblfeedback.strbusinessname='Horosho Makeup and Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Lush Lip
Port Augusta SA 5700
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=25767 or tblfeedback.strbusinessname='Lush Lip' or tblfeedback.strbusinessname='Lush Lip') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Narelle Amy makeup & hair
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=39657 or tblfeedback.strbusinessname='Narelle Amy makeup &%%semi%% hair' or tblfeedback.strbusinessname='Narelle Amy makeup & hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Makeup by Kate Heaslip
Henley Beach 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=41238 or tblfeedback.strbusinessname='Makeup by Kate Heaslip' or tblfeedback.strbusinessname='Makeup by Kate Heaslip') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Karen Hedger Complete Look
Ridgehaven SA 5097
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=26036 or tblfeedback.strbusinessname='Karen Hedger Complete Look' or tblfeedback.strbusinessname='Karen Hedger Complete Look') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
2 reviews
Rating
Billie's Makeup
Port Augusta SA 5700
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=37725 or tblfeedback.strbusinessname='Billie'%%semi%%s Makeup' or tblfeedback.strbusinessname='Billie's Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Mobile Make-Overs
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=41398 or tblfeedback.strbusinessname='Mobile Make-Overs' or tblfeedback.strbusinessname='Mobile Make-Overs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
2 reviews
Rating
Glamour SA Makeup & Photography
Oakden SA 5086
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=27666 or tblfeedback.strbusinessname='Glamour SA Makeup &%%semi%% Photography' or tblfeedback.strbusinessname='Glamour SA Makeup & Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Mannly Makeup
Roseworthy SA 5371
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=41350 or tblfeedback.strbusinessname='Mannly Makeup' or tblfeedback.strbusinessname='Mannly Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Sam Frost Hairstylist
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=29797 or tblfeedback.strbusinessname='Sam Frost Hairstylist' or tblfeedback.strbusinessname='Sam Frost Hairstylist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Parisian Hair and Beaute
Moonta 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=35779 or tblfeedback.strbusinessname='Parisian Hair and Beaute' or tblfeedback.strbusinessname='Parisian Hair and Beaute') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
She said yes and co
Adelaide South 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=29653 or tblfeedback.strbusinessname='She said yes and co' or tblfeedback.strbusinessname='She said yes and co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Hair Artistique
Erindale SA 5066
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=6207 or tblfeedback.strbusinessname='Hair Artistique' or tblfeedback.strbusinessname='Hair Artistique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jodi Nash
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=5034 or tblfeedback.strbusinessname='Jodi Nash' or tblfeedback.strbusinessname='Jodi Nash') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
3 reviews
Rating
Creations Plus
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=6197 or tblfeedback.strbusinessname='Creations Plus' or tblfeedback.strbusinessname='Creations Plus') 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
Blush Makeup Designs
Hope Valley SA 5090
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=6193 or tblfeedback.strbusinessname='Blush Makeup Designs' or tblfeedback.strbusinessname='Blush Makeup Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Michelle's Mobile Hair Design
Parafield Gardens SA 5107
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=6219 or tblfeedback.strbusinessname='Michelle'%%semi%%s Mobile Hair Design' or tblfeedback.strbusinessname='Michelle's Mobile Hair Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Crowning Glory
Glenelg South 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=6198 or tblfeedback.strbusinessname='Crowning Glory' or tblfeedback.strbusinessname='Crowning Glory') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Makeup Studio With Dina Giaccio
Port Noarlunga South SA 5167
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=6215 or tblfeedback.strbusinessname='Makeup Studio With Dina Giaccio' or tblfeedback.strbusinessname='Makeup Studio With Dina Giaccio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Klasse Hair by
Stonyfell SA 5066
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=6211 or tblfeedback.strbusinessname='Klasse Hair by' or tblfeedback.strbusinessname='Klasse Hair by') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Make a Face Makeup
Sheidow Park SA 5158
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=19150 or tblfeedback.strbusinessname='Make a Face Makeup' or tblfeedback.strbusinessname='Make a Face Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Ninette's Hair City Salon
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=19161 or tblfeedback.strbusinessname='Ninette'%%semi%%s Hair City Salon' or tblfeedback.strbusinessname='Ninette's Hair City Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Salon Hair Designers
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=19231 or tblfeedback.strbusinessname='The Salon Hair Designers' or tblfeedback.strbusinessname='The Salon Hair Designers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Hair Tonic
Campbelltown SA 5074
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=19122 or tblfeedback.strbusinessname='Hair Tonic' or tblfeedback.strbusinessname='Hair Tonic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Frangos
Mitchell Park SA 5043
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=6203 or tblfeedback.strbusinessname='Frangos' or tblfeedback.strbusinessname='Frangos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Buff Makeup Beauty & Nails
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=19222 or tblfeedback.strbusinessname='The Buff Makeup Beauty &%%semi%% Nails' or tblfeedback.strbusinessname='The Buff Makeup Beauty & Nails') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Make A Face Make-Up
Sheidow Park SA 5158
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=6214 or tblfeedback.strbusinessname='Make A Face Make-Up' or tblfeedback.strbusinessname='Make A Face Make-Up') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lynch
Hawthorn SA 5062
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=6212 or tblfeedback.strbusinessname='Lynch' or tblfeedback.strbusinessname='Lynch') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elska Studios
Happy Valley SA 5159
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=19094 or tblfeedback.strbusinessname='Elska Studios' or tblfeedback.strbusinessname='Elska Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
2 reviews
Rating
Hair Artistique
Christies Beach SA 5165
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=6208 or tblfeedback.strbusinessname='Hair Artistique' or tblfeedback.strbusinessname='Hair Artistique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bla-Zo's Hair Studio
Tea Tree Gully SA 5091
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=19048 or tblfeedback.strbusinessname='Bla-Zo'%%semi%%s Hair Studio' or tblfeedback.strbusinessname='Bla-Zo's Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Persuasion
Evandale SA 5069
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=19121 or tblfeedback.strbusinessname='Hair Persuasion' or tblfeedback.strbusinessname='Hair Persuasion') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chameleeon Pty Ltd
One Tree Hill 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=6194 or tblfeedback.strbusinessname='Chameleeon Pty Ltd' or tblfeedback.strbusinessname='Chameleeon Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Make Up Studio - Dina Giaccio
Port Noarlunga South SA 5167
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=19151 or tblfeedback.strbusinessname='Make Up Studio - Dina Giaccio' or tblfeedback.strbusinessname='Make Up Studio - Dina Giaccio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
1 - 50 of 67 Sort search results alphabetically