Home > Wedding Hair and Makeup Adelaide

Wedding Hair and Makeup Adelaide

67 result(s) found. View Your Favorites List

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
2 reviews

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
2 reviews

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

5 stars
1 review

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

Havringtons Hair Designs

Glenside SA 5065

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=19123 or tblfeedback.strbusinessname='Havringtons Hair Designs' or tblfeedback.strbusinessname='Havringtons Hair Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15

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

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

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

5 stars
1 review

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

5 stars
1 review

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

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

5 stars
3 reviews

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

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

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

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

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

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

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

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

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

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

5 stars
1 review

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

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

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

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

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

1 - 50 of 67 Sort search results alphabetically