Rating
Paint by Brock
Orange NSW 2800
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=41444 or tblfeedback.strbusinessname='Paint by Brock' or tblfeedback.strbusinessname='Paint by Brock') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
HairByJaxz
Wagga Wagga NSW 2650
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=36357 or tblfeedback.strbusinessname='HairByJaxz' or tblfeedback.strbusinessname='HairByJaxz') 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
Kate's Face and Body Art
Wagga Wagga NSW 2650
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=36356 or tblfeedback.strbusinessname='Kate'%%semi%%s Face and Body Art' or tblfeedback.strbusinessname='Kate's Face and Body Art') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Emily Brewis Hairdressing
Tumut NSW 2720
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=27699 or tblfeedback.strbusinessname='Emily Brewis Hairdressing' or tblfeedback.strbusinessname='Emily Brewis Hairdressing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating