Rating
NG Hair
Frenchville QLD 4701
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=26039 or tblfeedback.strbusinessname='NG Hair' or tblfeedback.strbusinessname='NG Hair') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Lush beautique
West Mackay QLD 4740
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=37721 or tblfeedback.strbusinessname='Lush beautique' or tblfeedback.strbusinessname='Lush beautique') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beauty to Beautiful
Mackay QLD 4740
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=27054 or tblfeedback.strbusinessname='Beauty to Beautiful' or tblfeedback.strbusinessname='Beauty to Beautiful') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Bella Vendetta
Brisbane QLD 4000
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=25933 or tblfeedback.strbusinessname='Bella Vendetta' or tblfeedback.strbusinessname='Bella Vendetta') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Amelia's Salon
Frenchville QLD 4701
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=21237 or tblfeedback.strbusinessname='Amelia'%%semi%%s Salon' or tblfeedback.strbusinessname='Amelia's Salon') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
MS Beauty & Makeup
Glenella QLD 4740
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=25690 or tblfeedback.strbusinessname='MS Beauty &%%semi%% Makeup' or tblfeedback.strbusinessname='MS Beauty & Makeup') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beauty Worx
Mt Pleasant QLD 4740
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=27342 or tblfeedback.strbusinessname='Beauty Worx' or tblfeedback.strbusinessname='Beauty Worx') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Alice Makeup Artist
Cairns QLD 4870
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=29031 or tblfeedback.strbusinessname='Alice Makeup Artist' or tblfeedback.strbusinessname='Alice Makeup Artist') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Effekt Beauty
Frenchville QLD 4701
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=27407 or tblfeedback.strbusinessname='Effekt Beauty' or tblfeedback.strbusinessname='Effekt Beauty') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Pinalli's Pamper Room
Aitkenvale QLD 4814
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=15125 or tblfeedback.strbusinessname='Pinalli'%%semi%%s Pamper Room' or tblfeedback.strbusinessname='Pinalli's Pamper Room') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Imperial Nails & Beauty by Marcella
Pleystowe QLD 4741
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=15121 or tblfeedback.strbusinessname='Imperial Nails &%%semi%% Beauty by Marcella' or tblfeedback.strbusinessname='Imperial Nails & Beauty by Marcella') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
Rating
Beautiful Brides
Bushland Beach QLD 4818
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=15109 or tblfeedback.strbusinessname='Beautiful Brides' or tblfeedback.strbusinessname='Beautiful Brides') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Indulgence Natural Beauty Clinic
Bowen QLD 4805
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=18670 or tblfeedback.strbusinessname='Indulgence Natural Beauty Clinic' or tblfeedback.strbusinessname='Indulgence Natural Beauty Clinic') AND tblfeedback.active = 1 AND year(getdate())-year(dtmadded)<=15