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
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,
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
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!
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
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
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
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
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
Jessica Peacock Makeup
Brisbane 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=38287 or tblfeedback.strbusinessname='Jessica Peacock Makeup' or tblfeedback.strbusinessname='Jessica Peacock Makeup') 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
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
Studio CA
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=27970 or tblfeedback.strbusinessname='Studio CA' or tblfeedback.strbusinessname='Studio CA') 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
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
Hollywood Brides
Sunnybank QLD 4113
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=21544 or tblfeedback.strbusinessname='Hollywood Brides' or tblfeedback.strbusinessname='Hollywood Brides') 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
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
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
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
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
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
The Touch Up Team
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=21821 or tblfeedback.strbusinessname='The Touch Up Team' or tblfeedback.strbusinessname='The Touch Up Team') 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
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
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
Angela Curtis Make-up
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=26348 or tblfeedback.strbusinessname='Angela Curtis Make-up' or tblfeedback.strbusinessname='Angela Curtis Make-up') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Tyneal Hahn Makeup Artist
Lockyer Valley QLD 4341
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=46156 or tblfeedback.strbusinessname='Tyneal Hahn Makeup Artist' or tblfeedback.strbusinessname='Tyneal Hahn Makeup Artist') 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
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
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
La Spa Parisien
Wilston QLD 4051
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=29211 or tblfeedback.strbusinessname='La Spa Parisien' or tblfeedback.strbusinessname='La Spa Parisien') 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
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
JoMac Make Up
Ormiston QLD 4160
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=29859 or tblfeedback.strbusinessname='JoMac Make Up' or tblfeedback.strbusinessname='JoMac Make Up') 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
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
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
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
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
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
Belladonna Brides
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=21421 or tblfeedback.strbusinessname='Belladonna Brides' or tblfeedback.strbusinessname='Belladonna Brides') 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
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
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
Dolls & Sailors
Augustine Heights 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=29047 or tblfeedback.strbusinessname='Dolls &%%semi%% Sailors' or tblfeedback.strbusinessname='Dolls & Sailors') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15