Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pure Envy Makeup
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=27039 or tblfeedback.strbusinessname='Pure Envy Makeup' or tblfeedback.strbusinessname='Pure Envy Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Manes & Makeup
Jacobs Well QLD 4208
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=26126 or tblfeedback.strbusinessname='Manes &%%semi%% Makeup' or tblfeedback.strbusinessname='Manes & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Evalyn Parsons Hair
Moffat Beach 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=38566 or tblfeedback.strbusinessname='Evalyn Parsons Hair' or tblfeedback.strbusinessname='Evalyn Parsons Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Make up by Jaz
Burleigh Waters QLD 4220
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=26961 or tblfeedback.strbusinessname='Make up by Jaz' or tblfeedback.strbusinessname='Make up by Jaz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
KB Hair and Makeup
Palm Beach QLD 4221
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=29868 or tblfeedback.strbusinessname='KB Hair and Makeup' or tblfeedback.strbusinessname='KB Hair and Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kylie's Professional
Burleigh Heads QLD 4220
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=25728 or tblfeedback.strbusinessname='Kylie'%%semi%%s Professional' or tblfeedback.strbusinessname='Kylie's Professional') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Emma Lancaster Makeup
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=27807 or tblfeedback.strbusinessname='Emma Lancaster Makeup' or tblfeedback.strbusinessname='Emma Lancaster Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mia Connor - Makeup Artist
Robina QLD 4226
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=22151 or tblfeedback.strbusinessname='Mia Connor - Makeup Artist' or tblfeedback.strbusinessname='Mia Connor - Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Makeup By Jaz
Varsity Lakes QLD 4227
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=26713 or tblfeedback.strbusinessname='Makeup By Jaz' or tblfeedback.strbusinessname='Makeup By Jaz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Inspired Artistry
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=29711 or tblfeedback.strbusinessname='Inspired Artistry' or tblfeedback.strbusinessname='Inspired Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mish & Co
Burleigh Heads QLD 4220
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=38214 or tblfeedback.strbusinessname='Mish &%%semi%% Co' or tblfeedback.strbusinessname='Mish & Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lara Quinn
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=26006 or tblfeedback.strbusinessname='Lara Quinn' or tblfeedback.strbusinessname='Lara Quinn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sally R Makeup
Currumbin or Arundel QLD 4214
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=22743 or tblfeedback.strbusinessname='Sally R Makeup' or tblfeedback.strbusinessname='Sally R Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cassaz Colourful Curls
Allora QLD 4362
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=27412 or tblfeedback.strbusinessname='Cassaz Colourful Curls' or tblfeedback.strbusinessname='Cassaz Colourful Curls') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lauren Saul
Ormeau QLD 4208
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=29282 or tblfeedback.strbusinessname='Lauren Saul' or tblfeedback.strbusinessname='Lauren Saul') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Zoe Sewell Bridal Hairstylist
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=46400 or tblfeedback.strbusinessname='Zoe Sewell Bridal Hairstylist' or tblfeedback.strbusinessname='Zoe Sewell Bridal Hairstylist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Face It, You're Beautiful
Ashmore QLD 4214
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=26228 or tblfeedback.strbusinessname='Face It, You'%%semi%%re Beautiful' or tblfeedback.strbusinessname='Face It, You're Beautiful') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Krystal Robbins
Currumbin QLD 4223
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=26990 or tblfeedback.strbusinessname='Krystal Robbins' or tblfeedback.strbusinessname='Krystal Robbins') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Isabella Jane Hair & Makeup
Burleigh Waters QLD 4220
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=43133 or tblfeedback.strbusinessname='Isabella Jane Hair &%%semi%% Makeup' or tblfeedback.strbusinessname='Isabella Jane Hair & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Esho & Co Makeup
Robina QLD 4226
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=26518 or tblfeedback.strbusinessname='Esho &%%semi%% Co Makeup' or tblfeedback.strbusinessname='Esho & Co Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Alesha Maree Hair and Makeup
Carrara QLD 4211
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=44100 or tblfeedback.strbusinessname='Alesha Maree Hair and Makeup' or tblfeedback.strbusinessname='Alesha Maree Hair and Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Makeup Hut
Gold Coast QLD 4220
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=43188 or tblfeedback.strbusinessname='The Makeup Hut' or tblfeedback.strbusinessname='The Makeup Hut') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Aurum Bride
Biggera Waters QLD 4216
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=42909 or tblfeedback.strbusinessname='Aurum Bride' or tblfeedback.strbusinessname='Aurum Bride') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Amy Spry Hair
Coolangatta QLD 4225
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=38252 or tblfeedback.strbusinessname='Amy Spry Hair' or tblfeedback.strbusinessname='Amy Spry Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
House of Glamour
Southport QLD 4215
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=21029 or tblfeedback.strbusinessname='House of Glamour' or tblfeedback.strbusinessname='House of Glamour') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
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
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jasmine Lei Creations
Upper Coomera QLD 4209
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=29081 or tblfeedback.strbusinessname='Jasmine Lei Creations' or tblfeedback.strbusinessname='Jasmine Lei Creations') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Inspired Artistry - Hair & Makeup by Mickeela
Gold Coast 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=44775 or tblfeedback.strbusinessname='Inspired Artistry - Hair &%%semi%% Makeup by Mickeela' or tblfeedback.strbusinessname='Inspired Artistry - Hair & Makeup by Mickeela') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tina Kristen Weddings
Gold Coast QLD 4211
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=24232 or tblfeedback.strbusinessname='Tina Kristen Weddings' or tblfeedback.strbusinessname='Tina Kristen Weddings') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Impressions by Melissa
Parkwood QLD 4214
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=18867 or tblfeedback.strbusinessname='Impressions by Melissa' or tblfeedback.strbusinessname='Impressions by Melissa') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bridal Make Up & Hair
Tugun QLD 4224
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=2801 or tblfeedback.strbusinessname='Bridal Make Up &%%semi%% Hair' or tblfeedback.strbusinessname='Bridal Make Up & Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Julia Stokes Makeup Artistry
Benowa 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=15895 or tblfeedback.strbusinessname='Julia Stokes Makeup Artistry' or tblfeedback.strbusinessname='Julia Stokes Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
A Next International Hairdressers
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=15870 or tblfeedback.strbusinessname='A Next International Hairdressers' or tblfeedback.strbusinessname='A Next International Hairdressers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Accredited Anywhere Hair
Surfers Paradise 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=15871 or tblfeedback.strbusinessname='Accredited Anywhere Hair' or tblfeedback.strbusinessname='Accredited Anywhere Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Cj's Make-Up Artistry
Robina QLD 4226
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=15883 or tblfeedback.strbusinessname='Cj'%%semi%%s Make-Up Artistry' or tblfeedback.strbusinessname='Cj's Make-Up Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Wiebke Luske
Brisbane QLD 4275
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=18894 or tblfeedback.strbusinessname='Wiebke Luske' or tblfeedback.strbusinessname='Wiebke Luske') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Paradise Hair Indulgence
Surfers Paradise 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=18879 or tblfeedback.strbusinessname='Paradise Hair Indulgence' or tblfeedback.strbusinessname='Paradise Hair Indulgence') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Envy Hair & Make-Up
Coolangatta QLD 4225
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=15887 or tblfeedback.strbusinessname='Envy Hair &%%semi%% Make-Up' or tblfeedback.strbusinessname='Envy Hair & Make-Up') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Konc Design
ChirnPark QLD 4215
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=18872 or tblfeedback.strbusinessname='Konc Design' or tblfeedback.strbusinessname='Konc Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Samantha Novak
Southport QLD 4215
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=18886 or tblfeedback.strbusinessname='Samantha Novak' or tblfeedback.strbusinessname='Samantha Novak') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 60 Sort search results alphabetically