Rating
Vanity Make Up Bar and Body Lounge
Mount Gambier SA 5290
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=22331 or tblfeedback.strbusinessname='Vanity Make Up Bar and Body Lounge' or tblfeedback.strbusinessname='Vanity Make Up Bar and Body Lounge') 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
Fuse Hair
Mount Gambier SA 5290
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=27577 or tblfeedback.strbusinessname='Fuse Hair' or tblfeedback.strbusinessname='Fuse Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Taylor made hair
Port MacDonnell SA 5291
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=41439 or tblfeedback.strbusinessname='Taylor made hair' or tblfeedback.strbusinessname='Taylor made hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Shear Class Hair Studio
Naracoorte SA 5271
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=6221 or tblfeedback.strbusinessname='Shear Class Hair Studio' or tblfeedback.strbusinessname='Shear Class Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Tanya's Hairworks
Mt Gambier SA 5290
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=19215 or tblfeedback.strbusinessname='Tanya'%%semi%%s Hairworks' or tblfeedback.strbusinessname='Tanya's Hairworks') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15