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 & 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
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
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
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
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
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
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 & Beauty by Marcella' or tblfeedback.strbusinessname='Imperial Nails & Beauty by Marcella') and year(getdate())-year(dtmadded)<=15
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's Pamper Room' or tblfeedback.strbusinessname='Pinalli's Pamper Room') and year(getdate())-year(dtmadded)<=15
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 year(getdate())-year(dtmadded)<=15