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.
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.
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.
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
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
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
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
Sarah Maciejewski
Endeavour Hills VIC 3802
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=29075 or tblfeedback.strbusinessname='Sarah Maciejewski' or tblfeedback.strbusinessname='Sarah Maciejewski') 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
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
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
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
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
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
Shauna Big Tease
Botanic Ridge VIC 3977
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=37596 or tblfeedback.strbusinessname='Shauna Big Tease' or tblfeedback.strbusinessname='Shauna Big Tease') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Stephanie Nguyen Artistry
Laverton VIC 3028
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=46571 or tblfeedback.strbusinessname='Stephanie Nguyen Artistry' or tblfeedback.strbusinessname='Stephanie Nguyen Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Makeup by Vass
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=38061 or tblfeedback.strbusinessname='Makeup by Vass' or tblfeedback.strbusinessname='Makeup by Vass') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Zoe O'Meara 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=26271 or tblfeedback.strbusinessname='Zoe O'%%semi%%Meara Makeup Artistry' or tblfeedback.strbusinessname='Zoe O'Meara Makeup Artistry') 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
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
Traks Hair Design
Mooroolbark VIC 3116
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=36106 or tblfeedback.strbusinessname='Traks Hair Design' or tblfeedback.strbusinessname='Traks Hair Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
GLOW by sarabellamua
Berwick VIC 3806
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=27640 or tblfeedback.strbusinessname='GLOW by sarabellamua' or tblfeedback.strbusinessname='GLOW by sarabellamua') 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
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
Glad all over
Carrum VIC 3197
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=44130 or tblfeedback.strbusinessname='Glad all over' or tblfeedback.strbusinessname='Glad all over') 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
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
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
Emily Terry
Wantirna VIC 3152
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=25663 or tblfeedback.strbusinessname='Emily Terry' or tblfeedback.strbusinessname='Emily Terry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Merton Muaremi
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=38241 or tblfeedback.strbusinessname='Merton Muaremi' or tblfeedback.strbusinessname='Merton Muaremi') 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
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
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
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
Blushin Brides
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=46402 or tblfeedback.strbusinessname='Blushin Brides' or tblfeedback.strbusinessname='Blushin Brides') 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
A'blaze Hair Artistry
Knoxfield VIC 3180
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=36041 or tblfeedback.strbusinessname='A'%%semi%%blaze Hair Artistry' or tblfeedback.strbusinessname='A'blaze Hair Artistry') 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
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
ZF 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=24999 or tblfeedback.strbusinessname='ZF MakeUp Artistry' or tblfeedback.strbusinessname='ZF 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
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
Corrine Annelies MUA
Mooroolbark VIC 3138
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=25656 or tblfeedback.strbusinessname='Corrine Annelies MUA' or tblfeedback.strbusinessname='Corrine Annelies MUA') 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
Mobile Makeovers Hair and Make Up
Langwarrin VIC 3911
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=18209 or tblfeedback.strbusinessname='Mobile Makeovers Hair and Make Up' or tblfeedback.strbusinessname='Mobile Makeovers Hair and Make Up') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Serena 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=29554 or tblfeedback.strbusinessname='Serena Hair' or tblfeedback.strbusinessname='Serena Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
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
LD 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=41035 or tblfeedback.strbusinessname='LD Makeup Artistry' or tblfeedback.strbusinessname='LD Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15