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
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
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
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
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
Rosie Viney Hairdressing
Devonport TAS 7310
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=27695 or tblfeedback.strbusinessname='Rosie Viney Hairdressing' or tblfeedback.strbusinessname='Rosie Viney Hairdressing') 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
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
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
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
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
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
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