Rating
Riz Beauty Co
Geelong VIC 3220
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=29496 or tblfeedback.strbusinessname='Riz Beauty Co' or tblfeedback.strbusinessname='Riz Beauty Co') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Make up by Miranda
Belmont VIC 3216
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=25195 or tblfeedback.strbusinessname='Make up by Miranda' or tblfeedback.strbusinessname='Make up by Miranda') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cosmetic MD
Melbourne VIC 3000
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=46426 or tblfeedback.strbusinessname='Cosmetic MD' or tblfeedback.strbusinessname='Cosmetic MD') 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
Hair by Elesha Rae
Werribee VIC 3030
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=24884 or tblfeedback.strbusinessname='Hair by Elesha Rae' or tblfeedback.strbusinessname='Hair by Elesha Rae') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bella Lewis Makeup Artistry
Warrnambool VIC 3280
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=26755 or tblfeedback.strbusinessname='Bella Lewis Makeup Artistry' or tblfeedback.strbusinessname='Bella Lewis Makeup Artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Holly Brooke Makeup
Geelong VIC 3220
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=27465 or tblfeedback.strbusinessname='Holly Brooke Makeup' or tblfeedback.strbusinessname='Holly Brooke Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Makeup by Cass
Werribee VIC 3039
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=24885 or tblfeedback.strbusinessname='Makeup by Cass' or tblfeedback.strbusinessname='Makeup by Cass') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hair by Nikita
Geelong VIC 3220
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=23963 or tblfeedback.strbusinessname='Hair by Nikita' or tblfeedback.strbusinessname='Hair by Nikita') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hair & Lashes By Nikita
Geelong VIC 3220
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=35982 or tblfeedback.strbusinessname='Hair &%%semi%% Lashes By Nikita' or tblfeedback.strbusinessname='Hair & Lashes By Nikita') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
I Know a Chick
Bell Park VIC 3215
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=37988 or tblfeedback.strbusinessname='I Know a Chick' or tblfeedback.strbusinessname='I Know a Chick') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
CornerWorks Hairdressing
Geelong VIC 3220
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=29314 or tblfeedback.strbusinessname='CornerWorks Hairdressing' or tblfeedback.strbusinessname='CornerWorks Hairdressing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Make-Up Artistry by Rachel
Newtown VIC 3220
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=13286 or tblfeedback.strbusinessname='Make-Up Artistry by Rachel' or tblfeedback.strbusinessname='Make-Up Artistry by Rachel') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Sue Kayler-Thomson
Highton VIC 3216
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=13293 or tblfeedback.strbusinessname='Sue Kayler-Thomson' or tblfeedback.strbusinessname='Sue Kayler-Thomson') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Topaz Hair Studio
Waurn Ponds VIC 3216
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=13294 or tblfeedback.strbusinessname='Topaz Hair Studio' or tblfeedback.strbusinessname='Topaz Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Darren Grayson Salon Functions Interiors
Geelong VIC 3220
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=13275 or tblfeedback.strbusinessname='Darren Grayson Salon Functions Interiors' or tblfeedback.strbusinessname='Darren Grayson Salon Functions Interiors') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Make-Up Magic
Geelong West VIC 3218
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=840 or tblfeedback.strbusinessname='Make-Up Magic' or tblfeedback.strbusinessname='Make-Up Magic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Perfections Beauty by Tamara
Hamlyn Heights VIC 3215
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=13290 or tblfeedback.strbusinessname='Perfections Beauty by Tamara' or tblfeedback.strbusinessname='Perfections Beauty by Tamara') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Evolution Hair Design
Belmont VIC 3216
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=12644 or tblfeedback.strbusinessname='Evolution Hair Design' or tblfeedback.strbusinessname='Evolution Hair Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15