Rating
Natasha Stone Bridal Makeup
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=38441 or tblfeedback.strbusinessname='Natasha Stone Bridal Makeup' or tblfeedback.strbusinessname='Natasha Stone Bridal Makeup') 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
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
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
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
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
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
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
Narelle Amy makeup & hair
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=39657 or tblfeedback.strbusinessname='Narelle Amy makeup &%%semi%% hair' or tblfeedback.strbusinessname='Narelle Amy makeup & hair') 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
The Kat's Whiskers
Salisbury Heights SA 5109
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=46548 or tblfeedback.strbusinessname='The Kat'%%semi%%s Whiskers' or tblfeedback.strbusinessname='The Kat's Whiskers') 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
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
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
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
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
Make up by Jessica Ramsey
Aldinga beach SA 5173
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=39733 or tblfeedback.strbusinessname='Make up by Jessica Ramsey' or tblfeedback.strbusinessname='Make up by Jessica Ramsey') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Mannly Makeup
Roseworthy SA 5371
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=41350 or tblfeedback.strbusinessname='Mannly Makeup' or tblfeedback.strbusinessname='Mannly Makeup') 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
Makeup by Kate Heaslip
Henley Beach 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=41238 or tblfeedback.strbusinessname='Makeup by Kate Heaslip' or tblfeedback.strbusinessname='Makeup by Kate Heaslip') 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
Makeup by Rechelle
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=37807 or tblfeedback.strbusinessname='Makeup by Rechelle' or tblfeedback.strbusinessname='Makeup by Rechelle') 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
Mobile Make-Overs
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=41398 or tblfeedback.strbusinessname='Mobile Make-Overs' or tblfeedback.strbusinessname='Mobile Make-Overs') 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
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
TJ's Style Bar
Fulham SA 5024
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=44811 or tblfeedback.strbusinessname='TJ'%%semi%%s Style Bar' or tblfeedback.strbusinessname='TJ's Style Bar') 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
Kylie Stainer Makeup Artistry
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=41608 or tblfeedback.strbusinessname='Kylie Stainer Makeup Artistry' or tblfeedback.strbusinessname='Kylie Stainer Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Manto
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=6216 or tblfeedback.strbusinessname='Manto' or tblfeedback.strbusinessname='Manto') 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
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
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
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
Lyne Zalewski
Dover Gardens SA 5048
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=6213 or tblfeedback.strbusinessname='Lyne Zalewski' or tblfeedback.strbusinessname='Lyne Zalewski') 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 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
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
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
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
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
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
Makeup Studio With 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=6215 or tblfeedback.strbusinessname='Makeup Studio With Dina Giaccio' or tblfeedback.strbusinessname='Makeup Studio With Dina Giaccio') 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
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
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
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
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
Stage Shop The
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=6223 or tblfeedback.strbusinessname='Stage Shop The' or tblfeedback.strbusinessname='Stage Shop The') 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
1 - 50 of 69 Sort search results alphabetically