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.
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
Lisa Maree's Hair Design
Upper 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=27232 or tblfeedback.strbusinessname='Lisa Maree'%%semi%%s Hair Design' or tblfeedback.strbusinessname='Lisa Maree's Hair Design') 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Posh Pouts
Elsternwick VIC 3185
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=36314 or tblfeedback.strbusinessname='Posh Pouts' or tblfeedback.strbusinessname='Posh Pouts') 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
Hair by Elesha Rae
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=24884 or tblfeedback.strbusinessname='Hair by Elesha Rae' or tblfeedback.strbusinessname='Hair by Elesha Rae') 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
Bizz's Scissors
Korumburra VIC 3950
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=29515 or tblfeedback.strbusinessname='Bizz'%%semi%%s Scissors' or tblfeedback.strbusinessname='Bizz's Scissors') 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
LeJade
Chelsea Heights VIC 3196
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=24890 or tblfeedback.strbusinessname='LeJade' or tblfeedback.strbusinessname='LeJade') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15