Rating
MS Beauty & Makeup
2 McLaren Court 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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
NG Hair
291 Mills Avenue 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beauty to Beautiful
4 College Court 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beauty Worx
Shop 8 Mt Pleasant Plaza Phillip St 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Effekt Beauty
388 Dean St 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 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Beautiful Brides
13 Kurrajong Court 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 year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Imperial Nails & Beauty by Marcella
Eungella Road 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 year(getdate())-year(dtmadded)<=15
Rating
Pinalli's Pamper Room
37 Caroline Street 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 year(getdate())-year(dtmadded)<=15
Rating
Indulgence Natural Beauty Clinic
62 George St 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 year(getdate())-year(dtmadded)<=15