Rating
Sam Frost Hairstylist
Adelaide SA 5000
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=29797 or tblfeedback.strbusinessname='Sam Frost Hairstylist' or tblfeedback.strbusinessname='Sam Frost Hairstylist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Parisian Hair and Beaute
Moonta SA 5558
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=35779 or tblfeedback.strbusinessname='Parisian Hair and Beaute' or tblfeedback.strbusinessname='Parisian Hair and Beaute') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Horosho Makeup and Beauty
Glenelg SA 5045
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=35692 or tblfeedback.strbusinessname='Horosho Makeup and Beauty' or tblfeedback.strbusinessname='Horosho Makeup and Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
NV Makeup and Hair Styling
Adelaide SA 5000
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=26281 or tblfeedback.strbusinessname='NV Makeup and Hair Styling' or tblfeedback.strbusinessname='NV Makeup and Hair Styling') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lush Lip
Port Augusta SA 5700
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=25767 or tblfeedback.strbusinessname='Lush Lip' or tblfeedback.strbusinessname='Lush Lip') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chilli Hair
Mount Barker SA 5251
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=25162 or tblfeedback.strbusinessname='Chilli Hair' or tblfeedback.strbusinessname='Chilli Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Caitlin Rose Makeup Artist
Highgate SA 5063
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=25163 or tblfeedback.strbusinessname='Caitlin Rose Makeup Artist' or tblfeedback.strbusinessname='Caitlin Rose Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Karen Hedger Complete Look
Ridgehaven SA 5097
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=26036 or tblfeedback.strbusinessname='Karen Hedger Complete Look' or tblfeedback.strbusinessname='Karen Hedger Complete Look') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beauty to D-Zire
Mawson Lakes SA 5095
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=26667 or tblfeedback.strbusinessname='Beauty to D-Zire' or tblfeedback.strbusinessname='Beauty to D-Zire') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Amanda Grace Nash
Unley SA 5061
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=29028 or tblfeedback.strbusinessname='Amanda Grace Nash' or tblfeedback.strbusinessname='Amanda Grace Nash') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Glamour SA Makeup & Photography
Oakden SA 5086
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=27666 or tblfeedback.strbusinessname='Glamour SA Makeup &%%semi%% Photography' or tblfeedback.strbusinessname='Glamour SA Makeup & Photography') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Serene Hair and Beauty Lounge
Kensington Park SA 5068
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=27731 or tblfeedback.strbusinessname='Serene Hair and Beauty Lounge' or tblfeedback.strbusinessname='Serene Hair and Beauty Lounge') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
The Blushing Creator
Plympton Park SA 5038
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=29205 or tblfeedback.strbusinessname='The Blushing Creator' or tblfeedback.strbusinessname='The Blushing Creator') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
She said yes and co
Adelaide South SA 5000
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=29653 or tblfeedback.strbusinessname='She said yes and co' or tblfeedback.strbusinessname='She said yes and co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
NEAT Hair & Beauty
Para Hills West SA 5096
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=36282 or tblfeedback.strbusinessname='NEAT Hair &%%semi%% Beauty' or tblfeedback.strbusinessname='NEAT Hair & Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Samie Williams
Happy Valley SA 5162
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=36283 or tblfeedback.strbusinessname='Samie Williams' or tblfeedback.strbusinessname='Samie Williams') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Billie's Makeup
Port Augusta SA 5700
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=37725 or tblfeedback.strbusinessname='Billie'%%semi%%s Makeup' or tblfeedback.strbusinessname='Billie's Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bla-Zo's Hair Studio
Tea Tree Gully SA 5091
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=19048 or tblfeedback.strbusinessname='Bla-Zo'%%semi%%s Hair Studio' or tblfeedback.strbusinessname='Bla-Zo's Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Elska Studios
Happy Valley SA 5159
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=19094 or tblfeedback.strbusinessname='Elska Studios' or tblfeedback.strbusinessname='Elska Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hair Persuasion
Evandale SA 5069
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=19121 or tblfeedback.strbusinessname='Hair Persuasion' or tblfeedback.strbusinessname='Hair Persuasion') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hair Tonic
Campbelltown SA 5074
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=19122 or tblfeedback.strbusinessname='Hair Tonic' or tblfeedback.strbusinessname='Hair Tonic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Havringtons Hair Designs
Glenside SA 5065
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=19123 or tblfeedback.strbusinessname='Havringtons Hair Designs' or tblfeedback.strbusinessname='Havringtons Hair Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Jazz Cutters
West Lakes SA 5021
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=19137 or tblfeedback.strbusinessname='Jazz Cutters' or tblfeedback.strbusinessname='Jazz Cutters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Make a Face Makeup
Sheidow Park SA 5158
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=19150 or tblfeedback.strbusinessname='Make a Face Makeup' or tblfeedback.strbusinessname='Make a Face Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Make Up Studio - Dina Giaccio
Port Noarlunga South SA 5167
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=19151 or tblfeedback.strbusinessname='Make Up Studio - Dina Giaccio' or tblfeedback.strbusinessname='Make Up Studio - Dina Giaccio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ninette's Hair City Salon
Adelaide SA 5000
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=19161 or tblfeedback.strbusinessname='Ninette'%%semi%%s Hair City Salon' or tblfeedback.strbusinessname='Ninette's Hair City Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Buff Makeup Beauty & Nails
Adelaide SA 5000
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=19222 or tblfeedback.strbusinessname='The Buff Makeup Beauty &%%semi%% Nails' or tblfeedback.strbusinessname='The Buff Makeup Beauty & Nails') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
The Salon Hair Designers
Mt Gambier SA 5092
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=19231 or tblfeedback.strbusinessname='The Salon Hair Designers' or tblfeedback.strbusinessname='The Salon Hair Designers') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jodi Nash
Adelaide SA 5000
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=5034 or tblfeedback.strbusinessname='Jodi Nash' or tblfeedback.strbusinessname='Jodi Nash') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lynch
Hawthorn SA 5062
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=6212 or tblfeedback.strbusinessname='Lynch' or tblfeedback.strbusinessname='Lynch') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Marro's Professional Hair & Beauty
Firle SA 5070
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=5674 or tblfeedback.strbusinessname='Marro'%%semi%%s Professional Hair &%%semi%% Beauty' or tblfeedback.strbusinessname='Marro's Professional Hair & Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alessi Hair
Somerton Park SA 5044
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=6191 or tblfeedback.strbusinessname='Alessi Hair' or tblfeedback.strbusinessname='Alessi Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Angels
Elizabeth SA 5112
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=6192 or tblfeedback.strbusinessname='Angels' or tblfeedback.strbusinessname='Angels') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blush Makeup Designs
Hope Valley SA 5090
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=6193 or tblfeedback.strbusinessname='Blush Makeup Designs' or tblfeedback.strbusinessname='Blush Makeup Designs') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Chameleeon Pty Ltd
One Tree Hill SA 5114
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=6194 or tblfeedback.strbusinessname='Chameleeon Pty Ltd' or tblfeedback.strbusinessname='Chameleeon Pty Ltd') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Costalos
Mitcham SA 5062
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=6196 or tblfeedback.strbusinessname='Costalos' or tblfeedback.strbusinessname='Costalos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Creations Plus
Grange SA 5022
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=6197 or tblfeedback.strbusinessname='Creations Plus' or tblfeedback.strbusinessname='Creations Plus') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Crowning Glory
Glenelg South SA 5045
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=6198 or tblfeedback.strbusinessname='Crowning Glory' or tblfeedback.strbusinessname='Crowning Glory') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
DDP Makeup Studio
Sefton Park SA 5083
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=6199 or tblfeedback.strbusinessname='DDP Makeup Studio' or tblfeedback.strbusinessname='DDP Makeup Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Dimitriadis
Rostrevor SA 5073
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=6200 or tblfeedback.strbusinessname='Dimitriadis' or tblfeedback.strbusinessname='Dimitriadis') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Esposito
Ovingham SA 5082
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=6201 or tblfeedback.strbusinessname='Esposito' or tblfeedback.strbusinessname='Esposito') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Face Dreams
Wayville SA 5034
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=6202 or tblfeedback.strbusinessname='Face Dreams' or tblfeedback.strbusinessname='Face Dreams') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Frangos
Mitchell Park SA 5043
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=6203 or tblfeedback.strbusinessname='Frangos' or tblfeedback.strbusinessname='Frangos') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Artistique
North Adelaide SA 5006
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=6204 or tblfeedback.strbusinessname='Hair Artistique' or tblfeedback.strbusinessname='Hair Artistique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Artistique
Hyde Park SA 5061
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=6205 or tblfeedback.strbusinessname='Hair Artistique' or tblfeedback.strbusinessname='Hair Artistique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Artistique
Somerton Park SA 5044
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=6206 or tblfeedback.strbusinessname='Hair Artistique' or tblfeedback.strbusinessname='Hair Artistique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Artistique
Erindale SA 5066
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=6207 or tblfeedback.strbusinessname='Hair Artistique' or tblfeedback.strbusinessname='Hair Artistique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Artistique
Christies Beach SA 5165
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=6208 or tblfeedback.strbusinessname='Hair Artistique' or tblfeedback.strbusinessname='Hair Artistique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Hair Hair
Glandore SA 5037
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=6209 or tblfeedback.strbusinessname='Hair Hair' or tblfeedback.strbusinessname='Hair Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Klasse Hair by
Stonyfell SA 5066
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=6211 or tblfeedback.strbusinessname='Klasse Hair by' or tblfeedback.strbusinessname='Klasse Hair by') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
1 - 50 of 57 Sort search results alphabetically