Rating Finesse Makeup
Finesse Makeup
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=20083 or tblfeedback.strbusinessname='Finesse Makeup' or tblfeedback.strbusinessname='Finesse Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
A professional fully mobile makeup service.
Rating Cutting Edge Boutique
Cutting Edge Boutique
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=23017 or tblfeedback.strbusinessname='Cutting Edge Boutique' or tblfeedback.strbusinessname='Cutting Edge Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
A luxury, boutique salon experience, leave feeling relaxed & beautiful.

Rating
Rachael Gregory Hairstyling & Makeup
Cairns QLD 4870
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=15908 or tblfeedback.strbusinessname='Rachael Gregory Hairstyling &%%semi%% Makeup' or tblfeedback.strbusinessname='Rachael Gregory Hairstyling & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Berry Lane Hair
Cairns QLD 4870
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=21664 or tblfeedback.strbusinessname='Berry Lane Hair' or tblfeedback.strbusinessname='Berry Lane Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blossom Hair and Beauty
Bushland Beach QLD 4818
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=25637 or tblfeedback.strbusinessname='Blossom Hair and Beauty' or tblfeedback.strbusinessname='Blossom Hair and Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Hair Shop
Port Douglas QLD 4877
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=27229 or tblfeedback.strbusinessname='The Hair Shop' or tblfeedback.strbusinessname='The Hair Shop') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Your Canvas Make Up
Riverside Gardens QLD 4811
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=38351 or tblfeedback.strbusinessname='Your Canvas Make Up' or tblfeedback.strbusinessname='Your Canvas Make Up') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Doll face beauty & makeup
Carins QLD 4870
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=23213 or tblfeedback.strbusinessname='Doll face beauty &%%semi%% makeup' or tblfeedback.strbusinessname='Doll face beauty & makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Makeup by Ellen
Whitfield QLD 4870
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=29539 or tblfeedback.strbusinessname='Makeup by Ellen' or tblfeedback.strbusinessname='Makeup by Ellen') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Your Canvas Makeup - Lan
Townsville QLD 4814
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=38536 or tblfeedback.strbusinessname='Your Canvas Makeup - Lan' or tblfeedback.strbusinessname='Your Canvas Makeup - Lan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Makeup by Makayla
Cairns QLD 4880
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=29200 or tblfeedback.strbusinessname='Makeup by Makayla' or tblfeedback.strbusinessname='Makeup by Makayla') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Urban Miss Beauty Bar
Townsville QLD 4810
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=38500 or tblfeedback.strbusinessname='Urban Miss Beauty Bar' or tblfeedback.strbusinessname='Urban Miss Beauty Bar') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Everwonder Hair Creatives
Mackay QLD 4740
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=29335 or tblfeedback.strbusinessname='Everwonder Hair Creatives' or tblfeedback.strbusinessname='Everwonder Hair Creatives') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sisbella Hair and Beauty
Charters Towers QLD 4820
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=38367 or tblfeedback.strbusinessname='Sisbella Hair and Beauty' or tblfeedback.strbusinessname='Sisbella Hair and Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Capricorn Hair Studio
Mount Isa QLD 4825
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=29245 or tblfeedback.strbusinessname='Capricorn Hair Studio' or tblfeedback.strbusinessname='Capricorn Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Inner Goddesss Hair
Atherton QLD 4883
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=23657 or tblfeedback.strbusinessname='Inner Goddesss Hair' or tblfeedback.strbusinessname='Inner Goddesss Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
CMH Artistry
Townsville QLD 4810
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=38487 or tblfeedback.strbusinessname='CMH Artistry' or tblfeedback.strbusinessname='CMH Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
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
NV Beauty and Cosmetic Tattooing
Cairns North QLD 4870
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=27111 or tblfeedback.strbusinessname='NV Beauty and Cosmetic Tattooing' or tblfeedback.strbusinessname='NV Beauty and Cosmetic Tattooing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tableland Bridal & Event Makeup
Tablelands QLD 4883
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=29595 or tblfeedback.strbusinessname='Tableland Bridal &%%semi%% Event Makeup' or tblfeedback.strbusinessname='Tableland Bridal & Event Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Touch of Utopia - Professional Hair Stylists
Townsville City QLD 4810
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=27323 or tblfeedback.strbusinessname='Touch of Utopia - Professional Hair Stylists' or tblfeedback.strbusinessname='Touch of Utopia - Professional Hair Stylists') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Loose Endz
Deeragun QLD 4818
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=27061 or tblfeedback.strbusinessname='Loose Endz' or tblfeedback.strbusinessname='Loose Endz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
rhondall hair and make up
Townsville QLD 4817
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=35897 or tblfeedback.strbusinessname='rhondall hair and make up' or tblfeedback.strbusinessname='rhondall hair and make up') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Georgies Beauty Room
Townsville QLD 4817
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=44658 or tblfeedback.strbusinessname='Georgies Beauty Room' or tblfeedback.strbusinessname='Georgies Beauty Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pulse Hair
Cairns QLD 4870
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=27033 or tblfeedback.strbusinessname='Pulse Hair' or tblfeedback.strbusinessname='Pulse Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Podium hair and beauty
Townsville QLD 4810
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=43346 or tblfeedback.strbusinessname='Podium hair and beauty' or tblfeedback.strbusinessname='Podium hair and beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
JAK Salons
Atherton QLD 4883
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=37612 or tblfeedback.strbusinessname='JAK Salons' or tblfeedback.strbusinessname='JAK Salons') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The House of Marah
Bundaberg QLD 4670
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=27235 or tblfeedback.strbusinessname='The House of Marah' or tblfeedback.strbusinessname='The House of Marah') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bella Hair by Monica
Cairns QLD 4870
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=27070 or tblfeedback.strbusinessname='Bella Hair by Monica' or tblfeedback.strbusinessname='Bella Hair by Monica') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
HM Makeup & Brow Artist Mackay
Mackay QLD 4740
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=29336 or tblfeedback.strbusinessname='HM Makeup &%%semi%% Brow Artist Mackay' or tblfeedback.strbusinessname='HM Makeup & Brow Artist Mackay') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kristin Martin Makeup Artist
Townsville QLD 4817
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=29000 or tblfeedback.strbusinessname='Kristin Martin Makeup Artist' or tblfeedback.strbusinessname='Kristin Martin Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Selina Baldry Make-Up Artistry
Bundaberg QLD 4670
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=26482 or tblfeedback.strbusinessname='Selina Baldry Make-Up Artistry' or tblfeedback.strbusinessname='Selina Baldry Make-Up Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bella Obsessions Hairdressing
Mount Isa QLD 4825
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=26598 or tblfeedback.strbusinessname='Bella Obsessions Hairdressing' or tblfeedback.strbusinessname='Bella Obsessions Hairdressing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
NG Hair
Rockhampton QLD 4701
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=26154 or tblfeedback.strbusinessname='NG Hair' or tblfeedback.strbusinessname='NG Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Totoka Hair and Makeup
Nadi Fiji 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=23763 or tblfeedback.strbusinessname='Totoka Hair and Makeup' or tblfeedback.strbusinessname='Totoka Hair and Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Emmy Poppins Makeup
Townsville QLD 4810
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=29891 or tblfeedback.strbusinessname='Emmy Poppins Makeup' or tblfeedback.strbusinessname='Emmy Poppins Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Events Makeup and Hair Cairns
Cairns QLD 4870
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=37380 or tblfeedback.strbusinessname='Events Makeup and Hair Cairns' or tblfeedback.strbusinessname='Events Makeup and Hair Cairns') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Sarah Holmes Make-up Artist Cairns
Cairns QLD 4870
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=39715 or tblfeedback.strbusinessname='Sarah Holmes Make-up Artist Cairns' or tblfeedback.strbusinessname='Sarah Holmes Make-up Artist Cairns') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Inspire Hair by Sarah
Andergrove QLD 4740
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=43586 or tblfeedback.strbusinessname='Inspire Hair by Sarah' or tblfeedback.strbusinessname='Inspire Hair by Sarah') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Christy Goldfinch
Ingham QLD 4850
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=26102 or tblfeedback.strbusinessname='Christy Goldfinch' or tblfeedback.strbusinessname='Christy Goldfinch') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Wild Lilly Hair
Aitkenvale QLD 4814
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=41305 or tblfeedback.strbusinessname='Wild Lilly Hair' or tblfeedback.strbusinessname='Wild Lilly Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blush Make up Designs
Cairns QLD 4870
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=18851 or tblfeedback.strbusinessname='Blush Make up Designs' or tblfeedback.strbusinessname='Blush Make up Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Reds Salon
Cairns QLD 4870
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=18883 or tblfeedback.strbusinessname='Reds Salon' or tblfeedback.strbusinessname='Reds Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tanya's Travelling Scissors
Townsville QLD 4810
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=15920 or tblfeedback.strbusinessname='Tanya'%%semi%%s Travelling Scissors' or tblfeedback.strbusinessname='Tanya's Travelling Scissors') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sophisticut Hair Salon
Hermit Park QLD 4812
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=15918 or tblfeedback.strbusinessname='Sophisticut Hair Salon' or tblfeedback.strbusinessname='Sophisticut Hair Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sensaysh Hair & Makeup
Manunda QLD 4870
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=15915 or tblfeedback.strbusinessname='Sensaysh Hair &%%semi%% Makeup' or tblfeedback.strbusinessname='Sensaysh Hair & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Angelz
Townsville QLD 4810
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=18848 or tblfeedback.strbusinessname='Angelz' or tblfeedback.strbusinessname='Angelz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Total Hair Studio
Manunda QLD 4870
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=15922 or tblfeedback.strbusinessname='Total Hair Studio' or tblfeedback.strbusinessname='Total Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Noelene's Nail & Skin Care
Parramatta Park QLD 4870
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=18877 or tblfeedback.strbusinessname='Noelene'%%semi%%s Nail &%%semi%% Skin Care' or tblfeedback.strbusinessname='Noelene's Nail & Skin Care') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
MASS
PortDouglas QLD 4871
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=18875 or tblfeedback.strbusinessname='MASS' or tblfeedback.strbusinessname='MASS') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 52 Sort search results alphabetically