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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Chilli Hair
31 Gawler street 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Caitlin Rose Makeup Artist
Shop 2, 435-439 Fullarton road 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Karen Hedger Complete Look
Shop 19 Pelican Plaza Shopping Centre Cnr North East & Golden Grove Roads 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 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 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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Serene Hair and Beauty Lounge
370 Magill Rd 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 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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bla-Zo's Hair Studio
1291 North East Road 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 year(getdate())-year(dtmadded)<=15
Rating
Elska Studios
Po Box 309 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hair Persuasion
152 Payneham Rd 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hair Tonic
1/ 27 Heading Ave 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Havringtons Hair Designs
302A Greenhill Rd 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jazz Cutters
Shop 2 Brebner Dr 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Make a Face Makeup
Mobile Service 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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Ninette's Hair City Salon
82 Hindley Street 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 year(getdate())-year(dtmadded)<=15
Rating
The Buff Makeup Beauty & Nails
36 East Tce 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 year(getdate())-year(dtmadded)<=15
Rating
The Salon Hair Designers
14 Krummel Street 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 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 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 year(getdate())-year(dtmadded)<=15
Rating
Marro's Professional Hair & Beauty
171 Glynburn Road 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 year(getdate())-year(dtmadded)<=15
Rating
Alessi Hair
297 Brighton Road 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 year(getdate())-year(dtmadded)<=15
Rating
Angels
Rosewood Village 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Blush Makeup Designs
1220 Grand Junction Road 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 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 year(getdate())-year(dtmadded)<=15
Rating
Costalos
8 Evans Avenue 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 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 year(getdate())-year(dtmadded)<=15
Rating
Crowning Glory
70 Broadway Street 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 year(getdate())-year(dtmadded)<=15
Rating
DDP Makeup Studio
503 Regency Road 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 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 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 year(getdate())-year(dtmadded)<=15
Rating
Face Dreams
15 Rose Terrace 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 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 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 year(getdate())-year(dtmadded)<=15
Rating
Hair Artistique
140 King William Road 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 year(getdate())-year(dtmadded)<=15
Rating
Hair Artistique
212 Brighton Road 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 year(getdate())-year(dtmadded)<=15
Rating
Hair Artistique
370D Kensington Road 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 year(getdate())-year(dtmadded)<=15
Rating
Hair Artistique
60 Beach Road 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 year(getdate())-year(dtmadded)<=15
Rating
Hair Hair
37A Beckman Street 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 year(getdate())-year(dtmadded)<=15
Rating
Klasse Hair by
34 Hallett Road 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 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 year(getdate())-year(dtmadded)<=15
Rating
Make A Face Make-Up
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=6214 or tblfeedback.strbusinessname='Make A Face Make-Up' or tblfeedback.strbusinessname='Make A Face Make-Up') 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 year(getdate())-year(dtmadded)<=15
Rating
Manto
3 Pope Crescent 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 year(getdate())-year(dtmadded)<=15
Rating
Michelle's Mobile Hair Design
Parafield Gardens SA 5107
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=6219 or tblfeedback.strbusinessname='Michelle'%%semi%%s Mobile Hair Design' or tblfeedback.strbusinessname='Michelle's Mobile Hair Design') and year(getdate())-year(dtmadded)<=15
Rating
Sonya Wiese
Morphett Vale 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=6222 or tblfeedback.strbusinessname='Sonya Wiese' or tblfeedback.strbusinessname='Sonya Wiese') and year(getdate())-year(dtmadded)<=15
1 - 50 of 51 Sort search results alphabetically