Rating
Surreal hair salon
Wynyard TAS 7322
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=37911 or tblfeedback.strbusinessname='Surreal hair salon' or tblfeedback.strbusinessname='Surreal hair salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Salon Spoil
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=42807 or tblfeedback.strbusinessname='Salon Spoil' or tblfeedback.strbusinessname='Salon Spoil') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Obsession Hair
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=27849 or tblfeedback.strbusinessname='Obsession Hair' or tblfeedback.strbusinessname='Obsession Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Styled by Jasmin Mobile Wedding Hair And Makeup
Ulverstone TAS 7315
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=44603 or tblfeedback.strbusinessname='Styled by Jasmin Mobile Wedding Hair And Makeup' or tblfeedback.strbusinessname='Styled by Jasmin Mobile Wedding Hair And Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Jenna-lee artisan
Burnie TAS 7320
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=45823 or tblfeedback.strbusinessname='Jenna-lee artisan' or tblfeedback.strbusinessname='Jenna-lee artisan') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Alyce Treloar Hairstylist
Port Sorell TAS 7307
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=29233 or tblfeedback.strbusinessname='Alyce Treloar Hairstylist' or tblfeedback.strbusinessname='Alyce Treloar Hairstylist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Kozani Kutz
Smithton TAS 7330
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=27753 or tblfeedback.strbusinessname='Kozani Kutz' or tblfeedback.strbusinessname='Kozani Kutz') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Catherine Watson Make-up
Deloraine TAS 7304
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=26680 or tblfeedback.strbusinessname='Catherine Watson Make-up' or tblfeedback.strbusinessname='Catherine Watson Make-up') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Big Tease Pop-Up Parlour
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=43742 or tblfeedback.strbusinessname='Big Tease Pop-Up Parlour' or tblfeedback.strbusinessname='Big Tease Pop-Up Parlour') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Tyra Rose Makeup Design
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=45905 or tblfeedback.strbusinessname='Tyra Rose Makeup Design' or tblfeedback.strbusinessname='Tyra Rose Makeup Design') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Bec Jansen
Penguin TAS 7316
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=27896 or tblfeedback.strbusinessname='Bec Jansen' or tblfeedback.strbusinessname='Bec Jansen') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bianca Jean make up artistry
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=24939 or tblfeedback.strbusinessname='Bianca Jean make up artistry' or tblfeedback.strbusinessname='Bianca Jean make up artistry') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
CR Hair & Skin
Ulverstone TAS 7315
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=45822 or tblfeedback.strbusinessname='CR Hair &%%semi%% Skin' or tblfeedback.strbusinessname='CR Hair & Skin') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Aspire Beauty & Body
Latrobe TAS 7307
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=37821 or tblfeedback.strbusinessname='Aspire Beauty & Body' or tblfeedback.strbusinessname='Aspire Beauty & Body') 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
Rosie Enniss 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 Enniss Hairdressing' or tblfeedback.strbusinessname='Rosie Enniss Hairdressing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating