Rating
KazC Mobile Makeup Artisty
Sorell TAS 7172
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=27421 or tblfeedback.strbusinessname='KazC Mobile Makeup Artisty' or tblfeedback.strbusinessname='KazC Mobile Makeup Artisty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Audrey Hair
Sorell TAS 7172
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=27856 or tblfeedback.strbusinessname='Audrey Hair' or tblfeedback.strbusinessname='Audrey Hair') 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
Monro's Haircutters
Margate TAS 7054
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=26857 or tblfeedback.strbusinessname='Monro'%%semi%%s Haircutters' or tblfeedback.strbusinessname='Monro's Haircutters') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Make up by ELC
Kingston TAS 7050
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=25010 or tblfeedback.strbusinessname='Make up by ELC' or tblfeedback.strbusinessname='Make up by ELC') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Liv Rogers Makeup Artist
Moonah TAS 7009
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=41520 or tblfeedback.strbusinessname='Liv Rogers Makeup Artist' or tblfeedback.strbusinessname='Liv Rogers Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jakadjari Hair Australia
Hobart TAS 7000
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=43381 or tblfeedback.strbusinessname='Jakadjari Hair Australia' or tblfeedback.strbusinessname='Jakadjari Hair Australia') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bonnie-Rose Make up
Hobart TAS 7000
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=27919 or tblfeedback.strbusinessname='Bonnie-Rose Make up' or tblfeedback.strbusinessname='Bonnie-Rose Make up') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Miss Moss Makeup
Hobart TAS 7000
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=46713 or tblfeedback.strbusinessname='Miss Moss Makeup' or tblfeedback.strbusinessname='Miss Moss Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Midway Hair and Beauty
Midway Point TAS 7171
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=44709 or tblfeedback.strbusinessname='Midway Hair and Beauty' or tblfeedback.strbusinessname='Midway Hair and Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Makeup by Yaz
Hobart TAS 7000
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=25124 or tblfeedback.strbusinessname='Makeup by Yaz' or tblfeedback.strbusinessname='Makeup by Yaz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Honey's Hair Hive
Glenorchy TAS 7010
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=5282 or tblfeedback.strbusinessname='Honey'%%semi%%s Hair Hive' or tblfeedback.strbusinessname='Honey's Hair Hive') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Country Cutters Hair & Beauty Salon
Sorell TAS 7172
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=5205 or tblfeedback.strbusinessname='Country Cutters Hair &%%semi%% Beauty Salon' or tblfeedback.strbusinessname='Country Cutters Hair & Beauty Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Nova Hair Boutique
Blackmans Bay TAS 7052
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=5209 or tblfeedback.strbusinessname='Nova Hair Boutique' or tblfeedback.strbusinessname='Nova Hair Boutique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Signature Hair & Makeup Studios
Hobart TAS 7000
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=5286 or tblfeedback.strbusinessname='Signature Hair &%%semi%% Makeup Studios' or tblfeedback.strbusinessname='Signature Hair & Makeup Studios') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Lorian Salon
Glenorchy TAS 7010
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=5284 or tblfeedback.strbusinessname='Lorian Salon' or tblfeedback.strbusinessname='Lorian Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15