Home > Wedding Hair and Makeup Adelaide

Wedding Hair and Makeup Adelaide

61 result(s) found. RatingView Your Favorites List

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Lyne Zalewski
Dover Gardens SA 5048
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=6213 or tblfeedback.strbusinessname='Lyne Zalewski' or tblfeedback.strbusinessname='Lyne Zalewski') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Face Dreams
Wayville SA 5034
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=6202 or tblfeedback.strbusinessname='Face Dreams' or tblfeedback.strbusinessname='Face Dreams') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Artistique
North Adelaide SA 5006
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=6204 or tblfeedback.strbusinessname='Hair Artistique' or tblfeedback.strbusinessname='Hair Artistique') 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
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
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
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
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
4.5 stars
2 reviews
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
DDP Makeup Studio
Sefton Park SA 5083
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=6199 or tblfeedback.strbusinessname='DDP Makeup Studio' or tblfeedback.strbusinessname='DDP Makeup Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Hair
Glandore SA 5037
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=6209 or tblfeedback.strbusinessname='Hair Hair' or tblfeedback.strbusinessname='Hair Hair') 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
star ratingstar ratingstar ratingstar ratingstar rating
5 stars
1 review
Rating
Hair Artistique
Somerton Park SA 5044
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=6206 or tblfeedback.strbusinessname='Hair Artistique' or tblfeedback.strbusinessname='Hair Artistique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
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
Costalos
Mitcham 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=6196 or tblfeedback.strbusinessname='Costalos' or tblfeedback.strbusinessname='Costalos') 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
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
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
Manto
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=6216 or tblfeedback.strbusinessname='Manto' or tblfeedback.strbusinessname='Manto') 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
Stage Shop The
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=6223 or tblfeedback.strbusinessname='Stage Shop The' or tblfeedback.strbusinessname='Stage Shop The') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sonya Wiese
Morphett Vale 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=6222 or tblfeedback.strbusinessname='Sonya Wiese' or tblfeedback.strbusinessname='Sonya Wiese') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alessi Hair
Somerton Park SA 5044
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=6191 or tblfeedback.strbusinessname='Alessi Hair' or tblfeedback.strbusinessname='Alessi Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dimitriadis
Rostrevor SA 5073
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=6200 or tblfeedback.strbusinessname='Dimitriadis' or tblfeedback.strbusinessname='Dimitriadis') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Artistique
Hyde Park 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=6205 or tblfeedback.strbusinessname='Hair Artistique' or tblfeedback.strbusinessname='Hair Artistique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 61 Sort search results alphabetically