Rating
Tonik House Hair Studio
Toowoomba QLD 4350
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=39831 or tblfeedback.strbusinessname='Tonik House Hair Studio' or tblfeedback.strbusinessname='Tonik House Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Brows & Beauty By Sam
Kingaroy QLD 4610
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=26564 or tblfeedback.strbusinessname='Brows &%%semi%% Beauty By Sam' or tblfeedback.strbusinessname='Brows & Beauty By Sam') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Capricorn Hair Studio
Mount Isa QLD 4825
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=29245 or tblfeedback.strbusinessname='Capricorn Hair Studio' or tblfeedback.strbusinessname='Capricorn Hair Studio') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Nicoles Beauty Clinic
Dalby QLD 4405
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=26578 or tblfeedback.strbusinessname='Nicoles Beauty Clinic' or tblfeedback.strbusinessname='Nicoles Beauty Clinic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Nocole Bruce makeup artist
Dalby QLD 4405
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=27912 or tblfeedback.strbusinessname='Nocole Bruce makeup artist' or tblfeedback.strbusinessname='Nocole Bruce makeup artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bella Obsessions Hairdressing
Mount Isa QLD 4825
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=26598 or tblfeedback.strbusinessname='Bella Obsessions Hairdressing' or tblfeedback.strbusinessname='Bella Obsessions Hairdressing') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lauren Hughes - A Flair for Hair
Warwick QLD 4370
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=21129 or tblfeedback.strbusinessname='Lauren Hughes - A Flair for Hair' or tblfeedback.strbusinessname='Lauren Hughes - A Flair for Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lust. Hair & Beauty
Bundaberg QLD 4670
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=43517 or tblfeedback.strbusinessname='Lust. Hair &%%semi%% Beauty' or tblfeedback.strbusinessname='Lust. Hair & Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Cassaz Colourful Curls
Allora QLD 4362
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=27412 or tblfeedback.strbusinessname='Cassaz Colourful Curls' or tblfeedback.strbusinessname='Cassaz Colourful Curls') 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
Hair & Beauty Barn
Blackall QLD 4472
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=43349 or tblfeedback.strbusinessname='Hair &%%semi%% Beauty Barn' or tblfeedback.strbusinessname='Hair & Beauty Barn') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hairdo4you
Nanango QLD 4615
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=39721 or tblfeedback.strbusinessname='Hairdo4you' or tblfeedback.strbusinessname='Hairdo4you') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Hair On Victoria
Stanthorpe QLD 4380
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=18863 or tblfeedback.strbusinessname='Hair On Victoria' or tblfeedback.strbusinessname='Hair On Victoria') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
MASS
PortDouglas QLD 4871
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=18875 or tblfeedback.strbusinessname='MASS' or tblfeedback.strbusinessname='MASS') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15