Chrissy Louise MUA
Brisbane QLD 4000
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=35952 or tblfeedback.strbusinessname='Chrissy Louise MUA' or tblfeedback.strbusinessname='Chrissy Louise MUA') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
The Powder Room
New Farm QLD 4005
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=20865 or tblfeedback.strbusinessname='The Powder Room' or tblfeedback.strbusinessname='The Powder Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Susanne Nicholson
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=19491 or tblfeedback.strbusinessname='Susanne Nicholson' or tblfeedback.strbusinessname='Susanne Nicholson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
With a wealth of local and international experience and over 20 years' experience in the bridal industry, Susanne Nicholson specialises in creating breathtaking brides' m
Danielle Robinson Airbrush Makeup Artist
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=17385 or tblfeedback.strbusinessname='Danielle Robinson Airbrush Makeup Artist' or tblfeedback.strbusinessname='Danielle Robinson Airbrush Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Danielle Robinson is a multi-award winning freelance Airbrush Make-up artist, based in Brisbane. With work published in domestic and international editorial publications,
Andrea Bartlett
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=18846 or tblfeedback.strbusinessname='Andrea Bartlett' or tblfeedback.strbusinessname='Andrea Bartlett') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
In salon & mobile airbrush make-up for all your special occasions!
Meraki Hair Studio
Toowoomba QLD 4350
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=37507 or tblfeedback.strbusinessname='Meraki Hair Studio' or tblfeedback.strbusinessname='Meraki Hair Studio') 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
Allure Bridal Stylists
Caloundra QLD 4551
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=25986 or tblfeedback.strbusinessname='Allure Bridal Stylists' or tblfeedback.strbusinessname='Allure Bridal Stylists') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wedding Dream Services
Oxley QLD 4075
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=41202 or tblfeedback.strbusinessname='Wedding Dream Services' or tblfeedback.strbusinessname='Wedding Dream Services') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sugar Mobile Makeup & Hair
Helensvale QLD 4212
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=27079 or tblfeedback.strbusinessname='Sugar Mobile Makeup &%%semi%% Hair' or tblfeedback.strbusinessname='Sugar Mobile Makeup & Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Twidale Hair & Makeup
Fortitude Valley QLD 4006
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=26519 or tblfeedback.strbusinessname='Twidale Hair &%%semi%% Makeup' or tblfeedback.strbusinessname='Twidale Hair & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Lauren Hughes - A Flair for Hair
Warwick QLD 4370
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=21129 or tblfeedback.strbusinessname='Lauren Hughes - A Flair for Hair' or tblfeedback.strbusinessname='Lauren Hughes - A Flair for Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Alex Ouston Beauty Co
Brisbane QLD 4000
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=39834 or tblfeedback.strbusinessname='Alex Ouston Beauty Co' or tblfeedback.strbusinessname='Alex Ouston Beauty Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Dolly May Make Up Artist
West End QLD 4101
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=29894 or tblfeedback.strbusinessname='Dolly May Make Up Artist' or tblfeedback.strbusinessname='Dolly May Make Up Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Minx Contemporary Boutique
Toowoomba QLD 4350
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=27708 or tblfeedback.strbusinessname='Minx Contemporary Boutique' or tblfeedback.strbusinessname='Minx Contemporary Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Miss A Hair & Makeup
Warner QLD 4500
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=25299 or tblfeedback.strbusinessname='Miss A Hair &%%semi%% Makeup' or tblfeedback.strbusinessname='Miss A Hair & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Bella Brides
Holland Park QLD 4121
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=22765 or tblfeedback.strbusinessname='Bella Brides' or tblfeedback.strbusinessname='Bella Brides') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sophie Durbidge Make Up Artist
Brisbane QLD 4053
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=39871 or tblfeedback.strbusinessname='Sophie Durbidge Make Up Artist' or tblfeedback.strbusinessname='Sophie Durbidge Make Up Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Glam hair by Tamara
Gatton QLD 4343
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=25358 or tblfeedback.strbusinessname='Glam hair by Tamara' or tblfeedback.strbusinessname='Glam hair by Tamara') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Harpier
Strathpine QLD 4500
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=21929 or tblfeedback.strbusinessname='Harpier' or tblfeedback.strbusinessname='Harpier') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Coleman Consulting
Bridgeman Downs QLD 4035
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=19551 or tblfeedback.strbusinessname='Coleman Consulting' or tblfeedback.strbusinessname='Coleman Consulting') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Blush'd Brides
Yarrabilba QLD 4207
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=29560 or tblfeedback.strbusinessname='Blush'%%semi%%d Brides' or tblfeedback.strbusinessname='Blush'd Brides') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
V'bonnie salon
Red hill QLD 4059
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=26463 or tblfeedback.strbusinessname='V'%%semi%%bonnie salon' or tblfeedback.strbusinessname='V'bonnie salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Clare Hannon
Brisbane QLD 4000
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=29941 or tblfeedback.strbusinessname='Clare Hannon' or tblfeedback.strbusinessname='Clare Hannon') 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
Perfectly Beautiful
Brisbane QLD 4000
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=46624 or tblfeedback.strbusinessname='Perfectly Beautiful' or tblfeedback.strbusinessname='Perfectly Beautiful') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Janets Complete Beauty
Mt Gravatt QLD 4122
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=25157 or tblfeedback.strbusinessname='Janets Complete Beauty' or tblfeedback.strbusinessname='Janets Complete Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Elizabeth Crossley MUA
Brisbane QLD 4000
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=26491 or tblfeedback.strbusinessname='Elizabeth Crossley MUA' or tblfeedback.strbusinessname='Elizabeth Crossley MUA') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Wedding Hair & Makeup by Jessica Rose
Regents park QLD 4118
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=22688 or tblfeedback.strbusinessname='Wedding Hair & Makeup by Jessica Rose' or tblfeedback.strbusinessname='Wedding Hair & Makeup by Jessica Rose') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sarah Courtney Hair Artist
Toowoomba QLD 4350
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=27950 or tblfeedback.strbusinessname='Sarah Courtney Hair Artist' or tblfeedback.strbusinessname='Sarah Courtney Hair Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Blush & Bangs Beauty
Annerley QLD 4103
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=36067 or tblfeedback.strbusinessname='Blush &%%semi%% Bangs Beauty' or tblfeedback.strbusinessname='Blush & Bangs Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Natalie Lucas Makeup & Hair
Gold Coast QLD 4218
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=46492 or tblfeedback.strbusinessname='Natalie Lucas Makeup &%%semi%% Hair' or tblfeedback.strbusinessname='Natalie Lucas Makeup & Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Hair I Come
Gold Coast QLD 4217
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=27243 or tblfeedback.strbusinessname='Hair I Come' or tblfeedback.strbusinessname='Hair I Come') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Chantal Hart Makeup
Brisbane QLD 4000
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=39770 or tblfeedback.strbusinessname='Chantal Hart Makeup' or tblfeedback.strbusinessname='Chantal Hart Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
LK Makeup
Springfield Lakes QLD 4300
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=27387 or tblfeedback.strbusinessname='LK Makeup' or tblfeedback.strbusinessname='LK Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Megan Williamson MUA
Thornlands QLD 4164
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=27927 or tblfeedback.strbusinessname='Megan Williamson MUA' or tblfeedback.strbusinessname='Megan Williamson MUA') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sarah Harrington
Brisbane QLD 4000
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=39878 or tblfeedback.strbusinessname='Sarah Harrington' or tblfeedback.strbusinessname='Sarah Harrington') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Isabella Jane Hairstyling
Broadbeach Waters QLD 4218
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=36155 or tblfeedback.strbusinessname='Isabella Jane Hairstyling' or tblfeedback.strbusinessname='Isabella Jane Hairstyling') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Nicoles Beauty Clinic
Dalby QLD 4405
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=26578 or tblfeedback.strbusinessname='Nicoles Beauty Clinic' or tblfeedback.strbusinessname='Nicoles Beauty Clinic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Leigh McCoy Hair & Makeup
Brisbane QLD 4000
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=46466 or tblfeedback.strbusinessname='Leigh McCoy Hair &%%semi%% Makeup' or tblfeedback.strbusinessname='Leigh McCoy Hair & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Brookfield Makeup
Brookfield QLD 4069
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=38615 or tblfeedback.strbusinessname='Brookfield Makeup' or tblfeedback.strbusinessname='Brookfield Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Makeup by Andri
Brisbane QLD 4000
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=38148 or tblfeedback.strbusinessname='Makeup by Andri' or tblfeedback.strbusinessname='Makeup by Andri') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Makeup by Lira
Stafford QLD 4053
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=27776 or tblfeedback.strbusinessname='Makeup by Lira' or tblfeedback.strbusinessname='Makeup by Lira') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Blissful Beauty Co
Thornlands QLD 4164
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=36323 or tblfeedback.strbusinessname='Blissful Beauty Co' or tblfeedback.strbusinessname='Blissful Beauty Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Pro make up studio
Yeppoon QLD 4703
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=39674 or tblfeedback.strbusinessname='Pro make up studio' or tblfeedback.strbusinessname='Pro make up studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Make overs by Shelly
Springfield Lakes QLD 4300
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=46319 or tblfeedback.strbusinessname='Make overs by Shelly' or tblfeedback.strbusinessname='Make overs by Shelly') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Sheridan Meyers
Brisbane QLD 4000
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=38259 or tblfeedback.strbusinessname='Sheridan Meyers' or tblfeedback.strbusinessname='Sheridan Meyers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rokstar Salon
West End QLD 4101
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=35855 or tblfeedback.strbusinessname='Rokstar Salon' or tblfeedback.strbusinessname='Rokstar Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Miss A Hair and Beauty
Brisbane QLD 4000
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=29867 or tblfeedback.strbusinessname='Miss A Hair and Beauty' or tblfeedback.strbusinessname='Miss A Hair and Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
An eye for style
Cleveland QLD 4163
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=29502 or tblfeedback.strbusinessname='An eye for style' or tblfeedback.strbusinessname='An eye for style') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
View Your Favorites List
