Angel Faces
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=17681 or tblfeedback.strbusinessname='Angel Faces' or tblfeedback.strbusinessname='Angel Faces') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Breathtaking flawless makeup that lasts all day and feels incredibly light. Creative hairstylists work miracles with all hair types and secure hairpieces for a carefree,
Magical Makeovers
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=13284 or tblfeedback.strbusinessname='Magical Makeovers' or tblfeedback.strbusinessname='Magical Makeovers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Our professional award winning team of Bridal Stylists will create the look you desire based on your requests and ideas.
Bridalhairplus
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=20252 or tblfeedback.strbusinessname='Bridalhairplus' or tblfeedback.strbusinessname='Bridalhairplus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A freelance hairstylist, with years of experience in all facets of creative styl
SGD Body & Beauty
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=20922 or tblfeedback.strbusinessname='SGD Body &%%semi%% Beauty' or tblfeedback.strbusinessname='SGD Body & Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Beauty for all your wedding beauty services.
Swish mobile beauty
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=19534 or tblfeedback.strbusinessname='Swish mobile beauty' or tblfeedback.strbusinessname='Swish mobile beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Look picture perfect on your special day.
Pink Gloss Makeup
Mornington VIC 3931
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=25194 or tblfeedback.strbusinessname='Pink Gloss Makeup' or tblfeedback.strbusinessname='Pink Gloss Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Kochou hair and makeup
Wyndham Vale VIC 3024
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=26204 or tblfeedback.strbusinessname='Kochou hair and makeup' or tblfeedback.strbusinessname='Kochou hair and makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Brides of Beauty
Werribee VIC 3030
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=29008 or tblfeedback.strbusinessname='Brides of Beauty' or tblfeedback.strbusinessname='Brides of Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Beyond The Mirror
Pakenham VIC 3801
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=36158 or tblfeedback.strbusinessname='Beyond The Mirror' or tblfeedback.strbusinessname='Beyond The Mirror') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Makeup By Grace VIC
Taylors Lakes VIC 3038
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=41331 or tblfeedback.strbusinessname='Makeup By Grace VIC' or tblfeedback.strbusinessname='Makeup By Grace VIC') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hair and Makeup by Bru
Melbourne VIC 3000
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=43992 or tblfeedback.strbusinessname='Hair and Makeup by Bru' or tblfeedback.strbusinessname='Hair and Makeup by Bru') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Riri Design (Vic)
Frankston VIC 3199
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=25356 or tblfeedback.strbusinessname='Riri Design (%%semi%%Vic)%%semi%%' or tblfeedback.strbusinessname='Riri Design (Vic)') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Runway Room Hampton
Hampton VIC 3188
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=26223 or tblfeedback.strbusinessname='Runway Room Hampton' or tblfeedback.strbusinessname='Runway Room Hampton') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
By Juliette
Wahroonga NSW 2076
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=26087 or tblfeedback.strbusinessname='By Juliette' or tblfeedback.strbusinessname='By Juliette') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Suzy Sela Makeup Artist
Melbourne VIC 3000
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=25280 or tblfeedback.strbusinessname='Suzy Sela Makeup Artist' or tblfeedback.strbusinessname='Suzy Sela Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Cosmetic MD
Melbourne VIC 3000
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=46426 or tblfeedback.strbusinessname='Cosmetic MD' or tblfeedback.strbusinessname='Cosmetic MD') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jedavu
Melbourne VIC 3000
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=26649 or tblfeedback.strbusinessname='Jedavu' or tblfeedback.strbusinessname='Jedavu') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Milco Hair and Makeup
Melbourne VIC 3000
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=27486 or tblfeedback.strbusinessname='Milco Hair and Makeup' or tblfeedback.strbusinessname='Milco Hair and Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ricci Jean Makeup
Mernda VIC 3754
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=27528 or tblfeedback.strbusinessname='Ricci Jean Makeup' or tblfeedback.strbusinessname='Ricci Jean Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tash Tynan Makeup Artist and Hair Stylist
Melbourne VIC 3000
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=41465 or tblfeedback.strbusinessname='Tash Tynan Makeup Artist and Hair Stylist' or tblfeedback.strbusinessname='Tash Tynan Makeup Artist and Hair Stylist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Leighton Makeup Studios
Fitzroy VIC 3065
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=26176 or tblfeedback.strbusinessname='Leighton Makeup Studios' or tblfeedback.strbusinessname='Leighton Makeup Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
A and R hair and makeup
Melbourne VIC 3000
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=29544 or tblfeedback.strbusinessname='A and R hair and makeup' or tblfeedback.strbusinessname='A and R hair and makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
Natalie Elrington Makeup Artist
Melbourne VIC 3000
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=38198 or tblfeedback.strbusinessname='Natalie Elrington Makeup Artist' or tblfeedback.strbusinessname='Natalie Elrington Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hair by Nikita
Geelong VIC 3220
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=23963 or tblfeedback.strbusinessname='Hair by Nikita' or tblfeedback.strbusinessname='Hair by Nikita') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
EKO Designs
Ivanhoe VIC 3079
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=24930 or tblfeedback.strbusinessname='EKO Designs' or tblfeedback.strbusinessname='EKO Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Strut Hair and Makeup
Altona VIC 3018
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=42821 or tblfeedback.strbusinessname='Strut Hair and Makeup' or tblfeedback.strbusinessname='Strut Hair and Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hair by Rozi
Melbourne VIC 3000
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=43606 or tblfeedback.strbusinessname='Hair by Rozi' or tblfeedback.strbusinessname='Hair by Rozi') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hair by Elesha Rae
Point Cook VIC 3030
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=29007 or tblfeedback.strbusinessname='Hair by Elesha Rae' or tblfeedback.strbusinessname='Hair by Elesha Rae') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Phuong Do Hairstylist & MUA
Melbourne VIC 3000
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=46286 or tblfeedback.strbusinessname='Phuong Do Hairstylist &%%semi%% MUA' or tblfeedback.strbusinessname='Phuong Do Hairstylist & MUA') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Elly B Salon
Gisborne VIC 3437
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=27797 or tblfeedback.strbusinessname='Elly B Salon' or tblfeedback.strbusinessname='Elly B Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Heather Woll Makeup Artist
Melbourne VIC 3000
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=26575 or tblfeedback.strbusinessname='Heather Woll Makeup Artist' or tblfeedback.strbusinessname='Heather Woll Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Glamour Mafia
Melbourne VIC 3000
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=28994 or tblfeedback.strbusinessname='The Glamour Mafia' or tblfeedback.strbusinessname='The Glamour Mafia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Make up by Miranda
Belmont VIC 3216
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=25195 or tblfeedback.strbusinessname='Make up by Miranda' or tblfeedback.strbusinessname='Make up by Miranda') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Natalie Jade Makeup Artist
Ferntree Gully VIC 3156
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=41220 or tblfeedback.strbusinessname='Natalie Jade Makeup Artist' or tblfeedback.strbusinessname='Natalie Jade Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Elegancia Makeup & Hair
Melbourne VIC 3000
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=44196 or tblfeedback.strbusinessname='Elegancia Makeup &%%semi%% Hair' or tblfeedback.strbusinessname='Elegancia Makeup & Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Living Dolls Makeup Artistry
Melbourne VIC 3000
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=27829 or tblfeedback.strbusinessname='Living Dolls Makeup Artistry' or tblfeedback.strbusinessname='Living Dolls Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Makeup by Cass
Werribee VIC 3039
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=24885 or tblfeedback.strbusinessname='Makeup by Cass' or tblfeedback.strbusinessname='Makeup by Cass') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Beauty in a brush
Hillside VIC 3037
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=26375 or tblfeedback.strbusinessname='Beauty in a brush' or tblfeedback.strbusinessname='Beauty in a brush') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Dollface Nathalie
West Melbourne VIC 3021
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=38033 or tblfeedback.strbusinessname='Dollface Nathalie' or tblfeedback.strbusinessname='Dollface Nathalie') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
De'l Hair
Dandenong North VIC 3175
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=27725 or tblfeedback.strbusinessname='De'%%semi%%l Hair' or tblfeedback.strbusinessname='De'l Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bridget Sophie Studio
Richmond VIC 3121
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=29104 or tblfeedback.strbusinessname='Bridget Sophie Studio' or tblfeedback.strbusinessname='Bridget Sophie Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lysa Kiely Hair and Make Up Artistry
Rhyll VIC 3923
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=45848 or tblfeedback.strbusinessname='Lysa Kiely Hair and Make Up Artistry' or tblfeedback.strbusinessname='Lysa Kiely Hair and Make Up Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Adele Make Up Artist
Melbourne VIC 3000
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=38141 or tblfeedback.strbusinessname='Adele Make Up Artist' or tblfeedback.strbusinessname='Adele Make Up Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Ella's Bridal Hair
Deer Park VIC 3023
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=29495 or tblfeedback.strbusinessname='Ella'%%semi%%s Bridal Hair' or tblfeedback.strbusinessname='Ella's Bridal Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
HK Makeup Artistry
Melbourne VIC 3000
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=26768 or tblfeedback.strbusinessname='HK Makeup Artistry' or tblfeedback.strbusinessname='HK Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Instyle Hair for Brides
Ferntree Gully VIC 3156
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=27938 or tblfeedback.strbusinessname='Instyle Hair for Brides' or tblfeedback.strbusinessname='Instyle Hair for Brides') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Misk Hair and Beauty
Bundoora VIC 3083
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=26608 or tblfeedback.strbusinessname='Misk Hair and Beauty' or tblfeedback.strbusinessname='Misk Hair and Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Jelita Hair
Ardeer VIC 3022
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=26048 or tblfeedback.strbusinessname='Jelita Hair' or tblfeedback.strbusinessname='Jelita Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
View Your Favorites List
